Hi Antonino, can you help me?
I use the Pixel Caffeine plugin to produce a Feed and the “Perfect WooCommerce Brands” plugin to assign a brand to each product in my warehouse. Now I need to insert this information in the feed that I produce with Pixel Caffeine. The “Perfect WooCommerce Brands” plugin creates a row in the WP_TERMS table by assigning a term_id to each brand, this term_id is then associated with the product (defined in the WP_POSTS table with its own ID) using the WP_TERMS_RELATIONSHIP table.
So I need to retrieve the brand name starting from the product (in the WP_POSTS table) and going through the WP_TERMS_RELATIONSHIP table until I reach the WP_TERMS table where the information resides.
Thank you very much
Alex
