Syncing Data To and From ChannelAdvisor

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.

  1. Click on ChannelAdvisor Connector Initialization in the ChannelAdvisor workspace.

  2. Click the Initialize button.

Connector Initialization

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.

  1. The stock item must belong to an Item Class that has been previously mapped to a Classification in ChannelAdvisor.

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

  1. Custom Sync: The product data from Acumatica will only sync changes that happened within a specified date range.

  2. Delta Sync: Only products with data changes will be synchronized and updated. All other records will be skipped.

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

  1. Select the type of sync from the drop-down menu.

  2. Toggle the ChannelAdvisor
    Site on.

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

  1. Exported simple stock items are listed in the All tab with all other kits and configurable products.

    kits and configurable products

  2. Configurable products are listed under the Variations tab. The parent item will list with all configurable variation relationships beneath.

    variation relationships beneath

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

    Qty Total Available

ChannelAdvisor Data Exchange

The Data Exchange screen is used to exchange orders and shipment data between Acumatica and ChannelAdvisor.

  1. In Acumatica, navigate to the ChannelAdvisor workspace and click Data Exchange.

  2. Toggle the Action from the dropdown menu.

    1. Orders Import: Imports all order data from ChannelAdvisor to Acumatica, including FBA order data and shipment data

    2. Shipments Export: Exports all FBM shipment data from Acumatica to ChannelAdvisor.

    3. Retrieve Product IDs in ChannelAdvisor: Displays the ChannelAdvisor Product IDs in the Stock Items’ General Settings tab.

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

  3. Select Process All.

Data Exchange screen in Acumatica

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.

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

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

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

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

Active Sales Price Sync screen

When all items have been added, clicking Process will push the new Sales Price data to ChannelAdvisor