I struggled with this problem last week and I really hope that someone here can help me.
After repeatedly importing products from CSV generated by another (and slightly older) Magento store using the Import and Dataflow / Import All Products tools , I can make them appear in the backend , seemingly with all the data intact and with the images and everything, but they just do not appear in the interface .
It seems that the only way to make them express themselves in the interface is to save them on the admin product page, which I would prefer not to do for the client on the 1922th products. They are not displayed if I add them to the categories from the category manager, only (as far as I know) if I save them on the product manager page.
Also note that all products
- included
- quantity of stocks> 0, weight> 0 and price> 0
- stock availability = stock
- there is visibility = "Directory, search"
- assigned the correct website
- have an appropriate tax class associated with them
In addition, the cache was completely disabled, and I updated all at least two dozen times. I also tried to run the following PHP fragment:
$products = Mage::getModel('catalog/product') ->getCollection() ->addAttributeToSelect('*'); foreach ($products as $product) { if ($product->isSaleable()) Mage::log("Sellable product: {$product->getId()}"); else Mage::log("Unsellable product: {$product->getId()}"); }
and the log file subsequently contains nothing but "Product Sold: ..." . I also used the same product cycle to set the product website ID and then save it, which also doesn't matter. I tried to output the attribute values of various invisible products (using $product->getData() ) both before and after saving through the product manager, but I can not find any differences. I did not study every MySQL table before and after saving, and honestly, I would prefer not to.
I am in the end. I do not know what else to try. I could reimport the product list for the first time, but I doubt it will make a difference. I could try bulk updating the products again (using the Actions product dropdown list set to Update Attributes), but it probably won't help either. Does anyone have any ideas?
I apologize if this is the wrong place for such a question; Feel free to point me in the right direction if this is the case.
UPDATE
It turns out that in fact the products actually do not have the right set of websites, even though the admin panel explicitly stated this for all the products that I looked at (none of them appeared in the interface).
Solution: Product Management> Select All, then select the Update Attributes action and add the products to the desired websites. Remember to rebuild indexes.