101 Magento Import Questions
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 CSV import 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 product upload questions/answers prevailing in the retrieval of any search engine. The inquires are grouped into clusters for more handy examination.
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.
Check there the article with required fields and format of data in them when you use Import/Export built-in Magento functionality - https://www.mag-manager.com/useful-articles/tipstricks/required-csv-file-values-for-error-free-magento-import-via-admin/
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: 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: 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 import, as the system might not recognize them (check the first question/answer in this section to see required fields that should be included importing using default upload method).
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 beore import from csv, unless you use Store Manager for Magento* that allows to input changes on the fly.
Errors that occur during import into Magento
Question: “Performing upload 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. Check also column names. They should be the same as Magento database names, otherwise they might simply be not recognized. 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 (open it in NotePad++, there select UTF-8 without BOOM).
Question: “” is no valid value for “...”
Answer: Make sure the column names do not have unnecessary spaces in file. Column names should be identical to database names. 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 long line.
Question: Invalid value for ... column (... does not exists?) in rows:
Answer: As was mentioned, using import you have to stick to strict requirements Magento has concerning the fields necessary for upload. Read here the Magento tutorial - http://merch.docs.magento.com/ce/user_guide/Magento_Community_Edition_User_Guide.html#store-operations/data-transfer-manage.html
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 CSV to be imported. 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 and the ones that support all Magento product types import, 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 CSV import.
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. Important thing is also that Magento built-in upload tool does not allow import of all product types with associated items (does not import bundle, grouped products). 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 for importing it back.
Question: How to import position of associated products?
Answer: Default 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 uploader of Magento, then prior to bringing products up to your store, you will need to manually create all the categories you wish to assign them to. 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 spreadsheet with main categories and subcategories.
Question: In what way to import products into multiple categories
If you want to assign products to multiple categories via import/export, your categories should be formatted in this way: each category path should be in separate line and root category need to be indicated in separate column. Check the screen-capture
To list product into 2 categories using above mentioned 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: First of all, place all images you are going to upload to media/import folder at your FTP. Next you need to work over our import file. For example, if you are planning to add 5 images to one and the same product you need in _media_image column of your file add image name with leading backslash. Each image should be in next line.
Important for Magento 1.9 and later: you can use 'gallery' column of your file. There you can add an array of images, which is expressed as a semi-colon delimited list e.g. /name1.jpg;/name2.jpg relative to '/media/import'
As for other fields related to images:
- _media_lable -> some text as image lable (note lable => this is not a typo!)
- _media_attribute_id -> the id of your media gallery - check ID at Attributes - Manage attributes section or export one product with images and verify this
- id_media_is_disabled -> value = 0
- _media_position -> number to indicate position from 1 to ...
Moreover, in case you need your images to be marked as small, base and thumbnail you need to have images the separate columns of your import file.
In your import 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 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 data 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 transfer 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 import on schedule?
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 import from csv formatted file (quantity should be bigger than 0, visibility - Catalog 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 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 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:Submitted 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 data uploa 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