Cart2Cart  Seriously, this service saved me 100s of hours of work. I had over 1200 skus and they moved it over in a day. All the images, all the descriptions, categories... everything in tact. If you are on the fence about their ...  Cart2Cart
David Sammons

How to Import Categories to Magento Store with File2Cart

Magento Category Import

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 "|".

The second important thing (in particular, if the files contain special symbols) is that language should be UTF-8.
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);
  • Price;

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:


You can download sample CSV files (csv, ~3kB):
CSV with absolute image URL | CSV with relative image URL | CSV with image name only

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.
For instance:
Separator Delimiter - |
Path Delimiter = /

In this case, your categories should look this way:

1. Category1|Category2
2. Category1/Subcategory1
3. Category1|Category2/Subcategory1/Subcategory2|Category3/Subcategory1

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 - (“”).
For example:
“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.

Related Post

Import products to your store right away!

Customer Testimonials

Performed on Amazon Elastic Cloud
Secured by Globe SSL
Cart2Cart  I’d recommend the service to people who really value their time. Because File2Cart saved me LOTS of time and efforts doing the import for me. The highest speed that I ever saw. Cart2Cart
Date Written: 26 February 2012
Tom Sledge
Cart2Cart  I imported products with your one-time import plan. It was quite alright, for now the store functions fluently and all products are imported correctly. I consider using your scheduled import option, hope it works well ...  Cart2Cart
Date Written: 01 June 2012
Silvia Fox