entityMap|blocks|key|9g1bj|text|我还没有测试，但这应该是接近那里或准备发货。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|f1uqd|function+get_variation_by($size,+$color)+{
++$args+=+array(
++++'post_type'+=>+'product',
++++'numberposts'+=>+-1,
++);
++$product_posts+=+get_posts(+$args+);

++foreach+(+$product_posts+as+$single_product_post+)+{
++++$_product+=+wc_get_product(+$single_product_post->ID+);
++++if+($product_s->product_type+!=+'variable')+continue;

++++$avail_vars+=+$_product->get_available_variations();
++++foreach+($avail_vars+as+$v)
++++++if+($v["attributes"]["attribute_pa_size"]+==+$size
++++++++++&&+$v["attributes"]["attribute_pa_color"]+==+$color)
++++++++return+$v;
++}
++return+null;
}

$variation+=+get_variation_by(+"large",+"green");
$variation_id+=+$variation->variation_id;|code-block|syntax|javascript|d4e3c|如果你有产品_已经是变量产品的id，可以这样简化：|7qoq3|function+get_variation_by($variable_product_id,+size,+$color)+{
++$var_prod+=+wc_get_product(+$variable_product_id+);++++++++
++$avail_vars+=+$var_prod->get_available_variations();

++foreach+($avail_vars+as+$v)
++++if+($v["attributes"]["attribute_pa_size"]+==+$size
++++++++&&+$v["attributes"]["attribute_pa_color"]+==+$color)
++++++return+$v;

++return+null;
}^0|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|L|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|M|9|@]|A|@]|B|$F|G]]|$2|H|4|I|6|7|8|N|9|@]|A|@]|B|$]]|$2|J|4|K|6|E|8|O|9|@]|A|@]|B|$F|G]]]]

I haven't tested but this should be nearly there or ready to ship.

<pre><code>function get_variation_by($size, $color) {
 $args = array(
 'post_type' =&gt; 'product',
 'numberposts' =&gt; -1,
 );
 $product_posts = get_posts( $args );

 foreach ( $product_posts as $single_product_post ) {
 $_product = wc_get_product( $single_product_post-&gt;ID );
 if ($product_s-&gt;product_type != 'variable') continue;

 $avail_vars = $_product-&gt;get_available_variations();
 foreach ($avail_vars as $v)
 if ($v["attributes"]["attribute_pa_size"] == $size
 &amp;&amp; $v["attributes"]["attribute_pa_color"] == $color)
 return $v;
 }
 return null;
}

$variation = get_variation_by( "large", "green");
$variation_id = $variation-&gt;variation_id;
</code></pre>

If you have the product_id of the variable product already, you can simplify like this:

<pre><code>function get_variation_by($variable_product_id, size, $color) {
 $var_prod = wc_get_product( $variable_product_id ); 
 $avail_vars = $var_prod-&gt;get_available_variations();

 foreach ($avail_vars as $v)
 if ($v["attributes"]["attribute_pa_size"] == $size
 &amp;&amp; $v["attributes"]["attribute_pa_color"] == $color)
 return $v;

 return null;
}
</code></pre>

entityMap|blocks|key|53ilc|text|以下函数使用非常简单的SQL查询从定义的产品属性“颜色”和“大小”术语段的变量产品中获取的变体ID：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1qjcl|function+get_product_variation_id(+$size,+$color,+$product_id+=+0+)+{
++++global+$wpdb;

++++if+(+$product_id+==+0+)
++++++++$product_id+=+get_the_id();

++++return+$wpdb->get_var(+"
++++++++SELECT+p.ID
++++++++FROM+{$wpdb->prefix}posts+as+p
++++++++JOIN+{$wpdb->prefix}postmeta+as+pm+ON+p.ID+=+pm.post_id
++++++++JOIN+{$wpdb->prefix}postmeta+as+pm2+ON+p.ID+=+pm2.post_id
++++++++WHERE+pm.meta_key+=+'attribute_pa_color'
++++++++AND+pm.meta_value+LIKE+'$color'
++++++++AND+pm2.meta_key+=+'attribute_pa_size'
++++++++AND+pm2.meta_value+LIKE+'$size'
++++++++AND+p.post_parent+=+$product_id
++++"+);
}|code-block|syntax|javascript|94mmm|代码放在活动子主题(或活动主题)的function.php文件中。经过测试，效果良好。|1tod6|用法(2例)|am8q3|从定义的变量产品ID+(其中746是父变量产品ID)：|offset|length|style|CODE|19oou|$variation_id+=+get_产品_变化_id(+'large'，'blue'，746+)；|5vmro|在可变产品单一产品页面上(不需要定义变量产品ID)：|9j2qd|$variation_id+=+get_产品_变化_id(+'large'，'blue‘)；^0|0|0|0|0|E|3|0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|X|9|@]|A|@]|B|$]]|$2|C|4|D|6|E|8|Y|9|@]|A|@]|B|$F|G]]|$2|H|4|I|6|7|8|Z|9|@]|A|@]|B|$]]|$2|J|4|K|6|7|8|10|9|@]|A|@]|B|$]]|$2|L|4|M|6|7|8|11|9|@$N|12|O|13|P|Q]]|A|@]|B|$]]|$2|R|4|S|6|7|8|14|9|@]|A|@]|B|$]]|$2|T|4|U|6|7|8|15|9|@]|A|@]|B|$]]|$2|V|4|W|6|7|8|16|9|@]|A|@]|B|$]]]]

The following function uses a very light SQL query to get the variation ID for from a variable product for defined product attributes &quot;color&quot; and &quot;size&quot; term slugs:
<pre><code>function get_product_variation_id( $size, $color, $product_id = 0 ) {
 global $wpdb;

 if ( $product_id == 0 )
 $product_id = get_the_id();

 return $wpdb-&gt;get_var( &quot;
 SELECT p.ID
 FROM {$wpdb-&gt;prefix}posts as p
 JOIN {$wpdb-&gt;prefix}postmeta as pm ON p.ID = pm.post_id
 JOIN {$wpdb-&gt;prefix}postmeta as pm2 ON p.ID = pm2.post_id
 WHERE pm.meta_key = 'attribute_pa_color'
 AND pm.meta_value LIKE '$color'
 AND pm2.meta_key = 'attribute_pa_size'
 AND pm2.meta_value LIKE '$size'
 AND p.post_parent = $product_id
 &quot; );
}
</code></pre>
Code goes in function.php file of your active child theme (or active theme). Tested and works.
<hr />
USAGE (2 cases examples):
<ol>
<li>From a defined variable product ID (where <code>746</code> is the parent variable product ID):
$variation_id = get_product_variation_id( 'large', 'blue', 746 );
</li>
<li>On the variable product single product page (No need to define the variable product ID):
$variation_id = get_product_variation_id( 'large', 'blue' );
</li>
</ol>

How can I get product variation ID by taxonomy terms?

For example if I have two taxonomies and their terms:

<pre><code>1) Size: medium, large
2) Color: blue, green
</code></pre>

And my product variations:

<pre><code>Variation id 1: medium &gt; blue
Variation id 2: medium &gt; green
Variation id 3: large &gt; blue
Variation id 4: large &gt; green
</code></pre>

I would like to get variation ID of this terms combination <code>medium &gt; green</code>.

Get product variation id by their product attributes slug values pairs in Woocommerce

 如何通过分类术语获取产品变体ID？ 例如，如果我有两个分类法及其术语： 1) Size: medium, large2) Color: blue, green 以及我的产品变体： Variation id 1: medium > blueVariation id 2: medium > greenVariation ...

问通过Woocommerce中的产品属性slug值对获取产品变体id
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问通过Woocommerce中的产品属性slug值对获取产品变体idEN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问通过Woocommerce中的产品属性slug值对获取产品变体id
EN