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.

Step 1 – Upload your products

First 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 2a or Step 2b depending on where your images are located.

Step 2a – Import your images from your computer

If your product images are on your computer, then follow the instructions below to upload the images. If your product images are already on the Internet then skip to Step 2b instead.

  • Create a new empty folder on your computer.
  • Copy the product images you want to upload to the new empty folder 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’.
  • Save the Product Image Data sheet that is now being downloaded to the new folder that you previously created.
  • Open the Product Image Data sheet that you have just downloaded.
  • Type in the image file name next to the relevant product in the column called ‘Image File Name’.
  • If your image file names have no structure you will have to type them in one-by-one. If your image file names are structured (eg. all images are named after the product code) then you can easily generate the image name field by copying and pasting in Excel and by using some Excel string manipulation techniques.
  • Save the sheet. Both the individual product images and the Product Image Data sheet should now be present in the new folder.
  • 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.
  • 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 file you created.
  • Click ‘Import’ to upload the newly-created zip file to your account via this tab. You will get a message that notifies you if the import has either failed or been approved.
  • Select ‘View’ to check that everything is correct and ‘Approve’ if you are satisfied with the import. All images will now sync to your account.

Step 2b – Alternatively, import your images from the Internet

If your product images are already hosted on the Internet (eg. on your website), you can go back and redo the bulk product import process listed in Step 1. This time you should fill in the ‘Image URL’ field in the product upload spreadsheet. An example of an image URL is : ‘https://www.mywebsite.com/images/product_xyz.jpg’ . Your images will be downloaded from the URL and imported into Onsight.

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.