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
Run in Sidekick
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

  1. Copy the prompt above
  2. Open Shopify Sidekick in your Shopify admin
  3. Paste the prompt and replace the bracketed placeholders with your details
  4. Review Sidekick's response and apply the suggestions