If you run a store with real orders flowing in, the CSV is the fastest way to touch hundreds of SKUs at once — reprice a whole collection, fix supplier titles, swap images. It's also the fastest way to blank out every description in your catalog if you treat it like a normal spreadsheet. This guide walks the workflow, the limits, and the margin math most tutorials skip. For the bigger picture of running the admin day to day, see our Shopify store operations guide.
The CSV bulk edit workflow, start to finish
The loop is always the same: export, edit, import.
Go to Products in the admin, click Export, and choose the products you want (all, current page, or a search-filtered set). Shopify emails you a .csv file. Open it in Google Sheets or Excel, make your changes, save it back as CSV, then return to Products and click Import.
Two columns do the heavy lifting on an update. For new products the import only requires a Title, but for updates both the URL handle and the Title are required — the handle is the matching key Shopify uses to find the existing product. (Source: Shopify Help Center — Importing products, accessed 2026-09-22.) Change the handle and Shopify thinks it's a brand-new product instead of an edit.
Variants each take their own row. The first row carries the product-level fields; every following row for that handle only needs the variant-specific columns plus the Option name and value. That's how a tee with five sizes and three colors becomes fifteen rows you can reprice in one pass.
The overwrite trap that wipes catalogs
Here is the single most expensive misunderstanding in Shopify CSV imports, and almost none of the ranking tutorials spell it out.
When you import with "Overwrite products with matching handles" turned on, a column that is present but blank overwrites the existing value with blank — while a column that is missing entirely leaves the existing value alone. (Source: Shopify Help Center — Using CSV files, accessed 2026-09-22.) Those two cases feel identical in a spreadsheet, and they do the opposite thing.
There's no safety net behind the mistake. Per Shopify, "Product imports started with a CSV file can't be canceled once they begin, and you can't view a history of past imports." (Source: Shopify Help Center — Importing products, accessed 2026-09-22.) Your only undo is re-importing an earlier export — which is exactly why the working rule is always keep the pre-import export file.
Worked example: the blank-column wipe
Say you want to raise prices on 300 products. You export, then "clean up" the sheet by deleting most columns — but you leave the Body (HTML) header in place with empty cells underneath.
On import with overwrite on, Shopify reads 300 blank description cells as "set the description to nothing" and wipes all 300. The fix that would have prevented it: delete the whole column (missing = untouched) instead of leaving it present and empty (blank = overwrite with blank). Recovery means re-importing your earlier export — if you kept it.
File limits and gotchas the how-to guides skip
The thin guides promise "unlimited products in one import." The real constraints matter when your catalog is large, which POD catalogs get fast.
- File size caps at 15 MB. "Your product CSV can't exceed 15 MB," so bigger catalogs have to be split across multiple files. (Source: Shopify Help Center — Using CSV files, accessed 2026-09-22.)
- Images must be public https URLs, up to 250 per product, and Shopify re-downloads them on import. (Same source, accessed 2026-09-22.)
- Variants have a daily upload ceiling at huge catalogs. "If you have 500,000 or more variants in your store, then you're subject to a daily rate limit for uploading variants by using an app or CSV file import. You can add up to 10,000 new variants in a day before the limit is reached." (Source: Shopify Help Center — Adding variants, accessed 2026-09-22.) A store with 250 designs across five products and forty size-and-color combos is already at 50,000 variants.
- Collections don't round-trip. You can assign a collection on import, but collections won't export in a product CSV. (Source: Using CSV files, accessed 2026-09-22.)
One more that bites: changing a variant's option values deletes the old variant IDs and creates new ones, which breaks anything keyed to them — feeds, apps, your POD fulfillment mappings. Edit option values only when you mean to.
Bulk editor vs CSV: when to use which
Shopify ships a spreadsheet-style bulk editor inside the admin too: check the boxes on the Products list, click Bulk edit, add columns like price or SKU, type, and save. For same-day tweaks across a handful of products it's faster than a round-trip CSV and has no overwrite trap. For larger volumes, Shopify's own guidance is to switch to CSV for products, inventory, or customers. (Source: Shopify Help Center — Bulk editing, accessed 2026-09-22.)
The rule of thumb: in-admin bulk editor for quick, visible edits you can eyeball; CSV when the change spans hundreds of rows or needs spreadsheet formulas. If customer records are what you're after instead of products, the mechanics differ slightly — we cover that in bulk editing Shopify customer information.
The profit question a CSV reprice can't answer
Here's the gap no CSV workflow closes. A bulk price change is only as smart as the margin math behind it, and the CSV knows your price — not your cost, your ad spend, or your fees.
Worked example: repricing without guessing
Say your store does 340 orders a month at a $31 average order value, with $2,800 a month in Meta spend. You sell a tee at $28. Your Printify cost is $11.50. Payment processing runs about 2.9% plus $0.30, so on a $28 order that's (0.029 × 28) + 0.30 = $1.11. Your blended ad cost per order is $2,800 ÷ 340 = $8.24.
Per-order profit today: $28 − $11.50 − $1.11 − $8.24 = $7.15.
Now you bulk-raise that tee to $31 in the CSV. Cost holds at $11.50, the fee becomes (0.029 × 31) + 0.30 = $1.20, ad cost stays $8.24. New profit: $31 − $11.50 − $1.20 − $8.24 = $10.06 — a $2.91 gain per order, roughly $990 a month across 340 orders. That's the calculation worth doing before you push the import, not after.
And it matters which way fees cut. When you refund an order, the original payment-processing fee isn't returned to you. (Source: Shopify Help Center — Shopify Payments refunds, accessed 2026-09-22.) On a POD order the already-spent production cost is gone too, so a thin-margin SKU priced wrong doesn't just earn little — it loses money on every return.
Where Victor fits
PodVector AI puts an AI employee named Victor on exactly this problem. Victor sees every order, every ad dollar, and every supplier cost together, so he computes the true per-order profit on each product — not just revenue. Victor reprices the thin-margin SKUs directly in Shopify, changes prices and discounts, and pulls your product costs from Printify, Printful, and Gelato, so the cost side of that margin math is known before the first sale.
He doesn't stop at the catalog. Victor pauses the losing Meta ad set, adjusts Google Ads bids, builds and sends your Klaviyo flows, and delivers the profit report to your Google Drive. Victor is not a dashboard you read — he does the work a CSV reprice can only start. When you're ready to show those new prices off, he can also show a discount on the product page to protect conversion while margin goes up. You can put Victor to work on your store today.
FAQs
Can I undo a Shopify CSV import if I make a mistake?
No. Shopify can't cancel an import once it begins, and there's no import history to roll back to. (Source: Shopify Help Center — Importing products, accessed 2026-09-22.) Your only recovery is re-importing an earlier export, so save the pre-import file every single time before you touch the overwrite setting.
Why did my product descriptions disappear after a CSV import?
Almost certainly the blank-column overwrite. With overwrite enabled, a column that's present but empty replaces the existing value with blank, while a column that's missing entirely leaves it untouched. (Source: Shopify Help Center — Using CSV files, accessed 2026-09-22.) Delete columns you don't want to change rather than clearing their cells.
How big can my Shopify product CSV file be?
The product CSV can't exceed 15 MB. (Source: Shopify Help Center — Using CSV files, accessed 2026-09-22.) Split larger catalogs into multiple files and import them one at a time.
Should I use the bulk editor or a CSV?
Use the in-admin bulk editor for quick edits across a handful of products you can eyeball, and switch to CSV when the change spans hundreds of rows or needs spreadsheet formulas — which is Shopify's own guidance for larger volumes. (Source: Shopify Help Center — Bulk editing, accessed 2026-09-22.)
How do I match CSV rows to existing products?
By the URL handle. For updates, both the handle and the Title are required columns, and the handle is the key Shopify uses to find the matching product. (Source: Shopify Help Center — Importing products, accessed 2026-09-22.) Don't change the handle unless you intend to create a new product.
Does a CSV reprice tell me if the new price is actually profitable?
No — the CSV knows your price, not your cost, fees, or ad spend. You have to run the per-order margin math separately, or let Victor compute true per-order profit across Shopify, your ad accounts, and your POD suppliers and reprice the thin-margin SKUs for you.
What if my store sells internationally?
CSV price columns are tied to your base currency, and multi-market pricing adds its own rules on top. We break those down in Shopify international store management features.