Quick Rule Summary · Updated November 2026

BigCommerce Bulk Edit CSVs split products across Item Type = Product, SKU, and Rule rows: before importing into Shopify, compute [ADD] / [FIXED] rules into plain numeric variant prices, strip [RB] / [S] / [CS] widget tags and hex swatches from option strings, and unpack Product Image URL - 1..10 onto shared-handle rows.

01 / INTERACTIVE BIGCOMMERCE-TO-SHOPIFY CONVERTERResolve [ADD]/[FIXED] price rules, clean [RB]/[CS] options & unpack images.

Click any BigCommerce Bulk Edit scenario below—or open the live field drawer to test your own SKU rules—and download a clean UTF-8 Shopify file:

Source Rows Inside BigCommerce Bulk Edit CSV
Paste or edit your own BigCommerce fields (live converter)

02 / THE 4 BIGCOMMERCE CSV TRAPSWhy BigCommerce Bulk Edit files break 1-to-1 Shopify header mapping.

  1. 3-Tier Item Type rows (Product / SKU / Rule) & [ADD] strings: BigCommerce stores variant price adjustments on separate Rule rows using tags like [ADD]15.00, [SUBTRACT]5.00, or [FIXED]345.00. You must fold each rule onto its matching SKU row as a plain decimal figure (see Shopify price format check).
  2. Embedded widget prefixes & hex swatches inside Product Name on SKU rows: BigCommerce encodes option controls directly inside the SKU’s Product Name cell—such as [RB]Size=2XL,[CS]Color=Olive:#3d4f2f. Strip [RB] (Radio Button), [S] (Select), [RT] (Rectangle), and :#hex codes before filling Shopify’s Option1..3 columns.
  3. Numbered horizontal image columns (Product Image URL - 1, 2, …): Just like Etsy listing exports, BigCommerce spreads gallery URLs across wide numbered columns. Transpose every extra photo onto a shared-handle vertical continuation row (see multi-image continuation spec).
  4. Product URL slashes & Product Visible? = Y / N: Strip leading/trailing slashes and subfolder prefixes from BigCommerce’s Product URL (/category/item-slug/ → item-slug) to form Shopify’s URL handle, and map Y / N to Status = active / draft.

03 / HEADER DICTIONARYBigCommerce Bulk Edit CSV to canonical Shopify column reference.

Mapping BigCommerce Bulk Edit export columns to canonical Shopify product CSV headers
BigCommerce Bulk Edit headerShopify CSV headerRequired transformation
Product URLURL handle (Handle)Take final slug segment without slashes; repeat across parent, variant, and image rows.
Item Type (Product / SKU / Rule)Structural row ruleCollapse Rule adjustments onto SKU rows; keep Title only on the first row of each handle.
Product Name (on Product row)TitleCopy to Row 1 of each handle; leave blank on subsequent variant/photo rows.
Product Name (on SKU row)Option1..3 name & valueParse [RB]Size=Large;[CS]Color=Navy:#001f3f by stripping [tags] and :#hex suffixes.
Price + Sale Price + Rule [ADD]/[FIXED]Price + Compare-at priceInvert active Sale Price first, then apply [ADD], [SUBTRACT], or [FIXED] modifier.
Current Stock Level + Track InventoryInventory quantity + Inventory trackerMap integer stock + set shopify when by product or by options tracking is active.
Product Image URL - 1..10Product image URLEmit Image 1 on Row 1 and Images 2..10 on shared-handle continuation rows.
Product Visible? (Y / N)Status (active / draft)Convert Y to active and N to draft.

04 / SAFE MIGRATION STEPSMigrate BigCommerce products to Shopify in 4 clean steps.

  1. Export using BigCommerce’s Bulk Edit template: In BigCommerce Control Panel, open Products → Export, choose the Bulk Edit template (which includes full image URLs and SKU/Rule rows), and keep your BigCommerce CDN online until Shopify finishes downloading all images.
  2. Flatten Rule rows & strip [RB] / [CS] tags: Resolve relative price rules and clean option widget tags as shown in the interactive converter above.
  3. Preflight your UTF-8 file in Row & Record: Load the converted CSV into our local browser workspace to catch blank variant prices, duplicate handles, or malformed image URLs before touching Shopify Admin.
  4. Set up 301 URL redirects for BigCommerce paths: Because BigCommerce URLs vary (e.g., /product-slug/ vs. Shopify’s /products/product-slug), import URL redirects alongside a 3-product pilot batch first.

Common questions.

Which BigCommerce export template should I choose when moving to Shopify?

Always select the Bulk Edit CSV template under Products → Export in BigCommerce. Unlike the Default template, Bulk Edit includes full Product Image URL columns, SKU rows, and Rule price modifiers in one file.

How do I convert BigCommerce [ADD] and [FIXED] price rules for Shopify?

Shopify Product CSVs require an explicit decimal number on every variant row rather than relative rule formulas. Match each Item Type = Rule row to its corresponding SKU row, add [ADD] deltas onto the parent price (or replace with [FIXED]), and delete the standalone Rule rows.

Why do my imported Shopify options show [RB] or [CS] and hex codes?

BigCommerce embeds storefront control types ([RB] for radio buttons, [S] for dropdowns, [CS] for color swatches with :#hex values) directly inside the SKU option string. Strip bracketed tags and colon-delimited swatch suffixes before mapping to Option1..3 value.

How do I migrate BigCommerce’s Product Image URL - 1, 2, 3 columns into Shopify?

Place Product Image URL - 1 on the primary product row with Image position = 1, and transpose Product Image URL - 2, 3, and higher onto additional vertical rows sharing the same URL handle with Title and Price left blank.

05 / PLATFORM MIGRATION HUBConverting from another storefront to Shopify?

Ready to verify your BigCommerce-to-Shopify CSV?

Audit headers, resolved SKU prices, and image rows locally in your browser—nothing uploaded.

Open CSV Preflight Workspace ↗

Verified November 2026 against BigCommerce Bulk Edit CSV v3/v2 export columns and Shopify’s multi-row Product CSV specification.

Shopify store migration documentationShopify product CSV column referenceRow & Record Chrome Extension ↗