| Author |
 Topic  |
|
|
[email protected]
VP-CART New User
149 Posts |
 Posted - July 22 2015 : 12:33:57
|
Hi,
I was hoping 8.0.0.9 was going to solve this problem for me but it still persists.
I keep getting a calculation error on shopaddtocart.asp
For example:
Item cost: $9.99 In cart, it shows: $9.98
So already, it throws off paypal express which says the total is invalid.
But it gets weirder.
If I have a quantity of 3 of that item
it *should* show up as 3x9.99 (29.97)
but since, in the cart, it *should* show it (incorrectly) for $9.98: 3x$9.98 = 29.94
but it doesn''t. It lists it as $9.98 but the x3 total is 29.96 which doesn''t fit the math of 3x9.99 nor 3x9.98
And also, the code still tries to show tax on a product page even when someone is not logged in. This should not happen because there is no way of basing the tax if they are a guest so it throws this error
Microsoft VBScript runtime error ''800a000d''
Type mismatch: ''csng''
/shopping2/shoptax.asp, line 228
which prevents the rest of the page from being loaded and no one can order anything unless they realize that it will work after they''ve logged in. (a temporary solution for me is to rip out of the tax field from being displayed on the product page).
|
Edited by - [email protected] on August 25 2015 09:46:23 |
|
|
[email protected]
VP-CART New User
149 Posts |
Posted - July 22 2015 : 12:38:52
|
| (Incidentally, even orders that appear correct in the cart...example: item listed 29.95, shows up in the cart as 29.95 yet still, the paypal express is producing a "10401 : Order total is invalid" error) |
 |
|
|
[email protected]
VP-CART New User
149 Posts |
Posted - July 22 2015 : 14:30:46
|
Also, if it helps with troubleshooting...this only happens when a price has a cents value to it (particularly in the pennies).
Items that are listed by dime (eg .50 or .80) or a full dollar amount (eg: $35, $129) work perfectly fine. This only occurs when the penny in the price is anything other than a 0 |
|
|
|
support
Administrator
4679 Posts |
Posted - July 22 2015 : 23:11:40
|
Unfortunately, we are unable to replicate this.
Can you please post this into our helpdesk ticket at https://helpdesk.vpasp.com/ and provide us your FTP login details, so our developer can try to check your files.
Thank you.
Wilson
VPCart Support |
|
|
|
jbutt
VP-CART New User
USA
56 Posts |
Posted - July 23 2015 : 23:22:41
|
Hi Sunshore,
Are you using the discount feature of VPCART to calculate percentages or flat rate discounts to an item/user? How many decimal points are you using?
Regards,
John |
|
|
|
[email protected]
VP-CART New User
149 Posts |
Posted - August 11 2015 : 15:28:11
|
I figured out one of the two problems (the price amounts changing).
Our data types on currency fields (cprice, otax, odiscounts, and such) were FLOAT when it should have been DOUBLE.
Switching to DOUBLE worked out just fine.
I would prefer to use something more precise like DECIMAL but the code throws errors so DOUBLE will have to do.
It fixed pretty much everything.
As for the csng error where taxes for a product are being shown (which works properly when someone is logged in but throws an error when someone is not logged in) was resolved simply by deleting tax from being displayed on the products page (by the time they see tax in the cart, it is during checkout so they will have been logged in). |
|
|
|
support
Administrator
4679 Posts |
Posted - August 12 2015 : 22:21:09
|
Hi there,
Thanks for this!
Based on your update we will make some changes to the core package.
if you like we can apply them to your site for you for you to test.
If interested just post a ticket in the helpdesk and we will make the update for you.
Thanks
Cam Flanigan
VPCart Support |
|
|
|
[email protected]
VP-CART New User
149 Posts |
Posted - August 18 2015 : 14:53:19
|
Hi Cam,
What are you updating in the core files?
Is it about the database data types?
Or the csng tax error when someone isn''t logged in? |
|
|
|
support
Administrator
4679 Posts |
Posted - August 19 2015 : 05:01:53
|
All of the above. 
Thanks
Cam Flanigan
VPCart Support |
|
|
| |
Topic |
|
All Forums
[solved] Off by pennies, also tax error
New Topic
Printer Friendly
TrustGuard - PCI Security Scanner
