If you have a lot of items in your catalogue, uploading each image one-by-one can be cumbersome. The Onsight admin console allows you to bulk upload your product images instead. Before you can bulk upload product images, you need to upload all your products without any images. If you have not done so already, please follow this guide to bulk upload all your products. After you have completed your product import, you can proceed to Step 1 of the process below.

Step 1 – Download the product image data sheet

• Create a new empty folder on your computer.
• Copy the product images you want to upload to the new empty folder that you have created.
• Log in to the Onsight web console at https://web.onsightapp.com/.
• Click on ‘Catalogue’ from the left-hand side menu.
• Click on the ‘Manage Products’ menu item.
• Click the ‘Action’ button at the top of the screen.
• Select ‘Import Product Images’ from the drop-down list.
• This will open up the 5-step bulk upload tool.
• Select ‘Download’.
• Download and save the product image data sheet to the new folder that you previously created.

Step 2 – Add image files from your computer to the product image data sheet

• Open the product image data sheet that you have just downloaded.
• Most of the cells in this data sheet are locked and cannot be changed. Please do not unlock the cells. There is only one column that is unlocked. That is the only column that you must edit. All other columns must remain unchanged.
• You will see the following columns:
  
   

  Column name	Description	Instructions
  Onsight ID	The Onsight system allocates an unique ID for each item name	This field cannot be changed
  Item Name	This field displays the name of all your products	This field cannot be changed
  Image File Name	Use this field to add new images	You can add one or multiple file names into this field. Follow the steps in the next section.
  Primary Image	If you already have at least one image uploaded for a particular product, then the image link will display in this field.	You can click on the file name to view your image. This column cannot be changed so you cannot edit or delete the information in this field.
  Image 2	If you already have more than one image for a particular product, then the image link will display in this field.	You can click on the file name to view your image. This column cannot be changed so you cannot edit or delete the information in this field.
  Image 3 etc	If you already have more than two image for a particular product, then the image link will display in this field.	You can click on the file name to view your image. This column cannot be changed so you cannot edit or delete the information in this field.

   

• Type in the image file name(s) next to the relevant product in the column called ‘Image File Name’.
  
   

  Guidelines for adding image file names
  1	The file extensions / image formats can be JPG, JPEG, GIF, PNG. You can also use an image URL.
  2	If you want to add multiple images, you can list all the file names in the ‘Image File Name’ column separated by a comma without a space in-between. For example: Pic1.png,Pic2.png,Pic3.png
  3	List your file names in the order that you want them to be displayed.
  4	If you already have an image listed as the ‘Primary Image’ for a specific product, you can replace this image by typing a new file name into the ‘Image File Name’ field and adding that new image file to your folder.
  5	If you want to add a second image to the existing image, then you need to make sure that both the original image file plus the new file are listed in the ‘Image File Name’ field and you also need to make sure that both the original image file plus the new image file are in your new folder. If you only list the new image, it will replace the old image.
  6	If your image file names are structured (eg. all images are named after the product code, for example) then you can easily generate the image name field by copying and pasting in Excel and by using some Excel string manipulation techniques. If your image file names have no structure you will have to type them in one-by-one.

   

• When you are done with your changes, save the sheet. Both the individual product images and the product image data sheet should now be present in the new folder.

Step 3 – Zip all your image files and the product image data sheet

• You need to zip up the folder. On a Windows computer you can highlight the product images and the product image data sheet within the folder. Right click > Click “Send to” > Click Compressed (zipped) folder.
• This creates a zip file which contains all of the images as well as the product image data sheet.
• Your zipped file must not be bigger than 200MB. If your file is bigger than 200MB, then you can remove some image file names on the sheet as well as the actual image files from the folder and upload them in batches.

Step 4 – Upload your zipped file into Onsight

• Log in to the Onsight web console at https://web.onsightapp.com/.
• Click on ‘Catalogue’ from the left-hand side menu.
• Click on the ‘Manage Products’ menu item.
• Click the ‘Action’ button at the top of the screen.
• Select ‘Import Product Images’ from the drop-down list.
• This will open up the 5-step bulk upload tool.
• Click ‘Select File’ and choose the new zipped file that you have created.

Step 5 – Import your zipped file into Onsight

• Click ‘Import’ to upload the newly-created zip file to your account. You will get a message that notifies you if the import has either failed or been approved.
• Click ‘View and Approve the job’ to check that everything is correct.
• Click ‘Approve Job’ if you are satisfied with the import.

All the images will now sync to your account.

How to handle image file names

Typing out each and every image name one by one into the upload spreadsheets can be cumbersome. It is better to have your images named according to one of the product fields. Then you can easily generate the ‘Image File Name’ field by copying and pasting in Excel and by using some Excel string manipulation techniques. Let’s say that your images are named after the product code. You can copy and paste the product code field into the ‘Image File Name’ field. Then you just need to add the file extension (eg. .JPG) to the field in order to complete it.