Thursday, August 11, 2011

How to Create Excel csv file for product importing

First you create a product from the admin panel of magento.
Then in the admin panel go to System and select Import/Export profile
and select profiles then a window appears with options for exporting and importing.
Then click on Export All products and then select export method as CSV file from the option and click on save and continue.
Then on the left tab select RUN PROFILE and click on run profile button the you product will be exported .
you can get it from magento root folder then in the path = magento/var/export
then open the export.csv and you can see field name in the first row and in the second row product.
Just select the row and drag down to multiply and change product name ,description especially sku ,sku should be unique.then save and go to admin ->system->import/export profile->profile->import all products



Then change the xls file to csv file in the option tab in current window.
click on save and continue.
Upload file and click save and continue
Then RUN PROFILE then select your file from option and click on run profile button.
Then your product will be imported you can see the product in catalog->manage product in admin panel












No comments:

Post a Comment