MAJOR issue, orders are incorrect

I believe that’s related to this issue: https://github.com/woocommerce/woocommerce/issues/18561

The problem should be fixed in WC 3.3 (released today).

I’ve also seen issues similar to this caused by:

1) Caching
2) A corrupted / inaccurate database

For the first, make sure all caching plugins and your web hosts are following the suggestions here: https://docs.woocommerce.com/document/configuring-caching-plugins/

For the second, make sure you don’t have any development/test sites that are connected to your live sites database. And then aside from that, have you ever done order importing/exporting on this site? If so, it’s possible something went wrong during an import and there are inaccurate database entries for order that are yet-to-be.

Thank you for the fast response. I took a look at that thread, and while my issue sounds similar, unfortunately I think it is different. I wish I could reproduce my issue more definitively. The steps listed in that thread do not work for me to reproduce their issue either; additionally my sessions table does not have any empty session_key fields. Also, if the session was actually someone elses that got shared, wouldn’t the product that was ordered be listed twice in the sessions table? (since I have no empty session keys). Not only was the product that ended up being ordered not listed even once in the entire table, the session for the customer did not have any products in it at all…

@mumme1msncom, when you get a chance, go over my reply as well.

I’ve debugged quite a few similar issues and it was always one of those two things.

@icaleb
Thank you Caleb for your response. Varnish is not relevant to the server setup, we do not use a plugin for caching and I have excluded the cart and checkout from the cache.
The development site has it’s own database, so that also cannot be it either. So I guess that leaves a corrupt/inaccurate database. We did import the database from a different host, but that was 3 or 4 years ago, nothing imported since that time. Do you have any information for me on how to troubleshoot for a corrupt/inaccurate database? Thank you again for your time, this has been a very difficult issue to troubleshoot. Customers being charged for things they didn’t order it will have a negative effect on the sites reputation, so I am trying to get this resolved for good.

• This reply was modified 6 years, 10 months ago by melmmm.
• This reply was modified 6 years, 10 months ago by melmmm.

This will require some digging in. Would you mind opening up a ticket at https://woocommerce.com/my-account. Mention this forum thread please ??

Update, we rolled back to version 3.1.1 and have not seen the issue, doesn’t this mean it is not a database issue? There is no way for me to open a ticket in my account area, can you provide an email or something else?

@icaleb I spoke too soon, just got an email from a customer upset about being charged for $400 of stuff he did not order… so it is still happening. ?? Can you please give me some ideas for what I am looking for in the database? We need to get this resolved asap. If it helps, an admin said that when he was adding new products to the store, items were randomly being added to his cart, he would clear his cart, start adding new products, and then go look at his cart and it was full of random products again.

Did you submit a ticket for the support team to take a closer look? Please remember to put a link to this forum thread.

Hello,

Was there any resolution to this issue? We have been having the same issue and it started around the same time as yours. It wasn’t too bad up until recently. Any advice or suggestions would be appreciated.

Also having major issues similar to this (version 4.9.8 WP, Woocommerce Version 3.4.5)

This client website https://sky-baby.pipeten.co.uk only has one product (mattress, 29.99) but a random old version of the product (mattress 24.99) keeps getting added at checkout, does;t appear in basket or at checkout but only at order confirmation stage and in emails. Customer is charged correct amount ￡29.99. Doesn’t appear to happen with first order just subsequent ones. Have tried disabling all plugins, caching, optimising database, can’t find the rogue product in the database. Anyone else had this and found a fix? Have been poking around for hours on this. Help!!

Our issue was resolved by either modifications to a third party firewall or forcing the database to update, we did both at the same time so I can’t be sure, but I think it was the later. To force the Woo database update we rolled back the version of Woo via ftp and then updated it through the dashboard which triggered the database update, which was successful.

It sounds like you might have something similar, though my clients customers were being charged for products they did not order, as opposed to getting the correct charge but seeing the incorrect products on confirmation… At any rate I would try rolling back and re-updating and if that does not work you could look at the product fields in your database and delete any old entries. Or since you only have only one product you could remove Woo altogether, making sure the database is clear of any woo tables, and then re-install it…

• This reply was modified 6 years, 1 month ago by melmmm.

@marthast I seem to have the exact same problem. Did you find a solution for this?