Bulk editor

Store Design
1

Hi, i’m trying to bulk edit all the quanities of my items to 2 at the same time by selecting multiple rows at a time as i have over 1000 variables and it is taking too long to edit each row individually. Is there anyway I can change multiple rows of quantities at once?

2

You can export your inventory to an Excel spreadsheet, update the quantities for all your variants there (since it’s much easier to bulk edit in Excel), and then import the updated spreadsheet back into Shopify.

Instructions:

  1. Export your inventory to an excel spreadsheet

002.png
002.png999×392 51.2 KB

004.png
004.png633×563 25.5 KB

  1. Edit your inventory quantities

DrewOswald_0-1746854490644.png

  1. Import the spreadsheet in Products > Inventory (this will update the quantities)

003.png
003.png651×489 34.5 KB

Alternate:

You can also update the quantities directly in Products > Inventory

006.png
006.png1272×399 44.6 KB

3

What’s with all the AI powered answers lately?

4

Hi Sjosborne, we will suggest you 2 options to bulk edit all the quanities:

Option 1: Use Shopify’s Bulk Editor

Steps:1. Go to Products > All Products.

  1. Use filters to display the variants you want.

  2. Click the checkbox to select multiple products or variants.

  3. Click “Edit products”.

  4. In the bulk editor, click “Add fields” > “Available quantity”.

  5. Manually enter “2” for each visible row (can still be time-consuming for 1000+). You can copy-paste “2” down a column like in Excel.

Option 2: Export & Re-import with CSV (Faster for 1000+ variants)

Steps:
Go to Products > Export.

  1. Choose to export All products as a CSV.
  2. Open the CSV in Excel or Google Sheets.
  3. Locate the Variant Inventory Qty column.
  4. Use spreadsheet tools to bulk change all relevant cells to “2”.
  5. Save the CSV.
  6. Go back to Shopify > Import > upload the updated CSV.
  7. Choose Overwrite products with the same handle when prompted.
5

The JSON Money format trip is real here. CSV with a formula gets you the one-shot fill, but the import is brittle the moment prices change later. The bigger blocker is Shopify’s native variant metafield bulk editor itself. Variant metafields often don’t show up as columns in the grid at all, which is why CSV ends up being everyone’s fallback.

For that, a Shopify-native PIM is usually the cleaner setup. Variant metafields sit as proper columns next to variant prices, and you can derive RRP from the price column directly. Peak PIM is one to look at.