How do I bulk upload my stock levels?

Our admin console provides an easy way to bulk upload stock level information for all your products without having to update and import all of the other product data. Only your stock level info will be updated. This way all of your other product info will not have to re-sync to your team’s mobile devices. To use this tool, your product info must be uploaded already. If you have not yet uploaded all your product info please rather follow the guide on how to bulk import your products instead.

To access the bulk upload tool to upload your stock levels:

  • 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 Stock Levels’ from the drop-down list
  • This will open up the 4-step bulk upload tool

Step 1: Download your data

This step will download a list of existing products on your account and columns for Product/Pack Code and Stock Availability.

Step 2: Edit the datasheet

Each row in your spreadsheet represents one of your products. Edit the cells in the Stock Availability column to add your latest stock level numbers.

Step 3: Upload Data Sheet

Save your file. Then select its location on your computer, and upload it to Onsight for processing.

Step 4: Import Updated Product/Pack Pricing

Once you click the “Import” button your spreadsheet will be analysed and validated.

If your spreadsheet passes validation you will be shown a list of updates that will happen once you approve the import job, and you will be able to approve it so that the datasheet is actually processed and your product information imported. If the spreadsheet fails, you will be shown a list of errors to rectify before uploading it all again. If everything is OK – hit “Approve Job” and all your information will be imported into the database.

Check on your import jobs

To see the status of all your import jobs, go to Setup > Import Jobs and you will see them all listed.

Still have questions?

If you are still uncertain of how to proceed or if you encounter any problems email us at support@onsightapp.com and we will help you through the process step-by-step.