Mapping products

The BigCommerce connector contains a list of existing fields by default, the ones which are generally very intuitive to map. However, there are others that need some mapping rules:

  • Retail Price: this refers to the MSRP, located in the “Pricing > Advanced Pricing” section. Thus, this does not need to be added as an additional field in the connector.
  • Sale Price: to match this field, you only have to send a value in the “Sale Price” field in the connector. Note that once a value has been sent, in order to delete it, the value ‘0’ will have to be sent for this field. If you send the field to Sales Layer with no content, the connector will not review that field and will not remove the initial value you placed there.
  • Tax Class: it must be mapped with the corresponding “Tax Class ID” in your BC store.
  • Type: corresponds to the Product Type field, just send the words "Digital" or "Physical".
  • Tracking Method: it corresponds to the Track Inventory field; in the product area, just send "product", in a variant level, you should send "variant".
  • Brand: if filled with a numerical value, the brand field must be the ID of the brand in BigCommerce. In case of a text field, it will be generated if it is new, or it will be associated if it already exists.
  • Availability: to map this field, just send the product status as "available", "disabled" or "preorder".

  Note: in some cases this field is called "Purchasability" in BigCommerce.

  • Gift Wrapping: to fill in this field, just send "any", "none" or "list", with the options. In the case of a “list”, it is necessary to map the Gift Wrapping Options List field (also in the connector) with the Gift Wrapping ID's previously created in BigCommerce, separated by commas (You can map multi-selection list type fields, text or number type fields).

 Note: If the Gift Wrapping ID does not exist in BC, it will return an error and the listing will not be added.

  • Condition: this field is mapped with "New", "Used" or "Refurbished".
  • Object Type: existing options can be sent exactly as is in the list that appears in BC.
  • Bulk Pricing: bulk price rules will be generated following 4 required fields where {n} must be the same number in the 4 fields of a rule.
    1. bulk_pricing_rule_qty_min_{n}: minimum units
    2. bulk_pricing_rule_qty_max_{n}: maximum units
    3. bulk_pricing_rule_type_{n}: discount rate to be mapped with “price”, “fixed” or “percent”.
    4. bulk_pricing_rule_amount_{n}: discount amount

Attention: If you select the discount type directly on the Big Commerce platform, you will see that you cannot select more than type. However, through API it is possible to send more than one type, even though you see only one type selected:

Bulk type selection

 

  • Free Shipping/Visible/Featured Product: these fields belong to boolean type and can be mapped with Yes/ No field type.
  • In the products tab, the additional fields will be associated and generated in the custom fields within BigCommerce. The additional fields within the variants tab will be those that define the product options in BigCommerce. Within the variants of the same product, the options must be unique.
  • URL: there are two ways to manage the URL field in the BigCommerce connector. The first one is the definition of the URL format in the Parameters tab of the connector depending on the structure chosen in the Url Structure tab within BigCommerce → Store Settings:

In Sales Layer

In Sales Layer

In BigCommerce

In BigCommerce

The second way consists of mapping the URL field that you find in the Category and Product tables of the BigCommerce connector in Sales Layer.

Warning: The mapping of the URL field in the tables has priority to the structure chosen in the 'Parameters' of the connector. Therefore, if in any of the tables in the connector the URL field is empty or not mapped, the URL will have the structure which was chosen initially.

  • Product images descriptions: this field is used to map the BigCommerce image description field and can be mapped with a table type field, in such a way that it contains the name of the images in the first column and its description in the second column. For instance:

Image text

Please note that:

  1. To remove a BigCommerce description from a specific image, you must send the name of the image in the first column, leaving the second column empty.
  2. If you send two different descriptions for the same image, only the first description will be considered.
  3. If any of the images are not in the table, their description will be omitted.

Starting with Sales Layer version 105  (October 2021), if the Availability field is a preorder type, it can be combined with the following fields:

  • Preorder Message: to send a text with the pre-order message;
  • Preorder Release Date: to send a date type field;
  • Remove pre-order status on this date: to send true / false value type;
  • Minimum Purchase Quantity: to send a number type field.
General recommendations
Mapping variants