How to mass update your Magento SKUs

20 responses to “How to mass update your Magento SKUs”

1. Hi, Trying to update all SKU’s includiing the previous orders. Any ideas how?

   1. Im a little confused at your question. You’d like to update previous orders or SKUs or both?

2. Thanks for the post.. I’m having some issues gettng it to work for me. I’m getting the following:

   Warning: include_once(../app/Mage.php) [function.include-once]: failed to open stream: No such file or directory in /home/vapornin/public_html/sku2sku.php on line 2

   Warning: include_once() [function.include]: Failed opening ‘../app/Mage.php’ for inclusion (include_path=’.:/usr/lib/php:/usr/local/lib/php’) in /home/vapornin/public_html/sku2sku.php on line 2

   Fatal error: Class ‘Mage’ not found in /home/vapornin/public_html/sku2sku.php on line 3

   Any idea? Thanks!

   1. You’ll need to make sure the include statement is pointing to the actual location of your Mage.php file. If you fix that, you should be good.

3. I found very useful this information and I want to thank you !

4. Could someone tell me on the include statement, what you mean that it is pointing to the actual; ;location of my mage.php. My installation is in the root so myweb.com/app/mage.php.

5. What path is the script file to be placed? Thanks.

   1. my example shows magento in the root directory with the script being run from any folder inside the root directory like var.

6. Thank you. The script is exactly what I needed for Magento 1.6.1.

7. how to change old sku no to new sku no plz help me

   1. This script is not ideal for changing sku.

8. Thanks it’s very nice and it’s saved lots of time, I did some changes in my code

   error_reporting(E_ALL | E_STRICT);
   define('MAGENTO_ROOT', getcwd());
   $mageFilename = MAGENTO_ROOT . '/app/Mage.php';
   require_once $mageFilename;
   Mage::setIsDeveloperMode(true);
   ini_set('display_errors', 1);
   Mage::app();
   Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);
   $updates_file="/home/magento/htdocs/sku2sku.csv";
    
   $sku_entry=array();
    
   $updates_handle=fopen($updates_file, 'r');
   if($updates_handle) { 
       while($sku_entry=fgetcsv($updates_handle, 1000, ",")) { 
           $old_sku=$sku_entry[0];
   	    $new_sku=$sku_entry[1];
           echo "Updating ".$old_sku." to ".$new_sku." ";
           try {
               $get_item = Mage::getModel('catalog/product')->loadByAttribute('sku', $old_sku);
               if ($get_item) {
                   $get_item->setSku($new_sku)->save();
                   echo "successful";
               } else {
                   echo "item not found";
               }
           } catch (Exception $e) { 
               echo "Cannot retrieve products from Magento: ".$e->getMessage()."";
               return;
           }
       }
   }
    
   fclose($updates_handle);

   1. Glad you were able to use it and save you time!

9. Hi,

   I have a quick question, if I use this to change all my SKU’s, will I lose the Simple Product Associations for Configurable Products?

   Thanks

   Simon

   1. It shouldn’t as we are not changing that db field.

10. Where do I put this script? just upload it as its own page? or is there somewhere special i need to put this code? i cant see any help on the WiKi and i have over 1000 SKUS to change

    1. Andrew – yes you would create a file in the root of your site (or wherever) to run this. Just know that you would have to adjust the script to make sure you load Mage.php

11. Got a syntax error. Can you teach me how to fix this?
    Parse error: syntax error, unexpected ‘&’ in your code on line 16

12. Oh wait, I just found it out that I should replace the gt with -> Thanks. 😀 Your code works handsomely. 😀

13. What will happen with images? Should I change image names also?