Fields Correlation

Categories

 

The following fields can be found in the Category Details tab within a specific category.

 

Category Details

 

• Name: Category’s display name.
  • Mapped with the Category name.
  • A string is sent.
• URL: The unique URL path differentiator.
  • Mapped with the unique text of your choice, this text will appear in the URL when you open the category.
  • A string is sent.
• Description: Category description.
  • Mapped with the Category description.
  • Big_string is sent.
• Parent Category: Category under which the current category is placed.
  • Automatically mapped with the corresponding parent category.
• Sort Order: The position number of the category within the parent category.
  • Mapped with order field.
  • An integer or string is sent.
• Image: Category Image.
  • Mapped with Category image.
  • The array is sent with status, unique ID, and download link of the corresponding picture size cut.

 

Product Categories Menu

 

• Is Visible: the Visible toggle button Product Categories menu.
  • Mapped with the corresponding boolean visibility field.
  • Boolean is sent (string also accepted Yes/No, True/False).

 

Search Engine Optimization

 

• Page Title: Home Page Title, the title of the web page displayed in the searches.
  • Mapped with the name of your choice, if blank the Category name will be used.
  • A string is sent.
• Meta Keywords: Content’s descriptive keywords.
  • Mapped with the selection of keywords separated by commas.
  • A string is sent.
• Meta Description: Summary of the category shown in web searches.
  • Mapped with the text of your choice with a brief description of the category.
  • Sent in string or big string format.
• Search Keywords: Keywords used in a web search of the category.
  • Mapped with the selection of keywords separated by commas.
  • Sent in string or big string format.

 

 Products

 

Basic Information

 

• Name: Product Name.
  • Mapped with the name.
  • A string is sent.
• Default Price: Default price (tax excluded).
  • Mapped with the price without tax.
  • The number is sent.
  • Also present in the Pricing section.
• Product Code/SKU: SKU field.
  • Mapped with item’s reference.
  • A string is sent.
• Weight: Weight field/ tab.
  • Mapped with the weight in kilograms.
  • The number is sent.
  • Also present in the Dimensions & weight section.
• Brand: Brand field.
  • Mapped with the brand.
  • A string is sent.
• Visible: Visible on storefront checkbox. 
  • Mapped with the corresponding field.
  • Boolean is sent.

 

Pricing

 

• Tax Class: Tax Class Dropdown list field.
  • Mapped with the corresponding Tax class field.
  • A string is sent.
  • Values accepted are those defined in Settings>Tax Settings>Tax Class Settings.

 

Pricing > Advanced Pricing

 

• Cost Price: Cost field.
  • Mapped with the cost price.
  • The number is sent.
• Retail Price: MSRP field.
  • Mapped with Retail price.
  • The number is sent.

• Sale Price: to match this field, you only have to send a value in the “Sale Price” field in the connector.

Note:  once a value has been sent, 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.

 

• Sale Price: Sale Price field
  • Mapped with sale price
  • Number is sent
• Product Tax Code: Tax Provider Tax Code field in Pricing Tab
  • Mapped with the corresponding tax code
  • String is sent
  • Tax Configuration subsection
• Bulk Pricing Rule Qty Min X: Min quantity
  • Mapped with the minimum amount to apply the discount
  • Number is sent
• Bulk Pricing Rule Qty Max X: Max quantity
  • Mapped with the maximum amount to apply the discount
  • Number is sent
• Bulk Pricing Rule Type X: Discount type 
  • Mapped with the discount type
  • String is sent
  • Values accepted
    • percent
    • fixed
    • price 

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

 

• Bulk Pricing Rule Amount X: Unit price
  • Mapped with the amount of € or %
  • Number is sent

 

Dimensions & Weight

 

• Width: Width field
• Height: Height field
• Depth: Depth field

 

Description

 

• Description: Description field

  • Mapped with Description field
  • A big string is sent

 

Shipping details

 

• Free Shipping: Free Shipping checkbox
  • Mapped with the corresponding field
  • Boolean is sent
• Fixed Shipping Price: Fixed Shipping Price
  • Mapped with the shipping price
  • Number is sent
  • This field will be disregarded if Free Shipping is marked

 

Images & videos

 

• Product Images: Image
  • Mapped with the image field
  • The array is sent with status, unique ID, and download link of the corresponding picture size cut
• Product Image descriptions: Description 
  • Mapped with the image description field
  • The table is sent with picture names in the first column and the corresponding descriptions in the second column
• YouTube Videos: Video
  • Mapped with the field containing the YouTube video link
  • String is sent

 

Inventory

 

• Tracking Method: Track inventory
  • Mapped with the tracking method field
  • String is sent
  • Values accepted
    • variant
    • product
• Stock and Low Stock
  • Mapped with the stock and low stock field
  • Number is sent
  • If Tracking Method = product > stock field in the Inventory tab
  • If Tracking Method = variant > stock field in each variant

 

Product Identifiers

 

• Global Trade Item Number: Global Trade Item Number (GTIN)
  • Mapped with the GTIN format text
  • String is sent
• Manufacturer Part Number: Manufacturer Part Number (MPN)
  • Mapped with MPN format text
  • String is sent
• Product UPC/EAN: Product UPC/EAN
  • Mapped with the UPC/EAN format text
  • String is sent
• Bin Picking Number: Bin Picking Number (BPN)
  • Mapped with the BPN format text
  • String is sent

 

Storefront Details

 

• Warranty Information: Warranty information in the Storefront Details tab
  • Mapped with the corresponding warranty information field
  • A big string is sent
• Search Keywords: Search Keywords
  • Mapped with the list of keywords
  • A list of comma-separated values is sent
• Availability: Purchasability/Availability text
  • Mapped with the corresponding message text indicating the availability of the item
    • Example: Shipped in 1 hour if ordered before 07:00 p.m.
  • String is sent
• Featured Product: Set as Featured Product on my Storefront
  • Mapped with the corresponding field
  • Boolean is sent will mark or unmark the Featured Product star
• Sort Order: Sort Order field
  • Mapped with the corresponding sort field
  • The number is sent corresponding to the position of the item
• Condition: Condition field
  • Mapped with the condition field
  • String is sent
  • Accepted values:
    • new, used, refurbished

 

Purchasability

 

• Preorder Message and Release Date: Message and Release date
  • Visible if the checkbox “This product is coming soon but I want to pre-order” option is checked in the Purchasability Section
  • Mapped with the Preorder message field and Release Date field
  • String and Date are sent
• Remove pre-order status on this date: Remove Pre-order status
  • Visible if the checkbox “This product is coming soon but I want to pre-order” option is checked in the Purchasability Section
  • Mapped with the corresponding field
  • Boolean is sent
• Minimum Purchase Quantity: Minimum Purchase Quantity
  • Mapped with the corresponding quantity
  • Number is sent
• Maximum Purchase Quantity: Maximum Purchase Quantity
  • Mapped with the corresponding quantity
  • Number is sent

 

Gift Wrapping

 

• Gift Wrapping: Gift Wrapping options
  • Mapped with the corresponding field
  • String is sent
  • Values accepted
    • Any, none, or list
• Gift Wrapping Options List: Gift Wrapping options
  • If the “Specify gift wrapping options for this product” option is checked
  • These options have to be previously created, several options can be chosen
  • A list of values separated by a comma is sent

 

Search Engine Optimization

 

• Page Title: Page Title
  • Mapped with the corresponding SEO Title field
  • String is sent
• Meta Keywords: Meta keywords
  • The version used during the creation of this document doesn’t have this field either
• Meta Description: Meta Description
  • Mapped with the corresponding SEO Description field
  • BigString is sent
• URL: Product URL
  • Mapped with the handle that will appear at the end of the item’s URL
  • String is sent

 

Open Graph Sharing

 

• Object Type: Object type dropdown
  • Mapped with the corresponding
• Related Products: Related products in the Related Products tab

Warning: it is possible to send custom fields in the connector.

 

Variants

 

Products Variations tab

All the fields below are situated in the Variants section table and can be chosen to view or not view

Warning: These fields can be hidden, check the “Edit Columns” option in the Variants section. Also, to create variants in BigCommerce it is mandatory to send at least one configurable field apart from the previous fields.