JP2006277536A - Ordering system, and processing method and program for the same - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To prevent data inconsistency between databases caused at merchandise registration while utilizing advantages of an ordering system allowing temporary registration and definite registration of order data. <P>SOLUTION: An ordering system has an ordering terminal 1a and an order data DB 41 for registering order data entered into the ordering terminal 1a. The ordering terminal 1a comprises a screen display 10 for displaying a predetermined ordering screen, a data input unit 20 for entering order data including an order quantity for each article of merchandise to be ordered on the displayed ordering screen, and an arithmetic device (display data arithmetic processing unit 31, memory system 32) 30 for, when the order data is entered, temporarily registering the order data as distinguishable temporary order data in the order data DB 41, and when a predetermined operation for fixing the temporarily registered temporary order data is performed, definitely registering the temporary order data as distinguishable definite order data. <P>COPYRIGHT: (C)2007,JPO&INPIT

Description

  The present invention relates to an ordering system, a processing method thereof, and a program, and more particularly to a device for preventing a data inconsistency at the time of registering a product in a database.

  Order data management terminals (dedicated product ordering terminals) are used for store systems used in retail, wholesale, and restaurant industries that require order processing to secure inventory products or materials as inventory, such as warehouse inventory management. Or, an ordering system using a terminal or software similar to that is known. In this ordering system, ordering data such as the number of orders for commodities to be ordered is entered and registered in a database. The registered data is transmitted to an ordering system connected to the ordering system in a communicable manner. By doing so, the ordering process is performed and the product or stock is replenished.

  In order processing using such an ordering system, the data entry of the ordered product is directly registered in the database. Therefore, when the order data is entered, it is immediately treated as final registration confirmation (entry = final registration confirmation). Therefore, when the numerical value is corrected after the order data is confirmed, the order data is overwritten and written. Then, the overwritten ordering data is transmitted to the ordering system. In this case, depending on the specifications of the system, it may not be possible to accept post-order order data, so it was necessary to pay close attention to the operation. For this reason, depending on the operation, it may be difficult to correct an entry error in the ordering data or to change the quantity during the ordering time.

As a countermeasure, there is also known a system in which a database in which order data entries are registered is operated separately for temporary registration and main registration.
JP 2004-164146 A

  However, in the system that operates the database separately for temporary registration and main registration as described above, for example, when a plurality of ordering terminals are used at the same time in the same store, they should be referred to by a plurality of terminals. Since the reference destinations of the provisional registration data (provisional confirmation data) and the main registration data (confirmation data) are different, there is a possibility that data inconsistency of the ordering data will occur between databases when ordering is performed on multiple terminals. There is a need to prevent it. In addition, when ordering data is input, provisional confirmation data and confirmation data are mixed, so it is difficult to determine the confirmation data on the display screen, and the operability is not always good.

  On the other hand, as a prior art document related to this, a merchandise ordering / managing management method and apparatus for preventing re-execution of a user's order processing due to a change in merchandise information after an order has been proposed (see Patent Document 1). Such a method and apparatus are not necessarily intended to prevent such inconsistencies during product registration.

  The present invention has been made in view of such conventional circumstances, and prevents data inconsistency between databases occurring at the time of product registration while taking advantage of the ordering system for temporary registration of ordering data and finalization of final registration. The purpose is to do.

  In order to achieve the above object, an ordering system according to the present invention displays a predetermined ordering screen, and an ordering terminal for entering ordering data including the number of orders for each product to be ordered on the displayed ordering screen; An ordering system having a database for registering ordering data entered by the ordering terminal, wherein when the ordering data is entered by the ordering terminal, the ordering data can be determined as temporary ordering data on the database And provisionally registering the provisional ordering data so that the provisional ordering data can be discriminated as ordering confirmation data when a predetermined operation for finalizing the provisional ordering data is performed. .

  In the present invention, when the order quantity of the order data is entered by the order terminal, the processing means provisionally registers the entered order data in the database so as to be discriminable as provisional order data. When a predetermined operation for confirming the order quantity of the provisional order data is performed, the provisional order data may be permanently registered as distinguishable order data.

  The order data includes a flag that can identify an unconfirmed state of the order data and a confirmed state thereof, and the processing means sets the flag of the order data in the unconfirmed state at the time of provisional registration of the order data. On the other hand, there may be provided means for setting a flag of the order data to a value corresponding to the unconfirmed state at the time of the main registration of the order data.

  In the present invention, based on a value of a flag of the order data on the database, determination means for determining whether the order data is provisional order data or order confirmation data, and based on a determination result by the determination means, the order There may be further provided means for displaying the provisional order data and the order confirmation data in a color-coded manner so as to be visually distinguishable on the order screen of the terminal.

  Further, the predetermined operation may be an operation by a predetermined operation button preset on the ordering screen of the ordering terminal. The order terminal may be communicably connected to the database and the processing means via a communication line. The processing means may be integrally mounted in the ordering terminal.

  The processing method of the ordering system according to the present invention includes an ordering terminal that displays a predetermined ordering screen and enters ordering data including the number of orders for each product to be ordered on the displayed ordering screen, and the ordering terminal A processing method of an ordering system having a database for registering entered ordering data, wherein when the ordering data is entered by the ordering terminal, the ordering data can be discriminated as provisional ordering data on the database. A provisional registration step for provisional registration, and a main registration step for registering the provisional order data as order confirmation data when a predetermined operation for confirming provisionally registered provisional order data is performed. It is characterized by that.

  In the present invention, when the order quantity of the order data is entered by the ordering terminal, the provisional registration step provisionally registers the entered order data in the database so as to be discriminable as provisional order data, In the main registration step, when a predetermined operation for determining the order quantity of the provisional order data that has been provisionally registered is performed, the provisional order data may be main-registered so as to be distinguishable as order confirmation data.

  The order data includes a flag that can specify an unconfirmed state of the order data and a confirmed state thereof, and the temporary registration step sets the flag of the order data to a value corresponding to the unconfirmed state. The main registration step may include a step of setting a flag of the order data to a value corresponding to the unconfirmed state.

  In the present invention, a step of determining whether the order data is provisional order data or order confirmation data based on a value of a flag of the order data on the database, and an order of the order terminal based on the determined result The method may further include displaying the provisional order data and the order confirmation data in a color-coded manner so as to be visually distinguishable on the screen.

  The processing program of the ordering system according to the present invention displays a predetermined ordering screen, and enters an ordering terminal for entering ordering data including the number of orders for each product to be ordered on the displayed ordering screen, and the ordering terminal A processing program of an ordering system having a database for registering entered ordering data, and when the ordering data is entered into a computer by the ordering terminal, the ordering data is stored as provisional ordering data on the database. Temporary registration step for provisionally registering in a distinguishable manner and a main registration step for performing regular registration so that the provisional ordering data can be discriminated as ordering confirmation data when a predetermined operation for confirming provisionally registered provisional ordering data is performed. Are executed.

  In the present invention, when the order quantity of the order data is entered by the ordering terminal, the provisional registration step provisionally registers the entered order data in the database so as to be discriminable as provisional order data, In the main registration step, when a predetermined operation for determining the order quantity of the provisional order data that has been provisionally registered is performed, the provisional order data may be main-registered so as to be distinguishable as order confirmation data.

  The order data includes a flag that can specify an unconfirmed state of the order data and a confirmed state thereof, and the temporary registration step sets the flag of the order data to a value corresponding to the unconfirmed state. The main registration step may include a step of setting a flag of the order data to a value corresponding to the unconfirmed state.

  In the present invention, the computer determines, based on a value of the order data flag on the database, whether the order data is provisional order data or order confirmation data, and based on the determined result, The provisional order data and the order confirmation data may be further displayed in a color-coded manner so as to be visually distinguishable on the ordering screen of the ordering terminal.

  According to the present invention, it is possible to prevent data inconsistency between databases that occurs at the time of product registration, while taking advantage of an ordering system that performs provisional registration of order data and final registration confirmation.

  The best mode for carrying out an ordering system, its processing method, and program according to the present invention will be described below in detail with reference to the drawings.

  The ordering system of the present embodiment has a method for preventing inconsistency of ordering data with respect to the internal logic of the ordering product data entry in the product ordering dedicated terminal in the store system, and manages provisional ordering data and confirmed data entry. By managing a single database, it is possible to prevent inconsistencies in order data from a plurality of terminals. Further, when ordering data is entered, the screen display of the input from the ordering dedicated terminal or a similar terminal is color-coded to prevent operator inconsistencies such as mixing of provisional ordering data and confirmed data.

  The ordering system according to the present embodiment is applied to a store system for an industry such as a retail business, a wholesale business, or a restaurant that requires an ordering process for securing stock products or materials as stock, such as warehouse inventory management. This ordering system uses an ordering data management terminal (product ordering dedicated terminal) or a similar terminal and software to perform an ordering action for replenishing goods or inventory, and a plurality of input terminals or input methods can be used. Means are provided for preventing inconsistency in ordering data even when a person performs work.

  FIG. 1 illustrates the overall configuration of the ordering system of this embodiment. The function of the ordering system shown in FIG. 1 includes a screen display (display unit) 10, a data input device (input unit) 20, an arithmetic device (control unit) 30, and a database (DB) 40.

  The screen display device 10 is composed of a display device such as a liquid crystal display, for example, and displays a display screen such as an ordering screen (see later) based on display data provided from the arithmetic device 30.

  The data input device 20 is composed of an input device such as a keyboard and a mouse, for example, and various data such as specific product registration instruction data for an operator to specify a specific product to be registered in the DB 40 on the display screen of the screen display 10. Input (including ordering data), instructions, and selections, and operations (click operations, etc.) of predetermined operation buttons and operation keys set in advance on the display screen, and various operation signals corresponding thereto It is possible to generate. Here, the input, instruction, selected data, and the generated operation signal are sent to the arithmetic unit 30 as necessary.

  The database 40 includes a product master database (hereinafter referred to as “product master DB”) 41 for storing order product data (product code, product name, price (unit price), etc.) and order data (order product name, And an ordering data entry database (hereinafter referred to as “ordering data DB”) for setting entries of product codes, order quantity, and the like.

  The arithmetic device 30 includes, for example, a display data arithmetic processor 31 composed of a processor including a CPU that operates under program control, a control program executed by the CPU of the display data arithmetic processor 31, and control data used when the program is executed. And a memory system 32 composed of a ROM, a RAM, or the like.

  The product ordering dedicated terminal used in the ordering system shown in FIG. 1, or a terminal having a mechanism for performing data entry of product information similar thereto, or a terminal including a processor that executes software having the function (hereinafter collectively referred to as these) (Referred to as “ordering terminal”), the terminal itself has the screen display 10 and the data input device 20 as well as the ordering terminal 1a of the type having the arithmetic unit 30, and the terminal itself has the screen display 10 and the data input device 20. An ordering terminal 1b of the type that uses the arithmetic unit 30 that is owned and connected to the network via a specific communication line is included. In any type, the same operation can be realized regarding the product ordering action.

  In the example of FIG. 2, two ordering terminals 1 and 2 are shown as an example of the ordering terminal 1 a having the screen display device 10, the data input device 20, and the arithmetic device 30 described above. In this case, the two ordering terminals 1 and 2 exchange data with the database 40, respectively.

  In the example of FIG. 3, two ordering terminals 1 and 2 are shown as an example of the ordering terminal 1b having the screen display 10 and the data input unit 20 described above. In this case, the two ordering terminals 1 and 2 exchange data with the arithmetic unit 30 and its database 40 via the communication line 50. The ordering terminal 1b in this case includes a communication interface (not shown) for network connection in addition to the screen display 10 and the data input device 20. In this case, for example, a computer such as a server connected to a network is applied to the arithmetic unit 30 and includes a communication interface (not shown) for network connection. The communication line 50 can be either a public line or a dedicated line, and the communication medium may be either a wireless line or a wired line.

  Next, the overall operation of this embodiment will be described with reference to FIGS.

  FIG. 4 shows an operation procedure of the ordering system. The operation procedure shown in FIG. 4 is previously mapped as a control program on the memory system 32 in the arithmetic unit 30 and executed by the CPU of the display data arithmetic processor (control unit) 31.

  First, the product information (product name, price, etc.) in the product master DB 41 is obtained by operating the data input device 20 on the ordering screen of the screen display 10 by the ordering terminals 1 and 2 shown in FIG. While referring to, order data such as the product name of the orderable product and the number of orders is entered (step St2).

  FIG. 5 shows a display example of the ordering screen. In the example of FIG. 5, the ordering screen 10 a displayed by the screen display device 10 includes, for each product to be ordered, an ordered product input / display field 10 b and an order quantity input / display field (an operation button corresponding to order confirmation is provided. 10c and the like are displayed in a list, and operation buttons such as an order transmission button 10d are set to be operable by a click operation or the like at a predetermined position. FIG. 5 is merely an example, and the ordering screen 10a can be applied to any order including a known configuration as long as it can enter at least the ordered product and the number of orders.

  Next, when the order quantity of the order data is entered by the order terminals 1 and 2, the arithmetic unit 30 provisionally registers the entered data in the order data DB 42 (step St3). In this state, the data on the ordering data DB 42 is classified as provisional ordering data, not fixed data.

  FIG. 6 shows a configuration example of data on the order data DB 42. In the example of FIG. 6, the data registered in the order data DB 42 is a record for each ordered product, in addition to the normally used ordering data a1 such as the product name and the number of orders corresponding thereto, and in this embodiment, a confirmation flag. a2 is added. The confirmation flag a2 is set to be OFF (unconfirmed state) when the flag value is “0”, for example, and ON (confirmed state) when the flag value is “1”, by the processing of the arithmetic unit 30. In the temporary registration state described above, the confirmation flag a2 is kept at the flag value “0”, that is, OFF (unconfirmed).

  In the above state, product information such as the product name of the ordered product is displayed on the ordering screen (step St3). When the order quantity of the ordered product is entered, the order quantity is displayed on the ordering screen, and changes to a button color and a character color so that it can be seen that the entry has been made (order quantity input / display field 10c in FIG. 5). reference).

  Next, in order to confirm the entered data as order data, an order confirmation button on the ordering screen, an order button (in the example of FIG. 5, an operation button corresponding to order confirmation on the order quantity input / display field 10d), etc. When an explicit operation such as pressing the operation button is performed, the arithmetic unit 30 uses the operation signal generated and sent by the operation as a trigger to confirm the provisional order data as the order confirmation data. Processing is performed (step St4: YES). As a result, the provisional order data temporarily registered becomes the main registration, and accordingly, in the confirmation flag of the corresponding order data on the order data DB 42, the flag value is changed from “0” to “1”, that is, OFF (unconfirmed). The state changes from ON to ON (determined state) (step St5). As a result, the order data is confirmed and becomes the order confirmation data. At this time, on the ordering screen, the button color and the character color at the time of provisional registration are also changed to the button color and the character color set in advance for the main registration (the order quantity input / display field corresponding to today's transmission in FIG. 5). 10c).

  The example of FIG. 4 considers a case where an ordering action for the same product is performed using a plurality of ordering terminals in the same store. For this reason, after performing temporary registration to order confirmation registration for a desired ordering product on a certain ordering terminal, an operation to confirm the input of the order quantity for the same ordering product on another ordering terminal Is also assumed. In this case, the arithmetic unit 30 refers to the state of the confirmation flag a2 in the order data DB 41, recognizes that the corresponding data is order confirmation data, and sends a message warning the overwriting of the data to other order terminals. The data is output to alert the operator and the data is overwritten.

  Therefore, according to the present embodiment, by temporarily registering the order data and confirming the final registration, it is possible to correct an entry error of the order data or change the quantity during the ordering time regardless of the operation. By making the ordering data entered and provisionally registered the same database as the ordering data finalized and registered, data inconsistency between the databases can be prevented. In addition, for the products for which order data is entered, the order quantity has already been entered by separating the change in the button color for provisional order and the color change in the order quantity from the color change that can be clearly determined as confirmed order data. Can be specified, and the operability can be improved.

  In the above-described embodiment, the ordering action when orderable product data already exists in the database has been described. However, even if the orderable product data does not exist in the database, the ordering data By adding an order code (data that can be uniquely identified when placing an order, such as a PLU (Price Look Up) code or an EOS (Electronic Ordering System) code) to the DB, an ordering action can be performed. In that case, detailed information such as the product name of the ordered product cannot be displayed, but an ordering action by inputting an order code is possible. Even when ordering data is input by inputting an ordering code, data can be overwritten when data is input from a plurality of ordering terminals.

  Further, in the above-described embodiment, in order to control the transition from the provisional ordering data of provisional registration to the order confirmation data of main registration, a confirmation flag is added to the ordering data in the ordering data DB for each ordering product, and the flag is used. However, the present invention is not necessarily limited to this, and instead of such flag control, for example, the transition from temporary registration of order data to its main registration is performed using the data update date as a key. You may make it control.

It is a schematic block diagram which shows the whole structure of the ordering system by the Example of this invention. In the Example of this invention, it is the schematic explaining the example of a structure of the ordering system using the ordering terminal in the case of including an arithmetic unit in an own terminal. In the Example of this invention, it is the schematic explaining the example of a structure of the ordering system using the ordering terminal in case an arithmetic unit is not included in an own terminal. It is a schematic flowchart which shows operation | movement of the ordering system by the Example of this invention. It is a figure which shows the example of a display of the ordering screen on an ordering terminal. It is a figure which shows the structural example of the data on order data DB.

Explanation of symbols

1a, 1b Ordering terminal 10 Screen display 10a Ordering screen 20 Data input device 30 Arithmetic unit (processing means)
31 Display data processor 32 Memory system 40 Database (DB)
41 Product Master DB
42 Ordering data DB
50 Communication line

Claims (15)

An ordering terminal for displaying a predetermined ordering screen and entering ordering data including the number of orders for each product to be ordered on the displayed ordering screen;
An ordering system having a database for registering ordering data entered by the ordering terminal;
When the ordering data is entered by the ordering terminal, the ordering data is provisionally registered on the database so as to be discriminable as provisional ordering data, and a predetermined operation for confirming the provisionally registered provisional ordering data is performed. An ordering system comprising: processing means for registering the provisional ordering data as discriminating ordering data so that the provisional ordering data can be discriminated when received.   When the order quantity of the order data is entered by the order terminal, the processing means provisionally registers the entered order data in the database so as to be discriminable as provisional order data, and the provisionally registered provisional data 2. The ordering system according to claim 1, wherein when a predetermined operation for confirming the order quantity of the ordering data is performed, the temporary ordering data is permanently registered as ordering confirmation data so as to be discriminated. The order data has a flag that can identify the unconfirmed state and the confirmed state of the order data,
The processing means sets the ordering data flag to a value corresponding to the unconfirmed state at the time of provisional registration of the ordering data, and sets the ordering data flag to the unconfirmed state at the time of main registration of the ordering data. 3. The ordering system according to claim 1, further comprising means for setting a value corresponding to. Determining means for determining whether the order data is provisional order data or order confirmation data based on the value of the order data flag on the database;
The apparatus further comprises means for displaying the provisional order data and the order confirmation data in a color-coded manner so as to be visually discriminable on the ordering screen of the ordering terminal based on a discrimination result by the discrimination means. The ordering system according to any one of 1 to 3.   The ordering system according to any one of claims 1 to 4, wherein the predetermined operation is an operation by a predetermined operation button preset on an ordering screen of the ordering terminal.   6. The ordering system according to claim 1, wherein the ordering terminal is communicably connected to the database and the processing means via a communication line.   6. The ordering system according to claim 1, wherein the processing unit is integrally mounted in the ordering terminal. An ordering terminal for displaying a predetermined ordering screen and entering ordering data including the number of orders for each product to be ordered on the displayed ordering screen, and a database for registering ordering data entered by the ordering terminal A processing method for an ordering system having:
A provisional registration step of temporarily registering the order data as provisional order data on the database when the order data is entered by the order terminal;
And a main registration step of registering the provisional order data so that the provisional order data can be discriminated as order confirmation data when a predetermined operation for confirming provisionally registered provisional order data is performed. Processing method. In the temporary registration step, when the order quantity of the order data is entered by the order terminal, the entered order data is provisionally registered on the database so as to be discriminable as provisional order data,
In the main registration step, when a predetermined operation for determining the order quantity of the provisional order data that has been provisionally registered is performed, the provisional order data is main-registered so as to be discriminated as order confirmation data. The ordering system processing method according to claim 8. The order data has a flag that can identify the unconfirmed state and the confirmed state of the order data,
The provisional registration step includes a step of setting a flag of the order data to a value corresponding to the unconfirmed state,
10. The processing method of an ordering system according to claim 8, wherein the main registration step includes a step of setting a flag of the ordering data to a value corresponding to the unconfirmed state. Determining whether the order data is provisional order data or order confirmation data based on a value of the order data flag on the database;
9. The method according to claim 8, further comprising: displaying the provisional order data and the order confirmation data in a color-coded manner so as to be visually distinguishable on the ordering screen of the ordering terminal based on the determined result. 11. A processing method for an ordering system according to any one of 10 above. An ordering terminal for displaying a predetermined ordering screen and entering ordering data including the number of orders for each product to be ordered on the displayed ordering screen, and a database for registering ordering data entered by the ordering terminal An ordering system processing program comprising:
On the computer,
A provisional registration step of temporarily registering the order data as provisional order data on the database when the order data is entered by the order terminal;
An ordering system that, when a predetermined operation for confirming provisionally registered provisional ordering data is performed, performs a main registration step of registering the provisional ordering data so that the provisional ordering data can be discriminated as order confirmation data. Processing program. In the temporary registration step, when the order quantity of the order data is entered by the order terminal, the entered order data is provisionally registered on the database so as to be discriminable as provisional order data;
The main registration step is characterized in that when a predetermined operation for determining the order quantity of the provisionally registered temporary order data is performed, the provisional order data is permanently registered as order confirmation data so as to be discriminated. 13. A processing program for an ordering system according to claim 12. The order data has a flag that can identify the unconfirmed state and the confirmed state of the order data,
The provisional registration step includes a step of setting a flag of the order data to a value corresponding to the unconfirmed state,
14. The processing program for an ordering system according to claim 12, wherein the main registration step includes a step of setting a flag of the ordering data to a value corresponding to the unconfirmed state. In the computer,
Determining whether the order data is provisional order data or order confirmation data based on the value of the order data flag on the database;
The step of displaying the provisional order data and the order confirmation data in a color-coded manner so as to be visually discriminable on the ordering screen of the ordering terminal based on the determined result is further executed. The processing program of the ordering system of any one of thru | or 14.

Images