JPH11250129A - Mail-order selling management system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a system capable of flexibly dealing with the individual stances of each mail-order seller and unitarily managing information accompanying a mail-order selling business including mail-order selling dealt with by external consignees. SOLUTION: This mail-order management system intervenes among a mail- order seller group 14, a customer group 16, a deliverer group 18, a maker group 20, a warehouseman group 24 and a credit sale company group 22, and unnaturally manages information related to the mail-order business of respective mail- order sellers 13. The system consists of a database group 25 provided with plural databases, etc., a system control part 26, an order processing part 27 having a terminal connected to the control part 26 and capable of registering information obtained from the terminal in the database group 25 and transmitting information generated from the control part 26 to customers or the like, a physical distribution processing part 28, a claim processing part 29, and a mail-order selling business support processing part 30. An enterprise code for exclusively specifying each mail-order seller 13 is imparted to each data stored in the group 25 and respective data are managed and operated based on respective enterprise codes.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a mail order management system, and more particularly to a system capable of centrally managing order processing, distribution processing, and the like associated with the mail order business of a plurality of companies.

[0002]

2. Description of the Related Art In order to operate a mail-order business (hereinafter referred to as a "mail order business"), in addition to planning and developing products and catalogs, an order processing business via telephone, fax, postcard, etc. It is necessary to perform various tasks, such as logistics processing such as inventory management and delivery, and credit processing such as issuing invoices and collecting accounts receivable. For this reason, the mail-order business started
Maintenance required a lot of capital and know-how, and it was difficult for private shops and small and medium-sized enterprises to enter the market easily.

[0003] Of course, in order to reduce the burden on the mail-order business, a part of the business is entrusted to an external specialist business. For example, it is possible for an in-house company to concentrate solely on product planning and development and outsource all other operations to an external specialist. In this way, by outsourcing a part or most of the business related to the mail order business to an external specialist, the burden on each mail order can be reduced.

[0004]

[Problems to be Solved by the Invention] However, by dispersing each business that should be processed in a centralized manner to outside contractors, various information that is indispensable for continuing and developing the mail-order business can be accurately obtained. It becomes difficult to grasp.
As an example, if something goes wrong during delivery of a product, it is common for customers to call the orderer who received the order instead of the delivery company, but the ordering company and the delivery company are separate. If it is a company, there is a possibility that this claim information cannot be reflected in the delivery business in a timely manner. As a result, customer satisfaction is delayed
This would destroy the credit of the mail order company itself. In order to solve such a problem, it is conceivable to entrust a large-scale mail-order contractor who can undertake all processes from order processing to logistics processing and receivables processing.

[0005] In this case, the distribution of information between the business units can be smoothly performed, but this time, a problem arises in that it is not possible to flexibly respond to the individual circumstances of each mail order company. In other words, the mail-order company will ask the past business relationship and product characteristics for
While using a delivery company or warehouse company that we have arranged independently, or outsourcing some products to other contractors or logistics companies, information management is centrally managed by a large-scale mail order contractor. There is a request that you want. However,
In order to flexibly respond to the individual circumstances of a large number of mail-order companies, the conventional system would require a large initial investment. There was a tendency for the options of manufacturers, warehousers, etc. to be limited. In addition, in some cases, the use of an order receiving center or a distribution center operated by a mail-order contracting company itself was forced.

The present invention has been devised in order to solve the above-mentioned problems of the conventional mail order business, and can flexibly cope with the individual circumstances of many mail order companies, as well as providing external mail. To provide a mail-order management system that can centrally manage various information that accompanies the mail-order business, including those by cooperating companies, and store and process this information to help maintain and develop the mail-order business. The purpose is.

[0007]

In order to achieve the above object, a mail order management system according to the present invention comprises a mail order group consisting of a group of plural mail order companies, a customer group consisting of a set of customers of each mail order, And intervening with a group of external contractors consisting of a group of multiple external contractors entrusted with the business related to the mail order business by each mail order business, and information generated accompanying the mail order business of each mail order business A mail order management system for centrally managing a database group consisting of a plurality of databases and a set of master files that classify and store various types of information that accompany the mail order business, and manages the database group and the entire system. A system control unit having a program, and a terminal connected to the system control unit, and at least information on orders received from the customer via the terminal, Various kinds of information accompanying the mail-order business received from the external contractor or mail-order business are registered in a predetermined database or the like of the database group, and the system control is performed based on the data stored in the database group. And a processing unit with the function of transmitting the information issued from the department to the required customers, external contractors and mail-order businesses. Each data stored in the multiple databases belonging to the database group and the master file is In addition, a company code for exclusively specifying each mail-order company is assigned, and data in each database and master file is managed and operated based on the company code.

[0008] Examples of the external contractor include a delivery company, a producer (manufacturer), a warehouse company, a catalog maker, a credit company, a financial institution, a telephone order agency, a distribution center, and the like. Further, the above-mentioned “processing unit” can be divided into a plurality of units according to its main function. For example, it is in charge of an order processing unit that is responsible for receiving orders from customers, a logistics processing unit that is responsible for logistics processing such as receipt processing, shipping processing, inventory processing, etc., and is in charge of claims processing such as billing processing, deposit processing, refund processing, and dunning processing. This includes the receivables processing department and the mail-order business support processing department in charge of supporting mail-order companies.

The database group includes, for example, a master file in which data on each mail order company is stored, a master file in which merchandise data handled by each mail order company is stored, and a master file in which customer data of each mail order company is stored. And a master file in which data on an external contractor designated by each mail order dealer is stored. In addition, the database group includes information on orders received from customers,
A database may be provided which stores the cancellation information after the order is accepted, the cancellation information before the order is established, and the inquiry information for the products classified and stored for each product of each mail-order company. In this case, the system control unit calculates the total order quantity by summing up the determined order information, the cancellation information after the order has been received, the cancel information before the order has been received, and the inquiry information for the product for each product of each mail order company. It is desirable to provide. Alternatively, a database is provided in the database group in which the stock information of the product is classified and stored for each product of each mail order company, and the system control unit determines that the stock quantity of the product is equal to or less than a set value. If this happens, a program may be provided to issue a warning to a mail order company handling the product. Further, the system control unit may be provided with a program for processing various data classified and stored for each mail order company in the database group and analyzing the business of the mail order company.

[0010] In the mail order management system according to the present invention, not only the information received from a plurality of customers and mail order companies as described above, but also information from a plurality of external contract companies independently entrusted by each mail order company. Are stored in a group of databases managed by the system control unit, and each data is centrally managed after being associated with a company code of each mail order company. Further, the system control unit can operate (process) these data based on a predetermined program and transmit the data to necessary customers, mail-order companies, and external contractors.
As a result, a plurality of customers and a plurality of external contractors can be easily managed for each mail-order company, and information received from each person can be used organically and rationally. For example, when an order is received from a customer for a product of a mail order company, the system control unit analyzes information on the stock status sent from an external warehouse contracted by the mail order company. After ordering the product to an external producer entrusted by the mail-order company, and after the information on the product delivery is entered, the mail-order company issues a command to the external delivery company entrusted by the mail-order company to deliver the product to the customer. It becomes possible. Also, when a customer receives complaint information on a product of a certain mail order company, this is temporarily stored in a predetermined database in the database group, processed into a predetermined form, and processed by the mail order company as well as externally. To the producers and delivery companies in the country, and the cause of the complaint can be identified.

[0011] The system control unit stores a read data directory for storing information uploaded from one or more terminals specified by each mail-order company, and stores information downloaded by the terminal. When new information is uploaded from the terminal to the read data directory and the read data directory, the information is stored in a predetermined database of the database group according to the type of information allocated in advance to each terminal. A program X for registering the terminal and updating the data, and a program Y for writing the specific type of information assigned to each terminal in the updated data to the transmission data directory at regular intervals by designating the terminal. May be provided. In this case, after confirming that the upload to the read data directory has been completed from all terminals specified by the mail order company as the program Y, the specific type of information assigned to each terminal is specified for the first time. It is desirable to use the one written in the transmission data directory.

With the above-described configuration, for example, order information received from a customer by a mail order dealer can be fetched into the database group, and can be centrally managed together with the order information input from the processing unit. Is also taken into the terminal of the mail-order company. That is, it becomes possible to synchronize the contents of the database group and the terminal of the mail order company with respect to the information of the preset type. The terminal designated by the mail-order company may be a terminal managed by the mail-order company itself, or a terminal managed by an external contractor commissioned by the mail-order company. For example, for a certain product, if the processing related to logistics such as inventory management and shipping processing is outsourced to an external specialist, a terminal managed by the specialist is specified in advance, and the terminal It is also possible to synchronize the database with the database group.

In the above description, when the system control unit has various programs and directories, in addition to the auxiliary storage device connected to the system control unit and the auxiliary storage device connected to the terminal managed by the system control unit. It is also assumed that these are stored.

[0014]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS The present invention will be described below with reference to the illustrated embodiments. FIG. 1 is a block diagram showing a typical configuration example of the mail order management system 10. As shown in FIG. This mail order management system 10 is mainly configured with a mail order management center 12. The mail order management center 12 is a mail order group 14 made up of a plurality of mail order companies 13 using this system, a customer group 16 made up of a set of customers 15 of each mail order company 13, and a designated (consigned) delivery of each mail order company 13. Delivery company group 18, consisting of a set of
Producer group 20 consisting of a set of producers 19 designated by each mail order company 13, credit sales company group 22 consisting of a set of credit companies 21 designated by each mail order company 13, warehouse companies designated by each mail order company 13.
It intervenes between a group of 23 warehouse companies 24 consisting of a set of 23, and fulfills the function of acting a part or most of the mail order business of each mail order company 13. The set of external contractors designated by each mail-order company 13 includes the above-mentioned delivery company group 18, producer group
In addition to 20, a credit company group 22, and a warehouse company group 24, although not shown, there are also financial institutions such as banks, distributors such as wholesalers, catalog producers, and consultants.

The mail order management center 12 includes a database group 25 as a set of databases in which various kinds of information required for executing the mail order business are classified, arranged, and stored according to a certain standard. A system control unit 26 that manages the group 25 and controls the operation of the entire mail-order management system 10, and an order processing unit 27 that processes information such as orders, inquiries, and complaints from each customer 15.
And a logistics processing unit 28 for ordering products to each producer 19, issuing a delivery command to each delivery company 17, or issuing a stocktaking or warehouse transfer command to each warehouse company 23, and an invoice or A credit processing unit 29 that issues a reminder and exchanges credits with the external credit sales company 21 and a mail-order business support processing unit 30 that exchanges information with each mail-order company 13 I have.

The individual mail order dealers 13 constituting the mail order dealer group 14 do not need to be particularly associated with each other, and are usually unrelated to each other. However, this mail order management system
It is also possible to operate such that 10 is opened only to mail-order companies 13 that satisfy certain qualification requirements (for example, companies belonging to a specific industry group). In addition, a large number of customers 15
Also, although classified into each mail order company 13, the individual customers 15 are not related to each other.

FIG. 2 is an image diagram showing a specific configuration example of the mail order management system 10. As shown in FIG. The above system control unit
Reference numeral 26 denotes a system management server 31 composed of a personal computer (hereinafter referred to as a "personal computer"). In this system management server 31, a system management program and a database management program for controlling the entire mail-order system are set up. ing.

The system management server 31 has a hard disk drive (hereinafter referred to as “HDD3”) as an external storage device.
2 "). The HDD 32 stores various master files and databases, which correspond to the database group 25 described above.

The order receiving section 27 functions as a contact point with the customer 15, and performs not only an order for a product but also a response to various inquiries and complaints. This order processing unit 27 includes a telephone 33 and a facsimile machine 34,
A communication dedicated terminal 35 and a plurality of input terminals 36a and 36b are arranged. These terminals 35, 36a, and 36b are composed of personal computers connected to the system management server 31 via a hub 37.

For example, when a telephone call is received from the customer 15 to the order processing unit 27, an operator belonging to the management center receives the call on behalf of the mail order company 13, responds to orders, inquiries, and complaints, and generates the result. Information input terminal
Enter using 36. The input information is immediately registered in a predetermined database of the database group 25 via the system management server 31. When an order or the like is received from the customer 15 via the postal mail 38 or facsimile, certain information is registered in a predetermined database after the necessary processing is performed in the order processing unit 27. In this case, every time information occurs,
Input can be performed using the input terminal 36, or batch input can be performed at predetermined time intervals. Even when an order is placed online from the customer 15 via personal computer communication, the order is received by the communication-dedicated terminal 35 of the order processing unit 27, and after performing necessary processing such as format check, the system management server It is transmitted to 31 and registered in a predetermined database.

The physical distribution processing unit 28 includes a physical distribution management server 39 that supports the operation of the physical distribution processing unit 28, a plurality of terminals 40a to 40c, and a printer 41. The distribution management server 39 and the plurality of terminals 40a to 40c are each configured by a personal computer. The terminals 40a to 40c and the printer 41 are connected via a hub 37 to form a network.

The distribution management server 39 includes a pair of routers 4
2 and 42 are connected to the system management server 31 via the digital public line 43. Thus, FIG. 2 shows an example in which the physical distribution processing unit 28 is arranged at a remote place. Of course, it may be arranged in the same building as 31. The terminals 40a and 40c are connected to a terminal 44 such as a personal computer or a facsimile machine owned by an external delivery company 17, producer 19, or warehouse company 23 via a public line.

Upon receiving a command from the system management server 31, the terminal 40a of the physical distribution processing unit 28 transmits a delivery command to the terminal 44 managed by the required delivery company 17 through a public line, The product is ordered online to the terminal 44 managed by. Further, the other terminals 40c are also provided with a necessary warehouse company based on a command from the system management server 31.
It instructs the terminal 44 managed by 23 to carry out inventory and warehouse movement.
Alternatively, in accordance with a command from the system management server 31, the necessary forms for the delivery company 17, the production company 19, and the warehouse company 23 are output from the printer 41. These slips are delivered to necessary external contractors by mailing or handing.

The physical distribution processing unit 28 includes, in addition to the information processing system relating to the physical distribution described above, an operational division for packing and storing goods and sending direct mail (hereinafter referred to as “DM”).
It is also equipped with a 45 and functions as a distribution center. The worker in the working department operates the terminal 40b to display a command from the system management server 31 on the screen, and performs a specific operation based on the command. Then, when necessary information (for example, “XX work completed”) is input from the same terminal 40b after the work is completed, this information is input to the system management server 31.
Is registered in a predetermined database.

The credit processing unit 29 includes a terminal 46 composed of a personal computer connected to the system management server 31 via the hub 37.
And a printer 47. The terminal 46 is connected to a terminal 44 managed by a plurality of external credit companies 21 and financial institutions (not shown) via a public line.

The receivable processing unit 29 is responsible for all information processing related to receivables / debts that accompany the mail order business.
For example, when information indicating that the shipment of goods to the customer 15 is completed is transmitted from the distribution processing unit 28, the system management server 31 issues a command to the terminal 46 of the receivable processing unit 29 to send the bill to the printer 47.
To print out. This invoice is sent to the receivables processing department
Mailed from 29 to customer 15.

The mail order business support processing section 30 is provided by each mail order
The terminal 48 has a function as a window with the terminal 13, and includes a terminal 48 composed of a personal computer connected to the system management server 31 via a hub 37, and a printer 49. The terminal 48 is connected to the terminal 44 of the mail-order company 13 via a public line.

The support processing section 30 provides daily business reports to the mail order company 13 and reports useful for the execution of the mail order business formed by processing information accumulated in the database group 25. Performs the function of transmitting to the 13 side. For example, when the system management server 31 automatically generates a monthly report for each mail-order company 13 according to a predetermined program, this data is immediately stored in the auxiliary storage device (HD
D). The mail-order company 13 periodically updates the terminal 48
By accessing the website and downloading data addressed to the company, you can view monthly reports. Alternatively, the data generated by the system management server 31 can be printed out by the printer 49 of the support processing unit 30 and distributed to the mail order company 13 by mail or facsimile transmission.

The specific hardware configuration shown in FIG. 2 is merely an example, and may be replaced with another device capable of performing the same function. For example, it is appropriate to configure the system control unit 26 with a computer having a higher processing capacity than a personal computer according to the scale of the entire system. Also, in order to facilitate the explanation, each processing unit of the mail order management center 12 is independent. However, the distinction between the processing units is an idea focusing on the function thereof, and there is a case where the processing units cannot be clearly distinguished in practice. For example, the terminal configuring the order processing unit 27 may also serve as the terminal of the mail-order business support processing unit 30 and the loan processing unit 29 at the same time.

Next, the contents of the main master files and the databases constituting the database group 25 will be described with reference to FIGS. Figure 3 shows this mail order management system
This is an image of a part of a master file related to a mail order company 13 that is 10 users. First, the [mail order trader master] 50 includes, in addition to the "company code" exclusively assigned to each mail order trader 13, "company name", "address", "TEL", and "F".
Records having data items such as "AX" are stored in a table structure. In addition, the “closing date” that describes the accounting date of the mail-order company 13, the “payment method” that specifies payment conditions such as cash on delivery and bank transfer, and the “shipping site” that specifies the warehouse to ship the goods There are also data items such as a "code", a "delivery code" for designating a delivery company, and a "transfer fee" for designating which of the mail-order company 13 and the customer bears the transfer fee.

[Promotion master] 51 is a master file for specifying which of the mail-order companies 13 will use the media such as catalogs, DMs, and newspaper advertisements to introduce and sell products. It is. Specifically, in addition to the “company code” and “promotion code”, “media number”, “promotion name” for inputting the title of the catalog, etc., and “promotion type (for example: 1. Catalog, 2. Newspaper, 3. Magazine, 4. Handbill, 5. D
M, 6. Radio, 7. TV, 8. Personal computer communication, 9. FD / CD
-ROM, select from) "," Distribution method (example: 1. mail, 2.
Home delivery, 3.Individual distribution / visit, 4.Newspaper insert, 5.Store,
6. Group / Organization, 7. Other, etc.).

[Application number master] 52 is a master file in which data indicating the correspondence between the application number assigned to each product listed in the catalog or the like registered in the promotion master and the product is stored. , "Company code"
In addition to data items such as “product code”, “product name”, and “price”, in addition to “promotion code” and “application number”.

[Commodity master] 53 is a master file in which individual commodities handled by each mail-order company 13 are registered. In addition to the "company code" and "commodity code", "commodity classification (Example: 1.
Select from product, 2. catalog, 3. material, 4. material))
And data items such as “product name” and “specifications”.

[Maker master] 54 is a master file for registering traders who produce products of each mail order trader 13, and includes data items such as "maker code" as well as "company code" and "maker code". It has.

[Supplier master] 55 is a master file for registering distributors who wholesale the goods of each mail order company 13, and includes "company code" and "supplier code" as well as "supplier code". Data items such as "name".

[Shipping place master] 56 is a master file for registering a warehouse company that stores the goods of each mail order company 13, and includes a "company code" and a "shipping place code".
Data items such as “shipping place name” are provided.

The [delivery company master] 57 is a master file for registering the companies that deliver the goods of each mail order company 13. In addition to the "company code" and "delivery company code", the "delivery company name" And data items such as a "handling slip" for specifying a slip form.

[Transfer destination master] 58 is a master file for registering the financial institution in which the account of each mail-order company 13 is opened. In addition to the "company code" and "transfer destination registration type", the "transfer destination master" Destination name ”or“ Transfer method (Example: 1. Bank transfer, 2.
Post office transfer, select and enter), "Account type (example: 0. None, 1. Checking account, 2. Savings account, select and enter)", and "Account number".

The [credit company master] 59 is a master file for registering the credit company designated by each mail-order company 13, and includes "company code", "credit company code", "credit company name", " It has data items such as “closing date”.

[Customer Master] 60 is a master file for registering customers of each mail-order company 13 and includes a "company code".
, "Customer number", "customer name", "sex (example: 0. unknown, 1. male, 2. female, 3. corporate, 4. other, etc.)", "birth date", "Marriage (e.g. 0. unknown, 1. unmarried,
2. Select from married, 3. other, etc.), "occupation" and "annual income".

[Customer family master] 61 is a master file in which the family information of the customer is registered. In addition to "company code", "customer number" and "family registration serial number", "family name" and " Data items such as “date of birth”, “gender”, and “connection code” are provided.

FIG. 4 is an image of a part of a database mainly related to the order processing unit 27. First, the [order DB] 62 is a database in which order information from the customer received by the operator by telephone or the like in the order processing unit 27 is registered. In addition to the "company code" and "order number", the "order type ( Example: 1. TEL, 2. Postcard, 3. FAX, 4. Internet, 5. Cable TV, 9. Other, etc.), "Order Date", "Customer Number", "Payment-Same as Order-To" (Example: 1. Select the same, 2. Different, select and enter) "," Payment-payment method (Example: 1. Cash on delivery, 2. Postal transfer, 3. Convenience store transfer, 4. Bank transfer, 5. Registered cash, 6. . Credit, input), "payment-number of payments", "credit company code", "card No.", "card expiration date". In addition, "Destination (Example: 1. Same as billing address, 2.
It includes data items such as "number of items" and "orders" in addition to "total,""specify gifts (necessity and type of" Noshi ")" and "total." The "number of items" is not only the "number of confirmed items" that describes the number of items that were definitely ordered in one order, but also the "number of pending items" that describes the number of unconfirmed items, and is canceled once an order has been received A detailed item "number of discontinuations" describing the number of sold products is set. "Orders" describes whether the entire order has been confirmed or is on hold / suspended.
Detailed items such as "order receiving status" and "hold / suspension reason code" for displaying the reason for suspension / suspension are set.

[Order Details DB] 63 is the same as [Order DB].
Is a database in which detailed information supplementing the order information registered in the database is stored. That is, "company code"
In addition to the “order number” and “order details number”, the “application number”, “list price”, “quantity”,
"Amount", "Consumption tax", "Scheduled shipment date", "Shipper code", "Change / cancel status (example: 1. Normal, 2. Change, 3. Cancel, select and enter)", "Change / Cancel" Cancel reason code ",
"Receivable occurrence status (Example: 1. Generate, 2. Not generate, select from)", "Receivable non-occurrence reason code (Example: 1. Return exchange etc.)", "Order details status (Example: 1. Confirmed) , 2. Hold,
3. Stop and select from), "Hold / Cancel reason code (Example:" Hold reason "1. Not scheduled to arrive, 2. Stop shipping, Select from" Stop reason "1. Cancel, 2. Out of stock, ), "Shipment possible date", "Shipment-Shipment status (Example: 0. Unprocessed, 1. Cumulative, 2. Shipped, 3. Shipment stopped, Select and enter from)", "Shipment-Shipment" No. "," Billing-Billing Status "(Example: 0. Unbilled, 1. Cumulative, 2. Billed, 3. Billing Stop, Select and Enter) and" Billing-Billing Number " I have.

[Inquiry / Claim History DB] 64 is a database for recording actions other than orders received from the customer to the order processing unit.
In addition to "Inquiry / Claim Number", "History Type (Example: 1.
Inquiry, 2. Claims, select and input), "Registration date", "Customer number", "Customer name", "Gender", "Specific contents", etc. are provided.

[Order batch history DB] 65 stores, instead of registering order information sent to the order processing unit via a means other than telephone, such as FAX or mail, in the order DB or order detail DB in real time. This is a database for recording the fact that the number of cases is registered by batch processing at the stage when the number of cases is collected. This database is
In addition to the “company code” and “ordered batch serial number”, data items such as “startup date”, “startup time”, and “terminal number” for specifying the terminal that performed the batch processing are provided.

FIG. 5 is an image of a database mainly related to the distribution processing unit 28. First, the [warehouse DB] 66 is a database that records the state of arrival of goods and the like in the warehouse managed by the physical distribution processing unit 28, and includes a "company code" and a "goods classification (for example, 1. goods, 2. Catalog, 3. Material, 4. Other, etc.), as well as "Registration number for receiving goods", "Registered date of storing goods", "Product code",
"Supplier code", "Scheduled warehousing number", "Taxation classification (Example:
1.External tax, 2.Internal tax, 3.Exempt from tax, select and enter), "Purchase unit price,""Scheduled warehousing date,""Receivingdate,""
"Reception route (Example: 1. Normal receipt, 2. BM, 3. Defective products,
), "Completion category (example: 1. completed, 2. incomplete, selected from)", and "number of reserved orders".

[Inventory DB] 67 is a database in which the inventory status of commodities is recorded. In addition to the "company code" and "commodity code", "planned number of stocks" and "stock quantity (Example: Warehouse A個, B warehouse 個, C warehouse ○)), −
"Scheduled warehousing quantity", "Reserved quantity-Actual stock quantity", "Shipment quantity-
Normal shipment "," shipment quantity-sample shipment "," return quantity ",
It has data items such as "inventory counter". In this case, not only the warehouse in the physical distribution processing unit 28 of the mail order management center 12 but also the warehouse managed by the external warehouse agent 23 is a target of grasping the stock quantity.

The warehouse transfer registration DB 68 is a database for recording the fact that goods in a specific warehouse have been transferred to another warehouse, and includes a "company code" and a "warehouse transfer registration serial number". , "Registration date of warehouse transfer", "Product code", "Source of warehouse transfer", "Destination of warehouse transfer", "Number of warehouse transfers", "Reason for warehouse transfer"
And other data items.

[Inventory results DB] 69 is a database for keeping a record of the fact that inventory has been performed for a specific product, and includes "company code" and "product category (for example, 1. product,
2. Catalog, 3. Material, 4. Other, etc.),
In addition to the “inventory execution date” and “product code”, “planned number of stocks”, “stock quantity”, “allocation quantity”, “shipment quantity”, “customer return quantity”, “actual shelf quantity (example: Warehouse A ○ Pieces, B Warehouse XX Pieces,
C warehouse XX) and "Inventory data classification (example: 1. Stock, 2. Stock out, select from)" and other data items.

The [shipment accumulation DB] 70 is a database for recording the results of shipping the merchandise to the customer. In addition to the “company code” and “shipping number”, the “shipping-shipping date”, "Shipment-Shipment cumulative status (Example: 1. Cumulative, 2. Stop, 3. Shipment, select and enter)", "Shipment-Shipment stop date", "Shipment-Shipment stop reason code", "Customer number", ""Delivery-delivery company code", "delivery-shipping area code", "delivery-delivery type (example: 0. Normal, 1. Cool, 2. Cash on delivery, select from)", "Destination", "Delivery amount" , And “slip number”.

[Returned goods DB] 71 is a database for recording the fact that once shipped goods are returned from the customer, the "company code", "shipping number",
In addition to "Order Number" and "Order Details Number", "Customer Number"
"Return date", "Application number", "Price", "Quantity", "Amount", "Consumption tax", "Return reason-Return category" (Example: 1. Enter your own reason, 2. Customer reason) "," Return reason code (Example: 1. Select defective item, 2. Image difference, etc.) "," Return-Shipping return "," Return-Return fee "," Shipping-Shipping bearer (Example: 1 Data items such as "owner's share, 2. customer's share, and input)" and "postage-postage share amount" are provided.

[DM history DB] 72 is a database for recording the results of direct mail transmission to the customer 15, and includes "DM code" in addition to "company code", "promotion code" and "DM number". ", DM type (Example: 1. Postcard, 2. Envelope, 3. Other, etc.),"
Data items such as "customer number" and "issue date" are provided.

FIG. 6 is an image of a part of a database mainly related to the credit processing unit 29. First, the [invoice accumulation DB] 73 is a database for recording the fact that an invoicing action to the customer 15 has occurred. In addition to the “company code” and the “invoice number”, the “invoice date”
"Customer number", "Billing method (example: 1. Cash on delivery, 2. Postal transfer, 3. Convenience store transfer, 4. Bank transfer, 5. Registered cash, 6. Credit, select from three),""Number of requests", "Credit company code", "Billing party", "Billing total", "Bundling availability",
It has data items such as "slip number".

[Payment DB] 74 is a database for recording the fact of payment from the customer 15, and includes a "customer number", a "customer number""Depositdate","Deposit method (example: 1. cash on delivery, 2. postal transfer, 3. bank transfer, 4. cash, 5. credit, select from)", "deposit amount", "commission", "fare" , "Other", "Credit company code", "Dunning number", and the like.

[Dunning DB] 75 is a database for recording information on a dunning letter issued to a customer 15 who has not received payment within a predetermined period. Billing number, customer number, dunning date,
Data items such as "Dunning amount", "Dunning letter-issue date", "Dunning letter-Dunning note number", and "Dunning history number" are provided.

[Dunning history DB] 76 is a database in which the number of dunning for the customer 15 is recorded. In addition to the “company code” and “dunning history number”, “dunning date”, “dunning number”, “dunning number” Amount, Billing number, Customer number,
It has data items such as "update dunning times".

[Refund DB] 77 is a database for recording the fact that a refund to the customer 15 occurs for some reason, and includes a "company code" and a "billing number". , "Refund registration serial number", "Customer number", "Refund date", "Refund reason code", "Customer burden", "Refund amount", "Refund method (Example: 1. Bank transfer, 2.
Post office transfer, 3. Registered cash, and select) and data items such as "Refundee".

[Credit DB] 78 is a database for recording the credit and debt status of each customer 15 and includes a "customer number" and a "claim-number" in addition to the "company code" and "claim number".
"Billing Date", "Billing-Billing Method", "Billing-Billing Amount", "Billing-Consumption Tax", "Return-Last Return Date",
"Return-Returned Amount", "Return-Consumption Tax", "Deposit-
Last deposit date, Deposit-deposit amount, Deposit-commission, Deposit-fare, Refund-Last refund date,
"Refund-Customer-paid", "Refund-In-house", "Refund-Refund amount", "Billing balance", "Dunning-Last dunning date", "Dunning-Dunning amount", "Dunning-Dunning count",
It has data items such as "status-billing abandoned", "status-billing abandoned date", and "state-billing abandoned reason code".

The above master file and database are merely examples, and other master files and databases can be provided as needed. Needless to say, the data items of each master file and database can be increased, decreased, or changed as necessary. Each master file and database has a relational data structure, and data operations (selection, projection, combination, change, set operation, etc.) between databases can be freely performed using the "company code" of each mail order company 13 as a primary key. Can be realized.
Since this “company code” is exclusively given to each mail-order company 13, data stored in each of the above-mentioned master files and databases, such as a customer master and an order receiving DB, may interfere with each other between different company codes. There is no. However, in the case where a plurality of companies having different company codes constitute a capital group, it is possible to operate the predetermined company codes so that data interferes with each other.

Next, based on the flowchart of FIG.
The flow of processing in the order receiving unit 27 will be described. First, when a call is made from a customer 15 to a specific mail-order company 13 for ordering (S1), the operator inputs a customer number, a kana name, a telephone number, etc., spoken by the other party to the terminal 36a. An access is made to search whether or not the person is registered (S2). "None applicable" on the terminal screen
Is displayed (S3), attributes such as the name and address of the other party are input on the spot and newly registered in the customer DB (S4). Thereafter, the application number of the catalog specified by the other party is input to access the application number master 52, and it is confirmed whether the product name displayed on the screen is correct (S5).
If there is another product to be ordered, the above operation is repeated until all the orders are completed (S6), and the final quantity is confirmed (S7). After that, the stock DB 67 is accessed to display the stock status of the product on the screen, and guide the scheduled delivery date (S8). Next, after confirming the payment amount and the payment method (S11) and confirming the delivery destination (S13), it is registered in the order DB 62 and the order detail DB 63 as order information (S14).

The system management server 31 stores the order DB 62
In addition, it manages the order information registered in the order detail DB 63 and instructs the physical distribution processing unit 28 to perform necessary processing while referring to the data in the inventory DB 67 and the receiving DB 66. For example, if there is stock, an instruction to pack and deliver immediately is sent to the logistics processing unit.
The information is displayed on the terminal screen 28 and the slip for the delivery company is output from the printer 41. Further, the user accesses the terminal 44 of the delivery company 17 and registers a collection reservation. If there is no stock,
It immediately accesses the terminal 44 of the manufacturer 19 that produces the product and instructs the ordering of the product. If the mail order company 13 itself supplies products, the terminal 44 of the mail order company 13
Is ordered. If the goods are stored by an external warehouse 23, the terminal of the warehouse 23
44 is accessed and a dispatch or warehouse move command is issued immediately.

As described above, the received order is processed promptly, and the product shipping process is realized (S16). Also,
It goes without saying that the data in the relational database, such as the inventory DB 67 and the shipping accumulation DB 70, is updated each time a certain process is performed as described above.

In the case of mail order sales, it is always expected that the order will be canceled. However, if there is a cancellation request after the order is accepted (S15), the necessary processing for immediately stopping the shipment is performed (S17). ), The fact is recorded in a predetermined data item in the order DB 62 (S10). In addition, there are many cases where the customer changes his mind before the order is accepted, that is, while the operator is responding by telephone, and the customer is often canceled. For example, when the delivery date is announced in S8, it takes an unexpectedly long time to cancel the order intention (S8).
9) Or, when the amount of payment is announced in S11, a part of the order is canceled due to fear of the large sum (S12). As described above, when the customer changes his mind before the order is accepted, the order receiving operation is usually only stopped at that point. On the other hand, in the mail order management system 10, the order DB 62 has data items for accumulating such cancellation information before the order is established, and is reliably input by the operator. In addition, during the above-mentioned order processing, access is made to the receivable DB 78 and the dunning history DB 76,
It is possible to check the past payment status of the customer 15 and if the delinquency exceeding a certain standard is recognized, it is possible to operate to hold the order until payment of the balance can be confirmed, but in this case, the customer 15 Receives order information for the product you wish to purchase D
It is desirable to register it in B62 or the like.

Before and after the above-mentioned physical distribution processing, a loan processing is also executed. For example, when the customer 15 selects the payment method using a credit card as the payment method, the system management server 31 sends the credit company 21 through the terminal 46 of the receivable processing unit 29.
Access the terminal 44 of the name, credit card number,
The necessary data such as the number of payments is transmitted to perform the receivable transfer procedure, and the payment information is registered in the payment DB 74.

When the customer 15 selects the bank transfer, the system management server 31 refers to the order receipt DB 62 and the bill accumulation DB 73 and sends data necessary for bill creation to the terminal of the receivable processing unit 29.
It is transmitted to 46 and the printer 47 outputs a bill. This bill is delivered to customer 15 by mail. If the transfer destination is a bank account managed by the mail order management center 12, a payment report is sent to the mail order company 13 via the terminal 48 of the support processing unit 30. In the case where the transfer destination is a bank account managed by the mail order company 13, after the mail order company 13 confirms the deposit, the deposit information is registered in the deposit DB 74 via the terminal 48 of the support processing unit 30.

If the payment from the customer 15 has been delayed even after the elapse of a certain period, the system management server 31
Data required for issuing a reminder is transmitted to the terminal 46 of 29, and the reminder output from the printer 47 is transmitted to the customer. At the same time, the data in the dunning DB 75 and the dunning history DB 76 are updated.

The results and progress of the order processing, physical distribution processing and credit processing are reported to the individual mail-order companies 13 in the form of daily reports, weekly reports, and monthly reports. Specifically, the system management server 31 receives the order DB 62, the order detail DB 63,
The necessary data is tabulated and processed with reference to B74, the bond DB 78, etc., and a report file is generated in the HDD of the terminal 48 of the support processing unit 30. The mail-order company 13 periodically makes a dial-up connection to the terminal 48 of the support processing unit 30 and downloads the report file to its own terminal 44 so that it can be viewed.
Of course, the report printed out by the printer 49 can be mailed or facsimile transmitted to the mail order company 13. A warning can be issued to the mail order company 13 before the stock of each product runs out. For example,
The appropriate stock quantity is set for each product and stored in a dedicated master file, and the system management server 31
B62, order details DB63, warehousing DB66, inventory DB67, cumulative shipment DB70, and returns DB71, constantly monitor the necessary database data, and compare the above-mentioned proper stock quantity with the actual stock quantity to determine whether the stock quantity is the proper stock quantity. If it is determined to be lower, the fact is reported to the mail-order company 13 in the form of a daily report.

In the case of this mail order management system 10, most information generated in the course of running the mail order business is classified and arranged for each mail order company 13 and accumulated in a large number of databases. It is centrally managed by a management program. And
The information stored in each database can be freely searched and processed using a "company code" that exclusively displays each mail-order company 13 as a primary key. For this reason, it is possible to provide useful information beyond the mere report to each mail order company 13 via the support processing unit 30.

For example, in the case of this mail order management system 10,
As mentioned above, not only the cancellation information after the order is completed,
Cancellation information before the order is accepted is also stored in the order DB 62. In addition, the "inquiry" and "claim" information sent from the customer to the order processing unit are also used for the inquiry / claim DB64.
Accumulates inside. Although these do not directly benefit the mail order business, they provide valuable information for planning future business strategies. In other words, even though the call did not lead to the final order, the fact that the call was made once means that the cancellation information and the inquiry information can be sufficiently used as an index for measuring the level of interest in the product. Therefore, the data obtained by summarizing these cancellation information and inquiry information together with the order confirmation information as [total order amount] for each product has value as a material for judging the best selling product. Also, the claim information is effective information when improving an existing product or developing a new product. The information indicating the total order value and the complaint information are also regularly sent to the mail-order
It is transmitted to 13.

Alternatively, by using data stored in each database and processing the data according to a predetermined program, it becomes possible to perform various analyzes indispensable for conducting a mail order business. As one example, RFM analysis will be described. "R" in the RFM analysis is the date of last purchase (re
c)), “F” represents the cumulative number of purchases (frequency), and “M” represents the cumulative purchase amount (monetary), and determines whether or not the probability that the customer will purchase again at the next opportunity is high. The factors are how recently purchased (R) and how much you purchased in the past (F and M).
This is an analysis method for examining. Issuance of a DM is indispensable for successful mail-order sales, but sending the DM to every customer who has purchased it every time is too wasteful in terms of cost effectiveness. This RFM analysis can be an important decision in determining which range of customers to send a DM to is most efficient.

FIG. 8 shows a specific example of the analysis result. The analysis sheet 79 has a total of 72 columns divided into 8 columns by 9 rows.
Cells. The horizontal column indicates "R", and 24 months are divided into eight in three-month units, going back from the most recent, and each column is numbered 80 to 10 in ascending order of 10 digits.
Is given. Also, the vertical row is divided into nine by the combination of "F" and "M",
Each is assigned a line number of 9-1. Then, a customer having a purchase history matching the conditions of the column and row of each cell is applied to the cell, the number of persons (number of orders), the total order amount, and the unit price per DM per division obtained by dividing the order amount by the number of persons. And display them in the upper, middle, and lower rows in each cell.

The book unit price basically indicates the value (order amount) brought by one copy of DM. [Cell 89] (Orders of more than 20.000 yen have been used three or more times in the past three months. It can be estimated that sending the next DM to the customer belonging to [cell 89] is the most effective, since the unit price of the book per cell is the highest at 3000 yen. In contrast,
[Cell 11] (5.000 for one use in the past 24-21 months)
The book unit price of a cell with an order record of less than yen is only 100 yen, and therefore, it can be determined that sending a DM to a customer belonging to [cell 11] is not expected to be very effective.

The amount of DM to be sent to a customer belonging to a cell having a unit price of more than one booklet depends on the circumstances of each mail order company 13 in consideration of the cost required for sending out one DM. For example, if the break-even point is set to 1200 yen, only the customers who belong to the cell having the unit price of 1200 yen or more are listed as DM sending targets.

In addition to the above-mentioned order DB 62, order detail DB 63, customer master 60, etc., a master file and a database (not shown) for RFM analysis are prepared, and each database and database are stored by a dedicated program stored in the system management server 31. By manipulating the data in the master file, the system management server 31 automatically executes the RFM analysis, and can issue the RFM analysis result sheet 79 in FIG. The printer 41 of the logistics processing unit 28
Can automatically print out the label addressed to the customer and apply it to the DM sending process.

In addition to the above-mentioned RFM analysis, LTV (Life T
ime Value) analysis and PICS (Purchase Index Control)
System) can automatically perform various analysis such as analysis common in mail order business. In this case, it is necessary to provide each analysis program, database, and master file.

Depending on the mail order company 13 who is a user of the mail order management system 10, a part of the mail order management center
You may want to outsource to an organization (company) other than 12. For example, in the case of a mail order company 13 that has its own telephone order center, the order information received by the company and the mail order management center
Rather than managing the company's order information received in 12 separately,
It is more efficient to centrally manage with the system of the mail order center 12. In addition, in the case of mail order company 13 dealing with products directly from the production area,
For a part of the physical distribution processing, it is more convenient in terms of cost to use the physical distribution center of the production area. Therefore, in the mail order management system 10, a part of the functions of the mail order management center 12 is distributed to an external institution, and a mechanism capable of centrally managing the information is provided.

FIG. 9 shows an example of such a case. One of the mail order dealers performs an order receiving operation at its own telephone order receiving center separately from the mail order management center 12, and sends the order to a logistics agent present at a remote place. It outsources logistics processing of direct-grown products. In this case, Party A registers in advance the terminal of its own and the terminal managed by Party B as the function-dispersed terminals 80a and 80b in the shop management center 12, and the terminal 48 of the support processing unit of the shop management center 12
And a communication path between the function distribution terminals 80a and 80b. Then, Party A regularly accesses the terminal 48 of the mail order management center 12 from the terminal 80a of the company and uploads the order information received by the company via the terminal 48 to the read data directory 81 in the system management server 31. At the same time, the update data stored in the transmission data directory 82 in the system management server 31 is downloaded. Similarly,
You must also periodically upload the shipment information that accompanies your logistics processing to the read data directory 81, and download the updated data, including new order information, stored in the transmission data directory 82. Come.

As shown in FIG. 10, the system management server
31 has a program X and a program Y for managing distributed processing. The system management server 31 constantly monitors the read data directory 81 in accordance with the program X. If a new file is written, the system management server 31 reads the new file and updates the contents of necessary databases such as the order DB 62. The program Y is started at the time determined by the schedule file in the system management server 31, and receives the order information and the like written in the read data directory 81 from the function distribution terminals 80a and 80b and the mail order management center.
The 12 side creates an update data file including the received order information and the like, and writes this in the transmission data directory 82. In FIG. 10, the function distribution terminal 80a of the mail order company accesses the terminal 48 of the mail order management center 12 every day at 10:00 am and writes order data in the read data directory 81. The data and the data on the mail order management center 12 side are exchanged. The program Y transmits the merged update file to the transmission data directory 82.
The function distribution terminal 80a of the mail order company A accesses the terminal 48 of the mail order management center 12 and downloads the update file in the transmission data directory 82 again at 12:00 pm.

By the way, for some reason such as a machine trouble, the function distribution terminal 80 of the mail order company A or the distribution company B
The files from a and 80b may not be uploaded to the read data directory 81 even after the scheduled time. In this way, a file is automatically created in the transmission data directory 82 by the program Y in a state where the data from the mail order company A or the logistics company B is not added, and the function distribution terminal 80a of the mail order company A or the logistics company B is added. , 80b
If the data is downloaded to the server, a situation may occur in which data consistency is not ensured. Therefore, in this mail order management system 10, after confirming that writing from the pre-registered function distribution terminal to the read data directory 81 has been completed, an update file is created in the transmission data directory 82. There is a mechanism to do this.

That is, the system management server 31
A distribution master as shown in FIG. This distribution master is provided with a column for describing the company code of the mail-order company 13 at the top and a total of 12 function columns A to L. The function columns A to L indicate the functions of the mail order management center 12 that can be distributed to the outside, meaning that the distribution can be finely and freely performed for each of the units shown in A to L. Among them, A to D are related to the function of the order processing unit, and A is “order-online processing (in the case of immediately inputting order information using a terminal)”.
B corresponds to “order-batch processing”, C corresponds to “order-inquiry processing”, and D corresponds to “order-multimedia processing (order processing via personal computer communication or the Internet)”. E to G relate to the function of the logistics processing unit,
E is "logistics-shipping process", F is "logistics-shipping process"
G corresponds to “distribution-stock processing”. H to K relate to the function of the credit processing unit, H corresponds to “claim-claim processing”, I corresponds to “claim-payment processing”, and J corresponds to J-claim processing.
K corresponds to “claims-refund processing”, and K corresponds to “claims-reminding processing”. Further, L corresponds to a maintenance function of various master files.

The numbers entered in the respective function columns represent the number of terminals that are distributed. For example, in the case of this mail-order company, the numbers “2” are entered in the columns A and C in the case of “order-online processing” and “order-inquiry processing”.
Regarding the function, apart from the system management center 12, it means that distributed processing is performed by two terminals each. Also, the number 1 is entered in the B and D columns,
The “order-batch processing” and “order-multimedia processing” functions mean that a single terminal performs distributed processing. Further, the fact that 0 is entered in the columns E to L means that these functions are not desired to be distributed and are left to the mail order management center 12.

The file name of a file uploaded from each function distribution terminal to the read data directory 81 is specified by the function code and company code of the distribution master and the distribution serial number (terminal serial number). For example, "0001"
If the mail order company having the company code of "1" performs the distributed processing of "order-on-line processing" of A on two terminals (01 and 02), the following two files are uploaded to the read data directory. "A010001""A020001"

As shown in FIG. 12, the system management server 31 has a [management record] corresponding to the distribution master for each mail-order company 13. In each function column of this management record, "0" is initially entered when the function column is selected to be subjected to distributed processing, and when it is not selected, a space state is set. . The program X constantly monitors the read data directory 81 for the existence of a new file for each function, terminal, or mail order company. If there is a file, the program X reads the file and updates the data in the related database. At the same time, “1” is added to the function column of the management record. Therefore,
When the data update on the function A from the two terminals registered in advance is completed, the number “2” is written in the function A column.

As shown in FIGS. 13 and 14, the system management server 31 has a [schedule table] and a [schedule execution management table]. The schedule table includes columns for describing company codes, times, and distributed serial numbers, as well as function columns for AL. In the “time” column, a time set in advance as a time at which an update file is written to the transmission data directory 82 is described. In addition, “1” is described in the function column set as the terminal corresponding to the distributed serial number to be subjected to distributed processing, and the other function columns are left as spaces. The schedule execution management table contains company codes,
In addition to a column for describing the distributed serial number, a function column of A to L is provided. In the function columns A to L, “0” is set in the same function column where “1” is set in the schedule table, and the remaining function columns are left as spaces.

As shown in FIG. 15, the program Y manages the schedule for each function distribution terminal of each mail-order company. When the time described in the schedule table arrives (S21), the program Y refers to the schedule table. While recognizing the function assigned to the terminal (S22),
Refer to the management record of the mail-order company and check whether the numbers described in each function column of the management record and the numbers of each function column set in the distribution master of the mail-order company are equal. (S23).

Then, “number of management record function column” =
If the relationship of “numbers in the distribution master function column” is established, data stored in each database is processed to generate an update file addressed to each function distribution terminal, and “function code + distribution serial number + company” A file name "code" is assigned and written in the transmission data directory 82 (S24). At the same time, "1" is set in the corresponding function column of the schedule execution management table (S25), and the corresponding function column of the management record is returned to "0" (S26). Each function-distributed terminal side establishes a dial-up connection to the terminal 48 of the mail order management center 12 at a predetermined time and downloads a file addressed to itself stored in the transmission data directory 82 to obtain a predetermined function. It is possible to share the same information as the database of the mail order management center 12.

On the other hand, if the relationship of “number in the management record function column” <“number in the distribution master function column” is satisfied (S23), uploading to the read data directory 81 by the function distribution terminal is not yet completed. "Number in management record function column" =
Until the “number in the distribution master function column” is confirmed, the generation of the update file by the program Y is on standby.

In short, in this mail-order management system 10, “number in management record function column” = “number in distribution master function column”, indicating that uploading to the read directory 81 by each function distribution terminal has been completed. After confirming, it is operated to generate the update file for each function distribution terminal for the first time, so it is possible to ensure the consistency between the data in the database of the management center 12 and the data on the function distribution terminal side Becomes The read data directory 81, transmission data directory 82, distribution master,
The management record, the schedule table, and the schedule execution management table are usually stored in the HDD 32 connected to the system management server 31. However, the present invention is not limited to this, and may be stored in the auxiliary storage device of another terminal managed by the system management server 31.

[0089]

According to the mail order management system according to the present invention, not only the information received from a plurality of customers and mail order companies as described above, but also a plurality of external contractors individually entrusted by each mail order company. Is stored in a database group managed by the system control unit, and each data is managed in a unified manner by being associated with the company code of each mail-order company. Further, the system control unit can operate (process) these data based on a predetermined program and transmit the data to necessary customers, mail-order companies, and external contractors.
For this reason, an external contractor can be freely selected according to the circumstances of each mailer, and information received from each external contractor can be processed and used as information useful for the business of each mailer.

[Brief description of the drawings]

FIG. 1 is a block diagram showing a configuration of a mail order management system according to the present invention.

FIG. 2 is an image diagram showing a specific configuration example of the mail order management system.

FIG. 3 is an image diagram showing a configuration example of a database provided in the mail-order management system.

FIG. 4 is an image diagram showing a configuration example of a database provided in the mail-order management system.

FIG. 5 is an image diagram showing a configuration example of a database provided in the mail-order management system.

FIG. 6 is an image diagram showing a configuration example of a database provided in the mail-order management system.

FIG. 7 is a flowchart illustrating processing in an order receiving processing unit.

FIG. 8 is a table showing an RFM analysis sheet.

FIG. 9 is an image diagram showing a state of data exchange between a system management server and a function distribution terminal.

FIG. 10 is an image diagram showing a state of data exchange between a system management server and a function distribution terminal.

FIG. 11 is an image diagram showing a distribution master.

FIG. 12 is an image diagram showing a management record.

FIG. 13 is an image diagram showing a schedule table.

FIG. 14 is an image diagram showing a schedule execution management table.

FIG. 15 is a flowchart illustrating an operation of a program Y;

[Explanation of symbols]

 10 Mail order management system 12 Mail order management center 13 Mail order company 14 Mail order company group 15 Customer 16 Customer group 17 Delivery company 18 Delivery company group 19 Producer 20 Producer group 21 Credit company 22 Credit company group 23 Warehouse company 24 Warehouse company group 25 Database Group 26 System control unit 27 Order processing unit 28 Logistics processing unit 29 Credit processing unit 30 Mail order business support processing unit 31 System management server 32 HDD 35 Communication dedicated terminal 36a, 36b Input terminal 39 Distribution management server 40a to 40c terminal 46 terminal 48 terminal 50 Mail orderer master 53 Product master 54 Manufacturer master 55 Supplier master 56 Shipment area master 57 Delivery agent master 58 Transferee master 59 Credit company master 60 Customer master 62 Order DB 63 Order details DB 64 Inquiry / Claim DB 67 Inventory DB 81 Read data directory 82 Transmission data directory 80a, 80b Function distribution terminal

 ──────────────────────────────────────────────────続 き Continuing on the front page (72) Inventor Toshio Matsumoto 4-11 Sakaemachi, Takasaki City, Gunma Pref.

Claims (8)

[Claims] Claims: 1. A mail-order business group consisting of a set of plural mail-order companies, a customer group consisting of a set of customers of each mail-order business, and a plurality of external contractors entrusted by each mail-order business with business related to the mail-order business. A mail-order management system that intervenes with a group of external contractors consisting of a set of It has a database group consisting of a set of a plurality of databases and master files for classifying and storing information, a system control unit having a program for managing the database group and the entire system, and a terminal connected to the system control unit. And at least order information received from the customer via the terminal, and various types of information generated accompanying the mail-order business received from the external contractor or mail-order business. Function to register information in a predetermined database or the like of the database group, and to transmit information issued from the system control unit to a customer, an external contractor, and a mail order business based on data stored in the database group. Each of the data stored in the plurality of databases and the master file belonging to the database group is provided with a company code that exclusively specifies each mail-order company,
A mail order management system wherein data in each database and master file is managed and operated based on the company code. 2. The database group includes a master file in which at least data on each mail order company is stored, a master file in which merchandise data handled by each mail order company is stored, and a master file in which customer data of each mail order company is stored. 2. The mail order management system according to claim 1, comprising a file and a master file in which data on an external contractor specified by each mail order company is stored. 3. The database group stores, in addition to information on orders received from customers, cancellation information after orders have been received, information on cancellations before orders are received, and information on inquiries on products classified by product of each mail order company. The mail order management system according to claim 1, further comprising a database for storing the mail order. 4. The system control unit tabulates the determined order information, cancellation information after the order has been established, cancellation information before the order has been established, and inquiries information for each product for each product of each mail order company, and calculates the total order quantity. The mail-order management system according to claim 1, further comprising a calculation program. 5. The database group includes a database for storing stock information of commodities classified by merchandise dealers for each merchandise, and the system control unit determines that the stock quantity of the merchandise is equal to or less than a set value. The mail order management system according to any one of claims 1 to 4, further comprising a program for issuing a warning to a mail order dealer handling the product in the event that the condition has been reached. 6. A system according to claim 1, wherein said system control unit has a program for processing various data stored in said database group classified for each mail order company and analyzing the business of said mail order company. The mail-order management system according to claim 1. 7. The system control unit includes: a read data directory for storing information uploaded from one or a plurality of terminals designated by each mail order company; and a system for storing information downloaded by the terminal. When new information is uploaded from the terminal to the read data directory, the information is stored in the database group according to the type of information allocated in advance to each terminal. A program X for registering and updating data in a database, and among the updated data, a specific type of information assigned to each terminal is written to the transmission data directory at regular intervals by designating the terminal. A mail-order management system according to any one of claims 1 to 6, further comprising a program Y. . 8. The program Y, after confirming that uploading to the read data directory from all terminals designated by the mail-order company has been completed, transmits the specific type of information assigned to each terminal for the first time. 8. The mail order management system according to claim 7, wherein the mail address is designated and written in the transmission data directory.