This is a Magento 1 script, it won’t work for Magento 2.

The script will loop through a CSV file and update the SKU on each product. This can be useful when a website owner changes supplier or when they hook their Magento store up to a CRM which requires specific SKUs to be used.

Place the following script in your Magento root folder

First create your CSV with the old and new SKU numbers in a simple CSV file as follows and upload onto FTP into the magento/var/import directory.

1232,new-24B8
442,2w39489
0909d,11299033

One product on each line the current SKU followed by a comma, then the new SKU you wanto to use followed by a new line. Next, place the following script in the root folder of your Magento install. Make sure $updates_file matches the location of the CSV file on the server.

An alternative method uses the SOAP API built into Magento but is slightly slower.

Magento

Magento is a feature-rich ecommerce platform built on open-source technology that provides online merchants with unprecedented flexibility and control over the look, content and functionality of their ecommerce store.

About Magento Ecommerce · Magento Posts

Related Magento Posts

Aheadworks switch to subscription model

Aheadworks will be removing Composer keys and download access for existing customers and switching entirely to a subscription model. From February 2022 Aheadworks announced it... March 2022 · Magento

Magento Store Hierarchy

Before you start building-out your Magneto website you must first plan your store hierarchy. Magento's hierarchy is referred to throughout your store's configuration. Each store... February 2022 · Magento

Optimising Magento 2 in Easy Steps

Some (fairly) simple step-by-step instructions to ensure your Magento 2 store is running the best it can. While most of these options should only require... December 2021 · Magento

More Magento Posts...