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.

The three methods compared
Each method suits a different size of job. Here's how they compare on the things that matter before you change a live store:
| Admin bulk editor | Shopify CSV import | Bulkvane | |
|---|---|---|---|
| Best for | Quick edits to a few dozen products | Adding or overwriting many products now and then | Regular edits you want to check first and be able to undo |
| How you edit | A grid in Shopify admin | A CSV file in a spreadsheet program | Excel, CSV or Google Sheets, or a grid inside Shopify admin |
| Size of job | Shopify suggests a CSV for larger numbers of items | Files up to 15 MB | Per job: 10 products on Free up to 100,000 on Pro |
| Fields | The columns you add in the editor | Every column of Shopify's product CSV | Product fields, variants, SEO, metafields, stock per location and 17 other data types |
| Preview before saving | You see the grid; nothing else | A summary of the import | Every changed field, old value beside new |
| Undo | No | No, and it can't be cancelled once it starts | One click, for 30 days |
| Price | Free | Free | Free for 10 of each type per job; from $12 every 30 days |
Method 1: Shopify's admin bulk editor
The bulk editor is built into Shopify admin and costs nothing. It shows the products you select as a grid, one row per product or variant, and you type the new values into the cells.
- In Shopify admin, go to Products.
- Filter the list if you need to (by vendor, tag, product type or status) and tick the checkboxes of the products you want to change. Tick the box at the top to select every product on the page.
- Click Bulk edit. The products open in a grid.
- Click Columns and add the fields you want to change, such as Price, Compare-at price, Tags or Vendor.
- Click a cell and type. To copy one value to many rows, drag the cell's fill handle up or down. Shift-click selects a range of cells; Command-click (Mac) or Alt-click (PC) picks separate cells.
- Click Save. If Shopify says “Update the invalid values, then save again”, find the highlighted cells and save again. A missing SKU or a metafield value of the wrong type is a common cause.
- Pros: free, built in, no files, and quick for small jobs.
- Cons: slow on large selections. Shopify itself suggests a CSV for larger numbers of items. There are no formulas, so a 10% price rise means typing every price. Once you save, there's no undo button.
Method 2: Export and import a CSV
For hundreds or thousands of products, or changes you can work out with a formula, a spreadsheet is faster. Shopify exports your products as a CSV file, you change it in Excel, Numbers or Google Sheets, and import it again.
- On the Products page, click Export, choose All products and CSV for Excel, Numbers or other spreadsheet programs, and download the file. Keep an untouched copy: it's your backup.
- Open the file and change the columns you need. Keep the Handle column on every row. It's how Shopify knows which product a row belongs to.
- Save the file as CSV with UTF-8 encoding.
- Back on the Products page, click Import, add the file and tick “Overwrite products with matching handles” so existing products are updated instead of skipped.
- Click Upload and continue, review the summary, then click Import products.
Column by column, the product CSV columns explained guide covers what each one does, and the free product CSV template shows a finished example.
- Pros: free, handles thousands of rows, and spreadsheet formulas do the work for you.
- Cons: CSV only, up to 15 MB per file. You don't see a field-by-field preview, the import can't be cancelled once it begins, it can't be undone, and Shopify keeps no history of past imports.
Why CSV imports break stores
Most bad imports aren't caused by a big mistake but by a small one repeated across every row. These are the traps Shopify's own help center warns about:
- Blank cells overwrite. With “Overwrite products with matching handles” on, an empty cell in a column you included replaces the product's value with nothing. Leave out the columns you aren't changing.
- Variant IDs get replaced. Changing an Option1, Option2 or Option3 value deletes the variant and creates a new one with a new ID, which can break apps and links that pointed at the old variant.
- Missing related columns delete data. A SKU column without the Option1 columns, for example, can remove a variant option.
- Sorting moves images. Sorting the rows in a spreadsheet can separate image rows from their product, so images are lost.
- Spreadsheets change values. Excel turns long IDs into numbers like 7.2E+12 and may save curly quotes or a non-UTF-8 file, which breaks the import. See 7 costly import mistakes.
- There's no way back. If a file was wrong, you fix products one by one or re-import your backup, if you made one.
Method 3: Use a bulk editing app
Bulk apps keep the speed of a spreadsheet and add the checks Shopify's tools don't have. Here's the flow in Bulkvane:
- Install Bulkvane from the Shopify App Store and open Export. Choose Products, filter by status, vendor, product type, tag or created date, pick the columns you need and choose Excel. It keeps long IDs and barcodes exact.
- Edit the file in Excel or Google Sheets. Change only the columns you mean to change and keep ID and Variant ID, so every edit lands on the right product and variant.
- Open Import, add the file (or paste a Google Sheets, Google Drive or Dropbox link) and choose a mode. Update only changes existing products and never creates new ones.
- Click Check file. Every field that will change is listed, old value beside new, and problems are explained by row in plain words. Common ones, such as a decimal comma or a currency symbol in a price, are fixed for you.
- Click Apply. Bulkvane saves a snapshot of each product first, so if anything looks wrong afterwards, open the job and click Undo this import. You have 30 days.



Rather not handle files? Bulkvane's spreadsheet editor shows your products and variants in a grid inside Shopify admin, 50 products a page. Paste a column from Excel, fill down, undo and redo, then click Review changes: your edits go through the same check, preview and 30-day undo as a file.
- Pros: Excel and Google Sheets as well as CSV, a field-by-field preview with a risk check, plain-language errors, one-click undo, price rules and sales that end by themselves, and data types beyond products: customers, collections, orders, discounts, pages, metaobjects and more.
- Cons: the free plan covers 10 items of each type per job; bigger jobs need a paid plan, from $12 every 30 days. Price rules, sales and scheduled jobs need Starter or higher. Bulkvane doesn't create past orders. FTP, FTPS and SFTP file sources are available on Growth and Pro.
Other bulk apps worth a look
We make Bulkvane, so here's a short, fair view of the others. Each one does something Bulkvane doesn't:
- Matrixify imports and exports almost every kind of Shopify data, runs jobs on a schedule and is the usual choice for migrating a whole store. It has a dry run that simulates an import; its listing doesn't mention a one-click undo. From $20 every 30 days. See Bulkvane vs Matrixify.
- Hextom: Bulk Product Edit edits products in bulk or from a CSV, can revert edits and keeps backups for 30 to 180 days, and runs scheduled tasks. Its Basic plan is $9.99 for 500 products per task. See Bulkvane vs Hextom.
- Ablestar Bulk Product Editor is built around rules: filter products, then change prices, tags, text or metafields, with one-click undo and scheduled or recurring edits on paid plans, from $30. See Bulkvane vs Ablestar.
For the full picture, including Altera and Setary, see the best Shopify bulk edit apps, with each app's price, free plan, strengths and weak spots.
Common bulk edits, step by step
Whichever method you choose, these are the columns to change. The steps below use a Bulkvane file; fields marked “editor too” can also be changed in its spreadsheet editor.
Prices and compare-at prices
- Export products with the Variant Price and Variant Compare At Price columns (editor too).
- For a percentage change, put =ROUND(X2*1.1, 2) in a spare column (where X2 is the first price) to raise prices by 10%, or *0.9 to cut them by 10%. Fill it down, then paste it back over the price column as values.
- For a sale, put the original price in Variant Compare At Price and the sale price in Variant Price. Shopify only shows a sale when the compare-at price is higher, and Bulkvane warns you when it isn't.
- Import with Update only, check the preview and apply. To end the sale, undo that import.
No spreadsheet needed for the common cases: a Bulkvane price rule changes prices by a percentage or to cost × margin, rounded to .99, and a sale campaign drops prices at a start hour and restores them at the end, by itself.
More in how to bulk edit prices in Shopify.
SEO titles and meta descriptions
Change SEO Title and SEO Description (editor too). Spreadsheet formulas help here: =LEFT(B2, 60) trims a title, and =B2&" | Your Store" adds your store name. Bulkvane warns when an SEO title is longer than the roughly 70 characters search engines show, or a description longer than about 320. See bulk editing SEO titles and descriptions.
Metafields
Each metafield is a column named “Metafield: namespace.key [type]”, or Shopify's style, “Material (product.metafields.custom.material)”. Variant metafields use “Variant Metafield: namespace.key [type]”. Every value is checked against its type before it's saved, and lists can be written as “Wash cold; Line dry”. See how to bulk edit Shopify metafields.
Variants, SKUs and barcodes
A product file has one row per variant. Change Variant SKU, Variant Barcode and Variant Price on each row (editor too). To add a size or colour to an existing product, add a row with the product's Handle and the new option values. Undo removes it again. Rows are matched to variants by Variant ID, then SKU, then option values. See how to bulk edit variants.
Inventory by location
Add one column per location, named “Inventory: ” and the location's name, with each variant's available quantity. Empty cells never change stock, and if stock changes between the preview and the import (after an order, say), Bulkvane skips that variant rather than overwrite the newer number. See bulk updating inventory by location.
Images
Put public image links that start with https:// in Image Src, separated by commas. New images are added and existing ones are kept. Links that aren't web addresses are skipped with a warning before anything changes. See importing products with images.
Vendor, product type and status
Vendor, Type and Status are product-level columns on each product's first row (editor too). Status must be Active, Draft or Archived; Bulkvane accepts any capitalisation and tells you when a value isn't one of those. Archive products you might want again rather than deleting them. If you do need to delete, bulk delete with undo explains the safe way.
5 rules for safe bulk editing
- Export a backup first, and keep it unedited, even if your tool has an undo.
- Test on five products. Filter the export down to a handful, run the whole edit, and check them on your storefront before you do the rest.
- Include only the columns you're changing. Fewer columns means fewer ways for a blank cell to overwrite something.
- Keep the IDs. ID and Variant ID make sure each row lands on the right product, and Excel's Text format stops them being rounded.
- Read the preview before you apply. Look for changes you didn't expect (a column shifted by one, a formula pasted as text) and stop if anything looks off.
Common errors and how to fix them
| Message | What it means | Fix |
|---|---|---|
| Invalid CSV header: missing headers | Shopify's importer didn't find the header row it expects | Use the header row from a Shopify export; check for spaces at the end of the first line |
| Handle already exists | Two different products in the file share a handle | Give each product its own handle; only a product's own variant rows repeat it |
| Illegal quoting on line | A stray or curly quote, or a file that isn't UTF-8 | Replace curly quotes with straight ones and save as CSV UTF-8 |
| Options are not unique | Two variants of a product have the same option values | Make each variant's combination of options different |
| Image failed to download | The image link isn't public or doesn't point at an image | Use a direct https:// link that opens the image in a private browser window |
| ID shown as 7.2E+12 | Excel shortened a long ID | Format the ID columns as Text and export again |
Every message Bulkvane shows is listed in Errors A–Z, and Shopify's own import errors in Shopify CSV import errors. Still stuck? See Shopify CSV import not working?
Which method should you use?
- Under about 50 products and one or two fields: the admin bulk editor.
- Hundreds or thousands of products, once in a while: a CSV import, after exporting a backup.
- Regular changes, supplier files, Excel workbooks, or anything you'd hate to get wrong: a bulk app with a preview and undo.
- A sale with a start and an end, or a supplier sheet imported every morning: a bulk app with scheduled sales and jobs, such as Bulkvane.
- A whole-store migration that requires historical orders or payouts: an app built for that, such as Matrixify. Bulkvane supports FTP, FTPS and SFTP file sources on Growth and Pro.
Comparing apps for importing and exporting rather than editing? See the best Shopify import and export apps.
Frequently asked questions
Can you bulk edit products in Shopify without an app?
Yes. Select products on the Products page and click Bulk edit to change fields in a grid, or export a product CSV, edit it in a spreadsheet and import it with “Overwrite products with matching handles” ticked. Neither has an undo, so export a backup first.
How many products can I bulk edit at once in Shopify?
Shopify doesn't publish a fixed number for the admin bulk editor, but large selections get slow and Shopify suggests a CSV for larger numbers of items. A product CSV can be up to 15 MB. In Bulkvane, one job can change 10 products on Free, 5,000 on Starter, 50,000 on Growth and 100,000 on Pro.
Can I undo a bulk edit in Shopify?
Not with Shopify's own tools: saved bulk edits and CSV imports can't be undone, and a CSV import can't be cancelled once it starts. Bulkvane saves a snapshot before every import and can undo it in one click for 30 days, including re-creating deleted products.
How do I bulk edit prices by a percentage?
Export the prices to a spreadsheet, use a formula such as =ROUND(X2*1.1, 2) for a 10% rise, paste the results back over the price column as values, and import the file. Bulkvane shows every price old beside new before you apply it.
Can I bulk edit metafields in Shopify?
Yes. Shopify's bulk editor can show metafield columns, and a CSV can carry them. In Bulkvane, each product or variant metafield is a spreadsheet column, and every value is checked against its type before it's saved.
Can I bulk edit products in Shopify with Excel?
Shopify's importer only takes CSV, so you have to save your Excel file as CSV first, and long IDs can be rounded on the way. Bulkvane imports Excel (.xlsx) files directly, and Google Sheets from a link.
Why did my Shopify CSV import delete data?
With “Overwrite products with matching handles” on, an empty cell in a column you included replaces the product's value with nothing, and changing option values replaces variants with new ones. Include only the columns you're changing, and keep a backup.
What's the safest way to bulk edit a live store?
Export a backup, test the change on five products, include only the columns you're changing, and use a tool that shows every change before it's saved and can undo it afterwards.
Related guides
How to bulk edit prices in Shopify (and put them back)
Four ways to change many Shopify prices at once, how to schedule a sale with compare-at prices, and how to undo a price change that went wrong.
· 4 min read
How to bulk edit Shopify metafields with a spreadsheet
Bulk edit Shopify product and variant metafields with a spreadsheet: column names, the value format for every type, definitions, metaobjects and fixes.
· 6 min read
How to bulk update Shopify inventory by location
Update stock for every variant at every location from one spreadsheet, with a before/after preview, a check for stock that changed, and undo.
· 2 min read
How to bulk edit Shopify variants: prices, SKUs, options and stock
Change prices, SKUs, barcodes, stock and metafields for thousands of Shopify variants at once, add new sizes or colours, and avoid replacing variant IDs.
· 4 min read
How to bulk edit SEO titles and meta descriptions in Shopify
Write or fix SEO titles and meta descriptions for hundreds of Shopify products at once, with spreadsheet formulas, length checks, a preview and undo.
· 4 min read
Best Shopify bulk edit apps in 2026 (honest comparison)
Bulkvane, Matrixify, Hextom, Ablestar, Altera, Setary and Shopify's own tools compared on price, free plan, undo, Excel and scheduling, with sources.
· 7 min read
Preview every change.Undo any import for 30 days.
Install free
