JP2000215233A - Device, system and method for managing commodities, and recording medium - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a commodity management system capable of easily and efficiently executing commodity management on each of selling and buying sides even in the case of commodities like perishables such as meat and airline tickets whose validity term is limited and the supply amount is previously determined. SOLUTION: On the buying side and the selling side having respectively different commodity code systems, a commodity applying means 320 on the selling side applies plural kinds of commodities being in stock which are indicated by plural second codes corresponding to buying side first codes in negotiation information 311 to commodities indicated by the first codes in prescribed order based on stock commodity information 312.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to the management of products with a limited expiration date and a predetermined supply amount, such as perishables such as vegetables and meat, air tickets, and concert tickets. Product management device used for
The present invention relates to a merchandise management system, a merchandise management method, and a storage medium in which a computer stores a processing step for executing the method.

[0002]

2. Description of the Related Art For example, various merchandise is sold at retailers such as supermarkets. Attention is paid to "meat" as a perishable product in the merchandise. FIG.
Fig. 4 specifically shows how a display shelf for meat is split on a display shelf on which fresh products such as vegetables, tofu, seafood, and meat are displayed. As shown in FIG. 7, first,
Items such as "beef", "pork", and "chicken" are divided into shelves. In the "beef" shelf, the shelves are divided by "domestic products" and "imports", and further, in the "domestic products" shelf, they are shelves by "Japanese beef" and "general beef". And "Wagyu"
And “General cows” on each shelf display meat for each part, such as peaches and fins. The other "pork", "chicken", and the like are also shelved in the same manner as in the case of "beef", and the meat is displayed.

[0003] As described above, a retailer who displays various kinds of meat and sells the meat is to negotiate with a manufacturer that handles the meat to purchase the desired meat from the manufacturer.

Here, the manufacturer (hereinafter, referred to as “seller”) classifies the meat (see FIG. 7) on the retailer side (hereinafter, referred to as “buyer side”). The classification has been further refined. Specifically, the buyer says
Beef-Domestic-Wagyu-Thigh meat "
Grains used for production or breeding, or country and brand names if imported (hereinafter referred to as "quality information"
) Are classified into peach meat A, peach meat B, peach meat C, and so on. Therefore, for example, as shown in FIG. 2, the "beef-domestic product-"
In the case of trading “Wagyu-Thigh meat” products at a unit price of X yen, the seller sends the corresponding products (thigh meat that fits the buyer's intention) with Thigh meat A, Thigh meat B, Thigh meat C, .. (Here, “peach meat C” indicated by the black arrow in FIG. 8 is selected) and supplied (shipped) to the buyer side.

[0005] The supply unit (shipping unit) on the seller side to the buyer side is a box unit such as cardboard packed with 10 blocks of meat equivalent to 1 kg. For example, if the buyer wants 500 kg of "beef-domestic-Japanese-beef-peach", the seller side has one box (10 kg) consisting of 10 peach meat blocks equivalent to 1 kg.
We proceed with negotiations with the buyer in 50 boxes (50 boxes of considerable peach meat). It should be noted that the settlement is performed in an accurate gram unit. In addition, when the seller imports meat from a foreign country, the above-mentioned box is used for the transaction.

At this time, a negotiation similar to the negotiation concerned (a negotiation with another buyer by another negotiation person on the seller side)
Is performed simultaneously in another place, and the same peach meat C is allocated to another buyer side, so that the peach meat C selected as described above cannot be supplied to the buyer side in the negotiation. Is also conceivable. This is because the total supply amount of the peach meat C is determined in advance. Therefore, in order to cope with such a case, the seller selects the peach meat D and E (see the white arrow in FIG. 8) having the same quality as the peach meat C in addition to the peach meat C. Therefore, in this case, the seller side proceeds with the peach meat C, D, and E for the goods ("beef-domestic-Japanese beef-thigh meat", unit price X yen, Y box) requested by the buyer side. become.
Then, when this business negotiation is completed, the seller confirms the stock amount of the thigh meat C, D, and E on the date designated by the buyer, and selects one of the thigh meat C, D, and E. Is supplied to the buyer.

[0007] The business negotiation between the seller side and the buyer side as described above,
It is performed in a certain period cycle (hereinafter referred to as a business cycle). Specifically, for example, on the buyer side (such as a supermarket), so-called sales are often performed as a form of sales to consumers. In this case, the buyer will provide the meat at a low price to the consumer during the sale period, and thus the seller will want the meat with a lower unit price. Also, as another sales form,
In some cases, they sell high-quality meat. In this case, the buyer side provides the consumers with high quality but high quality meat, which is high price. Therefore, the buyer wants the corresponding high quality meat to the seller side. As described above, the unit price of the meat on the buyer side (the unit price of sales to the consumer) is not always constant but varies depending on the sales form at that time. Therefore, in order to cope with this, a negotiation cycle is provided in the negotiation between the seller and the buyer. Therefore, every time a buyer negotiates with a seller, the buyer desires the corresponding meat from the seller while taking into account the sales form (sale or the like) to be held in the next business cycle period.

[0008]

On the buyer side (supermarket or the like) as described above, computerization of order placement and inventory management to the seller side (manufacturer side) makes it possible to produce fresh products such as meat, industrial products, and the like. Barcodes (product codes) are added to all of various products such as confectionery and the like. As a result, the buyer can immediately grasp the sales status of each product, and if a shortage is likely to occur as a result, the buyer can immediately order an additional product to the seller (manufacturer). In addition, it is possible to easily perform product order management and inventory management.

On the other hand, on the seller side (manufacturer) that supplies various goods to the buyer side (supermarket or the like), particularly, on the seller side that handles the above-mentioned products such as meat, the order of goods from the buyer side, Inventory management and the like are not computerized, but are performed manually by humans. This is for the following reasons.

First, goods such as industrial products and confectioneries packed in bags or boxes are in one-to-one correspondence with goods on the buyer side and goods on the seller side. That is, the product “AAA” (specifically, a confection named “AAA”) on the buyer side indicates the product itself “AAA” on the seller side. For such products,
As a product code, a similar code is used on relatively any buyer side (such as a supermarket). Therefore, for example, by unifying the product code on the buyer side and the seller side, and using the product code when the buyer orders the product to the seller side, if the buyer side and the seller side use the product code, Since a common product code is used for ordering and receiving a product, it is conceivable that product management can be facilitated on both the buyer side and the seller side.

However, products such as meat products do not correspond one-to-one with products on the buyer side and products on the seller side with respect to the above-mentioned products such as industrial products and confectionery. Specifically, as shown in FIG. 8, for one product such as "beef-domestic-Japanese beef-thigh meat" on the buyer side (supermarket or the like), the seller side (manufacturer side) converts this to quality. .. Corresponds to n products such as peach meat A, peach meat B, peach meat C,. That is, the goods on the buyer side and the goods on the seller side have a 1: n relationship. This means that the classification at the buyer side is sufficient if it can respond to the needs of the consumer (the general consumer does not need to classify up to quality information indicating what kind of grain was used for breeding). ,
On the other hand, the seller's classification is not limited to supermarkets, and there are buyers of various industries (processing plants, restaurants, etc.). It is necessary. As described above, for products having completely different classification forms between the buyer side and the seller side, for example, when trying to unify the product codes on the buyer side and the seller side in the same manner as the above-mentioned products such as industrial products and confectionery, the product code If is made to correspond to the classification on the seller side, there arises a problem that there are many useless commodity codes that are not used on the buyer side. On the contrary,
If the merchandise code is made to correspond to the classification on the buyer side, there arises a problem that the seller cannot cope with the merchandise on the seller side (commodities classified in detail). Therefore, it is very difficult for buyers and sellers to unify product codes for products such as meat.

[0012] For the reasons described above, particularly for a product (such as meat) in which the classification of the product on the buyer side and the classification of the product on the seller side have a 1: n relationship, the product Currently, on the seller side who handles, product management such as product ordering and inventory management is still performed manually by humans. This is not very efficient.

The present invention has been made in order to eliminate the above-mentioned drawbacks, and has a limited expiration date and a predetermined supply amount, such as fresh meat such as meat or an airline ticket. A product management device, a product management system, a product management method, which can easily and efficiently perform the product management on the seller side and the buyer side even if the product is a product.
It is another object of the present invention to provide a storage medium in which a computer stores processing steps for executing the same.

[0014]

For such a purpose,
A first invention is negotiation information including information on a product determined by a negotiation with a buyer to which the product is shipped and indicated by a first code according to a first product code system on the buyer. A merchandise management device on the seller side that allocates a corresponding merchandise from the stock merchandise to the merchandise indicated by the first code, based on the first code Inventory information storage means for storing in association with a second code according to a code system; and a plurality of items indicating a plurality of types of inventory items selected as items corresponding to the item indicated by the first code in the negotiation information. The negotiation information storage means for storing the second code in association with the first code, and the negotiation information storage means based on the inventory product information stored in the inventory information storage means. Product allocation means for allocating, in a predetermined order, a plurality of types of inventory products indicated by the plurality of second codes associated with the first code, to products indicated by the first code in the negotiation information. And characterized in that:

According to a second aspect, in the first aspect,
The predetermined order includes a priority order added to each of the plurality of second codes.

According to a third aspect, in the first aspect,
The merchandise allocation means, when the buyer issues a real order request for the merchandise indicated by the second code,
The above-mentioned processing is executed for the negotiation information stored in the negotiation information storage means corresponding to the final order request.

According to a fourth aspect, in the first aspect,
The above-mentioned products are characterized in that they have a limited expiration date and include products whose supply amount to the buyer side is determined in advance.

According to a fifth aspect based on the first aspect,
Supply-possible information storage means for storing information of commodities that can be supplied to the buyer side in association with the second code;
A first determining unit that determines an allocation processing order of the plurality of negotiation information stored in the negotiation information storage unit within a predetermined period based on the product information included in the negotiation information; According to the determined processing order, the allocation processing order of the plurality of second codes associated with the target negotiation information is determined based on the suppliable product information stored in the suppliable information storage means. Determining means.

According to a sixth aspect based on the fifth aspect,
The suppliable product information includes cost information of the product, and the product information of the negotiation information includes a transaction unit price with the buyer.

According to a seventh aspect of the present invention, there is provided a buyer who manages a product using a first code according to a first product code system, and a seller who manages a product using a second code according to a second product code system. And a product management system including
The seller has a function of the product management device according to any one of claims 1 to 6.

According to an eighth aspect of the present invention, the management of a product supplied to a buyer who manages a product by a first code according to a first product code system is performed by a second product according to a second product code system. A merchandise management method on the seller side to be performed by using the code of (1), wherein the stock information is stored in the stock information memory in association with the second code, and is determined by negotiation with the buyer. Negotiation information including information on the product indicated by the first code
A negotiation information storage step of storing in the negotiation information memory in association with a plurality of the second codes indicating a plurality of types of stock products selected as products corresponding to the product, and a stock product stored in the stock information memory Based on the information, a plurality of products indicated by the plurality of second codes associated with the first code are provided for a product indicated by the first code in the negotiation information stored in the negotiation information memory. And a product allocation step of allocating types of stock products in a predetermined order.

According to a ninth aspect, in the eighth aspect,
The merchandise allocating step includes a step of executing the allocating process by setting the predetermined order as an order of priority added to each of the plurality of second codes.

In a tenth aspect based on the eighth aspect, the step of allocating the goods is performed by the buyer in the second step.
And a step of executing the above-described processing for the negotiation information stored in the negotiation information memory corresponding to the real order request when the real order request for the product indicated by the code is issued.

An eleventh invention is characterized in that, in the eighth invention, the commodity includes a commodity whose expiration date is limited and whose supply amount to the buyer is predetermined.

In a twelfth aspect based on the eighth aspect, a supply-possible information storage step of storing information of commodities that can be supplied to the buyer side in a supply-capable information memory in association with the second code. A first determining step of determining an allocation processing order of a plurality of pieces of negotiation information stored in the negotiation information storage memory within a predetermined period based on the product information included in the negotiation information; In accordance with the processing order determined in the step, the allocation processing order of the plurality of second codes associated with the target negotiation information is determined based on the suppliable product information stored in the suppliable information memory. And a determining step.

In a thirteenth aspect based on the twelfth aspect, the suppliable product information includes cost information of the product,
The product information of the negotiation information includes a transaction unit price with the buyer.

According to a fourteenth aspect of the present invention, a computer-readable storage medium stores the processing steps of the product management method according to any one of claims 8 to 13.

[0028]

Embodiments of the present invention will be described below with reference to the drawings.

(First Embodiment) The present invention provides, for example,
It is applied to a product management system 10 as shown in FIG.
The merchandise management system 10 includes a plurality of buyers 100 (A), 100 including retail stores such as supermarkets.
(B), 100 (C),..., And the seller (manufacturer) 300 with the merchandise
Product management such as order management and inventory management. For this reason, a terminal device for merchandise management is provided on the seller side 300, and the terminal device (hereinafter referred to as “the seller side 300” including the terminal device for the sake of simplicity) is described in detail. Is the negotiation data 3 described later
11, stock amount data 312, and suppliable amount data 31
A database (DB) memory 310 in which 3 is stored;
A product management processing unit 320.

Here, first, the buyers 100 (A), 10 (A)
At 0 (B), 100 (C),..., Various commodity modes provided to consumers are provided with corresponding commodity modes according to a commodity code system dedicated to the buyer side. For example, according to the classification of products corresponding to the shelf layout as shown in FIG. 8 (classification according to consumer needs, etc.), the product code of "ABC001" is assigned to "beef-domestic-Japanese-beef-peach". The product code of "ABC003" is made to correspond to "beef-domestic-Japanese beef-fillet". With such a product code system, product management such as product order management and inventory management is performed.

On the other hand, on the seller side 300, the buyer side 100
According to a code system dedicated to the seller, which is different from the product code system of (A), 100 (B), 100 (C),..., Each of the products classified on the buyer side is classified more finely. Have a corresponding product code.
For example, depending on the difference in quality information (information such as the type of cereal used for breeding) as shown in FIG. 7, the product "beef-domestic-wagyu-thigh meat" is further finely divided into thigh meat A and thigh meat B. , Peach meat C, ...
With respect to these products of peach meat A, peach meat B, peach meat C,..., “RR0A”, “RR0B”, “RR0”
C ",.... With such a product code system, the buyer side 100 (A), 100 (B), 100
Similarly to (C),..., Product management such as product order management and inventory management is performed.

Therefore, the merchandise management processing section 320 of the seller 300 refers to the information in the DB memory 310 and
Execute various processes for product management. In particular, the merchandise management processing section 320 performs the purchaser side 100 (A), 100
(B), 100 (C),... Have a function (code conversion function) of associating the product code used by each of the sellers 300 with the product code used. As a result, buyers 100 (A), 100 (B),
100 (C),... And the seller side 3
00, the buyer side 100 (A), 100 (B), 100
(C),... And the seller side 300
, Even if the classification of the goods in the above is 1: n, the buyers 100 (A), 100 (B), 100 (C),.
The product management is performed by using the product code exclusive for the own side, and the seller 300 can also perform the product management using the product code exclusive for the own side. The product management processing unit 320 includes, for example, a CPU, and the CPU executes a processing program prepared in advance to execute various processing functions of the product management processing unit 320, which will be described later.

In the DB memory 310, "RR0A",
Information (stock amount data) of the stock amount of each product corresponding to the product code such as “RR0B”, “RR0C”,.
12 are stored, and the contents of the stock amount data 312 are updated according to the shipping amount at the time of shipping the product. For products such as meat, 1
Since the total amount (suppliable amount) of commodities that can be supplied to 00 (A), 100 (B), 100 (C),... Is determined in advance, the DB memory 310 The available supply amount data 313 of each product is stored. Further, the DB memory 310 has a
And buyers 100 (A), 100 (B), 100
(C),... (A), (B), (C),... (Hereinafter collectively referred to as “negotiation data 312”) generated by the negotiation with (C),. It has been made like that.

Hereinafter, the commodity management system 10 as described above
At the buyer side 100 (A), 100 (B), 100
(C),... And the seller 300 will be described in detail from the negotiation of the product (meat) to the shipment.

As shown in FIG. 1, first, the seller side 30
In accordance with the above-described negotiation cycle (two weeks, one month, etc.), the person 330 in charge goes to, for example, the buyer 100 (A) and conducts business with the person in charge 101 (A). The contents decided as a result of this negotiation are the person in charge 33 of the seller side 300.
0 terminal device (notebook personal computer, etc.) 3
12 is input.

FIG. 2 shows a negotiation result input screen of the terminal device 340. On such a negotiation result input screen, the person in charge 330 on the seller side 300 inputs the contents determined in the above negotiation.

Specifically, first, “customer code” and “customer code”
At this time, if "customer code" is entered, the corresponding "customer name" may be automatically displayed.Next, "sales period" is entered. The “sale period” indicates a period during which the buyer 100 (A) actually sells the product (meat meat) determined (contracted) in the negotiation. A name, a product code, an amount, and a unit price are input, where the product code indicates a product code according to a product code system on the buyer side 100 (A). "
The value set in “Amount” is the temporary amount (“sales period”)
Is a tentative quantity that the buyer side 100 (A) plans to sell during the period set in (1).

Therefore, for example, the products to be traded with the buyer 100 (A) are as follows: “product name” = “beef-domestic-Japanese-beef-peach”, “product code” = “ABC001”, “quantity” = “ 100 ”(Kg) and“ unit price ”=“ 500 ”(yen). In this case, the person 330 in charge of the seller 300
Is the beef-domestic-Japanese-beef-peach peach that is handled by itself, and is selected by the buyer 100 (A) from the peach meat A, peach meat B, peach meat C, and so on. Select the product corresponding to the above product (peach meat that fits the buyer's will). For example, the peach meat A is selected, and the corresponding “product code” is input. The “product code” here indicates a product code according to a product code system on the seller side 300. Also, according to the result of the other negotiations,
Considering the case where is not assigned to the buyer side 100 (A), two other products equivalent to the peach meat A are selected. For example, thigh meat D and E are selected, and the corresponding "product code" is input. Therefore, in the items of transaction products (1) to (3) on the negotiation result input screen, products such as thigh meat A, D, and E on the seller side 300 are input in priority order.

The values in parentheses of "trade products (1) to (3)" correspond to the priorities. The trade product (1) has the highest priority, and the trade product (2) , (3) in this order. Also, here, the number of traded products to be selected is three, but the number is not limited to three.

As described above, the data (negotiation data (A)) input to the terminal device 340 by the person in charge 330 of the seller 300 is transferred to the DB memory 310 of the seller 300 via the distribution center 200. It is stored as data 311. The storage at this time may be performed by an operation on the terminal device such as a manager or by communication via a network (transmitted directly from the terminal device 340 to the DB memory 310 of the seller 300. Etc.). Further, the other buyers 100 (B), 100
(C),...
In the same manner as (A), a negotiation with the seller side 300 is performed,
The result (negotiation data (B), (C),...) Is stored as negotiation data 311 in the DB memory 310 of the seller 300. Therefore, the DB memory 3 of the seller 300
The 10 negotiation data 311 includes the buyer side 100
(A), 100 (B), 100 (C),... Negotiation data (A), (B), (C),.
・ There will be.

Next, the seller side 300 and the buyer side 100
After negotiations with (A), 100 (B), 100 (C),..., The buyer side 100 (A), 100 (B), 100
(C),... Issue a final order request to the seller 300 (see the dotted arrow in FIG. 1). The issuance of this real order request is made on the day before the sales period (specifically, the sales date) desired in the negotiation, etc., by EOS (Electric Order System: Electronic Order System) or facsimile (FA).
X) or the like. For example, the buyer side 100 (A)
After the negotiation, on the day before the actual sales date, the “customer code” and “sales period” used in the negotiation (the “customer code” input to the terminal device 340 by the person 330 in charge of the seller 300) and Using the “sale period”), a final order request is issued to the seller side 300 via the distribution center 200. The real order request also includes information on the “quantity” (hereinafter, referred to as “actual order quantity”) that is actually desired to be received for each product desired in the negotiation. Therefore, the merchandise of the actual order quantity at this time is actually shipped from the seller 300 to the buyer 100 (A).

When the real order request as described above is issued to the seller side 300, the merchandise management processing section 3 of the seller side 300
20 is, for example, according to the flowchart shown in FIG.
It works as follows.

Step S400: Product management processing section 320
, A real order request from a certain buyer (here, the buyer 100 (A)) is received via the distribution center 200. As described above, this actual order request includes the information of the actual order quantity actually requested to be received for each product, together with the “customer code” and the “sales period”.

Step S401: Then, first, based on the "customer code" and "sales period" included in the above-mentioned order request, the merchandise management processing section 320 stores the corresponding negotiation data (X) in the DB memory 310. To get from. Here, for example, as shown in FIG.
It is assumed that negotiation data (A) for (A) is acquired. The negotiation data (A) is the same as that in FIG.
As shown in FIG. 7, the data 100 includes data (product data) (A-1), (A-2),... For a plurality of products such as beef thigh meat and beef fillet meat desired by the buyer 100 (A). Shall be.

Step S402: Next, the product management processing section 320 initializes a processing counter (internal counter) C1 (C1 = 1). The processing counter C1 is used to execute the processing after this step on all the product data (A-1), (A-2),... Constituting the negotiation data (A) acquired in step S401. It is provided in.

Step S403: Next, the merchandise management processing section 320 acquires merchandise data (A-C1) indicated by the processing counter C1 from the negotiation data (A) acquired in step S401. If the processing counter C1 = “1”, as shown in FIG. 4, “desired product” = “ABC001” (beef-domestic-
Wagyu-thigh meat), "amount" = "100", "unit price" = "500", "allocated product (1)" = "RR0A" (thigh meat A), "allocated product (2)" = "RR0D" (Thigh meat D), “allocated product (3)” = “RR0E” (Thigh meat E), and the product data (A-1) including the following information is obtained.

Step S404: Next, the product management processing unit 320 initializes the processing counter C2 (internal counter) (C2 = 1). The processing counter C2 is used to check the inventory of the products indicated by the product codes of the “allocated products (1) to (3)” (the product code of the seller 300) from those with the highest priority, that is, “allocate”. Product (1) ","
This is provided to check the allocation product (2) ”and the allocation product (3) in this order.

Step S405: Next, the merchandise management processing section 320 sets "trade merchandise (C2)" indicated by the processing counter C2 in the merchandise data (A-C1) acquired in step S403. Get product code. Then, the inventory amount of the product corresponding to the product code is obtained from the inventory data 312 of the DB memory 310. If the processing counter C2 = “1”, as shown in FIG. 4, “stock amount” = “5” of the product corresponding to the product code “RR0A” set in “allocated product (1)”.
0 "will be obtained.

Step S406: Next, the merchandise management processing section 320 compares the actual order quantity included in the real order request with the stock quantity acquired in step S405. It is determined whether or not there is. If the result of this determination is that “actual order quantity ≦ stock quantity”, step S
The processing from step 407 is executed, and if not, the processing from step S411 is executed.

Step S407: If the result of determination in step S406 is that "actual order quantity ≤ stock quantity", the product management processing unit 320 sets the product data (A-C1) to be processed at present. , A product corresponding to the product code set in “allocated product (C2)”. If the processing counter C1 = "1" and the processing counter C2 = "1", the buyer 100 (A) desires the product "ABC0".
For "01" (beef-domestic-Japanese beef-thigh meat), the product "RR0A" (thigh meat A) of the seller 300 with the highest priority is allocated.

Step S408: After that, the merchandise management processing section 320 updates the contents of the inventory data 312 in the DB memory 310 in accordance with the actual order amount (inventory amount = inventory amount-).
(The actual order quantity) and the processing counter C to execute the processing from step S403 on the next product data.
Count up 1 (C1 = C1 + 1).

Step S409: Then, the product management processing section 320 determines whether or not the processing counter C1 has exceeded the total number m of the product data constituting the negotiation data (A) as a result of the count-up in step S408, Step S4 for product data (A-1) to (A-m)
It is determined whether or not the processing from step 03 has been completed. If the result of this determination is that processing has ended, the next step S4
The process proceeds to step S10, and if not, returns to step S403 to repeatedly execute the subsequent processes.

Step S410: When the processing on all the product data (A-1) to (A-m) constituting the negotiation data (A) is completed, the product management processing unit 320 makes the product data obtained by the process (A-1) to (A-m)
Is output as the shipping instruction information (the allocation result information in step S407). Therefore, the person in charge of shipping on the seller side 300 performs a procedure for shipping the corresponding product to the buyer side 100 (A) based on the shipping instruction information.

Step S411: Step S40
If the result of the determination in step 6 is not “actual order quantity ≦ inventory quantity”, the product management processing unit 320 counts up the processing counter C2 in order to check the inventory quantity of the next highest priority reserved commodity ( C2 = C2 + 1).

Step S412: The product management processing unit 320 determines whether or not the processing counter C2 has exceeded "3" as a result of the count-up in step S411, that is, the "allocated product (3) having the lowest priority". It is determined whether or not the inventory amount check has been completed up to "". As a result of this determination, if the inventory amount has not been checked up to “allocated product (3)”, the process returns to step S405 and the subsequent processes are repeatedly executed. As a result, "Trade Product (1)"
If the stock quantity of the product is less than the actual order quantity, the stock level of the product of the next highest priority "trade product (2)" is checked, and the stock of the product of this "trade product (2)" is checked. If the quantity is less than the actual order quantity, the inventory quantity of the next highest priority "trade product (3)" is checked, and so on. The stock amount of the corresponding product will be checked. When the check of the inventory amount is completed up to “allocated product (3)”, this is the inventory amount of all the products indicated by the product codes set in “transaction products (1) to (3)”. However, this is the case where the actual order quantity desired by the buyer 100 (A) is less than the actual order quantity. Therefore, in this case, information (error information) indicating that fact is temporarily stored internally, and then stored in step S40.
In the processing of step S410 after the execution of the processing of steps 8 to S409, the above error information is included in the shipping instruction information and output. Thus, in this case, the person in charge of shipping grasps this situation and performs a procedure to deal with it.

As described above, in the present embodiment, the product code system on the buyer side 100 (X) included in the result of the negotiation (negotiation data (X)) between the buyer side 100 (X) and the seller side 300. (The beef-domestic-Japanese-beef-
For example, a plurality of products (allocation products such as “peach meat A, peach meat B, and peach meat C”) selected in priority order from the stock items on the seller side 300 with respect to Are stored in the DB memory 310 in association with product codes (“RR0A”, “RR0B”, “RR0C”, etc.) according to the product code system (second product code system). When the buyer 100 (X) issues a real order request based on the first product code system, the negotiation data (X) corresponding to the real order request specified from the negotiation data stored in the DB memory 310. In step (1), with respect to the products indicated by the first product code system, the allocation products indicated by the second product code system associated with the products are allocated in order of priority. Thus, even if the buyer 100 (X) and the seller 300 have different product code systems, the seller 3
At 00, the desired product (product indicated by the first product code system) indicated by the real order request from the buyer 100 (X) is changed to the product (product indicated by the second product code system) on the seller side 300. ) (Interpretation function in which the first product code system is automatically recognized by the second product code system), and therefore, product management such as order management and inventory management as in the past. Need not be done manually.

(Second Embodiment) In the first embodiment described above, at the time of negotiation between the buyer side 100 (X) and the seller side 300, the person in charge 330 of the seller side 300 makes contact with the buyer side 1 (X).
A plurality of commodities (allocated commodities (1) to (3)) are selected in descending order of priority as commodities on the seller side 300 corresponding to the desired commodities of 00 (X). On the other hand, in the present embodiment, the priority of the plurality of allocated products is not determined by the person in charge 330 of the seller 300, but is automatically determined by the product management processing unit 320 so as to be most effective. decide.

For this reason, the merchandise management processing unit 320 operates as follows, for example, according to a flowchart shown in FIG. 5 before executing the processing at the time of the real order request shown in FIG.

Step S500: The negotiation data 311 in the DB memory 300 includes the negotiation data 311 described in the first embodiment,
Assume that negotiation data (A), (B), (C),... For (B), 100 (C),. At this time, the product codes of “trade products (1) and (2)” set in the respective negotiation data are set in an arbitrary order (order in which priority is not considered).

Step S501: First, the merchandise management processing section 320 converts the negotiation data stored as the negotiation data 311 in the DB memory 300 within the predetermined period set in advance into the currently stored negotiation data (A). ,
(B), (C),... Are extracted.

Step S502: It is assumed that the negotiation data (B), (D), (F), and (H) are extracted as a result of the extraction in step S501, for example, as shown in FIG. Therefore, the product management processing unit 320 stores the product data (B-1), (B-2),... Of the negotiation data (B).
Product data (D-1), (D-
2), ..., product data (F-
1), (F-2),... And the merchandise data (H-1), (H-2),... Of the negotiation data (H) are sorted in the order of merchandise data having the highest transaction unit price. As a result, FIG.
Then, transaction unit price = (550) (B-5), transaction unit price = (530) (H-1), transaction unit price = “400” (B-3), transaction unit price = “350” (D) -2), the product data is sorted in the order of (F-3) of the transaction unit price = “340”, and so on (hereinafter “sort”).
To say). At this time, if there is product data of the same unit price, the process proceeds according to a predetermined priority assigned to the product data. For example,
The earlier time stored in the DB memory 310 is prioritized.

Step S503, Step S504: Next, the product management processing unit 320 acquires the target product data (Xn) in accordance with the order of the sorting in Step S502 (Step S503), and obtains the target product data (X −
"Transaction products (1) to (3)" set in n)
By referring to the suppliable amount data 313 of the DB memory 310, sorting is performed in ascending order of cost (hereinafter, referred to as "sort") (step S504). Here, as shown in FIG. 6, the suppliable amount data 313 includes “RR0A” and “RR0” in the same manner as the inventory amount data 312 described above.
The “cost” and “suppliable amount (available amount)” of each product are set in accordance with the product code on the seller side 300 such as “B”, “RR0C”,. Therefore, for example, when the target product data is the product data (B-5) having the highest transaction unit price (see FIG. 6), the product data includes “trade products (1) to (3)”.
Are set as product codes "RR0A", "RR0B", and "RR0G", and their costs are "200",
Since “220” and “190”, “RR0”
G "," RR0A ", and" RR0B ".

Step S 505, Step S 506: Next, the merchandise management processing unit 320 obtains “suppliable amount” of the target merchandise code by referring to the suppliable amount data 313 in the order of sorting in step S 504. (Step S505), and comparing the suppliable amount with the “amount” (temporary order amount) of the target product data (X-n), the target product code (X-n) is compared with the target product code (X-n). It is determined whether or not it is possible to allocate the product (step S506). For example, if the target product data is (B
-5), and the target product code is "RR
0G ”(see FIG. 6 above), the tentative order quantity (20
0)> Suppliable amount (150) (cannot be allocated)
The process returns to step S505 to check the suppliable amount of the next traded product (2). At this time, if the allocation is possible (temporary order amount ≦ suppliable amount), the process proceeds to the next step S507.

Step S507, step S508: As a result of the determination in step S506, the target product data (X-
If it is possible to allocate the product of the target product code to n), the product management processing unit 320 determines the allocation (step S507), and sets the “suppliable amount” of the target product code to the target product. The data (X-n) is updated based on the tentative order quantity (suppliable quantity = suppliable quantity-temporary order quantity) (step S508).

Step S509: Then, the product management processing section 320 determines whether or not there is a product code to be processed next, and if so, returns to step S503 and repeatedly executes the subsequent processing steps. If not, the process ends.

As described above, in the present embodiment, in each product data constituting each negotiation data within a predetermined period,
First, the respective merchandise data is sorted in descending order of the transaction unit price, and the merchandise indicated by the merchandise (1) to (3) in the target merchandise data (the merchandise on the seller side 300) is sorted in ascending order of cost in accordance with the order. Then, according to the order, it is determined that a product satisfying the provisional order quantity of the target product data is allocated to the target product data. As a result, each product data can be processed in an order that is advantageous to the seller 300, and the transaction products (1) to (3) in each product data can be processed in an order that is advantageous to the seller 300. Can be allocated to product data. In other words, prior to the issuance of a full order request from the buyer side (before actual shipment of the product), the priority of the most advantageous transaction products (1) to (3) for the seller side 300 is automatically determined.
You can have it for each product data of each negotiation data,
Products can be allocated in the priority order. Also,
According to the suppliable amount data 313 of the DB memory 310,
Since the order status (provisional order status) from the buyer side can be grasped in advance, for example, it is possible to grasp in advance which product is currently provided to the buyer side and which is most advantageous for the seller side 300 in advance. You can keep. This allows
The person in charge 330 of the seller 300 can carry out the most efficient sales activities according to the situation at that time. Further, since the remaining goods can be predicted earlier, the sales form for the remaining goods can be changed to the most efficient form earlier. For example, products such as meat remaining as products are frozen at that time, so the price will decrease accordingly, but if that prediction can be made in advance,
Before freezing, it can be sold at a higher price than the price after freezing. Furthermore, the above-described negotiation cycle can be accelerated, which is advantageous for both the seller and the buyer.

As a modified example of the above-described second embodiment, for example, the merchandise codes of the seller side 300 are sorted in descending order of cost, and the buyer side 100 (A), 100
(B), negotiation data for (A), (B),
.. May be sorted in descending order of the transaction unit price, and the above-mentioned product allocation may be performed in accordance with the sorted order.

In the first and second embodiments described above, the processing shown in FIG. 3 (commodity allocation processing) is executed in the order of issuance of this order request. However, the present invention is not limited to this. For example, a priority may be assigned to the buyer side, and the processing may be executed according to the priority. Also, here, the target product is "meat",
It is not limited to this. For example, the present invention can be applied to products with a limited expiration date and a predetermined supply amount, such as fresh products such as vegetables and meat, air tickets, and concert tickets.

Further, an object of the present invention is to provide a storage medium storing a program code of software for realizing the functions of the host and the terminal according to each of the above-described embodiments to a system or an apparatus, and to provide Needless to say, this can also be achieved by a program (or CPU or MPU) reading and executing a program code stored in a storage medium. In this case, the program code itself read from the storage medium realizes the function of each embodiment, and the storage medium storing the program code constitutes the present invention. As a storage medium for supplying the program code, RO
M, floppy disk, hard disk, optical disk, magneto-optical disk, CD-ROM, CD-R, magnetic tape, nonvolatile memory card, and the like can be used. In addition, by executing the program code read by the computer, not only the functions of the embodiments are realized, but also based on the instructions of the program code,
It goes without saying that the OS or the like running on the computer performs part or all of the actual processing, and the processing realizes the functions of the embodiments.
Further, after the program code read from the storage medium is written to a memory provided in an extension function board inserted into the computer or a function extension unit connected to the computer, the function extension is performed based on the instruction of the program code. C provided on board and function expansion unit
It goes without saying that a PU or the like performs part or all of the actual processing, and the processing realizes the functions of the embodiments.

[0070]

As described above, according to the present invention, even if the product code system on the buyer side is different from the product code system on the seller side, the seller uses the product code system on the buyer side. By associating a code with a code based on a product code system on the seller side, product management on the seller side can be performed electronically using the code.

More specifically, for example, the product indicated by the first code on the buyer side (“beef meat indicated by“ ABC001 ”) included in the result of the negotiation (negotiation information) between the buyer and the seller. For fresh products such as "domestic-Japanese-beef-peach", a plurality of products selected in the order of priority from stock items on the seller side ("peach meat A" which is further finely classified with respect to the product classification on the buyer side). , Thigh meat B, thigh meat C ", etc.) and the second code (" RR0A ",
"RR0B", "RR0C", etc.) and store them in the negotiation information memory. When the buyer issues a real order request using the first code, the negotiation information corresponding to the real order request specified from the negotiation information stored in the negotiation information memory is indicated by the first code. The allocated products indicated by the second code corresponding to the allocated products are allocated in order of priority. As a result, for the target product, a single product such as "beef-domestic-Japanese-Japanese beef-peach" on the buyer side is further finely classified on the seller side by quality information (information on the grains used for breeding). Peach meat A, peach meat B, peach meat C,
Even if it is not possible to unify the product code system on the buyer side and the seller side because the product corresponds to the n products (the relationship of 1: n), the seller side will be the buyer side. Since the desired product (product indicated by the first code) indicated by the real order request from the seller is automatically associated with the product (product indicated by the second code) on the seller side (first The code is automatically recognized by the second code (interpretation function), and the seller does not need to manually perform merchandise management such as order management and inventory management as in the related art.

Further, in a plurality of pieces of negotiation information stored in the negotiation information memory within a predetermined period, the order of allocation processing is determined based on the product information (transaction unit price, etc.) of each negotiation information (priority is given in descending order of transaction unit price). Degrees are determined, etc.), and according to the allocation processing order, the allocation processing order of the plurality of second codes associated with the first code in the target negotiation information is changed to a supplyable product corresponding to each second code. Is determined based on the information (product cost, etc.) (priority is determined in ascending order of product cost, etc.), and is associated with the product indicated by the first code of the target negotiation information according to the allocation processing order. The assigned second coats are sequentially assigned.
As a result, the negotiation information can be allocated to the seller in an order that is advantageous to the seller, and the merchandise (the product indicated by the second code) on the seller side is advantageous to the seller for each negotiation information. Can be allocated in any order. Further, the supply available product information in the supply available information memory is updated in accordance with the content of the negotiation information, and the like, so that the order status (provisional order status) from the buyer can be grasped in advance from the update result. Therefore, for example, it is possible to know in advance which product is currently provided to the buyer side and is most advantageous to the seller side. As a result, the seller's person in charge can carry out the most efficient sales activities according to the situation at that time. Further, since the remaining goods can be predicted earlier, the sales form for the remaining goods can be changed to the most efficient form earlier. For example, products such as remaining meat, which are frozen at that time, will be frozen at that time, so the price will drop accordingly, but if that prediction can be made in advance, before the freezing, the price will be higher than the price after freezing. Can be sold at a price. Furthermore, the business cycle between the buyer and the seller can be made faster, which is advantageous for both the seller and the buyer.

Thus, according to the present invention, even if a product has a limited expiration date and a predetermined supply amount, such as a fresh product such as meat or an airline ticket, the product management is performed by the seller. It can be done easily and efficiently on both the buyer and buyer sides.

[Brief description of the drawings]

FIG. 1 is a block diagram showing a configuration of a product management system to which the present invention is applied in a first embodiment.

FIG. 2 is a diagram for explaining negotiation data on a buyer side generated at the time of negotiations in the product management system.

FIG. 3 is a flowchart for explaining a process of assigning a product indicated by a seller's product code to a product indicated by a buyer's product code included in the negotiation data.

FIG. 4 is a diagram illustrating a specific example of the allocation processing.

FIG. 5 In the second embodiment, after the negotiation, the priority of a plurality of products indicated by the seller's product code to be allocated to the product indicated by the buyer's product code is automatically determined. Is a flowchart for explaining the processing for this.

FIG. 6 is a diagram illustrating a specific example of the priority determination process.

FIG. 7 is a diagram for explaining classification of commodities on a general buyer side (such as a supermarket).

FIG. 8 is a diagram for explaining a difference in the classification of the merchandise on the seller side (manufacturer side) with respect to the classification of the merchandise on the buyer side.

[Explanation of symbols]

 10 Merchandise management system 100 (A), 100 (B), ... Buyer side 101 (A) Buyer's person in charge 200 Distribution center 300 Seller side 310 Database memory 311 Business negotiation data 312 Stock amount data 313 Suppliable amount data 320 Merchandise management processor 330 Person in charge of seller 340 Terminal device

Claims (14)

[Claims] 1. The negotiation information including information of a product indicated by a first code according to a first product code system on the buyer side, which is determined by a negotiation with a buyer who is a shipping destination of the product. A merchandise management apparatus on the seller side for assigning a corresponding merchandise from the stock merchandise to the merchandise indicated by the first code, wherein the information on the stocked merchandise is stored in a second merchandise code on the seller side Inventory information storage means for storing in association with a second code according to a system; and a plurality of inventory information indicating a plurality of types of inventory products selected as products corresponding to the product indicated by the first code in the negotiation information. A negotiation information storage unit that stores the second code in association with the first code; and a negotiation information storage unit that is stored in the negotiation information storage unit based on inventory product information stored in the inventory information storage unit. A product allocation that allocates, in a predetermined order, a plurality of types of inventory products indicated by the plurality of second codes associated with the first code with respect to the product indicated by the first code in the negotiation information. A product management device comprising: 2. The merchandise management apparatus according to claim 1, wherein the predetermined order includes an order of priority added to each of the plurality of second codes. 3. The merchandise allocation means, when a real order request for the goods indicated by the second code is issued from the buyer, is stored in the negotiation information storage means corresponding to the real order request. 2. The merchandise management apparatus according to claim 1, wherein said processing is executed for negotiation information. 4. The product has a limited expiration date,
2. The merchandise management apparatus according to claim 1, wherein the suppliable amount to the buyer includes merchandise whose predetermined amount is determined in advance. 5. A suppliable information storage means for storing information on commodities which can be supplied to the buyer side in association with the second code, and a plurality of information stored in the negotiation information storage means within a predetermined period. First determining means for determining the allocation processing order of the negotiation information based on the product information included in the negotiation information, and according to the processing order determined by the first determining means,
And second determining means for determining the allocation processing order of the plurality of second codes associated with the target negotiation information based on the supplyable product information stored in the supplyable information storage means. The merchandise management device according to claim 1, wherein: 6. The merchandise management apparatus according to claim 5, wherein the suppliable merchandise information includes cost information of the merchandise, and the merchandise information of the negotiation information includes a transaction unit price with the buyer. 7. A buyer side that manages a product by a first code according to a first product code system and a seller side that manages a product by a second code according to a second product code system. It is a goods management system, Comprising: The said seller side has the function of the goods management apparatus in any one of Claims 1-6, Comprising: The goods management system characterized by the above-mentioned. 8. Management of a product supplied to a buyer who manages a product by a first code according to a first product code system is performed by a second code according to a second product code system. A merchandise management method on the seller side for storing information on stocked goods in the stock information memory in association with the second code, and the second information determined by the negotiation with the buyer side. The negotiation information stored in the negotiation information memory in association with the negotiation information including the information of the product indicated by the first code and the plurality of second codes indicating the plurality of types of stock products selected as the products corresponding to the product An information storage step; a product indicated by the first code of the negotiation information stored in the negotiation information memory based on the inventory product information stored in the inventory information memory A product allocation step of allocating a plurality of types of inventory products indicated by the plurality of second codes associated with the first code in a predetermined order. 9. The product allocation step includes a step of executing the allocation processing by setting the predetermined order to an order of priority added to each of the plurality of second codes. Item 8 management method. 10. The commodity allocation step includes: when a real order request for the commodity indicated by the second code is issued from the buyer, a negotiation stored in the negotiation information memory corresponding to the real order request. 9. The product management method according to claim 8, further comprising the step of executing the above-mentioned processing for the information. 11. The merchandise management method according to claim 8, wherein the merchandise includes a merchandise whose expiration date is limited and whose supply amount to the buyer is determined in advance. 12. A suppliable information storage step of storing information of commodities that can be supplied to the buyer side in a suppliable information memory in association with the second code, and the negotiation information storage memory within a predetermined period. A first deciding step of deciding the allocation processing order of a plurality of pieces of negotiation information stored in the negotiation information based on the product information included in the negotiation information; And a second determining step of determining the allocation processing order of the plurality of second codes associated with the information based on the supplyable product information stored in the supplyable information memory. The product management method according to claim 8. 13. The product management method according to claim 12, wherein the suppliable product information includes cost information of the product, and the product information of the negotiation information includes a transaction unit price with the buyer. 14. A storage medium, wherein the processing steps of the product management method according to claim 8 are stored in a computer readable manner.