JP7278009B1 - Coupon management system and program - Google Patents

Abstract

An object of the present invention is to apply benefits corresponding to coupons without requiring complicated operations. A control unit and a storage unit are provided, and the storage unit includes a menu storage unit that stores a plurality of menu items, coupon identification information for each of the plurality of coupons, menu items to which the coupon is applied, Coupon benefits provided in accordance with the coupon are included in the storage in association with each other, and the control unit acquires the order menu items ordered by the customer and the coupons used by the customer. , when the order menu item is associated with the use coupon in the coupon storage unit, the coupon benefit associated with the use coupon is applied to the order menu item. [Selection drawing] Fig. 1

Description

The present invention relates to a coupon management system and program.

Conventionally, various types of coupons are used in eating establishments such as restaurants. As a technique related to coupons, Patent Document 1 discloses a technique for outputting a message indicating that the coupon needs to be collected when the used coupon needs to be collected.

JP 2022-41581 A

However, when a coupon is used, it is necessary to perform an operation such as changing the price of the product corresponding to the coupon at the order terminal, which is troublesome.

SUMMARY OF THE INVENTION The present invention has been made in view of the above problems, and an object of the present invention is to apply benefits corresponding to coupons without requiring complicated operations.

To achieve the above object, the present invention provides a coupon management system comprising a control section and a storage section, the storage section comprising a menu storage section for storing a plurality of menu items, and a plurality of menu items. a coupon storage unit that associates and stores coupon identification information for each coupon, menu items to which the coupon is applied, and coupon benefits provided according to the coupon; obtaining an order menu item ordered and a use coupon to be used by the customer, and acquiring the use coupon when the order menu item is associated with the use coupon in the coupon storage unit; Applying the associated coupon benefit to the order menu item.

According to another aspect of the present invention, a computer of the coupon management device is provided with a program executed by the coupon management device, and an acquisition step for acquiring a coupon used by a customer and an order menu item ordered by the customer. , the order menu item acquired in the acquisition step in a coupon storage unit that associates and stores coupon identification information for each of a plurality of coupons, menu items to which the coupon is applied, and coupon benefits provided according to the coupon. is associated with the use coupon, applying the coupon benefit associated with the use coupon to the order menu item.

ADVANTAGE OF THE INVENTION According to this invention, the privilege corresponding to a coupon can be reflected, without requiring complicated operation.

1 is a configuration diagram of a coupon management system; FIG. It is a figure which shows an example of the data structure of goods DB. It is a figure which shows an example of a data structure of coupon DB. It is a flow chart which shows order reception processing. It is a flow chart which shows coupon management processing. It is a figure which shows an example of a data structure of coupon DB which concerns on a modification. FIG. 11 is a diagram showing a display example of a menu screen according to a modified example;

Embodiments of the present invention will be described with reference to the drawings. It should be noted that the embodiment shown below is merely an example that embodies the present invention, and does not limit the present invention.

FIG. 1 is an overall view of an ordering system 1 according to this embodiment. The ordering system 1 is a system for managing the provision of ordered products in a store such as a restaurant that provides products related to eating and drinking. The ordering system 1 further applies a coupon privilege, which is a privilege according to the coupon, when the coupon is used by the customer at the store. For example, when a coupon for one free french fries is used, processing is performed such that one french fries ordered by the customer is free of charge.

Here, the coupon is a ticket for enjoying coupon benefits such as discounts and free offerings, such as one free French fries, 10% discount on drinks, and 50 yen discount on drinks. The coupon may be a paper medium or an electronic coupon available on the Internet or the like. The issuer of the coupon is the restaurant in which the ordering system 1 is introduced, but the issuer of the coupon is not limited to the embodiment. As another example, the issuer of the coupon may be a company that operates a portal site of a restaurant, or the like.

The order system 1 includes a management device 10 , an order terminal device 20 and a checkout device 30 . The management device 10, order terminal device 20, and accounting device 30 are connected via a network such as a wireless LAN (Local Area Network). The management device 10 is composed of, for example, a stationary general-purpose computer, a cloud-type server, or the like, and manages provision of ordered products, accounting, and the like, and performs processing related to coupons. Here, the management device 10 is an example of a coupon management device that manages application of coupons. The order terminal device 20 is, for example, a smart device such as a handy terminal, a smart phone, or a tablet terminal. The order terminal device 20 is carried by a user such as a waiter and used for inputting an order from a customer. The entered information is transmitted to the management device 10 . Although one order terminal device 20 is shown in the example shown in FIG. The accounting device 30 performs accounting processing for ordered products.

The management device 10 includes a first control section 11 , a first communication section 12 and a recording medium 13 . The first control unit 11 includes a processor such as a CPU (Central Processing Unit) and a memory for the processor to execute processing such as ROM (Read Only Memory) and RAM (Random Access Memory), and performs various processes. Execute. The first control unit 11 executes various programs stored in the recording medium 13, ROM, or the like. The first control unit 11 of the present embodiment executes a program stored in the recording medium 13 to perform processing for product provision management and coupon management. Processing of the first control unit 11 will be described later. The first communication unit 12 is a device for performing wireless communication with external devices such as the order terminal device 20 and the checkout device 30 . will be

The recording medium 13 stores a product DB 131 and a coupon DB 132 . Here, the product DB 131 stores a plurality of products. Here, the product is a menu such as a hamburger set or coffee offered at a restaurant, and corresponds to a menu item. Also, information indicating a plurality of menus offered at a store, such as a hamburger set, ginger-fried set, etc., is referred to as a menu table. The menu table is information corresponding to the menu table viewed by customers in the store. The product DB 131 is an example of a menu storage unit that stores multiple menu items.

FIG. 2 is a diagram showing an example of the data configuration of the product DB 121. As shown in FIG. The product DB 131 stores information on each product offered at the store. Specifically, the product DB 131 stores menu table IDs, menu table names, category IDs, category names, product IDs, product names, and unit prices in association with each other.

The menu table ID is identification information of the menu table. For example, in one store, there are a plurality of menu tables, such as a morning menu table, a lunch menu table, and a grand menu table, when the menu table to be applied is switched according to the time period. The menu table is information for identifying these multiple menu tables.

The menu table name is the name of the menu table. The category ID is identification information of the product category displayed in the menu table. Categories include set menus, a la carte dishes, drinks, and the like. The product ID is identification information of the product. A hamburger set includes a plurality of items such as a hamburger, rice, and a drink. Thus, one item may include multiple items. The unit price is the price of the product.

It is sufficient that a DB that can specify the unit price of each product, the category to which the product belongs, and the product displayed in each menu table is stored in the storage unit as the recording medium 13, and the specific configuration of the DB. is not limited to the configuration of the product DB 131 of this embodiment. As another example, the recording medium 13 may further store a menu table DB in which correspondence relationships between products and categories are defined in the product DB, and products included in each menu table are defined.

FIG. 3 is a diagram showing an example of the data structure of the coupon DB 132. As shown in FIG. The coupon DB 132 is an example of a coupon storage unit that stores information on each of multiple coupons used at a store. Specifically, the coupon DB 132 stores coupon IDs, menu list IDs, category IDs, product IDs, coupon benefits, and application conditions in association with each other.

A coupon ID is identification information of a coupon used at a store. In one store, multiple coupons may be used, such as a free potato coupon, a 50% off drink coupon, and a 50 yen discount per drink. Such multiple coupons are identified by coupon IDs.

The coupon privilege is information indicating the details of the privilege that the user can receive by applying the coupon. Coupon privileges include price reductions, discounts, and price changes such as free of charge and changes to 100 yen. The application condition is a condition under which application of the coupon benefit is permitted. Applicable conditions are, for example, up to one group per group (applicable to only one product in one visit group), applicable to products for the number of people included in one visit group, etc. Number of applicable products There are conditions regarding (quantity). Also, applicable conditions include applicable order time zone conditions such as 16:00 to 18:00 (only the time zone from 16:00 to 18:00). The eligibility criteria may also be the number of patrons applicable, for example, 5 free fries on one coupon. Note that the application condition is not essential information, and if there is no restriction on the application of the coupon privilege, the application condition is not associated with the coupon ID.

In the example of FIG. 3, the coupon with the coupon ID "C001" is associated with French fries identified with the product ID "F021." This means that the application target of the coupon with the coupon ID "C001" is french fries. In addition, the coupon with the coupon ID "C001" is associated with an application condition of "one group per group". This means that the coupon with the coupon ID "C001" applies the free coupon benefit to only one french fries per group. Note that the applicable customers can be freely set. For example, it is possible to set an application limit such as up to 5 people included in the group instead of the group.

Also, the coupon with the coupon ID "C002" is associated with the drink identified with the category ID "G009". This means that the coupon with the coupon ID “C002” is applied to all products included in the category “drink”. In addition, since the coupon with the coupon ID "C002" is associated with the application condition of "16:00 to 18:00", the available time is limited to 16:00 to 18:00.

Also, the coupon with the coupon ID "C003" is associated with the morning menu table identified with the menu table ID "M002". That is, the coupon with the coupon ID "C003" is applied to all products included in the morning menu table.

The coupon with the coupon ID "C004" is associated with the lunch menu table with the menu table ID "M003" and the potato salad with the product ID "F111". This means that the coupon with the coupon ID "C004" is applied to the potato salad on the lunch menu table. In other words, this means that even if it is potato salad, it does not apply to the potato salad on the grand menu table.

As described above, the coupon ID is associated with at least one of the product ID, category ID, and menu table. That is, the coupon ID is associated with one or more products in the product DB 131 . Thus, one coupon ID may be associated with one product, or may be associated with multiple products. Specifically, when a coupon ID is associated with a product ID, the coupon privilege is associated with one product identified by the product ID. Note that when multiple product IDs are associated with one coupon ID, the coupon privilege is associated with multiple products specified by each of the multiple product IDs. Also, when a coupon ID is associated with a category ID, it is associated with all products included in the category identified by the category ID. Further, when the coupon ID is associated with the menu table ID, the coupon benefits are associated with all the products included in the menu table identified by the menu table ID. Furthermore, the product to which the coupon privilege is applied may be specified by a plurality of pieces of information such as the menu ID and the product ID.

Returning to FIG. The order terminal device 20 includes a second control section 21 , a second communication section 22 , a display section 23 and an input section 24 . Like the first control unit 11 of the management device 10, the second control unit 21 includes a processor and a storage unit (not shown), and executes various programs stored in a storage unit such as a ROM. Executes various processing. The second control unit 21 receives input from, for example, a user (a customer) who operates the order terminal device 20, and displays information received from the management device 10 (for example, a menu table, etc.). The second communication unit 22 is a device for performing wireless communication with an external device such as the management device 10 , and transmission and reception of information by the second control unit 21 are performed via the second communication unit 22 . The display unit 23 is a display device that displays various information. The input unit 24 is a user interface for receiving instructions input by the customer. The display unit 23 and the input unit 24 may be provided integrally as a touch panel.

FIG. 4 is a flow chart showing order reception processing by the order terminal device 20. As shown in FIG. In the order reception process, first, in step S100, the second control unit 21 confirms whether or not the details of the order from the customer of the store have been acquired. For example, when a customer orders a product such as a hamburger set, and the customer inputs this through the input unit 24 of the order terminal device 20, the second control unit 21 receives the order indicating the hamburger set through the input unit 24. to get If the second control unit 21 does not acquire an order (N in step S100), the process proceeds to step S104. When the second control unit 21 acquires an order (Y in step S100), it registers the ordered product (step S102).

Next, in step S104, the second control unit 21 confirms whether or not the coupon ID of the coupon used by the customer has been acquired. In this embodiment, when a customer presents a coupon to be used (use coupon), the waiter inputs the coupon ID of the presented use coupon to the order terminal device 20 . In this case, the second control section 21 acquires the coupon ID via the input section 24 . When the second control unit 21 does not acquire the coupon ID (N in step S104), the process proceeds to step S108. When acquiring the coupon ID (Y in step S104), the second control unit 21 registers the coupon ID (step S106). Next, in step S108, the second control unit 21 determines whether or not an order transmission instruction has been acquired. When the order by the customer is completed, the customer selects a send button (not shown) displayed on the display section 23 . When the send button is selected, the second control section 21 acquires an order send instruction.

If the second control unit 21 does not acquire an order transmission instruction (N in step S108), the process proceeds to step S100. When the second control unit 21 acquires the order transmission instruction (Y in step S108), the second control unit 21 generates order information indicating the product registered in step S102, and transmits this to the management device 10 (step S110). . For example, when a hamburger set, ginger-grilled set, and french fries are ordered, the second control unit 21 generates order information indicating these three items and the order date and time, and transmits this to the management device 10. . Also, in step S106, if the coupon ID is registered, the second control unit 21 generates order information indicating the ordered product (order menu item), the coupon ID, and the order date and time. , to the management device 10 . This completes the order acceptance process.

FIG. 5 is a flowchart showing coupon management processing by the management device 10. As shown in FIG. In the coupon management process, the first control unit 11 waits until the first communication unit 12 receives the order information in step S200 (N in step S200), and when the order information is received (Y in step S200), the process to step S202. In step S202, the first control unit 11 confirms whether the order information includes a coupon ID. When the coupon ID is not included (N in step S202), the first control unit 11 advances the process to step S208. If the coupon ID is included (Y in step S202), the first control unit 11 advances the process to step S204. In step S204, the first control unit 11 confirms whether or not the coupon benefit is applied to the product included in the order information. At this time, the first control unit 11 refers to the order information and the coupon D132.

For example, it is assumed that the order information includes the hamburger set, the ginger-fried ginger set, and the french fries as the ordered products, and the coupon ID "C001" is indicated. In this case, the second control unit 21 determines that the coupon benefit can be applied to French fries. However, since the application condition is associated with the coupon ID "C001", the first control unit 11 further confirms whether or not the application condition is satisfied. The applicable condition is from 16:00 to 18:00. Therefore, if the order date and time indicated in the order information is between 16:00 and 18:00, it is determined that the coupon privilege is applied to the French fries. In this way, the first control unit 11 refers to the product associated with the coupon ID indicated in the order information and the application conditions in the coupon DB 132 to confirm whether or not the coupon is applied.

When the coupon benefit is not applied (N in step S204), the first control unit 11 advances the process to step S208. When the coupon privilege is applied (Y in step S204), the first control unit 11 applies the coupon privilege (step S206). Specifically, the first control unit 11 identifies the coupon benefit associated with the coupon ID included in the order information in the coupon DB 132 . Then, the first control unit 11 applies the coupon benefits to the products identified as being subject to the coupon benefits among the products included in the order information. For example, if the product specified to be subject to the coupon privilege is french fries and the coupon privilege is free, the fee for the french fries is set to be free.

Next, in step S208, the first control unit 11 generates slip information. Specifically, the first control unit 11 sets the unit price registered in the product DB 131 as the price for each product included in the order information. Further, the first control unit 11 sets the amount of money to which the coupon privilege is applied as the discount amount for products to which the coupon privilege is applied. Then, the sum of these charges is calculated as the billed amount. Then, when the coupon privilege is not applied, the first control unit 11 generates slip information indicating the unit price of each product, the discount amount according to the privilege, and the total billed amount. When the coupon is applied, the first control unit 11 generates slip information indicating the discount amount according to the benefit and the total billed amount reflecting the discount. Next, in step S210, the first control unit 11 transmits the slip information to the accounting device 30, and prints the slip information on a printer (not shown). This completes the coupon management process. Accounting processing is performed in the accounting device 30 according to the slip information.

For example, suppose that the order items are a hamburger set, a ginger-fried ginger set, and french fries, and a coupon "C001" is applied. In this case, in step S208, 1,000 yen is set as the price of the hamburger set and the ginger-grilled set, and 300 yen is set as the price of the french fries. be.

A specific example of the coupon management process will be described below. For example, assume that the ordered products are a hamburger set and coffee, and the coupon ID is "C002". In this case, in step S204, in the coupon DB 132, the application condition associated with C002 is confirmed. If the order date and time indicated in the order information is between 16:00 and 18:00, it is determined that the coupon benefit is applicable, and the coffee price is set to 50% discount.

It is also assumed that the ordered item is the Morning A set included in the morning menu table and the coupon ID is "C003". In this case, it is determined that the coupon privilege is applicable, and a 10% discount amount is set for the morning A set.

Coupon ID "C001" is associated with an application condition of "one coupon per group". Therefore, even if the order information includes a plurality of french fries, only one french fries is eligible for the coupon benefit. Also, as an applicable condition, if an applicable condition corresponding to the number of customers included in one group is associated, such as free fries for up to five people per group, fries for the number of people will be free of charge, and if more units are ordered, the free shipping will not apply to the additional units.

Coupon ID "C002" is associated with an application condition of "16:00 to 18:00". Therefore, even if the order information includes products of the category "drink", if the order date and time do not meet the application conditions, such as 20:00, the coupon benefits are not applied.

As described above, in the order system 1 of the present embodiment, the coupon, the product to which the coupon privilege is applied, and the coupon privilege are associated in the coupon DB 132 . Thereby, the coupon benefits can be applied automatically.

The above embodiment is an example for carrying out the present invention, and various other embodiments can be adopted. That is, various modifications and changes described below are possible without departing from the gist of the invention described in the claims.

As such a first modification, instead of the management device of the present embodiment, a coupon management system including a device having a product DB and a coupon DB and a device for executing coupon management processing may be provided. In this way, it may be realized as a coupon management system in which a plurality of devices perform the processing of the management device.

As a second modification, the management device of the ordering system may manage the use of coupons at each of a plurality of shops. In this case, the order system includes an order terminal device used at each store and a checkout device used at each store. In the coupon DB 1321 of the management device in this case, as shown in FIG. 6, the coupon ID is further associated with the shop ID. Thereby, the management device can manage the application target of the coupon privilege on a store-by-store basis.

For example, as shown in the first row, when the coupon ID "C001" is associated with all stores, the application of the coupon with the coupon ID "001" is valid for all stores. On the other hand, the coupon ID "C002" is associated only with the shop ID "R001", so the coupon with the coupon ID "C002" is valid only at the shop with the shop ID "R001". Coupon ID "C003" is associated with store IDs "R001 to R010". This indicates that the coupon with the coupon ID "C003" is valid at a plurality of stores specified by the store IDs "R001 to R010".

As a third modification, the display unit 23 of the order terminal device 20 may display a coupon button 410 on the menu screen 400 as shown in FIG. Then, the waiter selects the coupon button 410 when the coupon is presented by the customer. When the coupon button 410 is selected, each coupon registered in the coupon DB 132 is displayed. When the customer selects the type of coupon, the second control unit 21 displays a list of all products associated with the selected type of coupon. For example, in the time zone of 16:00 to 18:00, when the "C002" coupon is presented, the second control unit 21 displays a list of all drinks belonging to the "G009" drink category on the display unit 23. .

As a fourth modification, the timing of acquiring the coupon ID is not limited to the embodiment. As another example, the coupon may be presented at checkout on checkout device 30 . In this case, when ordering, order information is transmitted from the order terminal device 20 to the management device 10 with no coupon. Then, the management device 10 generates slip information to which the coupon benefit is not applied and transmits it to the accounting device 30 . When the customer presents a coupon at the time of checkout, the coupon ID is input by an input unit (not shown) of checkout device 30 and sent to management device 10 . By referring to the coupon ID and the coupon DB 132, the management device 10 performs discounts, discounts, and free settlements for products to which coupon benefits are applied, and generates new slip information.

As another example, as described in the third modification, the checkout device 30 displays a coupon button on the display unit (not shown) of the checkout device 30, and when a coupon to be used is selected, , a list of products to which coupon benefits can be applied may be displayed. In this case, when a product to be applied is selected from the listed products, the coupon benefit is applied to the selected product.

As a fifth modified example, menus to which coupons are applied are not limited to those related to products offered at restaurants. As another example, it may be applied to menus related to products other than products offered at restaurants. Also, the menu to which the coupon is applied is not limited to products, and may be related to services such as karaoke and massage services. Further, the application target of the coupon is not limited to the menu, and may be, for example, options such as hamburger sauce. Also, it is possible to set a menu group to be subjected to product analysis as a coupon application target.

As a sixth modification, the coupon management method is not limited to the embodiment. For example, coupons may be managed in association with store visit information. Thereby, the coupon benefit can be applied to the entire transaction corresponding to the table ID corresponding to the store visit information.

As a seventh variation, the coupon may be applied automatically. For example, when a campaign benefit is uniformly applied to customers who visit the store during a certain period of time, the benefit can be automatically applied based on the date and time of the store visit.

As an eighth modified example, the number of times the coupon benefit can be applied may be unlimited or limited.

As a ninth modification, the customer may place an order by directly operating the ordering device instead of using the ordering terminal device 20 by the customer. In this case, the coupon can be used by reading the two-dimensional code or inputting the code information.

Furthermore, the method of the present invention can be applied as a program or method. In addition, it can be changed as appropriate such that part of it is software and part of it is hardware. Furthermore, the invention is established as a recording medium for a program for controlling the system. Of course, the program recording medium may be a magnetic recording medium, a semiconductor memory, or any other recording medium that will be developed in the future.

1 order system 10 management device 11 first control unit 12 first communication unit 13 recording medium 20 order terminal device 21 second control unit 22 second communication unit 23 display unit 24 input unit 30 accounting device 131 product DB
132 Coupon DB

Claims (6)

a control unit;
a storage unit;
with
The storage unit
a menu storage unit that stores a plurality of menu items in association with categories of the menu items and types of menu tables containing the menu items ;
Any one of the menu items, categories, and menu table types to which each of a plurality of coupons is applied, and coupon benefits provided according to the coupon are stored in association with coupon identification information of the coupon. including a coupon storage unit;
The control unit
obtaining the order menu item ordered by the customer and the coupon identification information of the coupon used by the customer;
When the coupon storage unit is referred to, and any one of the order menu item, the category, and the menu table is associated with the coupon identification information of the usage coupon in the coupon storage unit, the usage coupon applying the coupon privilege associated with the coupon identification information of the order menu item to the order menu item. The coupon storage unit further stores conditions for applying the coupon benefits in association with the coupon benefits,
2. The coupon management system according to claim 1, wherein said control unit applies said coupon privilege associated with said use coupon when said order by said user satisfies said application condition. the coupon benefits are discounts, discounts or free offers for the menu items;
2. The coupon management system according to claim 1, wherein said control unit sets a discount amount or no charge for said order menu item when said order menu item is associated with said use coupon. 4. The coupon management system according to claim 3 , wherein said coupon storage unit stores one coupon identification information in association with one or more menu items. 3. The coupon management system according to claim 2 , wherein said application conditions include at least one of an order time zone to which said coupon privilege is applied, the number of said customers, and an upper limit of menu item quantity. A program executed by a coupon management device,
The storage unit of the coupon management device,
a menu storage unit that stores a plurality of menu items in association with categories of the menu items and types of menu tables containing the menu items;
Any one of the menu items, categories, and menu table types to which each of a plurality of coupons is applied, and coupon benefits provided according to the coupon are stored in association with coupon identification information of the coupon. including a coupon storage unit;
an acquisition step of acquiring coupon identification information of a coupon used by a customer and an order menu item ordered by the customer;
When the coupon storage unit is referred to, and any one of the order menu item, the category, and the menu table is associated with the coupon identification information of the usage coupon in the coupon storage unit, the usage coupon and an applying step of applying the coupon privilege associated with the coupon identification information of to the order menu item.

Images