woocommerce 3 中产品的数据库更改 [英] Database changes for products in woocommerce 3

问题描述

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+ 中的功能"产品功能:

The "feature" product functionality in 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 through term_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 to rated-5 (product rating)

这篇关于woocommerce 3 中产品的数据库更改的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！