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
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.
In case someone is searching for this in the year 2022 or later: In the meantime woocommerce isn’t storing this value in the post_meta table. Instead there is a taxonomy called “product_visibility” with different states (exclude-from-catalog, exclude-from-search). In the “term_relationships” table is stored which of these values is associated with a product.