Magento product images missing after import products

9

After importing products,sometimes you can’t view it’s images of that product.Product images are missing.If already included image names/path of the csv file this is happening.Here simple MySQL Query that will fill the missing records, and which you will need to run each time after importing products with images using CSV.

If you want to know properly import and export products it will describes my another article.

Note:- My Magento version is 1.4.2.0

Steps

  • Before you must export your images as csv file.You can view it’s format from this link.[download id=”29″]
  • Then upload your images into the /media/catalog/product folder.

1-Log into the Magento admin panel and go to the System -> Import/Export -> Dataflow-Profiles.

2-Select Upload File option.Upload your images.csv file and click “Save and Continue Edit” button.

3-Select Run Profile option.Then select that you uploaded csv file.Click “Run Profile in Popup” button.

4-After execution csv file, log into the database of magento. Run the following MySQL Query in the database.

5-Go to the System -> Index Management. Select all check boxes and re-index them.

6-Then go to the products page, open a product -> images, then you can see product images there.

If you don’t see them, clear all cache in the magento admin panel and then see the images.

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.