SQL query to map tag to products

i am using woocommerce plugin and i have more then 1 lakh products..i have product taxonomies like industry type ( IT, HEALTH)

Each product linked with taxonomy(IT,HEALTH).. now i have to create product tags and need to link them with products. for this need to edit each product and select particular tag and update the product.

I cant edit 1 lak products and map tags to products..

can some one tell me sql query to map the products with product tags based on taxonomy value.

Example.. products with taxonomy (Health Industry) must be linked to tag (Health)..

• This topic was modified 2 years, 4 months ago by Jan Dembowski.