Execute Sitecore Commerce API calls in Postman

      1. Download and Install Postman tool

                         https://www.postman.com/downloads/

      2. Open Postman Tool

      3. Click Import button

      4. Navigate to the folder

               C:\deploy\Sitecore.Commerce.Engine.SDK.2.2.72\postman

                Note: This is the folder is used to setup commerce environment for                    your local. so the path can be different in your local.

                 Select Folder

       5. You can see the collections imported into your postman tool

       6. Select Environment

      7. Get Token

      8. You can perform several API call. Below are some example.

                 Bootstrap Sitecore Commerce

                Clean Environment

                Initialize Environment

                Check Long Running Command Status

                Environments

                Catalogs

                 Import Catalogs (with publishing)

                 Clear cache store

Uninstalling Sitecore eCommerce

1. Restart your system.
2.Copy and save the below script as "uninstall-commerce-sitecore.ps1"

#define parameters
Param(
[string]$Prefix = 'XXXX',
[string]$CommerceOpsSiteName = 'CommerceOps_Sc9',
[string]$CommerceShopsSiteName = 'CommerceShops_Sc9',
[string]$CommerceAuthoringSiteName = 'CommerceAuthoring_Sc9',
[string]$CommerceMinionsSiteName = 'CommerceMinions_Sc9',
[string]$SitecoreBizFxSiteName = 'SitecoreBizFx',
[string]$SitecoreIdentityServerSiteName = 'SitecoreIdentityServer',
[string]$SolrService = 'Solr',
[string]$PathToSolr = 'C:\Solr\Solr-6.6.2',
[string]$SqlServer = 'XXXXXXX',
[string]$SqlAccount = 'sa',
[string]$SqlPassword = 'XXXXXXX'
)
#Write-TaskHeader function modified from SIF
Function Write-TaskHeader {
    param(
        [Parameter(Mandatory=$true)]
        [string]$TaskName,
        [Parameter(Mandatory=$true)]
        [string]$TaskType
    )

    function StringFormat {
        param(
            [int]$length,
            [string]$value,
            [string]$prefix = '',
            [string]$postfix = '',
            [switch]$padright
        )

        # wraps string in spaces so we reduce length by two
        $length = $length - 2 #- $postfix.Length - $prefix.Length
        if($value.Length -gt $length){
            # Reduce to length - 4 for elipsis
            $value = $value.Substring(0, $length - 4) + '...'
        }

        $value = " $value "
        if($padright){
            $value = $value.PadRight($length, '*')
        } else {
            $value = $value.PadLeft($length, '*')
        }

        return $prefix + $value + $postfix
    }

    $actualWidth = (Get-Host).UI.RawUI.BufferSize.Width
    $width = $actualWidth - ($actualWidth % 2)
    $half = $width / 2

    $leftString = StringFormat -length $half -value $TaskName -prefix '[' -postfix ':'
    $rightString = StringFormat -length $half -value $TaskType -postfix ']' -padright

    $message = ($leftString + $rightString)
    Write-Host ''
    Write-Host $message -ForegroundColor 'Red'
}

Function Remove-Service{
[CmdletBinding()]
param(
[string]$serviceName
)
if(Get-Service "My Service" -ErrorAction SilentlyContinue){
sc.exe delete $serviceName
}
}

Function Remove-Website{
[CmdletBinding()]
param(
[string]$siteName
)

$appCmd = "C:\windows\system32\inetsrv\appcmd.exe"
& $appCmd delete site $siteName
}

Function Remove-AppPool{
[CmdletBinding()]
param(
[string]$appPoolName
)

$appCmd = "C:\windows\system32\inetsrv\appcmd.exe"
& $appCmd delete apppool $appPoolName
}

#Stop Solr Service
Write-TaskHeader -TaskName "Solr Services" -TaskType "Stop"
Write-Host "Stopping solr service"
Stop-Service $SolrService -Force -ErrorAction stop
Write-Host "Solr service stopped successfully"

#Delete solr cores
Write-TaskHeader -TaskName "Solr Services" -TaskType "Delete Cores"
Write-Host "Deleting Solr Cores"
$pathToCores = "$pathToSolr\server\solr\$Prefix*"
Remove-Item $pathToCores -recurse -force -ErrorAction stop
Write-Host "Solr Cores deleted successfully"

#Remove Sites and App Pools from IIS
Write-TaskHeader -TaskName "Internet Information Services" -TaskType "Remove Websites"


Write-Host "Deleting Website $CommerceOpsSiteName"
Remove-Website -siteName $CommerceOpsSiteName -ErrorAction stop
Write-Host "Websites deleted"

Write-Host "Deleting Website $CommerceShopsSiteName"
Remove-Website -siteName $CommerceShopsSiteName -ErrorAction stop
Write-Host "Websites deleted"

Write-Host "Deleting Website $CommerceAuthoringSiteName"
Remove-Website -siteName $CommerceAuthoringSiteName -ErrorAction stop
Write-Host "Websites deleted"

Write-Host "Deleting Website $CommerceMinionsSiteName "
Remove-Website -siteName $CommerceMinionsSiteName  -ErrorAction stop
Write-Host "Websites deleted"

Write-Host "Deleting Website $SitecoreBizFxSiteName"
Remove-Website -siteName $SitecoreBizFxSiteName -ErrorAction stop
Write-Host "Websites deleted"

Write-Host "Deleting Website $SitecoreIdentityServerSiteName"
Remove-Website -siteName $SitecoreIdentityServerSiteName -ErrorAction stop
Write-Host "Websites deleted"



Remove-AppPool -appPoolName $CommerceOpsSiteName -ErrorAction stop
Write-Host "Application pools deleted"
Remove-AppPool -appPoolName $CommerceShopsSiteName -ErrorAction stop
Write-Host "Application pools deleted"
Remove-AppPool -appPoolName $CommerceAuthoringSiteName -ErrorAction stop
Write-Host "Application pools deleted"
Remove-AppPool -appPoolName $CommerceMinionsSiteName -ErrorAction stop
Write-Host "Application pools deleted"
Remove-AppPool -appPoolName $SitecoreBizFxSiteName -ErrorAction stop
Write-Host "Application pools deleted"
Remove-AppPool -appPoolName $SitecoreIdentityServerSiteName -ErrorAction stop


Remove-Item C:\inetpub\wwwroot\$CommerceOpsSiteName -recurse -force -ErrorAction stop
Write-Host "Websites removed from wwwroot"
Remove-Item C:\inetpub\wwwroot\$CommerceShopsSiteName -recurse -force -ErrorAction stop
Write-Host "Websites removed from wwwroot"
Remove-Item C:\inetpub\wwwroot\$CommerceAuthoringSiteName -recurse -force -ErrorAction stop
Write-Host "Websites removed from wwwroot"
Remove-Item C:\inetpub\wwwroot\$CommerceMinionsSiteName -recurse -force -ErrorAction stop
Write-Host "Websites removed from wwwroot"
Remove-Item C:\inetpub\wwwroot\$SitecoreBizFxSiteName -recurse -force -ErrorAction stop
Write-Host "Websites removed from wwwroot"
Remove-Item C:\inetpub\wwwroot\$SitecoreIdentityServerSiteName -recurse -force -ErrorAction stop
Write-Host "Websites removed from wwwroot"


Write-TaskHeader -TaskName "SQL Server" -TaskType "Drop Databases"
#Drop databases from SQL
Write-Host "Dropping databases from SQL server"
push-location
import-module sqlps

Write-Host $("Dropping database SitecoreCommerce9_Global")
$commerceDbPrefix = $("DROP DATABASE IF EXISTS [SitecoreCommerce9_Global]")
Write-Host $("Query: $($commerceDbPrefix)")
invoke-sqlcmd -ServerInstance $SqlServer -U $SqlAccount -P $SqlPassword -Query $commerceDbPrefix -ErrorAction stop

Write-Host $("Dropping database [SitecoreCommerce9_SharedEnvironments]")
$sharedDbPrefix = $("DROP DATABASE IF EXISTS [SitecoreCommerce9_SharedEnvironments]")
Write-Host $("Query: $($sharedDbPrefix)")
invoke-sqlcmd -ServerInstance $SqlServer -U $SqlAccount -P $SqlPassword -Query $sharedDbPrefix -ErrorAction stop


Write-Host "Databases dropped successfully"
pop-location

3. Change the Parameter values

[string]$Prefix = 'XXXX',
[string]$CommerceOpsSiteName = 'CommerceOps_Sc9',
[string]$CommerceShopsSiteName = 'CommerceShops_Sc9',
[string]$CommerceAuthoringSiteName = 'CommerceAuthoring_Sc9',
[string]$CommerceMinionsSiteName = 'CommerceMinions_Sc9',
[string]$SitecoreBizFxSiteName = 'SitecoreBizFx',
[string]$SitecoreIdentityServerSiteName = 'SitecoreIdentityServer',
[string]$SolrService = 'Solr',
[string]$PathToSolr = 'C:\Solr\Solr-6.6.2',
[string]$SqlServer = 'XXXXXXX',
[string]$SqlAccount = 'sa',
[string]$SqlPassword = 'XXXXXXX'

4. Save and Close the power shell script.
5. Run power shell as administrator.
6. navigate to the path of uninstall script.
7. run the uninstallation script.

Installing Sitecore eCommerce

                             Installing Sitecore eCommerce

PREREQUISITES:

1.      Download and Install .NET Core 2.1.4 from the below link.

https://www.microsoft.com/net/download/thank-you/dotnet-sdk-2.1.4-windows-x64-installer

2.      Download and Install .NET Core Windows Server Hosting 2.0.0 from the below link.

https://aka.ms/dotnetcore-2-windowshosting

3.      Download(Just Download Don’t Install) Sitecore PowerShell Extensions 4.7.2 from the below link

https://marketplace.sitecore.net/en/Modules/Sitecore_PowerShell_console.aspx

4.      Download(Just Download Don’t Install) Sitecore Experience Accelerator 1.7.1 from the below link

https://dev.sitecore.net/~/media/1FF242BE683E4DE989925F74B78978FC.ashx

5.      Download(Just Download Don’t Install) the Sitecore XC Update 2 release package from the below link

https://dev.sitecore.net/~/media/F374366CA5C649C99B09D35D5EF1BFCE.ashx

6.      Create Folders

c:\Sitecore\Deploy

c:\Sitecore\Deploy\assets

7.      Copy

Sitecore PowerShell Extensions 4.7.2

Sitecore Experience Accelerator 1.7.1

To

c:\Sitecore\Deploy\assets

8.       

8.1   Copy

Sitecore XC Update 2 ZIP file

To

c:\Sitecore\Deploy

8.2   Extract

Sitecore XC Update 2 ZIP file

To

c:\Sitecore\Deploy

8.3   Delete

“Sitecore XC Update 2” ZIP file

9.       

9.1    

Extract Below ZIP files

From c:\Sitecore\Deploy

SIF.Sitecore.Commerce.1.2.14.zip

Sitecore.Commerce.Engine.SDK.2.2.72.zip

Sitecore.BizFX.1.2.19.zip

To Same folder (c:\Sitecore\Deploy)

9.2    

      Delete Below ZIP files

From c:\Sitecore\Deploy

SIF.Sitecore.Commerce.1.2.14.zip

Sitecore.Commerce.Engine.SDK.2.2.72.zip

     Sitecore.BizFX.1.2.19.zip

10.  Download MS Build Microsoft Visual Studio Web targets from the below link

https://www.nuget.org/packages/MSBuild.Microsoft.VisualStudio.Web.targets/

10.1             

a)      Change extension of downloaded file from “nupkg” to “zip”

b)     extract zip file

c)      open extracted folder and navigate to

msbuild.microsoft.visualstudio.web.targets.14.0.0.3 -> tools -> VSToolsPath -> Web

d)     Copy “Microsoft.Web.XmlTransform.dll” file into “c:\sitecore\deploy\assets”.

11.   

Copy file “Sitecore.Commerce.Engine.DB.dacpac” from “C:\Sitecore\deploy\Sitecore.Commerce.Engine.SDK.2.2.72” into “C:\sitecore\deploy\assets”

Unzip “C:\sitecore\deploy\Sitecore.Commerce.Engine.2.2.126.zip” into “C:\sitecore\deploy\Sitecore.Commerce.Engine.2.2.126” folder and open “C:\sitecore\deploy\Sitecore.Commerce.Engine.2.2.126\wwwroot\bootstrap\Global.json” file.

a)      Set the “Database” value under “SourceStoreSqlPolicy” to “SitecoreCommerce9_Global”

b)      Set the “Server” value under “SourceStoreSqlPolicy” to “.”

c)      Zip the folder “C:\deploy\Sitecore.Commerce.Engine.2.2.126” as “C:\deploy\Sitecore.Commerce.Engine.2.2.126.zip” file overwriting the existing file “C:\deploy\Sitecore.Commerce.Engine.2.2.126.zip”.

d)      Remove “C:\deploy\Sitecore.Commerce.Engine.2.2.126” folder afterwards

CERTIFICATE FOR SITECORE COMMERCE ENGINE CONNECT:

We create this certificate for Commerce Engine to authenticate with Sitecore XC Engine.

1.      Open PowerShell as Admin

2.      Run the following command

New-SelfSignedCertificate -certstorelocation cert:\localmachine\my -dnsname “sc902.engineconnect”

Copy and Save the Thumbprint in notepad.

3.      Export certificate by running the following command

Export-Certificate -Cert cert:\localMachine\my\{Thumbprint} -FilePath ‘C:\sitecore\deploy\assets\sc902.engineconnect.cer’

Replace {Thumbprint} with your generated Thumbprint value from above step.

INSTALLATION:

1.      Check whether you have all your necessary files placed in your deploy(c:\sitecore\deploy) folder

And assets(c:\sitecore\deploy\assets) folder

Pic 1.

Pic 2.

2.      Check your Sitecore Instance

2.1             Rebuild link databases(core, master)

2.2             Rebuild search index

2.3             Sitecore PowerShell Extensions 4.7.2

2.4             Install “Sitecore Experience Accelerator 1.7.1 rev. 180604 for 9.0” package

After Successful installation.

Go to

Sitecore Control Panel -> Indexing Manager -> Select the Below 2 Indexes and Click Rebuild

3.      Running Deploy Script

Copy the Script from this https://gitlab.com/viet.hoang/workshop/blob/master/Scripts%20for%20Sitecore%20Commerce%20902/sc9_com_install.ps1 link, Create a Powel Shell Script “Deploy-Sitecore-Commerce.ps1” file, Save it into c:\sitecore\deploy\SIF.Sitecore.Commerce.1.2.14

               Open PowerShell in Administration mode, run the script.