Inventory
💎 Built for Sidekick
âš¡ Sidekick does this for you
shopify
sidekick
inventory
purchase-order
vendor
Supplier PO Consolidation by Vendor
Group everything due for reorder across multiple product lines from the same vendor into one consolidated purchase order instead of several small ones.
📋 Prompt
I’m about to place several small orders with [VENDOR_NAME] and want to consolidate them into one purchase order instead. Pull every SKU supplied by [VENDOR_NAME] that is currently below [REORDER_THRESHOLD] units or tagged [REORDER_TAG, if used]. Group them by product line/category so I can see the full spread of what’s needed. Show quantity, unit cost, and line total for each SKU, plus a running grand total. Check if the combined order total qualifies for [VOLUME_DISCOUNT_THRESHOLD] — if I’ve told you this vendor has volume pricing breaks, flag if I’m just short of the next tier and by how much. Present the full consolidated list and total cost, and ask for my confirmation. After I confirm, build one draft purchase order to [VENDOR_NAME] at [LOCATION_NAME] containing every line item, and confirm the PO number, total units, and total cost back to me.
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