JP4236432B2 - Sales promotion support system and sales promotion support method - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to a sales promotion support system and a sales promotion support method for providing support when a store that sells goods and services performs sales promotion.
[0002]
[Prior art]
In recent years, customers who purchase goods and services often pay by credit card. For example, if a credit company is affiliated with a large store such as a department store, and a customer purchases an item using a credit card at the department store, the customer pays the department store on behalf of the customer and divides the amount from the customer. Or it collects in a lump. When a customer registers as a member of a credit company, the customer's personal data (member data) such as name, address, date of birth, gender, occupation, family composition, and annual income is reported to the credit company.
On the other hand, when a customer purchases with a credit card, a store such as a department store knows what the customer bought but does not know who bought it. In other words, the customer's personal data is unknown.
On the other hand, as described above, the credit company knows who bought it, that is, the customer's personal data, but does not know what it bought, that is, data related to sales.
[0003]
[Problems to be solved by the invention]
Therefore, by docking information on both the customer membership data held by the credit company and the sales data held by the dealer, a database with high added value can be constructed, and strategic sales promotion can be implemented. However, since both pieces of information contain important personal information, the information cannot be easily transferred due to the problem of personal information protection, and therefore there is a limit to efficient sales promotion.
[0004]
The present invention has been made in view of the above circumstances, and an object thereof is to provide a sales promotion support system and a sales promotion support method capable of efficiently performing sales promotion while protecting personal information. .
[0005]
[Means for Solving the Problems]
  In order to achieve the above object, a sales promotion support system according to claim 1 of the present invention provides:
  Installed in the storeHas a sales information databaseInstalled in a credit card company with a dealer computer, and can communicate with the dealer computerAnd have a member information databaseWith a credit company computer,
  In the sales information database, a credit card member number for identifying a member of a credit company serving as a customer is stored in association with sales information,
  The sales information is a credit card that is registered with the credit company as a member of a product purchased by a member as a customer, such as data related to sales such as a product code, a unit price, a quantity, and an amount of money of the purchased product. A customer who has been given a membership number has data obtained by shopping with the credit card at the store,
  In the member information database, the member information obtained by the customer registering with the credit company, such as data such as name, date of birth, address and telephone number, is associated with the member number of the credit card. RememberedA sales promotion support system,
  The store computer is
  When a member number of the credit card of a customer who should send a direct mail for sales promotion using the sales information database is searched based on the sales information, a member number associated with the sales information is extracted. First 1 ofMembership number extraction means;
  Encrypt the extracted membership numberGet an encrypted membership numberEncryption means;
  An input means for inputting a narrowing condition as a search condition for searching for a member number extracted by searching the sales information database with a member information in a member information database of a credit company of the credit company. , A filtering condition file consisting of the member information input by the input meansA refinement condition generation means for generating,
  The encrypted member number and the generated refinement condition file are transmitted to the credit company computer. 1 ofA communication device,
  The credit company computer
  A second communication device for receiving the encrypted membership number and the filtering condition file transmitted from the store computer;
  Decryption means for decrypting the encrypted membership number transmitted from the store computer;
  Search the member information database including the member information associated with the decrypted member number with the refinement condition transmitted from the store computer.And from the combined membership numberSecond member number extracting means for extracting a member number associated with member information that matches the narrowing-down conditions;
  Based on an instruction from the store, the credit company can send a direct mail to a customer of the store having the membership number extracted by the second membership number extracting means.It is characterized by that.
[0006]
Here, the member number is a number given by the credit company when the customer registers as a member with the credit company, and this member number is often stamped on a credit card lent to the customer.
Sales information is data obtained when a customer purchases goods or services from a store using a credit card. For example, the date and time of purchase, the member store number of the store, the store Sales area code indicating the sales area of the customer, a person-in-charge code indicating the person in charge who has responded to the customer, the total amount of the purchased item, and data relating to sales such as the product code, unit price, quantity and amount of the purchased item.
[0007]
  The stores include large stores such as department stores and other medium-sized and small stores.
  The member information is, for example, personal data such as a customer's name, date of birth, address code, postal code, telephone number, annual income, occupation, gender, and family structure.
  In addition, as a narrowing-down condition, for example, “the purchaser is a housewife who is 40 years old or older and lives in the XX district, and the representative member is a member whose annual income is 8 million yen or more”.The
[0008]
In the sales promotion support system according to claim 1, the sales information database of the store computer is searched under a predetermined search condition, and the member number corresponding to the searched information is extracted by the member number extracting means, The encrypted membership number obtained by encrypting the extracted membership number by the encrypting means and the narrowing condition generated by the narrowing condition generating means are transmitted to the credit company computer on the credit company side. The decryption means decrypts the encrypted member number to obtain the member number, searches the member information database including the member information associated with the member number with the narrowing condition, and matches the narrowing condition The member number associated with the member information is extracted by the member number extracting means, and the extracted member number And transmits the number to the dealer computer, the dealer also be a member information, that personal information is not available, it is possible to know the number of the membership number that matches the narrowing-down conditions. Therefore, support for sales promotion is provided by instructing the credit company to send a direct mail for sales promotion from the credit company to the member whose membership number meets the filtering conditions while protecting the personal information of the member. it can.
In addition, since the credit companies cannot obtain the sales information held by the dealers, the credit companies and the dealers can support sales promotion without obtaining personal information more than the information they own.
[0009]
  The sales promotion support system according to claim 2 is characterized in that in claim 1,
  The credit company computer is provided for each of a plurality of credit companies,
  The sales information database includes a credit company identification code associated with a membership number of the credit card,
  The dealer computerFirstThe membership number extracted by the membership number extraction meansEach based on the credit company identification codeCredit companyCredit company computerIt is characterized by having a sorting means for sorting each.
[0010]
In the sales promotion support system according to claim 2, since the member number extracted by the member number extracting unit is distributed to each credit company by the distributing unit, the encrypted member number obtained by encrypting the member number and the narrowing-down condition are obtained. It can be transmitted easily and reliably to the credit company computer of each credit company.
[0011]
  The sales promotion support system according to claim 3 is characterized in that in claim 2,
  The encryption means includeseachThe membership number is encrypted with a public key designated by a credit company.
[0012]
Here, the public key is a key used when encrypting information, and the encrypted information encrypted by this public key (corresponding to the encrypted member number in this application) is a secret key. Can only decrypt.
In this application, the private key is held by the credit company, and the public key designated by the credit company is used at the store.
[0013]
In the sales promotion support system according to claim 3, since the encryption means encrypts the member number with the public key designated by the credit company, the encrypted member number obtained by encrypting the member number of the credit company is incorrect. Even if it is sent to the credit company computer of another credit company, the member number of the member can be surely protected because the encrypted company number can be decrypted by the credit company computer.
[0014]
  The sales promotion support system according to claim 4 is any one of claims 1 to 3,
  The credit company computer transmits the number of member numbers extracted by the second member number extracting means to the store computer by the second communication device,
  When the store computer receives the number of member numbers extracted by the second member number extracting means by the first communication device,
  In the store, the direct mail is sent to the customer of the member number extracted by the second member number extraction means from the credit company based on the number of the member numbers transmitted from the credit company computer to the store computer. Can decide whether or not to sendIt is characterized by that.
[0015]
Here, the direct mail may be based on FAX or electronic mail, as well as by mail or courier. In the case of e-mail, the e-mail is sent directly to the member from the credit company computer of the credit company.
[0016]
In the sales promotion support system according to claim 4, since the instruction means instructs the credit company whether or not to send a direct mail from the credit company to the member based on the number of member numbers transmitted from the credit company computer, Credit companies can easily know whether or not to send direct mail to members, as well as dealers can give instructions to not send direct mail depending on the number of member numbers, and wasteful sales There is no promotion support.
[0017]
  The sales promotion support method according to claim 5 is:A dealer computer installed in a dealer and having a sales information database; and a credit company computer installed in a credit company and communicable with the dealer computer and having a member information database;
  In the sales information database, a credit card member number for identifying a member of a credit company serving as a customer is stored in association with sales information,
  The sales information is a credit card that is registered with the credit company as a member of a product purchased by a member as a customer, such as data related to sales such as a product code, a unit price, a quantity, and an amount of money of the purchased product. A customer who has been given a membership number has data obtained by shopping with the credit card at the store,
  In the member information database, the member information obtained by the customer registering with the credit company, such as data such as name, date of birth, address and telephone number, is associated with the member number of the credit card. Executed with a memorized sales promotion support systemA sales promotion method,
  The store computer is
  in frontWhen the member number of the credit card of the customer who should send a direct mail for sales promotion using the sales information database is searched based on the sales information, the member number associated with the sales information is extracted. First 1 ofMembership number extraction step;
  An encryption step of obtaining an encrypted membership number by encrypting the extracted membership number;
  An input means for inputting a narrowing condition as a search condition for searching for a member number extracted by searching the sales information database with a member information in a member information database of a credit company of the credit company. , A filtering condition file consisting of the member information input by the input meansA refinement condition generation step to be generated;
  Performing the first communication step of transmitting the encrypted membership number and the generated narrowing condition file to the credit company computer;
  The credit company computer
  A second communication step of receiving the encrypted membership number and the narrow-down condition file transmitted from the store computer;
  in frontEncrypted member number sent from the store computerA decrypting step for decrypting
  Search the member information database including the member information associated with the decrypted member number with the refinement condition transmitted from the store computer.And from the combined membership numberA second member number extracting step of extracting a member number associated with member information that matches the narrowing-down condition;Run
  Based on an instruction from the store, the credit company can send a direct mail to a customer of the store having the membership number extracted by the second membership number extracting means.
[0018]
In the sales promotion support method according to claim 5, the sales information database is searched under a predetermined search condition, a member number corresponding to the searched information is extracted, and the extracted member number is encrypted. The encrypted member number and the narrowing-down conditions are transmitted to the credit company, and the credit company decrypts the transmitted encrypted member number to obtain the member number, and the member information associated with the member number is obtained. Since the member information database provided is searched with the narrowing condition, the member number associated with the member information that matches the narrowing condition is extracted, and the number of the extracted member numbers is sent to the store. Even if the member information, that is, the personal information cannot be obtained at the store, the number of member numbers that match the narrowing-down conditions can be known. Therefore, support for sales promotion is provided by instructing the credit company to send a direct mail for sales promotion from the credit company to the member whose membership number meets the filtering conditions while protecting the personal information of the member. it can.
In addition, since the credit companies cannot obtain the sales information held by the dealers, the credit companies and the dealers can support sales promotion without obtaining personal information more than the information they own.
[0019]
  The sales promotion support method according to claim 6 is a method according to claim 5.In
  The credit company computer is provided for each of a plurality of credit companies,
  The sales information database includes a credit company identification code associated with a membership number of the credit card,
  The store computer uses the membership number extracted in the first membership number extraction step.Each based on the credit company identification codeCredit companyCredit company computerA distribution step is performed for each.
[0020]
In the sales promotion support method according to claim 6, since the membership number extracted in the membership number extraction step is distributed to each credit company, the encrypted membership number obtained by encrypting the membership number and the narrowing down conditions are assigned to each credit company. Can be transmitted easily and reliably.
[0021]
  The sales promotion support method according to claim 7 is the claim6
    The encryption stepsoIseachThe membership number is encrypted with a public key designated by a credit company.
[0022]
In the sales promotion support method according to claim 7, since the member number is encrypted with the public key designated by the credit company, the encrypted member number obtained by encrypting the member number of the credit company is wrong and another credit Even if it is sent to the company's credit company computer, the member's membership number can be reliably protected because the credit company can decrypt the encrypted membership number.
[0023]
  The sales promotion support method according to claim 8 is a method according to claims 5 to 7.In either
  The credit company computer transmits a number of membership numbers extracted in the second membership number extraction step to the store computer,
  By executing the receiving step in which the store computer receives the number of membership numbers extracted in the second membership number extraction step and transmitted in the transmission step,
In the store, the direct mail is sent to the customer of the member number extracted in the second member number extracting step from the credit company based on the number of the member numbers transmitted from the credit company computer to the store computer. Can decide whether or not to sendIt is characterized by that.
[0024]
In the sales promotion support method according to claim 8, since the credit company is instructed whether to send a direct mail from the credit company to the member based on the number of member numbers transmitted from the credit company, the credit company directly In addition to being able to easily know whether or not to send e-mails to members, dealers can issue instructions not to send direct e-mails depending on the number of member numbers, and provide unnecessary sales promotion support There is nothing.
[0025]
  The program according to claim 9 is any one of claims 5 to 8.In the above, the dealer computer is caused to execute the step executed by the dealer computer.
  The program according to claim 10 causes the credit company computer to execute the step executed by the credit company computer in the sales promotion support method according to any one of claims 5, 6, and 8. It is characterized by.
[0026]
  Claim 9Or claim 10In the described invention, the computer according to any one of claims 5 to 8 can be executed.
[0027]
  A recording medium according to an eleventh aspect is characterized in that the program according to the ninth aspect is recorded.
  A recording medium according to claim 12 is recorded with the program according to claim 10.
[0028]
  In the recording medium according to claim 11 or 12, it is possible to cause a computer to execute the method according to any one of claims 5 to 8.
[0029]
DETAILED DESCRIPTION OF THE INVENTION
Hereinafter, embodiments of the present invention will be described with reference to the drawings.
FIG. 1 is a diagram for explaining a schematic configuration of a sales promotion support system according to the present invention. This system includes a store computer 10 of a store 1 such as a department store and a credit company computer 20 of a plurality of credit companies 2. The computer 10 and the computer 20 are connected via a communication network N such as the Internet. It is possible.
[0030]
As shown in FIG. 2, the store computer 10 has a function as a WWW (World Wide Web) server, a CPU (Central Processing Unit) 11, a RAM (Random Access Memory) 12, a recording device 13, An input device 14 such as a keyboard and a mouse, a communication device 15 and the like are configured, and these are connected via a bus 16 and various interfaces. Further, the store computer 10 is connected to the Internet N via the communication device 15.
[0031]
The CPU 11 stores the program stored in the recording device 13 and the data received from the Internet N via the communication device 15 in the RAM 12 and executes various processes according to the application program stored in the RAM 12 in accordance with this instruction and the recorded data. Then, the processing result is temporarily stored in the RAM 12, and the processing result is transmitted to the computer 20 through the communication device 15 via the Internet N.
[0032]
The RAM 12 forms a program storage area for developing various data when the CPU 11 executes a program stored in the recording device 13, and also temporarily stores data related to processing executed by the CPU 11, and an input instruction. And a work area to be processed by the input data.
[0033]
The recording device 13 is a hard disk device that stores programs, data, and the like. The hard disk device 13 includes a database storage unit 30 and a program information storage unit 31.
The database storage unit 30 stores a sales information database 32. As shown in FIG. 4, the sales information database 32 includes a credit company identification code 33 for identifying the credit company 2, a credit card member number 34 for identifying a member, and sales information 35. The sales information 35 is stored in association with the member number 34.
[0034]
The sales information 35 includes the date and time of sale, the member store number of the store, the sales floor code indicating the sales floor of the store, the contact code indicating the person in charge who has responded to the customer, the total amount of the purchase, Data relating to sales such as product code, unit price, quantity, amount of money, etc. of purchased items.
The sales information 35 includes the date and time of purchase, the store member number of the store, the sales floor code indicating the sales floor of the store, the contact code indicating the person in charge of the customer, The total amount of purchased items is stored as one set, and the product code, unit price, quantity, and amount of purchased items are stored as one set in the lower layer.
[0035]
The program information storage unit 31 stores an extraction program for performing a process of searching the sales information database 32 under a predetermined search condition and extracting a member number corresponding to the searched information. The program is developed on the RAM 12 by the CPU 11 and executed. Therefore, the member number extracting means for searching the sales information database 32 under a predetermined search condition and extracting the member number corresponding to the searched information is constituted by the CPU 11, RAM 12, extraction program, and the like.
Further, the program information storage unit 31 stores an encryption program for performing processing for encrypting the extracted membership number, and this encryption program is developed in the RAM 12 by the CPU 11 and executed. Therefore, the encryption means for encrypting the extracted membership number is composed of the CPU 11, RAM 12, encryption program, and the like. The encryption program functions with a public key, and this public key is designated by each credit company 2.
[0036]
The program information storage unit 31 stores a distribution program for performing a process of distributing the member number extracted by the member number extracting means for each credit company 2 based on the credit company identification code. The program is developed on the RAM 12 by the CPU 11 and executed. Therefore, the distribution means for distributing the extracted membership number for each credit company is constituted by the CPU 11, the RAM 12, a distribution program, and the like.
[0037]
Further, the store computer 10 is provided with narrowing condition generation means for generating narrowing conditions further narrowing down the search conditions. The narrowing-down condition generating means includes an input device 14 such as a keyboard and a mouse, and a generating program that generates the narrowing-down conditions input from the input device 14 as a file such as a text file. Stored in the program information storage unit 31.
Further, the store computer 10 includes instruction means for instructing the credit company whether to send a direct mail from the credit company to the member based on the number of member numbers transmitted from the computer 20 of the credit company. This instructing means operates the input means 14 such as a keyboard or a mouse in accordance with the number of member numbers transmitted, and transmits to the credit company computer 20 whether or not to send a direct mail to the member. Etc. are constituted.
[0038]
As shown in FIG. 3, the credit company computer 20 has a function as a WWW (World Wide Web) server, and includes a CPU (Central Processing Unit) 21, a RAM (Random Access Memory) 22, a recording device 23, and the like. The input device 24 such as a keyboard and a mouse and the communication device 25 are connected via a bus 26 and various interfaces. The credit company computer is connected to the Internet N via the communication device 15.
[0039]
The recording device 23 is a hard disk device that stores programs, data, and the like. The hard disk device 23 includes a database storage unit 40 and a program information storage unit 41.
A member information database 42 is stored in the database storage unit 40. As shown in FIG. 5, the member information database 42 is data 43 composed of a plurality of member information, and each member information includes a customer's name, date of birth, address code, postal code, telephone number, annual salary, There is personal data such as occupation, gender, family composition. These data 43 are stored in association with the credit card member number 44.
[0040]
Further, the program information storage unit 41 stores a decryption program for performing a process of decrypting the encrypted member number transmitted from the store computer 10, and this decryption program is expanded in the RAM 22 by the CPU 21. To be executed. Therefore, the encryption means for decrypting the encrypted member number is composed of the CPU 21, RAM 22, decryption program, and the like. This decryption program functions with a secret key, and this secret key is held secretly by each credit company 2.
Further, in the program information storage unit 41, the member information database 42 is searched with the narrowing condition transmitted from the store computer 10, and the member number associated with the member information that matches the narrowing condition is extracted. An extraction program is stored, and this extraction program is expanded in the RAM 22 by the CPU 21 and executed. Therefore, the member number extraction means for searching the member information database 42 with the narrowing condition and extracting the member number associated with the member information that matches the narrowing condition is constituted by the CPU 21, RAM 22, extraction program, and the like. Yes.
[0041]
Then, the number of member numbers extracted by the member number extracting means is transmitted to the store computer via the communication device 25 via the Internet N.
[0042]
Next, an example of a method for supporting sales promotion by the above-described sales promotion support system will be described with reference to FIG.
First, when the customer registers with the credit company 2, the membership number is given and the customer's member data is registered with the credit company computer 20.
Then, when the registered member makes a purchase at the department store 1 using a credit card, the member number and sales information are registered in the store computer 10 of the department store 1. Then, as the members successively shop, the member number and sales information are stored in the sales information database 32 of the store computer 10.
Next, the department store 1 searches the sales information database 32 under conditions necessary for sales promotion, and extracts a member number corresponding to the searched information (member number extraction step). The condition is, for example, “a person who bought a scarf made of XX company at 30000 yen or more at the XX store in the last month of last month”.
[0043]
Next, the extracted membership number is assigned to each credit company that has been contracted in advance to use this system (assignment step).
Next, the assigned member number is encrypted to obtain an encrypted member number (encryption step). In this case, the membership number is encrypted using the public key designated for each credit company.
[0044]
Next, a narrow-down condition further narrowing down the search condition is generated (a narrow-down condition generating step). As a narrowing-down condition, for example, “a purchaser is a housewife who is 40 years old or older and lives in the XX district, and a representative member has a monthly income of 8 million yen or more”.
Next, the narrowing-down conditions and the encrypted member number are transmitted to the credit company (number condition transmission step). At this time, instructions for sending direct mail to members are also attached.
Then, the encrypted member number, narrowing conditions, instructions, etc. are transmitted from the store computer 10 to the credit company computer 20 of the credit company via the Internet.
[0045]
  Next, the credit company decrypts the transmitted encrypted member number to obtain a member number (decryption step).
  Next, the member information database 42 having the member information associated with the decrypted member number is searched with the narrowing condition transmitted from the store computer 10, and the member information matching the narrowing condition is obtained. Extract associated member number (membership number extraction step).
  NextThen, the number of the extracted membership numbers is transmitted to the store computer 10 (number transmission step).
[0046]
The dealer instructs the credit company whether or not to send a direct mail from the credit company to the member based on the number of member numbers transmitted from the credit company computer 20 (instruction step). This instruction may be transmitted from the dealer computer 10 to the credit company computer 20 via the Internet, or may be instructed from the dealer to the credit company by FAX or telephone.
[0047]
When the credit company receives an instruction to send a direct mail to a member, it sends a direct mail for sales promotion to each of the extracted members. Direct mail may be sent by FAX or electronic mail as well as by mail or courier. In the case of e-mail, the e-mail is sent directly to the member from the credit company computer 20 of the credit company.
[0048]
Thus, according to the present embodiment, the following effects can be obtained. (1) Search the sales information database with a predetermined search condition, extract the member number corresponding to the searched information, and further narrow down the encrypted member number obtained by encrypting the extracted member number The credit company transmits the conditions to the credit company computer 10, and the credit company decrypts the encrypted member number to obtain the member number, searches the member information database with the narrowing condition, and obtains the member information that matches the narrowing condition. Since the associated member number is extracted and the number of the extracted member numbers is transmitted to the store computer 20, even if member information, that is, personal information cannot be obtained at the store, it matches the narrowing-down conditions. You can know the number of member numbers to be registered. Therefore, support for sales promotion is provided by instructing the credit company to send a direct mail for sales promotion from the credit company to the member whose membership number meets the filtering conditions while protecting the personal information of the member. it can.
In addition, since the credit companies cannot obtain the sales information held by the dealers, the credit companies and the dealers can support sales promotion without obtaining personal information more than the information they own.
[0049]
(2) Since the extracted member number is assigned to each credit company, the encrypted member number obtained by encrypting the member number and the narrowing-down conditions can be transmitted easily and reliably to the credit company computer of each credit company.
(3) Since the membership number is encrypted with the public key specified by the credit company, the encrypted membership number obtained by encrypting the membership number of the credit company is wrongly sent to the credit company computer of another credit company. However, since the encrypted membership number can be decrypted with the credit company computer, the membership number of the member can be reliably protected.
[0050]
(4) Since the credit company is instructed whether or not to send a direct mail to the member based on the number of member numbers transmitted from the credit company computer, the credit company can easily determine whether or not to send a direct mail to the member. Of course, the dealer can issue an instruction not to send a direct mail according to the number of member numbers, and there is no useless sales promotion support.
(5) Since the dealer computer 10 and the credit company computer 20 are connected via the Internet, it is possible to perform almost real time from the membership number extraction by the search condition to the instruction of whether or not to send the direct mail. Can support sales promotion.
(6) Since there is no third party organization between the dealer and the credit company, it is possible to prevent leakage of personal information more reliably, and it is not necessary to construct a database for the third party organization. It is advantageous in terms of cost.
[0051]
Needless to say, the present invention is not limited to the present embodiment, and various modifications can be made without departing from the scope of the present invention. For example, in the above embodiment, a department store has been described as an example of a dealer. However, a dealer is not limited to this. For example, a securities company that sells securities and bonds, an insurance company that sells insurance, securities, and regular It may be a bank that sells loans, sells bank accounts, or lends.
[0052]
【The invention's effect】
As described above, according to the present invention, the retailer cannot obtain the customer's personal information (member information), and the credit company cannot obtain the customer's sales information. Sales outlets and credit companies will be provided with means of sales promotion without obtaining personal information beyond the information they own. That is, sales promotion can be performed efficiently while protecting personal information.
[Brief description of the drawings]
FIG. 1 shows an example of a sales promotion support system according to an embodiment of the present invention, and is a diagram for explaining a schematic configuration of the system.
FIG. 2 is a block diagram of a store computer.
FIG. 3 is a block diagram of the credit company computer.
FIG. 4 is a diagram showing the structure of a sales information database.
FIG. 5 is a diagram showing the structure of a member information database.
FIG. 6 is a diagram for explaining the flow of information for explaining the sales promotion support method.
[Explanation of symbols]
1 department store
2 credit companies
10 Dealer computer
20 credit company computers
32 Sales information database
34,34 membership number
42 Member Information Database
N Internet (communication network)

Claims (12)

A dealer computer installed in a dealer and having a sales information database; and a credit company computer installed in a credit company and communicable with the dealer computer and having a member information database ;
The front Symbol sales information database, and the membership number of the credit card used to identify the members of the credit company, which became a customer, and the sales information is stored in association with each other,
The sales information is a credit card that is registered with the credit company as a member of a product purchased by a member as a customer, such as data related to sales such as a product code, a unit price, a quantity, and an amount of money of the purchased product. A customer who has been given a membership number has data obtained by shopping with the credit card at the store,
In the member information database, the member information obtained by the customer registering with the credit company, such as data such as name, date of birth, address and telephone number, is associated with the member number of the credit card. A memorized sales promotion support system,
The store computer is
When a member number of the credit card of a customer who should send a direct mail for sales promotion using the sales information database is searched based on the sales information, a member number associated with the sales information is extracted. and the first of the membership number extracting means for,
An encryption means for obtaining an encrypted membership number by encrypting the extracted membership number ;
An input means for inputting a narrowing condition as a search condition for searching for a member number extracted by searching the sales information database with a member information in a member information database of a credit company of the credit company. Narrowing condition generation means for generating a narrowing condition file composed of the member information input by the input means ;
A first communication device that transmits the encrypted membership number and the generated refinement condition file to the credit company computer ;
The credit company computer
A second communication device for receiving the encrypted membership number and the filtering condition file transmitted from the store computer;
Decryption means for decrypting the encrypted membership number transmitted from the store computer;
The member information database including the member information associated with the decrypted member number is searched with a narrowing condition transmitted from the store computer, and the narrowed member number matches the narrowing condition. Second member number extracting means for extracting a member number associated with the member information to be
Based on an instruction from the store, the credit company can send a direct mail to a customer of the store having the membership number extracted by the second membership number extraction means at the credit company. Support system. The sales promotion support system according to claim 1,
The credit company computer is provided for each of a plurality of credit companies,
The sales information database includes a credit company identification code associated with a membership number of the credit card,
The store computer includes a distribution unit that distributes the membership number extracted by the first membership number extraction unit for each credit company computer of each credit company based on the credit company identification code. Sales promotion support system. In the sales promotion support system according to claim 2 ,
The sales promotion support system, wherein the encryption means encrypts a member number with a public key designated by each credit company. In the sales promotion support system according to any one of claims 1 to 3,
The credit company computer transmits the number of member numbers extracted by the second member number extracting means to the store computer by the second communication device,
When the store computer receives the number of member numbers extracted by the second member number extracting means by the first communication device,
In the store, the direct mail is sent to the customer of the member number extracted by the second member number extraction means from the credit company based on the number of the member numbers transmitted from the credit company computer to the store computer. A sales promotion support system characterized by being able to decide whether or not to send a message . A dealer computer installed in a dealer and having a sales information database; and a credit company computer installed in a credit company and communicable with the dealer computer and having a member information database;
In the sales information database, a credit card member number for identifying a member of a credit company serving as a customer is stored in association with sales information,
The sales information is a credit card that is registered with the credit company as a member of a product purchased by a member as a customer, such as data related to sales such as a product code, a unit price, a quantity, and an amount of money of the purchased product. A customer who has been given a membership number has data obtained by shopping with the credit card at the store,
In the member information database, the member information obtained by the customer registering with the credit company, such as data such as name, date of birth, address and telephone number, is associated with the member number of the credit card. A sales promotion method executed by a stored sales promotion support system ,
The store computer is
When a member number of the credit card of a customer who should send a direct mail for sales promotion using the sales information database is searched based on the sales information, a member number associated with the sales information is extracted. and the first of the membership number extraction step of,
An encryption step of obtaining an encrypted membership number by encrypting the extracted membership number;
An input means for inputting a narrowing condition as a search condition for searching for a member number extracted by searching the sales information database with a member information in a member information database of a credit company of the credit company. A refinement condition generation step for creating a refinement condition file made up of the member information input by the input means ;
Performing the first communication step of transmitting the encrypted membership number and the generated narrowing condition file to the credit company computer ;
The credit company computer
A second communication step of receiving the encrypted membership number and the narrow-down condition file transmitted from the store computer ;
A decryption step of decrypting the encrypted membership number transmitted from the store computer ;
The member information database including the member information associated with the decrypted member number is searched with a narrowing condition transmitted from the store computer, and the narrowed member number matches the narrowing condition. A second member number extracting step of extracting a member number associated with the member information to be performed,
Based on an instruction from the store, the credit company can send a direct mail to a customer of the store having the membership number extracted by the second membership number extraction means at the credit company. Support method. The sales promotion support method according to claim 5,
The credit company computer is provided for each of a plurality of credit companies,
The sales information database includes a credit company identification code associated with a membership number of the credit card,
The dealer computer executes a distribution step of distributing the membership number extracted in the first membership number extraction step for each credit company computer of each credit company based on the credit company identification code. Sales promotion support method. The sales promotion support method according to claim 6 ,
In the encryption step , the membership number is encrypted with a public key designated by each credit company. In the sales promotion support method according to any one of claims 5 to 7,
The credit company computer transmits a number of membership numbers extracted in the second membership number extraction step to the store computer,
By executing the receiving step in which the store computer receives the number of membership numbers extracted in the second membership number extraction step and transmitted in the transmission step,
In the store, the direct mail is sent to the customer of the member number extracted in the second member number extracting step from the credit company based on the number of the member numbers transmitted from the credit company computer to the store computer. A sales promotion support method characterized in that it is possible to decide whether or not to send a message . 9. The sales promotion support method according to claim 5 , wherein the store computer executes the step executed by the store computer .   9. The sales promotion support method according to claim 5, wherein the credit company computer executes the step executed by the credit company computer.   A computer-readable recording medium on which the program according to claim 9 is recorded.   A computer-readable recording medium on which the program according to claim 10 is recorded.

Images