Inventory
đź’Ž Built for Sidekick
⚡ Sidekick does this for you
shopify
sidekick
inventory
purchase-order
cost
margin
Purchase Order Cost Variance Report
Compare the unit cost on file against what was actually paid on received purchase orders to catch supplier price creep before it erodes margin.
đź“‹ Prompt
Run a cost variance report comparing what I’m paying suppliers now against what’s recorded on my product cost-per-item field. Pull all purchase orders received in the last [LOOKBACK_PERIOD] from vendor(s) [VENDOR_LIST, or “all vendors”]. For each SKU, compare the unit cost paid on the received PO against the current cost-per-item stored on that variant. Flag every SKU where the PO cost differs from the stored cost by more than [VARIANCE_THRESHOLD_PERCENT]%, whether the PO cost is higher or lower. For SKUs with a cost increase, show the retail price, current margin at the old cost, and new margin if cost-per-item is updated to match the latest PO — flag anything that drops below [MINIMUM_MARGIN_PERCENT]% margin. Show total dollar impact if I updated cost-per-item to the latest PO cost across every flagged SKU. Ask for my confirmation before changing anything. After I confirm, update cost-per-item on the confirmed SKUs to match their latest received PO cost, and give me the final list of what changed.
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