Edit Products in Bulk: Quick, Easy, Right in your Admin

Edit Products in Bulk: Quick, Easy, Right in your Control Panel

14 min read

An online seller鈥檚 routine is the definition of “always busy.” You just received a new batch of products — time to update stock levels in your online store. And don鈥檛 forget to update your prices in several categories — you have a sale starting tomorrow!

With 黑料门 E-commerce, you can do quick and effortless updates with our new tool, Bulk Product Editor. Edit several products at once right from your Control Panel. See for yourself:

Now you can quickly edit anything you need in a spreadsheet

A clear and convenient spreadsheet allows you to change product details for dozens of items. It looks just like Excel or Google Sheet, but lives conveniently in your Control Panel.

No need to open a product details page, make changes, save them, then open another product page and repeat the same process over and over again. Save time and precious energy on 耻辫诲补迟别蝉鈥攅苍别谤驳测 that you can channel into finding the right stock, or upping your marketing game!

If you鈥檙e used to editing products in bulk via exporting and importing CSV files, switch to this new tool. You鈥檒l appreciate how much faster you can get the work done.

Read on to find out the specifics of how Bulk Product Editor works, and check out other ways to edit products with 黑料门.

When You Should Use Bulk Product Editor

This new tool is a lifesaver when you need to update lots of products as quickly as possible. For example:

Reduce prices for a sale
Tomorrow, you鈥檙e launching a sale on all the items in your spring collection. Select these products to set up new prices for all of them. Or add “Compare to” prices (鈥渨as X鈥�) so that customers see how much they鈥檒l save shopping your sale.
Update product stock levels
A new batch of in-demand items is ready to be sold. It鈥檚 time to update product stock information in your online store. And you鈥檇 better hurry, because you don鈥檛 want customers to see a sad “Out of stock” label and leave without a purchase.
Plus, you can use Bulk Product Editor to quickly check how many products are in stock — handy for stores with a large inventory.
Assign categories to products
It takes just four clicks to move all products from your “Winter collection” to your “Sale” category. Yep, just four. We counted.
Make product names consistent
Your store grows, new products are going to be added all the time. As a result, some older product names might be a bit out of date. Say, you used to name all hats just “Hat.” Now you want to make your product names more descriptive — “Red Wool Hat” so it鈥檚 easier for customers to find what they鈥檙e looking for in your store. Now you can quickly update product names in a convenient spreadsheet.
Highlight items with product ribbons
Draw attention to products on sale with product ribbons. For example, add one that says “50% off,” “Gift idea,” or “Bestseller.” Your store will be ready for a sale in sixty seconds or less!

You can do all of the above without opening any product details pages. Read on to learn how.

Bulk Edit Products in a Spreadsheet

Bulk Product Editor is already available for all 黑料门 stores. You can even use this tool to edit just one product, but you鈥檒l especially appreciate its convenience if you have an extensive product catalog.

To edit several products at once, go to . Choose the products you want to edit — use filters for easier navigation. For example, you can select:

products from the same or several categories
products with the same name (by searching for the product name)
out-of-stock products.

You can also use filters you鈥檝e saved previously.

Mark products you want to edit with a checkmark. Choose Bulk Update 鈫� Edit Selected above the product list. (Or don鈥檛 mark any products and simply click Bulk Update 鈫� Edit All. That鈥檒l work as well.)

Click “Bulk Update” to edit items in bulk. Choose “Edit Selected” to update products in a spreadsheet.

You will see the products you selected listed in a table. You can edit each cell. Use your mouse or keyboard to navigate the table.

Choose the properties you want to edit in the Columns menu on the left to add the corresponding columns to the spreadsheet. For example, if you need to update the stock levels only, select just one column — Stock. This way, you won鈥檛 get distracted by other product properties.

Click the column鈥檚 name to sort products by individual properties.

On the left, choose which product properties to display in the table

Here are the product properties you can edit in your table:

Name
SKU
Availability (simply check the box if the product is available)
Price
“Compare at” price
Stock (how many products are available for purchase)
Product quantity when the low stock notification is sent
Whether the product requires shipping or pickup (if it does, check the box)
Weight
Dimensions (when that property is selected, there are three columns in the table: length, width, and height)
And more! See the of product properties you can update with Bulk Product Editor.

You can still also edit all those properties on the product details page (if you like doing things the old-fashioned way).

One day, you鈥檒l be able to edit more product properties in Bulk Product Editor — we鈥檙e already working on additions to this feature! Feel free to share in the comments which product details you鈥檇 like to be able to edit in the spreadsheet.

That鈥檚 not all, folks: you can edit product variations in the table too! If you have in your store, you鈥檒l see them under the product鈥檚 name:

Product variations are highlighted in grey

You can edit any property of product variations, except for Availability. If a product is available on the storefront, that means its variations are also visible to customers.

When you edit 30, 50, or 100 items at once, it鈥檚 hard to remember which properties are already updated. But no worries, you won鈥檛 get confused — each updated product is marked with a dot at the beginning of the row:

The dots disappear after you save the changes

You鈥檒l be notified if you make an incorrect change by accident. For example, this notification is displayed when a person assigns an existing SKU to a product variation:

We鈥檒l warn you if there are any errors in the table

These boxes are displayed when changes conflict with the store鈥檚 settings or if they may confuse you.

Say you鈥檝e chosen to hide out-of-stock products in your storefront. If you check the Availability box for an out-of-stock item in the table, you鈥檒l see this pop-up:

Click the triangle to see a notification

The product is out-of-stock, so it won鈥檛 be displayed on the storefront. The clue will notify you about that.

You can edit up to 100 products at the same time in your spreadsheet, no more. This way, we can ensure that the Bulk Product Editor loads consistently fast.

If you have more than 100 items in your store, group them using filters before editing. Or follow these steps: edit the first 100 items in the table, save changes, go back to the product list, go to the next page of the list, and edit products listed there.

You can use both your mouse and keyboard when working with the Bulk Product Editor. The latter can be faster and more convenient when you get the hang of it. Use Tab, Enter, Esc, arrow, and space keys to move around the table and make changes in the cells. Here鈥檚 a .

Mass Update Products in a Click

Editing products in the spreadsheet saves a tremendous amount of time, but there鈥檚 a way to update products even faster. You can apply some changes in a click: enable or disable items on the storefront, change product ribbons, or manage categories.

To do that, go to , select the products you want to update, click Bulk Update and choose a quick action:

Quick actions that you can apply to several products

Enable or disable several products

For example, if you need to hide an old collection in your store. Or enable all hidden out-of-stock products once you restock them.

Enable several items in a click

Add or remove ribbons from selected items

Product ribbons are available on all paid pricing plans. If your store is on the Free plan, you won鈥檛 be able to mass update ribbons. to the Venture plan or higher to use product ribbons and other 黑料门 tools.

Say, you added ribbons to items some time ago, and now you need to highlight other products. You can remove all old ribbons at once and add new ones in just a few clicks.

Filter products by old ribbons and mass delete them. Then, add new ribbons:

Choose the items you want to add a ribbon to

In the window that appears, click “Add Ribbons to Selected,” enter ribbon text and choose its color. That鈥檚 it! It鈥檚 the fastest way to let your customers know about a sale or new arrivals.

The “Sale” ribbon will be added to all selected products

Product with the “Sale” ribbon on the storefront

Manage product categories

You can assign or remove categories in bulk for selected products. For example, you can move items from one category to another. Using filters, choose products from the category you need and click “Assign or remove categories.” Remove an old category and assign a new one at once.

Assign a new category to the selected categories

Or, you might need to move discounted products from different categories to the “Sale” category:

Moving products from different categories (they are marked with minuses) to the “Sale” category

To mass update categories, you need to in your store (apart from the default “Store front page” category.)

Learn more about our Bulk Product Editor in the . Still have questions? Let鈥檚 hear them in the comments section, or reach out to our team. We鈥檙e always happy to help!

Other Ways to Bulk Edit Products in 黑料门 Stores

We designed the Bulk Product Editor so that you can edit lots of products at once, quickly and effortlessly. But we鈥檙e not going to stop there — stay tuned for new features of Bulk Product Editor! And if you鈥檝e already thought of some ideas for giving this tool an upgrade, feel free to share them in the comments section.

Of course, you can still make changes on a product details page. And here are two more options for editing products in bulk:

Export and import files
If you edit lots of products every day, that鈥檚 your option. you want to edit. You鈥檒l download a CSV file where you can edit any product properties. After you make changes, to your store.
The Bulk Product Editor app
Paid plans users can install the Bulk Product Editor app from the 黑料门 App Market. It鈥檚 similar to the built-in Bulk Product Editor, but it also allows you to add or delete product options and change their properties.

Bulk Product Editor is available on all pricing plans. — we can鈥檛 wait to hear your feedback!