Complex promotion preferential calculation and cost allocation method

Abstract

The invention relates to a complex promotion discount calculation and cost allocation method, and aims to solve the problems of price calculation errors and cost allocation when an existing system processes complex promotion superposition. The method comprises the step of establishing a universal promotion model, a commodity-based promotion calculation system and a cost allocation module. The universal promotion model can meet promotion requirements of future retailers, and configuration work of multiple promotion is completed through one-to-many promotion rules, promotion ranges and promotion objects. The commodity-based sales promotion calculation system calculates the discount price of the commodity according to the sales promotion rule triggering condition and the discount content, and factors such as the lowest discount price and the top discount are considered. And after calculating the discount amount, the cost allocation module performs price allocation on each commodity, calculates the final discount price and performs cost allocation. According to the calculation method, the problems of price discount and cost allocation under the condition of complex promotion superposition can be effectively solved, and the competitiveness and attraction of the retail industry are improved.

Description

Technical Field

[0001] The present invention relates to the calculation of discounts and cost allocation for multiple promotional superpositions, and in particular to a method for calculating price discounts and cost allocation for commodities in multiple complex promotions. Background Art

[0002] At present, the competition in the retail industry is becoming increasingly fierce. In order to win in the fierce market competition, shopping malls use various means to attract consumers, among which product discounts are a major means. Discount promotion activities emerge in an endless stream. On the basis of traditional discounts such as full discounts, buy-one-get-one-free, full-rebate, discounts, and member prices, more complex combination promotions, gradient promotions, and multiple discount sharing have emerged. Complex promotion models and combinations have led to many retail software being unable to configure the corresponding combination effects, and even problems such as price calculation errors occur when multiple promotions are superimposed. Summary of the invention

[0003] Based on this, in view of the problems existing in the above existing systems, the present invention proposes a method for calculating complex promotional discounts and allocating costs. The present invention aims to solve the problems in the existing system that complex promotions cannot be configured or the discount price of goods under complex promotions is calculated incorrectly, and the cost allocation of goods is incorrect, through a reasonable and efficient discount and cost calculation method.

[0004] In order to achieve the above object, the present invention adopts the following technical solutions: A method for calculating and allocating complex promotional offers, the method comprising three parts: a general promotional model, a commodity-based promotional calculation system, and a cost allocation module.

[0005] General promotion model (please refer to Figure 2 ), which can meet the current and future retailer's promotion ideas. By establishing a promotion plan, one-to-many promotion rules, promotion scope, and promotion objects under the promotion plan can complete the configuration of one or more promotions. The promotion scope can be limited to time, applicable stores, applicable channels, etc. The promotion object can be limited to the applicable population. Promotion rules can configure a variety of specific trigger conditions and rewards for promotions. Please refer to the promotion rule model Figure 3 .

[0006] The product-based promotion calculation system calculates whether the discount is triggered and the number of times it is triggered through the conditions in the promotion, and then calculates the discount for the product based on the discount defined in the promotion. It also needs to consider factors such as the product's minimum discount price and whether discounts on discounts are allowed, and finally calculates the total amount of discounts enjoyed by the product after the manager's complex promotion.

[0007] The cost allocation module allocates the price of each product reasonably after the system has calculated the discount amount, so as to calculate the final discounted price of the product in this sale, and then allocate the cost of each product.

[0008] According to the invention, the calculation method recalculates the price of the product according to the promotion rules that can be triggered in the current promotion configuration every time the product in the shopping cart of the retail software is updated. This ensures that when there is any update to the shopping cart, the user can clearly know the change in the price of the product. It can more intuitively let customers see the discount amount enjoyed by the shopping cart product combination, thereby helping customers to achieve the most beneficial product purchase combination for them. Let customers enjoy the most suitable discount, improve user experience, and allow merchants to attract more customers. BRIEF DESCRIPTION OF THE DRAWINGS

[0009] Figure 1 The present invention provides a complete cash register flow chart.

[0010] Figure 2 A sales promotion scheme model diagram provided by the present invention.

[0011] Figure 3 The sales promotion rule model diagram provided by the present invention.

[0012] Figure 4 The present invention provides a complex sales promotion calculation flow chart. DETAILED DESCRIPTION

[0013] The purpose of the present invention is to calculate the discount amount of goods and allocate it to all goods in an efficient and accurate manner, which can be applied to complex promotion situations, so as to provide cost data for sellers. Figure 4 In order to deepen the understanding of the present invention, the present invention will be further described in detail with reference to examples, which are only used to explain the present invention and do not limit the protection scope of the present invention.

[0014] The steps to calculate the discount amount of a product under multiple promotions are as follows: When a customer selects a product and comes to the checkout counter to check out, the POS software will first create a shopping cart for the customer. When the shopping cart is created, the system will filter out all promotions that the customer can participate in based on promotion time period, promotion object, promotion channel and other conditions. As shown in the promotion model, each promotion will have a weight value attribute, which defaults to 1. Merchants can adjust the weight value according to the activity. The system will sort all promotions that can be participated in from high to low according to the weight value attribute of the promotion. If multiple promotions have the same weight value, they will be sorted from new to old based on the creation time of the promotion. Finally, a sorted promotion queue is formed.

[0015] When the quantity and price of a product in the shopping cart change, the promotion collision of the product will be triggered. The products in the shopping cart will be checked in the order of the promotions in the promotion queue to see if the promotion is triggered. If the product meets the triggering conditions of the promotion, it will enjoy the promotion discount, and then calculate the discount amount of the product in the promotion and the sales price of the product after the discount based on the discount content. When the product enters the next promotion collision, the new sales price will be used as the price reference. When the product in the shopping cart changes and triggers the promotion operation, the system will also pre-calculate the conditions required for the next level of the promotion for the first confirmed triggered promotion in the promotion queue, and display the result to the customer, providing the customer with shopping tips that meet the next level of discounts, thereby promoting consumption and giving suggestions on how to enjoy discounts when shopping. The following takes a certain buy AB get C free promotion in the promotion queue as an example to explain the promotion algorithm process in detail.

[0016] 1. First, enter the promotion in the shopping cart and obtain the promotion type through the promotion rules. Determine whether the various settings of the promotion are compliant, whether there are reasonable settings for promotion conditions and discounts. If everything is compliant, the promotion is considered to be a valid promotion and proceed to the next step. If not, it is considered to be an invalid promotion and skipped directly.

[0017] 2. Get all the items in the shopping cart through the shopping cart, and compare these items in turn. If the item is not in the list of items with promotion conditions (the list of items with promotion conditions is item A and item B), skip the item. If the item is in the list of items with promotion conditions, determine whether the item has participated in the same type of promotion. If it has, skip the item. If the item has enjoyed other promotions, and the current promotion does not allow promotion stacking, skip the item. If it has not participated in any of them, put the item into the set of items that meet the conditions. If the item is in the list of items with discount plans (item C is in the list of items with discount plans), also determine whether the item has participated in the same type of promotion and whether promotion stacking is allowed. If all the above conditions are passed, put the item into a discount plan set and continue to cycle the next item.

[0018] 3. When all products have been cycled, the module for finding the optimal solution for promotion is entered. This module checks the product set and discount scheme set that meet the conditions in turn. This module provides independent optimal solution calculation methods for various promotions according to different promotion types. For example, taking the promotion "Brand A cosmetics get 200 off for purchases over 1000", first filter the products, find all the cosmetics of the brand in the shopping cart, add up the total price, and then determine whether it is over 1000. If not, calculate how much money is left and give a prompt for the next stage of promotion, such as "If you buy cosmetics under brand A for X yuan again, you can enjoy the promotion 'Brand A cosmetics get 200 off for purchases over 1000'". The optimal solution returns empty, indicating that the promotion is not currently met. If the total price of the product exceeds 1000, the optimal solution calculation needs to be combined with the number of promotion repeats, the total price of the product, etc. If the number of repeats is 2, and the total price of the product is 3500 yuan, since the number of repeats cannot be exceeded, the promotion can be enjoyed twice, and there is no need to continue the next stage of promotion. Because the promotion has reached the maximum number of repeats. If the number of repetitions is 5 and the total price of the product is 3500, the optimal solution is 3500 divided by 1000, which equals 3, with a remainder of 500. The optimal solution returns that the promotion can be enjoyed 3 times, and there is still a difference of 500 yuan from the fourth enjoyment, and the corresponding next stage promotion reminder is given. For example, taking the promotion "Buy one product A and one product B, and get one product C for free" as an example, first check whether there are A and B in the set of products that meet the conditions. If A or B is missing, the optimal solution is empty, and the promotion is not triggered, and the promotion is skipped. If the conditional product set has A and B, then calculate the number of promotion enjoyments based on the number of A and B and whether the promotion is allowed to be enjoyed multiple times. For example, if there are 5 A and 3 B and the number of repetitions allowed is 10 times, the initial promotion enjoyment number is 3 times, because 1 A and 1 B can be enjoyed once. Then check the preferential plan set. If there is no C in the preferential plan set, the optimal solution module returns empty, and although the promotion meets the triggering conditions, there is no discounted product to enjoy, so the promotion is skipped. If there is C in the discount scheme set, then according to the previously calculated triggering discount number of 3, determine whether there are 3 products C that can support the discount. If there are only 2 Cs, the output promotion optimal solution is buy A + B get C free, and the discount is enjoyed twice. When the optimal solution is calculated and the optimal solution is not empty, determine whether the promotion is the first promotion triggered in the product queue. If it is the next promotion added on the basis of satisfying the optimal solution. When the shopping cart consists of 5 A, 3 B and 2 C products, the optimal solution is calculated to enjoy 2 times of buy A + B get C free, and the number of repeated enjoyments allowed is greater than 2 times, then the next promotion is theoretically 3 A + 3 B get 3 C. In this example, 3 A and 3 B have been satisfied, and 1 C is missing to implement the next promotion.The system will prompt the customer that according to this promotion, the customer can also get 1 C for free. Assuming that there are 5 A, 2 B, and 3 C in the shopping cart, through calculation, in order to meet the requirement of buying AB and getting C for free 3 times, one more B needs to be purchased. The system will prompt that buying another B can enjoy an additional promotion of buying AB and getting C for free. If the optimal solution calculation result of this promotion shows that the product has enjoyed the maximum number of repetitions in this promotion, the promotion is marked as "cannot calculate the next stage discount", and the next stage promotion reminder logic is skipped. After the subsequent promotion is triggered, the basis for judging whether to carry out the next stage promotion reminder logic is to sort according to the promotion queue, and then start from the first triggered promotion. If the first one is marked as "cannot calculate the next stage discount", it will skip and enter the next one. Until there is a promotion that can calculate the next stage discount.

[0019] 4. After getting the optimal solution for the promotion, calculate the total discount amount according to the discount plan. For example, if you calculate in the previous step that you can get 2 Cs for free if you buy AB and enjoy it twice, you can get 2 Cs for free. Assuming the unit price of C is 50 yuan, the total discount for this promotion is 100 yuan. Spread this 100 yuan to each product according to the total sales price of the participating products. Assume that there are 5 products A, 3 products B, and 2 products C. The unit price of product A is 50, the unit price of product B is 100, and the unit price of product C is 50. Then the total sales price of product A is 50*5=250, the total sales price of product B is 100*3=300, and the total sales price of product C is 50*2=100, so the discount allocated to product A is 100*(250 / (250+300+100))=38.46. The discount allocated to product B is 100*(300 / (250+300+100))=46.15. The discount allocated to product C is 100-38.46-46.15=15.39. Then the discount allocated to products ABC is evenly allocated to each product according to the number of products. Calculate the discount that each product can enjoy, and then subtract the discount price from the sales price to get the discounted price of each product after the promotion, which is also the updated sales price. At the same time, record the promotion process in the shopping cart so that customers can know and use it as a basis for historical document inquiries in the future.

[0020] After the shopping cart has gone through all the promotions in the promotion queue, the discounted price of each item will be updated to the final sales price, and the total sales price of the shopping cart is the total price after the promotion discount calculation. When the transaction is completed, all promotion participation and discount details of the transaction will be recorded on each item participating in the promotion in the transaction. In order to trace the process and reasons for the price change. At this point, the promotion superposition calculation is completed.

Claims

1. A method for calculating and allocating costs of complex promotional offers, characterized in that: The method includes the following modules: a promotion rule configuration module, a promotion discount calculation module, and a cost allocation module.

2. The method of claim 1, wherein: The promotion rule configuration module configures complex and varied promotion rules that can adapt to customers' complex promotion needs through a combination of conditions and triggering behaviors.

3. The method of claim 1, wherein: The promotion discount calculation module is used to analyze the content of the promotion rules, so as to calculate the price of the goods in real time after considering the promotion rules when the items in the checkout shopping cart change, and finally give the discount amount.

4. The method according to claim 1 or 3, wherein: After calculating the discount amount, the cost allocation module will reasonably allocate the total discount amount to the corresponding products based on the discount amount and the configured allocation rules, thereby helping customers perform cost accounting and other calculations.

Images