Skip to content

Which SKUs are out of stock or aging, by channel?

Join Shopify inventory and sales to Amazon's FBA ledger. See in-stock rate by channel, the SKUs out on Amazon that your warehouse still holds, and stock that hasn't sold in 90 days.

Open Querri

What you'll need

Querri (Free trial) to line up both channels day by day

Shopify and Amazon Seller Central: Step 1 says what each adds

Your stock rules: so in stock and aged mean the same thing on both channels

Free resources

Start your free trial here →

Sample data sets

Synthetic data for Curio Supply, a made-up home goods brand. Not real customer, retailer or marketplace data.

Need help?

If you have any questions, you can request a demo or email our team.

Before we begin

In-stock rate usually gets reported as one number per channel, and it usually looks fine. A healthy rate can hide a steady seller that has been out on Amazon for days while a thousand units sit in your own warehouse. Shopify knows what the warehouses hold and Amazon knows what its fulfillment centers hold, so seeing the gap between them takes two exports and a SKU map.

This playbook works out in-stock rate day by day on each channel, lists the SKUs out on Amazon that the warehouse still holds, and finds stock with no sale on a channel in 90 days.

How it works:

  • • Connect Shopify and Amazon Seller Central
  • • Calculate in-stock rate by channel, day by day
  • • Find SKUs out on Amazon but stocked in the warehouse
  • • List aged SKUs with units on hand
  • • Build the weekly stock view

Follow the steps

Open Querri →
1 Step 1:

Connect Shopify and Amazon Seller Central

Two sources, one project:

  • •

    Shopify: daily sellable units at each warehouse location, and sales by day and SKU.

  • •

    Amazon Seller Central: the FBA inventory ledger: each SKU's daily ending balance, receipts and shipments.

Both connect directly and sync on a schedule. Querri matches Amazon seller SKUs to Shopify SKUs, including a few legacy listings matched by title.

Tip: Pull at least 90 days of sales, so a SKU with no sale in that window is aged rather than new.

  • Shopify inventory and sales
  • Amazon FBA inventory ledger
Querri One project
2 Step 2:

Calculate in-stock rate by channel, day by day

Start with the rate, every day, on both channels:

Prompt

"What share of our SKUs is in stock on the store and on Amazon, day by day?"

From May to early October the store averaged 97.4% in stock and Amazon 98.3%. By 2026-11-01 both had fallen, to 92.2% and 92.7%.

Calculate in-stock rate by channel, day by day
DateStoreAmazon
Average, 2026-05-04 to 2026-10-0497.4%98.3%
2026-10-0497.2%100.0%
2026-11-0192.2%92.7%

Share of listed SKUs in stock, by channel.

3 Step 3:

Find SKUs out on Amazon but stocked in the warehouse

Then find what's out on Amazon that you already have:

Prompt

"Which SKUs are out on Amazon today, and which of them do we still have in the warehouse?"

13 SKUs were out on Amazon on 2026-11-01. 6 of them have 2,372 units in the warehouses, among them the Curio Waffle Throw, Amazon's ninth-best seller, with 1,239.

Find SKUs out on Amazon but stocked in the warehouse
SKUWarehouse unitsDays out of last 14
Curio Waffle Throw1,2399
Fenwick Linen Pillow Cover, 20 in42814
Harlow Linen Duvet Set, Queen30714
Garrick Linen Duvet Cover, King22311
Two more SKUs17514

Out on Amazon on 2026-11-01, with units in the warehouses.

4 Step 4:

List aged SKUs with units on hand

Last, find stock that isn't selling where it sits:

Prompt

"Which SKUs have stock but haven't sold on that channel in 90 days?"

7 SKUs on Amazon hold 7,960 units with no Amazon sale in the 90 days to 2026-11-01. The largest is Curio Glazed Dinner Plates, Set of 4: 2,310 units, last sold on 2026-07-21.

List aged SKUs with units on hand
SKUUnits at AmazonLast sale
Curio Glazed Dinner Plates, Set of 42,3102026-07-21
Elsin Knit Throw1,6402026-06-14
Marlow Knit Throw1,1802026-07-06
Tamsin Stoneware Bowls, Set of 49602026-06-28
All 7 aged SKUs7,960

Aged on Amazon: units on hand and no Amazon sale in the 90 days to 2026-11-01.

5 Step 5:

Build the weekly stock view

Four numbers for the weekly meeting, and one list of what to look at.

The narrative Querri writes:

Amazon's in-stock rate fell to 92.7% by 2026-11-01, and 6 of the 13 SKUs out there still have units in the warehouse.

What you can create or export:

Build the weekly stock view
GroupSKUsNext step
Out on Amazon, units in the warehouse6Check a transfer
Out on both channels7Check reorder timing
Aged on Amazon7Review the listing
Aged on the store3Review the listing

The weekly stock list, 2026-11-01.

One list of what to send in and what to stop sending.

Try it on your own data
Querri for ecommerce growth See how Querri helps growth teams see real profit by channel and campaign, with fees, ad spend and product cost in one place. See Querri for growth

See Querri for the whole brand

Tips for a stock view people trust

Check the warehouse before you reorder

A SKU out on Amazon may only need a transfer. Look at warehouse units first, then decide whether a purchase order is needed.

Age stock by channel

A SKU can sell well in the store and sit still at Amazon. Measuring the last sale per channel shows where the units are stuck.

Teach Querri your rules once. Every answer after that follows them.

What in stock means, how long before stock is aged, which units are sellable: say each rule once and Querri applies it to every question on that data.

Show me how

Say it in chat

Settle a rule in conversation and the Librarian records it as a fact under Facts & Rules, attached to the table it governs. Every later question on that data applies it, whoever asks, and every view built afterwards carries it.

Prompt

"A SKU is aged on a channel when it has units on hand there and no sale on that channel in 90 days. Save that as a rule for the inventory tables."

Or bring the document that already says it

Upload your inventory policy like any other file. Querri files a From a document card in the Inbox with the statements it found, each with its page and exact words; tick the ones to keep and they become facts. The rules this playbook depends on:

  • In stock: at least one sellable unit at the end of the day
  • Sellable on Amazon: ending warehouse balance, not inbound or reserved
  • Sellable on the store: units at the 3PL East and West locations
  • Aged: units on hand and no sale on that channel in 90 days
  • SKUs listed for fewer than 90 days are not aged
  • Amazon SKU map: Curio SKU plus -FBA, or by title for legacy listings
Prompt

"Read our inventory policy and propose the rules it states about in-stock rate and aged stock. I'll review them in the Inbox."

Where the rules reach

A rule is attached to the data, not to one person's chat, so it follows the data everywhere:

  • • Every question asked in chat, by anyone on the ecommerce team
  • • Every view the Librarian builds on that data
  • • Every step of a project, including the code it writes
  • • Dashboards and scheduled runs, each time they refresh
  • • Claude and ChatGPT, when they ask Querri

You stay in control

Every rule is listed under Facts & Rules next to the data it governs, where you can edit or remove it. Rules from a document wait for your tick in the Inbox, and a Worth remembering card is how Querri offers one it noticed itself. Workspaces and roles decide who can change what. Company-wide rules go in Settings → Customize; the Library is where the rest lives.

The payoff in the meeting

The meeting gets one list: what to send to Amazon, what to reorder, what to stop sending. Changing the aging window is a sentence.

Frequently asked questions

How is in-stock rate counted?
The share of listed SKUs with at least one sellable unit that day. A top seller and a slow one count the same, so the steady sellers that are out get listed by name.
Why compare with the warehouse?
Because a SKU out on Amazon with units in your own warehouse needs a transfer, not a purchase order. Six SKUs were in that position on 2026-11-01, with 2,372 units.
What counts as aged?
Units on hand on a channel and no sale on that channel in the 90 days to the snapshot. Amazon had 7 aged SKUs with 7,960 units; the store had 3 with 2,938.
Why are some SKUs left out of aging?
A SKU listed for fewer than 90 days can't have gone 90 days without a sale. Five recent launches are left out and listed.
Are inbound and reserved units counted?
No. Only sellable units count as in stock. Units on their way to Amazon or held for an order are not available to sell.
Does this forecast stockouts?
No. It reports days out of stock and usual daily units, not a forecast or a lost-sales figure.
Does Querri move inventory?
No. It reads a copy of the data and never creates a shipment or a purchase order.
How often should this run?
Weekly for the meeting, or daily on a schedule. A steady seller going out on Amazon shows up the first day it happens.