data from wp/woocommerce database
-
Hello
At first I thought that I have quite an easy task to complete, but as it turned out, still too difficult. Maybe somebody can help:
I need to create query in phpMyAdmin that gives me a following result:
Show products that are in orders (all states) list by category. Like if I insert category “cars” then i see a result of orders that has category as cars.
-
Now I have had some progress, I can get object_ID from orders list, searching by category. Now I need additional data:
order number; Object_ID; object name; description; rented from date; rented to date; order status; client name; client aadressI would really appreciate if someone could help me 🙂
MySQL ia have now:
SELECT DISTINCT tr.object_id
FROM iqpe_term_relationships tr
INNER JOIN iqpe_term_taxonomy tt
ON tr.term_taxonomy_id = tt.term_taxonomy_id
INNER JOIN iqpe_terms t
ON tt.term_id = t.term_id
INNER JOIN iqpe_woocommerce_order_itemmeta oim
ON tr.object_id = oim.meta_value
INNER JOIN iqpe_woocommerce_order_items oi
ON oim.order_item_id = oi.order_item_id
INNER JOIN iqpe_posts as o
ON oi.order_id = o.ID
WHERE tt.taxonomy = ‘product_cat’
AND t.slug = ‘jaana-ou’
AND oim.meta_key = ‘_product_id’
AND o.post_type = ‘shop_order’
AND o.post_status IN (‘wc-completed’,’wc-processing’)
The topic ‘data from wp/woocommerce database’ is closed to new replies.
