Product and related category
-
I actually did brief research in woocommerce tables, I reached some results to mention here and if I am wrong I will be happy to be corrected with LOGIC:
I was wondering where the category of each product is hidden because products could be found in table posts and no field contains id of the category in the table category of woocommerce the product belongs to.
(there are other tables which contain products like product meta lookup yet they do not have it either). Then table terms, term relationship and term taxonomy drew my attention, in table terms created categories in woocommerce with a term id exist, in term taxonomy table that term id with a taxonomy id exist and in term relationship table taxonomy id with object id which is the same as post id in table posts, also term taxonomy id has the same value as term id. This was the only way I could figure out a product to its category data.
Kian William
- The topic ‘Product and related category’ is closed to new replies.
