{"id":4647,"date":"2025-11-20T08:52:13","date_gmt":"2025-11-20T08:52:13","guid":{"rendered":"https:\/\/www.onsightapp.com\/user-guide\/?p=4647"},"modified":"2025-11-20T09:08:20","modified_gmt":"2025-11-20T09:08:20","slug":"how-do-i-bulk-upload-my-volume-pricing","status":"publish","type":"post","link":"https:\/\/www.onsightapp.com\/user-guide\/how-do-i-bulk-upload-my-volume-pricing\/","title":{"rendered":"How do I bulk upload my volume pricing?"},"content":{"rendered":"<p>Our admin console provides an easy way to bulk upload or bulk update volume pricing information for all your products. 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 <a href=\"\/user-guide\/bulk-uploading-your-product-catalogue\/\">how to bulk import your products<\/a> instead.<\/p>\n<p>To access the bulk upload tool to upload your volume pricing:<\/p>\n<ul>\n<li>Log in to the Onsight web console at\u00a0<a href=\"https:\/\/sales.onsightapp.com\/\" target=\"_blank\" rel=\"noopener\">https:\/\/sales.onsightapp.com<\/a>.<\/li>\n<li>Click on \u2018Import &#038; export data\u2019 from the left-hand side menu.<\/li>\n<li>Click on the &#8216;Products&#8217; menu item.<\/li>\n<li>Click on &#8216;Product volume pricing&#8217;<\/li>\n<li>This will open up the 4-step\u00a0product volume pricing import &#038; export tool.<\/li>\n<\/ul>\n<h2>Step 1: Export the product volume pricing data<\/h2>\n<p>Click the &#8220;Download&#8221; button and save the the product volume pricing data sheet somewhere you will find it easily. Once done, click on \u2018Continue\u2019. <\/p>\n<h2>Step 2: Change the product volume pricing data<\/h2>\n<p>Open the spreadsheet file. Each row in the spreadsheet represents one volume pricing tier for one of your products. If you have customer groups, then there will be rows for each customer group as well. This allows you to define volume pricing per customer group.<\/p>\n<p>To create a new volume price tier, copy one of the existing rows and then change the Start Qty and Unit Price fields.  <\/p>\n<p>To delete all the volume tiers for a specific customer group, either:<br \/>\nblank out the Start Qty and Unit Price fields of all rows for that product and customer group,<br \/>\nor<br \/>\ndelete all the rows for that that product and customer group, but keep one row where the Start Qty and Unit Price fields are empty.<\/p>\n<p>To delete all the volume tiers for a product, either:<br \/>\nblank out the Customer Group, Start Qty and Unit Price fields of all rows for that product,<br \/>\nor<br \/>\ndelete all the rows for that product, but only keep one row where the Customer Group, Start Qty and Unit Price fields are empty.<\/p>\n<h2>Step 3:  Upload the new product volume pricing data<\/h2>\n<p>Save your file. Click on the \u2018+\u2019 button and select your saved data sheet on your computer. Once done, click on \u2018Continue\u2019.<\/p>\n<h2>Step 4: Import the new product volume pricing data<\/h2>\n<p>Click the \u2018Import\u2019 button to start the import process. Your data sheet will be analysed and validated. Once the import job progress is at 100%, click on either:<\/p>\n<p>\u2018For review &#8211; view and approve this job\u2019.  If your data sheet passes validation, you will see a list of updates that will be applied once you approve the import job. If everything is correct, click \u2018Approve Job\u2019 and your data will be imported into the database.<\/p>\n<p>or <\/p>\n<p>\u2018Failed &#8211; view the job\u2019. If the data sheet fails validation, a list of errors will appear, which you must correct before uploading it again.  Click on \u2018Cancel Job\u2019 and correct the data in your upload data sheet and then start at Step 3 again. <\/p>\n<h2>Check on your import jobs<\/h2>\n<p>If you navigate away from the import process whilst it is running, you can come back later to check on the progress. To see the status of all your import jobs, go to &#8216;Import &#038; export data&#8217;  &gt; &#8216;Import jobs&#8217; and you will see them all listed. Click on the file name to see the detailed progress. <\/p>\n<h2>Still have questions?<\/h2>\n<p>If you are still uncertain of how to proceed or if you encounter any problems email us at <a href=\"mailto:support@onsightapp.com\">support@onsightapp.com<\/a> and we will help you through the process step-by-step.<\/p>\n<p>&nbsp;<br \/>\n&nbsp;<br \/>\n<b>Related articles:<\/b><br \/>\n<a href=\"\/user-guide\/how-do-i-add-volume-pricing-to-my-products\/\">How do I add volume pricing to my products?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Our admin console provides an easy way to bulk upload or bulk update volume pricing information for all your products. To use this tool, your product info must be uploaded already. If you have not yet uploaded all your product<span class=\"ellipsis\">&hellip;<\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"_links":{"self":[{"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/posts\/4647"}],"collection":[{"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/comments?post=4647"}],"version-history":[{"count":5,"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/posts\/4647\/revisions"}],"predecessor-version":[{"id":4652,"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/posts\/4647\/revisions\/4652"}],"wp:attachment":[{"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/media?parent=4647"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/categories?post=4647"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/tags?post=4647"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}