KR20190130195A - System for managing store stock - Google Patents

Abstract

According to an embodiment of the present invention, a system for managing stock of a store in real time may comprise: an electronic sensor attached to a product and recording product identification information; a reader sensing product identification information of the electronic sensor attached to the product; a supplier terminal used at supplier supplying products; and a store terminal connected to the reader by wire or wireless communication, counting the number of the products having the product identification information sensed by the reader to grasp the number of the products and requesting a product order to the supplier terminal as order number for each product set by a business operator when the counted number of the products is less than a preset reference number.

Description

Real-time store inventory management system {System for managing store stock}

The present invention relates to a store inventory management system, a real-time store inventory management system that can manage the product inventory in the store in real time.

In recent years, as the number of large, medium and small discount stores has increased, it is required to provide better services to customers, and to provide efficient work processes and optimal product management. In particular, since customer management and product management are important factors directly related to profits and losses in all retail stores, stores that are sellers of merchandise should have an appropriate marketing strategy in consideration of both the convenience of customers and inventory management of the merchandise. Can be increased with

From this point of view, the management of goods, that is, the management of goods display and the management of goods inventory, are very important. In particular, the management of goods on shelves of goods shelves that are in direct contact with customers can be more important.

In all existing offline shopping malls and large / medium / small-sized discount stores, the store staff checks the shortage status directly for a certain amount of time to replenish the merchandise shelves and manage them. It has been checked and replenished, or delivered to warehouse personnel with details of shortages orally, wired or wireless. The store staff or warehouse staff checks the stock of the goods in the warehouse to secure the replenishment quantity, and replenishes and displays the goods at the corresponding display location. I have taken the way of displaying through.

However, the existing merchandise display rack product management method is premodern and has many problems. The problems are summarized as follows.

First, the store staff must check the status of the shortage for supplementary display of the product, which leads to unnecessary time and labor costs for the store manager.

Second, it is difficult for the store staff to walk around the store to check the shortage status, and it is difficult to identify the shortage goods accurately and quickly.

Third, information on merchandise display on the merchandise display rack is difficult to manage due to lack of systematic computerization.

Fourth, the absence of data on the quantity of replenishment displays of commodities may be cumbersome to frequently perform replenishment displays, missed timing of replenishment displays, and additional orders for lack of stocks of products. There is a problem that the response to such a replacement product is delayed.

As described above, the conventional merchandise management system of the merchandise display rack has an uneconomical problem in that unnecessary time and money are incurred in the management of stores for merchandise sales.

Korean Patent Publication No. 10-2013-0062854

The technical problem of the present invention is to provide a real-time store inventory management means that can manage the product inventory in the store in real time.

An embodiment of the present invention is attached to a product, the electronic sensor recorded product identification information; A reader for detecting product identification information of an electronic sensor attached to the product; A delivery account terminal used in a delivery account for delivering goods; And counting the number of products of the goods having the product identification information detected by the reader, which is connected to the reader by wire communication or wireless communication, to determine the stock number of the goods, and the counted inventory number is less than the preset reference number. If it is to be set as the number of orders per product set by the operator; store terminal for requesting the product order to the delivery customer terminal; may include.

The real-time store inventory management system, the operator terminal used by the store operator; And a store management server that manages a product inventory of a store, wherein the store terminal transmits product order information to the operator terminal and the store management server, and receives product receipt information from an administrator. The product inventory information including the number and the inventory number is transmitted to the operator terminal and the store management server, and the store management server generates a product inventory / sales graph including a product stock amount graph and a product sales amount graph to the operator terminal. Can provide.

The store terminal may transmit the estimated time of arrival and the quantity of the product to the operator terminal at the time of delivery of the product at the delivery customer.

There are at least two delivery customers who deliver goods for each product, and the real-time store inventory management system includes delivery history information including delivery time, undelivered goods delivered, and A / S processing result of delivered goods. Includes updated delivery history information DB stored for each delivery customer, the store terminal, may select any one or more delivery customers based on the delivery history information DB from a plurality of delivery customers to request a product order.

The store terminal calculates the respective evaluation scores according to the delivery time required, the undelivered goods delivered, and the A / S processing result of the delivered goods, and selects the delivery customer with the highest overall score to order the goods. You can request

The store terminal receives a weight from the operator for each of the delivery time, the state of undelivered goods delivered, and the result of A / S processing of the delivered goods, and applies a weight to the evaluation score of each item, thereby applying the weighted overall evaluation score. Can request the goods order by selecting the highest delivery account.

According to the embodiment of the present invention, inventory and merchandise orders that have been performed by existing manual operations can be automatically processed one-stop automatically based on data set by the business operator, thereby making it easy to identify the stock. This reduces unnecessary manpower for inventory and eliminates the need to contact different delivery customers multiple times when ordering different products.

1 is a block diagram of a real-time store inventory management system according to an embodiment of the present invention.
2 is a block diagram of a store management server according to an embodiment of the present invention.
Figure 3 is an illustration of a product / inventory sales graph displayed on the operator terminal according to an embodiment of the present invention.
Figure 4 is a block diagram of a store terminal according to an embodiment of the present invention.
Figure 5 and Figure 6 is an illustration of the replenishment of the merchandise is made again according to the number of stock according to an embodiment of the present invention.
Figure 7 is an illustration of calculating the evaluation score of each delivery account for the selection of delivery customers in accordance with an embodiment of the present invention.
Figure 8 is an exemplary figure calculated by applying a weight to the evaluation score of each delivery customer for the selection of delivery customers in accordance with an embodiment of the present invention.

Advantages and features of the present invention, and methods for achieving them will be apparent with reference to the embodiments described below in detail with the accompanying drawings. However, the present invention is not limited to the embodiments disclosed below, but may be implemented in various forms, and is provided to fully inform the scope of the invention to those skilled in the art. The invention is defined only by the scope of the claims. In addition, in the following description of the present invention, if it is determined that related related technologies and the like may obscure the gist of the present invention, detailed description thereof will be omitted.

1 is a block diagram of a real-time store inventory management system according to an embodiment of the present invention, Figure 2 is a block diagram of a store management server according to an embodiment of the present invention, Figure 3 is a product according to an embodiment of the present invention 4 shows an example of a stock sales graph displayed on an operator terminal, FIG. 4 is a block diagram of a store terminal according to an embodiment of the present invention, and FIGS. 5 and 6 show an order according to the number of stocks according to an embodiment of the present invention. It is an example figure that the product is made up again.

The real-time store inventory management system of the present invention, as shown in Figure 1, the electronic sensor 10, the reader 100, the delivery customer terminal 300, the store management server 500, the operator terminal 400, and the store It may include a terminal 200.

The electronic sensor 10 is a sensor attached to a product in which product identification information is recorded, and is a counting sensor used to detect the presence or absence of a product, and may be provided as an RFID tag, an Arduino, or a counter using a Raspberry Pi.

As is known, an RFID tag is a chip tag with an antenna that stores a unique ID or data read from a sensor and transmits the information in various ways when requested by a reader.

The counter sensor using Raspberry Pi and Arduino is a kind of mini computer, and it works in conjunction with the counter sensor made of printed circuit board (PCIO) using general-purpose input / output (GPIO). Can be transferred.

On the other hand, when the electronic sensor 10 is broken, when the reader, the Internet communication network is disconnected, it is implemented to send SMS text notification to the owner, customer, technical staff terminal, so as to quickly identify the failure.

In addition, the store inventory grasp due to the communication disconnection can be implemented to deliver information to the server by temporarily counting the inventory to the POS terminal.

The reader 100 may be implemented as an RFID tag reader, an Arduino, a Raspberry Pi, or the like as the reader 100 that detects the product identification information of the electronic sensor 10 attached to the product. The reader 100 may read the product identification information by reading the electronic sensor 10 attached to the product that is provided at the checkout counter and sold at the checkout counter. Alternatively, the goods displayed on the goods display can be scanned and goods identification information can be read.

In addition, the merchandise counting means including the electronic sensor 10 and the reader 100 may be manufactured in various forms according to the display form of the merchandise, the kind of the merchandise, and the like.

The delivery account terminal 300 is a terminal used in a delivery account for delivering goods, and in the drawings, a desktop PC is described as an example, but not only a desktop PC but a smart phone and a tablet PC are described. ), A slate PC, a notebook computer, and the like. Of course, the terminal to which the present invention is applicable is not limited to the above-described type, and of course, may include all terminals capable of communicating with external devices.

The operator terminal 400 is a terminal used by a store operator operating a store. In the drawing, a smartphone is described as an example, but various other terminals such as a desktop PC may be used as well as a smartphone.

The store management server 500 has the same configuration as a conventional web server in hardware, and is implemented in various types of languages such as C, C ++, Java, Visual Basic, Visual C, and the like in software. It includes a program module for doing this. In addition, it can be implemented by using a web server program that is variously provided according to operating systems such as DOS, Windows, Linux, Unix, Macintosh, etc. in general server hardware. have.

The store management server 500 receives the product stock information including the product name, the date of arrival, the number of goods received, and the number of stocks, and the product order information from the store terminal 200 to manage the product inventory of the store. In addition, a product stock / sales graph including a product stock graph, a product sales graph is generated and provided to the operator terminal (400).

To this end, the store management server 500 may include a server communication unit 510, a product order information storage unit 520, a product inventory information storage unit 530, and a product inventory / sales graph generation unit ( 540.

The server communication unit 510 supports hardware and software protocols for communicating with the store terminal 200 and the operator terminal 400, respectively. The server communication unit may perform data communication using, for example, a wireless mobile communication network including a base transceiver station (BTS), a mobile switching center (MSC), and a home location register (HLR). . In addition, data communication may be performed through a wire according to an Internet protocol such as Transmission Control Protocol / Internet Protocol (TCP / IP).

The merchandise order information storage unit 520 receives the merchandise order information ordered to the delivery customer from the store terminal 200 and stores it in real time.

The product stock information storage unit 530 receives and stores the product stock information including the product name, the date of arrival, the number of goods received, and the number of stocks from the store terminal 200 in real time. The product order information storage unit 520 and the product inventory information storage unit 530 may include a hard disk drive, a solid state drive, a flash memory, and a compact flash card. ), SD card (Secure Digital Card), SM card (Smart Media Card), MMC card (Multi-Media Card) or a memory stick (Memory Stick) module that can input and output information may be provided inside the device It may be provided in a separate device.

The product inventory / sales graph generation unit 540 generates a product inventory / sales graph including a product inventory graph and a product sales graph and provides the same to the operator terminal 400. Accordingly, the operator terminal 400 displays a product inventory / sale graph, such as a product stock graph and a product sales graph, as shown in FIG. 3, so that the business operator can easily grasp the stock inventory for each product and the sales volume for each product.

The store terminal 200 is connected to the reader 100 by wire or wireless communication, and counts the number of products of the products having the product identification information detected by the reader 100 to determine the stock number of the products. Therefore, when the counted inventory number becomes less than the preset reference number, the store terminal 200 requests a product order to the delivery customer terminal 300 as the order number for each product set by the business operator.

In addition, the store terminal 200 transmits the product order information to the operator terminal 400 and the store management server 500, and receives the goods receipt information from the administrator, including the product name, the date of receipt, the number of receipts, inventory number The product inventory information is transmitted to the operator terminal 400 and the store management server 500. In addition, the shop terminal 200 transmits the estimated time of arrival and the quantity of goods to the operator terminal 400 at the time of delivery of goods from the delivery customer.

To this end, the store terminal 200 of the present invention, as shown in Figure 4, the terminal communication unit 210, the terminal display unit 220, the terminal input unit 230, the inventory number grasping unit 240 for each product, and goods delivery The request processing unit 260 may be included. In addition, the delivery history information DB 250 may be further included.

The terminal communication unit 210 receives the product identification information read by wire communication or wireless communication with the reader 100. This communication method may be a wired communication method such as Ethernet, Universal Serial Bus, IEEE 1394, serial communication, and parallel communication. Infrared Radiation Wireless communication schemes such as, Bluetooth, home RF (Radio Frequency), and wireless LAN may be used.

The terminal display unit 220 displays the product identification information read through the reader 100 and the stock number of the read product.

The terminal input unit 230 may receive a necessary setting value from the operator. The terminal input unit 230 and the terminal display unit 220 may be implemented as a single type of touch screen panel. The touch screen panel is a display window that provides a touch screen screen that can simultaneously perform input and display and is provided on the front of the terminal to display a work screen, and displays a graphical user interface (GUI).

The inventory number determining unit 240 for each product may determine the inventory number of the product by counting the product number of the product having the product identification information detected by the reader 100.

For example, when the reader 100 is provided at the cash register, the electronic sensor 10 attached to the merchandise is read every time the merchandise is sold at the cashier, and is subtracted by '-1' from the current number of the merchandise. To determine the number of items in stock.

Alternatively, when the reader 100 reads the goods displayed on the merchandise display rack, the electronic sensor 10 attached to the merchandise on the display rack may be read, and the number of corresponding goods may be increased by '+1' to determine the stock number. .

The product delivery request processor 260 requests a product order to the delivery customer terminal 300 as the order number for each product set by the business operator when the counted inventory number is less than the preset reference number.

For example, as shown in FIG. 5, there were 10 items A in the store, and when the product sales resulted in 4 being less than 5, which is the standard number of products A, 10 preset stocks of goods A were To request as many as six A goods orders to the A goods delivery customer terminal (300). If six A goods are delivered, ten A goods are restocked.

Similarly, as shown in FIG. 6, there were six B products in the store, and when the product sales resulted in two being less than three, which is the standard number of the B products, the number of the B stocks was set to six. Requests B goods to the B goods delivery client terminal 300. If four B goods are delivered, six B goods are back in stock.

On the other hand, at least two delivery accounts for delivering goods may be provided for each product, because when a single delivery customer is designated alone, the goods may not be delivered when necessary due to an internal problem of a solely designated delivery customer. Therefore, the store secures a variety of suppliers and selectively selects them when necessary to place a delivery order.

By the way, in the present invention, when the store terminal 200 can order any one delivery customer from a plurality of delivery customers at the time of the delivery order, it may be an inefficient order. This is because some of the delivery customers have sincere delivery customers, while others are not sincere and expensive.

Therefore, the real-time store inventory management system of the present invention, by using the delivery history of each delivery customer to select a delivery customer to order. Hereinafter, the present invention will be described with reference to FIGS. 7 and 8.

7 is an exemplary view of calculating the evaluation score of each delivery account for the selection of delivery customers in accordance with an embodiment of the present invention, Figure 8 is an evaluation of each delivery account for the selection of delivery customers in accordance with an embodiment of the present invention This is an example figure calculated by applying weights to scores.

According to the present invention, when there are two accounts, a single delivery account is selected by comparison, or when a delivery account is selected in a situation where a delivery account is not yet selected, the delivery history of each delivery account is used. Select a customer to order.

To this end, the real-time store inventory management system of the present invention, the delivery history for updating and managing the delivery history information of each delivery customer when at least two delivery customers to deliver the goods are provided for each product, or when recruiting customers, Information DB 250 is included.

The delivery history information DB 250 is a database in which the real time store inventory management system updates and stores delivery history information including delivery time, delivered goods undamaged status, and A / S processing result of delivered goods by delivery account. to be.

Therefore, the store terminal 200 may select one or more delivery customers based on the delivery history information DB 250 among a plurality of delivery customers and request a product order.

The method of requesting a product order by selecting one or more delivery customers based on the delivery history information DB 250 may be performed in two ways as follows.

The first method is to select a delivery account based on the evaluation score.

To this end, each evaluation score is calculated according to the time required for delivery, undelivered goods delivered, and the result of A / S processing of delivered goods. For example, the time required for evaluation of delivery time may be calculated, such as 10 points if the time required for delivery is within 5 hours, 9 points if it is within 15 hours, and 8 points within 20 hours. Likewise, if there is no damage status of the delivered goods, a score of 10 points can be calculated if the goods are damaged, 5 points if the goods are damaged, and 0 points if the goods are damaged. If the satisfaction is 10 points, if not satisfied with the A / S processing result evaluation score can be calculated.

After the calculation of each valuation score, the delivery customer with the highest overall valuation score is selected to request a product order. For example, as shown in FIG. 7, when there are three delivery accounts for the A product, and the highest evaluation score of the second delivery account is the highest, the second delivery transaction customer orders the delivery of the A product to the second delivery transaction account. Done.

Furthermore, the present invention receives a weight from the operator for the time required for delivery, the state of undelivered goods delivered, and the result of A / S processing of the delivered goods, by applying a weight to the evaluation score of each item, Request the goods order by selecting the highest delivery account.

For example, as shown in FIG. 8, when a weight of 0.2 is set for the required delivery time, a weight of 0.3 is set to the delivered goods undamaged state, and a weight of 0.5 is set in the A / S processing result of the delivered goods, each item By applying weights to the valuation points of, the delivery of the goods of A is ordered to the third delivery trading account having the highest weighted overall valuation points.

On the other hand, another second method of requesting a product order by selecting any one or more delivery customers based on the delivery history information DB 250 is to use the priority set by the operator.

That is, each evaluation score is calculated according to the time required for delivery, undelivered goods delivered, and A / S processing result of delivered goods, and the time required for delivery, undelivered goods delivered, A / S of delivered goods Among the processing results, the highest priority is set by the operator, and the delivery customer who has the highest evaluation score of the item set as the highest priority is selected to request a product order.

For example, when the operator sets the time required for delivery to be the highest priority, the operator orders the delivery of the A product to the first delivery trading account having the highest evaluation score for the time required for delivery.

The embodiments in the above description of the present invention are presented by selecting the most preferred examples to help those skilled in the art from the various possible examples, and the technical spirit of the present invention is not necessarily limited or limited only by the embodiments. Various changes, modifications, and other equivalent embodiments may be made without departing from the technical spirit of the present invention.

10: electronic sensor, 100: reader,
200: store terminal, 300: delivery customer terminal,
400: operator terminal, 500: store management server.

Claims (6)

An electronic sensor attached to the product and recording product identification information;
A reader for detecting product identification information of an electronic sensor attached to the product;
A delivery account terminal used in a delivery account for delivering goods; And
Is connected to the reader by wire or wireless communication, and counts the number of products of the product having the product identification information detected by the reader to determine the inventory number of the product, the counted inventory number is less than the preset reference number A store terminal requesting a product order to the delivery customer terminal as an order number for each product set by an operator;
Real-time store inventory management system comprising a.
The system according to claim 1, wherein the real-time store inventory management system,
Operator terminal used by the store operator; And
A store management server that manages a product inventory of a store;
Including;
The store terminal transmits the product order information to the operator terminal and the store management server, and receives the product receipt information from the manager and receives the product stock information including the product name, the date of receipt, the number of receipts, and the number of inventory. To the management server,
The store management server generates a product inventory / sale graph including a product stock graph and a product sales graph and provides the same to the operator terminal.
The method according to claim 2, The store terminal,
Real-time store inventory management system, characterized in that the delivery time to deliver the expected time of arrival, the quantity of goods to the operator terminal at the time of delivery.
The method according to claim 1,
There are at least two delivery accounts for each product.
The real-time store inventory management system, the delivery history information, including the delivery time, the delivered goods undamaged state, the result of the A / S processing of the delivered goods updated delivery history information DB stored for each delivery customer;
The store terminal, the real-time store inventory management system, characterized in that to request a product order by selecting any one or more delivery accounts based on the delivery history information DB from a plurality of delivery accounts.
The method according to claim 4, The store terminal,
Computing each evaluation score according to the delivery time required, delivered goods undamaged status, A / S processing result of the delivered goods, and selects the delivery customer with the highest overall rating score to request a product order Real time store inventory management system.
The method according to claim 5, The store terminal,
Receive a weight from the operator for the time required for delivery, undelivered goods delivered, and A / S processing result of the delivered goods, and apply the weight to each item's valuation score, and deliver the highest weighted total score. Real-time store inventory management system, characterized in that to request a product order by selecting.

Images