Round product prices in Magento 2 (Magento Open Source 2, Adobe Commerce)

The role of Magento 2 (Magento Open Source 2, Adobe Commerce) price rounding is essential when online merchants calculate and plan pricing strategies. It is impossible to underestimate or overlook this operation, since, according to the recent studies, products with rounded prices are more psychologically appealing to your potential customers.

A rounded price ($100.00) encourages consumers to rely on feelings when evaluating products, while a non-rounded price ($97.86) encourages consumers to rely on reason.

So if you want to adjust prices for multiple goods at once, it might be a problem. In case products are priced differently it would be difficult as by default in Magento 2 (Magento Open Source 2, Adobe Commerce) there is no a possibility to adjust them in bulk.

You can remove decimal price in Magento 2 (Magento Open Source 2, Adobe Commerce) without touching the core or any coding. Store Manager for Magento application is the tool designed to enable better price rounding management.

Let’s analyze the use of rounding function available in Store Manager for Magento by applying it to real-life examples.

Round Magento 2 (Magento Open Source 2, Adobe Commerce) Prices to the Nearest Whole Number

Who needs cents anyway? This is especially true for online purchases. You can display rounded price without change, like $49.00 instead of $49.36 or $35.00 instead of $34.73 etc.

To round prices with Store Manager for Magento you first need to select goods for which you want to adjust cost. After that you can use Multi-Editor tool built in the application. You can launch it via context menu or from product toolbar: Multi Editor's -> Product Multi Editor.

When new window is opened, switch to Prices tab. There you will see special Expression option in front of each attribute. Click on buttons with 3 dots to open ‘Expression Editor’.

There you can input the formula that allows to round prices for selected goods to the nearest whole number. If we want to modify current price the function will be the following:

After you input the formula do not forget to tick update box next to field you want to update.

The Rounding Rules

This function actually rounds product price according to mathematical rounding rules. It means that if the product decimals are up to or equal to .5 - the value will be rounded to smaller value, if more than .5 - to bigger one.

So, if you have 2 products priced $49.5 and $49.7, after you apply the formula, the value will be changed to $49 for the first item and to $50 for the second.

Round and Set Smart Price

There is also a possibility of using delta round operations not only for base, but also for special price calculation.

Suppose, that you need to set special price, rounding regular one and make smart price, so it could end in the nearest, .99 value.

For this you can use the ROUND function then subtract .01. So the formula to apply in ‘Special price’ field of Multi-Editor will be the following:

If you already have special price value you want to adjust, use this function:

Note: For higher decimal precision, when you want to replace zero cents with 0.99, adding 99 cents additionally to the total, you can use the following formula:

Price Rounding During Import

Now let us assume, that supplier has provided you in the file prices that you want to round. You can do it on-the-fly right during import with Store Manager for Magento.

At the step of mapping file columns to database names next to each field you assign, there is also option that allows to apply expression formula. This way you can make changes right during import without manual file editing and recalculation.

For import, the formula round prices will be the following:

Where INDEX is the number of column in your file where product prices.

Related Articles:

7 Examples of Most Widely-Used Magento Promotions

Explanation of most often used Magento promotions (Buy 1 Get 1, Free shipping etc) and guidance on their configuration. Read More...

How to Make Price Reductions in Magento

Learn the types of Magento reductions (special price, group price, tier price) and find out how to properly configure them. Read More...

How to Import Group Prices in Magento?

Check how you can use customer groups for different pricing, find out group price restrictions and get guides on adding group prices to Magento products. Read More...

Add Percentage Margin on the Price in Magento

Figure out how to add profit margin to prices durng import (add the same markup percentage, increase final price basing on cost price). Read More...