How to CSV import simple and configurable Magento product

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.

• Import Simple Product
• Import Configurable Product

Simple product

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.

Import product

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.

Configurable product

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

Download Magmi

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

https://understandinge.com/forum/magmi-forum/

Good luck on importing Magento product