Magento import makes it more convenient and faster to create even the biggest web shops. It helps economize time and smartly organize store data, sparing without manual data inputting or updating. Though Magento data upload facilitates the work of Magento users, it can oftentimes bottleneck and go wrong.
Web entrepreneurs encounter unpleasant glitches, which can negatively influence the catalog, since Magento upload is a bulk operation. To that end, it behooves you to be vigilant about the ways Magento platform can nonplus and, what is more important, learn how to improve matters, if the malfunction reached you.
Let’s tackle into the possible issues, you may face during Magento import, and consider what actions to resort to when some of them occurred.
Possible Error: “Skip import row, required field “...” not defined”
The way out: This is one of the commonest obstacles Magento users stumble upon. To shortout this problem, make sure values are specified in this very field. All the entities, the file comprises, should be listed in separate rows. The first row must be the header. Furthermore, ascertain UTF-8 is used for encoding - open the file, you import from, through any spreadsheet program and check what is designated under Encoding.
Possible Error: “” is no valid value for “...”
The way out: Having encountered such an issue, one must look through file column names. There might be extra symbols that are not supposed to be included, e.g underscores. Ensure, this column includes data, since it’s mandatory and is required by Magento. Take into account, in case file column titles differ from database fields name, you are to map the fields, using your Magento import utility.
Possible Error: “Image does not exist”
The way out: This is highly annoying, especially when you need to upload multiple products with images. When this is notified, Magento images were not uploaded properly or were not uploaded at all. Verify whether image names have no slashes, for example, picture.jpg but not /picture.jpg should be indicated in the file. One more thing is that, all the images should be placed to media/import folder.
Possible Error: “Column names have duplicates”
The way out: If Magento shows such an error, you, most likely, have a mess with your file. Magento notifies that columns are included twice. Check whether the file has UTF-8 encoding and column titles are the same as database field names.
Possible Error: “Product Type is invalid or not supported”
The way out: There are several kinds of products you can manage with Magento and it’s obligatory to include type_id column and designate what the type this or that item belongs to. Thus, have a glance at the file you perform Magento import from and check whether the column, responsible for product type, include the values.
If everything is specified properly but you still get this error, compare file header and database field titles. If they differ, you should either re-name file columns or associate them using the tool for fields mapping.
Magento data appending from the file is supposed to be a top-grade way of web shop content management and should be accomplished without a hitch, what is not always attained. Running across even the slightest issue you should be familiar with it and do your utmost to improve matters.
Read related article to find out what are the commonest Magento import inquiries and answers to themhttp://blog.mag-manager.com/2013/01/101-magento-import-questions.html