Info

Price logic allows you to build some intelligence into the way your shop calculates prices. Want low-cost cables to carry a higher margin than high-cost laptops? No problem. Want to give your favourite customer preferential pricing? No problem.

General information about price logic

You specify, per price logic, what margins a certain selection or product should bear. The calculated output prices can be checked via the price test. It is possible to specify ten different margin levels (ten price levels) per price logic, and you specify on the customer card which price level generally applies to the customer. The basic ten price levels, from 1 to 10, can be supplemented by customer- or customer-group-specific price logic.

Nettailer comes with two general pricing logic's. One of these, called "General," cannot be edited or deleted. This price logic acts as a lifeline if you or someone else happens to remove your specific general price logic. Note that you must change the pre-filled values in the editable general price logic to the margins that are relevant in your case. If the general price logic is removed, or if the date has expired, the general price logic that cannot be removed will be used. The general price logic is used as a parachute to collect the products that do not fall within the scope of any other price logic.

The general price logic can be supplemented by a free number of price logics that specify marginal levels at the manufacturer, category, or product level. For example, you can create a price logic that provides a unique margin level for the manufacturer, "HP." You can then refine the model with a new supplementary price logic with a different margin level for, for example, the category "Computers/Laptops / Hewlett Packard." If necessary, in the next step, you can refine the price logic to give the desired margin per product.

The general price logic can be supplemented with customer-specific price logic. These work together with the price level allocated to the customer on the customer card, for example, "Price level 7." In practise, a price level is created for a particular customer in combination with a manufacturer, category, or product. This makes it possible to give customer A an extra price level with, for example, a 7% margin on Apple's product range instead of the 10% that would have been obtained according to the general price level.


Note

There are great opportunities to tailor and fine-tune the pricing structure. When you create your price logic structure, it is important that you think through which methodology is useful for your business. The basic idea is that you should be able to divide your customer base into different segments. For example, a certain similar customer segment is linked to “Price Level 2,” while another customer segment is linked to “Price Level 7." The assigned price level should cover most scenarios for the customer, but can be supplemented with customer-specific price logic if necessary. The basic version offers ten different price levels for managing customer segments. Our assessment is that a normal retailer defines between twenty and forty general price logics, which are then supplemented with customer or customer group-specific exceptions.

Create or Price price logic.

Feature

What it does

Label

Give your price logic a unique, meaningful name.

From date

Enter the date you want the price logic to become active.

To date

Enter the date you want the price logic to be deactivated.

Manufacturer

Pick which manufacturer the pricing logic will affect. If you don't pick an option, your pricing logic will affect every manufacturer.

Category

Pick the category, subcategory, and product family that the price logic will affect.

Product

Specify the stock code if you want the price logic to only affect a single product.

Price type

Select if the price logic is for 'normal' costs, 'BID' costs, or both.

Handy Hint

Price level 1 is the default price used for customers who are not logged in. This can be changed in Settings > Defaults > "Price levels."

Types

Feature

What it does

Type

Specify the type of price logic. 
'Global' means the price logic will affect every customer (unless customers have another price logic connected to them).
'Customer connected' means the price logic will only affect specific customers or customer groups.

Calc type

Learn more about markup vs. margin here: Markup vs Margin

Specify what calculation type the price logic will use.

'Mark up' (increase): this is what percentage of the cost price you add on to get the selling price.
'Margin' this percentage is the percentage of the final selling price that is profit.
'Discount on guide price' will set a price at the specified percentage under in-price (cost price).  Example: cost price - discount % = sales price.
'Fixed price' changes the logic, so instead of entering a percentage, you should enter the sell price (exclusive of VAT).

'Discount on general price' — Learn more here: Discount on general price
    • This will apply a discount against whatever price logic is already applied to an item. Example: sales price minus discount general price % = new sales price.
    • This option will also display a specified label ("Discount," "Sale Price, etc) that is set up in Settings > Products > Prices 
Contribution margin limits ADD-ON

Option to define either a % of fixed value as min/max for profit calculated in price logics.

With option enabled price logics get new section "Contribution margin limits" with following options:

Feature

What it does

TypePercent or fixed.
Minimum valueFixed value.
Maximum valueFixed value.
Price Level

Feature

What it does

Interval

This will set a range of costs; any products with a cost price between these ranges will be affected by this line

Price level: 1–10

Nettailer lets you create ten price levels, which means you should be able to tailor your prices to match your accounts without having to create multiple customer-connected price levels.

Handy Hint

Nettailer allows you to create ten different price levels to allocate to different groups of customers. By default, every customer will see price level 1, but it can be changed in Users > Customers > Customer card > Customer info > "price level."

Example price levels


Example: Default price level

Setting

Value

Label

Default

From date

01/01/01

To date

01/01/25

Manufacturer

Select option

Category

Select option

Product

None selected

Types

Value

Price Type

Normal

Type

Global

Calc Type

Margin

Interval

price level

0.0–10

30

10 - 20

25

20–50

22.5

50 - 100

20

100 - 200

17.5

200 - 500

15

500 - ∞

12.5

This is a fairly typical example of a logic where the greater the cost of the item, the lower the margin applied.
In this example, any product that costs £9.99 or less will be given a margin of 30%, whereas any product that costs between £200 and £499.99 will have a margin of 15% applied.

Handy Hint

You should always have a default price logic to act as a safety net and ensure that every product is sold at a profit. With no default price logic, any product with no logic associated with it will be displayed as 'Call for price' in your store.


Example Manufacturer and Category Specific Price Logic

Setting

Value

Label

HP Laptops

From date

01/01/01

To date

01/01/25

Manufacturer

HP

Category

Computers
Laptops
Select Option

Product

None selected

Types

Value

Price Type

Normal

Type

Global

Calc Type

Margin

Interval

price level

0.0 - ∞

10

In this example, any HP-branded laptop will be given a margin of 10%.
Any HP product that is not a laptop will not be affected.
Any other brand of laptop will not be affected.


Price Logic Priorities

As the price logic structure is so flexible, it is possible to create overlapping logic's (for example, you could have one logic for laptops and another for every HP product). To avoid any conflicts, we have put in place the following order of priorities:

Going from highest to lowest priority,

  1. Customer-specific price logic on the product (including fixed price logic)
  2. Customer-specific price logic on the subcategory 
  3. Customer-specific price logic on the category
  4. Customer-specific pricing logic on the manufacturer
  5. Default price logic on the product (including fixed price logic)
  6. Default price logic on the subcategory
  7. Default price logic on the category
  8. Default price logic on the manufacturer
  9. Default global price logic


Please note that a default or global fixed price will not override any customer or customer group-specific price logic.



  • No labels