Price lists
Price list calculations
An overview of how price calculations are handled within the wholesale module.
Description of fields
| Column | Description |
|---|---|
| Purchase price | The value is retrieved from the Purchase price field on a product |
| Price (ex VAT) | The value is retrieved from the Price field on a product. If ex VAT, the price is calculated by excluding VAT, based on the rate of the channel's default market. |
| Price list price (ex VAT) | The price that the product will be sold for when included in this price list. It is retrieved from the Price field on a product. If ex VAT, the price is calculated by excluding VAT, based on the rate of the channel's default market. |
| Discount | Automatically calculate prices based on predefined rules. |
| Margin | The margin (%) between the purchase price and the original set price (calculated by excluding VAT, based on the rate of the channel's default market). |
Inc VAT
If the price list is created to be inc VAT, the price and the price list price field are calculated including VAT.
If the price list is created to be inc VAT, the price and the price list price field are calculated including VAT.
Field behavior
There are three fields in the price list that are editable: Price list price, Discount and Margin. The fields interact with each other in the following way:
- If the Price list price is changed, the Margin is automatically recalculated based on the new Price list price and the Purchase price.
- If a Discount is applied, the Price list price is adjusted accordingly, and the Margin is recalculated based on the new Price list price after the discount.
- If the Margin is adjusted manually, the Price list price is recalculated to maintain the specified Margin based on the Purchase price. The discount % is adjusted accordingly.
Currency and VAT
- Prices in the price list are shown either including or excluding VAT, based on which VAT setting the price list is created with.
- Because the price of a product is added inc VAT in Merchant Center, an automatic adjustment is made when the product is added to a price list and calculated by excluding VAT, based on the rate of the channel's default market.
- If a price list is created inc VAT and the currency of the list is set to other than your default currency, the price is calculated by excluding VAT, based on the rate of the channel's default market. Then calculated including VAT based on VAT rate the chosen currency has.
Price type indicators: D, G & M
In the price list on each row there is a Price type indicator to the right, which can be one of the following:
- D: Default price, no global rules or manual prices have been set. The price is the product's default price.
- G: Price set globally, the price is set by a global adjustment
- M: Price set manually, either by changing the Price list price field, margin or discount field
Create price list
A price list is a set of prices for a specific customer or group of customers. Price lists can be assigned to accounts and specific buyers, enabling tailored pricing strategies.
Volume pricing
Volume pricing allows you to set different price breaks based on the quantity of products purchased