admin管理员组文章数量:1026989
I have code that successfully returns product within a price range. However, I need to also filter by a product attribute called 'size'.
So I should get all products of a certain size between the given price range.
My code works for the price range part, but I can't work out the correct way to add the size part.
Here's my code:
$params = array(
'posts_per_page' => 20,
'post_type' => array('product', 'product_variation'),
'meta_query' => array(
'relation' => 'AND',
array(
array(
'key' => '_price',
'value' => $_POST['product_price_min'],
'compare' => '>=',
'type' => 'NUMERIC'
),
array(
'key' => '_price',
'value' => $_POST['product_price_max'],
'compare' => '<=',
'type' => 'NUMERIC'
)
),
array(
array(
'taxonomy' => 'pa_size',
'field' => 'slug',
'terms' => $_POST['size'],
'operator' => 'IN',
)
)
)
);
$products = new WP_Query($params);
I have code that successfully returns product within a price range. However, I need to also filter by a product attribute called 'size'.
So I should get all products of a certain size between the given price range.
My code works for the price range part, but I can't work out the correct way to add the size part.
Here's my code:
$params = array(
'posts_per_page' => 20,
'post_type' => array('product', 'product_variation'),
'meta_query' => array(
'relation' => 'AND',
array(
array(
'key' => '_price',
'value' => $_POST['product_price_min'],
'compare' => '>=',
'type' => 'NUMERIC'
),
array(
'key' => '_price',
'value' => $_POST['product_price_max'],
'compare' => '<=',
'type' => 'NUMERIC'
)
),
array(
array(
'taxonomy' => 'pa_size',
'field' => 'slug',
'terms' => $_POST['size'],
'operator' => 'IN',
)
)
)
);
$products = new WP_Query($params);
- stackoverflow/questions/44688846/… – rudtek Commented Mar 21, 2019 at 17:38
1 Answer
Reset to default 1Your mixing up your meta query and tax query. try this:
$params = array(
'posts_per_page' => 20,
'post_type' => array('product', 'product_variation'),
'meta_query' => array(
array(
'key' => '_price',
'value' => $_POST['product_price_min'],
'compare' => '>=',
'type' => 'NUMERIC'
),
array(
'key' => '_price',
'value' => $_POST['product_price_max'],
'compare' => '<=',
'type' => 'NUMERIC'
),
),
'tax_query' => array(
array(
'taxonomy' => 'pa_size',
'field' => 'slug',
'terms' => $_POST['size'],
'operator' => 'IN',
)
)
);
$products = new WP_Query($params);
I have code that successfully returns product within a price range. However, I need to also filter by a product attribute called 'size'.
So I should get all products of a certain size between the given price range.
My code works for the price range part, but I can't work out the correct way to add the size part.
Here's my code:
$params = array(
'posts_per_page' => 20,
'post_type' => array('product', 'product_variation'),
'meta_query' => array(
'relation' => 'AND',
array(
array(
'key' => '_price',
'value' => $_POST['product_price_min'],
'compare' => '>=',
'type' => 'NUMERIC'
),
array(
'key' => '_price',
'value' => $_POST['product_price_max'],
'compare' => '<=',
'type' => 'NUMERIC'
)
),
array(
array(
'taxonomy' => 'pa_size',
'field' => 'slug',
'terms' => $_POST['size'],
'operator' => 'IN',
)
)
)
);
$products = new WP_Query($params);
I have code that successfully returns product within a price range. However, I need to also filter by a product attribute called 'size'.
So I should get all products of a certain size between the given price range.
My code works for the price range part, but I can't work out the correct way to add the size part.
Here's my code:
$params = array(
'posts_per_page' => 20,
'post_type' => array('product', 'product_variation'),
'meta_query' => array(
'relation' => 'AND',
array(
array(
'key' => '_price',
'value' => $_POST['product_price_min'],
'compare' => '>=',
'type' => 'NUMERIC'
),
array(
'key' => '_price',
'value' => $_POST['product_price_max'],
'compare' => '<=',
'type' => 'NUMERIC'
)
),
array(
array(
'taxonomy' => 'pa_size',
'field' => 'slug',
'terms' => $_POST['size'],
'operator' => 'IN',
)
)
)
);
$products = new WP_Query($params);
- stackoverflow/questions/44688846/… – rudtek Commented Mar 21, 2019 at 17:38
1 Answer
Reset to default 1Your mixing up your meta query and tax query. try this:
$params = array(
'posts_per_page' => 20,
'post_type' => array('product', 'product_variation'),
'meta_query' => array(
array(
'key' => '_price',
'value' => $_POST['product_price_min'],
'compare' => '>=',
'type' => 'NUMERIC'
),
array(
'key' => '_price',
'value' => $_POST['product_price_max'],
'compare' => '<=',
'type' => 'NUMERIC'
),
),
'tax_query' => array(
array(
'taxonomy' => 'pa_size',
'field' => 'slug',
'terms' => $_POST['size'],
'operator' => 'IN',
)
)
);
$products = new WP_Query($params);
本文标签：
版权声明：本文标题：wp query - Woo Commerce using WP_Query to get products that match price range, with an additional required product attribute 内容由热心网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://it.en369.cn/questions/1745668116a2162293.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。
发表评论