query woocomerce database for specific custom attribute

Kyriakos Dimitrios answered on July 29, 2022 Popularity 2/10 Helpfulness 1/10

answer query woocomerce database for specific custom attribute

query woocomerce database for specific custom attribute

Comment

// Set custom attribute name and value to search for
$attribute_name  = 'color';
$attribute_value = 'green';

$serialized_value = serialize( 'name' ) . serialize( $attribute_name ) . serialize( 'value' ) . serialize( $attribute_value ); // extended version: $serialized_value = serialize( $attribute_name ) . 'a:6:{' . serialize( 'name' ) . serialize( $attribute_name ) . serialize( 'value' ) . serialize( $attribute_value ) . serialize( 'position' );
$args = array(
	'post_type'      => 'product',
	'post_status'    => 'any',
	'posts_per_page' => -1,
	'orderby'        => 'title',
	'order'          => 'ASC',
	'meta_query' => array(
		array(
			'key'     => '_product_attributes',
			'value'   => $serialized_value,
			'compare' => 'LIKE',
		),
	),
);
$loop = new WP_Query( $args );
while ( $loop->have_posts() ) {
	$loop->the_post();
	// do stuff here... e.g. get_the_ID()
}
wp_reset_postdata();

Popularity 2/10 Helpfulness 1/10 Language php

Source: wpcodebook.com

Tags: custom-attribute database php

Link to this answer
Share Copy Link

Contributed on Jul 29 2022

Kyriakos Dimitrios

0 Answers Avg Quality 2/10

query woocomerce database for specific custom attribute

Contents

More Related Answers

query woocomerce database for specific custom attribute

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.