Skip to content

NewSchedule your Black Friday sale: prices drop at the start and go back by themselves. See how

Bulkvane

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 Bulkvane teamPublished Last updated 14 min read
Bulkvane's spreadsheet editor in Shopify admin, with products, variants, prices, tags and SKUs in an editable grid.

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 editorShopify CSV importBulkvane
Best forQuick edits to a few dozen productsAdding or overwriting many products now and thenRegular edits you want to check first and be able to undo
How you editA grid in Shopify adminA CSV file in a spreadsheet programExcel, CSV or Google Sheets, or a grid inside Shopify admin
Size of jobShopify suggests a CSV for larger numbers of itemsFiles up to 15 MBPer job: 10 products on Free up to 100,000 on Pro
FieldsThe columns you add in the editorEvery column of Shopify's product CSVProduct fields, variants, SEO, metafields, stock per location and 17 other data types
Preview before savingYou see the grid; nothing elseA summary of the importEvery changed field, old value beside new
UndoNoNo, and it can't be cancelled once it startsOne click, for 30 days
PriceFreeFreeFree for 10 of each type per job; from $12 every 30 days
Shopify facts from its help center pages on bulk editing and importing products, checked October 2026.

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.

  1. In Shopify admin, go to Products.
  2. 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.
  3. Click Bulk edit. The products open in a grid.
  4. Click Columns and add the fields you want to change, such as Price, Compare-at price, Tags or Vendor.
  5. 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.
  6. 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.

  1. 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.
  2. 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.
  3. Save the file as CSV with UTF-8 encoding.
  4. 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.
  5. 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:

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
Bulkvane's Export page: Products selected with 24 of 25 columns, an Add data menu offering Customers and Collections, and Excel chosen as the format so IDs and barcodes stay exact.
Step 1: choose the data, columns and format.
Bulkvane's import check listing values it fixed automatically, such as product statuses, and a warning that row 18's compare-at price isn't higher than its price.
Step 4: problems by row, in plain words, before anything is saved.
A finished Bulkvane import showing 2 products updated, each title change with its before and after value, and an Undo this import button.
Step 5: every change on the job page, with Undo this import.

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

  1. Export products with the Variant Price and Variant Compare At Price columns (editor too).
  2. 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.
  3. 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.
  4. 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.

Tags

A product's Tags cell is its whole tag list (editor too). To add a tag, keep the old ones and add the new one; to remove one, delete it; to rename one, use Find and replace on the Tags column. Leave the column out to leave tags alone. Tags separated with “;” or “|” are split the way Shopify expects. See how to bulk edit tags.

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

  1. Export a backup first, and keep it unedited, even if your tool has an undo.
  2. 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.
  3. Include only the columns you're changing. Fewer columns means fewer ways for a blank cell to overwrite something.
  4. 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.
  5. 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

MessageWhat it meansFix
Invalid CSV header: missing headersShopify's importer didn't find the header row it expectsUse the header row from a Shopify export; check for spaces at the end of the first line
Handle already existsTwo different products in the file share a handleGive each product its own handle; only a product's own variant rows repeat it
Illegal quoting on lineA stray or curly quote, or a file that isn't UTF-8Replace curly quotes with straight ones and save as CSV UTF-8
Options are not uniqueTwo variants of a product have the same option valuesMake each variant's combination of options different
Image failed to downloadThe image link isn't public or doesn't point at an imageUse a direct https:// link that opens the image in a private browser window
ID shown as 7.2E+12Excel shortened a long IDFormat 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

Free CSV templatesBrowse the help center

Preview every change.Undo any import for 30 days.

Install free