JP2648093B2 - POS system - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION The present invention relates to a method of inputting sales information each time a product is sold to a customer,
For POS systems that collect data on sales locations (branches, sales floors, etc.) and perform product management, accounting and management information analysis operations such as product purchase and inventory, and more specifically, portable scanners, Using the product identification means by inputting display screens, sales staff and other personnel can easily identify any product at the sales site, etc., and analyze, order, and purchase products such as top selling products and dying products. And a POS system configured to perform product management operations such as inventory management.

[0002]

2. Description of the Related Art In recent years, with the development of information processing systems in management and the like, computerization has also progressed in department stores, supermarkets, retail businesses, and distribution businesses. Each time a product is sold to a customer, sales information is input. In addition to issuing receipts, collect data on the quantity of products sold, the date and time of sale, and the location of sales (branches, sales floors, etc.), and perform product management and accounting operations, such as product purchase and inventory, and management information analysis. POS systems that perform such tasks as above are widely used.

As shown in the block diagram of FIG. 9, a conventional POS system comprises a head office (head office) system 1 and a branch (store) system 5 connected by a communication line 8 by a store configuration. , A plurality of POS terminals 4a to 4
c is connected to the host CPU 2 which is a central computer via the terminal control device 3, and the branch system 5
A plurality of POS terminals 7a, 7 are connected to a terminal control device 6 connected to the host CPU 2 of the head office system 1 via the communication line 8.
b is connected.

[0004] The main functions of such a POS system are the POS terminals 4a to 4c, 7 installed in each counter.
a, 7b, using a scanner or the like to read each product purchased by a customer, collecting the amount of money for each product, receiving sales proceeds, paying change, and issuing receipts, cash register business processing, central host The CPU 2 collects sales information such as products sold at each of the POS terminals 4a to 4c, 7a and 7b, sales quantity of each product, sales date and time, sales location (branch, sales floor, etc.), and is designed in advance by the host CPU. Aggregation based on the analysis units, etc. collected and accumulated in the database as sales data, and product management and accounting, such as product purchasing and inventory management using this sales data, and business information analysis, etc. Processing.

[0005] By the way, in the product management business, purchasing,
The data that forms the basis of the inventory management business is analysis data on hot-selling products and dying-goods. The reason for this is that, by grasping the best selling products and dying products and purchasing the products, the opportunity loss is reduced, and by compressing the defective inventory, the store area is effectively utilized and the efficiency is improved. This is because sales can be performed and the business situation of the store can be improved.

[0006] In the conventional POS system, grasping of a hot selling product and a dead hot product is performed as follows. That is, the host CPU 2 has master data such as a product master (barcode master), a price master, a purchase master, a sales master, and an accounting master.
A price master exists in the terminal controllers 3 and 6 that control the POS terminals 4a to 4c, 7a and 7b.

[0007] The price master is composed of a product code, a bar code, a product name, a sales unit price, discount data, and the like. Terminals 4a to 4c, 7a,
7b, it is loaded before starting. The price master is connected between the host CPU 2 and the terminal control devices 3 and 6 so that the price master can be matched.
Are introduced into the terminal control devices 3 and 6 under the management of. In the discount data, necessary discount prices, service conditions, and the like are recorded according to discount formats such as bargain sale, time service, bundle sale, and the like. It is also possible to add them uniformly.

[0008] Each POS terminal 4a-4c, 7a, 7b
Based on this price master, each product purchased by the customer is read by a stationary scanner or the like, the amount for each product is totaled, sales proceeds are received, change is displayed, this is displayed on a display, and receipts are displayed. Issue Further, the POS terminals 4a to 4c, 7a, and 7b add information such as a sales time, a terminal number, a sales clerk, and the like to the data of the above-mentioned sales product, sales quantity, sales amount, and the like, and perform terminal control as sales data. The POS terminals 4a to 4c, 7a, 7
The sales data of “b” is totaled and transmitted to the host CPU 2.
In the host CPU 2, sales department, supplier, daily total,
Aggregate sales data sent from each terminal control device 3, 6 based on pre-designed analysis units such as weekly total and monthly total,
The sales data of all stores is stored in a database in the storage device.

[0009] With the above configuration, it is assumed that the merchandise stored in the sales data coincides with all the merchandise stored in the merchandise master. Is done. Therefore, in order to grasp the top selling products and the last selling products, the host CPU 2 sorts the sales data of the sales master in descending order of sales, and outputs the top selling products and the bottom selling products to a printer or the like to a desired order. You will get it by running the program.

[0010]

However, according to the above-mentioned conventional POS system, the method of grasping the hot selling products and the dead hot products allows a person in charge such as a sales person to easily and accurately obtain the hot selling products at the sales site. There was an inconvenience that it was impossible to grasp the muscle product in the dead. That is, since the sales data of the sales master is sorted in descending order of the sales, and the products with the highest sales and the products with the lower sales are output to a desired order, all the products registered in the product master are targeted. At the sales site, a sales person can easily specify a desired product or a product to be analyzed by a simple operation to specify a product to be analyzed, and perform fine-grained product management work and analysis. The problem is that you cannot do that.

The cause of such inconvenience is that the conventional POS system has the following configuration. First, the maintenance of registered products in the product master, which is the basis of sales data, is practically impossible. Products handled by retailers include products that have already been discontinued by producers, seasonal products that have customer demand only in specific seasons, regional products that are only required in specific regions due to regional characteristics, etc. There are products having various characteristics, such as lunches and breads, which can be sold in a concentrated manner over a certain period of time, and products which are out of stock due to delays in purchasing or receiving goods and are not placed in a sales floor.

[0012] Unless the product master is maintained in real time, such as by deleting it from the product master, these products are subject to analysis of hot-selling products and dead-goods. The sales volume of these products is, of course, zero, and when such products increase,
The result of the analysis of the dying product becomes meaningless, and the effective purchasing cannot be performed.

However, in reality, it is extremely difficult to maintain the registered products of the product master in real time. Generally, small-scale stores such as convenience stores with a floor area of about 100 square meters handle about 3,000 items, and medium-sized supermarkets with a floor area of about 1500 square meters handle three items.
About 5,000 items, even if the products are the same and the same type, if you divide the products by manufacturer or wholesaler, you will handle several times the number of products, and chain stores and large supermarkets will have more than several million products Will be registered in the product master.

In order to update the data on discontinued products, seasonal products, regional products, etc. from the product master as described above, it is necessary to collect and input such data. The renewal work is required to be completed at the start of business the next day. Therefore, it is practically extremely difficult to grasp the status of products that change every day in real time and keep the product master up to date, and it is impossible at all if the number of products handled such as chain stores and large supermarkets is large. State.

The second cause is that the conventional POS system is
It is a configuration based on the concept of centralized management and centralized processing using large computers and office computers as host CPUs, led by computer and system manufacturers, so all processing must be performed via the central host CPU. The point is that the degree of freedom to easily carry out product management work or the like on site is not allowed.

In the system constructed based on the concept of such centralized management and centralized processing, the above-mentioned merchandise management operations such as analysis of the hot selling products and the dying muscle products are also performed by the sales master collected by the host CPU of the center. Processing is performed based on an analysis processing program that is designed and created in advance by the person in charge of the system department for a product group fixedly set in units such as product field unit, supplier unit, sales department unit, etc. Therefore, at the point of sale, there is no means for easily selecting a desired product and analyzing the sales situation.

The third cause lies in the method of totalizing sales data and storing data in a database in a conventional POS system. That is, the sales data in the conventional POS system is a data structure designed in advance by a person in charge of the system section for a product group fixedly set in units such as a product field unit, a supplier unit, and a sales department unit. The sales data transmitted from each POS terminal is totaled and stored in a database in accordance with the totaling unit such as weekly total, monthly total, and the like. Therefore, even if an arbitrary product is specified, sales data relating to the product is acquired, and a business such as product analysis and product management is performed, there is no raw sales data for each product and each sales in the database. This is because the configuration is impossible.

The present invention solves the above-mentioned inconvenience, and inputs sales information each time a product is sold to a customer.
Collects data such as the quantity of products sold, the date and time of sale, and the location of sales (branches, sales floors, etc.), and performs product management, accounting, and management information analysis such as product purchasing and inventory.
In the OS system, a sales person or the like easily specifies an arbitrary product at a sales site or the like by using a portable scanner, a product specifying means by inputting a display screen, etc. It is an object of the present invention to provide a POS system configured to perform product management operations such as product analysis such as grasping, ordering, purchasing, and inventory management.

[0019]

In order to achieve the above object, according to the present invention, every time a product is sold to a customer, sales data including a product code and a sales quantity are input, and the sales data is stored in a database. In the collecting POS system,
POS terminal for inputting sales data including the product code and quantity of the product purchased by the customer ;
A storage device constituting a database for storing master data and sales data for each sales item based on sales data input from the POS terminal device, and a portable scanner for specifying a product code for an arbitrary product to be processed A server computer and a client computer connected to the POS terminal device and the storage device; input means for inputting data or desired instructions to the server computer and the client computer; and processing by the server computer and the client computer It consists of a output means for outputting the result, a product code specified by the portable scanner, and introduced into the client computer, not based on the master data about the product, only the product code Get the response was sales data from the storage peripherals, based on an instruction from the entering force means acquires
The sales data is processed and output to the output means.

Further, according to the present invention, every time a product is sold to a customer, sales data including a product code and a sales quantity is input,
In a product analysis method in a POS system that collects the sales data in a computer, a first step of specifying an arbitrary product code to be processed by a portable scanner, based on the specified product code,
A second step of obtaining, from the sales data, the sales data of the product corresponding to only the product code without being based on the master data relating to the product; and collecting the sales of each product based on the sales data to obtain a large amount of sales. A third step of sorting the sales data in ascending order or in ascending order;
Sales of descending order, or in ascending order, until the desired rank, and a fourth step of outputting to the output device, characterized in that it consists of.

Further, according to the present invention, each time a product is sold to a customer, a POS for inputting sales data including a product code and a sales quantity and collecting the sales data in a computer.
Keep inventory method in the system, the portable scanner, and the first step of reading by scanning the arbitrary commodity code to be processed, based on the product code the the read, from the storage device, the product About
Refer to the master data to
A second step of obtaining a corresponding product code and a product name corresponding to the product code; and the obtained product code.
And product name , at least the product code, product name,
Create a shelf allocation table ing from the product quantity entry field, the third to be output
And the fourth step of entering the quantity of goods in the shelf layout table
A fifth step of scanning and inputting a product code from the shelf allocation table in which the product quantity is entered by the POS terminal, and inputting the product quantity, and a fifth step of outputting the inventory data to a desired output means. 6 steps,
It is characterized by consisting of.

[0022]

In the POS system according to the present invention, the bar code scanner reads the merchandise code of the merchandise purchased by the customer and inputs the sales data including the sales quantity by the POS terminal device. This sales data is stored in a database constructed in the storage device as sales data for each sales unit.

On the other hand, the portable scanner specifies the product code (bar code) of any product to be selected as a target of a product management business or a business analysis business, such as analysis of a hot selling product or a dead product.

The information on the product code of each product specified by the portable scanner is introduced into a client computer, and an operator inputs a processing instruction through an input unit, and the client computer is introduced from the portable scanner. Master about the product according to the product code
Without data, that is,
Without reference to coater data to get the sales data of the commodity corresponding only to the product code from the storage peripherals, based on an instruction of the inputted process, obtaining process the sales de <br/> over data was Then, output to the output means. Examples of processing include, for example, totaling of sales data for each product, totaling of sales data for each department and each product, totaling of sales data for each supplier and each product, and sorting the totaled sales data in descending order of sales. Or an example in which the sales data is output to the output unit after sorting in ascending order, and an example in which a shelf allocation table is output.

[0025]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS A POS system according to the present invention will be described in detail below with reference to the accompanying drawings.

FIG. 1 is a block diagram showing a configuration of a POS system 10 according to the present invention.
Head office (head office) system 12 and branch (store) system 14
Each system comprises a modem device 16a, 16b
Thus, the connection is made via a communication line, for example, an ISDN line 18. Head office system 12
Are the server CPU 20 and the client CPU 22
a, 22b, 22c and POS terminals 24a to 24d are connected by a LAN 26 (local area network), and a storage device 28 such as a hard disk device, and printers 30a, 30b are connected to the LAN 26. I have. Each product code is displayed as a bar code or the like on the product shelf 32 on which the product to be sold is displayed, and the product code is scanned by the portable scanners 34a and 34b.

The branch system 14 includes a server CPU 40 and a client CPU 4 like the head office system 12.
2a, 42b, 42c, and POS terminals 44a to 44d are connected by a LAN 46 (local area network), and a storage device 48 such as a hard disk device and printers 50a, 50b are connected to the LAN 46. Each product code is displayed as a bar code or the like on the product shelf 52 on which the product to be sold is displayed, and the product code is scanned by the portable scanners 54a and 54b.

The server CPU 20 and the client CPUs 22a in the head office system 12 and the branch system 14 are used.
22c, the server CPU 40 and the client C
The PUs 42a to 42c are configured as a generally known server / client type distributed system,
Various processing programs for access to storage devices, input / output, business analysis and product management are executed by the server CPUs 20 and 40.
The client CPUs 22a to 22c, 42a to 42c perform a desired service request (input of a processing instruction) by input means such as a keyboard and a mouse connected to the client CPUs 22a to 42c. (Service).

Each server CPU20, 40 has LAN2
In storage devices 28 and 48 such as hard disk devices connected via the devices 6 and 46, a database for storing data such as merchandise master data, supplier master data, department-specific master data, and sales data is constructed. I have.

FIGS. 2A to 2E are diagrams showing the structure of this database. The product master data 60 includes a bar code (product code) 60a, a product number 60b, a maker name 60c, a product name 60d, a purchase value 60e, and a purchase value 60e of the corresponding product. The supplier master data 62 includes a supplier 60f, a selling price 60g, a department code 60h indicating a sales department of the product, information 60i on other products, and the like. The supplier master data 62 includes a supplier code 62a, a supplier name 62b, and other information 62c. The section-specific master data 64 includes a section code 64a, a section name 64b, and other information 64c. On the other hand, the sales data 66 includes a bar code (product code) 66a, a product name 66b, and a sales price 66.
c, sales quantity 66d, discount 66e, information 66f indicating the date and time of sale, section code 66g, other information 66h, etc., and the POS terminals 24a to 24d, 44a to 44
From the sales data sent from d, for each sale (for each customer)
Then, sales data (raw sales data) for each sales item (each product) is sequentially accumulated.

Each POS terminal 24a-24d, 44a-4
Reference numeral 4d denotes a well-known POS terminal, which reads each product purchased by a customer with a scanner or the like, inputs sales data including a sales quantity, and inputs the sales data via the server CPUs 20 and 40.
Referring to the selling price 60g of the product master data 60, the amount of each product is totaled, the sales amount is received, change is paid, and a receipt is issued. Although not shown, the merchandise master data 60 stores the same discount information as in the related art, and the discount processing is performed on the merchandise to be discounted.

Each of the POS terminals 24a to 24d, 44
a-44d processed product code product name, sales price,
Sales data such as sales quantity, amount, discount amount, date and time of sale, sales location (checkout number, salesperson (checkout person), etc.
N26, 46, each server CPU2
The sales data is sent to the sales data 66 in the databases of the storage devices 28 and 48 as sales data for each sales item (each product).

Further, each of the POS terminals 24a to 24d, 4
4a to 44d are provided with an input mode in which in the stocktaking process, a product code entered in the shelf layout table is scanned and input, and an operation of continuously inputting the quantity of the product entered in the shelf layout table is provided. It can be used by switching to the normal sales data input mode.

The master data in the branch system 14 can be referred to in the head office system 12, and from each of the client CPUs 22a to 22c, the server CPU 20 at the head office and the communication line, for example, the ISDN line 1
By transmitting an access request for the storage device 48 to the server CPU 40 on the branch side via the server 8, desired processing can be performed. Similarly, the master data in the head office system 12 can be referred to in the branch system 14, and the server CPU 40 on the branch side and the communication line from each client CPU 42a to 42c, for example,
The server CPU 2 at the head office via the ISDN line 18
0, a desired process can be performed by transmitting an access request for the storage device 28. The portable scanners 34a, 34b, 54a, 54b can arbitrarily select products to be subjected to processes such as product analysis and ordering. It functions as a product specifying means for specifying. That is, the sales staff and the product management staff use the product code such as the bar code displayed on the product shelves 32 and 52 on which the products to be sold are displayed at each sales floor. It scans and reads the product code of any product that you want to target in product management operations such as stocktaking, hot selling product, and dead product analysis, and stores it in a built-in memory.
The stored product code is stored in the portable scanner 34a,
34b, 54a, 54b to the client CPU 22a
To 22c and 42a to 42c, and input (introduce) to the system. In addition, the client CPUs 22a to
A predetermined service request (processing instruction) from input means such as a keyboard and a mouse connected to 22c and 42a to 42c.
Is input, the product code is transmitted to the server CPUs 20 and 40 to specify the product.

On the other hand, the client CPUs 22a to 22a
c, 42a to 42c can also function as product specifying means. That is, the client CPU 22
a to 22c, 42a to 42c to the product master data 60 in the storage devices 28 and 48, the supplier master data 6
2. An access request is made by arbitrarily selecting the section-specific master data 64 or the like, displaying the master data on a screen, and selectively specifying a desired product code or setting collectively by inputting specific conditions. In this way, the product is specified.

The server CPUs 20 and 40 transmit the portable scanners 34a and 34a based on the service requests input from the client CPUs 22a to 22c and 42a to 42c.
4b, 54a, 54b or client CPU 22
The sales data of the corresponding product is obtained from the storage device in accordance with the product codes introduced from the product specifying means a to 22c and 42a to 42c, and the obtained sales data is processed based on the input processing instruction. For example, for example, totals are sorted and sorted in the order of increasing sales or in decreasing order, and the sorting result is output to output means such as the printers 30a, 30b, 50a, and 50b.

The POS system according to the present invention is basically configured as described above, and its operation and effects will be described below.

Sales of merchandise and collection of sales information in the POS system 10 of FIG.
4d, 44a-44d, in a manner similar to the general method. That is, the POS terminals 24a to 24d,
44a to 44d read each product purchased by the customer with a scanner or the like, input sales data including the sales quantity, refer to the product master data 60, and totalize the price for each product based on the selling price 60g. To receive the proceeds, pay change, and issue a receipt. Also, the product codes, product names, sales prices, sales quantities, amounts, discounts, sales dates and times, sales locations (checkout numbers, salespersons (cashier representatives), etc.) processed by the POS terminals 24a to 24d and 44a to 44d. Sales data for LANs 26 and 46
Are sent to the respective server CPUs 20 and 40 and are stored in the sales data 66 in the databases of the storage devices 28 and 48 as sales data for each sale and each sales unit.

The service requests to the server CPUs 20 and 40 are sent to the client CPUs 22a to 22c and 42, respectively.
This is performed by selecting a desired menu from the menus prepared in a to 42c. FIG. 3 shows the client CPU 2
FIG. 2B is a diagram showing a configuration of a service request menu displayed on 2a and the like. First, main menus MM 1) to E) are displayed on a screen, and a desired process is selected by operating a corresponding key from a keyboard. Next, a submenu SM corresponding to the selected process is displayed on the screen, and a desired process is selected by operating a corresponding key from the keyboard in the same manner. Further, in accordance with the selected processing, an input screen for various parameters and data required for the processing is displayed on a window screen or the like, predetermined parameters and data are input, transmitted to the server CPU 20, and transmitted to the server CPU 20 to receive a service request (processing request). )I do.

A service process (processing program) corresponding to each service (processing) is prepared in each of the server CPUs 20 and 40, and a predetermined process is performed by the service process. Server CPU 20, 40
And each of the client CPUs 22a to 22c and 42a to 42
The processing functions in c can take various forms of sharing. For example, the processing of data acquired from the storage device and the like are performed by the client CPUs 22a to 22c and 42a to 4c.
2c can also be configured to perform
20, 40 and client CPUs 22a to 22c, 42
A series of processing is performed while exchanging necessary data, processing requests, parameters, and the like with a to 42c.

Commodity Analysis (Selling Goods, Deadly Commodity Analysis) Next, taking as an example the case of analyzing the hot selling commodities and the deadly commodities using the portable scanner 34a as the commodity specifying means, FIG. Will be described.

First, in step ST1, using the portable scanner 34a, the merchandise codes of the merchandise to be analyzed for the hot selling merchandise and the dead merchandise are read by scanning. In this operation, the person in charge puts a bar code (product code) installed in front of each product on the product shelf 32 into a portable scanner 34.
By scanning with a, it means that any product can be easily selected as an analysis target. The product code read by the portable scanner 34a is
It is temporarily stored in the built-in memory.

As a result, the product master data 60
Even if no maintenance is performed on the product, it is possible to specify and analyze the product actually placed on the product shelf 32, and the product that exists in the product master data 60 and does not exist on the product shelf Can be excluded from the object of analysis, and flexible product analysis processing such as product specification for each department and product specification for each supplier can be performed.

Next, in step ST2, the portable scanner 34a is set in the client CPU 22a.
When data collection is specified from the main menu MM screen (FIG. 3), and EOS temporary data is selected from the sub menu SM screen (FIG. 3) in step ST3 and the processing is executed, the internal memory of the portable scanner 34a is stored. Is read by the client CPU 22a, and the product code is transmitted to the server CPU 20 in step ST4. The server CPU stores the product code in the storage device 28 as temporary data.

Next, in step ST5, a screen of the main menu MM of the client CPU 22a (FIG. 3)
, A temporary process is designated, and in step ST6, ordering / purchasing / sales analysis is selected from the submenu SM screen (FIG. 3). When ordering / purchasing / sales analysis is selected, in step ST7, a condition input screen (window) is displayed on the display screen by a well-known window switching technique, and a search condition and a totaling condition are input according to the display. In ST8, a service request is made to the server CPU20.

Here, the search condition is, for example, a period specification. If it is desired to analyze the best selling products in the total sales for one month, and the analysis of the dying products, specify the start and end periods of the search to the desired one month. For example, the sales data for the relevant period is searched, and if you want to analyze the best sellers by time of the day or the products that are dying, you can specify the date of the day and the time you want to sum up. The data is searched.

For example, lunches are sold according to time,
The quality changes, and discount sales are generally performed after a certain period of time, and in a timely manner, such as at what time of day the sales volume was large and how much the sales volume was increased by the discount. By analyzing the situation and performing the order processing, it is possible to minimize the loss and maximize the profit.

If the totaling conditions are specified in the order of sales (ascending order), in the order of sales (descending order), etc., the retrieved sales data is totaled, and in accordance with the specification, the order of sales is increased or The data is sorted in ascending order of sales, and the result of the tallying process in the desired order is output.

Next, in step ST9, the server CPU 20 first fetches the product code stored in the storage device 28 (product code input from the portable scanner 34a) as temporary data, and stores the data in the database in the storage device 28. The sales data 66 (FIG. 2D) is searched, and in step ST7, sales data corresponding to the search condition input from the client CPU 22a and corresponding to the product code is acquired. Next, step ST1
0, the server CPU 20 totals the obtained sales data in accordance with the totaling conditions input from the client CPU 22a in step ST7, and in step ST11, outputs the totaled sales data to the printer 3.
0a. Here, the aggregation of the sales data in step ST10 may be divided into functions such that the client CPU 22a processes the data.

In the merchandise analysis process, as shown in the processing procedure of FIG.
PU 22a can be used. In this case, in step ST1a, master search / correction is selected from the main menu MM of the client CPU 22a, and in step ST2a, for example, a product and master data are specified from the submenu SM of the client CPU 22a. As a result, the server CPU 20 reads the product master data 60 from the storage device 28, and
Send to 22a. Upon receiving the product master data 60, the client CPU 22a displays the product master data 60 on the screen. Next, in step ST3a, the client CPU 22a selects a product to be analyzed from the displayed product master data 60, and uses input means such as a keyboard. Specify and enter the product from
Alternatively, they can be collectively specified and input according to specific conditions. The designated product code is transmitted to server CPU 20 in step ST4a. The processing after step ST5a is the same as the processing in FIG. Here, as the master data in step ST2a, supplier master data 62 and department-specific master data 64 can be selected, and a predetermined search condition can be designated by a search condition input window. For example, in the product master data 60, a search is performed under desired conditions excluding products with zero stock on the basis of the stock quantity or the like, and any product code is selected as an analysis target or collectively selected and specified under specific conditions. can do.

In the POS system 10 according to the present invention, since the merchandise analysis is performed by the above-described processing, the sales clerk simply scans the merchandise code using the client CPU 22a or the portable scanner 34a at the sales site. , It is easy to determine the products that are the subject of the hot selling and dying product analysis, and the sales data can be aggregated based on the result of the product specification.
Flexible product analysis and product management can be performed.

In the POS system 10, the bar code is scanned by the client CPU 22a or the portable scanner 34a in the purchase, ordering, and other processes without depending on the product analysis. By entering the product code into the system,
Various processes as described below can be performed by designating an arbitrary product.

Product Order Processing Next, the procedure of a product order processing will be described. FIG. 6 is a flowchart showing the procedure for ordering a product. When ordering products, first, in step ST21,
The product code of the product to be ordered is scanned and read using the portable scanner 34a. In this operation, the person in charge can easily and arbitrarily select an arbitrary product as an order target by scanning the barcode (product code) installed in front of each product on the product shelf 32 with the portable scanner 34a. When the product code is read by the portable scanner 34a and the order quantity is input,
The product code and the order quantity are temporarily stored in a memory built in the portable scanner 34a.

Next, in step ST22, the portable scanner 34a is set in the client CPU 22a, and data collection is designated from the main menu MM screen (FIG. 3).
When the EOS order data is selected from the M screen (FIG. 3) and the process is executed, the product code stored in the built-in memory of the portable scanner 34a is read by the client CPU 22a.
The order data including the product code and the order quantity is transmitted to the customer. The server CPU 20 stores the order data in the storage device 28 as temporary data.

Next, in step ST25, order processing is designated from the main menu MM screen (FIG. 3) of the client CPU 22a. In step ST26, order check is selected from the sub menu SM screen (FIG. 3). In ST27, the server CPU2
A service request to 0 is made. When the service request is made, the server CPU 20 reads out the order data stored in the storage device 28 in step ST28, and performs a predetermined order check. When the order check is completed, the order processing is designated from the main menu MM screen (FIG. 3) of the client CPU 22a in step ST29, and an order form is selected from the sub menu SM screen (FIG. 3) in step ST30. , A service request to the server CPU 20 is made. When the service request is made, the server CPU 20 creates an order form in step ST32 and outputs it to the printer 30a.

In this ordering process, the client CPU 22a can be used as a product specifying means.
The procedure when using the client CPU 22a is the same as the procedure of steps ST1 to ST4 of the processing procedure in the product analysis of FIG.

Purchasing Process Next, the procedure of the product purchasing process will be described. FIG.
Is a flowchart showing a procedure for purchasing goods.
When purchasing a product, first, in step ST41, the portable scanner 34a scans and reads the product code, the purchased quantity, and the like of the product to be purchased. In this work, the person in charge can easily collect the purchase data by scanning the delivery slip or the product with the bar code attached thereto with the portable scanner 34a at the site. Portable scanner 34
When the commodity code is read and the purchase quantity is input by a, the commodity code and the purchase quantity are temporarily stored in a memory built in the portable scanner 34a.

Next, in step ST42, the portable scanner 34a is set in the client CPU 22a, and data collection is designated from the main menu MM screen (FIG. 3).
When the EOS inspection data is selected from the M screen (FIG. 3) and the process is executed, the product code stored in the built-in memory of the portable scanner 34a is read by the client CPU 22a, and in step ST44, the server CPU 20
The purchase data including the product code and the purchase quantity is transmitted to the customer. The server CPU 20 stores the purchase data in the storage device 28 as temporary data.

Next, in step ST45, a purchase process is designated from the main menu MM screen (FIG. 3) of the client CPU 22a. In step ST46, an acceptance check is selected from the sub menu SM screen (FIG. 3). In ST47, the server CPU2
A service request to 0 is made. When the service request is made, the server CPU 20 reads out the purchase data stored in the storage device 28 in step ST48 and performs a predetermined acceptance check. When the acceptance check is completed,
In step ST49, a slip processing is designated from the main menu MM screen (FIG. 3) of the client CPU 22a, and in step ST50, a purchase slip is selected from the sub menu SM screen (FIG. 3), and step ST51 is selected.
, A service request to the server CPU 20 is made.
When a service request is made, the server CPU 20 creates a purchase slip in step ST52 and outputs it to the printer 30a.

In this purchasing process, the client CPU 22a can be used as a product specifying means. The procedure when the client CPU 22a is used is the same as the step ST1 of the processing procedure in the product analysis of FIG.
The processing is performed in a procedure similar to the procedure from step ST4.

Here, even if there is a missing item or the like at the time of delivery, the products listed on the product delivery note are set to a rule that the delivery company attaches a delivery slip as a delivery quantity of zero, so that the delivery slip is attached. However, the form and the description contents match the purchase slip as it is, and this also matches the form of the product order form, which facilitates data collection and data processing work in the product management business and business analysis business.

Next, the procedure of the inventory processing of a product will be described. FIG.
9 is a flowchart showing the inventory processing procedure of a product.
When carrying out inventory of goods, first, in step ST61, the portable scanner 34a scans and reads the commodity code of the commodity to be subjected to inventory.
This work is performed by the person in charge scanning the barcodes (product codes) installed in front of each product on the product shelf 32 with the portable scanner 34a in the order of the arranged products.
This means that the products can be selected as inventory targets in the order of the arranged products. The product code read by the portable scanner 34a is temporarily stored in a built-in memory.

Next, in step ST62, the portable scanner 34a is set in the client CPU 22a, and data collection is designated from the main menu MM screen (FIG. 3).
When the EOS inventory data is selected from the M screen (FIG. 3) and the process is executed, the product code stored in the built-in memory of the portable scanner 34a is read by the client CPU 22a, and in step ST64, the server CPU 2
This product code is transmitted to “0”. Server CPU 20
Stores the stocktaking data in the storage device 28 as temporary data.

Next, in step ST65, temporary processing is designated from the main menu MM screen (FIG. 3) of the client CPU 22a. In step ST66, a temporary slip is selected from the sub menu SM screen (FIG. 3). In ST67, a service request is made to server CPU20. When the service request is made, the server CPU 20 reads out the product master data 60 stored in the storage device 28 in step ST68, sequentially arranges product codes and product names corresponding to the specified product codes, and writes a quantity entry field. Is created and output to the printer 30a.

This shelf allocation table is affixed to the corresponding product shelf, and in step ST69, the person in charge at the site checks the product shelf and enters the quantity of the product corresponding to each product code. When this operation is completed, in step ST70, the shelf allocation table in which the quantity is entered is input to the system using the POS terminals 24a to 24d installed at the cash register. At this time, the operation mode of the POS terminals 24a to 24d is switched from the normal cash register operation mode, and the operation of scanning and inputting the product code from the shelf allocation table and key inputting the entered quantity data is performed continuously. It is operated in a mode that performs it. The inventory data input in this manner is stored in the server CPU2 in step ST71.
0 is stored as inventory data in the database of the storage device 28.

As described above, by using the portable scanner 34a, the product code of the product shelf is scanned and input to the system, thereby creating a shelf layout table. The shelf allocation table in which the number has been entered is read using a POS terminal installed at a cash register, and the server CPU is used.
Inventory data is collected via 20. Therefore, unlike the related art, a portable scanner for the worker performing the inventory work is not required, and the quantity entry into the shelf allocation table can be performed by a supporter or a temporary worker, and the inventory work can be completed in a short time. It becomes possible. This means that it is not necessary to take a leave for the inventory work, and that the use efficiency and the management efficiency of the store can be improved.

[0067]

Further, by providing a distributed system including a server CPU and a client CPU in this manner, a low-cost personal computer can be connected to the server CPU.
And can be used as a client CPU. In a medium- or small-scale retail store, a POS system can be constructed at a lower cost than a conventional system using a large computer or an office computer. The system can be maintained and operated by the person in charge, and the merchandise management can be executed flexibly at the sales site.

[0069]

As described above, according to the POS system according to the present invention, a product code is scanned by a portable scanner and input to the system, or a processing device such as a client CPU searches for product master data. The product code is specified by displaying and using a product specifying means such as selecting and specifying an arbitrary product, and the product code is input to the system. For this reason, a sales person or the like can easily select and specify products to be managed at the sales site, such as grasping, selling, inventory management, and various analysis operations of hot-selling products and dying products. There is an effect that a desired task can be easily and flexibly performed in a short time.

[Brief description of the drawings]

FIG. 1 is a diagram showing a configuration of a POS system according to the present invention.

FIGS. 2A to 2D are diagrams illustrating a configuration of a database.

FIG. 3 is a configuration diagram of a process selection menu in a client CPU.

FIG. 4 is a flowchart showing a procedure of a product analysis.

FIG. 5 is a flowchart showing a procedure of a product analysis.

FIG. 6 is a flowchart showing a processing procedure of a product order.

FIG. 7 is a flowchart showing a processing procedure for purchasing goods.

FIG. 8 is a flowchart illustrating a stocktaking process;

FIG. 9 is a diagram showing a configuration of a conventional POS system.

[Explanation of symbols]

10 POS System 12 Head Office (Head Office) System 14 Branch Office (Store) System 16a, 16
b: Modem device 18: ISDN line 20, 40 ...
Server CPUs 22a to 22c ... Client CPUs 24a to 24
d: POS terminal 26, 48 ... LAN 28, 48 ...
Storage devices 42a to 42c ... client CPUs 44a to 44
d POS terminal 30a, 30b Printer 32, 52
Product shelves 34a, 34b: portable scanners 50a, 50
b: Printer 54a, 54b: Portable scanner

Continuation of the front page (56) References JP-A-50-40256 (JP, A) JP-A-2-12453 (JP, A) JP-A-2-55391 (JP, U)

Claims (16)

(57) [Claims] 1. Each time a product is sold to a customer, a product code,
In a POS system for inputting sales data including a sales quantity and collecting the sales data in a database, a POS terminal device for inputting sales data including a product code and a quantity of a product to be purchased by a customer , a storage device configuring a database for storing the sales data for each sales separately based on sales data inputted from the POS terminal device, a portable scanner to identify the product code for any product to be processed, wherein A server computer and a client computer connected to the POS terminal device and the storage device; input means for inputting data or desired instructions to the server computer and the client computer; and the server computer and the client computer According processing result consists of a output means for outputting a product code specified by the portable scanner, and introduced into the client computer, Ma on products
Not based on the star data to get the sales data corresponding only to the commodity code from the storage peripherals, based on an instruction from the entering force means, and processing <br/> sense the acquired sales data, the output POS output to means
system. 2. The POS system according to claim 1, wherein
Introducing the product code specified by the portable scanner into the client computer, acquiring sales data corresponding to only the product code from the storage device,
A POS system wherein the acquired sales data is totaled for each product based on an instruction from the input means, and output to the output means. 3. The POS system according to claim 2, wherein
The sales data tabulated for each product is sorted in descending order of sales or in ascending order, and the sorted sales data is output to the output unit to a desired order in ascending or descending order of sales. P characterized by the following:
OS system. 4. The POS system according to claim 1, wherein
Introducing the product code specified by the portable scanner into the client computer, acquiring sales data corresponding to only the product code from the storage device,
A POS system wherein the acquired sales data is totaled for each section and for each product by referring to section information of the master data based on an instruction from the input means, and output to the output means. 5. The POS system according to claim 4, wherein
The sales data aggregated for each department and for each product is sorted in the order of sales or in the order of small sales, and the sorted sales data is sorted to the desired order in the order of sales or in the order of small sales to the desired order. POS system for outputting to a POS system. 6. The POS system according to claim 1, wherein
Introducing the product code specified by the portable scanner into the client computer, acquiring sales data corresponding to only the product code from the storage device,
The acquired sales data is totaled for each supplier and for each product by referring to supplier information of the master data based on an instruction from the input unit, and is output to the output unit. POS system. 7. The POS system according to claim 6, wherein
The sales data aggregated for each supplier and for each product, in descending order of sales, or sorted in ascending order, the sorted sales data, in descending order of sales, or
A POS system outputting to the output means up to a desired order in ascending order. 8. The POS system according to claim 2, wherein
The product code specified by the portable scanner and the instruction from the input unit are input from the client computer and transmitted to the server computer, and the server computer transmits a product
Not based on the star data to get the sales data corresponding only to the commodity code from the previous term memory devices, based on the previous SL instruction, to process the acquired sales data, and wherein the output to the output means POS system. 9. The POS system according to claim 8, wherein
The POS system, wherein the server computer receives sales data from the POS terminal device and stores the sales data in the storage device as sales data for each sales unit. 10. The POS system according to claim 1, wherein the merchandise code stored in the memory of the portable scanner is introduced into the client computer, and at least the merchandise code and the merchandise code are inputted based on an instruction from the input means. A POS system, wherein a shelf layout table having a product quantity entry column corresponding to the product code is output to the output means. 11. A POS system according to claim 1, wherein, introducing a product code stored in the memory of the portable scanner to the client computer, the product
Product data corresponding to only the product code and the product code corresponding to the product code
Gets the product name, at least, the a product code, to create a product corresponding to the goods code name, shelf allocation table for the inventory with Product Quantity answer column corresponding to the commodity code, the output to the output means A POS system, comprising: 12. The POS system according to claim 10, wherein the POS terminal scans and inputs a product code in the shelf layout table, and writes the product code in a product quantity entry column of the shelf layout table. A POS system having an input mode for inputting a product quantity. 13. The POS system according to claim 1, wherein the master data in the storage device is merchandise master data in which merchandise data is stored for each handled merchandise, and supplier master data in which merchandise data is stored for each supplier. And a department-specific master data storing product data for each department. 14. The POS system according to claim 13, wherein the commodity code specified by the portable scanner is introduced into the client computer, and supplier master data corresponding to only the commodity code, or
Departmental master data, one of the product master data, obtained from the storage device, based on an instruction from the entering force means, a purchase voucher processing the product data obtained, to output to the output means POS featuring
system. 15. A product analysis method in a POS system in which sales data including a product code and a sales quantity is input each time a product is sold to a customer, and the sales data is collected by a computer. a first step of identifying a commodity code by the portable scanner, based on the identified product code of the, related to the product
Instead of being based on master data ,
A second step of obtaining sales data of a product corresponding to only the product code, and, based on the sales data, totaling sales for each product;
A third step of sorting the sales data in ascending or descending order, and outputting the sorted sales data to the output means to a desired order in ascending or descending order. 4. A method for analyzing goods in a POS system, comprising: 16. Every time a product is sold to a customer, sales data including a product code and a sales quantity is input, and the sales data is collected by a computer. A first step of scanning and reading an arbitrary product code to be processed; and referring to master data on the product from a storage device based on the read product code, and
Product code corresponding to only the product code and the product code
A second step of acquiring a product name corresponding to , and at least based on the acquired product code and product name ,
Also, a fourth step of filling product code, product name, create a planogram <br/> Ri Table ing from Product Quantity entry field, and a third step of outputting, the product quantity on the shelf allocation table, A fifth step of scanning and inputting a product code from the shelf layout table in which the product quantity is entered by the POS terminal and inputting the product quantity; and a sixth step of outputting inventory data to a desired output means. An inventory method in a POS system, comprising: