Pushing Products to Bigcommerce Mapping

ChannelApe supports pushing products into Bigcommerce from ChannelApe. In order to be able to push products into your Bigcommerce store, you must install and configure the Bigcommerce integration. Once this is complete, you can set up a recipe to push your products into Bigcommerce.

Permissions
ChannelApe does not support pushing products when variants are disabled. The following permissions are needed to perform the following actions in Bigcommerce.

  • To create new products in Bigcommerce, you need to have the Create and Read Products setting.
  • To update products that ChannelApe has created, you need to have the Update and Read Products setting.
  • To update variants that ChannelApe hasn’t created but ChannelApe has a matching variant, you need to have the Update and Read Products setting.
  • To remove products that ChannelApe has created, you need to have the Delete and Read Products setting.
    • When delete is disabled, update is enabled, and all products are in the block panel, ChannelApe will hide the product in your storefront. This is ideal when you want to keep the product listing, but not show it on your storefront.

Mapping
When products are pushed into Bigcommerce, they are mapped in the following way.
*If ChannelApe didn’t create the product nothing is changed at the product level by ChannelApe. When ChannelApe matches by inventory item value when pushing products, the updateable by match fields are denoted in the mapping table below.

ChannelApe Product → Bigcommerce Product

 

ChannelApe Field Bigcommerce Field or Value Notes
title name
“physical” type
upc upc
The weight of the first found variant for the product converted to the store’s weight unit from grams weight Must have ‘weight’ update field configured on Channel to update.
description description Must have ‘description’ update field configured on Channel to update.
Additional Field = “width” width Not converted
Additional Field = “depth” depth Not converted
Additional Field = “height” height Not converted
Additional Field = “gtin” gtin
Additional Field = “mpn” mpn
Modified retail or wholesale price (depending on channel settings) of first variant for product. price Must have ‘price’ update field configured on Channel to update.
Additional Field = “bigcommerce_cost_price” cost_price Must have ‘price’ update field configured on Channel to update.
Additional Field = “bigcommerce_retail_price” retail_price Must have ‘price’ update field configured on Channel to update.
Additional Field = “bigcommerce_sale_price” sale_price Must have ‘price’ update field configured on Channel to update.
If “bigcommerce_categories” additional fields is present on first variant for product

  • Parse “bigcommerce_categories” variant additional field into list. This should be a comma seperated list.

Else

  • use primary/secondary categories
categories These must match some valid category id in Bigcommerce. ChannelApe does not validate before pushing.
If product vendor is a valid brand name for the BigCommerce store:

  • Find and set band id by name

Else

  • Create and use created brand id
brand_id Must have ‘vendor’ update field configured on Channel to update.
“variant” inventory_tracking
true or false is_visible
  • True when creating new product
  • When delete is disabled and update is enabled, and all variants for product are in block panel, and ChannelApe created the product this will get set to false.
condition of first found variant on product condition Valid values are New, Used, and Refurbished
set to false when first variant for product doesn’t have a valid condition is_condition_shown
tags meta_keywords Must have ‘tags’ update field configured on Channel to update.
List of all unique additional field pairs beginning with the prefixes “bigcommerce_custom_field_name_” and “bigcommerce_custom_field_value_” across all ChannelApe variants making up the BigCommerce product sorted alphabetically by name. custom_fields Map all custom field pairs found in additional fields across all ChannelApe variants for ChannelApe product. Duplicate additional field suffixes for the same ChannelApe variant will be omitted.
variants variants

ChannelApe Variant → Bigcommerce Variant

 

ChannelApe Field Bigcommerce Field or Value Notes
Modified retail or wholesale price (depending on channel settings) price Updateable by match.
Additional Field = “bigcommerce_cost_price” cost_price Must have ‘price’ update field configured on Channel to update. Updateable by match.
Additional Field = “bigcommerce_retail_price” retail_price Must have ‘price’ update field configured on Channel to update. Updateable by match.
Additional Field = “bigcommerce_sale_price” sale_price Must have ‘price’ update field configured on Channel to update. Updateable by match.
weight converted to the stores weight unit from grams weight Must have ‘weight’ update field configured on Channel to update. Updateable by match. Retrieves value from product when not provided. Supports conversion from grams to pounds, ounces, kilograms, grams, and tonnes.
Additional Field = “height” height Not Converted. Updateable by match.
Additional Field = “width” width Not Converted. Updateable by match.
Additional Field = “depth” depth Not Converted. Updateable by match.
Additional Field = “gtin” gtin
Additional Field = “mpn” mpn
First image from variant images image_url Must have ‘images’ update field configured on Channel to update. Updateable by match.
upc upc Updateable by match if SKU is inventory Item key.
sku sku Updateable by match if UPC is inventory Item key.
quantity inventory_level Must have ‘inventoryQuantity’ update field configured on Channel to update. Updateable by match.
Create list of option values by iteration through variant options.

  • key is mapped to option_display_name
  • value is mapped to lable
option_values

ChannelApe Product → Bigcommerce Product Image

 

ChannelApe Field Bigcommerce Field or Value Notes
First Image is set to true is_thumbnail
Additional Field = “bigcommerce_images_description” description
image from images list image_url

ChannelApe Product → Bigcommerce Product Metafields

ChannelApe stores product id as a metafield to know when ChannelApe has created a product.

ChannelApe Field Bigcommerce Field or Value Notes
“channelape” namespace
“write” permission_set
“productId” key
ChanneApe product ID value

ChannelApe also tracks images for products in metafields.

ChannelApe Field Bigcommerce Field or Value Notes
“channelape” namespace
“write” permission_set
“images” key
ChannelApe product images converted to valid CSV cell string value