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

问题描述

我正在优化magento商店，并且遇到了几条建议将Flat Product Catalog用于具有大量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，只需进入要在扁平产品目录" 中使用的属性，并确保该属性用于产品详情" 设置为是.进行更改后，重新索引产品数据"

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屋！