Information processor, system, order management method, and program
Patent Information
- Application Number
- JP2023143104
- Authority / Receiving Office
- JP · JP
- Patent Type
- Applications
- Current Assignee / Owner
- Filing Date
- 2023-09-04
- Publication Date
- 2025-03-14
AI Technical Summary
【0007】 本発明により、注文が無い取引先別に適切な通知方法で通知できる。
Smart Images

Figure 2025035818000001_ABST
Abstract
Description
[Technical field]
[0001] The present invention relates to an information processing device, a system, an order management method, and a program. [Background technology]
[0002] Conventionally, there is known an information processing device that automatically transmits recommended product information to a customer. For example, there is known a product recommendation system that creates a list of recommended products that are due for purchase based on product information in a product information database and the replacement period and last purchase date in a customer information database, and transmits the list to a customer terminal of the target customer (see Patent Document 1). Necessary products are sold to customers at the necessary time by receiving orders for products according to the customer's viewing of the recommended product list. [Prior art documents] [Patent documents]
[0003] [Patent Document 1] JP 2001-325523 A Summary of the Invention [Problem to be solved by the invention]
[0004] In the above-mentioned product recommendation system, the recommended product list was sent to the customer terminal by one communication method (notification method) via the network. The customer referenced the recommended product list on the customer terminal. However, depending on the customer (business partner, client), there were cases where they preferred to be contacted by a specific notification method or where it was difficult to contact them other than by a specific notification method.
[0005] An object of the present invention is to notify each trading partner that has no orders in an appropriate notification method. [Means for solving the problem]
[0006] In order to solve the above problem, the information processing device of the present invention comprises an extraction means for extracting, from among the supplier information stored in a specified supplier table, supplier information for which order information is not stored in a specified storage means at a specified time as a notification target, and a notification control means for controlling the notification means to notify the notification target extracted by the extraction means based on notification method information that is pre-linked to the supplier information of the notification target. Effect of the Invention
[0007] According to the present invention, it is possible to notify suppliers who have no orders by a suitable notification method. [Brief description of the drawings]
[0008] [Figure 1] 1 is a block diagram showing a schematic configuration of an order management system according to an embodiment of the present invention; [Diagram 2] FIG. 2 is a block diagram showing a functional configuration of the information processing device. [Diagram 3] FIG. 2 is a block diagram showing a functional configuration of a terminal device. [Figure 4] FIG. 2 is a block diagram showing a functional configuration of a server. [Diagram 5] 1A is a diagram showing the configuration of a company control table, FIG. 1B is a diagram showing the configuration of a customer master table, FIG. 1C is a diagram showing the configuration of a product master table, and FIG. 1D is a diagram showing the configuration of an order transaction table. [Figure 6] 1A is a diagram showing the configuration of an order transaction table, FIG. 1B is a diagram showing the configuration of an order transaction table, FIG. 1C is a diagram showing the configuration of a notification list, and FIG. 1D is a diagram showing a login information table. [Figure 7] 13 is a flowchart showing an information registration process. [Figure 8] 13 is a flowchart showing a confirmation information notification process. [Figure 9] FIG. 13 is a diagram showing a company information registration screen. [Figure 10] FIG. 13 is a diagram showing a customer registration screen. [Figure 11] FIG. 13 is a diagram showing a web order input screen. [Figure 12] FIG. 13 shows a web order capture screen. [Figure 13] FIG. 13 is a diagram showing an unordered item automatic determination processing screen. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
[0009] Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings. However, the scope of the present invention is not limited to the illustrated examples.
[0010] First, the device configuration of the present embodiment will be described with reference to Figs. 1 to 4. Fig. 1 is a block diagram showing a schematic configuration of an order management system 1 as a system of the present embodiment. Fig. 2 is a block diagram showing the functional configuration of an information processing device 10. Fig. 3 is a block diagram showing the functional configuration of a terminal device 20A. Fig. 4 is a block diagram showing the functional configuration of a server 30.
[0011] The order management system 1 of the present embodiment is an information processing system that receives and manages product order information (order information, ordering information) from customers.
[0012] 1, the order management system 1 includes an information processing device 10, terminal devices 20A, 20B, and 20C, a server 30, and a FAX device 40A. The devices in the order management system 1 are communicatively connected via a communication network N.
[0013] The information processing device 10 is an information processing device such as a PC (Personal Computer) installed in a wholesale company that sells products, and is used by a person in charge of the wholesale company. The information processing device 10 generates order information for all products based on product order information ordered from terminal devices 20A... and stored in the server 30, and product order information for products ordered by customers to the wholesale company by telephone or the like and directly input and stored by a person in charge of the wholesale company. Here, the product order information stored in the server 30 is referred to as "order information" for convenience. Also, the product order information directly input by a person in charge and stored in the information processing device 10 is referred to as "order information" for convenience. Also, the product order information generated in the information processing device 10 is referred to as "received order information" for convenience.
[0014] The information processing device 10 stores the order information in an order transaction table 100 (described later) and displays the order information so that the person in charge can refer to it. The person in charge carries out processes such as delivery of the ordered products.
[0015] In addition, when no product order is received from one of the customers at a specified time in a day, the information processing device 10 notifies the customer of the product order confirmation information using a notification method, such as FAX, that is individually set for that customer.
[0016] The terminal devices 20A, 20B, and 20C are information processing terminals such as smartphones and tablet PCs owned by customers of the wholesale company. Here, it is assumed that each customer of the terminal devices 20A, 20B, and 20C is a customer who orders products from the wholesale company every day. In other words, it is assumed that the customer runs a physical store or an online store that sells products, and purchases the products from the wholesale company. It is to be noted that the number of terminal devices of the customer is not limited to the above. In addition, the terminal devices of the order management system 1 may be configured to include terminal devices owned by customers who are not customers (for example, customers making their first purchase).
[0017] It is also assumed that the customer of terminal device 20A has a FAX device 40A installed in its own store. FAX device 40A is a device that is connected to the telephone line network of communication network N and communicates various information to FAX devices on the telephone line network of communication network N and devices with FAX functions (information processing device 10) using a FAX communication method. For example, FAX device 40A has a function of FAXing information to be sent to a destination device, and a function of FAXing information from a source device and printing the received information on paper. It is assumed that the customer of terminal devices 20A and 20B does not have a FAX device.
[0018] The server 30 is a DB (Data Base) server that stores, as a database, order information of products ordered from the terminal devices 20A, 20B, and 20C. The server 30 is accessible from the terminal devices 20A, 20B, and 20C or the information processing device 10.
[0019] The server 30 also functions as a WEB server. In response to a request from a customer from the terminal devices 20A, 20B, 20C, the server 30 transmits product information for the wholesale company to the terminal devices 20A, 20B, 20C, and the terminal devices 20A, 20B, 20C display the product information received from the server 30 as a WEB order input screen on a display unit 34, which will be described later. The server 30 receives product order information input via the WEB order input screen from the requesting terminal devices 20A, 20B, 20C, and stores it in the order transaction table 120.
[0020] The communication network N is, for example, the Internet and includes a telephone line network. Furthermore, the communication network N may include a LAN (Local Area Network) or a dedicated line.
[0021] Next, the internal functional configuration (circuit configuration) of the information processing device 10 will be described with reference to Fig. 2. As shown in Fig. 2, the information processing device 10 includes a CPU (Central Processing Unit) 11, an operation unit 12, a RAM (Random Access Memory) 13, a display unit 14, a storage unit 15, a communication unit 16, a FAX unit 17, and a clock unit 18. The CPU 11 functions as an extraction means, a notification control means, a first storage control means, and a second storage control means. The storage unit 15 functions as a storage means. The communication unit 16 and the FAX unit 17 function as a notification means. The units of the information processing device 10 are connected to each other via a (system) bus 19.
[0022] The CPU 11 controls each unit of the information processing device 10. The CPU 11 reads out a specified program from among various programs stored in the storage unit 15, loads it into the RAM 13, and executes various processes in cooperation with the loaded program.
[0023] The operation unit 12 has a keyboard and a pointing device such as a mouse, and receives input of key operations and position operations from a person in charge as a user, and outputs the operation information to the CPU 11.
[0024] The RAM 13 is a volatile semiconductor memory from which information can be read and written, and provides a work area for the CPU 11 and temporarily stores data and programs.
[0025] The display unit 14 has a display panel such as an LCD (Liquid Crystal Display), an EL (Electro-Luminescence) display, etc. The display unit 14 displays various types of display information on the display panel in accordance with various types of display information input from the CPU 11, etc.
[0026] The storage unit 15 is a storage unit that is composed of an HDD (Hard Disk Drive) or an SSD (Solid State Drive) and is capable of reading and writing information, and stores various data and various programs. In particular, the storage unit 15 stores an information registration program P1 for executing an information registration process described below, and a confirmation information notification program P2 for executing a confirmation information notification process described below. Furthermore, the storage unit 15 stores a company control table 50, a customer master table 60, a product master table 80A, an order transaction table 90, an order receipt transaction table 100, and a notification list 110.
[0027] The communication unit 16 is a wired communication unit configured with a network card or the like, and connected to the communication network N to perform wired communication. The CPU 11 transmits and receives information to and from external devices such as the terminal devices 20A, 20B, and 20C and the server 30 via the communication unit 16. However, the communication unit 16 may be a wireless communication unit connected to the communication network N by a wireless communication method such as wireless LAN.
[0028] The FAX unit 17 is a communication unit that is connected to a telephone communication network of the communication network N and communicates various information by a FAX communication method. The CPU 11 transmits and receives information by FAX to and from an external device such as a FAX device 40A on the telephone communication network via the FAX unit 17.
[0029] The timekeeping unit 18 is a real-time clock that keeps track of the current date and time and outputs the current date and time information to the CPU 11.
[0030] Next, the internal functional configuration (circuit configuration) of the terminal device 20A will be described with reference to Fig. 3. The configurations of the terminal devices 20B, 20C, etc. are similar to that of the terminal device 20A, and therefore description thereof will be omitted.
[0031] 3, the terminal device 20A includes a CPU 21, an operation unit 22, a RAM 23, a display unit 24, a storage unit 25, and a communication unit 26. The components of the terminal device 20A are connected to each other via a (system) bus 27.
[0032] The CPU 21 controls each unit of the terminal device 20 A. The CPU 21 reads out a specified program from among various programs stored in the storage unit 25, loads it in the RAM 23, and executes various processes in cooperation with the loaded program.
[0033] The operation unit 22 has a touch panel, receives touch operation input from a customer (shop owner) as a user, and outputs the operation information to the CPU 21.
[0034] The RAM 23 has the same configuration as the RAM 13 in Fig. 2. The RAM 23 provides a work area for the CPU 11, and temporarily stores data and programs.
[0035] The display unit 24 has a display panel for a terminal device such as an LCD, an EL display, etc. The display unit 24 displays various types of display information on the display panel according to various types of display information input from the CPU 21 or the like.
[0036] The storage unit 25 is a storage unit that is composed of a flash memory or the like, is capable of reading and writing information, and stores various data and programs. In particular, the storage unit 25 stores a browser program P3 for executing a browser. The storage unit 25 may be configured to store a web ordering application program for executing a web ordering process that displays a product ordering screen and accepts and transmits input of product ordering information.
[0037] The communication unit 26 has an antenna, an oscillator, a modulator / demodulator, an amplifier, a signal processor, and the like for a wireless communication method such as a wireless LAN. The communication unit 26 performs wireless communication with an access point or a base station on the communication network N in accordance with an instruction from the CPU 21. The CPU 21 communicates with external devices on the communication network N, such as the information processing device 10 and the server 30, via the wireless communication of the communication unit 26.
[0038] Next, the internal functional configuration (circuit configuration) of the server 30 will be described with reference to Fig. 4. As shown in Fig. 4, the server 30 includes a CPU 31, an operation unit 32, a RAM 33, a display unit 34, a storage unit 35, a communication unit 36, and a clock unit 37. The respective units of the server 30 are connected to each other via a (system) bus 38.
[0039] The CPU 31, operation unit 32, RAM 33, display unit 34, memory unit 35, communication unit 36, and timing unit 37 have the same configuration as the CPU 11, operation unit 12, RAM 13, display unit 14, memory unit 15, communication unit 16, and timing unit 18 of the information processing device 10, respectively, so the differences will be mainly described.
[0040] The CPU 31 controls each part of the server 30. The CPU 31 receives product order information transmitted from the customer's terminal devices 20A, 20B, 20C via the communication unit 36, and stores the information in the order transaction table 120. The storage unit 35 particularly stores a product master table 80B, the order transaction table 120, and a login information table 130.
[0041] Next, with reference to Figs. 5(a) to 6(d), information stored in the information processing device 10 and the server 30 will be described. Fig. 5(a) is a diagram showing the configuration of a company control table 50. Fig. 5(b) is a diagram showing the configuration of a customer master table 60. Fig. 5(c) is a diagram showing the configuration of a product master table 80A. Fig. 5(d) is a diagram showing the configuration of an order transaction table 120. Fig. 6(a) is a diagram showing the configuration of an order transaction table 90. Fig. 6(b) is a diagram showing the configuration of an order transaction table 100. Fig. 6(c) is a diagram showing the configuration of a notification list 110. Fig. 6(d) is a diagram showing a login information table 130.
[0042] With reference to Fig. 5(a), the company control table 50 stored in the storage unit 15 of the information processing device 10 will be described. The company control table 50 is a table for managing information such as settings related to wholesale companies that sell products. The company control table 50 has columns such as a system code 51, a company name 52, a postal code 53, an address 54, a telephone number 55, and a confirmation time 56. The system code 51, the company name 52, the postal code 53, the address 54, and the telephone number 55 are basic information about a company.
[0043] The system code 51 is identification information of the wholesale company. The company name 52 is the name of the wholesale company of the system code 51. The postal code 53 is the postal code of the wholesale company of the system code 51. The address 54 is the address of the wholesale company of the system code 51. The phone number 55 is the phone number of the wholesale company of the system code 51.
[0044] The confirmation time 56 is the time at which it is automatically determined whether or not confirmation information needs to be sent to customers who have not placed orders with the wholesaler of the system code 51. The confirmation time 56 is, for example, a two-digit hour and two-digit minute in a 24-hour format.
[0045] 5(b), the customer master table 60 stored in the storage unit 15 of the information processing device 10 will be described. The customer master table 60 is a table for managing information on customers among customers. The customer master table 60 has columns such as a customer code 61, a customer name 62, a reading 63, a postal code 64, an address 65, a telephone number 66, a fax number 67, an email address 68, an SNS (Social Networking Service) ID 69, and a notification category 70.
[0046] The customer code 61 is identification information indicating a customer. The customer name 62 is the name of the customer of the customer code 61. The reading 63 is the reading of the customer name 62. The postal code 64 is the postal code of the customer of the customer code 61. The address 65 is the address of the customer of the customer code 61.
[0047] The telephone number 66 is the telephone number of the customer of the customer code 61. The fax number 67 is the fax telephone number of the customer of the customer code 61. For example, if the customer of the customer code 61 is the customer of the terminal device 20A, the fax number 67 is the fax number of the fax device 40A. The email address 68 is the electronic mail address of the customer of the customer code 61. A mail server (not shown) of the email address 68 is connected to the communication network N.
[0048] SNSID69 is the ID of a specific SNS for the customer of customer code 61. An SNS is a service that allows a social network to be built on the web. A server (not shown) for the specific SNS for SNSID68 is connected to a communication network N, and an SNSID is assigned to a person or company that uses the specific SNS. The server (not shown) for the specific SNS provides for the exchange of information such as messages between the person or company to which the SNSID is assigned. Here, it is assumed that the wholesale company that sells the product and the customer of terminal devices 20A, 20B, and 20C have registered accounts on the specific SNS. For this reason, an SNDID is assigned to the wholesale company and each customer.
[0049] The notification category 70 is category information for the method of notifying confirmation information when no product order has been placed with respect to the customer with the customer code 61. The notification category 70 takes one of the following values: 0: no notification required, 1: fax, 2: email, 3: specified SNS.
[0050] The record in the first row of the customer master table 60 corresponds to the customer (Yamada Taro) who owns the terminal device 20A. The record in the second row of the customer master table 60 corresponds to the customer (Suzuki Hanako) who owns the terminal device 20B. The record in the third row of the customer master table 60 corresponds to the customer (Sato Ichiro) who owns the terminal device 20C.
[0051] 5(c), the product master table 80A stored in the storage unit 15 of the information processing device 10 will be described. The product master table 80A is a table for managing information on products sold by a wholesale company. The product master table 80A has columns such as product code 81, product name 82, reading 83, unit price 84, purchase price 85, and category 86.
[0052] Product code 81 is identification information of a product sold to a wholesaler. Product name 82 is the name of the product with product code 81. Furigana 83 is the furigana of the product name 82. Unit price 84 is the selling price of the product with product code 81. Unit purchase price 85 is the unit purchase price of the product with product code 81. Classification 86 is a product classification code of the product with product code 81.
[0053] The product master table 80B stored in the storage unit 35 of the server 30 is identical to the product master table 80A. For example, in the information processing device 10, when the product master table 80A is updated by an operation input from a person in charge via the operation unit 12, the product master table 80B is synchronized with the updated product master table 80A.
[0054] 5(d), the order transaction table 120 stored in the storage unit 35 of the server 30 will be described. The order transaction table 120 is a table for managing order information of products ordered (placed) by customers via the terminal devices 20A, 20B, and 20C. The order transaction table 120 has columns such as customer code 121, order date 122, product code 123, product name 124, quantity 125, and import category 126.
[0055] The customer code 121 is identification information of the customer who ordered the product. The order date 122 is the order date of the product ordered by the customer with the customer code 121. The product code 123 is identification information of the product ordered by the customer with the customer code 121. The product name 124 is the name of the product with the product code 123. The quantity 125 is the ordered quantity of the product with the product code 123.
[0056] The import category 126 is flag information indicating whether or not the records of the customer code 121 to the quantity 125 have been imported (=1) into the information processing device 10 (=0). Product order information (customer code 121 to quantity 125) ordered by customers via the terminal devices 20A... is temporarily stored as an order transaction table 120 in the storage unit 35 of the server 30. The order information in the order transaction table 120 is imported into the order receipt transaction table 100 on the information processing device 10 side at a predetermined timing of the confirmation information notification process.
[0057] With reference to Fig. 6(a), an order transaction table 90 stored in the storage unit 15 of the information processing device 10 will be described. The order transaction table 90 is a table for managing order information for products ordered directly from customers to a person in charge at a wholesale company by telephone or the like. The order transaction table 90 has columns such as customer code 91, order date 92, product code 93, product name 94, quantity 95, import category 96, etc.
[0058] Customer code 91 is identification information of the customer who ordered the product. Order date 92 is the order date of the product ordered by the customer with customer code 91. Product code 93 is identification information of the product ordered by the customer with customer code 91. Product name 94 is the name of the product with product code 93. Quantity 95 is the quantity ordered of the product with product code 93.
[0059] The import category 96 is flag information indicating whether the record of the customer code 91 to the quantity 95 has been imported (=1) or not (=0) into the order transaction table 100. The order information (customer code 91 to quantity 95) of a product ordered directly by a customer is temporarily stored in the order transaction table 90. The order information in the order transaction table 90 is imported into the order transaction table 100 at a predetermined timing of the confirmation information notification process.
[0060] 6(b), the order receipt transaction table 100 stored in the storage unit 15 of the information processing device 10 will be described. The order receipt transaction table 100 is a table that manages the order information and the order information acquired from the order placement transaction table 120 and the order transaction table 90 as order receipt information. The order receipt transaction table 100 has columns such as customer code 101, order date 102, product code 103, product name 104, quantity 105, and acquisition source category 106.
[0061] The customer code 101 is identification information of the customer who placed an order for the product. The order date 102 is the order date of the product placed or ordered by the customer with the customer code 101. The product code 103 is identification information of the product placed or ordered by the customer with the customer code 101. The product name 104 is the name of the product with the product code 103. The quantity 105 is the quantity of the product with the product code 103.
[0062] The import source category 106 is information indicating the import source of the records of the customer code 101 to the quantity 105 into the order transaction table 100. The import source category 106 takes one of the following values: 1: direct operation input of the information processing device 10 (order transaction table 90); 2: import from the server 30 (order transaction table 120).
[0063] 6(c), the notification list 110 stored in the storage unit 15 of the information processing device 10 will be described. The notification list 110 is setting information that defines the notification method (transmission method) of confirmation information for each customer when a product has not been ordered. The notification list 110 has columns for customer code 111, notification category 112, FAX number 113, email address 114, and SNS ID 115.
[0064] The customer code 111 is identification information of a customer who is a buyer of the wholesale company's products. The notification category 112 is category information indicating the method of notifying the customer of the customer code 111 of confirmation information when the product has not been ordered. The notification category 112 takes one of the following values: 1: FAX, 2: E-mail, 3: Predetermined SNS.
[0065] The FAX number 113 is the FAX number of the customer with the customer code 111 and the notification category 112 being "1". The email address 114 is the email address of the customer with the customer code 111 and the notification category 112 being "2". The SNSID 115 is the SNSID of the customer with the customer code 111 and the notification category 112 being "3".
[0066] 6(d), the login information table 130 stored in the storage unit 35 of the server 30 will be described. The login information table 130 is a table for managing login information related to the login of the terminal devices 20A, 20B, 20C in the order information input process in which order information is input to the terminal devices 20A, 20B, 20C and received. The login information table 130 has columns for a login ID 131, a password 132, and a customer code 133.
[0067] The login ID 131 is the login ID of the customer who orders the product. The password 132 is a password corresponding to the login ID 131. The customer code 133 is a customer code corresponding to the customer of the login ID 131.
[0068] Next, the operation of the order management system 1 will be described with reference to Figs. 7 to 13. Fig. 7 is a flowchart showing information registration processing. Fig. 8 is a flowchart showing confirmation information notification processing. Fig. 9 is a diagram showing the company information registration screen 400. Fig. 10 is a diagram showing a customer registration screen 500. Fig. 11 is a diagram showing a web order input screen 600. Fig. 12 is a diagram showing a web order import screen 700. Fig. 13 is a diagram showing an unreceived automatic order determination processing screen 800.
[0069] First, the information registration process executed by the information processing device 10 will be described with reference to Fig. 7. The information registration process is a process for registering in advance information required for the confirmation information notification process.
[0070] In the information processing device 10, an instruction to execute information registration processing is input from a person in charge at the wholesale company via the operation unit 12. The CPU 11 executes the information registration processing in accordance with the information registration program P1 stored in the storage unit 15, using the instruction as a trigger.
[0071] First, the CPU 11 accepts input of company information related to the wholesale company (the company) via the operation unit 12, and stores and registers the input company information in the company control table 50 (step S11). In step S11, for example, the CPU 11 generates a company information registration screen 400 shown in FIG. 9 and displays it on the display unit 14.
[0072] The company information registration screen 400 has input fields for various information, including a company name input field 401, a postal code input field 402, an address input field 403, a telephone number input field 404, and a confirmation time input field 405. The company name input field 401 is an input field for the company name of the wholesale company. The postal code input field 402 is an input field for the postal code of the wholesale company. The address input field 403 is an input field for the address of the wholesale company. The telephone number input field 404 is an input field for the telephone number of the wholesale company. The confirmation time input field 405 is an input field for the confirmation time that automatically determines whether or not confirmation information needs to be notified to customers who did not order the product.
[0073] The company name entered in the company name input field 401 is stored in company name 52 of the company control table 50. The postal code entered in the postal code input field 402 is similarly stored in postal code 53. The address entered in the address input field 403 is similarly stored in address 54. The telephone number entered in the telephone number input field 404 is similarly stored in telephone number 55. The confirmation time entered in the confirmation time input field 405 is similarly stored in confirmation time 56.
[0074] Then, the CPU 11 accepts an input of customer information related to the customers of the wholesale company via the operation unit 12, and stores and registers the input customer information in the customer master table 60 (step S12). In step S12, for example, the CPU 11 generates a customer registration screen 500 shown in FIG.
[0075] The customer registration screen 500 has various information input fields including a customer code input field 501, a customer name input field 502, a reading input field 503, a postal code input field 504, an address input field 505, a telephone number input field 506, a fax number input field 507, an email address input field 508, an SNS ID input field 509, and a notification category input field 510. The customer code input field 501 is an input field for the customer code of the customer. The customer name input field 502 is an input field for the customer name of the customer. The reading input field 503 is an input field for the reading of the customer name of the customer. The postal code input field 504 is an input field for the postal code of the customer. The address input field 505 is an input field for the address of the customer. The telephone number input field 506 is an input field for the customer's telephone number. The fax number input field 507 is an input field for the customer's fax number. The email address input field 508 is an input field for the customer's email address. The SNS ID input field 509 is an input field for the SNS ID of the customer. The notification category input field 510 is an input field for the notification category of the customer's confirmation information.
[0076] The customer code entered in the customer code input field 501 is stored as customer code 61 in the customer master table 60. The customer name entered in the customer name input field 502 is stored as customer name 62 in the customer master table 60. The furigana entered in the reading input field 503 is also stored as reading 63. The zip code entered in the postal code input field 504 is also stored as postal code 64. The address entered in the address input field 505 is also stored as address 65. The phone number entered in the phone number input field 506 is also stored as phone number 66. The fax number entered in the fax number input field 507 is also stored as fax number 67. The email address entered in the email address input field 508 is also stored as email address 68. The SNSID entered in the SNSID input field 509 is also stored as SNSID 69. The notification category entered in the notification category input field 510 is also stored in the notification category 70.
[0077] Then, the CPU 11 accepts input of product information related to the products sold by the wholesale company via the operation unit 12, stores and registers the input product information in the product master tables 80A, 80B (step S13), and ends the information registration process. In step S13, for example, the CPU 11 generates a product registration screen (not shown) and displays it on the display unit 14.
[0078] The product registration screen has input fields for the product's product code, product name, furigana, unit price, purchase price, classification, etc. The product code entered into the input field for the product's product code is stored as product code 81 in product master tables 80A, 80B. The product name entered into the input field for the product's product name is also stored as product name 82. The furigana entered into the input field for the product's product name furigana is also stored as furigana 83. The unit price entered into the input field for the product's unit price is also stored as unit price 84. The purchase price entered into the input field for the product's unit price is also stored as purchase price 85. The classification entered into the input field for the product classification is also stored as classification 86.
[0079] Here, a simple description will be given of the flow of ordering a product from a customer (order information input process). Here, an example will be described in which a customer (Taro Yamada) uses the terminal device 20A to order a product, but the same applies to other customers.
[0080] Yamada Taro takes orders for products from customers and sells products as part of the normal business of his store. Yamada Taro then checks the amount of stock remaining after the order or sale to determine whether it is below the minimum stock level.
[0081] The CPU 21 of the terminal device 20A accepts input of an instruction to run the browser from Yamada Taro via the operation unit 22, and executes the browser program P3 stored in the storage unit 35 to start the browser. The CPU 21 accepts input of a URL (Uniform Resource Locator) for executing an order information input process within the browser via the operation unit 22. The input URL is a URL corresponding to the server 30 that executes the order information input process and provides WEB order screen information.
[0082] When the CPU 31 of the server 30 receives the URL from the terminal device 20A via the communication unit 36, it executes an order information input process. The CPU 31 creates login screen information and transmits it to the requesting terminal device 20A. The CPU 21 receives the login screen information from the server 30 via the communication unit 36 and displays it as a login screen on the browser of the display unit 24. The CPU 21 accepts input of a login ID and password from Yamada Taro via the operation unit 22, and transmits the login ID and password to the server 30 via the communication unit 26.
[0083] The CPU 31 receives a login ID and password from the terminal device 20A via the communication unit 36. The CPU 31 performs login authentication based on the received login ID and password and a combination of the login ID 131 and password 132 in the login information table 130. If the login authentication is successful, the CPU 31 acquires the customer code 133 corresponding to the authenticated login ID 131. The CPU 31 generates WEB order input screen information for a WEB order of a product based on the customer code 133 and the product master table 80B, and transmits the information to the requesting terminal device 20A.
[0084] The CPU 21 receives the web order entry screen information from the server 30 via the communication unit 26, and displays the web order entry screen information on the browser of the display unit 24 as a web order entry screen.
[0085] The displayed web order entry screen is, for example, web order entry screen 600 shown in Fig. 11. Web order entry screen 600 has display fields 601 and 602, input fields 603 and 604, and an order confirmation button 605. Display field 601 displays the name of the product being sold. Display field 602 displays the unit of the product being sold. Display fields 601 and 602 correspond to the products of each record in product master table 80B.
[0086] An input field 603 accepts input of the quantity of the product in the display field 601. An input field 604 accepts input of the selection of the customer from which the order is placed. An order confirmation button 605 is a button that accepts input of confirmation display of the order information before placing an order. After the confirmation display of the order information, the order is executed.
[0087] The Web order entry screen 600 allows the records in the display fields 601, 602 and input field 603 to be sorted by order number of orders, order date, or product name. The Web order entry screen 600 also has an input field for summary information as a memo for product orders.
[0088] CPU 21 accepts input of ordering information from Yamada Taro via operation unit 22, and transmits the ordering information to server 30 via communication unit 26. The input ordering information includes Yamada Taro's customer code selected and input in input field 604, the name of the product to be ordered in display field 601, the quantity input in input field 603, application information, etc.
[0089] CPU 31 receives order information from terminal device 20A via communication unit 36, obtains current date and time information at the time of reception from clock unit 37, and stores the order information and current date and time information in order transaction table 120. More specifically, CPU 31 stores the obtained customer code, current date and time information, product name and quantity of the order information in customer code 121, order date 122, product name 124 and quantity 125. CPU 31 also sets product code 123 and import category 126 corresponding to the stored record. Product code 123 is stored as product code 81 corresponding to product name 82 of product name 124 in product master table 80B. Import category 126 is stored with "0" as the default value.
[0090] Next, we will briefly explain the flow of ordering products from customers (order information input process). Here, we will explain an example in which a person in charge at a wholesale company directly receives an order for products from a customer (Taro Yamada) by phone, but the same applies to other customers.
[0091] The person in charge at the wholesale company receives the order information from Taro Yamada by phone. The order information includes the name of the customer who placed the order, the product name and quantity of the product to be ordered. The CPU 11 of the information processing device 10 receives an input of an instruction to execute an order information input process from the person in charge at the wholesale company via the operation unit 12, and executes the order information input process.
[0092] The CPU 11 accepts input of order information from a person in charge of the wholesale company via the operation unit 12, obtains current date and time information at the time of input from the clock unit 18, and obtains a customer code 61 corresponding to the customer name 62 of the order source by referring to the customer master table 60. The CPU 11 stores the order information and the like in the order transaction table 90. More specifically, the CPU 11 stores the obtained customer code 61, the obtained current date and time information, the product name and quantity of the order information in the customer code 91, order date 92, product name 94, and quantity 95. The CPU 11 sets a product code 93 and an import category 96 corresponding to the stored record. The product code 81 corresponding to the product name 82 in the product master table 80A is stored as the product code 93. The import category 96 is stored with "0" as a default value.
[0093] Next, the confirmation information notification process executed by the information processing device 10 will be described with reference to Fig. 8 and Fig. 9. The confirmation information notification process is a process for identifying customers who have not placed orders or received orders for products at a specified confirmation time, and for transmitting confirmation information to the identified customers to confirm that no orders for products have been received, using a notification method set for each customer.
[0094] In the information processing device 10, an instruction to execute the confirmation information notification process is input once a day from the person in charge of the wholesale company via the operation unit 12. The CPU 11 is triggered by the instruction to execute the confirmation information notification process in accordance with the confirmation information notification program P2 stored in the storage unit 15. The confirmation information notification process may be configured to be executed at a predetermined time of day (for example, business hours of the wholesale company).
[0095] First, the CPU 11 refers to the order transaction table 120 of the server 30 via the communication unit 16 (step S21). The CPU 11 determines whether or not there is any unprocessed (unimported) order information (record) in which the import category 126 of the referenced order transaction table 120 is "0" (step S22).
[0096] If there is unprocessed order information (step S22; YES), the CPU 11 receives the unprocessed order information from the server 30 via the communication unit 16, and stores the received unprocessed order information in the order transaction table 100 (step S23). Specifically, the CPU 11 requests the server 30 for the unprocessed order information. The CPU 31 of the server 30 transmits a record in the order transaction table 120 with the import category 126=0 to the information processing device 10 as order information. Furthermore, the CPU 31 stores 1 in the import category 126 of the record. The customer code 121, order date 122, product code 123, product name 124, and quantity 125 of the unprocessed order information are stored in the customer code 101, order date 102, product code 103, product name 104, and quantity 105, and "2 (order transaction table 120)" is stored in the import source category 106. Furthermore, "1 (acquired)" is stored in the acquisition category 126 of the unprocessed order information after acquisition in the order transaction table 120.
[0097] In step S23, the CPU 11 may be configured to display a Web order capture screen 700 shown in FIG.
[0098] Then, the CPU 11 reads out unprocessed order information (records) from the order transaction table 90, and stores the read out unprocessed order information in the order receipt transaction table 100 (step S24). Specifically, in the information processing device 10, the customer code 91, order date 92, product code 93, product name 94, and quantity 95 of the unprocessed order information (import category 96=0) are stored in the customer code 101, order date 102, product code 103, product name 104, and quantity 105, and "1 (order transaction table 90)" is stored in the import source category 106. Furthermore, "1 (imported)" is stored in the import category 96 of the unprocessed order information after import in the order transaction table 90. If there is no unprocessed order information (step S22; NO), the process proceeds to step S24.
[0099] The CPU 11 refers to the confirmation time 56 in the company control table 50, acquires current date and time information from the clock unit 18, and determines whether the acquired current date and time information is the confirmation time 56 (step S25). If the current date and time information is not the confirmation time 56 (step S25; NO), the process proceeds to step S21.
[0100] If the current date and time information is the confirmation time 56 (step S25; YES), the CPU 11 extracts order information (records) from the order transaction table 100 for the day in which the order date 102 corresponds to the current date and time information acquired in step S25 (step S26). The CPU 11 refers to the customer master table 60, extracts customer codes 61 that do not exist in the customer codes 101 of the order information extracted in step S26, and stores them in the notification list 110 together with the notification category 70 (step S27). More specifically, the CPU 11 stores the extracted customer codes 61 and notification category 70 from the customer master table 60 in the customer codes 111 and notification category 112 of the notification list 110 for each record of the customer code.
[0101] Then, CPU 11 selects the next unselected record in notification list 110 as customer information (step S28). When step S28 is executed for the first time, customer information of the first record in notification list 110 is selected. In step S28, CPU 11 may be configured to display an unreceived order automatic determination processing screen 800 shown in Fig. 13 on display unit 14. The unreceived order automatic determination processing screen 800 includes, for example, a message to the effect that customers who have not received product orders on the day will be extracted and confirmation information will be transmitted.
[0102] Then, CPU 11 determines whether or not the notification category 112 of the selected confirmation information requires notification of the confirmation information (is not "0") (step S29). If notification of the confirmation information is required (step S29; YES), CPU 11 sets the FAX number 67, email address 68, or SNS ID 69 corresponding to the notification category 70 of the selected customer information to the FAX number 113, email address 114, or SNS ID 115 in the notification list 110 (step S30). CPU 11 determines whether or not all customer information has been selected in step S28 (step S31).
[0103] If not all customer information has been selected (step S31; NO), the process proceeds to step S28. If notification of confirmation information is not required (step S29; NO), the CPU 11 deletes the record of the customer code 111 corresponding to the selected customer information from the notification list 110 (step S32). The process proceeds to step S28.
[0104] When all the customer information has been selected (step S31; YES), as shown in FIG. 9, the CPU 11 selects the next unselected record in the notification list 110 as customer information (step S33). When step S33 is executed for the first time, the customer information of the first record in the notification list 110 is selected. The CPU 11 acquires the notification method (FAX, email, or SNS) and its contents of the notification category 112 corresponding to the selected customer information from the notification list 110, and sets it as the notification method of the confirmation information (step S34). If the notification category 112 is FAX, the notification method includes FAX and its FAX number 113. If the notification category 112 is email, the notification method includes email and its email address 114. If the notification category 112 is SNS, the notification method includes SNS and its SNS ID 115.
[0105] Then, the CPU 11 determines which notification method of the confirmation information is selected (step S35). If the notification method is FAX (step S35; FAX), the CPU 11 generates confirmation information of the unordered product and notifies the confirmation information by FAX transmission to the FAX number of the notification method via the FAX unit 17 (step S36). The confirmation information is, for example, a message saying, "There is no order or order for today's product. Perhaps you forgot to order or place an order for the product." For example, when the destination is the customer of the terminal device 20A, the CPU 11 FAX-transmits the confirmation information to the FAX device 40A via the FAX unit 17 and the telephone line network of the communication network N. The customer of the terminal device 20A refers to the confirmation information on the paper received and printed by the FAX device 40A.
[0106] If the notification method is email (step S35; email), CPU 11 generates confirmation information of the non-ordered product, and notifies the confirmation information by email to the email address of the notification method via communication unit 16 (step S37). If the notification method is SNS (step S35; SNS), CPU 11 generates confirmation information of the non-ordered product, and notifies the confirmation information by email to the SNSID of the notification method via communication unit 16 (step S38).
[0107] Then, the CPU 11 determines whether or not all the customer information has been selected in step S33 via the communication unit 16 (step S39). If all the customer information has not been selected (step S39; NO), the process proceeds to step S33. If all the customer information has been selected (step S39; YES), the confirmation information notification process ends.
[0108] As described above, according to this embodiment, the information processing device 10 includes the CPU 11. The CPU 11 extracts, as a notification target, customer information that is not stored in the order information of the order transaction table 100 of the storage unit 15 at a predetermined confirmation time, from among the customer information stored in a predetermined customer master table 60. The CPU 11 controls the FAX unit 17 and the communication unit 16 to notify the extracted notification target based on the notification category 70 that is linked in advance to the customer information of the notification target.
[0109] This allows notifications to be sent in an appropriate manner for each customer who has not placed an order. This prevents customers who have forgotten to order a product from running out of stock and allows them to deal with the situation if they have forgotten to place an order. Furthermore, for the wholesale company, the system automatically determines whether there have been any orders for the day and even automates the notification process, eliminating the need for a staff member to check each order one by one. This saves the wholesale company time and effort (work load), and also reduces costs such as labor costs.
[0110] In addition, the notification category 70 is one of the following: notification by fax, notification by e-mail, or notification by SNS. Therefore, it is possible to notify the customer by various appropriate notification methods, and it is also possible not to notify depending on the customer's circumstances.
[0111] The notification is a notification of confirmation information for confirming with the customer to whom the notification is to be made that there is no order for the product. Therefore, the confirmation information can reliably notify the customer that there is no order for the product, and can encourage the customer to order the product.
[0112] Furthermore, the CPU 11 temporarily stores the order information from the customer that has been inputted through operation in the order transaction table 90, and stores the order information in the order transaction table 100 and then stores it in the storage unit 15. Therefore, the order information from the customer that has been inputted through operation can be reliably stored.
[0113] The order management system 1 includes an information processing device 10, a server 30 as a storage device for storing order information (order information) from customers received from the customer terminal devices 20A, 20B, 20C, and the customer terminal devices 20A, 20B, 20C. The customer terminal devices 20A, 20B, 20C transmit the order information (order information) from the customers to the server 30. The CPU 11 receives the order information from the business partners from the server 30, and stores the received order information from the customers in the order transaction table 100 and in the storage unit 15. Therefore, the order information from the customers transmitted from the terminal devices 20A... to the server 30 can be reliably acquired and stored.
[0114] In the above description, an example has been disclosed in which the storage unit 15 such as an HDD or SSD is used as a computer-readable medium for the program according to the present invention, but the present invention is not limited to this example. As other computer-readable media, other non-volatile memories and portable recording media such as CD-ROMs can be applied. In addition, a carrier wave is also applied to the present invention as a medium for providing data of the program according to the present invention via a communication line.
[0115] The above description of the embodiment is merely an example of the information processing device, system, order management method, and program according to the present invention, and the present invention is not limited to this.
[0116] For example, in the above embodiment, a customer places an order with a wholesale company every day, and the company control table 50 has one confirmation time 56, but this is not limited to the above. Depending on the type of business of the company that accepts orders, it is effective to set the confirmation time 56 to a date and time, or to multiple times. The confirmation time 56 may be, for example, 4 p.m. every Friday, 4 p.m. on a certain day of each month, or 12 p.m. and 4 p.m. every day.
[0117] In the above embodiment, the confirmation time 56 is the same for all customers of one wholesale company, but this is not limited to this. The confirmation time 56 may be set to be different for each customer.
[0118] In the above embodiment, all products sold by the wholesaler are subject to the input of order information (order) on the Web, but the present invention is not limited to this. Only product information of products required for each customer may be set, and the CPU 31 of the server 30 may display only the product information of the products required on the display unit 24 of the terminal device for each customer. The CPU 31 may be configured to accept an input of order information for a selected product from the displayed product information via the operation unit 22.
[0119] In the above embodiment, the wholesale company using the information processing device 10 sells products to customers who operate stores, but the present invention is not limited to this. For example, a store may use the information processing device 10 to sell products to customers who are consumers.
[0120] The method of notifying the confirmation information is not limited to FAX, email, or SNS, and may be, for example, an automated voice message by telephone or a Short Message Service (SMS).
[0121] In the above embodiment, the company control table 50, the customer master table 60, the order transaction table 90, and the order transaction table 100 are stored in the storage unit 15 of the information processing device 10, but the present invention is not limited to this. For example, the company control table 50, the customer master table 60, the order transaction table 90, and the order transaction table 100 may be stored in the storage unit 35 of the server 30. The CPU 11 of the information processing device 10 requests the server 30 to receive and acquire the information stored in the storage unit 35 via the communication unit 16 as necessary.
[0122] Although the embodiments of the present invention have been described, the scope of the present invention is not limited to the above-described embodiments, but includes the scope of the invention described in the claims and its equivalents. [Explanation of symbols]
[0123] 1. Order Management System 10. Information processing device 11 CPU 12 Control section 13 RAM 14 Display section 15 Storage section 16 Communications Department 17 Fax Department 18 Timing section 19 Bus 20A, 20B, 20C Terminal equipment 21 CPU 22 Control section 23 RAM 24 Display 25 Memory section 26 Communications Department 27 Bus 30 Servers 31 CPU 32 Operation section 33 RAM 34 Display section 35 Storage section 36 Communications Department 37 Timing section 38 Bus 40A fax machine N Communication Network
Claims
1. an extraction means for extracting, from among the supplier information stored in a specified supplier table, supplier information for which order information is not stored in a specified storage means at a specified time, as a notification target; and a notification control means for controlling the notification means so as to notify the notification target extracted by the extraction means based on notification method information that is linked in advance to customer information of the notification target.
2. The information processing apparatus according to claim 1 , wherein the notification method information is any one of notification by facsimile, notification by e-mail, and notification by social networking site.
3. The information processing apparatus according to claim 1 , wherein the notification is a notification of confirmation information for confirming to the notification target that there is no order.
4. 2. An information processing apparatus according to claim 1, further comprising a first storage control means for storing order information inputted from a supplier in said storage means.
5. 5. An information processing device as claimed in any one of claims 1 to 4, further comprising a second memory control means for receiving order information from a supplier from a storage device that stores order information from the supplier received from the supplier's terminal device, and storing the received order information from the supplier in the storage means.
6. The information processing device according to claim 5 ; a storage device for storing order information from the supplier received from the terminal device of the supplier; A terminal device of the supplier that transmits order information from the supplier to the storage device.
7. an extraction step of extracting, from among supplier information stored in a specified supplier table, supplier information for which order information is not stored in a specified storage means at a specified time, as a notification target; a notification control step of controlling a notification means to notify the notification targets extracted in the extraction step based on notification method information that is linked in advance to trading partner information of the notification targets.
8. Computer, an extraction means for extracting, from among the supplier information stored in a predetermined supplier table, supplier information for which no order information is stored in a predetermined storage means at a predetermined time, as a notification target; A notification control means for controlling a notification means to notify the notification target extracted by the extraction means based on notification method information previously associated with customer information of the notification target; A program to function as a
Citation Information
Patent Citations
System and method for recommending commodity, recording medium, and system and method for selling commodity
JP2001325523A