Configuration for a single instance or multi-tenant setup is stored in the Commerce Database in the TenantConfig table. Most values do not need to be changed.
The most important values to look at are:
| Value | Description |
|---|---|
| Allow_Dublicate_Email | Allow same email on one or more Member Contacts. |
| Base64MinXmlSizeInKB | Minimum size of XML data being sent to LS Central WS before data gets converted to Base64 String. |
| Cache_Image_DurationInMinute | Image Cache Duration in minutes, 0 is no cache. |
| Central_Token | Security token for LS Central in SaaS. |
| Central_TokenTime | Security token expire time for LS Central in SaaS. |
| Currency_Code | Local currency code. Commerce uses this currency code if it does not get it from LS Central. |
| Currency_Culture | Example: en-US, de-DE. By default, the UI region on the server decides but can be overwritten here. |
| Currency_LoyCode | Currency code used for Loyalty point rates. Default is LOY. |
| Demo_Print_Enabled | True/false, true then print receipt in LS Central will not be called. |
| forgotpassword_code_encrypted | Reset Code is encrypted. |
| GiftCard_DataEntryType | Data Entry Type used for gift cards in LS Central. |
| Image_Save_AbsolutePath | The URL where the images are located. Example: http://myserver.com/OmniImages/ Empty means it uses the ApplicationVirtualPath on the local machine, http://localhost/CommerceService/Images |
| Inventory_Mask_IncludeCycleCounting | Include Cycle counting lines in Mask Replication. |
| LSNAV_Version | LS Central version to be used. This is set the first time Commerce connects to LS Central and is used after that. When updating Commerce, remove the value here to update it to the latest version. To set a different version than the actual running version, set the value here and it will overwrite the current LS Central version. |
| NavAppId | Web Sync App ID to track replication when using the Web Sync feature. Only required for LS Central 20.3 or earlier. |
| NavAppType | Web Sync Type to determine the App type (ECOM / MPOS / INV). Only required for LS Central 20.3 or earlier. |
| OfflinePrintTemplate | |
| Password_Policy | Information about password policy, enforced in BackOffice. |
| PDF_Save_FolderName | POS Only, Folder Name to save PDF slips. Exampe: c:\LS Retail\PDF. Empty means it uses \PDF folder under \Service. |
| POS_System_Inventory | Show Inventory button on App. |
| POS_System_Inventory_Lookup | Do Inventory look up for items. |
| Proxy_Server Proxy_Domain Proxy_Password Proxy_Port Proxy_User |
Proxy server information to connect to LS Central Web Service. |
| ScanPayGo_Staff | Staff used for ScanPayGo transactions. |
| ScanPayGo_Terminal | POS terminal used for ScanPayGo transactions. |
| SkipBase64Conversion | Skip the Base64 Conversion set by Base64MinXmlSizeInKB. |
| TenderType_Mapping | Mapping between Commerce and LS Central TenderType IDs. CommerceTenderTypeId=LSCentralTenderTypeId, for example. Cash is 1=1, GiftCard is 10=10 and so on. See enum TenderType. If left blank, Tender Type Ids from LS Central will be used "as is". |
| Timezone_HoursOffset | LS Central stores everything in UTC. Replicated data may need to use time offset. |
| URL_Displayed_On_Client | A URL displayed on client, App, or eCommerce. |
Note: The Commerce admin portal uses this table for its configuration, so when using multi-tenant mode all configuration is done via Admin Portal, see Commerce Admin Portal.
If single tenant mode, this needs to be adjusted directly in the TenantConfig table in the Commerce database.