Working with Magento platform for more than 6 years already, we have noticed that the majority of questions asked by its users are related to the procedure of Magento import. This can be explained by the fact that Magento import from csv is evidently perilous because it brings changes to the whole data list, however, due to the same reason it is also one of the most widely-used as there is nothing faster for appending information.
Here we made up a list of Magento import questions/answers prevailing in the retrieval of any search engine. The inquires are grouped into clusters for more handy examination.
Question: How many products can be imported to Magento? Are there any Magento import limitations?
Answer: Magento itself has no limitations in the number of entities that can be uploaded. However, the procedure depends on your server resources, so make sure that you have enough of them or search for means to improve it. More info here.
Question: What file format is supported? Can I import from Excel?
Answer: Magento supports CSV and XML formats for importing, if you are trying to import with an XLS file, you need to convert it to supported format.
Question: Where can I get the sample of the file suitable for Magento import from csv?
Answer: You can ask for it your developer, also by exporting products to the file, you can get the idea what column names there should be and what data need to be listed there. Further you can provide the file to your supplier as a sample. However, remember that not always exported file works for importing it back.
Question: Should my column names be the same as database names or supplier names?
Answer: Magento has strict requirements to the columns listed at your store and often in case the column names do not coincide with database names, they can be ignored during Magento import, as the system might not recognize them.
Question: If I need to change anything? Should I do it in the file or there is some other way?
Answer: You should do all the data modifications in the file before Magento import from csv, unless you use Store Manager for Magento* that allows to input changes on the fly.
Errors that occur during Magento import
Question: “Performing Magento import using a csv file with number of products, there occurs "Please wait..." screen and the process hangs and then times out.“
Answer: Extend maximum execution time, increase memory limit and other possible server resources. You can also try to separate the file in portions and import in chunks. Alternatively, use solutions that can handle the procedure and do not require huge server resources.
Question: Skip import row, required field “...” not defined
Answer: Check if this field has the values indicated, if not, input them. Each entity should be in separate row and the first one needs to be the header. In case all the data are there, try to open the file using any spreadsheet program making sure that character set has UTF-8 encoding.
Question: “” is no valid value for “...”
Answer: Make sure the column names do not start with an underscore in your Magento import .csv file. Check if the column mentioned in the error is field with data (is not empty), as this field is obligatory and required by Magento itself.
Question: "Column names have duplicates"
Answer: Magento is telling you that your CSV file is improperly formatted, as it's detected a column's been included twice. There may be the issue with encoding if your file has other than UTF-8 or the headers might have the same names. Check line endings of your file, as in case there are no line breaks, entire text file will be treated as one line long.
Question: Invalid value for ... column (... does not exists?) in rows:
Answer: As was mentioned, using Magento import you have to stick to strict requirements Magento has concerning the fields necessary for upload. Read here which ones are obligatory ones - http://www.magentocommerce.com/wiki/3_-_store_setup_and_management/import_export/export_tool
Even in case you are trying to update only some info, lets say just price, there is no simple way of doing that by having in the file just this column with Magento admin. You need to have all the necessary columns in Magento import csv file. As an alternative, you can use import tools with less requirements. Let’s say Store Manager for Magento* doesn’t dictate specifications that need to be kept, thus you can update only necessary columns reducing the time spent on the process.
Magento import of various product types
Question: What is wrong if I receive this error: “Product Type is invalid or not supported”
Answer: Magento allows its users to sell different types of goods, thus the column Product type (type_id) should contain the information that indicates to which type the item belongs (simple, configurable, grouped etc.). In case you have the type listed, but you still have the error, make sure that the column names are the same as database names. Otherwise, the columns may be not recognized and skipped. Also note that this field is case sensitive. You can also use some field mapping tools like available in Store Manager for Magento* to avoid having to re-name headlines of your file.
Question: Getting the following message during import: Orphan rows that will be skipped due default row errors in rows ...
Answer: Magento includes complex products like configurable, grouped or bundle and they have associated products linked to them. Make sure to indicate those associations in order for related products to be linked to parent one after Magento import from csv.
Question: What should be the structure of import file if I try to upload various product types?
Answer: Each product type requires some specific columns filled in. Special attention should be paid to complex products with relations. The best way to obtain the example of correctly configured file is to export some products first. But keep in mind that default Magento export file is not always suits Magento import.
Question: How to import position of associated products?
Answer: Default Magento import from csv functionality does not include this feature. However, Store Manager for Magento application supports import of positions for associated products for all types of products. It requires skus or ids of associated products in one column divided by comma and their positions in another column. It also allows to make import of the position for cross-sells, up-sells, and related products same way.
Magento categories import
Question: Can the categories be created at the same go with product upload or should I create categories first?
Answer: If you use default Magento import, then prior to bringing products up to your store, you will need to create all the categories you wish to assign them to manually. The import/export feature does not create product categories, it is only used to assign the products to the categories/sub-categories. If you need to create categories on the fly right during product import - use Store Manager for Magento.
Question: I need to built-up category tree of complex structure. Is it possible to create multi-leveled categories via import?
Answer: Importing via Store Manager for Magento, simply indicate full category path in your Magento import csv file with main categories and subcategories.
Question: In what way to import products into multiple categories
Answer: To list product into 2 categories using above solution, you need in your .csv file separate set different category paths separating them by double delimiter (lets say / symbol), then it should look like - Dog/Dog Food//Dog/Health Care
Magento image import
Question: Import multiple images to products. How?
Answer: In your Magento import csv file in the column for images put image names and divide them by separator, lets say - semi-column.
Question: Import of image from URL like http://suppliersite.com/images/imagename.jpg
Answer: If you have links to images, you need to download them before Magento import or use the tool that supports upload of pictures placed remotely, like Store Manager for Magento.
Question: Why do I get “Image Does not exist!” importing my images to Magento?
Answer: The correct folder where images should be placed is media/import. Please double check your .csv image fields that they do not have slashes. Example: for the file /media/folder/image.jpg the correct .csv field entry is image.jpg, not /image.jpg. More on possible reasons of the issue here.
Question: Invalid image type. What should be format of images?
Answer: Magento accepts 'jpg','jpeg','gif','png' image types only.
Question: Images are not saving as base, thumbnail or small.
Answer: Check if you assigned images to the mentioned image field(s) of database and to the media gallery while Magento import from csv.
Question: After Magento import some of my images were duplicated.
Answer: Run Store Diagnostics tool of Store Manager for Magento, get the list of duplicated images and remove them if necessary.
Other Import Data
Question: How to import Attribute sets?
Answer: Default Magento is obviously lacking of this functionality. Thus, you can use any third-party solution that handles Magento import from csv of attributes and attribute sets. One of them is Store Manager for Magento.
Question: How to copy custom options and add them to multiple product via Magento import?
Answer: Taking into account the fact that there is no import/export custom options functionality in Magento itself, you can use Store Manager for Magento to add custom options massively to products using import procedure.
Question: How to set up regular Magento import?
Answer: You can use some script and set up cron-job. If you are lacking of technical skills, you can use either import services or ready-made solutions for scheduled import (for example Automated Product Import***).
Issues after the process has been accomplished
Question: Products imported successful but do not appear in frontend
Answer: Try clearing cache and making full re-index. If you have any other third-party extensions, disabled them.
Check if you imported all the required fields for the products to be shown after the procedure of Magento import from csv (quantity should be bigger than 0, visibility - Сatalog or Сatalog, Search, stock availability - in stock).
Question: How is it possible to avoid re-indexing after the import?
Answer: Re-indexing is required after each bulk procedure, especially such as Magento import. If you do not follow this rule, you might not be able to see changes at your front-end. The most reasonable way it to automate this process. It is possible to do re-index of data right in the process of import if accomplished with Store Manager application.
Question: After the import I receive duplicated entities. How to avoid this?
Answer: Most likely your Magento import tool does not have the function to add and update products or wrong import option was chosen. There might be the chance that your product identifier (e.g. SKU) was changed and products were treated as new ones.
Question: Importing product special characters are discarded
Answer: Generally, Magento does not allow special characters for importing data generally. The working practice is to go to .htaccess file and remove # from AddDefaultCharset UTF-8 and open your csv file Save As under UTF-8 and then re-import.
Question: Did Magento import csv and uploaded entities become out of stock. How to make them in-stock in bulk?
Answer: Set column with stock status to 1 and do not forget that your products should have quantity 1 and more. Then re-import the file or change values on-the-fly with Store Manager for Magento.
Important Note - Make database backup before any mass changes. Even if you try to update only a few products, do not skip this step. It may be your lifebelt if anything goes wrong.
Naturally, it is not complete list of Magento import questions, errors and issues but we leave some room for adding new inquiries that emerge. If you have some questions on Magento import from csv or experienced some difficulties and have solutions that might be useful for other users, please, comment out here and they will be added to the collection. Hopefully, very soon we get over 101 questions that will help you to find the solution you are looking for.
** - Magento import
*** - Automated Product Import