CN105184600A - Rule and operation-based electronic business platform price engine implementing method - Google Patents
Rule and operation-based electronic business platform price engine implementing method Download PDFInfo
- Publication number
- CN105184600A CN105184600A CN201510430856.7A CN201510430856A CN105184600A CN 105184600 A CN105184600 A CN 105184600A CN 201510430856 A CN201510430856 A CN 201510430856A CN 105184600 A CN105184600 A CN 105184600A
- Authority
- CN
- China
- Prior art keywords
- price
- engine
- commodity
- discipline
- strategy
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a rule and operation-based electronic business platform price engine implementing method and belongs to the electronic business platform price engine field. With the method of the invention adopted, a problem that electronic business platform prices cannot adapt and quickly respond to commodity price demands can be solved. According to the technical scheme of the invention, a price engine includes a design phase and an operational phase, wherein the design phase is responsible for designing the price strategy of the price engine and performing persistence processing on the strategy, and the operational phase is responsible for executing the price strategy according the content of the design phase. The method includes the following steps that: a corresponding database table is designed to persist the designed price strategy; a unified management background customized by the design phase is realized; when price strategy conditions and price rule actions are set, a plurality of price strategy conditions and a plurality of price rule actions are used in combination; and in the operation stage of the price engine, the database table is circulated, so that all price rule conditions are judged, if all the conditions are satisfied, all the price rule actions are executed in a circulating manner.
Description
Technical field
The present invention relates to a kind of electric business's Platform Price engine technique field, specifically a kind of rule-based electric business's Platform Price engine implementing method with operating.
Background technology
In general electric business's platform, merchandise news maintainer needs for commodity arrange multiple pricing usually, some electric business's platform realizes the design of multiple pricing by customized development, but this customization mode can not adapt to and the commodity price demand of quick response change, the change of each price usually brings extra coding work amount, and underaction is with quick.In the sales process of electricity business website, usually need again to set different prices to commodity, such as sticker price, special counter valency, promotion price, lowest price etc., may to specific commodity or catalogue within certain a period of time in order to improve sales volume during merchandise sales, even some fixing customer group and individual formulate exclusive price, and various price change demand brings larger challenge.
Prior art cannot accomplish, while meeting the demand of client, can respond new demand in time.
Summary of the invention
Technical assignment of the present invention is for above weak point, provides a kind of rule-based electric business's Platform Price engine implementing method with operating, and solves electric business's Platform Price and can not adapt to and the problem of the commodity price demand of quick response change.
The technical solution adopted for the present invention to solve the technical problems is:
Rule-based and operate electric business's Platform Price engine implementing method, price engine comprises design phase and operation phase two states, and the design phase is responsible for the price strategy designing price engine, and this strategy is done persistence process; Operation phase according to the content of design phase, strike price strategy; Comprise the steps:
(1), design corresponding database table and carry out the price strategy that persistence designed, database table includes but not limited to following database table: product_price table, product_price_rule table, product_price_cond table, product_promo_action table, product_price_type table, product_price_change table;
(2) the management backstage of a unified design phase customization, is realized, its function includes but not limited to: check all price strategy database tables, view or edit price strategy details, arrange price discipline, price discipline comprises price strategy condition and price discipline action;
(3), when price strategy condition and price discipline action are set, multiple price strategy condition is set and multiple price discipline combination of actions uses;
(4), price strategy condition is that one of following multiple condition or multiple conditional combination use, and the built-in price strategy condition of engine is including but not limited to following rule: specify commodity, formulate classification, specify product features, specify retail shop, formulate commodity amount, specify member's name, specify member's grouping, specify member's type, specify member role, specify price;
(5), price discipline action can be combinationally using of multiple action, and the built-in price discipline action of engine includes but not limited to following action: deduct close end price, substitute close end price, the number percent of marked price number percent, default price number percent, profit;
(6), operation phase of price engine refers to when user adds commodity to shopping cart, carries out the execution of price engine, execution according to the price discipline content being design phase design, comprise price strategy condition and price discipline action;
(7), the operation phase of price engine, the price discipline condition that first circular database list deciding is all, if all conditions is all satisfied, then circulation performs all price discipline actions, in this process, shopping cart entity as the close part of correlation comparison in this process called by as Parameter transfer;
(8), after accounting price, all calculation of price results will be set in commodity entity, when consumer does shopping in store, foreground, and the commodity price be after calculating of commodity details page display.
In step (1):
The essential information of product_price table for defining price strategy, includes but not limited to: goods number, price type, price value, price effective Start Date and price effective Close Date;
Product_price_rule table is for defining the header of price strategy, tactful self-defined title, remarks, start time, end time;
The corresponding relation that product_price_cond table performs an action for defining price discipline condition and price, includes but not limited to price discipline condition number, input parameter enumerated value, compare operation enumerated value, condition parameter values;
Product_promo_action table, for defining the details that price performs an action, includes, but are not limited to price discipline condition number, type that sequence number that price performs an action, price perform an action, performs an action variate-value;
Product_price_type table is for defining the type of price plan row, and relevant description;
Product_price_change table is used for defining price change historical record, record price type, new price record, original cost lattice record.
In step (4), the built-in price strategy condition of engine can carry out determined type setting, and the built-in determined type of engine comprises: equal, be not equal to, be less than, be less than or equal to, be greater than, be more than or equal to.
The functional realiey flow process of price engine is as follows:
1., the commodity price policy design stage, in merchandise control place on electric business backstage, arrange the multiple pricing of commodity, these prices are including but not limited to marked price, highest price, lowest price, promotion price, default price;
2., at price engine management interface, by the rule of combination, typing price engine, and combine, typing meets operation under this rule, and its persistence to be preserved;
3., in the price engine-operated stage, the condition of iteration price engine rule successively, and according to or regular decision condition true and false, if meet all conditions, the action lists of iteration executable operations, carries out the calculating of commodity price, and returns the price list of commodity;
4., when page display of commodity price and when placing an order, by Code obtaining to the marked price in commodity price list, promotion price and final price data, calculate or the real price of display of commodity according to these data.
The condition that step is 3. described and action all can repeatedly combinationally use, to reach diversified calculation of price method.
The marked price of commodity P1 is A unit, and acquiescence selling price is B unit, and reservation price is C unit, when buyer belongs to Gold Subscriber group, buys P1 and can enjoy eighty percent discount; The use flow process of price engine is as follows:
The first step, opens the visualized management interface of price engine, a newly-built price discipline, name nominating is: gold medal buyer eight folding is preferential, and by price discipline: when buyer belongs to Gold Subscriber group, buy commodity P1 and can enjoy eighty percent discount, input as the explanation of price engine remarks;
Second step, opens the newly-built price discipline page, newly-built price strategy condition 1: select built-in condition for working as user's group, and Selecting operation symbol is for equaling, and the member of input Gold Subscriber group organizes identification condition value;
3rd step, newly-built price strategy condition 2: select built-in rule to buy product for working as, Selecting operation symbol, for equaling, inputs the conditional value of the mark of commodity P1;
4th step, newly-built price discipline action 1: select built-in being operating as: the number percent of marked price, the value arranging computing is 80;
5th step, preserves whole price discipline to database table;
6th step, uses the account that user's group is Gold Subscriber group to log in shopping center, clicks commodity P1 and enter commodity details page, can check that the price of commodity is eight foldings of A unit;
7th step, namely the enforcement through the price discipline of above six steps electricity business platform declare to be finished, and after having implemented, user is newly-built or re-set price is regular in time according to the commodity price demand of oneself;
Above-mentioned A > B > C, and A, B, C are positive number.
Compared to the prior art a kind of rule-based electric business's Platform Price engine implementing method with operating of the present invention, has following beneficial effect:
By configuring flexibly and combining, can realize and meet diversified pricing policy in a little upper sale
Fast-changing demand can either be met, also do not need extra Xiang Mingda workload, but realize the change of commodity price and preferential by a series of configuration on backstage and cooperation
The features such as reasonable in design, structure is simple, be easy to processing, volume is little, easy to use, one-object-many-purposes, thus, have good value for applications.
Accompanying drawing explanation
Below in conjunction with accompanying drawing, the present invention is further described.
Accompanying drawing 1 is a kind of process flow diagram of rule-based electric business's Platform Price engine implementing method with operating.
Embodiment
Below in conjunction with the drawings and specific embodiments, the invention will be further described.
Embodiment 1:
Rule-based and operate electric business's Platform Price engine implementing method, price engine comprises design phase and operation phase two states, and the design phase is responsible for the price strategy designing price engine, and this strategy is done persistence process; Operation phase according to the content of design phase, strike price strategy;
Comprise the steps:
(1), design corresponding database table and carry out the price strategy that persistence designed, database table includes but not limited to following database table: product_price table, product_price_rule table, product_price_cond table, product_promo_action table, product_price_type table, product_price_change table;
(2) the management backstage of a unified design phase customization, is realized, its function includes but not limited to: check all price strategy database tables, view or edit price strategy details, arrange price discipline, price discipline comprises price strategy condition and price discipline action;
(3), when price strategy condition and price discipline action are set, multiple price strategy condition is set and multiple price discipline combination of actions uses;
(4), price strategy condition is that one of following multiple condition or multiple conditional combination use, and the built-in price strategy condition of engine is including but not limited to following rule: specify commodity, formulate classification, specify product features, specify retail shop, formulate commodity amount, specify member's name, specify member's grouping, specify member's type, specify member role, specify price;
(5), price discipline action can be combinationally using of multiple action, and the built-in price discipline action of engine includes but not limited to following action: deduct close end price, substitute close end price, the number percent of marked price number percent, default price number percent, profit;
(6), operation phase of price engine refers to when user adds commodity to shopping cart, carries out the execution of price engine, execution according to the price discipline content being design phase design, comprise price strategy condition and price discipline action;
(7), the operation phase of price engine, the price discipline condition that first circular database list deciding is all, if all conditions is all satisfied, then circulation performs all price discipline actions, in this process, shopping cart entity as the close part of correlation comparison in this process called by as Parameter transfer;
(8), after accounting price, all calculation of price results will be set in commodity entity, when consumer does shopping in store, foreground, and the commodity price be after calculating of commodity details page display.
In step (1):
The essential information of product_price table for defining price strategy, includes but not limited to: goods number, price type, price value, price effective Start Date and price effective Close Date;
Product_price_rule table is for defining the header of price strategy, tactful self-defined title, remarks, start time, end time;
The corresponding relation that product_price_cond table performs an action for defining price discipline condition and price, includes but not limited to price discipline condition number, input parameter enumerated value, compare operation enumerated value, condition parameter values;
Product_promo_action table, for defining the details that price performs an action, includes, but are not limited to price discipline condition number, type that sequence number that price performs an action, price perform an action, performs an action variate-value;
Product_price_type table is for defining the type of price plan row, and relevant description;
Product_price_change table is used for defining price change historical record, record price type, new price record, original cost lattice record.
In step (4), the built-in price strategy condition of engine can carry out determined type setting, and the built-in determined type of engine comprises: equal, be not equal to, be less than, be less than or equal to, be greater than, be more than or equal to.
Embodiment 2:
Rule-based and operate electric business's Platform Price engine implementing method, price engine comprises design phase and operation phase two states, and the design phase is responsible for the price strategy designing price engine, and this strategy is done persistence process; Operation phase according to the content of design phase, strike price strategy;
Comprise the steps:
(1), design corresponding database table and carry out the price strategy that persistence designed, database table includes but not limited to following database table: product_price table, product_price_rule table, product_price_cond table, product_promo_action table, product_price_type table, product_price_change table;
(2) the management backstage of a unified design phase customization, is realized, its function includes but not limited to: check all price strategy database tables, view or edit price strategy details, arrange price discipline, price discipline comprises price strategy condition and price discipline action;
(3), when price strategy condition and price discipline action are set, multiple price strategy condition is set and multiple price discipline combination of actions uses;
(4), price strategy condition is that one of following multiple condition or multiple conditional combination use, and the built-in price strategy condition of engine is including but not limited to following rule: specify commodity, formulate classification, specify product features, specify retail shop, formulate commodity amount, specify member's name, specify member's grouping, specify member's type, specify member role, specify price;
(5), price discipline action can be combinationally using of multiple action, and the built-in price discipline action of engine includes but not limited to following action: deduct close end price, substitute close end price, the number percent of marked price number percent, default price number percent, profit;
(6), operation phase of price engine refers to when user adds commodity to shopping cart, carries out the execution of price engine, execution according to the price discipline content being design phase design, comprise price strategy condition and price discipline action; Method is defined as follows:
publicstaticMap<String,Object>calculateProductPrice(DispatchContextdctx,Map<String,?extendsObject>context){
}；
(7), the operation phase of price engine, the price discipline condition that first circular database list deciding is all, if all conditions is all satisfied, then circulation performs all price discipline actions, in this process, shopping cart entity as the close part of correlation comparison in this process called by as Parameter transfer;
Wherein key code is as follows:
// cycle criterion
for(GenericValueproductPriceCond:productPriceConds){
totalConds++;
if(!checkPriceCondition(productPriceCond,productId,virtualProductId,prodCatalogId,productStoreGroupId,webSiteId,partyId,quantity,listPrice,currencyUomId,delegator,nowTimestamp)){
allTrue=false;
break;
}
if(allTrue){
// Query Database obtains the operation of all price engines
List<GenericValue>productPriceActions=delegator.findByAnd("ProductPriceAction",UtilMisc.toMap("productPriceRuleId",productPriceRuleId),null,true);
for(GenericValueproductPriceAction:productPriceActions){
totalActions++;
BigDecimalmodifyAmount=BigDecimal.ZERO;
// perform according to built-in price action iteration
if("PRICE_POD".equals(productPriceAction.getString("productPriceActionTypeId"))){
if(productPriceAction.get("amount")!=null){
modifyAmount=defaultPrice.multiply(productPriceAction.getBigDecimal("amount").movePointLeft(2));
price=defaultPrice;
}
}elseif("PRICE_POL".equals(productPriceAction.getString("productPriceActionTypeId"))){
if(productPriceAction.get("amount")!=null){
modifyAmount=listPrice.multiply(productPriceAction.getBigDecimal("amount").movePointLeft(2));
}
}elseif("PRICE_POAC".equals(productPriceAction.getString("productPriceActionTypeId"))){
if(productPriceAction.get("amount")!=null){
modifyAmount=averageCost.multiply(productPriceAction.getBigDecimal("amount").movePointLeft(2));
}
}elseif("PRICE_POM".equals(productPriceAction.getString("productPriceActionTypeId"))){
if(productPriceAction.get("amount")!=null){
modifyAmount=margin.multiply(productPriceAction.getBigDecimal("amount").movePointLeft(2));
}
}elseif("PRICE_POWHS".equals(productPriceAction.getString("productPriceActionTypeId"))){
if(productPriceAction.get("amount")!=null&&wholesalePrice!=null){
modifyAmount=wholesalePrice.multiply(productPriceAction.getBigDecimal("amount").movePointLeft(2));
}
}elseif("PRICE_FOL".equals(productPriceAction.getString("productPriceActionTypeId"))){
if(productPriceAction.get("amount")!=null){
modifyAmount=productPriceAction.getBigDecimal("amount");
}
}elseif("PRICE_FLAT".equals(productPriceAction.getString("productPriceActionTypeId"))){
foundFlatOverride=true;
if(productPriceAction.get("amount")!=null){
price=productPriceAction.getBigDecimal("amount");
}else{
Debug.logInfo("ProductPriceActionhadnullamount,usingdefaultprice:"+defaultPrice+"forproductwithid"+productId,module);
price=defaultPrice;
isSale=false;
}
}elseif("PRICE_PFLAT".equals(productPriceAction.getString("productPriceActionTypeId"))){
foundFlatOverride=true;
price=promoPrice;
if(productPriceAction.get("amount")!=null){
price=price.add(productPriceAction.getBigDecimal("amount"));
}
if(price.compareTo(BigDecimal.ZERO)==0){
if(defaultPrice.compareTo(BigDecimal.ZERO)!=0){
Debug.logInfo("PromoPriceandProductPriceActionhadnullamount,usingdefaultprice:"+defaultPrice+"forproductwithid"+productId,module);
price=defaultPrice;
}elseif(listPrice.compareTo(BigDecimal.ZERO)!=0){
Debug.logInfo("PromoPriceandProductPriceActionhadnullamountandnodefaultpricewasavailable,usinglistprice:"+listPrice+"forproductwithid"+productId,module);
price=listPrice;
}else{
Debug.logError("PromoPriceandProductPriceActionhadnullamountandnodefaultorlistpricewasavailable,sopriceissettozeroforproductwithid"+productId,module);
price=BigDecimal.ZERO;
}
isSale=false;
}
}elseif("PRICE_WFLAT".equals(productPriceAction.getString("productPriceActionTypeId"))){
foundFlatOverride=true;
price=wholesalePrice;
if(productPriceAction.get("amount")!=null){
price=price.add(productPriceAction.getBigDecimal("amount"));
}
if(price.compareTo(BigDecimal.ZERO)==0){
if(defaultPrice.compareTo(BigDecimal.ZERO)!=0){
Debug.logInfo("WholesalePriceandProductPriceActionhadnullamount,usingdefaultprice:"+defaultPrice+"forproductwithid"+productId,module);
price=defaultPrice;
}elseif(listPrice.compareTo(BigDecimal.ZERO)!=0){
Debug.logInfo("WholesalePriceandProductPriceActionhadnullamountandnodefaultpricewasavailable,usinglistprice:"+listPrice+"forproductwithid"+productId,module);
price=listPrice;
}else{
Debug.logError("WholesalePriceandProductPriceActionhadnullamountandnodefaultorlistpricewasavailable,sopriceissettozeroforproductwithid"+productId,module);
price=BigDecimal.ZERO;
}
isSale=false;
}
}
if(foundFlatOverride){
break;
}else{
price=price.add(modifyAmount);
}
}
}；
(8), after accounting price, all calculation of price results will be set in commodity entity, when consumer does shopping in store, foreground, and the commodity price be after calculating of commodity details page display.
In step (1):
The essential information of product_price table for defining price strategy, includes but not limited to: goods number, price type, price value, price effective Start Date and price effective Close Date;
Product_price_rule table is for defining the header of price strategy, tactful self-defined title, remarks, start time, end time;
The corresponding relation that product_price_cond table performs an action for defining price discipline condition and price, includes but not limited to price discipline condition number, input parameter enumerated value, compare operation enumerated value, condition parameter values;
Product_promo_action table, for defining the details that price performs an action, includes, but are not limited to price discipline condition number, type that sequence number that price performs an action, price perform an action, performs an action variate-value;
Product_price_type table is for defining the type of price plan row, and relevant description;
Product_price_change table is used for defining price change historical record, record price type, new price record, original cost lattice record.
In step (4), the built-in price strategy condition of engine can carry out determined type setting, and the built-in determined type of engine comprises: equal, be not equal to, be less than, be less than or equal to, be greater than, be more than or equal to.
The functional realiey flow process of price engine is as follows:
1., the commodity price policy design stage, in merchandise control place on electric business backstage, arrange the multiple pricing of commodity, these prices are including but not limited to marked price, highest price, lowest price, promotion price, default price;
2., at price engine management interface, by the rule of combination, typing price engine, and combine, typing meets operation under this rule, and its persistence to be preserved;
3., in the price engine-operated stage, the condition of iteration price engine rule successively, and according to or regular decision condition true and false, if meet all conditions, the action lists of iteration executable operations, carries out the calculating of commodity price, and returns the price list of commodity;
4., when page display of commodity price and when placing an order, by Code obtaining to the marked price in commodity price list, promotion price and final price data, calculate or the real price of display of commodity according to these data.
The condition that step is 3. described and action all can repeatedly combinationally use, to reach diversified calculation of price method.
Embodiment 3:
Rule-based and operate electric business's Platform Price engine implementing method, price engine comprises design phase and operation phase two states, and the design phase is responsible for the price strategy designing price engine, and this strategy is done persistence process; Operation phase according to the content of design phase, strike price strategy;
Comprise the steps:
(1), design corresponding database table and carry out the price strategy that persistence designed, database table includes but not limited to following database table: product_price table, product_price_rule table, product_price_cond table, product_promo_action table, product_price_type table, product_price_change table;
(2) the management backstage of a unified design phase customization, is realized, its function includes but not limited to: check all price strategy database tables, view or edit price strategy details, arrange price discipline, price discipline comprises price strategy condition and price discipline action;
(3), when price strategy condition and price discipline action are set, multiple price strategy condition is set and multiple price discipline combination of actions uses;
(4), price strategy condition is that one of following multiple condition or multiple conditional combination use, and the built-in price strategy condition of engine is including but not limited to following rule: specify commodity, formulate classification, specify product features, specify retail shop, formulate commodity amount, specify member's name, specify member's grouping, specify member's type, specify member role, specify price;
(5), price discipline action can be combinationally using of multiple action, and the built-in price discipline action of engine includes but not limited to following action: deduct close end price, substitute close end price, the number percent of marked price number percent, default price number percent, profit;
(6), operation phase of price engine refers to when user adds commodity to shopping cart, carries out the execution of price engine, execution according to the price discipline content being design phase design, comprise price strategy condition and price discipline action;
(7), the operation phase of price engine, the price discipline condition that first circular database list deciding is all, if all conditions is all satisfied, then circulation performs all price discipline actions, in this process, shopping cart entity as the close part of correlation comparison in this process called by as Parameter transfer;
(8), after accounting price, all calculation of price results will be set in commodity entity, when consumer does shopping in store, foreground, and the commodity price be after calculating of commodity details page display.
In step (1):
The essential information of product_price table for defining price strategy, includes but not limited to: goods number, price type, price value, price effective Start Date and price effective Close Date;
Product_price_rule table is for defining the header of price strategy, tactful self-defined title, remarks, start time, end time;
The corresponding relation that product_price_cond table performs an action for defining price discipline condition and price, includes but not limited to price discipline condition number, input parameter enumerated value, compare operation enumerated value, condition parameter values;
Product_promo_action table, for defining the details that price performs an action, includes, but are not limited to price discipline condition number, type that sequence number that price performs an action, price perform an action, performs an action variate-value;
Product_price_type table is for defining the type of price plan row, and relevant description;
Product_price_change table is used for defining price change historical record, record price type, new price record, original cost lattice record.
In step (4), the built-in price strategy condition of engine can carry out determined type setting, and the built-in determined type of engine comprises: equal, be not equal to, be less than, be less than or equal to, be greater than, be more than or equal to.
The marked price of commodity P1 is 200 yuan, and acquiescence selling price is 180 yuan, and reservation price is 120 yuan, when buyer belongs to Gold Subscriber group, buys P1 and can enjoy eighty percent discount; The use flow process of price engine is as follows:
The first step, opens the visualized management interface of price engine, a newly-built price discipline, name nominating is: gold medal buyer eight folding is preferential, and by price discipline: when buyer belongs to Gold Subscriber group, buy commodity P1 and can enjoy eighty percent discount, input as the explanation of price engine remarks;
Second step, opens the newly-built price discipline page, newly-built price strategy condition 1: select built-in condition for working as user's group, and Selecting operation symbol is for equaling, and the member of input Gold Subscriber group organizes identification condition value 10000;
3rd step, newly-built price strategy condition 2: select built-in rule to buy product for working as, Selecting operation symbol is for equaling, and the conditional value of the mark of input commodity P1 is DS001;
4th step, newly-built price discipline action 1: select built-in being operating as: the number percent of marked price, the value arranging computing is 80;
5th step, preserves whole price discipline to database table;
6th step, uses the account C that user's group is Gold Subscriber group to log in shopping center, clicks commodity P1 and enter commodity details page, can check that the price of commodity is 160 yuan;
7th step, namely the enforcement through the price discipline of above six steps electricity business platform declare to be finished, and after having implemented, user is newly-built or re-set price is regular in time according to the commodity price demand of oneself.
A kind of rule-based electric business's Platform Price engine implementing method with operating of the present invention, its structure comprises
By embodiment above, described those skilled in the art can be easy to realize the present invention.But should be appreciated that the present invention is not limited to above-mentioned embodiment.On the basis of disclosed embodiment, described those skilled in the art can the different technical characteristic of combination in any, thus realizes different technical schemes.
Except the technical characteristic described in instructions, be the known technology of those skilled in the art.
Claims (6)
1. rule-based electric business's Platform Price engine implementing method with operating, is characterized in that price engine comprises design phase and operation phase two states, and the design phase is responsible for the price strategy designing price engine, and this strategy is done persistence process; Operation phase according to the content of design phase, strike price strategy;
Comprise the steps:
(1), design corresponding database table and carry out the price strategy that persistence designed, database table includes but not limited to following database table: product_price table, product_price_rule table, product_price_cond table, product_promo_action table, product_price_type table, product_price_change table;
(2) the management backstage of a unified design phase customization, is realized, its function includes but not limited to: check all price strategy database tables, view or edit price strategy details, arrange price discipline, price discipline comprises price strategy condition and price discipline action;
(3), when price strategy condition and price discipline action are set, multiple price strategy condition is set and multiple price discipline combination of actions uses;
(4), price strategy condition is that one of following multiple condition or multiple conditional combination use, and the built-in price strategy condition of engine is including but not limited to following rule: specify commodity, formulate classification, specify product features, specify retail shop, formulate commodity amount, specify member's name, specify member's grouping, specify member's type, specify member role, specify price;
(5), price discipline action can be combinationally using of multiple action, and the built-in price discipline action of engine includes but not limited to following action: deduct close end price, substitute close end price, the number percent of marked price number percent, default price number percent, profit;
(6), operation phase of price engine refers to when user adds commodity to shopping cart, carries out the execution of price engine, execution according to the price discipline content being design phase design, comprise price strategy condition and price discipline action;
(7), the operation phase of price engine, the price discipline condition that first circular database list deciding is all, if all conditions is all satisfied, then circulation performs all price discipline actions, in this process, shopping cart entity as the close part of correlation comparison in this process called by as Parameter transfer;
(8), after accounting price, all calculation of price results will be set in commodity entity, when consumer does shopping in store, foreground, and the commodity price be after calculating of commodity details page display.
2. a kind of rule-based electric business's Platform Price engine implementing method with operating according to claim 1, is characterized in that in step (1):
The essential information of product_price table for defining price strategy, includes but not limited to: goods number, price type, price value, price effective Start Date and price effective Close Date;
Product_price_rule table is for defining the header of price strategy, tactful self-defined title, remarks, start time, end time;
The corresponding relation that product_price_cond table performs an action for defining price discipline condition and price, includes but not limited to price discipline condition number, input parameter enumerated value, compare operation enumerated value, condition parameter values;
Product_promo_action table, for defining the details that price performs an action, includes, but are not limited to price discipline condition number, type that sequence number that price performs an action, price perform an action, performs an action variate-value;
Product_price_type table is for defining the type of price plan row, and relevant description;
Product_price_change table is used for defining price change historical record, record price type, new price record, original cost lattice record.
3. a kind of rule-based electric business's Platform Price engine implementing method with operating according to claim 1, it is characterized in that in step (4), the built-in price strategy condition of engine can carry out determined type setting, and the built-in determined type of engine comprises: equal, be not equal to, be less than, be less than or equal to, be greater than, be more than or equal to.
4. a kind of rule-based electric business's Platform Price engine implementing method with operating according to claim 1, is characterized in that the functional realiey flow process of price engine is as follows:
1., the commodity price policy design stage, in merchandise control place on electric business backstage, arrange the multiple pricing of commodity, these prices are including but not limited to marked price, highest price, lowest price, promotion price, default price;
2., at price engine management interface, by the rule of combination, typing price engine, and combine, typing meets operation under this rule, and its persistence to be preserved;
3., in the price engine-operated stage, the condition of iteration price engine rule successively, and according to or regular decision condition true and false, if meet all conditions, the action lists of iteration executable operations, carries out the calculating of commodity price, and returns the price list of commodity;
4., when page display of commodity price and when placing an order, by Code obtaining to the marked price in commodity price list, promotion price and final price data, calculate or the real price of display of commodity according to these data.
5. a kind of rule-based electric business's Platform Price engine implementing method with operating according to claim 4, is characterized in that the condition that step is 3. described and action all can repeatedly combinationally use, to reach diversified calculation of price method.
6. a kind of rule-based electric business's Platform Price engine implementing method with operating according to claim 1, it is characterized in that the marked price of commodity P1 is A unit, acquiescence selling price is B unit, and reservation price is C unit, when buyer belongs to Gold Subscriber group, buy P1 and can enjoy eighty percent discount; The use flow process of price engine is as follows:
The first step, opens the visualized management interface of price engine, a newly-built price discipline, name nominating is: gold medal buyer eight folding is preferential, and by price discipline: when buyer belongs to Gold Subscriber group, buy commodity P1 and can enjoy eighty percent discount, input as the explanation of price engine remarks;
Second step, opens the newly-built price discipline page, newly-built price strategy condition 1: select built-in condition for working as user's group, and Selecting operation symbol is for equaling, and the member of input Gold Subscriber group organizes identification condition value;
3rd step, newly-built price strategy condition 2: select built-in rule to buy product for working as, Selecting operation symbol, for equaling, inputs the conditional value of the mark of commodity P1;
4th step, newly-built price discipline action 1: select built-in being operating as: the number percent of marked price, the value arranging computing is 80;
5th step, preserves whole price discipline to database table;
6th step, uses the account that user's group is Gold Subscriber group to log in shopping center, clicks commodity P1 and enter commodity details page, can check that the price of commodity is eight foldings of A unit;
7th step, namely the enforcement through the price discipline of above six steps electricity business platform declare to be finished, and after having implemented, user is newly-built or re-set price is regular in time according to the commodity price demand of oneself;
Above-mentioned A > B > C, and A, B, C are positive number.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510430856.7A CN105184600A (en) | 2015-07-21 | 2015-07-21 | Rule and operation-based electronic business platform price engine implementing method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510430856.7A CN105184600A (en) | 2015-07-21 | 2015-07-21 | Rule and operation-based electronic business platform price engine implementing method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105184600A true CN105184600A (en) | 2015-12-23 |
Family
ID=54906658
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510430856.7A Pending CN105184600A (en) | 2015-07-21 | 2015-07-21 | Rule and operation-based electronic business platform price engine implementing method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105184600A (en) |
Cited By (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106096992A (en) * | 2016-05-27 | 2016-11-09 | 乐视控股（北京）有限公司 | The changing method of commodity price and system |
| CN106126602A (en) * | 2016-06-21 | 2016-11-16 | 浪潮通用软件有限公司 | A kind of method realizing price strategy dictionary based on XML |
| CN107153982A (en) * | 2017-04-11 | 2017-09-12 | 深圳市粮食集团有限公司 | The intelligent movable ordering method and system of a kind of grain |
| CN107346489A (en) * | 2016-05-04 | 2017-11-14 | 湖南易分销电子商务有限公司 | MEC movement four-in-one electric business solves processing system and its method |
| CN107451872A (en) * | 2017-08-10 | 2017-12-08 | 中国民航信息网络股份有限公司 | The management method and device of flight freight rate |
| CN107451846A (en) * | 2016-05-31 | 2017-12-08 | 北京京东尚科信息技术有限公司 | The management method and managing device of business rule |
| CN107678808A (en) * | 2016-08-02 | 2018-02-09 | 阿里巴巴集团控股有限公司 | Page info Choice generation method and device |
| CN107730335A (en) * | 2016-08-11 | 2018-02-23 | 凡学（上海）教育科技有限公司 | A kind of multistage price data processing system applied to electric business platform |
| CN107766231A (en) * | 2016-08-22 | 2018-03-06 | 阿里巴巴集团控股有限公司 | A kind of automated testing method and device |
| CN107909400A (en) * | 2017-11-10 | 2018-04-13 | 广东亿迅科技有限公司 | System and method based on commodity price configuration |
| CN109032690A (en) * | 2018-06-20 | 2018-12-18 | 南京万米信息技术有限公司 | A kind of method and apparatus of dynamic processing marketing data |
| CN109993564A (en) * | 2018-01-02 | 2019-07-09 | 北京奇虎科技有限公司 | Methods of exhibiting, device and the computer readable storage medium of commodity price |
| CN110175862A (en) * | 2019-04-16 | 2019-08-27 | 苏宁易购集团股份有限公司 | Commodity price calculation method and system are sold for electric business platform |
| CN110428290A (en) * | 2019-08-07 | 2019-11-08 | 金瓜子科技发展（北京）有限公司 | A kind of data processing method and device |
| CN115619466A (en) * | 2022-09-07 | 2023-01-17 | 广东云徙智能科技有限公司 | Multi-dimensional high-pass extensible price management system |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2002312382A (en) * | 2001-04-18 | 2002-10-25 | Matsushita Electric Ind Co Ltd | Database management system |
| CN104463621A (en) * | 2014-11-27 | 2015-03-25 | 浪潮通用软件有限公司 | Electronic commerce platform sales promotion engine implementation method |
| CN104766228A (en) * | 2015-04-21 | 2015-07-08 | 陈博 | Electronic payment method, device and system based on price adjustment |
-
2015
- 2015-07-21 CN CN201510430856.7A patent/CN105184600A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2002312382A (en) * | 2001-04-18 | 2002-10-25 | Matsushita Electric Ind Co Ltd | Database management system |
| CN104463621A (en) * | 2014-11-27 | 2015-03-25 | 浪潮通用软件有限公司 | Electronic commerce platform sales promotion engine implementation method |
| CN104766228A (en) * | 2015-04-21 | 2015-07-08 | 陈博 | Electronic payment method, device and system based on price adjustment |
Cited By (17)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107346489A (en) * | 2016-05-04 | 2017-11-14 | 湖南易分销电子商务有限公司 | MEC movement four-in-one electric business solves processing system and its method |
| CN106096992A (en) * | 2016-05-27 | 2016-11-09 | 乐视控股（北京）有限公司 | The changing method of commodity price and system |
| CN107451846A (en) * | 2016-05-31 | 2017-12-08 | 北京京东尚科信息技术有限公司 | The management method and managing device of business rule |
| CN106126602A (en) * | 2016-06-21 | 2016-11-16 | 浪潮通用软件有限公司 | A kind of method realizing price strategy dictionary based on XML |
| CN107678808A (en) * | 2016-08-02 | 2018-02-09 | 阿里巴巴集团控股有限公司 | Page info Choice generation method and device |
| CN107730335A (en) * | 2016-08-11 | 2018-02-23 | 凡学（上海）教育科技有限公司 | A kind of multistage price data processing system applied to electric business platform |
| CN107766231B (en) * | 2016-08-22 | 2021-03-16 | 阿里巴巴集团控股有限公司 | Automatic testing method and device |
| CN107766231A (en) * | 2016-08-22 | 2018-03-06 | 阿里巴巴集团控股有限公司 | A kind of automated testing method and device |
| CN107153982A (en) * | 2017-04-11 | 2017-09-12 | 深圳市粮食集团有限公司 | The intelligent movable ordering method and system of a kind of grain |
| CN107451872A (en) * | 2017-08-10 | 2017-12-08 | 中国民航信息网络股份有限公司 | The management method and device of flight freight rate |
| CN107909400A (en) * | 2017-11-10 | 2018-04-13 | 广东亿迅科技有限公司 | System and method based on commodity price configuration |
| CN109993564A (en) * | 2018-01-02 | 2019-07-09 | 北京奇虎科技有限公司 | Methods of exhibiting, device and the computer readable storage medium of commodity price |
| CN109032690A (en) * | 2018-06-20 | 2018-12-18 | 南京万米信息技术有限公司 | A kind of method and apparatus of dynamic processing marketing data |
| CN110175862A (en) * | 2019-04-16 | 2019-08-27 | 苏宁易购集团股份有限公司 | Commodity price calculation method and system are sold for electric business platform |
| CN110428290A (en) * | 2019-08-07 | 2019-11-08 | 金瓜子科技发展（北京）有限公司 | A kind of data processing method and device |
| CN115619466A (en) * | 2022-09-07 | 2023-01-17 | 广东云徙智能科技有限公司 | Multi-dimensional high-pass extensible price management system |
| CN115619466B (en) * | 2022-09-07 | 2023-05-16 | 广东云徙智能科技有限公司 | Multi-dimensional high-generality extensible price management system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105184600A (en) | Rule and operation-based electronic business platform price engine implementing method | |
| CN103729359B (en) | A kind of method and system recommending search word | |
| CN103164804B (en) | The information-pushing method of a kind of personalization and device | |
| CN104077693B (en) | Commodity control methods, server, client and e-commerce system | |
| CN112837118B (en) | Commodity recommendation method and device for enterprise users | |
| CN106127504A (en) | The method for pushing of electronic article certificate, generation method, device, user terminal and server | |
| CN106251168A (en) | Information-pushing method and system | |
| CN110033331A (en) | A kind of distribution method of discount coupon, system and terminal device | |
| CN107301592A (en) | The method and device excavated for commodity substitute | |
| CN103971256A (en) | Information push method and device | |
| CN110852818A (en) | Commodity sorting method and device and computer-readable storage medium | |
| CN113761393A (en) | Commodity collaborative recommendation method and device, equipment, medium and product thereof | |
| Abdullah et al. | Evaluating E-commerce website content management system in assisting usability issues | |
| CN109190027A (en) | Multi-source recommended method, terminal, server, computer equipment, readable medium | |
| US20120078887A1 (en) | Method and system for limiting share of voice of individual users | |
| CA2805264C (en) | Product pricing in e-commerce | |
| CN113449116B (en) | Map construction and early warning method, device and medium | |
| Yang et al. | Discovery of online shopping patterns across websites | |
| CN103793828A (en) | Electronic shopping method and device | |
| KR20230160766A (en) | Electronic apparatus for providing information of discount and method thereof | |
| CN108510302A (en) | A kind of marketing decision-making method and trading server | |
| CN108062666A (en) | Intelligent cashier system and method | |
| CN106920124A (en) | A kind of Data acquisition and issuance method and device | |
| CN116757715A (en) | Ranking list generation method and device, storage medium and computer equipment | |
| CN116167825A (en) | Commodity recommendation method, device, equipment and storage medium based on electronic commerce |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20151223 |
|
| WD01 | Invention patent application deemed withdrawn after publication |