SKU Price-List Optimizer
Import a product CSV, model target-margin prices and endings, preview changes, and export a spreadsheet-safe price list.
What This Tool Does
SKU Price-List Optimizer models a consistent gross-margin floor across a catalog while preserving product identifiers. It rounds upward to a chosen price ending and produces a separate change report, so a bulk update is reviewable before import.
How to Use
- Load a product CSV and map the SKU, cost, and current-price columns.
- Set the target gross margin and preferred fractional price ending.
- Review decreases and a sample of changed rows before exporting.
How the Analysis Works
The minimum price is cost divided by one minus the target gross-margin rate. The result is rounded up, never down, to the selected ending so rounding does not push an item below the target.
Limits and Responsible Use
The model excludes VAT or sales tax, shipping, payment fees, returns, discounts, channel commissions, minimum advertised price rules, and currency conversion unless those costs are already included in the cost column.
Examples
Protect a 40% margin
SKU 00123; cost 12.00; current price 18.00; ending .99
Result: A modeled price of 20.99 with the SKU preserved as text.
Frequently Asked Questions
Why can a modeled price be lower?
The current price may already exceed the selected margin floor. The tool flags decreases so you can keep the current price instead.
Is markup the same as margin?
No. Margin divides profit by selling price; markup divides profit by cost. This tool targets gross margin.
References
Important Note
Results are estimates for planning and education. They do not replace financial, tax, legal, or professional advice. Review assumptions before making decisions.