How to Speed up Magento Product & Stock Import
Posted by: Tim M. // // January 20th, 2010 // Magento
We love Magento at Evohosting–it is a very impressive application with so much functionality; however, with some things Magento is a massive pain. One of the main problems our customers are seeing is that product and stock imports are INCREDIBLY slow, and take up a LOT of CPU usage.
We did some digging and found a nice solution to this, a community member called ‘michael_08′ over at the Magento forums has kindly developed a very nice Magento import script. This will take the import time for products, stock levels etc down to 1% or less of the original time it would take.
Read: Forum thread regarding Magento Import Speed (the code is in the forum thread).
Test the script before running (take a database backup!), you’ll also need to know your Magento database settings and file path settings.





















Really interesting… I have been looking at Magento and got a bit turned off because of this issue. I might just rethink it!
Thanks for the heads up about this. We’re about to start offering Magento sites as part of our product offerings, and have been researching the war stories to get ourselves ready. This is definitely typical of an item that could be brought up as a ‘bug’ by a client.
Hopefully this might be fixed in 1.4 — haven’t had a chance to play with that yet.