Thursday, August 11, 2011

How to create a product in magento from admin panel ?

Log into admin panel in localhost with this url  ( http://localhost/magento/index.php/admin ) in default
Then go to Catalog tab in admin panel and take manage products.then click on add product button.Then you are asked to select an attribute set (default) and type of product you want to create choose simple product and click continue.
Then a new page appears
General
enter product name in name textfield,description,short description,sku,enable,catalog,search
Price
enter price
select taxable goods
Image
browse image and click upload and click all the radio button



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