BigCommerce Product CSV Import Errors

How to fix it

Try these in order — the most common fix is first.

1. 1. Read the error

   Copy steps
   1. After the import click More information in the import summary
   2. Note the CSV row and message
   3. Fix those rows and re-import
   Did this fix it? Yes No

2. 2. Fix common errors

   Copy steps
   1. For new products leave Product ID blank
   2. Put images in the product_images/import folder in WebDAV or use public URLs
   3. Write custom fields as name=value separated by semicolons
   4. Use /product-url/ format for URLs
   Did this fix it? Yes No

3. 3. Fix scientific notation SKUs

   Copy steps
   1. Excel: Data > From Text/CSV > Import > Transform Data, then deselect Changed Type in Query Settings
   2. Google Sheets: File > Import and uncheck Convert text to numbers, dates, and formulas
   Did this fix it? Yes No

4. 4. Unstick a stalled import

   Copy steps
   1. Clear browser cache or use an incognito window
   2. Split the file into smaller parts
   3. Delete unused columns and keep under 1,000 images per file
   4. Re-export with the Bulk Edit template
   Did this fix it? Yes No

Symptoms

The import fails, stalls at a percentage, or reports errors on specific rows.

Why it happens

• Product ID does not match an existing product
• Image missing in WebDAV or URL not public
• Custom fields not in name=value format
• Excel converted SKUs or UPCs to scientific notation
• File not ending in .csv
• Very large files or many images

This guide also covers

• bigcommerce product import error
• bigcommerce csv import not working
• bigcommerce import stuck

The same problem in other apps

All not loading, error messages & connection guides →

• WooCommerce Checkout Page Loading Forever (WooCommerce)
• Squarespace Domain Not Connecting (Squarespace)
• Wix Site Not Loading or Can't Be Reached (Wix)

Other BigCommerce errors

• BigCommerce Checkout Not Working
• BigCommerce Payment Gateway Error
• BigCommerce Forced Plan Upgrade (Sales Limit)
• BigCommerce Open Payment Provider Fee
• BigCommerce SSL Certificate Not Working
• BigCommerce Custom Domain Not Working
• Why Is My BigCommerce Store So Slow
• BigCommerce Out of Delivery Zone Error at Checkout