Since updating to 6.9.4, the orders that come through have items in the cart that the customer did not order. These items show up on the invoice. Typically the items are first in the list and are not in the pricing. The customers say they did not place the items in the cart. Any ideas on how to fix this?

Thanks,
Perry

Hi Perry
I've seen this before when the database had been re-used. What happened was that someone reset the orders table so it started the AUTO_INCREMENT in the ordID from 1 again, but didn't clear the cart table. This meant that each new order already had items in the cart. Could something like that have happened? Also, what version had you updated from?

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

Vince,
I guess it's possible that could have happened to the database. I think I upgrade from 6.7.1. Is there a halfway easy fix for the database if the is the problem?

I just looked at the database and in ordID it does have AUTO_INCREMENT.

What you need to do is look up the highest order ID that exists in the cart table and then set the the auto increment value higher than that value in the orders table.

But really the database needs checking thoroughly before you start making changes like that.

You may want to use this ECT service here - https://www.ecommercetemplates.com/Database-Health-Check or send me an email and I'll take a look and work out a price for you.



* Database Migrations and Conversions*
* ASP to PHP Cart Conversions*
*Contact Us*
*Buy The PHP Capture Card Plugin*
*Rate Our Services/View Our Feedback*