7 costly Shopify import mistakes (and how to undo them)
Scientific-notation IDs, decimal commas, missing handles: the seven import mistakes we see most, how to spot them before they go live, and how to recover.

Why imports go wrong
Most broken imports aren't caused by a big mistake. They're caused by a spreadsheet program quietly “helping”: reformatting an ID, swapping a dot for a comma, trimming a leading zero. Here are the seven we see most often, and what to do about each.
Accents that turn into “é” after an import are a different problem: the file wasn't saved as UTF-8. Here is how to fix Shopify CSV encoding errors in Excel, Google Sheets and Numbers.
1. IDs turned into scientific notation
Shopify product and variant IDs are long numbers. Open an export in Excel and 7234567890123 becomes 7.23457E+12. Save the file and the real ID is gone, so the import can't find the product.
Bulkvane checks for this and stops the row with a clear message: “ID 7.2E+12 was shortened by your spreadsheet program (scientific notation). Format the ID column as Text and export again.”
2. Decimal commas and currency symbols
A supplier in Germany sends “19,50 €”. Shopify expects 19.50. Depending on the tool, that becomes 1950, an error, or nothing at all.
Bulkvane reads decimal commas, thousands separators and currency symbols, converts them, and tells you it did: “Price “12,50 €” contains a currency symbol and a decimal comma — it will be saved as 12.50.”
3. Handles with spaces or capitals
Handles are the product's URL slug. They can only use lowercase letters, numbers and dashes. “Blue Linen Shirt” isn't a valid handle; “blue-linen-shirt” is. A bad handle can create a duplicate product instead of updating the existing one.
4. Rows with no ID, handle or title
Every row needs something that says which product it belongs to. Variant rows copied from another sheet often lose that link. Keep the Handle column filled on every variant row, even if it repeats.
6. Status values that don't exist
Product status must be Active, Draft or Archived. “Published”, “Live” or “hidden” won't work. Bulkvane accepts different capitalisation and tells you when a value isn't recognised.
7. No way back
The costliest mistake is the one you can't reverse. Shopify's CSV import has no undo, so a wrong file means fixing products one by one or restoring from an old export, if you have one.
- Export your catalogue before any big change and keep the file.
- Use a tool that shows every change before applying it.
- Prefer imports that can be undone. In Bulkvane, each import saves a snapshot first, and one click restores every product it changed for 30 days.
Frequently asked questions
Why did my Shopify import create duplicate products?
Usually because the handle didn't match. A handle with spaces, capitals or a typo doesn't match the existing product, so a new one is created. Keep the exact handle from an export, or keep the ID column.
Why do my product IDs look like 7.23457E+12?
Excel shows long numbers in scientific notation and rounds them when you save. Format the ID and Variant ID columns as Text before you edit. If the file was already saved, export again.
What status values does Shopify accept for products?
Active, Draft and Archived. Words like Published, Live or hidden aren't recognised. Bulkvane accepts any capitalisation and tells you when a value isn't one of the three.
Can I undo a Shopify CSV import?
Not with Shopify's built-in importer. Bulkvane saves a snapshot before each import, and Undo restores every product it changed for 30 days.
Why does “Café” show up as “Café” after an import?
The CSV wasn't saved as UTF-8, the encoding Shopify reads. In Excel, use File → Save As → CSV UTF-8 (Comma delimited). Google Sheets downloads are always UTF-8. Or import an Excel (.xlsx) file into Bulkvane, which doesn't have this problem.
Related guides
How to bulk edit products in Shopify (2026 guide, 3 methods)
Bulk edit Shopify product data three ways (the admin bulk editor, a CSV import or an app), with steps for prices, tags, SEO, metafields, variants and stock.
· 14 min read
Import supplier CSV files into Shopify over FTP or SFTP
A practical guide to importing supplier CSV files via FTP, FTPS or SFTP into Shopify: SKUs, inventory locations, preview and safe updates.
· 2 min read
How to schedule Shopify product exports daily or weekly
Set up recurring Shopify CSV or Excel exports with saved templates, daily or weekly schedules, job history and completion notifications.
· 2 min read
How to bulk edit Shopify productsFree CSV templatesBrowse the help center
Preview every change.Undo any import for 30 days.
Install free