Sample data · stock and sales synced from Shopify 06:00
Inventory
Products in stock
ShopifyLots expiring within 90 days
Warehouse / 3PL · to confirmNext order deadline
Lead time: you enterStock by lot
Lots & expiry: from your warehouse / 3PL, to confirmShopify knows the total per product, not lots. Lot numbers and best-before dates come from the 3PL's stock report, or are entered when a shipment is received. Oldest first: pick K-2408-C next.
| Product · lot | On hand | Best before | Shelf life left | Outlook |
|---|---|---|---|---|
| Café Grade 1kg K-2409-C | 180 bags | 1 Jan 2027 | 60 days | ~140 sell in time |
| Hojicha 30g H-2407-A | 85 tins | 30 Jan 2027 | 89 days | Sells out first |
| Ceremonial No.1 30g K-2408-C | 69 tins | 14 Jun 2027 | 7 months | On track |
| Ceremonial No.1 30g K-2410-A | 240 tins | 2 Sep 2027 | 10 months | On track |
| Ceremonial No.1 30g K-2411-B | 360 tins | 20 Oct 2027 | 11 months | On track |
| Café Grade 1kg K-2411-A | 420 bags | 3 Nov 2027 | 12 months | On track |
Days of stock
ShopifyDashed line: 72-day lead time You enter. Left of it needs an order now, or one is on its way.
Hojicha: 400 tins on order, landing 18 Nov. Click any number to see how it was worked out.
Reorder alert Order Ceremonial No.1 30g by 20 Nov · 1,200 tins suggested See planHide plan
669 tins on hand, selling about 52 a week Shopify, so stock runs out around 31 January. A new order takes 72 days to reach the shelf You enter, counting Japan's New Year closure HQ calendar.
Suggested order
1,200 tins
About 23 weeks of sales · supplier minimum 600 You enter
Lead time · 72 days
Entered by your team on Assumptions. Once purchase-order and received dates are recorded, HQ learns the real lead times from them.Order 20 Novsupplier starts production
Ships 18 DecNew Year closure planned in
Lands 13 JanPort of Los Angeles
On shelf 24 Janafter customs and receiving
Runs out 31 Jan7-day buffer left
Inputs used
You approve every order. HQ suggests; it never orders on its own.