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.
· 2 min read
Bulk import, export & edit for Shopify
Bulk edit your Shopify store — without the fear.
Update thousands of products, customers and collections from Excel, CSV or Google Sheets — or edit them in a spreadsheet inside Shopify. See every change first. Undo any import for 30 days.
- Preview every change
- 30-day undo
- Errors in plain words
- Works with AI assistants
Free plan for up to 10 items per job. Paid plans start with a 7-day free trial, billed through Shopify.
- to undo any import
- 30 days
- until you press Apply
- 0 changes
- products, customers, collections
- 3 data types
- free trial on every paid plan
- 7 days
The problem
Bulk edits are scary.
You change one column in a 3,000-row spreadsheet, press Import, and hope. If a supplier sent prices with commas instead of dots, you find out from a customer.
Shopify's built-in CSV import shows you a sample, not every change — and there's no undo button. Bulkvane was built around those two gaps.
Preview
See every field that will change, old value beside new, before anything is written to your store.
Undo
A snapshot is saved before each import. For 30 days, one click puts everything back.
Plain errors
Problems are named by row, in words you'd use yourself — and the simple ones are fixed for you.
What a raw API error looks like
userErrors: [{
field: ["productSet", "variants", 13, "id"],
message: "Invalid id: 7.2E+12"
}] 1 row needs your attention
Row 14: ID "7.2E+12" was shortened by your spreadsheet program (scientific notation). Format the ID column as Text and export again.
Fixed for you · Row 22: Price "12,50 €" contains a currency symbol and a decimal comma — it will be saved as 12.50.
How it works
From spreadsheet to store in four steps. Five, if you change your mind.
Step 1
Upload a file or paste a link
Export from Bulkvane, edit in Excel or Google Sheets, and upload it back — or paste a Google Sheets, Drive or Dropbox link. Shopify's own CSV works too.
Step 2
Columns are matched
Bulkvane recognises its own headers, Shopify's CSV headers and common names like “SKU” or “Price”. Columns it doesn't use are listed, not silently dropped.
Step 3
Preview every change
Old value beside new, for every field on every product. Problems are listed by row in plain words. Nothing is written yet.
Step 4
Apply — or undo
Press Apply and it runs in the background. A snapshot is saved first, so for 30 days one click restores everything the import touched.
Spreadsheet editor
Edit like it's Excel — right inside Shopify.
No download, no upload. Search, filter and edit products in a grid; paste a column from Excel or Google Sheets; fill down; undo and redo. When you're done, Review changes shows every edit before it's saved.
- 50 products per page, search and filters
- Changed and invalid cells highlighted
- Saved as an import — undoable for 30 days
Bulkvane · Spreadsheet editorsample data
TitleStatusVendorPriceSKU
changed needs a fixClick a cell and type — try it.
More than products
Products, customers and collections in one file.
Export any mix of data types into one Excel file with a sheet per type — then import it back as one job per sheet, each with its own preview and undo. Metafields and stock per location are just more columns.
- Customers with tags and default address
- Smart collections with conditions, manual with product lists
- Product metafields and inventory per location
XLSXstore-backup_2026-10-01.xlsx
| Handle | Variant SKU | Variant Price | Metafield: custom.material | Inventory: Main St |
|---|---|---|---|---|
| blue-linen-shirt | LS-BLU-M | 42.00 | Linen | 18 |
| blue-linen-shirt | LS-BLU-L | 42.00 | — | 7 |
| canvas-tote | CT-NAT | 26.00 | Cotton canvas | 31 |
AI assistants In the app
Ask your AI assistant about your store's data.
Bulkvane is an MCP server. Connect the assistant you already use and ask in plain words — it picks the right Bulkvane tool and answers from your real jobs and catalog.
- Claude
- ChatGPT
- Cursor
- Claude Code
- Any MCP app
- Explain what went wrong
- “Why did my last import skip rows?” Your assistant reads the job and answers row by row.
- Catalog health report
- Missing images, empty SEO descriptions, missing or duplicate SKUs, zero prices — in one answer.
- Exports on request
- “Export all draft products from Nordhem.” A download link arrives in the chat, valid for 15 minutes.
- Counts and templates
- Count customers or products with Shopify search, or run a saved export template by name.
Read-only for your store: assistants can look things up and start exports, never change products, customers or collections. Every call is logged, and your data is never used to train AI models.
How to connect your assistantYour AI assistant + Bulkvane
sample storeWhy did my last import skip some rows?
bulkvane · list_jobs bulkvane · explain_job_errors
Import #42 (spring_prices.xlsx) updated 1,236 products and skipped 6 rows:
• 4 rows — Price “abc” isn't a number (rows 88, 91, 140, 212).
• 2 rows — no ID, Handle or Title, so the product can't be matched (rows 301, 302).
Fix those cells and import the file again; the other rows are already applied.
Try asking
Sample conversation with a demo store. Try the questions below the chat.
Features
Everything a bulk edit needs. Nothing you can't take back.
Every feature below is in the app today, on every plan — Free included.
- Every plan
One-click undo, for 30 days
Before an import touches your store, Bulkvane saves a snapshot of every product, customer or collection it will change. Changed your mind? One click puts them back — even deleted items are re-created.
- 09:14Import “spring_prices.xlsx”1,242 products updated
- 09:14Snapshot savedundo available until 26 Oct
- 09:31Undo pressed1,242 products restored
Preview every change
Every changed field, old value beside new. Nothing is written until you press Apply.
Learn moreSpreadsheet editor inside Shopify
Edit products in a grid, paste from Excel or Google Sheets, fill down, undo and redo — then review the changes before they're saved.
Learn moreProducts, customers & collections
Variants, images, SEO, metafields, stock per location, customers with addresses, smart and manual collections — in one file, one sheet per type.
Learn moreErrors in plain words
“Row 14: Price “12,50 €” contains a decimal comma — it will be saved as 12.50.” Each problem names the row and the fix, and simple ones are fixed for you.
Learn moreWorks with your AI assistant
Connect Claude, ChatGPT, Cursor or any MCP app. Ask why an import failed, run a saved export or get a catalog health report — read-only, with every call logged.
Learn moreImport from a link
Paste a Google Sheet, Google Drive, Dropbox or direct CSV/Excel link. Run the same link again next week with one click.
Learn moreFive import modes
Create and update, create only, update only, replace, or delete — so a file only does what you meant it to.
Learn moreSaved export templates
Save data types, filters, columns and format under a name. Start the same export again in two clicks.
Learn moreEmail when a job is done
Get an email when an export is ready, a preview is waiting for you, or an import finishes — pick the events and the address.
Learn moreExport from the Shopify admin
Select products in your Products list, choose More actions → Export with Bulkvane.
Learn moreIn your language
The app and its emails in English, Español, Français, Deutsch and Português (Brasil). It follows your Shopify admin language, or pick one in Settings.
Learn more
Use cases
What merchants use it for.
In the app today
Update 5,000 prices before lunch.
Export your catalogue, change the Price column in Excel, upload it back. The preview shows each old and new price, so a misplaced decimal never reaches a customer.
SKUPriceCompare at
- LS-BLU-M39.00 → 42.00— → 49.00
- CT-NAT24.00 → 26.00—
- WB-GRY18.00 → 19.5022.00 → 24.00
Integrations
Where your data already lives.
Excel and CSV files, Google Sheets, Drive and Dropbox links, the AI assistant you already use and your Shopify admin — all in the app today.
Excel & CSV files
AvailableExport to and import from .xlsx and .csv. Excel files hold one sheet per data type.
Google Sheets
AvailableImport a sheet shared as “Anyone with the link” — one tab or the whole workbook.
Google Drive
AvailableImport a CSV or Excel file from a Drive share link.
Dropbox
AvailableImport a CSV or Excel file from a Dropbox share link.
Any file link
AvailableImport from a direct CSV or Excel link, and run it again later.
Claude
AvailableConnect with the server URL and sign in with a Bulkvane token.
ChatGPT
AvailableAdd Bulkvane as an MCP connector in ChatGPT Desktop.
Cursor
AvailableOne-click install from Settings → AI assistants.
VS Code & other MCP apps
AvailableAny app that supports remote MCP servers connects with the server URL and a token.
Claude Code
AvailableOne command adds Bulkvane to your terminal assistant.
Shopify admin
Available“Export with Bulkvane” on selected products in your Products list.
Email notifications
AvailableEmails when exports are ready and imports finish or fail.
Need something else? Request an integration
Compare
The honest comparison.
Some bulk apps do more today — orders and scheduling, for example. Few let you see every change first and take an import back afterwards. Here's where Bulkvane stands, gaps included.
| Capability | Bulkvane | Typical bulk apps | Shopify CSV tool |
|---|---|---|---|
| Products, variants, metafields, stock per location | Yes | Yes | Partial |
| Customers and collections | Yes | Yes | Customers only |
| Orders | No | Yes | No |
| Preview every changed field before applying | Yes | Partial | No |
| One-click undo for 30 days, deletes included | Yes | Rare | No |
| Plain-language errors with automatic fixes | Yes | Partial | No |
| Spreadsheet editor inside the Shopify admin | Yes | Some apps | No |
| Import from Google Sheets, Drive or Dropbox links | Yes | Yes | No |
| AI assistants (Claude, ChatGPT, Cursor) via MCP | Yes | Rare | No |
| Scheduled imports / supplier sync | No | Yes | No |
| Safety features on the free plan | Yes | Partial | Free |
Based on public App Store listings and Shopify's documentation, October 2026. Spotted something out of date? Tell us.
Time saved
How much of your month goes into editing products?
Move the sliders to match your store.
Assumes 45 seconds per product edited by hand in Shopify admin, and 10 minutes per bulk job in Bulkvane (export, edit, import, check the preview).
Why Bulkvane exists
A bulk import is the most useful thing you can do to a Shopify store — and the most nerve-racking. One wrong column and thousands of products change at once.
The built-in tools can import. What they can't do is show you every change before it happens, or take it back afterwards. So we built those first.
We'll only show you features that are in the app today. If it isn't built, it isn't on this site.
Pricing
Priced by how many items you change at once.
Free plan, then from $12 a month with a 7-day free trial. Billed through Shopify; cancel anytime.
Free
Trying Bulkvane and small edits
$0forever
No trial needed
- Up to 10 items per job
- Spreadsheet editor: 5 products a month
- 5 AI assistant actions a month
- Preview, plain-language errors and 30-day undo
Starter
Most popularEditing a whole small catalog
$12per month
7-day free trial
- Up to 5,000 items per job
- Unlimited spreadsheet editing
- 500 AI assistant actions a month
- 50 job emails a month
Growth
Growing stores with larger catalogs
$39per month
7-day free trial
- Up to 50,000 items per job
- 2,500 AI assistant actions a month
- 100 job emails a month
- Everything in Starter
Pro
Large stores and agencies
$149per month
7-day free trial
- Unlimited items per job
- 10,000 AI assistant actions a month
- 250 job emails a month
- Everything in Growth
From the blog
Guides for people who live in spreadsheets.
Shopify product spreadsheet: every column explained
What each column in a Shopify product export means, which ones you can change on import, and which are read-only — with examples.
· 2 min read
How to bulk edit products in Shopify (complete guide)
The three ways to change many Shopify products at once — the admin bulk editor, CSV import and a bulk app — and when each one makes sense.
· 2 min read
FAQ
Questions merchants ask before installing.
Something else? Search the help center or ask us — we reply within 1 business day.
Is it safe to run Bulkvane on my live store?
Yes. Nothing changes until you've seen a preview of every field and pressed Apply. Before an import runs, Bulkvane saves a snapshot of each item it will touch, so you can undo the whole import for 30 days.
What exactly does Undo restore?
Undo puts back the fields an import changed — titles, prices, SKUs, tags, SEO, metafields, stock, customer details, collection conditions and products — deletes items the import created, and re-creates items it deleted (with a new ID). It doesn't roll back orders, analytics or changes made by hand after the import.
Which data can I import and export?
Products and variants (including images, SEO, product metafields and inventory per location), customers with their default address, and smart and manual collections. Export any mix of them into one Excel file with a sheet per type. Orders and variant metafields aren't supported.
Which files and sources work?
Excel (.xlsx) and CSV uploads, plus links to a Google Sheet, Google Drive or Dropbox file, or any direct CSV/Excel link (up to 20 MB). Bulkvane reads its own headers, Shopify's native CSV headers and common aliases, so most existing files import without renaming anything.
I use another bulk app. Will my files work?
Usually, yes. Shopify's own product and customer CSV headers are recognised, and Excel workbooks with sheets named Products, Customers, Collections, Smart Collections or Custom Collections are split into one import per sheet. The preview shows exactly what will change before you apply anything.
Can I edit products without a spreadsheet file?
Yes. The spreadsheet editor lets you edit products in a grid inside Shopify — paste from Excel or Google Sheets, fill down, undo and redo. When you review, the edits go through the same checks, preview and 30-day undo as a file import.
What happens if my file has mistakes?
The preview lists every problem in plain words with the row number — for example, “ID 7.2E+12 was shortened by your spreadsheet program. Format the ID column as Text and export again.” Common mistakes such as currency symbols or decimal commas are fixed for you. Rows with errors are skipped; the rest can still be applied.
How much does it cost?
Free covers up to 10 items per job. Starter is $12 a month (5,000 items per job), Growth $39 (50,000) and Pro $149 (unlimited). Paid plans start with a 7-day free trial, once per store. Billing runs through Shopify, so it appears on your Shopify invoice and you can cancel at any time.
How does the AI assistant connection work?
Bulkvane is an MCP server. Create a token under Settings → AI assistants, connect Claude, ChatGPT, Cursor, Claude Code or any app that supports MCP, and ask about your jobs, errors, templates and catalog health. The assistant can start exports but cannot change your store, and every call is logged.
Does Bulkvane use my store data to train AI?
No. Bulkvane doesn't send your data to any AI model on its own. When you connect an AI assistant, the answers you ask for are sent to that assistant, under its provider's terms. We never use your data to train models.
Is Bulkvane available in my language?
The app and its emails are available in English, Español, Français, Deutsch and Português (Brasil). Bulkvane follows your Shopify admin language automatically, or you can pick a language in Settings. Messages in import checks and results files are in English.
How fast is it?
Exports use Shopify's Bulk Operations API, so thousands of products export in minutes. Imports run in the background — close the tab and get an email when they finish.
Try Bulkvane free. Undo is always one click away.
Install from the Shopify App Store in under a minute. Free plan for up to 10 items per job; paid plans start with a 7-day free trial.
Not ready to install?
Get one practical tip a week on imports, exports and keeping a catalogue tidy.