Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
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.
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.
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.
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
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).
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.
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
Type
Percent or fixed.
Minimum value
Fixed value.
Maximum value
Fixed value.
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: 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.
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.
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,
Customer-specific price logic on the product (including fixed price logic)
Customer-specific price logic on the subcategory
Customer-specific price logic on the category
Customer-specific pricing logic on the manufacturer
Default price logic on the product (including fixed price logic)
Default price logic on the subcategory
Default price logic on the category
Default price logic on the manufacturer
Default global price logic
Please note that a default or global fixed price will not override any customer or customer group-specific price logic.
ADD-ON
Instead of creating multiple single-price logics, a group can be created and associated with one or more customers. Once the group is created, multiple price logics can be created or changed easily afterwards.
A price logic associated with price logic groups can only be changed under price logic groups as they share a "header" and are managed entirely within this group.
Please note that price logic groups cannot have prices based on in-price intervals.
\
Connect a customer or customer group by clicking Connect customer or customer group. You can connect multiple customer groups to a single price logic group.
In this part you can put your own name on the various price levels
Handy Hint
Nettailer allows you to create ten different price levels to allocate to different groups of customers. New customers are default assigned to the price level specified in Settings/Default, which also applies pre-login.
Adds configurable lists of fixed prices with import functionality. The values from the fixed price lists have the highest priority when calculating prices.
If the same product exists on multiple fixed price lists, the one with the best priority wins; if it has the same priority, the first one wins.
Fixed price list priority
By default, the price priority looks like this:
1. Fixed Pricelist List: customer-specific 2. Fixed Pricelist List: common 3. Price Logic: customer-specific 4. Price Logic: Common
The priority is controlled by the setting "Fixed price lists always trump price logics." If the setting is turned off, the prioritisation will be as below:
1. Fixed Pricelist List: customer-specific 2. Price Logic: customer-specific 3. Fixed Pricelist List: common 4. Price Logic: Common
Settings / Products / Prices / Fixed price lists always trump price logics.
When activated, both customer-specific and general fixed price lists are examined before general price logics. If deactivated, we first inspect customer-specific fixed prices and then customer-specific price logic, followed by general fixed prices and then general price logic.
Enter the part number in the search box that you want to add to the fixed price list, and click Search. A range of results might appear if the text entered matches multiple articles. Select the one you want to use by clicking it.
Enter the fixed price for the article.
Click OK or Apply to save.
Use this button to delete all products connected to this fixed price list.
If you want to add part numbers using an Excel sheet, you can use this function. Click Import to upload and import the Excel file.
If a part number is not unique, you will be notified of which part numbers failed, and the row will not be imported. All other valid rows will be imported. If this happens, please update the excel sheet with the manufacturer in column B.
If a part number already exists in the fixed price list, it will be updated with the new fixed price in the import.
Export the fixed price list to Excel. This file can also be used for import. This is a good way to bulk edit multiple fixed prices.
Learn more about markup vs. margin here:
'Discount on general price' — Learn more here:
This option will also display a specified label ("Discount," "Sale Price, etc) that is set up in Settings > Products >
Label
Name the price logic group. This is for internal purpose only, so you can identify this group from the list you have or may create
From date
when the price logic group is valid.
To date
To what date is the price logic group valid?
Types
Price type
Which price types is this logic group applied to? Your options are:
Normal: a price that is calculated against your normal cost-price logic
Bid: a price that is calculated against bid prices
Customer connected
If this price logic group is customer-connected, If not checked, the price logic group will be global.
Calc type
Mark up or Margin.
Price logics
Manufacturer (optional)
To which manufacturer the price logic is applied.
Category (optional)
To what category is the price logic applied?
Value
The value of what's selected at the "Calc type" setting
General price logic
Check this box to save the price logic when the manufacturer and category fields are empty. This will create a general price logic that is applied to products when no other, more specific, price logic is found.
Remove
Remove the price logic row.
Guide Price
Will display the guide price (Recommended retail price (RRP))
Info: Only visible if the suppliers you are using provide RRP in their feed.
Label
Name the fixed price list. This is for internal purposes only.
Priority
Enter a numeric value for priority. A lower value equals better priority.
From date
When the prices in the fixed price list are enabled,
To date
To what date is the fixed price list enabled? After this date, the prices in the fixed price list will not be shown.
Customer connected
If this fixed price list is customer-connected only, If not checked, the fixed price list will be global.
Currency
Currency for fixed sales prices
Only available if the shop supports multiple currencies.
Download template
Download a template with the columns needed for the import.
Excel file
Choose the excel file to use for the import
Skip first line
Check this in your Excel sheet, which contains headers.
Cost-price strategies determine the default behaviour of your store in relation to the products that are available.
You can customise the strategy to suit your business needs and tweak and amend it as you need to throughout your business lifecycle.
By applying various rules, you can ask the store to consider prices for in-stock products only, or you could decide that your suppliers have a set priority for their products. You could even combine the two so that the store will pick prices for the highest-priority supplier, provided they have stock.
The filters available are:
In stock
Supplier priority
Calculation method
By adding a calculation method, you can set the store to pick the lowest price and average price (for all available prices), or you can calculate the average price by the amount of stock available.
Your cost price strategy can be found under your store administration section under Pricing>Cost price strategies
Click the create button to start a new strategy. You can create multiple strategies but only one can be active at a time.
On the next section you will need to give your strategy a name (this is so that you can easily idenity what strategy this is)
You can then add a filter:
In stock
Or
Supplier priority
Selecting "in stock" will then mean only prices from suppliers with the product in stock are considered. Unless no supplier has any stock in which case all prices are included.
Selecting supplier priority will being up a list of all available suppliers in your store and give you an option of adding a number in the "Prio" box. This is how you tell your store which supplier prices to pick first. The lower the number, the higher the priority (e.g. number 1 is the top priority).
You can create several combinations of "is-stock" and "supplier priority" strategies.
You will then need to select the calculation method from the drop down.
This can be:
Weighted average by stock
Median price
Lowest Price
Average Price
The store will then use the method selected in combination with your store price logic, to determine the sell price of your products.
Cost price examples (PDF) can be downloaded using the link/image below.
You could set up a strategy for "in-stock, lowest price" which would mean your store would calculate its sell price based up on the cheapest in-stock products available (in this instance with the supplier priority set the same, the store would consider all suppliers prices)
With this function you have ability to prioritise your suppliers on several levels.
You can continue to use the existing scenarios or create a strategy of your own. For example:
In this part, you activate or deactivate rounding on prices, including VAT
To access roundings go to Pricing>Roundings in the shop admin menu
Here you will have the following options:
Selecting "Round off sales prices including VAT" will determine whether the rounding rules you set here apply to the VAT or non-VAT price of products in your shop.
Interval
Select a price break point for the rounding to apply to (leaving this as default will apply to all pricing in the shop). Use the "Add" button to add multiple price breaks to apply different rounding rules.
Rounding mode
Round half up: This method rounds a number to the nearest specified place value, rounding up if the digit to the right is 5 or greater. For example, 2.5 rounds to 3.
Round half to even: (Banker's rounding): This method rounds a number to the nearest specified place value. If the digit to the right is exactly 5, it rounds towards the nearest even number. For example, 2.5 rounds to 2, and 3.5 rounds to 4.
Round half down: This method rounds a number to the nearest specified place value, rounding down if the digit to the right is 5 or less. For example, 2.5 rounds to 2.
Round up: This method always rounds a number up to the next specified place value, regardless of the digit to the right. For example, 2.1 rounds to 3.
Round down: This method always rounds a number down to the previous specified place value, regardless of the digit to the right. For example, 2.9 rounds to 2.
Rounding
Select the nearest number to round to (e.g. nearest 0.01p, 0.10p, £1.00 etc)
Offset
The offset is added before rounding and subtracted after to get a value like 1449 by subtracting 1 from a rounding to tens, or 9.99 by subtracting 0.01 from a rounding to whole numbers.
Example
Enter a start / in price here and "tab" to see how the current rounding settings will change the displayed price in the shop
ADD-ON
Through add-on feature "Global bid" it is possible to declare selected bid as global, these bids will subsequently apply to all customers.
Read more about shop settings related to bid handling:
If you are a reseller or customer who uses specialist pricing (known as bid´s). Some distributors can supply you with a bid feed in addition to your regular feed. Once this has been installed and connected to your Nettailer site, you can connect the right customers to the correct bid code. This shows all the bid`s that are currently on your feeds.
USEFUL TIP Through add-on feature “Global bid” you can declare selected bids as global so they automatically applies to all customers.
You can use this feature to test price logic's you have set for specific customer, customer groups or products. Simply put the product you want and the customer you want to test against in to the relevant boxes and the system will display the calculated purchase price, sales price, the price logic selected for that customer and even the Price level they are attached to.
After you click "Calculate", Nettailer will calculate why the price will be as it will be.
Here is the entire price logic used.
Feature
What it does
From date
Enter the date that the logic will come into effect.
To date
Enter the date what the logic will cease to be effective.
Type
Select whether the fixed price is for Normal or BID cost prices - or both.
Feature
What it does
Delete
If you want to delete a specific line, select this & click apply.
Part number
Use the search box to find the product you want to have a fixed price. Enter the part number or product name & click search. If multiple matches are found, refine your search or select the correct product.
Inprice
This will show the cost price for the selected product.
Fixed
Enter the price that you wish the product at.
Margin
This will show the margin you will make based on the Inprice & Fixed price.
From date
If you're creating a new fixed price, this will show today's date. Otherwise it will show the date the fixed price came into effect.
To date
If you're creating a new fixed price, this will show the default 'To date'. Otherwise it will show the date the fixed price will expire.
Type
If you're creating a new fixed price, select if you want the fixed price to be for normal or BID customers - or both. Otherwise it will show the current status of the line.
Feature
What it does
Product
Enter the product you want to test and click on search.
Customer or reseller
Can be left.
Customer
If there is a specific customer that you want to see why he receives a specific price, then enter it here. Otherwise leave blank if it is for Price level 1 or your standard Price level.
Feature
What it does
Price in store
Displays the retail price excluding VAT.
Used logic
Displays the pricing logic used.
Feature
What it does
Calculation step
Shows step by step how the calculation has been done.
Cost price
Shows your cost price. This does not necessarily have to be the cheapest price, but depends on the pricing logic you have chosen in Settings
BID id
Shows if the product has a BID and what ID that has.
