If you really want to make Magento category import easier and faster you need to know a few important things before starting to transfer .CSV files. Let’s start from the file preparation.
First of all edit your file. You can do it using any usual text editor. However, it is better to open a file with any spreadsheet program. Here are the recommended symbols that can be used as separators - ",", ";" or "|".
To find out more information about all the demands for .CSV files read here.
A lot of people face problems during the field mapping. Here are a few things you have to know about this step to make the import successful.
With File2Cart, the fields can be mapped automatically. If your file does not contain one of the required fields it is necessary to add them, otherwise the import process won’t be performed successfully. Here are the required fields:
- Product ID (SKU);
- Product Name (SKU/Product Id);
- Full Description (Short Description/Description);
With File2Cart, it is possible to use Product Name (SKU) instead of Description.Below you can see an example of .CSV file with the columns that you can use:
If your file contains some fields that are formatted in a different way, it is recommended to map them manually using a special data preview The main categories have to be divided by Separator Delimiter, subcategories - with Path Delimiter. Separator delimiters and Path delimiters should consist of one character.
Separator Delimiter - |
Path Delimiter = /
In this case, your categories should look this way:
Pay attention at price format. Your file must contain integer prices or fractions.
Note: 1,000 or 1.000 = $1. NOT $1000
Here are some category delimiters: / \ | ; > ,
It is not recommended to put the similar kinds of delimiters for categories and columns, but if you have those, make sure that category fields are limited this way - (“”).
“Category1/Subcategory1” NOT Category1/Subcategory1
When your file is checked and ready for import, there are only six simple steps and all the necessary data will be easily transferred to your Magento store.1. Register an account on File2Cart website.
2. Set up your target Magento cart and provide its URL. Then connect Magento store with the server download Connection Bridge. To find more info and a video tutorial visit this page.
3. Select the entities you want to import and upload a file.
4. Pass field mapping.
Don’t forget about required fields. If needed, fill optional and additional fields. Also, you have an opportunity to add 4 additional product images.
5. For your convenience and safety try the Demo Import of 10 products. It is possible to skip this option, but it is highly recommended performing it just to ensure that all the fields were mapped correctly.
6. Now check the results on your Magento store and start Full Import!
With File2Cart, you can make your import regular. The only thing that has to be done is choosing Scheduled Import after the Demo import. There is no need to be a skilled programmer to create Scheduled Import. It is a fully automated and easy to use option, so there is no software to install. For more information about how to set up Scheduled Import read here.So, if you want to start importing categories right now all you need to do is register an account. Make your import process easier and faster with File2Cart.