Bulk editing

You can use the bulk editor tool to make changes to multiple products and product variants at the same time. From your Shopify admin, you can select the products that you want to change, select which properties you want to update, and then make your changes. The bulk editor displays up to 100 products and product variants at the same time. You can also use the bulk editor to edit collections, customers, and inventory.

If you use the Microsoft Edge web browser when you edit products in bulk, then it might cause errors because that browser has a limited URL length. Consider using other web browsers such as, Chrome, Firefox, or Safari.

Step 1: Select products to edit

You can select products to edit in bulk from the Products page in your Shopify admin.

Steps:

  1. From your Shopify admin, click Products.
  2. Use the checkboxes to select each product that you want to edit. If you want to edit product variants of just one product, then select only that product.
  1. Click Edit products.

Step 2: Select product properties to edit

The Product Bulk Editor page displays the products that you selected and some of their properties in a table. You can change which product properties display in the table.

Each column in the table represents a product property, such as price, SKU, and compare at price. Each row in the table represents a selected product or product variant.

Add a product property

  1. In the Product Bulk Editor page, click Columns.

  2. Select all product properties that you want to add to the table.

Remove a product property

  1. In the Product Bulk Editor page, click Columns.

  2. Deselect all product properties that you want to remove from the table.

Step 3: Edit products in bulk

After you select the product properties that you want to edit, you can click the fields within the editor to type in new data or edit existing data.

Steps:

  1. Click and type within a field in the table to edit the product property for that product or product variant.

  2. Click Save. If any errors occur, then you need to fix them, and then click Save again.

Shortcuts in the bulk editor

To help you navigate and edit product properties efficiently in the bulk editor, you can use the following shortcuts:

Bulk editor shortcuts
Action Shortcut
Move between cells Click to select a table cell, and then press an arrow key on your keyboard to move to the next editable cell in that direction.
Select multiple cells that aren’t adjacent Hold the Alt key on a PC or the command key on a Mac and click different cells.
Select multiple adjacent cells Click to select a cell, then hold the shift key and click the last cell in the range of cells that you want to select.
Select and edit multiple fields at the same time Click and drag your cursor across multiple cells. This works for typing text and numbers, clicking checkboxes, and using drop-down menus in the selected cells.
Apply the value of a cell to the cells below or above it Click and drag the cell's fill handle across the cells below or above.

Ready to start selling with Shopify?

Try it free