Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3
Info
titleInfo

Price Logics allow 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 favorite customer preferential pricing? No problem.

Create/Edit a 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 price logic will affect. If you don't pick an option, your price logic will affect every manufacturer.

Category

Pick the category, sub category & product family 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, 'OPG' costs, or both.

Tip
titleHandy Hint

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

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

Specify what calculation type the price logic will use;
'Increase' (Mark up) 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' will reduce the sell price by the specific percentage.
'Fixed price' changes the logic so instead of entering a percentage, you should enter the sell price (exclusive of VAT).

Price list

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

Pricelist 1-10

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

Tip
titleHandy Hint

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

Example Price lists


Example Default Price List

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 list

0.0 - 9.99

30

10 - 19.99

25

20 - 49.99

22.5

50 - 99.99

20

100 - 199.99

17.5

200 - 499.99

15

500 - ∞

12.5

This is a fairly typical example of a logic where the greater the cost price 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 & £499.99 will have a margin of 15% applied.

Tip
titleHandy Hint

You should always have a default price logic to act as a safety net & 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 & 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 list

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 logics (for example, you could have one logic for Laptops & 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 price 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
Note

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