JP2007004518A - Online shop exhibition support device and program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide an online shop exhibition support device which supports exhibitors, such as price revision of goods which are exhibited on an online shop, transmission of an order receiving mail to a purchaser, printing of an invoice. <P>SOLUTION: Information of the goods which are currently exhibited on the online shop is stored in a stock table of a database 31. Another exhibition information acquisition part 32 acquires exhibition information of other exhibitors who exhibit the same goods as the goods exhibited by the exhibitor based on an ISBN code of the stock table, calculates his or her exhibition price based on the other exhibitors' exhibition price in an exhibition price determination part 38, and changes the exhibition price. Thus, even when there are many stocks, price revision can be performed quickly. <P>COPYRIGHT: (C)2007,JPO&INPIT

Description

  The present invention relates to an online shop in which a user can sell products by selling them, and more particularly, to an online shop exhibition support apparatus that supports the exhibition and management of exhibitors.

Conventionally, there are many online shops that sell products through the Internet. The online shop is a system in which a user browses and purchases products by connecting to an online shop server via the Internet. In contrast to online shops where such users only purchase products, recently, CtoC (consumer to
There is an online shop where a user can sell a product to a user.

  For example, Patent Literature 1 discloses an online shop (marketplace) where a plurality of exhibitors can exhibit. In this online shop, one product page is created for each product, and information related to the product such as product name, product content, and evaluation is displayed on the web page on one product page. A user who wants to purchase this product can purchase from this page.

  A user who wants to sell a product that has the same product as that product can be sold by registering the seller name, the condition of the product, and the product price. The condition is information indicating the state of the product such as “good” or “very good” if it is a used product.

  The product page is linked to the sales page of the seller who sells the same product as the product, and when the seller's sales page is opened, a list with the seller name, condition and price in one line is displayed. The The user who wants to purchase can purchase a product from an exhibitor by selecting the product he / she likes here.

  When the product is purchased here, the online shop sends an exhibition product sales end mail notifying the seller that the product has been sold. In the email, the product name of the sold product, the email address, address and name of the user who purchased the product are described. Upon receiving the exhibition product sales end mail, the seller sends an order mail to the purchaser and ships the product to the purchaser. At this time, a delivery note is printed on the basis of the end-of-sale-item sales end mail, and is attached to the product and packed.

  Similar technology of an online shop where a plurality of exhibitors can sell products is also disclosed in Patent Document 2.

JP 2005-508038 gazette JP 2001-256356 A

  The sales of a product are greatly influenced by the price of the product, and if the product is the same, the cheaper it is, the easier it is to sell. Therefore, among the sellers who sell the same products, if they sell as cheaply as possible, they will sell quickly. If many of the exhibitors think in this way, the price of the newly exhibited person is most likely to be the cheapest, and the price of the person who has exhibited at the beginning tends to be high. Therefore, it is difficult to sell the products listed in the first one. Therefore, it is necessary to revise the price.

To make a price revision, first open the product page for the product you are listing, then open the seller's sales page linked to it, and look up all the other seller's listing prices The exhibition price is determined with reference to the cheapest price among them. Such work can be performed manually as long as the number of exhibition points is small, but it is almost impossible to perform manually when the number of exhibition points is hundreds.

  Also, when a product is sold, it is necessary to send an order e-mail to the purchaser or print a delivery note. However, if dozens of items are sold per day, This is a very annoying task.

  In addition, when listing a product, it is necessary to determine the listing price by referring to the listing price of other sellers. To do so, open the listing page for the product and link to the linked page. However, there is a problem that it is very troublesome when there are many items for sale.

  The present invention is intended to reduce the work of exhibitors of such online shops, and aims to support the price revision work of exhibited products, work when products are sold, and exhibition work. It is.

A first problem solving means for achieving the above object is an online shop listing support that supports a seller who sells a product to the online shop connected to a server of an online shop that sells a plurality of products via a network. A device,
In the online shop, a plurality of sellers can sell a single product. For a single product, product specifying information for specifying the product, a seller who sells the product, and the seller Display the related listing price of
The online shop exhibition support device has an exhibition information storage means for storing product specifying information of a plurality of exhibition products that the exhibitor is exhibiting,
Other exhibition information acquisition means for acquiring an exhibition price of other sellers who sell the product based on the product specification information stored in the exhibition information storage means;
It has an exhibition price determining means for determining an exhibition price of its own exhibition product based on the exhibition price acquired by the other exhibition information acquiring means.

The second problem-solving means is an online shop exhibition support device that is connected to a server of an online shop that sells a plurality of products via a network and supports an exhibitor who sells products in the online shop,
The online shop allows a plurality of sellers to sell a single product, and when the sold product is sold, it sends an exhibition product sales end email including the buyer's email address to the seller,
The online shop exhibition support device is configured to send an email to a purchaser based on the received exhibition product sales end email,
And printing means for printing a delivery slip to be sent to the purchaser together with the product based on the mail for selling the finished product.

Further, the third problem solving means is an online shop listing support apparatus that is connected to a server of an online shop that sells a plurality of products via a network and supports a seller who sells products in the online shop,
In the online shop, a plurality of sellers can sell a single product. For a single product, product specifying information for specifying the product, a seller who sells the product, and the seller Display an associated listing price, receive from the seller a list of listings that pair the product identification information with the listing price of the product, store it,
The online shop exhibition support device, when the product specifying information is input, other exhibition information acquisition means for acquiring and displaying the exhibition price of other sellers who exhibit the product,
When an exhibition price is input, it has an exhibition list creating means for creating an exhibition list in combination with the product specifying information.

Furthermore, the fourth problem solving means is an online shop listing that is executed by a computer connected via a network to a server of an online shop that sells a plurality of products, and that supports sellers who sell the products in the online shop. A support program,
In the online shop, a plurality of sellers can sell one product. For one product, product specifying information for specifying the product, an exhibitor who sells the product, and presentation of the seller Display the related listing price
The online shop exhibition support program stores product identification information of a plurality of items for sale that are exhibited by the seller himself,
Based on the stored product identification information, obtain the listing price of other sellers of the listing product,
Based on the acquired exhibition price, the exhibition price of the item for sale is determined.

  According to the first and fourth problem solving means, the other exhibition information obtaining means automatically obtains the price of the other seller of the product being exhibited by the seller, and based on this, the exhibition price determining means The exhibition price can be determined by. This makes it possible to quickly perform operations such as changing the exhibited product to the lowest price. By performing all of such work on all the exhibited products stored in the exhibition information storage means, it is possible to quickly perform price revision work even when a large number of products are exhibited. Become.

  According to the second problem solving means, when an e-mail for selling items sold from the online shop is received, the e-mail sending means can send an e-mail to the purchaser, saving the time for sending the e-mail. Moreover, since the printing means prints the delivery note when receiving the exhibition merchandise sales end mail, the trouble of creating the delivery note is saved.

  According to the third problem solving means, the exhibition price of other sellers can be obtained by the other exhibition information obtaining means, so that an exhibition list can be easily created and a large number of products are exhibited. Even so, the exhibition work can be performed quickly.

  According to the present invention, it is possible to quickly perform price revision work even when a large number of products are exhibited.

  Further, according to the present invention, troublesome operations such as sending an e-mail to a purchaser when a product is sold and printing a delivery note are automatically performed, thereby reducing the work of the exhibitor.

  Furthermore, according to the present invention, an exhibition list can be easily created while looking at the exhibition prices of other exhibitors, so that an exhibition operation can be performed quickly.

  FIG. 1 is a network diagram showing an environment to which an online shop exhibition support apparatus of the present invention is applied. With reference to this figure, the operation of the online shop assumed in the present invention will be described first. The online shop server 1 and the online shop user PC (personal computer) 2 are connected via a network 3 such as the Internet. The user may be a purchaser who purchases a product from an online shop or an exhibitor who sells a product in the online shop, and the purchaser and the exhibitor may be the same. A plurality of PCs 2 are on the client side and read data from the server 1.

  FIG. 2 is a diagram illustrating a product page of an online shop displayed on the PC 2. The user's PC 2 browses the online shop product page 10 with a browser or the like. One product page 10 is created for one product, and the user searches the product name and displays the product page 10.

  On the product page 10, a product name 11, a product photo 12, a price 16, and the like are displayed. Further, as the description of the product, the product content, evaluation, sales ranking, etc. are displayed. Also, information such as the shipping time, which is the period from when the order is placed, to the date of shipment, and the price 13 of the used item when the used item is exhibited by the seller are also displayed. The product content is provided by the manufacturer of the product or created in an online shop. Evaluation is performed by a user who has used the product, for example, in five stages. The sales ranking shows the sales at this online shop. With reference to these, the user can purchase a product.

The online shop server 1 stores the above-mentioned information such as the product name and price in relation to the product in the database. When the product is designated from the user's PC 2, the relevant information is extracted from the database, and the product page 10 is created dynamically.

  As products sold in the online shop, there are various products such as books, CDs (compact discs), DVDs (digital Versatile Discs), videos, software, electrical appliances, toys, tickets, and the like. In order to display the product page 10, information specifying a product such as a product name is entered and searched. For example, in the case of a book, a product such as an ISBN code (Japanese book code) or a combination of a book title and author It is also possible to search by other methods as long as it is information specifying. In the case of an electrical appliance, a model number or the like can be used as product specifying information.

  The product page 10 includes an order button 15, and the user can press the order button 15 to order a product. If you order here, you will buy from this online shop. In this online shop, it is possible not only to purchase directly from the shop, but also to purchase from an exhibitor exhibiting in this shop.

  The used price 13 of the product page 10 has a link, and this linked page is the seller's sales page where the seller sells the same product as this product.

  FIG. 3 is a diagram showing a seller's sales page which is a link destination of the used price 13. A product name 20 is described at the top of the page of the seller's sales page, and below that, a list of product information of the seller is displayed. In this list, one piece of exhibition information is described in one line. The exhibition information includes an exhibition price 21, a condition 22, an exhibitor name 23, a comment 24, and the like, and an order button 25 is provided.

  The exhibition price is the selling price of the product, and is determined by the exhibitor himself. The condition is the state of the product, and is broadly classified into “used” and “collector”, each of which is in the state of “new”, “almost new”, “very good”, “good”, “good”, etc. Expressed in good or bad rank. This is also decided by the exhibitor. A “collector” is an item with added value such as a signature, and can be exhibited at a price higher than the selling price of an online shop. The comment explains the state of the product in more detail, and is described by the exhibitor as necessary. As the seller information, not only the seller name 23 but also the seller's evaluation may be displayed. The seller's evaluation means that a user who has purchased a product from this seller evaluates the transaction contents in five stages, for example. The average value of this evaluation and the number of evaluations are displayed as exhibitor information.

Such information is recorded in the database of the online shop server in relation to the exhibited product, and when the display of the seller's sales page is instructed from the PC 2, the necessary information is obtained from the database and dynamically Generate a sales page. The list of products is displayed, for example, in order from the lowest sales price, and the product with the lowest price is displayed at the top. Also, the number of items displayed on one page is predetermined as, for example, five items. If more items are listed, a link such as “next page” will be displayed and the remaining link will remain. Products are displayed.

  A user who wants to purchase a product determines a product with reference to the exhibition price, condition, seller's evaluation, etc., and presses the order button 25 of the seller to order the product. In addition, the user who purchases the product has registered his / her name, address, e-mail address, and credit card information for payment in the online shop, and the seller is also a bank account to transfer the fee when the product is sold Register your account information in the online shop.

When a product is ordered, the online shop will send an email indicating that the product has been sold to the seller, and information on the sale of the product will be registered in the database of the online shop server. Disappear from the seller's sales page. The sale merchandise end-of-sale email includes the name of the merchandise sold, the exhibition price, the purchaser's name, address, e-mail address, and a delivery note attached when sending the merchandise.

When an item is sold, it is determined that the item will be shipped within a predetermined period of time, for example, two business days. When the seller receives an email indicating that the item has been sold, the seller first received an order from the buyer. Send order mail to notify you. Then, a delivery note described in the exhibition merchandise sales end mail is printed, packed together with the merchandise, and shipped to the purchaser within a predetermined period. When it is shipped, a mail that has already been sent is sent to the purchaser.

  When an online shop sells a product, it settles with the credit card of the user who purchased it, and deducts a fee and transfers the money to the bank account of the exhibitor. The above is the outline of the entire online shop system to which the online shop support apparatus of the present invention is applied. Next, the online shop support device will be described.

  The online shop support apparatus is realized by executing an online shop support program on the user's PC 2. FIG. 4 is a block diagram of the online shop support program 30. The online shop support program 30 includes a database 31, an other exhibition information acquisition unit 32, an exhibition file creation unit 33, an invoice printing unit 34, an email reception unit 35, an email transmission unit 36, an order mail creation unit 37, and an exhibition price determination unit 38. , A product information acquisition unit 39 and a shipped mail creation unit 40 are provided.

  FIG. 5 is a main screen of the online shop support apparatus. The main screen 50 is provided with a warehousing registration button 51, an exhibition registration button 52, a price revision button 53, a mail acquisition button 54, an invoice printing button 55, a shipping status registration button 56, and a shipped mail transmission button 57. FIG. 6 is a diagram showing the contents of the database 31 of the online shop support apparatus. The operation of the online shop support apparatus will be described with reference to these figures.

  When the warehousing registration button on the main screen 50 is pressed, the exhibited product can be registered. FIG. 7 is a warehousing registration screen displayed when the warehousing registration button 51 is pressed. The warehousing method will be described using this figure. In the following description, it is assumed that a book is exhibited as an exhibition product. First, the ISBN code of the book that is the exhibited product is input to the ISBN input box 71. The ISBN code is used to uniquely identify a book that is an exhibited product. When the ISBN is input and the search button 72 is pressed, the product information acquisition unit 39 of the online shop support program 30 searches for products from the online shop server 1, acquires the product information, and displays it on the book information display unit 73.

  The book information display section 73 includes a title display section 74, a publisher display section 75, an author name display section 76, a shipping time display section 77, a publication date display section 78, a price display section 79, a sales ranking display section 80, a product. There is an image display unit 82, and the acquired information is displayed on these. Information acquired by the exhibition information acquisition unit 39 is mainly displayed on the product page of FIG.

Further, the information on other exhibitors is acquired by the other exhibit information acquisition unit 32 and displayed on the other exhibit information display unit 90. The other exhibition information display section 90 displays the number 91 of exhibitions, the lowest price 92, and the other exhibition information table 93. The number of exhibitions 91 displays the total number of exhibitions by other exhibitors. In the other exhibition information table 93, information on one exhibition is displayed in one line, and a price 94, a condition 95, an exhibitor name 96, a rating number 97, and a comment 98 are displayed in one line.

  When registering the goods, the exhibition price is determined with reference to the book information and other exhibition information and input to the exhibition price input unit 99. In addition, the purchase price input unit 100 inputs the price at which the product was purchased, and the quantity input unit 101 inputs the quantity of the exhibited product. The condition and comment are input to the condition input unit 102 and the comment input unit 103, respectively. In addition, the exhibition ID display unit 104 displays a unique number for identifying the exhibited product. The exhibition ID is used by the exhibitor for product management, and is automatically set by the program. By inputting the purchase price 100, the profit can be calculated, and the sales can be managed finely.

  Thus, since the book information 73 and other exhibition information 90 are displayed on the same screen as the exhibition price input unit 99 on the warehousing registration screen, the online shop product page (FIG. 2) and the seller sales page (FIG. 3). ) Is no longer required to be opened and displayed. When all necessary information is input, when the save button 105 is pressed, the information is saved in the inventory table of the database 31. As shown in FIG. 6, ISBN, title, purchase price, quantity, condition, comment, exhibition ID, and exhibition price information are recorded in one record of the inventory table.

  When the registration is completed by pressing the save button 105, all displays are cleared, and the next exhibition item can be registered. In this way, it is possible to register the exhibited products one after another quickly. The ISBN code to be input first may be input from a keyboard. In the case of a book with a barcode (book JAN), it can be input more efficiently by inputting it with a barcode reader. Alternatively, the ISBN number may be read and input by an OCR (Optical Character Reader). When the registration of all products is completed, the close button 106 is pressed at the end to close the warehousing registration screen.

  When the warehousing registration is completed, the exhibition registration button 52 on the main screen 50 is pushed to perform the exhibition work in the online shop. In order to exhibit in the online shop, an exhibition list file including information such as ISBN, title, exhibition price, quantity, condition, and comments is required for each product. When the exhibition registration button 52 is pressed, the exhibition file creation unit 33 creates the exhibition list based on the inventory table in the database 31. The exhibition file is, for example, a CSV (comma separated values) file. When the exhibition file is created, the file may be manually uploaded to the online shop, or may be automatically uploaded when the exhibition registration button 52 is pressed. When receiving the exhibition file, the online shop server stores the information as exhibition information in the online shop database. Then, based on this exhibition information, the seller's sales page is generated.

  FIG. 8 is a flowchart showing an operation when the mail acquisition button 54 is pressed. The mail reception will be described with reference to this flowchart.

  When the mail acquisition button 54 is pressed, in step a1, the mail receiving unit 35 reads the mail to the user's mail server, determines whether there is a mail in step a2, and if there is a mail, in step a3, Judge whether it is order mail from online shop from the title of mail. If it is not an order mail, the process returns to step a1. In the case of order mail, in step a4, the text is read and registered in the order table of the database. The order mail text includes the purchaser's name, purchaser's address, purchaser's mail address, product name, and delivery note information, which are registered in the order table of the database.

  In this way, the mails in the mail server are sequentially checked, and if it is determined in step a2 that there are no mails, it is determined that all the mails in the mail server have been checked, and the mail reception process is terminated.

  When the mail reception process is completed, an order mail is sent to the purchaser. The database for the order mail is registered in the database, and when the mail reception is completed, the order mail creation unit 37 sequentially retrieves records from the order table, sets the destination as the buyer email address, and the text as the order mail text. Create and send an email. In this way, an order mail can be created and transmitted for all orders in the order table. A step of confirming by the user before sending the order mail may be provided.

  When the transmission of the order mail is finished, the delivery form print button 55 is pressed to print the delivery form. When the delivery note print button 55 is pressed, the delivery note printing unit 34 sequentially retrieves records from the order table of the database 31 and prints one delivery note for each order. A printer is connected to the PC 2, and the delivery note is printed on paper by this printer. At this time, by printing the purchaser's address and name along with the delivery note, this address and name can be used as an address label. Alternatively, the address label may be printed by printing only the address name on a separate sheet or sticker.

  When the delivery note and the address label are printed, the delivery note is packed together with the product, and the address level is pasted to prepare for the product shipment.

  Merchandise is shipped by mail or courier. Depending on the delivery method, the package number can be pasted and managed, and the package can be traced over the Internet. In other words, by notifying the purchaser of the package number and conducting a package tracking survey on the Internet, the purchaser can check when the product arrives.

  Therefore, in this embodiment, there is a function capable of adding a package number to a mail that has been sent to the purchaser after shipping the product. When the sent mail creation button 56 is pressed, a sent mail creation screen opens. In advance, a plurality of mail texts are registered in the database 31 for each shipping method to be used, and individual text numbers are assigned to the texts. The sent mail creation screen has a text selection section. When a text number is selected here, it is registered in the order table and inserted into the text of the sent mail. The shipping mail creation screen has a package number input section. By inputting the package number here, the package number is registered in the order table. This package number is inserted into the mailed mail text. For shipping methods that do not use a package number, enter only the body number without entering the package number. The package number may be entered by reading a barcode attached to the package with a barcode reader.

  Further, the selection of the body number and the input of the package number may be combined into one. For example, if the number entered in the package number input section matches the body number, the body number is registered in the order table. If there is no corresponding body number, the entered body number is determined as the package number. And register it in the order table. In this case, the text with the package number inserted in the text for the default package number becomes the text of the sent mail. In this way, the sent mail can be easily created.

  Finally, when the sent mail sending button 57 is pressed, the sent mail creating unit 40 reads the order table of the database, retrieves the text of the selected mail body number, and if there is a package number, Take out, combine them, create a mail body and insert it into the body of the mail. In addition, the purchaser's email address in the order table is inserted into the destination email address, and a dispatched email is created and transmitted. In this way, a sent mail is transmitted for all orders in the order table.

  FIG. 9 is a flowchart showing a price revision method. The price revision method will be described with reference to this figure. When the price revision button 53 is pressed, first, an inventory record is read from the inventory table of the database 31 in step b1, and the presence or absence of a record is determined in step b2. If a record exists, the ISBN of the inventory record is determined in step b3. Extract the code. In step b4, the extracted ISBN code is passed to the other exhibition information acquisition unit 32, and the product information of other sellers of the product is acquired. The product information of other sellers includes at least the seller's listing price. In the next step 5, the inventory price and the acquired other exhibition information are passed to the exhibition price determination unit 38 to determine the exhibition price. A detailed method for determining the exhibition price will be described later. In step b6, the listing price of the inventory record is rewritten with the listing price determined by the listing price determination unit 38. Then, returning to step b1, the next inventory record is taken out. In this way, the exhibition price of all stocks is changed, and if it is determined that there is no next record in step b2, the price revision process is terminated.

  When the price revision process ends, the exhibition file creation unit 33 creates an exhibition file based on the rewritten inventory table, uploads it to the online shop server 1, and performs price revision.

  FIG. 10 is a flowchart showing a first method of the price determination method. First, in step c1, the condition of the item for sale is acquired from the inventory record. In the next step c2, all prices of the same condition as the own condition are acquired from the other exhibition information. Then, in step c3, the lowest price is calculated among the exhibition prices of the same condition including its own price, and this is output.

  Using this pricing method, you can set your own listing price at the lowest price in the same condition. This makes it possible to sell quickly.

  As another form of the first method, in the above-described step c2, instead of including the own exhibition price, only the other sellers may be included, and the lowest price among the other sellers may be calculated. . Even if it does in this way, it can be set as the lowest price in the same condition as a result, and also when this lowest price is higher than own exhibition price, an exhibition price will be raised. In other words, you can increase the profit when sold.

  As yet another form, the lowest price may be calculated from all the listing prices for listing the same product. That is, the lowest price is calculated regardless of the condition. By doing in this way, it is possible to make the commodity the lowest price in any case.

  On the seller sales page of the online shop (FIG. 3), the items are displayed in ascending order of the exhibition price. Therefore, the item is displayed at the top by making it the cheapest, so that it can stand up and sell quickly. Further, instead of determining the exhibition price so as to be the lowest price, the exhibition price may be determined so as to be within a predetermined rank from the lowest price. The predetermined order is determined based on, for example, the number of items displayed on one page, and if the number of items displayed on one page is five items, the number is displayed fifth. By doing this, it will always be displayed on the first page, so it will be easy for the user who wants to purchase it and it will be easy to purchase, and the exhibition price will be high, so the profit when sold will be large can do.

  In the above-described method, the user's price is set to be the same as the lowest price. However, the price may be set to be lower by a predetermined amount, for example, 1 yen. As a result, the lowest price is not lined up at the same price, but only oneself is the lowest price. The predetermined amount to be reduced is not limited to 1 yen, but may be changed according to the price. For example, if the exhibition price is less than 500 yen, it may be changed according to the exhibition price, such as 1 yen, 500 yen or more, and 10 yen if less than 1000 yen. The price may be lowered by rounding down the fraction.

  Next, a second method of price determination will be described. This second method sets prices in more detail according to the situation. The status is various information such as the sales ranking of the product, the number of exhibited products, the shipping time, whether or not the online shop is in stock, in addition to the condition of the product. Then, from the situation, the optimal price is set such that the price is not lowered when it is determined that the product can be sold without being reduced, and the lowest price is determined when it is determined that the product will remain unsold unless it is sold quickly.

  Then, five patterns A to E are set as price revision patterns according to the situation. The following shows examples of the situation of the four price revision patterns and the operation at that time.

Pattern A
Situation: No other points. Online shop out of stock or shipping time more than 4 weeks Operation: Price increase. For example, 1.5 times the current price.
Pattern B
Situation: Ranking is less than 10,000. Within 5 items. Not in stock or shipping time is more than 4 weeks.
Operation: No price change.
Pattern C
Situation: Ranking is more than 10,000 and less than 100,000.
Operation: Set to the lowest price in the same condition.
Pattern D
Situation: Ranking more than 100,000 and less than 200,000.
If your condition is “Yes”, set the lowest price among the listed items. If you are not “OK”, set the lowest price among the items listed other than “Yes”.
Pattern E
Situation: A ranking of 200,000 or more, or a predetermined period or more, for example, a half year or more after listing
Action: The lowest price among all listings.

FIG. 11 is a flowchart showing a second method of price determination. The second price determination method will be described based on this flowchart. First, at step d1, the ISBN code of the exhibited product is passed to the product information acquisition unit 38, and the product information is acquired. As described above, this product information includes information such as the sales ranking of the exhibited product, the shipping time, and the presence / absence of inventory at the online shop.

  In the next step d2, it is determined based on the acquired product information and the other seller information acquired in advance which pattern A to D is applied. In step d3, the exhibition price is calculated based on the determined pattern.

  In this way, an optimal exhibition price can be set according to the situation. As elements for price determination, not only the above-mentioned sales ranking and shipping time but also, for example, genre, publisher, issue time, exhibitor name, etc. may be used. For example, if the genre is “Law”, if a predetermined period (three years) has passed since the year of publication, set the price revision pattern so that the listing price will be cheap, or if it is a novel book If the paperback book is published, the price revision pattern will be cheaper.

Also, if you know that certain publishers or series are less likely to fall in price, use a price revision pattern that revises the price higher, or is out of stock (or shipped out) in a particular series. In the case of 4 weeks or more), the price may be set to be double or triple the regular price.

Also, once the price has been raised, record the date and time of the price increase, and set the price not to increase again if it has not passed for a predetermined period, for example, more than half a year, to prevent the price from rising sharply. Can do.

  Further, the price determination pattern may be changed depending on the seller who sells the lowest priced product. For example, if a particular seller is at the lowest price, such as a seller who tends to drastically reduce prices, or if a novice seller is at the lowest price, ignore the lowest price and determine the price. Also good. Whether you are a beginner can be judged by the number of evaluations. If there is no evaluation yet, or if it is a single digit, it is judged as a beginner.

  Also, when the difference between the lowest price and the next cheapest price is extremely large, or when the price cut is more than a predetermined value, for example, more than half of the current price, this lowest price may be ignored. . As a result, it is possible to prevent a significant drop in price.

  In addition, when the postage of the exhibitor can be individually determined, the price may be changed based on this. For example, the shipping cost of the exhibitor is discounted when orders are placed together, such information is read from, for example, a comment, and the price is changed accordingly.

  Such price revision work may be performed only when the price revision button 53 is pressed, or may be performed at a time determined by a timer. For example, once a day or twice a day, the price may be revised every day at a fixed time, or once a week, once a month, and only for products that cannot be sold for a certain period of time, such as 3 months or more. The price may be selected and revised. Furthermore, not only the price revision work but also a series of work of mail acquisition, order mail transmission, and delivery note printing may be executed every initial time, for example, every 30 minutes.

  In the above-described embodiment, the online shop exhibition support apparatus is configured to be executed by the PC 2 as a client. However, the present invention is not limited to such a form, and may be configured by a server and a client. For example, the functions of the above-described embodiments may be realized by a server and operated and displayed with a client operated by a user. As a result, information on a plurality of exhibitors can be centrally managed by the server. The client side displays and operates only information related to its own listing.

  The online shop support program 30 of the present invention is recorded and distributed on a recording medium such as a CD or DVD, and may be installed and executed on a PC, stored on a server, and distributed via a network such as the Internet. May be.

As described above, the online shop exhibition support apparatus of the present invention can automatically perform the exhibition work to the online shop, the price revision work, the e-mail transmission to the purchaser, the invoice printing, etc. that have been manually performed until now. It is possible to remarkably reduce the work of individuals or merchants who exhibit in the online shop.

It is a network diagram which shows the environment where the online shop assistance apparatus of this invention is applied. It is a figure which shows the goods page of an online shop. It is a figure which shows a seller's sales page. It is a block diagram of an online shop support program. This is the main screen of the online shop support program. It is a figure which shows the content of the database. It is a figure which shows a warehousing registration screen. It is a flowchart which shows operation | movement when a mail acquisition button is pushed. It is a flowchart which shows the price revision method. It is a flowchart which shows the 1st method of price determination. It is a flowchart which shows the 2nd method of price determination.

Explanation of symbols

1 Online shop 2 PC
3 network
30 Online shop exhibition support program
31 database
32 Other exhibition information acquisition part
34 Invoice Printing Department
35 Mail receiver
36 Mail sending part
37 Order Mail Creation Department
38 Exhibit Price Determination Department
39 Product Information Acquisition Department
40 E-mail creation department

Claims (4)

An online shop listing support apparatus that is connected to a server of an online shop that sells a plurality of products via a network and supports a seller who sells products to the online shop,
In the online shop, a plurality of sellers can sell a single product. For a single product, product specifying information for specifying the product, a seller who sells the product, and the seller Display the related listing price of
The online shop exhibition support device has an exhibition information storage means for storing product specifying information of a plurality of exhibition products that the exhibitor is exhibiting,
Other exhibition information acquisition means for acquiring an exhibition price of other sellers who sell the product based on the product specification information stored in the exhibition information storage means;
An online shop exhibition support apparatus, comprising: an exhibition price determination unit that determines an exhibition price of an item for sale based on the exhibition price acquired by the other exhibition information acquisition unit. An online shop listing support device that is connected to a server of an online shop that sells a plurality of products via a network and supports a seller who sells products to the online shop,
The online shop allows a plurality of sellers to sell a single product, and when the sold product is sold, it sends an exhibition product sales end email including the buyer's email address to the seller,
The online shop exhibition support device is configured to send an email to a purchaser based on the received exhibition product sales end email,
An online shop exhibition support apparatus, comprising: a printing unit that prints a delivery slip to be sent to a purchaser together with a product based on the sale product sales end mail. An online shop listing support apparatus that is connected to a server of an online shop that sells a plurality of products via a network and supports a seller who sells products to the online shop,
In the online shop, a plurality of sellers can sell a single product. For a single product, product specifying information for specifying the product, a seller who sells the product, and the seller Display an associated listing price, receive from the seller a list of listings that pair the product identification information with the listing price of the product, store it,
The online shop exhibition support device, when the product specifying information is input, other exhibition information acquisition means for acquiring and displaying the exhibition price of other sellers who exhibit the product,
An online shop exhibition support apparatus, comprising: an exhibition list creating means for creating an exhibition list in combination with product specifying information when an exhibition price is input. An online shop listing support program that is executed by a computer connected via a network to a server of an online shop that sells a plurality of products, and that assists sellers who sell products in the online shop,
In the online shop, a plurality of sellers can sell one product. For one product, product specifying information for specifying the product, an exhibitor who sells the product, and presentation of the seller Display the related listing price
The online shop exhibition support program stores product identification information of a plurality of items for sale that are exhibited by the seller himself,
Based on the stored product identification information, obtain the listing price of other sellers of the listing product,
An online shop listing support program characterized in that the listing price of one's listing product is determined based on the acquired listing price.

Images