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:
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.
- 3-Tier
Item Typerows (Product/SKU/Rule) &[ADD]strings: BigCommerce stores variant price adjustments on separateRulerows 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). - Embedded widget prefixes & hex swatches inside
Product Nameon SKU rows: BigCommerce encodes option controls directly inside the SKU’sProduct Namecell—such as[RB]Size=2XL,[CS]Color=Olive:#3d4f2f. Strip[RB](Radio Button),[S](Select),[RT](Rectangle), and:#hexcodes before filling Shopify’sOption1..3columns. - 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). Product URLslashes &Product Visible? = Y / N: Strip leading/trailing slashes and subfolder prefixes from BigCommerce’sProduct URL(/category/item-slug/ → item-slug) to form Shopify’sURL handle, and mapY / NtoStatus = active / draft.
03 / HEADER DICTIONARYBigCommerce Bulk Edit CSV to canonical Shopify column reference.
| BigCommerce Bulk Edit header | Shopify CSV header | Required transformation |
|---|---|---|
Product URL | URL handle (Handle) | Take final slug segment without slashes; repeat across parent, variant, and image rows. |
Item Type (Product / SKU / Rule) | Structural row rule | Collapse Rule adjustments onto SKU rows; keep Title only on the first row of each handle. |
Product Name (on Product row) | Title | Copy to Row 1 of each handle; leave blank on subsequent variant/photo rows. |
Product Name (on SKU row) | Option1..3 name & value | Parse [RB]Size=Large;[CS]Color=Navy:#001f3f by stripping [tags] and :#hex suffixes. |
Price + Sale Price + Rule [ADD]/[FIXED] | Price + Compare-at price | Invert active Sale Price first, then apply [ADD], [SUBTRACT], or [FIXED] modifier. |
Current Stock Level + Track Inventory | Inventory quantity + Inventory tracker | Map integer stock + set shopify when by product or by options tracking is active. |
Product Image URL - 1..10 | Product image URL | Emit 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.
- 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.
- Flatten
Rulerows & strip[RB]/[CS]tags: Resolve relative price rules and clean option widget tags as shown in the interactive converter above. - 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.
- 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?
~mv2.jpg media slugs.
Squarespace CSV
Squarespace → Shopify Sanitizer
Block the Sale Price = 0.00 zero-dollar trap and clean Unlimited stock strings.
WooCommerce
WooCommerce → Shopify Merger
Invert Regular vs. Sale price cleanly and separate simple vs. variable rows.
Ready to verify your BigCommerce-to-Shopify CSV?
Audit headers, resolved SKU prices, and image rows locally in your browser—nothing uploaded.
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 ↗