How do I bulk upload my prices?

Our web console provides an easy way to bulk upload price changes for all your products without having to update and import all of the other product data. Only your prices 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 product prices:

  • Log in to the Onsight web 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 Pricing’ 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, Cost Price and Price.

Step 2: Edit the datasheet

Each row in your spreadsheet represents one of your products. Edit the cells in the Cost Price and Price columns to add your latest cost prices and normal selling prices.

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 [email protected] and we will help you through the process step-by-step.