← ImportSift

Shopify CSV: SKU or barcode turned into 1.23E+12 (scientific notation)

What's happening: Excel rewrote long SKUs and barcodes as 1.23457E+12 or dropped leading zeros, so Shopify imports the wrong values. Once the file is saved, the original digits are gone from the CSV.

How to fix it

  1. Don't fix it in the broken file: re-export from your source (supplier sheet, old store, inventory tool) to get the real digits back.
  2. Open the CSV in Excel via Data → From Text/CSV, set Variant SKU and Variant Barcode to Text before loading. Or use Google Sheets / a text editor, which keep the digits as typed.
  3. Check for leading zeros: UPC/EAN barcodes like 012345678905 must keep the 0.
  4. Save as CSV UTF-8 and check a few rows in a text editor: you should see 4006381333931, not 4.00638E+12.

Not sure which rows are affected? Drop the CSV into the free checker: it lists every problem row by row, in your browser (the file isn't uploaded).

Check my CSV free

Other import errors

ImportSift is independent and not affiliated with Shopify. · support@importsift.com