Price format in notification emails

-- HikaShop version -- : 4.7.1
-- Joomla version -- : 4.3.2
-- PHP version -- : 7.4

Dear support,
I correctly see price values in the frontend and in the Orders table in the backend. One euro is for example: 1,00

However, in the notification email, three more zeros are added. In the email template, I just use: {VAR:order.order_full_price}

Can someone advise me?
Kind regards
Lorenzo

Hi,

That's normal. The dynamic tag you're using uses the data coming directly from the database and in the database the order_full_price column of the hikashop_order table has a type with 5 decimals.
Then, HikaShop rounds the price when displaying it to 2 decimals as per your currency settings.
Here, that second part isn't done.
So either:
- edit the structure of the hikashop_order table via your PHPMyAdmin access and change the number of decimals from 5 to 2 for that column.
- instead of using this tag, you could add PHP code like this:

Awesome quick reply. SOLVED