Archive for March, 2009
Use Categories in Product URLs for Magento SEO without Duplicate Content
Mar 7th
Magento provides the option to use categories in your product URLs for the search engine optimization benefits it brings, but they’ve implemented it in a very unusual way. Basically, if you enable this option, you’ll end up with at least 4 URLs per product. Once people realize it, this often raises a number of concerns including possible duplicate content penalty from Google, fractured link juice for product pages, frustrated admins, etc.
With so many people also searching for a clever solution, I decided disabling the feature was an unacceptable solution, and took the challenge.
(4 votes, average: 4.50 out of 5)
Loading ...Automatically Sorting Magento Catalog Categories Alphabetically via MySQL
Mar 7th
Beats me why this isn’t an option in Magento core back-end administration already. I have been using the core patch for Magento Dataflow which allows me to import categories with my products similar to the way Yahoo! eCommerce lets you do it. It makes things easy for importing but you end up with the categories appearing in the order they were specified in your .CSV file you imported, and not alphabetically as most customers would expect when browsing your product catalog from the front-end.
So, rather than manually attempting to reorder 68 categories across 3 levels one-by-one using the tools provided in the Magento back-end, I decided to write a simple MySQL script that would do it all for me automatically. Here it is, for anyone else who may be running into this problem.
(2 votes, average: 4.50 out of 5) Loading ...