The columns that need attention
Close doesn't mean identical. These BigCommerce columns break the import if left untouched:
Common Scenarios:
- Product Name vs Title: the importer only reads Title, so an untouched export produces blank product names.
- Product Code vs Variant SKU: BigCommerce's code column must be renamed or Shopify imports products with empty SKUs.
- Image File: BigCommerce sometimes exports local paths like images/1.jpg instead of full URLs, which Shopify cannot fetch.
Rename and reformat without leaving the browser
ShopTools maps BigCommerce's column names to the Shopify schema and flags relative image paths so you can fix them before the import fails. Local processing, instant download.
Features:
- Column rename map: Product Name, Product Code and Sale Price to Shopify twins
- Image path check: Flags relative paths and missing http prefixes
- Variant rows kept: Single-file structure imports without re-splitting
The rename map
- Rename Product Name to Title and keep variant rows aligned under their parent.
- Map Product Code to Variant SKU.
- Rename Sale Price to Variant Price and optionally add Compare At Price.
- Verify every Image File cell is a full https URL; prefix the CDN domain if needed.
Before and after
- Before: Product Name: Ceramic Mug, Product Code: CM-100, Sale Price: 12.00 After: Title: Ceramic Mug, Variant SKU: CM-100, Variant Price: 12.00
- Before: Image File: images/mugs/ceramic.jpg (relative path) After: Image Src: https://cdn.store.com/images/mugs/ceramic.jpg
Who benefits
- BigCommerce merchants moving platforms: Rename-and-import instead of manual rebuild
- Multi-channel sellers: Reuse BigCommerce catalog data on Shopify
Frequently Asked Questions (FAQ)
- Does BigCommerce export variants?
- Yes - in a single file with variant rows under each product. That structure maps to Shopify with minimal work.
- Why are my images not importing?
- BigCommerce exports often use relative paths (images/1.jpg). Shopify needs full https URLs. Prepend your CDN domain or use full URLs.
- What about BigCommerce categories?
- Categories export as a single column and can be mapped to Shopify's Tags column, semicolon-separated.
- Is this really free?
- Yes. The converter runs in your browser at no cost and without an account.