JP5483636B2 - Product order management apparatus and program - Google Patents

Description

  Embodiments described herein relate generally to a product order management apparatus and a program.

  For example, the headquarters of a mass merchandising store that manages multiple chain stores generally has an ordering terminal installed at each store, and a product order management device mainly composed of a host computer at the headquarters for ordering at each store. 2. Description of the Related Art A product ordering system in which a terminal and a product order management device at a headquarters of a mass sales store are connected via a communication line has been constructed.

  This type of conventional product ordering system refers to the product information records (PLU code, product name, unit price, etc.) stored in the product master file at the ordering terminal, and the PLU code, the number of orders, When data such as an entry code, an order date, and a delivery date are input, product order data is created based on the input data and transmitted to the product order management apparatus via a communication line.

  In the product order management apparatus, product order data received from each ordering terminal via a communication line is stored and stored in an order data file. Then, when the ordering work is started, the data for which the ordering date is the same as the ordering work day is extracted from the product ordering data stored and stored in the ordering data file. Create an order slip that records the order contents of the product and place an order.

  In addition, in recent years, in the product order management apparatus, it is also possible to place an order for a future date in which orders for future dates are reserved in advance.

  By the way, when there is a change in the merchandise information record such as a change in selling price at a future date, the change contents are reflected in the merchandise master file after the merchandise master is updated on the scheduled change date.

  That is, for the product whose product information record (PLU code, product name, unit price, etc.) stored in the product master file does not correspond to the change contents in the future date, the previous date order for the future date as described above was made. In this case, since the order is placed without referring to the contents of the product change such as the selling price, it is difficult to accurately calculate the order quantity and there is a problem that the accuracy of the product order is lowered.

  The product order management apparatus of the embodiment includes order date receiving means, update schedule information extracting means, product information extracting means, and screen generating means. The order date receiving means receives an estimated order date input in an ordering apparatus that creates data related to product ordering. The update schedule information extraction unit extracts from the master update data storage unit an update schedule product information record that is associated with an update date that matches the planned order date and includes a product identification code. The product information extraction unit extracts, from the product master storage unit, a product information record including a product identification code that is not included in the update planned product information record extracted from the master update data storage unit. The screen generation means is to display on the ordering device, and displays the update planned product information record extracted from the master update data storage unit and the product information record extracted from the product master storage unit. Generate an order entry screen to be used for data entry when ordering products.

FIG. 1 is an overall configuration diagram showing an order management system in the embodiment. FIG. 2 is a front view showing an example of an order entry screen. FIG. 3 is a schematic diagram showing a main data structure of the product ordering data. FIG. 4 is a functional block diagram showing a functional configuration of the CPU of the server. FIG. 5 is a flowchart showing the flow of the product order input screen generation process. FIG. 6 is a schematic diagram schematically illustrating an example of a process related to an earlier date ordering.

  This embodiment will be described with reference to the drawings. In the present embodiment, the server 1 of the order management system using a communication line constructed in a mass sales store that manages and manages a plurality of chain stores at the headquarters is applied to a product order management apparatus.

  FIG. 1 is an overall configuration diagram showing an order management system in the present embodiment. As shown in FIG. 1, the order management system is constructed by connecting a plurality of ordering devices 2 to a server 1 via a network 3. The server 1 is installed at, for example, the headquarters of a mass sales store. Further, the ordering device 2 is normally provided in each chain store of a mass sales store. One unit per store may be provided, or a plurality of units may be provided.

  As shown in FIG. 1, the server 1 is equipped with a CPU (Central Processing Unit) 11 as a control unit body. The CPU 11 is connected to a ROM (Read Only Memory) 13, a RAM (Random Access Memory) 14, a clock unit 15, a communication controller 16, and an HDD (Hard Disk Drive) via a bus line 12 such as an address bus and a data bus. The controller 17, the input device controller 18, the display controller 19, the printer controller 20, and the like are connected.

  The ROM 13 stores fixed data such as programs in advance. The RAM 14 functions as a work table to be described later, and has a memory area for temporarily storing various data. In the clock unit 15, the current date and time are timed. The communication controller 16 controls data communication with each ordering device 2 connected via the network 3. The HDD controller 17 controls writing and reading of data with respect to the HDD device 22 which is a storage unit. The input device controller 18 controls an input device 23 such as a keyboard and a mouse, takes in data input via the input device 23, and supplies the data to the CPU 11. The display controller 19 controls the display unit 24 such as a display device and displays an image based on display data provided from the CPU 11. The printer controller 20 controls the driving of the printer 25 that can print on a slip sheet.

  The server 1 stores in the HDD device 22 a product master file that is a product master storage unit that stores a product information record such as a PLU (Price Look Up) code, a product name, and a unit price that is a product identification code of each product sold in the store. 50. Each store is provided with a POS (Point Of Sales) terminal (not shown) for settlement of a commercial transaction with the customer, and each customer purchases based on the product information record stored in the product master file 50. Process product sales data.

  The server 1 further includes a product master update file 60 serving as a master update data storage unit in the HDD device 22. The product master update file 60 adds, for each record, an update date on which the product information record is valid to the product information record after the sales price change of the product whose sales price etc. is changed or the product information record of a newly released product. This is a file for storing a product information record (update planned product information record) to be set in advance.

  Each time the current date managed by the system is updated, the server 1 extracts all records whose update date matches the current date from the product information records registered in the product master update file 60, and extracts the extracted records. The product master file 50 is searched with the PLU code of the product information record. When the server 1 detects the product information record of the corresponding PLU code, the server 1 overwrites the product information record extracted from the product master update file 60 with the product information record, and updates the product master when the product information record cannot be detected. The product information record extracted from the file 60 is added to the product master file 50, and the product information file is updated daily.

  Further, the server 1 automatically deletes product information records whose update date is a predetermined number of days or more ago from the product information records stored in the product master update file 60.

  The ordering device 2 includes an information processing device having a data communication function such as a personal computer, a tablet terminal, a handy terminal, or the like. Although details will be described later, the ordering device 2 is generated according to the planned order date and is based on the product information record stored in the product master file 50 or the product information record stored in the product master update file 60. An order entry screen P (see FIG. 2) including the PLU code, product name, unit price, etc. of the order target product is acquired from the server 1 via the network 3 and displayed on the browser. It has a function of accepting input of product ordering data such as PLU code, order quantity, supplier code, ordering date, delivery date and the like. Further, the product order data input from the order input screen P is transmitted to the server 1 via the network 3.

  Here, FIG. 2 is a front view showing an example of the order entry screen P. FIG. As shown in FIG. 2, the order entry screen P includes an order target product selection screen P1 and an order target product detail display screen P2. The order target product selection screen P1 corresponds to the planned order date X, and is an area for displaying a list of order target products for each category, for example, and also serves as an area for inputting the order quantity. Further, the order display target product detail display screen P2 is a product information record (PLU code, product name, unit price, product) of one order target product selected from the products listed on the order target product selection screen P1. This is the area where images etc. are displayed.

  Further, the server 1 includes an order data file 30 in the HDD device 22. The order data file 30 stores and stores product order data sent from each ordering device 2. FIG. 3 is a schematic diagram showing a main data structure of product ordering data stored in the ordering data file 30. As shown in FIG. 3, the product ordering data includes a store code 31 for identifying an ordering source store, an order date 32, a PLU code 33 for a product to be ordered, a delivery date 34, a supplier code 35 for specifying a supplier, It consists of various data items such as a classification code 36 for classifying an order target product and an order quantity 37. The server 1 creates an order slip that records the order contents of the order target product for each supplier based on the product order data whose order date 32 matches the current date managed by the system, and places an order. .

  The server 1 has a program for realizing a function as a product order management device installed in the HDD device 22. When this program is started, the CPU 11 of the server 1, as shown in FIG. 4, updates means 111, deletion means 112, order date reception means 113, update schedule information extraction means 114, and product information extraction means 115. , Functions as the screen generation means 116, and controls each part according to the procedure shown in the flowchart described later.

  As described above, the update unit 111 extracts and extracts a record whose update date matches the current date from the update planned product information records stored in the product master update file 60 every time the current date is updated. The record is updated or added to the product master file 50 as a product information record.

  As described above, the deletion unit 112 deletes the record whose update date is a predetermined number of days or more before the update scheduled product information record stored in the product master update file 60.

  The order date receiving means 113 receives the scheduled order date input in the ordering device 2 that creates data related to product ordering.

  The update schedule information extraction unit 114 extracts, from the product master update file 60, an update schedule product information record that is associated with the update date that matches the planned order date and that includes the PLU code.

  The product information extraction unit 115 extracts a product information record including a PLU code that is not included in the update planned product information record extracted from the product master update file 60 from the product master file 50.

  The screen generation means 116 is displayed on the ordering device 2, and displays the planned product information record extracted from the product master update file 60 and the product information record extracted from the product master file 50 to place a product order. An order entry screen P used for data input is generated.

  Of the functions as the product order management apparatus exhibited by the server 1, the order entry screen P used for data input at the time of product ordering is based on any product information record in the product master file 50 or the product master update file 60. FIG. 5 is a flowchart showing a processing procedure for generating a product order input screen for determining whether to generate a product.

  When the CPU 11 of the server 1 is instructed to execute the product order input screen generation process by an access operation from the ordering device 2 via the network 3, the CPU 11 starts this processing procedure according to the program stored in the HDD device 22. To do.

  First, when the CPU 11 (order date receiving means 113) receives the planned order date input in the ordering device 2 via the network 3 (Yes in step S1), the CPU 11 (update schedule information extracting means 114) A product information record including an update date that matches the date is extracted from the product master update file 60 (step S2).

  In addition, the CPU 11 (product information extraction unit 115) receives a product information record including a PLU code other than the PLU code included in the product information record extracted in step S2 (a product information record including an update date that matches the planned order date). Extracted from the product master file 50 (step S3).

  Subsequently, the CPU 11 (screen generation means 116) extracts the product information record extracted from the product master file 50 and the product master update file 60 in accordance with a predetermined format and the category of the product to be displayed. Acquire various product information (PLU code, product name, unit price, etc.) of the order target product from the product information record (step S4), and input an order based on the acquired various product information (PLU code, product name, unit price, etc.) A screen P is generated (step S5).

  Then, the server 1 displays the generated order entry screen P on the ordering device 2 accessed via the network 3 (step S6).

  Here, FIG. 6 is a schematic diagram schematically showing an example of the processing related to the earlier date ordering in the server 1. The example shown in FIG. 6 is an example in which a product information record (referred to as new data) whose update date is “29th” is registered in the product master update file 60, and “00:00 on 29th”. The new data is overwritten or added to the product information record (referred to as old data) in the product master file 50.

  An example of generating the order entry screen P when the system date is “27th” under such conditions will be described. As shown in FIG. 6, the server 1 of the present embodiment generates an order entry screen P with reference to the old data for the 27-day order (current-day order) and the 28-day order (pre-date order). On the other hand, as shown in FIG. 6, the server 1 of the present embodiment displays the order entry screen P with reference to new data for the 29th order (previous date order) and the 30th order (previous date order). Generate.

  As described above, according to the server 1 which is the product order management apparatus of the present embodiment, the PLU is associated with the update date corresponding to the scheduled order date input in the ordering apparatus 2 that creates data related to product ordering. The product information record including the PLU code not included in the product information update record extracted from the product master update file 60 and the product information record including the PLU code extracted from the product master update file 60 is extracted from the product master update file 60. The order entry screen P used for data input at the time of product ordering is generated by displaying the update planned product information record extracted from the product master update file 60 and the product information record extracted from the product master file 50. . As a result, when placing a future date order for the future date after the update date of the product information, various product information displayed on the order entry screen P displayed on the ordering device 2 is changed to the product information (for example, Sales price, etc.), the order quantity can be calculated accurately, and the accuracy of product ordering can be improved.

  In the present embodiment, the HDD device 22 of the server 1 which is the product order management device is provided with the product master file 50 and the product master update file 60. However, the present invention is not limited to this. The apparatus may include a product master file 50 and a product master update file 60.

  The program executed in the server 1 of the present embodiment is a file in an installable format or an executable format, and is a computer such as a CD-ROM, flexible disk (FD), CD-R, DVD (Digital Versatile Disk). Recorded on a readable recording medium.

  Further, the program executed by the server 1 of the present embodiment may be stored on a computer connected to a network such as the Internet and provided by being downloaded via the network. Further, the program executed by the server 1 of the present embodiment may be provided or distributed via a network such as the Internet. Further, the program of this embodiment may be configured to be provided by being incorporated in advance in a ROM or the like.

  Although several embodiments of the present invention have been described, these embodiments are presented by way of example and are not intended to limit the scope of the invention. These novel embodiments can be implemented in various other forms, and various omissions, replacements, and changes can be made without departing from the scope of the invention. These embodiments and modifications thereof are included in the scope and gist of the invention, and are included in the invention described in the claims and the equivalents thereof.

DESCRIPTION OF SYMBOLS 1 Commodity order management apparatus 2 Ordering apparatus 60 Master update data memory | storage part 50 Commodity master memory | storage part 111 Update means 112 Deletion means 113 Order date receiving means 114 Update plan information extraction means 115 Merchandise information extraction means 116 Screen generation means P Order input screen

JP 2002-74102 A

Claims (6)

An order date receiving means for receiving an estimated order date input in an ordering device for creating data relating to product ordering;
Update schedule information extraction means for extracting from the master update data storage unit an update schedule product information record that is associated with an update date that matches the planned order date and that includes a product identification code;
Product information extraction means for extracting a product information record including a product identification code not included in the update planned product information record extracted from the master update data storage unit from a product master storage unit;
Data to be displayed on the ordering device, wherein the update planned product information record extracted from the master update data storage unit and the product information record extracted from the product master storage unit are displayed, and data when placing a product order Screen generation means for generating an order entry screen to be used for input;
A product order management apparatus comprising: The product master storage unit for storing the product information record;
The master update data storage unit that stores the update planned product information record for updating or adding to the product master storage unit as the product information record on a date that matches the update date;
The product order management apparatus according to claim 1, further comprising: Every time the current date is updated, a record whose update date matches the current date is extracted from the planned update product information records stored in the master update data storage unit, and the extracted record is the product information Update means for updating or adding to the product master storage unit as a record;
3. The merchandise order management apparatus according to claim 1, wherein A deletion means for deleting a record whose update date is a predetermined number of days or more ago from the update-scheduled product information record stored in the master update data storage unit;
The merchandise order management apparatus according to any one of claims 1 to 3. Computer
An order date receiving means for receiving an estimated order date input in an ordering device for creating data relating to product ordering;
Update schedule information extraction means for extracting from the master update data storage unit an update schedule product information record that is associated with an update date that matches the planned order date and that includes a product identification code;
Product information extraction means for extracting a product information record including a product identification code not included in the update planned product information record extracted from the master update data storage unit from a product master storage unit;
Data to be displayed on the ordering device, wherein the update planned product information record extracted from the master update data storage unit and the product information record extracted from the product master storage unit are displayed, and data when placing a product order Screen generation means for generating an order entry screen to be used for input;
A program characterized by functioning as Every time the current date is updated, a record whose update date matches the current date is extracted from the planned update product information records stored in the master update data storage unit, and the extracted record is the product information Causing the computer to function as update means for updating or adding to the product master storage unit as a record;
6. The program according to claim 5, wherein:

Images