JPH04306763A - Customer data management device - Google Patents

Abstract

PURPOSE:To improve service for a customer by outputting delivery destination customer data stored in a customer data storage means by means of the retrieval of delivery source customer data with delivery source customer data to a printer so as to improve service for the customer in a store executing the delivery work of a product. CONSTITUTION:In the customer data management device of a florist, a customer master file, a store master film and the like are provided for RAM, and the work processings of customer data setting, customer data retrieval, store retrieval and direct mail generation are provided. customer data setting work, delivery source customer data being the delivery requester of the product is stored in the areas 9a-9c of the costomer record 9o of the customer master file, and delivery destination customer data is store in areas 9d-9m. In customer data retrieval work, the customer master file is retrieved with the name and the telephone number of the delivery source as retrieval keys. A customer list is outputted to the printer based on the content of all the detected customer record 9.

Description

[Detailed description of the invention]

0001

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a customer data management device.

0002

[Prior Art] Traditionally, in various stores that sell flowers and gifts and deliver them, the price of the product and the delivery fee are entered into an electronic cash register, and then the delivery Original name, address, telephone number, and
After filling out the name, address, telephone number, etc. of the recipient on a multiple-page delivery slip (carbonless paper, etc.) prepared in advance, attach each slip to the delivered product or use it as a copy for the store. They file it in a ledger, keep it, and then hand it over to the customer as a copy.

0003

[Problem to be Solved by the Invention] Generally, some stores that carry out delivery operations for such products do not keep store copies as described above, and even if they do store store copies, However, it is merely a "reserve" and it is virtually impossible to manage customers based on it.

[0004]Furthermore, some stores manage customer data such as the customer's name and address written on delivery slips, etc. by inputting it into a customer data management device. The target of management is only data related to the customer who is the delivery source. That is,
It is not possible to manage data related to delivery destinations, such as who sent what products to whom.

[0005] For this reason, even if the product is delivered based on a request from the customer, there are cases where the same product as the previous product is delivered to the same destination.

[0006]Furthermore, even if you are a regular customer who regularly purchases products such as year-end gifts, birthday presents, etc. every year and requests delivery to the same delivery address, you must confirm the delivery address each time you receive a delivery request. Furthermore, if the request is made by telephone, it will be difficult to confirm the delivery destination, and as a result, the delivery may be made with a misspelled name, address, etc.

[0007] On the other hand, in a store having a sales network such as branches in various locations, if the delivery destination of the product is a remote location, the product may be delivered from the store closest to the delivery destination. In such cases, the store that receives the product delivery request will
After searching for the nearest store from a ledger or the like based on the address of the delivery destination, a request is made to the store to deliver the product. This work is very troublesome and time consuming.

[0008]

[Means for solving the problem] The invention according to claim 1 includes:
A customer data storage means, based on the input data from the input means, associates the delivery source customer data regarding the customer who requested delivery of the product with the delivery destination customer data regarding the customer who is the delivery destination of the product, and stores the customer data. customer data storage means for storing in a storage means; and delivery source customer data retrieval means for searching the customer data storage means for delivery source customer data based on at least part of the delivery source customer data inputted by the input means. and, when the delivery source customer data is detected by the delivery source customer data search means, the delivery destination customer data stored in the customer data storage means corresponding to the delivery source customer data is outputted together with the delivery source customer data. and a customer data output means for outputting to.

[0009] Furthermore, the invention according to claim 2 provides a store data storage means in which store data regarding various stores included in the sales network is stored in advance, and a store data storage means for storing store data based on address data inputted by an input means. a store data search means for searching store data; and a store data output means for outputting store data to an output means when the store data search means detects store data having location data that substantially matches the address data. has been established.

0010

[Operation] The invention as claimed in claim 1 corresponds the delivery source customer data regarding the customer who is the person who requested delivery of the product and the delivery destination customer data regarding the customer who is the delivery destination of the product based on the input data from the input means. The customer data storing means stores the shipping source customer data in the customer data storage means, and performs a shipping source customer data search on the customer data storage means based on at least part of the shipping source customer data inputted by the input means. When the delivery source customer data is detected, the delivery destination customer data stored in the customer data storage means corresponding to the delivery source customer data is sent to the output means together with the delivery source customer data. Output by

[0011] Furthermore, the invention as set forth in claim 2 is such that store data regarding various stores included in the sales network is stored in advance by the store data storage means, and store data is stored in the store data storage means based on the address data inputted by the input means. A data search is performed by a store data search means, and when store data having location data that substantially matches the address data is detected, the store data output means outputs the store data to an output means.

0012

DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described with reference to FIGS. 1 to 13. As shown in FIG. 2, this customer data management device 1 consists of a device main body 2, a display 3 disposed on the top thereof, and a floppy disk device 4 connected to the device main body 2. .

However, the device main body 2 has a keyboard 5 on its top surface as an input means used for inputting various data such as customer data, and various data processing executed based on the input data from the keyboard 5. A printer 6 or the like is provided as an output means for printing the processing results.

Furthermore, this customer data management device 1 has a hardware configuration as shown in FIG. That is, a microcomputer is formed by connecting the ROM 8 and RAM 9 to the CPU 7, and
U7 includes a clock circuit 10, a printer controller 6a connected to the printer 6, a display controller 3a connected to the display 3, a keyboard controller 5a connected to the keyboard 5, and the floppy disk device. 4, a floppy disk controller 4a, etc. are connected to the floppy disk controller 4a.

However, the ROM 8 stores in advance fixed data such as programs for performing various data processing related to customer data.

Further, as shown in FIG. 4, the RAM 9 includes a name area 9a, an address area 9b, a telephone number area 9c, a desired arrival date area 9d, and a usage classification area 9.
e, direct mail classification area 9f, name area 9g, address area 9h, postal code area 9i, telephone number area 9j, type area 9k, and color area 9.
A customer master file (not shown) in which a large number of customer records 9o are formed, each consisting of a flower type area 9m, an unused area 9n, a postal code area 9p, and a telephone number as shown in FIG. Area 9q, store name area 9r,
A store master file (not shown) including a large number of store records 9w consisting of an address area 9s, a person in charge name area 9t, a closed day area 9u, and a business hours area 9v, and a work buffer area (not shown) ) and various data areas such as a counter area used for counting.

However, the customer master file is used as a customer data storage means. That is, the name area 9a, the address area 9b, and the telephone number area 9c in this customer master file are areas for storing in advance delivery source customer data regarding the customer who requests delivery of the product, The remaining areas are the desired arrival date area 9d and the usage classification area 9e.
, the direct mail classification area 9f, the name area 9g, the address area 9h, the postal code area 9i, the telephone number area 9j, the type area 9k, the color area 9l, and the flower species. Area 9m (77 BYTE in total) is an area for pre-storing delivery destination customer data regarding the customer to whom the product will be delivered, in correspondence with the delivery source customer data. 12 items (77 BYTE
x12) was formed.

Furthermore, in the store master file, the postal code area 9p and the telephone number area 9q
, store name area 9r, address area 9s, person in charge name area 9t, closed days area 9u, business hours area 9
v is store data of various stores included in the sales network stored in advance. That is, this store master file forms a store data storage means.

[0019] This customer data management device uses the same technology as before, and after turning on the power, performs "1. Customer data setting business,""2. Customer data search business,""3. Store search business," and "4. Direct." Executes the process of displaying the task selection screen with four menus, ``E-mail creation task'', and selects one of these menus from the keyboard 5.
When selected using the numeric keypad (not shown), the selected task is executed, and when the task is completed, the program returns to the display process of the task selection screen.

In such a configuration, first, in order to obtain delivery source customer data and delivery destination customer data (hereinafter referred to collectively as customer data) to be set in the customer master file, the steps shown in FIG. As shown, the name, address, and phone number of the shipping source (shipping source customer data), the name, address, postal code, phone number, and product type and color of the shipping destination. Create an application form in advance with fields for the flower species, usage category, desired arrival date, direct mail category (delivery destination customer data), and message, and fill it out when requesting product delivery. The customer fills in the necessary information in each column of this application form. Then, the operator performs customer data setting work while referring to this application form.

As described above, this customer data setting task is executed by the customer data storage means when "1. Customer data setting task" is selected on the task selection screen, and is executed as shown in FIG. When the input of the delivery source customer data is completed, the delivery source customer data is stored in the corresponding area in the customer master file, and then the delivery destination customer data is waited for input, and when the input is completed. At this time, the delivery destination customer data is stored in the corresponding area in the customer master file, and the process ends.

[0022] In addition, when "2. Customer data search business" is selected on the business selection screen, as shown in Figure 1, the name and telephone number (
When these are input, the name is set to UNAME, the phone number is set to UTEL, the counter is cleared, and the first digit of UTEL is entered. After setting the key as a key and searching the customer master file for the customer record 9o (delivery source customer data) (search process 1), the corresponding phone number is stored in the phone number area 9c. It is determined whether the customer record 9o has been detected.

[0023] If it is determined that the customer record 9o in which the corresponding telephone number is stored in the telephone number area 9c is not detected, the process is terminated after printing the message "No corresponding customer data". do.

[0024] Furthermore, if it is determined that a customer record 9o in which the corresponding telephone number is stored in the telephone number area 9c is detected, after adding +1 to the counter, it is determined whether the counter value is 10 or not. If it is determined that the counter value is not 10, the next 1 of UTEL is determined.
After setting the digit as a key, return to the search process 1 described above, and if it is determined that the counter value is 10, the process shown in FIG.
As shown in , after clearing the counter, the first digit of UNAME is set as a key, and based on this key, the customer master file is searched for customer record 9o (search process 2), and the corresponding Name is name area 9
It is determined whether the customer record 9o stored in a is detected.

If it is determined that the customer record 9o in which the corresponding name is stored in the name area 9a is not detected, a message "No corresponding customer data" is printed, and then the process is terminated.

[0026] Furthermore, if it is determined that a customer record 9o in which the corresponding name is stored in the name area 9a is detected, +1 is added to the counter, and then it is determined whether the counter value is 20 or not. However, if it is determined that the counter value is not 20, the next digit of UNAME is set as a key, and then the process returns to the above-mentioned search process 2. If it is determined that the counter value is 20, Based on the stored contents of all detected customer records 9o, print data is output to the printer 6 by the customer data output means,
As a result, a customer list as shown in FIG. 9 is issued.

Note that the above-mentioned search process 1 and search process 2 are both processes executed by the delivery source customer data search means.

[0028] Furthermore, when "3. Store search business" is selected on the business selection screen, as shown in FIG.
First, the postal code and telephone number (address data) of the delivery destination, which are the key to the search, are in a waiting state for input. When the postal code and telephone number of the delivery destination are input, the postal code is set to UPOST. Then, set the telephone number in UTEL, divide this UTEL into UTEL1 (upper 4 digits of the upper 6 digits) and UTEL2 (lower 2 digits of the upper 6 digits), clear the counter, and then , said U.T.
After setting the first digit of EL1 as a key and searching the store master file for the store record 9w based on this key (search process 3), the corresponding telephone number is stored in the telephone number area 9q. Store record 9w
is detected.

If it is determined that the store record 9w in which the corresponding telephone number is stored in the telephone number area 9q is not detected, the process ends after printing a message "No corresponding store data". do.

Furthermore, if it is determined that a store record 9w in which the corresponding telephone number is stored in the telephone number area 9q is detected, after adding +1 to the counter, it is determined whether the counter value is 4 or not. If it is determined that the counter value is not 4, the next digit of UTEL1 is set as a key, and then the process returns to the above-mentioned search process 3. If the counter value is determined to be 4, , as shown in Figure 11, after clearing the counter, the top 1 of UPOST
After setting the digit as a key and searching the store record 9w against the store master file based on this key (search process 4), the store record 9w whose corresponding postal code is stored in the postal code area 9p is searched. is detected.

[0031] If it is determined that the store record 9w in which the corresponding postal code is stored in the postal code area 9p is not detected, the process is finished after printing a message "No corresponding store data". do.

[0032] Furthermore, if it is determined that a store record 9w in which the corresponding postal code is stored in the postal code area 9p is detected, after adding +1 to the counter, it is determined whether the counter value is 5 or not. If it is determined that the counter value is not 5, the next 1 digit of UPOST is set as a key, and then the process returns to the above-mentioned search process 4. If the counter value is determined to be 5, , After storing all the detected store records 9w in the work buffer area, clear the counter and UT
After setting the first digit of EL2 as a key and searching the store master file for the store record 9w based on this key (search process 5), the corresponding telephone number is stored in the telephone number area 9q. Store record 9w
is detected.

If it is determined that the store record 9w in which the corresponding telephone number is stored in the telephone number area 9q is not detected, print data is output to the printer 6 based on the contents stored in the work buffer area and the store record 9w is stored in the telephone number area 9q. A list is issued (store list issuing process 1), and the store record 9w stores the corresponding telephone number in the telephone number area 9q.
If it is determined that the counter value is detected, +1 is added to the counter, and then it is determined whether the counter value is 2 or not. If the counter value is not 2, the above-mentioned value is added to the work buffer area. Store record 9w as detection result
After storing only the UT and updating its memory contents, the UT
Set the next digit of EL2 as a key and return to the above-mentioned search process 5. Also, if the counter value is determined to be 2, print data is sent to the printer 6 based on the contents stored in the work buffer area. Output and issue a store list (
Store list issuing process 2).

Note that the above-mentioned search processing 3, search processing 4, and search processing 5 are all processes executed by the store data search means. In addition, the above-mentioned store list issuance process 1,
The store list issuing process 2 is a process performed by the store data output means. Furthermore, the location data is the zip code area 9p in the store record 9w.
It consists of the postal code stored in , and the telephone number stored in telephone number area 9q.

Furthermore, if "4. Direct mail creation business" is selected on the business selection screen, the screen shown in FIG.
As shown in , first, the system waits for the input of the desired arrival date, which is the key to the search, and the two desired arrival dates (
(from when to when) is entered, after setting those desired arrival dates as keys, the customer master file is searched for customer record 9o based on these keys, and the corresponding desired arrival date is entered in the desired arrival date area. It is determined whether the customer record 9o stored in 9d has been detected.

[0036] The corresponding desired arrival date is the desired arrival area 9d.
If it is determined that the customer record 9o stored in the customer record 9o has been detected, the direct mail classification stored in the direct mail classification area 9f of the customer record 9o is "00" (if you wish to send direct mail). If it is determined that the direct mail classification is "00", the usage classification stored in the usage classification area 9e is "0x" (first digit is 0: celebration). ), and if it is determined that the usage classification is "0x", print data is output to the printer 6 based on the stored content of the customer record, and print data for direct mail is determined. Have a label issued.

Furthermore, when the issuance of this direct mail label is completed, or when it is determined in the above-described determination process that the direct mail classification stored in the direct mail classification area 9f is not "00",
Alternatively, in the above determination process, the usage classification area 9e
The usage classification stored in is "0x" (the first digit is 0)
If it is determined that it is not, the process returns to the above-described search process for the customer record 9o in the customer master file.

[0038] Furthermore, in the judgment process after the search process for the customer record 9o in this customer master file, if it is judged that the customer record 9o whose corresponding desired arrival date is stored in the desired arrival date area 9d is not detected. Processing ends.

Since such processing is performed, the operator first executes "1. Customer data setting task" and inputs customer data while referring to the contents written on the application form. Then, in response to a request from a customer, execute "2. Customer data search operation" and input the customer's name and phone number to issue a customer list with the customer's past delivery history printed. I can do it.

[0040] In other words, in addition to the delivery source customer data, it is possible to manage the corresponding delivery destination customer data, so when the same customer selects a product for the second time or later, the previous delivery destination, delivery product, delivery date, etc. This makes it possible to provide customers with delivery destination customer data such as value-added information, which prevents the delivery of the same product to the same destination, and also prevents the delivery of products from the second time onwards to the same destination. By simplifying the previous confirmation, it is possible to improve customer service and retain customers. Furthermore, by making effective use of the delivery destination customer data and approaching the delivery destination for sales, it is possible to expand sales of the product.

[0041] In addition, when requesting delivery to a store included in the sales network, such as when the delivery destination is in a remote location, execute "3. Store search operation" and enter the postal code and telephone number of the delivery destination. By inputting , you can issue a list of stores with printed data about the stores closest to the delivery destination.

That is, by simply inputting the postal code and telephone number of the delivery destination using the keyboard 5, the postal code and telephone number will almost match (in the case of this embodiment, at least the first four digits of the telephone number and the postal address) Since store data with location data (matching number) is issued as a store list by the printer 6, you can easily find the store closest to the delivery destination among the various stores included in the sales network without having to look up ledgers or the like. can be found.

Furthermore, by executing "4. Direct mail creation service" and inputting two desired arrival dates indicating a predetermined period, you can confirm that you wish to send a direct mail when requesting delivery of a past product, and Direct mail labels can be issued only to customers whose products are celebratory gifts, which streamlines direct mail shipping operations and at the same time further customer retention. It becomes possible.

[0044] In this embodiment, a customer list is issued as the execution result of "2. Customer data search operation",
Although we have described the case where a store list is issued as the execution result of "3. Store search task", the present invention is not limited to this. In addition, a store data area is added to the storage area for delivery destination customer data in the customer master file (for example, using unused area 9n in FIG. 4), and the search results by the store data search means are added to this store data area. By providing a means for storing store data and a means for outputting the stored contents, it is possible to know the nearest store without searching for store data when the product is delivered for the second time or later to a past delivery destination. Furthermore, by adding a function as an electronic cash register to this customer data management device 1, we will implement a device that can manage both sales data and customer data. I can do it.

Furthermore, the customer data management device 1 of this embodiment
Although it is intended for flower shops, it is not limited to this, but by changing the content of customer data and configuring the device accordingly, it can be used for other delivery services such as department stores and various specialty stores. It is possible to implement a customer data management device for stores in the same way, and it is particularly effective for stores that deliver products in connection with ceremonial occasions, etc., in other words, stores where the delivery time of products is fixed. Become something.

[0046]

[Effects of the Invention] As described above, the invention according to claim 1 provides delivery source customer data regarding a customer who requests delivery of a product and a delivery destination regarding a customer who is a delivery destination of the product based on input data from the input means. The customer data is stored in the customer data storage means by the customer data storage means in correspondence with the customer data, and the delivery source customer data is retrieved from the customer data storage means based on at least part of the delivery source customer data inputted by the input means. is performed by the delivery source customer data search means, and when the delivery source customer data is detected, the delivery destination customer data stored in the customer data storage means corresponding to the delivery source customer data is outputted together with the delivery source customer data. The customer data is output to the means by the customer data output means. In other words, in addition to the delivery source customer data, it is possible to manage the corresponding delivery destination customer data, so when the same customer selects a product for the second time or later, the previous delivery destination, delivery product, delivery date, etc. It is now possible to provide customer data as value-added information to the customer, which prevents the delivery of the same product to the same delivery address and also allows confirmation of the delivery address when delivering the product to the same delivery address for the second time onwards. This makes it possible to improve customer service and retain customers.Furthermore, by effectively using shipping destination customer data and approaching sales to shipping destinations, product sales can be improved. It becomes possible to expand sales.

Further, as described above, the invention as claimed in claim 2 stores store data regarding various stores included in the sales network in advance by the store data storage means, and stores the store data based on the address data inputted by the input means. A store data search means searches for store data, and when store data having location data that substantially matches the address data is detected, the store data output means outputs the store data to the output means. That is, by simply inputting address data using the input means, the output means outputs store data having location data that substantially matches the address data, so there is no need to check a ledger or the like.
Among the various stores included in the sales network, the store closest to the delivery destination can be easily found.

[Brief explanation of drawings]

FIG. 1 is a flowchart showing a customer data search operation (1/2) in an embodiment of the present invention.

FIG. 2 is a perspective view showing the appearance of the customer data management device.

FIG. 3 is a block diagram showing an overview of its hardware configuration.

FIG. 4 is a memory map showing customer records formed in RAM.

FIG. 5 is a memory map showing store records formed in RAM.

FIG. 6 is a plan view showing an application form.

FIG. 7 is a flowchart showing customer data setting work.

FIG. 8 is a flowchart showing a customer data search operation (2/2).

FIG. 9 is a plan view showing a customer list issued as a result of the processing.

FIG. 10 is a flowchart showing store search work (1/3).

FIG. 11 is a flowchart showing store search work (2/3).

FIG. 12 is a flowchart showing store search operations (3/3).

FIG. 13 is a flowchart showing direct mail creation work.

[Explanation of symbols]

5 Input means 6 Output means 9o Customer data storage means 9w Store data storage means

Claims (2)

[Claims] Claim 1: A customer data storage means, based on input data from an input means, mutually associates delivery source customer data regarding a customer who requests delivery of a product and delivery destination customer data regarding a customer who is a delivery destination of the product. and a customer data storage means for storing the delivery source customer data in the customer data storage means, and searching the customer data storage means for delivery source customer data based on at least part of the delivery source customer data inputted by the input means. When the delivery source customer data is detected by the delivery source customer data search means, the delivery destination customer data stored in the customer data storage means is retrieved from the delivery source customer data corresponding to the delivery source customer data. A customer data management device comprising: customer data output means for outputting customer data to an output means together with the customer data. 2. Store data storage means that stores in advance store data regarding various stores included in the sales network, and store data that searches for store data in the store data storage means based on address data input by input means. The present invention is characterized by comprising a search means and a store data output means for outputting the store data to the output means when the store data search means detects store data having location data that substantially matches the address data. The customer data management device according to claim 1.