•  Refresh
  • Tools
  •  
  • Expand All
  • Collapse All
  • Locales
  • Get File Link
  • Report Typo
  • Print
  • Export

Sync History

Form ID: (BC301000)

By using this form, you can view the status of all synchronization records related to a particular entity or quickly view particular groups of synchronization records related to the entity on separate tabs, based on what their status is or whether they are active synchronization records.

You can also use the form to manually synchronize individual synchronization records between Acumatica ERP and the external ecommerce system, delete synchronization records, and set the status of particular synchronization records to Skipped or Processed.

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



In This Topic [Hide/Show]

Back to TopForm Toolbar

The form toolbar and More menu include the buttons and commands described below.

Command Description
Sync Starts the data synchronization process for the selected synchronization record or records. You select a synchronization record by selecting the Included check box for it or by clicking its row before invoking this command.
This button launches forced synchronization. That is, even if the synchronization record already has a status of Processed, the system synchronizes it again, with the data in the primary system (the system used as the source of data) taking precedence.
Prepare Starts the data preparation process in Incremental mode for the entity selected in the Entity box of the Summary area.
This command is available only if an entity is selected in the Entity box.
Delete Deletes the selected synchronization record or records from the table on the tab. You select a synchronization record by selecting the Included check box for it or by clicking its row before invoking this command.
Skip Sets the status of the selected synchronization record or records to Skipped, which excludes the synchronization record from further synchronization and removes it from the table. You select a synchronization record by selecting the Included check box for it.
Skipped synchronization records are listed on the Skipped filter tab of this form.
Set as Processed Sets the status of the selected synchronization record or records (that is, all records for which you have selected the Included check box) to Processed, updates the date and time of the last synchronization with the current date and time for these records, and sets the Last Operation value to Manually Synchronized for these records.
Synchronization records set as processed are listed on the Processed filter tab of this form.
Set as Prepared Sets the status of the selected synchronization record or records (that is, all records for which you have selected the Included check box) to Prepared, updates the date and time of the last synchronization with the current date and time for these records, and sets the Last Operation value to Forced to Resync for these records.
Synchronization records set as prepared are listed on the Prepared filter tab of this form.
Add New Opens the Add or Edit Sync Status dialog box for adding a new synchronization record.
Edit Opens the Add or Edit Sync Status dialog box for editing the selected synchronization record. You select a synchronization record by selecting the Included check box for it or by clicking its row before invoking this command.
Synchronization records can be edited for the following entities:
  • For BigCommerce: Stock Item, Non-Stock Item, Template Item, Sales Order, Shipment, Customer Price Class, Sales Category, Customer
  • For Shopify: Stock Item, Non-Stock Item, Template Item, Sales Order, Shipment, Customer
View Details Opens the Sync Record Details dialog box for the selected synchronization record. You select a synchronization record by selecting the Included check box for it or by clicking its row before invoking this command.

Add or Edit Sync Status Dialog Box

By using this dialog box, you can create a new synchronization record or update an existing one.

Element Description
Connector The ecommerce connector used for the synchronization of data between Acumatica ERP and the external ecommerce system.
Store Required. The name of the ecommerce store with which data is synchronized.
Only stores configured for the selected connector are displayed in the drop-down list.
Entity The entity for which data is synchronized.
ERP ID The identifier in Acumatica ERP of the record being synchronized.
Filtering by ERP ID can affect system performance.
External ID The identifier in the external ecommerce system of the record being synchronized.
Need to Sync A check box that you select to indicate that the new or updated record must be synchronized upon the creation.
The dialog box also contains the following button.
Apply Creates or updates the synchronization record with the specified values and closes the dialog box.

Sync Record Details Dialog Box

The table of this dialog box shows the details of the entity records that were synchronized during the processing of the selected synchronization record.

Column Description
Entity Type The type of entity that was synchronized during the processing of the synchronization record.
ERP ID The identifier of the entity record in Acumatica ERP that was synchronized during the processing of the synchronization record.
If you click the link in this column, the system opens the corresponding Acumatica ERP form with the record selected.
External ID The identifier of the entity record in the external system that was synchronized during the processing of the synchronization record.
If you click the link in this column, the system opens the corresponding page of the ecommerce system and displays the details of the record.

Back to TopSelection Area

In this area, you select the criteria of the synchronization records to be displayed on the tabs of the form.

Element Description
Store The name of the ecommerce store for which you want to display synchronization records on the tabs.
By default, the system inserts the store for which the Default check box is selected on the BigCommerce Stores (BC201000), Shopify Stores (BC201010), or Amazon Stores (BC201020) form.
Entity The entity for which you want to display synchronization records on the tabs.
The drop-down list contains only the entities that have been activated for the selected store.
If no option is selected in this box, the synchronization records of all entities are listed on the tabs.

Back to TopTable

The table displays synchronization records for the selected store and entity.

Above the table is the Filter List drop-down menu. It contains a list of the following filters to display specific types of synchronization records in the table:

  • All Records: This filter displays all synchronization records for the selected store and entity.
  • Aborted: This filter displays active synchronization records with the Aborted status—that is, active synchronization records that have been excluded from the synchronization by the system. The system assigns the Aborted status to a synchronization record if it fails to process it for more than the maximum number of failed attempts allowed for the synchronization of the entity to which the synchronization record belongs.
  • Deleted: This filter displays active synchronization records that have the Deleted status, which is assigned to a synchronization record if the record data it contains has been prepared (that is, pulled from Acumatica ERP and the external ecommerce system) and then deleted in the primary system of the entity.
  • Failed: This filter displays active synchronization records that have the Failed status, which the system assigns if the system could not process a synchronization record but the number of synchronization attempts is below the allowed maximum specified for the entity to which the synchronization record belongs. The system attempts to process synchronization records with this status when data processing is started for the corresponding entity.
  • Filtered: This filter displays active synchronization records that have the Filtered status. The system assigns this status to a synchronization record if it has been prepared and then filtered out during the synchronization because filtering conditions defined for the entity on the Entities (BC202000) form have been applied.
  • Inactive: This filter displays synchronization records for entities that have been deactivated (that is, the Active check box is cleared) on the Entities tab of the BigCommerce Stores (BC201000), Shopify Stores (BC201010) and Amazon Stores (BC201020) forms. Inactive synchronization records have the Active check box cleared in the table.
  • Invalid: This filter displays active synchronization records that the system has assigned the Invalid status—that is, synchronization records generated for document or entity records that cannot be synchronized, for example, if they have been used in the store settings. For instance, a customer record that has been selected as the Generic Guest Customer is not synchronized during the synchronization of the Customer entity.
  • Processed: This filter displays active synchronization records that have the Processed status—that is, active synchronization records that have been successfully processed by the system.
  • Ready to Process: This filter displays active synchronization records that have the Prepared status or the Failed status. The system attempts to synchronize records with either of these statuses when data processing is started for the corresponding entity.
  • Skipped: This filter displays the active synchronization records that have the Skipped status—that is, the active synchronization records that have been manually excluded from the synchronization by users.

Table Columns

Column Description
Included An unlabeled check box that you select to indicate that this synchronization record should be processed when you click an available button on the form toolbar or click an available command on the More menu. The possible commands that can be clicked for are Sync, Delete, Skip, Set as Processed Edit, and View Details.This check box is available for selection only if the entity and the store the synchronization record was generated for are activated in the store settings—that is, if the Active check box is selected for the store in the Summary area of the BigCommerce Stores (BC201000) or Shopify Stores (BC201010) form and the Active check box is selected for the entity on the Entities tab of these forms.
Entity The entity for which the synchronization record was generated.
Store The online store with which the entity is synchronized.
ERP ID The ID of the document or entity record in Acumatica ERP.
If you click the link in this column, the system opens the corresponding Acumatica ERP form in a pop-up window with the document or record selected.
External ID The ID of the document or entity record in the external ecommerce system.
If you click the link in this column, the system opens the corresponding page of the ecommerce system in a new window and displays the details of the document or record.
The value in this column may be simple or combined. A combined external ID includes two identifiers separated by a comma. For example, if the record represents a sales order that has been paid, this column would contain the order number and the payment number, separated by a comma.
External Description The description of the document or entity record in the external ecommerce system. The value in this column depends on the entity type of the synchronization record.
Status The status of the synchronization record.
The statuses for which active synchronization records are shown on a particular tab are generally indicated by the tab name. A synchronization record can have any of the following statuses:, which can be any of the following:
  • Prepared: The processing of the synchronization record has not yet been performed.
  • Failed: The processing of the synchronization record has failed.
  • Processed: The synchronization process for the synchronization record has been completed successfully.
  • Aborted: The synchronization record was excluded from synchronization by the system.
  • Skipped: The synchronization record was manually excluded from synchronization by a user.
  • Deleted: The document or entity record associated with the synchronization record has been deleted in one system or both systems.
  • Filtered: The synchronization record has been excluded from processing because the filtering conditions defined in the code or on the Entities (BC202000) form have been applied.
  • Invalid: The synchronization record cannot be processed because the synchronization of the document or entity record associated with it is not supported, for example, if the document or entity record was used in the store settings.
Last Error The error, if any, that occurred during the last attempt to process the synchronization record.
Last Operation The operation that was last performed on the document or entity record, which is one of the following options:
  • Inserted in ERP: The synchronization record was successfully processed; during the synchronization, a new document or entity record was created in Acumatica ERP.
  • Updated in ERP: The synchronization record was successfully processed; during the synchronization, the existing document or entity record was updated in Acumatica ERP.
  • Deleted in ERP: The synchronization record was successfully processed; during the synchronization, the existing document or entity record was deleted in Acumatica ERP.
  • Modified in ERP: The document or entity record associated with this synchronization record was changed in Acumatica ERP but not synchronized.
  • Failed to Save in ERP: An error occurred while the document or entity record was being saved in Acumatica ERP.
  • Conflict Resolved by Override in ERP: The synchronization record was successfully processed; during the synchronization, a conflict occurred that the system resolved by updating the document or entity record in Acumatica ERP with the changes from the external system.
  • Modified Locally, Sync Not Needed: The document or entity record was changed in Acumatica ERP but requires no synchronization.
  • Inserted Externally: The synchronization record was successfully processed; during the synchronization, a new document or entity record was created in the external system.
  • Updated Externally: The synchronization record was successfully processed; during the synchronization, the existing document or entity record was updated in the ecommerce system.
  • Deleted Externally: The synchronization record was successfully processed; during the synchronization, the existing document or entity record was deleted in the external ecommerce system.
  • Modified Externally: The document or entity record was changed in the external ecommerce system but not synchronized.
  • Failed to Save Externally: An error occurred while the document or entity record was saved in the external ecommerce system.
  • Conflict Resolved by Override Externally: The synchronization record was successfully processed; during the synchronization, a conflict occurred that was resolved by updating the document or entity record in the external ecommerce system with the changes from Acumatica ERP.
  • Modified Externally, Sync Not Needed: The document or entity record was changed in the external ecommerce system but requires no synchronization.
  • Sync Failed: An error occurred during the synchronization.
  • Manually Synchronized: The synchronization record was manually synchronized by the user.
  • Forced to Resync: The synchronization record was force-synchronized.
  • Not Found: During the synchronization, the document or entity record was not found in Acumatica ERP or in the external system.
  • Sync Settings Reconfigured: The synchronization settings for the entity were updated.
  • Skipped from Sync: The document or entity record was skipped during the synchronization.
  • Filtering Applied: Filtering conditions defined in the code or on the Entities (BC202000) form have been applied.
Last Attempt The date and time when the last attempt to run the data synchronization process occurred.
Attempt Count The total number of attempts to process the synchronization record if the attempt resulted in an error; otherwise, the column contains 0.
Active A read-only check box that indicates (if selected) that the entity to which the synchronization record belongs is activated in the store settings on the Entities tab of the BigCommerce Stores (BC201000) or Shopify Stores (BC201010) form.
External Hash The security value generated during the export or import operation if the document or entity record does not have a time stamp.
Ready to Process A read-only check box that indicates (if selected) that the synchronization record needs to be processed.
Connector The ecommerce connector used for synchronization.
This column is hidden by default.
Last Externally Modified The date and time when the document or entity record was last modified in the external ecommerce system.
This column is hidden by default.
Last Locally Modified The date and time when the document or entity record was last modified in Acumatica ERP.
This column is hidden by default.
Primary System The system that is used as the source of data during the synchronization of entities.
The primary system can be either of the following:
  • ERP (that is, Acumatica ERP)
  • External System (that is, the external ecommerce system)
If an entity is synchronized in both directions (Bidirectional is specified in the Sync Direction column), the data of the primary system takes precedence if any conflicts arise during the synchronization.
This column is hidden by default.
Sync Direction The direction of the synchronization. One of the following options may be displayed:
  • Export: Data is exported from Acumatica ERP to the external ecommerce system.
  • Import: Data is imported to Acumatica ERP from the external ecommerce system.
  • Bidirectional: Data is synchronized between Acumatica ERP and the external ecommerce system in both directions.
This column is hidden by default.
Sync Record ID The identifier of the synchronization record.
This column is hidden by default.
Created Date (ERP) The date and time of creating documents in Acumatica ERP during the import of the following documents from the Amazon store:
  • Seller-fulfilled orders
  • Marketplace-fulfilled orders
  • Payments
This date may not match the document date in Acumatica ERP, which is set as the created date of the corresponding external document.
This column is hidden by default and displays applicable dates for only Amazon stores.
Created Date (External) The date and time of creating the document in the Amazon store, which are the following depending on the document type:
  • Seller-fulfilled orders: Purchase date
  • Marketplace-fulfilled orders: Purchase date
  • Payments: Posted date
This column is hidden by default and displays applicable dates for only Amazon stores.