This step-by-step tutorial shows Shopify store owners how to bulk edit inventory using a CSV file. It covers exporting inventory from the Products > Inventory section, editing stock values in a spreadsheet without altering column headers, and re-importing the saved CSV to apply updates across many products and variants at once.
A short editorial from the VEONIB team on why this content matters.
CSV bulk editing remains Shopify's most reliable free method for updating large inventories, and this guide nails the core export-edit-import loop.
Most tutorials skip the failure points — header changes and wrong file formats — but this one flags them, which is exactly where imports break.
Store owners managing dozens or hundreds of SKUs should watch this, then test the workflow on a small CSV batch before running a full update.
Updating stock levels for many Shopify products or variants at once instead of individually.
A comma-separated values spreadsheet format that Shopify uses for inventory export and import.
Downloading current stock data from the Shopify admin as a CSV file for editing.
Uploading an edited CSV back into Shopify to apply bulk inventory changes.
Different versions of a product, such as size or color, each with its own inventory count.
The backend dashboard where merchants manage products, inventory, orders, and settings.
The labeled row at the top of a CSV that Shopify relies on to map imported data correctly.
The ongoing process of tracking and updating stock levels across a store's catalog.
How do I bulk edit inventory on Shopify?
Export your inventory as a CSV from Products > Inventory, edit the stock values in a spreadsheet, save as CSV, then re-import the file via the Import button.
Where is the inventory export button in Shopify?
It's at the top right of the Inventory page, which you reach by clicking Products then Inventory in the left sidebar.
Can I edit Shopify inventory in Google Sheets?
Yes. Open the exported CSV in Google Sheets or Excel, make your changes, then download or save it back as a CSV file.
Why did my Shopify CSV import fail?
Common causes are renamed column headers, rearranged columns, or saving the file in a non-CSV format like XLSX.
Should I save my Shopify inventory file as XLSX or CSV?
Always save as CSV. Shopify cannot reliably read other spreadsheet formats during import.
Can I update inventory for multiple variants at once?
Yes. The exported CSV includes rows for each variant, so you can edit stock values for all of them in one file.
Do I need to keep the original column headers?
Yes. Shopify maps your data using those headers, so changing or removing them will break the import.
How long does a Shopify CSV inventory import take?
Shopify usually processes the file within seconds to a few minutes, depending on the number of rows.
Can I add new products with the inventory CSV import?
The inventory CSV is designed for updating stock on existing items. To add new products, use the product CSV import instead.
Is bulk CSV editing better than using an inventory app?
For occasional large updates, CSV is free and fast. For frequent, automated syncing, a dedicated inventory app may be more efficient.