JP4979098B1 - Product information processing apparatus and product information processing method - Google Patents

Abstract

Provided is an information processing apparatus and method for merchandise purchase and sale that improves the efficiency of merchandise trade by performing information processing based on needs of sellers and buyers.
When sell order information is received, buy order information having a buy price that is equal to or higher than the sell price is extracted and rearranged in descending order of buy price and in the order of buy order time at the same price. It is determined whether or not one of the sorted buy order information and the received sell order information matches the filter information, and a transaction establishment process is performed if the filter information matches. When buy order information is received, sell order information having a sell price that is equal to or less than the buy price is extracted, and sorted in ascending order of sell price and in order of early sell order time at the same price. It is determined whether or not one of the sorted sell order information and the received buy order information matches the filter information, and if the filter information matches, the transaction establishment process is performed.
[Selection] Figure 1

Description

The present invention relates to a merchandise trading information processing apparatus and a merchandise trading information processing method for performing information processing related to trading of merchandise based on information relating to seller selling orders and buyer buying orders.

  2. Description of the Related Art Conventionally, a merchandise trading system for buying and selling merchandise in the form of an auction on the Internet is known (for example, see Patent Document 1). In addition, regarding securities transactions, securities information distribution devices that distribute information on seller's desired selling price and the number of items (auction price) and buyer's desired selling price and the number of items (auction price) have been proposed (for example, patents). Reference 2).

JP 2001-350964 A JP 2008-130020 A

  For example, in order to buy and sell products via a network such as the Internet, it is conventionally necessary for the seller (supplier) to have a unique sales page on the Internet for each seller (referred to as "sales space"). This is a system in which information and prices of products are posted in a unique sales space, and buyers (buyers) who see the products order the products if the content is as desired, and the transaction is concluded.

  However, in such a system, from the viewpoint of the buyer, the desired product must be searched for on the Internet and compared from different information layouts. Also, if there is a difference between the market price of the desired product and the desired price, you have to be patient and keep looking. Further, since the buyer does not know the actual situation on the distribution side, there is a problem that the desired price is not always a feasible price and is not always sold at the desired price.

  On the other hand, from the viewpoint of the seller, it is necessary to provide a unique sales page on the Internet in order to sell the product, and it is expensive to maintain such a sales space. In recent years, the sales space has been increasing, so it is necessary to actively carry out advertising activities such as advertisements, and the advertising costs must be added to the product price. In addition, products cannot be sold unless they are purchased in advance, but when you purchase, you do not know how much demand there is in the world, so purchase in small quantities or in anticipation of some loss. As a result, the price of the product increases.

  SUMMARY OF THE INVENTION An object of the present invention is to provide a product trading information processing apparatus and a merchandise trading information processing method that perform information processing based on needs possessed by sellers and buyers via a network and efficiently perform merchandise trading processing. And

In order to achieve the above object, the present invention includes supplier identification information, selling price, number of units sold, selling order time, supplier-side filter information, and shipping definition information regarding the size of the product. Sell order information receiving means for receiving sell order information and storing it in the sell order information storage unit, and for the product, from the buyer's terminal, buyer identification information, buy price, quantity purchased, buy order time and buyer side filter information Buy order information receiving means for receiving buy order information and storing it in a buy order information storage unit, and supplier postage setting including postage data set by the supplier and corresponding to the size and shipping destination of the product When the sell order information is received by the supplier information storage unit storing the table and the sell order information receiving means, the buy order information is received. For each of a plurality of buy orders stored in the order information storage unit, refer to the supplier postage setting table, and search for the postage data corresponding to the shipping order shipping destination and the postage definition information to determine the postage. A postage-free purchase price calculation means for calculating a postage-free purchase price obtained by subtracting the postage from the purchase price, and the purchase order information having the post-shopping price higher than or equal to the sell price of the received sell order information. A purchase order extracting unit that is extracted from the purchase order information storage unit, and the buy order information that is extracted by the buy order extracting unit is rearranged in descending order of the purchase price without shipping charges and the order of the buy order at the same price. Corresponding to one of the sorted order information and the received sell order information in the order rearranged by the order rearranging means and the buy order rearranging means Predetermined data processing is performed on the supplier-side filter information and the buyer-side filter information, and when the condition is met, a first filter determination processing means for outputting a value indicating a match, and the rearranged For one of the buy order information and the received sell order information, a first transaction establishment means for performing a transaction establishment process when a value indicating the match is output, and the buy order information receiving means When the order information is received, for each of the plurality of sell orders stored in the sell order information storage unit, the supplier postage setting table is referred to, and the shipping destination of the received buy order information and the postage definition information The postage data corresponding to the price is determined by determining the postage, and the postage-included sales price calculation means for calculating the postage-included sales price obtained by adding the postage to the sales price; Sell order extraction means for extracting from the sell order information storage unit the sell order information having a low or the same price including the postage, and the sell order information extracted by the sell order extraction means. Sell order rearranging means for rearranging the sell order time in ascending order of the selling price and in order of the sell order time, and one of the sell order information rearranged in the order rearranged by the sell order rearranging means. A second filter determination that performs predetermined data processing on the supplier-side filter information and the buyer-side filter information corresponding to the received buy order information and outputs a value indicating the match when the condition is met. A transaction establishment process is performed when a value indicating the match is output for the processing means and one of the sorted sell order information and the received buy order information. And a second transaction establishment means, with respect to the product, to generate a sale sign table displayed in association with a plurality of price is set at regular intervals, and the number of number and purchase orders sell orders for each price sale A bid table generating means, and when the bid price table generating means generates the bid price table to be displayed on the terminal of the supplier, referring to the supplier shipping cost setting table, Search the postage data corresponding to the postage definition information, and refer to the sell price and the number of units sold for each of a plurality of sell orders stored in the sell order information storage unit, and sell the number corresponding to the price The selling number corresponding to each price is determined by adding the selling number to each of the plurality of buying orders stored in the buying order information storage unit. The buying quantity corresponding to each price is determined by adding the buying quantity to the buying quantity of the price obtained by subtracting the shipping cost from the buying price, while referring to the quantity, and the buying and selling displayed on the terminal of the buyer When generating a quotation table, the supplier's shipping cost setting table is referred to, the shipping data corresponding to the buyer's shipping destination and the shipping cost definition information is searched, and a plurality of data stored in the selling order information storage unit are stored. For each of the selling orders, the selling price corresponding to each price is determined by adding the selling volume to the selling price of the price obtained by adding the shipping price to the selling price with reference to the selling price and the selling price. For each of a plurality of buy orders stored in the buy order information storage unit, refer to the purchase price and the number of units purchased, and add the number of units purchased to the corresponding number of purchases of the corresponding price. Decide how many to buy The buy order information includes buy order log information and buy order detail information. The buy order log information includes a buy order ID assigned to each buy order on a one-to-one basis, and a transaction is established for each buy order. A transaction establishment flag indicating whether or not the transaction has been completed, and a parallel bid flag indicating whether or not each purchase order is a target of a parallel bid. Can be stored in association with the purchase order related to the product ID, and the purchase order detail information stores the purchase order related to the plurality of product IDs in association with the purchase order having the parallel bid flag of 1. Therefore, when the transaction establishment flag of the buy order ID whose parallel bid flag is 1 is already established, the transaction ends for all of the plurality of products related to the plurality of product IDs corresponding to the buy order ID. Made is to provide products for sale for the information processing apparatus.

Further, the supplier-side filter information includes a supplier-side shipping date filter composed of a first predetermined-length bit string that represents information related to the shipping date, and the buyer-side filter information represents the information about the desired shipping date. A buyer-side shipping date filter composed of a bit string of a predetermined length, wherein the first filter determination processing means and the second filter determination processing means are configured such that the supplier-side shipping date filter and the buyer-side shipping date filter When there is a bit that is “1” by taking the logical product of the corresponding bits, it is determined that the condition is met, and the supplier is constituted by a bit string of a second predetermined length that represents information about the region where the supplier is located. A supplier information storage unit for storing a regional bit string is further provided, and the buyer-side filter information includes a supplier desired by the buyer. A supplier region filter composed of the second predetermined-length bit string representing information relating to the customer's region, wherein the first filter determination processing means and the second filter determination processing means include the supplier region bit string and the supplier region filter. An information processing apparatus for buying and selling merchandise that determines that the condition is met when there is a bit that is “1” by taking the logical product of the bits corresponding to each other .

  Here, it further includes a buyer information storage unit that stores payment information corresponding to the buyer identification information of each buyer, and each of the first transaction establishment means and the second transaction establishment means is based on the payment information, Payment error determination means for determining whether or not an error has occurred in the payment, and subtracting the number of successful transactions from the number sold and the number bought when the payment error determination means determines that no error has occurred Number subtracting means, a remaining number zero determining means for determining whether the sold number and the purchased number subtracted by the number subtracting means have become zero, and the sold number determined by the remaining number zero determining means. It is preferable to include a transaction establishment flag setting means for setting a flag indicating the establishment of a transaction for the sell order information or the buy order information when the number of units or the number of purchased units becomes zero.

Further, the buying and selling price table generating means refers to the selling order information storage unit, and extracts a selling order that has the same selling price as the selling order of the supplier and whose transaction establishment flag is 0. Sorted in ascending order of update time, determines the ranking of the selling order of the supplier and displays it on the trading quotation table. The trading quotation table generating means refers to the buying order information storage unit Necessary for immediate sales by searching for the highest bid price among the buy orders with the transaction establishment flag of 0 and obtaining the difference between the price obtained by subtracting the shipping cost from the bid price and the selling price of the supplier's selling order. The bid price table generating means refers to the buy order information storage unit and refers to the buy order information storage unit, and the buy price information is a buy order having the same buy price as the buyer's buy order and A buy order with an established flag of 0 is extracted and rearranged in ascending order of update time, the order of the buyer's buy order is determined and displayed in the buy and sell table, and the buy and sell table is generated The means refers to the selling order information storage unit, searches for the lowest selling price among selling orders with the transaction establishment flag being 0, and calculates the price obtained by adding the shipping cost to the selling price and the buying price of the buyer's buying order. By calculating the difference, it is preferable to calculate the price increase necessary for immediate purchase and display it on the sales quotation table.

  The present invention also provides a merchandise sales information processing method corresponding to the above apparatus.

According to the above-described merchandise buying and selling information processing apparatus and merchandise buying and selling information processing method , the sell order information received from the supplier and the buy order information received from the buyer can be efficiently linked based on the price and the order time. . Further, since the transaction is established only for the buy order and the sell order that match the supplier side filter information and the buyer side filter information, the sale can be established according to the needs of the supplier and the buyer. More specifically, the buyer does not need to operate a sales space (a unique sales page on the Internet), and costs for operating the sales space, advertising costs, and the like are not required. In addition, payment related processing such as the introduction of a payment system and payment confirmation becomes unnecessary. Further, by using a mechanism using such a purchase order or the like, the buyer can make a reservation for purchasing the product at a desired price, and can purchase at the desired price if the conditions are met.

Further, according to the above-described merchandise trading information processing apparatus and merchandise trading information processing method , a plurality of prices set at regular intervals, the number of sell orders and the number of buy orders for each price are displayed in association with each other. By generating the sales quotation table, it is possible for the supplier or the buyer to visually recognize the sales situation in an easy-to-understand manner. In addition, after the shipping cost is determined from the supplier shipping cost setting table, the number of purchases of the price minus the shipping cost in the trading quote table is shown to the supplier, and the seller of the price including the shipping cost is added to the buyer in the trading quote table. We are going to show the number. For this reason, since the price after considering the shipping fee can be shown to the supplier and the buyer, it is possible to avoid the problem that the shipping fee differs depending on the region of the shipping source and the shipping destination and the comparison is troublesome. In addition, the supplier can purchase as many items as necessary according to the purchase reservation number (buy number) of the buyer, so that efficient purchase is possible.

In addition, according to the information processing apparatus for selling / buying merchandise and the merchandise buying / selling information processing method described above, a plurality of merchandise IDs corresponding to one buy order ID are set when a transaction establishment flag of one buy order ID is already established. The transaction is concluded for all of the plurality of commodities related to. For this reason, when a buyer places a purchase order for a plurality of products and wants to purchase one of them (parallel bid), there is no possibility that a transaction will be concluded for a plurality of products, which is safe and convenient. .

Further, according to the above-described merchandise trading information processing apparatus and merchandise trading information processing method , the filter information is composed of a bit string of a predetermined length, and a bit that is “1” is obtained by performing a logical product on each bit of both filter information. It is possible to determine whether or not the condition is met by a simple method of determining whether or not there exists.

In addition, according to the information processing apparatus for buying and selling merchandise described above, it is possible to immediately determine whether or not an error has occurred in settlement based on the settlement information of buyers registered in advance, By setting a flag indicating that the transaction has been established when the number of units becomes zero, it is possible to refer to the subsequent processing.

The block diagram which shows the information processing apparatus for merchandise sales by embodiment of this invention, and the terminal of the supplier and buyer connected via the internet. The table which shows the merchandise master information memorize | stored in a merchandise information storage part. The table which shows the supplier information memorize | stored in a supplier information storage part. The table which shows the supplier mailing cost setting memorize | stored in a supplier information storage part. The table which shows the buyer information memorize | stored in a buyer information storage part. The table which shows sell order log information memorized by a sell order information storage part. The table which shows the purchase order log information memorize | stored in a purchase order information storage part. The table which shows the purchase order detailed information memorize | stored in a purchase order information storage part. The table which shows the transaction establishment log information memorize | stored in a trading information storage part. The figure which shows the supplier registration screen displayed on the screen of a supplier terminal. The flowchart which shows a supplier registration process. The figure which shows the buyer registration screen displayed on the screen of a buyer terminal. The flowchart which shows a buyer registration process. The figure which shows the product registration screen displayed on the screen of a supplier terminal. The flowchart which shows a part in sell order processing. The flowchart which shows the remaining part among sell order processes. The figure which shows notionally the information of the buy order rearranged based on a price and update date in a sell order process, and memorize | stored in a temporary memory part. The figure which shows the product purchase reservation screen displayed on the screen of a buyer terminal. The flowchart which shows a part in purchase order processing. The flowchart which shows the remaining part among purchase order processes. The flowchart which shows parallel bid processing. The figure which shows the parallel bid selection screen displayed on the screen of a buyer terminal. The flowchart which shows a filter determination process. The figure for demonstrating the bit string of a shipping date filter. The figure for demonstrating the bit string of a supplier area | region filter, and the area | region bit string of a supplier. The flowchart which shows transaction establishment processing. The flowchart which shows an expired purchase order determination process. The flowchart which shows a shipping process. The flowchart which shows a part in trading price table generation process (for suppliers). The flowchart which shows the remaining part in the sales quotation table generation process (for suppliers). The figure which shows the buying and selling price table (for suppliers) displayed on the screen of a supplier terminal. The flowchart which shows a sales quotation table generation process (for buyers). The flowchart which shows a part in trading price table generation processing (at the time of login for buyers). The flowchart which shows a part following FIG. 27A among the sales quotation table generation processing (at the time of login for buyers). The flowchart which shows the remaining part in the sales quotation table generation process (at the time of login for buyers). The figure which shows the buying and selling price table (for buyers) displayed on the screen of a buyer terminal. The flowchart which shows a part in trading price table generation processing (at the time of non-login for buyers). The flowchart which shows a part following FIG. 29A among buying and selling price table generation processing (at the time of buyer non-login). The flowchart which shows the remaining part in the sales quotation table generation process (at the time of non-login for buyers).

  An information processing apparatus for buying and selling goods according to an embodiment of the present invention will be described with reference to FIGS. 1 to 29C. FIG. 1 is a conceptual diagram showing a system including an information processing apparatus for buying and selling goods according to this embodiment. A plurality of supplier terminals 2 and a plurality of buyer terminals 3 are connected to the Internet 1. Browsers for browsing websites are installed on the terminals 2 of the suppliers and the terminals 3 of the buyers. Here, the supplier means a person who sells the product, and the buyer means a person who purchases the product from the supplier.

<Device configuration>
FIG. 1 shows a server 10 that embodies a product trading information processing apparatus according to the present embodiment. The server 10 has a configuration similar to that of a known server computer, and includes a CPU 11, a RAM 12, a ROM 13, a communication interface (communication IF) 14, a clock unit 16, a hard disk drive (HDD) 20, and the like. Are connected to each other. The communication IF 14 is connected to the Internet 1.

  The CPU 11 is a central processing unit, and executes each process stored in the program storage unit 21 described later in cooperation with the RAM 12, the ROM 13, and the like. The RAM 12 temporarily stores data when the CPU 11 performs calculations. The ROM 13 is a read-only memory in which programs such as BIOS are stored. The clock unit 16 has a clock function for recording a sell order time and a buy order time, which will be described later. The configuration of the HDD 20 will be described later.

  In addition, about the structure of the server 10, since the access number is enormous and becomes a heavy load, it is preferable to construct the server 10 with several tens of servers. Here, by introducing a known load distribution device and load distribution function, uniform processing can be performed regardless of which server receives access.

  The configuration of the HDD 20 will be described. The HDD 20 includes a program storage unit 21, a product information storage unit 22, a supplier information storage unit 23, a buyer information storage unit 24, a sell order information storage unit 25, a purchase order information storage unit 26, a buying and selling information storage unit 27, and a temporary storage unit 28. Is provided. Actually, the area of the HDD 20 is not divided in this way by hardware, but conceptually shows each storage unit.

  The program storage unit 21 is for storing a plurality of processing programs for executing merchandise sales. As a plurality of processing programs will be described in detail later, supplier registration processing, buyer registration processing, sell order processing, buy order processing, transaction establishment processing, expired buy order determination processing, parallel bid creation processing, shipping processing, for suppliers There are trading price table creation processing, buyer trading price table creation processing (when logged in / not logged in), and the like. Further, screens (supplier registration screen, buyer registration screen, product registration screen, product purchase reservation screen, parallel bid selection screen) displayed on the display devices of the supplier terminal 2 and the buyer terminal 3 are also stored in the program storage unit 21. Yes.

  The merchandise information storage unit 22 is a storage unit for storing information related to merchandise sold on the EC site. As shown in FIG. 2, information on a product ID, a product name, a model number, a category, a manufacturer, a list price, a product description, and a unit price is stored for each product.

  The supplier information storage unit 23 is for storing information of suppliers registered in the EC site. As shown in FIG. 3A, for each supplier ID, the supplier name, location, postal code, region bit string, and prefecture information are stored. Further, as shown in FIG. 3B, information related to the supplier postage setting is also stored.

  The buyer information storage unit 24 is a storage unit for storing buyer information registered in the EC site. As shown in FIG. 4, for each buyer ID, the buyer's name, address, postal code, regional bit string, prefecture, and credit card information are stored.

  The sell order information storage unit 25 is a storage unit for storing a sell order issued by each supplier. As shown in FIG. 5, for each sell order ID (sell order log number), order date / time, update date / time, supplier ID, product ID, selling price (excluding shipping), initial number, remaining number, shipping date filter, buyer area Each information of a filter, a transaction establishment flag, and a postage definition is stored.

  The purchase order information storage unit 26 is a storage unit for storing a purchase order issued by each buyer. As shown in FIG. 6A, for each buy order ID (buy order log number), the order date / time, update date / time, buyer ID, buy price, initial number, remaining number, supplier exclusion filter, shipping date filter, supplier region filter, transaction Each information of the establishment flag, shipping destination area filter, shipping address, shipping name, and parallel bid flag is stored. Here, even if the number is two or more, a buy order (each row in FIG. 6A) accepted in one process is defined as one buy order. That is, the buy order ID is assigned one-to-one for each buy order.

  Further, the purchase order information storage unit 26 stores the purchase order detail information shown in FIG. 6B. The purchase order details include an order date, an update date, a product ID, an initial purchase price, and a purchase price (including shipping). In the purchase order details, it is possible to store a plurality of product IDs corresponding to one purchase order ID. In the example of FIG. 6, merchandise ID = 1 and 2 are stored corresponding to purchase order ID = 3. With such a data structure, in the parallel bid function described later, when the transaction establishment flag of one purchase order ID is a transaction establishment, a plurality of products related to a plurality of product IDs corresponding to the one purchase order ID are stored. The transaction ends for all.

  The trade information storage unit 27 stores information on a transaction establishment log shown in FIG. The transaction establishment log includes information on establishment date / time, purchase order ID, sell order ID, product ID, buyer ID, supplier ID, establishment price, number of establishments, cancellation flag, shipment flag, shipment date / time, and slip number. The temporary storage unit 28 is a storage area for temporarily storing information necessary for processing.

<Supplier registration process>
The supplier registration process will be described with reference to FIGS. When a supplier who wishes to register in this system accesses the website of this system from the supplier terminal 2 and presses a link leading to supplier registration processing, the supplier registration screen in FIG. 8 is displayed. In other words, the supplier registration screen data is transmitted from the program storage unit 21 of the server 10 to the supplier terminal 2. On this screen, the supplier sequentially inputs supplier information (name, postal code, address under the prefecture, telephone number) and presses the registration button. Then, the supplier information is transmitted to the server 10 via the Internet 1, and using this as a trigger, the supplier registration process of FIG. 9 is started.

  In the supplier registration process, the CPU 11 receives supplier information via the communication IF 14 (S110), and stores the received supplier information in the supplier information storage unit 23 of the HDD 20 (S120). At this time, a specific supplier ID is assigned to the supplier, and the supplier information is stored in association with the supplier ID. In this embodiment, A, B, C,. . . Of course, other symbols such as numbers may be used.

  Next, the CPU 11 determines a region from the prefecture of the supplier among the stored supplier information, and stores it in the supplier information storage unit 23 (S130). In this embodiment, a region is represented by a region bit string (FIG. 3A) in which nine 0s or 1s are arranged. As will be described in detail later with reference to FIG. 20, the regional bit strings are arranged from the left to Okinawa, Kyushu, Shikoku, China, Kinki, Chubu, Kanto, Tohoku, and Hokkaido. For example, the regional bit string of the Kanto supplier is 000000100. The regional bit string of the supplier in Kyushu is 010000000. Note that the region may be determined from the zip code of the supplier. In the present embodiment, the supplier registration process is automatically performed based on the input at the supplier terminal 2, but the supplier information may be manually input because the supplier's document review may be required.

<Buyer registration process>
The buyer registration process will be described with reference to FIGS. When a buyer who wishes to register in this system accesses the website of this system from the buyer terminal 3 and presses a link leading to the buyer registration process, the buyer registration screen of FIG. 10 is displayed. On this screen, the buyer sequentially inputs buyer information (name, postal code, address under prefecture, telephone number, credit card information) and presses the registration button. Then, the buyer information is transmitted to the server 10 via the Internet 1, and using this as a trigger, the buyer registration process of FIG. 11 is started.

  In the buyer registration process, the CPU 11 receives buyer information via the communication IF 14 (S210), and stores the received buyer information in the buyer information storage unit 24 of the HDD 20 (S220). At this time, a specific buyer ID is assigned to the buyer, and the buyer information is stored in association with the buyer ID. In the present embodiment, a, b, c,. . . Of course, other symbols such as numbers may be used.

  Next, the CPU 11 determines a region from the buyer's prefecture in the stored buyer information and stores it in the buyer information storage unit 24 (S230). Similar to the supplier area, the buyer area is represented by an area bit string in which nine 0s or 1s are arranged.

<Sell order processing>
The sell order process will be described with reference to FIGS. 12, 13A, and 13B. A supplier who is registered in the system and desires to sell a product proceeds from a registered supplier page (not shown) of the system to a product selection page (not shown). The product selection page has a hierarchical structure, for example, electrical appliances → refrigerator → I company (manufacturer), and products can be selected from the list. Here, assuming that the refrigerator (model number AA-A-W) of company i is selected, the product registration screen of FIG. 12 is displayed. On this screen, when the selling order information such as the registered number and selling price (excluding shipping fee) is input and the confirmation button is pressed, the information is transmitted to the server 10 via the Internet 1 and triggered by this as shown in FIG. 13A. And the sell order process of FIG. 13B is started.

  Here, the selling order information shown in FIG. 12 will be described. The registered number (initial number) is the number of the product that the supplier desires to sell, and can be input in units of one. The selling price (excluding shipping fee) is the selling price of the product desired by the supplier, and can be input in units of the unit price of the product (see FIG. 2; 100 yen for product ID = 1). Here, enter the price minus the shipping cost. As the shipping date, an option that the supplier can ship is selected from “within 24 hours”, “within 48 hours”, “within 72 hours”, “4-7 days”, and “7 days or more”. The buyer area is information for limiting the area of the buyer (shipping destination). For example, in FIG. 12, since the check is removed from Okinawa and Hokkaido, it is set not to sell to buyers (shipping destinations) in these regions. In this way, as a reason to be able to limit the buyer's area, the selling price here is a price without shipping fee, so even if you ship to a remote area, basically there is a disadvantage for the supplier Although it should not exist, it is possible to set it so that it can be excluded from the sales target depending on the shipping destination area such as when the shipping fee is irregular such as a remote island. The shipping cost definition is selected from small, medium and large. As shown in the supplier shipping cost setting of FIG. 3B, the shipping cost is set according to whether small, medium, or large is selected and according to the region. Note that different sizes may be defined for the same product depending on the supplier.

  In the sell order process, the CPU 11 receives sell order information via the communication IF 14 (S305), and updates the sell order log (FIG. 5) in the sell order information storage unit 25 based on the received sell order information (S310). ). In S315, the CPU 11 refers to the purchase order log (FIG. 6A) and the purchase order details (FIG. 6B) stored in the purchase order information storage unit 26, and initializes a variable i indicating the purchase order ID (i = 1).

  In S320, the CPU 11 determines the shipping cost from the received shipping cost definition (FIG. 5), the supplier shipping cost setting (FIG. 3B), and the i-th purchase order shipping destination (FIG. 6A). In S325, the CPU 11 subtracts the shipping cost determined in S320 from the purchase price (including shipping cost) of the i-th purchase order to obtain a price without shipping cost. In S330, the CPU 11 determines whether or not the postage-free price obtained in S325 is equal to or higher than the selling price of the received selling order. If the price without shipping is equal to or higher than the selling price (S330: Yes), the process proceeds to S335, and the i-th purchase order is stored in the temporary storage unit 28 together with the price without shipping. Here, buy orders whose transaction establishment flag (FIG. 6A) is not 0 are excluded. If the shipping price is less than the selling price (S330: No), S335 is skipped and the process proceeds to S340. In S340, 1 is added to the variable i (i = i + 1).

  In S342, the CPU 11 determines whether or not there is a next buy order in the buy order log (FIG. 6A). If there is a next buy order (S342: Yes), the CPU 11 returns to S320 and repeats the process. If there is no next buy order (S342: No), the process proceeds to S345. In S345, the CPU 11 determines whether or not one or more buy orders stored in the temporary storage unit 28 exist. If there is no buy order stored in the temporary storage unit 28 (S345: No), the process is terminated. When one or more buy orders stored in the temporary storage unit 28 exist (S345: Yes), the process proceeds to S348, and the buy orders stored in the temporary storage unit 28 are sorted in descending order of the price without shipping charges, and At the same price, they are sorted in order of update date. In the example illustrated in FIG. 13C, the purchase orders illustrated in FIGS. 6A and 6B are rearranged in the descending order of the price excluding the postage for the product with the product ID = 1 and the update date and time at the same price. In this example, the shipping cost is calculated from the supplier shipping cost setting (FIG. 3B) on the assumption that the supplier ID = A and the shipping cost definition = large size. That is, in S348, the purchase orders are rearranged in this order and stored in the temporary storage unit 28.

  In S <b> 350, the CPU 11 performs a filter determination process for the purchase order with the highest rank among the purchase orders stored and rearranged in the temporary storage unit 28. Although details will be described later, in the filter determination process, a value of determination result = 1 is stored in the temporary storage unit 28 when the filter condition is satisfied, and determination result = 0 is stored when the filter condition is not satisfied. In S355, the CPU 11 refers to the temporary storage unit 28, and if the determination result = 1, that is, if the filter condition is met (S355: Yes), the CPU 11 proceeds to S360 and executes the transaction establishment process. On the other hand, if the determination result = 0, that is, if the filter condition does not match (S355: No), the process proceeds to S380.

  In S370, the CPU 11 determines whether the transaction establishment flag of the supplier has become 1. Here, the supplier's transaction establishment flag is 1 when the remaining number of the product is 0, that is, when all the registered products are sold. On the other hand, when the number of remaining products is 1 or more, the transaction establishment flag remains 0. When the transaction establishment flag becomes 1 (S370: Yes), the sell order process is terminated. When the transaction establishment flag remains 0 (S370: No), the process proceeds to S390.

  If the highest purchase order does not match the filter condition in S355, the CPU 11 deletes the purchase order from the temporary storage unit 28 in S380. In step S <b> 390, the CPU 11 refers to the temporary storage unit 28 and determines whether there is a next order purchase order. Here, the next-order buy order is a buy order that has become the highest as a result of the processing of S380. If there is a next order buy order (S390: Yes), the process returns to S350, and it is determined whether or not the buy order matches the filter condition. If there is no next order buy order (S390: No), the sell order process is terminated.

  The sell order process described above is a process when the supplier registers a new sell order, but the supplier can also update an existing sell order. The supplier can confirm the contents of his / her sell order in the logged-in state, and in this case, a screen similar to the product registration screen of FIG. 12 is displayed. The supplier can change the contents of the sales order (the registered number, selling price (excluding shipping cost), shipping date, buyer area, shipping cost definition in FIG. 12) on this screen. The most frequently thought is to change the selling price (excluding shipping charges). When the contents of the sell order are changed and the update button (corresponding to the registration button in FIG. 12) is pressed, the sell order process in FIGS. 13A and 13B is started. When an existing sell order is updated, the date / time becomes a new update date / time, so the update date / time may be later than other sell orders and the order of transactions may be later (S448 in FIG. 15B). ).

<Buy order processing>
The purchase order process will be described with reference to FIGS. 14, 15A, and 15B. A buyer who is registered in the system and desires to purchase a product proceeds from a registered buyer page (not shown) of the system to a product selection page (not shown). The product selection page is as described above. Here, assuming that the buyer selects the refrigerator (model number AA-A-W) of Lee Co., a product purchase reservation screen (screen for registering a purchase order) in FIG. 14 is displayed. On this screen, if you enter buy order information such as the number of units purchased, price (buy price), etc. and press the “Confirm (no parallel bid)” button, the information is sent to the server 10 via the Internet 1 and this As a trigger, the buy order process shown in FIGS. 15A and 15B is started.

  Here, the purchase order information shown in FIG. 14 will be described. The number of purchases (initial number) is the number of the products that the buyer wants to purchase, and can be entered in units of one. The purchase price (including postage) is the purchase price of the product desired by the buyer and can be entered in units of the unit price of the product (see FIG. 2; 100 yen for product ID = 1). Here, enter the price including shipping. For the desired delivery date, the buyer selects an option desired by the buyer from “within 24 hours”, “within 48 hours”, “within 72 hours”, “4-7 days”, and “unspecified”. The supplier area is information for limiting the area of the supplier (shipping source). For example, in FIG. 14, since all the regions are checked, the setting can be purchased from suppliers in all regions. The reason why the region of the supplier (shipping source) can be restricted in this way is that it takes a relatively long time to deliver from a long distance even if the shipping date is specified, so purchase from a remote region supplier as viewed from the buyer. This is because it can be set not to be performed. The excluded supplier is, for example, information (black list method) for excluding suppliers that did not respond well in past transactions. In the example of FIG. 14, the suppliers with supplier IDs = 1 and 3 are excluded.

  In the buy order process, the CPU 11 receives the buy order information via the communication IF 14 (S400), and executes a parallel bid process described later (S405). Next, based on the received purchase order information, the purchase order log (FIG. 6A) and the purchase order details (FIG. 6B) in the purchase order information storage unit 26 are updated (S410). In S415, the CPU 11 refers to the sell order log (FIG. 5) stored in the sell order information storage unit 25 and initializes a variable i indicating the sell order ID (i = 1).

  In S420, the CPU 11 determines the shipping cost from the shipping cost definition of the i-th selling order (FIG. 5), the supplier shipping cost setting (FIG. 3B), and the received purchase order shipping destination (FIG. 6A). In S425, the CPU 11 adds the shipping cost determined in S420 to the selling price (excluding shipping cost) of the i-th selling order to obtain the price including shipping cost. In S430, the CPU 11 determines whether or not the postage including price calculated in S425 is equal to or less than the purchase price of the received purchase order. When the postage price is equal to or less than the purchase price (S430: Yes), the process proceeds to S435, and the i-th selling order is stored in the temporary storage unit 28 together with the postage price. Here, sell orders whose transaction establishment flag (FIG. 5) is not 0 are excluded. If the price including shipping costs exceeds the purchase price (S430: No), the process skips S435 and proceeds to S440. In S440, 1 is added to the variable i (i = i + 1).

  In S442, the CPU 11 determines whether or not there is a next sell order in the sell order log (FIG. 5). If there is a next sell order (S442: Yes), the CPU 11 returns to S420 and repeats the process. If there is no next selling order (S442: No), the process proceeds to S445. In S445, the CPU 11 determines whether one or more selling orders stored in the temporary storage unit 28 exist. If there is no sell order stored in the temporary storage unit 28 (S445: No), the process is terminated. When one or more sell orders stored in the temporary storage unit 28 exist (S445: Yes), the process proceeds to S448, and the sell orders stored in the temporary storage unit 28 are sorted in ascending order of the price including shipping cost, and At the same price, they are sorted in order of update date.

  In S450, the CPU 11 performs a filter determination process on the selling order with the highest rank among the selling orders stored in the temporary storage unit 28 and rearranged. As described above, in the filter determination process, a value of determination result = 1 is stored in the temporary storage unit 28 when the filter condition is satisfied, and determination result = 0 is stored when the filter condition is not satisfied. In S455, the CPU 11 refers to the temporary storage unit 28, and when the determination result = 1, that is, when the filter condition matches (S455: Yes), the CPU 11 proceeds to S460 and executes the transaction establishment process. On the other hand, if the determination result = 0, that is, if the filter condition does not match (S455: No), the process proceeds to S480.

  In S470, the CPU 11 determines whether or not the transaction establishment flag of the buyer has become 1 or 3. Here, the buyer's transaction establishment flag is set to 1 in the transaction establishment process (S460) when the remaining number of the product becomes 0, that is, when all the products desired to be purchased are purchased. Further, when the purchase is withdrawn (cancelled) after the settlement processing, the value is 2. If the purchase is withdrawn due to a credit card payment error, the value is 3. When it is determined that the expiration date has expired in the expired purchase order determination process (FIG. 22), the value is 4. In other cases, that is, when the effective remaining number of the product is 1 or more, the transaction establishment flag remains 0. When the transaction establishment flag becomes 1 or 3 (S470: Yes), the buy order process is terminated. In other cases (S470: No), the process proceeds to S490.

  If the highest selling order does not match the filter condition in S455, the CPU 11 deletes the selling order from the temporary storage unit 28 in S480. In step S <b> 490, the CPU 11 refers to the temporary storage unit 28 and determines whether there is a next-order selling order. Here, the next selling order is the selling order that is the highest as a result of the processing of S480. If there is a next-order selling order (S490: Yes), the process returns to S450, and it is determined whether or not the selling order matches the filter condition. If there is no next order selling order (S490: No), the buy order processing is terminated.

  The above-described buy order process is a process when the buyer registers a new buy order, but the buyer can also update an existing buy order. The buyer can confirm the content of his / her purchase order in the logged-in state, and in this case, a screen similar to the product purchase reservation screen of FIG. 14 is displayed. The buyer can change the contents of the purchase order (the number of purchases, the purchase price (including the shipping cost), the desired delivery date, the supplier area, the excluded supplier in FIG. 14) on this screen. It is considered to change the purchase price (including the shipping fee) to be considered the most frequent. When the content of the purchase order is changed and the update button (corresponding to the confirmation button in FIG. 14) is pressed, the purchase order processing in FIGS. 15A and 15B is started. Note that when an existing buy order is updated, the date / time becomes a new update date / time, so the update date / time may be later than other buy orders and the order of transactions may be later (S348 in FIG. 13B). ).

<Parallel bid processing>
The parallel bid process will be described with reference to FIGS. 16 and 17. Parallel bid is a function that allows buyers to register as an alternative purchase product when they have already registered a purchase order for one of the products and there is a product that can be purchased as an alternative to the corresponding product. . At this time, the purchase price can be specified for each product, but the shipping destination and filter contents are the same as the conditions of the original purchase order. This is due to the data structure of the buy order log (FIG. 6A) and the buy order details (FIG. 6B).

  The parallel bid process is executed after S400 of the above-described buy order process. In S <b> 412, the CPU 11 refers to the buyer ID of each log in the purchase order log (FIG. 6A) in the purchase order information storage unit 26 and checks whether or not the buyer has already registered a purchase order for another product. . The check here may be limited to products in the same category (for example, camera). This is because if buyers make a reservation to purchase multiple types of products in the same category, it is likely that they want to purchase one of them.

  If it is determined in S412 that no purchase order has been registered for another product (S412: No), the parallel bid process is terminated and the process returns to the purchase order process. If a purchase order is registered for another product (S412: Yes), the buyer's purchase order is extracted from the purchase order log in the purchase order information storage unit 26 and displayed on the screen of the buyer's terminal 3 as shown in FIG. Such a parallel bid selection screen is displayed (S414). If a plurality of buy orders have already been registered, a list is displayed as shown in FIG.

  In FIG. 17, when the buyer presses the “parallel bid” or “no parallel bid” button of any product, the CPU 11 receives this information via the Internet 1 and the communication IF 14. When the “no parallel bid” button is pressed (S416: No), the parallel bid process is terminated and the process returns to the buy order process. When the “Parallel bid” button of any product is pressed (S416: Yes), in S418, the CPU 11 adds the product to be bid in parallel to the purchase order details (FIG. 6B) of the selected product. . Further, the parallel bid flag of the corresponding buy order in the buy order log (FIG. 6A) is set to 1 (S418).

  At this time, the purchase order details of the selected product and the purchase order details of the product to be bid in parallel have the same purchase order ID. In the example of FIG. 6B, for the two rows where the purchase order ID = 3, the product with the product ID = 1 is registered first, and then the product with the product ID = 2 is registered as a parallel bid product.

  When the parallel bid process ends, the process returns to the buy order process (FIGS. 15A and 15B). Here, S410 is a process of updating the purchase order log and the purchase order details, but since the update has already been completed through the process of S418, nothing is done in S420. Thereafter, the processing from S430 onward is executed for the product bid in parallel this time. Here, for a buy order registered as a parallel bid, no matter which product is traded, if the total number of trades reaches the initial required number, the trade establishment flag in the buy order log (FIG. 6A) becomes 1. (S470: Yes), the buy order processing is completed.

<Filter judgment processing>
The filter determination process will be described with reference to FIG. 18, FIG. 19, and FIG. The filter determination process is a process for determining whether a supplier and a buyer who are processing targets match each other's filter conditions. In this embodiment, a supplier exclusion filter, a shipping date filter, a supplier region filter, and a buyer region filter are set as filter conditions.

  First, in S510, the CPU 11 determines a supplier exclusion filter, that is, determines whether or not the supplier is excluded from the buyer. Specifically, the CPU 11 refers to the supplier exclusion filter in the purchase order information storage unit 26 and determines whether or not the ID of the supplier to be processed exists. If the supplier ID exists (S510: Yes), the CPU 11 temporarily stores determination result = 0 (does not match the filter condition) in the temporary storage unit 28 (S560), and ends the process. . On the other hand, when the ID of the supplier does not exist (S510: No), the process proceeds to S520.

  In S520, the CPU 11 determines the shipping date filter, that is, determines whether the supplier's shipping date satisfies the shipping date desired by the buyer. Specifically, the CPU 11 compares the shipping date filter of the selling order information storage unit 25 (FIG. 5) with the shipping date filter of the purchase order information storage unit 26 (FIG. 6A). Here, as shown in FIG. 19, the shipping date filter is formed of a 5-bit bit string. In the example of FIG. 19, the buyer wishes to ship within 48 hours, the supplier 1 can ship within 48 hours, and the supplier 2 can ship within 72 hours. That is, supplier 1 meets the buyer's condition, but supplier 2 does not meet the buyer's condition. Therefore, the CPU 11 corresponds to the 1st to 5th bits of the shipping date filter of the sales order information storage unit 25 (supplier side) and the 1st to 5th bits of the shipping date filter of the purchase order information storage unit 26 (buyer side). If there is a bit that is both “1” (that is, if there is a bit that is “1” when the logical AND of each bit is taken), It is judged that it matches. If the condition is met (S520: Yes), the process proceeds to S530. If the condition is not met (S520: No), the CPU 11 temporarily stores determination result = 0 (does not match the filter condition) in the temporary storage unit 28 (S560), and ends the process.

  In S530, the CPU 11 determines the supplier region filter, that is, determines whether or not the supplier region satisfies the buyer's request. Specifically, the CPU 11 compares the region bit string of the supplier information (FIG. 3A) stored in the supplier information storage unit 23 with the supplier region filter (FIG. 6A) of the purchase order information storage unit 26. Here, as shown in FIG. 20, the supplier region filter is composed of a 9-bit bit string. In the example of FIG. 20, the buyer desires a supplier in the Kinki / Chubu / Kanto region, the supplier 1 is located in the Kanto region, and the supplier 2 is located in the Kyushu region. That is, supplier 1 meets the buyer's condition, but supplier 2 does not meet the buyer's condition. Accordingly, the CPU 11 stores the first to ninth bits of the region bit string of the supplier information (FIG. 3A) stored in the supplier information storage unit 23 and the first to first bits of the supplier region filter (FIG. 6A) of the purchase order information storage unit 26. When the corresponding bits of 9 bits are compared, and there are bits that are both “1” (that is, when there is a bit that is “1” when the logical AND of each bit is taken) Judge that it meets the requirements of the supplier area. If the condition is met (S530: Yes), the process proceeds to S540. If the condition is not met (S530: No), the CPU 11 temporarily stores determination result = 0 (does not match the filter condition) in the temporary storage unit 28 (S560), and ends the process.

  In S540, the CPU 11 determines the buyer area filter, that is, determines whether the buyer area satisfies the supplier's request. Specifically, the CPU 11 compares the region bit string of the buyer information (FIG. 4) stored in the buyer information storage unit 24 with the buyer region filter (FIG. 5) of the selling order information storage unit 25. Similar to the supplier region filter described above, the buyer region filter is composed of a 9-bit bit string. The CPU 11 stores the first to ninth bits of the region bit string of the buyer information (FIG. 4) stored in the buyer information storage unit 24 and the first to ninth bits of the buyer region filter (FIG. 5) of the sell order information storage unit 25. If there is a bit that is both “1” (that is, if there is a bit that is “1” when the logical AND of each bit is taken), Judged to meet local conditions. If the condition is met (S540: Yes), the CPU 11 temporarily stores determination result = 1 (matches the filter condition) in the temporary storage unit 28 (S550), and ends the process. On the other hand, if the condition is not met (S540: No), the CPU 11 temporarily stores determination result = 0 (does not match the filter condition) in the temporary storage unit 28 (S560), and ends the process. As a result of the above processing, the determination result = 1 (S550) is obtained only when all the filter conditions are met for the sell order and the buy order to be compared, and any one of them does not meet the filter conditions The determination result = 0 (S560).

<Transaction processing>
The transaction establishment process will be described with reference to FIG. First, in S610, card payment processing is performed. Here, for sell orders and buy orders where the transaction was successful, if the buy price (including postage) of the buy order is higher than the selling price (excluding postage) of the sell order plus the postage, The purchase price (including shipping) is used as the transaction closing price. The card payment process is a commonly performed process. The CPU 11 transmits the buyer's credit card information (FIG. 4) stored in the buyer information storage unit 24 to the partner card payment processing apparatus via the communication IF 14 and the Internet 1. Authentication and payment processing is performed in the card payment processing apparatus, and an OK or error result is transmitted.

  When an error occurs in the card settlement (S620: Yes), the CPU 11 sets the transaction establishment flag in the purchase order information storage unit 26 (S680), and ends the process. If no error has occurred (S620: No), the process proceeds to S630.

  In S630, the CPU 11 adds information to the transaction establishment log (FIG. 7) of the buying and selling information storage unit 27 regarding the sell order and the purchase order for which the transaction has been established. Specifically, each information of establishment date / time, buy order ID, sell order ID, product ID, buyer ID, supplier ID, establishment price, and establishment number is stored in the transaction establishment log of the buying and selling information storage unit 27. In S640, the CPU 11 determines the number of successful transactions from each of the remaining number in the sell order log (FIG. 5) in the sell order information storage unit 25 and the remaining number in the buy order log (FIG. 6A) in the buy order information storage unit 26. Is subtracted to update the value.

  In S650, when the remaining number of sales order logs becomes 0 (S650: Yes), the transaction establishment flag of the sales order log is set to 1 (S655), and the process proceeds to S660. When the remaining number of sales order logs is 1 or more (S650: No), S655 is skipped. In S660, when the remaining number of purchase order logs becomes 0 (S660: Yes), the transaction establishment flag of the purchase order log is set to 1 (S665), and the process proceeds to S670. If the remaining number of purchase order logs is 1 or more (S660: No), S665 is skipped.

  In S670, the supplier, the buyer, and the system operator are notified that the transaction has been established. Specifically, the CPU 11 refers to the product ID, the established price, and the number of established units in the transaction establishment log (FIG. 7) of the sale / sale information storage unit 27, and “price △△△ for product XX (product ID)”. An email to the effect that “a transaction of □□□ units (confirmed number of units) has been completed with a yen (established price)” is automatically sent to the email addresses of the supplier, the buyer and the system operator. This completes the transaction establishment process.

<Expired purchase order determination process>
Next, the expired purchase order determination process will be described with reference to FIG. The expired purchase order determination process is a batch process executed at regular time intervals (for example, every minute).

  First, in S710, the CPU 11 initializes a variable i indicating a buy order ID (i = 1). In S720, the CPU 11 refers to the clock unit 16 and stores the current time in the RAM 12. In S730, the CPU 11 refers to the update time of the purchase order log stored in the purchase order information storage unit 26 and stores it in the RAM 12. Note that the temporary storage unit 28 of the HDD 20 may be used instead of the RAM 12.

  In S740, the CPU 11 obtains a difference (elapsed time) between the current time stored in S720 and the update time stored in S730, and determines whether or not the elapsed time exceeds a predetermined time (for example, 96 hours). When the elapsed time exceeds the predetermined time (S740: Yes), the value 4 is substituted into the transaction establishment flag of the buy order log (S750). This indicates that the purchase order log has expired. If the elapsed time is equal to or shorter than the predetermined time (S740: No), S750 is skipped.

  In S760, the CPU 11 adds 1 to the variable i indicating the purchase order ID, and proceeds to the next purchase order log. In S770, it is determined whether or not there is a next buy order log. If there is a next buy order log (S770: Yes), the process returns to S720 and the same processing is repeated. When there is no next purchase order log (S770: No), the expired purchase order determination process is terminated. As described above, an expiration date is set for a purchase order, and if the buyer does not extend the expiration date (that is, updates an existing purchase order), the purchase order automatically disappears. Such processing can prevent old purchase orders from remaining valid for a long time.

<Shipping process>
Next, the shipping process will be described with reference to FIG. In this system, the supplier is to send a shipment completion notification to the server 10 after shipping the product for which the transaction has been completed. When the server 10 receives the shipment completion notification, the shipping process is started using this notification as a trigger.

  First, in step S <b> 810, the CPU 11 receives shipment completion information (the number of shipments, shipment date / time, and slip number) transmitted from the terminal 2 of the supplier, and temporarily stores them in the temporary storage unit 28. In S820, the CPU 11 determines whether or not the received shipment quantity matches the establishment number in the transaction establishment log (FIG. 7).

  If the received number of shipments matches the number of completed transactions in the transaction completion log (S820: Yes), the shipping date and time and the slip number are stored in the transaction completion log (FIG. 7) in S830. Further, the shipment flag is set to “1”. Note that if a product for which a transaction has been completed is canceled due to the circumstances of the supplier or the buyer before shipment, the cancellation flag in the transaction establishment log (FIG. 7) is set to “1”. If the product has already been shipped (that is, if the shipping flag is “1”), it cannot be canceled. Next, in S840, the fact that the shipment has been completed is sent by e-mail to the buyer's and operator's e-mail addresses. On the other hand, if the received number of shipments does not match the number of completed transactions (S820: No), a message to that effect is sent to the supplier (S850) and confirmation is requested from the supplier. This completes the shipping process.

<Supplier quotation table generation processing>
Next, the supplier sales quotation table generation processing will be described with reference to FIGS. 24A, 24B, and 25. FIG. The supplier sales quotation table is a table having a format as shown in FIG. 25, for example, and the price arranged in the vertical direction at the unit price interval, the desired number of sales (number of sales) and the desired number of purchases ( (Buy) is displayed. Note that the price displayed on the supplier trading table is a price without shipping. In the example of FIG. 25, for the price of 99600 yen, there are five selling numbers for the entire supplier. In addition, for the price of 99500 yen, there are 11 buys for the entire buyer (excluding buyers excluded by the filter condition). The “number of self-orders”, “order”, and “amount of reduction for immediate sales” will be described later. When a supplier wants to sell their products, the supplier's buy / sell table allows you to know the current selling price of other suppliers and the buyer's preferred purchase price. You can check the price, number of units, and sales conditions (ranking, etc.). In the supplier trading quotation table generation process, unlike the buyer trading quotation table generation process described later, the supplier cannot view this screen without logging in.

  This process is triggered by a purchase quotation table display request from a logged-in supplier. Specifically, when the supplier logs in to the present system and tries to open a predetermined page in order to view the trading price table, a trading price table display request is transmitted from the terminal 2 of the supplier to the server 10.

  When a trade quotation table display request is received, first, in S910, the CPU 11 obtains information on the merchandise master (FIG. 2) stored in the merchandise information storage unit 22 for the merchandise for which the supplier intends to browse the trade quotation table. refer. In step S912, the CPU 11 refers to the filter condition set on the screen. Here, the supplier can set the filter conditions (shipment date and buyer area) described in the filter determination process on the screen, and display only the purchase orders that meet his / her conditions on the sales quotation table. It is possible to make it.

  In S914, the CPU 11 determines whether there is a selling order for the supplier. When there is a selling order (S914: Yes), the selling order of the supplier is referred to (S916), and the process proceeds to S920. If there is no sell order (S914: No), the address of the supplier is referred to (S918), and the process proceeds to S920. In S920, the sales order log other than the supplier is referred to.

  In S922, the variable i is initialized (i = 1). In S930, the CPU 11 refers to the transaction establishment flag of the i-th sell order in the sell order log (FIG. 5) stored in the sell order information storage unit 25, and determines whether this is 0 or not. When the transaction establishment flag is 0 (S930: Yes), since the sell order is one or more remaining units, in S932, the remaining units are added to the number of sales corresponding to the selling price of the sell order, and the trading quotation table (S932). Thereafter, 1 is added to the variable i (S934). On the other hand, when the transaction establishment flag is other than 0, for example, when the transaction establishment flag is 1 (S930: No), the selling order is the remaining number of units, and all the transactions have been completed. The process proceeds to S934 without counting and 1 is added to the variable i.

  In S936, the CPU 11 determines whether or not the sell order is the final log of the sell order log (FIG. 5). If it is not the final log (S936: No), the process returns to S930 and the processes of S930 to S934 are repeated. If it is the final log (S936: Yes), the process proceeds to S940.

  In S940, the CPU 11 refers to the purchase order log (FIG. 6A) stored in the purchase order information storage unit 26. In S942, the variable i is initialized (i = 1). In S950, the CPU 11 determines whether or not the transaction establishment flag of the i-th purchase order is 0. When the transaction establishment flag is 0 (S950: Yes), it progresses to S955 and performs a filter determination process. When the transaction establishment flag is other than 0 (S950: No), the process proceeds to S975 and 1 is added to the variable i.

  The filter determination process executed in S955 has been described above with reference to FIG. However, in the filter determination process performed in this process (supplier trading quotation table generation process), unlike the filter determination process performed in the sell order process and the buy order process, the supplier has not yet registered a sell order ( That is, there may be no specific selling order). In that case, the filter condition referred to in S912 is used. Here, when the supplier does not set the shipping date and the buyer area on the screen, the processing is performed by determining Yes in each of the filter determination processes S520 and S540. Therefore, if the supplier sets the filter condition on the screen, the purchase order can be displayed under the condition narrowed down according to his / her condition. Since it is assumed that the supplier is logged in, the determinations in S510 (excluded supplier) and S530 (supplier region) are performed based on the supplier exclusion filter, supplier region filter, and supplier information in the purchase order log (FIG. 6A). This can be done from each piece of information in the regional bit string of FIG. 3A.

  In S960, based on the result of the filter determination process, the CPU 11 determines whether or not the i-th purchase order matches the filter condition. If the filter condition is met (S960: Yes), the process proceeds to S965. If the filter condition is not met (S960: No), the process proceeds to S975 and 1 is added to the variable i.

  In S <b> 965, the CPU 11 refers to the area of the i-th buy order, the location of the supplier, and the postage definition of the sell order of the supplier, and calculates the postage of the buy order. For the area of the i-th purchase order, the destination area of the purchase order log (FIG. 6A) is referred to. For the location of the supplier, the regional bit string of the supplier information (FIG. 3A) is referred to. For the shipping definition of the supplier's selling order, refer to the shipping definition in the selling order log (FIG. 5). If the supplier has not yet registered a sell order, the supplier is requested to set a shipping cost definition on the screen, and the shipping cost definition is used.

  In S970, the CPU 11 subtracts the postage calculated in S965 from the buy price of the i-th purchase order, adds it to the number of purchases of that price (price excluding postage), and displays it on the sales quotation table (FIG. 25). Thereafter, 1 is added to the variable i (S975), and it is determined in S980 whether or not processing has been performed up to the final log in the purchase order log (FIG. 6A). If there is a buy order that has not yet been processed (S980: No), the process returns to S950 and is repeated. When the process is completed up to the final log (S980: Yes), the process proceeds to S985.

  In S <b> 985, the CPU 11 refers to the sell order log (FIG. 5) stored in the sell order information storage unit 25 and determines whether there is a sell order of the supplier for the product. If there is no selling order for the supplier (S985: No), the processing of S990 to S994 is skipped and the processing is terminated. If there is a selling order for the supplier (S985: Yes), the process proceeds to S990.

  In S990, the current remaining number of sell orders of the supplier (remaining number of sell order logs in FIG. 5) is displayed in the self-order number column of the corresponding price in the sales quotation table. For example, in the example of FIG. 25, in the row of price 99600 yen, one of the five sold suppliers including the other is the own sold number, and this is displayed in the “Self Ordered” column. ing.

  Next, in S992, the CPU 11 refers to the selling order log (FIG. 5) and determines the order of the selling order of the supplier among selling orders having the same selling price as the selling order of the supplier. Displayed on the buying and selling price table. More specifically, the CPU 11 extracts a selling order having the same selling price as the selling order of the supplier and having a transaction establishment flag of 0 in the selling order log (FIG. 5), and updates them. Sort in ascending order of time. Then, the order number of the supplier's selling order is determined and displayed in the “rank” column of the sales quotation table. In the example of FIG. 25, the selling order of this supplier is ranked third among selling orders with a selling price of 99600 yen.

  Next, in S994, the CPU 11 obtains the price reduction amount necessary for immediate sales (that is, how much the sale price can be immediately sold) and displays it on the sales quotation table. For example, in the example of FIG. 25, since there is no sell order and there is a buy order at the price of 99500 yen (the number of purchases is 11), the supplier sells immediately by reducing the price from 99600 yen to 99500 yen. Can do. Specifically, the CPU 11 refers to the purchase order log (FIG. 6A) and the purchase order details (FIG. 6B) to search for the highest purchase price among the purchase order logs whose transaction establishment flag is 0, and to determine the postage from this purchase price. The difference between the price minus the selling price and the selling price of the supplier's selling order is obtained. In the example of FIG. 25, 99600−99500 = 100 yen, and this value of 100 yen is displayed in the “Price reduction for immediate sale” column of the sales quotation table. The process ends here.

<Buyer buying and selling price table generation processing>
Next, the buy / buy price table generation processing will be described with reference to FIG. The buy / buy price table can be viewed by a buyer or a general viewer. In the buyer buy / sell table generation process, the buyer can view this screen without logging in. If logged in as a buyer, the data narrowed down based on the buyer registration information can be displayed. If the registered buyer is not logged in, the processing is the same as that for the general viewer.

  This process is triggered by a buy / sell price table display request from a buyer or a general viewer (hereinafter simply referred to as “buyer”). Specifically, when a buyer tries to open a predetermined page in order to view the trading quotation table, a trading quotation table display request is transmitted from the buyer's terminal 3 to the server 10.

  When the trade price table display request is received, in S1000, the CPU 11 determines whether or not the buyer is logged in based on information transmitted from the buyer's terminal 3 together with the trade price table display request. When the buyer is logged in (S1000: Yes), the sales quotation table generation process (at the time of login for the buyer) is called in S1100. If the buyer is not logged in (S1000: No), the trading price table generation process (when the buyer is not logged in) is called in S1200.

<Buy and sell price table generation process (at login for buyers)>
Next, the sales quotation table generation process (at the time of login for the buyer) will be described with reference to FIGS. First, in S1110, the CPU 11 refers to the information of the product master (FIG. 2) stored in the product information storage unit 22 for the product that the buyer intends to browse the sales quotation table. In step S1112, the CPU 11 refers to the filter condition set on the screen. Here, the buyer can set on the screen the filter conditions (delivery date, supplier region, excluded supplier) described in the above filter determination process, thereby narrowing down to only sell orders that meet his conditions. Can be displayed on a table.

  In S1114, the CPU 11 determines whether or not there is a purchase order for the buyer. When there is a buy order (S1114: Yes), the buyer's purchase order shipping destination is referred to (S1116), and the process proceeds to S1120. If there is no purchase order (S1114: No), the address of the buyer is referred to (S1118), and the process proceeds to S1120. In S1120, the selling order log is referred to.

  In S1122, the variable i is initialized (i = 1). In S1130, the CPU 11 refers to the transaction establishment flag of the i-th purchase order in the purchase order log (FIG. 6A) stored in the purchase order information storage unit 26, and determines whether this is 0 or not. When the transaction establishment flag is 0 (S1130: Yes), the process proceeds to S1135 and the filter determination process is performed. When the transaction establishment flag is other than 0, for example, 1 (S1130: No), since the purchase order is the remaining number of units and all transactions have been completed, the transaction is not counted and the process proceeds to S1152. Proceed and add 1 to variable i.

  The filter determination process executed in S1135 has been described above. However, in the filter determination process performed in this process (buyer buy and sell table generation process), unlike the filter determination process performed in the sell order process and the buy order process, the buyer has not yet registered a buy order ( That is, there is a case where there is no specific buy order). In that case, the filter condition referred to in S1112 is used. Here, when the buyer does not set the shipping date, the supplier area, and the excluded supplier on the screen, the determination is made as Yes in the filter determination processes S510, S520, and S530, respectively. Therefore, if the buyer has set the filter condition on the screen, the selling order can be displayed under the condition narrowed down according to his / her condition. Note that the determination of S540 (buyer area) is made based on the buyer's shipping address referenced in S1116 or the buyer's address referenced in S1118.

  In S1140, based on the result of the filter determination process, the CPU 11 determines whether or not the i-th sell order matches the filter condition. If the filter condition is met (S1140: Yes), the process proceeds to S1142, and if the filter condition is not met (S1140: No), the process proceeds to S1152 and 1 is added to the variable i.

  In S1142, the CPU 11 refers to the selling price of the i-th selling order in the selling order log (FIG. 5) stored in the selling order information storage unit 25. In S1144, the CPU 11 refers to the shipping cost definition of the i-th selling order, that is, the size (small size, medium size, large size) for determining the shipping cost in the selling order log (FIG. 5). In S <b> 1146, the CPU 11 refers to the supplier shipping cost setting (FIG. 3B) stored in the supplier information storage unit 23.

  In S1148, the CPU 11 determines the shipping cost from the shipping cost definition referred to in S1144, the shipping cost setting referred to in S1146, and the purchase order shipping destination referred to in S1116 or the buyer's address referred to in S1118. In step S1150, the CPU 11 adds the shipping cost obtained in step S1148 to the selling price of the i-th selling order, adds it to the number of sales at the corresponding price, and displays it on the sales quotation table (FIG. 28).

  Thereafter, 1 is added to the variable i (S1152), and it is determined in S1154 whether or not processing has been performed up to the final log in the selling order log (FIG. 5). If there is a sell order that has not yet been processed (S1154: No), the process returns to S1130 and the process is repeated. When the process is completed up to the final log (S1154: Yes), the process proceeds to S1160.

  In S1160, the CPU 11 refers to the buy order log (FIG. 6A) stored in the buy order information storage unit 26. In step S1162, the variable i is initialized (i = 1). In S1164, the CPU 11 refers to the transaction establishment flag of the i-th purchase order in the purchase order log (FIG. 6A) stored in the purchase order information storage unit 26, and determines whether this is 0 or not. When the transaction establishment flag is 0 (S1164: Yes), the process proceeds to S1166. When the transaction establishment flag is other than 0, for example, 1 (S1164: No), the purchase order is the remaining number of units, and all the transactions have been completed. Therefore, the transaction is not counted and the process proceeds to S1172. Proceed and add 1 to variable i.

  In S <b> 1166, the CPU 11 determines whether or not the i-th purchase order satisfies the buyer area condition set on the screen. The buyer's regional conditions here refer to the purchase price of a specific region (shipping destination) because the buyer's purchase price (including shipping fee) of areas with extremely different shipping costs is not very helpful when browsing the trading table. This is for browsing only orders. This determination can be made by referring to the shipping destination region bit string in the purchase order log (FIG. 6A). When the buyer area condition set on the screen is satisfied (S1166: Yes), the process proceeds to S1168. Otherwise (S1166: No), the process proceeds to S1172 without counting the number of purchases, and 1 is added to the variable i.

  In S1168, the CPU 11 compares the bid price of the i-th buy order with the lowest price of the sell order displayed in the buy and sell price table, and the bid price of the i-th buy order is the highest bid price of the sell order. Judge whether it is higher than the low price. If the buy price of the i-th buy order is less than or equal to the lowest price of the sell order (S1168: No), the process proceeds to S1170. If the buy price of the i-th buy order is higher than the lowest price of the sell order (S1168: Yes), the process proceeds to S1172 without counting the number of purchases, and 1 is added to the variable i. In this determination, the selling price of the selling order (including the shipping fee) changes depending on the ship-to party of the buyer (buyer). Depending on the buying price of other buyers, there may be a phenomenon that the buying price exceeds the selling price. This is to exclude such a phenomenon because it is unnatural to display in the buying and selling price table.

  In S1170, the CPU 11 refers to the buy price and the remaining number of the i-th buy order in the buy order log (FIG. 6A), and displays the added number of the remaining number in the buying and selling price table. Thereafter, 1 is added to the variable i (S1172), and it is determined in S1174 whether or not the final log has been processed in the purchase order log (FIG. 6A). If there is a buy order that has not yet been processed (S1174: No), the process returns to S1164 and is repeated. When the process is completed up to the final log (S1174: Yes), the process proceeds to S1176.

  In S <b> 1176, the CPU 11 refers to the purchase order log (FIG. 6A) stored in the purchase order information storage unit 26 and determines whether or not there is a buyer purchase order for the product. When there is no buy order for the buyer (S1176: No), the processing of S1178 to S1182 is skipped and the processing is terminated.

  If there is a buy order for the buyer (S1176: Yes), in S1178, the current remaining number of the buyer's buy order (the remaining number in the buy order log in FIG. 6A) is replaced with the self-order of the corresponding price in the trading table Display in the number field. For example, in the example of FIG. 28, in the row of the price of 99500 yen, one of 11 buyers including himself / herself and others is the own purchase number, and this is displayed in the “Number of self-orders” column. ing.

  Next, in S1180, the CPU 11 refers to the buy order log (FIG. 6A) and determines the order of the buyer's buy order among the buy orders having the same buy price as the buyer's buy order. Displayed on the buying and selling price table. More specifically, the CPU 11 purchases the purchase order having the same purchase price as the buyer's purchase order and the transaction establishment flag is 0 in the purchase order log (FIG. 6A) and the purchase order details (FIG. 6B). Extract orders and rearrange them in ascending order of update time. Then, the purchase order of the buyer is determined and displayed in the “rank” column of the buy / sell price table. In the example of FIG. 28, the buyer's buy order is ranked seventh among the buy orders with a selling price of 99,500 yen.

  Next, in S1182, the CPU 11 obtains the price increase necessary for immediate purchase (that is, how much the purchase price can be purchased immediately) and displays it on the sales quotation table. For example, in the example of FIG. 28, there is no buy order and there is a sell order at a price of 99600 yen (sell number 5), so the buyer immediately purchases by raising the price from 99500 yen to 99600 yen. Can do. Specifically, the CPU 11 refers to the selling order log (FIG. 5), searches for the lowest selling price in the selling order log whose transaction establishment flag is 0, the price obtained by adding the postage to the selling price, and the buyer's Find the difference between the buy price and the buy price. In the example of FIG. 28, 99600−99500 = 100 yen, and this value of 100 yen is displayed in the “Price increase for immediate purchase” column of the sales quotation table. The process ends here. On the screen of FIG. 28, when the buyer clicks the pointer in the price “99600” yen field, the screen transitions to the product purchase order screen of FIG. 14 (in this case, the purchase price (including shipping cost) of FIG. Yen), you can proceed to buy order processing.

<Buy / quote table generation processing (when not logged in for buyers)>
Next, the sales quotation table generation process (at the time of non-login for the buyer) will be described with reference to FIGS. Since this process has many similar parts to the sales quotation table generation process (at the time of login for buyers), different parts will be mainly described.

  That is, in this process, since there is no buyer login information, a column is provided in which the buyer can input his / her address or shipping address area as a filter condition. In S1112, the CPU 11 also refers to this information. Do. Further, since there is no buyer login information, there is no processing of S1114, S1116, and S1118 in the sales quotation table generation processing (at the time of login for buyers).

  The filter determination process executed in S1135 is the same as that described above. In the filter determination process performed here, the filter condition (shipping date, supplier area, excluded supplier, buyer area) referred to in S1112 is used. Here, when the buyer has not set on the screen at least one of the shipping date, the supplier area, the excluded supplier, and the buyer area, Yes in the corresponding step of the filter determination process S510, S520, S530, and S540. Determine and process.

  If the buyer does not set the buyer area (address or shipping address) on the screen, the shipping fee is not determined in S1148. In this case, in S1150, the CPU 11 adds the selling price of the i-th selling order as it is (without adding the shipping fee), adds it to the number of sales at the corresponding price, and displays it on the trading quotation table (FIG. 28).

  In this process, the process of S1166 is not performed. Furthermore, since there is no buyer login information, the processing of S1176 and S1178 is not performed.

  2. Description of the Related Art Conventionally, there are sites on the Internet that display the selling price of each supplier that provides a product, for example, in ascending order of the price. In such a site, the buyer decides which supplier to purchase from after comparing and considering the selling price and shipping cost of each supplier. That is, it can be said that the buyer has the right to make a purchase. On the other hand, according to the information processing apparatus and method for selling / buying goods according to the above-described embodiment, the buyer's desired price is visualized by the buying / selling price table. You can know if you can expect sales. And if goods can be provided according to a buyer's desired price, a transaction can be established almost certainly. Therefore, it can be said that the supplier has the right to decide. In addition, the supplier can purchase the goods together after confirming the order. In addition, product information can be presented with the same information layout for the same product as a common sales space, so the desired price and inventory quantity can be visualized together to know the current market price and price fluctuations. be able to. Buyers can place a buy order at a price that can be purchased immediately if they want to obtain it immediately even at a high price, or they can place a buy order at a lower price if they want to obtain it cheaply even if it takes time. It becomes possible to cope with. As described above, the information processing apparatus and method for selling / buying goods according to the above-described embodiment brings great advantages to both the supplier and the buyer.

  The merchandise trading information processing apparatus and merchandise trading information processing method according to the present invention are not limited to the above-described embodiments, and various modifications and improvements can be made within the scope described in the claims.

  For example, in the above embodiment, the supplier exclusion filter, the shipping date filter, the supplier region filter, and the buyer region filter are set as the filter conditions, but only some of these may be used, or other filter conditions May be used.

  Moreover, in the said embodiment, all the screens and programs displayed on the supplier terminal 2 and the buyer terminal 3 are provided by the server 10 side, and the execution result in the server 10 is displayed on the web browser of the supplier terminal 2 and the buyer terminal 3. . On the other hand, application programs may be installed in the supplier terminal 2 and the buyer terminal 3 so that most processing is executed on the terminal side. In this case, for example, data is recorded and referred to as a server role. A batch processing program at regular time intervals is operated on the server side. The trading price table display program is operated on the application side.

  Moreover, the form of the supplier terminal 2 and the buyer terminal 3 is not particularly limited, such as a personal computer, a smartphone, or a mobile phone.

  In the above embodiment, once the selling price is set, the selling price is fixed unless the supplier updates the selling price. Not limited to this method, if the selling price of the product set by the supplier is lower than the lowest price of the other supplier's selling price in the buyer's buying and selling price table, the set price is not displayed as it is and the other supplier's selling price is not displayed. You may employ | adopt the method of displaying in alignment with the lowest price of a sales price.

  Moreover, in the said embodiment, the credit card payment was used as a payment method at the time of sale transaction establishment. In addition to this, the buyer may make a deposit by bank transfer or the like in advance, and may select to perform trading within the range of the deposited amount (pre-payment). When the buyer selects this method, S620 of the transaction establishment process (FIG. 21) may be set as a determination step, for example, “Does the transaction amount exceed the deposit balance?”. In addition to payment by credit card payment and advance payment, for example, if there is a method that can perform payment processing immediately in transaction establishment processing (FIG. 21), it may be used.

  Moreover, in the said embodiment, although it described on the assumption that it was in Japan as an area | region of a supplier and a buyer, a foreign country may be included. In the case of a foreign country, each bit of the supplier's and buyer's regional bit string / regional filter may be set to correspond to each region such as Asia, North America, Europe, or each country such as China, the United States, and the United Kingdom.

  In the above-described embodiment, in the transaction establishment process, when the purchase order (including the shipping cost) of the buy order is higher than the price obtained by adding the shipping cost to the selling price of the sell order for the sell order and the buy order for which the transaction has been established. In contrast, the purchase price (including the shipping cost) of the purchase order is the transaction settlement price, but on the contrary, the price obtained by adding the shipping cost to the selling price of the sell order may be the transaction settlement price.

  As described above, the information processing apparatus for buying and selling goods according to the present invention performs information processing based on the needs of sellers and buyers via a network, thereby efficiently processing and selling goods. Useful as a method.

1 Internet 2 Supplier terminal 3 Buyer terminal 10 Server 11 CPU
12 RAM
13 ROM
14 Communication IF
15 Bus 16 Clock unit 20 HDD
21 Program storage unit 22 Product information storage unit 23 Supplier information storage unit 24 Buyer information storage unit 25 Sell order information storage unit 26 Purchase order information storage unit 27 Buying and selling information storage unit 28 Temporary storage unit

Claims (6)

Selling order information storage unit for receiving selling order information including supplier identification information, selling price, number of units sold, selling order time, supplier side filter information, and postage definition information relating to the size of the product with respect to the product Selling order information receiving means stored in
With respect to the product, buy order information receiving means for receiving buy order information including buyer identification information, buy price, number of units bought, buy order time and buyer side filter information from the buyer's terminal and storing it in the buy order information storage unit;
A supplier information storage unit for storing a supplier postage setting table including postage data set by the supplier and including postage data corresponding to the size and shipping destination of the product;
When the sell order information is received by the sell order information receiving means, for each of a plurality of buy orders stored in the buy order information storage unit, the supplier shipping cost setting table is referred to and the purchase order is sent out. A postage purchase price calculation means for searching the postage data corresponding to the destination and the postage definition information, determining a postage, and calculating a postage purchase price obtained by subtracting the postage from the purchase price;
Buy order extracting means for extracting from the buy order information storage unit the buy order information having the purchase price without the postage that is higher than or equal to the sell price of the received sell order information;
A buy order rearranging means for rearranging the buy order information extracted by the buy order extracting means in descending order of the purchase price without shipping charges and in order of the buy order time at the same price;
For the supplier side filter information and the buyer side filter information corresponding to one of the sorted buy order information and the received sell order information in the order rearranged by the buy order rearranging means. A predetermined data processing, and a first filter determination processing means for outputting a value indicating a match when the condition is met,
A first transaction establishment means for performing a transaction establishment process when a value indicating the match is output for one of the sorted order information and the received sell order information;
When the buy order information is received by the buy order information receiving means, for each of a plurality of sell orders stored in the sell order information storage unit, the received purchase order is referred to the supplier shipping cost setting table. A postage sales price calculation means for searching the postage data corresponding to the shipping destination of the information and the postage definition information to determine the postage, and calculating the postage sales price by adding the postage to the sales price;
Sell order extracting means for extracting from the sell order information storage unit the sell order information having the selling price including the postage that is lower than or equal to the buy price of the received buy order information;
Sell order rearranging means for rearranging the sell order information extracted by the sell order extracting means in ascending order of the selling price including postage and in order of the sell order time at the same price;
The supplier-side filter information and the buyer-side filter information corresponding to one of the sorted sell order information and the received buy order information in the order sorted by the sell order sorting means. A second filter determination processing means for performing predetermined data processing and outputting a value indicating the match when the condition is met,
A second transaction establishment means for performing a transaction establishment process when one of the sorted sell order information and the received buy order information is output with a value indicating the match;
With regard to the product, a trading price table generating means for generating a trading price table that displays a plurality of prices set at regular intervals, and the number of selling orders and the number of buying orders for each price in association with each other,
The buy / sell price table generating means generates the buy / sell price table to be displayed on the terminal of the supplier.
With reference to the supplier shipping cost setting table, search for shipping address of the purchase order and the shipping cost data corresponding to the shipping cost definition information,
For each of a plurality of selling orders stored in the selling order information storage unit, the selling price and the selling volume are referred to, and each selling price is handled by adding the selling volume to the selling price of the corresponding price. Determine the number of items to sell,
For each of a plurality of buying orders stored in the buying order information storage unit, referring to the buying price and the buying quantity, adding the buying quantity to the buying quantity obtained by subtracting the shipping fee from the buying price. To determine the number of purchases corresponding to each price,
On the other hand, when generating the trading price table to be displayed on the buyer's terminal,
Referring to the supplier shipping cost setting table, search for the shipping cost data corresponding to the shipping destination of the buyer and the shipping cost definition information,
For each of a plurality of selling orders stored in the selling order information storage unit, by referring to the selling price and the selling volume, and adding the selling volume to the selling volume of a price obtained by adding a shipping fee to the selling price Determine the number of sales corresponding to each price,
For each of a plurality of buy orders stored in the buy order information storage unit, refer to the purchase price and the number of units purchased, and add the number of units purchased to the corresponding number of purchases of the corresponding price. Determine how many to buy,
The buy order information includes buy order log information and buy order details information,
The buy order log information includes a buy order ID assigned to each buy order on a one-to-one basis, a trade establishment flag indicating whether or not each buy order has been established, and each buy order is a parallel bid. Including a parallel bid flag indicating whether or not
The buy order detail information can be stored in association with a buy order related to a plurality of product IDs for one buy order ID,
The buy order detail information stores a buy order having a plurality of product IDs in association with a buy order having the parallel bid flag of 1, and the transaction of the buy order ID having the parallel bid flag of 1 is stored. An information processing apparatus for buying and selling goods, characterized in that, when the establishment flag is already established, the transaction ends for all of the plurality of products related to the plurality of product IDs corresponding to the purchase order ID.   Selling order information storage unit for receiving selling order information including supplier identification information, selling price, number of units sold, selling order time, supplier side filter information, and postage definition information relating to the size of the product with respect to the product Selling order information receiving means stored in
  With respect to the product, buy order information receiving means for receiving buy order information including buyer identification information, buy price, number of units bought, buy order time and buyer side filter information from the buyer's terminal and storing it in the buy order information storage unit;
  A supplier information storage unit for storing a supplier postage setting table including postage data set by the supplier and including postage data corresponding to the size and shipping destination of the product;
  When the sell order information is received by the sell order information receiving means, for each of a plurality of buy orders stored in the buy order information storage unit, the supplier shipping cost setting table is referred to and the purchase order is sent out. A postage purchase price calculation means for searching the postage data corresponding to the destination and the postage definition information, determining a postage, and calculating a postage purchase price obtained by subtracting the postage from the purchase price;
  Buy order extracting means for extracting from the buy order information storage unit the buy order information having the purchase price without the postage that is higher than or equal to the sell price of the received sell order information;
  A buy order rearranging means for rearranging the buy order information extracted by the buy order extracting means in descending order of the purchase price without shipping charges and in order of the buy order time at the same price;
  For the supplier side filter information and the buyer side filter information corresponding to one of the sorted buy order information and the received sell order information in the order rearranged by the buy order rearranging means. A predetermined data processing, and a first filter determination processing means for outputting a value indicating a match when the condition is met,
  A first transaction establishment means for performing a transaction establishment process when a value indicating the match is output for one of the sorted order information and the received sell order information;
  When the buy order information is received by the buy order information receiving means, for each of a plurality of sell orders stored in the sell order information storage unit, the received purchase order is referred to the supplier shipping cost setting table. A postage sales price calculation means for searching the postage data corresponding to the shipping destination of the information and the postage definition information to determine the postage, and calculating the postage sales price by adding the postage to the sales price;
  Sell order extracting means for extracting from the sell order information storage unit the sell order information having the selling price including the postage that is lower than or equal to the buy price of the received buy order information;
  Sell order rearranging means for rearranging the sell order information extracted by the sell order extracting means in ascending order of the selling price including postage and in order of the sell order time at the same price;
  The supplier-side filter information and the buyer-side filter information corresponding to one of the sorted sell order information and the received buy order information in the order sorted by the sell order sorting means. A second filter determination processing means for performing predetermined data processing and outputting a value indicating the match when the condition is met,
  A second transaction establishment means for performing a transaction establishment process when one of the sorted sell order information and the received buy order information is output with a value indicating the match;
  With regard to the product, a trading price table generating means for generating a trading price table that displays a plurality of prices set at regular intervals, and the number of selling orders and the number of buying orders for each price in association with each other,
  The buy / sell price table generating means generates the buy / sell price table to be displayed on the terminal of the supplier.
    With reference to the supplier shipping cost setting table, search for shipping address of the purchase order and the shipping cost data corresponding to the shipping cost definition information,
    For each of a plurality of selling orders stored in the selling order information storage unit, the selling price and the selling volume are referred to, and each selling price is handled by adding the selling volume to the selling price of the corresponding price. Determine the number of items to sell,
    For each of a plurality of buying orders stored in the buying order information storage unit, referring to the buying price and the buying quantity, adding the buying quantity to the buying quantity obtained by subtracting the shipping fee from the buying price. To determine the number of purchases corresponding to each price,
  On the other hand, when generating the trading price table to be displayed on the buyer's terminal,
    Referring to the supplier shipping cost setting table, search for the shipping cost data corresponding to the shipping destination of the buyer and the shipping cost definition information,
    For each of a plurality of selling orders stored in the selling order information storage unit, by referring to the selling price and the selling volume, and adding the selling volume to the selling volume of a price obtained by adding a shipping fee to the selling price Determine the number of sales corresponding to each price,
    For each of a plurality of buy orders stored in the buy order information storage unit, refer to the purchase price and the number of units purchased, and add the number of units purchased to the corresponding number of purchases of the corresponding price. Determine how many to buy,
  The supplier-side filter information includes a supplier-side shipping date filter composed of a bit string of a first predetermined length that represents information related to the shipping date.
  The buyer-side filter information includes a buyer-side shipping date filter composed of the first predetermined-length bit string indicating information on a desired shipping date,
  The first filter determination processing means and the second filter determination processing means have a bit that is “1” obtained by ANDing the corresponding bits of the supplier-side shipping date filter and the buyer-side shipping date filter. If it exists, it is judged that the condition is met,
  In addition, a supplier information storage unit that stores a supplier region bit string composed of a bit string of a second predetermined length representing information about the region where the supplier is located,
  The buyer side filter information includes a supplier region filter composed of a bit string of the second predetermined length representing information on a supplier region desired by the buyer,
  The first filter determination processing means and the second filter determination processing means are provided when there is a bit that is “1” obtained by ANDing the corresponding bits of the supplier region bit string and the supplier region filter. An information processing apparatus for buying and selling merchandise, characterized in that the condition is met. A buyer information storage unit that stores payment information corresponding to the buyer identification information of each buyer;
Each of the first transaction establishment means and the second transaction establishment means,
Payment error determination means for determining whether an error has occurred in payment based on the payment information;
A unit number subtracting unit that subtracts the number of completed transactions from the unit sold and the unit purchased when the settlement error determining unit determines that no error has occurred;
A remaining number zero determining means for determining whether the sold number and the purchased number subtracted by the number subtracting means have become zero;
A transaction establishment flag setting means for setting a flag indicating that a transaction is established for the sell order information or the buy order information when the sold number or the purchased number determined by the remaining number zero determination means becomes zero. The information processing apparatus for buying and selling goods according to claim 1 or 2 . The buying and selling price table generating means refers to the selling order information storage unit and extracts a selling order having the same selling price as the selling order of the supplier and having the transaction establishment flag of 0, and updating time Are sorted in order from the earliest, the order of the selling order of the supplier is determined and displayed on the trading quotation table,
  The buying and selling price table generating means refers to the buying order information storage unit, searches for the highest buying price among the buying orders with the transaction establishment flag being 0, the price obtained by subtracting the postage from the buying price, and the selling price of the supplier By calculating the difference from the selling price of the order, the price reduction required for immediate sales is calculated and displayed on the trading quotation table,
  The buying and selling price table generating means refers to the buying order information storage unit and extracts a buying order having the same buying price as the buyer's buying order and having the transaction establishment flag of 0, and an update time Are sorted in order from the earliest, the order of purchase order of the buyer is determined and displayed on the buy and sell price table,
  The buying and selling price table generating means refers to the selling order information storage unit, searches for the lowest selling price among selling orders with the transaction establishment flag being 0, and buys the buyer and the price obtained by adding the postage to the selling price. 4. The information processing apparatus for buying and selling merchandise according to claim 3, wherein a price increase necessary for immediate purchase is obtained by obtaining a difference from a purchase price of an order and displayed on the buying and selling price table. A method of processing the sale of goods using a computer,
The computer includes a processor that executes processing, and a storage unit that can store information used by the processor. The storage unit includes a sell order information storage unit, a buy order information storage unit, and a supplier information storage. Part
The processor, with respect to goods, from suppliers of terminal, supplier identification information, sales price, sales volume, sell order time, the supplier side filter information, and, the received order information sell including shipping definition information about the size of the quotient goods Store it in the sell order information storage unit,
The processor, with respect to the product, stores the terminal buyer, the buyer identification information, bid, purchase volume, in the buy order information storage unit receives the purchase order information including a buy order time and the buyer side filter information,
The processor receives and stores a supplier shipping setting table including shipping data set by the supplier and including shipping data according to the size and shipping destination of the product in the supplier information storage unit ,
When the sell order information is received , the processor refers to the supplier shipping setting table for each of a plurality of buy orders stored in the buy order information storage unit, determining shipping searches the said transmission fee data corresponding to postage definition information, to calculate the postage vent bid obtained by subtracting said transmission fees from該買value,
The processor, have該買the該買have order information having the same said transmission fees vent bid higher or該売value than selling price of the received sell order information extracted from the order information storage section,
The processor, the該買have order information that has been extracted, eh exchange arranged in ascending order is the order time have該買a high order and the price of said transmission fee Without bid,
The processor performs predetermined processing on the supplier side filter information and the buyer side filter information corresponding to one of the sorted buy order information and the received sell order information in the sorted order. It performs data processing, if it meets the condition, and outputs a value indicating the matching,
The processor, for the one and the received sell order information of該買have order information which is changed the arrangement, have rows transaction establishment processing when a value indicating the match is output,
When the buy order information is received , the processor refers to the supplier shipping setting table for each of a plurality of sell orders stored in the sell order information storage unit, and sends the received buy order information. searches the said transmission fee data corresponding to previously and said transmission fee definition information to determine the postage, calculates postage selling price obtained by adding said transmission fee該売value,
The processor, the該売Ri order information having the same said transmission charges included selling price lower or該買value than purchase price of the received purchase order information extracted from該売Ri order information storage unit,
The processor, the extracted該売Ri order information was, eh exchange arranged in ascending order is該売Ri order time in said transmission charge lump of low order and the same price of the sale price,
The processor performs predetermined processing on the supplier-side filter information and the buyer-side filter information corresponding to one of the sorted sell order information and the received buy order information in the sorted order. It performs data processing, and outputs a value indicating the matching if it meets the condition,
The processor, for the one and the received purchase order information of該売Ri order information which is changed the arrangement, have rows transaction establishment processing when a value indicating the match is output,
Further, the processor generates a buy and sell price table that displays a plurality of prices set at regular intervals, the number of sell orders and the number of buy orders for each price in association with each other,
When the processor generates the buy and sell price table to display on the supplier's terminal,
With reference to the supplier shipping cost setting table, search for shipping address of the purchase order and the shipping cost data corresponding to the shipping cost definition information,
For each of a plurality of selling orders stored in the selling order information storage unit, the selling price and the selling volume are referred to, and each selling price is handled by adding the selling volume to the selling price of the corresponding price. Determine the number of items to sell,
For each of a plurality of buying orders stored in the buying order information storage unit, referring to the buying price and the buying quantity, adding the buying quantity to the buying quantity obtained by subtracting the shipping fee from the buying price. To determine the number of purchases corresponding to each price,
On the other hand, when generating the trading price table to be displayed on the buyer's terminal,
Referring to the supplier shipping cost setting table, search for the shipping cost data corresponding to the shipping destination of the buyer and the shipping cost definition information,
For each of a plurality of selling orders stored in the selling order information storage unit, by referring to the selling price and the selling volume, and adding the selling volume to the selling volume of a price obtained by adding a shipping fee to the selling price Determine the number of sales corresponding to each price,
For each of a plurality of buy orders stored in the buy order information storage unit, refer to the purchase price and the number of units purchased, and add the number of units purchased to the corresponding number of purchases of the corresponding price. Determine how many to buy,
The buy order information includes buy order log information and buy order details information,
The buy order log information includes a buy order ID assigned to each buy order on a one-to-one basis, a trade establishment flag indicating whether or not each buy order has been established, and each buy order is a parallel bid. Including a parallel bid flag indicating whether or not
The buy order detail information can be stored in association with a buy order related to a plurality of product IDs for one buy order ID,
The buy order details information stores a buy order with a plurality of product IDs corresponding to a buy order with the parallel bid flag set to 1, so that the transaction with the buy order ID with the parallel bid flag set to 1 is stored. A merchandise sales information processing method characterized in that, when the completion flag indicates that the transaction has been completed, the transaction ends for all of the plurality of products related to the plurality of product IDs corresponding to the purchase order ID. A method of processing the sale of goods using a computer,
The computer includes a processor that executes processing, and a storage unit that can store information used by the processor. The storage unit includes a sell order information storage unit, a buy order information storage unit, and a supplier information storage. Part
The processor, with respect to goods, from suppliers of terminal, supplier identification information, sales price, sales volume, sell order time, the supplier side filter information, and, the received order information sell including shipping definition information about the size of the quotient goods Store it in the sell order information storage unit,
The processor, with respect to the product, stores the terminal buyer, the buyer identification information, bid, purchase volume, in the buy order information storage unit receives the purchase order information including a buy order time and the buyer side filter information,
The processor receives and stores a supplier shipping setting table including shipping data set by the supplier and including shipping data according to the size and shipping destination of the product in the supplier information storage unit ,
When the sell order information is received , the processor refers to the supplier shipping setting table for each of a plurality of buy orders stored in the buy order information storage unit, determining shipping searches the said transmission fee data corresponding to postage definition information, to calculate the postage vent bid obtained by subtracting said transmission fees from該買value,
The processor, have該買the該買have order information having the same said transmission fees vent bid higher or該売value than selling price of the received sell order information extracted from the order information storage section,
The processor, the該買have order information that has been extracted, eh exchange arranged in ascending order is the order time have該買a high order and the price of said transmission fee Without bid,
The processor performs predetermined processing on the supplier side filter information and the buyer side filter information corresponding to one of the sorted buy order information and the received sell order information in the sorted order. It performs data processing, if it meets the condition, and outputs a value indicating the matching,
The processor, for the one and the received sell order information of該買have order information which is changed the arrangement, have rows transaction establishment processing when a value indicating the match is output,
When the buy order information is received , the processor refers to the supplier shipping setting table for each of a plurality of sell orders stored in the sell order information storage unit, and sends the received buy order information. searches the said transmission fee data corresponding to previously and said transmission fee definition information to determine the postage, calculates postage selling price obtained by adding said transmission fee該売value,
The processor, the該売Ri order information having the same said transmission charges included selling price lower or該買value than purchase price of the received purchase order information extracted from該売Ri order information storage unit,
The processor, the extracted該売Ri order information was, eh exchange arranged in ascending order is該売Ri order time in said transmission charge lump of low order and the same price of the sale price,
The processor performs predetermined processing on the supplier-side filter information and the buyer-side filter information corresponding to one of the sorted sell order information and the received buy order information in the sorted order. It performs data processing, and outputs a value indicating the matching if it meets the condition,
The processor, for the one and the received purchase order information of該売Ri order information which is changed the arrangement, have rows transaction establishment processing when a value indicating the match is output,
Further, the processor generates a buy and sell price table that displays a plurality of prices set at regular intervals, the number of sell orders and the number of buy orders for each price in association with each other,
When the processor generates the buy and sell price table to display on the supplier's terminal,
With reference to the supplier shipping cost setting table, search for shipping address of the purchase order and the shipping cost data corresponding to the shipping cost definition information,
For each of a plurality of selling orders stored in the selling order information storage unit, the selling price and the selling volume are referred to, and each selling price is handled by adding the selling volume to the selling price of the corresponding price. Determine the number of items to sell,
For each of a plurality of buying orders stored in the buying order information storage unit, referring to the buying price and the buying quantity, adding the buying quantity to the buying quantity obtained by subtracting the shipping fee from the buying price. To determine the number of purchases corresponding to each price,
On the other hand, when generating the trading price table to be displayed on the buyer's terminal,
Referring to the supplier shipping cost setting table, search for the shipping cost data corresponding to the shipping destination of the buyer and the shipping cost definition information,
For each of a plurality of selling orders stored in the selling order information storage unit, by referring to the selling price and the selling volume, and adding the selling volume to the selling volume of a price obtained by adding a shipping fee to the selling price Determine the number of sales corresponding to each price,
For each of a plurality of buy orders stored in the buy order information storage unit, refer to the purchase price and the number of units purchased, and add the number of units purchased to the corresponding number of purchases of the corresponding price. Determine how many to buy,
The supplier-side filter information includes a supplier-side shipping date filter composed of a bit string of a first predetermined length that represents information related to the shipping date.
The buyer-side filter information includes a buyer-side shipping date filter composed of the first predetermined-length bit string indicating information on a desired shipping date,
The processor determines that the condition is met when there is a bit that is “1” by performing a logical product of the corresponding bits of the supplier side shipping date filter and the buyer side shipping date filter.
The supplier information storage unit stores a supplier region bit string composed of a bit string of a second predetermined length representing information on an area where the supplier is located,
The buyer side filter information includes a supplier region filter composed of a bit string of the second predetermined length representing information on a supplier region desired by the buyer,
The processor determines that the condition is met when there is a bit of “1” by taking the logical product of the corresponding bits of the supplier region bit string and the supplier region filter. Information processing method.

Images