WooCommerce: Select all products with price <15

Check all products with price under 15.

Run this query on phpmyAdmin in your wordpress Database.


SELECT p.ID, p.post_title, pm.meta_value
FROM wp_posts as p
INNER JOIN wp_postmeta as pm ON pm.post_id = p.ID

WHERE pm.meta_value < 15
AND pm.meta_key= "_regular_price"
AND p.post_type = "product"
AND p.post_status = "publish"