### Author Topic: [SOLVED] Virtuemart 3.2.2 shipping cost shown max of 100,000 (SOLVED by MILBO)  (Read 964 times)

#### Jörgen

• Global Moderator
• Full Member
• Posts: 1097
• VirtueMart Version: 3.2.5
##### Re: Virtuemart 3.2.2 shipping cost shown max of 100,000
« Reply #15 on: July 04, 2017, 16:02:30 pm »
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.8.1
Virtuemart 3.2.5
Olympiantheme Hera (customized)

#### fredricklamaz

• Beginner
• Posts: 10
• A beginner
##### Re: Virtuemart 3.2.2 shipping cost shown max of 100,000
« Reply #16 on: July 05, 2017, 10:22:26 am »
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

• Beginner
• Posts: 10
• A beginner
##### Re: Virtuemart 3.2.2 shipping cost shown max of 100,000
« Reply #17 on: July 06, 2017, 21:26:55 pm »
Milbo. Do you kbow anyone can help me on this bug?

Anyone can help me please?

Thank you.

#### fredricklamaz

• Beginner
• Posts: 10
• A beginner
##### Re: Virtuemart 3.2.2 shipping cost shown max of 100,000
« Reply #18 on: July 11, 2017, 13:10:08 pm »
Anyone know how to solve this problem? I really need solution for this bug.

Thank you.

#### Milbo

• Virtuemart Projectleader
• Administrator
• Super Hero
• Posts: 9372
• VM3.2 Cached and Optimized
• VirtueMart Version: VirtueMart 3 on joomla 3
##### Re: Virtuemart 3.2.2 shipping cost shown max of 100,000
« Reply #19 on: July 12, 2017, 13:41:37 pm »
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
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

#### Milbo

• Virtuemart Projectleader
• Administrator
• Super Hero
• Posts: 9372
• VM3.2 Cached and Optimized
• VirtueMart Version: VirtueMart 3 on joomla 3
##### Re: Virtuemart 3.2.2 shipping cost shown max of 100,000
« Reply #20 on: July 12, 2017, 15:11:47 pm »
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.
I should fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

#### fredricklamaz

• Beginner
• Posts: 10
• A beginner
##### Re: Virtuemart 3.2.2 shipping cost shown max of 100,000 (SOLVED by MILBO)
« Reply #21 on: July 21, 2017, 10:26:20 am »
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.