Preparing Entities for Synchronization: General Information

Acumatica ERP Retail-Commerce Edition provides flexible tools that you can use to prepare the data for synchronization with your BigCommerce store and configure the synchronization settings.

Learning Objectives

In this chapter, you will learn the following:

  • How to filter data that needs to be synchronized between MYOB Advanced and the BigCommerce store
  • How to configure mapping of standard and custom fields that need to be synchronized
  • How to update stock items and non-stock items with e-commerce-related data

Applicable Scenarios

You might want to configure additional mapping if you have defined custom fields in MYOB Advanced, in the BigCommerce store, or in both systems, and you want these fields to be synchronized between the two systems. For example, you might want to define an extra field on the customer registration form in the online store and map this field to a user-defined field or an attribute in a customer record in MYOB Advanced.

Filtering is useful if you do not want to synchronize all data of a particular entity. For example, you might want to define a subset of items in MYOB Advanced (which are referred to as products in BigCommerce) that you want to export to the online store, or exclude from export the customers that have incomplete information in MYOB Advanced (that is, the customers that have the On Hold status).

You might want to update e-commerce-related information about items in MYOB Advanced if you want to override default inventory settings related to export that have been configured for the store on the BigCommerce Stores (BC201000) form or if you want to maintain all product data, e-commerce-related or otherwise, in one system.

Configuration of Synchronization Preferences

During the initial configuration of the connection between MYOB Advanced and the BigCommerce store, you determine which of the entities supported by the BigCommerce connector need to be synchronized between the two systems. To do this, you select the Active check box for each required entity on the Entity Settings tab of the BigCommerce Stores (BC201000) form. On this tab, you can also configure the following:

  • The direction of the synchronization. For each entity, you specify whether data should be exported to BigCommerce, imported to MYOB Advanced, or synchronized in both directions.
  • The primary system. You indicate which of the systems, ERP (that is, MYOB Advanced) or External System (that is, BigCommerce), should be used as the source of data if conflicts occur during the synchronization of a particular entity.
  • The real-time synchronization mode. You indicate whether the synchronization records for a particular entity should be processed immediately after the data is prepared by selecting either of the following options:
    • Prepare: As soon as a push notification about a change to data is received, the corresponding synchronization record is placed in the processing queue.
    • Prepare & Process: As soon as a push notification about a change to data is received, the corresponding synchronization record is placed in the processing queue, and data processing is immediately started for the synchronization record.
  • The number of attempts when an error occurs. You specify the number of times the system will try to process each synchronization record before the synchronization record is assigned the Aborted status and excluded from synchronization.

You can also change these settings for each particular entity by using the Entities (BC202000) form.

Filtering and Field Mapping for Export and Import

For some of the entities supported by the e-commerce connector, on the Entities (BC202000) form, you can configure the additional synchronization settings—for example, define a filter to be applied during the synchronization of entity data, or define a new mapping between the fields in MYOB Advanced and the fields in BigCommerce. You define filters and mappings for the import and export processes on the following tabs:

  • Filtering for import: Import Filtering tab
  • Filtering for export: Export Filtering tab
  • Mapping for import: Import Mapping tab
  • Mapping for export: Export Mapping tab
Tip: On these tabs, you can change the order of any row in the table by dragging it to its new position.

The display of the listed tabs is determined by the entity selected in the Summary area. The table below shows the availability of filtering and mapping functionality for particular entities.

Table 1. Availability of Filtering and Mapping Options for Entities
Entity in Import Mapping Import Filtering Export Mapping Export Filtering
Customer Yes Yes Yes Yes
Customer Price Class Yes Yes Yes Yes
Customer Location No Yes No Yes
Sales Category Yes Yes Yes Yes
Stock Item No No Yes Yes
Non-Stock Item No No Yes Yes
Template Item No No Yes Yes
Base Sales Price No No No No
Price List No No No No
Product Image No No No No
Product Availability No No No No
Sales Order Yes Yes Yes Yes
Payment Yes Yes No No
Shipment No No Yes Yes

For information about standard mapping of entities, see Retail Edition Entity Reference. For details about filtering and mapping for the export and import processes, see Preparing Entities for Synchronization: Filtering and Preparing Entities for Synchronization: Field Mapping.