How to Import/Export Products into Magento? Posted by Stranger on 6:49 AM Digg it Bookmark it Stumble it Email to friend

Here is a small details about exporting products in to magento. This was one of my friends thoughts named vaseem


Step 1 – Add a new product manually
I am assuming that your store already have at least one product with particular category assigned to it. If not then please add one product and fill the required fields else the below functionality of import/export wont work and you will get a blank xls file.

Step 2 – Export Your Products
Now we want to export your product to a .csv file so that we can view the fields that are required to import. Go to System >> Import/Export >> Profiles. Now click on Export All Products (you can find this option in default rows there) then Run Profile. Click on the “Run Profile in Popup” button. Once the export is completed, go to your var/exportdirectory on your Magento install and you will find the .csv file there for you to download.

Step 3 – Analyze The .CSV File and make some modifications (If required)
Now if you look at your .csv export file you will see the field names that you need to match up. Now just start filling yours in and creating your csv file ready for import. This step is extremely important. Otherwise Magento cannot match what you are trying to import and the importing will fail. At a most basic level, here are the fields that I imported:

• store
• attribute_set
• type
• sku
• category_ids
• status
• visibility
• tax_class_id
• weight
• price
• name
• description may be more
  

Step 4 – Import Your New .CSV File
Now go to System >> Import/Export >> Profiles. Now click on Import All Products. Change “Type” under Data Format to CSV/Tab Seperated. Now click on Upload File, and browse for your .csv file and click “Save and Continue Editing”.
Now go to “Run Profile” and select your file from the dropdown menu. Click the button underneath to run the import. All your products should now be imported.

That was the easiest most simple approach that worked well for mine.
Dont forget to upload Images (upload media folder as images of products and categories reside in that) and Quantity numbers manually.