Empty order records

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

You’re right; sometimes, WooCommerce can create customer records when users reach the payment page, even if they don’t complete the order. This can help understanding user behavior and adds to “abandoned cart” data, which can be useful.

While there’s no way to change this behavior on WooCommerce settings, you might be able to do it with custom code or a third-party plugin.

While we can’t provide support for code customization as per our support policy, we do our best to offer advice and direct you to appropriate resources.

You can visit the WooCommerce Facebook group or the #developers channel of the WooCommerce Community Slack. We’re lucky to have a great community of open-source developers for WooCommerce, and many of our developers hang out there too.

If you rather checkout plugin options, you can search on the Plugins > Add New section of your dashboard or on a search engine like Google, for example.

Please note that we also do not provide support for third-party plugins, so it is good to check the plugin thoroughly to see if it is reliable. You can find more about this in this guide.

I hope this was clarifying. Please let us know if there’s anything else we can do to help or if you have any questions.

Have a wonderful day!

Hello, thank you for your response. @carolm29

In which table are empty customer order records created? Which analysis tables?

Yes, this may contribute to abandoned data, but let’s also consider that a malicious user or bot can make tens of thousands of transactions this way. This creates a huge load on the database and server. Actually, I think this is also a security issue. Am I thinking wrong?

Also, I’m curious about this. Does Woocommerce analysis data create a different record in the database? Or is it just reading existing data? (When controlled from the admin panel)

Hello thecreator01

Thank you for your reply.

From WooCommerce version 8.2 onwards, orders are stored in the “wc_orders” tables within the database. When a customer initiates the checkout process but does not complete it, a new record with the status ‘pending’ or ‘failed’ might be created. These records are important for tracking and managing incomplete transactions.

Concerns about bots creating a large number of abandoned transactions are understandable, but it’s unlikely for a bot to perform all the necessary actions to reach the Checkout page and then abandon the cart. Additionally, many web hosting providers implement bot protection to prevent such scenarios, reducing the potential load on your database and server.

While we have not encountered reports of such behavior causing security issues or performance concerns, please rest assured that if you do face any unusual activities on your site, we are happy to assist you in resolving the matter.

Regarding WooCommerce analysis, the system reads the existing data from the database to perform any analytical functions.

I hope this information helps address your concerns. ??

Best regards.

Hello, thank you very much for your help @doublezed2

Hi @thecreator01

I’m glad we were able to help! I will mark this thread as resolved. Should you have further inquiries, kindly create a new topic here.

Thanks!