JP2001109960A - Commodity sale managing method and commodity sale data managing system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a commodity sale managing method and a commodity sale data managing system capable of sales strategy planning and will determination supporting in a retail store by improving the efficiency in processing such as pricing of a commodity, especially, of fresh food, discounting, check of validity for taste and waste treatment and automatically summing up data such as production result, discount result and sales result. SOLUTION: The production result data are summed up on the basis of an article label with bar code issued by a weighting/packaging/pricing machine AW, weight label printer DPS and label printer DP. At the time of estimated discounting of an article, the discount data are summed up on the basis of a discount label issued by a handy terminal HT. The sales result data are summed up on the basis of registering/account settling processing of the commodity in a POS register PR. These summed-up data are stored in a file server FS and provided.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a commodity pricing apparatus for printing and issuing a bar code label of a commodity including price information, a commodity package to which the bar code information is added,
The present invention relates to a merchandise sales data totalizing system using the barcode information and a merchandise sales management method.

[0002]

2. Description of the Related Art In a POS (Point of Sales) system, a bar code added to a product is read to perform a registration and settlement process of the product, and a total management of sales data is performed.

[0003] Fresh food products, such as meat, fresh fish, and delicatessen, have a short shelf life, so that a relatively small amount of production and processing can be performed several times a day, and discounts due to unsold products can be cut off. Often done. For this reason,
In a retail store such as a food supermarket, in-store marking is often performed (the retail store side attaches a label printed with a NON-PLU barcode to the product) to reduce the price of the product displayed on the product shelf. . As a conventional technology for such price reduction sales, Japanese Patent Publication No.
There is a barcode processing device disclosed in JP-A-13990. In the bar code processing device, discount information such as x% reduction and y yen reduction is input in advance, and the NON-PLU barcode indicating the product code and the selling price is read from the label attached to the product, and the value is read. Calculate the price after subtraction. Then, a new NO that reduces the selling price to the price of the calculation result
The N-PLU barcode is printed, the label is issued, and the label is overlaid on the barcode of the old label before the discount, so that the price reduction sale at the POS register can be easily performed. .

[0004]

[0004] The above-mentioned price reduction sales and disposal of goods due to the above-mentioned closing will cause a loss to the seller, so that the amount of such price reduction sales and waste products is further reduced, and In order to reduce losses, the extent and timing of price cuts must be determined appropriately.

[0005] However, in the above-mentioned prior art, since data is obtained only from the NON-PLU barcode at the time of product registration, only the product code and sales price of the product sold at a reduced price can be grasped, and the product whose expiration date is approaching. Couldn't get any information on how much the price was cut and when it was sold. For this reason, when planning a sales strategy, it was not possible to consider the extent and timing of price reductions based on sales data.

Further, for example, of the products produced and processed in a certain time zone on a certain day, how much is sold at a normal price, how much is sold at a discount price, and how much is unsold It was very troublesome to aggregate the data on whether the data was discarded in detail and calculate the gross profit.

[0007] The present invention has been made in view of such circumstances, and the management of perishable foods, in particular, for products whose sales prices have been reduced due to price reductions (discounts, discounts, price reductions, etc.), the degree of price reduction, Information such as the sale time can be obtained, and the expiration date can be checked and the disposal process can be performed automatically when the expiration date has passed. It is an object of the present invention to provide a product sales management method and a product sales data management system.

[0008]

According to the first aspect of the present invention,
The barcode is read from a product to which a barcode including product registration settlement data including a product identification code and sales management data including date and time information related to sales management of the product is added, and the product is read based on the identification code. The gist of the present invention is a merchandise sales management method characterized by performing registration processing and settlement processing of (i) and totalizing the goods registered in the registration processing based on the sales management data. here,
“Date and time information regarding the sales management of this product” includes, for example, the date and time of production, the expiration date, and the expiration date (sale date) of the product.
And the like, and is information composed of one or both of day and time.

According to a second aspect of the present invention, a product to which a bar code representing a product registration settlement data including a product identification code and price information and a sales management data including date and time information relating to sales management of the product is added. The bar code is read from the server, a registration process and a settlement process of the product are performed based on the identification code and the price information, and the products registered in the registration process are totaled based on the sales management data. The summary of the product sales management method.

According to a third aspect of the present invention, there is provided a first barcode representing merchandise registration settlement data including an identification code of a commodity and price information, and a first barcode representing sales management data including date and time information relating to sales management of the commodity. The first barcode and the second barcode are read from the product to which the second barcode has been added, and a registration process and a settlement process of the product are performed based on the first barcode, and the registration process is performed. The summary of the merchandise sales management method is characterized in that the merchandise registered in the above is aggregated based on the sales management data represented by the second barcode.

According to a fourth aspect of the present invention, there is provided a merchandise sales management method, wherein the sales total data of the merchandise obtained as a result of the aggregation based on the sales management data and the production result data associated with the date and time information relating to the sales management of the merchandise. And based on
It is characterized by calculating unsold data of the product.

According to a fifth aspect of the present invention, there is provided a merchandise sales management method, wherein the sales total data of the merchandise obtained as a result of the totalization based on the sales management data and the production result data associated with the date and time information relating to the sales management of the merchandise. And based on
It is characterized in that a disposal process for recording a loss for a product after a predetermined time limit is performed.

According to a sixth aspect of the present invention, there is provided a first barcode representing merchandise registration settlement data including a commodity identification code and price information, and a second barcode representing sales management data including date and time information relating to sales management of the commodity. A label printer that prints a second barcode on a label, a label on which the first barcode and the second barcode are printed by the label printer, and a first barcode and the second barcode from the label. 2 for reading barcodes, and performs registration and settlement of goods based on the identification code and the price information represented by the first barcode read by the reading means. Aggregation processing of commodities registered in the registration processing based on the sales management data represented by the read second barcode It consists of a merchandise sales data processing apparatus for a gist merchandise sales data aggregation system according to claim.

According to a seventh aspect of the present invention, there is provided a first barcode representing merchandise registration settlement data including an identification code of a commodity and price information, and a first barcode representing sales management data including date and time information relating to sales management of the commodity. A label printer that prints a second barcode on a label, a label on which the first barcode and the second barcode are printed by the label printer, and a first barcode and the second barcode from the label. 2 for reading barcodes, and performs registration and settlement of goods based on the identification code and the price information represented by the first barcode read by the reading means. Aggregation processing of commodities registered in the registration processing based on the sales management data represented by the read second barcode And a product sales data processing device that calculates unsold data of the product based on the sales total data obtained as a result of the totaling process and the production result data associated with the date and time information on the sales management of the product. The gist is a merchandise sales data totaling system characterized by the following.

In the merchandise sales data totaling system according to the present invention, the merchandise sales data processing device comprises:
Based on the sales summary data of the product obtained as a result of the aggregation based on the sales management data and the production performance data associated with the date and time information related to the sales management of the product, a loss is recorded for the product whose predetermined period has passed. Is performed.

According to a ninth aspect of the present invention, the label printer prints a barcode representing the production result data on a label.

In a tenth aspect of the present invention, the second barcode further includes data indicating whether the product is a discounted product and data relating to a discounted price. The sales data processing device determines whether or not the product is a discounted product based on the second barcode read by the reading unit, and performs a discounting process in the registration process and the settlement process according to the determination result. The totalizing process is characterized in that the totalizing process is performed while discriminating whether or not a discount has been made.

In the merchandise sales data totaling system according to the eleventh aspect of the present invention, the merchandise sales data totaling system includes a first barcode representing merchandise registration settlement data including a merchandise identification code and price information, and date and time information relating to sales management of the merchandise. The second barcode representing the sales management data is printed on the first label at the first timing by the label printer, and indicates the data indicating that the product is a discount product and the second barcode representing the data regarding the discount price. Is printed on a second label at a second timing different from the first timing, and the second label is affixed on the first label.

According to a twelfth aspect of the present invention, a first barcode representing merchandise registration settlement data including an identification code of a commodity and price information and a second barcode representing sales management data including date and time information relating to the sales management of the commodity. A label printer that prints a bar code on a label, a production result data storage unit that stores the result data of the bar code printed by the label printer for each product and for each date and time, and a label attached to the product. The first bar code and the second bar code;
Reading means for reading a bar code, registration and payment means for performing product registration and payment processing based on the identification code and the price information represented by the first bar code read by the reading means, Tallying means for summing up the sales of commodities registered by the settlement means for each date and time information represented by the second barcode read by the reading means, and sales result data storage for storing the result of tallying by the tallying means Means, based on the storage contents of the production result data storage means and the storage contents of the sales result data storage means, unsold data calculation means for calculating unsold data for each date and time information of the product, and the unsold data calculation means An output means for outputting a calculation result is provided.

In the merchandise sales data totaling system according to the thirteenth aspect, the date and time information is information indicating the date and time of production of the product, and the expiration date storage means for storing the expiration date of each product; Based on a best-before date calculation unit that calculates a best-before date based on the best-before period stored in the best-before period storage unit, and based on unsold data for each date and time information calculated by the unsold data unit,
And discarding means for recording a loss for the product whose expiration date has passed.

According to a fourteenth aspect of the present invention, in the merchandise sales data totaling system, based on unsold data for each date and time information calculated by the unsold data calculation means,
It is characterized by comprising a disposal means for accounting for a loss of a product after a predetermined time limit.

According to a fifteenth aspect of the present invention, in the merchandise sales data totaling system, the second barcode representing data indicating that the merchandise is a discount merchandise and data relating to a discount price is printed on the discount label, and the discount label is printed. Is provided on the label.

According to a sixteenth aspect of the present invention, a first bar code representing merchandise registration and settlement data including an identification code of a commodity and price information and a second bar code representing sales management data including date and time information relating to sales management of the commodity. A second aspect of the present invention is to provide a label printer characterized in that the label printer prints the second bar code on a label.

According to a seventeenth aspect of the present invention, a bar code representing a bar code representing merchandise registration and settlement data including a merchandise identification code and price information and sales management data including date and time information relating to sales management of the merchandise is added. Make the package a summary.

The invention according to claim 18 is a first barcode representing merchandise registration settlement data including an identification code of merchandise and price information, and a first barcode representing sales management data including date and time information relating to sales management of this merchandise. Using a label printer characterized by printing a bar code of No. 2 on a label,
The gist of the present invention is a merchandise sales management method, wherein a label on which the first barcode and the second barcode are printed is printed and attached to a merchandise.

[0026] According to a nineteenth aspect of the present invention, a first bar code and a second bar code are read, an identification code of a product is acquired from the read first bar code, and the identification code is obtained based on the acquired identification code. Or read the first
The price information of the product is obtained directly from the bar code of the product, the registration process and the settlement process of the product are performed based on the identification code and the price information, and the date and time related to the sales management of the product from the read second bar code. Get information,
The gist of the present invention is a merchandise sales data processing apparatus that counts commodities registered in the registration process based on the date and time information.

[0027]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS <Structure> First, an embodiment of a price maker (label printer) according to the present invention will be described with reference to the drawings. FIG. 1 is an in-store layout of a retail store that sells products such as fresh foods whose expiration date is determined, and shows an example of a retail store to which a product pricing device according to an embodiment of the present invention is applied. .

The upper back yard in FIG. 1 is an area for processing and pricing fresh foods in particular. A label printer LP is provided in this area, and a label (hereinafter, referred to as a label) to be attached to the processed fresh foods. This label is referred to as a “first label”). The sales area on the lower side is an area in which goods shelves are arranged, and a checkout counter CC (register) provided with a barcode reader BR is provided, whereby the customer pays for the goods to be purchased. Here, the checkout counter CC includes predetermined calculation means, storage means, and the like, and performs processing of information read from the barcode reader BR based on data of a product file preset for each product (details). Will be described later).

When the store closing time approaches (for example, one hour before the store closes), the store clerk on the right side of the sales floor searches for a product whose expiration date is today from the product shelf. Then, a label (hereinafter, this label is referred to as a “second label”) to be attached to the product with the expiration date is issued by the handy terminal HT in the hand, and is superimposed on a predetermined position on the first label of the product. paste.

In the above-described retail stores, the label printer LP and the handy terminal HT correspond to a product pricing device according to the present embodiment. Hereinafter, those configurations will be specifically described.

(1) Label Printer LP FIG. 2 is an electric block diagram of the label printer LP. In FIG. 1, reference numeral 1 denotes a CPU (central processing unit) that controls the entire operation of the label printer LP, and is connected to each of the other components as shown. Reference numeral 2 denotes a ROM in which a program to be executed by the CPU 1 is stored. Reference numeral 3 denotes a RAM (Random Access Memory) used in the arithmetic processing of the CPU 1, which stores in advance a product file of product data (product name, product code, normal unit price, expiration date, etc.) corresponding to each product number. Have been. As the product file referred to here, a file corresponding to the product file registered in the checkout counter CC is stored, and a file for each product is set and registered in advance.

Reference numeral 4 denotes a display unit for displaying predetermined information according to a display instruction from the CPU 1. Reference numeral 5 denotes an operation unit provided with input means for inputting a product number, confirming completion of weighing, setting input of a product file, and the like, and supplies the input data to the CPU 1. Reference numeral 6 denotes a printing unit for performing predetermined barcode printing or the like in accordance with a printing instruction from the CPU 1. Reference numeral 7 denotes a weighing unit that weighs the weight (content) of the placed product, and supplies the weighed value to the CPU 1. 8 is the month,
It is a clock that measures the day, hour, and minute and supplies it to the CPU 1.

(2) Handy terminal HT FIG. 3 shows an electric block diagram of the handy terminal HT. In this figure, reference numeral 10 denotes a CPU for controlling the entire operation of the handy terminal HT, which is connected to each of the other components as shown. Reference numeral 11 denotes a ROM (Read-Only Me) in which a program to be executed by the CPU 10 is stored.
mory), and stores a program or the like that defines processing of the CPU 10 in the operation description to be described later. 12 is C
This is a RAM used in the arithmetic processing of the PU 10 and the like. 13
Is a display unit for displaying predetermined information according to a display instruction from the CPU 10.

Reference numeral 14 denotes an operation unit provided with input means for selecting input of a price reduction method and inputting price reduction data, and a print key for instructing printing, and the like. Supply to

Here, the price reduction methods include a "discount" in which a fixed amount is reduced from a normal selling price (hereinafter, referred to as "normal price") of a product, and a "discount" in which a fixed percentage is reduced from the normal price. There is a "price reduction" in which the selling price is reduced to a specific amount that is reduced from the normal price. These price reduction methods are prepared in advance in a program in the ROM 11 or as data in the RAM 12, and the operation unit 14 Any one of them can be selected and input. Further, as price reduction data, “discount amount” corresponding to “discount”, “discount%” corresponding to “discount”, and “sale price” corresponding to “price reduction” are included. The operation unit 14 is designed to input an amount or a discount rate corresponding to each case.

In the present embodiment, a simple price reduction is a general term for all price reduction modes such as discounts, discounts, and price reductions. In particular, “price reduction” is one of the above price reduction methods. It shall mean only "price reduction". In the following, both the price reduction method and the price reduction data may be collectively referred to as “price reduction information”.

Reference numeral 15 denotes a printing unit for performing predetermined bar code printing or the like in accordance with a printing instruction from the CPU 10. 16 scans a bar code and reads the data, and the CPU
10 is a barcode scanner to be supplied.

A label to be attached to a product is issued by the label printer LP and the handy terminal HT as described above. The label printer LP prints the first barcode in the standard NON-PLU format on the first row (upper row in the label), and uses the date / price format specific to the present pricing apparatus in the second row (lower row). A label on which the second barcode is printed is issued as a first label.
On the other hand, the handy terminal HT issues, as a second label, a label corresponding to the second barcode in the second row of the first label, in which only the second barcode in the same date price format is printed.

The format of these bar codes is specifically as shown in FIG. In the figure, (a) shows a standard NON-PLU format of a first barcode in which a commodity code and a normal price are recorded, and (b) shows a date price format of a second barcode. As shown in this figure, the first bar code has a leading two-digit flag “FF” indicating an in-store code, a five-digit product code “XXXXX” for specifying a product, and a check for correctness of price reading. Single digit price check digit "PC /
D ", a four-digit first price code" P1P1P1P1 "indicating the normal price of the product, and a one-digit check digit" C / D "for confirming whether or not each digit has been read. On the other hand, the second bar code includes a flag “FF”, a two-digit manufacturing month code “MM”, a two-digit manufacturing date code “DD”, and a two-digit manufacturing time code “HH” as described above. ", 4
A second price code “P2P2P2P2” of the digit's normal price, discount amount, discount% or price reduction price and a check digit “C / D” similar to the above are printed.

Here, the flag "FF" is selected from the in-store code characters "20" to "29" for the first row (for the first bar code) and the second row (for the second bar code). ) Is selected at each retail store and printed with a barcode, and is used to distinguish the first-stage barcode from the second-stage barcode at the time of reading. For this reason, for the label printer LP and the handy terminal HT, the flag selected at the retail store is set in advance for each barcode in each row, and the handy terminal HT (barcode scanner 16) and The checkout counter CC is also set in advance so that the read flag can distinguish the first stage or the second stage.

The production month code “MM” is from “01” to
"12" indicates the production month of the product, and a numerical code representing the meaning of the second price code "P2P2P2P2" is printed every time "20" is added thereto. That is, the production month code is from “01” to “12”. At the same time that the second price code is a normal price code, the numerical value of “01” to “12” itself is the production price of the product. Represents the month. In the case of "21" to "32" → At the same time that the second price code is a code of "discount amount", a numerical value obtained by subtracting "20" from the numerical value represents the production month of the product. In the case of "41" to "52"-> The second price code represents a code of "Discount%", and the numerical value obtained by subtracting "40" from the numerical value represents the production month of the product. In the case of "61" to "72"-> The second price code represents the code of "price reduction", and the numerical value obtained by subtracting "60" from the numerical value represents the production month of the product. The corresponding production month code “MM” of each product is printed with a bar code. The normal price is printed on the first label attached after processing, and other price reduction data is printed on the second label attached on the expiration date, etc. Printed on the second barcode on the first label,
Is printed in the second bar code on the second label.

As the production date code "DD", numerical values of "01" to "31" representing the production date of the product on the 1st to 31st are printed by bar codes. As the production time code “HH”, “01” to “24” represent the production time at 00 hours per hour, and “31” to “54” obtained by adding “30” to 3 hours per hour.
A bar code representing a manufacturing time of 0 minutes is printed. For example, when the production time is 3:00 pm, the production time code “HH” is set to “15”, and when the production time is 3:30 pm, the bar code is printed as “45”.

As the second price code "P2P2P2P2", a bar code representing any of a normal price, a discount, a discount% or a discount price is printed in correspondence with the numerical code indicated by the production month code "MM". I will. In other words, the second price code is “0” that represents the month as it is when the production month code “MM” is used.
A value between 1 and 12 indicates a normal price, and a value of “20” added to the value indicates a “discount amount”.
If "0" is added, it represents "discount%", and if "60" is added, it represents "sales price".
Note that the normal price among them is the same as the first price code “P1P1P1P1” in the first barcode.

ROM2 or RA of label printer LP
M3 has the first barcode and the second barcode printed in the first and second rows, respectively, in the formats (a) and (b).
It is stored in advance as a barcode format.
On the other hand, ROM 11 or RA of handy terminal HT
The format of (b) is stored in M12 in advance as the format of the second barcode. Further, in these storage means, other predetermined print character data necessary for display of a store name, price, and the like are stored in advance, and are appropriately used in label printing described later.

<Operation> (1) Issuance of First Label Next, the operation of the above configuration will be described. Commodities, such as fresh foods, for which the expiration date is defined, are processed in the backyard, attached with a first label issued by the label printer LP, and priced. FIG. 5 is a flowchart showing a first label issuing process performed by the label printer LP for each product at that time.

In the first label issuing process, first, the person in charge of pricing inputs the product number of the product to which the label is to be attached from the operation unit 5 (step S1). Then, the CPU 1 reads out the product data such as the product name, the product code, the normal unit price, and the expiration date from the product file of the product registered in the RAM 3 (Step S2). Next, when the pricing person puts the product on the weighing section 7 and starts weighing, C
The PU 1 determines that the weighing is not completed and waits until there is a confirmation input from the operation unit 5 (step S3). still,
At this time, the CPU 1 causes the display unit 4 to display the weighed value, the read product name, and the like, and provides the same to the flight of a pricing person.

When the weighing is completed and the price clerk inputs confirmation of completion of the weighing from the operation unit 5, the CPU 1 calculates the normal price of the product by multiplying the read normal unit price by the weighed weight. (Step S4). Next, at this time, the date and time supplied from the clock 8 are read and rounded in units of 30 minutes to produce manufacturing date and time data conforming to the notation format of date and time in the date price format (step S5). That is, the CPU 1 reads “01”-
The month of "12" and the days of "01" to "31" are the production month and the production date, respectively. If the read time is less than 30 minutes, the read time is the production time, and the time after 30 minutes In the case of, "30" is added at the time of reading to make the manufacturing time.

Thereafter, the CPU 1 issues a print instruction to control the print unit 6 and issue a print of the first label (step S6). That is, the CPU 1 sends the commodity code read out in step S2 and the normal price calculated in step S4 to the printing unit 6 as the standard NON-
Product code "XXXX" in PLU format
X "and a first bar code with a first price code" P1P1P1P1 "are printed on the first row of the label paper, and the production month, production date and production time obtained in step S5, and the normal price are shown. In the date price format of 4 (b), the second bar code of the production month code “MM”, the production date code “DD”, the production time code “HH”, and the second price code “P2P2P2P2” is the second row in the label paper. In addition, the CPU 1 determines predetermined information such as the read product name, the normal unit price and the expiration date, the measured weight (contents of the product), the calculated normal price, the manufacturing date of the product, and the like. The information is also printed at a predetermined position in the label paper by controlling the printing unit 6 as appropriate.

The first bar code on which the commodity code and the normal price are recorded in this way, the second bar on which the production date and time (all of the above-mentioned production month, production date and production time; the same applies hereinafter) and the normal price are recorded Code and the first printed
A label is issued and the price clerk attaches it to the product. As a result, for example, as shown in FIG. 6, the first bar code and the second bar code are displayed in the upper and lower two rows, and the first label in which predetermined characters are displayed at other positions is printed and issued to the product. Affixed.

The product priced by the first label is displayed on a product shelf at a sales floor and provided to a customer at a normal price. Then, in the checkout counter CC, the first barcode and the second barcode are respectively scanned by the barcode reader BR at the time of product registration, and after reading the product code, the normal price, and the manufacturing date and time, the normal price is read again. . Therefore, the checkout counter CC recognizes that the product is not a target product for price reduction sales, performs a normal product registration process (accounting process), and accumulates and stores the sales amount and quantity for each product code. Is done.

(2) Issuance of the Second Label The merchandise to which the above-described first label has been affixed is subject to price reduction sales when its expiration date expires soon after it has not been sold. The clerk in FIG. 1 searches for such a product whose expiration date is today from the product shelf when the closing time is approaching. Then, the user operates the handy terminal HT to issue a second label for each item to be price-reduced, and price the product for price reduction sale.

FIG. 7 shows a procedure for issuing a second label by the handy terminal HT. In this issuance process,
First, the CPU 10 determines whether or not the operation unit 14 has been operated to input a selection of a price reduction method (step S1).
1). At this time, when the clerk inputs to select any of “discount”, “discount” or “price reduction”, the CPU
10 uses the RA as the current price reduction mode.
It is stored in a predetermined area in M12 (step S12).
Here, the predetermined area is a storage area that is reserved as an area that stores the selected price reduction method and keeps holding it until a new selection is made. Therefore, if there is no new selection input in step S11, such as when a second label is issued for the same kind of product, the process directly proceeds to the subsequent processing, and the previously stored price reduction method is continuously used as the current price reduction mode. become.

Next, the CPU 10 determines whether or not the operation unit 14 has been operated to input price reduction data corresponding to the current price reduction mode (step S13). here,
When the current price reduction mode is “discount”, the clerk inputs “discount amount” and stores it in a predetermined area in the RAM 12 as current price reduction data.
Similarly, the current price reduction modes are "Discount", "Price reduction"
, The corresponding “Discount%”,
When the clerk inputs the "price reduction", it is stored in the same predetermined area as the current price reduction data (step S1).
4). Here, the predetermined area is also a storage area for storing and holding the input price reduction data. If no new price reduction data is input in step S13, the process directly proceeds to the subsequent processing, and the previously stored price reduction data continues to be the current value. Will be used as price reduction data.

Subsequently, the CPU 10 determines whether or not the data of the second barcode has been supplied from the barcode scanner 16 (step S15). At this time, when the clerk scans the second barcode printed on the first label of the product to be reduced with the barcode scanner 16, the CPU 10
Stores the data of the manufacturing date and time and the normal price in the supplied barcode data in a predetermined area in the RAM 12 as the current second barcode data (step S16). The second area to which the predetermined area is also supplied
This is a storage area for storing and holding barcode data. If no new barcode data is supplied in step S15, the process directly proceeds to the subsequent processing, and the previously stored manufacturing date / time data and normal price data continue to be stored in the current second bar. It will be used as code data.

Next, the CPU 10 determines whether or not the print key of the operation unit 14 has been turned on (step S17).
Now, assuming that the clerk turns on the print key, the CPU 10
Reads the current price reduction mode and the production month of the production date / time data in the current second barcode data from the RAM 12, and adds a value corresponding to the price reduction mode to the data of the production month (step S18). That is, the production month code “MM” in the second bar code is the same as “(1)
Label issuance "," 01 "to" 12 "is set as one of the" 01 "to" 12 "
If the read price reduction mode is “discount”, “20” is added, if “discount”, “40” is added, and if “price reduction”, “60” is added.

The second bar code data on the second label obtained by changing the current second bar code data on the first label based on the current price reduction data and the production month data having undergone the above addition processing.
The barcode data is generated and printed by the printing unit 15 to issue and print the second label (Step S).
19). That is, the CPU 10 adds the production month data to which the value corresponding to the price reduction mode has been added in step S18 as shown in FIG.
Assuming the manufacturing month code “MM” in the date price format of (b), the manufacturing date and manufacturing time of the manufacturing date and time data in the current second bar code data are read out from the RAM 12 respectively, and the manufacturing date code “DD” and the manufacturing time code “ H
"H", the current price reduction data is read from the RAM 12 to obtain a second price code "P2P2P2P2", and a flag "FF" and a check digit "C / D" are added to those codes to generate second bar code data. Then, the second
A printing instruction for bar code data is issued to control the printing unit 15 to print the second bar code on the label paper. Also, C
The PU 10 controls the printing unit 15 to appropriately print the predetermined character information or the like representing the discount amount, the percentage%, or the price reduction price based on the read current price reduction data or the like at a predetermined position in the label paper.

In this way, a second label printed with a second barcode that records the date and time of manufacture, the method of price reduction, and the price reduction data is issued, and the clerk hides only the second barcode of the product to be reduced. Attach it to a predetermined position on the first label. Thereby, for example, as shown in FIG. 8, the first barcode on the first label and the second barcode on the second label are displayed in upper and lower two rows, and other predetermined character display, discount display, and the like are displayed. The label consisting of the first label and the second label is attached to the target product for the price reduction sale.

In the above-described second label issuing process, RA
Since the price reduction mode, the price reduction data, and the second barcode data are kept stored in M12, printing is performed using the previously stored pertinent data even when there is no input operation in steps S11, S13, and S15. be able to. However, the printing is performed only when the print key is turned on. If the print key is not turned on, the process returns from step S17 to S11, and the input receiving state such as the price reduction method is again received. Further, during steps S11 to S16, C
The PU 10 appropriately displays the input data, the data currently stored in the RAM 12, and the like on the display unit 13 so as to serve the convenience of the clerk.

As described above, the products priced by the second label are “discount” indicated by the second label,
Offered to customers at reduced sales prices either by "discount" or "price reduction". In the checkout counter CC, the first barcode and the second barcode are respectively scanned by the barcode reader BR at the time of product registration, the product code and the normal price are read from the first barcode, and the second barcode is read. From, the numerical value of the production month code, the production date, the production time, and the price reduction data that have been subjected to the above addition processing are read.

Thus, the checkout counter CC
In, the merchandise registration process is performed based on the read merchandise code, normal price, numerical value of the production month code, and price reduction data. That is, the numerical value of the production month code is "21" to "3
If “2”, the checkout counter CC recognizes that the price reduction data indicates “discount amount”, subtracts the value of the price reduction data from the normal price, and accounts for the resulting amount as the sales price. If the value of the production month code is “41” to “52”, the price reduction data is recognized as indicating “discount%”, and the discount rate of the price reduction data is reduced from the normal price. If the value of the production month code is “61” to “72”, it is recognized that the price reduction data indicates “price reduction price” and the price of the price reduction data is used as the sales price. With regard to the product to which the second label is attached, the price reduction information is obtained in this way, and the product registration at the selling price lower than the normal price is automatically performed.

At this time, the checkout counter CC
If the numerical value of the read manufacturing month code exceeds “20”, subtract “20”, “40” or “60” from the numerical value to obtain the manufacturing month data of “12” or less. Convert. Then, for each product code, the price reduction amount from the normal price is accumulated, stored, and accumulated. In addition, information such as the date and time of manufacture, price reduction method and price reduction data, the cumulative amount, and the date and time of sale is stored and accumulated as necessary for each product code. As a result, information for grasping how much the price of the product whose expiration date is approaching and the time when the product has been sold can be obtained at the retail store.

Further, the checkout counter CC is made to perform a discard mode process for counting information on discarded products, and further information is collected. That is, the unsold products with the second label attached are discarded products, but the label of such a discarded product is placed on the barcode reader BR after closing the store or on a holiday.
And supplies it to the checkout counter CC in the discard mode. In this case, the checkout counter CC receives the product code and the regular price indicated by the first barcode, the production date and time, the price reduction method and the price reduction data indicated by the second barcode, and based on these, the production date or the production date and time. Totals the disposal amount and price reduction information and outputs the report. At the retail store, it is possible to analyze and examine the production plan of the product, the method of reducing the price at the time of closing, and the like, based on the information collected in this report.

<Supplement> Although the embodiment of the present invention has been described above, the commodity pricing apparatus according to the present invention is not limited to the above-described embodiment. For example, the following modifications and applications are also possible.

(1) As for the production date and time in the second barcode, the expiration date and time may be printed instead. In a shop where the date and time data in the label is set to the expiration date and time, the expiration date of each product is set in the product file stored in advance in the checkout counter, and the expiration date and time from the read expiration date and time is used. By performing the arithmetic processing of going back, the manufacturing date and time can be calculated.

(2) The first bar code of the first label is read by the handy terminal, a label is printed with a bar code in which the first price code is replaced with price reduction data, and the label is superimposed on the first bar code. May be attached. That is, the product code and the normal price are recorded in the first barcode, and the date of manufacture (or the expiration date and time) and the normal price are recorded in the second barcode, and the product code of the first barcode is read. The barcode recorded together with the input price reduction data may be printed and issued, and may be pasted on the first barcode. However, in this case, it is necessary to unify the price reduction method of the in-store product to the price reduction method corresponding to the price reduction data. Further, the date data of each claim is date data used for fresh foods, and includes all data that can obtain the effects of the present invention. For example, the date of manufacture includes the date of processing and the date of finishing as a product, and the expiration date includes the date of expiration of consumption and the date of expiration of the product.

(3) In the above embodiment, a two-stage barcode is used. However, the present invention is not limited to such a form, and a product code, a normal price, a production date and time or a shelf life date and a price reduction data can be recorded in a barcode. If it is something,
For example, a three-stage barcode or a two-dimensional barcode may be used. Further, the second label issued by the handy terminal may be affixed on top of the barcode of the first label or the entire first label, if necessary, so as to hide the entire barcode. For example, the product code, the normal price, and the date and time of manufacture (or date of expiration date) recorded on the first label are all read, and the price reduction data input thereto and the information on the price reduction method are added thereto, or By including the same information in either,
It generates bar code data in which the product code, the normal price, the date and time of manufacture (or the date and time of expiration date), and the same information are recorded. Then, a new barcode based on the barcode data may be printed and issued, and the barcode may be pasted on the entire barcode of the first label, the entire first label, or the like.

(4) The date and time data in the second bar code is
It may be used to detect expired products at the time of scanning at the time of product registration or at the time of price reduction sale. Thereby, the credit of the store can be improved.

Next, the bar code data system described above, a label printer that prints a bar code on a label and affixes it to a product, and a POS register that reads a bar code and performs a product registration and settlement process will be described. A method and system for totalizing data and performing product sales management will be described with reference to the drawings.

<Structure> FIG. 9 is a layout diagram of a retail store that sells products such as fresh food, and the retail store to which the product sales data aggregation system and the product sales management method according to one embodiment of the present invention are applied. An example is shown.

The upper right back room in FIG. 9 is an area for processing and pricing fresh foods in particular, and includes a weighing / packaging / pricing machine AW (label printer) and a weighing label printer DPS. And a label printer DP are arranged, and labels (first
Is affixed at the time of product production or processing.

The sales floor at the bottom in FIG. 9 is an area where product shelves are arranged, and a POS provided with a bar code reader is provided.
A register PR is provided, by which the customer pays for the goods to be purchased. Here, the POS register PR has the same configuration and function as the above-described checkout counter CC, includes predetermined calculation means, storage means, and the like, and stores data of a product file preset for each product. The information read from the barcode reader is processed based on the information. A clerk carrying the handy terminal HT in the sales floor searches for a product near the expiration date from the product shelf, issues a label (second label) using the handy terminal HT, and places the product at a predetermined position on the first label. And paste it on.

The upper left office in FIG. 9 is an area in which clerical processing such as data aggregation and accounting processing, and decision-making regarding purchase quantities, production / processing quantities, etc. are performed based on this data. SC is provided.

FIG. 10 is a block diagram showing the configuration of a system for data processing in the retail store. In the back room LAN (N1), the weighing, packaging,
In addition to the pricing machine AW, the weighing label printer DPS and the label printer DP, a file server FS holding various data files is connected. Further, the file server FS is provided with a transceiver TR, through which data can be exchanged between the file server FS and the handy terminal HT carried by the clerk. . The above-mentioned POS register PR and store controller SC are connected to the in-store LAN (N2). Also, LAN in the back room
(N1) and the in-store LAN (N2) are connected to each other, and data can be exchanged between these two LANs.

FIG. 11 is an electrical configuration diagram of the POS register PR. In this figure, 21 is a POS register PR
Is a CPU that controls the entire operation of the device, and is connected to each of the other components as shown in the figure. 22 is CPU2
1 is a ROM in which a program to be executed is stored, and stores a program or the like which defines processing of the CPU 21 in the operation description to be described later. Reference numeral 23 denotes a RAM used in the arithmetic processing of the CPU 1, and a P corresponding to each product number
An LU file (product file) and the like are stored.

Reference numeral 24 denotes a display unit for displaying predetermined information according to a display instruction from the CPU 1. Reference numeral 25 denotes an operation unit provided with an input unit for inputting completion of merchandise registration and inputting numerical data such as a deposit amount from a customer at the time of settlement, and supplies the input data to the CPU 21. Reference numeral 26 denotes a printing unit that prints a receipt or the like of a product registered and settled according to a printing instruction from the CPU 21. 28 is the month,
It is a clock unit that measures the day, hour, and minute and supplies it to the CPU 21. 29 reads the barcode added to the product,
The scanner unit supplies the data to the CPU 21.
Reference numeral 30 denotes a communication unit for exchanging data with the outside through communication via a LAN. The communication unit 30 downloads the product data from the file server FS or uploads sales data to the file server FS, for example.

<Operation> The operation procedure of the merchandise sales data totaling system is as follows.
It consists of a price setting process, a product closing / price reduction label issuing process at the sales floor, and a product registration / payment / aggregation process.

(1) Commodity production / processing / pricing process This processing is basically as described in the description of the above-described embodiment of the pricing machine. It consists of processing for issuing an attached price label, attaching the price label to the product, and totaling production / processing data (label issuing data).

The price label is issued by the weighing / packaging / pricing machine AW or the weighing label printer DPS for the weighed products having different quantities and prices for each product, and is issued by the flat-rate label printer DP for the flat-rate products. The file server FS stores a PLU file (product file) and a tally file. FIG. 12 shows the PL
It is a table | surface figure which shows the data structure of U file, and the example of data.
As shown in this figure, the PLU file holds, for each product number, a product name including an additional character, a unit price, a tare weight, a validity period indicating a shelf life, and the like. Here, the unit price is
In the case of fixed price products, the price is per item, and in the case of weighed products, the price is per 100 g of net weight. The tare weight is the weight of a package such as a tray in a weighed product. The PLU file is stored in a weighing / packaging / pricing machine AW, a weighing label printer DPS, a label printer DP, and a store controller S as necessary.
C, POS register PR, and handy terminal HT refer to or download and use.

FIG. 13 is a flowchart showing an outline of the procedure of the pricing process. Here, weighing label printer D
The description will be made on the assumption that the pricing process is performed using the PS. In the pricing process, first, a pricing person inputs a product number of a product (step S51). Then, the CPU provided in the weighing label printer DSP reads the product name related to the product number from the PLU file stored in the RAM,
Product data such as unit price and tare weight is read (step S52).

Next, when the pricing person places the product on the weighing section, the weighing label printer DSP measures the weight of the product (step S53), and subtracts the tare weight from the measured weight and the unit price. Then, the price is calculated by multiplication with (step S54). Then, a bar code including data such as a product number, a price, and a date and time of production and other information are printed and a label is issued (step S55).
Finally, the production result data is totaled based on the issued label data, and recorded in the production result totalization file centrally managed on the file server FS (step S56).

FIG. 14 is a table showing a data structure and an example of data of the above-mentioned production result totalizing file. As shown in this figure, the production result totalization file has data items such as a product number, a production date and time division, a production quantity, an amount, and a weight. In this file, the production date and time category is “YYY
Y. MM. DD. Z ", where" YYYY "represents the year," MM "represents the month,
“DD” represents a day, and “Z” represents a time zone in which a product is produced and processed. In the example shown in FIG. 14, one day is divided into four time zones, and “Z” is “1”, “2”, “3”, “4”.
4 values can be taken, and “1” is 0
Hours to 6:00, "2" is from 6:00 to 12:00, "3" is from 12:00 to 1
At 8:00, “4” represents each time zone from 18:00 to 24:00. It should be noted that the method of dividing the time zone of the production result totaling file is not limited to the time interval of 6 hours as in this example, and can be changed by setting as appropriate. As described above, the production result totalization file holds the number of products, the total weight, and the total price for each product number and for each production date and time division.

(2) Processing for issuing a product closing / price reduction label When a price reduction label is issued at the handy terminal HT in order to reduce the price of a product whose expiration date is approaching as a product, the issuance data of the label is transmitted and received by the transceiver TR. To the file server FS, and is stored in the price reduction product file on the RAM of the file server FS.

FIG. 15 is a table showing the data structure and an example of data of the price-reduced product file. The data of the product number and the production date / time section of the price-reduced product file is based on the data of the barcode label originally attached to the product and read by the handy terminal HT.
The data of the number of price reductions is the number of price reduction labels issued by the handy terminal HT. The data of the price is the total of the price after the price reduction, and the data of the weight is the total of the weight obtained by dividing the price before the price read by the handy terminal HT by the unit price of the product.

(3) Merchandise registration / payment / aggregation processing For merchandise that customers take from merchandise shelves and purchase, POS
In the register PR, processing of merchandise registration / payment / aggregation is performed. FIG. 16 is a flowchart illustrating the procedure of the merchandise registration / payment process. In this figure, first, the merchandise is registered based on the barcode data read by the scanner unit of the POS register PR (step S61, details will be described later), and this is repeated until all the merchandise registration is completed (step S62). repeat. Next, the total price of the registered merchandise is displayed (step S63), and the settlement process is performed (step S64).

FIG. 17 is a flowchart showing a detailed procedure of the commodity registration processing in step S61. In this figure, first, the scanner unit of the POS register PR reads data such as a product code and a date and time of production from the two-stage barcode added to the product (step S71). Since the same PLU file as that on the file server FS is stored and synchronously updated on the store controller SC,
Next, the expiration date of the product is read by referring to the PLU file on the store controller SC based on the read product code (step S72).

Then, the expiration date is calculated by adding the expiration date read from the PLU file to the production date / time division data read from the bar code of the product, and the expiration date is compared with the date and time of the clock held in the POS register PR. By doing so, it is determined whether or not the product has expired (step S73). If the expiration date has expired, a warning is displayed to notify the operator of the POS register of the expiration date, and a warning sound is generated (step S74).
If it has not expired, then read the barcode 2
Based on the data in the row, it is determined whether or not the product has a price reduction (step S75). If the product is a price reduction product, a process of calculating the price after the price reduction is performed (step S76). Finally, the sales result data file described later is updated for the product registered here (step S77).

FIG. 18 is a table showing a data structure and an example of data of the sales performance data file. As shown
This sales performance data file holds, for each product number and for each production date and time section, the number, amount, and weight of items sold without price reduction and those sold with price reduction. Data in which the item of the price decrease is "0" indicates "no price reduction", and data in which the value of the price decrease is "1" indicates "the price is reduced". During the registration process described above,
The amount and weight are added and the file is updated. At this time, the weight is calculated by dividing the price before the price reduction read from the upper row of the barcode by the unit price read from the PLU file.

By using the system as described above, firstly, when reading a barcode with the POS register PR or reading a barcode with the handy terminal HT, a product whose expiration date has expired is automatically determined and a warning is issued. It is possible to emit. Secondly, it is possible to grasp the sales without price reduction and the sales due to price reduction for each product and for each production date and time section (time zone). Further, by making a determination based on such data, it is possible to optimize the timing of price reduction and the price reduction width.

Third, by taking the difference between the actual production amount read from the production actual totalization file and the actual sales amount read from the actual sales data file for each product and for each production date and time section, loss products that become unsold are obtained. The amount of money can be grasped. In addition, for such a loss product, it is possible to perform automatic disposal processing such as accounting for a loss in accounting. In addition, as a method of grasping the amount of the loss product, the difference between the price after the price reduction read from the price reduction product file and the sales price due to the price reduction sales read from the sales performance data file is calculated for each product and for each production date and time section. You may do it. In any case, it is also possible to manage the quantity of the lost product not only by the amount but also by the number and weight of the products. in this way,
Automatic management of loss products from various angles becomes possible.

Fourth, since the number of unsold products can be grasped online in real time by the same calculation processing as the above-described method for each product and each production section, the determination is made based on such data. By doing
The timing of additional production, the amount of additional production, and the timing of price reduction can be optimized.

<Supplement> Although the embodiment of the present invention has been described above, the product sales data management system according to the present invention is not limited to the above-described embodiment. For example, the following modifications and applications are also possible.

(1) Instead of reading a barcode added to a discount target product and issuing a discount label based on the barcode data, a discount label (second label) is printed and prepared in advance. In advance, the discount label may be attached to the product when the price reduction occurs. At this time, the discount label prepared in advance does not have the price reduction date / time information. Specifically, the production time code “HH” and the production date code “DD” of this discount label are both fixed values of “00”, and the production month code “MM”
Is one of "20", "40", and "60". If the production month code “MM” is “20”, the second price code is a code of “discount amount”, and if it is “40”, the second price code is a code of “discount%”. And "60" indicates that the second price code is a "price reduction price" code. This preprinted discount label may be mixed with a normal discount label having date and time information. In this case, the value of the manufacturing month code “MM” distinguishes between the preprint discount label and the normal discount label. .

In the case of this embodiment, data such as the number of price cuts without date and time information is not reflected on the price cut product file, and the sales performance data file is not aggregated by production date and time category. Although processing using these data, such as disposal processing, cannot be performed, it is not necessary to scan a barcode on the label of a product when printing a price reduction label.

(2) As another embodiment, a price reduction label may be issued using the code of the manufacturing date / time information of the bar code in the second row as information representing the price reduction date / time. At this time, according to the value of the production month code “MM”, the barcode data of the price reduction label has the following meanings. When “MM” is “21” to “32” → At the same time that the second price code is a code of “discount amount”, the numerical value obtained by subtracting “20” from the numerical value of “MM” is Represents the month of price cut. When "MM" is between "41" and "52" → It indicates that the second price code is the code of "Discount%", and at the same time, the value obtained by subtracting "40" from the value of "MM" is Represents the month of price cut. When "MM" is "61" to "72" → At the same time that the second price code is a "price reduction price" code, the value obtained by subtracting "60" from the value of "MM" is the relevant product Represents the month of price cut. Further, the production date code “DD” takes a value in the range of “51” to “81”, and a numerical value obtained by subtracting “50” from the numerical value of “DD” represents a price reduction date of the product. Also, the production time code “HH”
Represents the price reduction time of 00 minutes every hour from “01” to “24”,
A barcode representing a 30 minute hourly price reduction time is printed from “31” to “54” to which “30” has been added. For example, when the production time is 15:00, the production time code “HH” is “15”, and when the production time is 15:30, it is “45”.

Since the price label of the production date and time information is used to represent the date and time of the price reduction as described above, this price reduction label is used in combination with a price reduction label of the type having production date and time data in the code of the production date and time information. Is not done. This price reduction label is affixed over the second barcode originally attached to the product,
The date and time of manufacture recorded in the original barcode cannot be directly acquired by scanning. However, by managing the relationship between the production date and time and the price reduction date and time in the manner described below, it is possible to substantially grasp the production date and time division, and therefore, the production quantity and production quantity for each production date and time division can be obtained. The above-described automatic disposal can be performed based on the information on the amount of money.

FIG. 19 is a table showing the data structure and data example of the price reduction data file. As shown in this figure, the price reduction data file has data items such as a product number, a discount date / time category, a production date / time category, a price reduction quantity, an amount, and a weight. It is possible to manage the discount date / time category, the number of products, the amount of money, the weight, etc. for each category. Here, by managing the product so that the production date / time section is uniquely determined from the product number and the discount date / time section, even if the price reduction label is attached so as to overlap the second row of the original barcode, The production date / time division can be grasped from the scanned barcode data and the data of the price reduction data file.

Further, by using the above-mentioned price reduction data file, it is easy to summarize the data for each discount date and time division, and it is possible to optimize the timing of the price reduction based on this data. .

(3) For the purpose of improving the bar code reading rate, the following reading method may be adopted. FIG. 21 is a reference diagram showing a method of reading a barcode by a barcode scanner. For example, FIG.
As shown in (a), when the reading laser beam crosses along the direction of the broken line 211, the first half 201 and the second half 202 of the bar code can be read at once. However, depending on the direction of the product read by the barcode scanner, the reading as shown in FIG.
As shown in (b), the reading laser beam traverses along the direction of the broken line 212, and the first half 201 of the bar code is read.
In some cases, only the bar code can be read, or as shown in FIG. 21C, the reading laser beam crosses along the direction of the broken line 213, and only the second half 202 of the bar code can be read. Therefore, even when the first half part 201 and the second half part 202 are read separately, by performing the merchandise registration process together with the information, the number of rereads due to reading errors is reduced, and the reading rate of the entire barcode is reduced. It is possible to improve the efficiency of the merchandise registration / payment operation in the POS register.

By the way, in the case where a two-stage barcode is used as in the present invention and a process of separately reading the first half and the second half of the barcode as described above and making it valid is performed,
The first half (left half) of the barcode (first barcode) on the second row and the second half (right half) of the barcode (second barcode) on the second row, or the first half of the barcode on the second row There is a possibility that the part (left half) and the second half (right half) of the first-stage barcode may be combined. Therefore, the barcode format shown in FIG. 22 may be used instead of the format shown in FIG. The barcode format in the first row shown in FIG. 22A has a feature that the price code is increased by one digit to five digits instead of eliminating the one-digit "price check digit".
The barcode format shown in FIG.
The two-digit “manufacturing month” is eliminated, and the “second price code” (any of discounted price, discount amount, discount%) is increased by one digit to five digits, and represents the meaning of the “second price code”. There is a feature that a single-digit “section” is provided.

When the “section” is “0”, the “second price code” and “PPPPP” represent the discounted price.
Is “1”, the “second price code” represents the discount amount,
When the "category" is "2", the "second price code" represents a discount%. Further, the value of the “price code” of the barcode in the first row is valid only in the range of “00000” to “49999”, and can represent a price up to 49999 yen. Further, the value of the “second price code” of the bar code in the second row is valid only in the range of “50000” to “99999”, and the value obtained by subtracting 50,000 from this value is the actual price and value after discount. Discount or discount%.

In the case of perishable food products, the shelf life of the product is relatively short, usually about 10 days or less, and the product after that period is discarded. Since the same product as the previous month is not mixed in the store, even if the “manufacturing month” is eliminated as a barcode system as described above, no inconvenience is caused by that.

Further, by adopting the bar code system as described above, the first half of the bar code is set to “flag”.
The first row and the second row can be distinguished by the value of “FF”. In the latter half of the bar code, the most significant digit of “price code” or “second price code” is “0” to “4”. The first stage and the second stage can be distinguished depending on whether the range is "" or "5" to "9". Therefore, even when the first half and the second half are read separately, the first half and the second half are not confused, and the first half and the second half of the first half,
Alternatively, it is possible to prevent the combination of the first half of the second stage and the second half of the first stage from being processed.

(4) In the above embodiment, merchandise sales management is performed using a two-stage barcode. However, the present invention is not limited to this. A merchandise code, a production date and time, a price reduction date and time, a price, and the like are added to the product. Other forms that can be managed by using the same may be used. For example, optically readable code data represented by a two-dimensional pattern, magnetically recorded data, or the like may be used.

(5) In the above embodiment, the NON-PLU barcode in which the price data is recorded in the barcode is used. However, the present invention is not limited to this. Is a PL with no price data recorded
The price data of the PLU file may be read based on the product number in the barcode using the U barcode.

(6) In the above embodiment, the date and time data on the barcode is recorded as month, day, hour, and minute in 30-minute units. Date and time data on a file such as a price reduction data file is "YYY
Y. MM. DD. Although the year, month, day, and time in six-hour units are recorded in the Z ″ format, the present invention is not limited to this, and another system of date and time information may be used.
And any other format is possible and is not limited to these formats. Date only Date + morning / afternoon classification Date + time zone classification (for example, 0:00 to 6:00, 6:00 to
12:00, 12: 00-18: 00, 18: 00-24: 00) Date + hour + 30 minute unit (or 15 minute unit) Date + hour + minute

The date and time may be managed by data substantially equivalent to the date and time information. FIG. 20 is a table showing the structure and data example of a lot number / date and time division correspondence table that holds the relationship between the lot number of the product and the date and time division. As shown in the figure, by referring to this table, the correspondence between the production lot number of the product and the production date / time division of the lot can be known. For example, the lot number is recorded in the barcode of the product, The production date / time division can be known based on the lot number scanned and read.

(7) In the above-described embodiment, the loss data is managed by recording the production result data and the sales result data in files, respectively, and comparing them. By recording data such as the number of commodities to be executed or the number of commodities in the lot, it is possible to manage lost commodities only with the data read from the barcode, and it is not necessary to read the production performance data from the file.

(8) In the above embodiment, the components of the POS system (the LAN in the store) and the components of the perishables system (the LAN in the back room) are connected by the communication network. It is not limited to. For example, a floppy disk or C
Data may be exchanged using a recording medium such as a DR (CD Recordable). As an example, the production result data of the fresh product system (LAN in the back room) may be input to the store controller of the POS system by a floppy disk.

(9) In the above embodiment, the PLU file in the POS register or the weighing label printer D
Although the PLU file in the SP and the price reduction product file in the file server are stored in the RAM, the medium in which various data and files are stored is not limited to this, and another storage medium may be used. The other storage medium is, for example, a magnetic tape, a magnetic disk, or an optical disk, but is not limited thereto.

(10) In the above embodiment, the data of the production date and time of the product is recorded in the barcode. However, the present invention is not limited to such date and time management. Date and time data such as an expiration date and a quality retention expiration date may be recorded in the barcode, and sales management of the product may be performed based on these dates and times.

[0111]

As described above, according to the present invention, a bar code label which records information of a product code, a normal selling price, a production date or a shelf life date, and a price reduction data of a selling price for a product to be sold at a reduced price. Is attached, so that it is possible to surely reduce the selling price simply by reading it in the register, and to supply the register with information on the date of manufacture or the expiration date of the product and the price reduction data. . As a result, the information can be stored and accumulated, and the degree and timing of the price reduction can be examined, and the effect that the sales strategy can be easily set can be obtained.

Here, the new label to which the price reduction data has been added is attached so as to have a portion that overlaps the old label, so that an increase in the area that covers the surface of the product can be reduced.

Further, by summing up sales data for each production date and time zone based on sales management data such as the production date and time included in the barcode, sales data management for each fresh food production time zone is performed. Can be done easily. For example, by summing up sales data for each production date and time zone and comparing it with the production result data, the number of products sold and the number of unsold products produced on the production date and time zone can be determined. For this reason, data for optimizing the production plan and optimizing the closing timing can be obtained, and rational production and closing processing can be performed.

Further, by accounting for unsold products whose expiration date has expired as loss, automatic disposal can be performed. Furthermore, it is possible to automatically check for expired products using the production date and time data. If the barcode further includes a discounted price, the sales volume of the normal price and the sales volume of the discounted price of the product manufactured on the same production date and time zone can be totaled.

In particular, according to the first or second aspect of the present invention, the bar code added to the product includes data for product registration and settlement including an identification code of the product and date and time information related to sales management of the product. The product registration and production process is performed using the product registration and settlement data, and sales, quantity, weight, etc. are totaled for each date and time using the sales management data. Using the date and time information included in the sales management data to manage and check the expiration date and expiration date of the product, and using the date and time information included in the sales management data to reduce the closing price of unsold products and record losses Processing can be performed automatically, and it can also be used to support store management decision-making, such as planning sales strategies and tactics based on the aggregated data. .

According to the third aspect of the present invention, since the merchandise registration settlement data and the sales management data are recorded as separate bar codes, one of the data is independently replaced with the other data. It becomes possible. Specifically, for example, by attaching a bar code label representing new data over one of the bar codes, updating the data without changing the data of the other bar code This can be applied to, for example, a change in sales price due to the closing of a fresh product or the like.

According to the fourth aspect of the present invention, the number of unsold products, the amount of money, the weight, and the like can be calculated by calculation based on the actual production data and the sales total data of the products. In the management, it is possible to save the trouble of counting the actual number of commodities and reading the barcode added to those commodities.

According to the fifth aspect of the present invention, since the number of unsold products, the amount of money, the weight, etc. of the product can be calculated based on the actual production data and the total sales data of the product, the sales management can be performed. Since the date and time information included in the application data is used, it is possible to eliminate the trouble of counting the actual number of discarded products and reading the barcode added to those products in the disposal process.

According to the invention described in claim 6, a label on which the first and second barcodes are printed is issued by the label printer, and the first and second barcodes on the label are put on the commodity. It is read by reading means provided in the sales data processing device, and performs registration processing and settlement processing of goods based on the read first barcode, and also tabulates goods registered based on the second barcode. Therefore, it is possible to automate the registration, settlement, and tallying of commodities, thereby making it possible to save labor in these processes.

According to the seventh aspect of the present invention, in the merchandise sales data processing device, the registered or sold merchandise is registered based on the date and time information included in the sales management data represented by the second barcode. Counting the actual number of products in the management of unsold products, because the unsold data can be calculated by referring to the production performance data associated with the date and time information. It is possible to save the trouble of reading the barcode added to those products.

Further, according to the invention of claim 8, the merchandise sales data processing device converts the sales total data of the merchandise and the production result data associated with the date and time information included in the sales management data of the merchandise. Based on this, it is possible to automate the disposal process that records losses for products that have passed a predetermined deadline, eliminating the need to count the actual number of discarded products and read the barcode added to those products Becomes

According to the ninth aspect of the present invention, since the production result data of the product is printed on the label, the production result data can be directly obtained by reading the data from the label. There is no need to refer to data recorded separately in a file or the like.

According to the tenth aspect of the present invention,
By reading the second barcode, it is possible to determine whether the product is a discount product and to obtain data on the discount price, so that the discount process at the time of registration and settlement can be automated. Become. Also, since it is counted separately whether or not discounted sales have been made, it is possible to grasp the amount and amount of products discounted based on the aggregated data, which can be useful for store management decision making support Become.

According to the eleventh aspect of the present invention,
The data indicating that the product is a discount product and the data related to the discount price are printed on a second label that is separate from the first label, and the second label is affixed to the first label in an overlapping manner. The price information printed on the first label is updated with the discount price information printed on the second label, and the discount processing in the registration processing and the settlement processing can be automated.

According to the twelfth aspect of the present invention,
The production results for each product and each date and time information are stored by the production results data storage means, the sales for each product and each date and time information are totaled by the totaling means, and the totaled results are stored by the sales result data storage means, Based on the production results stored by the data storage means and the sales results stored by the sales result data storage means, it is possible to calculate and manage the unsold amount and the amount of money for each product and date and time information. In the management of (1), it is possible to save the trouble of counting the actual number of commodities and reading the barcode added to those commodities.

According to the thirteenth aspect of the present invention,
The expiration date of the product can be known based on the production date and time information and the expiration date information, and it is possible to automate the disposal process that records the loss of the product whose expiration date has passed, and can count the actual number of products or apply them to those products. It is possible to save the trouble of reading the added barcode.

According to the fourteenth aspect of the present invention,
Based on the unsold data calculated by the unsold data calculation means, in order to record a loss for the unsold product after a predetermined time limit, in the disposal process, the actual number of the products is counted or added to those products. It is possible to save the trouble of reading a barcode.

According to the fifteenth aspect of the present invention,
It is possible to affix the discount label printed by the discount label printer over the original label, so by attaching this discount label, it is easy to price the discount price by closing the product etc. Become
In addition, it is possible to automate the discount processing in the registration processing and the payment processing of the product.

Further, according to the nineteenth aspect,
In the merchandise sales data processing device, the price of the merchandise is obtained based on the identification code of the merchandise obtained from the first barcode, or the price of the merchandise is obtained directly from the first barcode. The product registration and settlement processes are automatically performed using the price and the price, and the counting process is performed based on the date and time information obtained from the second barcode. And the like, and the collected data can be used for the management decision-making support of the store.

[Brief description of the drawings]

FIG. 1 is a diagram showing an example of a retail store to which a commodity pricing device according to an embodiment of the present invention is applied.

FIG. 2 shows a label printer LP constituting an equivalencing apparatus.
It is an electric block diagram of.

FIG. 3 is an electric block diagram of a handy terminal HT constituting the equivalencing device.

FIG. 4 is a diagram showing a barcode format in the same value assigning device.

FIG. 5 is a flowchart illustrating a procedure of a first label issuing process performed by the label printer LP.

FIG. 6 is a diagram showing an example of a first label issued and affixed to a product.

FIG. 7 is a flowchart showing a procedure for issuing a second label by the handy terminal HT.

FIG. 8 is a diagram showing an example of a second label issued and affixed on the first label.

FIG. 9 is a plan view showing an arrangement in a fresh food sales store to which the merchandise sales data totaling system and the merchandise sales management method according to one embodiment of the present invention are applied.

FIG. 10 is a block diagram showing a configuration of a data processing system according to the same embodiment.

FIG. 11 is an electrical configuration diagram of a POS register according to the same embodiment.

FIG. 12 is a table showing a data configuration and a data example of a PLU file (product file) in the embodiment.

FIG. 13 is a flowchart showing an outline of a procedure of a pricing process in the embodiment.

FIG. 14 is a table showing a data configuration and a data example of a production result totalization file in the embodiment.

FIG. 15 is a table showing a data configuration and a data example of a price-reduced product file in the embodiment.

FIG. 16 is a flowchart showing an outline of a procedure of merchandise registration / payment processing in the embodiment.

FIG. 17 is a flowchart showing a detailed procedure of a commodity registration process in the embodiment.

FIG. 18 is a table showing a data configuration and a data example of a sales performance data file in the embodiment.

FIG. 19 is a table showing a data structure and a data example of a price reduction data file in the embodiment.

FIG. 20 is a table showing a data configuration and a data example of a lot number / date / time classification correspondence table in the embodiment.

FIG. 21 is a reference diagram showing a state of scanning a barcode by a laser beam of a barcode scanner.

FIG. 22 is a diagram showing another form of a barcode format according to the present invention.

[Explanation of symbols]

 1, 10, 21 CPU 2, 11, 22 ROM 3, 12, 23 RAM 4, 13, 24 Display unit 5, 14, 25 Operation unit 6, 15, 26 Printing unit 8 Clock 16 Barcode scanner 28 Clock unit 29 Scanner Unit 30 Communication unit AW Weighing / packaging / pricing machine DP Label printer DPS Weighing label printer FS File server HT Handy terminal LP Label printer N1 LAN in back room N2 POS system (LAN in store) PR POS register SC Store controller TR Transceiver

Claims (19)

[Claims] The bar code is read from a product to which a bar code including data for product registration and settlement including an identification code of the product and sales management data including date and time information on sales management of the product is added, and the identification is performed. A merchandise sales management method comprising: performing merchandise registration processing and settlement processing based on a code; and totalizing the merchandise registered in the registration processing based on the sales management data. 2. The barcode is read from a product to which a barcode representing a product registration and settlement data including a product identification code and price information and a sales management data including date and time information on sales management of the product is added. A merchandise registration process and a settlement process based on the identification code and the price information, and totalizing the merchandise registered in the registration process based on the sales management data. 3. A first bar code representing merchandise registration settlement data including a product identification code and price information, and a second bar code representing sales management data including date and time information relating to sales management of this product. From the added product, the first
Reading the bar code and the second bar code,
The merchandise registration processing and the settlement processing are performed based on the first barcode, and the merchandise registered in the registration processing is totaled based on the sales management data represented by the second barcode. Product sales management method. 4. Based on sales total data of a product obtained as a result of aggregation based on the sales management data and production performance data associated with the date and time information relating to sales management of the product, unsold data of the product is obtained. The product sales management method according to claim 1, wherein the calculation is performed. 5. A predetermined time limit has passed based on sales summary data of a product obtained as a result of aggregation based on the sales management data and production performance data associated with the date and time information on sales management of the product. The method according to claim 4, wherein a disposal process for recording a loss on the product is performed. 6. A first barcode representing merchandise registration settlement data including a commodity identification code and price information, and a second barcode representing sales management data including date and time information relating to sales management of the commodity. A label printer for printing on a label, a label on which the first barcode and the second barcode are printed by the label printer, and reading the first barcode and the second barcode from the label A reading unit that performs a registration process and a settlement process of a product based on the identification code represented by the first barcode read by the reading unit and the price information, and performs the second reading process by the reading unit. Merchandise sales data for performing an aggregation process of merchandise registered in the registration process based on the sales management data represented by the barcode of Commodity sales data tabulation system, characterized in that it consists of a physical device. 7. A first barcode representing merchandise registration settlement data including a product identification code and price information, and a second barcode representing sales management data including date and time information relating to sales management of this product. A label printer for printing on a label, a label on which the first barcode and the second barcode are printed by the label printer, and reading the first barcode and the second barcode from the label A reading unit that performs a registration process and a settlement process of a product based on the identification code represented by the first barcode read by the reading unit and the price information, and performs the second reading process by the reading unit. Performing a totalizing process of the products registered in the registration process based on the sales management data represented by the barcode of A product sales data processing device for calculating unsold data of the product based on the sales total data obtained as a result and the production result data associated with the date and time information relating to the sales management of the product; Data aggregation system. 8. The merchandise sales data processor based on sales total data of a product obtained as a result of the totalization based on the sales management data and production result data associated with the date and time information on sales management of the product. 8. The merchandise sales data totaling system according to claim 7, wherein a discarding process for recording a loss of the merchandise after a predetermined time limit is performed. 9. The merchandise sales data totaling system according to claim 7, wherein the label printer prints a barcode representing the production result data on a label. 10. The second barcode further represents data indicating whether or not the product is a discount product and data regarding a discount price, and the product sales data processing device is read by the reading unit. It is determined whether or not the product is a discount product based on the second barcode, and a discount process is performed in the registration process and the settlement process according to the determination result.
The merchandise sales data totaling system according to any one of claims 6 to 9, wherein, in the totalizing process, the totaling is performed while distinguishing whether or not the discount has been made. 11. A first barcode representing merchandise registration settlement data including a commodity identification code and price information, and a second barcode representing sales management data including date and time information relating to sales management of this commodity. A second barcode printed on the first label at a first timing by the label printer and representing data indicating that the product is a discount product and data relating to a discount price is different from the first timing. The second at the second timing
The merchandise sales data totaling system according to claim 10, wherein the second label is printed on the first label, and the second label is attached on the first label. 12. A first barcode representing merchandise registration settlement data including a commodity identification code and price information, and a second barcode representing sales management data including date and time information relating to sales management of the commodity. A label printer for printing on a label, production result data storage means for storing the result data of the barcode printed by the label printer for each product and for each date and time information, and the first barcode based on the label attached to the product Reading means for reading the second barcode; and registration adjustment means for performing registration processing and adjustment processing of a product based on the identification code represented by the first barcode read by the reading means and the price information. And the second barcode read by the reading means displays the sales of the goods registered by the registration settlement means. Totaling means for totalizing date and time information, sales performance data storage means for storing the results totalized by the totaling means, storage contents of the production performance data storage means and storage contents of the sales performance data storage means A product sales data totaling system, comprising: unsold data calculating means for calculating unsold data for each product date and time information; and output means for outputting the calculation result of the unsold data calculating means. 13. The date and time information is information indicating the date and time of production of a product, and includes a best-before period storage unit that stores a best-before period for each product; A expiration date calculation unit that calculates the expiration date on the basis of the unsold data calculated by the unsold data calculation unit, and a discarding unit that records a loss for a product whose expiration date has passed based on the unsold data for each date and time information calculated by the unsold data calculation unit. 13. The merchandise sales data totaling system according to claim 12, wherein: 14. The apparatus according to claim 12, further comprising a discarding unit that records a loss for a product that has passed a predetermined time limit based on the unsold data for each date and time information calculated by the unsold data calculating unit. Item 14. A merchandise sales data totaling system according to item 13. 15. A discount label printer that prints the second barcode representing data indicating that the product is a discount product and data relating to a discount price on a discount label, and affixes the discount label on the label. The merchandise sales data totaling system according to any one of claims 12 to 14, wherein: 16. A first barcode representing merchandise registration settlement data including a product identification code and price information, and a second barcode representing sales management data including date and time information relating to sales management of the merchandise. A label printer for printing on a label. 17. A merchandise package to which a barcode representing merchandise registration settlement data including a merchandise identification code and price information and sales management data including date and time information relating to sales management of the merchandise is added. 18. A first barcode representing merchandise registration settlement data including a commodity identification code and price information, and a second barcode representing sales management data including date and time information relating to sales management of the commodity. A merchandise sales management method, wherein a label on which the first barcode and the second barcode are printed is printed and affixed to a merchandise using a label printer that prints on the label. 19. A first barcode and a second barcode are read, an identification code of a product is obtained from the read first barcode, and the product is read or read based on the obtained identification code. Product price information is obtained directly from the first barcode, product registration processing and payment processing are performed based on the identification code and the price information, and product sales management is performed from the read second barcode. A merchandise sales data processing apparatus, which acquires date and time information about the merchandise, and totals the products registered in the registration process based on the date and time information.