Magento URL indexing and core_url_rewrite table

magento indexing magento-1.7
Peter O'Callaghan picture Peter O'Callaghan · Nov 12, 2012 · Viewed 13.4k times · Source

Can anybody shed some light on how Magento determine whether to create a new URL rewrite for a product? Every time I run the Catalog URL Rewrite reindex process the number of rows in core_url_rewrite increases by roughly 10,000 rows. Since no product data has been modified in the mean time, why is a new URL generated?

Answer

SPRBRN picture SPRBRN · Jan 9, 2015

This problem still exists in Magento 1.7, but I have no clue about 1.8 or 1.9. Magento does not delete old entries it seems. This can slow down your database seriously. The easiest way to solve this is to truncate the table and to reindex it.

  • Login to mysql and select (use) the proper database
  • Execute the following query: truncate table core_url_rewrite;
  • Goto the shell folder in your magento root (commandline) and execute the following command: php -f indexer.php -- -reindex catalog_url
  • Alternatively you can do this in the admin: System > Index Management; Reindex Catalog URL Rewrites

Then check in the admin: Catalog > URL Rewrite Management, and see if the new entries have been created. If this shows no items, URL rewrites won't work!

Related questions

Magento index status pending forever

I've created a Magento instance via command line and added a few products. Right after, started the re-index proccess for every indexes. The current situation is that all indexes have status pending/processing. This situation brings me a few questions: …

Read More
Magento Indexes Issue - Can't reindex

I have a problem with index management inside my Magento 1.6.2.0 store. Basically I can't get them to update. The status says Processing but it says like that for over a 3 weeks now. And when I try to reindex I am …

Read More
Class 'DOMDocument' not found

I've found an error on a page in my Magento application; it always show this message error when I visit it: Fatal error: Class 'DOMDocument' not found in /home/.../lib/Zend/Feed/Abstract.php on line 95 Can you give me …

Read More