Custom Magento product not showing in category list?
I have a custom product that contains small sizes and large sizes. i have done all the steps in this article http://www.magentocommerce.com/knowledge-base/entry/tutorial-creating-a-configurable-product .
it worked well and I can directly access the product.
The little problem is that it doesn't show up in the category. I am confident in the following points.
- Products must be visible in the Catalog.
- Products must be included.
- The product must have stock.
- The product must be in stock.
- If a product is not configured to track inventory, it must still have a Quantity and a Stock in Stock.
- The product must be assigned to the target category.
- When using multi-website mode (or if you imported products via Data Flow), the products must be linked to the target website.
- You must update your cache / indexes.
what to do next? = (
source to share
Have you used the Organic Internet extension, which is SimpleCOnfigurableProducts? If so, the simplest solution would be to make changes to this fileapp/code/community/OrganicInternet/SimpleConfigurableProducts/Catalog/Model/Resource/Eav/Mysql4/Product/Indexer/Price/Configurable.php
From:
$select->columns(array(
'entity_id' => new Zend_Db_Expr('e.entity_id'),
'customer_group_id' => new Zend_Db_Expr('pi.customer_group_id'),
'website_id' => new Zend_Db_Expr('cw.website_id'),
'tax_class_id' => new Zend_Db_Expr('pi.tax_class_id'),
'orig_price' => new Zend_Db_Expr('pi.price'),
'price' => new Zend_Db_Expr('pi.final_price'),
'min_price' => new Zend_Db_Expr('pi.final_price'),
'max_price' => new Zend_Db_Expr('pi.final_price'),
'tier_price' => new Zend_Db_Expr('pi.tier_price'),
'base_tier' => new Zend_Db_Expr('pi.tier_price')
));
To:
$select->columns(array(
'entity_id' => new Zend_Db_Expr('e.entity_id'),
'customer_group_id' => new Zend_Db_Expr('pi.customer_group_id'),
'website_id' => new Zend_Db_Expr('cw.website_id'),
'tax_class_id' => new Zend_Db_Expr('pi.tax_class_id'),
'orig_price' => new Zend_Db_Expr('pi.price'),
'price' => new Zend_Db_Expr('pi.final_price'),
'min_price' => new Zend_Db_Expr('pi.final_price'),
'max_price' => new Zend_Db_Expr('pi.final_price'),
'tier_price' => new Zend_Db_Expr('pi.tier_price'),
'base_tier' => new Zend_Db_Expr('pi.tier_price'),
'group_price' => new Zend_Db_Expr('pi.group_price'),
'base_group_price' => new Zend_Db_Expr('pi.group_price')
));
AND...
From:
$outerSelect->columns(array(
'customer_group_id',
'website_id',
'tax_class_id',
'orig_price',
'price',
'min_price',
'max_price' => new Zend_Db_Expr('MAX(inner.max_price)'),
'tier_price',
'base_tier',
#'child_entity_id'
));
To:
$outerSelect->columns(array(
'customer_group_id',
'website_id',
'tax_class_id',
'orig_price',
'price',
'min_price',
'max_price' => new Zend_Db_Expr('MAX(inner.max_price)'),
'tier_price',
'base_tier',
'group_price',
'base_group_price'
#'child_entity_id'
));
Hope it helps ...
source to share
Even I couldn't do it before (solved now). I had two attributes: shape and size (previously applied to selected products: custom products). It has been argued that the shape and size attributes only apply to "custom products" and not to "simple products" (that was a problem!).
The related products we create (from custom products) are actually simple products. Therefore Magento requires that the attributes we created to create custom products must be with the "Simple Products" option.
Catalog> Attributes> Manage Attributes> Size> Apply To> Selected Product Types> Simple Product
This attribute can then be used to create a set of attributes and in turn to create a custom product (and this is used to create simple related products).
Please make sure product attributes are applied to "simple products" in the Manage Attributes section of the administrator.
source to share