JP2003058760A - Reservation system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a reservation system in which a reservation can be made at a required timing easily for a client and the reservation can be managed for reducing idle time without trouble for a service provider side. SOLUTION: In the system provided with a data storage part 2, a data processing part 1 and a client terminal 3 connectable through communication to this data processing part, the data storage part 2 stores a reservation table 5 of a service and client data on the client who utilizes this service, and the reservation table 5 is equipped with a service providing unit time frame and a reservation condition field corresponding to this unit time frame. In the data processing part, an idle time frame within a preset period on the reservation table is specified, a mail transmitting destination client is specified on the basis of the client data of the client, mail presenting the idle time frame is transmitted to the client terminal of this transmitting destination client and further, a function is provided for setting the temporary reservation of the transmitting destination client to the specified idle time frame.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a reservation system for managing customer reservations for receiving services such as a beauty salon and a driving school.

[0002]

2. Description of the Related Art Conventionally, there are industries such as beauty salons, which mainly provide services mainly to reserved customers. In order to receive such a service, a customer calls or goes to a store to make a reservation. For example, in the case of a beauty salon, the intervals between visits are generally fixed, but it is rare to make the next reservation after returning to the service, and if you want to go next, call yourself from the store. I often make reservations.

[0003]

In order to make a reservation as described above, the customer must take action to make a reservation. Therefore, if the customer is busy and misses the time to contact the reservation,
Sometimes there was a delay in coming to the store. In this way, it is a loss even for the store side that the customer visit interval becomes long due to the trouble of making a reservation. Also, as the store side,
Relying solely on contact from customers may lead to reservations being flooded with reservations, which can lead to free time. It is a loss to leave free time as it is. for that reason,
It is conceivable to make a call or send an e-mail in order to inform the customer that there is free time and encourage the customer to visit the store during that time.

However, in order to make such contact,
The clerk must check the reservation table and check the customer's visit history. The history of visits to the store is confirmed in order to select a customer who has a high probability of deciding to visit the store when an invitation phone is called. Then, in response to the customer's reply, the reservation table must be filled in. In other words, contacting customers to reduce free time and accepting reservations are
It was a laborious task. An object of the present invention is to provide a reservation system that allows a customer to easily make a reservation at a necessary timing, and also allows a service provider to realize reservation management for reducing a vacant time without trouble. That is.

[0005]

According to a first aspect of the present invention, a data storage unit, a data processing unit, and a customer terminal connectable to the data processing unit via communication are provided. , A service reservation table and customer data of customers who have received this service are stored, and the reservation table includes a service providing unit time frame and a reservation status column corresponding to this unit time frame, and the data processing In the reservation table, the department specifies an empty time frame within a preset period, and also specifies a mail destination customer based on the customer data of the customer, and the empty terminal is set in the customer terminal of the destination customer. It is characterized in that it has a function of transmitting an e-mail showing a time frame and setting a temporary reservation for the destination customer in the specified empty time frame.

A second invention is provided with a data storage unit, a data processing unit, and a customer terminal connectable to the data processing unit via communication, and the data storage unit includes a service reservation table and a service reservation table. , Customer data of customers who have received this service are stored, and the above-mentioned reservation table is a service providing unit time frame,
A reservation status column corresponding to this unit time frame is provided, and the data processing unit specifies a vacant time within a preset period in the reservation table, and specifies the above based on the customer data of the customer. One customer with a high probability of booking to the available time frame is identified, an email is sent to the customer terminal of the identified customer requesting a reservation, and the sending customer makes a temporary reservation in the identified available time frame. The feature is that it has a setting function.

A third aspect of the present invention is characterized in that the data processing unit has a function of changing a provisional reservation in the reservation status column of the reservation table to a real reservation when a reservation signal is input from the customer terminal.

According to a fourth aspect of the present invention, the data processing section sends a mail to a specific customer to make a reservation for a specific free time frame, and at the same time, in the reservation status column corresponding to the specific free time frame in the reservation table. When the customer ID of the specific customer, the temporary reservation flag, and the temporary reservation expiration date are input, and the reservation signal is not input from the customer terminal of the specific customer within the temporary reservation expiration date, the data processing unit Changes the temporary reservation flag in the specific reservation status column to a free time flag, and when a reservation signal is input from the specific customer within the temporary reservation expiration date, the temporary reservation flag in the specific reservation status column It is characterized in that it has a function of changing to the reservation flag.

According to a fifth aspect of the invention, the data processing section sets a home page for each mail to the specified customer, and sets the U
The RL is stored in the data storage unit in association with the specific unit time frame corresponding to the email, and when the customer terminal accesses the home page, the unit time frame corresponding to the URL and the reservation status column are displayed. It is characterized by having a function to specify.

According to a sixth aspect of the present invention, the data storage unit stores the customer's mail address, and when the data processing unit receives the mail from the customer terminal, it identifies the customer from the sender's mail address. , It is characterized in that it has a function of specifying a unit time frame and a reservation status column corresponding to the customer.

According to a seventh aspect of the invention, the data processing unit sets a reservation number for each mail to the specified customer, associates the reservation number with a specific unit time frame corresponding to the mail, and stores the data. It is characterized in that it has a function of storing it in the storage unit and specifying the time frame and the reservation status column corresponding to the reservation number when the reservation number is input from the customer terminal.

[0012]

1 to 7 show a first embodiment of the present invention. Here, a case where the reservation system of the present invention is used for a reservation at a beauty salon will be described. This system includes a reservation management computer C having a data processing unit 1 and a data storage unit 2, and a customer terminal 3 connected to the reservation management computer C via a communication network N such as the Internet. The reservation management computer C is a computer installed in a beauty salon, and the customer terminal 3 is a terminal used by a customer who has visited the beauty salon.

The data storage unit 2 stores customer data and a reservation table. The customer data corresponds to the customer's visit date. Also,
The reservation table is the reservation table 5 shown in FIG. 2, and includes a unit time frame display field 6 for service provision and a reservation status field 7 corresponding thereto. Here, three reservation status columns 7 are provided, but this is because there are three hairdressers and they can simultaneously provide services to three customers. Reservation status column 7
May be provided separately for each hairdresser in charge, or may be provided for each seat.

The reservation table 5 is set for all business days and is stored in the data storage unit 2. Here, as an example, the reservation table 5 is July 7th as of June 30th. The reservation status of In addition, the reservation status column 7 is
Reservation flag column 8, customer ID column 9, temporary reservation expiration date column 1
It consists of 0 and. The reservation flags include "0" to "3", which are a free time flag "0", a temporary reservation flag "1", a real reservation flag "2", and an automatic reservation impossible flag "3", respectively.

The vacant time flag "0" is a flag which is set in a vacant unit time frame with no reservation. The provisional reservation flag “1” will be described later in detail. When sending a mail requesting a reservation to a specific customer by designating a specific free time, wait for a reply from the customer. It is a flag that is set during the period. This reservation flag “2” is a flag that is set when a reservation is made by contacting the customer.

Further, the automatic reservation prohibition flag "3" is a flag which is set in a unit time frame in which the system decides not to accept the reservation. For example, the non-reservation flag "3" is set during break time, preparation time, and the like. Also,
Although it is possible not to register the reservation table for holidays from the beginning, the reservation table for all schedules should be registered, and on the holidays, the reservation impossible flag " 3 ”may be input in advance. Further, the non-reservation flag "3" can be set to a unit time frame in which a free customer who has not made a reservation can easily visit the store. For customers who do not have a reservation, you can open a specific unit time slot and add new customers to that unit time slot.

A procedure for accepting a reservation from a customer using the reservation table 5 as described above will be described below. The processing described below is performed by the data processing unit 1 on a regular basis.
For example, it is automatically performed at a fixed time every day.
First, as shown in FIG. 3A, the processing day is set to A.
Here, it is June 30th. And from the processing day A,
The reservation acceptance period is from the time point B after the period L1 to the time point C after the period L2. The above periods L1 and L2
Is a value set in advance, but in the first embodiment, the period L1 = 4 days and the period L2 = 4 days. That is, as of June 30, the reservation acceptance period is four days from July 4th to July 7th. Further, the temporary reservation valid period after setting the temporary reservation is d, and the temporary reservation valid period is D.

On the next day, that is, on July 1, as shown in FIG. 3B, the processing date A is A ', the reservation acceptance start date B is B', and the reservation acceptance end date C is C. ', And the temporary reservation expiration date D is moved to D'for one day each.
In this way, each day will move from day to day.
The reservation acceptance period is an acceptance period for automatic reservations using this system. Further, the automatic reservation does not include a reservation directly accepted by a clerk through a telephone call or a customer visit. Therefore, the reservation directly accepted by the clerk can be accepted regardless of the reservation acceptance period. However, when the clerk accepts the reservation, the reservation data is manually input into the reservation table 5 of this system. At this time, the data processing unit 1
By providing the function of identifying the telephone number that has been called and identifying the customer from this telephone number, the clerk who answers the telephone can identify the customer without asking for the customer name.

The reservation system of the first embodiment is configured by executing two processes, a temporary reservation process for setting a temporary reservation and a main reservation process for accepting a main reservation. First, the temporary reservation process will be described according to the flow of FIG. Note that this process is a process executed by the data processing unit 1 at the time point A. In step 1, the data processing unit 1 specifies the reservation acceptance period from time points B to C, and in step 2, checks the reservation flags of the reservation table 5 within the above period one by one. In step 3,
The type of the flag is specified. Here, if the flag is the provisional reservation flag “1”, the process proceeds to step 4, and if the free time flag is “0”, the process proceeds to step 6. If the other flag is “2” or “3”, the process proceeds to step 11.

If the temporary reservation flag is "1", it is determined in step 4 whether or not the current time point A has passed the temporary reservation expiration date. If the temporary reservation expiration date has passed, the process proceeds to step 5, where the temporary reservation flag “1” is changed to the free time flag “0” and the customer ID is erased. In other words, since the temporary reservation expiration date of the temporary reservation has expired, the temporary reservation is invalidated and made available. Then, the process proceeds to step 6. On the other hand, if the provisional reservation provisional reservation expiration date has not passed in step 4 above, the flag is left as it is and the process proceeds to step 11.

When the reservation flag is the free time flag "0" in step 3 and when the free time flag "0" is set in step 5, the process proceeds to step 6. In step 6, the customer X having a high probability of coming to the store is extracted in the unit time frame. There are various possible extraction methods. For example, the probability of coming to the store on each day of the week and the probability of coming to the store on each unit time frame are calculated from the customer's visit history, and the probability of coming to the store on the day of the week of the empty unit time frame specified in step 6 and the unit time frame The customer X having the highest sum of the past store visit probabilities corresponding to the above can be specified as the customer having the highest store visit probability.

In step 7, the free time flag "0" of the unit time frame is changed to the temporary reservation flag "1", and the ID of the customer X is entered in the customer ID column 9. Step 8
Then, set the temporary reservation expiration date. The temporary reservation expiration date is
The time point D in FIG. 3 is calculated based on the preset period d. Here, since the period d is 3 days, it is July 3 after 3 days as of June 30.

For example, let us consider a case where a process corresponding to the reservation status column 7a of the person in charge in the reservation table 5 shown in FIG. 2 is performed corresponding to 15:00 to 16:00. Although the vacant time flag “0” is set in the reservation status column 7a, provisional reservation is set for this vacant unit time frame in the processes of steps 1 to 8. That is, the reservation flag column 8 of the reservation status column 7a of the reservation table
Is set to the temporary reservation flag “1”, the customer ID column 9 is the ID of the customer X, and the temporary reservation expiration date column 10 is July 3
The day is set.

When the temporary reservation is set in this way, in step 10, the customer X is sent a mail as shown in FIG. The content of the e-mail is "15:00 to 1 on July 7th.
I can make a reservation at 6:00. What should I do? It is the purpose. As shown in FIG. 5, this sent mail is sent together with the reservation button 11 and displayed on the customer terminal 3. When the customer receives the reservation button 11 and clicks the reservation button 11, a reply mail creation screen is displayed so that the customer can easily send the reservation intention. At this time, the data processing unit 1 so that the reservation number is returned from the customer terminal 3.
Reserves a reservation number for each email and sends it to the customer terminal 3.

In step 10, the data processing unit 1
The data storage unit 2 stores the mail transmission data. The transmission data includes a unit time frame in which the temporary reservation is set and a reservation number for specifying the customer ID. In step 11, it is determined whether or not all the flags in the reservation acceptance periods B to C have been confirmed. If there are still unconfirmed flags, the process returns to step 2 and the above steps are repeated. When all the flags have been confirmed, the process proceeds to step 12, and the temporary reservation process at time A (June 30) ends.

Next, how to make a real reservation will be described with reference to the flowchart of FIG. The main reservation process is performed at any time when the reservation mail from the customer terminal 3 is received. First, when a mail from the customer Y is received in step 101, the reservation number included in this mail is recognized in step 102. This reservation number is the number that was previously given when the mail was sent from the management reservation management computer C side to the customer Y. Then, when the customer returns a reply mail, the customer will be returned about the mail. Therefore, if this reservation number is recognized, it is possible to specify which customer has made a reservation in which unit time frame on which day.

However, when the customer makes a real reservation from a terminal other than the terminal that receives the mail from the data processing unit 1, if the customer does not manually input the reservation number and then sends the reservation mail, The reservation number does not reach the data processing unit 2. Therefore, when using a different terminal, a message saying that you should enter the reservation number and then send the e-mail is displayed with the e-mail attached.

In step 103, the reservation flag in the reservation status column 7 of the specified unit time frame is checked. The customer who sends the mail is the customer who has sent the mail after the data processing unit 1 of the reservation management computer C sets the temporary reservation. Therefore, normally, the provisional reservation flag “1” should be set in the reservation flag field 8 of the reservation status field 7. However, the reply mail from the customer Y is
When the transmission is made after the temporary reservation expiration date has passed, the temporary reservation flag “1” may be changed to the free time flag “0”. Also, once the free time flag is "0".
There may be a case where another customer has made a reservation after the standing of, and the main reservation flag “2” is standing. Therefore, in this step 103, the reservation flag is confirmed.

If the reservation flag is the temporary reservation flag "1" or the free time flag "0" in step 103, the process proceeds to step 104, and the flag "1" or "0" is set to the main reservation flag "2". change. And step 10
At 5, the customer ID is entered in the customer ID column 8. However, if the provisional reservation flag “1” is set in step 103, the customer ID has already been entered, so the customer ID
Does not need to be input again. Then, the process proceeds to step 107, and this reservation process ends.

On the other hand, if the reservation flag is the main reservation flag “2” or the automatic reservation impossible flag “3” in step 103, the process proceeds to step 106. In step 106,
The reservation process is terminated by notifying that the reservation cannot be received due to another customer's reservation already made or due to other circumstances (step 107).

As described above, since a temporary reservation setting is made for a specific customer, and an e-mail prompting visit to the customer is sent, it is possible that a plurality of customers make reservations in the same unit time frame. There is no such thing. Moreover, since an invitation email is sent to customers who have a high probability of coming to the store based on the visitor customer data, there is a high possibility that a reservation will be made, email transmission will not be wasted, and free time will be available. It is rarely left alone. It should be noted that here, the processing is described once a day, but the processing interval may be appropriately set according to the type of service, the temporary reservation expiration date d, and the like. The reservation acceptance period L2, the temporary reservation valid period d, the reservation start time, etc. can be freely set depending on the type of service.

Further, in the mail sent to the customer, as shown in FIG.
As shown in FIG. 6, if the special charge is shown, such as "Only the customer is charged a special 10% discount in this time zone", the higher the probability of reservation becomes. In particular, it is expected that the probability of coming to the store will be increased by presenting the above-mentioned special charge in the unit time frame where the number of stores is small. In addition, cancellation of this reservation will be accepted by phone or on a website other than this system. If the reservation is canceled, the data is manually input into the reservation table. That is, the corresponding reservation status column 7 of the reservation table 5 is changed to a free status.

In the first embodiment, the unit time frame in which the free time flag “0” is set is specified from the reservation table 5, and the highest probability of coming to the store is based on the unit time frame. Although the customer is extracted and the temporary reservation is set, the method of identifying the temporary reservation customer is not limited to this. For example, from the store history of customer data, predict the next store visit date, and based on the person whose estimated store visit date is approaching, extract multiple free times that are likely to come to that store,
You may make it present those times simultaneously. In that case, as shown in FIG. 7, the reservation button 12, 13, 14 is attached to the mail to the customer for each unit time frame and transmitted. In this case, the reservation table 5 has a plurality of unit time frames,
The same customer ID and temporary reservation flag “1” are set,
When the customer makes a reservation by clicking one of the reservation buttons, the data processing unit 1 changes the provisional reservation flag “1” of the unit time frame not reserved to the free time flag “0”. I am trying to do it.

It is also possible to attach a URL of a specific home page to an e-mail to be sent to the customer, display the URL, and display the URL so that the customer can access the specific home page by clicking on it. it can. Then, if the above homepage is made compatible with the temporary reservation set when sending the e-mail, it is possible to identify which homepage has been accessed by the customer, and which unit time frame the main reservation corresponding to the temporary reservation has been made. it can. As described above, when a specific URL is attached to an e-mail to be transmitted, the URLs corresponding to the reservation buttons 11 to 14 shown in FIGS. 5 and 7 are attached and the reservation button is clicked to automatically Alternatively, a specific URL can be accessed.

Further, if the mail address of the customer who is the destination when sending the mail from the data processing unit 1 is stored in the data storage unit 2, the provisional reservation can be made by the address of the reply mail from the customer. Customers can be specified. In this way, if the customer can be specified, the time frame for which the temporary reservation is set can be specified. However, in this case,
The address of the customer terminal 3 used by the customer to apply for this reservation must be the address registered in the data storage unit 2. It should be noted that all signals transmitted to the data processing unit 1 when making a real reservation from the user terminal 3 are included in the reservation signal of the present invention. That is, by clicking the reservation button, the log when the data processing unit 1 is accessed, the reservation number, the reservation application mail, and the like also correspond to the reservation signal.

When the store actually arrives, the store side inputs the information into the reservation management computer C,
The store history is stored in the data storage unit 2 as customer data. However, it is also possible to register the customer visit data by setting the visit flag “4” in the reservation flag column 8 of the reservation table 5, for example. For customers who make a reservation by using this system, it is only necessary to change the flag from "2" to "4", and in the case of a customer who does not make a reservation, enter the customer ID together with the shop flag "4". You can do it. By doing so, the reservation table 5 can be stored as it is as the store visit history data.

The second embodiment shown in FIG. 8 is different from the first embodiment in that a plurality of data storage units 2 are connected to the data processing unit 1 via a communication network N such as the Internet. The data processing unit 1 is installed in the reservation management center and each data storage unit is installed in each store. That is, in each store, the data storage unit 2 stores the customer data of the store and a reservation table. Then, the reservation management center side uses the data on each store side to perform processing on the reservation table and mail transmission. In this way, one data processing unit 1
It is possible to manage reservation tables for multiple stores.

However, the customer data and reservation table of each store are not stored only in the data storage unit 2 provided on the store side, but a part of the data may be stored on the reservation management center side. I don't care. That is, the data storage units 2 may be distributed and provided in both the store and the center.

The reservation system can be used not only for beauty salons but also for providing various services. For example, it is possible to handle any service that requires a reservation, such as renting out a driving school or a sports facility such as a tennis court, or a dentist. In particular, even if the user did not make a reservation immediately after receiving the service last time, it is easy for the customer to make a reservation if an email notifying the free time comes. Furthermore, this system is not only for customers to come to the store to receive services, but also for home etc.
It can also be applied to industries that provide services on a business trip. With such a reservation system, the service provider side can automatically perform e-mail delivery for attracting customers and reservation reception, so that the labor can be saved.

[0040]

According to the first and second aspects of the present invention, since the mail indicating the specific free time is sent to the customer terminal, it is easy to make a reservation for the time frame. The loss that the free time is left as it is is reduced. As the service provider side can automatically perform the mail delivery and the reservation acceptance process, it is not necessary to take the trouble of those tasks. Further, the customer side does not have to take any action for reservation because he / she delivers an email showing the available time. Therefore, you can easily make a reservation. Therefore, it is possible to avoid making a reservation and missing the timing of coming to the store. Furthermore, by sending an email to the customer and setting a temporary reservation, it is possible to prevent reservations from being made by a plurality of customers at the same time.

In particular, according to the second aspect of the present invention, since a mail requesting a reservation for a specific vacant time is sent to a customer who has a high probability of coming to the store, it is easier to make a reservation for the unit time frame. Therefore, the amount of wasted mail is reduced, and the loss that the idle time is left as it is is further reduced. According to the third invention, the main reservation can be automatically set. According to the fourth aspect, by setting the temporary reservation expiration date, when the reservation signal is not input forever, the temporary reservation is canceled and reservations from other customers can be accepted.

According to the fifth to seventh inventions, the data processing section can easily specify the customer who has set the temporary reservation. In particular,
If the reservation number is set as in the seventh invention, the customer can
Even when sending a reservation mail from a terminal different from the terminal that received the mail from the data processing unit, if the reservation number is sent, the data processing unit automatically sets the time frame and customer ID for which this reservation should be set. Can be specified.

[Brief description of drawings]

FIG. 1 is a configuration diagram of a first embodiment.

FIG. 2 is a reservation table for one day according to the first embodiment.

FIG. 3 is a diagram illustrating each date of the first embodiment.

FIG. 4 is a flowchart showing a procedure of temporary reservation processing in the first embodiment.

FIG. 5 is an example of a mail to be transmitted according to the first embodiment.

FIG. 6 is a flow chart showing a procedure for accepting a main reservation according to the first embodiment.

FIG. 7 is an example of an email sent from the reservation management computer of the first embodiment to a customer.

FIG. 8 is a system diagram of a second embodiment.

[Explanation of symbols]

C Reservation management computer 1 Data processing unit 2 Data storage 3 Customer terminals 5 reservation table 6 unit time frame display column 7 Reservation status column 8 Reserved flag column N communication net

Claims (7)

[Claims] 1. A data storage unit, a data processing unit, and a customer terminal connectable to the data processing unit via communication are provided, and the data storage unit includes a service reservation table.
The customer data of the customer who has received this service is stored, and the reservation table includes a service providing unit time frame and a reservation status column corresponding to this unit time frame. Among them, the free time frame within the preset period is specified, the mail destination customer is specified based on the customer data of the customer, and the mail showing the free time frame is displayed on the customer terminal of the destination customer. A reservation system having a function of transmitting and further setting a tentative reservation of the destination customer in the specified free time frame. 2. A data storage unit, a data processing unit, and a customer terminal connectable to the data processing unit via communication. The data storage unit includes a service reservation table.
The customer data of the customer who has received this service is stored, and the reservation table includes a service providing unit time frame and a reservation status column corresponding to this unit time frame. Of these, the free time within the preset period is specified, and based on the customer data of the customer, one customer with a high probability of reservation for the specific free time frame is specified,
A reservation system having a function of transmitting an email requesting a reservation to a customer terminal of the specified customer, and further setting a temporary reservation by the sending customer in the specified free time frame. 3. The reservation system according to claim 1, wherein the data processing unit has a function of changing a tentative reservation in the reservation status column of the reservation table to a main reservation when a reservation signal is input from the customer terminal. . 4. The data processing unit sends an email urging a specific customer to make a reservation for a specific free time frame, and in a reservation status column corresponding to the specific free time frame of the reservation table,
When the customer ID of the specific customer, the temporary reservation flag, and the temporary reservation expiration date are input and no reservation signal is input from the customer terminal of the specific customer within the temporary reservation expiration date, the data processing unit , The temporary reservation flag in the specific reservation status column is changed to a free time flag, and when the reservation signal is input from the specific customer within the temporary reservation expiration date, the temporary reservation flag in the specific reservation status column is changed. The reservation system according to claim 1, further comprising a function of changing the reservation flag. 5. The data processing unit sets a home page for each mail to the specified customer, stores the URL in the data storage unit in association with a specific unit time frame corresponding to the mail, The reservation system according to claim 1, further comprising a function of specifying a unit time frame and a reservation status column corresponding to the URL when the home page is accessed from a terminal. 6. The data storage unit stores the customer's mail address, and when the data processing unit receives the mail from the customer terminal, the data processing unit identifies the customer from the sender's mail address and assigns it to the customer. The reservation system according to claim 1, further comprising a function of specifying a corresponding unit time frame and a reservation status column. 7. The data processing unit sets a reservation number for each mail to the specified customer, and stores the reservation number in the data storage unit in association with the specific unit time frame corresponding to the mail. The reservation system according to claim 1, further comprising a function of specifying a time frame and a reservation status column corresponding to the reservation number when the reservation number is input from the customer terminal.