Bulk Product Editor

You can use Bulk Product Editor to mass update products and product variations in your online store. This tool allows you to edit multiple product properties, including name, SKU, images, price, stock, shipping settings, etc. 

 

Choose a product to mass update

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

• Name
• SKU
• Images
• Availability
• Description
• Categories
• Subtitles
• Whether the product is featured on the store homepage
• Price
• “Compare to” price
• Price per unit (if enabled)
• Cost price (if enabled)
• Stock
• Out of stock behavior
• Product quantity when the low stock notification is sent
• Whether the product requires shipping or pickup
• Weight
• Dimensions (length, width, and height)
• Attributes

Before entering the Bulk Product Editor, you need to choose which products you want to update. You can choose to mass update all the products in your store, or select items individually (the maximum is 100).

 

Option 1: Update all products

1. On the left-hand sidebar, select Catalog > Products.
2. Click Bulk Edit All.

You will then be redirected to the Bulk Product Editor page, where you can edit properties for all the products in your store.

 

Option 2: Choose multiple products to mass update

1. On the left-hand sidebar, go to Catalog > Products.
2. Select the products you want to update (you can click Filter in the top-left corner to use filters and search more quickly).
3. Click Bulk Edit Selected.

 

You will then be redirected to the Bulk Product Editor page, where you can edit properties for all the selected products.

 

Edit product properties

Once you select products for editing and proceed to the Bulk Product Editor page, you will see these products (as well as their variations) listed in a table. Products are table rows, and product properties are table columns:

Select the properties you want to edit in the Columns menu on the left. This will add the corresponding columns to the table; you can also deselect the columns 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/product 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:

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 update product accessibility

You can quickly enable, disable, or delete selected products even without entering the Bulk Product Editor by using the Mass Update option. 

To instantly update selected products:

1. On the left-hand sidebar, go to Catalog > Products.
2. Select 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, Enable or Disable > Disable Selected, or Delete Selected.
5. If you chose Delete Selected, click Yes in the pop-up.

The changes will save automatically.

1.  

 

Change prices in bulk

With the Mass Update option, you can also easily increase or reduce prices for several products at once by a fixed value or by a percentage of the current price. For example, if you run a storewide sale or you need to raise prices a little to cover your expenses.

To change product prices:

1. On the left-hand sidebar, 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 > Set Up Pricing > Increase Prices for Selected or Mass Update > Set Up Pricing > 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.