Module for website flexible pricing system. It allows setting financial strategies for website and adjusting to seasonal market fluctuations, making profitable offers of different goods categories for customers.
Location in admin panel: Pricing › Banker
“Banker” Module is flexible pricing. Read more about module price and connection on the website: http://en.otcommerce.com/prices-and-promo
“Top” and “Connect” Box versions include this module by default.
Read more about detailed description for business benefits here: Банкир (описание модуля)
“Banker” Module settings consist of two main steps:
- Add price group.
- Bind category to price group.
Add price group
It is possible to add price group for:
- For all goods categories.
- For several goods categories.
- For single goods category.
That is, it is possible to create unlimited number of price groups with different conditions for delivery calculation and margin percent to goods price.
Click “Add price group” in Banker tab to add price group:
Fill in “Price group name” field
Fill in "Description" field:
Choose Provider of items (it can be Warehouse also):
Decide whether this group will be used by default (that is, all goods categories will be added into default group if they are not be listed in any price groups) or not. If yes, then choose Default group by clicking the mouse in the white box on the right. Do not choose Default group if you create price group for specific goods category:
Default price group is marked by star in all groups list. There is only one default group for each provider:
It means that old default group will lose its status if you create new price group and set it as default.
Pricing for goods of different price categories is set in “Intervals” block:
First, we set margin for Local delivery (delivery within China set by Vendor on trade provider website):
Set delivery value in “Delivery price for this group CNY” field. This value will be taken for delivery price of 1 item.
Example: we set 20 yuan in this field and delivery price will be the following:
1 item = 20 yuan
2 items = 40 yuan
10 items = 200 yuan
Set in yuan:
Before (12 CNY )
After (20 CNY )
Now we add value to “Fixed margin for group CNY” field. This value is added to delivery price of any quantity of goods.
Example: on the condition above, we know that delivery price of each item is 20 yuan. We get the following result if we set 10 yuan in “Fixed margin for group CNY” field:
1 item = 20 yuan +10 yuan = 30 yuan
2 items = 2*20 yuan + 10 yuan = 50 yuan
10 items = 10*20 yuan + 10 yuan = 210 yuan
Set value in field:
Delivery can be also set for each price interval:
Default value will be used if fields are empty:
Goods: add price interval
There is a system of interval margin for goods margin.
Price interval is a basis of flexible pricing. The essence of intervals is to divide group of goods by price and set own margin and delivery.
For example: there are men’s pants at the price of 100 yuan, up to 1000 yuan and above. It is possible to divide into intervals: from 0 to 100 yuan, from 101 to 1000 yuan and from 1001 yuan and above. There are three intervals. And it is possible to make settings only for pants above 1000 yuan or only for pants below 1000 yuan.
We make the following settings as an example:
- Goods from 0 to 100 yuan will have 10% margin to each item and 25 yuan will be added to the total sum of all goods. Delivery by default.
- Goods from 100 to 300 yuan will have 15% margin to each item and 30 yuan will be added to the total sum of all goods. Delivery will be 10 yuan for each item and 20 yuan to total delivery.
- Goods from 300 yuan and above have 55% margin to each item and 70 yuan will be added to the total sum of all goods. Delivery by default.
Now we make settings in a special form. It is necessary to set initial value for each price interval. We add 2 additional fields to set 3 intervals. Click “Add price interval” link 2 times:
This is what we get:
We have enough fields now. We can start to add initial values of our intervals: 0, 100 and 300:
System automatically added second interval value.
What margin will be set for goods at the price of 100 yuan? It’s in two intervals at once!
Answer is the following: margin will depend on second interval (from 100 to 300 yuan), as the rightmost value is used to denote the border, and the last valid value will be one less, because the last value is already the first in the next interval.
- from 0 to 100 — last value is 99
- from 100 to 300 — last value is 299
- from 300 and above — any value from 300 to infinity
Mathematical notation is the following: [0; 100), [100; 300), [300; +∞)
Set margin from example above:
The table below will show example how these settings influence goods price and delivery:
“Delivery value CNY”
to delivery CNY”
Total sum of order
from 0 to 100
10×1 + 10% = 11
11 + 25 = 36
36 + 20×1 = 56
56 + 10 = 66
10×2 + 10% = 22
22 + 25 = 47
47 + 20×2 = 87
87 + 20 = 107
from 100 to 300
100×1 + 15% = 115
115 + 30 = 145
145 + 10×1 = 155
155 + 20 = 175
100×2 + 15% = 230
230 + 30 = 260
260 + 10×2 = 280
280 + 10 = 290
from 300 and above
1000×1 + 55% = 1550
1550 + 70 = 1620
1620 + 20×1= 1640
1640 + 10 = 1650
1000×2 + 55% = 3100
3100 + 70 = 3170
3170 + 20×2= 3210
3210 + 10 = 3220
Delete price interval
Click the cross right from interval if you need to delete interval:
Interval will be automatically recalculated:
Settings for advanced users
Here you can choose delivery calculation formula. All possible formulas are shown below.
Click a triangle of “Complex settings for advanced users” field to set appropriate pricing for delivery:
A menu to choose delivery calculation variant will open:
Below are definitions and formulas in order to quickly understand the process. Choose appropriate scheme and use!
- Pricing — the mechanism of goods price formation on showcase and in orders. This is a set of rules, settings, formulas that convert Taobao price to the one set by agent according to his rules.
- Local delivery — delivery from Taobao vendor to logistician (within China).
- Item code — goods ID visible in goods card and in address bar:
Formula title in dropdown list
(product + delivery)
Fixed delivery price is added to total sum regardless of quantity of ordered goods with one ID.
Item weight is taken into account. Fixed delivery is multiplied by one item (unit) weight.
Weight is 1 if it is unknown:
Fixed delivery price is added to each item.
Fixed delivery price is added to each item taking into account its weight. Item weight is taken if vendor set delivery price by weight steps (that is delivery price of the first kg and subsequent kg).
Item weight is equal to first step weight (for example, 10 kg) if weight is not set.
In example 1 we add 20 元 — because one item does not exceed the first weight step from condition.
In example 2 we add 5 元 — because 3 items 1,350 kg, that is first kg is for 20 元 and subsequent is for 5 元 as set in condition.
“Calculated weight” is used if vendor did not set delivery with weight step:
(3 items*10kg – 10kg)/(1kg*5 元 ) — this is calculation of approximate delivery of 3 items with 10 with “calculated” weight of 10 kg.
Calculation takes into account item weight rounded to even kg. Weight sum of all items with one ID is rounded.
In example 2 kg because weight sum of 3 items is 1,350 kg and it is rounded to 2 kg
( set by default)
AdvancedDelivery strategy (line 4 of this table) is used if vendor set delivery price calculation by weight steps (that is delivery price of first and subsequent kg)
Delivery price will be calculated according to items quantity (not weight) if vendor set delivery by items steps.
Vendor shows minimum delivery price (for example, for 10 items) and price of each subsequent items step (for example, each 2 items cost 5元) in this case
This is a strategy for more accurate delivery calculation of items with lack of weight set by vendor.
In example 1 we add 20 元 because 1 item does not exceed the first weight step from condition.
In example 2 we add 7 元 because 3 items 1,350 kg, that is first kg is for 20 元 and subsequent is for 7 元 as described in condition.
Items quantity is used if vendor did not set weight:
First 10 items cost 10元, each subsequent item costs — 1元.
Local delivery in item card is 0 in such strategy. Vendor delivery calculated by Taobao rules is added in a shopping cart.
Goods will be grouped by vendors and each group will have total delivery.
It is recommended to hide delivery options in item card not to confuse customers. It is done in Configuration — Website configuration — Item info
Actions with categories in price group
In fact, we add category to price group. Click gear icon in "Action" column next to group name:
Click “Edit categories of price group” in menu:
Click “Add” link to bind category:
Add link to category on your website into special field:
or click button next to field for link on the right and search for category in catalog:
Find appropriate category moving slider on the right:
Click + next to category name to choose subcategory:
Click category name to choose category:
Click “Choose” button when category is selected:
Click “Add” button in the form of category choice to bind category to price group:
“Banker” module settings for category “Toys” are complete.
Pricing for all other required categories is set similarly.
Click gear icon in "Action" column next to group name to edit categories bind to price group:
Click “Edit categories of price group” in menu:
Click gear icon in "Action" column next to group name to remove categories from price group:
Click “Edit categories of price group” in menu:
Click button with х in column “Action”:
Confirmation is required to remove. Click “Yes” if you really want to remove category from price group:
Edit and remove price group
Click gear icon in "Action" column next to group name:
Choose variant depending on further actions.
Click gear icon in "Action" column next to group name to edit price group:
Choose “Edit price group”:
Similar to “Add price group” form will open. Make changes and click “Save”:
Price group removal goes beyond recovery!
Click gear icon in "Action" column next to group name to remove price group:
Choose “Remove price group”:
Confirmation is required to remove. Click “Yes” if you really want to remove price group: