Call us 7am to midnight (GMT)
02037453658

How to Speed up Magento Product & Stock Import

  (by )

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.

Are you looking for UK Magento hosting?  Then check out our UK web hosting plans!  Magento is one of the 250+ free scripts we offer with every web hosting plan!

5 Comments

  1. On July 28, 2010 at 4:19 pm

    Website Breda said:

    Hey Tim,

    do you know if this has been fixed in 1.4 yet? I’ve heard some terrible speed issues regarding Magento. Nevertheless, I’ll be sure to try out your tip when I’m downloading the latest Magento Community version.

  2. On July 12, 2010 at 10:00 am

    Freelance web design said:

    Hey Tim, thanks for the tip! It’s been a few months since you’ve published this post and I was wondering if you’ve tested your script with version 1.4 yet? I’m trying out Magento out as we speak and I’m noticing some speed issues… your script would be a great asset.

  3. On February 15, 2010 at 6:08 pm

    Cost of Loft Conversion said:

    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.

    • On February 16, 2010 at 2:59 pm

      Tim M. said:

      Hopefully this might be fixed in 1.4 — haven’t had a chance to play with that yet.

  4. On February 1, 2010 at 6:09 pm

    Retro Sweets said:

    Really interesting… I have been looking at Magento and got a bit turned off because of this issue. I might just rethink it!