JP4876479B2 - Price presenting apparatus and price presenting program - Google Patents

Description

  The present invention relates to a price presentation device and a price presentation program for presenting price information according to a customer order.

  Conventionally, when a user purchases a product using the Internet or the like, the price display of the product only displays the current price or the price for the shortest delivery date.

In addition, the price fluctuation within the specified period is calculated as price stability for the purpose of determining the shipping destination satisfying the target sales amount etc. and determining the required shipment quantity in consideration of fluctuations in the market price, etc. As a result, in some cases, the price is determined as a more appropriate market as a shipping destination in the order of the smallest price fluctuation, and some of them are ranked. (For example, refer to Patent Document 1.)
JP-A-11-353364

  In the conventional technique, the shortest delivery date is presented or a price corresponding to the shortest delivery date is displayed. For this reason, even if it is not necessary for the user to deliver the product with the shortest delivery time, it has been delivered at the same price at the shortest time. In addition, the transporter only orders transport with the shortest delivery date, and the transport amount cannot be made uniform.

  The present invention provides a receiving means for receiving product information, a second period in which a provision cost related to product information within a predetermined first period is shorter than the first period based on the product information of the receiving means It is made to function as a calculation means for calculating every time, and a display means for displaying the provision cost for each second period calculated by the calculation means.

  With this configuration, price information is presented for each delivery date, and the customer can select a suitable delivery date based on the information.

  Further, when there are a plurality of provision costs when the second period is the same period in the second period, the calculation means calculates only the provision cost that is the calculation result with the lowest provision cost. It is characterized by holding as.

  With this configuration, the lowest price for each delivery date is displayed, and the user can select more easily.

  Further, the calculating means is calculated from a product warehouse management cost, a product transportation cost, and a product price.

  With this configuration, the lowest price can be calculated from the warehouse management cost, the transportation cost, and the product price of the product.

  In addition, the transport amount is smoothed by selecting the lowest price by the customer.

  According to the present invention, it is possible to display the price for each delivery date. Thus, the user can consider the delivery date and price, and can select an appropriate delivery date. In addition, for the transportation company, it is possible to smooth the transportation amount for each transportation day from the smoothing of the delivery date of the user.

  Preferred examples for carrying out the present invention are shown below.

  FIG. 1 shows a system configuration diagram for realizing the price pattern presentation program of the present invention.

  The system of the present invention includes a price presentation device 10, a client terminal 20, a trader terminal 30, and a data table 40.

  The price presentation apparatus 10 is connected to the client terminal 20 and the trader terminal 30 via a network and has a data table 40. Furthermore, it is also possible to have a price presentation program 11 and cause the computer to function as a price presentation device.

  The client terminal 20 is a terminal used by customers who order products.

  The trader terminal 30 is a terminal through which a transportation company or a warehouse management company transmits transportation information, warehouse information, and the like to the price presentation device 10.

  The data table 40 stores a data table for managing costs related to products. Specifically, a product table 41 and a transportation pattern table 42 are stored.

  FIG. 2 shows a data configuration diagram of the product table 41. The product table 41 includes a product 411, a product unit price 412, a shipping source 413, and a warehouse management cost 414. The product 411 is a product model number or the like, and is used to distinguish the type of product. The product unit price 412 is a price per unit quantity of the product 411.

  The shipping source 413 indicates which warehouse the shipping source of the product 411 is. The warehouse management cost 414 is a price per day required when the product 411 is stored in the warehouse.

  FIG. 3 shows a data configuration diagram of the transport pattern table 42. The transportation pattern table 42 includes transportation means 421, shipping origin 422, shipping destination 423, shipping date 424, transportation period 425, transportation unit maximum number 426, transportation cost unit price 427, and shipping confirmed product number 428. The transport pattern table 42 is a table that exists for each type of product 411.

  The transportation means 421 is a transportation type of the product 411, and includes a truck, a ship, a train, an aircraft, and the like, and a plurality of traders are registered. The shipping source 422 is the same as the shipping source 413 of the product table 41. The shipping destination 423 indicates a warehouse at the shipping destination.

  The shipping date 424 indicates a date that can be shipped. This is because the carrier is suspended. The shipping date is obtained from another system in advance. For example, it is possible by linking the production factory and the system.

  The transportation period 425 is the number of days required for the product to move from the shipping source to the shipping destination. The maximum number of transport units 426 indicates the quantity that the transport means 421 can transport the product 411. The transportation cost unit price 427 indicates the transportation cost per unit of the transportation means 421. The shipment confirmed product number 428 is the number of products 411 confirmed to be shipped at the present time.

  The hardware configuration of the price presentation device 10 includes a CPU, ROM, RAM, HDD (hard disk drive), HD (hard disk), FDD (flexible disk drive), and FD as an example of a removable recording medium. (Flexible disk), display, I / F (interface), keyboard, and mouse. Each component is connected so that information can be transmitted.

  The CPU controls the entire price presentation device 10. The ROM stores a program such as a boot program. The RAM is used as a work area for the CPU. The HDD controls reading / writing of data with respect to the HD according to the control of the CPU. The HD stores data written under the control of the HDD. The FDD controls reading / writing of data with respect to the FD according to the control of the CPU. The FD stores data written under the control of the FDD, or causes the information processing apparatus to read data recorded on the FD. As a removable recording medium, in addition to the FD, a CD-ROM (CD-R, CD-RW), MO, DVD (Digital Versatile Disk), memory card, or the like may be used.

  The display displays a window (browser) relating to data such as a document, an image, and function information as well as a cursor, an icon, or a tool box. For example, CRT, TFT liquid crystal display, plasma display and the like. The CPU implements the function by executing the price presentation program stored in the ROM, RAM, HD, FD, or the like.

  In addition, various data stored in the various data tables 40 and a part of the data table may be generated and deleted as needed in a RAM used for work area purposes.

  The I / F (interface) is connected to a network such as a LAN or the Internet through a communication line, and is connected to another information processing apparatus (such as a server) via the network. The I / F controls the interface between the network and the inside, and controls data input / output from other servers and information terminal devices. The I / F is, for example, a modem. When the information providing apparatus performs wireless communication with a mobile phone or the like, the I / F also has a function as a communication device (wireless transceiver).

  The keyboard has keys for inputting characters, numbers, various instructions, etc., and inputs data. It may be a touch panel type input pad. The mouse moves the cursor, selects a range, or moves and changes the size of the window. A trackball, a joystick, or the like may be used as long as it has a similar function as a pointing device.

  Hereinafter, a series of processing from order data reception to price presentation in the present embodiment will be described with reference to a flowchart.

FIG. 4 shows a flowchart for calculating the product cost.
The price presentation apparatus 10 receives the product 411 and the delivery location (shipping destination 423) from the client terminal 20 (S101). It receives order information from customers.

  FIG. 7 shows an example of an input screen displayed on the client terminal 20. The method for displaying the input screen of FIG. 7 may be a method performed by executing an application program registered in advance in the client terminal, or may simply display data held on the price presentation apparatus 10 side. In FIG. 7, a product name (product 411) is displayed, and a quantity, a delivery location, and a selection input part are displayed in a column associated with the product name. The customer inputs information to the input part, and the order information is transmitted to the price presentation device by pressing the estimate button.

  When the price presenting apparatus 10 receives the order information of S101, the price presenting apparatus 10 refers to the record of the product table 41 from the product 411 and extracts the shipping source 413 (S102).

  The price presenting apparatus 10 searches for the nearest shipping destination warehouse 423 from the delivery location information of the order information in S101 (S103). In the transport pattern table 42, the price presentation apparatus 10 extracts a record in which the shipping destination information of the order information matches the shipping destination 423 and the shipping source 413 of the product table 41 matches the shipping source 422 (S104).

  The price presentation device 10 reads data for a predetermined period (S105). The period data specifically indicates information on the number of days from the present to the delivery deadline date when the product is delivered to the shipping destination warehouse. The price presentation apparatus 10 extracts a record that can be delivered before the delivery deadline date from the record extracted in S103, and stores it as a delivery possible date in association with the record (S106). Specifically, the scheduled delivery date is calculated from the shipping date 424 and the transportation period 425 for the corresponding record, and the record in which the product can be transported to the shipping destination before the delivery deadline date is stored.

  The price presentation device 10 sorts in order of delivery date (S107). This is a preliminary process for sorting the records narrowed down in S106 in order of delivery date, and for calculating the price in order of delivery date.

  The price presentation device 10 performs a cost calculation process (1) (S108). The cost calculation process (1), which will be described in detail below, calculates the cost of the product every delivery date.

  FIG. 5 shows a flowchart of the cost calculation process (1). The transportation cost is calculated for each delivery date, and the lowest value of the transportation cost is stored.

  The price presenting apparatus 10 reads the records sorted in order of delivery date in S107 in order of delivery date (S201).

  Next, the record date read in S201 is read as the delivery date 1 with reference to the delivery date associated in S106 (S202). Here, the delivery date 1 refers to the delivery date associated with the current record, and the delivery date 2 refers to an identification value for extracting the lowest price for each delivery date.

  Next, the process of cost calculation (2) is performed (S203). The cost calculation process (2), which will be described in detail below, calculates the shipping cost for the current record.

  FIG. 6 shows a flowchart of the cost calculation process (2).

  The price presentation device 10 reads the product price from the product table 41 (S301). This is to obtain the product price.

  Next, the warehouse management cost is read from the product table 41, and the current shipping date 424 is read from the record of the transportation pattern table 42 (S302).

  Next, the warehouse cost is calculated from the warehouse management cost (yen / day) obtained in S302 and the storage period (day) (S303).

  The storage period is a period from the current date to the shipping date 424. The transportation cost unit price 427, the transportation unit maximum number 426, and the shipping confirmed product number 428 are read from the transportation pattern table 42 (S304).

  Next, the number of products to be transported with respect to the transport unit is calculated (S305). The number of products to be transported is determined by the remainder obtained by dividing the number 428 of products that have been shipped by the maximum number of transport units.

  Next, the transportation cost of the ordered product is calculated (S306). The transportation cost is obtained by dividing the transportation cost unit price by the number of products to be transported calculated in S305.

  The ordering cost is calculated by summing up the above costs from S301 to S306 (S307). The ordering cost is the sum of the product price, warehouse cost, and transportation cost.

  After the cost calculation (2) is completed, the price presentation device 10 determines whether the delivery date 1 and the delivery date 2 match (S204). The case of matching means that the delivery date of the record processed immediately before matches the delivery date of the record read in S201, and indicates a case where the lowest price needs to be compared. On the other hand, if they do not match, the delivery date of the record read in S201 is different from the delivery date of the immediately preceding record, so it is necessary to perform a switching process.

  That is, when the delivery date 1 and the delivery date 2 do not match (S204: No), the delivery date 2 is updated as the delivery date 1 (S205). When the delivery date 1 and the delivery date 2 match, it is necessary to compare the lowest price on the delivery date. Therefore, the cost for the current record calculated in S203 and the previous record are calculated. Of the costs, the delivery date is compared with the cost on the same day (S206).

  Next, it is determined whether or not the cost for the current record is the lowest price (S207). If the cost is the lowest price (S207: Yes), the information on the lowest price on the current delivery date is updated (S208).

  The delivery date 2 and the lowest price record are stored in association with each other (S209). Thereafter, it is determined whether or not the processing has been completed for all the records sorted in S107 (S210). If the processing has not been completed for all the records (S210: No), the next record is processed in S201, When the process is completed for all records, display processing after S109 is performed.

  The lowest price for each delivery date is output (S109). The product cost for each delivery date calculated in the cost calculation process (1) of S108 is displayed. The client terminal 20 receives the lowest price for each delivery date and displays it on the client terminal 20 (S110).

FIG. 8 shows an output screen example.
If the product name is CP0503, the quantity is 1 unit, and the shipping destination is Fukuoka XXX, the price for each delivery date from March 6, 2005 to March 10, 2005 is the client. It is displayed on the terminal 20. The customer selects a suitable one from among the plurality of price displays and places an order by using the client terminal 20 to confirm the order.

  As a price display method, it is possible to add a function of notifying the customer terminal of the price change when the price of the product is changed due to a change in the transportation cost due to the transportation quantity. That is, there is a case where the transportation cost is lowered when another customer orders the product after the customer places an order until the product is shipped. In this case, it is possible to reflect the transportation cost and present the revised product price to the terminal of the customer who ordered.

  In addition, when there is a possibility of fluctuations in transportation costs due to the above-mentioned transportation quantity, the price when the transportation cost becomes the lowest value is calculated when presenting the price, and the current product price and the transportation cost are calculated. It is also possible to expand the customer's options by adding the price when the price is at the lowest price.

  FIG. 9 shows an output screen example 2 when the price is written together.

Although one embodiment of the present invention has been described above, the present invention is not limited to this. For example, the cost calculation process shown in FIG. 6 is an example, and the transportation cost varies according to the number of transportation. The price related to the number of products transported per unit transportation number and the transportation unit price is calculated in advance. It is also possible to decide and present a price according to the current number of orders. Moreover, the structure of the price presentation apparatus 10 shown in FIG. 1 is an example, and may differ from an actual structure. Each device may be configured by a plurality of servers and computers.
(Appendix 1)
A price presentation program that displays the price of a product,
On the computer,
Receiving means for receiving product information;
An arithmetic means for calculating a provision cost related to product information within a predetermined first period for each second period, which is a period shorter than the first period, based on the product information of the receiving means;
Display means for displaying the provision cost for each second period calculated by the computing means;
Price presentation program to function as.
(Appendix 2)
The price presentation program according to appendix 1, wherein the calculation means holds the lowest provision cost as a calculation result when there are a plurality of provision costs in the second period in the second period.
(Appendix 3)
The price presentation program according to appendix 1, wherein the calculation means is calculated from a warehouse management cost of the product, a transportation cost of the product, and a product price.
(Appendix 4)
A price presentation device that displays the price of a product according to order conditions,
Receiving means for receiving product information;
An arithmetic means for calculating a provision cost related to product information within a predetermined first period for each second period, which is a period shorter than the first period, based on the product information of the receiving means;
Display means for displaying the provision cost for each second period calculated by the computing means;
A price presentation device comprising:
(Appendix 5)
The price presentation apparatus according to appendix 4, wherein the calculation means holds the lowest provision cost as a calculation result when there are a plurality of provision costs in the second period in the second period.
(Appendix 6)
The price presentation apparatus according to appendix 4, wherein the calculation means is calculated from a product warehouse management cost, a product transportation cost, and a product price.

System Configuration Data structure diagram of product table 41 Data configuration diagram of transport pattern table 42 Flow chart for calculating product cost Flow chart of cost calculation process Flow chart of cost calculation process (2) Input screen example Output screen example Output screen example 2

Explanation of symbols

DESCRIPTION OF SYMBOLS 10 Price presentation apparatus 11 Price presentation program 20 Client terminal 30 Contractor terminal 40 Data table

Claims (4)

A price presentation program that displays the price of a product on a computer,
Receive order information including product and product quantity information,
Transportation unit maximum number information indicating the quantity that can be transported the product by one transportation means stored in advance, transportation cost unit price information indicating the price when the one transportation means is transported, and shipping by the one transportation means Calculating a remainder obtained by dividing the shipment confirmed product number information by the transportation unit maximum number information with reference to a transportation pattern table having a record including the shipment confirmed product number information indicating the quantity of the confirmed product ;
Calculate the transportation cost per product by dividing the transportation cost unit price information by the calculated remainder,
Identify bid of the product contained in the order information with reference to the product table having a record including the bid information stored in advance for each product,
Calculate the provision cost of the product from the calculated transportation cost of the product and the unit price of the identified product,
A price presentation program for executing a process for outputting the calculated provision cost. The order information further includes information on a delivery location, and the transportation pattern table further includes information on a shipping source of the product, a shipping destination of the product, a shipping date indicating a shipping date, and a transportation period. Contains further information on the origin of the product,
Identifying the product information of the order information and the shipping source of the product in the product table corresponding to the delivery location;
Identifying the shipping source of the product and the shipping destination of the product in the transport pattern table respectively corresponding to the shipping source of the product in the specified product table and the delivery location of the order information;
Specifying a transportation period for each shipping destination of the product and the shipping destination of the product in the identified transportation pattern table;
A delivery date is calculated from the shipping date and the specified transportation period in the transportation pattern table;
Identify the record of the transportation pattern table and the record of the product table that will be the scheduled delivery date before a predetermined delivery deadline date,
The price presentation program according to claim 1, wherein the computer executes a process of calculating the provision cost based on the specified record of the transportation pattern table and the record of the product table. The product table further includes warehouse management cost information indicating the storage cost of the product for each predetermined period,
Based on the warehouse management cost of the product table, calculate the warehouse management cost from obtaining the order information to shipping,
A claim for causing the computer to execute a process of calculating the provision cost from a warehouse management cost from acquisition of the calculated order information to shipping, a calculated transportation cost of the product, and a unit price of the identified product. The price presentation program according to 1. A price presentation device,
Receiving means for receiving order information including product and product quantity information;
Information on the maximum number of transport units indicating the quantity that can be transported by one transport means, transport unit price information indicating the price at which the one transport means is transported, and shipping confirmed by the one transport means Storage means for storing a transport pattern table having a record including shipment confirmed product number information indicating the quantity of the product, and a product table having a record including unit price information for each product;
By referring to the transportation pattern table , a remainder obtained by dividing the shipment confirmed product number information by the transportation unit maximum number information is calculated, and by dividing the transportation cost unit price information by the calculated remainder, per product. A calculating means for calculating the transportation cost of
A bid specifying means for referring to said product table identifies the price of the products included in the order information,
A computing means for computing the provision cost of the product from the transportation cost of the product calculated by the calculating means and the unit price of the product specified by the unit price specifying means;
A price presentation apparatus comprising: output means for outputting the provision cost calculated by the computing means.

Images