JP2014153801A - Information collection system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide an information collection system capable of collecting customer information, regardless of the existence of member registration, and providing information to a customer at a proper time once a member registration is made.SOLUTION: An administrative server 1 includes: a member information DB 12 storing member identification information, portable terminal identification information and member information; commodity purchase history storage means which stores commodity identification information, store identification information, member identification information and purchase dates regarding a registered customer; and commodity purchase experience history storage means (sales management information DB 14) which stores commodity identification information, store identification information, portable terminal identification information and purchase dates regarding an unregistered customer. When an unregistered customer purchases a commodity, the commodity purchase experience history storage means stores this purchase history together with his/her portable terminal identification information. When the customer makes a member registration, his/her purchase history is retrieved and extracted from the commodity purchase experience history storage means on the basis of the portable terminal identification information, and his/her purchase history is stored together with his/her past purchase history in the commodity purchase history storage means.

Description

  The present invention relates to an information collection system that collects and manages customer purchase information and the like using a portable terminal such as a mobile phone and a smartphone.

  A POS system is widely used as an information collection system for collecting information such as information on purchased products of customers. As such an information collection system, for example, a POS sales management system described in Patent Document 1 is known.

The POS sales management system described in Patent Document 1 is a POS sales management system that is installed in a store that sells or rents goods and services and performs sales management and rental management. This POS sales management system
(A) Portable communication by packet communication means capable of communication connection with a terminal packet communication center, having operation buttons, a display unit, connection terminals of external devices, and means for storing e-mail and Internet browser functions and a contract number Phone and
(B) An operation input having a transaction input unit for inputting sales data and lending data, a bar code input unit for inputting bar code data, a card input unit for inputting card data, and an operation input unit for operating the apparatus. A sales management means having a means, a sales management section for managing sales and lending of products, and a collection management section for managing sales collection, and managing customer data such as store member registration / update and customer transaction history Customer management means having a customer management section, a card issuing section for issuing a membership card, and a point adding section for adding and managing points (privileges) to the customer, a customer data file for storing customer data, and a sales for storing sales data A data storage means having a data file and a mail data file for storing e-mail data, and a member mail student for generating an e-mail addressed to the member A mail generating unit having parts, and a POS terminal and a communication control unit having a communication control unit for communication connection to a communication line in the store,
(C) a transaction accepting means having a terminal I / F means having a connection terminal for connecting to a mobile phone, a data transmitting / receiving unit for sending / receiving transaction data to / from the mobile phone, and a transaction accepting unit for accepting transactions by the mobile phone; A terminal authentication unit having a password confirmation unit that receives a password number or password data from the mobile phone and compares the password with the password data stored and registered in advance in the data storage unit to authenticate the mobile phone; and a POS terminal; An I / F means for performing the I / F of the MIF unit attached to or built in the POS terminal;
(D) a store server that performs sales management processing such as sales management of POS terminals, order management, product management, price collection management,
(E) It is composed of a local communication line for communication connection of devices in the store, a web page for store information, and a WEB server for sending and receiving e-mails.

  In this system, when collecting purchase information of a customer, first, the customer is registered as a member and a membership card is issued. For member registration, a member registration page opened by a WEB server is accessed by a mobile phone, and necessary items are entered from this page. When member registration is performed, the WEB server issues a membership card in the form of an email and transmits it to the customer's mobile phone.

  When a customer purchases a product, the mobile phone is used as a general membership card. The mobile phone is held over the MIF unit connected to the POS terminal, and the mobile ID is transmitted to the MIF unit by short-range wireless communication. Then, sales data and lending data are input from the POS terminal using a barcode of the product. Thereby, the purchase information of the customer who is a member is collected.

  Further, in Patent Document 2, in the user terminal 1, the user creates a mail for notifying the user of a predetermined matter on a predetermined date, and the user's own mail address and transmission date are created. The information is registered in the reservation management database 2c of the service company server 2 together with the information. The service company server 2 stores the sales promotion information database 2b in which the sales promotion information is registered, and the reservation management database 2c in which the mail transmitted from the user terminal 1 is registered. And a function of monitoring the scheduled transmission date of the email registered in the reservation management database 2c, and when the email with the scheduled transmission date is detected, the sales promotion information corresponding to the email is displayed in the promotional information database 2b. A sales promotion information transmission system is disclosed in which the content of sales promotion information is added to an email and transmitted to a user.

Japanese Patent Laid-Open No. 2002-63658 JP 2002-342241 A

  However, in the above-described conventional information collection system, it is necessary to have a customer register as a member in advance before collecting information. Accordingly, since purchase information of customers before membership registration is not collected, there may be some inconvenience when providing information such as sales promotion guidance to customers.

  For example, in a store such as a gas station, the customer collects information about the time when the car inspection service was received, and when the next car inspection time is approaching, a service for sending an email of car inspection guidance information to the customer is performed. Think. In this case, if the customer has received (purchased) the vehicle inspection service after registering as a member, information on the time when the customer has received the vehicle inspection service is registered, so an email of subsequent vehicle inspection information is sent. be able to. However, for example, when a customer receives a vehicle inspection service at a store, the customer does not register as a member. There is no information about the receipt. Therefore, it is not possible to send an email of vehicle inspection guidance information about the first vehicle inspection time after member registration at an appropriate time. If the service for providing the first vehicle inspection guide information cannot be performed accurately, the possibility that the customer repeatedly establishes the vehicle inspection service at the store repeatedly as a repeater may be reduced.

  Therefore, an object of the present invention is to collect information about a customer regardless of whether or not the customer is registered as a member, and to provide information to the customer at an appropriate time immediately after the customer registers as a member. It is to provide an information collection system that enables the

A first configuration of an information collection system according to the present invention includes a management server that collects and manages information about customers;
A client terminal device located in the store;
A portable terminal possessed by a customer and connectable to the management server through a public line, and capable of short-range wireless communication with the client terminal device;
An information collection system for collecting information on products purchased by the customer,
The management server
Member information storage means for storing and managing member identification information for identifying a customer registered as a member, portable terminal identification information for identifying the portable terminal possessed by the customer, and member information including an email address of the customer;
Product identification information for identifying a product or service purchased by a registered customer, store identification information for identifying a store where the product or service has been purchased, the member identification information of the customer, and product purchase history information including the purchase date and time Product purchase history storage means for storage management;
Product identification information for identifying a product or service purchased by a customer who has not registered as a member, the store identification information of a store where the product or service has been purchased, the mobile terminal identification information of the mobile terminal possessed by the customer, and purchase Product purchase history history storage means for storing and managing product purchase history history information including date and time;
The mobile terminal identification information of the mobile terminal transmitted from the mobile terminal or the client terminal device that has acquired the mobile terminal identification information from the mobile terminal through a public line, a product purchased by a customer who owns the mobile terminal, or Information receiving means for receiving the product identification information of the service and the store identification information;
When the information receiving means receives the mobile terminal identification information, the product identification information and the store identification information, a member inspection means for searching out the member information including the mobile terminal identification information from the member information storage means;
When the member information is retrieved by the member inspection means, the product identification information and the store identification information are obtained from the member identification information of the member and the reception date and time of the information reception means which are the purchase date and time or the mobile phone. While saving in the product purchase history storage means together with the transmission date and time of the terminal or the client terminal device,
When the member information is not searched by the member inspection means, the product identification information and the store identification information are the date and time received by the information receiving means that is the mobile terminal identification information and the purchase date and time of the customer, or Collection information registration means for storing in the product purchase history storage means together with the transmission date and time of the mobile terminal or the client terminal device,
Member registration means for registering the member information in the member information storage means,
When the member information is registered in the member information storage unit by the member registration unit, the collection information registration unit is the member of the product purchase history history information stored in the product purchase history history storage unit. Information including the mobile terminal identification information included in the information is searched, and the product identification information, the store identification information, and the purchase date and time of the searched product purchase history information are included in the member information. The product is stored in the product purchase history storage unit together with the member identification information.

  With this configuration, merchandise purchase history history information of a customer who is not registered as a member is stored and managed by the merchandise purchase history history storage means, and correspondence between the merchandise purchase history information and the customer is managed using mobile terminal identification information. Is done. When the customer performs membership registration, the customer's product purchase history history information stored and managed in the product purchase history storage means is transferred to the product purchase history storage means together with the member information. Therefore, it becomes possible to provide information to the customer at an appropriate time using the purchase history of the past product / service of the customer.

  Here, the “public line” means a two-way communication line that can be used by the public, such as a mobile phone line or the Internet. “Mobile terminal” refers to a mobile phone, a PAD, and the like. “Portable terminal identification information” is an ID uniquely assigned to each portable terminal, and for example, IDm of FeliCa (registered trademark) can be used.

According to a second configuration of the information collection system of the present invention, in the first configuration, the client terminal device communicates with the mobile terminal by the short-range wireless communication to the store identification information and the management server via a public line. Address information for access through
The portable terminal is
A display device;
An input device;
Address acquisition means for performing short-range wireless communication with the client terminal device to acquire the address information and the store identification information;
A selection information acquisition unit that displays a selection screen of a product or service purchased by a customer on the display device, and generates the product identification information based on selection information of the product or service input by the customer from the input device;
Selection information transmission means for transmitting the product identification information generated by the selection information acquisition means to the management server using the address information together with the portable terminal identification information and the store identification information of the portable terminal;
It is provided with.

  According to this configuration, when a customer purchases a product, the mobile terminal is brought close to the client terminal device, and address information and store identification information are taken into the mobile terminal. When the customer selects the purchased product or service from the selection screen displayed on the display device of the mobile terminal by the selection information acquisition unit, the selection information transmission unit displays the product identification information, the mobile terminal identification information of the purchased product or service. The store identification information is transmitted to the management server. Thereby, the management server can collect product identification information, portable terminal identification information, and store identification information.

  Here, the “store identification information” transmitted from the client terminal device to the mobile terminal is included in the “address information” even if it is independent of the “address information” (for example, at the end of the address information). It may be a case where a store identification code is added).

According to a third configuration of the information collection system of the present invention, in the first configuration, the mobile terminal transmits the mobile terminal identification information of the mobile terminal to the client terminal device by short-range wireless communication. Is what
The client terminal device
A display device;
An input device;
Portable terminal identification information acquisition means for performing short-range wireless communication with the portable terminal and acquiring the portable terminal identification information;
A selection information acquisition unit that displays a selection screen of a product or service purchased by a customer on the display device, and generates the product identification information based on selection information of the product or service input by the customer from the input device;
Selection information transmission means for transmitting the product identification information generated by the selection information acquisition means to the management server together with the portable terminal identification information and the store identification information of the portable terminal;
It is provided with.

  According to this configuration, when a customer purchases a product, the mobile terminal is brought close to the client terminal device, and the mobile terminal identification information is transmitted to the client terminal device. Then, when the customer selects the purchased product or service from the selection screen displayed on the display device of the client terminal device by the selection information acquisition unit, the selection information transmission unit displays the product identification information of the purchased product or service, the mobile terminal identification Information and store identification information are transmitted to the management server. Thereby, the management server can collect product identification information, portable terminal identification information, and store identification information.

According to a fourth configuration of the information collecting system of the present invention, in any one of the first to third configurations, the management server includes:
For each product or service of each store, the store identification information for identifying the store, the product identification information for identifying the product or service, provision information provided to a customer who purchased the product or service, and the provision information Product purchase follow email storage means for storing and managing product purchase follow email information including a transmission waiting period that is a period until the
For each product or service of each store, email transmission reservation for storing and managing the provision information to be transmitted to the customer who purchased the product or service, the email address of the customer, and the transmission timing of the provision information Storage means;
When the product purchase history information stored in the product purchase history storage unit is updated by the collection information registration unit, it corresponds to the store identification information and the product identification information included in the updated product purchase history information. Retrieve the product purchase follow email information from the product purchase follow email storage means,
Retrieve the member information corresponding to the member identification information included in the updated product purchase history information from the member information storage means,
If the product purchase follow-up email information is retrieved,
Calculating the transmission time by adding the transmission waiting period included in the product purchase follow-up email information to the purchase date and time included in the updated product purchase history information,
Mail transmission reservation means for registering the provision information included in the product purchase follow-up mail information, the mail address included in the member information, and the calculated transmission time in the mail transmission reservation storage means as the mail transmission reservation information;
For each mail transmission reservation information stored in the mail transmission reservation storage means, when the transmission timing of the mail transmission reservation information comes, the provision information of the mail transmission reservation information for the mail address of the mail transmission reservation information A deadline management means for sending
It is provided with.

  According to this configuration, the member's customer uses the product purchase history information stored and managed in the product purchase history storage means and the product purchase follow mail information stored and managed in the product purchase follow mail storage means to When a predetermined period (transmission standby period) elapses after the service is purchased, an e-mail including provision information is automatically transmitted by the term management means. Therefore, it is possible to provide information such as purchase guidance for the next product or service to the member customer at an appropriate time designated in advance.

  As described above, according to the present invention, regardless of whether or not a customer is registered as a member, information on the customer is collected, and immediately after the customer registers as a member, the information is provided to the customer at an appropriate time. It is possible to provide an information collection system capable of performing the above.

It is a figure showing the apparatus structure of the information collection system which concerns on Example 1 of this invention. It is a block diagram showing the functional structure of the management server 1 of FIG. It is a block diagram showing the function structure of the portable terminal 4 of FIG. 4 is a table showing a table managed in each database of the management server 1. It is an ER figure showing the relation of each table of each database concerning goods purchase terminal. It is an ER diagram showing the relation of each table of each database related to merchandise purchase information collection management. It is an ER diagram showing the relation of each table of each database related to term management. 6 is a flowchart illustrating an operation when registering product information from a client store in the information collection system according to the first embodiment. 7 is a flowchart illustrating an operation when collecting product purchase information and registering a member in the information collection system according to the first embodiment. It is a figure showing an example of the display screen displayed on the portable terminal when the customer is not registered as a member. It is a figure showing an example of the display screen displayed on the portable terminal 4 when the customer has already been registered as a member. It is a flowchart showing the flow of a mail transmission reservation update process. It is a flowchart showing the flow of the time limit management process of information provision with respect to a member. It is a figure showing the apparatus structure of the information collection system which concerns on Example 2 of this invention. It is a block diagram showing the function structure of the portable terminal 4a and the client terminal device 7 in the information collection system of FIG. 12 is a flowchart illustrating an operation when collecting product purchase information of a customer and registering a member in the information collection system according to the second embodiment.

  Hereinafter, embodiments for carrying out the present invention will be described with reference to the drawings.

(1) System Configuration FIG. 1 is a diagram illustrating a device configuration of an information collection system according to Embodiment 1 of the present invention. The information collection system according to the present embodiment is a system that collects purchase information of a customer's products, and manages a time limit such as the replacement date of the product from the purchase date and time of each customer's product. The information collection system of the present embodiment includes a management server 1 installed in a management center, a client PC 2 installed in a store as a client, a client terminal device 3, and a mobile terminal 4 such as a mobile phone or a smartphone possessed by a customer. It has. The client PC 2 and the mobile terminal 4 are connected to the management server 1 via a public telephone line 5 and an Internet line 6 of a mobile phone. The client terminal device 3 is specifically a pit touch mini S (registered trademark) or the like, and is short-range with the mobile terminal 4 by infrared communication such as Bluetooth (registered trademark) or weak radio wave communication. Communication is possible.

  In the present embodiment, the portable terminal 4 incorporates an IC chip in which a unique ID for identifying the portable terminal 4 is incorporated. Here, as an example, it is assumed that an IC chip of FeliCa (registered trademark) that is generally widely used in Japan is built in, and IDm (FeliCa (registered trademark)) is used as a unique ID for identifying the mobile terminal 4. A unique ID number that is recorded on the IC chip and cannot be rewritten).

  In the management server 1, as a database, a client information DB 11 for managing client information, a member information DB 12 for managing customer information, information on products sold by a client in a store, and information provided to customers for the products are managed. And a sales management information DB 14 for managing the sales information of each product of each client and the time limit management information of the transmission timing of the provided information. In this embodiment, for convenience of explanation, the databases are classified into the above four types according to the type of management information and are displayed as independent databases, but in practice, these are managed as one database. Of course it is also possible.

  FIG. 2 is a block diagram showing a functional configuration of the management server 1 of FIG. In FIG. 2, the client information DB 11, member information DB 12, provision information DB 13, and sales management information DB 14 correspond to the same reference numerals in FIG.

  The management server 1 includes a network interface (network I / F) 15, an HP information transmission unit 16, an HP information creation unit 16a, a mail control unit 17, a transmission information creation unit 18, an information reception unit 19 (information reception unit), and a provision Information registration unit 20, client information registration unit 21, member information registration unit 22 (member inspection unit and member registration unit), selection information registration unit 23 (collected information registration unit), time limit management unit 24 (time limit management unit), clock unit 25, an output unit 26, and a mail transmission reservation unit 27 (mail transmission reservation means). Each of these units is functionally realized by causing the computer of the management server 1 to read and execute a program.

  The network I / F 15 is an interface with the Internet line 6 in the management server 1. The HP information transmission unit 16 transmits the page data of the homepage designated from the communication terminal (client terminal device 3, mobile terminal 4) of the client or customer to the communication terminal. The HP information creation unit 16 a generates page data of a home page to be transmitted to the mobile terminal 4. The mail control unit 17 controls transmission / reception of mail with the customer's communication terminal (mobile terminal 4). The transmission information creation unit 18 customizes for each client, each product, and each customer based on the provision information stored in the provision information DB 13, and the homepage page data (HTML, XML, etc.) transmitted by the HP information transmission unit 16 The page data described in the Web page description language is the same. The information receiving unit 19 analyzes the contents of various received information transmitted from the client or customer communication terminal (client terminal device 3, mobile terminal 4) to the management server 1, and performs control according to the type of received information. The provided information registration unit 20 registers and updates the provided information provided by the client to the customer in the provided information DB 13. The client information registration unit 21 registers / updates information about the client in the client information DB 11. The member information registration unit 22 registers and updates information related to the customer who has registered as a member or the customer who has not registered as a member in the member information DB 12. The selection information registration unit 23 registers / updates information related to the product purchased by the customer and information related to the purchase date / time in the sales management information DB 14. The time limit management unit 24 performs time limit management of the date and time when information is transmitted to the customer based on the product purchase date and time of the customer managed by the sales management information DB 14 and the information transmission time limit managed by the provision information DB 13. The clock unit 25 outputs the current time. The output unit 26 performs output control for a display and a printer. The mail transmission reservation unit 27 periodically executes a mail transmission reservation update process to be described later.

  FIG. 3 is a block diagram showing a functional configuration of the mobile terminal 4 of FIG. The mobile terminal 4 uses a general-purpose device capable of executing programs such as mobile phones and smartphones that are widely used in general, and installs and executes a program distributed by the management center on the mobile terminal 4 Thus, the functional configuration as shown in FIG. 3 is realized.

  The portable terminal 4 includes a touch panel 31 (display / input device), a key input unit 32 (input device), a user information storage unit 33, a wireless line I / F 34, a proximity wireless I / F 35, and a URL acquisition unit 36 (address acquisition means). , An HP information acquisition unit 37, a mail control unit 38, an HP information display unit 39, a selection information acquisition unit 40 (selection information acquisition unit), a selection information transmission unit 41 (selection information transmission unit), and a member registration control unit 42. ing.

  The touch panel 31 is an electronic component that combines a display device such as a liquid crystal panel and a position input device such as a touch pad, and is an input device that operates a device by pressing a display on the screen. The key input unit 32 is an input device by key operation.

  The user information storage unit 33 stores information (user ID and the like) related to the user of the mobile terminal 4. The wireless line I / F 34 is an interface for the mobile terminal 4 to perform wireless communication with the public telephone line 5. The close proximity wireless I / F 35 is an interface for the mobile terminal 4 to perform close proximity wireless communication with the client terminal device 3. The URL acquisition unit 36 communicates with the client terminal device 3 via the proximity wireless I / F 35 and acquires a URL (Uniform Resource Locator) of a homepage (HP) that is published by the management server 1. The HP information acquisition unit 37 accesses the HP designated by the URL acquired by the URL acquisition unit 36 via the public telephone line 5 and the Internet line 6 and acquires the page data of the HP. The mail control unit 38 controls mail sent to and received from the management server 1. The HP information display unit 39 displays the HP on the touch panel 31 based on the HP page data acquired by the HP information acquisition unit 37. The selection information acquisition unit 40 identifies an item selected on the screen based on the coordinate information input from the touch panel 31. The selection information transmission unit 41 transmits the information on the selection item specified by the selection information acquisition unit 40 to the management server 1 via the public telephone line 5 and the Internet line 6. The member registration control unit 42 performs input / output control at the time of member registration.

(2) Database Configuration FIG. 4 shows a list of tables (entities) managed in each database of the management server 1. FIG. 5 to FIG. 7 are ER diagrams (Entity-Relationship Diagrams) representing relationships between tables (entities) in each database. 5 to 7 are represented by IDEF1X.

  The client information DB 11 manages four tables: a store table, a product table, a product purchase terminal table, and a product purchase terminal registered product table. The store table is a table that stores client information such as the store name and store ID of the client. The product table is a table for storing product information (product name, product ID, etc.) handled at each client's store. The product purchase terminal table is a table that stores information (terminal ID, terminal number, etc.) of the client terminal device 3 installed in each client's store. The product purchase terminal registration product table is a table that stores information related to products set in each client terminal device 3.

  The member information DB 12 manages a member table (member information storage means). In the member table, information (member ID, member number, IDm, etc.) related to registered customers is registered. The “IDm” is a unique ID number that is recorded on a FeliCa (registered trademark) IC chip widely used in Japan and cannot be rewritten.

  The provision information DB 13 manages a product purchase history table (product purchase history storage means) and a product purchase history history table (product purchase history history storage means). The product purchase history table is a table for storing product purchase information of customers who are registered as members. The merchandise purchase history table is a table for storing information related to merchandise purchase history of customers who are not registered as members. Incidentally, identification of customers who are not registered as members is performed using IDm.

  The sales management information DB 14 manages a product purchase follow mail table (product purchase follow mail storage means), a mail transmission reservation table, and a mail transmission table (mail transmission reservation storage means). The product purchase follow-up mail table is a table for registering information related to the content of the provided information notified to the customer who is a member for each product registered by each client. The e-mail transmission reservation table is a table for registering reservation information such as an e-mail transmission scheduled date to be transmitted to each member. The mail transmission table is a table for registering distribution destination information of mail transmitted to each member.

  Specific contents of fields, primary keys, and relations in each table are described in FIGS.

  The operation of the information collecting system according to this embodiment configured as described above will be described below.

(3) System Operation (3.1) Registration of Products Handled by Each Store FIG. 8 is a flowchart showing an operation when registering product information from a client store in the information collection system according to the first embodiment.

  First, the client accesses the “product registration update page” published by the management server 1 of the management center through the Internet line 6 from the client PC 2 installed in the store via the Internet line 6 (S11). When there is an access, the management server 1 first transmits page data of “client authentication page” to the client PC 2 (S21). As a result, a “client authentication page” for inputting the store ID and password is displayed on the display of the client PC 2, and the client inputs the store ID and password here and transmits them to the management server 1. The management server 1 refers to the store table (FIG. 5) in the client information DB 11, checks the store ID / password, and permits access if they match. This operation is the same as the client authentication method generally performed widely on the Internet.

  When the access is permitted, the management server 1 searches the product table (FIG. 5) in the client information DB 11 and the product purchase follow-up mail table (FIG. 7) in the provided information DB 13 using the received store ID as a search key. All the product information and product purchase follow-up mail information registered for the store ID are extracted (S22).

  Next, the management server 1 creates page data of a “product registration update page” into which the extracted registered product information and product purchase follow-up mail information are inserted, and transmits this to the client PC 2 (S23). The client PC 2 receives the page data of “product registration update page” and displays the “product registration update page” on the display (S13). At this time, the “product registration update page” includes a list of registered product information and product purchase follow-up email information, and input boxes and check boxes for newly registering or changing product information and product purchase follow-up email information. Is displayed.

  Next, the client inputs the product information of the product to be registered or changed and the product purchase follow-up mail information in the “product registration update page”, and transmits them from the client PC 2 to the management server 1 (S14). When the management server 1 receives the product information of the product to be registered or changed and the product purchase follow-up mail information from the client PC 2 (S24), it updates the product table of the client information DB 11 with the information (S25) and registers the product purchase terminal. A record corresponding to the product information in the product table (FIG. 5) is created / updated (S26), and a record corresponding to the product information in the product purchase follow-up mail table of the provision information DB 13 is created / updated (S27).

  With the above operation, registration or update of the product handled by the client in the store is performed.

(3.2) Collection of Customer Purchase Information and Member Registration Next, operations of collecting customer purchase information and member registration when a customer purchases a product at a client store will be described.

  FIG. 9 is a flowchart illustrating operations when collecting product purchase information and registering a member in the information collection system according to the first embodiment.

  As an initial preparation, a customer who purchases a product installs and executes an application program distributed by the management center on the mobile terminal 4 possessed by the customer, and configures the function as shown in FIG. Keep it.

  First, in a client store, a customer who purchases a product brings the mobile terminal 4 possessed by the customer close to the client terminal device 3 installed in the store. When the client terminal device 3 knows that the mobile terminal 4 is approaching, the client terminal device 3 transmits URL information for accessing a specific homepage published by the management server 1 to the mobile terminal 4 by short-range wireless communication. The URL acquisition unit 36 of the portable terminal 4 receives the transmitted URL information (S101). Here, the URL information transmitted by the client terminal device 3 is a URL unique to the store and the client terminal device 3, and the store information can be identified by the URL information. Specifically, a store ID and a terminal ID (see FIG. 5) assigned to the store are added to the end of the URL.

  Next, the HP information acquisition unit 37 of the portable terminal 4 accesses the management server 1 via the public telephone line 5 and the Internet line 6 using the received URL information (S102). When the information receiving unit 19 of the management server 1 detects an access from the portable terminal 4, the HP information creating unit 16a extracts the store ID and the terminal ID from the URL. Then, the product purchase terminal registration product table of the client information DB 11 is searched using (store ID, terminal ID) as a search key, and a product ID corresponding to the (store ID, terminal ID) is extracted, and each product extracted The product table of the client information DB 11 is searched using the ID (store ID, product ID) as a search key, and the product name corresponding to the (store ID, product ID) is extracted. The HP information creation unit 16a creates page data of a “purchased product selection page” as shown in FIG. 10A from each extracted product name. The HP information transmitting unit 16 transmits the page data of the created purchase product selection page to the mobile terminal 4 (S202). When the HP information acquisition unit 37 of the portable terminal 4 receives the page data of “purchased product selection page”, the HP information display unit 39 displays a “purchased product selection page” as shown in FIG. It is displayed (S102).

  Next, when the customer selects a product purchased from the “purchased product selection page” displayed on the touch panel 31 of the mobile terminal 4, the selection information acquisition unit 40 identifies the selected product from the input coordinates of the touch panel 31 (S103). . When the “OK” button is touched, the selection information transmission unit 41 sends the purchase product information (in this case, “product name”) of the selected product and the IDm unique to the mobile terminal 4 to the management server 1. Transmit (S104). The information receiving unit 19 of the management server 1 receives purchased product information and IDm from the mobile terminal 4 (S204).

  Next, the member information registration unit 22 of the management server 1 searches the member table (FIGS. 6 and 7) of the member information DB 12 using the received IDm as a search key, and sets the member ID of the record corresponding to the received IDm. Extract (S205). Here, when there is a record corresponding to the received IDm (when the customer is already registered as a member), the process proceeds to the following (b), and when there is no record (the customer is not registered as a member) In the case), the process proceeds to the next process (a) (S206).

(A) When the customer is not registered as a member When the customer is not registered as a member, first, the selection information registration unit 23 of the management server 1 creates a new record in the product purchase history history table of the sales management information DB 14, Information such as (store ID, terminal ID, product ID, IDm) is registered (S207).

  Next, the HP information transmission unit 16 of the management server 1 transmits the page data of the “member registration guide page” as shown in FIG. 10B to the portable terminal 4 (S208). When the HP information acquisition unit 37 of the portable terminal 4 receives the page data, the member registration control unit 42 displays a “member registration guide page” on the touch panel 31 (S108). When the customer wants to register as a member, the customer touches the “empty mail transmission” area in FIG. If it is not desired to register as a member, the process ends as it is (break-off).

  When the customer touches the “empty mail transmission” area of the touch panel 31, the member registration control unit 42 displays a “mail transmission screen” as shown in FIG. 10C on the touch panel 31. When the customer inputs a transmission instruction, the mail control unit 17 transmits a blank mail to the management server 1 (S109).

  When the mail control unit 17 of the management server 1 receives the blank mail (S209), the member information registration unit 22 extracts the customer's mail address from the mail data header of the blank mail. Then, the member information registration unit 22 creates mail data of “main registration guide mail” as shown in FIG. 9D, and the mail control unit 17 transmits this “main registration guide mail” to the mail address of the customer. (S210). The mail control unit 38 of the mobile terminal 4 receives the “main registration guidance mail” (S110). As shown in FIG. 9 (d), the “main registration guidance mail” includes a URL for accessing the “member information input page”.

  When the customer accesses the “member information input page” of the management server 1 from the URL included in the “main registration guidance email” (S111), the member information registration unit 22 of the management server 1 displays the “member information input page” page. Data is transmitted to the portable terminal 4 (S211). The HP information acquisition unit 37 of the mobile terminal 4 receives the page data of “member information input page”, and the HP information display unit 39 displays the “member information input page” on the touch panel 31 (S111). As shown in FIG. 10E, the “member information input page” is provided with fields for inputting the customer's “name”, “sex”, “profession”, and the like. In addition, a link for displaying the “use agreement” is also provided.

  When the customer inputs customer information (member information) in the “member information input page” using the touch panel 31 and the key input unit 32 of the mobile terminal 4 (S112), and touches the “Register” button (FIG. 10E). The member registration control unit 42 of the portable terminal 4 transmits the input member information to the management server 1 (S113). When the information receiving unit 19 of the management server 1 receives the member information (S213), the member information registering unit 22 creates a new record in the member table of the member information DB 12 and gives a new unique member ID, The member information is registered in the record (S214). Next, the member information registration unit 22 creates page data of a “registration completion page” as shown in FIG. 10F, and the HP information transmission unit 16 transmits the page data to the mobile terminal 4 (S215). . When the HP information acquisition unit 37 of the mobile terminal 4 receives the page data of “registration completion page”, the HP information display unit 39 displays the “registration completion page” on the touch panel 31 (S115).

  Further, the member information registration unit 22 of the management server 1 creates mail data of “registration completion mail” as shown in FIG. 10G, and the selection information registration unit 23 as shown in FIG. The mail data of “thank you mail” is created, and the mail control unit 17 transmits the mail data to the mail address of the customer (S216). The mail control unit 38 of the mobile terminal 4 receives the “registration completion mail” and the “thank you mail” (S116). With the above operation, the customer membership registration process is completed.

  Next, the selection information registration unit 23 of the management server 1 searches the merchandise purchase history history table of the sales management information DB 14 using the IDm received in step S204 as a search key, and hits the record (product purchase history history information). ) Are all extracted (S217). At this time, the “deletion flag” of the extracted record is set to True (valid), and the product purchase history history table is updated. Then, a member ID is added to the extracted merchandise purchase history information to obtain merchandise purchase history information, and the merchandise purchase history information is registered in the merchandise purchase history table of the sales management information DB 14 (S218). With the above operation, the registration process of the customer's product purchase information is completed.

(B) When the customer is already registered as a member When the customer is already registered as a member, the selection information registration unit 23 of the management server 1 first adds the member ID to the purchased product information and IDm received in step S204. Is added as product purchase history information, and this product purchase history information is registered in the product purchase history table of the sales management information DB 14 (S307).

  Next, the member information registration unit 22 creates page data of a “registration completion page” as shown in FIG. 11B, and the HP information transmission unit 16 transmits the page data to the mobile terminal 4 (S315). . When the HP information acquisition unit 37 of the mobile terminal 4 receives the page data of “registration completion page”, the HP information display unit 39 displays the “registration completion page” on the touch panel 31 (S415).

  Further, the selection information registration unit 23 of the management server 1 creates mail data of “thank you mail” as shown in FIG. 11C, and the mail control unit 17 transmits the mail data to the mail address of the customer. (S316). The mail control unit 38 of the portable terminal 4 receives the “thank you mail” (S416). With the above operation, the registration process of the customer's product purchase information is completed.

(3.3) Database Update for Time Limit Management FIG. 12 is a flowchart showing the flow of processing when performing mail transmission reservation update processing. This e-mail transmission reservation update process (e-mail transmission reservation table and e-mail transmission table update process in the provision information DB 13) is periodically executed in the management server 1 at a predetermined time of the day (for example, midnight). Is done. If the product purchase history table has not been updated once in the period of one day immediately before the execution start time of the mail transmission reservation update process (S501), the main process of this mail transmission reservation update process ( S502 to S508) are not performed.

When the product purchase history table has been updated (S501), the e-mail transmission reservation unit 27 first uses the "registration date" and the "update date" as search keys to search the product purchase history table in the sales management information DB 14 (FIG. 7). ), And extracts all records whose "registration date" or "update date" is within the period of one day immediately before the process execution start time, and creates an update record list consisting of the set of extracted records (S502). Each record in the update record list is represented by rec [i] (i is a record number, i = 0,..., N _rec −1, N _rec is the total number of records).

Next, the mail transmission reservation unit 27 initializes the record number i to 0 (S503), and repeatedly executes the following processes of S504 to S508 while i <N _rec .

  First, the mail transmission reservation unit 27 searches the product purchase follow mail table in the provided information DB 13 using (store ID, product ID) of the record rec [i] as a search key, and hits the record (product purchase follow mail information). Is extracted (S504). If not hit (S505), the process proceeds to step S510.

  If there is a hit (S505), the mail transmission reservation unit 27 generates mail transmission reservation information (information of a record registered in the mail transmission reservation table) based on the extracted product purchase follow-up mail information (S506). It is registered in the mail transmission reservation table (S507). Here, each element of the mail transmission reservation information is set as shown in the following table. In (Table 1), the “product purchase follow-up email information” column is a value of the extracted product purchase follow-up email information, and the “external setting value” column is a value automatically set by the email transmission reservation unit 27. . At this time, the mail transmission reservation unit 27 acquires a reservation ID that is automatically given when mail transmission reservation information is registered in the mail transmission reservation table.

  Next, the mail transmission reservation unit 27 searches the member table of the member information DB 12 using the member ID of the record rec [i] as a search key, and extracts the mail address corresponding to the member ID (S508). Then, based on the extracted mail address, the record rec [i] (store ID, member ID), and the mail transmission reservation information (reservation ID, transmission classification), mail transmission information is generated, and the provision information DB 13 Register in the mail transmission table (S509).

Next, the record number i is incremented. If i <N _rec , the process returns to step S503; otherwise, the mail transmission reservation update process is terminated.

(3.4) Providing Information to Members FIG. 13 is a flowchart showing the flow of time limit management processing for providing information to members. The following time limit management process is executed following or in parallel with the mail transmission reservation update process.

  First, the time limit management unit 24 of the management server 1 searches the mail transmission reservation table of the provision information DB 13 using (transmission reservation date, transmission reservation time) as a search key, and creates a same-day transmission list including a set of extracted records. Create (S601). As a search condition, for example, (transmission reservation date, transmission reservation time) is within 24 hours from the current date and time (start time of the time limit management process).

Next, the time limit management unit 24 sorts the created same-day transmission list in ascending order using (transmission reservation date, transmission reservation time) as a sort key (S602). The sorted records in the current day transmission list are denoted as rec [i] (i = 0,..., N _rec −1: i is a record number, and N _rec is the total number of records).

  Next, the time limit management unit 24 initializes the record number i of the record to be processed to 0 (S603).

  Next, the time limit management unit 24 searches the mail transmission table of the provision information DB 13 using the “reservation ID” of the record rec [i] as a search key, and extracts (member ID, mail address, distribution classification) of the extracted record. A transmission address list including the set is created (S604).

  Next, the time limit management unit 24 waits until the current date and time output by the clock unit 25 passes the transmission reservation date and time (transmission reservation date and transmission reservation time) of the record rec [i] (S605).

  When the current date / time has passed the transmission reservation date / time of the record rec [i], the time limit management unit 24 creates mail data from the information of the record rec [i], and all the “mail addresses” registered in the transmission address list. In response to this, the mail control unit 17 transmits the mail data (S606). The mail control unit 38 of each mobile terminal 4 corresponding to the “mail address” receives the transmitted mail data (S706). As a result, distribution of the provided information by electronic mail is executed. When the electronic mail delivery is executed, the time limit management unit 24 sets “delete flag” of the record corresponding to the “reservation ID” in the mail transmission reservation table of the provision information DB 13 to True.

Next, the time limit management unit 24 increments the record number i (S607). If i <N _rec , the process returns to step S604. Otherwise, the period management process is terminated assuming that all the records have been processed (S608).

  FIG. 14 is a diagram illustrating a device configuration of the information collection system according to the second embodiment of the present invention. In FIG. 14, the same components as those in FIG. In the information collection system of this embodiment, a client terminal device 7 is installed in the client's store in addition to the client terminal device 3. In FIG. 14, the mobile terminal 4a represents a mobile phone that does not include a touch panel. Specifically, the client terminal device 7 uses a pit touch (registered trademark) or the like, and communicates with the mobile terminal 4 or the mobile terminal 4a possessed by the customer via Bluetooth (registered trademark), voice code communication, or the like. Is possible. In addition, the client terminal device 7 is provided with a touch panel 7a for displaying images and characters and touch-inputting selected coordinates, and an antenna area 7b for short-distance wireless communication with the mobile terminal on the front surface of the housing. ing. By bringing the portable terminal close to the antenna region 7b, short-range wireless communication is possible between the portable terminal and the client terminal device 7. Furthermore, the client terminal device 7 is connected to the Internet line 6 and can communicate with the management server 1.

  FIG. 15 is a block diagram showing functional configurations of the mobile terminal 4a and the client terminal device 7 in the information collection system of FIG. In FIG. 15, the same components as those in FIG. In the present embodiment, the client terminal device 7 has a part of the functions (the selection information acquisition unit 40 and the selection information transmission unit 41) of the mobile terminal 4 of the first embodiment.

  The mobile terminal 4 a includes a display 31 a instead of the touch panel 31, and input can be performed only from the key input unit 32. The portable terminal 4a includes an IDm transmission unit 45. The IDm transmission unit 45 transmits the IDm stored in the user information storage unit 33 to the client terminal device 3 via the proximity wireless I / F 35.

  On the other hand, the client terminal device 7 includes a terminal storage unit 46, a proximity wireless I / F 47, a touch panel 48 (display device / input device), an IDm reception unit 49 (portable terminal identification information acquisition means), a URL transmission unit 50, and HP information acquisition. Unit 51, HP information display unit 52, and network line I / F 53. The terminal storage unit 46 stores the URL (address information) of the “member registration page” published by the management server 1 and the store identification information of the store where the client terminal device 7 is installed, and transmits it from the mobile terminal 4a. IDm to be stored temporarily. Here, it is assumed that the store identification information is included in the URL (address information) in a form in which a store identification code is added to the end of the URL. The close proximity wireless I / F 47 is an interface for performing short distance wireless communication with the mobile terminal 4a. The touch panel 48 is an electronic component that combines a display device such as a liquid crystal panel and a position input device such as a touch pad, and is an input device that operates a device by pressing a display on the screen. The IDm receiving unit 49 receives IDm transmitted from the portable terminal 4 a via the proximity wireless I / F 47 and stores it in the terminal storage unit 46. The URL transmission unit 50 transmits the URL of the “member registration page” to the mobile terminal 4a via the proximity wireless I / F 47. The HP information acquisition unit 51 receives the page information of the homepage that the management server discloses via the Internet line 6. The HP information display unit 52 displays the page information received by the HP information acquisition unit 51 on the touch panel 48. The net line I / F 53 is an interface for connecting the client terminal device 7 to the Internet line 6.

  FIG. 16 is a flowchart illustrating operations when collecting product purchase information and registering a member in the information collection system according to the second embodiment. In FIG. 15, the same processing steps as those in FIG. 9 are denoted by the same reference numerals.

  First, at a client's store, a customer who purchases a product brings the mobile terminal 4a possessed by the customer close to the antenna region 7b of the client terminal device 7 installed in the store. When the client terminal device 7 is aware of the approach of the mobile terminal 4a, the client terminal device 7 transmits an IDm transmission request to the mobile terminal 4 by short-range wireless communication (S801). When the portable terminal 4 receives the IDm transmission request, the portable terminal 4 transmits IDm to the client terminal device 7 (S101a), and the client terminal device 7 receives this IDm (S801).

  Next, the client terminal device 7 uses the URL information stored in advance in the client terminal device 7 to access the management server 1 via the public telephone line 5 and the Internet line 6 (S802). When the information receiving unit 19 of the management server 1 detects access from the client terminal device 7, the HP information creating unit 16a extracts the store ID and the terminal ID from the URL. Then, the product purchase terminal registration product table of the client information DB 11 is searched using (store ID, terminal ID) as a search key, and a product ID corresponding to the (store ID, terminal ID) is extracted, and each product extracted The product table of the client information DB 11 is searched using the ID (store ID, product ID) as a search key, and the product name corresponding to the (store ID, product ID) is extracted. The HP information creation unit 16a creates page data of “purchased product selection page” from the extracted product names. The HP information transmission unit 16 transmits the generated page data of the purchased product selection page to the client terminal device 7 (S202). Upon receiving the page data of “purchased product selection page”, the client terminal device 7 displays the “purchased product selection page” on the touch panel 7a (S802).

  Next, when the customer selects a purchased product from the “purchased product selection page” displayed on the touch panel 7a of the client terminal device 7, the client terminal device 7 specifies the selected product from the input coordinates of the touch panel 7a (S803). . When the “decision” button is touched, the client terminal device 7 transmits the purchased product information (“product name” in this case) of the selected product and the IDm received earlier to the management server 1 (S804). ). The information receiving unit 19 of the management server 1 receives purchased product information and IDm from the client terminal device 7 (S204).

  Subsequent operations are the same as those in FIG. 9 of the first embodiment. However, the display of the “member registration guide page” in step S108 of FIG. 9 is performed on the client terminal device 7 instead of the mobile terminal (S808). When the “member registration guide page” is displayed on the client terminal device 7, the customer brings the mobile terminal 4 a close to the client terminal device 7 in order to perform member registration. Thereby, the URL transmission unit 50 of the client terminal device 7 transmits the URL of the “member registration guide page” to the mobile terminal 4a (S808a), and the URL acquisition unit 36 of the mobile terminal 4a displays the “member registration guide page”. The URL is acquired (S108a). The HP information acquisition unit 37 of the mobile terminal 4a accesses the “member registration guide page” published by the management server 1 to acquire page information, and the HP information display unit 39 acquires the page acquired by the HP information acquisition unit 37. Information is displayed on the display 31a (S108b).

  Further, the display of the “registration completion page” in steps S115 and S415 in FIG. 9 is performed on the client terminal device 7 instead of the mobile terminal (S815).

1 Management server 2 Client PC
3 Client terminal device 4, 4a Mobile terminal 5 Public telephone line 6 Internet line 7 Client terminal device 7a Touch panel 7b Antenna area 11 Client information DB
12 Member information DB
13 Information DB
14 Sales management information DB
15 Network interface (Network I / F)
16 HP information transmission unit 16a HP information creation unit 17 Mail control unit 18 Transmission information creation unit 19 Information reception unit 20 Provided information registration unit 21 Client information registration unit 22 Member information registration unit 23 Selection information registration unit 24 Time limit management unit 25 Clock unit 26 Output unit 27 Mail transmission reservation unit 31 Touch panel 31a Display 32 Key input unit 33 User information storage unit 34 Wireless line I / F
35 Proximity wireless I / F
36 URL acquisition unit 37 HP information acquisition unit 38 Mail control unit 39 HP information display unit 40 Selection information acquisition unit 41 Selection information transmission unit 42 Member registration control unit 45 IDm transmission unit 46 Terminal storage unit 47 Proximity wireless I / F
48 Touch Panel 49 IDm Receiver 50 URL Transmitter 51 HP Information Acquisition Unit 52 HP Information Display Unit 53 Net Line I / F

Claims (4)

A management server that collects and manages information about customers;
A client terminal device located in the store;
A portable terminal possessed by a customer and connectable to the management server through a public line, and capable of short-range wireless communication with the client terminal device;
An information collection system for collecting information on products purchased by the customer,
The management server
Member information storage means for storing and managing member identification information for identifying a customer registered as a member, portable terminal identification information for identifying the portable terminal possessed by the customer, and member information including an email address of the customer;
Product identification information for identifying a product or service purchased by a registered customer, store identification information for identifying a store where the product or service has been purchased, the member identification information of the customer, and product purchase history information including the purchase date and time Product purchase history storage means for storage management;
Product identification information for identifying a product or service purchased by a customer who has not registered as a member, the store identification information of a store where the product or service has been purchased, the mobile terminal identification information of the mobile terminal possessed by the customer, and purchase Product purchase history history storage means for storing and managing product purchase history history information including date and time;
The mobile terminal identification information of the mobile terminal transmitted from the mobile terminal or the client terminal device that has acquired the mobile terminal identification information from the mobile terminal through a public line, a product purchased by a customer who owns the mobile terminal, or Information receiving means for receiving the product identification information of the service and the store identification information;
When the information receiving means receives the mobile terminal identification information, the product identification information and the store identification information, a member inspection means for searching out the member information including the mobile terminal identification information from the member information storage means;
When the member information is retrieved by the member inspection means, the product identification information and the store identification information are obtained from the member identification information of the member and the reception date and time of the information reception means which are the purchase date and time or the mobile phone. While saving in the product purchase history storage means together with the transmission date and time of the terminal or the client terminal device,
When the member information is not searched by the member inspection means, the product identification information and the store identification information are the date and time received by the information receiving means that is the mobile terminal identification information and the purchase date and time of the customer, or Collection information registration means for storing in the product purchase history storage means together with the transmission date and time of the mobile terminal or the client terminal device,
Member registration means for registering the member information in the member information storage means,
When the member information is registered in the member information storage unit by the member registration unit, the collection information registration unit is the member of the product purchase history history information stored in the product purchase history history storage unit. Information including the mobile terminal identification information included in the information is searched, and the product identification information, the store identification information, and the purchase date and time of the searched product purchase history information are included in the member information. An information collection system, wherein the information is stored together with the member identification information in the product purchase history storage means. The client terminal device transmits address information for accessing the store identification information and the management server through a public line by short-range wireless communication to the mobile terminal,
The portable terminal is
A display device;
An input device;
Address acquisition means for performing short-range wireless communication with the client terminal device to acquire the address information and the store identification information;
A selection information acquisition unit that displays a selection screen of a product or service purchased by a customer on the display device, and generates the product identification information based on selection information of the product or service input by the customer from the input device;
Selection information transmission means for transmitting the product identification information generated by the selection information acquisition means to the management server using the address information together with the portable terminal identification information and the store identification information of the portable terminal;
The information collecting system according to claim 1, further comprising: The mobile terminal transmits the mobile terminal identification information of the mobile terminal by short-range wireless communication to the client terminal device,
The client terminal device
A display device;
An input device;
Portable terminal identification information acquisition means for performing short-range wireless communication with the portable terminal and acquiring the portable terminal identification information;
A selection information acquisition unit that displays a selection screen of a product or service purchased by a customer on the display device, and generates the product identification information based on selection information of the product or service input by the customer from the input device;
Selection information transmission means for transmitting the product identification information generated by the selection information acquisition means to the management server together with the portable terminal identification information and the store identification information of the portable terminal;
The information collecting system according to claim 1, further comprising: The management server
For each product or service of each store, the store identification information for identifying the store, the product identification information for identifying the product or service, provision information provided to a customer who purchased the product or service, and the provision information Product purchase follow email storage means for storing and managing product purchase follow email information including a transmission waiting period that is a period until the
For each product or service of each store, email transmission reservation for storing and managing the provision information to be transmitted to the customer who purchased the product or service, the email address of the customer, and the transmission timing of the provision information Storage means;
When the product purchase history information stored in the product purchase history storage unit is updated by the collection information registration unit, it corresponds to the store identification information and the product identification information included in the updated product purchase history information. Retrieve the product purchase follow email information from the product purchase follow email storage means,
Retrieve the member information corresponding to the member identification information included in the updated product purchase history information from the member information storage means,
If the product purchase follow-up email information is retrieved,
Calculating the transmission time by adding the transmission waiting period included in the product purchase follow-up email information to the purchase date and time included in the updated product purchase history information,
Mail transmission reservation means for registering the provision information included in the product purchase follow-up mail information, the mail address included in the member information, and the calculated transmission time in the mail transmission reservation storage means as the mail transmission reservation information;
For each mail transmission reservation information stored in the mail transmission reservation storage means, when the transmission timing of the mail transmission reservation information comes, the provision information of the mail transmission reservation information for the mail address of the mail transmission reservation information A deadline management means for sending
The information collection system according to any one of claims 1 to 3, further comprising:

Images