Duplicate order in the database

Hey there, @davidgimenez! Thanks for contacting us. I’m happy to help you.

Can you please share screenshots of what you are seeing so we can take a look?

You mentioned you are seeing this on the database, correct? But on your dashboard it shows correctly?

Furthermore, I’d like to understand your site properly. Please share with us the necessary information below for us to investigate the issue further:

System Status Report which you can find via WooCommerce > Status > Get system report > Copy for support.
Fatal error logs (if any) under WooCommerce > Status > Logs. Then you can use the selector to search for Fatal Errors.
You could copy and paste your reply here or paste it via https://gist.github.com/ and send the link here.

Looking forward to your reply.

Have a wonderful day!

In my state there are no errors, I checked, there is no log either, just pass what I told you if a user buys a product that order is recorded twice in the database or in the product metadata but nowhere is there any error that I see on my part that happens since I updated with the latest version with each request from the user but in the admin part I don’t get two orders, only one but it is counted as two orders as I mentioned

It also seems that there is an error when the coupon is applied, many users in my store are upset that they apply the coupon and pay and when they get paid, the coupon is not applied to them, that does not happen with all users, it happened like 5 times since I updated the plugin but the strange thing of all is that no error is recorded in any log.

To solve the problem, I went back to a previous version and carried out some tests and it seems that it is no longer duplicated. I am going to wait for more orders from other users to see if the order continues to duplicate.

Hi @davidgimenez,

In my state there are no errors, I checked, there is no log either, just pass what I told you if a user buys a product that order is recorded twice in the database or in the product metadata but nowhere is there any error that I see on my part that happens since I updated with the latest version with each request from the user but in the admin part I don’t get two orders, only one but it is counted as two orders as I mentioned

Did you check whether you’ve enabled HPOS with compatibility mode or not? If yes, then there will be two entries in the database. More info: https://woo.com/document/high-performance-order-storage/

To solve the problem, I went back to a previous version and carried out some tests and it seems that it is no longer duplicated. I am going to wait for more orders from other users to see if the order continues to duplicate.

I’m glad to hear that it was resolved by downgrading!

However, I have a hunch that HPOS might be turned off in your settings. Could you please go to WooCommerce > Settings > Advanced > Feature and check if it’s disabled? If it is, go ahead and enable it. After that, could you check and let us know if you’re seeing double entries or just single ones?

Let us know how that goes. Looking forward to hearing from you soon.

I don’t know what you mean by HPOS, I can’t find something like that in advanced

You cannot activate this option that it asks me for because I have two plugins that are incompatible with that option. but in all the previous versions I had no problems. I have version 8.6.0 and it works well. Version 8.6.1 already has problems with duplicate orders when a purchase is made.

I removed these incompatible plugins so that it allows me to activate and it still does not allow me to activate that option

Next time, if you don’t know what you’re talking about or don’t send me to activate things that shouldn’t be activated, I have more than 9,000 orders in my store and in synchronizing what you sent me a lot of problems, I appreciate the help but this way I don’t prefer to wait 20 versions that screw up my business.

Hi @davidgimenez,

I don’t know what you mean by HPOS, I can’t find something like that in advanced

High-Performance Order Storage (HPOS) is the new database structure that stores order data to improve your store performance.

HPOS is a feature that can potentially cause duplicate orders in the database, so I initially suggested checking its status. However, I understand that you’ve encountered issues when adjusting this setting, and I apologize for that.

More info: https://woo.com/document/high-performance-order-storage/

Version 8.6.1 already has problems with duplicate orders when a purchase is made.

If you previously enabled HPOS with compatibility mode, you’ll find two tables with order information in the database. This is normal and expected behaviour.

However, this shouldn’t create any issue with sales counts or analytics. Did you use any plugin or custom code to show sales counts or using default Analytics options?

Furthermore, given your situation, it seems best to continue using version 8.6.0 without HPOS if it’s working well for your store.

Please don’t hesitate to ask if you need any further assistance.

In making the changes that you told me, a big problem was formed that I solved with a backup copy that I had in making the changes that you mentioned to me as admin, he added orders that I had deleted and he also added my admin email to more of 160 orders from other users and all this is not normal, for that reason I had to restore my site and keep the WooCommerce version at 8.6.0 since the last one causes problems with duplicate orders. I hope that in a next update they will solve that problem so I can continue updating the plugin without having to make those changes that you asked me for since it is creating serious problems for me with the orders

Hi @davidgimenez,

I’m sorry to hear that the update to the latest version has caused some unexpected behavior with your orders and admin email notifications.

This is certainly not the typical experience we aim for and we understand how crucial it is for you to have a reliable system for your orders.

In the meantime, you’ve done the right thing by restoring your site to a previous version that was working well for you. We recommend sticking with this version until we can confidently assure you that the issue has been resolved in a future update.

We appreciate your patience as we work on this.

Hi there ??

Moving forward, should the issue persist, kindly note it’d be necessary to share the site’s System Status Report (SSR), along with logs, and/or further details on how to replicate the issue.

A site’s SSR can be found via WooCommerce > Status. Select Get system report and then Copy for support.

Once you’ve done that, you can paste it here or into our https://quickforget.com/ service and send that secret link here.

We haven’t heard back from you in a while, so I’m going to mark this as resolved – we’ll be here if and/or when you are ready to continue.

• This reply was modified 8 months ago by anastas10s. Reason: typo