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.Images-to-import.csv (873)
  • 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.

  • Pingback: Magento import and export all products,categories and images using csv file - FaQ()

  • Alex

    i updated my store’s products and imported using the normal import tool and I ran this script after due to images missing and this is what I got:

    #1146 – Table ‘ocgadget_dev.catalog_product_entity_media_gallery’ doesn’t exist

    • The images are stored in the catalog_product_entity_media_gallery table. So check that table if exist in your database.Also check catalog_product_entity_media_gallery_value table is exist. These are not exist you need to restore correct database with all tables and then try to run this SQL command.
      Check this images..
      Thanks

    • The
      images are stored in the catalog_product_entity_media_gallery table. So
      check that table if exist in your database.Also check
      catalog_product_entity_media_gallery_value table is exist. These are not
      exist you need to restore correct database with all tables and then try
      to run this SQL command.

      Check these images of tables….

      Thanks

  • Pingback: How to import and export all products,categories and images using csv file in Magneto | Fixwebprobs()

  • After I followed the Step 3 – click “run profile” button,
    the popup window keeps reading as below:
    “Image does not exist.”
    “Skipping import row, required field “sku” is not defined.”

    These 2 sentences repeated multiple times. Is this normal??

  • I heard many times the Magento direct Exporting feature was no good. Need to use the Run Profile option instead. Now I’m using the CSV from the direct exporting feature. After import the the image issues took place as expected….

  • Marcos

    I sent all images and I tried to run this SQL, but I think nothing was affected. I receive this message:
    0 rows inserted

    • Marcos

      Just to complete. I habe both tables: catalog_product_entity_media_gallery and catalog_product_entity_media_gallery_value