Skip to content
  • There are no suggestions because the search field is empty.

BigCommerce Setup - Sending/Retrieving Listing Data

Sending Listing Data to BigCommerce

Once you have created a CSM listing and defined any additional information such as product description, you can send the listing to your BigCommerce platform by choosing the Actions ribbon, then choose the Channel Integration menu and executing Send All Listing Data to Channel function.

This will send the basic information about the item to BigCommerce. As part of this process, a new, corresponding product will be created on your BigCommerce platform. BigCommerce will assign a unique identification number to this record; this value will be retrieved by CSM and presented in the External ID field on the listing’s Listing Status FastTab. The Last External Update Result field on this FastTab will also contain information about the process; this is particularly useful if CSM was unable to send the listing information to BigCommerce, as the message in this field will contain insight into the nature of the error.

You can also perform these actions against multiple listing records at once from the CSM Listings page:

  • Select the relevant CSM listing records
  • Choose the Actions ribbon, then choose the desired action in the Channel Integration group. Both the Send All Listing Data to Channel and Send Listing Base Info to Channel actions can be executed for multiple CSM listing records.

Note: the instructions in this section pertain to the export of simple or non-configurable items from Business Central to BigCommerce. Exporting a configurable item (defined as a top-level or parent item with a number of “children” based on variable attributes) is a multi-step process discussed later. 

If you are using CSM to synchronize product attributes between Business Central and BigCommerce, you can send a CSM listing’s defined attributes to the external platform by choosing the Actions ribbon, then opening the Channel Integration group and choosing the Send Attribute Values to Channel action. Static attributes will be assigned as custom fields for the corresponding product record in BigCommerce, while configurable attributes will be set up as product variant options.

If you have assigned multiple categories to a listing, they will be sent to BigCommerce as part of the Send All Listing Data to Channel action. If you add these categories after the listing is initially sent to BigCommerce, however, you can update the product on BigCommerce with this additional information by choosing the Actions ribbon, then opening the Channel Integration group and choosing the Send Additional Categories to Channel action.


The Actions ribbon also has a dedicated Send Price Update to Channel action that will only send pricing information from Business Central to BigCommerce. This is useful in scenarios where an item’s pricing changes, but all other information remains the same. When sending price information for an item, CSM will first review the price group that has been assigned in the Price Group Code field for the BigCommerce sales channel. If a price exists for the item within that price group, this amount will be sent to BigCommerce. If CSM is unable to find the item within the assigned price group, it will use the unit price that has been defined for the item record.

In addition to the manual process of sending updated pricing to BigCommerce described above, these actions can be scheduled as part of BigCommerce’s automation routines. There are two automation routines included to support different update scenarios:

  • PRODBASEPRICEALL: when this automation is executed, prices for all CSM listing items will be sent to BigCommerce
  • PRODBASEPRICEUPDATE: when this automation is executed, only prices for CSM listings items whose External Requires Update field is enabled will be sent to BigCommerce.

Loading CSM Listings from BigCommerce Data

It is possible to import product information from your connected BigCommerce platform into Business Central, then create CSM listings from this data. You can then link these CSM listings to Business Central items. This is useful if you have already created products on your BigCommerce platform, and would prefer to use this external platform, rather than Business Central, as the basis for your CSM listings.

Note: the process of importing listing information from BigCommerce and into Business Central is meant to assist in the initial setup of your CSM listing management module. For the ongoing maintenance of products between platforms, we recommend using Business Central as the primary source and then exporting data to BigCommerce.

 To load listings from BigCommerce:

  • Open the CSM sales channel that represents your BigCommerce platform. 
  • Choose the Related ribbon, then select the Setup Actions menu and choose the Load Products From Channel action.
  • On the Get Listings from Channel page, confirm the correct sales channel has been selected, then choose the OK button. 

CSM will import product data from BigCommerce and create a separate CSM listing record for each product. The external ID for each listing will be populated with the unique identification number assigned by BigCommerce. In addition, any product listing availability default settings that are defined for the sales channel will be assigned to these new CSM listings.

  • Open each CSM listing, and on the General FastTab, enter the corresponding Business Central item number in the No. field to link the CSM listing to an item.

Note: you can automate this linkage prior to loading items from BigCommerce by assigning the product’s channel item SKU as one of the Business Central item’s item identifiers. When CSM creates a new listing with data from BigCommerce, it will determine if any Business Central items have an item identifier that shares that listing’s channel item SKU; if it can find a match, it will assign the item to the new listing.

Product Listing Availability

It is possible to instruct CSM to calculate availability for a CSM listing’s Business Central item and then send this information to BigCommerce. It is necessary for the External Inventory ID field on the CSM listing’s Inventory Information FastTab to be populated with the BigCommerce product’s unique variant ID; this value should be automatically retrieved by CSM when the listing is initially associated to the related BigCommerce product.

If default product availability calculation settings are defined for a CSM sales channel, they will be assigned to new CSM listings that are created for the channel. It is possible to modify these values on a listing-by-listing basis:

  • Open the CSM listing record for which you want to calculate and send inventory availability. 
  • On the Availability FastTab, enable the Send Availability field. This field will be automatically enabled/disabled based on the sale channel’s default setting, but it can be changed on a listing-by-listing basis.
  • Fill in the following fields:
    • Availability Basis: select the Business Central value that will be used as the basis for the item’s availability calculation.
    • Compare availability To: select the Last Value Sent This will instruct Business Central to calculate the item’s availability from the last availability quantity that was sent from Business Central to BigCommerce. External Inventory on Hand, is not supported at this time.
    • Available Channel Percent: enter the percentage of Business Central availability that will be sent to BigCommerce. This percentage will be applied to the item’s quantity when calculating availability for the listing. This is useful if you want to retain a portion of your on-hand quantity as safety stock.
    • Available Min Qty Threshold: enter the minimum available product quantity that will be sent to BigCommerce. CSM will not send an available quantity that is less than the defined minimum threshold to BigCommerce; in such a scenario, an available quantity of zero will be sent to BigCommerce.
    • Subtract Threshold From Availability: select this field to instruct CSM to subtract the defined minimum quantity threshold value as part of the listing’s availability calculation.
  • To manually calculate the product’s availability, choose the Actions ribbon, then select the Data menu and choose the Calculate Channel Availability action.

CSM will calculate availability for the item based on the settings on the Availability FastTab and enter the result of this calculation in the Available Last Qty Calc field. CSM will include inventory from any Business Central locations that have been mapped to the sales channel’s assigned channel inventory location, which is defined in the Channel Inv. Location ID field on the CSM Sales Channel page. You can map more than one Business Central location to this channel location, allowing you to calculate and send an inventory availability quantity that is an aggregate of item availability across multiple locations.

For example, suppose we have a CSM listing record with the following settings:

  • Available Channel Percent: 90%
  • Available Minimum Quantity Threshold: 15
  • Subtract Threshold from Availability: Yes

If we instruct CSM to calculate availability for the item and it has an on-hand quantity of 600, the CSM listing’s calculated availability would be (600 x 90%) – 15 = 525.

Following the listing availability calculation, CSM uses the setting in the Compare availability To field:

  • Last Value Sent: CSM compares the listing’s calculated availability to the value in the Available Last Qty Sent This field presents the quantity that was most recently sent to BigCommerce for the listing.

If the listing’s calculated availability value differs from the comparison value, you can instruct CSM to send updated availability information to BigCommerce by choosing the Actions ribbon, then selecting the Channel Integration menu and choosing the Send Availability to Channel action.