Use a different exchange rate per brand or channel
One general rate for a currency pair is right when you buy and sell at the market. When a supplier or a channel gives you its own rate, set a rule for that scope, and Keelvy uses it for the goods it covers. The general rate stays for everything else.
What a rule can apply to
Section titled “What a rule can apply to”A rule applies to one of these:
- a brand
- a category
- a product group
- a product
- a channel
Set the rules in Settings → Currency.
Which rule wins
Section titled “Which rule wins”When several rules cover the same product, the most specific one wins, in this order:
- the product’s own rule
- its product group
- its category
- its brand
- the channel
- the general rate
So a rate set on a product beats one set on its brand, and a rule for a brand beats one for the channel it is sold through.
What the rules are used for
Section titled “What the rules are used for”- Price lists. A price list that converts from another currency uses the rule that covers each product.
- Every price recalculation from a currency. When a rate changes, the prices of the affected products are recalculated.
- Cost in a foreign currency. A cost recorded in another currency is converted with the same rules, so the margin you read and the markup and margin Skipper reports use the rate that applies to the product.
An example: a dealer of three brands
Section titled “An example: a dealer of three brands”Harbor Home Supply sells ceramics from three brands: Aster, Brin and Corvo. It buys from each brand’s distributor in euros, and sells through one channel with one price list in hryvnia.
Each distributor gives its own euro-to-hryvnia rate, so a single general rate would be wrong for at least two of them.
- Keep the general rate for the pair for anything without a rule.
- Add a rule for the brand Aster with the rate its distributor gave you.
- Do the same for Brin and Corvo, each with its own rate.
Now one price list in hryvnia gives each brand’s products their own converted price, and the cost of each brand’s goods is converted at that brand’s rate too. When Brin’s distributor changes its rate, you change the one rule, and only Brin’s products are recalculated. If you later need a different rate for one product, add a rule on the product: it wins over the brand.