Set up a Price Matrix

The Purpose of a Price Matrix is to establish differentiated pricing structures for Customers based upon their assigned Matrix and a product’s Product Group. They allows users to apply markups or offers discounts to specific customers.

Please note: This feature is available on our Gold Subscription level or greater only, To upgrade please go into your Profile settings – Subscription and click Upgrade.

Creating a New Product Matrix

  1. To create or update a Matrix navigate to Settings (1) then Price Matrix (2) in the left hand sidebar.
Screenshots of Workshop Software's left hand sidebar. Numbered cursors indicate to click Settings and then Price Matrix.
  1. Click the + icon to create a new Price Matrix., you may also use the Matrix drop down Menu to select a Product Matrix to edit.
A screenshot of the Price Matrix list page. The Matrix Field and + icon are highlighted.
  1. If creating a new Matrix a pop up will appear allowing you to name your Matrix and select its type. A Markup Matrix increases the prices for chosen Product Groups to any assigned Customer, a Discount Matrix reduces the prices.
The pop up to add a new Price Matrix with fields for Matrix Name and Matrix Type

A Matrix applies a markup or discount to Products from the included Product Groups. If you need to create new Product Groups follow the instructions in our Add a Product Group Article.

Assigning Product Groups and Discounts

  1. With your Product Groups configured you may add them to your matrix by clicking Add Product Group (A) or include all your product groups at once by selecting Add All Product Groups (B).
A screenshot of a new Price Matrix called Trade Customer. The button for Add a Product group is marked with a cursor labeled A, the button for Add All Product Groups is marked with B.

2.  If you selected Add All Product Groups, please confirm by clicking Yes when prompted.

An image of the pop up that confirms a user will add all Product Groups to a Price Matrix.
  1. If you selected Add Product Group you may click the desired Groups in the pop up and then choose Select to add them to your matrix.
A screenshot of the Select a Product Group pop up. Cursors indicate clicking two Product Groups to select them, the the Select button to confirm.
  1. You may then configure the specific markup or discount for any Group (C), click the Product Group’s Percentage field and enter the new value.
  2. To update all Percentage fields choose an Update Type to update all fields or only those with a value of Zero, enter the desired value in the batch Percentage Field and click Update (D).
  3. Be sure to click Save to save your matrix after completing these steps.
An image of a Price Matrix with two Product Groups added, the individual Percentage Fields for each Product Group are highlighted and tagged C, the Update All and batch Percentage Field is highlighted and tagged D. A cursor icon indicates to click the Save button.

Assigning a Price Matrix to a Customer

After configuring the Matrix the final step is to assign which Customers will receive the modified pricing. Even if you have only one Matrix, you must still assign one or more customers to this Matrix for it to take effect.

  1. Navigate to the Customer profile you would like to apply a Matrix to, select Price Type and choose the desired Matrix.
A cropped screenshot of a Workshop Software Customer. The Price Type dropdown is highlighted showing a list of possible Matrix prices.
  1. Click Save before exiting the Customer.
A cropped screenshot of a Customer showing the Cancel, Archive and Save buttons. The Save button is highlighted.

This will apply the Matrix’s defined markups or discounts to the customer. When you create a new Invoice the prices will reflect the percentage adjustments specified in the matrix.

Please Note: The matrix percentage is applied to the Retail price, if a product does not have a Retail price entered, the markup or discount will not be applied.

Please refer to this video which will also go over the steps mentioned above.

Also Explore