One plan across every warehouse and sales channel. Forecast demand, allocate shared stock, and net off incoming purchase orders.
Ordered units are used for inventory turnover, not the number of orders. Overlapping sales windows are not added together.
| Sales window | Ordered units | Daily unit sales | Current inventory cover · days |
|---|
To date versus the same elapsed part of the previous period. Weeks start Monday; months and quarters follow the calendar.
| Period | Current inventory | Previous inventory | Inventory change | Net slow-stock reduction | Current receipts | Previous receipts |
|---|
Inventory is a point-in-time balance, never a sum of daily balances. Missing comparison snapshots show a dash. Slow-stock reduction is previous slow units minus current slow units; it may include reclassification, not just sales. Receipt totals require declared ERP coverage; partial recorded units are shown separately. Company receipts exclude internal transfers, while platform receipts count arrivals assigned to that platform.
Current imports save daily inventory snapshots automatically. Import older ERP snapshots and receipt records to populate prior periods. No historical values are invented.
Health uses current visible sellable stock ÷ weighted daily ordered units: 7 days (50%), 14 days (30%), 28 days (20%), or your configured forecast weights. Missing 28-day sales renormalizes the available weights and marks the result incomplete. Company stock is counted once; shared platform inventory pools are not additive.
Healthy: weekly cover under 30 days, subject to the higher-priority comprehensive bands. Risk: weekly daily sales at least 25% below the 28-day average, 14-day cover over 30 days, and comprehensive cover within 45 days; remaining 30–45-day transition cases are also Risk. Sub-healthy: comprehensive cover over 45 through 90 days, including the 60–90-day watch band. Slow-moving: over 90 through 180 days. Stubborn Slow-moving Inventory: over 180 days or no recent sales pace. Zero stock has no inventory aging exposure; stockout alerts remain separate. These are forecasts, not actual lot ages.
Aging starts at Xuchang shipment for Amazon (75 days) and TikTok Shop (45 days), and at Xuchang receipt for DTC (30 days). Months use 30 days. Only remaining sellable lot quantities are assessed. Eligible units indicate provision exposure; an amount requires ERP unit cost, currency, and a provision rate. Missing inputs never become zero. No accounting entry is posted.
| SKU / lot | Platform / warehouse | Remaining units | Aging starts | Age / threshold · days | Eligible provision units | Provision amount |
|---|
Choose visible fields and move them into your preferred order. Saved for this account in this browser.
Period demand totals include pending, reviewing and approved submissions once per SKU-platform. Recommended forecast quantities are shown separately. SKU/SPU inventory totals follow role visibility; company-wide inventory is reserved for business managers. Stock attribution uses ERP allocations when supplied; otherwise it is the forecast planning allocation. Shared or unattributed stock is shown separately and counted once. A dash means hidden or unreported inventory. All new stocking enters Xuchang domestic warehouse before the final destination.
Production completion → domestic receipt → shipment → destination arrival. These are ERP facts, not actions executed in this system.
| SKU / demand reference | Approved | Domestic → destination | Produced / order completed | Domestic received | Shipped / tracking | 目标仓库存 | ERP data updated |
|---|
The production stocking manager reviews and executes orders in Dianxiaomi. Sync verified cumulative quantities, tracking and warehouse receipt data here.
Monitor SKU exposure, SPU slow-moving risk and cross-warehouse transfer decisions.
| SKU / SPU | Sellable stock | Open PO units | Unmatched purchase requests | Daily forecast | Stock cover | SPU factor | Recommended purchase |
|---|
Stock and transfer quantities are counted once across the business. Unmatched purchase requests exclude requests already linked to an ERP PO by ERP reference. Transfers reposition existing inventory; they do not add to total stock.
Only non-Amazon source inventory can enter this queue. Pending and approved requests reserve donor surplus until rejected or recorded as completed.
| SKU / manager | Platform | Source → destination | Quantity | Status | Decision / ERP reference |
|---|
Assign one sales platform to each manager. Site sharing access is managed separately; assignments do not send invitations.
Review your platform demand with visibility into every warehouse’s inventory.
Warehouse columns show sellable stock. Adjust the receiving warehouse and quantity, then confirm stocking in the rightmost column. Suggestions appear below each SKU; transfers still require owner approval. FBA 超出 45 天保护量且分给本渠道的库存已冲抵建议采购。
| SKU | Source → destination | Quantity | Status | Owner decision |
|---|
Follow one SKU from current warehouse stock to its final replenishment destinations.
See physical stock, reservations, sellable units and how the forecast uses each warehouse.
Allocated stock is a planning assignment, not an ERP reservation or warehouse transfer. Unallocated sellable stock remains in the shared pool.
Every deduction below is traced back to a warehouse or a purchase order for this SKU.
| Platform | 7d / 14d / 30d units | Weighted daily sales | Cycle | Target units | Stock deduction | PO deduction | Net replenishment | Trace |
|---|
The same stock and PO units are counted once. Low-volume SKUs retain base demand but receive no extra safety buffer; SPU risk may reduce the net purchase gap.
Adjust each platform’s quantity and receiving warehouse. The final warehouse breakdown updates immediately.
| Include | Platform | Net replenishment | Final quantity | Receiving warehouse | Supplier | Lead time |
|---|
Each platform line has one receiving warehouse. Multiple platform lines sent to the same warehouse are combined in the final SKU breakdown. Receiving destinations can differ from the warehouses supplying existing stock.
Compare current stock and deducted supply with the new quantities assigned to each receiving warehouse.
| Warehouse | Current sellable | Stock allocated | Open PO units | PO units deducted | New replenishment | Serving platforms |
|---|
New replenishment is an order plan, not stock already received. Open PO units include all outstanding open orders; only qualifying arrival quantities appear in the PO deduction column.
Positive quantities form the purchase-request batch. Select a SKU to inspect its workflow.
Forecast gaps within the next 7, 14 and 30 days, starting from the inventory snapshot date.
Shared stock and on-time POs are consumed once across platforms, following the saved platform priority.
| SKU / product | Platform | Risk category | First forecast gap | Days to gap | Eligible stock¹ | Incoming ≤30d¹ | 7d / 14d / 30d shortfall | Daily forecast | 30d sales |
|---|
¹ Eligible stock and PO quantities are shared warehouse pools; do not add them across platforms. Shortfall is forecast unmet demand by horizon, rounded up to units. POs arriving after a gap do not erase the earlier risk. Categories are 0–<7 days, 7–<14 days, and 14–<30 days; “No gap” means covered through this 30-day simulation. This forecast does not apply the 3-unit replenishment trigger.
Find inventory with no recent sales or more stock than the current sales pace supports.
Compare total sellable inventory, sales pace and time in slow-moving status.
| SKU / product | Category | Inventory quantity | 30d sales · all platforms | Daily forecast | Stock cover | Slow-moving since | Days in slow-moving status | Last sold | Details |
|---|
“No 30-day sales” is a dead-stock candidate, not proof that a product will never sell. Excess stock cover uses total sellable stock ÷ weighted daily sales across platforms. Days in slow-moving status require the snapshot’s historical slowMovingSince field; absent history is shown as Unknown and sorts last. Optional lastSoldAt shows the last sale date. Warehouse filtering changes the quantity displayed; classification remains SKU-wide.
Base demand uses the weighted forecast. Extra safety stock is disabled below 3 sales / 14 days AND 5 sales / 28 days. SPU slow-moving risk adjusts the net gap.
| SKU / product | Platform | 7d / 14d / 30d units | Daily forecast | Cycle | Target | Stock allocated | PO deduction | Cover days¹ | 30d turnover² | Replenish | Status / detail |
|---|
¹ Allocated stock ÷ weighted daily forecast. Shared stock is consumed once across platforms. This is forward stock cover; ² Unit turnover = 30-day sales ÷ platform historical average inventory; “—” means the average was not provided. Click a row’s detail for the calculation and allocation trace. Export includes every SKU and platform, regardless of filters.
Adjust quantities, verify the assigned supplier and choose a receiving warehouse before confirming.
| Include | SKU | Platform | Suggested | Confirm quantity | Supplier | Lead time | Receiving warehouse |
|---|
Purchase requests split by supplier and receiving warehouse. The forecast cycles remain 14 / 28 days; supplier lead time estimates the new request’s sellable restock date. Existing incoming POs keep their individual ERP ETAs.
Minute-stamped in America/New_York · immutable supplier, quantity and lead-time snapshots.
| Request name / reference | Supplier | Warehouse | Units | Estimated restock | ERP status | ERP reference | Action |
|---|
“Awaiting connection” is saved but not sent. “Submitted” requires a verified ERP receipt. “Outcome unknown” must be reconciled by request ID before retrying. Sample confirmations never create real ERP requests. After ERP creation, pull a fresh snapshot to include actual PO quantities and ETAs in forecasts.
Sellable balances across Xuchang, New Jersey returns, US warehouses and FBA.
Each warehouse shows sellable units (on hand − reserved − unsellable). Snapshot quantities are imported from ERP, not edited here.
Inventory is pooled by SKU, then allocated by platform priority.
| Warehouse | Sellable units | DTC website | TikTok Shop | Amazon |
|---|
Sellable = on hand − reserved − unsellable. NJ returns count only after inspection and restocking. Xuchang is eligible for DTC; transfer/transit times are not assumed. FBA includes sellable FBA inventory only; receiving/inbound units belong in POs.
Outstanding quantity = ordered − received. Only open POs with a confirmed ETA from snapshot date through platform cycle end can be deducted.
| PO / SKU | Destination | ETA | Lead time | Outstanding | Deducted | Remaining | Review |
|---|
Missing, overdue, cancelled, closed, late, or ineligible-destination arrivals are not credited. No PO unit is deducted twice. An ETA is not a guarantee of availability: stockout timing before arrival still needs operational review.
Live ERP access not configured
Live inventory syncing and purchase-request creation require your Dianxiaomi API authorization and an integration service. Purchase confirmation uses a server-side adapter; the connection status is shown in the confirmation tab. Never enter API secrets into this page.
Your integration should return one complete, consistent snapshot: canonical SKU mapping, historical platform average inventory (optional for turnover), all six warehouse groups, cumulative 7/14/30-day sales per platform, and PO destination / outstanding quantity / ETA. Aggregate all FBA locations without duplicating totals.
Optional HTTPS endpoint returning the normalized snapshot. Requires browser CORS support and service-side authorization. Never include API keys or tokens in the URL.
This is a manual data pull. Scheduled background sync is not active. API secrets and scheduled sync must be managed on your integration server; this workspace keeps adapter credentials server-side. Inventory snapshots, supplier settings and confirmation records are shared on the server with role-based access.
Sales windows end on asOf. Use physical units, exclude cancelled orders, and reconcile partial receipts. Missing data is rejected rather than treated as zero. PO ETA is the estimated sellable receipt date, not the supplier’s shipping date. Use explicit zero balances for empty warehouses/platforms.