Prepare Data

Form ID: (BC501000)

By using this form, you can manually start the data fetch process for a single entity or multiple entities. For details on the data fetch process, see Data Synchronization: General Information.

Note: This form is available only if the Retail Commerce feature is enabled on the Enable/Disable Features (CS100000) form.

Form Toolbar

The form toolbar includes standard and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands are listed in the following table.

Button Description
Prepare Starts the data preparation process for the entities you have selected in the table.

Selection Area

By using the elements in this area, you can configure the data fetch process to be started for the entities in the table.

Element Description
Store

The name of the online store.

By default, the system inserts the store for which the Default check box is selected on the BigCommerce Stores(BC201000) or Shopify Stores (BC201010) form.

Entity The entity for which the data preparation process should be started.
Prepare Mode An indicator of which data should be pulled from MYOB Acumatica and the online store and placed in the processing queue during the data preparation process.

You select either of the following options:

  • Incremental (default): Only document or entity records that have been modified since the last successful full or incremental data preparation (whichever happened most recently) should be pulled and put in the processing queue.
  • Incremental by Date: Document or entity records are pulled and placed in the processing queue only if they have been modified during the specified date range, which you define by specifying the Start Date and End Date, and if they have not been processed.
  • Full: All document or entity records created or updated during the specified date range, which you define by specifying the Start Date and End Date, should be pulled and placed in the processing queue, regardless of whether they have been processed previously or not.
Start Date

The start date of the date range. Records that have been modified in this date range are prepared for synchronization.

This box is available for editing only if Incremental by Date or Full is selected in the Prepare Mode box.

End Date

The end date of the date range. Records that have been modified in this date range are prepared for synchronization.

This box is available for editing only if Incremental by Date or Full is selected in the Prepare Mode box.

Table

In this table, you can select the entities that should be prepared for synchronization and view the information about the previous data preparation processes, including the date and time of the previous full and incremental fetch, and the errors that occurred during the last data preparation attempt, if any.

The table toolbar includes only standard buttons. For the list of standard buttons, see Table Toolbar.

Table 1. Table Columns
Column Description
Selected A check box that you select to include the row in processing.
Store

The online store with which the entity is synchronized.

If you click the link with the store name, the system opens the form with the store settings, which can be BigCommerce Stores (BC201000) or Shopify Stores (BC201010), in a pop-up window.

Entity

The entity that has been activated for synchronization with the store in the store settings.

If you click the link with the entity name, the system opens the Entities (BC202000) form.

Sync Direction The direction of the synchronization. One of the following options may be displayed:
  • Export: Data is exported from MYOB Acumatica to the external e-commerce system.
  • Import: Data is imported to MYOB Acumatica from the external e-commerce system.
  • Bidirectional: Data is synchronized between MYOB Acumatica and the external e-commerce system in both directions.
Primary System

The system that is used as a source of data during the synchronization of entities. If bidirectional synchronization is selected, the data of the primary system takes precedence if any conflicts arise during the synchronization.

The primary system can be either of the following:

  • ERP (that is, MYOB Acumatica)
  • External System (that is, the external e-commerce system)
Last Error The last error that occurred during the data fetch process (if any).
Ready to Process

The number of synchronization records that have been created for the entity and that have the Prepared and Failed statuses.

If you click the link with the number of records, the Process Data (BC501500) form opens with the store and the entity selected in the Selection area and the list of prepared and failed synchronization records displayed in the table.

Processed Records

The number of synchronization records that have been successfully synchronized and assigned the Processed status.

If you click the link with the number of records, the Sync History (BC301000) form opens with the store and entity selected in the Selection area and the list of successfully processed synchronization records displayed in the table of the Drilldown filter tab,

Total Records

The total number of synchronization records hat have been created for the entity.

If you click the link with the number of records, the Sync History (BC301000) form opens with the store and entity selected in the Selection area and the list of all records displayed on the All Records filter tab.

Latest Incremental Import The date and time of the last incremental data fetch for the Import direction.
Latest Incremental Export The date and time of the last incremental data fetch for the Export direction.
Connector

A read-only column that shows the name of the e-commerce connector.

This column is hidden by default.

Last Reconciliation Export

A read-only column that shows the date and time of the last data preparation in the Incremental by Date mode for the Export direction.

This column is hidden by default.

Last Reconciliation Import

A read-only column that shows the date and time of the last data preparation in the Incremental by Date mode for the Import direction.

This column is hidden by default.

Real-Time Export

A read-only column that shows the status of real-time export for the entity. The status can be one of the following:

  • Stopped: Real-time synchronization is not enabled for the Export direction.
  • Running: Real-time synchronization is enabled for the Export direction.
  • Not Supported: Real-time synchronization is not available for the Export direction.

This column is hidden by default.

Real-Time Import

A read-only column that shows the status of real-time import for the entity. The status can be one of the following options:

  • Stopped: Real-time synchronization is not enabled for the Import direction.
  • Running: Real-time synchronization is enabled for the Import direction.
  • Not Supported: Real-time synchronization is not available for the Import direction.

This column is hidden by default.

Real-Time Mode

A read-only column that shows the mode of the processing of the synchronization records, which can be either of the following:

  • 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.

This column is hidden by default.

Sync Order

A read-only column that shows the order of entity synchronization. The entity with the lowest value is processed first.

This column is hidden by default.