When importing Magento products to another Magento store, it will take lots of time if we insert products one by one, thus we will need an automated way to do this.
In this tutorial, we will guide you how to import multiple simple products and Configurable products in Magento using CSV file.
Export product and create template for importing product
In this part, we will create a sample product, export it and use it as template for importing multiple products.
Step 1: Create category
Now, go to your Magento admin backend -> Catalog -> Manage Categories.
Now add a new category by filling in all the required fields and click on Save Category
Remember to save ID of the new category.
If you want to add more attributes for the product to import, go to Catalog ->Attributes ->Manage Attributes -> Add new Attribute.
You can use this function to add custom attributes other than default attributes of Magento.
Step 2: Add sample product to Magento
Now we will add a sample product to Magento, after that we will export this product and use it as template for importing all the other products. Remember to add all the attribute you want to use for the product in this sample product. Go to Catalog > Manage product > Add product
Now we are ready to create sample export and we will use it as template for importing other product. In Magento backend, go to System -> Import/Export -> Dataflow – Profiles.
Select Export All Products
In Profile Information -> Store choose the store in which you created your sample product.
In Data Transfer, select Local/Remote Server to store your file in your hosting. This path field specifies you where you can find the exported file. After everything is set, click on save profile and next click on Run Profile in Popup.
Wait for the module to run, when everything is done you will see this
Next, use some software like Winscp to connect your Magento hosting server and go to var/export/ to get the exported csv file.
Now open the file and you will see columns corresponding to attribute value. Now insert the id of the category you want to assign to the product and add more products you want to import to this file.
Next, Go to Admin -> System -> Import/Export -> Dataflow Profiles and select Import All Products. Go to Upload file and Browse for the file you want to import.
Finally, run Profile to start importing your product
If there’s no error with your import, you will see the following message
Go to Product section to see the imported product and start to reindex.
It’s a bit more complicated to import configurable products, there are many 3rd Magento extension that can help you import Configurable product. In this tutorial, we recommend using the most popular tool: Magmi
Magmi is the most powerful tool to import both simple and configurable product in Magento
Click on this link to download Migami: http://sourceforge.net/projects/magmi/
How to install Magmi
You can find document on install Migami here: http://wiki.magmi.org/index.php?title=Installing_Magmi
How to import Magento configurable product with Magmi
We will need to install a plugin to enable importing configurable product in Magento, check it out here: http://wiki.magmi.org/index.php?title=Configurable_Item_processor
Full wiki page for usage of Magmi can be found here: http://wiki.magmi.org/index.php?title=Main_Page
The wiki page shows you full tutorials on using Magmi, if you have any questions please drop a comment here or there’s a dedicated forum for Migami users which can be found here
Good luck on importing Magento product