EarnToLink Tools

All tools / Sale price and margin calculator with bulk paste

Sale price calculator with bulk paste and margin check

Paste a list of prices, choose a discount, pick a price ending such as .99, and see the sale price, the real percent off and your margin.

Free. No signup. Runs entirely in your browser: nothing you enter or choose is uploaded.

Work out sale prices

How to calculate your sale prices

  1. Paste prices into the box, one per line. You can add a name before the price and a cost after it, for example Blue mug, 24.00, 9.50. Currency symbols are ignored.
  2. Choose the type of discount. Percent off takes a percentage from each price. Amount off subtracts a fixed amount. Target margin works backwards from your cost to the price that gives you a chosen margin.
  3. Choose a price ending. The tool rounds down to the nearest .99, .95 or whole number, so it never raises a price above what the discount alone would give.
  4. Copy the results as CSV or download them.

Margin and markup are different

Margin is profit divided by the selling price. Markup is profit divided by the cost. A product that costs 10 and sells for 20 has a 50% margin but a 100% markup. This calculator reports margin: (price minus cost) divided by price. If you add costs, you can see at a glance whether a discount pushes a product below break-even. Remember that the cost you enter should include everything you pay per unit that matters to you, such as shipping in and payment fees, which this tool does not know about.

Pricing tips for sales

Deep discounts need far more extra sales to pay off than most people expect. If your margin is 40%, a 20% discount cuts your profit per unit in half. Keep the original price visible as a compare-at price so shoppers see the saving. Use .99 or .95 endings if they match your brand; they are a habit, not a rule. Test one sale at a time so you know what caused the change in sales.

Frequently asked questions

How are prices rounded?

The calculation uses whole cents internally to avoid floating point errors, then applies your chosen ending by rounding down.

What does "n/a" mean in the table?

In target margin mode, a line needs a cost. Without one, no price can be calculated.

Does this change anything in my store?

No. It only does the arithmetic here. You copy the numbers wherever you need them.

Does it handle taxes?

No. Enter prices the way you want to compare them, either all with tax or all without.

More free tools