Product/category correlations in WP/Woo database

Hey there!

while working a plugin, I need to find how are product<–>Category correlations stored in WP/Woo database.

So far, I found product info in wp_posts & category info in wp_terms table, but am having difficulty of linking products with categories in database.

Can you tell me a bit more about what you’re looking for, i.e. how you need to use the information? That’ll help me try to answer your question.

I am also trying to find category<–>vendor correlations without any success. I have installed Woo’s product-vendor plugin.

I’ve addressed this question in your other thread:
https://www.ads-software.com/support/topic/woo-category-vendor-or-product-vendor-correlations/

Let’s continue the discussion there. ??

I think they’re looking for which table do the Categories exist in @fernashes

If that’s correct @zhuzh1 they reside in wp_term_taxonomy

This is a break down of the tables inside the database with relation to WooCommerce. Product types, categories, subcategories, tags, attributes and all other custom taxonomies are located in the following tables:

wp_terms
wp_termmeta
wp_term_taxonomy
wp_term_relationships
wp_woocommerce_termmeta

wp_woocommerce_attribute_taxonomies
(for product attributes only)

@serafinnyc, @fernashes

Thanks for your insights and responses which helped a lot.

Eventually, I used the following query to retrieve corresponding vendor_id and category_id by the post_id for the product (for those who have not dived deep in Woo: products are stored in wp_posts table where post_type=’product’):

select t.term_taxonomy_id, t.taxonomy
from wp_term_taxonomy as t, wp_term_relationships as r
where
r.term_taxonomy_id=t.term_taxonomy_id and
t.taxonomy in (‘product_cat’, ‘wcpv_product_vendors’) and
r.object_id=1051;

in the query, 1051 is post_id/product_id. The result is, hopefully, self-explanatory:

term_taxonomy taxonomy
————- ——–
23 wcpv_product_vendors
44 product_cat

• This reply was modified 5 years, 6 months ago by zhuzh1.

Awesome. Thank you for sharing. Have a great day.