JP2000048262A - Goods storage management system for shop - Google Patents

Abstract

PROBLEM TO BE SOLVED: To enable the collation of goods on a display rack in a shop such as a supermarket or a convenience store (including a discount store) to an amount of stock at the point of time when the goods pass a cash register, to make it possible to instantaneously grasp sales of the goods, to suppress sales loss by abandoning dead stock in the shop, to improve work efficiency in the shop, to make it possible to grasp the movement of the goods on the display rack and to make it possible to attain efficient management of the shop and low costs by linking with adjustment at a cash register. SOLUTION: A weight sensor 8 for goods and a CCD camera 9 are arranged on each rack plate 7 of a display rack in a shop, a free, long display 10 which is flexible and of the same length as that of a front side of each goods is provided on the front of each goods, results of goods in-store movement and sales are collated to each other in real time, work efficiency in the shop is improved, sales loss in the shop is suppressed, dead stock in a storage is reduced, a redundant work such as a change in a rack label is eliminated and ordering of an appropriate replenishment amount can be performed.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION The disclosed technology belongs to the technical field of an appropriate management system of merchandise on display shelves of retail stores such as supermarkets and convenience stores (including descant stores) and inventory of all stores.

[0002]

2. Description of the Related Art As is well known, the improvement of the life of citizens has greatly improved in terms of mass, and various kinds of daily necessities have been distributed by supermarkets, convenience stores (including descant stores) and other retail stores. Large quantities and small quantities are handled in the secondary market, and customers freely purchase the necessary products at retail stores such as supermarkets and convenience stores (including descant stores).

[0003] A desired product is taken out of the products placed on a predetermined number of display shelves arranged in the sales department of the store, the product is put into a shopping basket or the like, and the cashier goes to a cash register. At the cash register, a mode of paying an amount and purchasing the product is general.

[0004] However, due to seasonal fluctuations and the like, the customer does not always purchase all types of products on average. Therefore, the products placed on the display shelf are not always sold. It is inevitable that the number of sales fluctuates depending on the season and day.

[0005] On the other hand, in stores such as supermarkets and convenience stores (including descant stores) on the sales side, all products are not in a predetermined stockout state but are put in a sufficient stock state on average, and customers purchase the goods. In general, it is common practice to make sure that there are no inconveniences at the supermarkets and convenience stores (including descant stores). In order to deal with this, it is safe to replenish only the number of sales at the supermarkets and convenience stores (including descant stores). (Point of Sales) Customer pays at the cashier from the cashier At this point, the barcode of the product is read, the read data is sent to the computer, the number of sales of the product is counted, the number of replenishments is counted against the theoretical stock, the number of replenishments is created, the order data is created, and the replenishment amount is calculated. It is only necessary to adopt a mode in which the product is sent to the back yard or the like of the store, but this is all performed by prediction.

[0006]

However, in the conventional inventory management system, the customer pays at the cash register, and at the time when the data obtained by the barcode of the product is generated, the product on the display shelf is generated. I do not know the inventory of
It is not possible to immediately understand the sales of the product as a whole company, and therefore it is not possible to determine whether the number of sales is in a state of replenishment required at the time of passing the cash register of the product, even with a computer At headquarters, etc.
When the customer passes the actual cash register at all stores, there is a time lag that the sales quantity of the sold product can not be used as ordering data for immediate replenishment, so the replenishment quantity of inventory minus the number of sales is ordered There is a drawback in that it is not possible to transmit the order data to a supplier or the like who is an order receiver of a maker or the like as data so that a product shortage state on the display shelf does not occur.

[0007] Generally, in stores such as supermarkets and convenience stores (including descant stores), the person in charge of selling cash registers and the like and the person in charge of ordering terminals are different. At the end of sales, the sales department checks the number of items on each display shelf, that is, the number of missing items, and counts the number of items in stock. Minus the number sold,
There has been no alternative but to send the order data to the supplier as the order data for the replenishment number, using the number of remaining items as the numerical value of the stock amount.

[0008] Each display shelf is provided with a shelf label indicating the product name, price, and the like of the product, attached to the shelf, and the display shelf stores the product for each product. Since there is a so-called shelving work that determines the space, it is indiscriminately impossible to replenish the missing item, and therefore, when relocating the product, it is necessary to confirm the location of the product. There is a problem that it takes time and labor, and there are "sellable goods" and "dead goods" in the store, and the confirmation of both persons in charge requires extremely skill, and the work becomes complicated. As a result, there is a demerit that the work of replenishing missing goods on the display shelf in the store causes an increase in cost.

Further, as described above, the consistency of the data handled by the salesperson and the ordering person at the cash register is not sufficiently matched, and therefore, in order to prevent the out-of-stock condition, the order data is consequently less than the number of missing items. Overstocking has led to an increase in inventory in the distribution center and the backyard of the store, eventually leading to dead stock, which often has the disadvantage of deteriorating business conditions.

[0010] As a possibility, there is a lot of product loss (theft, shoplifting, etc.) in the store, and it is difficult to accurately obtain the stock amount and the order amount, which adversely affects the store management. Was.

[0011]

It is an object of the invention of the present application to generate dead stock due to mismatching of sales data and order data at a cash register of a retail store based on the above-mentioned conventional technology, and to confirm the location of a product by a label shelf label or the like. The technical problem to be solved is the adverse effect on the business due to the complexity of the work and the shelving of the shelves, etc., and does not directly send the replenishment order data of all stores owned by the store or the headquarters to the business partner. , The sales transition from the time of the previous delivery to the time of the order is matched with the sales data, collated, the period is confirmed, the order quantity is corrected appropriately, and the order is placed with the business partner at that time. In this way, an object of the present invention is to provide an excellent merchandise inventory management system for a store that benefits the merchandise management technology application field in the distribution industry.

[0012]

[Means] In order to manage product inventory at each store owned by distribution centers such as supermarkets and convenience stores (including descant stores), use the sales data and ordering data systems that have been used before,
In order to optimize inventory in the backyard of stores, etc.
A system for transmitting merchandise sales data from a store cash register to a computer and transmitting merchandise order data from a merchandise ordering terminal to the computer to perform inventory management of merchandise on display shelves in a merchandise sales department. A product movement detection sensor is provided on the shelf of the display shelf to detect the movement of the product, and a display electrically connected to the product movement detection sensor is provided on the front surface of the end of the shelf. It is based on the fact that the commodity data can be displayed freely and that it has a data storage (buffering) function and is connected to the above-mentioned computer. The product data can be processed freely, and the product movement detection sensor can be a weight sensor.
Also, the product movement detection sensor may be a small CCD camera, and in addition, the display may be a flexible, free and long size display having a length equal to the length of the front end of the shelf board. If, in addition, the display is a plasma or liquid crystal, the display indicates the name of each product, the unit price, and the number of shelves and the total weight or form of the products placed on the shelf. It takes technical measures to make it memorable.

[0013]

In the above configuration, the host computer of the headquarters calculates the number of stocks for each product in all stores based on order data from the stores, calculates the number of stores ordered for each product, and calculates the total number of ordered products. Calculate not a few items, calculate items with a smaller number of ordered stores, reserve the total inventory for each ordered product at all stores, check the sales period for each product store, Hosts that extract products with long sales periods, move products from other stores with large inventory to the ordering store, and suspend orders for stores with long suspension periods and small order volume, Orders are sent to trading partners as order data for each store from the computer, and at the time of delivery, the products delivered from the suppliers are checked at the distribution center, and the data for the stores that have been confirmed to be delivered are created, and the business of the trading partners is created. Of creating a shortage data, and sends it to the shop an order delivery customer information at the time of arrival of goods, to update the distribution centers and stock Fairu of each store, shop of Po
Based on the S (Point of Sales) data, the sales quantity is matched to the item of the delivered product, and the store creates a stock quantity table of the display shelf products of the sales department in accordance with the delivery, so that the inventory of all stores can be checked. Leveling, reducing defective inventory, improving the efficiency of logistics, preventing loss of sales opportunities, inventorying at stores every day is possible, the actual number of products can be grasped, and excess inventory and loss are prevented. It is something that can be done.

[0014]

DESCRIPTION OF THE PREFERRED EMBODIMENTS Embodiments of the present invention will be described below with reference to the accompanying drawings.

The illustrated mode is a management mode in an information system headquarters having a plurality of retail stores such as a supermarket and a convenience store (including a descant store), and 1 is a product of the store which is the center of the gist of the invention of this application. This is an inventory management system. In this embodiment, it is an embodiment of the merchandise inventory management system of the headquarters. The computer 2 installed in a predetermined manner in the backyard or the like of the store has a PoS (Point of Point) as in the conventional embodiment.
(Sales) A cash register 3 and an order terminal 4 are connected to the computer 2 in a wired or wireless manner so that data can be transmitted and received.

In the invention of this application, the display shelf 5 of the store is connected to the computer 2 so as to be able to transmit data as described below, and the computer 2 of the store is connected to the host of the headquarters. The computer 6 is also electrically connected to each other so as to freely transmit and receive data.

Thus, in the embodiment shown in FIG. 1, only one display shelf 5 is shown, but as is well known, a large number of display shelves 5, 5... Each of the display shelves 5 is connected to the computer 2 so as to freely transmit and receive the data as described below.

As shown in FIG. 2, a predetermined number of shelves 7 of each display shelf 5 are provided.

【I】,

As shown in (b), weight sensors 8, 8 such as small load cells, which can individually detect a change in weight due to taking out of the product or the like, corresponding to each product placed on each shelf plate 7, are embedded.

The sequence is set as shown in [A].

As shown in [b], small CCD cameras 9, 9... Are arranged and set so as to be able to individually detect changes in the movement of goods and the like, similarly to the weight sensors 8, 8, and each of the shelves 7 On the end face of the front end, a flexible, long-sized plasma or liquid crystal display 10 having the same length as the length of the shelf 7 is attached, instead of a display representing a numerical value in a simple manner such as a conventional mode. The display 10 and the sensors 8 and 9 for detecting a change in the movement of the product are electrically connected to each other by a lead wire 11.

As shown in (c), the display area 11 for characters of each product and the display area 12 for numbers are formed on the display 12 so that each product can be displayed. , 12 can be stored), and the data is connected to the computer 2 so that the data can be freely transmitted and received.

Therefore, in the conventional mode, as described above, when ordering work, the display shelves 5, 5,. At the time of loss due to shoplifting, etc., it is difficult to catch who was involved in the occurrence of the loss-related situation, but the change state of the product, that is, the display state of each product on the shelf 7 can always be grasped. In addition, the payment data at the cash register can be linked with the transmission to the computer 2 by PoS (Point of Sales) 3.

The total weight or total form (in the case of a CCD camera) of the goods placed on each shelf 7 can be stored by a buffering function, and the stored data can be stored in the computer 2.
When the customer takes out the product from the shelf 7 of each display shelf 5, the change data of the change in weight or the change in the installation form of the product is transmitted to the computer 2. The computer 2 receives the stored product movement information from the display 10 and files it every hour.

When the customer pays for the purchased product at the cash register, the data of the product name and quantity are stored in PoS (Point).
of Sales 3) to the computer 2 and the change data of the stocked goods from the display 10 are transmitted. At that time, the matching check of the goods movement data and the sales data is performed, and the purchased goods are registered. You can also check that you have passed.

Through such a process, the movement of goods in the store is constantly matched with the sales result, thereby improving the work efficiency in the store and reducing the loss and dead stock in the store. Work such as checking and changing the shelf label is also eliminated, and an optimum order can be placed for the supplier.

In addition, the work of label pasting and the work of splitting the shelf are eliminated, and the change of the product on the shelf plate 7 can be smoothly performed, so that the increase in the cost of the work in the store can be suppressed.

The flow of the data processing system will now be described with reference to the flowchart of FIG. 3. If the order data of the store is not transmitted as it is to the trading partner as it is in the conventional manner, By checking the change in sales up to the time of ordering this time with the sales, confirming the period, correcting the appropriate order quantity, and placing the order, the computer 2 in the system headquarters of the company concerned (1) As shown in step (2), order data from each store is collected, and the computer 2 of the store and the host computer 6 installed in the headquarters are integrated with the merchandise of all stores as shown in step (2). In step (3), the number of ordering stores for each product is calculated. In step (4), although the total number of orders is small, (The process is performed by determining a constant with a large or small total number of orders.) In the step (5), calculation of a store with a small number of ordered stores (a small number with a large number of stores) is performed. Is determined by determining a constant), and in the step (6), allocation is made for each product item of all stores and the total stock, and the next (7)
In the step of (1), the sales period of each store of the item is checked. In the step (8), the inventory of the store where no order is placed or the item whose sales period is long are extracted. Data processing is performed so that the product is moved from a store with a large stock, such as stock, to the store where the order was placed. In the step (10), an order is placed for a store with a long sales suspension period and a small order quantity Then, in step (11), order data for the store is created, and in step (12), the order data is used as the order data for each store. Performs order data processing for.

In the step (14),
The distribution center checks the products delivered from each trading partner to the store. In step (15), the process of creating delivery confirmation data is performed. In step (16), product-specific data for each trading partner is determined. It performs data creation processing of the stockout rate and transmits the data to the host computer 6 of the headquarters,
In the step (17), the delivery of the ordered product and the information of the business partner are transmitted to the store upon arrival of the product, and (1)
In the step (8), data processing for updating the stock file of the headquarters and each store is performed, and in the step (19), the PoS (Point of Sal) of each store is updated.
es) Based on the data, matching processing of the sales quantity from the order to delivery of the delivered item is performed. In step (20), a stock quantity table of the sales floor of the delivered product is created in each store.

With such a system, inventory at all stores can be leveled, defective inventory can be reduced, distribution can be made more efficient, sales chance loss can be prevented, and inventory at each store can be taken every day. The actual number of sales can be grasped, and excess inventory and sales loss can be prevented.

It should be noted that the embodiments of the invention of this application are not limited to the above-described embodiment, and various modes such as one retail store instead of a plurality of retail stores can be adopted.

[0028]

As described above, according to the invention of this application, it is possible to improve the ordering system by using the sales data and ordering data of the system currently implemented, and to optimize the store inventory and the total inventory. In addition, there is an excellent effect that simplification of the shelving operation and affixing of the shelf label can be omitted, and loss in the store can be reduced.

In addition, the sales transition from the last delivery of the product to the present order can be compared with the sales data, the period can be checked, and the correct order quantity can be obtained and the corrected order can be placed. Also, there is an excellent effect that dead stock such as defective stock can be reduced.

Since the sales data of the merchandise passing through the cash register can be matched with the shelf stock movement data of the store, it is possible to catch merchandise loss such as shoplifting or theft in real time, which has the effect of adding to store management.

Thus, when the cash is settled at the cash register, the stock of the product on the display shelf can be immediately known, and the sales of the product can be immediately grasped. By connecting the display shelf to the computer of the store, Thus, an excellent effect that the movement of the product on the display shelf can be always grasped can be obtained.

Therefore, it is possible to abolish the labeling of the shelf on which the product name and the price are displayed, to simplify the work of allocating the shelves and changing the shelves, etc. Reduction, dead stock phenomenon,
This also has the effect of reducing in-store losses and enabling early confirmation of product storage locations on display shelves, making it possible to optimize the order quantity of products, simplify inventory work, and improve overall management efficiency. In addition, an excellent effect that the overall cost can be reduced is achieved.

[0033]

[Brief description of the drawings]

FIG. 1 is a schematic diagram of the system of the present invention.

FIG. 2 is an explanatory view of a commodity movement check register and a display;

[A] is a schematic perspective view of the weight sensor,

[B] is a perspective view of the mounting of the small transition camera on the shelf board.

[C] It is a schematic front view of the display.

FIG. 3 is a flowchart of the system of the invention of this application.

[Explanation of symbols]

 2 Computer 4 Product ordering terminal 5 Display shelf 7 Shelf 8,9 Product movement detection sensor 10 Display 6 Host computer 8 Weight sensor 9 CCD camera

[Procedure amendment]

[Submission date] August 17, 1998 (1998.8.1)
7)

[Procedure amendment 2]

[Document name to be amended] Statement

[Correction target item name] 0013

[Correction method] Change

[Correction contents]

[0013]

[Operation] In the above configuration, the host computer of the headquarters calculates the number of stocks for each product in all stores based on order data from stores, calculates the number of stores for each product, and calculates the total number of ordered products. Calculate items with few orders, further calculate items with a smaller number of stores ordered, allocate total inventory for each ordered product at all stores, check the sales period for each product store, Hosts that extract products with long sales periods, move products from other stores with large inventory to the ordering store, and suspend orders for stores with long suspension periods and small order volume, The order is placed from the computer as order data of each store from the computer, and at the time of delivery, the products delivered from the customer are checked at the distribution center, the data of the store confirmed to be delivered is created, and the products of the customer are created. Create a shortage data, and sends an order delivery customer information in the store at the time of arrival of goods, to update the distribution centers and stock Fairu of each store, the store PoS
(Point of Sales) The sales quantity is matched to the item of the delivered product from the data, and the store creates a stock quantity table of the display shelf products of the sales department in accordance with the delivered product, thereby leveling the inventory of all stores. To reduce defective inventory, improve the efficiency of logistics, prevent loss of sales opportunities, allow inventory at stores every day, determine the actual number of products, and prevent excess inventory and loss. Is made possible. "

[Procedure amendment 3]

[Document name to be amended] Statement

[Correction target item name] 0019

[Correction method] Change

[Correction contents]

Therefore, in the conventional mode, as described above, when ordering work, the display shelves 5, 5,... Are patroled many times to detect the out-of-stock condition due to the sale of the product, and the theft. Although it is difficult to catch who was involved in the occurrence of the loss at the time of loss due to shoplifting or the like, it is difficult to always catch the change state of the product, that is, the display state of each product on the shelf 7. It can be grasped, and the data of the checkout at the cash register can be linked to the transmission to the computer 2 by the PoS (Point of Sales) 3. "

 ──────────────────────────────────────────────────続 き Continued on the front page F term (reference) 3E042 BA13 BA16 CC08 CD01 CD02 CE06 EA06 3F022 AA15 FF01 MM08 MM28 MM29 MM30 NN38 PP03 5B049 BB11 CC27 FF04 GG01 GG05 GG07

Claims (7)

[Claims] 1. A system for transmitting merchandise sales data from a cash register at a store to a computer and transmitting merchandise order data from a merchandise ordering terminal to the computer to manage inventory of merchandise on a display shelf in a merchandise sales department. In the above, a product movement detection sensor is provided on a shelf plate of the display shelf to detect the movement of the product, and a display electrically connected to the product movement detection sensor is provided on a front end of a plate end of the shelf plate. A merchandise inventory management system for a store, wherein the merchandise inventory management system is arranged and connected to the computer having a data storage (buffering) function and a data storage (buffering) function. 2. The merchandise inventory management system for a store according to claim 1, wherein the computer at each store is connected to a host computer at the headquarters so that the merchandise data of each store can be processed freely. . 3. The merchandise inventory management system according to claim 1, wherein said merchandise movement detecting sensor is a weight sensor. 4. The merchandise inventory management system for a store according to claim 1, wherein said merchandise movement detection sensor is a small CCD camera. 5. A merchandise inventory management system for a store according to claim 1, wherein said display is a flexible, free and long size display having a length equal to the length of the front end of said shelf board. . 6. A system according to claim 1, wherein said display is plasma or liquid crystal. 7. The display according to claim 1, wherein the display displays an item name and a unit price of each item, and stores the number of shelves and the total weight or form of the items placed on the shelf. Item inventory management system of a store described in any of items 1, 5, and 6.