Issues with importing quantities via csv - 2 locations

Shopify Discussion

Topic summary

Importing inventory via CSV fails to update available quantities after adding a second location; it works with a single location. The workflow used is product CSV for item details, then inventory CSV for location and quantities.

Initial uploads failed with “handle not in Shopify” despite matching files. Support advised normalizing product handles (remove spaces/capitals) and ensuring UTF‑8 encoding, which led to a successful upload notification.

Current outcome: quantities in the “available” column remain 0 at the new two-location setup, even though the import reports success. No error messages beyond the earlier handle issue.

Requests for help were made; one respondent noted they couldn’t provide technical guidance. No further solutions offered.

Key terms: CSV (comma-separated values) file for data import; handle (unique product identifier in Shopify); UTF‑8 (text encoding standard).

Status: unresolved. No confirmed fix; causes and next steps (e.g., how inventory is mapped per location in the CSV) remain unanswered.

Summarized with AI on January 18. AI used: gpt-5.
1

Hi all, I’ve been using csv files for uploading info into Shopify for some time now and have been getting on fine - recently, I’ve added a second location to the store so I have been advised that I now need to use the product csv for uploading the details, then the inventory csv for the location and quantities - all makes sense.

Before I explain this - let me note that the csv files are working fine when I remove the second location and just use the single location in the store - only when I add the second location am I seeing an issue.

at first the uploads were failing due to the handle not being in shopify despite the 2 files being copynpaste items so they matched exactly - so the help desk have gone from suggesting removing any spaces, capitals from the handles of all - OK

then also making the sure the encoding is unicode 8 - fine also.

this created some success, a successful notification of upload - except upon checking the actual quantities (in the available column) were not showing (still 0).

any suggestions please?

2

Hi Anyone? @moeed? @JPHB85 ?

3

I am just a shop owner, I have no idea how to help on anything technical sorry

1 Like