BigCommerce product export: convert it for another store

BigCommerce exports products as a CSV whose first column is Item: a Product row, then one Variant row per option combination and one Image row per picture.

Convert a BigCommerce export

BigCommerce to Shopify

Your BigCommerce products CSV.

Your file stays on this device

It is read and converted by this page, inside your browser. Nothing from the file is uploaded, and the tool keeps working offline once the page has loaded.

Loading the converter...

Where is it going?

How to export from BigCommerce

  1. In your BigCommerce control panel, open Products, then Export.
  2. Export all products as CSV and download the file. Menu names can differ a little between BigCommerce versions; the file's first column must be called Item.
  3. An older "Bulk Edit" export (first column Item Type) is not read by this converter. Export again with the current export.
  4. Note your store's weight unit (in the store settings). The file does not include it, so this page asks you before you download.

What to know about BigCommerce files

  • Categories and brands are exported as ID numbers, not names, so they cannot be carried over. Recreate them in the new store. Each file with them says so.
  • Weights have no unit in the file, so the page asks for your BigCommerce weight unit before you can download.
  • A variant with a blank price takes the product price, as BigCommerce documents. That it also takes the product's sale price is our reading, and each file with such variants says so. A sale price lower than the price becomes the compare-at price; with no sale, a higher retail price (MSRP) is used as the compare-at price. Where BigCommerce does not say which price shoppers saw, the converter tells you which one it wrote.
  • When BigCommerce tracks stock for the whole product rather than per variant, the stock cannot be split, so tracking is turned off for those variants with a note.
  • Not carried over, and listed when present: custom fields, videos, download files of digital products, dimensions, shipping settings, featured flag and search keywords. Modifier options and price rules are not in the export at all, so they do not move.
  • Swatch colours are carried over by name; the colour codes are dropped.
  • Is Visible must be TRUE or FALSE. A product with a blank or unclear value is kept as a draft, with a note, so nothing hidden is published by mistake.
  • BigCommerce's Variant and Image rows belong to the Product row above them. Do not sort the file in a spreadsheet before converting; the converter warns when the order looks changed.
  • Built from BigCommerce's published sample export and field documentation. It was not tested by importing into a live store.

Only products move. Customers, orders, reviews, gift card balances, blog posts, pages and URL redirects are not in a product export, so CatalogHop does not convert them.