JP2010117954A - Point management method and point management system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a coupon service for charging a fee on the basis of use in a shared point service in which a plurality of stores and companies participate. <P>SOLUTION: A point management server 1 stores a point ticket and a coupon in association with each other to a storage part 19 in issuing the point ticket with a coupon. By receiving use history information for the point ticket from a store system 2, the use history of the coupon associated with the point ticket is measured to charge a fee in accordance with the use of the coupon. <P>COPYRIGHT: (C)2010,JPO&INPIT

Description

  The present invention manages a system that manages the value that can be used as consideration for goods and services, such as cash vouchers, electronic money, and corporate points, and media for the purpose of sending advertisements and coupons to other companies and other stores. Related to the system.

  In recent years, there are increasing efforts to issue points that can be used in common between different companies and stores. For example, a local shopping street issues a common point for the purpose of activating consumption within the region. Here, the point is a monetary value in which the relationship with the currency is defined in the form of 1 point = 1 yen, for example, and can be used for payment in the same manner as money at a store that employs the point. . For customers, this service offers great benefits such as the ability to use points obtained at one store for discounts at other stores.

  However, if you only introduce common points, customers are likely to go to the same store, buy as much as before, and get discounts based on points, which does not lead to additional consumption. . One way to increase consumption within the region is to send customers of one company / store to another company / store using coupons that offer free products or discounts. It is important not only to introduce common points but also to send customers with coupons in order to activate consumption within the region.

  The customer sending using the coupon means, for example, that the store A distributes a coupon that can be used in the store B, thereby encouraging the customer who has visited the store A to go to the store B. If store A is defined as a customer store and store B is defined as a customer store, the customer store earns revenue by receiving a customer fee from the customer store, and the customer store increases sales due to customers. It is a business model that can be expected.

  Here, it is reasonable for the customer store to pay the customer fee based on the number of coupons distributed by the customer store, not the number of coupons distributed. The premise is that customer performance is accurately measured. However, in the case of a system in which the recipient store measures the performance, such as when a paper coupon is used, an incentive for underreporting occurs at the recipient store, which causes a problem in reliability. For example, even if 100 people bring a coupon and visit a recipient store, if they declare that there are only 50 recipient stores, the customer's handling fee for 50 people will be reduced.

  For such a problem, a technique disclosed in Patent Document 1 is proposed. In Patent Literature 1, coupon information having an identifier including the item information of the item selected by the customer and the customer information is transmitted to the customer's terminal, and the coupon identifier obtained from the transmitted coupon information is read and read. A technique regarding a coupon issuing method for giving points to a customer based on a given identifier is disclosed.

JP 2007-213281 A

  However, in patent document 1, the utilization of the coupon containing customer information is a premise, and the utilization of the coupon which does not contain customer information is not considered. In addition, only third parties such as advertising agencies entrusted with coupon issuance services by business operators are assumed as coupon issuers, and point service member stores independently issue coupons for each other's stores. It is not considered to do.

  For example, when a coupon that does not include customer information is used, points cannot be given to the customer, so it is necessary to give an incentive other than the point grant to the coupon usage status applicant. Also, even when the point service member stores independently issue points and coupons for each store, the point and coupon usage records are accurately grasped, and settlement processing between the stores is performed according to the usage records. It is demanded.

  Therefore, in the present invention, when a point service that can be commonly used in a plurality of stores is introduced, a point ticket to which a coupon provided (issued) at a certain store (coupon issuing store) is assigned to another store (point) When a coupon is issued at a coupon issue store and this point ticket is actually used at a coupon issue store (sent by a coupon), a mechanism is provided to pay a commission from the coupon issue store to the point ticket issue store. To do. In this case, since the point ticket issued at the point ticket issuing store is used at the coupon issuing store, the point ticket points from the point ticket issuing store to the coupon issuing store (point ticket using store) Pay for a few minutes. For this reason, as a result, the consideration which deducted the fee part from the point ticket issuing store to the coupon issuing store is paid.

More specifically, in a point management system that is connected to store terminals of a plurality of stores and manages points that can be commonly used among the plurality of stores,
Point ID item for storing a point ID for identifying a point ticket issued at any of the plurality of stores, and a point issuing store for storing a point ticket issuing store ID for identifying a store from which the point ticket is issued Point information in which an ID item, a point number item in which the number of points assigned to the point ticket is stored, and a coupon ID item in which a coupon ID for identifying a coupon assigned to the point ticket is stored are associated with each other A coupon issue item that stores a coupon, a coupon ID that identifies a coupon issued at any of the plurality of stores, and a coupon issue store item that stores a coupon issue store ID that identifies the store that issued the coupon And the fee paid to the store issuing the point ticket to which the coupon was granted A storage device for storing the coupon information table and handling items associated,
A point ticket use store ID for identifying a store where the point ticket is used, and a point ID for identifying the point ticket are received,
Extracting the point issuing store ID stored in the point issuing store ID item associated with the point ID item of the point information table in which the received point ID is stored;
When no coupon ID is stored in the coupon ID item associated with the point ID item in the point information table in which the received point ID is stored, the combination of the point ticket use store ID and the point ticket issue store ID For each time, a first billing amount is calculated by summing the amount corresponding to the number of points associated with the point ID,
When a coupon ID is stored in a coupon ID item associated with a point ID item in the point information table in which the received point ID is stored, the point ticket use store ID is associated with the coupon ID. The coupon issue store ID matches,
If it is determined that they match, the fee associated with the coupon ID from the amount corresponding to the number of points associated with the received point ID for each combination of the point ticket use store ID and the point ticket issue store ID To calculate a second billing amount that is the sum of the amounts subtracted from
If it is determined that they do not match, for each combination of the point ticket use store ID and the point ticket issue store ID, a third billing amount is calculated by summing the amount corresponding to the number of points associated with the point ID. ,
The present invention includes a point management system comprising: a usage record totaling unit that stores the calculated first to third billing amounts in the storage device.

In addition, in a point management method using a point management system that is connected to store terminals of a plurality of stores and manages points that can be commonly used among the plurality of stores,
The point management system includes a storage device that stores information about the points, and a usage record totaling unit that totals the usage records of the points among the plurality of stores,
The storage device stores a point ID item for storing a point ID for identifying a point ticket issued at any of the plurality of stores, and a point ticket issuing store ID for identifying the store from which the point ticket is issued. Point issue store ID items, point number items in which the number of points assigned to the point voucher is stored, and coupon ID items in which a coupon ID for identifying a coupon assigned to the point voucher is stored Attached point information table,
A coupon ID item that stores a coupon ID that identifies a coupon issued at any of the plurality of stores, a coupon issue store item that stores a coupon issue store ID that identifies a store that issued the coupon, and Storing a coupon information table associated with a fee item in which a fee to be paid for a point ticket issuing store to which a coupon is given is stored;
The usage record totaling unit
A point ticket use store ID for identifying a store where the point ticket is used, and a point ID for identifying the point ticket are received,
Extracting the point issuing store ID stored in the point issuing store ID item associated with the point ID item of the point information table in which the received point ID is stored;
When no coupon ID is stored in the coupon ID item associated with the point ID item in the point information table in which the received point ID is stored, the combination of the point ticket use store ID and the point ticket issue store ID For each time, a first billing amount is calculated by summing the amount corresponding to the number of points associated with the point ID,
When a coupon ID is stored in a coupon ID item associated with a point ID item in the point information table in which the received point ID is stored, the point ticket use store ID is associated with the coupon ID. The coupon issue store ID matches,
If it is determined that they match, the fee associated with the coupon ID from the amount corresponding to the number of points associated with the received point ID for each combination of the point ticket use store ID and the point ticket issue store ID To calculate a second billing amount that is the sum of the amounts subtracted from
If it is determined that they do not match, for each combination of the point ticket use store ID and the point ticket issue store ID, a third billing amount is calculated by summing the amount corresponding to the number of points associated with the point ID. ,
The point management method of storing the calculated first to third billing amounts in the storage device is also included in the present invention.

  ADVANTAGE OF THE INVENTION According to this invention, the utilization result of a coupon can be measured correctly and the payment based on the customer transfer fee according to the utilization result of a coupon is attained. In addition, it is possible to provide a coupon distribution mechanism that is advantageous to both the customer store and the customer store. Furthermore, the number of coupons issued within a group of companies or shops that have introduced the mechanism according to the present invention is increased, and the effect of increasing customer consumption can be expected.

  Hereinafter, embodiments of the present invention will be described.

  FIG. 1 is a schematic diagram of a point management system to which an embodiment of the present invention is applied. As shown in the figure, the point management system of this embodiment includes a point management server 1 and a store system 2. These systems are connected via the Internet, an intranet, a LAN, and other wired or wireless networks 9.

  FIG. 2 is a diagram illustrating a hardware configuration of the point management server 1. The point management server 1 includes a CPU 901, a memory 902, an external storage device 903, an input device 904, an output device 905, and a communication control device 906.

  The input device 904 is, for example, a keyboard or a mouse that accepts data input. The output device 905 is, for example, a display or a printer that outputs data. The communication control device 906 is, for example, an Ethernet (registered trademark) adapter, a modem, a wireless communication device, or the like for connecting to the network 9.

  The external storage device 903 is, for example, a hard disk drive that stores various data and programs. The memory 902 is a main storage device such as a RAM (Random Access Memory). The storage unit 19 of the point management server 1 described above is realized as a storage area provided by the memory 902 and the external storage device 903.

  The CPU 901 is an arithmetic device that controls the operation of the point management server 1, and by reading a program stored in the external storage device 903 into the memory 902 and executing it, the coupon registration unit 11, the point registration unit 12, and the usage counting unit 13 and various functions such as the settlement processing unit 14 are realized. Each functional unit described above may be realized as hardware.

  Based on the information received from the store system 2, the point management server 1 performs processing such as issuance of points and coupons, used check, and settlement of a customer service fee using point resources and coupons. In the present embodiment, management of common points in a shopping street is taken as an example. At that time, it is conceivable that the point management server 1 is held by an organization that organizes regions such as local business associations and regional leading companies. If it is a common point between companies, it can be held by core companies or management companies among participating companies. It is conceivable that a financial institution or an information system vendor owns the point management server 1 regardless of whether it is a shopping street or a company.

  The store system 2 is a terminal or a system owned by each participating store, and accesses the point management server 1 based on instructions from store-related persons, and performs point and coupon issue processing, settlement request, and the like.

  Next, the overall flow from the point issuance to the settlement will be described with reference to FIG. Here, in order to facilitate understanding, the explanation will be made assuming that one user is used and the stores are store A and store B.

  First, the store B makes a coupon registration application to the point management server 1 using the store system 2 possessed (step S1). Based on this application, the point management server 1 registers the contents of the coupon, the store where the coupon is desired to be distributed, the customer service fee, and the like (step S2). Here, the coupon is mainly intended for offering or discounting goods or services for users free of charge, and is, for example, “10% discount” or “free dessert”. However, the present invention can be applied even to an advertisement that does not provide a financial advantage to the user.

  Next, the store A makes a point issuance application to the point management server 1 using the store system 2 possessed (step S3). Based on this application, the point management server 1 registers the number of points, the number of point ticket issued, coupon information associated with the point ticket, and instructs the operator, printing company, etc. to print the point ticket. Here, it is assumed that one 100 point ticket corresponding to the coupon “one dessert at store B is free” is registered and printed. On the ticket surface, the number of points and coupon contents are printed so that the user can recognize the contents, and a unique number (hereinafter referred to as a point ID) for identifying each point ticket is also printed (step S4). . Subsequently, the printed point ticket is provided to the store A that has issued the application by mail or handing (step 5).

  In the present embodiment, the point management server 1 stores instruct to print the point ticket using paper as a medium, and the printed matter is given to the store, but the store issues a printing instruction using the store system 2, Printing may be performed by connecting a printer to the store system 2 or the like. Moreover, when a user purchases goods by electronic commerce, it is good also as a form which displays a point ticket and a coupon on a user's screen, and has this presented to a store by printing or bringing. Further, the store provides the user with a piece of paper on which a two-dimensional code is printed, and the user reads the URL with a mobile phone, acquires the URL, and accesses the URL to display the point ticket and the coupon ticket. Various forms are possible.

  Next, the store A provides products and services to the user (step S6), and provides point tickets to the users who have used the products and services. Here, it is assumed that the point ticket printed above is provided (step S7). The point ticket can be provided by each store by freely setting conditions such as the conversion rate. For example, “10 points will be given to customers who purchase 1,000 yen or more.” "If you have 10 points, you will receive a 200-point ticket." It can be provided regardless of the use of products and services. There are no restrictions on the point ticket issuance unit, and it is set at the design stage of the entire service.

  Next, the user presents the acquired point ticket to the store B (step S8), and receives a service corresponding to the 100 point ticket and a service corresponding to “free dessert at store B” (step S9). Here, when the service corresponding to the content of the coupon is received, it may be determined that the points cannot be used. When a point ticket is used, all points on the point ticket are transferred to the use store (store B). If there are points that have not been used at this time, it may be refunded to the user from the use store (store B) as money.

  The store B provides the received point ticket information to the point management server 1 using the store system 2 and applies for the settlement of the point ticket and the settlement of the coupon (step S10). The application method is a method in which the store B inputs the point ID, a method in which the point ID is imaged by a scanner, and a method in which the point ID is symbolized into a two-dimensional barcode and read by a reading device such as a mobile phone. There are various options. It is also conceivable for the store B to mail the point ticket without using the store system 2. In this case, the subject managing the point management server 1 inputs the point management server 1 using the above method or the like.

  Next, the point management server 1 confirms whether the received point ID is an issued point ID or a settlement-processed point ID in order to confirm the presence or absence of fraud, etc. S11).

  Subsequently, the point management server 1 performs a usage record totaling process in order to simplify the settlement process in step S13 (step S12). Detailed contents of the usage record total will be described later.

  Coupon registration process composed of step S1 and step S2, point ticket issuance process composed of step S3 to step S5, point ticket receipt and use by the user composed of step S6 to step S9, and step The settlement pre-processing configured from step S10 to step S12 is executed at any time at the timing that the user and the store consider necessary until the preset closing date arrives.

  When the closing date arrives, the point management server 1 calculates the settlement amount between the stores based on the processing performed in step S12 (step S13). Here, the store A that issued the point ticket pays to the store A if the store B that has registered the coupon and the store B that has registered the coupon pays to the store B that received the point ticket. It is possible to reliably capture the actual use of the coupon by performing the settlement of the customer service fee in association with each other. Here, it is conceivable that the calculated settlement amount is sent to a financial institution based on a prior contract, and funds are transferred between store accounts.

Next, an overview of each system connected to the network 9 is shown.
The point management server 1 includes a coupon registration unit 11 that accepts registration of coupons from a store, a point registration unit 12 that accepts registration of points from a store, and a usage counting unit 13 that accepts information on points used from a store and totals information. And a settlement processing unit 14 that performs settlement between stores, and a storage unit 19 that stores various types of information.

  The storage unit 19 stores six tables. Hereinafter, the contents of each table will be described. How each table is created will be described in the description of the operation of the point management server 1.

  The coupon information table 21 is a table for managing coupon information that can be selected when each store issues a point ticket. The store that wants to distribute the coupon registers the contents. Specific contents are a coupon ID that is a unique ID for identifying a coupon, a coupon provider ID, a customer service fee, a coupon content, a store ID at which the coupon can be selected, and a numerical value indicating the customer power of the coupon. A certain total store visit rate is stored.

  The point information table 22 is a table for managing information on point tickets issued by each store. Specifically, the point ID, which is a unique ID for identifying the point ticket, the ID of the store that is the point ticket issuer, the number of points of the point ticket, the coupon ID of the coupon associated with the point ticket, Status information indicating whether the point ticket has been passed is stored.

  Coupons do not necessarily need to be related, but if they are related, the settlement of points and coupons is performed at the time of settlement. Also, one point ID is given for each point ticket. Thereby, when the same point ID is used twice and an application for payment is made, it is understood that the point ticket is a duplicate. When duplication check is not performed, it is possible to manage the number of points with the same point ID for point coupons associated with the same coupon with the same number of points.

  The result table (with a coupon) 23 is a table that counts whether or not the coupon has been used at a coupon issue store (a store where a coupon can be used) based on information on a settlement application sent from the store.

  Specifically, in relation to the coupon ID, stores the point ticket issuer, the number of point tickets received at the coupon issuing store, the number received at other stores, and the total point ticket totals To do. When a point issuing store issues 100 point tickets related to a certain coupon, by counting how many of them go to the coupon issuing store as desired and how many others go, Measure the effect.

  The result table (no coupon) 24 totals the point ticket issuing store and the number of point tickets received for each store that has received the point ticket for the point ticket without the coupon. For example, the information that 33 coupon tickets issued by the store A without a coupon are used at the store B is stored. Thereby, the movement of the user between stores when there is no coupon can be grasped. As a total period, methods such as between the closing dates and the past six months can be considered.

  The couponless store visit rate table 25 stores information obtained by converting the information stored in the performance table (no coupon) 24 into the reception ratio for each issuer, not the number of receptions. For example, information indicating that 16% of the point coupons issued by the store A without a coupon are used at the store S is stored.

  The billing table 26 stores how much money needs to be transferred between stores. On the closing date, all the usage information of the point ticket is processed to create a table, and a settlement instruction is issued based on this information.

Next, various operations of the point management server 1 will be described.
Hereinafter, the point with the point ID P001 is described as “point P001”, and the coupon with the coupon ID C001 is described as “coupon C001”. Further, access from the store to the point management server 1 is performed from the store system 2 unless otherwise specified.

  First, the coupon registration process executed by the coupon registration unit 11 will be described. This is the process shown in step S2 in FIG. 3, and is performed based on the input shown in step S1.

  First, the coupon registration unit 11 accepts a coupon registration application via the store system 2 from a store (coupon issuing store) that wants to place the coupon of its own store on a point ticket issued by another store. Application for coupon registration includes the ID of the store that is the applicant (coupon issuance store ID), the amount of commission that can be paid for one customer, the contents of the coupon such as “free dessert”, and the coupon The ID of the store you want is included. The coupon registration unit 11 assigns a unique coupon ID, stores it in the coupon information table 21 in association with information included in the application. Each store performs such processing and registers coupons as necessary.

  Next, point registration / issuance processing executed by the point registration unit 12 will be described with reference to FIG. This is the process shown in step S4 in FIG. 3, which is performed based on the input shown in step S3 and leads to the sending of point tickets shown in step S5.

  First, the point registration unit 12 receives an application for issuing a point ticket from the store where the point ticket is to be issued (point ticket issuing store) via the store system 2. The point ticket issuance application includes information on the ID of the store that is the applicant (point ticket issuance store ID), the number of points that become the face value of the point ticket, and the number of point tickets to be issued (issue number). For example, it is assumed that the store ID is “store L”, the number of points is “500”, and the number of issued sheets is “2” (step S101).

  The point registration unit 12 that has received the information extracts a coupon in which the applicant's store ID (point ticket issuing store ID) is recorded in the desired store column of the coupon information table 21. If the coupon information table 21 is as shown in FIG. 4, a coupon C002 and a coupon C003 in which “store L” is described in the desired store column are extracted (step S102). In addition, it is good also as what extract | extracts the coupon containing a customer transfer fee lower than the number of points used as the face value of a point ticket here.

  Next, one unprocessed coupon is selected from the extracted coupons. For example, coupon C002 is selected (step S103).

  Next, from the couponless visit rate table 25, the issuer column is the store ID of the applicant (point ticket issue store ID), and the recipient column is the store ID of the coupon provider of the coupon (coupon issue store ID). ) Is extracted and the store visit rate is acquired. If the coupon-free visit rate table 25 is as shown in FIG. 8, a record having an issuer column of “Store L” and a recipient column of “Store N” is extracted, and the store visit rate is “0.05. Is obtained. (Step S104).

  Using the acquired store visit rate and information on the coupon recorded in the coupon information table 21, a recommended coupon value is calculated. For example, (total store visit rate−visit store rate) × customer fee is calculated. That is, (0.31-0.05) × 50 = 13.00 is set as the recommended coupon value.

  Here, the total store visit rate is a rate indicating how much the customer went to the coupon provider's store (coupon issue store) when this coupon was distributed in the past. For example, if a total of 50 point coupons with coupons have been issued at 3 stores so far, 20 of them have been used at the stores that issued the point coupons (point ticket issue stores), 20/50 = 0.4 is the total. It becomes the visit rate.

  In addition, the store visit rate here refers to the percentage of point vouchers used by stores that are issuing point vouchers that do not have coupons issued in the past. It is a rate indicating whether or not For example, if a total of 200 point coupons without coupons have been issued so far, and 10 of them have been used at this coupon issue store, 10/200 = 0.05 is the store visit rate. By taking the difference between the total store visit rate and the store visit rate, the effect of attaching a coupon is estimated. By multiplying this by the fee paid per customer, a coupon recommended value for predicting the income by attaching a coupon is calculated.

  Next, check if all coupons have been processed. Here, since the coupon C003 has not been processed, the processing from step S103 is repeated on the coupon C003. Here, (0.18−0.16) × 30 = 6.00 is calculated as the recommended coupon value (step S106). A screen is created so that coupon information is displayed in order from the highest coupon recommended value, and transmitted to the store system 2.

  Here, the coupons C002 and C003 are displayed in this order (step S107). At the store, a coupon is selected by looking at this information and transmitted to the point registration unit 12 using the store system 2. Here, it is assumed that the coupon C002 is selected (step S108). Next, information on the issued point ticket is added to the point information table 22. Information such as point P001 and point P002 in FIG. 5 is added.

  Here, “not yet” in the payment column is not yet settled, that is, it is placed in the store before distribution to the user, is owned by the user, is unused, or is used by the user but is in the store Indicates that it is not notified to the point management server 1 (step S109). Finally, instructions for printing and distributing point tickets are given (step S110). Here, the timing of receiving the application for the number of points and the number of issued cards from the store may be the time of selecting a coupon, not the first of the processing.

  The store that has applied for the issuance of points (the point ticket issuing store) receives the point ticket and passes the point ticket to the user in accordance with the use of the product or service during normal business. The user who has received the point ticket uses it at the store he / she wants to use and uses the product or service (from step S6 to step S9 in FIG. 3).

  Next, the forgery check process and the usage record totaling process executed by the usage totaling unit 13 will be described with reference to FIG. This is the process shown in step S11 and step S12 in FIG. 3, and is performed based on the input shown in step S10.

  First, the store where the point ticket is used (the point ticket using store) transmits the information of the point ticket received from the user to the use counting unit 13 using the store system 2. The usage totaling unit 13 receives a store ID (point ticket using store ID) and a point ID. For example, it is assumed that the store ID is “store N” and the point ID is “P001” (step S201). Next, the corresponding point information is extracted from the point information table 22 (step S202).

  If the corresponding point ID is not found (step S203: No), an alert is issued because an unissued point ticket is used (step S205), and the process is terminated. If the corresponding point ID is found (step S203: Yes), it is confirmed whether payment has been completed from the information in the payment column of the point information table 22 (step S204).

  If the payment has been completed (step S204: Yes), an alert is issued because the same point ticket has been used a plurality of times (step S205), and the process is terminated. When it is not settled (step S204: No), it is checked whether the coupon ID is related to the point ID (step S206).

  When the coupon ID is related (step S206: Yes), the coupon information is acquired from the coupon information table 21 using the coupon ID (step S207), and the applicant's store ID (point ticket using store ID) and coupon offer The user ID (coupon issue store ID) is compared (step S208).

  If the applicant's store ID and the coupon provider ID are the same (step S208: Yes), 1 is added to the coupon provider receipt number of the corresponding record in the record table (with coupon) 23, and the point amount is The number of points on the point ticket is added to the total amount of points (step S209), and the process ends. Here, from the coupon information table 22, the customer commission of the coupon ID associated with the received point ID is specified, and the amount obtained by subtracting this customer commission from the number of points of the point ticket is indicated in the billing table 26. It may be added to a record in which the payer column is the point issuer and the receiver column is the store ID of the applicant.

  When the store ID of the applicant and the coupon provider ID are different (step S208: No), 1 is added to the number of receipts other than the coupon provider of the corresponding record in the record table (with coupon) 23, and the point amount is The total number of points is added to the number of points on the point ticket (step S210), and the process is terminated. Here, the point number of the point ticket may be added to a record in which the payment side column of the charging table 26 is the point issuer and the receiving side column is the applicant's store ID.

  If no coupon ID is associated with the point ID in step 206 (step S206: No), 1 is added to the number of receipts of the corresponding record in the performance table (no coupon) 24 (step S211), and the billing table The number of points of the point ticket is added to a record in which the payer column of 26 is the store ID of the point issuer (point ticket issue store ID) and the receiver column is the store ID of the applicant (store ticket use store ID). (Step S212). Here, the point number of the point ticket may be added to a record in which the payment side column of the charging table 26 is the point issuer and the receiving side column is the applicant's store ID.

  In this case, the point ID “P001” is present from the point information table 22 (step S203: Yes), unsettled (step S204: No), and a coupon ID is given (step S206: Yes). Since the applicant's store ID and the coupon provider's ID are the same (step S208: Yes), the record ID in the record 23 (with coupon) is “C002” and the issuer is “store L”. 1 is added to the coupon provider receipt number (step S209).

  Up to this point, only the payment information of the point ticket with no coupon is stored in the billing table, and the payment information of the point ticket with the coupon is stored in the processing of the payment processing unit 14.

  Next, the payment process executed by the payment processing unit 14 will be described with reference to FIG. This is the process shown in step S13 in FIG. 3, and is performed based on the arrival of the closing date.

  First, a couponless store visit rate table 25 is created. This stores information obtained by converting the information stored in the performance table (no coupon) 24 into the reception ratio for each issuer, not the number of receptions. Specifically, in the results table (no coupon) 24, the issuer adds up the number of receipts for the same record as the total number of point tickets, and calculates the ratio of the number of receipts of each recipient to the total number of visits. And

  For example, if the result table (no coupon) 24 is as shown in FIG. 7 and there is no data after the fifth record, the total number of point tickets issued by store A is 12 + 33 + 52 + 19 = 116, and store B is the recipient. In this case, the store visit rate is 33/116 = 0.28.

  Next, a record having a coupon provider receipt number of 1 or more in the result table (with coupon) 23 is extracted. This is a process of removing a coupon that has not been passed to the coupon provider at all (step S301). Next, one unprocessed coupon is selected from the extracted coupons (step S302). In addition, in the results table (with a coupon) 23, the coupon provider corresponding to the coupon ID may be an issuer (coupon issue store ID = point ticket issue ID). This is a process of excluding this because a point-to-store payment is not required when a coupon for the store is attached to the point ticket issued by the store.

  Next, one unprocessed issuer is selected from the coupon ID. Here, since the same coupon may be related to a point ticket issued by a plurality of stores, a plurality of records with the same coupon ID exist in the result table (with coupon) 23. One record is selected (step S303). For the selected record, the coupon visit rate is calculated. The coupon visit rate is a numerical value indicating how many of the coupons are used at a coupon provider's store when a coupon with a certain coupon ID is issued at a store. Specifically, it is calculated by “coupon provider received number / (coupon provider received number + coupon provider received number)”.

  For example, in the record table (with coupon) 23 in FIG. 6, when the coupon ID is C001 and the issuer is the store A, 35 / (35 + 65) = 0.35 is the coupon visit rate (step S304). Next, the store visit rate without coupon is acquired from the store visit rate table 25 without coupon. If the coupon ID is C001 and the issuer is processing a record of store A, the coupon provider is store S, and therefore the issuer is “store A” and the recipient is The store visit rate of the record “store S” is acquired (step S305).

  Next, the coupon visit rate and the coupon-free visit rate are compared. When the coupon visit rate is larger than the no coupon visit rate (step S306: Yes), the customer service fee paid by the coupon provider to the point ticket issuer is calculated. Specifically, it is calculated by “(coupon visit rate−no-coupon visit rate) × number of issued × customer fee”. The coupon visit rate—the non-coupon store visit rate indicates an additional effect of sending customers by adding a coupon. On the other hand, the number of issued tickets is multiplied, and the number of point tickets additionally passed to the store by the coupon is calculated.

  Further, the payment amount is calculated by multiplying the customer transfer fee for each sheet (step S307). If the coupon visit rate is smaller than the no coupon visit rate (step S307: No), it means that there is no effect of the coupon, so the customer fee for the point ticket issuer is set to zero (step S308). The customer service fee specified in step S307 or step S308 is compared with the point amount in the performance table (with coupon) 23. If the point amount is larger, the point amount minus the customer fee is paid. Otherwise, zero is set as the payment amount (step S309), and the payment amount is added to the record in which the payment side column of the charging table 26 is the point issuer and the reception side column is the store ID of the coupon provider ( Step S310).

  Here, the process of step S309 is to prevent the amount of the coupon customer transfer fee from exceeding the amount of the point source payment. Thereby, the incentive which performs payment can be provided with respect to the point ticket receiving store.

  Next, if there is an unprocessed issuer in the coupon extracted in step S302 (step S311: No), the process returns to step 303, and if there is no unprocessed issuer (step S311: Yes), the process proceeds to step 312.

  Next, the coupon provider received number and the received number other than the coupon provider in the result table (with coupon) 23 are added together for each coupon ID. For example, when the coupon C001 is distributed at two stores, store A and store G, the information at these two stores is added up. Based on this information, the coupon visit rate for the coupon C001 as a whole, that is, “the sum of the number of coupon providers received for the store A and the store G as the issuer of the coupon C001 / (the store A as the issuer of the coupon C001 and The total number of coupon provider receipts for store G + the number of receipts other than the coupon provider for store A and store G, which is the issuer of coupon C001), is obtained in the column for the total visit rate of coupon information table 21 Record.

  For example, when the results table (with coupon) 23 is as shown in FIG. 6, the number of coupon provider receipts and the number of receipts other than coupon providers for the record (issuer is store A, store G) whose coupon ID is C001. And (35 + 12) / {(35 + 12) + (65 + 89)} = 0.23 is the coupon visit rate. This is overwritten if already recorded.

  As described above, the total store visit rate is used when calculating a recommended coupon value that indicates which coupon should be related when a point ticket is issued (step S312). Next, it is confirmed whether or not all coupon IDs have been processed. If they have not been processed (step S313: No), the process returns to step S302. If they have been processed (step S313: Yes), the result table (with coupons) ) 23, the performance table (no coupon) 24, and the coupon-free visit rate 25 are cleared (step S314), and the process is terminated.

  Thereafter, based on the information in the billing table 25, a bank transfer is instructed by informing the bank or the like. It is also possible to perform netting prior to the instruction. Netting is, for example, when there is a record in the billing table 25 where the paying side is store A, the receiving side is store B and the amount is 1000, and the paying side is store B, the receiving side is store A and the amount is 500. In other words, the processing is such that the paying side is store A, the receiving side is store B, and the amount is 500.

  Although the above has been described with respect to two parties, it can be performed in a relationship of three or more parties. If the payment from the store A to the store B is 100, the payment from the store B to the store C is 100, and the payment from the store C to the store A is 100, all the stores will pay 100 and receive 100. It may be possible to delete. Thereby, the frequency | count of a fund transfer can be reduced.

  According to this embodiment, the coupon issuing store, which is a point ticket using store, registers the information of the point ticket in order to receive the consideration of the used point ticket, and the coupon given to the point ticket Since the coupon usage record is also registered based on the corresponding relationship, the accurate coupon usage record can be measured, and settlement based on the commission corresponding to this use record is possible.

  In addition, point tickets and coupons can be issued at any of the common point service member stores, and the customer can use points without registering as a member, making it easy for both the member store and the customer to use it. Can provide highly convenient services.

  As mentioned above, although embodiment of this invention was described concretely based on the embodiment, it is not limited to this and can be changed in the range which does not deviate from the summary.

It is a system configuration figure showing an embodiment of the present invention. It is a figure which shows the example of the hardware constitutions of each system in embodiment of this invention. It is the outline | summary of the processing flow in embodiment of this invention. It is an example of the coupon information table in embodiment of this invention. It is an example of the point information table in the embodiment of the present invention. It is an example of the results table (with a coupon) in the embodiment of the present invention. It is an example of the performance table (no coupon) in the embodiment of the present invention. It is an example of the store visit rate table without a coupon in the embodiment of the present invention. It is an example of the accounting table in the embodiment of the present invention. It is a processing flow figure of point ticket issue in the embodiment of the present invention. It is a processing flow figure of the utilization results totaling in the embodiment of the present invention. It is a processing flowchart of the payment process in the embodiment of the present invention.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 ... Point management server, 11 ... Coupon registration part, 12 ... Point registration part, 13 ... Usage totaling part, 14 ... Settlement processing part, 19 ... Memory | storage part, 2 ... Store system, 9 ... Network.

Claims (8)

In a point management system that is connected to store terminals of a plurality of stores and manages points that can be commonly used among the plurality of stores,
Point ID item for storing a point ID for identifying a point ticket issued at any of the plurality of stores, and a point issuing store for storing a point ticket issuing store ID for identifying a store from which the point ticket is issued Point information in which an ID item, a point number item in which the number of points assigned to the point ticket is stored, and a coupon ID item in which a coupon ID for identifying a coupon assigned to the point ticket is stored are associated with each other Table,
A coupon ID item that stores a coupon ID that identifies a coupon issued at any of the plurality of stores, a coupon issue store item that stores a coupon issue store ID that identifies a store that issued the coupon, and A storage device for storing a coupon information table associated with a fee item in which a fee to be paid for a point ticket issuing store to which a coupon is given is stored;
A point ticket use store ID for identifying a store where the point ticket is used, and a point ID for identifying the point ticket are received,
Extracting the point issuing store ID stored in the point issuing store ID item associated with the point ID item of the point information table in which the received point ID is stored;
When no coupon ID is stored in the coupon ID item associated with the point ID item in the point information table in which the received point ID is stored, the combination of the point ticket use store ID and the point ticket issue store ID For each time, a first billing amount is calculated by summing the amount corresponding to the number of points associated with the point ID,
When a coupon ID is stored in a coupon ID item associated with a point ID item in the point information table in which the received point ID is stored, the point ticket use store ID is associated with the coupon ID. The coupon issue store ID matches,
If it is determined that they match, the fee associated with the coupon ID from the amount corresponding to the number of points associated with the received point ID for each combination of the point ticket use store ID and the point ticket issue store ID To calculate a second billing amount that is the sum of the amounts subtracted from
If it is determined that they do not match, for each combination of the point ticket use store ID and the point ticket issue store ID, a third billing amount is calculated by summing the amount corresponding to the number of points associated with the point ID. ,
A point management system comprising: a usage record totaling unit that stores the calculated first to third billing amounts in the storage device. In the point management system according to claim 1,
A payment processing unit is further provided for calculating the payment amount paid from the point ticket issuing store to the point ticket using store by counting the first to third billing amounts for each predetermined time limit,
The usage record totaling unit
For each combination of the point ticket use store ID and the point ticket issue store ID, the first use of the point ticket is performed by counting the number of times the point ID is received when no coupon ID is stored in the coupon ID item. Calculate the number of sheets,
For each combination of the point ticket use store ID and the point ticket issue store ID, the points are obtained by counting the number of times the point ID is received when it is determined that the point ticket use store ID and the coupon issue store ID match. Calculate the second number of tickets used,
For each combination of the point ticket use store ID and the point ticket issue store ID, the point ticket is obtained by counting the number of times the point ID is received when it is determined that the use store ID does not match the coupon issue store ID. Calculate the third usage number of
Storing the calculated first to third usage numbers in the storage device;
The settlement processing unit
Based on the first use number of sheets, for each combination of the point ticket use store ID and the point ticket issue store ID, the first use rate of the point ticket to which the coupon is not given is calculated,
Based on the second to third use number, the second use rate of the point ticket to which the coupon is given is calculated for each combination of the point ticket use store ID and the point ticket issue store ID,
2. The point management system according to claim 1, wherein the second billing amount is calculated based on the calculated first and second usage rates and the fee. The point management system according to claim 2, wherein the settlement processing unit includes:
The first usage rate is calculated by dividing the first usage number by the total number of the first usage numbers with the same point ticket issuing store ID,
Calculating the second usage rate by dividing the second usage number by the total value of the second to third usage numbers;
When the second usage rate is greater than the first usage rate, the second billing amount is multiplied by a value obtained by subtracting the first usage rate from the second usage rate. The point management system characterized by calculating by. In the point management system according to claim 3,
In order to issue the point ticket, further comprising a point registration processing unit for storing information in the point information table,
In the coupon information table, usage rate items in which a fourth usage rate, which is a usage rate for each coupon calculated based on the second to third usage number, is further stored in association with each other. ,
The point registration processing unit
The point management system characterized by sorting and outputting the information stored in the coupon information table based on the fourth utilization rate of points. In a point management method using a point management system that is connected to store terminals of a plurality of stores and manages points that can be commonly used among the plurality of stores,
The point management system includes a storage device that stores information about the points, and a usage record totaling unit that totals the usage records of the points among the plurality of stores,
The storage device
Point ID item for storing a point ID for identifying a point ticket issued at any of the plurality of stores, and a point issuing store for storing a point ticket issuing store ID for identifying a store from which the point ticket is issued Point information in which an ID item, a point number item in which the number of points assigned to the point ticket is stored, and a coupon ID item in which a coupon ID for identifying a coupon assigned to the point ticket is stored are associated with each other Table,
A coupon ID item that stores a coupon ID that identifies a coupon issued at any of the plurality of stores, a coupon issue store item that stores a coupon issue store ID that identifies a store that issued the coupon, and Storing a coupon information table associated with a fee item in which a fee to be paid for a point ticket issuing store to which a coupon is given is stored;
The usage record totaling unit
A point ticket use store ID for identifying a store where the point ticket is used, and a point ID for identifying the point ticket are received,
Extracting the point issuing store ID stored in the point issuing store ID item associated with the point ID item of the point information table in which the received point ID is stored;
When no coupon ID is stored in the coupon ID item associated with the point ID item in the point information table in which the received point ID is stored, the combination of the point ticket use store ID and the point ticket issue store ID For each time, a first billing amount is calculated by summing the amount corresponding to the number of points associated with the point ID,
When a coupon ID is stored in a coupon ID item associated with a point ID item in the point information table in which the received point ID is stored, the point ticket use store ID is associated with the coupon ID. The coupon issue store ID matches,
If it is determined that they match, the fee associated with the coupon ID from the amount corresponding to the number of points associated with the received point ID for each combination of the point ticket use store ID and the point ticket issue store ID To calculate a second billing amount that is the sum of the amounts subtracted from
If it is determined that they do not match, for each combination of the point ticket use store ID and the point ticket issue store ID, a third billing amount is calculated by summing the amount corresponding to the number of points associated with the point ID. ,
The point management method, wherein the calculated first to third billing amounts are stored in the storage device. In the point management method according to claim 5,
The point management system calculates a settlement amount paid from the point ticket issuing store to the point ticket using store by counting the first to third billing amounts for each predetermined time limit. Further comprising
The usage record totaling unit
For each combination of the point ticket use store ID and the point ticket issue store ID, the first use of the point ticket is performed by counting the number of times the point ID is received when no coupon ID is stored in the coupon ID item. Calculate the number of sheets,
For each combination of the point ticket use store ID and the point ticket issue store ID, the points are obtained by counting the number of times the point ID is received when it is determined that the point ticket use store ID and the coupon issue store ID match. Calculate the second number of tickets used,
For each combination of the point ticket use store ID and the point ticket issue store ID, the point ticket is obtained by counting the number of times the point ID is received when it is determined that the use store ID does not match the coupon issue store ID. Calculate the third usage number of
Storing the calculated first to third usage numbers in the storage device;
The settlement processing unit
Based on the first use number of sheets, for each combination of the point ticket use store ID and the point ticket issue store ID, the first use rate of the point ticket to which the coupon is not given is calculated,
Based on the second to third use number, the second use rate of the point ticket to which the coupon is given is calculated for each combination of the point ticket use store ID and the point ticket issue store ID,
A point management method, wherein the second billing amount is calculated based on the calculated first and second usage rates and the fee. In the point management method according to claim 6,
The settlement processing unit
The first usage rate is calculated by dividing the first usage number by the total number of the first usage numbers with the same point ticket issuing store ID,
Calculating the second usage rate by dividing the second usage number by the total value of the second to third usage numbers;
When the second usage rate is greater than the first usage rate, the second billing amount is multiplied by a value obtained by subtracting the first usage rate from the second usage rate. The point management method characterized by calculating by. In the point management method according to claim 7,
The point management system further includes a point registration processing unit for storing information in the point information table in order to issue the point ticket,
In the coupon information table, usage rate items in which a fourth usage rate, which is a usage rate for each coupon calculated based on the second to third usage number, is further stored in association with each other. ,
The point registration processing unit
The point management method characterized by sorting and outputting the information stored in the coupon information table based on the fourth utilization rate of points.

Images