Bulk Product Editor allows you to edit multiple product details: name, SKU, images, price, stock, shipping settings, etc. Product info is presented in a tabular form which makes the mass editing process fast and easy.

Bulk Product Editor is available from the Catalog → Products page in your store manager. You can also use the Mass Update option on this page to instantly enable, disable, or delete selected products, change prices, and more.

Table of contents

Choosing products for mass update

You can edit the following product properties using Bulk Product Editor:

  • Name (in all your store languages)

  • SKU

  • Images

  • Availability

  • Description (in all your store languages)

  • Categories

  • Whether the product is featured on the store homepage

  • Price

  • “Compare to” price

  • Cost price (if enabled)

  • Stock

  • Product quantity when the low stock notification is sent

  • Whether the product requires shipping or pickup

  • Weight

  • Dimensions (length, width, and height)

  • Subtitles (in all your store languages)

Before entering the Bulk Product Editor, you need to choose which products you want to update. You can either mass update all the products in your store or select several items. You can update up to 100 products at a time.

To choose all the products for a mass update, in your store manager, go to Catalog → Products and click Bulk Edit All.

Once you do that, you'll be redirected to the Bulk Product Editor page, where you can edit properties for all the products in your store.

To choose several products for mass update:

1. In your store manager, go to Catalog → Products.

2. Tick the products you want to update (you can click Filter in the left upper corner to use filters and make the search faster).

3. Click Bulk Edit Selected.

Once you do that, you'll be redirected to the Bulk Product Editor page, where you can edit properties for all the selected products.

Editing product properties

On the Bulk Product Editor page, you will see your products (and their variations) listed in a table. Products are table rows, and product properties are table columns:

BPE__1_.png

Tick the properties you want to edit in the Columns menu on the left to add the corresponding columns to the table and untick the ones you don’t need to make the table easier to manage. You can deselect all the columns except for the column with product images.

To edit a property for a particular product or its variation:

1. Click on the cell of this property in the row of the product/product variation.

2. Make the necessary changes.

3. Click Save.

The products that you have edited will be marked by a dot until you save the changes:

Note: You can change the properties that are not yet available in the Bulk Product Editor when you edit products one by one on their product detail pages in Catalog → Products → Edit Product.

Tips and shortcuts

You can edit the cells that have a white background in the table. Cells with a grey background are not available for editing.

Click the column name to sort products based on this property.

By default, the Columns menu is expanded, but you can always collapse it by clicking the Columns button to have more space to edit your products. You can unfold the menu back at any time.

To navigate the table, you can either click on the cell that you need with a cursor or use your keyboard:

  • Press Tab to select a cell and switch into keyboard navigation mode.

  • Use arrow keys (→, ←, ↑ or ↓) to move to the next/previous cell in the row/column (available after pressing Tab).

  • Press Enter to enter changes into the cell and move to the next cell in the column. You can also press Enter to start editing the selected cell.

  • Press Esc to discard the ongoing changes in the cell.

  • Press Spacebar to put a tick in the cell/to untick it.

Instantly updating product accessibility

You can quickly enable, disable, or delete selected products even without entering the Bulk Product Editor with the help of the Mass Update option. For example, if you want to temporarily hide a seasonable category, or you stop selling some product line forever and need to delete the items.

To instantly update selected products:

1. In your store admin, go to Catalog → Products.

2. Tick all the products you want to update (you can click Filter in the left upper corner to use filters and make the search faster).

3. Click Mass Update:

4. In the dropdown menu, choose Enable or Disable → Enable Selected, Disable Selected, or Delete Selected.

5. If you chose Delete Selected, click Yes in the popup.

The changes will be saved automatically.

Changing prices in bulk

With the Mass Update option, you can easily increase or reduce prices for multiple products at once by a fixed value or by a percentage of the current price.

To change product prices in bulk, follow these steps:

1. From your store manager, go to Catalog → Products.

2. Tick all the products you want to update (you can click Filter in the left upper corner to use filters and make the search faster).

3. Depending on your case, click Mass Update → Change Prices → Increase Prices for Selected or Reduce Prices for Selected.

4. In the dropdown menu, choose whether you want to change the price by a percentage or by an absolute value.

5. If you choose to change the price by a percentage, click Select a rounding method to choose how your prices will be rounded after recalculation. By default, they are rounded up to the nearest dollar (or any other currency you use in your store).

6. Enter the price change value.

7. Click Apply. The changes will be saved automatically.

You can also use the Mass Update option to perform the following actions in bulk:

Did this answer your question?