Inventory
đź’Ž Built for Sidekick
⚡ Sidekick does this for you
shopify
sidekick
inventory
cost
bulk-update
Unit Cost Bulk Update
Bulk update the cost-per-item field across a list of SKUs from a new supplier price list, previewing the margin impact before applying anything.
đź“‹ Prompt
[VENDOR_NAME] sent a new price list — update my cost-per-item field to match. New costs: [Paste SKU + new cost pairs, one per line — e.g. “SKU-101, $12.50” “SKU-102, $8.75”] Match each SKU to its product/variant and show the current cost-per-item next to the new cost, with the dollar and percent change. For each SKU, show current retail price and recalculate margin percent at the new cost — flag any SKU where margin drops below [MINIMUM_MARGIN_PERCENT]%. Flag any SKU from my list that you couldn’t match in the catalog — don’t guess, list them separately so I can check for typos. Show a summary: total SKUs updated, average cost change percent, and how many now fall below my minimum margin threshold. Ask for my confirmation before applying anything. After I confirm, update the cost-per-item field on every matched SKU to its new value, and give me the final list of SKUs still below minimum margin so I can decide whether to raise retail price on those.
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