How to Bulk Edit Your Products
Bulk Edit lets you change several products at once, in a table, instead of opening each product.
What you can change
For each selected product you can edit:
- Name and SKU
- Type
- Price and Currency
- Quantity
- Status and Stock Status
- Locations, Storefronts and Categories
Other fields, such as descriptions and images, need to be changed on the product itself.
How to bulk edit
- Navigate to Products and use the filters if you need to find the products.
- Tick the checkbox on each product you want to change. A row of bulk actions appears.
- Click Bulk Edit. The Bulk Products Edit window opens with one row per product.
- Edit the cells you want to change.
- Click Update Products (at the top or the bottom of the window).
You'll see "Successfully updated N product(s)." If some products couldn't be updated you'll see "Failed updating N product(s)." and the window stays open so you can fix them.
Apply one value to many products
At the top of the window there's an Apply to all row. Pick a value for a column, such as a status or a storefront, and click Apply to column to copy it into every selected row. Then click Update Products.
Things to know
- Type: you can change Simple, Digital simple and Add-on products between those types. Variable and Digital variable products can't have their type changed in bulk.
- Storefronts, Locations and Categories are replaced with whatever you choose. If you clear the cell, the product is removed from all of them.
- Status: all statuses can be chosen. This is also how you restore trashed products.
- Required fields: every row needs a name, price, quantity and a 3 letter currency code.
- Delete: to trash the selected products instead, click Bulk Delete. See How to trash a product.