Where do I use formulas? And what are they for?
In EffectConnect's Repricer, you make use of formulas. Formulas can be a bit overwhelming at first, but once you understand how a formula works (perhaps in combination with the use of placeholders) you may quickly get the hang of it.
Formulas are the basis for calculations. In your formula, you say exactly what should happen in your calculation.
In the Repricer you can fill in your formulas with placeholders or fixed amounts. Placeholders are abbreviations that refer to the price of your product, which can be different prices. When you use a placeholder, the result of this placeholder will be determined per product based on the data of your product.
How do I use them for the Repricer?
With a formula, you can configure your repricer to know exactly when to repriced, with what quantity, and up to how low or high the repricer may go with the prices. In this way, you are in control of exactly when and to what extent the repricer responds to your competitors.
An example of a formula
In your formulas, you can use the abbreviation PV, for example. Which stands for 'product selling price'. If you then enter PV*0,8 in your formula, the price will be multiplied by 0,8.
As an example, does your product have a selling price of €22,90? Then the result of your formula (PV*0,8) will be €18,32. Do you use PV*1.5 in your formula? Then your purchase price is multiplied by 1.5, and the result is €34,35.
Besides placeholders, you can also use fixed amounts or combinations of both. For example (PV*0,8)+500, then you multiply your purchase price by 0,8, and then you add 500 euro cents. Which results in €23,32.
You can use these formulas for your minimum sales price, maximum sales price, the result to adjust your price too, or minimum differences for a price reduction or increase.
If you need help creating or managing your formulas, feel free to contact us. We'll be happy to help you on your way.
Good to know: if you use a placeholder in your formulas, it is also important that this placeholder contains a price for all products. Otherwise, a product will be skipped when it has an empty value in a placeholder.
For example: if you use PI in your formulas, which represents the purchase price, then you should also have a purchase price in your data for all your products. Otherwise, the product will be skipped.