JP4049434B2 - Product management device - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to a merchandise management apparatus, and more particularly to a merchandise management apparatus that manages the inventory quantity of presented merchandise.
[0002]
[Prior art]
As a conventional merchandise sales method, a merchant generally places merchandise or merchandise information in a store and waits for a purchaser. In such a method, the store's location conditions and consumer awareness greatly influence sales, so it costs money to place the store in a well-conditioned place and to advertise to increase awareness There is a need.
[0003]
By the way, since the number of users of the computer network, particularly the Internet, is increasing rapidly, a virtual store service for presenting product information and receiving orders on the computer network has been devised and put into practical use. The merchandise supplier in this service does not need to set up a store in particular, and reserves merchandise to be sold at a virtual store and sends it out when an order is placed. In addition, the product orderer can purchase the product after examining the product information without going to the store.
[0004]
[Problems to be solved by the invention]
However, in such a virtual store service, unlike the case where the product is actually placed in the store, the state in which the product is decreasing cannot be seen by the product supplier or the product orderer. For this reason, there is a case in which the merchandise supplier loses the sales opportunity because the merchandise supplier cannot keep an estimate of the merchandise purchase time and cannot secure the merchandise even if an order is placed.
[0005]
This invention is made in view of such a point, and it aims at providing the merchandise management apparatus which can notify this to a merchandise supplier when the merchandise sold in a virtual store decreases. To do.
[0006]
[Means for Solving the Problems]
In the present invention, in order to solve the above-described problem, in the product management apparatus that manages the number of stocks of the displayed products of a plurality of product suppliers, the supplied product is refilled by the product supplier or ordered by the product orderer. In addition, the inventory management means for correcting the inventory quantity, the appropriate inventory setting means for setting the appropriate inventory quantity for the presented product, and when the inventory quantity is equal to or less than the appropriate inventory quantity, There is provided a merchandise management device characterized by having an appropriate inventory break notification means for outputting a stock break notification.
[0007]
In such a product management apparatus, when managing the inventory quantity of the products presented by a plurality of product suppliers, the inventory management means refills the presented products every time the product supplier replenishes or the product orderer places an order. Correct inventory quantity. The appropriate inventory setting means sets an appropriate inventory quantity for the presented product. The proper stock break notification means outputs a proper stock break notification to the product supplier when the stock quantity becomes less than the proper stock quantity.
[0008]
If the inventory quantity of the presented product is managed in this way, a notice of appropriate inventory breakage is output when the inventory quantity falls below the preset appropriate inventory quantity. You can see that is decreasing.
[0009]
DETAILED DESCRIPTION OF THE INVENTION
Hereinafter, embodiments of the present invention will be described with reference to the drawings.
FIG. 1 is a block diagram showing the principle configuration of a merchandise management apparatus according to the present invention.
[0010]
The merchandise management apparatus of the present invention manages the inventory quantity 2 a of merchandise 2 supplied from the merchandise supplier 1. When the product supplier 1 refills the product or the product orderer 3 orders the product, the inventory management unit 4 corrects the stock end 2a. The appropriate inventory quantity 2b for the product 2 is set by the appropriate inventory quantity setting means 5 based on an instruction from the product supplier 1. When the stock quantity 2a becomes equal to or less than the proper stock quantity 2b, the proper stock break notification means 6 outputs a proper stock break notification to the product supplier 1.
[0011]
In such a merchandise management apparatus, the stock quantity 2a of the merchandise 2 is sequentially corrected by the stock management means 4, and when the stock quantity 2a falls below the preset proper stock quantity 2b, the proper stock break notification means 6 causes the merchandise supplier to Appropriate inventory breakage notice is output to 1.
[0012]
Therefore, the merchandise supplier 1 can know that the merchandise 2 is decreasing without particular attention, and can use it as a standard for replenishment.
Next, a system configuration in the case where such a merchandise management apparatus is applied to a virtual store service for buying and selling merchandise via a computer network will be described.
[0013]
FIG. 2 is a diagram showing a system configuration when the merchandise management apparatus of the present invention is applied to a virtual store service.
The member store 10a communicates with the mall server 30 via the computer network 11 using the member store terminal 12a. Further, the consumer 20a, ... communicates with the mall server 30 via the computer network 21 using the consumer terminal 22a, ....
[0014]
The mall server 30 stores virtual store information 31 supplied by the member stores 10a,. Upon receiving an inquiry from the consumer 20a, the order processing unit 32 presents the virtual store information 31 to the consumer terminal 22a,..., And the consumer terminal 22a,. .. Is registered, and the environment variable cookie value is given to the consumer terminal 22a.
[0015]
The order processing unit 32 also checks the environment variable Cookie value attached to the order in the session management DB 33 when a product is ordered from the consumer terminal 22a,... Based on the presented virtual store information 31. Order processing described later is performed. At that time, all the information accompanying the order is stored in the order information DB 34.
[0016]
The order information DB 34 provides the stored order information to the member store 10a,. Then, when the current stock amount of the supplied product is equal to or less than the preset proper stock amount, the proper stock break processing unit 35 sends a proper stock break notification to the FAX 13a of the member store 10a,. Output to The details of the processing of the appropriate inventory crack processing unit 35 will be described in detail later.
[0017]
The virtual store information 31 includes a member store information DB 31a, a product information DB 31b, and an inventory information DB 31c. In the member store information DB 31a, at least the member store codes of the member stores 10a,..., Store names, and FAX numbers are stored in association with each other. In the product information DB 31b, at least the product name of the product supplied to the virtual store, the product code, the unit price, and the member store code of the member store that supplies the product are stored in association with each other. Further, in the inventory information DB 31c, at least the product code of the product supplied to the virtual store, the current storage amount, the appropriate inventory amount, the number of opportunity losses, and the member store code of the member store that supplies this are associated. Stored.
[0018]
FIG. 3 is a diagram showing a specific example of a member store information table stored in the member store information DB 31a.
The member store information table 40a is configured by adding a member store code to the name, address, telephone number and FAX number of the member store. Here, it is understood that “Fuji store” to which the member store code “10001” is added and “Sakura store” to which the member store code “10002” is added are registered as member stores.
[0019]
The member store information DB 31c is managed by the manager of the mall server 30, and the member store 10a,... And the consumers 20a,.
[0020]
FIG. 4 is a diagram illustrating a specific example of a product information table stored in the product information DB 31b.
The product information table 40b is configured by adding the product code and the member store code of the member store supplying the product code to the product name, unit price, and sales floor code of the product supplied from the member store. Here, “Eraser”, “Pencil”, “Sashijiki” and “Landsell” from the member store having the member store code “10001” as merchandise, and “Sweets” from the member store having the member store code “10002”. It can be seen that "Assortment" and "Stuffed animal set" are supplied.
[0021]
The merchandise information DB 31b is configured based on information provided from the member store 10a,..., And the stored contents cannot be changed by the manager of the mall server 30 or the consumers 20a,.
[0022]
FIG. 5 is a diagram showing a specific example of an inventory information table stored in the inventory information DB 31c.
The stock information table 40c holds an appropriate stock amount, a current stock amount, and the number of opportunity losses for each product specified by the product code, and has a member store code of a member store that supplies each product.
[0023]
Here, the appropriate stock quantity of the merchandise having the merchandise code “F-002” of the merchant with the merchant code “10001” is “20”, the current stock quantity is “0”, and the number of opportunity losses is “3”. It can be seen that there was a lack of proper stock and that there were three opportunity losses. Similarly, the appropriate stock quantity of the product having the product code “F-003” of the member store having the member store code “10001” is “100”, the current stock amount is “0”, and the number of lost opportunities is “5”. It can be seen that there was a lack of proper stock and that there were five opportunity losses. Furthermore, the proper stock quantity of the product with the product code “J-001” of the member store having the member store code “10002” is “30” and the current stock quantity is “25”, and the proper stock is not sufficient. I understand.
[0024]
The number of opportunity losses is a value obtained by counting the difference when the current storage amount is smaller than the ordered number. This counting is performed by the order processing unit 32. When the order processing unit 32 receives the order, the order processing unit 32 acquires the environment variable cookie value from the consumer terminal 22a, which is the ordering source. Then, the session management DB 33 makes an inquiry to check that the same order from the same consumer terminal is not counted.
[0025]
Of the contents stored in the inventory information DB 31c, the appropriate inventory quantity is set by the member store 10a,... And the manager of the mall server 30 and the consumers 20a,. The current storage amount indicates the amount of products secured for the virtual store, and increases or decreases by replenishment or ordering.
[0026]
FIG. 6 is a flowchart showing the order receiving process performed by the order processing unit of the mall server 30 when an order for a product is received from the consumer 20a.
[S1] Product information is acquired from the product information DB and presented to the consumer terminal 22a via the computer network 21. The product information presented here includes at least a product name and a unit price.
[S2] The order sheet is sent to the consumer terminal 22a.
[S3] The order sheet on which necessary items are described by the consumer 20a is received, and the ordered product name and the number of orders are acquired.
[S4] The inventory information DB 31c is searched to obtain the current stock quantity of the ordered product. If the quantity is greater than or equal to the number of orders, the process proceeds to step S5, and if smaller than the order quantity, the process proceeds to step S7.
[S5] The current storage amount of the ordered product in the inventory information DB 31c is reduced according to the number of orders.
[S6] The consumer 20a is notified of receipt of the accepted order.
[S7] The number of opportunity losses of the ordered product in the inventory information DB 31c is increased according to the number of orders.
[S8] The consumer 20a is notified that the ordered product is out of stock. At this time, if the number is merely insufficient, this is also notified.
[S9] The processing contents so far and the contents of the accepted order sheet are stored in the order information DB 34.
[0027]
When the order is received, the mall server 30 identifies the member store that supplies the ordered product from the product code and the member store code. Then, order information is sent to the corresponding member store via the computer network 11.
[0028]
FIG. 7 is a diagram showing an example of an order sheet display screen sent from the order processing unit 32 to the consumer terminals 22a,.
The order sheet 41 is provided with an anchor 411 for proceeding to a home page. By clicking the anchor 411 with a pointing device such as a mouse, it is possible to proceed to a home page where product information is presented.
[0029]
Further, the order sheet 41 is provided with an orderer data column 412, a product order column 413, a price billing column 414, and a delivery destination data column 415, and is configured to receive input of necessary data from the orderer.
[0030]
The order sheet 41 further includes an order button 416. When the orderer who has finished inputting data clicks the order button 416 with a pointing device such as a mouse, the order entered in the order sheet is displayed. Information can be sent to the order processor 32.
[0031]
FIG. 8 is a diagram showing an example of an inventory maintenance screen in which the mall server 30 receives inventory information input from the member store 10a,.
The inventory maintenance screen 42 shown here is for receiving inventory information from the Fuji store with the member store code “10001”.
[0032]
The inventory maintenance screen 42 is provided with an anchor 421 for proceeding to the menu page. By clicking on the anchor 421 with a pointing device such as a mouse, what kind of information is exchanged with the mall server 30 is a member. It is possible to proceed to a menu page where the store 10a,.
[0033]
On the inventory maintenance screen 42, the product code, the set appropriate stock amount, and the current stock amount are displayed for the product for which supply is determined, and the new proper stock amount input field 422 and entry / exit entry are displayed. A column 423 is provided. In the member store, when it is desired to change the proper stock quantity set in the past, the new proper stock quantity is input to the new proper stock quantity input field 422. When replenishing the product with respect to the current warehouse quantity, the quantity is entered in the entry / exit entry field 423. When the number of products reserved for the virtual store is reduced, the quantity is entered in the entry / exit input field 423 with a minus sign indicating delivery.
[0034]
The inventory maintenance screen 42 further includes a registration / update button 424. When the stock information input from the member store is completed, the registration / update button 424 is clicked with a pointing device such as a mouse, and the input stock information is sent to the stock information DB 31c.
[0035]
In addition to the inventory maintenance screen described above, in the member store terminal 12a,..., A product registration screen that enables registration of product information, and an inventory that can be added with arbitrary conditions regarding orders. A status condition setting screen, an inventory status inquiry screen that can reset the number of opportunity losses, and the like can be called and sent to the mall server 30.
[0036]
In addition, in such a mall server 30, the order information when the order is received is set not to be sent via the computer network 11 but to be set for each member store by FAX as in the case of the proper stock breakage notice. It is also possible to do this.
[0037]
As described above, when the merchandise management apparatus of the present invention is applied to the virtual store service, the appropriate inventory breaking processing unit 35 provided in the mall server 30 is based on the period set by the manager of the mall server 30. The inventory information DB 31c is searched at a rate of once a day or the like, and the relationship between the current storage amount of all the products supplied to the virtual store and the appropriate inventory amount set for each item is examined. Then, a list of products whose current stock amount is equal to or less than the appropriate stock amount is listed, and this is compiled in writing for each member store to generate a proper stock break notification. Then, the member store information DB 31a is searched for and acquired the FAX number of the member store to which the notice of the appropriate inventory breakage needs to be sent, and this is sent.
[0038]
As described above, in the product management device of the present invention, an appropriate stock amount is set for the product supplied from the member store for the virtual store, and the stock secured for the virtual store is reduced by the order from the consumer. When the amount is less than the proper stock amount, this is notified to the member store by FAX as a notice of proper stock breakage.
[0039]
Accordingly, even if the member store does not sequentially check the stock status, it can know this when the appropriate stock set by the stock quantity is interrupted, and can take measures such as replenishment of goods and ordering.
[0040]
【The invention's effect】
As described above, in the product management apparatus of the present invention, there is provided a proper stock break notification means for outputting a proper stock break notification to the product supplier when the stock amount of the presented product is equal to or less than the preset proper stock amount. Therefore, the merchandise supplier can know that the merchandise is decreasing without paying attention to the stock quantity of merchandise, and can replenish or place orders at an appropriate time.
[Brief description of the drawings]
FIG. 1 is a block diagram showing a principle configuration of a merchandise management apparatus according to the present invention.
FIG. 2 is a diagram showing a system configuration when the merchandise management apparatus of the present invention is applied to a virtual store service.
FIG. 3 is a diagram showing a specific example of a member store information table stored in a member store information DB.
FIG. 4 is a diagram illustrating a specific example of a product information table stored in a product information DB.
FIG. 5 is a diagram showing a specific example of an inventory information table stored in an inventory information DB.
FIG. 6 is a flowchart showing a procedure of an order receiving process performed by an order processing unit of a mall server when a product is ordered from a consumer.
FIG. 7 is a diagram showing an example of an order sheet display screen sent from the order processing unit to a consumer terminal.
FIG. 8 is a diagram illustrating an example of an inventory maintenance screen in which the mall server receives inventory information input from a member store.
[Explanation of symbols]
1 Commodity supplier 2 Commodity 2a Inventory quantity 2b Proper inventory quantity 3 Commodity orderer 4 Inventory management means 5 Proper inventory quantity setting means 6 Proper inventory crack notification means

Claims (5)

In product management equipment for managing the inventory quantity of presented products of multiple products supplier,
A communication means for performing communication via a computer network;
When receiving an inquiry from the consumer terminal of the product orderer via the communication means, the transmitting means for registering the consumer terminal and transmitting an environment variable value to the consumer terminal;
Receiving means for receiving the product name, the order number of the product and the environment variable value from the consumer terminal;
With respect to the presented goods, every time there is an order by the replenishment and the commodity purchaser by the commodity supplier, and inventory management means for correcting the inventory quantity,
An appropriate inventory setting means for setting an appropriate inventory quantity for the presented product;
Based on the environment variable value, it is determined whether or not the order is the same from the same consumer terminal. If the order is not the same, if the order quantity of the product exceeds the inventory quantity, the product Processing means that increases the number of opportunity losses and does not count this if it is the same order,
When the stock quantity is equal to or less than the proper stock quantity, proper stock break notification means for outputting a proper stock break notice to the product supplier;
A product management device comprising: Before SL inventory management means, product management device according to claim 1, wherein the information of the replenishment and ordering and wherein the receiving through the communication means for the presentation item. If the order of more than the stock quantity with respect to the presentation item is performed, the product orderer to the product management system according to claim 1, further comprising a sales failure notification means for outputting orders not notice .   The commodity management apparatus according to claim 1, wherein the notice of proper inventory breakage is output by facsimile to the commodity supplier. In a recording medium storing a product management program for causing a computer to manage the inventory quantity of the presented product,
Computer
A communication means for performing communication via a computer network;
A transmission means for registering the consumer terminal and transmitting an environment variable value to the consumer terminal upon receiving an inquiry from the consumer terminal of the product orderer via the communication means;
Receiving means for receiving the product name, the order number of the product and the environment variable value from the consumer terminal;
With respect to the presented goods, every time there is an order by the replenishment and the commodity purchaser by the commodity supplier, inventory control means for correcting the inventory quantity,
An appropriate inventory setting means for setting an appropriate inventory quantity for the presented product;
Based on the environment variable value, it is determined whether or not the order is the same from the same consumer terminal. If the order is not the same, if the order number of the product exceeds the inventory quantity, A processing means that increases the number of lost opportunities and does not count this if it is the same order,
When the stock quantity becomes equal to or less than the proper stock quantity, proper stock break notification means for outputting a proper stock break notice to the product supplier,
A computer-readable recording medium storing a product management program for functioning as a computer.

Images