tackme31

<?xml version="1.0" encoding="utf-8" ?>
<configuration xmlns:patch="http://www.sitecore.net/xmlconfig/" xmlns:role="http://www.sitecore.net/xmlconfig/role/" xmlns:search="http://www.sitecore.net/xmlconfig/search/">
  <sitecore role:require="Standalone or ContentManagement or ContentDelivery" search:require="Solr">
    <!-- Set your prefix of Solr's core. -->
    <sc.variable name="SolrCorePrefix" value="prefix.of.core" />
    <contentSearch>
      <configuration>
        <indexes>
          <index id="sitecore_core_index">
            <param desc="core">$(SolrCorePrefix)_core_index</param>

tackme31

<#
.SYNOPSIS
PowerShell script to create a Commerce Engine solution from SDK. (tested only on Sitecore Commerce 9.2)

.EXAMPLE
PS> .\setup-commerce-sdk.ps1 authoring.site.name \path\to\Sitecore.Commerce.Engine.SDK.4.0.102.zip
PS> dotnet run -p .\Sitecore.Commerce.Engine.SDK\src\Sitecore.Commerce.Engine\Sitecore.Commerce.Engine.csproj

.PARAMETER AuthoringSiteName
Name of your Commerce Authoring website in IIS.

tackme31

<#
.SYNOPSIS
    Lists the pages which are not published yet (in the current version or any version at all).
        
.NOTES
    Manuel Fischer
#>

function Get-AllUnpublishedPages {
    Get-ChildItem -Path $homeFolder -Recurse | IsPage | IsPublished

tackme31

/*
  Route Scaffolding Script
  This is a script that enables scaffolding a new JSS route using `jss scaffold:route <RouteName>`.
  Edit this script if you wish to use your own conventions for route storage in your JSS app.
*/

/* eslint-disable no-throw-literal,no-console */

const fs = require('fs');
const path = require('path');

tackme31

function Get-FormData($formId, $startDate, $endDate) {
    $provider = [Sitecore.DependencyInjection.ServiceLocator]::ServiceProvider.GetService([Sitecore.ExperienceForms.Data.IFormDataProvider])
    $entries = $provider.GetEntries($formId.Guid, $startDate, $endDate)
    if (-not $entries) {
        return $null
    }
    
    # Get all column title
    $titles = new-object System.Collections.Generic.HashSet[string]
    $entries | % { $_.Fields | % { $titles.Add($_.FieldName) > $null } }

tackme31

var url = 'https://sitecorecdn.azureedge.net/-/media/sitecoresite/images/global/logo/sitecore-logo.svg';
download(url);
// => sitecore-logo.svg will be downloaded.

var filename = 'logo.svg';
download(url, filename);
// => 'logo.svg' will be downloaded.

tackme31

USE [Commerce_SharedEnvironments]

SELECT
    Id,
    EntityVersion,
    JSON_VALUE(Entity, '$.ParentCategoryList') AS ParentCategoryList
FROM
    sitecore_commerce_storage.CatalogEntities AS CatalogEntities
    INNER JOIN sitecore_commerce_storage.CatalogEntity AS CatalogEntity
        ON CatalogEntities.UniqueId = CatalogEntity.UniqueId

tackme31

param (
    [Parameter(Mandatory=$false)]
    [string]
    $Profile = "FolderProfile",
    [Parameter(Mandatory=$false)]
    [string]
    $Project = "*",
    [Parameter(Mandatory=$false)]
    [string]
    $SolutionPath = ".",

tackme31

$options = [ordered]@{};
[Unicorn.Configuration.UnicornConfigurationManager]::Configurations | % { $options[$_.Name] = $_.Name }

$result = Read-Variable `
    -Parameters `
        @{ Name='packageName'; Title='Package Name'; Value=(Get-Date -Format yyyyMMddHHmmss); }, `
        @{ Name='configuration'; Title='Configuration'; Options=$options; Editor='radio'; } `
    -Title "Unicorn Package" `
    -Description "Make a package based on an unicorn configuration."

tackme31

function Restart-IIS {
    do {
        & { iisreset }

        $iis = Get-Service -Name W3SVC
    }
    while ($iis.Status -ne 'Running')
}

Restart-IIS