Scheduled Tasks

Sana Commerce 9.3
Your connector

Product Import

The Product import task is used to retrieve product data from your ERP system to build and update the catalog of your web store. Web store search functionality, sorting and filtering of products, phonetic search and product sets configuration depends on the product information that is indexed.

 NOTE

When Sana is installed and connected to your ERP system, you will need to set up the Index fields and run the Product import task to be able to manage your web store catalog and navigation. For more information, see "ERP Integration".


Update Index vs. Rebuild Index

By default, when you click Start, the Product import task will update the product index, but there is the alternative option - Rebuild index.

  • Update index - checks whether some product data has been modified in the ERP system and synchronizes the changes with Sana. This is the default action when you click Start. You must update the product index, when you changed some product data in the ERP system.

  • Rebuild index - retrieves all products from ERP. Rebuilding the product index removes the previously created index and creates the new one. You must rebuild the product index only when you changed some global settings which might influence all products, for example:
    • Set up index fields in Sana Admin.
    • Change price visibility in Sana Admin when ERP connection is not available, to show prices in the maintenance mode.
    • Set up web store filters for the products in ERP.
    • Set up data validation rules for the products in ERP.
    • Set up customer assortments in ERP.
    • Add product categories in ERP.
    • Change the default currency in ERP.
    • Change the customer template in ERP which is used to show product prices and inventory to the users who are not logged in to the web store.
    • Change the company in ERP the Sana add-on is assigned to.
    • Upgrade Sana to the new version. This is optional, but might be useful to make sure that everything is fine after upgrade, especially when you upgrade to the major version.

When you change product data in the ERP system, 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 task, Sana will check whether some product data has been changed since last indexing, then it will update the product index and apply the changes to the web store.

Those product fields which have translations in the ERP system, like title, description, product category, are also indexed for all configured languages. When a translation is not available for some language in the ERP system, the default description is taken for that language.

Set up the "Product import" task

To set up the Product import task, click Edit.

The table below provides the description of the Product import task settings:

Settings Description
Run on schedule Use this option to enable automatic running of the product import task according to the configured schedule, or disable it to allow only manual start of the task.

If you enable Run on schedule, you should enter either the interval in minutes when the task should run automatically or the fixed time.
Run interval (in minutes) Enter the time interval in minutes when the task should run automatically.
Run time Enter the fixed time when the task should run automatically. For the fixed time, the time of the server is used.
Send e-mail to administrator when task has failed

Use this option to enable or disable e-mail notifications when a scheduled task fails.

If the scheduled task has failed, the webstore administrator receives an e-mail with the name of the task that failed, the name of the webstore, which is useful in case you have several webstores, when the task failed, and the error message. Thanks to this, the webstore administrator can quickly respond to problems with data synchronization.

Batch size Enter the quantity of products that should be handled in one batch.
Maximum interval between retries (seconds) Enter the maximum interval between retries. When some products cannot be indexed for some reason, the task will make another attempt during the specified time interval.
Maximum retries count Enter the maximum retries count. When some products cannot be indexed for some reason, this value specifies how many times the task should try to index them again.
Maximum items to skip before failure Enter the maximum items to skip before failure. When some products cannot be indexed for some reason, this value specifies how many products can be skipped before the task will fail.
Maximum archived log files Enter the maximum number of log files to store. If this number exceeds, the oldest log file will be removed and the new one will be created.

 

See also:

How Items Are Synchronized between Sana and Microsoft Dynamics NAV
How Products Are Synchronized between Sana and Microsoft Dynamics AX
How Items Are Synchronized between Sana and Microsoft Dynamics 365 Business Central
How Products Are Synchronized between Sana and Microsoft Dynamics 365 Enterprise Edition