How to round up prices and create psychological prices in PrestaShop

How to round up prices from PrestaShop admin?

The answer is very quickly, you can't. At the moment, there is no basic function for rounding prices or creating psychological prices with PrestaShop.
So you have to use either a module specialized in price rounding, or use a multi-function module like Merlin.

How to round prices including VAT with the Merlin module.

It's actually really simple. Let's take a look, for example, at how to round up sales prices including VAT before discount for a selection of products:

1. Select the products to be modified, taking care to include the sales price column including VAT.
2. Click on the "Grouped actions" button.
3. Open the rounding tool.
4. Adjust the tool as desired. In the example below, sales prices including VAT will be rounded to x.90cts, to the value closest to the current price. For example, a product worth 12€18, will be reduced to 11€90.
5. Apply, it's immediately effective in store. Please note, there is no automatic rollback possible (always make a backup of your database before making mass changes to your prices).

Choosing the price to round

Round either sales prices including VAT before discount, or sales prices including VAT after discount, i.e. sale prices.

In the first case, the tool will modify the amount of the prices before tax, so that the prices including tax are rounded.
In the second case, the tool will vary the amount of the discount of the specific prices active at the time of the operation, so as to round the prices including tax taking into account this discount.

Note that you can start by rounding the prices including tax before discount, then in the rush the prices including tax after discount. As this does not affect the same parameters, there is no conflict and both will be correctly rounded in the end.

This is exactly the same tool available for rounding down prices. The only difference is in the calculation. In fact, when rounding the pre-discount sales prices of declinations, the program modifies not the sales price excluding VAT of the product, but the price impact excluding VAT of each declination. This allows the program to round off the product's basic sales price (incl. VAT) and the individual sales prices (incl. VAT) of each declination independently.

Rounding accuracy

Six choices are possible:

To the nearest currency

This amounts to removing the centimes.
For example, a price including VAT of 5€56 will be rounded either to 5€ or to 6€ (depending on the third setting).

A 90 centimes

This is a psychological price.
For example, the same price including VAT of 5€56 will be rounded up to either 4€90 or 5€90.

A 99 centimes

This is also a psychological price.
For example, the same price including VAT of 5€56 will be rounded up to either 4€99 or 5€99.

To the nearest tenth

For those who don't like small 1cts coins, we round up to the nearest 10 centimes.
For example, the same price including VAT of 5€56 will be rounded up to either 5€50 or 5€60.

To the nearest 5 centimes, widely used in Switzerland

Our Swiss friends are not allowed to display prices to the nearest centime, they are obliged to round up to at least the nearest tenth or fifth of a centime.
For example the same price including VAT of 5€56 will be rounded up to either 5€55 or 5€60.

To the nearest 50 centimes

History of cutting the pear in two.
For example the same price including VAT of 5€56 will be rounded either to 5€50, or to 6€.

Round down, up or nearest

.

Everyone will choose according to their situation. Lower value to lower all your prices, higher to nibble a little margin, closest to impact current prices as little as possible.

Example:
Always with our price of 5€56, if I want to create psychological prices, so a rounding to 90centimes.

• With the "Lower" choice, the new price will be 4.90€.
• With the "Superior" choice, the new price will be €5.90.
• With the choice "Au plus proche", the new price will also be 5,90€ because 5€56 is closer to 5€90 than to 4€90.

Case of international, multi-currency, multi-VAT sites and multi-shop configurations

As rounding is achieved by modifying the base prices or impacts excluding VAT, defined in the store's default currency.

Or base prices are used to calculate prices excluding VAT and then including VAT in all currencies and all countries. It is therefore not possible to round up base prices including VAT for more than one country and more than one currency at a time.

The only way to obtain rounded final prices in all countries, whatever the VAT rate and currency conversion rate, is to create a specific price for each country, modifying the product's base price excluding VAT. Then use Merlin to round up the VAT-inclusive prices in the specific price table, independently modifying the new base prices for each country/currency.

In the case of multi-shop configurations, remember from the design stage to differentiate your VAT-inclusive prices by store, so you can choose to differentially round up the VAT-inclusive price of common products, depending on the store.
Merlin again will assist you, as its multi-shop mode of operation allows you to modify product prices independently for each store.

Step-by-step tutorial to learn how to round prices and create psychological prices in PrestaShop with the Merlin module (in French)

• Round up product prices.
• Round up prices for variations.
• Round up discounted prices.
• Round up prices for all specific prices.

 Increase the resolution to 720p if the video is too blurry, replay it in Auto if it freezes.