Magento Themes and Magento Extensions

How To Add, Change SKU In Bulk Magento Product List

Share
Posted on July 21st, 2011 | Posted by admin

How To Add, Change SKU in Bulk Magento Product list is not as simple as it may sound by there is a quick solution to add, change SKU numbers within your existing huge product database. Stock Keeping Unit aka SKU is typically a unique, alphanumeric, merchant-defined identifier for the product with the primary intention to make this number human-readable, meaningful and concise. Many big ecommerce open source application uses SKU but i have seen some e-commerce open source applications which completely neglect this attribute.

Magento uses SKU explicitly as a “unique identifier for the particular product, across all stores and websites”. Keeping Product Title be the primary differentiation won’t help especially if the store is multi-site and multi-lingual. As per a study when people start their online store they don’t give much attention to the SKU numbers but keep on adding as many products as they can which leads to trouble we are talking about. Now, they end up having thousands of products in their database without proper SKU numbers. Tracking becomes difficult, heavy ordering takes a toll on back office.

Browser Language Redirection For Multi Language Stores In Magento

Share
Posted on July 21st, 2011 | Posted by admin

Do you run a Multilingual Magento store and looking to auto redirect your customers to their language store? Well, browser language redirection is what we are talking about which can run on Firefox, IE, Mozilla, Google Chrome, Avant and Safari browsers. Generally, Magento does not support geographical detection and redirection so many store owners are initially getting customers to land on their default page where they ask them to choose their preferred language. This is the default way of redirecting customers to their local language store. Other option is to choose a country drop-down or flag to redirect customers to their language store (widely used in multi language stores).

What about detecting the customers default language automatically and open specific language store without having those to select their country/language choice manually?

Automatic redirection based on Customers Location, Geographical detection and browser language.

How you could serve static content files from your Magento extension folder

Share
Posted on July 21st, 2011 | Posted by admin

As a part of my personal ongoing “unobtrusive Magento extensions” campaign. I will show you another “hack”/approach you can apply in order to squeeze your static files under the main extension folder.

When I say static, I am mainly referring to images, CSS and JavaScript in this case.

For example, imagine you are coding an extension called “Sociable“, which will display several links to various web services like Twitter, GoogleBuzz, etc. Links that you can click and the publish a short message about a product/category on that web service. Something like on the image shown below. Logical question is, where do you store your images?

Usually images are stored within the root /media/ folder. So it might seem perfectly fit to store them under the /media/mycompany/mymodule/ folder.

Advanced layout updates for categories and products in Magento

Share
Posted on July 21st, 2011 | Posted by admin

Recently I had a task to modify sorting in only one category of Magento shop.
What I had to do is “only” to change which attribute will be used for default sorting and I needed to reverse ordering from ascending to descending.
Task seems simple, right?

All you need to do is add/edit your category and in admin panel set your new configuration:

Default Product Listing Sort By:

Insert dynamical menu in Magento’s Admin

Share
Posted on July 21st, 2011 | Posted by admin

Hello everyone! I’ve recently got frustrated with Magento’s core functionality which requires XML definition for Administration menus. And I really wanted to add quick website / store links to it. Solution was to overwrite one of Magento’s Adminhtml blocks, and inject my non-XML, dynamic menu to it. If you’re interested in how I did it, read on.

To make it upgradeable, and painless, I’ve decided to make an extension just for this. It consists of only 2 Files, config.xml, and one Block rewrite.

First, I’ve created config.xml, and set it like this: