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

Getting Started with Magento Open Source

Magento Northern Ireland Open Source allows you to build a unique online store from the ground up. ## Standard Features Magento Open Source includes everything... November 2022 · Magento

Magento - WebP Image Format Conversion

An introduction to image optimisation in Magento Northern Ireland **[Image Optimisation](/web-image-formats)** is an increasingly important step improve page speed and search engine performance of your... September 2022 · Magento

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

More Magento Posts...