Learn New Tech: May 2022

Sana Commerce insight,App settings ,Piwik, Create sheard Access signature,Replicate installation, custom header

Sana Commerce insight

Add data > Save >

schedule > after schedule check Lens >

compare early and after values are correct.

App settings

check with App settings section

check with Environment variables

check with lense

Piwik

enable piwik tracking settings from general settings.

https://piwik.pro/login/ > sana-commerce

stagingplatform.piwikadmin@sana-commerce.com

sanAb11ud@3697

Menu (left side) > Administration

Create sheard Access signature

Trouble shoot > ... > copy

goto M storage Explore > Click Plug > blob container

select Shared access signature URL (SAS)

past the copied url

show the details within time.

Create temp db user

application insight 3.15

request view history

it will check : Webstore downtime, performance

General > Change Sana Sub

Replicate installation

it will create a copy of webstore

it will create another copy,

it will copy only

contents and add-ons only.

contents DB

check azure storage explore

images will save on Content

addons will save on packages.

Uptime

Custom Header

Setup Site for testing webstore ERP config

copy data from working erp

connect type: Microsoft Dynamics 365 Business Central

Web URL :

http://staging-navision.sana-test-cloud.net:10007/BC17_W1_SC10000/WS/scc3tjswkfu0zz/Codeunit/SC_NAV_WebService?tenant=ws56955scc3tjswkfu0zz

Basic

U domain : ws56955scc3tjswkfu0zz

User : SANAADMIN

pw: User1234

start all scheduled tasks

new Category import location

Setup > Navigation > Main > Items > Configure categories from ERP

add addons, lanuages

add images ttols > file manager > upload images

Add shop account

setup Home page

-----------------------

Delete Protection ON

it will hide the delete button

connect type: Microsoft Dynamics 365 Business Central

Web URL :

http://23.97.236.40:6003/SANA_TRIAL/WS/sccoxvvcul0ib3/Codeunit/SC_NAV_WebService?tenant=ws63144sccoxvvcul0ib3

Basic

U domain : ws63144sccoxvvcul0ib3

User : SANAADMIN

pw: User1234

How to map Partner and

When some users () cant view some webstores when partners are different.

we need to add manually

eg: Account user Isuru has Platform admin permissions, but the partner is "ABC Partner 2"

wants to view

5.39

search DB Backup content on azure side (Storage Explorer)

Open Azure storage explore

staging Trial : Sana platform Demo STAGIN

staging saas customized : Sana platform production STAGIN

right click > search from here > give id

it will show db back ups and content changes daily

When Webjob failes, how to find issue on Azure side

https://portal.azure.com/#home

search : staging-sanaplatform

scroll down to WEB JOB

click item and > click log icon

you may find an error if occurred

Enable Region to new Project/Partner

Update WebstoreInstallationProfiles Table

Region need to add :WEU

InstallationTypeId : 4 // customized

PartnerId : 5AFFFDF6-21DA-4E30-92C1-4A8D55DBFE9C

SELECT * FROM dbo.WebstoreInstallationProfiles SanaRegionCode

where SanaRegionCode ='WEU' and

InstallationTypeId = 4

~~PartnerId='5AFFFDF6-21DA-4E30-92C1-4A8D55DBFE9C'~~

Copy last data and past for new line

Update ConnectwithProfile field as latest id : 40

Update PartnerId field :

Then Login platform portal and check changes are applied.

[ClusterId] should not null --> correct cluster can find from [dbo].[AKSClusters] table

isActivate should true

to avoid issue copy record "Upgrade cronjob project" working project item

Verify with webstore azure settings table

for testing

When Creating a new Partner it will create 2 recodes on [PartnerViewPermissionMaps] Table

Sana Commerce partner
Same partner

SELECT TOP (1000) [Id]
,[PartnerGroupID]
,[PartnerGroupViewID]
,[CreatedUser]
,[CreatedDateTime]
,[ModifiedUser]
,[ModifiedDateTime]
FROM [dbo].[PartnerViewPermissionMaps]
where [PartnerGroupViewID] = 'CB9D1A20-824F-44B6-B5A4-D95B29E7C682'

SELECT*  FROM [dbo].[Partners] 
where name in ('Cy_PartnerQQ','Sana Commerce')