close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Totals do not match cart contents!

Thread began 4/17/2013 3:06 am by mrs | Last modified 4/17/2013 7:42 am by Jason Byrnes | 585 views | 3 replies |

mrs

Totals do not match cart contents!

I have just received an email from my customer about cart totals not matching up to what has been purchased. Please see attached for details. The products ordered down the right side add up to one amount which is equal to the subtotal, but the overall total including shipping is almost twice the price, but not quite. The tax at 20% is also wrong. The total should come to 53.46 including shipping, not 85.30

I've been through the database and looked at all products listed in the products table related to this purchase, and they don't have any prices applied to other fields such as discount prices... just prices in the column ProductPrice.

What's happening here?

Sign in to reply to this post

mrs

Just had a brain wave and found the problem!

The amount of products order in the table orderdetails was greater than those on display. Having looked at the code on the page, it was showing only five items when seven had been ordered, so the repeat region on the page wasn't displaying all products.

Looking at the repeat region code for the recordset though, it seems to have a repeat of 5 which then wraps to another page should the amount of products in the cart be greater than 5... so it looks to be creating a paging effect, but that doesn't show on the admin page.

$maxRows_WADAorderdetails = 5;
$pageNum_WADAorderdetails = 0;

Is this code correct?

I've overcome my problem by changing 5 to 500. If somebody has the time to order 500 individual products in one go, then they have issues!

Sign in to reply to this post

Jason ByrnesWebAssist

Thank you for reporting this issue, i have logged the problem in our bugbase to corrected in an update.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...