Import bulk products in magento with multiple images

product-import-export

Importing and exporting products can sometimes be a tricky task in magento. Recently one of our client want to migrate all products from one website to another. We have use default Magento product Import/Export Feature. Using this feature we can easily migrated products. The default magento import/export feature unable to import products data with multiple images. In this article we demonstrate how we can import bulk products with multiple images.

Problem with existing product import /export feature

The default magento import/export feature allow user to import products, but the default feature doesn’t allow us to import product with multiple images like small_images, thumbnails.

Proposed Solution for existing problem

To resolved this problem we need to perform a separate import product with multiple images. In this article we demonstrate how to import bulk products in magento with the multiple images.

Step1: Export product data

Follow below steps to export product data:

  1. Go to Admin > System > Import/Export > DataFlow – Profiles
  2. Click on the Export All Products link

    import-export-product

    import-export-product

  3. After run the profile,the exported CSV file will be placed in the /var/export folder. Edit the exported CSV file and remove the image, small image and thumbnail image columns because magento will not import the product if it can’t find the referenced image . So better we will perform a separate import for images, small image, and thumbnail image. After edit columns save the exported CSV file.
    run-profile

    run-profile

     

Step2: Import bulk products in magento

Follow below steps to import product data:

  1. Go to Admin > System > Import/Export > DataFlow – Profiles
  2. Click on the Import All Products link

    import-export-product

    import-export-product

  3. Upload the CSV file and Run profile.

    upload-run-profile

    upload-run-profile

This process will import all product from CSV into our new magento website.

Step3: Importing product with images

Follow below steps to importing products with images:

  1. Put products images in the media > import folder.
  2. Create a new CSV file with the following columns: sku, image,small_image,thumbnail.
  3. Copy the sku,image,small_image and thumbnail columns from the exported CSV file and save with name prod-image.csv.
  4. Create a new DataFlow profile called Import Product Images
  5. Upload the Newly created CSV file.
  6. Run the Profile.
add-new-profile

add-new-profile

Conclusion

Perception shows that Products images plays a very important role in selecting and purchasing a product for the consumers. Business owner don’t want to import products without images. So after import all products, now we need to perform a separate import for images, small image, and thumbnail image.

References

Import bulk products in magento with multiple images was last modified: August 17th, 2018 by Ajay Mehta