How does Colect calculate wholesale prices using margin and discount groups?
Below is an explanation of how Margin Groups and Discount Groups work in the system:
Margin Groups
When a customer is assigned to a margin group, Colect calculates the wholesale price based on the retail price (RRP) using the specified margin factor. The current wholesale price in the price element is ignored for these customers.
Important: A retail price must be provided for all margin-based customers. If all customers use margin-based pricing, you do not need to include a wholesale price in the product data — Colect will calculate it automatically based on the RRP and margin.
Margin + Discount
If a customer is assigned to both a margin group and a discount group, the system:
Calculates the wholesale price using the RRP and the margin factor.
Applies the discount percentage to the calculated wholesale price.
Example Customer: 11003114 (Margin Group 2.7)
RRP: €119.95
Wholesale: €119.95 ÷ 2.7 ≈ €44.43
Discount (30%): €44.43 × 0.70 ≈ €31.10
Discount Only
If a customer is not in a margin group, Colect uses the provided wholesale price and applies the discount directly.
Example Customer: 11001806 (Discount Group Only)
Wholesale: €46.10
Discount (30%): €46.10 × 0.70 = €32.27
Last updated
Was this helpful?

