JP6990286B1 - Purchase history acquisition system and method, and customer database update system and method using them - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a purchase history acquisition system in which the labor of a salesperson is reduced.
A purchase history acquisition system 1 identifies a vehicle number of a vehicle license plate from a camera that captures the license plate of the vehicle and an image captured by the camera, and outputs shooting data including the vehicle number and the shooting date and time. Specify the possible number identification unit 62, at least the sold goods, the sales date and time, the payment terminal that can output the sales data including the sales amount, and the sales data of the sales date and time within the predetermined time from the shooting date and time of a certain shooting data. It is provided with a data matching unit 64 that records the vehicle number of a certain shooting data and the specified sales data in a purchase history database.
[Selection diagram] Fig. 1

Description

The present invention relates to a purchase history acquisition system and method, and a customer database update system and method using them.

According to Patent Document 1, a vehicle data acquisition system for acquiring vehicle data of an automobile visiting a gas station is known.

Patent No. 6655317

In Patent Document 1, the camera takes a picture when the button for selecting the oil type is pressed. That is, it seems that there is a vehicle in the vicinity of the POS terminal for payment, and it is premised that this vehicle is photographed by a camera.
However, the services provided by the service station include the sale of consumables such as wipers and oil, as well as car wash and vehicle inspection services. Of these operations, consumables are sold and vehicle inspection services are settled at the POS terminal in the store, so there is not necessarily a vehicle near the POS terminal. In such a case, the salesperson of the service station needs to acquire the vehicle information from the customer and input the obtained information to the vehicle information acquisition system. Therefore, there is room for improvement in Patent Document 1 from the viewpoint of reducing the labor of sales staff.

Therefore, the present invention provides a purchase history acquisition system and a purchase history acquisition method in which the labor of a salesperson is further reduced.

In order to achieve the above object, according to the present invention,
At service stations that provide services such as fuel oil and wipers, and services such as car washing and vehicle inspection.
It is a purchase history acquisition system that updates the purchase history database in which sales data including sales goods or services, sales date and time, and sales amount are recorded in association with the vehicle number.
A camera that shoots the license plate of the vehicle,
A number specifying unit capable of specifying the vehicle number on the license plate of the vehicle from the image taken by the camera and outputting shooting data including the specified vehicle number and the shooting date / time or the specific date / time.
A payment terminal capable of making payments when a customer who visits a store purchases a product or service and outputting at least the sales goods or the sales service, the sales date and time, and sales data including the sales amount.
The sales data of the sales date and time within a predetermined time from the shooting date and time of a certain shooting data or the specific date and time is specified, and the vehicle number of the shooting data and the specified sales data are linked to the purchase history database. The data matching part to record and
A purchase history acquisition system is provided.

In the acquisition system described above,
The camera is installed in each payment terminal.
The camera can output the shooting data including the camera identification information that can identify the corresponding payment terminal.
The payment terminal can output terminal information that can identify each of them together with the sales data.
The data matching unit may associate the vehicle number with the sales data based on the shooting date / time or the specific date / time, the sales date / time, the camera identification information, and the terminal information.

In the acquisition system described above,
The camera and the payment terminal may be provided at least in a refueling lane and a car wash machine.

In order to achieve the above object, according to the present invention,
It is an update system of a customer database including a vehicle owner name, vehicle data, and sales data, which is created based on the purchase history database updated by the purchase history acquisition system.
An external data reading unit that reads the vehicle data including the vehicle owner and vehicle inspection information and an external database including the vehicle number,
When the vehicle number not recorded in the purchase history database exists in the external database read by the external data reading unit, the vehicle number and the vehicle data not recorded in the purchase history database are stored in the purchase history database. A customer database update system is provided that has an external data addition unit to be added to.

In order to achieve the above object, according to the present invention,
At service stations that provide services such as fuel oil and wipers, and services such as car washing and vehicle inspection.
It is a purchase history acquisition method using a purchase history acquisition system that updates the purchase history database in which sales data including sales goods or services, sales date and time, and sales amount are recorded in association with the vehicle number.
The acquisition system includes a memory for recording computer-readable instructions and an information processing device for executing the computer-readable instructions.
The purchase history acquisition method is applied to the acquisition system.
The vehicle number of the vehicle is specified from the image taken by the camera that captures the license plate of the vehicle, and the shooting data including the specified vehicle number and the shooting date / time or the specific date / time is output.
When a customer who visits a store purchases a product or service, at least the sales item or the sales service, the sales date and time, and sales data including the sales amount are output.
The sales data of the sales date and time within a predetermined time from the shooting date and time of a certain shooting data or the specified date and time is specified, and the vehicle number of the shooting data and the specified sales data are linked to the purchase history database. A method of acquiring purchase history to be recorded is provided.

In order to achieve the above object, according to the present invention,
It is an update method using an update system of a vehicle owner name, vehicle data, and a customer database including the sales data, which is created based on the purchase history database updated by the above purchase history acquisition method. hand,
The update system includes a memory for recording computer-readable instructions and an information processing device for executing the computer-readable instructions.
The update method is applied to the update system.
Load the vehicle data including the vehicle owner and vehicle inspection information and the external database including the vehicle number,
When the vehicle number not recorded in the purchase history database exists in the read external database, the vehicle number and the vehicle data not recorded in the purchase history database are added to the purchase history database. A method for updating the customer database is provided.

According to the present invention, there is provided a purchase history acquisition system and a purchase history acquisition method in which the labor of a salesperson is further reduced.

It is a block diagram of the purchase history acquisition system of this invention. Indicates the data output by the number identification unit. This is an example of a sales database. It is a flowchart of the process executed by the purchase history acquisition system. This is an example of a purchase history database. It is a block diagram of the update system of the customer database. This is an example of a customer database. This is an example of an external database. This is an example of the updated customer database.

<Purchase history acquisition system 1 and method>
FIG. 1 is a block diagram of a purchase history acquisition system 1 (hereinafter referred to as an acquisition system 1) according to an embodiment of the present invention. This acquisition system 1 is installed in a service station that sells fuel oil and the like. The acquisition system 1 automatically updates the purchase history database in which sales data including sales goods or services, sales date and time, and sales amount are recorded in association with the vehicle number (vehicle registration number).

As shown in FIG. 1, the acquisition system 1 is used in the equipment group installed in the first refueling lane 10, the equipment group installed in the second refueling lane 20, the equipment group installed in the kerosene lane 30, and the car wash lane 40. It is composed of a group of installed devices, a management server 60, and a data server 61 that records a purchase history database. The management server 60 includes a memory for recording computer-readable instructions and an information processing device for executing computer-readable instructions.

In the first refueling lane 10, fuel oil such as regular gasoline is supplied to the vehicle. A first camera 11, a first refueling machine 12, and a first POS 13 (payment terminal) are installed in the first refueling lane 10.
The first refueling machine 12 supplies fuel to the user's vehicle and counts the quantity of the supplied fuel oil. The first refueling machine 12 includes a refueling nozzle, a measuring instrument, and the like.

The first POS 13 is a device that requests the user to pay money and makes a payment according to the type and quantity of fuel oil refueled by the first refueling machine 12. The first POS 13 includes an operation unit operated by a user who refuels, a display unit that displays a payment amount, and a money receiving unit that accepts cash or a credit card.
The first POS 13 outputs sales data including the type, quantity, and settlement date and time of the supplied fuel oil. Further, in the present embodiment, the first POS 13 also includes the POSID (POS identification information) used for distinguishing from other POS in the sales data and outputs the data.

The first camera 11 photographs the license plate of the vehicle to be refueled in the first refueling lane 10. The first camera 11 outputs an image acquired by the first camera 11 together with a camera ID (camera identification information) indicating that the first camera 11 has taken a picture. The first camera 11 of the present embodiment constantly captures images and continuously outputs captured images.

In the second refueling lane 20, fuel oil is supplied in the same manner as in the first refueling lane 10. A second camera 21, a second refueling machine 22, and a second POS 23 are also installed in the second refueling lane 20 as in the first refueling machine 12. Since the configurations of the camera, the refueling machine, and the POS are the same as those of the respective devices installed in the first refueling lane 10, detailed description thereof will be omitted.

In the kerosene lane 30, kerosene is supplied to the customer. Similar to the first refueling lane 10, the kerosene lane 30 is also provided with a third camera 31, a kerosene refueling machine 32, and a third POS 33. A parking space is provided in front of the kerosene refueling machine 32, and the third camera 31 photographs the license plate of the customer's vehicle that parks in this parking space and purchases kerosene.

In the car wash lane 40, a car wash service is provided to the customer. Similar to the first refueling lane 10, the car wash lane 40 is also provided with a fourth camera 41, a car wash machine 42, and a fourth POS 43. The fourth camera 41 photographs the license plate of the vehicle entering the car wash machine 42. The fourth POS 43 makes a payment at a charge according to the car wash course set in the car wash machine 42.

The management server 60 includes a number specifying unit 62, a sales data management unit 63, and a data matching unit 64. The management server 60 is communicably connected to the first camera 11 to the fourth camera 41 and the first POS 13 to the fourth POS 43. These connections may be wired connections or wireless connections.

The number specifying unit 62 identifies the vehicle number of the vehicle number plate from the images taken by the first camera 11 to the fourth camera 41, and outputs the shooting data including the specified vehicle number and the shooting date / time or the specific date / time.
The number specifying unit 62 acquires image data and shooting date and time from the first camera 11 to the fourth camera 41. The number specifying unit 62 analyzes the image data and specifies the vehicle number. When a vehicle appears in the image continuously output from the first camera 11, the number specifying unit 62 identifies the vehicle number and outputs the specified vehicle number. Also, if the same vehicle continues to exist in the image or if the vehicle does not exist in the image, the vehicle number is not output.

FIG. 2 shows an example of data output by the number specifying unit 62. In the illustrated example, the number specifying unit 62 outputs the camera ID of the camera that took the image in which the vehicle number is specified, and the shooting data including the shooting date and time, together with the specified vehicle number. Although FIG. 2 is a table format of the data output by the number specifying unit 62 in the order of shooting time, the data server 61 may be configured to record the information shown in FIG. 2 as a database. ..

The sales data management unit 63 acquires sales data including sales goods or services such as fuel oil and engine oil replacement, sales date and time, and sales amount from the first POS 13 to the fourth POS 43, and based on the sales data, FIG. Output the sales database shown in.

The sales database shown in FIG. 3 is a collection of sales data acquired from each of the POS 13 to 43 in the order of sales date and time. As shown in FIG. 3, in the sales database, the POS ID indicating from which POS the sales data is acquired, the sales date and time, the slip number, the product code indicating the sales product or sales service, the quantity sold, the sales amount, and the customer are displayed. It includes the customer code that is entered when the member information is entered in the POS, and the credit card number that is entered when the customer makes a payment by credit card.

FIG. 4 is a flowchart of the process executed by the acquisition system 1. The flow shown in FIG. 4 is executed by the management server 60. After that, the management server 60 took a picture of the data in the list shown in FIG. 2 from the first camera 11 at 10:30:31 on November 16, 2020, and the vehicle number "Shinagawa ... An example of processing the data of "" will be described.

As shown in FIG. 4, the management server 60 first acquires image data and shooting data including the shooting date and time when the image data was shot from the camera (step S01). In this example, the image taken from the first camera 11 at 10:30:31 on November 16, 2020, the shooting date and time, and the camera ID are acquired. Then, the number specifying unit 62 of the management server 60 analyzes the image from the first camera 11, identifies the vehicle number "Shinagawa ...", and outputs the specified vehicle number, the shooting date and time, and the camera ID. ..

Next, sales data including the products and services sold from the POS, their quantities, and the date and time of sales are acquired (step S02). Here, it is not yet known which sales data corresponds to the specified vehicle number.

The data matching unit 64 of the management server 60 specifies the sales data of the shooting date and time of a certain shooting data or the sales time of the sales time within a predetermined time from the specific date and time from the sales data, and the sales data specified as the vehicle number of the certain shooting data. And record it in the purchase history database. In this embodiment, 420 seconds (7 minutes) is set as a predetermined time.

In this example, first, the reference date and time is 10:37:31 on November 16, 2020, which is the sum of the predetermined time and 7 minutes from 10:30:31 on November 16, 2020, which is the shooting date and time. The data matching unit 64 specifies a slip number whose sales date and time belongs between the shooting date and time and the reference date and time from the sales data output from the first POS 13 corresponding to the first camera 11. In the illustrated example, the sales of slip number P168748 are specified.

After the sales data corresponding to the vehicle number specified by the number specifying unit 62 is specified in this way, the data matching unit 64 records the vehicle number of certain shooting data and the specified sales data in the purchase history database. In this example, as shown in FIG. 5, the vehicle number "Shinagawa ..." is associated with the slip number P168748 and recorded in the purchase history database.

According to the acquisition system 1 and the method of the present embodiment, the vehicle number acquired by the camera and the sales data can be associated without going through the POS. In addition to the sale of fuel oil, most of the service station sales operations such as consumables sales, car wash and vehicle inspection services are linked to the vehicle number and sales data without going through a sales staff, and the purchase history is recorded. Collected. Therefore, the labor of the sales staff is reduced.
Further, in the past, only the information of payment using a credit card issued by the fuel oil sales company was collected as the purchase history of the member, but according to the acquisition system 1 of the present embodiment, the purchase history of non-members is collected. Can also be collected.

Further, according to the acquisition system 1 and the method of the present embodiment, the cameras 11 to 41 and the POS 13 to 43 are provided in the kerosene lane 30 and the car wash lane 40 in addition to the refueling lanes 10 and 20. Therefore, in addition to the purchase history of fuel oil, the purchase history of products and services other than fuel oil such as kerosene, car wash service, consumables such as wipers and engine oil, inspection and vehicle inspection service can be collected. In the past, the provision of these products and services was configured separately from the fuel oil supply system, and it was difficult to collect such products and services. However, the acquisition system 1 of the present embodiment can automatically collect the purchase history with the minimum capital investment such as the installation of the camera and the repair of the POS. Therefore, it is possible to enhance sales expansion of products and services other than fuel oil.

<Customer database update system 100 and method>
When selling fuel oil, fuel oil retailers create a customer database that summarizes what products and services customers have purchased in the past and how often, and use them for sales promotion. In creating such a customer database, conventionally, when registering a new customer in the customer database, a service station salesperson has entered the vehicle number of the customer's vehicle in the customer database. .. However, such work imposes a heavy workload on the sales staff. Therefore, in the present embodiment, the customer database is updated as follows by using the update system 100 in conjunction with the purchase history acquisition system 1 described above.

FIG. 6 is a block diagram of the update system 100. As shown in FIG. 6, the update system 100 includes an update server 110 and a data server 61. The update server 110 has a purchase history reading unit 111, a purchase history updating unit 112, an external data reading unit 113, and an external data adding unit 114. The data server 61 records the above-mentioned purchase history database, external database, and customer database.

FIG. 7 shows an example of the customer database to be updated. The customer database shown in FIG. 7 is created based on the purchase history database. The customer database is created by collecting data for each customer code from the purchase history database. For example, the update server 110 extracts the purchase history of the customer code "123456" from the purchase history database and updates the information of the customer code "123456" in the customer database on a regular basis such as daily or monthly. For example, the customer database contains customer codes, vehicle numbers, next vehicle inspection deadlines, purchase histories, and so on. The purchase history includes the last visit date, cumulative refueling amount, and so on.

When adding a new customer to such a customer database, it is done by incorporating an external database. An example of an external database is shown in FIG. As shown in FIG. 8, the external data is a database provided by the Ministry of Land, Infrastructure, Transport and Tourism that records vehicle data such as the next vehicle inspection deadline in association with the vehicle number.

The external data reading unit 113 reads external data periodically, such as monthly. The external data addition unit 114 compares the read external database with the customer database, and identifies a vehicle number (referred to as an unregistered number) not included in the customer database from the external database. Further, the external data addition unit 114 attaches a new customer code to the information such as the next vehicle inspection deadline of the vehicle with the unregistered number in the external database, and registers it in the customer database. FIG. 9 shows the updated customer database of FIG. 7.

Comparing FIGS. 7 and 8, the vehicle number "Shinagawa 9987" at the bottom of FIG. 8 is not included in the customer database of FIG. Therefore, the external data addition unit 114 adds the record of the customer code "999876" to the customer database as shown in FIG. At this time, the vehicle data associated with "Shinagawa 9987" from FIG. 8 is added to the customer database.

As described above, in the update system 100 of the present embodiment, when the vehicle number not recorded in the purchase history database exists in the external database read by the external data reading unit 113, the vehicle number not recorded in the purchase history database is present. And an external data addition unit 114 for adding vehicle data to the purchase history database.
Therefore, according to the update system 100 and the method of the present embodiment, it is not necessary for the salesperson of the service station to register a new customer in the customer database, and the burden on the salesperson is reduced. In addition, when a customer newly registered from an external database visits a service station, the purchase history of the customer can be collected immediately.

Although the embodiments of the present invention have been described above, it goes without saying that the technical scope of the present invention should not be construed as being limited by the description of the present embodiments. It is understood by those skilled in the art that the present embodiment is merely an example, and various embodiments can be modified within the scope of the invention described in the claims. The technical scope of the present invention should be determined based on the scope of the invention described in the claims and the scope thereof.

In the above-described embodiment, the configuration in which the camera outputs the camera ID has been described, but the present invention is not limited to this example. For example, when the management server 60 is connected to the first camera 11 via the first port, the first camera 11 does not have to output the camera ID. This is because the management server 60 can recognize that the information input from the first port is the output of the first camera 11.

Further, in the above-described embodiment, the configuration in which the camera outputs the shooting date and time and the number specifying unit outputs the shooting data including the shooting date and time has been described, but the present invention is not limited to this. The number specifying unit may be configured to output a specific date and time when the vehicle number is specified.

In the above-described embodiment, it is not specified that the customer database includes the customer's name and address, but the customer database may include the customer's name and address. Information such as the customer's name and address can be added to the customer database by having the customer input it into the customer database through an application or the like, or by having a salesperson ask the customer at the store and input it into the customer database.

1 Acquisition system (purchase history acquisition system)
10 1st refueling lane 11 1st camera 12 1st refueling machine 13 1st POS
20 Second refueling lane 21 Second camera 22 Second refueling machine 23 Second POS
30 Kerosene lane 31 Third camera 32 Kerosene refueling machine 33 Third POS
40 Car wash lane 41 4th camera 42 Car wash 43 4th POS
60 Management server 61 Data server 62 Number specification unit 63 Sales data management unit 64 Data matching unit 100 Update system 110 Update server 111 Purchase history reading unit 112 Purchase history update unit 113 External data reading unit 114 External data addition unit

Claims (6)

At service stations that provide services such as fuel oil and wipers, and services such as car washing and vehicle inspection.
It is a purchase history acquisition system that updates the purchase history database in which sales data including sales goods or services, sales date and time, and sales amount are recorded in association with the vehicle number.
A camera that shoots the license plate of the vehicle,
A number specifying unit capable of specifying the vehicle number on the license plate of the vehicle from the image taken by the camera and outputting shooting data including the specified vehicle number and the shooting date / time or the specific date / time.
A payment terminal capable of making payments when a customer who visits a store purchases a product or service and outputting at least the sales goods or the sales service, the sales date and time, and sales data including the sales amount.
The sales data of the sales date and time within a predetermined time from the shooting date and time of a certain shooting data or the specific date and time is specified, and the vehicle number of the shooting data and the specified sales data are linked to the purchase history database. The data matching part to record and
Purchase history acquisition system with. The camera is installed in each payment terminal.
The camera can output the shooting data including the camera identification information that can identify the corresponding payment terminal.
The payment terminal can output terminal information that can identify each of them together with the sales data.
The purchase history according to claim 1, wherein the data matching unit associates the vehicle number with the sales data based on the shooting date / time or the specific date / time, the sales date / time, the camera identification information, and the terminal information. Acquisition system. The purchase history acquisition system according to claim 1, wherein the camera and the payment terminal are provided at least in a refueling lane and a car wash machine. A customer database update system including a vehicle owner name, vehicle data, and sales data, which is created based on the purchase history database updated by the purchase history acquisition system according to claim 1.
An external data reading unit that reads the vehicle data including the vehicle owner and vehicle inspection information and an external database including the vehicle number,
When the vehicle number not recorded in the purchase history database exists in the external database read by the external data reading unit, the vehicle number and the vehicle data not recorded in the purchase history database are stored in the purchase history database. A customer database update system that has an external data addition part to be added to. At service stations that provide services such as fuel oil and wipers, and services such as car washing and vehicle inspection.
It is a purchase history acquisition method using a purchase history acquisition system that updates the purchase history database in which sales data including sales goods or services, sales date and time, and sales amount are recorded in association with the vehicle number.
The acquisition system includes a memory for recording computer-readable instructions and an information processing device for executing the computer-readable instructions.
The purchase history acquisition method is applied to the acquisition system.
The vehicle number of the vehicle is specified from the image taken by the camera that captures the license plate of the vehicle, and the shooting data including the specified vehicle number and the shooting date / time or the specific date / time is output.
When a customer who visits a store purchases a product or service, at least the sales item or the sales service, the sales date and time, and sales data including the sales amount are output.
The sales data of the sales date and time within a predetermined time from the shooting date and time of a certain shooting data or the specified date and time is specified, and the vehicle number of the shooting data and the specified sales data are linked to the purchase history database. How to get the purchase history to record. The update system of the vehicle owner name, the vehicle data, and the customer database including the sales data, which is created based on the purchase history database updated by the purchase history acquisition method according to claim 5, was used. It ’s an update method,
The update system includes a memory for recording computer-readable instructions and an information processing device for executing the computer-readable instructions.
The update method is applied to the update system.
Load the vehicle data including the vehicle owner and vehicle inspection information and the external database including the vehicle number,
When the vehicle number not recorded in the purchase history database exists in the read external database, the vehicle number and the vehicle data not recorded in the purchase history database are added to the purchase history database. How to update the customer database.

Images