Items and Customers Synchronization

Sana Commerce Cloud is the ERP integrated e-commerce solution. Thus, it uses a single source of data - your ERP system. All products, customers and orders are stored and managed in the ERP system.

Sana Commerce Cloud uses scheduled tasks to synchronize data with your ERP system and to apply any changes made in ERP to your webshop.

  • The Product import task retrieves all items from Microsoft Dynamics NAV to build the catalog for your webshop. It also updates item master data shown in the webshop, if something has been changed in Microsoft Dynamics NAV.

  • The Customer import task retrieves all customers, contacts and salespeople from Microsoft Dynamics NAV. Those customers and salespeople who have shop accounts can purchase online using the Sana webshop. It also updates customer, contact and salesperson master data used in the webshop, if something has been changed in Microsoft Dynamics NAV.

When you change item, customer, contact or salesperson data in Microsoft Dynamics NAV, the value of the Last Date / Time Modified field will be updated with the current date and time. Based on this, when you run the Product import or Customer import task, Sana will check whether some item or customer data has been changed since last indexing, then it will update the index and apply the changes to the webshop.

The list below presents all Sana related data in Microsoft Dynamics NAV influenced by the Last Date / Time Modified field.

Items

When you manage (create, edit or delete) the following catalog data in Microsoft Dynamics NAV, the value of the Last Date / Time Modified field will be updated:

  • Item

  • Sales price

  • Item unit of measure

  • Item cross reference (bar code)

  • Item translation

  • Item substitution

  • Item variant

  • Extended text header and line

  • Item attachment

  • BOM component

  • Item attribute (applies to Microsoft Dynamics NAV 2017 and higher)

Customers

  • Create, edit or delete a customer

Contacts

  • Create, edit or delete a contact

Salespeople

  • Create, edit or delete a salesperson

  • Change Salesperson Code on the Customer Card