How to import products into Magento?
13 May 2009
8 Comments
Suppose you have products around 35000 or more and you want them to be added to your magento store. Here are the few steps you will take to import products into Magento
- Go to Magento Admin > Catalog > Manage Categories
- Add your Product categories here but do note your category ids, you can make a list of your category ids in a notepad file.
- There might be a possibility that you need to define extra attributes for your products so for that go to Catalog >Attributes >Manage Attributes and click Add new Attribute. You can also save your Attributes sets based on the attributes you have defined.
- Now go to Magento Admin > Catalog > Manage Products
- Add four to five products manually.
- Now go to Magento Admin > System > Import/Export > Profiles
- Click Export all products.
- In Data Transfer choose Local/Remote Server (If you choose remote ftp, then you will have to provide the ftp information)
- Any select Local Server (though its upto you) and click Save Profile.
- Now click export all products again and then click Run Profile on your left.
- This will save a csv file of your manually added products on to your local/remote folder
- Download that csv file on to your computer using any ftp client.
- You will have a csv file having columns of all the product attributes such as store, websites, attribute_set, type, sku, category_ids, has_options, name,meta_title etc
- Populate these columns with your products and add the category ids that you had already saved in a notepad file in category_ids column to properly assign the products to their respective categories.
- When you are done, go again to Magento Admin > System > Import/Export > Profiles and click Import all products this time.
- Click Upload file, browse for that csv file and then click Save Profile. (Or you can upload the csv file via ftp client such as filezilla to var/import folder)
- Now again click Import all products, click Run Profile, Select the csv file that you have uploaded from the drop down and then click Run Profile in popup.
- Products will start importing into your Magento Store
hi there, awesome post that is very useful for beginners and novice ones like me
, so i appreciate your work and looking for more explains in magento simple tasks cause i would like to be professional like you, thanks 
Like or Dislike:
0 
1
For those who want to switch to magento and search the net in search of advice. There’s a tool which may help – cart2cart web service. It automatically moves not only products but also customers, orders and other data fm your current shopping cart to Magento. For details you may check http://www.shopping-cart-migration.com
Like or Dislike:
0 
0
This is great information but I have a problem. I have some products that will belong to multiple categories. When I add a test product to 2 categories, lets say category id’s 10 and 18, and then export, in the category_id field of the CSV that product has 1018 written. I would expect 10|18 or 10,18 or something like that. Any ideas what this field would expect on import for multiple categories?
Like or Dislike:
1 
0
@Chuck Cheeze
I added few products to my store and then exported the csv file and its something like 5,57,59 for the category_id
You can download the sample csv file which i exported by
http://techies-blog.com/downloads/samplecsv.zip
I hope its makes things clear!
Like or Dislike:
0 
0
Infact a very good and informative post for a magneto beginner. It can be used as a tutorial as you’ve provided a step-by step guide on how to import products in a magneto store.
Like or Dislike:
0 
0
Great Tutorial, this helped me a lot. However, for anyone using Excel on a Mac to edit your csv file please note that you need to save the file as csv(Windows) for the import to work. Other tips:to save time you do not need to fill out the url if you want it to be the same as your product name with ‘-’ for spaces. Also, every attribute you have will be its own column. Hope this helps for anyone using Excel.
Like or Dislike:
1 
0
possibly another option this module will do this as well. http://www.magentocommerce.com/extension/1894
also handles configurable product imports / bundled product imports / grouped product imports / tier pricing / custom options / images / multiple images and gallery images
Like or Dislike:
0 
1
Nice post, I found it very easy to upload new products via the import tab, although I think magento could make it easier to upload products in bulk!
Like or Dislike:
0 
0
Leave your response!
Stay in Touch
Sponsored Links
Tags
Archives
Blogroll
Pages
Recent Posts
Recent Visitors
Rate my Blog
Lets Connect
Most Commented
Recent Comments
Twitter links powered by Tweet This v1.6.1, a WordPress plugin for Twitter.
Powered by WordPress | Log in | Entries (RSS) | Comments (RSS) | Arthemia theme by Michael Hutagalung