This post has been archived
The content of this post has not been updated since 2015, and may be out of date. Extra care should be taken with any code provided.
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.
October 2023
The database structure of Magento is designed to store and manage various aspects of an e-commerce website, including products, orders, customers, and more. Understanding the...
August 2023
In the digital age, where online shopping has become an integral part of our lives, ecommerce websites hold the key to business success. Amidst the...
August 2023
For small businesses aiming to establish a formidable online presence and drive sales, Magento emerges as a powerful e-commerce platform offering a suite of features...
→ Continue reading"Using Magento to get small businesses online"
July 2023
Speed optimisation is crucial for a Magento website as it directly impacts user experience, conversions, and search engine rankings. You should prepare your server so...
June 2023
Enable Gzip compression on your server to compress your website's files before sending them to the visitor's browser. This significantly reduces the file size, resulting...
→ Continue reading".htaccess: Enable GZIP Compression for Magento"
April 2023
Ecommerce payment gateways are critical components of any online store, as they enable merchants to accept payments from customers securely and conveniently. There are many...
