Magento import and export all products,categories and images using csv file

75

How to import and export all products,categories and image using csv file in Magento.Here easy method to import and export all products without doing any errors and issues.

Note:- My Magento version is 1.7

1-Export All Products, Categories and Images

1.1-Export All Products

1-Log in to the Magento admin panel
2-Go and click System -> Import/Export ->Export
magento-export-products

3-Select Entity Type “Product” ,Export File Format “CSV” and then the click “Continue” Button at the Bottom.
magento-export-products

First of all Change the “var” and “media” folder permissions to 777.

Also you can,
a-Go to the System ->Import/Export -> Dataflow – Profiles.
b-Select Export All Products.
c-Then select Entity Type “Product” of the select box.
d-Click “Save Profile” Button.
e-After saving go to “Run Profile” and click the “Run Profile in Popup” button.Don’t close new opened tab of the browser.
f-When execution is finished, then go to the /var/importexport and you can view catalog_product.csv file.

1.2-Export All Categories

1-Download and install Magento import_categories Extension.
Download import_categories Extension

2-Then go to the Mageworks->Export.
3-You can view at the bottom “Export Profiles“. Click on the “Categories” link.
4-Go to the /var/export/category using CPanel or FTP.
5-You can view “categories.csv” file there.

1.3-Export All Images

1-Go to the /media/catalog using CPanel or FTP.
2-Simply download all category and product folders.There are all images of the all products and categories.

2-Import All Products, Categories and Images

Export process is done.Now consider about the import products.There are lot of issues of this import process of many users.Think this is easy if you follow the correct instructions.

2.1-Import All Products

1-Log in to the Magento admin panel
2-Go and click System -> Import/Export -> Import
3-Select Entity Type “Product” ,Import Behavior “Append Complex Data”,Select File to Import and then the click “Check Data” Button.

Also you can,
a-Go to the System ->Import/Export -> Dataflow – Profiles.
b-Select Import All Products.
c-Then select Entity Type “Product” of the select box.
d-Select “Upload File“.Click “Save Profile” button.
e-After saving go to “Run Profile” and select previously you uploaded csv file and click the “Run Profile in Popup” button.Don’t close new opened tab of the browser.
f-When execution is finished, then go to the System -> Index Management -> Select all check boxes, select action as “Reindex Data” and click Submit button.
g-If not display products go to System -> Cache Management -> select all check boxes and “Flush Magento Cache
e-Then you can view your products.

2.2-Import All Categories

1-Upload the category.csv file to the /var/import/category folder.
2-Select previously you installed Mageworks->Import.
3-Under the Import Profiles -> Click “Categories” link.After finished the execution you can view categories.If not display reindex your product categories and clear Magento cache.

2.3-Import All Images

This process doing if don’t have images of the each products.
1-Upload you downloaded images with folders to the /media/import
2-Run the following MySQL Query in the database.(Remember this is only run if don’t have images of the each product.)

3-Clear all cache in the Magento admin panel and then see the images.

Read about this issue from “Magento product images missing after import products”

Share.

About Author

Sumith Harshan is the Web Engineer Specializes in Java Script, JQuery, HTML4/5, CSS2/3, PHP, CodeIgniter, CakePHP, J2SE, J2EE, XML, Hacking & Security, Mobile Interface Developing, Magento, Wordpress, Joomla, Drupal,PHPBB,Facebook App Developing and Open cart...etc.