“is_visible” flag location for Woocommerce product

Question

This matter is driving me crazy as after wasting days going through my DB I've still been unable to find out an answer to the following question:

Where is the flag "is_visible" stored on the mysql DB for the attributes of Woocommerce products?

I checked all the tables 1000 times but I can't understand where and how the flag option "attribute visible on the product page" is stored on the Wordpress DB.

Thanks!

Enrico

Answer 1

the data is sotered in the postmeta table. However it is not quite straight forward to handle it. If you pick a product and do a search for the product ID as post_id you will see a record with the meta_key _product_attributes. In the meta value you will find a serialised array of the attributes including is_visible.

Just be careful because if you simply edit it in phpmyadmin you can mess stuff up badly. If you don't know what a serialised array is google it.