Discount types

Specific price, percentage off or fixed amount off — what each one does, when to pick it, and how it survives a catalog price change.

Every priced cell has a discount mode. It decides how the number in the cell is interpreted.

Set it in the cell's settings panel. The default is Specific price.

Specific price

The number is the price the buyer pays per unit.

Cell value 18 on a $30 product → the buyer pays $18.

Pick this when you have a negotiated price list — a real per-SKU price agreed with a customer. It is the most common wholesale case, and it is exactly what you get when you type a bare number into a cell.

Watch out: it is absolute. Raise the retail price to $40 and the wholesale price stays $18, quietly widening your margin gap. Specific prices need re-importing when your catalog moves.

Percentage

The number is a percentage off the product's price.

Cell value 20 with mode Percentage on a $30 product → the buyer pays $24.

Pick this when your wholesale relationship is genuinely "trade gets 20% off". It tracks catalog price changes automatically, so a price rise carries through to wholesale without a re-import.

In CSV this is 1:20;d:p.

Fixed amount

The number is an amount off the product's price, per unit.

Cell value 5 with mode Fixed amount on a $30 product → the buyer pays $25.

Useful for flat rebates — a fixed handling allowance per unit, say — where a percentage would over-reward expensive lines.

In CSV this is 1:5;d:f.

Fixed amounts do not scale. A $5 discount is 17% off a $30 product and 50% off a $10 one. Check your cheapest lines before applying a fixed amount broadly.

Mode applies to the whole cell

The discount mode is a property of the cell, not of an individual tier. Set a cell to Percentage with tiers at 1, 12 and 24, and every one of those tiers is a percentage.

In the CSV grammar this is why d:p appears once at the end of the cell rather than on each tier. There is a per-tier prefix form (p:12:20) if you genuinely need to mix modes within one cell, but the settings panel does not offer it and mixing is rarely worth the confusion.

Choosing

If your pricing is…	Use
A negotiated price per SKU, maintained in a spreadsheet	Specific price
A trade discount off retail	Percentage
A flat per-unit allowance	Fixed amount
Changing whenever your costs change	Percentage — it needs no maintenance when retail moves

Coming from Bold, the mapping is direct: fixed price → Specific price, percentage discount → Percentage, dollar-off → Fixed amount. See Migrating from Bold.

Interaction with tiers and loose pricing

• Volume tiers — every tier uses the cell's mode. A percentage cell with tiers gives deeper percentages at higher quantities.

• Loose unit pricing — loose prices are always an explicit per-unit price, whatever the cell's mode. See Progressive case multiples.