Magento 2 bulk product import with images

With our extension the Spreadsheet Product Master you can import product data inclusive product images. For this you need a Google account and our extension. How to set up the exension please look at this video.

In the view above you see the Google Drive folder where the spreadsheet for the product data remains and a folder to store all the image data.

The spreadsheet contains all the data which also can be modified in the Magento 2 admin area. The important part for the image bulk update is the SKU. With the SKU you can specify which folder should be assigned to which product. For this you have to go into the image folder from the image above and there you are creating a subfolder named exactly like the SKU. If you starting a export process this will be done automatically. After creating a new row/product in the spreadsheet it will also create a folder like this automatically after the first import is running.

If the image folder and the SKU are matching for the extension it is clear which product and which image are belongs together. Additionally the extension will append the name to the SKU folder. But this part is optional and will be only used for a better usability. The name of the image folder will be “[SKU] – [Product name]”. E.g. if the SKU is product-a and the Name is “Product A” the folder name will be “product-a – Product A”. But if you create the folder manually product-a as a name is enough. Please look here for an empty spreadsheet.

The position is specified by the alphabetical order of the images. Additionally it is possible to include some keywords in the image name to e.g. set the thumbnail or base image. The following keywords are allowed:

  • base – If the image contains this keyword, it will be the base image of the product.
  • swatch_image – The picture will be the swatch image of the product.
  • thumbnail – When the image name contains this keyword the image will be marked as thumbnail.
  • small_image – To specify the small image the keyword small_image should be part of the image name.

Go to Extension