JP2002117327A - Customer management system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a customer management system capable of managing customers and transmitting proper sales promoting information to the customers, that is, providing the proper sales promoting information to all the customers using a shop even if the customers are not the member of the own shop in consideration that the customer can receive a common point service at any shop without costing the shop side any expense for point card production. SOLUTION: When member information of members registered as the member by invitation by a specific shop and shop information of the specific shop is provided in an E-mail address management server 3 of the member, the member information of the member buying a commodity/service at another shop and shop information of this shop is inputted to the management server 3 for determining whether the shop and the member are correlated with each other or not by means of an affiliation table 20. If they are not correlated with each other, an E-mail asking the member whether supply of sales promotion information on the shop providing the commodity/service is allowable or not is sent to an E-mail address of the member.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

[Industrial application] Regarding a customer management system for providing store promotion information to store members who can receive services such as point services operated at stores that provide goods or services, The present invention relates to a customer management system that provides sales promotion information to each member registered in the management server while respecting the intention of the member beyond the frame of the store member by the management server in which a plurality of members are registered.

[0002]

2. Description of the Related Art When a customer purchases merchandise or services at a store, a service is provided to give points according to the purchase amount. The customer who wants to receive the point service becomes a member of the store and becomes a member of the store. I have a special loyalty card.

[0003] In addition, a customer has a plurality of store-specific cards in order to receive a point service at a plurality of stores. This requires at least management of a plurality of cards by the customer, and since each card is not used at all times, management becomes troublesome. On the store side, the cost of creating a card increases as the number of customers enclosing it increases, and is not inexpensive compared to the frequency of customer use.

On the other hand, stores provide sales promotion information to store members to enclose customers. The range of members who can provide this promotional information is limited to members registered at the store. Even if a customer who is not a member of the store purchases goods at the store, the store will give the customer Services similar to benefits cannot be provided to maintain membership benefits. That is, the same sales promotion information as the member cannot be provided to the customer. In order to provide sales promotion information to customers other than members, there is no other way than to use advertising media such as paper at a high cost, but it is reflected in the cost of goods.

[0005] In many cases, the point service is carried out solely by the store. In other words, although the store has information on customers who have become members to receive the point service,
The number of members at a store does not increase simply by purchasing by non-member customers. That is, the number of members who can provide the sales promotion information does not increase.

[0006] In order to send the sales promotion information to more customers, e-mail sent via the Internet may be used. This depends largely on the Internet provider, and is not only incurred separately, but also with whom the Internet provider sends information, regardless of the customer at the store. In other words, at present, users of the Internet provider do not always match customers who have used the store. In this method, accurate information cannot be given to a customer who needs the sales promotion information.

[0007]

From the customer's point of view, it is desirable that a common point service can be received regardless of the store used, and even if any store is used without possessing a plurality of cards, each customer can receive the same point service. It is hoped that it will be a point service that is bundled together. It is hard to say that a point card is always used or inconvenient unless you have it, and it is convenient but not so essential. Therefore, if the loyalty card is misplaced, lost, or lost, it is often not immediately noticed.

From the viewpoint of the store, an increase in the number of members who can use the point service is directly linked to sales, but the number of members that the store can independently acquire is naturally limited. Even if you are a member of another store, the customer who purchased the product or service at your own store is an important customer, and provides sales promotion information for all customers who visit your store, including members of other stores I want to do.

Further, in providing the sales promotion information to each customer, it is necessary to reduce the mailing cost or the cost for using the Internet provider, and a system capable of efficiently using the customer information obtained at the time of creating a point card is required. desired.

[0010] In view of the above, in consideration of the fact that the customer can receive a common point service at any store and that the store does not incur the cost of creating a point card, the customer can be managed and provided to the customer. A customer management system that can transmit accurate sales promotion information, that is, it can provide accurate sales promotion information to all customers who use the store, including customers who have purchased goods or services at the store, even if they are not members of their own store Providing is an issue.

[0011]

According to the present invention, as a means for solving the above-mentioned problems, a customer who purchases a product or service at a store that provides the product or service is provided by a customer.
A customer management system managed by a management server,
A store table storing store information including a store ID and a store name, a member table storing member information including a customer's member ID and an e-mail address, and member information and specification of a member registered as a member by soliciting a specific store The management server includes an affiliation table storing the store information in association with the store information, and an e-mail transmission function of transmitting the promotion information of the specific store to the e-mail address of the member associated with the specific store information by the affiliation table. The management server in which the member information of the member who purchased the product or service at the store and registered in the management server and the store information of the store that provided the product or service are input to the management server, and the data is input. In the affiliation table, it is determined whether or not the store and the member are associated with each other. To-mail address, and a customer management system that made it possible to send an E-mail asking whether or not to provide promotional information of the store that provided the goods or services.

In the management server, store information of a plurality of stores and member information of each store are managed by a store table, a member table, and an affiliation table. When the store information of the store that provided the product or service to the member is input from the store to the management server, it can be determined from the affiliation table whether the member is a member of the own store or a member of another store. If it is determined that the member is a member of another store, the member's e-mail address can be extracted from the member table, and an e-mail for asking whether or not to provide the sales promotion information of the store can be transmitted by the e-mail transmission function. In other words, even if this is not a member of the own store, it is possible to grasp the opportunity to give the sales promotion information as a temporary member of the own store.

[0013] That is, the management server adds, for example, the name of the store that provided the product or service to the member of the other store by the e-mail, and then sends “contents of thanks for purchase”.
And E, such as "Can you provide sales promotion information?"
send an email. The member of the other store that has received the e-mail replies whether or not the reception is possible at his / her own discretion, and the member is set to receive the sales promotion information of the store that purchased the product or service. Therefore, it does not become spam.

By the way, a customer who has become a member of a particular store by soliciting a particular store may accept the e-mail transmission from the particular store as a condition to become a member, and in this respect, it does not become unsolicited e-mail. .

In the above invention, the non-affiliation table is provided in the management server, and the member information of the member who has not provided the sales promotion information is stored in the non-affiliation table in association with the store information. When the member information of the member who purchased the product or service and the store information of the store that provided the product or service are input, whether or not the store and the member are associated in both the affiliation table and the non-affiliation table Is determined, and if they are not associated with each other, an e-mail is sent to the e-mail address of the member asking whether or not to provide the sales promotion information of the store that provided the product or service.

[0016] An e-mail is sent to a member other than the member of the specific store to provide the merchandise or service to a member other than the member of the specific store, asking whether it is possible to provide sales promotion information of the specific store that provided the product or service. This means that even if you are not a member of your store, you can get a chance to give promotional information as a temporary member of your store, but if you send e-mail every time you purchase a product or service, the burden on the sender will be It is a big disadvantage, and there is a possibility that repeat may decrease. Therefore, the management server is provided with a non-affiliation table in addition to the affiliation table, and determines whether or not the store and the member are associated with both the affiliation table and the non-affiliation table. Then, an e-mail is sent to the e-mail address of the member asking whether or not to provide the sales promotion information of the store that provided the product or service. As a result, even if a member of another store who has once rejected the provision of the promotion information has received a repeat at the same store, an e-mail asking whether or not to provide the promotion information of the store that provided the product or service again is asked. Will not be sent and will not be spam.

Further, by storing the member information of the member who can provide the promotional information and the store information in the affiliation table, the members who have been able to provide the promotional information can be provided with each purchase. An e-mail asking whether or not to provide the sales promotion information of the store that provided the product or service is not transmitted, and does not become unsolicited e-mail. That is, by storing the information in the affiliation table, the sales promotion information is provided as a member of the store after the storage.

It is to be noted that the management server is provided with a member-dedicated input screen to associate the member's own information as a store where the member wants to provide the sales promotion information, or to provide the sales promotion information at the member's will. If you have a system that allows you to associate your member information as a store that you do not want to have, you can decide whether or not to send an email asking whether you can provide sales promotion information for the store, or once or not The promotion information from the store can be stored in a affiliation table or a non-affiliation table so that it can be selected. In this system, a store is selected from a store table of a management server, a registration intention is input to the management server, and the management server stores the member information and the store information in a belonging table or a non-belonging table in association with the input. Is fine.

Since the management server is a WEB server operated on the Internet, information input to the operation server is performed via the Internet, and a portable information terminal such as a mobile phone or a device connectable to the Internet. If so, the above system can be used.

The member has a portable information terminal including a mobile phone connectable to the Internet, identification code information uniquely set for the member ID of the member is stored in the member table, and the store reads the identification code. It has input means connectable to a management server provided with reading means, and when a member purchases a product or service, the member logs in to the management server with the portable information terminal and displays the member identification code information displayed on the portable information terminal. In the store, the customer management system reads the identification code information by the input means of the store and transmits the sales information including the store ID and the identification code information of the member to the management server.

The owner of the portable information terminal serving as the customer registers personal information including the customer's e-mail address in the web server via the Internet, or the specific store registers the personal information of the member acquired by the specific store. However, since the identification code is allocated and stored in the WEB server in correspondence with the personal information, the identification code is stored in the member table of the WEB server by a connection operation to the WEB server by the owner of the portable information terminal via the Internet. Thus, the identification code can be displayed on the display screen of the portable information terminal.

When purchasing a product or service, the member presents the identification code displayed on the portable information terminal. W
In the member table of the EB server, since the identification code is added corresponding to the individual, the individual can be specified by the presented identification code. In the store, the identification code is read by the reading means, points based on sales of goods or services, for example, based on sales are calculated in the input terminal, and the read identification code (member information), the calculated points, and the store information are stored in the WEB server. Send to The WEB server stores points, for example, in the point table in association with the member table in which the identification code is stored.

[0023] Since the point code can be replaced by the identification code displayed on the portable information terminal, there is no cost for creating a point card at the store. The customer can receive the point service on a portable terminal, a portable information terminal, which is used daily. With a system that has advantages for both stores and customers, WE can be used in stores.
It is easy to implement the point service using the B server. For example, in the case of a WEB server operated by an organization other than a store, the initial cost for constructing the system does not occur, and only the running fee is required. By using such a WEB server in various types of stores, customers can receive a common point service in any stores, and there is a great advantage for both stores and customers.

Input code and point from input terminal to WE
To output to the B server, set the input terminal to L
It is also possible with the current technology to connect to an AN or store the identification code and points in the input terminal and output them to the WEB server in batch processing or on a specific medium, for example, a magnetic disk.

Alternatively, if the input terminal has a configuration connectable to the Internet, by transmitting the identification code and the points to the WEB server via the Internet, it is possible to accumulate the points in the WEB server in real time.

If the members connecting to the web server are specified by the e-mail address set in the mobile phone as the mobile information terminal, the login to the web server becomes easy. That is, when the owner of the mobile phone connects to the WEB server via the Internet, that is, when the mobile phone connects to the Internet, an e-mail address transmitted from the mobile phone is acquired by the WEB server. The acquired e-mail address is the member information, and from this member information, the identification code recorded in the member table of the WEB server can be transmitted to the mobile phone.

[0027]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS A preferred embodiment according to the present invention will be described with reference to FIGS. The reference numeral 1 in FIG. 1 indicates a customer management system 1 using a mobile phone, and the reference numeral 2 indicates a point operation system. The point operation system 2 includes a CPU, a program memory, an arithmetic control unit 3 having various interfaces and communication functions.
a web server 3 (hereinafter referred to as “WE
B server 3 ”), and the WEB server 3 is controlled to read and write by the WEB server 3 below.
A customer table storing personal information including a customer ID registered as a member in the server 3, a password and an e-mail address of a mobile phone (or a telephone number of the mobile phone), an identification code determined according to the personal information, and the like. 4 and customer I
D, a point table 5 for storing accumulated points, etc.,
A store table 6 for recording store names, store IDs, passwords, store addresses, etc., a customer management table 7 for recording customer IDs, store IDs, transaction dates, etc., identification codes, identification code images (for example, barcode images) And the like, a customer ID and a store I to which the customer belongs
An affiliation table 20 for recording D, a customer ID and a non-affiliation table 21 to which the customer has refused affiliation are connected.

Further, the WEB server 3 includes the WEB server 3
Is connected to a mail server 9 for transmitting an e-mail based on the e-mail address and the contents of the e-mail generated in the step (a). The WEB server 3 and the mail server 9 are connected to an Internet provider 10 by a communication line.
You are connected to the Internet via.

The store may be connected to the WEB server 3 via the Internet, or may be connected to the WEB server via a LAN or the like.
An input terminal 11 that can be connected to the server 3 is provided. The input terminal 11 includes a reading unit 12 (for example, a barcode reader) that reads an identification code displayed on a portable information terminal described later, and a display unit 13 that displays input contents. And input means 14 for inputting transaction information (for example, sales amount) relating to the transaction.
(For example, a numeric keypad) and a calculation unit 11a that calculates points based on the transaction information.

The customer has a portable information terminal 15 that can connect to the WEB server 3 via the Internet. When the portable information terminal 15 connects to the WEB server 3, the portable information terminal uses personal information such as an e-mail address or telephone number. Send the number and log in to the WEB server 3,
It has a communication function for acquiring the identification code and a display screen 16 for displaying the acquired identification code. For example, a mobile phone or a portable personal computer having a communication function can be used.

The store solicits and registers the customer as a member of the store. In other words, for example, via the Internet
The WEB server 3 connects to the server 3 and registers the customer's personal information such as a name and an e-mail address (or telephone number), and assigns a customer ID, an identification code, and the like to the customer table 4 in accordance with the personal information. Remember. Thereby, the customer is managed on the point operation system 2 by the customer ID or the identification code. In addition, the customer ID and the store ID are stored in the affiliation table 20 in association with each other.

Alternatively, the customer connects to the WEB server 3 via, for example, the Internet and registers the personal information such as a name and an E-mail address (or telephone number).
The EB server 3 assigns a customer ID, an identification code, and the like corresponding to the personal information and stores the customer ID and the identification code in the customer table 4. Thereby, the customer is managed on the point operation system 2 by the customer ID or the identification code. At this time, affiliation table 2
0 is not stored.

FIG. 9 shows a procedure when a customer purchases a product or service. The customer is the mobile information terminal 1
5 is connected to the web server 3 via the Internet (9-1), and at the time of this connection operation, the portable information terminal sends the web server 3 an e-mail address (or telephone number).
Is transmitted (9-2). The web server 3 sends the transmitted e-mail address (or telephone number) and the e-mail address (or telephone number) stored in the customer table 4.
(9-3), and when the comparison is completed, the WEB server 3 converts the bar code image of the identification code table 8 from the identification code stored in association with the e-mail address (or telephone number) of the customer table 4. Can be acquired by the portable information terminal (9-4). If they do not match, a new registration procedure is shown (9-4b). The customer obtains the barcode image of the identification code from the WEB server 3 (9-5), and more specifically, converts the identification code into a barcode and obtains a barcode image to display the barcode image on the display unit 16. Display (9-6). Alternatively, the user logs in to the WEB server 3 in advance, obtains a barcode image, stores the barcode image in the portable information terminal 1, and reads out and displays the purchased product or service. At this time, the customer logs in to the WEB server 3.

At the store, the reading means 1 of the input terminal 11
2. For example, the barcode image is read by a barcode reader (9-7) and converted into an identification code. Further, the purchase price is input by the input means 14, for example, the ten keys (9-8).
I do. When the purchase price is input, the operation unit 1 of the input terminal 11
In 1a, points are calculated (9-9) by a predetermined point rate (for example, 1%) determined according to the purchase price. By displaying the identification code and the purchase price on the display unit 13, input contents such as the identification code, the purchase price, and the points can be confirmed. After inputting, via the Internet or L
The data such as the identification code and the points and, if necessary, the purchase price are transmitted or output (9-10) from the input terminal 11 to the WEB server 3 through the AN connection.

The points, which are the data sent from the input terminal 11 to the WEB server 3, are accumulated in the point table 5 in association with the customer ID or the identification code (9-1).
1) is done. As a result, points are added corresponding to the personal information, and the WEB server 3 can manage the points for each customer. That is, by using the WEB server 3, the points of the customer can be accumulated in association with the customer ID or the identification code regardless of the store used by the customer.

The store registers store information such as store name, store ID, password, address, telephone number and the like in the store table 6 of the WEB server 3 in advance, and stores the store when transmitting or outputting data from the input terminal 11. By transmitting or outputting the ID, the WEB server 3 can store (9-12) the store ID, the points, the purchase date and time, etc. in the customer management table 7 in association with the customer ID or the identification code. By using the customer management table 7 stored in this way, the store I
By D, the customer ID using the store can be totaled. Therefore, customer information can be retrieved from the customer ID in the customer table 4. That is, the e-mail address of the customer who used the store can be known for each store, and the sales promotion information of the store can be provided to the e-mail address of the customer.
According to the customer management system of the present invention, the point operation system 2 is used in response to a request from a store, and sales promotion information such as bargain sale information can be provided accurately and efficiently only to customers who have used the store.

The above-described data input from the store to the WEB server 3 is performed by a store URL which enables the WEB server 3 to input data from the store via the Internet.
May be provided and an input screen may be set, and if via a LAN, an input form that enables data input from a store may be set in the database of the WEB server 3.

As described above, a mail system based on the customer management system using the portable information terminal of the present invention can be constructed. This will be described with reference to FIGS.

In the present invention, the point operation system 2
Is provided with a mail server 9, and an e-mail address can be searched from a customer ID in a customer table. That is, the customer ID is searched for each store ID from the data of the customer management table 7, and the searched customer ID and the e-mail address of the customer who used the store can be referred from the customer table 4. The store's sales promotion information can be provided to the customer's e-mail address as the inquiry result. Therefore, there is no need to spend expensively creating a paper flyer for sales promotion and distributing it randomly, and accurate and inexpensive e-mail can be used.

If the input terminal 11 makes a request for mail transmission to the WAB server, the input terminal 11
Connects to the B server 3 (10-1), inputs the mail content (10-2), and from the input terminal 11 to the WEB server 3,
If you send the store ID and e-mail contents (10-3), W
The EB server 3 searches for the customer ID for each store ID from the transmitted store ID and the data of the customer management table 7 (1.
0-4), and the e-mail address of the customer who used the store is referred from the searched customer ID and the customer table 4 (10-).
5) Yes. The WEB server 3 transmits the introduced e-mail address and the contents of the e-mail to the mail server 9 (10-6). The e-mail content of the store can be provided on the Internet to the e-mail address of the customer as the inquiry result (10
-7). This not only enables the store to actively and inexpensively provide sales promotion information to customers, but also sends e-mail to customers who have used the store managed by the customer management system. This sales promotion information can be a major purchase motivation for customers.

The e-mail transmission request from the store to the WEB server 3 described above is sent to the WEB server via the Internet.
An input screen may be set by providing an E-mail transmission request URL enabling reception of an E-mail transmission request from the store in the B server 3. It is only necessary to set an input form that enables the user to input data.

Since the transmission of the e-mail to the customer searched by the customer management table 7 is performed irrespective of the customer's intention, the present invention is implemented as follows. That is, the store member who has invited the store is recorded in the affiliation table 20 together with the customer ID as the customer data and the store ID as the store data. Therefore, in response to an e-mail transmission request from the store, the e-mail is transmitted only to the e-mail address of the customer ID associated with the store ID recorded in the affiliation table 20. That is, the store member is a customer who has requested or accepted transmission of an e-mail from the store invited to become a store member. Thus, the e-mail sent from the store to the store member does not become junk mail. The affiliation table 20 may record a plurality of store IDs corresponding to the customer IDs.

When a customer purchases a product or service at a store, purchase data is input to the WEB server 3 from the store, and the customer ID is recorded in the customer management table 7. The affiliation table 20 checks whether the ID is associated with the ID. If the store ID and the customer ID are not associated with each other in the affiliation table 20, in the present invention, the customer ID of the customer management table 7 and the customer's E-mail address are extracted from the customer table 4, and the (mobile) E to the information terminal) asking whether the store promotion information may be transmitted.
send an email. The content is "Thank you email", such as "Thank you for your purchase. Are you sure you want to send the sale information from the XX store in the future?" The URL for reply is described in this e-mail and transmitted.

The customer decides by his / her own e-mail whether or not the information of the store may be transmitted in the future, and transmits the information to the WEB server 3 if the transmission is permitted. That is, the customer connects to the WEB server 3 by the URL described in the e-mail and determines registration / non-registration. When the customer selects the registration, it is recorded in the affiliation table 20. To the customers recorded in the affiliation table 20, the store's sales promotion information is transmitted by e-mail from the store in response to a transmission request.

In addition, in the present invention, when the customer selects non-registration, the customer ID and the store I
D was associated and recorded. Therefore, the customer ID recorded in the customer management table 7 is collated by the web server 3 with the affiliation table 20 and the non-affiliation table 21, and the above-mentioned "thank you mail" is transmitted only when neither is stored. In this way, the customer who once selected non-registered for the store will not receive a "thank you email" from that store, that is, a one-time "thank you email" from that store. Does not.

Referring to FIG. 11, when purchase data is input from a store (11-1), the WEB server 3 records the data in the customer management table 7 (11-2) and refers to the affiliation table 20 with reference to the affiliation table 20. Inquire about whether the customer ID and the store ID are associated with each other (11-3). If it is not related, the customer ID is referred to the non-affiliation table 21.
And whether the store ID is associated with the store ID (11-
4). If not associated, E of the corresponding customer ID
“Thank you email” containing the name of the store, the store ID, and the registered URL is transmitted to the email address (11-5).
The customer who receives the "thank you email" logs in to the URL described in the email and selects registration or non-registration (11-6). The Web server 3 may acquire the store ID and the e-mail address of the customer by this login. When the customer wants to register, the customer ID and the shop ID are recorded in the affiliation table 20 in association with each other (11-7). If the customer desires non-registration, the customer ID and the store ID are recorded in the non-affiliation table 21 in association with each other (11-8). By the way, if the customer does not necessarily reply to the URL of “thank you email” for registration / non-registration, it may be programmed to be non-registered. At this time, a sent flag (sending date, etc.) of “Thank you mail” is stored in the customer management table 7,
If a response is not made through the URL after a lapse of a predetermined period, the program may be programmed so as not to be registered.

By the way, the embodiment in which the input terminal 11 is provided with the calculation section 11a and the input terminal 11 calculates points based on the transaction information has been described, but the calculation control section of the WEB server 3 converts the points into the transaction information in 3a. The points may be calculated based on the points. In this case, by providing a field for recording a point rate, for example, 1% of the sales amount or a value of ○ yen for each transaction in the store table 6 as shown in FIG. The side sends the store code, the sales amount, and the identification code to the WEB server 3 (12-9), and calculates the store code, the sales amount, and the point rate of the store table 6 sent from the input terminal 11 of the store. The point is calculated (12-10) in 3a. The calculated points are accumulated and recorded in the point table 5, and the store ID is stored in the customer management table 7 in association with the customer ID.

[0048]

As described above, there is an e-mail service for a portable information terminal using an Internet mail, for example, a mobile phone. However, a unilateral flow of the sales promotion information on the information providing side may become a junk mail. In other words, it must be performed with the consent of the customer. The accuracy of sales promotion information is that customers understand the provision of information and can provide the information they want in a timely manner, which is useful for customers and stores, and can provide timely sales information. It became.

Further, according to the present invention, the customer can receive a common point service at any store, and the store side does not incur the cost of creating a loyalty card, the customer can be managed, and accurate sales promotion information can be provided to the customer. It is possible to transmit information, that is, to provide accurate sales promotion information to all customers who use the store, including customers who have purchased goods or services at the store, even if they are not members of the store.

In the WEB server, merchandise or service transaction information, that is, points based on sales are stored in the point table in association with the customer table in which the identification code is stored, so that the customer points can be collectively managed by the WEB server. . For the customer, the portable information terminal that is used on a daily basis can be used as a substitute for the point card, the loss and misplacement are extremely reduced, and the point service can be continuously received.

The store can positively provide sales promotion information by e-mail to customers who have transacted goods or services at the store. This makes it possible for the store to actively and accurately provide the sales promotion information to the customer in an immediate manner, and to provide the sales promotion information without missing the sales promotion time. In other words, rather than requesting a provider unrelated to customer management to send out sales promotion information by e-mail, it is possible not only to provide accurate information to customers but also to transmit cheap information by e-mail. became.

[Brief description of the drawings]

FIG. 1 is a diagram illustrating an example of a configuration of a customer management system using a portable information terminal.

FIG. 2 is a diagram showing a customer table 4 of the customer management system.

FIG. 3 is a diagram showing a point table 5 of the customer management system.

FIG. 4 is a diagram showing a store table 6 of the customer management system.

FIG. 5 is a diagram showing a customer management table 7 of the customer management system.

FIG. 6 is a diagram showing an identification code table 8 of the customer management system.

FIG. 7 is a diagram showing an affiliation table 20 of the customer management system.

FIG. 8 is a diagram showing a non-affiliation table 21 of the customer management system.

FIG. 9 is a diagram showing a procedure for accumulating points acquired by a customer.

FIG. 10 is a diagram showing a procedure for transmitting an e-mail address.

FIG. 11 is a diagram showing a procedure for registering in an affiliation table and a non-affiliation table.

FIG. 12 is another diagram showing a second accumulation procedure of points acquired by a customer.

[Explanation of symbols]

 Reference Signs List 1 Customer management system using portable information terminal 2 Point operation system 3 Internet web server 4 Customer table 5 Point table 6 Store table 7 Customer management table 8 Identification code table 9 Email server 10 Internet provider 11 Input terminal 12 Reading means 13 Display Unit 14 input means 15 portable information terminal 16 display screen 20 affiliation table 21 non-affiliation table

──────────────────────────────────────────────────続 き Continued on the front page (51) Int.Cl. ⁷ Identification symbol FI Theme coat ゛ (Reference) G06F 17/60 506 G06F 17/60 506 H04Q 7/38 H04B 7/26 109M

Claims (5)

[Claims] 1. A customer management system for managing a customer who purchases a product or service at a store that provides the product or service by a management server, the store management table including store information including a store ID and a store name; A member table storing member information including a customer's member ID and an e-mail address, an affiliation table storing association of member information of members registered as members by invitation to specific stores and store information of specific stores, The management server is provided with an e-mail transmission function of transmitting the promotion information of the specific store to the e-mail address of the member associated with the specific store information by the table, and the member information of the member who purchased the product or service at the store; Store information for the store that provided the product or service,
Is input to the management server, and in the management server in which the data is input, it is determined whether or not the store and the member are associated in the affiliation table.
A customer management system, wherein an e-mail is sent to the e-mail address of the member asking whether or not to provide the sales promotion information of the store that provided the product or service. 2. A non-affiliation table is provided in the management server, and member information of a member who has not been provided with sales promotion information is associated with store information and stored in the non-affiliation table. When the member information of the member who purchased the service and the store information of the store that provided the product or service are input, it is determined whether or not the store and the member are associated in both the affiliation table and the non-affiliation table And sending an e-mail to the member's e-mail address asking whether or not to provide the sales promotion information of the store that provided the product or service, if the association is not made. Described customer management system. 3. The customer management system according to claim 1, wherein the member information of the member who can provide the sales promotion information and the store information are stored in the affiliation table in association with each other. 4. The management server according to claim 1, wherein the management server is a web server operated on the Internet.
Customer management system according to any of the above. 5. The member has a portable information terminal including a mobile phone connectable to the Internet, identification code information uniquely set for the member ID of the member is stored in the member table, and the store stores the identification code. Member input code means for reading the data and having access means connectable to the management server, and when the member purchases a product or service, the member logs in to the management server with the portable information terminal and displays the member identification code information on the portable information terminal 5. The customer management system according to claim 4, wherein the identification code information is read by the input means of the store at the store, and the sales information including the store ID and the identification code information of the member is transmitted to the management server. .