JP2003108797A - Server and mail order system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a server to enable a seller of merchandise to more efficiently determine prices, etc., of the merchandise. SOLUTION: The server 10 is constituted by including a request processing part 12 for providing a Web page on which a user can place a purchase order and an information order (a request for informing a fact that specified price are set to specified merchandise when the price is set to the merchandise) to a computer terminal 110 and for storing the contents of a placed information order in a cart data base 22 when the order is placed, and a merchandise management processing part 14 having functions for displaying and updating results by performing various statistic processing to information in the cart data base 22 according to an instruction of an operator (person on the seller's side of the merchandise).

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a server device and a mail order system for mail order sales.

[0002]

2. Description of the Related Art As is well known, in recent years, various products (daily sundries, electric products, software, etc.) can be purchased on the Internet. Also, many products are
There are also products (for example, computer-related devices) that are sold by a plurality of product sellers and whose sales prices are frequently changed.

Therefore, a person who intends to purchase a product using the Internet (hereinafter referred to as a purchase applicant)
Sequentially visits homepages where desired products can be purchased, compares selling prices and the like, and determines a product seller who purchases the product. Also, if the selling price of the product that the user wants to purchase is changed relatively frequently, a general purchase applicant performs the work of visiting a large number of homepages several times, changing the day. By doing so, the product seller who purchases the product is determined.

[0004]

As described above, since the purchase applicant visits a plurality of homepages in order to determine the product seller, the product seller sells the same or similar products. Had to determine the selling price by investigating the selling prices of other product sellers. Then, depending on the determined selling price, the product may remain unsold.

[0005] On the other hand, a person who wants to purchase a product cannot make a satisfactory transaction unless he / she visits the homepages of a plurality of product providers many times on different days. I can't find the products that are being sold).

[0006] Therefore, the object of the present invention is to
An object of the present invention is to provide a server device and a mail-order sales system that enable mail-order sales in a more preferable form for both purchase applicants.

[0007]

In order to solve the above-mentioned problems, the server device according to the first aspect of the present invention,
Acquiring means for acquiring product identification information representing a product that is considered to be purchased and desired purchase price for the product, and desired purchase price storage means for storing each desired purchase price acquired by the acquisition device for each product identification information. And an instruction input means for inputting various instructions, a display means for displaying various information, and a statistical desired processing according to the instruction input to the instruction input means is stored in the desired purchase price storage means. Means for displaying on the display means the result applied to the obtained information,
At least, display control means having a function of causing the display means to display information indicating the price distribution of the desired purchase price for each product.

The server device according to the second aspect of the present invention includes an acquisition unit for acquiring, from a user, product identification information representing a product which is considered to be purchased, and the product identification information acquired by this acquisition unit. A user request information storage unit for storing the user request information and each user request information stored in the user request information storage unit is stored for a predetermined period after the user request information is stored in the user request information storage unit. And a user request information erasing unit that deletes the request from the user request information storage unit.

Regarding the server device of the second aspect,
The acquisition unit is a unit that also acquires period specification information that specifies a period from the user, and the user request information stored in the user request information storage unit is information that includes product identification information and period specification information. Erasing means, each user request information stored in the user request information storage means,
After the user request information is stored in the user request information storage means, it can be deleted from the user request information storage means when the period designated by the period designation information in the user request information has elapsed. Further, in the server device of the second aspect, instruction input means for inputting various instructions, display means for displaying various information, and statistics according to the instructions input to the instruction input means. It is also possible to add display control means for displaying on the display means the result of applying the specific processing to the information stored in the user request information storage means.

Then, the mail order system of the present invention creates user request information, which is information including product identification information representing a product that the user is thinking of purchasing, based on the information input by the user, and the server device. A plurality of computer terminals provided with user request information transmitting means, and user request information storing means for storing the user request information transmitted by the product identification information transmitting means in each computer terminal; Erasing each user request information stored in the user request information storage unit from the user request information storage unit when a predetermined period has elapsed after storing the user request information in the user request information storage unit And a server device having means.

[0011]

BEST MODE FOR CARRYING OUT THE INVENTION An embodiment of a server device of the present invention will be described below with reference to the drawings.

A server device according to an embodiment of the present invention is
Purchase orders, reservation orders and notification orders for various products from members (who registered as members; details will be described later)
It is a device that accepts by communication. In the present embodiment, the purchase order is an order (sales request) issued by the member knowing that the member has stock, and the pre-order is
An order (sales request) issued by a member when they know that they are out of stock. In addition, a notification order is an email (hereinafter referred to as a price change notification email) to that effect when the selling price of a specified product falls below a specified price.
It is an order to request notification.

First, the schematic configuration and operation mode of the server device according to the present embodiment will be described with reference to FIG.

As shown in the figure, the server device 10 according to the embodiment is a kind of Web server that is used by being connected to the Internet 100, and includes a storage unit 11, a request processing unit 12, a notification order processing unit 13, and a product management. Processing unit 14
With. The storage unit 11 of the server device 10 stores a product database 21, a cart database 22, a status management table 23, and a plurality of sheet data.
Although not shown, the storage unit 11 also stores a purchase price information database and various html data and image data transmitted to the computer terminal 110 that has accessed the server device 10.

The server device 10 according to the present embodiment.
Is realized by installing various software in a computer having a relatively high function similarly to a general Web server, and the storage unit 11 substantially corresponds to the hard disk of the computer. In addition, the request processing unit 12 and the notification order processing unit 13
Both, various programs of the computer (HTTP
It corresponds to a part centering on a CPU (CPU, communication control circuit, various interface circuits, etc.) that controls according to a daemon program, a CGI application program, a database management program, etc. And
The product management processing unit 14 corresponds to a portion including such a portion, an input device (keyboard, mouse), a display, and the like.

Next, the configuration of each database and table provided in the server device 10 will be described with reference to FIGS.

The product database 21 is a database that stores product information about each product targeted for purchase / reservation / notification order. As schematically shown in FIG. 2, the product information stored in the product database 21 includes a product code, a product name, a selling price, the number of actual stocks, the number of sold products, order status information, and the like.

The product code and the product name, which form the product information, are both product identification information. The selling price is the price at which the product identified by the product code is sold.
The actual inventory quantity is the quantity of products stored in the warehouse (ready to be shipped to the orderer). The number of sold products is the number of products that have already received a purchase order or a pre-order, but have not completed the shipping procedure to the orderer. The order status information is information whose content is rewritten according to the order status of the corresponding product. As the order status information, information including an order date of a product to a manufacturer or the like, an expected arrival date, an expected arrival quantity, and the like, information indicating that an order has not been placed, and the like are set.

The product information is added to the product database 21 and the contents are updated by the product management processing unit 14 which operates according to the instruction of the administrator of the server device 10. However, the request processing unit 12 also changes the number of sold products.

Each sheet data prepared in the storage unit 11 is stored in the server device 1 in order to receive a purchase order or the like.
0 is data that defines the display content of a part of a Web page (hereinafter referred to as a shopping page) supplied to the computer terminal 110, and information about some products (text for explanation, image data file name, etc.). ) Consists of. Although a specific use of the sheet data will be described later, in order to identify (read) the plurality of sheet data in the storage unit 11, consecutive integers starting from “1” (hereinafter referred to as sheet numbers). ) Is given.

As shown schematically in FIG. 3, the cart database 22 is a database for storing member information about each member, and also for storing some order information in association with each member information. is there.

The member information stored in the cart database 22 includes a member name, a member ID, a credit card number, an E-mail address, address information and the like. The member name and member ID are information used for personal authentication, and the member ID is a so-called password.
Other information, such as a credit card number and an E-mail address, is information used when billing for purchased products and when notifying members of various information. Member information is
When a non-member performs member registration, it is added to the cart database 22 by the request processing unit 12.

The order information is information added to the cart database 22 by the request processing unit 12 for each order placed by the member. As shown schematically in FIG.
The order information includes a product code of the product for which the order is placed, and an order type indicating whether the order placed for the product is a purchase order, a reservation order, or a reservation order. The order information also includes price information, processing status information, and order ID.

Details of price information, processing status information, and order ID (addition of order information, details of usage procedure) will be described later.
The order ID is unique identification information given to a process performed using a shopping page between a member (computer terminal 110) and the server device 10, and a member may copy the shopping page to the computer terminal 110. The same information as the order ID is set in the order information regarding each order issued while being displayed.
Further, the order information regarding the purchase order (hereinafter referred to as the purchase order information) and the order information regarding the pre-order (hereinafter referred to as the pre-order information) are price information at the time when the order is placed. The selling price (the selling price set in the product database 21 at that time) is set, and the order information regarding the pre-order (hereinafter, referred to as pre-order information) is price information, and the sales desire of the product issued by the member is set. The price is set.

The processing status information is information whose contents are rewritten according to the processing performed for the order whose order information indicates the contents. Cart database 22
Each piece of order information added by the request processing unit 12 is information in which unprocessed information is set as the processing status information. Can be rewritten. The processing status information of the notification order information is rewritten to information indicating that the processing has been completed when the processing of transmitting the price change notification mail is performed by the notification order processing unit 13.

The status management table 23 is a table for managing members who are using (browsing) a shopping page. As shown in FIG. 5, the situation management table 23 includes an order ID, a member name, a member ID, and an IP.
Some management information including an address and a sheet number is stored. The meaning (use) of each piece of information that constitutes the management information will be described later.

The purchase price information database is a database that holds, for each product for which product information is stored in the product database 21, information indicating the relationship between the number of orders for the product and the unit price (purchase price). The purchase price information database is updated and referred to by the product management processing unit 14.

The operation of the server device 10 will be described below. First, the operation related to the request processing unit 12 will be described.

The request processing unit 12 has a function as a Web server, and operates according to a request received from the computer terminal 110.

That is, when operating the request processing unit 12, a member (or a non-member) asks the computer terminal 110 connectable to the Internet 100
Performs an operation (an operation of activating a Web browser and inputting a predetermined URL) for transmitting a predetermined HTTP request (hereinafter referred to as a top page request) that the request processing unit 12 receives and processes. .

The computer terminal 110 that has performed such an operation transmits a top page request, as shown in FIG. 6 (step S1001).

When receiving the top page request, the request processing unit 12 waiting for the reception of various requests sends the top page data (html data including the script) stored in the storage unit 11. ,
Return to the sender of the top page request.

Upon receiving the top page data, the computer terminal 110 displays the top page based on the received data (step S1002).

FIG. 7 shows an outline of the top page displayed on the display of the computer terminal 110 by the processing of step S1002. As shown in the figure, the top page has a main area 41 in which introduction texts of service contents are displayed and a sub area 42 having a member registration button 51, a shopping button 52, a confirmation end button 53, and a cancellation end button 54. Prepare

The member registration button 51 is a button that a non-member should press when performing member registration. The shopping button 52 is a button that the member should press when starting shopping (a work of issuing a purchase, a reservation, or a notification order). The confirmation end button 53 is a button that the member should press when confirming various orders placed during shopping and ending the shopping. Cancel end button 54
Is a button that the member should press when canceling various orders and ending shopping. The confirmation end button 53 and the cancel end button 54 do not function when the top page is displayed, but function after the shopping button 52 is pressed.

When the member registration button 51 is pressed (FIG. 6: step S1003; member registration button is pressed), the computer terminal 110 displaying the top page starts the member registration process (step S1004; transmission of a member registration request). ) Is executed.

On the other hand, the request processing unit 12 which has received the member registration request transmitted by the execution of the member registration process starts the member registration acceptance process of the procedure shown in FIG. It is returned to the sender of the member registration request (step S101).

The computer terminal 110 which has received the member information input data is step S1004 (FIG. 6).
In, it operates as follows.

The computer terminal 110 is for inputting information such as a member name, a credit card number, an E-mail address (each member of the member information except the member ID) and the sub area 42 having the non-functioning buttons 51 to 54. A member information input page including a plurality of information input fields, a main area 41 having a send button, a cancel button, and the like is displayed. After that, the computer terminal 110 performs a process of displaying the information input by the member in each information input field according to the content of the operation performed on the input device (mouse, keyboard) included in the computer terminal 110. And the computer terminal 1
When the send button is pressed, 10 confirms that all the essential information has been entered, and then sends an information registration request including all the entered information to the server device 10. Then, the computer terminal 110
The display contents of the display are returned to the original contents (shown in FIG. 7), and step S1004 is ended.

If the send button is pressed in the presence of uninputted essential information, the computer terminal 1
10 does not send an information registration request,
Display a message prompting you to enter the required information. When the cancel button is pressed, the computer terminal 1
No. 10 returns the display content of the display to the original one without transmitting the information registration request, and the step S
1004 is ended.

When the information registration request is received (FIG. 8: Step S102; YES), the request processing unit 1
2 generates a unique member ID (a password used for personal authentication together with the member name) assigned to a person who wishes to register as a member (step S103). Next, the request processing unit 12 stores the member information including the member ID and various information (member name, E-mail address, etc.) acquired from the member in the cart database 22.
(Step S104). After that, the request processing unit 12 sends the generated email containing the member ID to the E-mail address obtained from the member.
(Step S105), and the member registration acceptance process ends.

Shopping button 52 on the top page
If is pressed (FIG. 6: Step S1003; shopping button is pressed), the computer terminal 110 executes login processing (step 1005) which starts with transmission of a login request and is given an order ID from the server device 10 when the processing is completed. To do.

When the login request transmitted by executing the login process is received, the request processing unit 12
Executes the login acceptance process of the procedure shown in FIG.

That is, the request processing unit 12 that has received the login request returns the authentication information input data to the source of the login request (step S20).
1).

The computer terminal 110 receiving this authentication information input data, as shown in FIG. 10, has a log-in having a main area 41 having two information input fields for inputting a member name and a member ID. Display the page. Then, when the send button is pressed while the member name and the member ID are both input, the computer terminal 110 sends an authentication request including the information. When either or both of the information is not input and the send button is pressed, the computer terminal 110 displays a message to that effect without sending the authentication request.

When the authentication request is received (FIG. 9: Step S202; YES), the request processing unit 12 stores the member information in which the member name and the member ID included in the authentication request are set in the cart database 22.
Is searched (step S203). If such member information can be retrieved (step S203; YES),
The request processing unit 12 generates an order ID (a function of the date and time of reception of the authentication request in this apparatus) assigned to the current service use of the member who has sent the authentication request to the computer terminal 110 (step S20).
5). Next, the request processing unit 12 stores the generated management information in which the order ID and the like are set in the status management table 23.
(See FIG. 5) (step S206). More specifically, in step S206, the request processing unit 12 generates the order ID, the member name and the member ID included in the authentication request, the IP address of the computer terminal 110 that has transmitted the authentication request, The management information including the sheet number “0” indicating that the sheet data is not used (the shopping page is not yet displayed) is added to the situation management table 23. After that, the request processing unit 12 returns an authentication success notification including the order ID to the transmission source of the authentication request (step S207), and ends the login reception process.

On the other hand, when the member information in which the member name and the member ID included in the login request are set is not stored in the cart database 22 (step S203; NO), the request processing unit 12 determines that the authentication request has been made. The authentication failure notification is returned to the sender (step S204), and the login acceptance process ends.

When the authentication success notification is received, the computer terminal 110 determines the order ID included in the authentication success notification.
And login processing (FIG. 6: step S1005)
Is ended, and the processing from step S1010 is started.
Although not shown in FIG. 6, when the authentication failure notification is received during the login process, the computer terminal 110
A message to that effect is displayed on the display. Then, a process (a process of retransmitting the login request or a process of interrupting the login process) according to the operation content of the input device of the member is performed.

In step S1010, the computer terminal 110 transmits a shopping page request including the order ID acquired during the login process. The request processing unit 12 that has received the shopping page request returns the shopping page data (details will be described later), and the computer terminal 110 that has received the shopping page data displays the shopping page based on the data ( Step S1011).

FIG. 11 shows an example of a shopping page displayed on the computer terminal 110. It should be noted that this figure shows the contents of the shopping page after being displayed in step S1011 and after some operations have been performed by the member.

As shown in the figure, the main area 41 of the shopping page is a catalog area 61, a purchase cart information area 62, an auxiliary cart information area 63, and a "delete" button 6
4 and an “auxiliary → purchase” button 65.

The catalog area 61 is an area in which drawing is performed using the above-mentioned sheet data, and includes several introduction information areas 71, a "previous" button 72, and a "next" button 73. I have it. In each introduction information area 71 in the catalog area 61, information about the product (product name,
Price, inventory, product description, product image, etc.), "To purchase cart" button 81a or "Reserve" button 81
b, a "to auxiliary cart" button 82 is shown.

The "To purchase cart" button 81a is a button that is displayed for products for which the stock quantity (the value obtained by subtracting the quantity of sold goods from the actual stock quantity in the goods database 21) is not "0", and "Reservation". Button 81b has a stock of "1"
It is a button displayed for the above products. When issuing a purchase order or a reservation order for a certain product, the member has a "To purchase cart" button 81a or a "Reservation" button 81b provided in the introduction information area 71 for the product.
Press. Also, when issuing a notification order for a certain product, the member presses the “to auxiliary cart” button 82 provided in the introduction information area 71 for that product.

The "Previous" button 72 is used for the catalog area 61.
Is a button that the member should press when changing the display content of the item 1 to the item based on the previous sheet data (sheet data having a smaller sheet number “1”). The “Next” button 73
This is a button that the member should press when changing the display content of the catalog area 61 to the one based on the next sheet data (sheet data with a sheet number that is larger by “1”). In addition,
The “Previous” button 72 is a button that does not function when the catalog area 61 is displayed based on the first sheet data (sheet data whose sheet number is “1”), and “Next” button 72 The button 73 is a button that does not function when the final sheet data (sheet data with the largest sheet number) is used for displaying the catalog area 61 (such control is performed by the computer terminal 110).
Data including a script to be executed by the (Web browser) is sent from the request processing unit 12 to the computer terminal 110).

The purchase cart information area 62 is an area for displaying order display information (“product A”, “product B (reservation)”, etc.) indicating the contents of a purchase order or a reservation order issued by a member. The shopping page first displayed on the computer terminal 110 (the shopping page displayed in step S1011) includes the purchase cart information area 62 in which no order display information is displayed.

The auxiliary cart information area 63 is an area in which the order display information regarding the notification order is displayed. The order display information related to the notification order (hereinafter, also referred to as the notification order display information) includes the product name and the desired price, and the desired price configuring the notification order display information can change the value thereof. Is displayed inside. Although details will be described later, when the member who has received the price change notification mail logs in, a shopping page including the auxiliary cart information area 63 in which some notification order display information is displayed is displayed in step S1011.

The delete button 64 is displayed on the shopping page (the purchase cart information area 62 or the auxiliary cart information area 6
3) is a button for canceling a purchase order, a reservation order, or a notification order whose order display information is shown. For the delete button 64, when any of the order display information shown in the purchase cart information area 62 or the auxiliary cart information area 63 is selected (the operation of pointing the mouse pointer and clicking the mouse button has been performed). To function.

The “auxiliary → purchase” button 65 is a button that the member should press when changing the notification order into a purchase order or a pre-order (usually a purchase order). “Auxiliary →
The “Purchase” button 65 is the order display information (that is, the notice order display information) displayed in the auxiliary cart information area 63.
Only works when is selected. The "auxiliary → purchase" button 65 is provided so that the member who has placed the notification order can easily change the notification order into the purchase order when receiving the price change notification mail. However, it also functions as a button for changing an order that was accidentally made as a notification order to a purchase order.

In order to create shopping page data for displaying such a shopping page on the computer terminal 110, the request processing section 12 operates as follows.

That is, as shown in FIG. 12, the request processing unit 12 that has received the shopping page request first identifies and specifies the member who has issued the request based on the order ID included in the shopping page request. The processed notification order information (notification order information whose processing status information indicates that the processing has been completed) regarding the member (hereinafter, referred to as a processing target member) is extracted from the cart database 22 (step S301). More specifically, the request processing unit 12 searches the situation management table 23 using the order ID included in the shopping page request as a key, and identifies the member name and the member ID associated with the order ID. Next, the request processing unit 12 indicates that the order type represents a notification order from the order information stored in the cart database 22 in association with the member information in which the specified member name and member ID are set, In addition, all the order information (hereinafter referred to as processed notification order information) whose processing status information represents processed has been extracted.

As already explained in the outline, the processing status information in a certain notification order information is changed to the one indicating that the processing has been completed when the price change notification mail is sent. Therefore, in step S301, login is performed. The notified order information for which the price change notification mail has already been issued is extracted from the notified order information issued by the member who made the request.

After that, the request processing unit 12 stores the extraction result from the cart database 22, the first sheet data, and the information (sales price,
Based on the actual inventory number and the number of sold products), create shopping page data for displaying on the computer terminal 110 a shopping page having a catalog area 61 having contents corresponding to the first sheet data, and request the shopping page. The computer terminal 110 thus transmitted is supplied (step S302). When one or more processed notification order information items have been extracted in step S301, in step S302, the request processing unit 12 determines some notification orders corresponding to the extracted some processed notification order information items. The shopping page data whose display information (product name and desired price) will be shown in the auxiliary cart information area 63 is created. When the processed notification order information is not extracted in step S301, the request processing unit 12 performs shopping for displaying a shopping page having the auxiliary cart information area 63 in which no notification order display information is shown. Create page data.

After that, the request processing unit 12 sets the sheet number (“1” in this case) of the sheet data used to display the catalog area 61 in the management information regarding the processing target member in the status management table 23. Yes (step S303). Then, the request processing unit 12
Waiting for reception of various requests issued by operating the shopping page (step S30)
4).

Further, the computer terminal 110, which has displayed based on the shopping page data, performs an effective operation on the input device (pressing a button using a mouse or inputting / changing a desired price using a keyboard). Or waiting for the receipt of a stock quantity change instruction (details will be described later) from the server device 10 (FIG. 6: step S1012). Then, the computer terminal 110
Detects that such an event has occurred (step S1012; YES), and if the event has occurred other than pressing the confirmation end button 53 or the cancel end button 54 (step S1013; other).
In step S1014, a process corresponding to the event that has occurred is executed.

In step S1014, a process involving information exchange with the server device 10 and a process not involving it are performed. In addition, in step S1014, when a process involving information exchange with the request processing unit 12 is performed,
On the server device 10 side, the request processing unit 12 executes the process of step S306 (FIG. 12).

Specifically, when the "forward" button 72 is pressed (step S1013; other), the computer terminal 110 performs the following processing in step S1014.

First, the computer terminal 110 requests the catalog data request including a sheet number obtained by subtracting “1” from the sheet number of the sheet data used to display the catalog area 61 and the order ID, the request processing unit 12
Send to.

When a catalog data request is received (FIG. 12: step S304; YES, step S30)
5; other), the request processing unit 12 performs step S3.
In 06, data for making the display content of the catalog area 61 correspond to the sheet data of the sheet number included in the catalog data request (sheet data,
Create a product (sales price, quantity in stock) and send it back to the sender of the catalog data request. Next, the sheet number in the status management table 23 related to the order ID included in the catalog data request is changed to the sheet number included in the catalog data request, and step S306 ends (returns to step S304).

The computer terminal 110 which has transmitted the catalog data request changes the display content of the catalog area 61 to one according to the data transmitted as a response to the request, and in step S1014.
(FIG. 6) ends.

When the "Next" button 73 is pressed (step S1013; other), the computer terminal 110
In step S1014, transmits a catalog data request including a sheet number obtained by adding “1” to the sheet number of the sheet data used to display the catalog area 61 and the order ID to the server device 10. Then, as a response, the computer terminal 110 changes the display content of the catalog area 61 based on the data transmitted from the server device 10 (request processing unit 12).

When the "To purchase cart" button 81a is pressed, the computer terminal 110 proceeds to step S101.
At 4, the process of the procedure shown in FIG. 13 is performed. Further, when the processing shown in FIG. 13 is executed, the request processing unit 12 performs the purchase request response processing of the procedure shown in FIG. 14 in step S306.

That is, the computer terminal 110 transmits a purchase request including the stored order ID and the product code corresponding to the pressed "to purchase cart" button 81a to the server device 10 (FIG. 13: Step S1
101).

The request processing unit 12, which has received this purchase request, refers to the product database 21 to refer to the actual inventory quantity of the product having the product code included in the received purchase request (hereinafter referred to as the product to be processed). , The number of sold products and the selling price are acquired (FIG. 14: step S401). Then, the request processing unit 12
When "the actual number of products> the number of sold products" is not established between the acquired actual inventory number and the number of sold products (step S402; NO), a reception failure notification is sent to the sender of the purchase request. The process is returned (step S403), and the purchase request response process ends.

When “the actual number of products> the number of sold products” is satisfied (step S402; YES), the request processing unit 12 increments the number of sold products for the processing target product in the product database 21 by “1” ( Step S
Then, the successful reception notification is returned to the sender of the purchase request (step S405). Next, the request processing unit 12 refers to the situation management table 23 to identify all the computer terminals 110 that are performing display based on the sheet data related to the product to be processed, and specify the identified computer terminals 110 to each computer terminal 110. , And sends a stock quantity change instruction including the product code and the stock quantity (= actual stock quantity−the number of sold goods) (step S406). That is,
The request processing unit 12 uses the status management table 23 to
All the management information in which the sheet numbers of the sheet data related to the product to be processed are set are extracted, and the inventory quantity change instruction is transmitted to the IP address included in each extracted management information. Then, the request processing unit 12 ends the purchase request response process.

On the other hand, the computer terminal 110 which has transmitted the purchase request is waiting for the response to the purchase request to be received (FIG. 13: step S1102), and when the reception success notification is received (step S11).
02; YES, S1103; success notification), the product name (purchase order display information) corresponding to the pressed "To purchase cart" button 81a is displayed in the purchase cart information area 61 (step S1104), The processing that has been performed is terminated (return to step S1012 in FIG. 6). When the reception failure notification is received (step S1103; failure notification), the computer terminal 110 displays a message indicating that the stock is out (step S110).
Perform 5). Then, when a predetermined operation is performed,
The message is deleted (step S1105 is ended), and the process for pressing the "to purchase cart" button 81a is ended.

When the request processing section 12 carries out the processing of step S406, information about the products purchased by the purchase request including the computer terminal 110 which sent the purchase request is displayed in the catalog area 61. Each of the one or more computer terminals 110 that are present will receive the inventory quantity change instruction.

When the stock quantity change instruction is received (FIG. 6: step S1012; YES, S1013; other), the computer terminal 110 determines in step S1014 the commodity identified by the commodity code included in the instruction (hereinafter, changed). Change the value of the inventory quantity displayed for the target product) to the inventory quantity included in the instruction. At that time, if the stock quantity after the change is “0”, the computer terminal 110 replaces the “To purchase cart” button 81a for the product to be changed with the “Reserve” button 81b.
The process of changing to (the process of changing the character string displayed in the button) is also performed. Also, until then, "Reserve" button 81
When the stock quantity change instruction for the product displaying “b” is received (the stock quantity included in the stock quantity change instruction in this case is “1” or more), the computer terminal 110
Changes the number of items in stock for the product to be changed,
The "reserve" button 81b for the product to be changed is changed to the "to purchase cart" button 81a.

In other words, the server device 10 will first send a purchase order for a product for which the "actual inventory number-the number of sold products" is "1" from two members at substantially the same time. Only the purchase order from the member that has received the purchase request is received, and the purchase order issued by the other member is notified to the member that the stock is out. In other words, do not accept an order from a member who has pressed the "To purchase cart" button 81a when he / she thinks that there is stock, as a pre-order that is an order that cannot be responded immediately because the stock is not available The order is configured to be accepted only when the "reservation" button 81b is pressed).

When it is detected that the "reservation" button 81b is pressed (step S1013; other), the computer terminal 110, in step S1014, the reservation order display information (commodity) corresponding to the pressed "reservation" button 81b. The name and the character string "(reservation)" are displayed in the purchase cart information area 62, and the process returns to step S304. That is, the computer terminal 110 displaying the shopping page responds to the pressing of the "reserve" button 81b by
The process ends without exchanging information with the server device 10. It should be noted that the information regarding the content of the pre-order is passed to the server device 10 (request processing unit 12) when the confirmation end button 54 is pressed (details will be described later).

When it is detected that the "to auxiliary cart" button 82 has been pressed (step S1013; other),
The computer terminal 110 performs the process of the procedure shown in FIG. 15 in step S1014. That is, the computer terminal 110 first displays the notification order display information (the product name and the desired price column) corresponding to the pressed “To auxiliary cart” button 82 in the auxiliary cart information area 62 (step S1201). Next, the computer terminal 110 waits for the input of the desired price in the displayed desired price input field (step S1202). Then, when some numerical information is input to the desired price column, the computer terminal 110 takes a state in which the occurrence of an event other than the information input to the desired price column is regarded as a valid operation (return to step S1012).

When the computer terminal 110 detects that an operation for selecting any of the order display information is performed (step S1013; other), that is, in the state where the mouse cursor is positioned on a certain order display information. When it is detected that the mouse button has been clicked, in step S1014, the process of the procedure shown in FIG. 16 is performed.

That is, the computer terminal 110 first changes the display form of the selected order display information to one indicating that the order has been selected (step S130).
1). Next, when the selected order display information is the notification order display information (step S1302; YES), the computer terminal 110 causes the delete button 64 and the “auxiliary → purchase” button 65 to function (step S130).
4). More specifically, the display forms of the delete button 64 and the “auxiliary → purchase” button 65 are changed to those indicating that they are functioning, and the operation of pressing the buttons 64 and 65 is regarded as a valid operation. . Then, the illustrated process is ended, and the process returns to step S1012.

On the other hand, when the selected order display information is not the notification order display information (step S1302; N
O), that is, the purchase order or the reservation order, the computer terminal 110 displays the delete button 6
Only 4 is made to function (step S1303), and the illustrated process is ended.

When the delete button 64 is pressed (step S1012; YES, S1013; other), the computer terminal 110 executes the processing of the procedure shown in FIG. 17 in step S1014.

That is, the computer terminal 110 determines whether or not the selected order display information is purchase order display information (step S1401). If the selected order display information is not the purchase order display information (step S1)
401; NO), that is, if it is the reservation order display information or the notification order display information, the computer terminal 11
0 deletes the selected order display information from the shopping page (step S1403), and finishes the process for pressing the delete button 64.

When the selected order display information is the purchase order display information (step S1401; YES), the computer terminal 110 transmits a deletion request including the order ID and the product code related to the selected order display information (step S1402). After that, step S1403 is executed.

Upon receiving the delete request, the request processing unit 12 performs the following processing in step S306 (FIG. 12).

First, the request processing unit 12 deletes the order information including the product code and the order ID included in the deletion request from the cart database 22. The request processing unit 12 also decrements the number of sold products in the product database 21 associated with the product code by “1”. Next, the request processing unit 12 displays the product code and the stock number (= A stock quantity change instruction including the actual stock quantity-the number of sold goods) is transmitted.

When the "auxiliary → product" button 65 is pressed, the computer terminal 110 executes the processing shown in FIG. That is, the computer terminal 110 transmits a purchase request regarding the selected order display information (in this case, the notification order display information) (step S1501). The contents of the purchase request transmitted in this step and the operation of the server device 10 that has received the purchase request are the purchase request transmitted by pressing the "To purchase cart" button 81a and the server when the purchase request is received. The operation is the same as that of the apparatus 10 (see FIG. 14). That is, the computer terminal 110 that has transmitted the purchase request as a result of pressing the “auxiliary → purchase” button will subsequently receive the acceptance success notification or the acceptance failure notification.

When the acceptance success notification is received (step S
1502; YES, S1503; success notification), the computer terminal 110 erases the selected order display information in the auxiliary cart information area 63, and displays the purchase order display information (product name) regarding the same product in the purchase cart information area 62. It is displayed (step S1504), and the process ends.

On the other hand, when the reception failure notification is received (step S1502; YES, S1503; failure notification), the computer terminal 110 displays a dialog box asking whether the pre-order is acceptable (step S1505). If it is confirmed that the pre-order is good (step S1506; YES), the selected-order display information is erased, and the pre-order display information (product name and character string “(reservation)” regarding the same product is deleted. ) Is displayed in the purchase cart information area 62 (step S1507), and the “auxiliary → product” button 6 is displayed.
The process for pressing 5 is terminated. If the confirmation that the pre-order is good is not obtained (step S1506; N
O), the computer terminal 110 ends the process without doing anything.

When the cancel end button 54 is pressed (FIG. 6: step S1013; cancel end button is pressed), the computer terminal 110 transmits a cancel end request including the order ID (step S1015). Next, the computer terminal 110 rewrites the main area 41 based on the data (details will be described later) transmitted from the server device 10 (step S1017), and ends the illustrated process.

On the other hand, the request processing unit 12 receives the cancellation end request (FIG. 12: step S30).
5: cancellation end), each order information having the order ID included in the cancellation end request in the cart database 22 (only the purchase order information because the reservation / notification order information having the order ID is not set) ),
A process for deleting the order information, a process for incrementing the number of sold products in the product database 21 for the product related to the order information by “1”, and a display for the product in each computer terminal 110. A process of issuing an instruction to change the inventory quantity is performed (step S
307). Then, the request processing unit 12 cancels each order and logs off (the shopping button 52).
The cancellation end screen data for displaying the main area 41 in which a message indicating that shopping cannot be performed unless is pressed is returned to the computer terminal 110 (step S308).

Next, the request processing unit 12 deletes the management information in which the order ID included in the received request is set from the status management table 23 (step S311), and ends the illustrated processing.

When the confirmation end button 53 is pressed (FIG. 6: Step S1013; confirmation end button is pressed), the computer terminal 110 displays the reservation request information (product code) corresponding to the order ID and each reservation order display information being displayed. ), A confirmation end request including notification request information (product code and desired price) according to each notification order display information being displayed is transmitted to the server device 10 (step S1016).

When the confirmation end request is received (FIG. 12: Step S305; confirmation end), the server device 10 performs a cart database update process for adding reservation order information and the like to the cart database 22 (step S30). S309).

At the time of this cart database updating process, as shown in FIG. 19, the request processing unit 12 applies the product code to each reservation request information (that is, the product code) included in the received confirmation end request. The sales price associated with is read from the product database 21, and the pre-order information including the read sales price is
A process of adding to the cart database 22 as a member to be processed specified by the order ID included in the confirmation end request is performed (step S50).
1).

Next, the request processing section 12 starts the processing for the notification request information included in the confirmation end request, and first, the first processed notification order information (processing status information indicates that processing has been completed) regarding the processing target member. Yes, order information that is information indicating that the order type is a notification order) is searched (step S502). When the processed notification order information is retrieved (step S503; YES),
The request processing unit 12 determines whether the received notification request information includes the notification request information regarding the same product as the searched processed notification order information (step S504). In other words, the request processing unit 12 is
Since the processed notification order information is present in the cart database 22, the notification order display information shown in the auxiliary cart information area 63 of the shopping page is selected and the "Delete" button 64 or " Assistance → Purchase ”
It is determined whether or not the operation of pressing the button 65 has been performed.

When the received notification request information does not include the notification request information regarding the same product as the searched processed notification order information (step S504; N).
O), that is, when the processing for pressing the button 64 or 65 is performed on the notification order display information shown in the auxiliary cart information area 63 because the processed notification order information is present, the request processing unit The process 12 deletes the processed notification order information retrieved in step S501 from the cart database 22 (step S505). After that, the request processing unit 12 returns to step S502 and searches for the next processed notification order information.

On the other hand, when the notification request information regarding the same product as the searched processed notification order information is included (step S503; YES), the request processing unit 12 includes the notification request information regarding the same product. It is determined whether the desired price present matches the desired price set as price information in the processed notification order information (step S506). That is, the request processing unit 12
Since the processed notification order information is present, it is determined whether the price of the notification order display information shown in the auxiliary cart information area 63 has been changed.

If the prices match (step S50)
6; YES), that is, if the price has not been changed, the request processing unit 12 discards the processed (requested price comparison) notification request information (step S5).
08) and returns to step S502. On the other hand, if the prices do not match (step S506; NO), the request processing unit 12 responds to the notification request information for which the desired prices have been compared, instead of the processed notification order information to be processed. The notified order information is set in the cart database 22 (step S507). In other words, the request processing unit 12 sets the price information of the retrieved processed notification order information as the desired price constituting the notification request information, changes the processing status information to one indicating unprocessed, and sets the order ID to Change to the one included in the confirmation end request. After that, the request processing unit 12 discards the processed notification request information (step S508), and returns to step S
Return to 502.

After performing such processing on all processed notification order information related to the processing target member (step S503; NO), the request processing unit 12 does not perform processing (not discarding). The notification order information corresponding to each notification request information (that is, the notification order information corresponding to each notification order added this time) is added to the cart database 22 as the order information regarding the processing target member (step S509). The request processing unit 12
Ends the cart database update process shown in the figure,
Transmission of confirmation end image data for displaying the main area 41 in which a message indicating that each order has been accepted and logged off is displayed (FIG. 12: step S310),
Update contents of status management table 23 (step S311)
And.

Next, the operations of the product management processing unit 14 and the notification order processing unit 13 will be described.

The product management processing unit 14 has a function of displaying and updating the contents of the product database 21 and the cart database 22 in accordance with the operation contents of the input device by the administrator of the server device 10. Specifically, the product management processing unit 14 collects, for each product, a function of displaying the number of purchase orders received, the number of pre-orders, and the actual inventory quantity, and aggregates notification order information to purchase each product. It has a function of displaying the number of members who want to, the maximum value, the minimum value, the average value, etc. of the desired price.

Further, the product management processing unit 14 uses the information in the purchase price information database described above, and a three-dimensional graph showing the relationship among the number of orders of products specified by the manager, the selling price, and the profit. In addition to displaying (a graph that shows the profit from the number of orders and the sales price), the notification order information about the product is aggregated, and the price (sale price) and the number of members who are likely to purchase the product at that price (desired It has a function of displaying a graph showing a relationship with the number of notified order information whose price is equal to or higher than the price.

Further, the merchandise management processing section 14 changes the processing status information of the purchase / reservation order information (order information regarding the transaction for which the shipping procedure is completed) designated by the administrator to indicate that the processing has been completed. Along with the change, the function to reduce "1" from the actual inventory number and the number of sold items of the product information about the corresponding product, the function to change the selling price that constitutes the product information to the one specified by the administrator, the administrator It has a function of deleting the notification order information designated by from the cart database.

That is, the merchandise management processing section 14 allows the manager to make an ordering plan for each merchandise and to change the contents of the merchandise database 21 and the cart database 22 according to the actual situation by using each function. It has a configuration that can be changed to a different one.

Then, when the content of the product database 21 (the selling price of any product) is changed by the product management processing unit 14, the notification order processing unit 13 changes the sales price of each product. On the other hand, the processing of the procedure shown in FIG. 20 is executed.

That is, when the selling price of a certain product is changed, the notification order processing unit 13 determines, from the cart database 22, the notification order information regarding the product, that is, the desired price indicated by the price information. The first notification order information having a sales price equal to or higher than the changed selling price of the product is retrieved (step S601). When such notification order information is successfully retrieved (step S602; YE
S), the notification order processing unit 13 reads the member information (E-mail address and member name) associated with the retrieved notification order information, and uses the read information to identify the product addressed to the member. Create and send an email stating that the price has been changed to the desired price or lower (step S60
3) Do. Further, the notification order processing unit 13 changes the processing status information of the notification order information to that indicating that the processing has been completed (indicating that the electronic mail has been transmitted) (step S).
After 604), the process returns to step S601, and the next notification order information regarding the product whose price has been changed is searched.

Then, the notification order processing unit 13 searches the notification order information in which the desired price indicated by the price information is equal to or higher than the changed sales price of the product for the product whose sales price is changed. When it fails (step S
602; NO), the illustrated process is ended (the illustrated process is started for the next product for which the selling price is changed).

As described above, when the server device 10 according to the embodiment is used, the administrator of the server device 10 who is the product provider stores the notification order information regarding each product stored in the cart database 22. Since you can determine the number of items ordered and the price of each item by referring to the price distribution and the number of pre-order information for each item, you can carry out mail order in good condition (in the form of getting a large profit) You can

Further, each member can receive the notification by e-mail when the selling price of the product he / she wants to purchase falls below the desired price, as long as the member has placed a notification order. . Therefore, each member can purchase a desired product at a desired price without frequently accessing the server device 10.

On the shopping page provided by the server device 10 to the members, the order display information related to the notification order for which the price change notification mail has been issued is displayed, and the order display information is selected, and the “auxiliary → purchase” button is selected. By pressing 65, a product can be purchased (a notification order can be changed to a purchase order). Therefore, the member who receives the price change notification email can select the desired product,
It is possible to make a purchase with a simple operation (without performing an operation for displaying the "to purchase cart" button 81a for the product in the catalog area 61). Also, if the member changes the desired price of the order display information displayed on the shopping page because the price change notification email was sent, when the selling price becomes lower than the desired price, the price will be set again. You will receive a change notification email.

<Modification> The server device 1 according to the embodiment
0 can be variously modified. For example, the server device 10 cannot specify the purchase number of products (a plurality of products,
When purchasing the same product, the device has to press the "To purchase cart" button 64 for the product more than once), but the server device 1 allows the purchase number of products to be specified.
You may transform 0.

The shopping page provided to the member by the server device 10 is one that causes the computer terminal 110 to perform a considerable process (including a script), but every time the member performs some operation, the operation is performed. The server device 10 may be configured to provide a shopping page that causes the computer terminal 110 to transmit a request corresponding to the above. Further, the server device 10 is a device that provides a service in which only a person who has registered as a member can carry out shopping. However, the server device 10 is modified into a device that provides a service in which a general user can carry out shopping. Of course it is also good.

Further, although the server device 10 is a device for notifying that the selling price has been changed, the server device 10 is configured so as to be able to notify that the selling environment other than the selling price has been changed. You may keep it. Further, even if the member can specify the expiration date of the notification order (or the desired acquisition date of the product) and the price change notification mail is not transmitted when the expiration date has passed, the server device 10 may be configured. good. Note that the server device 10 that operates in this manner, for example, sets the notification order information to include information indicating the deadline (date, etc.) and adds a function of deleting the notification order information that has passed the deadline ( Alternatively, it can be realized by configuring the notification order processing unit 13 so as to determine whether the time limit has expired before executing step S603 (FIG. 20).

[0117]

According to the present invention, the manager of the server device can carry out mail order sales in a good condition (with a great profit). Also, the user
Since you can be notified that the sales environment of the desired product has been changed to the desired one, work to regularly check whether the sales environment of the product has changed (work to visit a Web page, etc.) It is possible to purchase a product under desired conditions without performing the above.

[Brief description of drawings]

FIG. 1 is an explanatory diagram of a configuration of a server device according to an embodiment of the present invention.

FIG. 2 is an explanatory diagram of a product database included in the server device according to the embodiment.

FIG. 3 is an explanatory diagram of a cart database included in the server device according to the embodiment.

FIG. 4 is an explanatory diagram of order information stored in a cart database.

FIG. 5 is an explanatory diagram of a status management table included in the server device according to the embodiment.

FIG. 6 is a flowchart showing an operation procedure of a computer terminal that has accessed a server device.

FIG. 7 is an explanatory diagram of a top page displayed on a computer terminal that has accessed a server device.

FIG. 8 is a flowchart of member registration acceptance processing executed by a request processing unit included in the server device.

FIG. 9 is a flowchart of login acceptance processing executed by a request processing unit.

FIG. 10 is an explanatory diagram of a login page displayed on a computer terminal that has accessed the server device.

FIG. 11 is an explanatory diagram of a shopping page displayed on a computer terminal that has accessed the server device.

FIG. 12 is a flowchart showing the overall operation procedure of the request processing unit after receiving a shopping page request.

FIG. 13 is a flowchart showing an operation procedure of the computer terminal when the “To purchase cart” button on the shopping page is pressed.

FIG. 14 is a flow chart of purchase request response processing executed by a request processing unit.

FIG. 15 is a flowchart showing the operation of the computer terminal when the “To auxiliary cart” button on the shopping page is pressed.

FIG. 16 is a flowchart of operations of the computer terminal when the order display information shown on the shopping page is selected.

FIG. 17 is a flowchart showing an operation procedure of the computer terminal when a “delete” button on the shopping page is pressed.

FIG. 18 is a flowchart showing an operation procedure of the computer terminal when the “auxiliary → product” button on the shopping page is pressed.

FIG. 19 is a flowchart of a cart database changing process executed by the request processing unit.

FIG. 20 is a flow chart of processing executed by a notification order processing unit included in the server device for each product whose sales price has been changed.

[Explanation of symbols]

10 Server device 11 Memory 12 Request processing unit 13 Notification order processing unit 14 Product management processing unit 21 Product database 22 cart database 23 Situation management table 100 Internet 110 computer terminal

Claims (5)

[Claims] 1. A server device for mail order, which acquires, from a user, product identification information indicating a product that is considered to be purchased and a desired purchase price for the product, the acquisition device. A desired purchase price storage means for storing the respective desired purchase prices acquired by the product identification information, an instruction input means for inputting various instructions, and a display means for displaying various information, Means for displaying on the display means a result of statistically processing the information stored in the desired purchase price storage means according to the instruction input to the instruction input means, at least the purchase request for each product. A server device, comprising: a display control unit having a function of displaying information indicating a price distribution of prices on the display unit. 2. A server device for mail-order sales, including acquisition means for acquiring product identification information representing a product for which a user is considering purchasing, and product identification information acquired by the acquisition device. User request information storage means for storing user request information, and each user request information stored in the user request information storage means, after storing the user request information in the user request information storage means, A server device comprising: a user request information erasing unit that deletes from the user request information storage unit when a predetermined period has elapsed. 3. The acquisition unit is a unit that also acquires period designation information for designating a period from a user, and the user request information stored in the user request information storage unit is the product identification information and the period. It is information including designation information, the user request information erasing means, each user request information stored in the user request information storage means, after storing the user request information in the user request information storage means,
3. The server device according to claim 2, wherein the server device deletes the user request information storage unit when a period designated by the period designation information in the user request information has elapsed. 4. An instruction input means for inputting various instructions, a display means for displaying various information, and a statistical processing according to the instruction input to the instruction input means by the user request. 4. The server device according to claim 2, further comprising: a display control unit that causes the display unit to display a result obtained by applying the information stored in the information storage unit. 5. A mail order system in which a plurality of computer devices and a server device are connected via a communication network, wherein each of the plurality of computer devices is based on information input by a user. A user request information transmitting unit that creates user request information, which is information including product identification information that represents a product that the user is considering to purchase, and transmits the user request information to the server device, wherein the server device is provided in each computer terminal. The user request information storage unit for storing the user request information transmitted by the product identification information transmission unit, and the user request information stored in the user request information storage unit, After the storage in the user request information storage means, when a predetermined period of time has passed, it is deleted from the user request information storage means. Mail-order system, characterized in that it comprises a chromatography The requested information erasing means.