[SOLVED] Virtuemart 3.2.2 shipping cost shown max of 100,000 (SOLVED by MILBO)

Started by fredricklamaz, June 20, 2017, 19:25:08 PM

Previous topic - Next topic

Jörgen

Hello

You are absolutely correct, there is some kind of limit of 100 000, but you can add tax,

I tested on Your site and got the result ahown in the added image.

I also tested on my site with 125 000 + tax (25%) = 156 250
But I got 100 000 + tax on 125 0000 = 100 000 + 31 250 = 131 250.

This has probably nothing with the template to do. Funny that the displayed value is affected but not the calculated value.

regards

Jörgen @ Kreativ Fotografi
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

fredricklamaz

Thanx Jorgen..

that is why it is really confusing.. It is a simple bug yet fatal. As customer wont pay the total if the shipment is only 100,000.

Milbo, did you try until the process completed? the pdf is also shown max 100,000.

Anyone has the solution for this? I think must be edited from the php.

Thank you

fredricklamaz

Milbo. Do you kbow anyone can help me on this bug?

Anyone can help me please?

Thank you.

fredricklamaz

Anyone know how to solve this problem? I really need solution for this bug.

Thank you.

Milbo

It took me a while to reproduce it.

It is very strange, the sql "SELECT o.*, o.created_on as order_created, u.*, s.order_status_name FROM #__virtuemart_orders o LEFT JOIN #__virtuemart_orderstates s ON s.order_status_code = o.order_status LEFT JOIN #__virtuemart_order_userinfos u ON u.virtuemart_order_id = o.virtuemart_order_id WHERE o.virtuemart_order_id=yourOrderId"

just returns a 99999.99999, the used database field has DECIMAL(10,2), so it is big enough. I am on it
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Milbo

Just use a bigger decimal in table virtuemart_orders, I set it now in the core to `order_shipment` decimal(12,5), this allows 9 Millionen, that should be enough.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

fredricklamaz

Thanx a lot Milbo.

So sorry i just manage to reply. was out of town, no laptop.

I have tried your solution and it is working really fine now.

I am really thankful you solve this problem. Thanx a lot Milbo.