Bulk editor

[sjosborne]

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?

[B__]

What's with all the AI powered answers lately?

[DrewOswald]

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

2. Edit your inventory quantities

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

Alternate:

You can also update the quantities directly in Products > Inventory

 

[LitExtension]

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.

2. Use filters to display the variants you want.

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

4. Click "Edit products".

5. In the bulk editor, click "Add fields" > "Available quantity".

6. 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.