Woocommerce get product attribute ID using name

Question

I want to get the ID of a Woocommerce product attribute using the attribute name. e.g. pa_foobar

I know that product attributes are taxonomies, but get_taxonomy() doesn't return the taxonomy ID. I can't find a Woocommerce function that does this.

This has already been answered in [this answer thread](https://stackoverflow.com/questions/47518333/create-programmatically-a-variable-product-and-two-new-attributes-in-woocommerce/47844054#47844054) — LoicTheAztec, Apr 29 '18 at 19:41
@LoicTheAztec not true, you can't find best solution there (to use `wc_attribute_taxonomy_id_by_name('pa_foobar')`). — Artur Czyżewski, Apr 12 '19 at 13:13
@ArturCzyżewski Sorry, but the custom function [`get_attribute_id_from_name()`](https://stackoverflow.com/questions/47518333/create-programmatically-a-variable-product-and-two-new-attributes-in-woocommerce/47844054#47844054) is a bit lighter than the woocommerce official one, and answers this question too… So yes it's answered before... I could have close this thread as duplicated, which I have not done, to allow people to answer. — LoicTheAztec, Apr 12 '19 at 14:16

score 4 · Answer 1 · answered Apr 12 '19 at 13:12

4

You can use wc_attribute_taxonomy_id_by_name($taxonomy_name).

answered Apr 12 '19 at 13:12

Artur Czyżewski

705
5
12

1

Hi! Please explain why this is a solution to OPs code as code only answers are discouraged on SO. This would help OP and future visitors to the site. Thanks! – d_kennetz Apr 12 '19 at 17:01
That is a function that can allow you to get an attribute's id by name. Usually, – Henry Obiaraije May 08 '23 at 17:10

score 1 · Answer 2 · answered Apr 29 '18 at 18:57

1

Woocommerce stores attributes in the table wp_woocommerce_attribute_taxonomies. Querying the database directly is not recommended but I was able to get the attribute ID using this code:

global $wpdb;
$attribute_id = $wpdb->get_var("select attribute_id from {$wpdb->prefix}woocommerce_attribute_taxonomies where attribute_name='pa_foobar'");

answered Apr 29 '18 at 18:57

Robbie Lewis

2,844
3
18
29

2

Yes that SQL query is similar to the one used in my custom function `get_attribute_id_from_name()` on [**this answer thread**](https://stackoverflow.com/questions/47518333/create-programmatically-a-variable-product-and-two-new-attributes-in-woocommerce/47844054#47844054) … +1 – LoicTheAztec Apr 12 '19 at 14:15

mooga · Answer 3 · 2018-04-29T17:32:40.590

-2

You can use that

woocommerce_get_product_terms

or

get_the_terms()

https://developer.wordpress.org/reference/functions/get_the_terms/

 global $product;
 $id = $product->get_id();

edited Apr 29 '18 at 17:32

answered Apr 29 '18 at 17:25

mooga

3,136
4
23
38

This does not answer the question. I want to get a product attribute ID, not a product ID. At this point the attribute might not even be assigned to a product. – Robbie Lewis Apr 29 '18 at 17:28
The two functions you have mentioned above do not return the product attribute ID. They return attribute terms. – Robbie Lewis Apr 29 '18 at 17:35
Have you seen this $terms = wp_get_object_terms( $post->ID, $taxonomy ); – mooga Apr 29 '18 at 17:40
What if the attribute is not yet assigned to a product? – Robbie Lewis Apr 29 '18 at 17:59

Woocommerce get product attribute ID using name

3 Answers3