JPH0290291A - Portable commodity data processor - Google Patents

Abstract

PURPOSE:To simply grasp the good seller of respective commodities by inputting each commodity code and outputting the good seller rank data of the commodity corresponding to the commodity code. CONSTITUTION:When a commodity code is inputted by a code input means 2 under the condition that good seller rank data of the commodity inputted from the external to the storage, the good seller rank data corresponding to the commodity code are read out and outputted from an output device. When the output device is a display device 3, the display can be checked, and when the output device is a printer 5, a print can be checked. Since the good seller rank can be immediately grasped by inputting the commodity code, the good seller of each commodity can be simply grasped and the increase/decrease of layout commodities can be easily decided in accordance with the ranks.

Description

DETAILED DESCRIPTION OF THE INVENTION [Industrial Field of Application] The present invention relates to a portable product data processing device that can grasp the best-selling status of products.

[Prior art] As a portable product data processing device, Japanese Patent Application Laid-Open No. 63-18
As seen in Publication No. 4165, when a product code is entered from a hand scanner, the product name is read out from the product data memory and displayed.In this state, when the current inventory quantity is entered manually, it is stored in the product data memory. In some cases, a comparison is made with the optimal inventory data for the item in stock, and the number of orders is calculated and printed out.

This indicates the number of products in stock at the product display location.

This has the advantage of being able to count and enter the information on the spot to determine how much to order for each product to achieve the optimal inventory.

However, although this publication allows for inventory management, it is not possible to manage, for example, how an individual product is selling well nationwide, or how it is doing in relation to other products in the store.

Conventionally, when managing such product sales, product sales data was collected from PO8 terminals and POS files installed at each store and stored in a data center via storage media such as online or floppy disks. The data is aggregated and processed by a host computer, and a ledger sheet is printed out showing the best-selling status of each product.
By passing the ledger to each store, each store can use the ledger to understand the best sellers of individual products by comparing them with the products on display, and decide which products to add, reduce, or even remove. I was judging.

[Problems to be solved by the invention] However, if we judge the best sellers of a product by looking at a book with the huge number of best-selling products nationwide or in a store printed and comparing it with the displayed products, The task of searching for compatible products is troublesome, and this poses a problem in that it cannot be fully utilized in practice.

Therefore, the invention described in claim (1) inputs a product code and outputs ranking data of the best-selling product nationwide or in-store, etc., corresponding to the product code.
The purpose of the present invention is to provide a portable product data processing device that makes it easy to grasp the best sellers of each product and also makes it easy to judge whether to increase or reduce the number of products on display depending on the rank.

For example, when looking at the best-selling products in a store based on national best-selling rank data of products stored in a storage device, even if there is data on products that are best-selling nationally, there are no products in the store. If it does not exist, the product code will not be entered and will not be known. However, this product is a top seller nationwide, so it may sell well if it is displayed in stores.

Therefore, the invention as claimed in claim (2) further provides that, when there is data that is not outputted among the higher rank data stored in the storage device, the product code of the higher rank that is not outputted is outputted and notified. The present invention aims to provide a portable product data processing device.

[Means for Solving the Problem] The invention described in claim (1) includes a data importing means for importing at least best-selling rank data of products from the outside, and storing the best-selling rank data taken in by the data importing means. a storage device for inputting a product code; a code input device for inputting a product code assigned to a product; and when a product code is input using the code input device, best-selling rank data of the product corresponding to the product code is sent from the storage device; A rank data output control means is provided for reading and outputting the rank data to an output device.

Further, the invention described in claim (2) is the invention described in claim (1), and furthermore, the invention described in claim (1) further includes a code input means for inputting a code from a code input means for a product having a preset high rank among the best-selling rank data stored in the storage device. The apparatus is provided with a check means for checking the input if any, and a high rank product data output control means for causing the output device to output the high rank product data that is not checked by the check means.

[Operation] In the invention described in claim (1), when a product code is inputted by the code input means in a state where the best-selling rank data of the product imported from the outside is stored in the storage device, the data is read from the storage device. The best-selling rank data of the product corresponding to the product code is read out and output to the output device.

Therefore, if the output device is a display device, the display can be checked, and if the output device is a printer, the printing can be checked. In this way, by entering a product code, you can immediately know the best-selling rank of that product.

In addition, in the invention of claim (2), when a product code of a higher rank is manually entered by the code input means, it is checked, and if there is a product of a higher rank for which a product code is not input, the product data is outputted. Output to device. This allows you to know about high-ranked products that were not confirmed by inputting the product code.

[Example code] Embodiments of the present invention will be described below with reference to the drawings.

As shown in Fig. 2, numeral 1 denotes a device body of a portable size that can be held in the hand, and on the top surface of this device body 1 there is a keyboard 2 which also serves as a code input means, and a liquid crystal display as an output device capable of displaying, for example, 8 lines. A display 3 and a knob 4 for adjusting liquid crystal weight are provided, and a dot matrix printer 5 as an output device is attached to the tip. Also provided on the side are a card loading port for loading a memory card 6, a connector 8 for connecting a hand scanner 7 for reading barcodes as a manual code means, a power switch, and the like.

The keyboard 2 has an execution key 2a and a % end key 2b.
, other numeric keys, mode setting keys, etc. are provided.

FIG. 1 is a block diagram showing the circuit configuration, where 11 is a CPU (central processing unit) that constitutes the main body of the control section, and 12 is this C.
A ROM (read only memory) that stores basic program data necessary for the PUI 1 to control each part, 13 a storage area for application programs for various tasks read from the memory card 6, and various processing data. This is a RAM (Random Access Memory) which is provided with a storage area for , and a memory (storage device) for storing best-selling information of products including best-selling rank data inputted from the outside.

14 is a card reader/writer that controls the memory card 6 and reads and writes data from the memory card 6; 15 controls the barcode scanner 7 and reads barcode reading data from the scanner 7; A scanner interface 16 is a keyboard controller that controls the keyboard 2 and receives key signals from the keyboard 2. 17 is a display controller that controls the display 3 and outputs display data to the display 3 for display; 18 is the printer 5;
A printer controller 19 controls the printer 5 and outputs print data to the printer 5. The printer controller 19 has a network control device inside and communicates data with a host computer 20 installed in the data center via a public line. It is a transmission interface that performs.

The CPU 1, ROM 12, RAM 13, card reader/writer 14, scanner interface 15,
Each controller 16, 17, 18 and transmission interface 19 are connected via a path line 21.

When the data reception mode is set by key operations on the keyboard 2, the CPU 1 performs the data reception process shown in FIG. 4 using an application program. Note that this program uses the one stored in the RAM 13 from the memory card 6.

First, when the execution key 2a is pressed, a check is made to see if there is a start request from the host computer 20 via the transmission interface 19, and if there is a start request, data is received.

The data at this time is information on the best sellers of products, such as information obtained by compiling product sales data from stores nationwide that the host computer 20 is affiliated with and processing it, as well as product sales data collected from individual stores. It is obtained by processing and processing at each store.

The received data is stored in the memory in the RAM 13 as a mask file. For example, information on best sellers nationwide is stored as a nationwide JAN check mask file as shown in (a) of Figure 3, and information on best sellers by store is stored as a nationwide JAN check mask file as shown in (b) of Figure 3. Store as a JAN check mask file.

The national JAN check master file includes, for example, the start national code S21 date, the processed classification, the information a1 data code DT consisting of the district code indicating the target district of data aggregation, the classification code for each product, the JAN code, the product name, and the best-selling rank. , the lowest price, the end code EN, the number of items for each category, and the information C consisting of the total number of items. Note that an AA rank unhandled flag is provided in the information table corresponding to each product.

In the above, the best-selling rank is set in four stages: AA, A, B, and D based on the number of sales items or sales amount.For example, it is assigned to the top 50 products in the AA ranking, and the A rank is assigned to products ranked 51st to 100th. It is attached to products up to
B rank is given to products ranked 101st to 200th.
D rank can be given to products ranked 201st or above.

Also, the lowest price is the lowest selling price among the compiled national data. Note that instead of the low price, the high price, which is the highest selling price in the national data, or the average value of the prices in the national data may be used.

A store-specific JAN check master file includes, for example, start store code ST, date, processing department, information d consisting of store code, data code DT, department code for each product, JAN code, product name, best-selling rank, and daily income. The information e consists of information e consisting of the information e, and the information f consisting of the end code EN, the number of cases for each department, and the total number of cases.

In the above, the best-seller ranks are set in four levels: A, B, C, and D based on the number of sales items or sales amount.
For example, A rank is given to the top products that reach 50% by adding up the sales ratio, B rank is given to the products with normal sales, and C rank is given to the product with the lowest sales score among the products with sales. The D rank is given to products that have had no sales for three months.

The daily income is the average number of items sold per day for one month.

When the end message is received from the host computer 20, this reception process ends. Further, even if the data receiving mode is entered, if there is any manual input of the end key 2b, this mode is immediately ended and the mode returns to the normal mode.

Further, the CPU II is configured to perform the JAN check process shown in FIG. 5 using an application program. Note that this program uses the one stored in the RAM 13 from the memory card 6.

First, it is checked whether the mask file in the RAM 13 is a nationwide JAN check mask file.

If it is the national JAN check mask file shown in FIG. 3(a), a nationwide JAN check confirmation screen shown in FIG. 6(a) is displayed on the display 3. This screen displays the classification code for nationwide JAN checking, district name, and created columns of processed information. Next, the AA rank unhandled flag for each product is cleared.

Further, if the file in the RAM 13 is a shop-specific JAN check mask file shown in FIG. 3(b), a confirmation screen for shop-specific JAN check shown in FIG. 7(a) is displayed on the display 3. This screen displays the department code and store name to be checked for JAN by store.

In this state, it waits for input of the execution key 2a or the end key 2b. And if you have the key power of end key 2b, this JA
Immediately end the N check process.

Also, if there is a key input to the execution key 2a, the barcode scanner 7 waits for the JAN code to be scanned.

In this state, when the barcode scanner 7 reads the JAN code on the barcode label affixed to the product display shelf, if the mask file is a national JAN check mask file, the JAN code is transferred to the national JAN check mask file. , the corresponding JAN code classification code, product name, best-seller rank, and lowest price information are read out from the file and displayed on the display 3 as shown in FIG. 6(b) together with the digitized JAN code.

Also, if the mask file is a store-specific JAN check mask file, the JAN code is added to the store-specific JAN check mask file, and the corresponding JAN code is added from that file.
Information such as the department code, product name, best-seller rank, and daily income of the AN code is read out and displayed on the display 3 as shown in FIG. 7(b) together with the digitized JAN code.

Subsequently, when the mask file is a national JAN check mask file, if the best selling rank of the product just read out is AA crank, an AA rank unhandled flag is set.

In addition, when scanning the JAN code, if the barcode on the barcode label is unclear or cannot be read, the JAN code can be entered manually using the keyboard 2, and the manually entered JAN code can also be processed by the barcode scanner 7. The process is the same as when reading with .

This JAN code input process can be repeated any number of times until the end key 2b is pressed manually.

Finally, if the end key 2b is pressed, it is checked whether the checked mask file is nationwide or by store, and if it is by store, this JAN check process is ended.

Also, if it is nationwide, we will once again have key personnel on standby. If the end key 2b is pressed manually, this JAN check process is ended. If the execution key is 2a, if there is an AA crank product for which the AA rank unhandled flag is not set, that is, if there is an AA crank product for which the code has not been input using the barcode scanner 7 or the keyboard 2, it will be retrieved from the mask file. The information is read out and the printer 5 prints out the classification code, product code, product name, and low price for each product as shown in FIG. In other words, an AA rank unhandled list is issued.

In this embodiment with such a configuration, for example, if best selling information nationwide is received from the host computer 20, the RA
A national JAN check master file is created in M13. For example, when receiving nationwide best-selling information about products in classification 11, category ■, and category ■, a national JAN check mask file shown in FIG. 3(a) is created.

In this state, when it is desired to diagnose the best sellers of each product displayed on the product shelf, a JAN check process is performed. In this process, first, the display shown in FIG. 6(a) is displayed on the display 3.

This display confirms that it is a nationwide JAN check, and also confirms the creation blade of the information stored in the mask file. The product classification to be diagnosed is also confirmed.

In this state, the user goes to the product shelf where products of the corresponding category are displayed, operates the execution key 28, and sequentially scans the JAN codes of the corresponding products with the barcode scanner 7.

When the JAN code is scanned, the JAN code that was scanned is stored in the national JAN check master file in RAM13.
An inquiry is made for the AN code, and the classification code, product name, best-selling rank, and lowest price of the corresponding product are read out, and the JAN code, classification code, product name, best-selling rank, and nationwide number are digitized on the display 3. The lowest price is displayed for each.

This allows you to know what is the best selling item nationwide and what the lowest price is for the item you read. For example, if you have an AA crank, you can see that it is a product that sells well nationwide. Therefore, it becomes possible to accurately judge whether or not to increase stock or whether or not to keep the display position as it is. Also, if the rank is D, it can be seen that the product is not selling very well nationwide. Therefore, from this diagnosis result, we can take into account the sales performance at the store and make accurate judgments such as whether or not to reduce purchasing, whether the display position should remain as it is, or whether to eliminate it. Become.

Note that when deciding whether to change the display amount or display location based on the results of a diagnosis based on the national best sellers of a product, it is desirable to do so after diagnosing all products in the corresponding category. A method of preparing stickers with different colors for rank, B rank, and D rank, and each time you check the best sellers of each product, paste the corresponding sticker on the blank part of the barcode label, and check the color of the sticker later. etc.

Also, since the lowest price is displayed along with the rank, you can also judge whether the current selling price at the store is acceptable.

By using the national JAN check master file in this manner, it is possible to easily grasp the national best sellers of each product for each product department. Therefore, it is possible to easily decide how to display the amount of products, the display position, etc. of the products.

In addition, when diagnosing the best sellers of products using the national JAN check master file, JAN of AA crank products
When the N code is input, the AA rank unhandled flag is set. Then, when all the products with the corresponding classification code in the store have been checked for best sellers, press the end key 2b, and then press the execute key 2a to set the AA rank unhandled flag for AA crank products from the national JAN check master file. Products that are not listed are searched and read out and printed out as a list by the printer 5. That is, as shown in FIG. 8, the classification code, JAN code, product name, and low price for each product are printed out.

Therefore, this list of AA rank items that are not available can be used to identify products that are selling well nationwide but are not displayed in stores. Therefore, countermeasures are taken, such as newly displaying those products.

For example, if store-specific best-selling information regarding only the own store is received from the host computer 20, a store-specific JAN check mask file is created in the RAM 13. For example, if a store receives information on best-selling products of department 1, department ■, and department ■ set in a store, a store-specific JAN check mask file shown in FIG. 3(b) is created.

In this state, when it is desired to diagnose the best sellers of each product displayed on the product shelf, a JAN check process is performed. In this process, first, the display shown in FIG. 7(a) is displayed on the display 3.

This display confirms that it is a JAN check by store. Also, the product category to be diagnosed is confirmed.

In this state, the user goes to the product shelf where products of the corresponding department are displayed, operates the execution key 2a, and sequentially scans the JAN codes of the corresponding products with the barcode scanner 7.

When the JAN code is scanned, the scanned JAN code is stored in the store-specific JAN check master file in RAM13.
An inquiry is made for the AN code, and the department code, product name, best-selling rank, and daily edition number of the corresponding product are read out and digitized on the display 3. The JAN code, classification code, product name, best-selling rank, The number of daily sales, which is the average number of items sold per day for one month, is displayed.

This allows you to understand which products you read are selling well in the store. For example, an A rank indicates that the product is selling well in stores. Therefore, it becomes possible to accurately judge whether or not to increase stock or whether or not to keep the display position as it is. Also, if the product is ranked C, it means that the product is not selling well. You can also know the number of units sold per day at that time. Furthermore, if it is ranked D, it means that the product has not sold at all in the past three months.

Therefore, based on these diagnostic results, it becomes possible to accurately judge whether or not to reduce purchasing, whether or not the display position should remain as it is, or whether to eliminate it.

By using the store-specific JAN check master file in this manner, it is possible to easily grasp the best sellers of each product at the store. Therefore, it is possible to easily decide how to display the amount of products, the display position, etc. of the products. In this case as well, just like the nationwide check, the rank of each product can be divided by the color of the sticker.

[Effect of the invention] As detailed above, according to the invention described in claim (1),
By inputting a product code, the ranking data of the product corresponding to that product code is output as a best seller nationally or in-store, allowing you to easily understand the best sellers of each product, and also increase the number of products on display based on the rank. Therefore, it is possible to provide a portable product data processing device that makes it easy to decide whether to increase or reduce the number of products.

Further, according to the invention described in claim (2), when there is data that is not outputted among the higher rank data stored in the storage device, it is possible to output and notify the product code of the higher rank that is not outputted. A portable product data processing device can be provided.

[Brief explanation of drawings]

The figures show an embodiment of the present invention; Fig. 1 is a block diagram, Fig. 2 is an external view, Fig. 3 is a diagram showing the structure of a master file for national JAN check and store-specific JAN check,
Figure 4 is a flowchart showing data reception processing from the host computer by the CPU, Figure 5 is a flowchart showing JAN check processing by the CPU, Figure 6 is a diagram showing the display format of information during nationwide JAN check, and Figure 7. 8 is a diagram showing the display form of information when checking JAN by store, and FIG. 8 is a diagram showing a printed out AA rank unhandled list. 1... Device body, 2... Keyboard, 2a... Execution key 2b... End key 3... Liquid crystal display,
5... Dot matrix printer, 7... Hand scanner for barcode reading 11... CPU (central processing unit), 12... ROM, 1B... RAM,
20...Host computer. Applicant's agent Patent attorney Takehiko Suzue Figure 2 Figure 5

Claims (2)

[Claims] (1) a data importing means for importing at least best-selling rank data of products from the outside, and a storage device for storing the best-selling rank data taken in by the data importing means;
a code input means for inputting a product code assigned to a product; and when a product code is input using the code input means, best-selling rank data of the product corresponding to the product code is read from the storage device and outputted; A portable product data processing device, characterized in that it is provided with rank data output control means for causing the device to output rank data. (2) a data importing means for importing at least best-selling rank data of products from the outside, and a storage device for storing the best-selling rank data taken in by the data importing means;
a code input means for inputting a product code assigned to a product; and when a product code is input using the code input means, best-selling rank data of the product corresponding to the product code is read from the storage device and outputted; rank data output control means for causing the device to output it; and checking means for checking the input of a code when a code is input from the code input means for a product of a preset high rank among the best-selling rank data stored in the storage device. A portable product data processing device characterized in that it is provided with a high rank product data output control means for causing the output device to output the high rank product data that is not checked by the checking means.