PHP

Where is WooCommerce order shipping methods stored

Here’s a sample SQL query that demonstrates this approach: SELECT MONTH(p.post_date) AS month, pm.meta_value AS shipping_method, COUNT(*) AS order_count FROM wp_posts p JOIN wp_postmeta pm ON p.ID = pm.post_id JOIN wp_woocommerce_order_items oi ON p.ID = oi.order_id WHERE p.post_type=”shop_order” AND pm.meta_key = ‘_shipping_method’ AND p.post_date >= ‘2021-01-01’ AND p.post_date < ‘2022-01-01’ GROUP BY month, shipping_method Replace … Read more

Check for a value in a custom query

After some serious thinking and some trial and error I came up with this solution. Because all data in the query comes from ACF fields I found a way to use the data from these fields to get the result I was looking for using a For loop: // Get the values from the ACF … Read more

+ More