Skip to content
Hypamoon

For teams that run on Shopify

Shopify dead stock and stock value per location

Shopify's sales reports are built from orders, so a product nobody bought does not show up there. Its month-end inventory snapshot shows stock per variant; matching the two to find slow stock per location and its value takes an export and a spreadsheet.

How it goes today

  1. Export the products with their stock.
  2. Export the sales report for the last months.
  3. Match the two in a sheet to find what did not sell.
  4. Tag the slow products one by one for a sale.

How it can go

Find what has not sold in months, and what it is worth at cost.

On the first of each month you get the products with stock that have not sold in 30, 90 or 180 days, per location, with the quantity on hand, the value at cost and the date of the last sale. The total stock value per location at that moment is saved each month, and slow products get a tag after your yes.

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, on the first of each month, email me the Shopify products with stock that have not sold in 30, 90 and 180 days, per location, with the quantity on hand, the value at cost and the last sale date. Save the total stock value per location each month and show it next to the months before. After my yes, tag the slow products for a sale.

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