JP2001297239A - Stock managing method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a stock managing method which can reduce the danger of overstocking at a store and speedily meets the demand of a user. SOLUTION: A system to which this stock managing method is applied is constituted by connecting a buyer's computer 1, a store's computer 2, and an article selling/buying management computer 3 to the Internet 100 and providing the article selling/buying management computer 3 with a customer information database 4. A customer accesses the article selling/buying computer 3 from the buyer's computer 1 through the Internet 100 and registers order information in the customer information database 4 and the store refers to the customer information database 4 from the store's computer 2 through the Internet 100. At this time, the purchase results of the customer are registered as a customer reliability coefficient in the customer information database 4, so the stock can be managed according to order information having a higher customer reliability coefficient and the danger of overstocking at the store is reducible.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an inventory management method, and more particularly to an inventory management method for merchandise in a store using a communication line such as the Internet.

[0002]

2. Description of the Related Art Conventionally, in a store that sells products, information on which product the customer purchases and when was actually unknown information until the customer actually came to the store and purchased the product. There was a need to not miss a sales opportunity for the product, or to prepare an excessive inventory according to the customer's request for the trust of the dealer.

[0003]

However, for each dealer, preparing excess inventory means that there is a great danger that the goods will be unsold and the inventory will be held up. There has been a problem that the sales floor area is occupied and the product value is reduced with the passage of time.

[0004] In order to prevent a store from holding excess inventory, it is sufficient to purchase the product by estimating the inventory to a small amount. However, when the product is sold out, it not only loses sales opportunities but also trusts customers. There was a problem that could also lose.

[0005] As described above, there is a situation in which a store must purchase a product that does not know whether it can be sold or not, including the risk of excess inventory due to experience and can.

The present invention has been made in view of the above problems, and provides an inventory management method capable of reducing the risk of excessive inventory at each store and promptly responding to user requests. The purpose is to:

[0007]

According to the first aspect of the present invention, there is provided a transmission system in which a customer transmits order information of a desired product from a customer side terminal to a product sales management terminal via the Internet. Step, a registration step of registering the order information received by the merchandise trading management terminal in the customer information database, and a dealer accessing the merchandise trading management terminal from the dealer terminal via the Internet and registering the customer information database. And a reference step of referring to the order information. The store manages the stock of the goods based on the order information referred to by the reference step.

[0008] According to a second aspect of the present invention, in the first aspect of the invention, the order information includes at least a product to be purchased,
It is characterized by comprising a planned purchase quantity and a purchase date.

The invention described in claim 3 is the first or second invention.
In the invention described above, the customer information database registers order information from a plurality of customers for each customer.

According to a fourth aspect of the present invention, in the first aspect of the present invention, the customer information database stores a customer ID (identification number) arbitrarily assigned to each customer. An ID storage field, a customer reliability coefficient storage field for storing a customer reliability coefficient based on the purchase performance of each customer, a product code storage field for storing a product code obtained by coding a product to be purchased by each customer, A field for storing the planned purchase quantity of the planned product, a field for storing the planned purchase date of the product to be purchased, and a field for storing the product code, the planned purchase quantity, and the planned purchase date. And a pointer storage field for storing a pointer indicating whether the customer ID is assigned to each customer. It is characterized in.

According to a fifth aspect of the present invention, in the invention of the fourth aspect, the customer reliability coefficient has a predetermined value when the product of the product code stored in the product code storage field is purchased on the scheduled purchase date. A predetermined value is subtracted when the product of the product code stored in the product code storage field is not purchased on the scheduled purchase date on the purchase date.

The invention according to claim 6 is the invention according to claim 4 or 5.
In the described invention, the store manages the product inventory based on order information from a customer having a high customer reliability coefficient.

According to a seventh aspect of the present invention, in the invention according to any one of the fourth to sixth aspects, when the customer who has transmitted the order information purchases the product to be purchased, the sales terminal Access to the merchandise trading management terminal via the Internet, refer to the customer reliability coefficient registered in the customer information database, and sell the merchandise at a discount rate according to the customer reliability coefficient. .

According to an eighth aspect of the present invention, in the first aspect of the invention, the order information includes at least a product to be purchased,
The planned number of purchases, the planned purchase date, and the card number of the credit card owned by the customer. And characterized by the following.

According to a ninth aspect of the present invention, in the invention of the eighth aspect, the customer information database registers order information from a plurality of customers for each customer.

According to a tenth aspect of the present invention, in the invention of the eighth or ninth aspect, the customer information database includes a customer ID storage field for storing a customer ID (identification number) arbitrarily assigned to each customer, Card No. of credit card owned by each customer Card N that stores
o. A storage field, a product code storage field for storing a product code obtained by coding a product to be purchased by each customer, a purchase quantity storage field for storing a planned purchase quantity of the product to be purchased, and a planned purchase date of the product to be purchased. A field for storing a planned purchase date to be stored, and a pointer storage field for storing a pointer indicating which field stores the product code, the planned number of purchases, and the planned purchase date, are stored in a customer ID assigned to each customer. It is characterized by being associated and managed.

According to an eleventh aspect of the present invention, in the invention according to the tenth aspect, the store determines the card number from the order information referred to in the reference step. After reading the credit card, the card company terminal is accessed via the Internet, and there is an inquiry step of requesting an inquiry of the customer, and an acquisition step of acquiring the credit information of the inquired customer. It is characterized in that merchandise inventory is managed based on order information from a customer with high information.

According to a twelfth aspect of the present invention, in the invention of the eleventh aspect, when the customer who has transmitted the order information purchases the product to be purchased, the store adds the customer's credit information obtained in the obtaining step. The product is sold at a corresponding discount rate.

<Operation> According to the present invention, a customer accesses a merchandise sales management terminal via the Internet, registers a planned purchase item, a planned purchase quantity, and a planned purchase date in a customer information database as order information. Inventory management and replenishment are performed from the store terminal with reference to the customer information database via the Internet, and the purchase results of the customer are registered in the customer information database as customer reliability coefficients.

[0020]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Next, an inventory management method according to an embodiment of the present invention will be described in detail with reference to the accompanying drawings.
1 to 7 show an embodiment of a stock management method according to the present invention.

FIG. 1 is a system configuration diagram to which an inventory management method according to an embodiment of the present invention is applied. In FIG.
A system to which an inventory management method according to an embodiment of the present invention is applied includes a purchaser computer 1 and a store computer 2
And the merchandise trading management computer 3 are connected to the Internet 100.
A customer information database 4 is provided.

The purchaser computer 1 is a computer terminal owned by each customer.
A product sales management computer via the Internet 100, referring to a product information providing HP (homepage), an advertisement, and the like, which are established by the store, and as order information, information such as a planned product name, a planned number of products, and a planned purchase date. Send to 3.

The purchaser computer 1 may be a computer terminal owned by each customer as described above, or may be a mobile communication portable terminal having an access function to the Internet 100. Is also possible.

For example, when the purchaser computer 1 is constituted by a mobile communication portable terminal, "when", "where",
Since the time and place are not restricted, the convenience of the user is further improved.

The store computer 2 is a computer terminal owned by each store, and the Internet 10
0, access the merchandise sales management computer 3 via
The customer information stored in the customer information database 4 is referred to. Each retailer refers to each customer information stored in the customer information database 4 as a reference for purchasing goods.

The store computer 2 creates an HP for providing product information as described above,
It also has a function of creating and delivering an e-mail or the like for notifying product information to each customer owned as customer information.

The merchandise sales management computer 3 is provided with a customer information database 4. In response to access from the purchaser computer 1, the order information transmitted from the customer is written in the customer information database 4, In response to the access, reading of a designated customer's database or writing to the database is performed.

In the customer information database 4, in response to the access by the purchaser computer 1 described above, information such as the name of the product to be purchased, the number of products to be purchased, and the date of purchase of each customer is provided with an ID (customer ID) for each customer. Is managed.

The customer ID is stored in the merchandise sales management computer 3 for a customer who uses the system for the first time.
After acquiring necessary information, a new customer ID is issued.

FIG. 2 is a configuration diagram of information managed in the customer information database according to the embodiment of the present invention. 2, the customer information database 4 in the embodiment of the present invention includes a customer ID 41, a customer reliability coefficient 42,
And a pointer storage field 43.

The information indicated by each pointer stored in the pointer storage field 43 includes a product code 431, a planned purchase section 432, and a planned purchase number 43.
3, the purchased mark 434 and the like are stored and managed in each field.

It is to be noted that the present invention is not limited to such information, and for a newly required category, a separate field can be provided and added in association with a customer ID for each customer.

The customer ID 41 is a customer identification number for uniquely identifying a customer assigned to each customer by the product sales management computer 3. The customer ID 41 is assigned to a customer who has accessed the product sales management computer 3 for the first time. After confirming the necessary items, you will be assigned. The customer ID 41 is written on a card issued as a customer card when the customer actually visits the store. By presenting the customer card at the time of product purchase, the customer can receive a discount privilege according to the purchase result (customer reliability coefficient).

The customer reliability coefficient 42 indicates how much the customer can trust based on the customer's purchase results so far. The larger the value, the greater the reliability, and the smaller the value, the smaller the reliability. . If you use this system to register order information in the past and actually purchase the product on the planned purchase date, a predetermined value will be added, and the product will be purchased or purchased after the planned purchase date If not, the customer reliability is digitized by subtracting a predetermined value.

The pointer storage field 43 includes a product code 431, a planned purchase unit 432, and a planned purchase number 4 described later.
33, location information indicating in which area information such as the purchased mark 434 is stored.

The product code 431 is obtained by coding the name of a product to be purchased input by the customer.
Even when an actual product name is input on the purchaser computer 1, when data is stored in the customer information database 4, information coded based on a predetermined code table or the like is stored.

The planned purchase date 432 stores information on the date on which the customer will actually purchase the product.
Stores information on the number of products to be purchased.

As the purchased mark 434, a mark indicating that the product has been purchased is recorded when the customer has actually purchased the product on the scheduled purchase date desired by the customer, and nothing is recorded when the product has not been purchased. Not done.

As shown in FIG. 2, the information stored in the customer information database 4 is, for example, that the customer information on the customer A is all associated with the customer ID issued to the customer A. , And all the customer information relating to the customer E is managed in association with the customer ID issued to the customer E.

When the same customer places an order for a plurality of products, as shown in the figure, the number of products to be purchased can be registered for one customer ID.

FIG. 3 is a diagram showing a specific example of the customer information database according to the embodiment of the present invention. In FIG. 3, for example, as order information of a customer A who has a purchase record,
It is assumed that the purchaser's computer has transmitted information such as the purchase of one black audio rack to the merchandise trading management computer 3 on April 24.

At this time, the information written in the customer information database 4 is associated with the customer ID 41 (0000123A) already issued to the customer A, and the customer reliability coefficient 42 (80) based on the purchase result and the black The product code 431 (AUDIO001) encoding the audio rack, the planned purchase date 432 (00/04/24), and the planned purchase number 433 (1) are written.

In FIG. 3, for example, as the order information of the customer B who has no purchase record, information such as a plan to purchase 30 gray business work tables on April 30 from the purchaser's computer is shown in FIG. 3 is transmitted.

At this time, the information written in the customer information database 4 is the customer I issued after inquiring the customer B about necessary items from the merchandise sales management computer 2.
D41 (0000456B), a customer reliability coefficient 42 (20) based on no purchase record, a product code 431 (TABLE005) that codes a gray business work table, and a planned purchase date 432 (00/04/30) ), The planned purchase number 433 (30), and so on.

In the above-described embodiment, the customer reliability coefficient 42 is arbitrarily digitized based on a standard of 0 to 100. For example, the digitized value is assigned to ranks A to E. It is also possible to manage.

FIG. 4 is a sequence diagram showing an example of processing by the inventory management method according to the embodiment of the present invention. In FIG. 4, first, merchandise information to be provided to a customer is registered from the merchant computer 2 to the merchandise trading management computer 3 (step S1). Each customer is a buyer computer 1
Accesses the merchandise sales management computer 3 to request merchandise information (step S2).

The merchandise sales management computer 3 transmits the merchandise information requested by the customer to the purchaser computer 1 (step S3). Each customer transmits desired order information from the purchaser computer 1 to the product sales management computer 3 while referring to the product information (step S4).

The order information received by the merchandise sales management computer 3 is registered in the customer information database 4 for each customer (step S5).

The store requests customer information from the store computer 2 to the merchandise sales management computer 3 (step S6). The customer information requested here is customer information stored in the customer information database 4 managed by the merchandise sales management computer 3, and is used to confirm whether new information has been added. is there.

The merchandise sales management computer 3 requests the customer information database 4 to read the customer information (step S7), and acquires the customer information (step S7).
8). The customer information thus acquired is transmitted from the merchandise sales management computer 3 to the store computer 2.

The store not only manages the inventory based on the order information such as the planned purchase item, the planned purchase quantity, and the purchase date with reference to the customer information obtained as described above, but also manages the inventory. Product purchase and inventory management are performed by referring to order information from customers who are actually expected to purchase based on the customer reliability coefficient, so unsold products or unsold products that are pointed out in the above problems It is possible to prevent a decrease in commercial value.

When the customer who ordered the product to be purchased actually visits the store and purchases the product as described above, the customer card described above is presented, and the store displays the customer card on the customer card. Using the customer ID to be used as a key, the merchandise sales management computer 3 is accessed from the store computer 2 to perform discount sales of the product amount in proportion to the customer reliability coefficient of the customer information registered in the customer information database 4. Do.

FIG. 5 is a system configuration diagram to which an inventory management method according to another embodiment of the present invention is applied. 5 differs from the above-described embodiment of the present invention in that the card company computer 5 is connected via the Internet 100.

In FIG. 5, a system to which an inventory management method according to another embodiment of the present invention is applied includes a purchaser computer 1, a store computer 2, a merchandise sales management computer 3, a card company computer 5, Are connected via the Internet 100, and the merchandise sales management computer 3 is provided with a customer information database 4.

In the embodiment of the present invention, the value recorded in the customer reliability coefficient 42 is based on the past purchase performance of the customer, but in another embodiment of the present invention, the credit owned by the customer is Inquiry is made to the card company computer 5 based on the card number of the card, and the credit information of the customer is referred to determine the reliability of the customer.

The credit card No.
Is transmitted as encrypted information on the Internet.

FIG. 6 is a diagram showing a specific example of a customer information database according to another embodiment of the present invention. In FIG. 6, for example, as order information of the customer C, 15 blue desk lamps are scheduled to be purchased from the purchaser computer 1 on April 13, and the card No. of the credit card owned by the customer C will be described. It is assumed that information such as 12345678 is transmitted to the commodity trading management computer 3.

At this time, the information written in the customer information database 4 is the customer ID 41 issued to the customer C.
(0000789C) and credit card N
o. Is written in the customer reliability coefficient 42 (12345678), and the product code 431 (ERECT
007), planned purchase date 432 (00/04/13), planned purchase number 433
(15), and so on.

In FIG. 6, for example, as the order information of the customer D, five sets of pastel-colored dish sets are scheduled to be purchased from the purchaser computer 1 on April 25, and the credit owned by the customer D is assumed. Card No. of the card It is assumed that information such as 2681357 has been transmitted to the commodity trading management computer 3.

At this time, the information written in the customer information database 4 is the customer ID 41 issued to the customer D.
(0000135D) associated with credit card N
o. Is written in the customer reliability coefficient 42 (24681357)),
Product code 431 (DISHS003) coded pastel color dish set, scheduled purchase date 432 (00/04/2
5), the planned purchase number 433 (5), and so on.

FIG. 7 is a sequence diagram showing an example of processing by the inventory management method according to another embodiment of the present invention. FIG.
First, the merchandise store computer 2 registers merchandise information to be provided to the customer in the merchandise sales management computer 3 (step S11). Each customer accesses the merchandise sales management computer 3 from the purchaser computer 1,
Request product information (step S12).

The merchandise sales management computer 3 transmits merchandise information requested by the customer to the purchaser computer 1 (step S13). Each customer transmits desired order information from the purchaser computer 1 to the product sales management computer 3 while referring to the product information (step S14).

The order information received by the commodity sales management computer 3 is registered in the customer information database 4 for each customer (step S15).

The store requests customer information from the store computer 2 to the product sales management computer 3 (step S16). The customer information requested here is
This is customer information stored in the customer information database 4 managed by the merchandise sales management computer 3, and is used to confirm whether new information has been added.

The merchandise sales management computer 3 requests the customer information database 4 to read the customer information (step S17), and acquires the customer information (step S17).
18). The customer information thus obtained is transmitted from the merchandise sales management computer 3 to the store computer 2 (step S19).

The store stores the card number of the customer's credit card recorded in the customer reliability coefficient 42 of the acquired customer information. Is transmitted to the card company computer 5 (step S20), the inquiry process is executed by the card company computer 5, and the fact that the inquiry is completed is transmitted to the store computer 2 (step S21).

When the inquiry of the credit card owned by the customer is completed, the dealer computer 2 requests the credit information of the customer from the card company computer 5 (step S22), and the credit information of the designated customer is stored in the dealer. A reply is sent to the computer 2 (step S23).

At the store, merchandise purchase and inventory management are performed by referring to order information from customers who are actually expected to purchase based on the customer credit information obtained as described above. It is possible to prevent the unsold product or the decrease in the value of the unsold product as pointed out in the above problem.

When the customer who ordered the product to be purchased actually visits the store and purchases the product as described above, the customer card described above is presented, and the store displays the customer card on the customer card. The merchandise sales management computer 3 is accessed from the store computer 2 using the customer ID as a key, and the card No. registered in the customer information database 4 is accessed. To the credit card company computer 5 to obtain credit information, and perform discount sales of the commodity amount based on the credit information.

In other words, the product purchase schedule on the Internet according to the present invention does not force the customer to purchase the reserved product, and the customer does not purchase the product registered in the purchase schedule. It only affects the coefficients. The store can manage the inventory based on the purchase schedule of a reliable customer based on the customer reliability coefficient. In return for a trusted customer, the customer can receive a discount on the product in proportion to the customer reliability coefficient.

In order to investigate the required stock of the merchandise, the dealer presumes the stock of the merchandise by searching / aggregating the merchandise desired by each customer registered in the customer information database 4 and the desired date of purchase. Then, order the estimated number of products and prepare the products.

The customer uses the purchaser computer 1 to
By inputting a customer ID from the merchandise trading management computer 3, the customer's current customer reliability coefficient can be known. In addition, the customer reliability coefficient is indicated to the customer from the store even when the product is purchased.

The above-described embodiment is a preferred embodiment of the present invention, and can be variously modified and implemented without departing from the gist of the present invention. For example, by reading out a product purchased by the customer in the past from the customer information database 4 and analyzing the product and the date of purchase, a product, a consumable item, an option product, and the like, which the customer may consider replacement by purchase, are sent by e-mail or the like. There is a method such as advertising using.

[0074]

As is apparent from the above description, according to the inventory management method of the present invention, before the customer actually visits the store, the product to be purchased, the number of products to be purchased, and the purchase date are set on the Internet. By referring to the order information from the customer registered in the customer information database, the dealer can know when, what product, and how much should be purchased. Therefore, it is possible to prevent excess inventory from being held at the store, eliminate the risk of excess inventory, and realize a minimum sales floor area.

Further, according to the inventory management method of the present invention, it is possible to improve the accuracy of inventory management based on the customer reliability coefficient. By purchasing the product registered by the customer from the dealer on the scheduled purchase date, the customer's reliability of the customer increases. The store manages the inventory based on the information on the products to be purchased of the customer having a high customer reliability coefficient, thereby maintaining the accuracy of the inventory management.

Further, according to the inventory management method of the present invention,
Customers can be attracted by discount sales of products to customers in proportion to the customer reliability coefficient. Since the higher the customer reliability coefficient is, the higher the discount rate of the product is, the customer tries to purchase the product whose planned purchase is registered by the planned purchase date. If you do not buy a product on the scheduled purchase date even though you have registered the purchase schedule, the customer's confidence factor will decrease, and the discount on the customer's next purchase will decrease, so you will need to receive discount sales. , The purchase rate of each customer is improved.

[Brief description of the drawings]

FIG. 1 is a system configuration diagram to which an inventory management method according to an embodiment of the present invention is applied.

FIG. 2 is a diagram showing a configuration of a customer information database according to the embodiment of the present invention.

FIG. 3 is a diagram showing a specific example of a customer information database according to the embodiment of the present invention.

FIG. 4 is a sequence diagram illustrating a processing example in a system to which an inventory management method according to another embodiment of the present invention is applied.

FIG. 5 is a system configuration diagram to which an inventory management method according to another embodiment of the present invention is applied.

FIG. 6 is a diagram showing a specific example of a customer information database according to another embodiment of the present invention.

FIG. 7 is a sequence diagram illustrating a processing example in a system to which an inventory management method according to another embodiment of the present invention is applied.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Purchaser computer 2 Dealer computer 3 Merchandise sales management computer 4 Customer information database 100 Internet

Claims (12)

[Claims] 1. A transmitting step in which a customer transmits order information of a product desired to be purchased from a customer side terminal to the product sales management terminal via the Internet, and the order information received by the product sales management terminal is stored in a customer information database. A registration step of registering, and a reference step in which a store accesses the commodity trading management terminal from the store terminal via the Internet, and refers to the order information registered in the customer information database, An inventory management method, wherein the store manages inventory of goods based on the order information referred to in the reference step. 2. The inventory management method according to claim 1, wherein the order information includes at least a planned product, a planned purchase quantity, and a planned purchase date. 3. The inventory management method according to claim 1, wherein the customer information database registers the order information from a plurality of customers for each customer. 4. The customer information database includes a customer ID (identification number) arbitrarily assigned to each customer.
Field, a customer reliability coefficient storage field for storing a customer reliability coefficient based on the purchase results of each customer, and a product for storing a product code coded for the purchase product of each customer. A code storage field; a planned purchase quantity storage field that stores the planned purchase quantity of the planned purchase product; a planned purchase date storage field that stores the planned purchase date of the planned purchase product; the product code; the planned purchase quantity; A pointer storage field for storing a pointer indicating in which field the expected purchase date is stored, wherein the pointer is managed in association with the customer ID assigned to each customer. The inventory management method according to any one of Items 1 to 3. 5. The customer reliability coefficient is added with a predetermined value when a product of the product code stored in the product code storage field is purchased on the scheduled purchase date, and is stored in the product code storage field. 5. The inventory management method according to claim 4, wherein a predetermined value is subtracted when the product having the specified product code is not purchased on the scheduled purchase date. 6. The inventory management method according to claim 4, wherein the store manages a product inventory based on order information from a customer having a high customer reliability coefficient. 7. When the customer who has transmitted the order information purchases a product to be purchased, the store accesses the product sales management terminal via the Internet from the store terminal, and stores the customer information database. The inventory management according to any one of claims 4 to 6, wherein the product is sold at a discount rate according to the customer reliability coefficient with reference to the customer reliability coefficient registered in the stock management. Method. 8. The order information includes at least a product to be purchased, a planned purchase quantity, a purchase date, and a card number of a credit card owned by the customer. 2. The inventory management method according to claim 1, comprising: 9. The inventory management method according to claim 8, wherein the customer information database registers the order information from a plurality of customers for each customer. 10. The customer information database includes a customer ID (identification number) arbitrarily assigned to each customer.
And a customer ID storage field for storing a credit card N which is owned by each customer.
o. Is stored in the card No. A storage field; a product code storage field for storing a product code obtained by coding the product to be purchased of each customer; a purchase quantity storage field for storing the planned purchase quantity of the purchase product; and a purchase of the purchase product. An estimated purchase date storage field for storing an expected date; and a pointer storage field for storing a pointer indicating in which field the product code, the expected purchase quantity, and the expected purchase date are stored. 10. The inventory management method according to claim 8, wherein the information is managed in association with the customer ID assigned to each customer. 11. The store according to claim 11, wherein said card number is determined from said order information referred to in said reference step. After reading the information, a card company terminal is accessed via the Internet, and an inquiry step of requesting an inquiry of the customer, and an acquiring step of acquiring credit information of the inquired customer, comprising: 11. The inventory management method according to claim 10, wherein the inventory management is performed based on the acquired order information from the customer with high credit information. 12. When the customer who has transmitted the order information purchases a product to be purchased, the store sells the product at a discount rate according to the credit information of the customer obtained in the obtaining step. The inventory management method according to claim 11, wherein: