Editing one product variant is easy. Editing 2000 product variants is a completely different story. Whether it’s updating the price of a single product, renaming a variation SKU, updating the weight of an option, or restoring inventory across multiple locations, merchants are constantly in need of a solution to make these tasks faster and easier. Doing it one row at a time through the product detail page is a sure fire way to loose all of your weekends. There are many different ways to bulk edit product variants, each with the potential to take more time then others.
We’ll go step by step through each method for updating product bulk information in your Shopify store. We’ll start with the native Shopify bulk editor, work through exporting and importing products in CSV format, then use Shopify Flow automated tasks, and finally highlight some third-party apps that will help with the job. To wrap things up, we’ll make a comparison chart showing the best app for specific tasks.
In this post
- What you can and cannot bulk edit
- Method 1: Native Shopify bulk editor
- Method 2: CSV export and reimport
- Method 3: Shopify Flow automations
- Method 4: Third-party bulk edit apps
- Comparison table
- Pitfalls and safety rules
- Frequently asked questions
- Related reading
What you can and cannot bulk edit
:before_you_begin Know your fields. Shopify allows you to bulk edit many different fields for variant title, SKU, barcode, price, compare at price, cost, weight, inventory, tax, shipping requirements and a few others. Variant images are a separate process (see our in-depth guide on variant images). Even metafields can be bulk edited, as long as you have already defined the field in Settings > Custom data.
Reminder on limits. As of Bulk Operations, the 2048 variant limit per product remains in place, as does the cap of 3 option types (such as size, color, and material) per product. Learn more about variants and options.
Method 1: Native Shopify bulk editor
- Open Products in the Shopify admin.
- Filter to the products you want to edit (by vendor, collection, tag, or published status).
- Select the products and click Bulk edit at the top.
- Click Columns and add the fields you want to edit (variant price, SKU, barcode, inventory).
- Click the expand arrow next to a product to reveal variant rows.
- Edit inline. Changes save automatically.
Good for: small batches of changes, quick updating of prices on a handful of products, inventory corrections on a handful of products. Bad for: Anything over 200 rows, anything that requires formularies, anything that you want to preview before posting.
Method 2: CSV export and reimport
- Go to Products and click Export.
- Choose All products (or a filtered selection) and export as CSV for Excel.
- Open the CSV in a spreadsheet. Each variant is a row.
- Edit the columns you need: Variant Price, Variant SKU, Variant Barcode, Variant Inventory Qty.
- Save as UTF-8 CSV (not xlsx). Preserve the Handle column exactly.
- Back in Shopify admin, click Import and upload. Tick Overwrite any current products that have the same handle.
Why this is the workhorse: you can use formulas. To demonstrate just how simple it is, we can multiply the price of an item by 12 in a single cell to get the markup: =*E2*12*. Also, because we can easily change the names of every SKU from OLD- to NEW- with a quick find and replace, it is simple to convert from an older product catalog to a newer one. To update an inventory report, we can use VLOOKUP to pull information from a supplier sheet. First, it is wise to validate the data in a given CSV with a tool like the one provided above to make sure you are not going to upload broken data. To get new SKUs, you can use a tool like our SKU generator.
Warning. Be careful not to edit the Handle column because you will make doppeltagged products. If you delete a row on Shopify then on reimport Shopify will NOT delete that variant, it will just leave it alone.
Method 3: Shopify Flow automations
Shopify Flow is free and allows you to perform bulk actions as scheduled or event-driven workflows. For example, every Monday at 2am, you might flag out of stock product variants as drafts, or you could apply a 10% markup to every variant in your Wholesale collection.
- Install Shopify Flow from the App Store (free).
- Click Create workflow and pick a trigger (Scheduled time, Product updated, Inventory quantity changed).
- Add a For each variant loop to iterate over every variant on a product.
- Add an Update product variant action with the new field values.
- Turn the workflow on and monitor the run log.
Flow is awesome for repeating, time-consuming tasks. Not so awesome for 1-off editings because while building the workflow was perhaps faster than doing the edits and exporting as a CSV, the stored flow needs to be re-edited and re-exported for any future 1-off edits.
Method 4: Third-party bulk edit apps
Even though there are many apps that can help you do bulk edits on variants, many of them add powerful features to what the native editor can do such as changing prices on a schedule, applying different markups based on criteria, rolling back changes, preview mode, and even audit logs. For large catalogs (above 1000 variants), the audit log alone makes the app worth the investment.
This is not the bulk operation you are looking for. If the bulk operation you need is around variant grouping (linking separate products as one combined listing with swatches), that is a different job. See Rubik Combined Listings for bulk grouping from CSV, title patterns, or AI. But for assigning variant images in bulk, see Rubik Variant Images for a background bulk assign based on gallery image order, not by filename.
Comparison table
| Method | Best for | Rollback | Cost |
|---|---|---|---|
| Bulk editor | Under 200 rows, quick fixes | No | Free |
| CSV reimport | Any size, formula work | Manual | Free |
| Shopify Flow | Recurring or event-driven | No | Free |
| Third-party app | Enterprise catalogs, audit | Yes | Paid |
Pitfalls and safety rules
5 Simple Rules for Bulk Editing Spreadsheets. Rule one: export a backup CSV before every bulk edit. Always. Rule two: test on five products before you touch five thousand. Rule three: never edit Handle, Variant ID, or Product ID columns. Rule four: disable inventory sync during big edits or you will double-count. Rule five: check the variant calculator to see what the final count will be after adding options.
– Why on earth does Shopify NOT have an “undo” feature on bulk edits? This is insane, and something that Shopify SHOULD have included from the get go. But hey, roll back you don’t get. Therefore, your safest option to “undo” is to keep a backup copy of your latest CSV file, and hope that you remember where you stored it.
Video walkthrough
Try it on your store
View the live demo of the Rubik apps before you download at rubikdemo.com. Documentation for Rubik Variant Images is at rubikvariant.com/docs. This video goes through the workflow of making a variant image for Rubik from start to finish.
Frequently asked questions
What is the fastest way to bulk edit variant prices?
Use native bulk editor for a quick edit of 10 to 200 rows. For edits over 200 rows or when using a formula, export as a CSV, edit in a spreadsheet, and then reimport into WordPress.
Can I bulk edit variant images?
Not through the native bulk edit tool. There are apps such as Rubik Variant Images, which have a method for background bulk assigning of variants to images, assigning based on the order of gallery images.
Does CSV reimport delete removed rows?
– Shopify only updates rows that exist in the CSV. Variants missing from the file will be left unchanged. To delete variants you have to remove them explicitly in the admin or via API.
How many variants can a product have?
Up to 2048 product variations (up from 100 in 8.2.2044), with 3 option types.
Is there a rollback after a bulk edit?
Not in Shopify 9. Third party apps may support rollbacks but by far the safest way to fallback is to keep a copy of the CSV export just before you make any changes.
Can Shopify Flow bulk edit variants?
Yes. Use a “For each variant” loop with an “Update product variant” action. Good for recurring tasks (though maybe a bit slower to setup than a CSV for a one-off), but seems like the only efficient route for what you’re asking.
Will bulk editing affect SEO?
Only if you change URLs/handles. Price, SKU, and inventory changes do not affect SEO. Changing the Handle column will create a new URL for that product, so you should set up a redirect for that as well.
