{"id":144,"date":"2014-07-01T13:42:25","date_gmt":"2014-07-01T13:42:25","guid":{"rendered":"https:\/\/www.onsightapp.com\/user-guide\/?p=144"},"modified":"2026-11-03T03:32:24","modified_gmt":"2026-11-03T03:32:24","slug":"how-do-i-set-up-customer-discounts","status":"publish","type":"post","link":"https:\/\/www.onsightapp.com\/user-guide\/how-do-i-set-up-customer-discounts\/","title":{"rendered":"How do I set up product discounts per customer?"},"content":{"rendered":"<p>Onsight allows you to configure per-customer discounts for each product. This is ideal for managing discounts for different groups of customers. For example, you can set different discounts for wholesale versus retail customers.<\/p>\n<h2>Create your customer groups<\/h2>\n<p>To set up per-customer discounts you first need to create a new customer group for each group of customers you would like to give a customer discount to. <\/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 \u2018Manage your data\u2019 from the left-hand side menu.<\/li>\n<li>Click on the &#8216;Customer groups&#8217; menu item.<\/li>\n<li>You will see a list of all of your customer groups.<\/li>\n<li>Click on the &#8216;Add Group&#8217; button at the top of the screen.<\/li>\n<li>Enter a name for the customer group.<\/li>\n<li>Click the &#8216;Save&#8217; button.<\/li>\n<\/ul>\n<h2>Assign each customer to a customer group<\/h2>\n<p>If there are only a few customers that must be part of the new discount group, add them one at a time. For each customer, follow these steps:<\/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 &#8216;Customers&#8217; from the left-hand side menu.<\/li>\n<li>You will see a list of all of your customers.<\/li>\n<li>Click on the customer that you would like to allocate to the customer group.<\/li>\n<li>Click the &#8216;Edit&#8217; button.<\/li>\n<li>In the &#8216;Customer Group&#8217; field select the customer group. If you have many groups, you can type the first few letters and it will appear.<\/li>\n<li>Click the &#8216;Save&#8217; button.<\/li>\n<\/ul>\n<p>If you have many customers that must be part of the new customer group, use the bulk upload tool instead.<\/p>\n<ul>\n<li>Click &#8216;Import &amp; export data&#8217; in the left-hand menu, then click &#8216;Customers&#8217;.<\/li>\n<li>On &#8216;Step 1: Export the customer data&#8217;, click &#8216;Download&#8217; to save your customer spreadsheet, then click &#8216;Continue&#8217;.<\/li>\n<li>Open the spreadsheet. Each row is a customer. Find the customers you want to add to the new group. In their &#8216;Customer Group&#8217; column, add the new group name. Save the file.<\/li>\n<li>On &#8216;Step 2: Change the customer data&#8217;, click &#8216;Continue&#8217;.<\/li>\n<li>On &#8216;Step 3: Upload the new customer data&#8217;, click the &#8216;+&#8217; button, select your saved file, then click &#8216;Continue&#8217;.<\/li>\n<li>On &#8216;Step 4: Import the new customer data&#8217;, click &#8216;Import&#8217;. When the progress reaches 100%, click &#8216;For review&#8217;, check the changes, then click &#8216;Approve Job&#8217;.<\/li>\n<li>If you see &#8216;Failed&#8217; instead, click it to view the errors. Click &#8216;Cancel Job&#8217;, correct the spreadsheet, then return to &#8216;Step 3: Upload the new customer data&#8217;.<\/li>\n<\/ul>\n<h2>Set the customer discounts for a product<\/h2>\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 \u2018Manage your data\u2019 from the left-hand side menu.<\/li>\n<li>Click on the &#8216;Products&#8217; menu item.<\/li>\n<li>You will see a list of all of your products. <\/li>\n<li>Click on the product that you want to configure.<\/li>\n<li>Click the &#8216;Discounts&#8217; tab.<\/li>\n<li>Click the &#8216;Edit&#8217; button.<\/li>\n<li>Enter a discount for each customer group that needs to get a preset discount.<\/li>\n<li>Click the &#8216;Save&#8217; button.<\/li>\n<\/ul>\n<p>You should do the above process at least once so that you are familiar with how to set discounts for a single product. <\/p>\n<p>If you have many products that must get a discount, use the bulk upload tool instead.<\/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 &#8216;Import &amp; export data&#8217; in the left-hand menu, then click &#8216;Products + Groups&#8217;, then click &#8216;Group discounts&#8217;.<\/li>\n<li>On &#8216;Step 1: Export the product group discount data&#8217;, click &#8216;Download&#8217; to save the spreadsheet, then click &#8216;Continue&#8217;.<\/li>\n<li>Open the spreadsheet. Each row is a product and each column is a customer group. Type your discounts in the column for your new group. Save the file.<\/li>\n<li>On &#8216;Step 2: Change the product group discount data&#8217;, click &#8216;Continue&#8217;.<\/li>\n<li>On &#8216;Step 3: Upload the new product group discount data&#8217;, click the &#8216;+&#8217; button, select your saved file, then click &#8216;Continue&#8217;.<\/li>\n<li>On &#8216;Step 4: Import the new product group discount data&#8217;, click &#8216;Import&#8217;. When the progress reaches 100%, click &#8216;For review&#8217;, check the changes, then click &#8216;Approve Job&#8217;.<\/li>\n<li>If you see &#8216;Failed&#8217; instead, click it to view the errors. Click &#8216;Cancel Job&#8217;, correct the spreadsheet, then return to &#8216;Step 3: Upload the new product group discount data&#8217;.<\/li>\n<\/ul>\n<h2>How per-customer discounts are shown in your catalogue<\/h2>\n<p>When a customer is selected in the Onsight app or web console, the catalogue automatically shows the price that applies to that customer, including any customer group pricing and discounts you have configured. You can choose whether the catalogue shows the price before or after the customer discount is applied. There is a configuration setting in the web console that controls this: &#8220;Show discounted prices in catalogue&#8221;. When this setting is enabled, the catalogue shows the discounted price. When it is disabled, the catalogue shows the customer group base price, or the normal selling price if no customer group base price has been set. By default, discounted products also display a percentage discount badge, such as \u201c10% off\u201d. Contact us if you want to show or hide the customer group discount percentage badges.<\/p>\n<h2>Data volume limits<\/h2>\n<p>On the Business plan, you can have a maximum of 5,000 products and up to 100 customer groups. Each combination of a product record and a customer group record generates a new customer discount record. The combination of products and customer groups is limited to 320,000 customer discount records.<\/p>\n<p>For example:<\/p>\n<ul>\n<li>If you have 5,000 products, you can have a maximum of 64 customer groups (5,000 \u00d7 64 = 320,000).\n<li>If you have 100 customer groups, you can have a maximum of 3,200 products (100 \u00d7 3,200 = 320,000).\n<\/ul>\n<p>These limits do not apply if your Onsight account is connected to an ERP system \/ accounting system, as all the price list data in your external system will automatically sync to Onsight.<\/p>\n<p>\n<b>Related articles:<\/b><br \/>\n<a title=\"How to bulk upload per-customer discounts\" href=\"\/user-guide\/how-do-i-bulk-upload-customer-discounts\">How to bulk upload per-customer discounts<\/a><br \/>\n<a title=\"What are customer groups?\" href=\"\/user-guide\/what-are-customer-groups\/\">What are customer groups?<\/a><br \/>\n<a title=\"How to set up per-customer pricing\" href=\"\/user-guide\/how-do-i-set-up-customer-pricing\">How to set up per-customer pricing<\/a><br \/>\n<a title=\"How to set up per-customer product availability\" href=\"\/user-guide\/how-do-i-set-up-customer-product-availability\">How to set up per-customer product availability<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Onsight allows you to configure per-customer discounts for each product. This is ideal for managing discounts for different groups of customers. For example, you can set different discounts for wholesale versus retail customers. Create your customer groups To set up<span class=\"ellipsis\">&hellip;<\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,7],"tags":[],"_links":{"self":[{"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/posts\/144"}],"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=144"}],"version-history":[{"count":48,"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/posts\/144\/revisions"}],"predecessor-version":[{"id":5045,"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/posts\/144\/revisions\/5045"}],"wp:attachment":[{"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/media?parent=144"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/categories?post=144"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.onsightapp.com\/user-guide\/wp-json\/wp\/v2\/tags?post=144"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}