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.