FreelanceLe Wine
Pricing engine for wine
From purchase price to price list
The pricing engine of the Le Wine PIM calculates the full cost price per bottle and turns it into selling prices per customer type, with promotions, price lists and quotes. Every parameter is dated, so every price can be explained later.
Used
- Supabase
- PostgreSQL
What goes into it
The landed cost per bottle: purchase price, exchange rate, discount, commission, transport, storage and statutory levies such as excise duty, packaging levies and import duty. On top of that a coefficient per category and price band, VAT and tiers per customer type.
Margin and deviation alerts show immediately when a price is out of line.
People decide, the system calculates
Next to the calculated recommended price are retail prices found online. The pricing colleague chooses the final recommended price; the system calculates the rest.
Promotions run over a period, for bottles, wineries or categories, per customer type. When several overlap, the cheapest price wins.
Price lists and quotes
Price lists per customer or customer type, with filters, grouping, custom columns and a PDF with a cover page and terms of sale. Templates make it repeatable for the team.
Quotes work the same way. When an account manager requests a price adjustment, pricing approves it first. A final quote is locked; a new version keeps the same number with a higher version number.
Dated and immutable
Pricing parameters are dated and never overwritten. That way every price, price list and quote can be explained afterwards, even when the parameters have changed since.


