fast queries to retrieve products on orders (since WooCommerce 3.7).
It looks like when I try to query wp_woocommerce_order_itemmeta table for ordered products data I'm loosing connection to a database (connection timed out ...
Could anyone provide an example query to get all orders by a certain category? I know this will probably involve wp_woocommerce_order_items ...
I know that a woocommerce purchase is a custom post type called shop order, what I don't know is what column identifies the specific product, ...
IDs of orders related to a subscription, a database query is run against the source ...
Non-performant PHP code,; Non-performant database queries, and; Slow- loading of files.
A client of mine has a rather large WooCommerce database.
(For example, if your site sells CBD oil products.)
You're facing database issues. During the life of your WooCommerce site, your database is going to store a lot of information: products, orders, ...
Behold: Our guide on how to export WooCommerce orders, products