Tag Archives: Magento

Use Categories in Product URLs for Magento SEO without Duplicate Content

Magento Open Source eCommerce logo 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.

Continue reading

Automatically Sorting Magento Catalog Categories Alphabetically via MySQL

Magento Open Source eCommerce logo 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.

Continue reading

Learning to Design and Code for Magento Themes

Magento Open Source eCommerce logoFirst off, the first reaction I always hear when others are introduced to Magento [including myself] are complaints about how difficult it is. The truth is it is just as easy as what we’re all used to. I’m going to show you that today by drawing comparisons between Magento and some other popular open-source projects we’re more familiar with such as Drupal and WordPress.

This guide is meant to be a quick-start supplement for the official Magento Design Guide, and not a replacement for it. It assumes you are already familiar with and have completed themes for Drupal and/or WordPress.

Continue reading

Magento Crashing Apache on WinXP XAMPP with PDO Enabled

Magento Open Source eCommerce logoVery frustrating! With XAMPP Lite 1.6.8 on Windows XP SP3, I could get Magento 1.2.0.1 to work but Apache would crash randomly every 3-5 minutes triggered by new page loads or refreshes. Upgrading to Magento 1.2.0.2 and then 1.2.1 didn’t help. Upgrading to XAMPP Lite 1.7.0 made it worse because Apache would crash on every page load, finally making it impossible to work with. That’s when I realized these types of problems were known issues between Magento and XAMPP.

Continue reading

Introducing Magento eCommerce Platform

MagentoFor anyone who doesn’t know, Magento is a new open-source e-commerce platform first stable released Q3 2008 using the PHP5 Zend Framework. What is amazing about this platform is in less than one year it has rocketed to the top of Google search volume trends closely rivaling—and soon to overtake—the long-time osCommerce project. Today the project is supported by Varien, an Open Source eCommerce software development and consulting firm who started the project, and an ever-growing community of over 68,000 users and developers.

Continue reading