JP2012221417A - Merchandise ordering system and merchandise ordering method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a merchandise ordering system which can be used at a plurality of shops using a tablet terminal for a large facility, and by which some pieces of merchandise at the plurality of shops can be ordered from one tablet terminal.SOLUTION: In a merchandise order system, a host system 3 is connected to a tablet terminal 4 and a store terminal 6 through a network 9. The host system 3 includes: means that searches database, in a case where a request received from the tablet terminal 4 is a shop and merchandise information search request, based on a shop code and a merchandise code that are received together with the request; means that constitutes information based on the acquired information and a model for displaying a merchandise menu; means that transmits the constituted information to the tablet terminal 4; means that updates or registering database in a case where the request received from the tablet terminal 4 is a merchandise order information determination request; and means that transmits an order status to the tablet terminal 4 and the store terminal 6.

Description

  The present invention relates to an information linkage system using a tablet terminal, and more particularly to a product ordering system and a product ordering method that can be used at a plurality of stores using tablet terminals in a large facility.

Various information can be exchanged by the spread of portable information terminals.
In recent years, solutions using tablet terminals such as iPad (registered trademark) and Android (registered trademark) smartphones are widely used in the world. The user can obtain various types of information from the tablet terminal in the form of text, voice, video, and the like. In addition, various tablet terminals such as those equipped with pen input and touch panels have appeared.

FIG. 13 is a schematic configuration diagram of an information linkage system using a conventional portable information terminal. The server device 510 stores and distributes various types of information, receives information from the server device 510, and receives the server device 510 as necessary. The mobile communication terminal 520 transmits information to the mobile communication terminal 520, and the information device 530 acquires the information transmitted from the mobile communication terminal 520 via the server device 510.
In addition, the following patent document 1 is mention | raise | lifted as a well-known technical document relevant to this invention.
Patent Document 1 discloses an information distribution system capable of acquiring necessary information even in a mobile communication terminal having a limited display area and outputting detailed information to an information output device disposed in a shopping mall or the like. Is described.

JP 2010-140274 A

In large-scale facilities, many stores are lined up, and many customers form a line to order and purchase goods.
For this reason, until the product is ordered, even if the product to be ordered is decided, it must be in line, and when ordering, it is necessary for the customer to tell the order to the store clerk. Both mentally and physically and physically.

  In view of the above situation, the present invention uses a plurality of tablet terminals for large facilities that can order products from a plurality of stores from a single tablet terminal without having to line up at the product sales counter or convey the order to store staff. An object is to provide a product ordering system and a product ordering method that can be used in a store.

In order to solve the above problems, the present invention provides the following configurations.
According to the first aspect of the present invention, a host system having a storage device for storing a database is connected to a tablet terminal via wireless communication using an access point and a network, and stores via a network using a public line network In the product ordering system connected to the terminal,
When the request received from the tablet terminal is a store / product information search request, the host system stores a product information database stored in the storage device based on the store code and the product code received together with the request. Means for searching store information, product information, store advertisement image and product image against store information database, store advertisement image database and product image database;
Based on the acquired information and a model for displaying the product menu, means for configuring information to be displayed on the tablet terminal to be transmitted;
Means for transmitting the configured information to the tablet terminal;
If the request received from the tablet terminal is not a store / product information search request, means for determining whether it is a product order information determination request;
In the case of a product order information determination request, based on the store code and product code received together with the product order information determination request, means for searching a product order status database and a product information database stored in the storage device;
A means for determining whether or not a product can be provided from information acquired through a search, or a providing time determination process;
As a result of the determination, if the product cannot be provided within a certain time, a means for creating a message indicating "insufficient inventory" or "time required to provide" and transmitting it to the tablet terminal;
If the product can be provided within a certain time, or if the request received from the tablet terminal is a product order information determination request, the order information received together with the product order information determination request or the product order information determination request is included. And means for updating or registering the product order status database, product information database, order history database stored in the storage device,
Means for transmitting the order status to the tablet terminal and the store terminal;
If the request received from the tablet terminal is not a product order information determination request and is an order status confirmation request, the product order status based on the terminal code and terminal usage serial number received together with the order status confirmation request There is provided a product ordering system comprising a means for searching a database and transmitting a result to the tablet terminal.

The invention according to claim 2 is the product order system in which the host system is further connected to the lending management terminal of the tablet terminal via a network using a public network.
The lending management terminal, the terminal code of the input tablet terminal, means for transmitting a terminal status search request of the tablet terminal to the host system,
Based on the terminal status search request, upon receiving a caution message indicating “the terminal is rented” or the tablet terminal information of the terminal code from the host system, the received caution message or tablet terminal information is displayed on the screen. Means to
When the lending time is input when the lending time of the tablet terminal is enabled by the tablet terminal information displayed on the screen, means for transmitting the lending time to the host system together with the tablet terminal information;
Means for transmitting a terminal payment status confirmation request to the host system together with the tablet terminal information in which the terminal code is input when the tablet terminal is returned;
In the search result for the terminal payment status confirmation request received from the host system, if there is no unpaid information, or if there is unpaid information and the unpaid price is collected, the return time is input, Means for transmitting the tablet terminal information to which the return time is input to the host system,
The host system is configured to search the tablet terminal information database based on a terminal code based on a terminal status search request received from the lending management terminal;
When there is information that the terminal lending status is lent with the same terminal code in the tablet terminal information database, means for transmitting a caution message indicating "the terminal is being lent" to the lending management terminal;
If there is no information that the terminal lending status is lent out, search for the same terminal code with the largest terminal use serial number, add 1 to the value, and manage the tablet terminal information including the terminal use serial number in the lending management Means for sending to the terminal;
When the tablet terminal information and the terminal payment status confirmation request are received from the lending management terminal, the status classification is other than cancellation for the product order status database based on the terminal code and terminal usage serial number of the received tablet terminal information, and the payment 2. A product order system according to claim 1, further comprising means for searching for unpaid information for a category and transmitting a search result to the lending management terminal.

According to a third aspect of the present invention, when the request received from the store terminal is a product order cancellation request, the host system receives the terminal code, terminal usage serial number, product store code, and product code received together with the product order cancellation request. Updating the merchandise order status database and merchandise information database on the basis of, and transmitting a message indicating "update completion" to the store terminal;
When the request received from the store terminal is a provided product update request for updating the product to the state in which the product is provided, the terminal code, terminal use serial number, product store code, and product code received together with the provided product update request are also included. Updating the product order status database and transmitting a message indicating "update completed" to the store terminal;
If the request received from the store terminal is a store / product information change request, the product information database, store information database, store advertisement image based on the store information and product information received together with the store / product information change request 3. A product order system according to claim 1, further comprising means for updating or registering the database and the product image database and transmitting a message indicating "update / registration completion" to the store terminal. To do.

According to a fourth aspect of the present invention, a host system including a storage device for storing a database is connected to a tablet terminal via wireless communication using an access point and a network, and a store via a network using a public line network. In the product ordering method of the product ordering system connected to the terminal,
When the request received from the tablet terminal is a store / product information search request, the host system stores a product information database stored in the storage device based on the store code and the product code received together with the request. Searching store information, product information, store advertisement image and product image against store information database, store advertisement image database and product image database;
Configuring the information to be displayed on the tablet terminal to be transmitted based on the acquired information and a model for displaying the product menu; and
Transmitting the configured information to the tablet terminal;
If the request received from the tablet terminal is not a store / product information search request, determining whether it is a product order information determination request;
If it is a product order information determination request, based on the store code and product code received together with the product order information determination request, searching the product order status database and product information database stored in the storage device;
A step of determining whether or not a product can be provided from information acquired by a search, or performing a provision time determination process;
As a result of the determination, if the product cannot be provided within a certain time, creating a message indicating "insufficient inventory" or "time required to provide" and sending it to the tablet terminal;
If the product can be provided within a certain time, or if the request received from the tablet terminal is a product order information determination request, the order information received together with the product order information determination request or the product order information determination request is included. And updating or registering the product order status database, product information database, order history database stored in the storage device, and
Transmitting the order status to the tablet terminal and the store terminal;
If the request received from the tablet terminal is not a product order information determination request and is an order status confirmation request, the product order status based on the terminal code and terminal usage serial number received together with the order status confirmation request The present invention provides a product ordering method for a product ordering system, comprising: searching a database and transmitting a result to the tablet terminal.

The invention according to claim 5 is the product ordering method of the product ordering system in which the host system is further connected to the lending management terminal of the tablet terminal via a network by a public network.
When the host system receives a terminal code of the tablet terminal and a terminal state search request of the tablet terminal from the lending management terminal, the tablet terminal information database based on the terminal code based on the received terminal state search request Searching for
If there is information that the terminal lending status is lent with the same terminal code in the tablet terminal information database, a step of transmitting a caution message indicating "the terminal is being lent" to the lending management terminal;
If there is no information that the terminal lending status is lent out, search for the same terminal code with the largest terminal use serial number, add 1 to the value, and manage the tablet terminal information including the terminal use serial number in the lending management To send to the device,
When the lending management terminal receives a caution message indicating “the terminal is being lent” or the tablet terminal information of the terminal code from the host system based on the terminal state search request, the received caution message or tablet Displaying device information on the screen;
When the lending time is input when the lending time is input when the lending time of the tablet terminal is enabled by the tablet terminal information displayed on the screen, the step of transmitting the lending time together with the tablet terminal information to the host system is executed,
When the host system receives the tablet terminal information and the terminal payment status confirmation request from the lending management terminal when the tablet terminal is returned, the product order status database is received according to the terminal code and terminal usage serial number of the received tablet terminal information. On the other hand, the status classification is other than cancellation, and the payment classification is searched for unpaid information, and the step of transmitting the search result to the lending management terminal is executed.
When the lending management terminal has no unpaid information in the search result for the terminal payment status confirmation request received from the host system, or when there is unpaid information and an unpaid price is collected The method of providing a product ordering method for a product ordering system according to claim 4, wherein the step of transmitting the tablet terminal information to which the return time has been input to the host system is executed when the return time is input. is there.

The invention according to claim 6 is that, when the request received from the store terminal is a product order cancellation request, the host system receives the terminal code, terminal usage serial number, product store code, and product code received together with the product order cancellation request. Updating the product order status database and product information database on the basis of, and transmitting a message indicating "update completion" to the store terminal;
When the request received from the store terminal is a provided product update request for updating the product to the state in which the product is provided, the terminal code, terminal use serial number, product store code, and product code received together with the provided product update request are also included. Updating the product order status database and sending a message indicating "update completed" to the store terminal;
If the request received from the store terminal is a store / product information change request, the product information database, store information database, store advertisement image based on the store information and product information received together with the store / product information change request The product of the product ordering system according to claim 4 or 5, wherein the product and the product image database are updated or registered, and a message indicating "update / registration complete" is transmitted to the store terminal. It provides an ordering method.

The merchandise ordering system of the present invention has the following effects.
It is possible to order products from a plurality of stores from one tablet terminal without having to line up at the product sales counter or tell the store staff about the order.

It is a system configuration figure showing an example of an embodiment of a goods ordering system of the present invention. It is a block diagram of the data stored in the tablet terminal information database of this invention. It is a block diagram of the data stored in the product information database of the present invention. It is a block diagram of the data stored in the product order status database of the present invention. It is a flowchart figure which shows the flow of the visitor's action of this invention. It is a flowchart figure which shows the operation and process in the rental management terminal of this invention. It is a flowchart figure which shows the process of the host system with respect to the request | requirement from the tablet terminal of this invention. It is a flowchart figure which shows the process of the host system with respect to the request | requirement from the lending management terminal of this invention. It is a flowchart figure which shows the process of the host system with respect to the request | requirement from the shop terminal of this invention. It is a flowchart figure which shows the process of the host system with respect to the request | requirement from the host terminal of this invention. It is explanatory drawing of the specific example of the goods menu template of this invention. It is explanatory drawing of the specific example of the menu comprised of this invention. It is a schematic block diagram of the information cooperation system using the portable information terminal of a prior art example.

Hereinafter, embodiments of the present invention will be described with reference to the drawings showing examples.
The host system, the tablet terminal, the rental management terminal, and the store terminal are computers, and each means or step is a means or step realized by reading and executing a computer program necessary for the CPU of the computer. FIG. 6 to FIG. 10 are flowcharts.

  FIG. 1 is a system configuration diagram showing an embodiment of the present invention. The merchandise ordering system of this embodiment includes a host system 3 having a storage device for storing a tablet terminal information database 1 and a merchandise order status database 2, and a plurality of tablet terminals 4a that receive store data and merchandise data from the host system 3. , 4b, 4c and lending management terminals 5a, 5b, 5c for managing the lending status of the tablet terminals 4a, 4b, 4c, and store terminals that are installed in a plurality of stores and exchange product order information with the host system 3 6a, 6b, 6c and wireless markers 7a, 7b, 7c installed so that product information can be efficiently acquired using the tablet terminals 4a, 4b, 4c. The tablet terminals 4a, 4b, 4c are controlled by the access point 8. Perform wireless communication. Further, the rental management terminals 5a, 5b, 5c and the shop terminals 6a, 6b, 6c are connected to a network 9 by a public network, and the host system 3 is connected to the network 9.

Therefore, the tablet terminals 4a, 4b, 4c and the host system 3 are connected to the host system 3 through wireless communication using the access point 8 and the network 9.
In the host system 3, in addition to the tablet terminal information database 1 that stores lending information and the like of the tablet terminals 4a, 4b, and 4c and the product order status database 2 that manages the order status of products, product information of each store in the facility Product information database 10 storing store information, store information database 11 storing various store information, store advertisement image database 12 storing store advertisement images, product image database 13 storing product images, and order information history. An order history database 14 to be stored and a product price history database 15 to store a history of product prices are stored in a storage device.

  Registered in the tablet terminal information database 1 are tablet terminal codes for identifying the tablet terminals 4a, 4b and 4c and information indicating the usage status of the tablet terminals 4a, 4b and 4c. In the merchandise order status database 2, the number of which merchandise at which store has been ordered, the time when the order of the merchandise is received and provided, the seat number for providing the merchandise, and the like are registered. In the product information database 10, information such as a code for identifying which product at which store, a product price, a stock quantity, a display position when displayed on the tablet terminals 4a, 4b, and 4c, and a product providing style are registered. ing. The store information database 11 stores store names, store opening / closing status, business hours, and the like, and the store advertisement image database 12 stores store advertisement images. In the product image information database 13, product images to be displayed on the tablet terminals 4a, 4b, and 4c when a product is selected are registered.

  The order history database 14 stores the processed date in addition to the contents of the product order status database 2. This assumes that information in the product order status database 2 is deleted from the lending management terminals 5a, 5b, 5c when the tablet terminals 4a, 4b, 4c are returned, and all order information is stored in the order history database 14. This is because the history is managed. In the product price history database 15, codes for identifying stores and products, price application periods, and prices are registered for the purpose of history management of product price fluctuations. A host terminal 16 is connected to the network 9 to update terminal information when adding terminals other than the tablet terminals 4a, 4b, 4c, and to leave the rental management terminals 5a, 5b, 5c or the store terminals 6a, 6b, 6c. It is configured so that maintenance can be performed from a location.

  FIG. 2 is a diagram illustrating an example of tablet terminal lending information stored in the tablet terminal information database 1. As shown in FIG. 2, each area data includes a terminal code 201, a terminal usage serial number 202, a terminal rental status 203, a rental time 204, and a return time 205. The terminal code, the terminal usage serial number, The terminal lending status, lending time, and return time are registered.

  Here, for example, when renting a terminal, “D0001” is registered as the terminal code 201, “0001” as the terminal use serial number 202, “under loan” as the terminal loan status 203, and “09:00” as the loan time 204 are registered. No value is set as the return time 205. If another terminal that is being rented (a different terminal whose terminal code 201 is different from “D0001”) is returned, “D0002” as the terminal code 201, “0001” as the terminal use serial number 202, and the terminal rental status 203 “Returned”, the rental time 204 is updated to “09:00”, and the return time 205 is updated to “10:30”. When another customer rents the same terminal (terminal with terminal code 201 “D0002”) after the return, “D0002” as terminal code 201 and “0002” as terminal use serial number 202 are added to a new record (row shown in the figure). ”,“ Lending ”as the terminal lending status 203,“ 11:00 ”as the lending time 204, and the terminal use serial number value are incremented by 1 and registered. By providing the terminal use serial number 202, even if another visitor borrows the same terminal after returning the terminal, it can be managed that the user is different from the previous terminal user. Registration and updating in the tablet terminal information database 1 can be performed from the lending management terminals 5a, 5b, and 5c.

  FIG. 3 is a diagram illustrating an example of product information stored in the product information database 10. As shown in FIG. 3, the store code 301, the product code 302, the price 303, the remaining inventory number 304, the display position 305, and the product provision style 306 are composed of area data. The price, remaining inventory, display position, and product provision style are registered. The display position 305 is information indicating where to display the product information on the tablet terminals 4a, 4b, and 4c. The product provision style 306 is information indicating whether the store staff carries the product to the seat where the visitor is present, or whether the visitor takes the product to the store window.

  Here, for example, when registering a new product, “S0001” as the store code 301, “F0001” as the product code 302, “650” as the price 303, “7” as the remaining inventory number 304, and “1” as the display position 305. “Seat” is registered as the product provision style 306. The merchandise information can be updated from the store terminals 6a, 6b, 6c and the host terminal 16, but the store terminals 6a, 6b, 6c restrict the contents that can be operated by the operation authority. For example, an operator with store manager authority can add products, change prices, remaining inventory quantity, display position, etc., but an operator with staff authority can only change the remaining inventory quantity. . It is assumed that the store opening hours are operated with staff authority and are used with store manager authority during maintenance after the store is closed. By providing the operation authority, it is possible to prevent important information such as the price by the store staff from being updated by an erroneous operation or a malicious operation. All updates and additions can be made to the host terminal 16. The remaining inventory number 304 is updated by processing inside the host system 3. For example, when two orders are received for a certain product, a calculation process is performed based on the current remaining inventory number, and if an order can be received, the value is updated by subtracting 2 from the current remaining inventory number. .

  FIG. 4 is a diagram showing an example of information for managing the order / provision status of products stored in the product order status database 2. As shown in FIG. 4, terminal code 401, terminal use serial number 402, order store code 403, order product code 404, order quantity 405, order reception time 406, status category 407, product provision time 408, seat number 409, payment category The area code 410 includes terminal code, terminal use serial number, order store code, order product code, order quantity, order reception time, status category, product provision time, seat number, and payment category.

  Here, for example, when a product is ordered, “D0001” as the terminal code 401, “0001” as the terminal use serial number 402, “S0001” as the order store code 403, “F0003” as the order product code 404, “ “2”, “09:30” as the order reception time 406, “reception” as the status classification 407, “T001” as the seat number 409, and “unpaid” as the payment classification 410 are registered. An operation for ordering a product is performed from the tablet terminals 4a, 4b, and 4c. From the store terminals 6a, 6b, 6c, it is possible to inquire about the ordered product information and to cancel the ordered product information. This operation can be performed from both store manager authority and staff authority. When the ordered product is canceled, the status classification 407 is updated to “cancel”.

If it is desired to cancel the merchandise, it is communicated to the store staff, and the store staff performs it from the store terminals 6a, 6b, 6c. When the ordered product is provided, if the product provision style 306 is “window”, the store staff confirms that the product can be provided from the store terminals 6a, 6b, 6c via the access point 8 and the network 9. The tablet terminals 4a, 4b, and 4c are notified by using. After payment and provision of goods are completed at the store window, the store terminals 6a, 6b, and 6c are updated to “provided” as the status category 407 and “paid” as the payment category 410.
When the product provision style 306 is “seat”, the product is carried to the seat position displayed on the store terminals 6a, 6b, 6c. After confirming that the product has been provided, the store staff performs an operation of determining that the product has been provided from the store terminals 6a, 6b, and 6c. At this time, the status classification 407 is updated to “Provision”, and the product provision time 408 is updated to “12:35”. Thereafter, after the customer has paid, the store terminal 6a, 6b, 6c is updated to “paid” as the payment category 410.
When the product provision style 306 is “seat”, product provision registration and payment registration are performed separately. When the product provision style 306 is “window”, product provision registration and payment registration are performed simultaneously.

  The host system 3 includes a transmission / reception unit 17 that transmits and receives product information to and from the tablet terminals 4a, 4b, and 4c. The store / product information acquisition request from the tablet terminals 4a, 4b, and 4c and the host system 3 acquire from each database. Transmission of information to the tablet terminals 4 a, 4 b, 4 c is performed via the transmission / reception unit 17. In response to a search request from the tablet terminals 4a, 4b, 4c, the lending management terminals 5a, 5b, 5c and the store terminals 6a, 6b, 6c, the search processing unit 18 searches each database. The arithmetic processing unit 19 is a processing unit that calculates the number of remaining inventory and the time required for product provision when order information is received from the tablet terminals 4a, 4b, and 4c. The database update unit 20 is an update processing unit for each database.

  This is the end of the description of the configuration and functions of the product ordering system that can be used in a plurality of stores using the tablet terminal for large facilities according to the present embodiment. Hereinafter, the tablet terminal for large facilities according to the present embodiment is used. The operation of the product ordering system that can be used at multiple stores will be described.

FIG. 5 is a flowchart showing the flow of visitor behavior.
A visitor borrows the tablet terminal 4 (one of the tablet terminals 4a, 4b, 4c) (step 501).
A visitor acquires store information and merchandise information in the tablet terminal 4 from the wireless marker 7 (any one of the wireless markers 7a, 7b, and 7c) installed in each store or its surroundings (step 502).
The visitor selects a store to be used from the tablet terminal 4 (step 503).
A visitor selects goods to order from tablet terminal 4 (Step 504).
The visitor confirms the order determination information from the host system 3 (step 505). If the ordered product is not in stock (step 506), the visitor determines whether to order another product (step 507). When ordering another product, the product to be ordered again is selected (step 504).

If the ordered product is in stock (step 506), the visitor determines whether to agree on the time it takes for the product to be provided (step 508).
When the agreement is reached, the order of the product is confirmed from the tablet terminal 4 (step 509).
The visitor determines whether to order another product (step 507).
If one or more products have already been ordered in a situation where no other product is ordered (step 510), the customer receives provision of the product (step 511).
Thereafter, the visitor pays for the provided goods (step 512).

After receiving the product (step 512) and if no product has been ordered (step 510), the visitor determines whether to use another store (step 513). If it is determined that another store is to be used, the visitor acquires other store information from the wireless marker 7 (step 502).
This series of operations is performed until it is determined that no other store is used.
If it is determined not to use another store, the visitor returns the tablet terminal 4 (step 514).

FIG. 6 is a flowchart showing operations and processing in the lending management terminal 5 (any one of the lending management terminals 5a, 5b, and 5c). The rental management terminals 5 are set in information centers scattered in several places in the facility, and are operated by the facility staff. Moreover, the tablet terminal 4 is also managed in each information center, and the terminal code sticker is affixed on the tablet terminal 4.
The facility staff inputs the terminal code of the tablet terminal 4 managed by the information (step 601).
The lending management terminal 5 transmits the input terminal code to the host system 3 together with the terminal status search request (step 602).

Based on the received terminal status search request, the host system 3 searches the tablet terminal information database 1 based on the terminal code, and transmits the corresponding tablet terminal information to the lending management terminal 5. At this time, if there is information that the terminal lending status 203 is being lent with the same terminal code 201 in the tablet terminal information database 1, a warning message indicating that “the terminal is being lent” is sent to the lending management terminal 5. Send. If there is no information being lent, a search is made for the terminal with the same terminal code 201 having the largest terminal use serial number 202, and 1 is added to the value. Then, the terminal management serial number 202 (terminal usage serial number after adding 1) is transmitted to the lending management terminal 5.
When the lending management terminal 5 receives a caution message indicating “the terminal is being lent” or the tablet terminal information from the host system 3, the lending management terminal 5 displays the received information on the screen (step 603).

If the tablet terminal 4 can be lent, the facility staff inputs the rent time 204 from the rent management terminal 5 and transmits it to the host system 3 together with the tablet terminal information (step 604).
The facility staff lends the tablet terminal 4 to the visitor (step 605).
When the tablet terminal 4 is returned, the facility staff performs a procedure for returning the tablet terminal 4 (step 606).
The facility staff inputs the terminal code 201 from the lending management terminal 5 and inquires about the unpaid information to the host system 3 together with the tablet terminal information (transmits a terminal payment status confirmation request) (step 607).

The host system 3 searches the merchandise order status database 2 with the received terminal code 201 and terminal usage serial number 402 for whether the status category 407 is other than canceled and the payment category 410 has no unpaid information. Is transmitted to the lending management terminal 5 (step 608).
When the lending management terminal 5 receives the result of the unpaid information inquiry (terminal payment status confirmation request) from the host system 3, the lending management terminal 5 displays the inquiry result, and if there is unpaid information in the inquiry result The facility staff collects the unpaid money (step 609).
As a result of the inquiry, if there is no unpaid information, or if there is unpaid information and an unpaid price is collected (step 609), the facility staff inputs the return time 205 and the tablet terminal to which the return time 205 is input Information (information that the tablet terminal 4 returns to the return state) is transmitted to the host system 3 (step 610).

FIG. 7 is a flowchart showing processing of the host system 3 in response to a request from the tablet terminal 4. If the request is for a store / product information search (step 701), the host system 3 uses the received store code and product code to store the product information database 10, the store information database 11, the store advertisement image database 12, and the product image database 13. Store information, product information, store advertisement images and product images are searched for (step 702).
And the information displayed on the tablet terminal 4 which transmits based on the acquired information and the model for displaying the product menu shown in FIG. 11 is configured (step 703). At this time, the current date and time are set. When the remaining inventory number 304 acquired from the product information database 10 is “0”, “sold out” is displayed in the inventory information to notify that the product is sold out.

When the value of the display position 305 acquired from the product information database 10 is “1”, the product name 1, product information 1, inventory information 1, and price 1 in FIG. 11 are displayed. That is, it is possible to determine at which position of the template the product information is displayed based on the value of the display position 305 in the product information database 10. For a product to be recommended, the display position 305 is set to “1”, “2”, or “3”. Product name 1, product information 1, inventory information 1, price 1, product name 2, product information 2, inventory information 2, price 2, product name 3, product information 3, inventory information 3, and price 3 in FIG. 11 are tablet terminals. Does not move even when scrolling during display. Other product information moves when scrolled. A display example after the configuration is shown in FIG.
After the configuration, information is transmitted to the tablet terminal 4 (step 704).

If it is not a store / product information search request (step 701), it is determined whether it is a product order information determination request (step 705).
If it is a product order information determination request, the product order status database 2 and the product information database 10 are searched based on the received store code and product code (step 706).
Then, it is determined whether or not a product can be provided from the acquired product information and product order information, or a provision time determination process is performed (step 707).
As a result of the determination, if the product cannot be provided within a certain time (step 708), a message indicating “inventory shortage” or “time required for provision” is created and transmitted to the tablet terminal 4 (step 709).

If the product can be provided within a certain time (step 708) or if it is a product order information determination request (step 710), the product order status database 2, the product information database 10, and the order history database based on the order information. 14 is updated or registered (step 711).
Then, the order status is transmitted to the tablet terminal 4 and the store terminal 6 (any one of the store terminals 6a, 6b, 6c) (step 712).
If it is not a merchandise order information determination request (step 710), and if it is an order status confirmation request (step 713), the merchandise order status database 2 is searched based on the terminal code and terminal usage serial number, and the result is transmitted. (Step 714).

FIG. 8 is a flowchart showing processing of the host system 3 in response to a request from the lending management terminal 5.
It is determined whether it is a terminal state search request (step 801). If it is a terminal state search request, necessary information is acquired from the tablet terminal information database 1 based on the terminal code (step 802).
It is determined whether or not the loan is possible (step 803).
The determination result is transmitted (step 804).
If it is a terminal update request (step 805), the tablet terminal information database 1 is updated based on the terminal code and terminal use serial number received together with the terminal update request (step 806).
A result message indicating “update completed” is transmitted (807).
If it is a terminal payment status confirmation request (step 808), the product order status database 2 is searched based on the terminal code and terminal usage serial number (step 809).
The search result is transmitted (step 810).
If it is a product order status clear request (step 811), the information in the product order status database 2 is cleared based on the terminal code and terminal use serial number (step 812).

FIG. 9 is a flowchart showing processing of the host system 3 in response to a request from the store terminal 6.
If it is a merchandise order cancellation request (step 901), the merchandise order status database 2 and merchandise information database 10 are updated based on the received terminal code, terminal use serial number, merchandise store code and merchandise code (step 902). , A message indicating “update completed” is transmitted (step 903).
If it is a provided product update request to update the product to the provided state (step 904), the product order status database 2 is updated based on the received terminal code, terminal use serial number, store code, and product code ( Step 905), a message indicating "update complete" is transmitted (Step 906).
If it is a store / product information change request (step 907), the product information database 10, store information database 11, store advertisement image database 12 and product image database 13 are updated and registered based on the store information and product information. (Step 908), a message indicating "update / registration complete" is transmitted (Step 909).

FIG. 10 is a flowchart showing processing of the host system 3 in response to a request from the host terminal 16.
If it is a price update request (step 1001), the product information database 10 and the product price history database 15 are updated and registered based on the request information (step 1002), and a message indicating "update / registration complete" is transmitted. (Step 1003).
When it is an image update request (step 1004), the store advertisement image database 12 and the product image database 13 are updated and registered based on the store code, product code, and image information (step 1005). Is sent (step 1006).
If it is a store addition request (step 1007), the product order status database 2 is searched based on the terminal code and terminal use serial number (step 1008), and the search result is transmitted (step 1009).
If it is a product information update request (step 1010), the information in the product order status database 2 is cleared based on the terminal code and the terminal use serial number (step 1011).
If it is a tablet terminal addition / deletion request (step 1012), addition / deletion to the tablet terminal information database 1 is performed based on the request information (step 1013).

DESCRIPTION OF SYMBOLS 1 Tablet terminal information database 2 Product order status database 3 Host system 4 Tablet terminal 5 Rental management terminal 6 Store terminal 8 Access point 9 Network 10 Product information database 11 Store information database 12 Store advertisement image database 13 Product image database 14 Order history database 201 , 401 Terminal code 202, 402 Terminal use serial number 203 Terminal lending status 204 Lending time 205 Return time 301 Store code 302 Product code

Claims (6)

A product ordering system in which a host system having a storage device for storing a database is connected to a tablet terminal via wireless communication using an access point and a network, and to a store terminal via a network using a public network In
When the request received from the tablet terminal is a store / product information search request, the host system stores a product information database stored in the storage device based on the store code and the product code received together with the request. Means for searching store information, product information, store advertisement image and product image against store information database, store advertisement image database and product image database;
Based on the acquired information and a model for displaying the product menu, means for configuring information to be displayed on the tablet terminal to be transmitted;
Means for transmitting the configured information to the tablet terminal;
If the request received from the tablet terminal is not a store / product information search request, means for determining whether it is a product order information determination request;
In the case of a product order information determination request, based on the store code and product code received together with the product order information determination request, means for searching a product order status database and a product information database stored in the storage device;
A means for determining whether or not a product can be provided from information acquired through a search, or a providing time determination process;
As a result of the determination, if the product cannot be provided within a certain time, a means for creating a message indicating "insufficient inventory" or "time required to provide" and transmitting it to the tablet terminal;
If the product can be provided within a certain time, or if the request received from the tablet terminal is a product order information determination request, the order information received together with the product order information determination request or the product order information determination request is included. And means for updating or registering the product order status database, product information database, order history database stored in the storage device,
Means for transmitting the order status to the tablet terminal and the store terminal;
If the request received from the tablet terminal is not a product order information determination request and is an order status confirmation request, the product order status based on the terminal code and terminal usage serial number received together with the order status confirmation request A product ordering system comprising: means for searching a database and transmitting a result to the tablet terminal. In the product order system in which the host system is further connected to the lending management terminal of the tablet terminal via a network using a public network.
The lending management terminal, the terminal code of the input tablet terminal, means for transmitting a terminal status search request of the tablet terminal to the host system,
Based on the terminal status search request, upon receiving a caution message indicating “the terminal is rented” or the tablet terminal information of the terminal code from the host system, the received caution message or tablet terminal information is displayed on the screen. Means to
When the lending time is input when the lending time of the tablet terminal is enabled by the tablet terminal information displayed on the screen, means for transmitting the lending time to the host system together with the tablet terminal information;
Means for transmitting a terminal payment status confirmation request to the host system together with the tablet terminal information in which the terminal code is input when the tablet terminal is returned;
In the search result for the terminal payment status confirmation request received from the host system, if there is no unpaid information, or if there is unpaid information and the unpaid price is collected, the return time is input, Means for transmitting the tablet terminal information to which the return time is input to the host system,
The host system is configured to search the tablet terminal information database based on a terminal code based on a terminal status search request received from the lending management terminal;
When there is information that the terminal lending status is lent with the same terminal code in the tablet terminal information database, means for transmitting a caution message indicating "the terminal is being lent" to the lending management terminal;
If there is no information that the terminal lending status is lent out, search for the same terminal code with the largest terminal use serial number, add 1 to the value, and manage the tablet terminal information including the terminal use serial number in the lending management Means for sending to the terminal;
When the tablet terminal information and the terminal payment status confirmation request are received from the lending management terminal, the status classification is other than cancellation for the product order status database based on the terminal code and terminal usage serial number of the received tablet terminal information, and the payment 2. The product ordering system according to claim 1, further comprising means for searching for unpaid information in the category and transmitting the search result to the lending management terminal. The host system, when the request received from the store terminal is a product order cancellation request, the product order status based on the terminal code, terminal use serial number, product store code and product code received together with the product order cancellation request Means for updating the database and the product information database, and transmitting a message indicating "update completion" to the store terminal;
When the request received from the store terminal is a provided product update request for updating the product to the state in which the product is provided, the terminal code, terminal use serial number, product store code, and product code received together with the provided product update request are also included. Updating the product order status database and transmitting a message indicating "update completed" to the store terminal;
If the request received from the store terminal is a store / product information change request, the product information database, store information database, store advertisement image based on the store information and product information received together with the store / product information change request 3. The product order system according to claim 1, further comprising means for updating or registering the database and the product image database and transmitting a message indicating “update / registration completion” to the store terminal. A product ordering system in which a host system having a storage device for storing a database is connected to a tablet terminal via wireless communication using an access point and a network, and to a store terminal via a network using a public network In the product ordering method,
When the request received from the tablet terminal is a store / product information search request, the host system stores a product information database stored in the storage device based on the store code and the product code received together with the request. Searching store information, product information, store advertisement image and product image against store information database, store advertisement image database and product image database;
Configuring the information to be displayed on the tablet terminal to be transmitted based on the acquired information and a model for displaying the product menu; and
Transmitting the configured information to the tablet terminal;
If the request received from the tablet terminal is not a store / product information search request, determining whether it is a product order information determination request;
If it is a product order information determination request, based on the store code and product code received together with the product order information determination request, searching the product order status database and product information database stored in the storage device;
A step of determining whether or not a product can be provided from information acquired by a search, or performing a provision time determination process;
As a result of the determination, if the product cannot be provided within a certain time, creating a message indicating "insufficient inventory" or "time required to provide" and sending it to the tablet terminal;
If the product can be provided within a certain time, or if the request received from the tablet terminal is a product order information determination request, the order information received together with the product order information determination request or the product order information determination request is included. And updating or registering the product order status database, product information database, order history database stored in the storage device, and
Transmitting the order status to the tablet terminal and the store terminal;
If the request received from the tablet terminal is not a product order information determination request and is an order status confirmation request, the product order status based on the terminal code and terminal usage serial number received together with the order status confirmation request A product ordering method for a product ordering system comprising: searching a database and transmitting a result to the tablet terminal. In the product ordering method of the product ordering system, wherein the host system is connected to the rental management terminal of the tablet terminal via a network using a public network.
When the host system receives a terminal code of the tablet terminal and a terminal state search request of the tablet terminal from the lending management terminal, the tablet terminal information database based on the terminal code based on the received terminal state search request Searching for
If there is information that the terminal lending status is lent with the same terminal code in the tablet terminal information database, a step of transmitting a caution message indicating "the terminal is being lent" to the lending management terminal;
If there is no information that the terminal lending status is lent out, search for the same terminal code with the largest terminal use serial number, add 1 to the value, and manage the tablet terminal information including the terminal use serial number in the lending management To send to the device,
When the lending management terminal receives a caution message indicating “the terminal is being lent” or the tablet terminal information of the terminal code from the host system based on the terminal state search request, the received caution message or tablet Displaying device information on the screen;
When the lending time is input when the lending time is input when the lending time of the tablet terminal is enabled by the tablet terminal information displayed on the screen, the step of transmitting the lending time together with the tablet terminal information to the host system is executed,
When the host system receives the tablet terminal information and the terminal payment status confirmation request from the lending management terminal when the tablet terminal is returned, the product order status database is received according to the terminal code and terminal usage serial number of the received tablet terminal information. On the other hand, the status classification is other than cancellation, and the payment classification is searched for unpaid information, and the step of transmitting the search result to the lending management terminal is executed.
When the lending management terminal has no unpaid information in the search result for the terminal payment status confirmation request received from the host system, or when there is unpaid information and an unpaid price is collected 5. The product ordering method of the product ordering system according to claim 4, wherein the step of transmitting the tablet terminal information to which the return time is input to the host system is executed when the command is input. The host system, when the request received from the store terminal is a product order cancellation request, the product order status based on the terminal code, terminal use serial number, product store code and product code received together with the product order cancellation request Updating the database and the product information database, and sending a message indicating "update completed" to the store terminal;
When the request received from the store terminal is a provided product update request for updating the product to the state in which the product is provided, the terminal code, terminal use serial number, product store code, and product code received together with the provided product update request are also included. Updating the product order status database and sending a message indicating "update completed" to the store terminal;
If the request received from the store terminal is a store / product information change request, the product information database, store information database, store advertisement image based on the store information and product information received together with the store / product information change request The product of the product ordering system according to claim 4 or 5, wherein the product and the product image database are updated or registered, and a message indicating "update / registration complete" is transmitted to the store terminal. How to order.

Images