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, inventory, and Metafields.

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

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.
  3. Click Bulk edit.

Select product properties to edit

The bulk editor 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 bulk editor, click Columns.
  2. Select all product properties that you want to add to the table.

Remove a product property

  1. In the bulk editor, click Columns.
  2. Deselect all product properties that you want to remove from the table.

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
ActionShortcut
Move between cellsClick 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 adjacentHold the Alt key on a PC or the command key on a Mac and click different cells.
Select multiple adjacent cellsClick 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 timeClick 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 itClick and drag the cell's fill handle across the cells below or above.
Adjust the width of a columnClick the divider to the right of a column title and drag your cursor to adjust the width of the column.
Ready to start selling with Shopify?Try it free