Inventory
💎 Built for Sidekick
âš¡ Sidekick does this for you
shopify
sidekick
inventory
reorder
margin
Margin-Weighted Reorder Prioritization
When purchasing budget is limited, rank everything due for reorder by margin dollars contributed instead of just sales volume, so cash goes to the most profitable restocks first.
📋 Prompt
I only have [PURCHASING_BUDGET] to spend on restocking this cycle — help me prioritize which SKUs to reorder first by profitability, not just volume. Pull every SKU currently below [REORDER_THRESHOLD] units along with unit cost, retail price, and sales velocity over the last [LOOKBACK_DAYS] days. Calculate margin dollars per unit (retail minus cost) and projected margin dollars per week at current velocity for each SKU. Rank the reorder-eligible SKUs by projected weekly margin dollars, highest first — this is different from ranking by units sold, since a lower-volume, higher-margin item may deserve budget before a high-volume, thin-margin one. Walking down the ranked list, allocate [PURCHASING_BUDGET] to reorder quantities (up to each SKU’s calculated restock need) until the budget runs out, and show exactly where the cutoff line falls. List the SKUs that fall below the cutoff and therefore won’t be reordered this cycle, so I can see what’s being deprioritized and decide if that’s acceptable. Show me the ranked table and budget cutoff before any narrative explanation.
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