Inventory 💎 Built for Sidekick ⚡ Sidekick does this for you
shopify sidekick inventory purchase-order incoming-inventory

Open Purchase Order & Incoming Inventory Tracker

List every open purchase order with expected arrival dates and quantities so you know what inventory is in transit before it's on the shelf.

📋 Prompt
Run in Sidekick
Give me full visibility into incoming inventory across all open purchase orders.


  Pull every purchase order currently in draft, submitted, or partially-received status.
  For each PO show: vendor, destination location, expected arrival date, total SKUs, total units ordered, and units still outstanding (ordered minus received so far).
  Sort the list by expected arrival date, soonest first.
  Flag any PO with an expected arrival date more than [OVERDUE_DAYS] days in the past that’s still not fully received — these are likely late.
  For [KEY_SKU_LIST] specifically, tell me how many units are currently incoming across all open POs and when the earliest batch is due, so I know how much “in transit” stock to factor in before deciding whether to place another order.


Present this as a table grouped by vendor, with a summary line at the top: total open POs, total units incoming, total dollar value on order.

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