Dear all,
I have viertuemart 3.2.2 and joomla 3.7.2. I use indonesian rupiah as currency. I found a problem with the shipping cost. Let say the product price is 300,000 Rupiah. The shipping cost is 150,000. The total is 450,000. After confirm purchase, i clicked on order information or the order history, product price 300000 Rupiah, Shipment Cost 100,000 Rupiah, and the total is 450,000 Rupiah. The total is right. But the shipping cost is 100,000 Rupiah only.
When I tried shipping cost below 100,000 Rupiah, let say 75,000 Rupiah, it has no problem at all. It seems that if the shipping cost is above 100,000 Rupiah, The shipping cost shown will only be 100,000 Rupiah.
Can anyone please help me on this? To try this, you can go to wiradaya.com. i set the shipping cost as 250,000 Rupiah. The total is right. The shipping cost shown only is the problem.
Thanx for your concern.
Fredrick
Hmm, I tried with similar values, but with euro and it worked. So it must be something else.
Thanx Milbo for the reply. I tried on wiradaya.com changing the currency to euro (May be the currency error). the shipping cost i set 250, 000 euro. The result is the same. After confirm order, i clicked order information, and the shipping cost shown is 100,000. But the strange thing the total is right.
Anyone know how to fix this? Please help.. :(
Do you use any custom template that makes rounding for the display?
Jörgen @ Kreativ Fotografi
Thanx Jorgen for your concern.
I use custom template from virtuemarttemplates.net. I have contacted them, but they said that it is not a template issue and they cant help me.
But it is true. When i tried to use beez as my joomla template, the same problem still occurred. The shipment shown is 100,000 which should be 250,000. The total is still correct. Very strange.
Milbo, may i know what virtuemart version you are using? i want to try that version if no problem occurred there.
Thanx.
I am the main developer and therefore I use always the last version.
That would probably be VM 3.2.3.9587
We should not use the term latest version...
regards
Jörgen @ Kreativ Fotografi
It will be 3.2.3.9589 now ..........
Hello Jenkins
I can not find version 3.2.3.9589 for download right now
http://dev.virtuemart.net/projects/virtuemart/files (http://dev.virtuemart.net/projects/virtuemart/files)
regards
Jörgen @ Kreativ Fotografi
In SVN. http://dev.virtuemart.net/projects/virtuemart/repository
Hi Milbo,
I think this is virtuemart bug.
I tried install a fresh joomla 3.7.2 and instal fresh virtuemart 3.2.2 Component, AIO, and tcpdf. No additional installation such as template or other modules involved.
I tested standard shipping cost as 250,000 and the result is the same. 100,000 shown but the total is right..
Anyone has tried this? i really need help for this.
Thank you.
I have tried with swedish krona and I can not see any error.
Could this have something to do with You using Indian rupee ? That there is an error inte conversion module.
regards
Jörgen @ Kreativ Fotografi
I tried it again with united states dollar. but still the same. Fresh installation of virtuemart 3.2.2.
Here I attach The screen shot.. It's really confusing.
Please help anyone..
Thank you.
Hello
I have checked out wiradaya.com, and it seems to work there.
But the template really needs some work...
Attached a screenshot
Jörgen @ Kreativ Fotografi
Hi Jorgen,
That step still has not finished. What i mean is after you confirm purcahse, Thank You page. After that, click "View Your Order" The problem is there. Not on the page you post just now. That page is still okay.
The problem is on the "View Your Order" Page and on the invoice (pdf).
Thank you.
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
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
Milbo. Do you kbow anyone can help me on this bug?
Anyone can help me please?
Thank you.
Anyone know how to solve this problem? I really need solution for this bug.
Thank you.
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
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.
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.