"is_visible"标记Woocommerce产品属性的位置 [英] "is_visible" flag location for Woocommerce products attributes

问题描述

这件事使我发疯，因为在花了我几天的时间之后，我仍然无法找到以下问题的答案:

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:

Woocommerce产品的属性在mysql DB上存储的标记"is_visible"在哪里?

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

我检查了所有表1000次，但我不明白在Wordpress DB上将标记选项产品页面上可见的属性"存储在何处以及如何存储.

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.

谢谢！

恩里科

推荐答案

数据被保存在postmeta表中.但是，处理它不是很简单.如果选择一种产品并以post_id的形式搜索产品ID，则会看到带有meta_key _product_attributes的记录.在元值中，您将找到包括is_visible在内的属性的序列化数组.

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.

请务必小心，因为如果仅在phpmyadmin中对其进行编辑，则可能会造成混乱.如果您不知道Google的序列化数组是什么.

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.

这篇关于"is_visible"标记Woocommerce产品属性的位置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！