JP5847279B1 - Server in sales promotion management system, control method thereof, and control program thereof - Google Patents

Abstract

An object of the present invention is to provide a sales promotion management system and the like capable of taking measures to increase the number of customers while optimizing payment of sales promotions. A sales promotion management server 3 acquires POS data including at least customer identification information, product identification information, and a sales price from a retailer side system, and the acquired POS data and a promotion stored in a server storage unit 32. Based on the information, the discount sales result information is created by specifying the discount information of the products sold by discount in a specific promotion and counting the sales quantity. From the product provider to the retailer with reference to the discounted sales performance information creation unit 335 for storing the created discounted sales performance information in the discounted sales performance information stored in the server storage unit and the discounted sales performance information stored in the server storage unit A sales promotion money calculation unit 337 that calculates the sales promotion money for the specific promotion based on the normal sales price, the discount information, and the sales quantity of the discounted product. [Selection] Figure 5

Description

  The present invention relates to a sales promotion management system that manages a sales promotion plan for a retail business store such as a supermarket or a convenience store, a business type that uses a POS register, and a business type.

  There is a practice of paying a rebate (hereinafter referred to as “sales promotion”) in a wholesale business that wholesales various products to the retail industry. The sales promotion is a rebate or incentive paid based on the delivery performance that has been raised to the retailer over a certain period in order for the product provider to promote sales with cooperation in the distribution channel. After the product is sold, the price is collected, and the product provider pays the retailer according to the amount. A merchandise provider is a person who manufactures or provides merchandise to retailers such as manufacturers, wholesalers, and telecommunications carriers.

  In Patent Literature 1, sales performance data for each product provider and target product is introduced into the calculation formula obtained based on the rebate conditions for each product provider and target product, and for each product provider and target product. A rebate management system for calculating sales promotions is described.

  Patent Document 2 describes a sale commodity determination support server including theme diversion means for providing sales promotion theme candidate information of a sales plan for a specified week based on a record of a sales plan for a specified week in the past.

  In Patent Document 3, a server prepares customer promotion plan information corresponding to customer identification information based on purchase status information and a plurality of sales promotion plan information prepared in advance, and a POS register is possessed by the customer. A sales promotion system is described in which customer identification information of a customer is read from a medium, and transaction is performed with transaction details to which customer promotion plan information corresponding to the read customer identification information is applied.

  However, as shown in FIG. 18, in Patent Document 1, a merchandise provider and a retailer conduct a regular transaction with a merchandise quantity of 100, and a retailer normally sells 70 merchandise out of 100 merchandise. Even if the product is sold at a discount, the sales promotion money is calculated according to the product of the quantity of 100 which is the total sales result of the product of the quantity sold normally 70 and the product of the quantity 30 sold discount. Therefore, it is impossible to grasp whether the sales performance is due to discount sales, and there is a feeling of overpayment of the sales promotion payment.

  Further, Patent Documents 2 and 3 have a problem that the discount amount is limited because only retailers have to prepare discount funds for sales promotion.

JP 2005-63378 A JP 2013-182362 A JP 2008-234336 A

  Accordingly, the present invention has been made to solve such problems, and a server in a sales promotion management system capable of taking measures to increase the number of customers while optimizing payment of sales promotions, its control method, and its control The purpose is to provide a program.

  The server according to the present invention is a server in a sales promotion management system including a server communicable with a retailer side system, and the server includes promotion information including customer identification information, product identification information, and discount information; A storage unit for storing identification information, product identification information, sales price, discount information, and discount sales performance information including sales quantity, and a POS including at least customer identification information, product identification information, and sales price from the retailer system Discount sales performance information by acquiring data, specifying discount information of products discounted and sold in a specific promotion based on the acquired POS data and promotion information stored in the storage unit, and counting the sales quantity The discounted sales results are stored in the storage unit. With reference to the discount sales performance information creation unit stored in the information and the discount sales performance information stored in the storage unit, the sales promotion money for the specific promotion from the product provider to the retailer A sales promotion calculation unit that calculates based on the normal sales price, discount information, and sales quantity is provided.

  In the server according to the present invention, when the promotion information stored in the storage unit further includes an implementation period, the retailer-side system reads the customer identification information of the customer's membership card, and reads the read customer identification information into the server. The server receives the customer identification information from the storefront terminal, and executes the promotion corresponding to the customer based on the received customer identification information of the customer and the promotion information stored in the storage unit. It is preferable to further include a promotion execution unit that transmits the period, product name, and discount information to the store terminal.

  In the server according to the present invention, the storage unit includes discount information for each product provider and negotiation discount information including product provider supplement information for each product and / or product category, product provider supplement information, and result reward information. The server further stores the performance reward data, and the server refers to the discount sales performance information, the negotiation discount information, and the performance reward data stored in the storage unit, and determines the performance reward from the retailer to the sales promotion manager in the specific promotion. In addition, it is preferable to further include a result reward calculation unit that calculates based on the actual sales price after discount in the specific promotion, the sales quantity, and the result reward information.

  In the server according to the present invention, the storage unit further stores customer information including customer identification information and customer attribute information, and recommendation information including product identification information, discount information, and target customer information. The server can communicate with the terminal and the product provider terminal, and the server refers to the acquired POS data and customer information stored in the storage unit, and proposes recommendation information including product identification information, discount information, and target customer information. A recommendation plan creation unit that sends a proposal of the created recommendation information to the retailer side terminal, and recommendation information including product identification information, discount information, and target customer information is received from the retailer side terminal and received. The recommendation information is transmitted to the product provider side terminal, and approval approval / disapproval information indicating approval / disapproval of the transmitted recommendation information is received from the product provider side terminal. A Mend proposing unit, if the authorization whether information received indicates approval friendly, it is preferable to further comprising a negotiation workflow portion that stores the recommendation information stored recommendation information approved in the storage unit.

  In the server according to the present invention, the customer information further includes an email address, and the server refers to the recommendation information and the customer information stored in the storage unit, and the target customer information of the recommendation information matches the customer attribute information of the customer information. It is preferable to further include a promotion information creation unit that extracts a customer's email address and creates promotion information including the extracted email address.

  In the server according to the present invention, the recommendation plan creation unit updates the life values of the customer information stored in the storage unit based on the acquired POS data, and creates a plan for the recommendation information based on the updated life values. It is preferable to create.

  In the server according to the present invention, the server receives a search condition including at least one of product identification information, discount information, and target customer information from a retailer side terminal or a product provider side terminal, and a storage unit With reference to the discounted sales record information and promotion information stored in the table, the purchase probability indicating the ratio of the purchased customers out of the customers for which at least one of the received search conditions is the target of the same promotion is calculated. It is preferable to further include a recommendation result analysis unit that transmits the calculated purchase probability to the retailer side terminal or the product provider side terminal.

  In the server according to the present invention, when the approval approval / disapproval information received indicates that approval is not possible, the negotiation workflow unit transmits information prompting correction to the product provider side terminal, and stores product identification information, discount information, and target customer information. Including the correction recommendation information including the received correction recommendation information to the retailer side terminal, receiving the approval propriety information indicating whether the sent correction recommendation information is approved from the retailer side terminal, When the received approval approval / disapproval information indicates approval approval, it is preferable to store the approved correction recommendation information in the recommendation information stored in the storage unit.

  A server control method according to the present invention is a server in a sales promotion management system including a server communicable with a retailer-side system, including promotion information including customer identification information, product identification information, and discount information, and customer identification A storage unit that stores information, product identification information, sales price, discount information, and discount sales performance information including sales quantity, the server including at least customer identification information from the retailer side system POS data including product identification information and sales price is acquired, and based on the acquired POS data and the promotion information stored in the storage unit, the discount information of the product sold at a specific promotion is specified and sold. Create discount sales performance information by counting quantity, and create discount sales Store the actual sales information in the discounted sales performance information stored in the storage unit, refer to the discounted sales performance information stored in the storage unit, and discount the sales promotion for the specific promotion from the product provider to the retailer in the specific promotion Calculation is performed based on the normal sales price, discount information, and sales quantity of the sold product.

  A server control program according to the present invention is a server in a sales promotion management system including a server communicable with a retailer-side system, and includes promotion information including customer identification information, product identification information, and discount information, and customer identification A storage control program for storing information, product identification information, sales price, discount information, and discount sales performance information including sales quantity, the server having at least customer identification information from a retailer system POS data including product identification information and sales price is acquired, and based on the acquired POS data and the promotion information stored in the storage unit, the discount information of the product sold at a specific promotion is specified and sold. Create discount sales performance information by counting quantity and create The discount sales performance information is stored in the discount sales performance information stored in the storage section, the discount sales performance information stored in the storage section is referred to, and the promotional money for the specific promotion from the product provider to the retailer is specified. Calculation is executed based on the normal sales price, discount information, and sales quantity of the discounted product in the promotion.

  According to the server, the control method, and the control program in the sales promotion management system according to the present invention, the sales price is not calculated for the product sold at the normal sales price, and the discount is sold in the promotion for the specific customer. By calculating the sales promotion only for the product, the product provider can optimize the payment of the sales promotion, and the retailer collects the source of the discount from the product provider as a sales promotion, while promoting the promotion. Can be prevented from leaking to other stores. Furthermore, because it is possible to promote regular products that are usually displayed in retail stores without preparing special products, there is no need to display special products, so the workload on the retail store side is reduced. It is reduced.

  In addition, since a server different from the retailer side system executes processing on the POS data acquired from the retailer side system, the scope of change of the retailer side system such as the existing chain or store POS cash register is small. it can.

An example of the outline | summary of the sales promotion payment according to discount sales performance is shown. An example of an overview of the one-to-one promotion service is shown. An example of schematic structure of a sales promotion management system is shown. An example of schematic structure of 1 A of merchandise provider side terminals, the retailer side terminal 1B, and the headquarters server 2 is shown. An example of schematic structure of the sales promotion management server 3 is shown. An example of schematic structure of the shop POS server 4 and the shop front terminal 5 is shown. An example of the data structure of the various tables memorize | stored in the server memory | storage part 32 is shown. An example of the data structure of the various tables memorize | stored in the server memory | storage part 32 is shown. An example of the operation flow of the sales promotion management server 3 is shown. An example of an operation sequence of the recommendation proposing unit 333 is shown. An example of the operation sequence of the negotiation workflow unit 334 is shown. An example of the operation | movement sequence of the promotion implementation part 336 is shown. An example of the operation sequence of the promotion execution part 336 and the recommendation result analysis part 339 is shown. An example of the recommendation proposal screen and correction screen of the retailer side terminal 1B is shown. The other example of the recommendation proposal screen of the retailer side terminal 1B and a correction screen is shown. An example of the recommendation approval screen and the correction screen of the retailer side terminal 1B and the product provider 1A is shown. An example of the recommendation result search screen of the retailer side terminal 1B and a recommendation result list screen is shown. An example of the outline | summary of the sales promotion payment according to the conventional sales performance is shown.

  Hereinafter, various embodiments of the present invention will be described with reference to the drawings. However, it should be noted that the technical scope of the present invention is not limited to these embodiments, and extends to the invention described in the claims and equivalents thereof.

  FIG. 1 is a diagram illustrating an example of an outline of sales promotion payment according to discount sales results.

  The retailer trades and purchases 100 quantities of products from the product provider. A retailer sells 70 quantities of merchandise to regular customers at regular selling prices. Retailers carry out promotions that sell specific products at discounted prices only to specific customers. The retailer notifies the particular customer of the promotion. A retailer sells 30 quantities of merchandise to a particular customer at a reduced price to prevent the particular customer from leaking to other stores. Then, the sales promotion manager collects from the merchandise provider by charging the merchandise provider with a sales promotion money according to the discounted sales performance of 30 quantities of merchandise. The sales promotion manager returns the sales promotion money collected according to the discounted sales performance of 30 quantities of products to the retailer. Finally, the promotion manager receives the performance fee from the retailer by charging the retailer for the performance fee. The sales promotion manager refers to a person who manages the sales promotion management server 3 and performs a sales promotion management service. Such a sales promotion management service is called a “One to One” promotion service.

  FIG. 2 is a diagram illustrating an example of an outline of a one-to-one promotion service.

  First, the contents of the promotion whose promotion ID is P001 will be described with reference to FIG. The promotion with the promotion ID P001 performs the following discount for the customers A to C at the store A of the retailer X chain. Customer A is 10% discount for green tea and 10% discount for tomato, Customer B is 20% discount for green tea, 50% discount for pizza and 20% discount for tomato, and Customer C is 10% discount for pizza And beer is 30% off. That is, even if the promotion ID is the same and the product is the same, there can be multiple discounts for each customer.

  Next, promotion will be described with reference to FIG. When customer A presents a membership card at store terminal 5 and the card reader of store terminal 5 reads the customer ID of customer A's membership card, 10% of green tea is discounted from July 1 to July 10, And the information regarding the promotion with respect to the customer A whose tomato is 10% discount is displayed on the display part 54 of the shop front terminal 5. From July 1st to July 10th, customer B's e-mail is sent with information related to promotions for customer B with a 20% discount on green tea, a 50% discount on pizza, and a 20% discount on tomatoes. The customer B confirms by outputting an e-mail on the display unit of the customer terminal of the customer B. From July 1st to July 10th, information related to the promotion for customer C, which is 10% discount for pizza and 30% discount for beer, is transmitted to the email of customer C. The customer C confirms by outputting an e-mail on the display unit of the customer side terminal of the customer C.

  Next, accounting will be described with reference to FIG. When the customer A presents the membership card, green tea, and tomato to the POS cash register 6 of the store, the card reading unit of the POS cash register 6 reads the customer ID of the membership card, and the POS cash register 6 prompts the customer A for the promotion. Reduce the price. That is, the POS cash register 6 reduces the price of green tea by 10%, reduces the price of tomato by 10%, and outputs “10% discount of green tea and 10% discount of tomato” on the display unit.

  When customer B presents a membership card, green tea and pizza to the store's POS register 6, the card reading unit of the POS register 6 reads the customer ID of the member card, and the POS register 6 gives an immediate discount for promotion to the customer B. To do. That is, the POS register 6 reduces the green tea by 20%, reduces the pizza by 50%, and outputs “green tea 20% discount and pizza 50% discount” on the display unit. Although the customer A and the customer B present the same green tea to the POS cash register 6, the discount rates are different.

  When the customer C presents the membership card, green tea, and pizza to the POS cash register 6 of the store, the card reading unit of the POS cash register 6 reads the customer ID of the membership card, and the POS cash register 6 is immediately discounted for promotion to the customer. do. That is, the POS register 6 reduces the pizza by 10%, outputs “pizza 10% discount” on the display unit, and does not discount the green tea. This is because the green tea discount is not included in the promotion for customer C.

  In this way, by discounting by customer for one product in the same promotion, the retailer can prevent outflow of a specific customer who executes the promotion to another store.

  FIG. 3 is a diagram illustrating an example of a schematic configuration of the sales promotion management system.

  The sales promotion management system includes a product provider side terminal 1A, a retailer side terminal 1B, an X chain headquarter server 2, a sales promotion management server 3, an X chain A store POS server 4, a storefront terminal 5, and a POS. And a cash register 6.

  Since the retailer side terminal 1B, the X chain headquarters server 2, the X chain A store POS server 4, the storefront terminal 5, and the POS register 6 are installed on the retailer side, the retailer side system is used. . The retailer-side terminal 1B is installed at the retailer's headquarters or at each store. The X chain headquarters server 2 is installed at the retailer's headquarters. The X chain A store POS server 4, the storefront terminal 5, and the POS cash register 6 are installed in each store of the retailer.

  The retailer side terminal 1B, the X chain headquarter server 2, the X chain A store POS server 4, the storefront terminal 5, and the POS cash register 6 are connected to each other via a store network 7 so as to communicate with each other. The store network 7 may be an intranet, the Internet, or another communication network. The sales promotion management server 3 includes a product provider side terminal 1A, a retailer side terminal 1B, an X chain headquarter server 2, an X chain A store POS server 4, a storefront terminal 5, and a POS cash register 6. 8 are communicably connected to each other. The Internet 8 may be another communication network. A program (for example, a browsing program) executed by the product provider side terminal 1A, the retailer side terminal 1B, and the storefront terminal 5 and a program (for example, a server control program) executed by the sales promotion management server 3 Communication is performed using a communication protocol such as Hypertext Transfer Protocol (HTTP) or HTTP over TLS. The product provider side terminal 1A, the retailer side terminal 1B, the X chain headquarter server 2, the X chain A store POS server 4, the storefront terminal 5, and the POS register 6 are shown as one unit. It is not limited to.

  FIG. 4 is a diagram illustrating an example of a schematic configuration of the product provider side terminal 1A and the retailer side terminal 1B. The product provider side terminal 1 </ b> A and the retailer side terminal 1 </ b> B connect to the sales promotion management server 3 via the Internet 8 and communicate with the sales promotion management server 3. The product provider side terminal 1 </ b> A and the retailer side terminal 1 </ b> B include a terminal communication unit 11, a terminal storage unit 12, an operation unit 13, a display unit 14, and a terminal processing unit 15.

  In the present embodiment, a desktop computer is assumed as the product provider side terminal 1A and the retailer side terminal 1B, but the present invention is not limited to this. The product provider side terminal 1A and the retailer side terminal 1B only need to be able to apply the present invention. For example, a notebook PC, a mobile phone (so-called “feature phone”), a smartphone, a mobile information terminal (Personal Digital Assistant, PDA) ), A tablet terminal, a wearable terminal, or the like.

  The terminal communication unit 11 includes a communication interface circuit, connects the product provider side terminal 1A to the Internet 8, and connects the retailer side terminal 1B to the store network 7 and / or the Internet 8. The terminal communication unit 11 transmits the input data supplied from the terminal processing unit 15 to the sales promotion management server 3 or the like. Further, the terminal communication unit 11 supplies the screen of the web page received from the sales promotion management server 3 or the like to the terminal processing unit 15.

  The terminal storage unit 12 includes, for example, at least one of a semiconductor memory, a magnetic disk device, a semiconductor storage device, and an optical disk device. The terminal storage unit 12 stores an operating system program, a driver program, an application program, data, and the like used for processing in the terminal processing unit 15. For example, the terminal storage unit 12 stores an input device driver program for controlling the operation unit 13 and an output device driver program for controlling the display unit 14 as driver programs. Furthermore, the terminal storage unit 12 may temporarily store temporary data related to a predetermined process.

  The operation unit 13 may be any device that can operate the product provider side terminal 1A and the retailer side terminal 1B, such as a touch pad, a touch panel, and a keyboard. A merchandise provider or retailer can input characters, numbers, and the like using the operation unit 13. When operated by the merchandise provider or retailer, the operation unit 13 generates a signal corresponding to the operation. The generated signal is supplied to the terminal processing unit 15 as input data of the product provider or retailer.

  The display unit 14 may be any device as long as it can display an image, a screen, or the like, such as a liquid crystal display or an organic EL (Electro-Luminescence) display. The display unit 14 displays a screen of the web page supplied from the terminal processing unit 15.

  The terminal processing unit 15 includes one or a plurality of processors and their peripheral circuits. The terminal processing unit 15 controls the overall operation of the product provider side terminal 1A and the retailer side terminal 1B, and is, for example, a CPU (Central Processing Unit). The terminal processing unit 15 is configured to execute various processes of the product provider side terminal 1A and the retailer side terminal 1B in an appropriate procedure according to the program stored in the terminal storage unit 12, the operation of the operation unit 13, and the like. In addition, the operation of the terminal communication unit 11 and the display unit 14 is controlled. The terminal processing unit 15 executes processing based on programs (operating system program, driver program, application program, etc.) stored in the terminal storage unit 12. Further, the terminal processing unit 15 can execute a plurality of programs (such as application programs) in parallel.

  The terminal processing unit 15 includes a browsing execution unit 151. The browsing execution unit 151 is a functional module realized by a program executed by a processor provided in the terminal processing unit 15. Or the browsing execution part 151 may be mounted in the goods provider side terminal 1A and the retailer side terminal 1B as firmware.

  The browsing execution unit 151 acquires and displays a screen. In addition, the browsing execution unit 151 transmits recommendation information and the like corrected by the product provider or retailer to the server 3 via the terminal communication unit 11. In addition, the browsing execution unit 151 receives a web page screen corresponding to the processing result for the recommendation information, the promotion information, and the like from the server 3 via the terminal communication unit 11. The browsing execution unit 151 outputs the received web page screen to the display unit 14.

  FIG. 4B is a diagram illustrating an example of a schematic configuration of the headquarter server 2.

  The headquarter server 2 includes a headquarter server communication unit 21, a headquarter server storage unit 22, and a headquarter server processing unit 23.

  The explanation about the headquarter server communication unit 21 and the headquarter server storage unit 22 of the headquarter server 2 is the same as the terminal communication unit 11 and the terminal storage unit 12 of the product provider side terminal 1A and the retailer side terminal 1B of FIG. is there.

  The headquarter server processing unit 23 includes one or a plurality of processors and their peripheral circuits. The headquarter server processing unit 23 controls the overall operation of the headquarter server 2, and is, for example, a CPU (Central Processing Unit). The headquarter server processing unit 23 controls the operations of the headquarter server communication unit 21 and the like so that various processes of the headquarter server 2 are executed according to a program stored in the headquarter server storage unit 22. . The headquarter server processing unit 23 executes processing based on a program (operating system program, driver program, application program, etc.) stored in the headquarter server storage unit 22. Further, the headquarter server processing unit 23 can execute a plurality of programs (such as application programs) in parallel.

  The headquarter server processing unit 23 includes a POS data transfer unit 231. The POS data transfer unit 231 is a functional module realized by a program executed by a processor included in the headquarter server processing unit 23. Alternatively, the POS data transfer unit 231 may be implemented in the main server 2 as firmware.

  The POS data transfer unit 231 receives the ID-POS data from the store POS server 4 or the POS cash register 6 via the POS server communication unit 21, and sells the received ID-POS data via the POS server communication unit 21. Transfer to the promotion management server 3.

  FIG. 5 is a diagram illustrating an example of a schematic configuration of the sales promotion management server 3.

  The sales promotion management server 3 includes a server communication unit 31, a server storage unit 32, and a server processing unit 33.

  The server communication unit 31 includes a communication interface circuit for connecting the server 3 to the store network 7 and / or the Internet 8, and performs communication with the store network 7 and / or the Internet 8. The server communication unit 31 supplies the input data received from the product provider side terminal 1A, the retailer side terminal 1B, the headquarter server 2, the store POS server 4, the storefront terminal 5, the POS register 6, and the like to the server processing unit 33. To do. In addition, the server communication unit 31 transmits the web page screen supplied from the server processing unit 33 to the product provider side terminal 1A, the retailer side terminal 1B, the storefront terminal 5, and the like. The server communication unit 31 also transmits immediate discount information to the store POS server 4 or the POS cash register 6. In addition, the server communication unit 31 receives ID-POS data from the headquarter server 2, the store POS server 4, the POS cash register 6, or the like.

  The server storage unit 32 includes, for example, at least one of a magnetic tape device, a magnetic disk device, a semiconductor storage device, and an optical disk device. The server storage unit 32 stores an operating system program, a driver program, an application program, data, and the like used for processing in the server processing unit 33.

  For example, the server storage unit 32 stores, as an application program, a server control program that performs recommendation proposal, negotiation workflow, and the like, and generates data related to the result. The server storage unit 32 includes, as data, a customer information table (FIG. 7A), a product information table (FIG. 7B), a recommendation information table (FIG. 7C), and a promotion information table (FIG. 7D). )), ID-POS data table (FIG. 8 (a)), discount sales performance information table (FIG. 8 (b)), negotiation discount information table (FIG. 8 (c)), result reward data table (FIG. 8 (d)) )) Etc. The server storage unit 32 may not be a table but may be a tag markup language or a key / value data store.

  The server processing unit 33 includes a discount sales performance information creation unit 331, a recommendation plan creation unit 332, a recommendation proposal unit 333, a business negotiation workflow unit 334, a promotion information creation unit 335, a promotion execution unit 336, a sales promotion calculation unit 337, and a result reward calculation. A section 338 and a recommendation result analysis section 339. Each of these units is a functional module realized by a program executed by a processor included in the server processing unit 33. Alternatively, each of these units may be mounted on the server 3 as firmware.

  The discount sales record information creation unit 331 executes Step S100 (see FIG. 9). The recommendation proposing unit 333 executes Step S101 (see FIG. 9).

  The recommendation proposing unit 333 executes step S102 (see FIG. 9) and steps S200 to S207 (see FIG. 10).

  The negotiation workflow unit 334 executes step S103 (see FIG. 9) and steps S300 to 312 (see FIG. 11).

  The promotion information creation unit 335 executes step S104 (see FIG. 9).

  The promotion execution part 336 performs step S105 (refer FIG. 9), step S400-409 (refer FIG. 12), and step S500-502 (refer FIG. 13A).

  The sales promotion calculation part 337 performs step S107 (refer FIG. 9). The achievement reward calculation unit 338 executes Step S108 (see FIG. 9).

  The recommendation result analysis part 339 performs step S600-602 (refer FIG.13 (b)).

  FIG. 6A is a diagram illustrating an example of a schematic configuration of the store POS server 4.

  The store POS server 4 includes a POS server communication unit 41, a POS server storage unit 42, and a POS server processing unit 43.

  The explanation about the POS server communication unit 41, the POS server storage unit 42, and the POS server processing unit 43 of the store POS server 4 is as follows. The main server communication unit 21, the main server storage unit 22, and the main server storage unit 22 of the main server 2 in FIG. This is the same as the headquarter server processing unit 23. The POS server storage unit 42 includes a merchandise sales price table in which merchandise IDs sold in stores are associated with normal sales prices, and an immediate discount information table in which customer IDs, merchandise IDs, discount information, and implementation periods are associated with each other. I also remember.

  The POS server processing unit 43 includes a POS data transfer unit 431 and an immediate discount information setting unit 432.

  The POS data transfer unit 431 receives the ID-POS data from the POS cash register 6 via the POS server communication unit 41, and receives the received ID-POS data via the POS server communication unit 41 for the headquarter server 2 or the sales promotion. Transfer to the management server 3.

  The immediate discount information setting unit 432 receives the immediate discount information from the sales promotion management server 3 via the POS server communication unit 41 and stores the received immediate discount information in the immediate discount information table of the POS server storage unit 42.

  The sales price inquiry unit 433 receives an inquiry including the customer ID and the product ID from the POS cash register via the POS server communication unit 41, and the received inquiry, the immediate discount information table and the product stored in the POS server storage unit 42 With reference to the sales price table, the sales price and the discount rate obtained by immediate discount of the customers and products that are the targets of the promotion within the promotion implementation period are transmitted to the POS register 6 via the POS server communication unit 41.

  FIG. 6B is a diagram illustrating an example of a schematic configuration of the storefront terminal 5.

  The storefront terminal 5 includes a terminal communication unit 51, a terminal storage unit 52, an operation unit 53, a display unit 54, a terminal processing unit 55, a card reading unit 56, and a printing unit 57.

  The explanation regarding the terminal communication unit 51, the terminal storage unit 52, the operation unit 53, the display unit 54, the terminal processing unit 55, and the browsing execution unit 551 of the storefront terminal 5 is shown in FIG. It is the same as the terminal communication unit 11, the terminal storage unit 12, the operation unit 13, the display unit 14, the terminal processing unit 15, and the browsing execution unit 151 of the side terminal 1B.

  The card reading unit 56 reads the customer ID of the customer from the membership card presented by the customer, and transmits the read customer ID to the sales promotion management server 3 via the terminal communication unit 51. The membership card has an IC chip, a magnetic table, and / or a barcode, and the customer ID of the customer is recorded on the IC chip, the magnetic table, and / or the barcode.

  The printing unit 57 prints the promotion period, the product name, and the discount rate received from the sales promotion management server 3 via the terminal communication unit 51 on a sheet of paper such as a receipt.

  FIG. 7A is a diagram illustrating an example of the data structure of the customer information table.

  The customer information table stores a customer ID, an e-mail address, a date of birth, a family structure, a living value, and the like.

  Family structure is a classification of customers into older families, young families (with children), young families (without children), singles, etc., based on the customer's age, gender, marital status and children . The way of classifying customers is not limited to these, and one customer may be classified into a plurality of family members.

  Life values are based on ID-POS data, which is the purchase history of a product. By analyzing the product values of the product purchased by the customer, the customer's preference is changed to health, high quality, saving, liquor lover, safety, etc. It is classified. The method of classifying customers is not limited to these, and one customer may be classified into a plurality of values of life. The life values include the same attributes as the product values in the product information table (FIG. 7B).

  The email address “none” of customer A indicates that the email address of customer A is not stored. The customer information table may further store hobbies and / or preferences in association with customer identification information of customers having hobbies and / or preferences. Of the information stored in the customer information table, information indicating customer attributes such as family composition, lifestyle values, hobbies, and preferences is referred to as customer customer attribute information.

  FIG. 7B is a diagram illustrating an example of the data structure of the product information table.

  The product information table stores a product provider ID, a product ID, a product name, a product category, a normal selling price, a product value, and the like.

  The merchandise value is information indicating a purchase decision value for the product provided by the brand of the merchandise manufacturer (value that becomes a decisive factor when the customer finally selects a product). The method of classifying the products is not limited to these, and one product may be classified into a plurality of product values.

  FIG. 7C is a diagram illustrating an example of the data structure of the recommendation information table.

  The recommendation information table stores the target customer information, the product ID, the discount rate, the implementation period, the target number of sales, the maximum number in the period, and the like.

  The target customer information is an AND condition of one piece of customer attribute information or a plurality of pieces of customer attribute information of a target customer selected from the customer attribute information in the customer information table (FIG. 7A). In other words, the target customer information may include customer attribute information including a plurality of family members and / or an AND condition of living values. Therefore, the number of customers storing customer attribute information corresponding to target customer information in the customer information table may be one.

  The maximum number within the period indicates the maximum number that can be sold by discounting the promotion within the promotion period.

  FIG. 7D shows an example of the data structure of the promotion information table.

  The promotion information table stores a promotion ID, an implementation period, a customer ID, a product ID, a discount rate, a maximum number within a period, an e-mail address, and the like.

  FIG. 8A shows an example of the data structure of the ID-POS data table (FIG. 8A).

  The ID-POS data table stores a chain ID, store ID, sales date / time, customer ID, product ID, sales price, quantity, and the like.

  The ID-POS data table may store the weather attribute information including the temperature, weather, etc. of the sales date and time in association with the product identification information.

  FIG. 8B is a diagram illustrating an example of the data structure of the discount sales performance information table.

  The discount sales record information table stores a promotion ID, sales date, customer ID, product ID, sales price, sales quantity, discount rate, and the like.

  FIG. 8C is a diagram illustrating an example of the data structure of the negotiation discount information table.

  The negotiation discount information table stores the discount rate and the product provider supplement rate for each product and / or product category in association with each other. Beverages indicate green tea and beer product categories, frozen foods indicate pizza product categories, and fresh food items indicate product categories. The fresh food items in the negotiation discount information table of FIG. 8C indicate all products belonging to the product category of fresh food items.

  The merchandise provider supplement rate indicates a ratio of compensating for the discount that the merchandise provider has sold to the retailer through discounts. The merchandise provider supplement rate 100% indicates that the merchandise provider compensates the retailer for all the discounts sold by the discount in the promotion.

  FIG. 8D is a diagram illustrating an example of a data structure of the result reward data table.

  The result reward data table stores the product provider supplement rate, the result reward rate, and the like.

  The performance reward rate is the discount paid by the retailer to the service provider of the sales promotion management service according to the proportion of the discount provided by the retailer in the promotion by the product provider (product provider compensation rate) Indicates the performance reward rate for.

  FIG. 9 is a diagram illustrating an example of an operation flow by the sales promotion management server 3.

  The operation flow described below is mainly based on the programs stored in advance in the terminal storage unit 12, the headquarter server storage unit 22, the POS server storage unit 42, and the server storage unit 32. By the server processing unit 23, the POS server processing unit 43, and the server processing unit 33, the product provider side terminal 1A, the retailer side terminal 1B, the X chain headquarter server 2, the X chain A store POS server 4, and the POS register 6 and the sales promotion management server 3 are executed in cooperation with each element.

  First, the discount sales performance information creation unit 331 creates discount sales performance information (step S100). That is, the discount sales record information creation unit 331 refers to the ID-POS data table (FIG. 8A) and the promotion information table (FIG. 7D) stored in the server storage unit 32, and stores a specific promotion ID. Based on the customer ID and the product ID, the discount rate of the product sold by discount in a specific promotion is specified, and the sales quantity is counted. The discount sales performance information creation unit 331 creates discount sales performance information including a promotion ID, sales date, customer ID, product ID, sales price, sales quantity, and discount rate, and the created discount sales performance information is stored in the server storage unit 32. Is stored in the discount sales record information table (FIG. 8B).

  Although the ID-POS data is acquired with reference to the ID-POS data table, the X chain headquarter server 2, the store POS server 4, and the POS are not transmitted from the ID-POS data table but via the server communication unit 31. You may receive directly from the cash register 6 and earn.

  Next, the recommendation plan creation unit 332 creates a recommendation information plan (step S101). First, the recommendation plan creating unit 332 stores the ID-POS data table (FIG. 8A), the product information table (FIG. 7B), and the customer information table (FIG. 7A) stored in the server storage unit 32. , And based on the merchandise values of the merchandise information table of the merchandise sold to the customer and the ID-POS data table which is the customer's past purchase history, the life values of the customer's customer information table are determined under predetermined conditions. Update. For example, when the same product is purchased a predetermined number of times (for example, three times) continuously in the same product category, the product value of the product may be added to the life values of the customer who purchased the product. . When the customer's lifestyle values reach a predetermined number (for example, five), the customer's lifestyle values added at the front may be deleted.

  Then, the recommendation plan creation unit 332 includes an ID-POS data table (FIG. 8A), a product information table (FIG. 7B), a customer information table (FIG. 7A), and discount sales record information. Referring to the table (FIG. 8B), the recommendation index is calculated based on the customer attribute information of the customer, the purchase history, the merchandise value of the sold product, and the weather attribute of the sales date, and the recommendation index is equal to or greater than the optimum value. A recommendation information plan is recommended for recommending products to customers at a predetermined discount rate.

  For example, the recommendation plan creation unit 332 refers to the ID-POS data table and acquires purchase histories (ID-POS data) of all customers from the present to a predetermined period before (for example, one year). When a customer purchases a product from the acquired purchase histories of all customers, the recommendation plan creating unit 332 adds a recommendation index for the product belonging to the same category as that product of the customer by a predetermined value. Also, the recommendation plan creation unit 332 refers to the ID-POS data table, calculates the average purchase interval for each customer and product, and the customer and / or the average that has passed the average purchase interval of the product from the previous product purchase. For a customer who remains within a predetermined period (for example, within one month) until the purchase interval elapses, the recommendation index for the product of the customer is further increased by a predetermined value. In addition, when the product value of the product matches the life value of the customer who purchased the product, the recommendation plan creating unit 332 further increases the recommendation index for the product of the customer by a predetermined value. Further, when the weather attribute associated with the purchase history of the product matches the current weather after a predetermined period (1 day or 1 week later) or the current weather, the recommendation plan creating unit 332 A predetermined value is added to the recommendation index for the product. The calculation of the recommendation index for such a product is performed on the acquired purchase histories of all customers. Here, the predetermined value to be added may be changed by weighting. Further, the method for calculating the recommendation index is not limited to this.

  Then, when the recommendation index for the product of the customer is equal to or greater than the optimum value, the recommendation plan creating unit 332 determines to recommend the product to the customer. Also, the recommendation plan creation unit 332 refers to the customer information table, and when there are other customers whose customer attribute information is equal to or more than a predetermined number (for example, three), the customer who has decided to recommend, the other customer Also decide to recommend the product. Such a decision to recommend is performed for the recommendation index for all products of all customers. Here, the optimum value may be changed according to the customer attribute of the customer and / or the product values of the product.

  The recommendation plan creation unit 332 refers to the customer information table and extracts customer attribute information of a customer whose recommended product is the same among the customers who have determined the recommendation. The customer attribute information of the extracted customer is classified into one customer attribute information of the target customer or target customer information which is an AND condition of a plurality of customer attribute information using a known clustering technique. There may be one customer who stores the classified target customer information in the customer information table.

  The recommendation plan creation unit 332 refers to the product information table, identifies the product ID and product provider ID of the product determined to be recommended, provides the product name of the identified product ID, and provides the product of the identified product provider ID A proposal of recommendation information including a name, classified target customer information, a predetermined discount rate, and an implementation period is created. The predetermined discount rate may be varied according to the classified target customer information.

  Therefore, the recommendation plan creation unit 332 automatically creates a recommendation information plan, thereby reducing the work load on the retail store side.

  When creating a recommendation information plan, the recommendation plan creation unit 332 creates a customer information table (FIG. 7A), a product information table (FIG. 7B), and a discount sales record information table (FIG. 8). With reference to (b)), a merchandise provider ID, merchandise ID, discount rate, and target with a purchase probability indicating a ratio of the purchased customers among the customers targeted for promotion being a predetermined probability (for example, 10%) or more Customer information and an implementation period may be extracted, and a proposal of recommendation information including the extracted product provider ID, product ID, discount rate, target customer information, and implementation period may be created.

  Further, the recommendation plan creation unit 332 may refer to the recommendation information table (FIG. 7C) and include the past same product ID and the same maximum number in the period in the recommendation information plan. Further, in the discount sales record information table, a sales target number indicating the number of past sales of products with the same product ID may be included in the recommendation information plan.

  Next, the recommendation proposing unit 333 of the sales promotion management server 3 proposes a recommendation (step S102). That is, the recommendation proposing unit 333 executes steps S200 to S207 (see FIG. 10).

  Next, the negotiation workflow unit 334 executes the negotiation workflow (step S103). That is, the negotiation workflow unit 334 executes steps S300 to 312 (see FIG. 11).

  Next, the promotion information creation unit 335 creates promotion information (step S104). That is, the promotion information creation unit 335 refers to the recommendation information table (FIG. 7C) and the customer information table (FIG. 7A) stored in the server storage unit 32, and the target customer information and customer of the recommendation information table The customer ID and email address of the customer whose customer attribute information in the information table matches are extracted, and the number of the extracted customers is counted. Furthermore, the maximum number in the recommendation information table is divided by the number of customers counted, the maximum number in the period per customer is calculated, promotion ID, implementation period, customer ID, product ID, discount rate, period per customer The promotion information including the maximum number and the mail address is created, and the created promotion information is stored in the promotion information table of the server storage unit 32.

  In addition, since the maximum number in the period is an optional item that is set as necessary, if the maximum number in the period is not set, the promotion ID, the implementation period, the customer ID, the product without counting the number of customers Create promotion information including ID, discount rate, and email address.

  Next, the promotion execution part 336 implements a promotion (step S105). That is, the promotion execution part 336 performs step S400-410 (refer FIG. 12) and step S500-502 (refer FIG. 13A).

  Next, the discount sales performance information creation unit 331 creates discount sales performance information as in step S100 (step S106).

  Next, the sales promotion money calculation part 337 calculates a sales promotion money (step S107). That is, the sales promotion calculation unit 337 refers to the product information table, the discount sales performance information table, and the negotiation discount information table stored in the server storage unit 32, and determines the sales promotion for a specific promotion from the product provider to the retailer. It is calculated by the normal sales price x discount rate x sales quantity x merchandise provider supplement rate of discounted products in a specific promotion. The sales promotion calculation unit 337 transmits information for requesting the calculated sales promotion to the product provider side terminal 1A, returns the sales promotion collected from the product provider to the retailer, and stores the information about the returned sales promotion on the retailer. It transmits to the side terminal 1B.

  Therefore, the product provider does not calculate the sales promotion for products sold at the normal sales price, but only calculates the sales promotion for products sold at discounts in the promotion to specific customers. Payment can be optimized. In addition, the retailer can collect the discounted funds from the merchandise provider as a sales promotion, and can prevent the customer targeted for promotion from flowing out to other stores.

  The sales promotion calculation unit 337 may estimate the product provider coverage rate to be 100% when calculating the sales promotion money, and may not multiply the product provider coverage rate. Further, the sales promotion money calculation unit 337 may calculate the sales promotion money by the discount price × sales quantity × the merchandise provider supplement rate in the case of the discount price instead of the discount rate.

  Next, the achievement reward calculation unit 338 calculates the achievement reward (step S108). That is, the result reward calculation unit 338 refers to the discount sales performance information table, the negotiation discount information table, and the result reward data table stored in the server storage unit 32, and the result from the retailer to the sales promotion manager in the specific promotion. The reward is calculated by the actual sales price after discount in the specific promotion × sales quantity × result reward rate. The achievement reward calculation unit 338 transmits information for charging the calculated achievement reward to the retailer-side terminal 1B.

  Note that when calculating the result reward, the result reward calculating unit 338 may calculate not the result reward rate but the result reward amount by the sales quantity of the product for which the result reward is sold by discounting x the result reward amount. . Further, the sales promotion calculation unit 337 may calculate the result reward by the discount price × sales quantity × result reward rate in the case of the discount price instead of the discount rate.

  Further, when the result reward calculation unit 338 calculates the result reward, the result reward may be a predetermined monthly fixed cost instead of the calculation based on the pay-per-use such as the result reward rate and the result reward amount.

  FIG. 10 is a diagram illustrating an example of an operation sequence of the recommendation proposing unit 333 of the sales promotion management server 3. The operation sequence of the recommendation proposing unit 333 will be described below with reference to FIGS.

  The operation sequence described below is based on the programs stored in the terminal storage unit 12 and the server storage unit 32 in advance, mainly by the terminal processing unit 15 and the server processing unit 33, with the product provider side terminal 1A. It is executed in cooperation with each element of the retailer side terminal 1B and the sales promotion management server 3.

  The recommendation proposing unit 333 transmits the recommendation information draft created in step S101 to the retailer side terminal 1B (step S200).

  The retailer-side terminal 1 </ b> B receives the recommendation information proposal from the sales promotion management server 3. The browsing execution unit 151 of the retailer-side terminal 1B outputs a recommendation proposal screen including a proposal of the received recommendation information to the display unit 14.

  FIG. 14A is a diagram illustrating an example of a recommendation proposal screen output to the display unit 14 by the browsing execution unit 151 of the retailer-side terminal 1B.

  The recommendation proposal screen includes recommendation information ID (P001), product provider name, target customer information, target, product name, discount rate, sales target number, maximum number in period, implementation period, proposal button 701, and correction button 702. including. The target is the number of customers that store customer attribute information corresponding to the target customer information in the customer information table stored in the server storage unit 32.

  Recommendations for target customer information (customer attribute information including multiple family members and / or lifestyle values and conditions) that have fewer targets, such as a single target, can be tailored to individual customer needs. It can be said that this is a recommended product recommendation, so the frequency of visits by customers can be expected to increase.

  When the retailer selects the product provider name field on the recommendation proposal screen, the browsing execution unit 151 of the retailer side terminal 1B sorts and outputs the rows of the recommendation proposal screen for each product provider. Further, when the product name field on the recommendation proposal screen is selected by the retailer, the browsing execution unit 151 of the retailer side terminal 1B sorts the rows on the recommendation proposal screen in units of a plurality of product providers for each product. Output.

  When the retailer selects a plurality of product provider name fields (“C company, D company”) for the same product (“Tomato”) on the recommendation proposal screen, the browsing execution unit 151 of the retailer side terminal 1B The recommendation proposal screen (FIG. 15A) showing the breakdown of each of the selected plurality of product providers is output. The sales target number and the maximum number in the period are divided by the number of product providers. The division ratio is not uniform, and may be varied depending on the product provider.

  Since the maximum number in the period is an optional item, if the maximum number in the period is not set, the maximum number in the period may be omitted.

  When the proposal button 701 is pressed by the merchandise provider, the browsing execution unit 151 of the retailer side terminal 1B determines that the proposal is accepted (step S201), and sales promotion management is performed on the proposal availability information including the proposal possibility. It transmits to the server 3 (step S202). On the other hand, when the correction button 702 is pressed by the merchandise provider, the browsing execution unit 151 of the retailer side terminal 1B determines that “proposal impossibility” has been input (step S201), and the proposal propriety information including the proposal impossibility is It transmits to the promotion management server 3 (step S202).

  The recommendation proposing unit 333 receives proposal propriety information from the retailer side terminal 1B. The recommendation proposing unit 333 determines whether or not the received proposal propriety information includes proposal possibility (step S203). When the proposal propriety information includes proposal possibility (Yes in step S203), the recommendation proposing unit 333 transmits the recommendation information proposal as it is to the product provider side terminal 1A as recommendation information. On the other hand, when the proposal propriety information includes the proposal impossibility (No in step S203), the recommendation proposing unit 333 transmits information for prompting the correction of the recommendation information to the retailer side terminal 1B (step S205).

  The browsing execution unit 151 of the retailer-side terminal 1 </ b> B receives information urging the correction of the recommendation information plan from the sales promotion management server 3. The browsing execution unit 151 of the retailer-side terminal 1B outputs a recommendation correction screen including information for prompting correction of the received recommendation information plan to the display unit 14.

  FIG. 14B is a diagram illustrating an example of a recommendation correction screen output to the display unit 14 by the browsing execution unit 151 of the retailer-side terminal 1B.

  The recommendation correction screen includes recommendation information ID (P001), product provider name, target customer information, target, product name, discount rate, sales target number, maximum number in period, implementation period, correction proposal button 801, row deletion button 802 and a line addition button 803.

  When the retailer selects the item provider name field on the recommendation correction screen, the browsing execution unit 151 of the retailer side terminal 1B sorts and outputs the rows on the recommendation proposal screen for each product provider. In addition, when the retailer selects the product name field on the recommendation proposal screen, the browsing execution unit 151 of the retailer side terminal 1B sorts the rows on the recommendation correction screen in units of a plurality of product providers for each product. Output.

  When the retailer selects a plurality of product provider name fields (“Company C, Company D”) for the same product (“Tomato”) on the recommendation correction screen, the browsing execution unit 151 of the retailer side terminal 1B Then, a recommendation correction screen (FIG. 15B) showing the breakdown of each of the selected plurality of product providers is output. The sales target number and the maximum number in the period are divided by the number of product providers. The division ratio is not uniform, and may be varied depending on the product provider.

  Since the maximum number in the period is an optional item, if the maximum number in the period is not set, the maximum number in the period may be omitted.

  On the recommendation correction screen, the retailer can correct and input the product provider name, target customer information, product name, discount rate, sales target number, maximum number in period, and implementation period (step S206).

  For example, when the target customer information is corrected and input, the browsing execution unit 151 of the retailer side terminal 1B stores the customer attribute information corresponding to the target customer information input after correction in the server storage unit 32. Modify the target value according to the number of customers stored in the table. Further, when the line delete button 802 is pressed by the retailer, the corresponding line is deleted. Further, when the line addition button 803 is pressed by the retailer, a new line is added.

  When the correction proposal button 801 is pressed after correcting the recommendation information, the browsing execution unit 151 of the retailer-side terminal 1B transmits the corrected recommendation information to the sales promotion management server 3 (step S207).

  Therefore, since the recommendation plan creation unit 332 of the sales promotion management server 3 creates the recommendation, the retailer sends the recommendation information to the product provider with less effort than the retailer himself creates the recommendation information plan from scratch. Can be created.

  FIG. 11 is a diagram showing an example of an operation sequence of the negotiation workflow unit 334 of the sales promotion management server 3. The operation sequence of the negotiation workflow unit 334 will be described below with reference to FIGS.

  The operation sequence described below is based on the programs stored in the terminal storage unit 12 and the server storage unit 32 in advance, mainly by the terminal processing unit 15 and the server processing unit 33, with the product provider side terminal 1A. It is executed in cooperation with each element of the retailer side terminal 1B and the sales promotion management server 3.

  First, the browsing execution unit 151 of the product provider-side terminal 1 </ b> A receives a recommendation (recommendation information or corrected recommendation information) proposed from the sales promotion management server 3. The browsing execution unit 151 outputs a recommendation approval screen including the received recommendation information to the display unit 14.

  FIG. 16A is a diagram illustrating an example of a recommendation approval screen output to the display unit 14 by the browsing execution unit 151 of the product provider side terminal 1A.

  The recommendation approval screen includes recommendation information ID (P001), product provider name, target customer information, target, product name, discount rate, sales target number, maximum number in period, implementation period, approval button 901, and correction button 902. including.

  When the approval button 901 is pressed by the product provider, the browsing execution unit 151 of the product provider side terminal 1A determines that approval is accepted (step S300), and approves approval / disapproval information including approval approval. It transmits to the management server 3 (step S301). On the other hand, when the correction button 902 is pressed by the merchandise provider, the browsing execution unit 151 of the retailer terminal 1B determines that the approval disapproval has been input (step S300), and sells approval approval / disapproval information including approval disapproval. It transmits to the promotion management server 3 (step S301).

  The negotiation workflow unit 334 receives approval approval / disapproval information from the retailer side terminal 1B. The negotiation workflow unit 334 determines whether the received approval approval / disapproval information includes approval approval (step S302). If the approval / disapproval information includes approval approval (Yes in step S302), the negotiation workflow unit 334 stores the approved recommendation information in the recommendation information table stored in the server storage unit 32 (step S303). On the other hand, when the approval approval / disapproval information includes an approval disapproval (No in step S302), the negotiation workflow unit 334 transmits information prompting correction of the recommendation information to the product provider side terminal 1A (step S304).

  The browsing execution unit 151 of the product provider side terminal 1 </ b> A receives information urging correction of recommendation information from the sales promotion management server 3. The browsing execution unit 151 of the product provider side terminal 1A outputs a recommendation correction screen including information for prompting correction of the received recommendation information to the display unit 14.

  FIG. 16B is a diagram illustrating an example of a recommendation correction screen output to the display unit 14 by the browsing execution unit 151 of the product provider terminal 1A.

  The recommendation correction screen includes recommendation information ID (P001), product provider name, target customer information, target, product name, discount rate, sales target number, maximum number in period, implementation period, correction proposal button 1001, row deletion button. 1002 and a line addition button 1003. The merchandise provider can modify and input the target customer information, the merchandise name, the discount rate, the sales target number, the maximum number in the period, and the implementation period on the recommendation correction screen (step S305).

  For example, when the target customer information is corrected and input, the browsing execution unit 151 of the product provider side terminal 1A stores the customer attribute information corresponding to the target customer information input after correction in the server storage unit 32. The target value is corrected according to the number of customers stored in the information table. Further, when the line deletion button 802 is pressed by the product provider, the corresponding line is deleted. Furthermore, when the line addition button 1003 is pressed by the product provider, a new line is added.

  When the correction proposal button 1001 is pressed after correcting the recommendation information, the browsing execution unit 151 of the product provider side terminal 1A sends the corrected recommendation information to the retailer side terminal 1B via the sales promotion management server 3. Transmit (step S306).

  The browsing execution unit 151 of the retailer side terminal 1 </ b> B receives the recommended recommendation information corrected from the sales promotion management server 3. The browsing execution unit 151 outputs the received recommendation information to the display unit 14. The browsing execution unit 151 of the retailer-side terminal 1B replaces the product provider-side terminal 1A and the retailer-side terminal 1B in the same manner as steps S300 to S306 (see FIGS. 16A and 16B). S303, 307-312 are executed.

  The browsing execution unit 151 of the retailer-side terminal 1B executes step S300 again after executing step S312. The negotiation workflow unit 334 repeatedly executes steps S300 to 312 until the approval information including approval is received from the product provider side terminal 1A or the retailer side terminal 1B and the negotiation workflow unit 334 executes step S303.

  Therefore, since the recommendation information stored in the recommendation information table is always approved by both the product provider and the retailer, the retailer will receive all or part of the funds used for the discount sale from the product provider. It can be expected to be collected as a promotional money. Also, the retailer and the product provider can jointly create recommendation information.

  FIG. 12 is a diagram illustrating an example of an operation sequence of the promotion execution unit 336 of the sales promotion management server 3. The operation sequence of the promotion execution unit 336 will be described below with reference to the customers B and C in FIG. 2B, the customers A, B, and C in FIG. 2C, and FIG.

  The operation sequence described below is mainly based on programs stored in advance in the terminal storage unit 12, the headquarter server storage unit 22, the POS server storage unit 42, and the server storage unit 32, and the terminal processing unit 15, headquarters. By the server processing unit 23, the POS server processing unit 43, and the server processing unit 33, the product provider side terminal 1A, the retailer side terminal 1B, the X chain headquarter server 2, the X chain A store POS server 4, and the POS register 6 and the sales promotion management server 3 are executed in cooperation with each element.

  First, the promotion execution unit 336 refers to the promotion information table and the product information table in the server storage unit 32, and transmits the promotion implementation period, the product name, and the discount rate by e-mail to the e-mail address of the customer side terminal (step S400). ). Therefore, the customer can confirm the discount information of his / her promotion by receiving the e-mail transmitted from his / her customer terminal and outputting it to the display unit of the customer terminal (customer B in FIG. 2B). , C).

  Next, the promotion execution unit 336 refers to the promotion information table stored in the server storage unit 32, and obtains immediate discount information including the customer ID, the product ID, the discount information, the implementation period, and the maximum number per customer per period. The specified immediate discount information is specified and transmitted to all the store POS servers 4 in the X chain (step S401).

  The immediate discount information setting unit 432 of the store POS server 4 receives the immediate discount information from the sales promotion management server 3, and stores the received immediate discount information in the immediate discount information table stored in the POS server storage unit 42 (step S402). ). By executing step S402, the store is ready for the promotion discount.

  In the X chain and A store, when the customer presents the membership card and the product to the POS register (see customers A, B, and C in FIG. 2C), the POS register 6 is attached to the customer ID and the product of the membership card. Read the product ID on the barcode. The POS cash register 6 transmits the read customer ID and product ID to the store POS server 4 (step S403).

  The sales price inquiry unit 433 of the store POS server 4 receives the customer ID and the product ID from the POS register 6. The sales price inquiry unit 433 of the store POS server 4 refers to the product sales price table and the immediate discount information table stored in the POS server storage unit 42, and the current date and time is within the implementation period based on the received customer ID and product ID. It is determined whether or not the customer that is the promotion target is the product that is the target of the promotion. In addition, if the customer and product are subject to implementation and are within the maximum number of customers per customer within the period, the discounted sales price (normal sales price multiplied by the discount rate) and the discount rate An inquiry is made (step S404). Note that the sales price inquiry unit 433 of the store POS server 4 reduces the maximum number per customer in the period according to the number of products sold by discounting, and the POS server 4 of all stores via the sales promotion management server 3. Share on

  On the other hand, when the sales price inquiry unit 433 of the store POS server 4 refers to the product sales price table and the immediate discount information table stored in the POS server storage unit 42 and is a customer or a product that is not a promotion target, Alternatively, when the maximum number per customer per period is exceeded, the normal sales price in the product sales price table is inquired as the sales price (step S404).

  Note that the maximum number in the period is an optional item, so if the maximum number in the period is not set, the maximum number in the period is decreased, and if the maximum number in the period is exceeded, the normal sales in the product sales price table Processing for inquiring the price as the selling price may be omitted.

  The sales price inquiry unit 433 transmits the inquired sales price, the discount rate, and the like to the POS register 6 (step S405). The POS register 6 receives the sales price (and the discount rate in the case of promotion implementation) from the store POS server 4. The POS register 6 performs an accounting process with the received sales price, and in the accounting process, if the promotion is to be executed, the discount rate is output to the display unit (see customers A, B, and C in FIG. 2C). . The POS register 6 stores ID-POS data including the store ID, sales date, customer ID, product ID, sales price, and quantity of the sold product in a POS register storage unit (not shown). The ID-POS data stored in the POS cash register storage unit includes ID-POS data of products sold at a discount and ID-POS data of products not sold at a discount.

  Steps S403 to 405 are repeated during the promotion period. During the promotion period, new discounts for the same products will not be given to the same customers. This is because it is impossible to determine whether the discount sales performance information is a result of promotion or a result of a new discount. When a new discount for a product is desired, the current promotion is temporarily ended, and a new discount for the product is performed in the new promotion information. In addition, although step S403-405 inquired about the sales price of one goods, you may inquire several price simultaneously.

  The POS cash register 6 transmits the ID-POS data stored in the POS cash register storage unit to the store POS server 4 on a daily, monthly, or real time basis (step S406).

  The POS data transfer unit 431 of the store POS server 4 receives the ID-POS data from all the POS registers 6 in the store, and transmits the received ID-POS data to the headquarter server 2 (step S407).

  The POS data transfer unit 231 of the headquarter server 2 receives the ID-POS data from all store POS servers 4 in the X chain, adds the chain ID “X” to the received ID-POS data, and sends it to the sales promotion management server 3. Transmit (step S408). The discount sales result information creation unit 331 of the sales promotion management server 3 receives the ID-POS data from the X chain headquarter server 2, and uses the received ID-POS data as weather attribute information including the temperature, weather, etc. of the sales date and time. And stored in the ID-POS data table stored in the server storage unit 32 (step S409). Note that the process of adding the chain ID “X” to the ID-POS data may be performed by the discount sales performance information creation unit 331 of the sales promotion management server 3 in place of the POS data transfer unit 231 of the headquarter server 2.

  By collecting the ID-POS data for the sale of products at each store by executing the operation sequence of the promotion execution unit 336 in FIG. 12, the retailer side system such as an existing chain or store POS cash register is changed. The range is small.

  FIG. 13A is a diagram illustrating an example of an operation sequence of the promotion execution unit 336. The operation sequence of the promotion execution unit 336 will be described below with reference to the customer A in FIG. 2B and FIG. 13A.

  The operation sequence described below is based on the programs stored in the terminal storage unit 52 and the server storage unit 32 in advance, mainly by the terminal processing unit 55 and the server processing unit 33, and the storefront terminal 5 and the sales promotion management. It is executed in cooperation with each element of the server 3.

  When the customer presents the membership card, the card reading unit 56 of the storefront terminal 5 reads the customer ID of the customer's membership card (see customer A in FIG. 2B). The card reading unit 56 transmits the read customer ID to the sales promotion management server 3 (step S500).

  The promotion execution unit 336 of the sales promotion management server 3 receives the customer ID from the storefront terminal 5. The promotion execution unit 336 refers to the promotion information table stored in the server storage unit 32, acquires the promotion execution period, product name, and discount rate of the received customer ID (step S501), and acquires the acquired promotion execution period, product The name and the discount rate are transmitted to the storefront terminal 5 (step S502).

  The storefront terminal 5 receives the promotion implementation period, the product name, and the discount rate from the sales promotion management server 3. The received promotion implementation period, product name, and discount rate are output to the display unit 54 (see FIG. 2B, customer A). Further, the storefront terminal 5 may output the received promotion implementation period, product name, and discount rate to the printing unit 57 and print it on a sheet of paper such as a receipt. Therefore, even customers who do not have their own e-mail addresses can check discount information of their own promotions on paper such as receipts printed by the display unit 54 and / or the printing unit 57 of the storefront terminal 5. In addition, the retailer can create a new purchase opportunity because the customer presents the membership card to the storefront terminal installed in the store.

  FIG. 13B is a diagram illustrating an example of an operation sequence of the recommendation result analysis unit 339. The operation sequence of the recommendation result analysis unit 339 will be described below with reference to FIGS. 13B and 17.

  Note that the operation sequence described below is based on a program stored in the terminal storage unit 12 and the server storage unit 32 in advance, mainly by the terminal processing unit 15 and the server processing unit 33, on the product provider side terminal 1A or It is executed in cooperation with each element of the retailer side terminal 1B and the sales promotion management server 3.

  The browsing execution unit 151 of the retailer side terminal 1B or the product provider side terminal 1A outputs a recommendation result search screen to the display unit 14. The retailer or the merchandise provider inputs search conditions for promotion information to be analyzed in the past on the retailer terminal 1B or the merchandise provider terminal 1A.

  FIG. 17A shows an example of a recommendation result search screen of the retailer side terminal 1B.

  For example, “Green tea pizza tomato beer” is entered as the search keyword for the search item “product name” and the search method is “AND”, so the four keywords “green tea”, “pizza”, “tomato” And the AND condition of “beer” is input as a search condition. As the search method, a retailer or a merchandise provider selects a search method in which one of “AND” and “OR” is a pull-down. Further, when a search keyword is input for a plurality of search items, the search keywords are input under AND conditions of the plurality of search items.

  The search items include “product name”, “product ID”, “discount rate”, “target customer information”, “implementation period”, and “promotion information”, but are not limited thereto. For example, by using “store ID” and “chain ID” as search items, the factors of discount sales performance can be analyzed in detail for each chain or store.

  When the search button 1101 is pressed, the browsing execution unit 151 of the retailer side terminal 1B or the product provider side terminal 1A transmits the input search condition to the sales promotion management server 3 (step S600).

  The recommendation result analysis unit 339 of the sales promotion management server 3 receives the search condition from the retailer side terminal 1B or the product provider side terminal 1A. The recommendation result analysis unit 339 refers to the discount sales record information table and the promotion information table stored in the server storage unit 32, and at least one of the received search conditions is a target of the same promotion. The purchase probability indicating the percentage of customers who purchased the product is calculated, and the promotion implementation period, product name, discount rate, and sales quantity are acquired (step S601).

  When searching from the product provider side terminal 1 </ b> A, the recommendation result analysis unit 339 of the sales promotion management server 3 refers to the product information table stored in the server storage unit 32, and information on the product provided by the product provider itself. Is only searchable.

  The recommendation result analysis unit 339 of the sales promotion management server 3 uses the acquired promotion implementation period, product name, sales quantity, discount rate, and calculated purchase probability as the retailer side terminal 1B or the product provider side terminal 1A. (Step S602).

  The browsing execution unit 151 of the retailer side terminal 1B or the product provider side terminal 1A receives the promotion implementation period, the product name, the discount rate, the sales quantity, and the purchase probability from the sales promotion management server 3, and the received promotion A recommendation result list screen including the implementation period, product name, discount rate, sales quantity, and purchase probability is output to the display unit 14.

  FIG. 17B shows an example of a recommendation result list screen of the retailer side terminal 1B.

  The recommendation result analysis unit 339 of the sales promotion management server 3 refers to the product information table stored in the server storage unit 32, further acquires the product provider ID, and sets the product provider name of the acquired product provider ID. The product provider name may be added to the recommendation result list screen by further transmitting to the retailer side terminal 1B or the product provider side terminal 1A.

  Therefore, the retailer or product provider can check the purchase probability and sales volume indicating the proportion of customers who have been purchased for the same promotion in the past, which can be used as a reference when determining recommendation conditions. .

  The purchase probability is the percentage of customers who have been promoted as a percentage and the ratio of customers (50% (5/10)). The ratio of purchased products may be expressed as a percentage and the number ratio of products (50% (5/10 pieces)).

  Also, the output items are not limited to “product name”, “discount rate”, “sales quantity”, and “purchase probability”. For example, by using “store ID” and “chain ID” as output items, it is possible to analyze in detail the factors of discount sales performance for each chain or each store.

  In the present embodiment, the “discount rate”, “product provider compensation rate”, and “result reward rate” have been described using discount information, product provider compensation information, and result reward information, respectively. “Rate” may be “discount price”, “product provider supplement rate” may be “product provider supplement price”, and “result reward rate” may be “result reward amount”.

  Further, the promotion information creation unit 335 refers to the recommendation information and customer information stored in the server storage unit 32, and extracts and extracts the customer e-mail address where the target customer information of the recommendation information matches the customer attribute information of the customer information. Although the case where promotion information including an email address is created has been described, promotion information may be created using an average purchase interval. That is, the promotion information creation unit 335 refers to the ID-POS data table, calculates an average purchase interval for each customer and product, and the customer and / or average purchase that has passed the average purchase interval of the product from the previous product purchase. Promotion information may be created for customers who remain within a predetermined period (for example, within one month) until the interval elapses.

  In the present embodiment, the case has been described where the maximum number in the period is set in the option item. However, when the maximum number in the period is not set in the option item, the recommendation information table (FIG. 7C) and The maximum number in the period of the promotion information table (FIG. 7D) may be omitted.

  In FIG. 12, the case where the POS register 6 inquires the store POS server 4 about the sales price of the product has been described. However, the function of the store POS server 4 is integrated into the POS register 6, and the store POS server 4 is It may be omitted. That is, the information stored in the POS server storage unit 42 is stored in the POS register storage unit, and the POS register 6 directly receives the immediate discount information from the sales promotion management server 3 or the headquarter server 2, and the received immediate discount is directly received. The information is reflected in the immediate discount information table stored in the POS register storage unit, the sales price and the discount rate are inquired by referring to the product sales price table and the immediate discount information table stored in the POS register storage unit, and the ID -You may transmit POS data directly to the sales promotion management server 3 or the headquarter server 2. FIG.

  In FIG. 12, the case where the POS cash register 6 inquires of the store POS server 4 about the sale price of the product has been described. However, the function of the store POS server 4 is integrated into the sales promotion management server 3, and the store POS server 6 4 may be omitted. That is, the information stored in the POS server storage unit 42 is stored in the server storage unit 32, and the POS cash register 6 stores the sale price and discount rate in the product storage price table and the immediate discount information stored in the server storage unit 32. The inquiry may be made by directly referring to the table, and the ID-POS data may be directly transmitted to the sales promotion management server 3 or the headquarter server 2.

  A computer program for causing a computer to realize the functions of the terminal processing units 15 and 55, the headquarter server processing unit 23, the POS server processing unit 43, and the server processing unit 33 includes a magnetic recording medium, a semiconductor recording medium, and an optical recording medium. Provided in a form recorded on a computer-readable recording medium, such as a medium, using a known setup program or the like from the recording medium, terminal storage units 12, 52, headquarter server storage unit 22, POS server storage unit 42, and It may also be installed in the server storage unit 32.

  All examples and specific terms listed herein are intended for instructional purposes to help the reader understand the concepts contributed by the inventor to the present invention and the promotion of the technology. is there. Also, all examples and specific terms listed herein are intended to represent any example configuration herein, such specific examples and conditions, with respect to indicating the superiority and inferiority of the present invention. It should be construed as not limiting. Although embodiments of the present invention have been described in detail, it should be understood that various changes, substitutions and modifications can be made thereto without departing from the spirit and scope of the present invention.

1A Product provider side terminal 1B Retailer side terminal 11, 51 Terminal communication unit 12, 52 Terminal storage unit 13, 53 Operation unit 14, 54 Display unit 15, 55 Terminal processing unit 151, 551 Browsing execution unit 2 Headquarter server 21 Headquarters Server communication unit 22 Headquarter server storage unit 23 Headquarter server processing unit 231 431 POS data transfer unit 3 Server 31 Server communication unit 32 Server storage unit 33 Server processing unit 331 Discount sales performance information creation unit 332 Recommendation proposal creation unit 333 Recommendation proposal unit 334 Business negotiation workflow part 335 Promotion information creation part 336 Promotion execution part 337 Sales promotion calculation part 338 Result reward calculation part 339 Recommendation result analysis part 4 Store POS server 41 POS server communication part 42 POS server storage part 43 POS server processing part 432 Immediately Discount information setting section 433 Sales price inquiry section 5 Store terminal 56 Card reading section 57 Printing section 6 POS cash register 7 Store network 8 Internet

Claims (10)

A server in a sales promotion management system comprising a server communicable with a retailer side system,
The server
A storage unit that stores promotion information including customer identification information, product identification information, and discount information; and discount sales performance information including the customer identification information, the product identification information, the sales price, the discount information, and the sales quantity; ,
POS data including at least the customer identification information, the product identification information, and the sales price is acquired from the retailer-side system, and based on the acquired POS data and the promotion information stored in the storage unit. The discount sales result information is created by identifying the discount information of the products sold by discount in a specific promotion and counting the sales quantity, and the discount stored in the storage section is the created discount sales result information. Discount sales performance information creation section to be stored in sales performance information,
With reference to the discount sales performance information stored in the storage unit, the sales promotion money for the specific promotion from the product provider to the retailer, the normal sales price, the discount information and the sales of the discounted product in the specific promotion A server comprising: a sales promotion calculation unit that calculates based on the quantity. The server
The promotion information stored in the storage unit further includes an implementation period,
The retailer-side system includes a storefront terminal that reads the customer identification information of the customer's membership card and transmits the read customer identification information to the server,
The server receives the customer identification information from the storefront terminal, and based on the received customer identification information and the promotion information stored in the storage unit, a promotion implementation period corresponding to the customer, a product The server according to claim 1, further comprising a promotion execution unit that transmits name and discount information to the storefront terminal. The storage unit further includes discount information for each product provider and negotiation discount information including product provider supplement information for each product and / or product category, and result reward data including product provider supplement information and result reward information. Remember,
The server refers to the discount sales performance information, the negotiation discount information, and the result reward data stored in the storage unit, and determines the result reward from the retailer to the sales promotion manager in the specific promotion. The server according to claim 1, further comprising: a result reward calculation unit that calculates based on the after-discount actual sales price, the sales quantity, and the result reward information in the promotion. The storage unit further stores customer information including the customer identification information and customer attribute information, and recommendation information including the product identification information, the discount information, and target customer information,
The server can communicate with a retailer side terminal and a product provider side terminal,
The server
Referencing the acquired POS data and the customer information stored in the storage unit, creating a proposal of recommendation information including the product identification information, the discount information, and the target customer information, and the created recommendation A recommendation drafting section for sending a draft of information to the retailer side terminal;
The recommendation information including the product identification information, the discount information, and the target customer information is received from the retailer side terminal, the received recommendation information is transmitted to the product provider side terminal, and the transmitted recommendation is received. A recommendation proposing unit that receives approval approval / disapproval information indicating approval / disapproval of information from the product provider side terminal;
The server according to claim 1, further comprising: a negotiation workflow unit that stores approved recommendation information in the recommendation information stored in the storage unit when the received approval approval / disapproval information indicates approval. The customer information further includes an email address;
The server
Promotion information including the extracted e-mail address, referring to the recommendation information and the customer information stored in the storage unit, extracting a customer e-mail address that matches the customer attribute information of the target customer information and the customer information The server according to claim 4, further comprising a promotion information creation unit for creating   The recommendation plan creation unit updates the life values of the customer information stored in the storage unit based on the acquired POS data, and the plan of the recommendation information based on the updated life values 6. The server according to claim 5, wherein the server is created. The server
The search condition including at least one of the product identification information, the discount information, and the target customer information is received from the retailer side terminal or the product provider side terminal, and stored in the storage unit With reference to the discounted sales performance information and the promotion information, the purchase probability indicating the ratio of the purchased customers among the customers for which at least one of the received search conditions is the target of the same promotion is calculated. The server according to any one of claims 4 to 6, further comprising a recommendation result analysis unit that transmits the calculated purchase probability to the retailer side terminal or the product provider side terminal. The negotiation workflow part
If the received approval approval / disapproval information indicates that approval is not possible, the product provider side terminal is sent information for prompting correction,
Receiving the recommended identification information including the product identification information, the discount information, and the target customer information from the product provider side terminal;
Sending the received modified recommendation information to the retailer side terminal;
Receiving approval approval / disapproval information indicating approval / disapproval of the transmitted corrected recommendation information from the retailer side terminal;
The server according to any one of claims 4 to 7, wherein, when the received approval approval / disapproval information indicates approval approval, the approved correction recommendation information is stored in the recommendation information stored in the storage unit. A server in a sales promotion management system including a server communicable with a retailer-side system, including promotion information including customer identification information, product identification information, and discount information, the customer identification information, the product identification information, and a sales price , A control method for a server comprising a storage unit for storing the discount information and discount sales performance information including a sales quantity,
The server is
POS data including at least the customer identification information, the product identification information, and the sales price is acquired from the retailer-side system, and based on the acquired POS data and the promotion information stored in the storage unit. The discount sales result information is created by identifying the discount information of the products sold by discount in a specific promotion and counting the sales quantity, and the discount stored in the storage section is the created discount sales result information. Store in sales performance information,
With reference to the discount sales performance information stored in the storage unit, the sales promotion money for the specific promotion from the product provider to the retailer, the normal sales price, the discount information and the sales of the discounted product in the specific promotion A control method for a server, wherein calculation based on a quantity is executed. A server in a sales promotion management system including a server communicable with a retailer-side system, including promotion information including customer identification information, product identification information, and discount information, the customer identification information, the product identification information, and a sales price , A control program for a server comprising a storage unit that stores the discount information and discount sales performance information including a sales quantity,
To the server,
POS data including at least the customer identification information, the product identification information, and the sales price is acquired from the retailer-side system, and based on the acquired POS data and the promotion information stored in the storage unit. The discount sales result information is created by identifying the discount information of the products sold by discount in a specific promotion and counting the sales quantity, and the discount stored in the storage section is the created discount sales result information. Store in sales performance information,
With reference to the discount sales performance information stored in the storage unit, the sales promotion money for the specific promotion from the product provider to the retailer, the normal sales price, the discount information and the sales of the discounted product in the specific promotion A control program for a server, which executes calculation based on a quantity.

Images