Skip to content
ZegMaarManu

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
Five steps from ex-cellar price to customer rate: input, landed cost, cost price, selling price and price lists.

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.

The price list builder with filters and a preview of the price list, with fictional test wines.

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.

A similar question?

Describe your situation and I will tell you honestly whether and how I can help.

Book an intro call
  • FreelanceLe Wine

    PIM platform for wine

    One source for all product information

    A PIM for wine importer Le Wine: all wines, spirits and glasses in one place, enriched in three languages, connected to SAP and the CRM, with price lists, quotes and a dedicated portal for B2B customers.

  • FreelanceLe Wine

    Visit report tool

    Visit reports for the retail team

    A mobile tool for Le Wine's new retail team: campaigns with stores from the CRM and products from the PIM, a flexible questionnaire, visit planning and reports that land on the timeline in the CRM. It makes the work in stores measurable for the producers.

  • FreelanceLe Wine

    Integrations and automation

    Web shops, ERP, CRM and email connected

    Behind Le Wine's web shops and event pages sits one connected whole: real-time connections with SAP Business One, Microsoft Dynamics, Omnisend and SendCloud, through one central gateway.

← All cases