Common Magento Import Errors and Ways to Fix Them
While working with Magento import, you may find that, all of a sudden, it gives you the random error. You do not see the rational cause of Magento import from csv trouble and have no idea how to fix it or what it is related to. The mentioned situation is quite prevailing among online merchants.
What to do next? Often entrepreneurs ask the advice of community, where more experienced users can assist or hire developer to correct the problem. If you choose the first way, you might expect that your Magento fast product import is, in fact, not so fast, as it can take a lot of time to get the piece of advice. The second solution will require from you additional expenses and also some time.
This article is the attempt to combine those 2 ways of getting solution and help you to find quick answers/way-outs concerning the most common Magento import issues. Here are gathered problems and replies for the inquiries that most often appear at Google or forum search:
"Please wait..." and Time Out Error
Increase the max_execution_time and memory_limit in php.ini or .htacces file. Get convinced that you have no restrictions and your server resources as big as they can be as import requires lots of resources to be executed. You can also try to divide your Magento import csv file into chunks and upload it in portions. On the other hand, you can use alternatives that can manage the process and do not need large server sources. One of such solutions is Store Manager for Magento, which handles Magento fast product import using computer resources instead of server ones.
Skip import row, required field “...” not defined
Verify if the column pointed out in the error is empty and does not contain any values, if it is so, add them. Each entity should be placed in another row and the first one should be for headlines. Every row should end with \r and \n (you can check it in plain text editor). In case you do not have values indicated in the mentioned column, there is a way to stay clear of manual entering of the data, if you use Store Manager, that enables you to add values on the fly during file appending.
In situation all the details are there and set properly but import still gives you error, open the spreadsheet using any program for file editing or Notepad. When you are at the save screen, tick the “Edit filter settings” box and then once you click save you will be given the option of choosing the encoding format, which needs to be UTF-8. Then you can come back to the process of fast product import and re-do it once again.
“” is no valid value for “...”
Review once again your column names in your Magento import csv file. They should not have extra symbols like underscores. Do not forget that it you have row headers the same as database titles, it will be highly beneficial. In any other case, use import tools with feature to map fields.
"Column names have duplicates"
The system is informing you that your CSV information file is badly arranged, as the system recognized that column in the worksheet has been engaged twice. There may be the problem with data parsing of your csv file, in case it has other than UTF-8 encoding or the headers with the same titles. Make sure that the file was parsed properly during fast product appending and you indicated correct delimiters. Look at your line breakers, or else your file will be treated as one massive line.
Invalid value for ... column (... does not exists?) in rows: ...
It was referred to above, this shopping cart is very peculiar about the format of file you are going to perform Magento import from. Thus, you have to adhere to tight requirements, this shopping cart has concerning the rows and data essential for input. More find www.magentocommerce.com.
Besides, the creation of new products via fast product import requires some fields, but their update calls for the other ones. There is no straightforward way to import having only a couple of fields, bringing up-to-date only the needed info using out-of-the-box import from. csv approach. Nevertheless, it is not the problem for Store Manager for Magento that does not determine requirements that you need to stick to. In this way you can revise only some part of the content lowering down the time put into the process.
“Product Type is invalid or not supported”
The platform allows its customers to provide several kinds of products, thus the product type (type_id) column of your file should incorporate the values that indicate whether the product is simple, configurable, grouped etc. Under the circumstance, you have the data about product type inserted, but you still deal with the problem, check if your file row titles are identical to database fields names. On contrary, the content may be not revealed and neglected. You can use some column linking tools like Store Manager program has, that will dismiss the necessity to re-name columns manually at your file.
Orphan rows that will be skipped due default row errors in rows ...
Magento gives to business owners disposal the possibility to handle items of a complex type like configurable, bundle or grouped items that have related goods connected to them using associations. This error implies that this relations were not kept and child-items were disassociated in the process of product upload.
“Image Does not exist!”
The acceptable directory where pictures should be positioned is media/import. Please verify if your picture names indicated in the import .csv file do not have slashes. Example: for the file /media/import/i/m/image123.jpg the appropriate file entry is image123.jpg, not /image123.jpg. More on possible reasons of the problem here.
To sum up, those are only a few errors that most often occur when merchants try to import their goods. Hope that with Store Manager software, you will forget about them and won’t see any further performing the procedure of data upload -
In case you have any issues with import, send us your file with comments about issue and we will check it for you free of charge! Check my file!
Case Study: Products are Not Visible at Front-End after Magento Import Unless Re-Saved
Check the list of solutions of non-displayed Magento products after import unless they were resaved. Read More...
i m facing one error while uploading sheet.
Total 5000 product was their in my website but when i upload .csv with 5000 products, it always show more than 12000 products in sheet.
I cleared catch but still it showing same error.
can any one help to resolved.
Thank you for your comment.
It would be appreciated if you share a screen capture of the error you get, so we could check it and maybe advise you on this regard.