Workflow that auto-populates DISCOUNT item when CUSTOMER chosen

How can I create a work order, or designation, that automatically assigns a discount item to a sales order, once the customer is populated? One of our customer’s receives a 17% discount to their entire sales order, every time. We want to avoid creating additional price levels – but it is easy to forget to manually click this discount item when creating the sales order.

Rookie Asked on December 18, 2020 in How To's.
Add Comment
1 Answer(s)

I understand you want to avoid price levels, but this is the way I would do it as it is the ‘cleanest’, uses no customisation (which means NS runs quicker) and is scalable (if there are more customers that you want to apply a 17% discount to, or a different % discount).

  1. Create a new Price Level
  2. Enter “-17%” into the “Markup/Discount %” field
  3. Tick “Update Existing Prices”
  4. Set the “Price Level” on the Customer Record (normally under the “Financial” tab)

Here are the advantages:

  1. When you create a new order for this customer, it automatically applies that price level, no manual intervention needed.
  2. Other customers can use that price level in the future
  3. You can easily add other price levels for other customers with different discounts
  4. If you change the price of the base price, it automatically updates the price levels

If you want the customer to ‘know’ that they are on a special discount level, you could add the price level name to the email/PDF template too (and you could call the price level “17% off” or something).


In theory you could do what you have asked for with a workflow. But because I suspect you have more than one SKU per order, I haven’t been able to get it to work (because I can’t add a “Subtotal” line via Workflow.

Rookie Answered on December 21, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor