To find Shopify stock that is not selling, start with the stocked products and compare them with sales over a defined period. Keep products with no matching sales in the review. Then check seasonality, recent receipts and whether the item was actually available to buy before deciding it is slow-moving.
Atso connects business software to AI assistants through MCP. Its Shopify connector reads connected stores, including orders and inventory. It can help with a focused stock review, but a confident conclusion requires enough history and complete product coverage.
Why can a sales report miss the stock you need to review?
A sales-led list can leave out products that have no sales in the period. Starting with inventory keeps those products in view and lets you distinguish a genuine zero from a missing match.
A merchant’s Shopify Community question describes this exact frustration: stock and units sold are difficult to review together, and the combined report they tried omitted stock without sales. That is a useful requirement for your own review, regardless of the reporting tool you choose.
Shopify already provides several inventory reports, including sales-related inventory measures. Check those first. Our recommendation is to test the report against a known stocked product with no recent orders, rather than assume that the report’s name guarantees the coverage you need.
Which fields should be in the review?
Use a stable product or variant identifier, store, location, stock quantity and sales period. Include a coverage column so a missing row is never silently interpreted as zero demand.
A proposed review table could contain:
| Field | Meaning |
|---|---|
| Store and variant | Which sellable item the row describes |
| SKU | Useful business label, checked for blanks and duplicates |
| Location | Where the reported stock is held |
| Current quantity | Stock at the time of retrieval |
| Recent units sold | Units measured over the stated order period |
| Coverage | Complete, partial or not established |
| Review reason | The specific observation that needs a person to check |
Use variant IDs within one store where possible. Across stores, agree a mapping before matching SKUs. Two stores can reuse a SKU for different products, or label the same product differently. A match based only on a similar title is weak evidence for moving stock or cancelling a purchase.
Current inventory and period sales also describe different moments. Label them accordingly. Do not call today’s stock quantity the opening stock for a past month.
What can Atso read from Shopify?
Atso provides separate sales summaries, top-product reports and current inventory snapshots. It also provides bounded record reads, so an assistant can inspect supported order and inventory details when a report raises a question.
The first-hand distinction in our connector is that an inventory snapshot describes stock now. Its date filters do not turn it into a historical stock report. A sales report, by contrast, uses a requested period. Keeping those meanings separate prevents a current stock count from being presented as a past month-end balance.
There are additional boundaries. The Shopify Order API limits ordinary order access to the last 60 days unless broader access is approved. Atso’s order-list response includes the first ten line items per order, and its inventory read includes the first ten locations holding each item. Large orders or location networks can therefore need a different retrieval or export path.
An assistant must check those boundaries before claiming that every item or location has been reviewed. If complete coverage cannot be established, the useful answer is a bounded list of candidates and a clear request for the missing information.
What prompt makes a useful first pass?
Ask for a coverage check before asking for a slow-stock ranking. That lets the assistant identify whether the available records can answer your actual question.
Try this suggested prompt after connecting the store:
Review current Shopify inventory against orders from 1 August 2026 to 31 August 2026. First tell me which stores, locations and order details you can read completely. Start from stocked variants and retain items without matching sales. Do not label an item as having zero sales if the order data is incomplete. Keep each store separate. Return a shortlist of products to investigate, the evidence for each, and any information you still need.
For an initial check, choose a small set of products you know well. Include an item with regular sales, an item with no sales and an item that was out of stock. Compare the assistant’s result with Shopify before widening the review.
This is a proposed workflow, not a claim that a single prompt produces a complete inventory audit. An export may be the better source when you need a long history or full line-item coverage.
How do you avoid mistaking unavailable stock for low demand?
Check whether customers could buy the item during the period. Low recorded sales can reflect a stockout, a new launch or seasonal timing, rather than a product nobody wants.
Suppose an item has stock today but only arrived near the end of the month. Dividing a few sales by the entire month’s days could make it look weaker than it is. Ask the buyer or warehouse team when the stock became available, and use reliable availability history if you have it.
A stock snapshot cannot reconstruct every past receipt or stockout. Keep that limitation visible. Suggested actions should be questions such as “check launch date” or “confirm availability”, until the supporting facts are known. Avoid automatically discounting an item because it appears near the bottom of a sales list.
How should you review multiple stores?
Use one consistent review format while retaining separate store identities and currencies. A shared view is useful only when you can trace each result back to its own store.
The multi-store operations discussion illustrates how reporting, wholesale operations and stock synchronisation can become mixed into one request. Separate those jobs. Atso can help read and compare connected store data; its read-only Shopify connector does not synchronise inventory or transfer stock.
For a weekly review, record which stores were included, which period was read and which questions remain unanswered. Ask the responsible person to review the shortlist before deciding on markdowns, transfers or replenishment. You can open Atso to connect your stores, or read how MCP connects business software to AI before choosing a first question.