问题描述
Woocommerce v2.6 在 wp_postmeta 表中存储以下 meta_key 值:
Woocommerce v2.6 stores the following meta_key values in the wp_postmeta table:
_sku
_价格
_regular_price
_regular_price
_sale_price
_sale_price
_manage_stock
_manage_stock
_stock_status
_stock_status
_精选
Woocommerce v3.x 是否仍然以与 v2.6 相同的方式存储上述所有内容,或者是否将上述任何内容重新定位到另一个表和/或以任何方式修改?
Does Woocommerce v3.x, still store are all of the above in an identical manner as v2.6 or have any of the above been relocated to another table and/or modified in any way?
推荐答案
在 WooCommerce 3+ 中,列出的所有内容都是相同的,除了 _featured
不再起作用.强>
In WooCommerce 3+ everything listed is the same, except for _featured
that doesn't work any more.
WooCommerce 3+ 中的功能"产品功能:
从第 3 版开始,WooCommerce 会在 wp_terms
表中生成一个 featured
术语 (名称和 slug),wp_term_taxonomy
表中的product_visibility
是哪个自定义分类法.
Since version 3, WooCommerce generates a featured
term (name and slug) located in wp_terms
table, which custom taxonomy is product_visibility
in wp_term_taxonomy
table.
wp_term_relationships
表建立以下链接:
The wp_term_relationships
table make the link between:
- 特色"产品 ID,通过
object_id
键 product_visibility
分类法的 ID 通过term_taxonomy_id
键
- the "featured" products IDs through the
object_id
key - the ID for
product_visibility
taxonomy throughterm_taxonomy_id
key
wp_term_taxonomy
表通过其 term_id 与词条
键.featured
建立链接
The wp_term_taxonomy
table make the link with the term featured
through its term_id
key.
它的工作原理就像一个帖子.
It works jut like a post term.
更新:关于问题中未列出的其他变化.
product_visibility
分类法也处理这些术语(功能):
The product_visibility
taxonomy also handle those terms (functionalities):
exclude-from-search
(产品可见性选项)exclude-from-catalog
(产品可见性选项)outofstock
(库存状态)rated-1
到rated-5
(产品评级)
exclude-from-search
(product visibility option)exclude-from-catalog
(product visibility option)outofstock
(stock status)rated-1
torated-5
(product rating)
这篇关于woocommerce 3 中产品的数据库更改的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!