JP2002211749A - Commodity information managing method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a commodity information managing method capable of managing and analyzing sales for every commodity allocated to shelves without taking labor and time and at low cost, control of stock and additional information. SOLUTION: This commodity information controlling method for controlling commodity information for every commodity item at a prescribed shop is provided with a process for constructing a commodity data base for storing various kinds of information on commodities delivered to the prescribed shop by a wholesaler for every commodity item in a form readable and workable by general purpose software, a process for storing sales data at the prescribed shop and delivery of commodity data to the prescribed shop into the commodity data base, a process for segmenting information on a prescribed item of a prescribed commodity item from the commodity data base and forming a commodity information data base for analysis in a form readable and workable by the general purpose software and a process for generating analysis information by analyzing the commodity information data base for analysis by the general purpose software.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a merchandise information management method for easily and inexpensively managing merchandise information including stock in a store using general-purpose software, and more particularly, to a method for managing shelves arranged on a shelf according to a predetermined standard. It relates to a method of linking and managing layout information.

[0002]

2. Description of the Related Art Conventionally, in stores operating a retail business, sales and inventory of each product are often managed by a computer using a POS system or the like. However,
These merchandise management only manages the sales and inventory of each merchandise, and is not linked with the shelf layout of each store at all. Further, even if an attempt is made to grasp the sales and stock information for each product item using a POS system or the like, it is necessary to suppress entry and exit from the warehouse, so that it cannot be managed with a simple system.

[0003] On the other hand, shelving in a store is important for efficient sales of commodities, and in recent years, a system for performing shelving on a computer has appeared. However, since these systems are special management software, and each of the imaged merchandise items are arranged on a computer in the same manner as real shelves, they require advanced image processing and are expensive. . Moreover, even if shelving is performed using such a system, it must be changed on site and is not very effective.

[0004]

As described above, heretofore, a system for managing sales and inventory of commodities according to shelf layout has not been provided at low cost. For example, in the above-described shelving system, in principle, the sales and stock of each product in the shelving are not linked. If this is to be linked with sales and inventory management, it is necessary to provide feedback on the status of changes to the shelf layout at the site, but this must be corrected by the shelf layout system. It takes a lot of time and effort.

In any case, conventionally, there is a problem in that management of sales and inventory of each product on a shelf is very costly and troublesome, and further, additional information is added thereto to analyze information. However, there is a problem that enormous cost is required to perform.

In view of such circumstances, the present invention provides a product information management method capable of managing sales and inventory of products laid out at low cost and low cost and managing and analyzing additional information. The task is to provide.

[0007]

According to a first aspect of the present invention, there is provided a merchandise information management method for managing merchandise information for each merchandise item in a predetermined store, wherein a wholesaler delivers the goods to the predetermined store. A step of constructing a commodity database for accumulating various kinds of information on the commodity for each commodity item in a format that can be browsed and processed by general-purpose software; and a step of accumulating sales data of the predetermined store and delivery data to the predetermined store in the commodity database. And cutting out information about a predetermined item of a predetermined product item from the product database to form a product information database for analysis in a format that can be browsed and processed by general-purpose software; and analyzing the product information database for analysis with the general-purpose software. And generating the analysis information.

[0008] In a second aspect of the present invention, in the first aspect, the various information includes shelf layout information of a shelf on which each product item is arranged at the predetermined store. Product information management method.

[0009] In a third aspect of the present invention based on the second aspect, the shelf layout information includes the number of shelves and the number of product items for each shelf. In the management method.

According to a fourth aspect of the present invention, in any one of the first to third aspects, the various information includes at least one of color, taste, texture, theme, and regionality of the commodity item. Is included in the product information management method.

According to a fourth aspect of the present invention, in any one of the first to fourth aspects, the delivery data includes order receipt data, delivery schedule data, and delivery confirmation data of the wholesaler for each product item. The method is characterized by a product information management method.

According to a fifth aspect of the present invention, there is provided the merchandise information management method according to the fourth aspect, wherein the delivery data further includes returned goods data and missing goods data.

According to the method of the present invention, sales and inventory of each product item can be managed efficiently and inexpensively together with shelf layout information using general-purpose software such as Excel (product name). Information linking such information and various product information can be inexpensively and efficiently performed.

[0014]

DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, the present invention will be described based on embodiments.

(Embodiment 1) FIG. 1 shows an overall flow of an embodiment of the present invention. As shown in FIG. 1, a wholesaler (wholesaler) first prepares a product master 1, acquires shelf allocation information 2 for each predetermined store, checks it with the product master 1, and creates a shelf allocation database 3. . The shelf allocation database 3 has a general-purpose database application on a personal computer, for example, a data format of Microsoft Excel (product name).

The POS of each merchandise item for each store
The data 4 creates a product management database 5 for managing sales and inventory. This product management database 5 is also, for example, Microsoft Excel
l: product name). Even when the POS data 4 cannot be obtained, the merchandise management database 5 can be created by using the order receipt data of the wholesaler, the scheduled delivery data, the confirmed delivery data, the returned data, and the missing data.

From the shelf layout database 3 and the product management database 5, information on a predetermined item of a predetermined product item is cut out, and if necessary, the information of the product information master 6 is added to the information.
Create The analysis-purpose product information database 7 is also in a general-purpose database application on a personal computer, for example, a data format of Microsoft Excel (product name).

Hereinafter, the contents of each database and the method of creating each database will be described.

The merchandise master 1 is a database of merchandise items that are the source of goods at a wholesaler. The merchandise master 1 indicates a JAN code as a merchandise code, a maker name, a merchandise name, a standard indicating the quantity of contents in the merchandise, and the number of boxes. Includes quantity, delivery unit price, and selling price, and also includes wholesaler's unique code.

The shelf allocation information 2 is created for each shelf of each store, and is information indicating what kind of merchandise items are arranged on the shelf and how, and is collected as follows.

FIG. 2 shows a flow of collecting the shelf information. As shown in FIG. 2, the collection of the shelf layout information is performed in the in-store operation S10.
Start from. First, in a store, goods are arranged on predetermined shelves based on a predetermined shelving plan (step S1).
1). The merchandise items thus arranged on the shelf are scanned in a predetermined order by a handy terminal (handy scanner) (step S12). For example, in the case of an eight-stage shelf, the shelf stages from the bottom are set to 01 to 08, and are read in order from left to right. Scanning of each merchandise item requires only scanning the merchandise code, that is, the barcode in this case, after putting the shelf number in the handy terminal. When the same merchandise item is arranged in two rows, scanning is performed twice, so that it is handled as two faces as described later. When one stage is completed, the next shelf stage number is input and the process proceeds to the next stage.

Next, the process proceeds to the personal computer business S20 at the wholesaler using the data of the handy terminal. First, the scan data is uploaded from the handy terminal to the personal computer (step S21). This is performed by connecting the handy terminal and the personal computer in a predetermined manner. next,
The scan data is uploaded from the personal computer (client) to the host computer (step S2).
2). This is a case where a network or the like is formed by a wholesaler, but all operations may be performed by a personal computer.

Next, the processing shifts to host business S30 at the wholesaler. Here, the scan data is converted into shelf allocation data (step S31). This data conversion includes a step of creating a product list database and a step of creating a shelf layout for a predetermined shelf.

When the product list database is created, the product code corresponding to each product item is called and held by comparing the product code of each product item with the product master 1. At this time, the information is displayed on the screen and can be corrected as needed. Product master 1
The merchandise information can be input for the merchandise which is not present in the product, and the added merchandise information is added to the merchandise master 1 as necessary. At this time, if necessary, the shelf allocation check list S3
2 is output. Then, based on this, shelf layout correction data is input (step S33). Further, in this operation, the initial stock quantity of each commodity item may be input. The initial stock quantity may be input at the time of scanning the product code at the handy terminal.

Here, an example of the product list database is shown in FIG. This product list database displays the product code, JAN code, manufacturer name, product name, standard indicating the quantity of the contents of the product, quantity indicating the number of one box, delivery unit price, and selling price. It is not limited to. For example, each company may have a unique classification code. Of course, it also has information indicating where each product is arranged on the shelf.

Next, a procedure for creating a shelf layout based on the product information thus collected will be described. First,
The number of merchandise items for each shelf is determined based on the collected merchandise information, the layout for each shelf is selected from, for example, a standard layout as shown in FIG. 4, and the layout frame of the entire shelf is determined. Here, the standard layout is equally divided based on the number of merchandise items on each shelf, and does not consider the size of the merchandise. When the same product is arranged in two rows, information of 2 faces is also provided, but the number of product items is handled as 1 in the shelf layout. In addition, what is equally divided based on the number of faces may be used as the standard layout.

FIG. 5 shows an example of such a shelf layout. In this shelf layout, for each product item,
The JAN code, the manufacturer name, the product name, the standard, the selling price, the number of faces, and the number of pieces are displayed, but the display contents are not limited to these.

As described above, the product list data can be output at any time as the shelf layout database 6 in accordance with the shelf layout (step S34). Note that this shelf allocation download data is appropriately backed up (step S35).

Next, on the other hand, referring to FIG. 6, a description will be given of a task of creating a product management database 6 for managing sales and inventory of each product item.

As shown in FIG. 6, for example, in the wholesaler host business S50, an inventory management master for each customer is created together with the product list data (step S51). This inventory management master has information such as purchase price, sale price, gross profit, net purchase quantity, number of stocks, book inventory, actual inventory, etc. of each product. For example, in the initial stage, by inputting the number of issues from the wholesaler into the net purchase quantity and the book inventory quantity, it is possible to input other than the issue quantity.

On the other hand, the sales information of each merchandise item can be grasped from the POS data 4 from each store.
That is, from the POS data 4 from the in-store operation S60, for example, the stock control and stock purchase of the inventory management master are updated with the end-of-month delivery data and return data every month (step S52), and the sales information of the POS data 7 is used. The stocking column of the inventory management master is updated (step S53),
Further, the book inventory of the inventory management master is converted and updated (step S54). After such input, the number of goods received, the number of goods issued, the net purchase, and the book inventory of each product item are collated with the shelf allocation data, and actual download data for each shelf is created (step S55).

If necessary, inventory is performed, for example, every two months to update the actual inventory. In this procedure, in the stocktaking operation S71 of the in-store operation S70, the actual barcode is scanned by the handy terminal for each commodity item on each shelf, and the stock quantity is input. Then, based on this data, the physical inventory column of the inventory management master is updated (step S56).

By performing the above inventory management work, it is possible to output the database 5 for merchandise management in which the sales / inventory information is accumulated.

By using the shelf layout database 3 and the merchandise management database 5 created as described above, data analysis can be performed for each sales floor unit, each shelf unit, each shelf unit, and each merchandise unit. In addition, a shelf split actual table, a shelf split sales actual table, a shelf split inventory table, and the like can be output as needed. These can be processed using, for example, the basic functions of Microsoft Excel (trade name) as shown below.

Further, by adding information of the product information master 6 storing various information for each product item to the shelf layout database 3 and the product management database 5, for example, what color is the best selling product? It is possible to analyze what kind of texture, whether there is a difference in sales between the eyelined item and the non-eyelined item, and the like.

Here, an example of the product information master 6 is shown in FIG. That is, the product information master 6 is a database group including, for example, color data 6a for each product item, taste data 6b for each product item, shape data 6c for each product item, origin data 6d for each product item, catch copy data 6e for each product item, and the like. is there.

FIG. 8 shows a procedure for creating the analysis product information database 7 from the shelf layout database 3, the product management database 5 and the product information master 6 described above. This work is performed by Microsoft Excel (Excel:
An example performed using (product name) will be described.

First, necessary data of the shelf layout database 3, the product management database 5, and the product information master 6 are stored in E
The integration is performed using the pivot table function of xcel or the like (step S81). Next, a sheet of the integrated new classified shelf allocation product data is copied, and a value of “select a format and paste” is selected and pasted on the same sheet (step S8).
2). Next, columns and rows of unnecessary items such as pages of the pivot table used only for the combination are deleted (step S83). Thus, the analysis product information database 7 is completed.

The product information database 7 for analysis as described above.
Can be automated by macro processing or the like.

The product information database for analysis 7
, A bar graph or a pie graph can be created using the graph data editing function for each classification (step S8).
4). Further, each column is filtered using the auto filter function (step S85), an auto filter is selected for each classification (step S86), and a target graph sheet is selected and graphed (step S87). Creation of such various types of analysis data can also be automatically processed with a single button by macro processing or the like.

FIG. 9 shows an output example of a shelf allocation sales result table in which sales results are attached to the shelf allocation layout table created as described above. This is the selling order of the entire shelf, but selection by category is also possible by selection. In this table, the ancestry rate, sales for the current month, and ancestry amount are shown, and the numbers on the far right are the number of registered items per shelf, total number of sales, average profit rate, total sales amount, and total profit amount. is there.

FIG. 10 shows an example of the output of the shelf inventory management table. The numbers in this example are purchases, sales, and inventory,
The purchase amount, cost of sales amount, and stock amount. The numbers on the right are the sum of each shelf.

FIG. 11 shows an output example of a sales performance graph for each shelf in the category of rice crackers. From the leftmost bar graph for each shelf, the sales amount, gross amount, previous month sales amount, gross amount, current month sales amount, and gross amount are calculated in the order from the leftmost bar graph. The table below is a numerical representation of the graph, showing the average selling price, the total SKU, and the zone number.

FIG. 12 shows an output example of the shelf-by-shelf inventory performance graph with respect to the sales performance graph of FIG. The bar graph shows, in order from the top, the balance, purchase, cost of sales, and end-of-month inventory. The table below is a numerical representation of the bar graph, which also shows the inventory, purchases, sales, and inventory of each shelf.

FIG. 13 shows an output example of a sales performance graph for each product. 11 is different from FIG. 11 in that a product name is displayed below the graph, and product information such as the number of faces, a shelf number, and a shelf is quantified. With this sales performance graph,
Changes in sales and gross profit for each product can be easily grasped.

FIG. 14 shows an output example of a stock-by-shelf performance graph with respect to the sales performance graph of FIG. This allows
The increase / decrease of inventory for each product can be grasped.

FIG. 15 is an output example of a sales performance graph narrowed down at a price line of 200 yen or more. By performing the narrowing-down in this way, it is possible to grasp the transition of sales and the like for each product.

FIG. 16 shows an example of the output of the stock result narrowed down by the price line.

As described above, the analysis product information database 7
By creating and analyzing the data, it is possible to grasp the sales situation by sales floor or shelf unit, or even by shelf unit, and furthermore, the color, taste, texture, regionality, etc. You can bite information.

[0050]

As described above, according to the present invention,
Without special investment, sales and inventory management, merchandise information analysis, and the like can be performed for each of the merchandise items at low cost and without trouble using general-purpose application software.

[Brief description of the drawings]

FIG. 1 is a diagram showing an overall flow of a first embodiment of the present invention.

FIG. 2 is a flowchart illustrating a procedure for acquiring shelf information according to the first embodiment of the present invention.

FIG. 3 is a diagram showing an example of a product list according to the present invention.

FIG. 4 is a diagram illustrating an example of data of a layout frame according to the present invention.

FIG. 5 is a diagram illustrating an example of a shelf layout according to the present invention.

FIG. 6 is a flowchart showing sales inventory information acquisition processing of the present invention.

FIG. 7 is a diagram showing an example of a product information master of the present invention.

FIG. 8 is a flowchart showing a procedure for creating an analysis product information database according to the present invention.

FIG. 9 is a diagram showing an output example of a shelf sales record table of the present invention.

FIG. 10 is a diagram showing an output example of a shelf allocation inventory management table of the present invention.

FIG. 11 is a diagram showing an output example of a sales performance graph for each category according to the present invention.

FIG. 12 is a graph of stock performance by shelf for each category according to the present invention.

FIG. 13 is a diagram showing an output example of a sales performance graph for each product of the present invention.

FIG. 14 is a shelf actual stock graph for each product according to the present invention.

FIG. 15 is an output example in which the sales performance graph of the present invention is narrowed down by a price line.

FIG. 16 is a diagram showing an output example in which the stock-by-shelf inventory graph of the present invention is narrowed down by price lines.

Claims (6)

[Claims] 1. A merchandise information management method for managing merchandise information for each merchandise item in a predetermined store, wherein a wholesaler stores a merchandise database in which various kinds of information on merchandise delivered to the predetermined store are stored for each merchandise item using general-purpose software. A step of building in a format that can be browsed and processed, a step of accumulating sales data of the predetermined store and delivery data to the predetermined store in the product database, and extracting information on predetermined items of predetermined product items from the product database Forming the analysis product information database in a format that can be browsed and processed by general-purpose software, and generating the analysis information by analyzing the analysis product information database with the general-purpose software. Information management method. 2. The method according to claim 1, wherein the various information includes:
A product information management method, comprising shelf layout information of a shelf on which each product item is arranged in the predetermined store. 3. The merchandise information management method according to claim 2, wherein the shelf layout information includes the number of shelves and the number of merchandise items for each of the shelves. 4. The apparatus according to claim 1, wherein the various information includes at least one of a color, a taste, a texture, a theme, and a regionality of the commodity item. Product information management method. 5. The product information management method according to claim 1, wherein the delivery data includes order data, delivery schedule data, and delivery confirmation data of the wholesaler for each product item. 6. The delivery data according to claim 4, wherein:
Further, a merchandise information management method characterized by including returned goods data and missing goods data.