ERP User GuideMicrosoft Dynamics NAV

Microsoft Dynamics NAV

Sana Commerce 9.3
Your connector

Items and Customers Synchronization

Sana 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 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)
  • Item vertical and horizontal components (applies to Pebblestone Fashion (PFS) add-on)

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
ERP User GuideMicrosoft Dynamics NAV