Inventory
💎 Built for Sidekick
âš¡ Sidekick does this for you
shopify
sidekick
inventory
purchase-order
locations
Purchase Order Split Across Multiple Locations
Build one purchase order from a supplier that receives into several different locations at once, with per-location quantities allocated by need.
📋 Prompt
I’m placing one purchase order with [VENDOR_NAME] but the stock needs to land across multiple locations: [LOCATION_LIST]. For [SKU_LIST], pull current available stock and sales velocity at each of [LOCATION_LIST] over the last [LOOKBACK_DAYS] days. Recommend a per-location quantity split for each SKU that brings every location up to roughly [TARGET_STOCK_LEVEL] units, weighted by that location’s sales velocity share. Show a table: SKU, location, quantity, unit cost, line total — then a grand total per location and overall. Flag any SKU where the total across all locations doesn’t match what I’d normally order in one batch from [VENDOR_NAME] (e.g. below their minimum order quantity, if you know it) — [VENDOR_MOQ, if applicable]. Ask for my confirmation on the full split before creating anything. After I confirm, create the purchase order(s) to [VENDOR_NAME] with each location’s line items correctly assigned as separate receiving destinations, and confirm the PO number(s), per-location unit counts, and total 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