tags:

views:

490

answers:

3

Hi

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).

Thanks

A: 

You need catalog URL rewrites to make your catalog work properly. How long are you letting it run for? There's a really substantial amount of data to be written to it...

If you cannot make it work programmatically, it may be possible to shove the data into the table manually and force the index to feel refreshed? Caveat emptor, I have not tried this.

Joseph Mastey
I'm waiting more than an hour until I'm getting an error:An error occurred while saving the URL rewrite.I think it's from:app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Url.php
pablo
A: 

Hopefully this link will help you.

http://www.magentocommerce.com/boards/main.php/viewthread/198534/#t255791

white spot
+1  A: 

My own attempt of reindexing URL rewrites was with 10,000 products and it took me like an Hour and Half to finish up.

this link will help you do it from Command Line , which is preferable than doing it from the same Magento admin panel.

http://www.yireo.com/tutorials/magento/magento-administration/340-magento-14-cronjobs

Make sure you read the part about skipping some basic configuration when facing memory limits , this is the one i usually use.

Rabe'e Abdelwahab