Skip to content
Hypamoon

For teams that run on Shopify

Shopify bulk inventory update per location

Shopify keeps several inventory states per item and location, such as on hand, available and committed. Its bulk editor sets quantities without a record of where stock came from, and the quantity column in a product CSV is meant for stores with a single location. So after a count, stores with more locations update item by item or through an extra import.

How it goes today

  1. Count the stock and write the numbers on a list.
  2. Open each product in the admin.
  3. Work out the on hand figure from what is available and committed.
  4. Type the new quantity for each location.

How it can go

Set the stock of a whole location from one count file.

You send the count as a spreadsheet or a scanner export per location. First you see the differences against Shopify, with the value of what is up or down. After your approval the on hand stock is set per item at that location with a stock count as the reason. If stock moved while you counted, those items are shown apart before anything changes.

Say this in ChatGPT, Claude or Copilot

Your chat gets connected to Hypamoon first, with this request filled in. Shopify works with a sign-in instead of a key: you sign in to Shopify once to give access, never in the chat.

Your request

With Hypamoon, when I send a stock count for a Shopify location as a spreadsheet, match it on SKU or barcode and show me the differences with the current stock and their value at cost. After I approve, set the on hand quantity per item at that location, with stock count as the reason. List items whose stock changed since the count apart, and email me a summary.

You create your own app in the Shopify Dev Dashboard and install it on your store once, with the access you approve. Shopify's help says apps that use customer names, emails or addresses need the Grow plan or higher. It stays yours.

More for teams on Shopify