How do I bulk upload my images?

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 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.

The process that follows requires your images to be stored on your computer. If your product images are already hosted on the Internet (eg. on your website), you need to follow the bulk upload process for products instead. There you can fill in the ‘Image URL’ field in the product upload spreadsheet so that your images can be downloaded from the URL and imported into Onsight.

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 admin console at http://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. When you open the file 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 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 or PNG.
    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 in column ‘Primary Image’ for a specific product, you will replace this image if you add a new file.
    If you do not want to replace this image (Primary Image) but add another image, then you need to also add the file name of the ‘Primary Image’ into the ‘Image File Name’ field and also add the actual image file to your new folder again.
    5 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 1,024MB. If your file is bigger than 1024MB, 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 admin console at http://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 or the ‘Image URL’ 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. After pasting the product info into the product upload spreadsheet or the image import spreadsheet, you can copy and paste the product code field into the ‘Image File Name’ field or the ‘Image URL’ field. Then you just need to add the file extension (eg. .JPG) to the field in order to complete it.