Prices

All products have a standard product field called Price in which you can enter a price using the default currency. In frontend, prices can be shown using the default currency or any other currency on the solution - if the latter, it is converted using the exchange rate set on the currencies. The default currency context for a website is set using the website ecommerce settings.

Price Matrix

For more advanced price-needs, we have the price matrix - a flexible and powerful way to create differentiated prices using a format similar to classic ERP-systems. To access the price matrix for a product:

1. Open the product overview screen
2. Open the action-menu and select Prices

This opens the price matrix where you can view and manage all prices for the product.

Prices are applied in the following manner:

• If all criteria for a price are met, the price will be applied
• If criteria for more than one price are met, the lowest price is applied

To add a new price to the price matrix manually, click New Price and then configure the Price, When, Who, and Where of the price.

Often, price matrix prices are create via integration.

Price

The Price-section defines the price and related information.

To use this section:

1. Specify the price and the currency
2. Consider VAT:
   • Price do not include VAT: VAT will be added to the price depending on the VAT context (country and reverse VAT charge settings)
   • Price includes VAT: The specified price will be final price with VAT, and the price before VAT will be calculated based on the VAT context (country)
3. If relevant, check the Informative box to exclude this price from being applied; this is typically done to show MSRP-prices or before-prices without applying them
4. Set a discount percentage
5. Check/uncheck Allow order line discounts - controls whether this line can receive product-specific discounts
6. Check/uncheck Allow order discounts - controls whether this line contributes to and receives any order-level discounts

Only price and currency are required. If you set the price to 0 it will be interpreted as null, only applying the discount percentage on the price entry - in such cases:

• The discount percentage is applied to the lowest applicable price in the matrix
• If the price matrix contains only discount lines (i.e. no prices are defined), the discount percentage will be applied to the product’s default price

This allows you to define percentage-based discounts independently of specific price points, offering flexible discounting logic based on customer groups, quantity, or other criteria. Additionally, this structure allows you to mirror the price structure in Dynamics 365 Business Central.

When

The When-section is used to specify the quantity of products which must be bought to qualify for this price, as well as the dates between which this price is active.

Who

The Who-section specifies the users and user groups which can get this price.

You can specify:

• A user
• A user group
• A specific customer number
• Users in a group with a specific customer number set

Where

The Where-section allows you to limit the discount to a specific:

• Variant
• Unit
• Stock location
• Language version
• Country
• Shop

Or, indeed, a combination of these parameters.

Example

To illustrate how the price matrix works, let's look at an example.

We want to set a specific price for a product, E-BIG TOUR 400EQ, for a particular user.

As shown below, the price for this product is 1.000 DKK. Please note that in this example, the price excludes VAT, meaning that with a 25% VAT, the total price is 1.250 DKK

We want to change this, by offering a 50% discount to a specific user, but only if they purchase at least five units of the product.

To do this:

1. In the top right corner, click Actions and click Prices
2. Click New price
3. Set the Price to 1000
4. Set the currency to dkk
5. Check Price do not include VAT
6. Set discount percentage to 50
7. Set Quantity to 5
8. Browse the users and locate the user you want to give the discount to
9. Save and close

Now, the specific price shows up in the price matrix:

When the users purchases five units of this product, the custom price will activate, applying the 50% discount:

Allow order discounts - Examples

Let’s look at a few different scenarios that illustrate how discount calculations work when 'Allow order discounts' is checked or unchecked.

1. Product A:
   • Default price: 1,000 DKK
   • Price set via the price matrix: 500 DKK
2. Product B:
   • Default price: 200 DKK
   • No price given in price matrix

Discounts applied

• Flat 100 DKK order discount
• 10% order discount

Calculation - 'Allow order discounts' unchecked

1. Product A:
   • Price = 500 DKK
2. Product B:
   • Price = 200 DKK
   • Flat 100 DKK order discount is applied: 200 → 100 DKK
   • 10% order discount is applied: 100 → 90 DKK
3. Total cart price:
   • 500 + 90 = 590 DKK

Takeaway: Only Product B receives the order discounts. Product A is excluded.

Calculation - 'Allow order discounts' checked

1. Product A:
   • Price = 500 DKK
2. Product B:
   • Price = 200 DKK
3. Total cart price:
   • 500 + 200 = 700 DKK
   • Flat 100 DKK discount is applied: 700 → 600 DKK
   • 10% order discount is applied: 600 → 540 DKK

Takeaway: Both products participate in the order discounts, reducing the overall price more significantly.

Calculation - Only Product A is in the Cart and 'Allow order discounts' is unchecked

1. Product A:
   • Price = 500 DKK
2. Total cart price:
   • Flat 100 DKK discount is applied → 400 DKK
   • 10% order discount is ignored since 'Allow order discounts' is unchecked

Takeaway: Unchecking 'Allow order discounts' for a product prevents any order-level discounts from applying to that product specifically. However, flat-rate order discounts (e.g. 100 DKK off the entire order) are not tied to individual products — they apply to the total cart value, so they still affect the final price even if the only item in the cart doesn’t allow order discounts.