reindex目录URL重写magento永远不会结束 [英] reindex Catalog URL Rewrites in magento never ends

问题描述

我使用自定义导入配置文件将6K类别和16K产品导入magento。
当我尝试重新索引时，一切都有效，除了目录URL重写，它们一直显示处理但从未完成。

I've imported 6K categories and 16K products to magento using a custom import profile. When I'm trying to reindex everything works except for 'Catalog URL Rewrites' that keep showing PROCESSING but never completes.

日志和例外文件不显示任何内容。

log and exceptions files don't show anything.

我能做些什么来使索引工作吗？
我可以忽略这个索引而不使用它吗？ （我不知道它是做什么的。）

Is there something I can do to make the index work? Can I just ignore this index and not use it? (I don't know what it does).

谢谢

推荐答案

<如果你不关心漂亮的，搜索引擎友好的URL，你可以忽略这个索引。产品仍将出现在目录中，但将具有其默认的Zend Framework类型URL（/ catalog / product / view / id / 123）

You can sort of ignore this index if you do not care about pretty, search engine "friendly" URL's. The products will still appear in the catalog but will have their default "Zend Framework" type URL (/catalog/product/view/id/123)

我的商店有150,000 +两个商店视图中的SKU。在我的开发环境中，完成了将近两周的时间。

My store has 150,000+ SKUs in two store views. On my development environment it took almost two weeks to complete.

确定运行速度的最佳方法是查看core_url_rewrite数据库表。似乎该流程从商店ID 1中的产品ID 1开始，并期望确保其所有URL都存在并创建尚不存在的URL。

The best way to determine how fast it is running is to look at the core_url_rewrite database table. It appears that the process starts at product ID 1 in store ID 1 and looks to make sure all of its URLs exist and creates the ones that do not yet exist.

For我花了这么长时间的原因是它必须通过我的整个目录两次来制作所有的URL。我注意到的一件事是这个过程创建了大量完全没必要的URL。在我们的商店中，我们90％的产品很容易属于可配置产品，因此它们的可见性设置为单独不可见，因此它们永远不需要具有URL。这个索引无论如何都会创建这些URL。

For me the reason it took so long was that it had to go through my entire catalog twice to make all the URLs. One thing I did notice was that this process creates a ton of URLs that are completely unnecessary. In our store easily 90% of our products belong to a configurable product so their visibility is set to "Not Visible Individually" so they never would need to have a URL. This index creates those URLs anyways.

希望这能说明这个URL是如何工作的。我会密切关注该数据库表，以便您了解该过程已经进行了多远。我也会认真考虑为命令行运行reindex进程。我已经包含了一个解释如何执行此操作的链接（披露：它来自我的博客）

Hopefully this will shed some light on to how this URL works. I would keep an eye on that database table so you sorta know how far the process has come. I would also seriously consider running the reindex process for the command line. I have included a link that explains how to do this (disclosure: it's from my blog)

http://overlycaffeinated.com/2011/02/when-reindexing-in-magento-fails-use-命令行/

这篇关于reindex目录URL重写magento永远不会结束的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！