Case study · FN Herstal
FN Herstal: selling in several currencies while keeping control of prices
For its international store, FN Herstal needed prices suited to the markets it serves, without separately maintaining one catalogue in euros, another in dollars and a third in pounds. With Medusa, we built a pricing policy based on a euro base, automatic conversion and an adjustable safety margin, also applied to shipping costs.
FN Herstal is a Belgian manufacturer whose online store serves consumers. The project combined several needs: welcoming buyers from different countries, offering several languages and currencies, and connecting sales to the company’s operations. For prices, the difficulty was specific. A sale collected in dollars or pounds does not always represent the same amount in euros. Exchange rates had to be taken into account without asking the team to rework each product’s prices as rates moved.
Choosing a country without being forced into a language
The delivery country and the reading language answer two different questions. The first determines the commercial conditions available for the purchase. The second lets the visitor understand the products and place an order. We therefore separated them: the customer chooses a market offered by the store and browses the site in English, French, Dutch or Spanish.
This distinction avoids automatically tying a language to a country. A buyer can keep their reading language while selecting the country where they want delivery. Prices and delivery options then follow the chosen market.
Changing country must also stay consistent with the cart. An address or delivery option chosen for one market cannot simply be reused for another. When the country changes, the cart’s previous addresses and shipping method are removed; the customer enters the information suited to their destination again.
Maintaining prices in euros and calculating foreign prices
We chose a euro price base. The team works on this base to set the commercial value of products. Dollar and pound prices are then calculated from these amounts. The team therefore does not have three independent price catalogues to maintain for the same items.
This organisation ties foreign prices to an identifiable commercial decision. When a reference price changes, its versions in the other two currencies rely on that same base. Automatic processing avoids having to carry each change over manually to several price lists.
The mechanism is designed to update conversions daily. This renewal follows exchange-rate movements rather than leaving foreign prices tied for a long time to the rate used when they were created.
Adding a safety margin the team can adjust
Converting at the raw rate was not enough for FN Herstal’s needs. The exchange rate can move between price calculation and payment collection. We therefore added a safety margin to the rate used to set foreign prices. The team can adjust this protection according to its commercial policy.
The setting governs how cautious the conversion is. It keeps a common rule for calculated prices, instead of correcting each item separately. The history keeps the rate used, its date and the safety margin applied: the team can find the elements used for an update.
This protection reduces exposure to exchange-rate movements. It does not guarantee the final margin on a sale, which also depends on product costs, the expenses actually incurred and rate movements after the update. The system provides a calculation rule and a way to track it.
Applying the same policy to shipping costs
The amount paid by the buyer also includes transport. We tied the shipping costs proposed by Odoo to the cart’s currency, with the same conversion rule and the same safety margin as for products.
Customers thus see their items and their delivery in the currency of their order. For FN Herstal, the exchange policy covers both components of the invoiced amount, without letting transport follow a different rule from the catalogue.
Keeping known prices when a rate cannot be retrieved
An automatic update must also plan for the rate provider being unavailable. If a new rate cannot be obtained, the system keeps the last calculated prices. It does not replace the amounts with an improvised rate.
This continuity has a limit: a kept rate can become old. The history helps identify the reference date of the conversions. For delivery, if no usable rate exists, no converted quote is offered. The journey thus avoids displaying foreign charges without a basis for calculation.
FN Herstal has a euro price base from which dollar and pound prices are derived, along with the transport conversions. The team keeps the commercial decision and the safety-margin setting; the system handles recalculations and their history. Buyers, for their part, build their order in their market’s currency with consistent amounts through to delivery.