How do I know if shoppers switched to another product?

Compare sales of similar products during the stock-out with their usual rate. If they rose by about what the missing product normally sold, buyers switched. If not, those sales were lost.

Why does ad spend matter here?

If you cut or raised ads during a stock-out, sales of other products move for that reason too. Pick periods where spend stayed steady, or note the change so you can read around it.

Can I do this with an assistant other than Claude?

Yes. Any assistant that can read your Shopify sales and inventory history, such as ChatGPT, Grok or Muse, can run the prompt on a live connection or an exported file.

What if I don't have stock history?

Days with zero sales of a normally steady product are a rough stand-in for a stock-out. Shopify inventory reports can also show when stock hit zero for each item.

All playbooks

Keep more of each sale · Play

Use past stock-outs to decide what to restock

Every time a product sold out, you ran a free experiment. Read it.

Past stock-outs show which products shoppers will replace and which they won't. Connect Shopify to Claude and ask it to find every top-product stock-out of three days or more in the last year, measure how much demand moved to similar items, and rank products by sales lost per day. Restock first where sales vanished.

1
Connect
- Shopify
2
Ask
Find every period in the last 12 months where a top product was sold out for 3 days or more. For each, how much of its usual sales moved to similar products, and how much simply disappeared? Rank products by sales lost per day out of stock.
Paste this into Claude, ChatGPT, Codex or Cursor.
3
Act
Restock first the products whose sales vanish when they're gone, not those whose buyers switch.

What it tends to findExample

When one colour sold out, 70% of its sales moved to another. A different product's stock-outs lost almost everything.

Watch out

Make sure ad spend didn't change during the stock-out. That would confuse the read.

Step by step

01Connect Shopify to Claude read-only, through a connector or MCP server if available, or upload 12 months of daily sales by product and inventory history.
02Run the prompt so Claude finds each stock-out and measures how much demand moved to similar products.
03Check that ad spend stayed steady during each stock-out, since a spend change would confuse the read.
04Restock first the products whose sales vanish when they are gone.
05Re-run before each stock order.

Questions

Run these next

Every number on these pages is an illustrative example, not a result from a named store. Read-only access is enough for every check; make any change yourself.

See where your funnel leaks

Book a call. We'll show you where you're losing sales and what to fix first.

Takes a minute. Then you pick a time.