Bulk editor

Store Design

Topic summary

A user needs to bulk edit inventory quantities to 2 for over 1,000 product variants and finds individual row editing too time-consuming.

Recommended Solutions:

CSV Export/Import Method (Best for large inventories):

  • Export inventory to Excel/CSV from Products section
  • Update the “Variant Inventory Qty” column in the spreadsheet
  • Re-import the file, selecting “Overwrite” to update quantities
  • Screenshots provided show the export/import interface

Alternative - Direct Bulk Editor:

  • Select multiple products/variants in Products > All Products
  • Click “Edit products” and add “Available quantity” field
  • Manually enter or copy-paste “2” across rows
  • Less efficient for 1,000+ items but works for smaller batches

Status: Multiple working solutions provided; CSV method recommended for this scale. One commenter questioned the prevalence of AI-generated responses in the forum.

Summarized with AI on October 28. AI used: claude-sonnet-4-5-20250929.
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

1 Like
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.