Bulk editing inventory

You can use the bulk editor tool to make changes to the inventory of multiple products and product variants at the same time. From your Shopify admin, you can select the products and variants that you want to change the inventory for, select which product properties you want to update, and then make your changes.

Step 1: Select variants to edit inventory for in bulk

You can select product variants to edit in bulk from either the product details page or from the Inventory section in your Shopify admin. If you need to update the inventory of one or two products, then you might want to use the product details page. If you need to update the inventory for more than a few products, then you can access the bulk editor through the Inventory page.

Open the bulk editor to edit a product’s variants

If you want to bulk edit the inventory for a product with multiple variants, then you can use the bulk editor on a per-product basis.

Steps:

  1. Click a product that you want to bulk edit the inventory of.
  2. In the Variants section, use the checkboxes to select the variants that you want to edit.
  3. Click Open bulk editor.

Open the bulk editor to edit multiple products and their variants

If you want to bulk edit multiple products and their variants, then you can select which products and variants to bulk edit from the Inventory page.

Steps:

  1. From your Shopify admin, click Products > Inventory.
  2. Optional: If you have multiple store locations and want to display one specific location's inventory, then choose a location from the drop-down list. The selected location is the only location's inventory that will display.
  3. Use the checkboxes to select each of the products and variants that you want to bulk edit the inventory of.
  4. Click Edit variants to open the bulk editor.

Step 2: Select product variant properties to edit in bulk

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

Each column in the table represents a property, such as price, SKU, and compare-at price. Each row in the table represents a selected product variant. Refer to the table of properties in the inventory bulk editor to learn about what each property means.

Add a variant property

  1. In the Inventory Bulk Editor page, click Columns.
  2. Select the variant properties that you want to add to the table.

Remove a variant property

  1. In the Inventory Bulk Editor page, click Columns.
  2. Deselect all variant properties that you want to remove from the table.

Inventory bulk editor variant properties

In the inventory bulk editor, you can add any of the following variant properties that you want to edit:

Inventory bulk editor properties
PropertyDefinition
PriceThe price of the product variant.
Compare-at priceThe original price for a product that is on sale. When you enter a compare-at price, the product displays a sale price.
Cost per itemHow much it costs you for the product or variant.
Charge taxesWhether a tax is charged when the product variant is sold.
SKUA unique identifier for the product variant in the store.
Barcode The barcode, UPC, or ISBN number for the product.
Continue selling when out of stockWhether customers are allowed to place an order for the product variant when it's out of stock.
Track quantityWhether Shopify tracks the number of items in stock for the product variant.
Stocked atAll store locations where the product variant is stocked. This only appears for shops with multi-managed inventory enabled.
WeightThe weight of the product variant in your store's specified weight measurement unit.
Requires shippingWhether a customer needs to provide a shipping address when placing an order containing the product variant.
Harmonized system codeThe general Harmonized System (HS) code for the inventory item.
Country of originThe country where the product was manufactured or assembled.
Quantities by locationAll store locations where inventory is stocked.

Step 3: Edit variant properties in bulk

After you select the 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 variant property for that 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 variant 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.
Can’t find the answers you’re looking for? We’re here to help.