Syncing Data To and From ChannelAdvisor
Configure Sync Settings
Syncing data between marketplaces and Acumatica is a key benefit of the ChannelAdvisor connector, and this integration works best when data syncs regularly.
The recommended best practice is to set up recurring syncs using Schedulers.
There may be times when it is appropriate to sync data on demand. Instructions for on demand syncs can be found below.
Administrators need to be able to configure sync settings for:
-
Products
-
Orders
-
Shipments
ChannelAdvisor Connector Initialization
The Price and Inventory Sync is unidirectional, syncing data from Acumatica to ChannelAdvisor.
To export price and inventory, you will first need to initialize queues and push notifications.
-
Click on ChannelAdvisor Connector Initialization in the ChannelAdvisor workspace.
-
Click the Initialize button.
When the connection is initialized and confirmed, product data and order data are ready to sync between Acumatica and ChannelAdvisor.
Preparing Products for Export
The product sync is unidirectional, with products syncing from Acumatica to ChannelAdvisor.
-
Simple Stock Items in Acumatica map to Products in ChannelAdvisor
-
Configurable products in Acumatica map to Variation products in ChannelAdvisor
-
Kit products in Acumatica map to Bundled products in ChannelAdvisor
There are 2 conditions which must be met to export products.
-
The stock item must belong to an Item Class that has been previously mapped to a Classification in ChannelAdvisor.
-
The Active on ChannelAdvisor checkbox must be checked in the eCommerce tab for each stock item to be synced.
The Allowed for FBA checkbox may also be checked for stock items that may be fulfilled by Amazon, but it is not a requirement for product export.
ChannelAdvisor Products Sync
The ChannelAdvisor Products Sync screen is used to sync product data on demand.
Product data syncs using FTP.
The purpose of this is to maintain up-to-date Acumatica data in ChannelAdvisor.
The products in Acumatica will then export to ChannelAdvisor based on the fields defined in Mapping Settings. There are 3 options for syncs in Products Sync.
-
Custom Sync: The product data from Acumatica will only sync changes that happened within a specified date range.
-
Delta Sync: Only products with data changes will be synchronized and updated. All other records will be skipped.
-
Full Sync: All product data will be synced with ChannelAdvisor.
When you are ready to sync product data, in Acumatica, navigate to the ChannelAdvisor workspace and click Products Sync.
-
Select the type of sync from the drop-down menu.
-
Toggle the ChannelAdvisor
Site on. -
Click Process All.
The Product Sync will take place. Depending on the size of inventory and number of products, this may take up to 15min. This time is also based on the message queue threshold created in the Site Configuration. Remember, FTP calls will take longer to synchronize than API calls. It is best practice to establish a schedule to allow syncs to happen in non-working hours.
Products in ChannelAdvisor
On the ChannelAdvisor Merchant Site, go to the Products tab and select Catalog.
-
Exported simple stock items are listed in the All tab with all other kits and configurable products.
-
Configurable products are listed under the Variations tab. The parent item will list with all configurable variation relationships beneath.
-
Kit products are listed under the Bundled tab. These products have a parent item with all child items in the kit listed beneath. The bundle quantity is based on the lowest Qty Total Available of its child items.
ChannelAdvisor Data Exchange
The Data Exchange screen is used to exchange orders and shipment data between Acumatica and ChannelAdvisor.
-
In Acumatica, navigate to the ChannelAdvisor workspace and click Data Exchange.
-
Toggle the Action from the dropdown menu.
-
Orders Import: Imports all order data from ChannelAdvisor to Acumatica, including FBA order data and shipment data
-
Shipments Export: Exports all FBM shipment data from Acumatica to ChannelAdvisor.
-
Retrieve Product IDs in ChannelAdvisor: Displays the ChannelAdvisor Product IDs in the Stock Items’ General Settings tab.
-
It is critical that this sync process in Data Exchange is maintained. ChannelAdvisor Product IDs must be synced with Acumatica items. If ChannelAdvisor Product IDs are not retrieved, orders will not import into Acumatica.
-
-
-
Select Process All.
Data Exchange screen in Acumatica.
ChannelAdvisor Price and Inventory Sync
Price and inventory changes are processed via API up to the threshold limit set by the business based on their contract with ChannelAdvisor.
Any messages beyond the threshold will be processed via FTP.
-
Go to the Products’ Price and Inventory Sync processing screen via the ChannelAdvisor workspace. All product and inventory changes will appear in the Message list.
-
Click Process All.
The changes made in Acumatica will reflect within the ChannelAdvisor product catalog. These include changes to:
-
Price (Base Price and ChannelAdvisor Prices)
-
Description
-
Inventory (quantities)
-
These changes will be made from incoming order data as well as warehouse receipts.
-
-
Image placement
-
Attributes
A change made to these parts of a stock item will then add them to the queue to be synced in the Price and Inventory sync.
Products’ Price and Inventory screen.
The item will be updated on ChannelAdvisor when the sync is complete.
Import Orders
The Import Order Screen allows a user to prepare and import orders on a selective basis.
-
Clicking Prepare on this screen will populate all available orders in ChannelAdvisor.
-
A user may toggle specific orders and click Import to import the selected records.
-
Clicking Import All will import all records.
This process may be scheduled for automation with Acumatica’s Automation Scheduler functionality.
Import Orders screen
ACTIVE SALES PRICE SYNC
The Active Sales Price sync allows users to add items with active sales prices to be added for sync. If products are a part of an active sales price in Acumatica, a user may navigate to the Active Sales Price Sync, select the Site ID, and add the Inventory ID of the Sales Priced item to the sync.
Active Sales Price Sync screen
When all items have been added, clicking Process will push the new Sales Price data to ChannelAdvisor