Magento – Magento auto-generated sitemap is different with URL Rewrite

magento-1.7magento-enterprise

When Magento generated my sitemap.xml, the total amount of links are much fewer than the URL Rewrite links. Of course I understand that in URL Rewrite Management page, many of the links are redundant.

That's why I truncated the core_url_rewrite first then run the reindex. So now all the links are System generated links, not Custom links. But still the total amount of links in URL Rewrite Management is much more than the sitemap.xml.

I've enabled Product, Category and CMS Pages in System-Configuration-Google Sitemap. But still the total amount of links in sitemap.xml is much fewer. I would expect the same or not too many different.

Any reason why?

Best Answer

core_url_rewrite will contain every conceivable possible URL for category or product.

Eg. For this product

/sony-vaio-vgn-txn27n-b-11-1-notebook-pc.html
/electronics/computers/laptops/sony-vaio-vgn-txn27n-b-11-1-notebook-pc.html
/catalog/product/view/id/27/

Etc.

Whereas your sitemap is really for a search engine, and should only really contain the canonical URL for the product (which would depend on your store configuration settings for Use Categories Path for Product URLs).

Related Solutions

Magento – ‘checkout as guest’ work same as ‘register’ with auto generated password

I would suggest observing customer_register_success event and doing something like this:

$customer = $observer->getEvent()->getData('customer');
/* TODO: check that registration type is 'guest'. Otherwise you overwrite inserted password */
$customer->setPassword(_your_generated_password_here_)->save();

Magento – Magento URL Rewrite Nightmare

If all you are wanting is to have an item in your main navigation that links to a CMS page without having to hardcode it into the navigation template or include it via a static block then you can use this guide here -> http://jc-designs.net/blog/2012/09/magento-adding-cms-pages-to-the-main-navigation/

There are a few out there but I always use this one (as I can never remember how to do it even after doing it umpteen times). Yes, it is ludicrously convoluted.

Best Answer

Related Solutions

Magento – ‘checkout as guest’ work same as ‘register’ with auto generated password

Magento – Magento URL Rewrite Nightmare

Related Topic