Listing to BigCommerce with the Bulk Upload tool works the same way as listing anything else — you just need the right headers. This guide covers the BigCommerce-specific ones.
How BigCommerce headers are named
Every BigCommerce header is the word bigcommerce followed by the field name with the underscores removed, all in lower case. So the BigCommerce field fixed cost shipping price is the header bigcommercefixedcostshippingprice.
If you have more than one BigCommerce channel, the second and later instances carry their number: bigcommerce2price, bigcommerce3categories. The first instance has no number.
Use lower case for all headers. Headers are matched in lower case and a capitalised header will not be recognised.
Getting the ID lists you need
Brands, categories, tax classes, option sets and channels are all referenced by ID number, not by name. You do not need to ask support for these — you can download each list yourself.
Go to Channels > BigCommerce > Settings. Each list has two controls:
- Refresh pulls the current values from your BigCommerce store into SureDone. Do this first, and again whenever you add or rename something in BigCommerce.
- Download gives you a CSV of everything that has been synced.
Each download is a two-column file — the name in your store and the ID to put in your bulk file — with the exact bulk header in the top row:
| Settings button | File you get | Bulk header |
| Download Categories | Bigcommerce-Category-IDs.csv | bigcommercecategories |
| Download Brands | Bigcommerce-Brand-IDs.csv | bigcommercebrandid |
| Download Tax Classes | Bigcommerce-Tax-Class-IDs.csv | bigcommercetaxclassid |
| Download Option Sets | Bigcommerce-Option-Set-IDs.csv | bigcommerceoptionsetid |
| Download Channels | Bigcommerce-Channels.csv | bigcommercechannels |
If a download comes back saying "You have not yet synced your BigCommerce … with SureDone", refresh that list first and download it again.
Multiple values in one cell
Categories and channels accept more than one ID. Both of these formats work:
- Separated by asterisks:
4*54*787 - JSON encoded:
JSON::["4","54","787"]
A single ID needs no special formatting — just 16.
To find which products are already in a given category, see BigCommerce Category Search in SureDone.
Channel override fields
These headers let you send BigCommerce something different from the value on the product. Leave the cell blank to use the SureDone value.
| Bulk header | Overrides | Notes |
bigcommercename | title | Any text. This is the product name in BigCommerce. |
bigcommercedescription | longdescription | Any text, including HTML. |
bigcommerceprice | price | Decimal, up to 2 places. |
bigcommercesaleprice | discountprice | Decimal, up to 2 places. |
bigcommercecostprice | cost | Decimal, up to 2 places. |
bigcommerceretailprice | msrp | Decimal, up to 2 places. This is BigCommerce's RRP field. |
Weight and dimensions have no BigCommerce override. They are always taken from the SureDone weight, boxlength, boxwidth and boxheight fields. Stock always comes from your SureDone stock, and the BigCommerce SKU is always the product's guid.
Other BigCommerce headers
| Bulk header | What it does | Accepted values |
bigcommercebrandid | Brand | A brand ID. Refresh and download your brands first. |
bigcommercecategories | Categories the product appears in | One or more category IDs. |
bigcommercetaxclassid | Tax class | A tax class ID. |
bigcommercechannels | Which BigCommerce storefronts the product is assigned to | One or more channel IDs. |
bigcommercebinpickingnumber | Bin picking number | Any text. |
bigcommercempn | Manufacturer part number | Any text. An empty value clears it in BigCommerce. |
bigcommercefixedcostshippingprice | Flat domestic shipping rate | A decimal. Leave blank for BigCommerce to calculate shipping from weight. |
bigcommerceisfreeshipping | Ship this item free | TRUE / FALSE (or on / off). When true, any fixed shipping price is ignored. |
bigcommerceisvisible | Visible in the storefront | TRUE / FALSE. Defaults to visible. |
bigcommerceavailability | Purchase state | available (or on), disabled (or off), preorder. Anything else is rejected with an error. |
bigcommercetype | Product type | physical or digital. Defaults to physical. Anything else is rejected with an error. |
bigcommercesearchkeywords | Storefront search keywords | Any text. |
bigcommercepagetitle, bigcommercemetakeywords, bigcommercemetadescription | SEO fields | Any text. |
bigcommercewarranty | Warranty text | Any text. |
bigcommerceinventorywarninglevel | Low stock warning level | A number. |
bigcommercerelatedproducts | Related products | Product IDs. Send -1 for automatic related products, or 0 to clear them. |
bigcommercemediareset | Replace every image on the listing with the ones in SureDone | TRUE, used together with action=relist. Use this to recover from an image sync error. |
bigcommerceskip | Skip BigCommerce for this row | TRUE to skip, FALSE or blank to send. |
media1alttext … media12alttext | Image descriptions (alt text), matched to the media field with the same number | Up to 200 characters. These are custom user fields — they are created automatically by a BigCommerce import, or you can create them yourself before use. Only the first 12 images support descriptions. |
Variations
Which variation headers you need depends on which workflow your channel uses:
bigcommercesharedoptionid— for the current Variation Fields workflow on V3 stores. See Variations Management Using Shared Options.bigcommerceoptionsetid— for the older Option Sets workflow. Enter the Option Set ID from your downloaded list. See How to List Bigcommerce Variations in Suredone.bigcommercemanageproductrules— on the Option Sets workflow, set toonto send each child's own price, weight and image as a BigCommerce Product Rule.
Before loading variations in bulk, check that every option field is listed under Settings > Products & Inventory > Variation Fields. A sample variation file is available at bigcommerce-VariantsAddSharedId.csv.
Headers SureDone manages for you
These identify the listing in BigCommerce and are maintained automatically. Any value you upload in these columns is discarded before the row is saved, so including them has no effect — leave them out of your file:
bigcommercelistingid— the BigCommerce product IDbigcommercesku— the SKU as it exists in BigCommercebigcommerceskuidandbigcommercevariantid— the variation identifiersbigcommerceproductid,bigcommerceproductrule,bigcommerceurl,bigcommerceoptions,bigcommercemedia
Leaving a column unchanged
If you want a column in your file but do not want to change its value on some rows, enter [CURRENT] in those cells. SureDone treats the cell as if the column were not in the file at all for that row, and the existing value is kept.
This works on any column, including the BigCommerce ones, and it is the safest way to handle bigcommercecategories when you are editing other fields on a mixed set of products.
[CURRENT] only makes sense on an edit or relist. On an add there is no current value to keep, so the cell is treated as empty and you will get a warning on the results file.
Things to watch for
- An empty category cell clears the product's categories in BigCommerce. If the
bigcommercecategoriescolumn is in your file but a row's cell is blank, SureDone reads that as "remove all categories" and sends an empty category list. This is specific to categories — a blank cell in most other columns means "no change". - Refresh before you reference. A brand, category, tax class or option set that has not been refreshed into SureDone will not be accepted, even if it exists in your store.
- Changes made in BigCommerce do not come back automatically. Run an import or a bulk upload to bring them into SureDone.