So the function below will return an array of all orders IDs for a given product ID, making the right SQL query: /** * Get All orders IDs for a given ...
I'm trying to obtain all orders for particular day/time and then order products using SQL (MySQL) as seen in the query below: select p.ID as order_id, p.post_date, ...
The only bit I don't understand is that 'menu_order' => 'ASC' doesn't seem to work . I doesn't' matter what I type as menu order in the product ...
Unfortunately, this is more complicated than just using WP_Query to grab orders. My Solution. The woocommerce_order_items has a reference to ...
Updates: 2017 - SQL query changed to "SELECT DISTINCT" instead of "SELECT " to avoid duplicated Order IDs in the array (then no need of ...
fill out this pre-sales form – please include the name of this extension in your query.
' Product Name' but can you tell me how can I extract all orders done per product ID.
As your business grows and orders begin to come in, the amount of data
It follows a similar structure to WP_Query . Note that I've just requested the IDs, in order to make the query a lot lighter, and the very neat and ...