Magento CE 1.7.0.2 –进口产品未出现在前端 [英] Magento CE 1.7.0.2 – Imported products do not show up in frontend
问题描述
上个星期我一直在与这个问题作斗争，我真的希望这里有人可以帮助我解决这个问题.
使用导入和数据流/导入所有产品工具反复从其他(稍旧)的Magento商店生成的CSV导入产品后，我可以让它们显示在后端 strong>，看似完整的数据，图像和所有内容，但它们根本不会显示在前端.
似乎使它们显示在前端的唯一方法是将它们保存在管理产品页面中，我宁愿不要让客户端使用1922产品.如果我从类别管理器中将它们添加到类别中，它们不会显示出来，(据我所知)，如果我从产品管理器页面中将它们保存到类别中，则它们不会出现. >
还要注意所有产品
- 已启用
- 库存数量> 0，重量> 0，价格> 0
- 拥有库存量=有库存
- 具有可见性=目录，搜索"
- 已为他们分配了正确的网站
- 具有与之相关的正确税种
此外，缓存已被完全禁用，我至少对所有内容重新编制了索引.我也尝试过运行以下PHP代码段:
$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()}");
}
，随后日志文件中仅包含可售产品:..." .我还使用了相同的产品循环来设置产品的网站ID，然后保存它，这也没有任何区别.在通过产品管理器进行保存之前和之后，我都尝试输出各种不可见产品的属性值(使用$product->getData())，但是我无法找到任何差异.我没有在保存前后检查每个MySQL表，坦率地说，我宁愿不必这样做.
我在机智的尽头.我不知道还能尝试什么.我可以在第15次重新导入产品列表，但我怀疑这会有所作为.我可以尝试再次大规模更新产品(使用产品经理的操作"下拉菜单设置为更新属性")，但这一次可能也无济于事. 任何人有什么想法吗?
如果这不是解决此类问题的正确地点，我深表歉意；如果是这样，请随时向我指出正确的方向.
更新
事实证明，即使管理面板明确声明对我看过的所有产品(前端都没有显示)，这些产品实际上没有正确的网站设置.
解决方案:管理产品>全选，然后选择操作更新属性并将产品添加到正确的网站.不要忘记重建索引.
我遇到了同样的问题，因此感谢您在帖子中提供的以下答案:
更新
事实证明，即使管理小组明确声明对我看过的所有产品(前端都没有显示)，这些产品实际上并没有正确的网站设置.
解决方案:管理产品>全选，然后选择操作更新属性并将产品添加到正确的网站.不要忘记重建索引.
I've been battling with this issue for the last week now, and am really hoping someone here might be able to help me with it.
After repeatedly importing products from a CSV generated by a different (and slightly older) Magento store, using both the Import and the Dataflow/Import All Products tools, I can get them to show up in the backend, seemingly with all the data intact and with images and everything, but they simply will not show up in the frontend.
It seems that the only way to make them show up in the frontend is to save them from the admin product page, which I'd rather not make the client do on 1922 products. They do not show up if I add them to categories from the category manager, only (as far as I know) if I save them from the product manager page.
Also note that all products
- are enabled
- have stock quantity > 0, weight > 0 and price > 0
- have stock availability = In Stock
- have visibility = "Catalog, search"
- have the correct website assigned to them
- have the right tax class associated with them
In addition, the cache has been entirely disabled and I've re-indexed everything at least two dozen times. I've also tried running the following snippet of PHP:
$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 "Sellable product: ...". I've also used the same product loop to set the website ID of the product and then save it, which also makes no difference. I've tried outputting the attribute values of various invisible products (using $product->getData()) both before and after saving through the product manager, but I cannot locate any differences whatsoever. I have not examined every MySQL table before and after saving, and frankly, I'd rather not have to do that.
I'm at wits' end. I don't know what else to try. I could re-import the product list for the umpteenth time, but I doubt it'll make a difference. I could try mass-updating the products again (using the product manager's "Actions" dropdown set to "Update Attributes"), but it's probably not going to help this time either. Does anyone have any ideas whatsoever?
My apologies if this is not the correct venue for this kind of question; feel free to point me in the right direction if that's the case.
UPDATE
Turns out that the products did not actually have the right website set, even though the admin panel clearly claimed so for all the products I looked at (none of which showed up in the frontend).
Solution: Manage Products > Select All, then select the action Update Attributes and add the products to the correct website(s). Don't forget to rebuild the indexes.
I had the same problem, so thank you for this answer you provided in your post:
UPDATE
Turns out that the products did not actually have the right website set, even though the admin panel clearly claimed so for all the products I looked at (none of which showed up in the frontend).
Solution: Manage Products > Select All, then select the action Update Attributes and add the products to the correct website(s). Don't forget to rebuild the indexes.
这篇关于Magento CE 1.7.0.2 –进口产品未出现在前端的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
