Home > Magento Tips > Clear Product Import Progress

Clear Product Import Progress

Posted on: 14th Jan 2011 By: Robert Kent No Comments

There have been many occasions in my life when I have been importing a spreadsheet of products into a magento database and I receive errors. These errors can be anything from invalid characters (non-UTF-8) to no SKU being defined. Sometimes we can let these errors slide – especially if they are not important in the overall scheme of things.

The problem when we let these errors slide is that they stack up on top of each other. Causing the progress bar to dip below the page – this is a problem as I love it when I can glace over at a 3-hour import and instantly see my progress, rather than walking over and scrolling down each time I want to check.

This blog post is a simple yet effective way of fixing this annoying little problem. I’m hoping in future versions of Magento they’ll see this and give us all a clear Heads-Up-Display.

First of all we need to create our local php file.

Create the following directory and app/code/local/Mage/Adminhtml/Block/System/Convert/Profile/ and copy the equivalent Run.php from the core directory.

You need to change a couple of lines in here. First of all change line 60. You will see an opening <body> tag. All you need to do is paste the following immediately after but still within the php quotations.

</head><body>
<ul>
<li onmouseover="this.style.backgroundColor=\'#DDDDFF\';"
onmouseout="this.style.backgroundColor=\'#FFF\'"
id="static" style="background: url(http://www.e-commercewebdesign.co.uk/images/magento-blog-logo.gif) left no-repeat;
height: 64px; width: 100%; text-align: center; font-size: 1.5em; padding: 20px 0 0; cursor: pointer;">
</li>
</ul>';

Next step is to navigate to line 276 and paste out static element javascript below the updatesRows_status line.

$("updatedRows_status").update(config.tplTxt.evaluate({updated:countOfUpdated, percent:getPercent()}));
$("static").update(config.tplTxt.evaluate({updated:countOfUpdated, percent:getPercent()}));

Upload your file and now witness a nice big progress report for your import progress.