Inventory
💎 Built for Sidekick
⚡ Sidekick does this for you
shopify
sidekick
inventory
ageing
capital
Inventory Ageing Report
Break down on-hand stock by how long it's sat since last received, flagging SKUs aging past your threshold as capital tied up in slow-moving inventory.
📋 Prompt
Build an inventory ageing report so I can see how long stock has been sitting since it was last received. For every SKU with on-hand inventory at [LOCATION_NAME, or “all locations”], pull the date of the most recent inventory receipt (purchase order receiving date or last positive adjustment). Bucket every SKU into age ranges: 0-30 days, 31-60 days, 61-90 days, 91-180 days, 180+ days since last received. For each bucket show: SKU count, total units, and total value at cost. Flag every SKU in the 91-180 and 180+ buckets specifically, sorted by tied-up capital (units x cost) descending — these are the highest-priority candidates for a markdown or clearance push. Cross-check the 180+ bucket against sales velocity over the last [LOOKBACK_DAYS] days — flag any SKU that’s both aged past 180 days AND had zero sales, since that’s dead capital, not just slow capital. Present as a summary table by age bucket, then a detailed list of the flagged 91+ day SKUs with product name, age in days, units, and value at cost.
How to Use
- Copy the prompt above
- Open Shopify Sidekick in your Shopify admin
- Paste the prompt and replace the bracketed placeholders with your details
- Review Sidekick's response and apply the suggestions