Inventory
💎 Built for Sidekick
⚡ Sidekick does this for you
shopify
sidekick
inventory
cost
pricing
Cost Change Margin Impact Report
After updating unit costs from a new price list or PO, recalculate margin across every affected SKU and flag which retail prices need to move to protect target margin.
📋 Prompt
I just updated cost-per-item on a batch of SKUs — show me the full margin impact and where retail price needs to move. For [SKU_LIST, or “every SKU updated in the last N days”], pull current cost-per-item, current retail price, and calculate current margin percent and margin dollars per unit. Compare against the previous cost (if I give you the old values below, or pull the last recorded cost if change history is available) to show the delta. Previous costs (if not otherwise available): [Paste SKU + old cost pairs, one per line] Flag every SKU where margin percent has dropped below [TARGET_MARGIN_PERCENT]%. For each flagged SKU, calculate the retail price that would restore margin back to [TARGET_MARGIN_PERCENT]%, and show current price vs. that recommended price side by side. Roll up total dollar margin impact across the whole batch at current pricing vs. what it would be if all flagged SKUs were repriced to target margin. Ask for my confirmation before changing any retail prices. If I confirm, update the flagged SKUs to their recommended price 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