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.

No file handy? or download the sample to look at it first.

The products in the sample are invented. It is converted on this device, the same way your own file would be.

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.

Questions

How do I move my BigCommerce products to Shopify or WooCommerce?
Export your products from BigCommerce as a CSV with the steps on this page, drop the file into the converter and pick Shopify or WooCommerce. The file is converted in your browser, and you download a CSV in that importer's layout. Import a few products first and check them before importing the rest.
Why are my BigCommerce categories missing?
The BigCommerce export lists categories by ID number, not by name, so there is nothing to turn into Shopify collections. Create your collections in Shopify after import.
Why are my BigCommerce categories and brands missing?
The BigCommerce export lists categories and brands by ID number, not by name, so they cannot become WooCommerce categories or brands. Create them in WooCommerce after import.
Does it move customers, orders or reviews?
No. 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.
Is my file uploaded anywhere?
No. The page reads the file with your browser and converts it there. The only thing the site records is an anonymous count: which converter was used, a rough row count, and whether it worked. The privacy page lists every field.