Mixing
Filter products by custom product attribute et post meta data in a WP_Query
3
I have already filtered by category, but don't know how to filter products by custom attributes or meta values
code:
$key="naam"; //custom attribute name
$value="test";// custom value
$query_custom = array('key' => $key, 'value' => $value);
$meta_query = $query_custom ;
$args=array('meta_query'=>$meta_query, 'product_cat' => 'activiteiten','posts_per_page' => 10,'post_type' => 'product');
$loop = new WP_Query( $args );
`
php wordpress loops woocommerce product
edited Jan 2 at 12:41
LoicTheAztec
94.2k1367107
asked Jan 2 at 10:48
td devtd dev
163
add a comment |
3
I have already filtered by category, but don't know how to filter products by custom attributes or meta values
code:
$key="naam"; //custom attribute name
$value="test";// custom value
$query_custom = array('key' => $key, 'value' => $value);
$meta_query = $query_custom ;
$args=array('meta_query'=>$meta_query, 'product_cat' => 'activiteiten','posts_per_page' => 10,'post_type' => 'product');
$loop = new WP_Query( $args );
`
php wordpress loops woocommerce product
edited Jan 2 at 12:41
LoicTheAztec
94.2k1367107
asked Jan 2 at 10:48
td devtd dev
163
add a comment |
3
3
3
I have already filtered by category, but don't know how to filter products by custom attributes or meta values
code:
$key="naam"; //custom attribute name
$value="test";// custom value
$query_custom = array('key' => $key, 'value' => $value);
$meta_query = $query_custom ;
$args=array('meta_query'=>$meta_query, 'product_cat' => 'activiteiten','posts_per_page' => 10,'post_type' => 'product');
$loop = new WP_Query( $args );
`
php wordpress loops woocommerce product
edited Jan 2 at 12:41
LoicTheAztec
94.2k1367107
asked Jan 2 at 10:48
td devtd dev
163
I have already filtered by category, but don't know how to filter products by custom attributes or meta values
code:
$key="naam"; //custom attribute name
$value="test";// custom value
$query_custom = array('key' => $key, 'value' => $value);
$meta_query = $query_custom ;
$args=array('meta_query'=>$meta_query, 'product_cat' => 'activiteiten','posts_per_page' => 10,'post_type' => 'product');
$loop = new WP_Query( $args );
`
php wordpress loops woocommerce product
php wordpress loops woocommerce product
edited Jan 2 at 12:41
LoicTheAztec
94.2k1367107
asked Jan 2 at 10:48
td devtd dev
163
edited Jan 2 at 12:41
LoicTheAztec
94.2k1367107
asked Jan 2 at 10:48
td devtd dev
163
edited Jan 2 at 12:41
LoicTheAztec
94.2k1367107
edited Jan 2 at 12:41
LoicTheAztec
94.2k1367107
edited Jan 2 at 12:41
LoicTheAztec
94.2k1367107
94.2k1367107
asked Jan 2 at 10:48
td devtd dev
163
asked Jan 2 at 10:48
td devtd dev
163
asked Jan 2 at 10:48
td devtd dev
163
163
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
1
You can achieve using following code.
$args = array(
'meta_query'=> array(
array(
'key' => 'vote', // here use your field name
'compare' => '=', // comparison sign
'value' => 5, // value using that you can search
)
),
'product_cat' => 'activiteiten',
'posts_per_page' => 10,
'post_type' => 'product'
) );
query_posts( $args ); // get all the posts data using above filter.
query_posts is used to find out the posts with list of arguments meta_query is used in your case to find the matched custom field data.
answered Jan 2 at 10:58
dipmaladipmala
1,64411217
Code only answers arent encouraged as they dont provide much information for future readers please provide some explanation to what you have written
– WhatsThePoint
Jan 2 at 11:40
thanks for answer! but it does not work
– td dev
Jan 2 at 11:40
add a comment |
1
Here is a working example of a query involving:
- product category filtering
- post meta value filtering (meta query)
- product attribute value filtering (tax query)
The code:
$products = new WP_Query( array(
'posts_per_page' => 10,
'post_type' => 'product',
'post_status' => 'publish',
// 1. Product category filter
'product_cat' => 'clothing',
// 2. The Post meta query part (filtering by post meta value)
'meta_query' => array( array(
'key' => '_price',
'value' => 5,
'type' => 'numeric',
'compare' => '>',
), ),
// 3. The taxonomy meta query part (filtering by term values)
'tax_query' => array( array(
'taxonomy' => 'pa_color', // Product attribute taxonomy: always start with 'pa_'
'field' => 'slug', // Can be 'term_id', 'slug' or 'name'
'terms' => array('blue'),
), ),
) );
// Testing output
if( $products->have_posts() ) :
echo '<ul>'
while ( $products->have_posts() ) : $products->the_post();
echo '<li class="post-id-' . get_the_id() . '">' . get_the_title() . '</li>';
endwhile;
wp_reset_postdata();
echo '</ul>'
endif;
Tested and working:
Official reference documentation for Wordpress WP_Query:
WP_Queryand Custom fields parameters
WP_Queryand Taxonomy parameters
answered Jan 2 at 12:41
LoicTheAztecLoicTheAztec
94.2k1367107
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54004962%2ffilter-products-by-custom-product-attribute-et-post-meta-data-in-a-wp-query%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
You can achieve using following code.
$args = array(
'meta_query'=> array(
array(
'key' => 'vote', // here use your field name
'compare' => '=', // comparison sign
'value' => 5, // value using that you can search
)
),
'product_cat' => 'activiteiten',
'posts_per_page' => 10,
'post_type' => 'product'
) );
query_posts( $args ); // get all the posts data using above filter.
query_posts is used to find out the posts with list of arguments meta_query is used in your case to find the matched custom field data.
answered Jan 2 at 10:58
dipmaladipmala
1,64411217
Code only answers arent encouraged as they dont provide much information for future readers please provide some explanation to what you have written
– WhatsThePoint
Jan 2 at 11:40
thanks for answer! but it does not work
– td dev
Jan 2 at 11:40
add a comment |
1
You can achieve using following code.
$args = array(
'meta_query'=> array(
array(
'key' => 'vote', // here use your field name
'compare' => '=', // comparison sign
'value' => 5, // value using that you can search
)
),
'product_cat' => 'activiteiten',
'posts_per_page' => 10,
'post_type' => 'product'
) );
query_posts( $args ); // get all the posts data using above filter.
query_posts is used to find out the posts with list of arguments meta_query is used in your case to find the matched custom field data.
answered Jan 2 at 10:58
dipmaladipmala
1,64411217
Code only answers arent encouraged as they dont provide much information for future readers please provide some explanation to what you have written
– WhatsThePoint
Jan 2 at 11:40
thanks for answer! but it does not work
– td dev
Jan 2 at 11:40
add a comment |
1
1
1
You can achieve using following code.
$args = array(
'meta_query'=> array(
array(
'key' => 'vote', // here use your field name
'compare' => '=', // comparison sign
'value' => 5, // value using that you can search
)
),
'product_cat' => 'activiteiten',
'posts_per_page' => 10,
'post_type' => 'product'
) );
query_posts( $args ); // get all the posts data using above filter.
query_posts is used to find out the posts with list of arguments meta_query is used in your case to find the matched custom field data.
answered Jan 2 at 10:58
dipmaladipmala
1,64411217
You can achieve using following code.
$args = array(
'meta_query'=> array(
array(
'key' => 'vote', // here use your field name
'compare' => '=', // comparison sign
'value' => 5, // value using that you can search
)
),
'product_cat' => 'activiteiten',
'posts_per_page' => 10,
'post_type' => 'product'
) );
query_posts( $args ); // get all the posts data using above filter.
query_posts is used to find out the posts with list of arguments meta_query is used in your case to find the matched custom field data.
answered Jan 2 at 10:58
dipmaladipmala
1,64411217
edited Jan 2 at 11:45
answered Jan 2 at 10:58
dipmaladipmala
1,64411217
answered Jan 2 at 10:58
dipmaladipmala
1,64411217
answered Jan 2 at 10:58
dipmaladipmala
1,64411217
1,64411217
Code only answers arent encouraged as they dont provide much information for future readers please provide some explanation to what you have written
– WhatsThePoint
Jan 2 at 11:40
thanks for answer! but it does not work
– td dev
Jan 2 at 11:40
add a comment |
Code only answers arent encouraged as they dont provide much information for future readers please provide some explanation to what you have written
– WhatsThePoint
Jan 2 at 11:40
thanks for answer! but it does not work
– td dev
Jan 2 at 11:40
Code only answers arent encouraged as they dont provide much information for future readers please provide some explanation to what you have written
– WhatsThePoint
Jan 2 at 11:40
Code only answers arent encouraged as they dont provide much information for future readers please provide some explanation to what you have written
– WhatsThePoint
Jan 2 at 11:40
thanks for answer! but it does not work
– td dev
Jan 2 at 11:40
thanks for answer! but it does not work
– td dev
Jan 2 at 11:40
add a comment |
1
Here is a working example of a query involving:
- product category filtering
- post meta value filtering (meta query)
- product attribute value filtering (tax query)
The code:
$products = new WP_Query( array(
'posts_per_page' => 10,
'post_type' => 'product',
'post_status' => 'publish',
// 1. Product category filter
'product_cat' => 'clothing',
// 2. The Post meta query part (filtering by post meta value)
'meta_query' => array( array(
'key' => '_price',
'value' => 5,
'type' => 'numeric',
'compare' => '>',
), ),
// 3. The taxonomy meta query part (filtering by term values)
'tax_query' => array( array(
'taxonomy' => 'pa_color', // Product attribute taxonomy: always start with 'pa_'
'field' => 'slug', // Can be 'term_id', 'slug' or 'name'
'terms' => array('blue'),
), ),
) );
// Testing output
if( $products->have_posts() ) :
echo '<ul>'
while ( $products->have_posts() ) : $products->the_post();
echo '<li class="post-id-' . get_the_id() . '">' . get_the_title() . '</li>';
endwhile;
wp_reset_postdata();
echo '</ul>'
endif;
Tested and working:
Official reference documentation for Wordpress WP_Query:
WP_Queryand Custom fields parameters
WP_Queryand Taxonomy parameters
answered Jan 2 at 12:41
LoicTheAztecLoicTheAztec
94.2k1367107
add a comment |
1
Here is a working example of a query involving:
- product category filtering
- post meta value filtering (meta query)
- product attribute value filtering (tax query)
The code:
$products = new WP_Query( array(
'posts_per_page' => 10,
'post_type' => 'product',
'post_status' => 'publish',
// 1. Product category filter
'product_cat' => 'clothing',
// 2. The Post meta query part (filtering by post meta value)
'meta_query' => array( array(
'key' => '_price',
'value' => 5,
'type' => 'numeric',
'compare' => '>',
), ),
// 3. The taxonomy meta query part (filtering by term values)
'tax_query' => array( array(
'taxonomy' => 'pa_color', // Product attribute taxonomy: always start with 'pa_'
'field' => 'slug', // Can be 'term_id', 'slug' or 'name'
'terms' => array('blue'),
), ),
) );
// Testing output
if( $products->have_posts() ) :
echo '<ul>'
while ( $products->have_posts() ) : $products->the_post();
echo '<li class="post-id-' . get_the_id() . '">' . get_the_title() . '</li>';
endwhile;
wp_reset_postdata();
echo '</ul>'
endif;
Tested and working:
Official reference documentation for Wordpress WP_Query:
WP_Queryand Custom fields parameters
WP_Queryand Taxonomy parameters
answered Jan 2 at 12:41
LoicTheAztecLoicTheAztec
94.2k1367107
add a comment |
1
1
1
Here is a working example of a query involving:
- product category filtering
- post meta value filtering (meta query)
- product attribute value filtering (tax query)
The code:
$products = new WP_Query( array(
'posts_per_page' => 10,
'post_type' => 'product',
'post_status' => 'publish',
// 1. Product category filter
'product_cat' => 'clothing',
// 2. The Post meta query part (filtering by post meta value)
'meta_query' => array( array(
'key' => '_price',
'value' => 5,
'type' => 'numeric',
'compare' => '>',
), ),
// 3. The taxonomy meta query part (filtering by term values)
'tax_query' => array( array(
'taxonomy' => 'pa_color', // Product attribute taxonomy: always start with 'pa_'
'field' => 'slug', // Can be 'term_id', 'slug' or 'name'
'terms' => array('blue'),
), ),
) );
// Testing output
if( $products->have_posts() ) :
echo '<ul>'
while ( $products->have_posts() ) : $products->the_post();
echo '<li class="post-id-' . get_the_id() . '">' . get_the_title() . '</li>';
endwhile;
wp_reset_postdata();
echo '</ul>'
endif;
Tested and working:
Official reference documentation for Wordpress WP_Query:
WP_Queryand Custom fields parameters
WP_Queryand Taxonomy parameters
answered Jan 2 at 12:41
LoicTheAztecLoicTheAztec
94.2k1367107
Here is a working example of a query involving:
- product category filtering
- post meta value filtering (meta query)
- product attribute value filtering (tax query)
The code:
$products = new WP_Query( array(
'posts_per_page' => 10,
'post_type' => 'product',
'post_status' => 'publish',
// 1. Product category filter
'product_cat' => 'clothing',
// 2. The Post meta query part (filtering by post meta value)
'meta_query' => array( array(
'key' => '_price',
'value' => 5,
'type' => 'numeric',
'compare' => '>',
), ),
// 3. The taxonomy meta query part (filtering by term values)
'tax_query' => array( array(
'taxonomy' => 'pa_color', // Product attribute taxonomy: always start with 'pa_'
'field' => 'slug', // Can be 'term_id', 'slug' or 'name'
'terms' => array('blue'),
), ),
) );
// Testing output
if( $products->have_posts() ) :
echo '<ul>'
while ( $products->have_posts() ) : $products->the_post();
echo '<li class="post-id-' . get_the_id() . '">' . get_the_title() . '</li>';
endwhile;
wp_reset_postdata();
echo '</ul>'
endif;
Tested and working:
Official reference documentation for Wordpress WP_Query:
WP_Queryand Custom fields parameters
WP_Queryand Taxonomy parameters
answered Jan 2 at 12:41
LoicTheAztecLoicTheAztec
94.2k1367107
answered Jan 2 at 12:41
LoicTheAztecLoicTheAztec
94.2k1367107
answered Jan 2 at 12:41
LoicTheAztecLoicTheAztec
94.2k1367107
answered Jan 2 at 12:41
LoicTheAztecLoicTheAztec
94.2k1367107
94.2k1367107
add a comment |
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54004962%2ffilter-products-by-custom-product-attribute-et-post-meta-data-in-a-wp-query%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
