中产品的数据库更改

中产品的数据库更改

本文介绍了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+ 中的功能"产品功能:

从第 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-1rated-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 中产品的数据库更改的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-03 22:25