Inventory
đź’Ž Built for Sidekick
⚡ Sidekick does this for you
shopify
sidekick
inventory
purchase-order
vendor
Vendor Reorder Pattern Report
Analyze historical purchase order cadence and size per vendor to show how often you actually reorder from them and whether that matches their lead time and your stock cycles.
đź“‹ Prompt
Show me my actual reorder cadence with [VENDOR_NAME] (or “each of my top vendors”) based on purchase order history. Pull every purchase order placed with [VENDOR_NAME] over the last [LOOKBACK_PERIOD]. Calculate: average days between consecutive POs, average PO size in units and dollars, and the SKUs that appear most consistently across orders. Compare the average reorder interval against this vendor’s known lead time ([VENDOR_LEAD_TIME_DAYS] days, if I’ve told you, or pull it from [SUPPLIER_LEAD_TIME_TRACKER_DATA] if already tracked) — flag if I’m ordering more frequently than the lead time comfortably supports (risking gaps) or far less frequently (risking overstock between orders). Identify any SKU that appears in every PO at roughly the same quantity — these are candidates for setting up a recurring/standing order size to save planning time. Flag any SKU that used to appear regularly but hasn’t been on a PO in the last [GAP_ALERT_DAYS] days — possible discontinued item on the supplier side or an oversight on mine. Present the cadence summary first, then the flagged items below it.
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