我可以在 magento 的平面产品目录表中添加其他属性吗? [英] Can I add other attributes to magento's flat product catalog table?

问题描述

我正在优化 magento 商店，我遇到了一些建议对具有大量 SKU 的商店使用平面产品目录的帖子.

I am in the process of optimizing magento store, and I've run across a couple of posts that recommend using the Flat Product Catalog for stores with a large amount of SKUs.

因为我有超过 1 万种产品，所以我想尝试一下.但是，当使用平面产品目录时，只有少数几个属性会加载到产品对象中(例如 SKU、名称、简短描述).我的模板在搜索/浏览视图中显示了一些其他属性，例如制造商和颜色.

As I have over 10K products I thought I'd give it a try. However, when using the Flat Product Catalog only a select few attributes are loaded in product object (e.g. SKU, name, short description). And my template displays a few other attributes in the search/browse view, such as Manufacturer and Color.

有没有办法将这些属性添加到平面产品目录表中，以便它们也可以被访问?

Is there a way to add these attributes to the flat product catalog table so they too can be accessed?

推荐答案

1.4.xx，在Flat Product Catalog"中进入你想使用的属性，确定属性用于产品列表" 设置为是.进行更改后，重新索引平面产品数据"

1.4.x.x, just go into the attributes you want to be used in the "Flat Product Catalog" and make sure the property "Used in Product Listing" is set to Yes. Upon making changes, reindex "Flat Product Data"

以下属性会导致该属性包含在平面产品目录"中:

The following properties cause the attribute to be included in the "Flat Product Catalog":

"Use in Layered Navigation" = Yes
"Used in Product Listing" = Yes
"Used for Sorting in Product Listing" = Yes

这篇关于我可以在 magento 的平面产品目录表中添加其他属性吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！