박동욱 박동욱 - 1 month ago 15
MySQL Question

What is woocommerce variations table names

Im new to wp + woocommerce.

I have to insert variations to existing products from other product.
But existing variations are more than 100 each product.

I found plugins but no plugin support variations only.

So I want to copy those variations in mysql but i cannot find that table and have no idea about relations.

Somebody help me pleas Let me go home tonight.

Thanks

Answer

as product is a post type so in mysql database it will store in table name wp_posts while variation will store in wp_postmeta , now if a product has id 1 in wp-posts it has 5 variations so the variation will store in 5 rows in wp_postmeta against id 1