Post by svendaems » Sun Apr 30, 2017 9:57 pm

Hello

I just setup a website with OC 2.3.0.2 and I have a problem with prices that get rounded. I've for example an article that should be prices € 3,50. But when I safe the product in the admin panel, the price get rounded automatically to € 3,00. The only way to show the € 3,50 on the website, is to edit the price in the MySQL database. When you see on the website, it says € 3,50. Even during checkout, it still says € 3,50. But in the confirmation mail, it changes back to € 3,00.

All my prices are excluded taxes, I don't use the tax system in OC.

Does anybody as an idea how I can change this?

Newbie

Posts

Joined
Mon Apr 11, 2016 5:52 pm

Post by opencartmart » Mon May 01, 2017 12:42 am

Could you please try entering dot instead comma? For example, enter 3.50 instead of 3,50
I think you will have to enter with dot instead of comma

XForm - Opencart Form Builder
Xshippingpro - An advanced Shipping Module
Need Professional support? Skype: opencartmart


Active Member

Posts

Joined
Wed Oct 02, 2013 3:59 am

Post by svendaems » Mon May 01, 2017 4:12 am

Thanks for the help bug In tried already that without luck...

Newbie

Posts

Joined
Mon Apr 11, 2016 5:52 pm

Post by svendaems » Mon May 01, 2017 7:42 pm

Small update: in the admin/config.php file, there was an extra line added:
setlocale(LC_ALL, 'nl_NL');

When I removed this line, the price is showed correctly on the website (both in admin pages as in front end). The user sees the correct price during the complete checkout process. Only in the email he gets, he still sees the wrong rounded price.

Newbie

Posts

Joined
Mon Apr 11, 2016 5:52 pm

Post by opencartmart » Thu May 04, 2017 11:45 pm

Since it works well in all places, it should work in email as well.
Are you using any module relating email?

XForm - Opencart Form Builder
Xshippingpro - An advanced Shipping Module
Need Professional support? Skype: opencartmart


Active Member

Posts

Joined
Wed Oct 02, 2013 3:59 am

Post by svendaems » Fri May 05, 2017 2:43 am

I have a module installed that I was planning to use to send newsletters. I will uninstall it, see what happens & let you know. However, I doubt it's something to do with that, because in the database, I see that the total is entered wrong, so even before sending the e-mail.

Newbie

Posts

Joined
Mon Apr 11, 2016 5:52 pm

Post by opencartmart » Fri May 05, 2017 1:26 pm

in which database table?

XForm - Opencart Form Builder
Xshippingpro - An advanced Shipping Module
Need Professional support? Skype: opencartmart


Active Member

Posts

Joined
Wed Oct 02, 2013 3:59 am

Post by svendaems » Fri May 05, 2017 3:41 pm

In the table "oc_order_product", both the column price & total are filled with 3.0000 while it should be 3.5000

Also in the table "oc_order" is the column total filled with 3.0000 instead of 3.5000

Newbie

Posts

Joined
Mon Apr 11, 2016 5:52 pm

Post by opencartmart » Sat May 06, 2017 12:28 am

Can I get a product URL? You can send via private message. thanks

XForm - Opencart Form Builder
Xshippingpro - An advanced Shipping Module
Need Professional support? Skype: opencartmart


Active Member

Posts

Joined
Wed Oct 02, 2013 3:59 am
Who is online

Users browsing this forum: No registered users and 80 guests