Bulk upload product images

To upload your images, you will need to create either a Cloudinary account or a Google Drive account,  if you don't have one. 

Uploading images with Cloudinary

If you would like to use a Cloudinary account, follow these steps below:

  1. Login and create a folder (the name is not important) 

  2. Upload your images that have the product SKU as their filename inside the new folder
  3. Copy the image URL of a product

Assuming the image filename is the product SKU, the URL you copied will have a pattern like this:

<Cloudinary folder path>/<SKU>.jpg

An example URL will look like this:

https://res.cloudinary.com/**********/image/upload/v***********/product-images/10110.jpg

Then you can export your existing products and edit the image_url column. It should have a dynamic value which will be the concatenation of:

  1. Your Cloudinary folder path
  2. The value from the product_sku column
  3. The file extension of your images (eg .jpg)

Then save the XLSX file with the image_url (and gallery_image_url columns) filled in for all products and import the spreadsheet. (Read about importing products here).

If you have many products you can test this process for 2-3 products initially and, if successful, proceed to upload the full list of products.

Uploading images with Google Drive

If you would like to use a Google Drive account, follow these steps below:

  1. Login and create a folder (click New > Folder > input the name you would like for your images folder > Create)

  2. Upload your images or image folders onto Google Drive, placing them in your newly created folder
  3. Right-click on the folder you created > select Share > in the window that opens up, if the permission status under “Get link” shows Restricted, click the option underneath to Change to anyone with the link (you can leave this set to ‘Viewer’ in the toggle that appears to the right)

To enable sharing all your images without having to do the same process for each image you can:

  1. Select all images in the folder (select the first image > scroll to the bottom > hold down SHIFT and select the final image > this selects all images in the folder). Note that if you have created subfolders within the main folder for your product images, you will need to repeat this process for each subfolder.
  2. Right-click anywhere within the folder > select Share > in the window that opens up, click the ‘Settings’ (gear) icon

  3. Make sure that the box is checked beside Viewers and commenters can see the option to download, print, and copy option

Bulk copying the image URLs

There are a couple of different ways we can then retrieve the image URLs for each of the images in your Google Drive folder:

  1. You can right-click on each individual image in your folder > select Get link > click Copy link in the window that opens up.

OR

  1. You can download a Google Chrome add-on to export all image URLs from Google Drive such as Drive Explorer.
  2. Right-click on the main Google Drive folder housing your product images > select Open with > select Drive Explorer

  3. A new tab will open up containing all of the download links for the images in your Google Drive folder > select Export CSV to open the links in Excel 

Then you can export your existing products from B2B Wave and edit the image_url column. For products where you have more than one image URL, insert a column to the right of the image_url column, titled gallery_image_url1 (repeat for each additional image you would like to add, naming the new column gallery_image_url2, gallery_image_url3, and so forth.

Then save the XLSX file with the image_url (and gallery_image_url columns) filled in for all products and import the spreadsheet. (Read about importing products here). 

If you have many products you can test this process for 2-3 products initially and, if successful, proceed to upload the full list of products.

Our support team has helped hundreds of customers upload their products. Should you have any questions, please contact us.

Still need help? Contact Us Contact Us