EStore Tools

Shopify Inventory CSV Builder

Turn a supplier's SKU and quantity list into Shopify's per-location inventory CSV.

Describe the result you need. AI will set up the tool and ask for any missing details.

Configure with AI

Enter to submit · Shift + Enter for a new line

Sent to AI. Leave out passwords and private customer data.

Drop your supplier's SKU and quantity sheet here or browse files

CSV up to 25 MB. It's read in your browser and never uploaded.

Must match a location under Settings → Locations in your Shopify admin, exactly.

How it works

Shopify's simpler inventory CSV format has a column per location, with the available quantity for that SKU underneath. This tool builds that layout: it looks for SKU and Quantity (or Stock) columns, and pivots a Location column into separate columns if your sheet has one.

If your sheet only covers one location, give that location's exact name below (matching your Shopify admin) instead.

Importing the result

  1. 01

    Check location names

    Go to Settings → Locations in your Shopify admin and copy each location's name exactly, including capitalization.

  2. 02

    Go to Products → Inventory

    Click Import, then upload the downloaded CSV.

  3. 03

    Review before confirming

    Shopify shows how many SKUs will change before you commit to the import.

Questions people ask

Does a location name have to match exactly?

Yes. Shopify matches locations by name, and it's case-sensitive, so "Warehouse" and "warehouse" are treated as different locations.

What if a SKU doesn't exist in Shopify yet?

The import won't create a new product from an inventory CSV. Add the product first (for example with the Supplier CSV Mapper), then set its stock here.

Can I set stock for several locations at once?

Yes, if your source sheet has a Location column, each distinct location becomes its own column in the output automatically.

Does this replace or add to existing stock?

Shopify's inventory CSV import sets stock to the number in the file; it doesn't add to what's already there.

Related tools

Shopify CSV ValidatorCheck a Shopify product CSV for import errors before you upload it, and download a cleaned-up copy.Supplier Sheet to Shopify CSV MapperTurn a supplier's product spreadsheet into a file Shopify can import.Shopify Bulk Image CSV BuilderTurn a SKU and image-URL sheet into Shopify's image import rows.Shopify Compare-at Price SetterStart or end a sale across a whole product CSV at once.

Want this builtinto your store?

I'm Emmanuel, a Shopify and WooCommerce developer. If this tool pointed at something you'd rather have fixed for you (a faster store, cleaner product data, a migration, a custom feature), send me a note.

Emmanuel Asika

Emmanuel Asika

Shopify & WooCommerce developer, Dublin

I build and fix online stores: new builds, migrations, speed, SEO and the custom bits apps can't do.

hello@emmanuelasika.com
See my work

Last reviewed 30 September 2026.

Sources: Shopify Help Center: Exporting and importing inventory with a CSV file