JP6650638B1 - Purchase history management device - Google Patents

Abstract

An object of the present invention is to provide a purchase history management device capable of listing the histories of products purchased from a plurality of online shops and quickly obtaining useful information when making a new purchase. A purchase history management device obtains electronic mail distributed to a user from a plurality of online shops via the Internet, and extracts a plurality of pieces of information related to product purchase from the obtained electronic mail. There are means for storing a plurality of information in the purchase history database, and means for extracting information on a plurality of online shops from the purchase history database in response to a request from the user, and presenting the information so that the user can list it. [Selection diagram] FIG.

Description

  The present invention relates to a purchase history management device for managing products purchased by a user from an online shop.

  2. Description of the Related Art In recent years, so-called online shopping, which buys and sells goods and services by electronic information communication on a computer network, has become essential in daily activities, regardless of individuals or corporations.

  Some of the typical online shopping sites offer mail-order sales in the form of multiple stores, that is, a shopping mall that collectively handles products from various stores. There are many such online shopping malls on the Internet.

  On the other hand, instead of online shopping malls, there are many individual online shops that have their own order settlement systems. Some of these online shops have gained access by posting on price comparison websites.

JP 2013-137598 A

  For online shopping sites, the purchase history of individual users is a very effective source of information for sales promotion. Many online shopping sites use this purchase history for the purpose of recommending products that the user is likely to purchase (Patent Document 1).

  On the other hand, the purchase history is very helpful information for the user. Online shopping sites provide a function that allows users to search and display past purchase histories in consideration of user convenience. This is very convenient, and if the user wants to purchase a previously purchased product again, he / she can quickly purchase the product.

  However, many users often use several malls and shopping sites instead of a single online shopping mall. Therefore, for companies and heavy users, courier companies deliver goods from different sites almost every day.

  In such a case, the user needs to display a purchase history for each of the plurality of shopping sites in order to check past purchases. This takes time. In addition, a small shopping site that does not provide information on past purchase history may be used. In some cases, you may forget such a shopping site and lose track of where you purchased it.

  Therefore, an object of the present invention is to provide a purchase history management device that can list the histories of products purchased from a plurality of online shops and can quickly obtain useful information when making a new purchase.

In order to solve the above-mentioned problems, a purchase history management device according to one aspect of the present invention includes: means for acquiring a message delivered to a user from a plurality of online shops via the Internet; Means for extracting a plurality of pieces of information related to purchase and storing the plurality of pieces of information in a purchase history database, and extracting information related to a plurality of online shops from the purchase history database in response to a request from the user; Means for presenting the information so that the user can list the information, and the request from the user presents the result of searching for a plurality of pieces of extracted information regarding the purchase of the product with a specified keyword so that the user can list the information. Request to sort the search results by price. Viewing including the door, wherein the plurality of online shops, and online shop the sender of the reply mail is registered in advance, it consists of an online shop that is not registered, mail from the online shop that has not been the registration is acquired At that time, by analyzing the contents and searching for the keywords and expressions included in the general reply mail, we tried to extract the product purchase data located near those keywords and expressions, and the product purchase data was extracted In this case, the information is stored in the purchase history database as a plurality of pieces of information on the purchase of the product .

  In a preferred embodiment, the purchase history management device is a purchase history management server that is connected to the Internet and implements the purchase history database, and the means for acquiring the message includes a mail client function of the purchase history management server. And acquiring an electronic mail as the message by accessing a mail server connected to the Internet.

  Further, in a preferred embodiment, the means for presenting information on the plurality of online shops is implemented as a Web server function of the purchase history management server, and based on the content of the purchase history database, information on the plurality of online shops is provided. It is presented as a Web page.

  ADVANTAGE OF THE INVENTION According to the purchase history management apparatus concerning this invention, the history of the goods purchased from several online shops can be listed, and useful information at the time of a new purchase can be obtained quickly.

FIG. 1 is a network diagram for explaining an embodiment of a purchase history management service provided by the purchase history management server 1 according to the first embodiment of the present invention. FIG. 2 is a table constituting the purchase history database according to the first embodiment of the present invention, and shows an order table in which one order is one record. FIG. 3 is a table constituting the purchase history database according to the first embodiment of the present invention, and shows a purchased product table in which one purchased product is one record. FIG. 4 is a flowchart illustrating a process in which the purchase history management server 1 according to the first embodiment of the present invention updates a purchase history database. FIG. 5 is a diagram illustrating an example of an e-mail to be analyzed by the purchase history management server 1 according to the first embodiment of the present invention. FIG. 6 illustrates a Web page displayed as an initial screen including a purchase history list when accessing the purchase history management server 1 according to the first embodiment of the present invention. FIG. 7 shows a Web page displayed as a result of searching the list of purchase histories with the keyword “paper A4” in the purchase history management server 1 according to the first embodiment of the present invention. FIG. 8 shows a Web page after the search results have been sorted by the purchase history management server 1 according to the first embodiment of the present invention.

  Hereinafter, an embodiment of a purchase history management device according to the present invention will be described with reference to the accompanying drawings. In the following embodiment, when a product is purchased at an online shop, a reply message (confirmation of the product purchase) is sent by e-mail. However, if the reply message is sent by other message means such as SMS or LINE instead of e-mail, it can be implemented in exactly the same way.

  The purchase history management device of this embodiment is mounted as a purchase history management server that provides a purchase history management service to a user by connecting to the Internet.

  FIG. 1 is a network diagram for explaining an embodiment of a purchase history management service by the purchase history management server 1. Here, in addition to the purchase history management server 1, a plurality of online shop servers 5, mail servers 7, and a personal computer 3 used when a user purchases a product from the online shop are connected to the Internet. I have. A user using this purchase history management service uses a plurality of online shops on the Internet, and registers personal information including electronic mail information in each online shop.

  In addition, in order to use the purchase history management service, the user registers in advance in the purchase history management server 1 account information of an e-mail used for purchasing a product at each online shop. This account information includes a user ID and a password, and the purchase history management server 1 can freely acquire an e-mail to the user.

  The purchase history management server 1 includes a purchase history database described later, and stores and manages the history of product purchase data in the online shop for each user.

  The user is, for example, a corporation, and in that case, there are generally a plurality of persons in charge of product purchase for one corporation. Therefore, a plurality of e-mail accounts used for purchasing goods are also registered, and the information on the purchase of goods to the plurality of e-mails is handled as the information of the corporate user.

  In order to purchase a product, the user logs in to the Web site distributed by the online shop server 5 from the personal computer 3, for example, and applies for product purchase. In response to this, the online shop server 5 sends a reply e-mail to the registered e-mail address indicating that the application for purchase of the merchandise has been accepted. This e-mail is transmitted to the user's personal computer 3 via the mail server 7. The e-mail is stored in the mail server 7 for a certain period.

  The purchase history management server 1 periodically accesses the mail server 7 to obtain an e-mail addressed to this user. Then, the product purchase data is extracted from the content of the e-mail, and the purchase history database is updated.

  2 and 3 show two tables constituting the purchase history database. FIG. 2 shows an order table in which one order is one record, and FIG. 3 shows a purchased item table in which one purchased item is one record.

  The order table includes fields of a domain name, an order number, a user ID, an order e-mail address, an order date, a shipping fee, a total amount, and a payment method. The domain name is the domain name of the online shop where the order was placed. The order number is an identification number assigned to the order in this online shop. The user ID is a user ID of the purchase history management service. The order e-mail address is the e-mail address of the user who has made this order (the destination address of the reply e-mail). The order date is the date and time when this order was placed. Shipping is the shipping charged for this order. The total price is the total price of the products purchased in this order.

  The values of the fields in each of the above tables are obtained by analyzing the reply mail from the online shop. The reply mail from the online shop has a fixed format determined for each online shop. The reply mail analysis program of the purchase history management server 1 is provided with a subroutine created in accordance with the fixed form of the main online shop, and the subroutine extracts the values of the fields of the above tables. For example, a character string representing a numerical value following a space after the first character string “total” searched from the beginning of the sentence is extracted as the total amount. In addition, these main online shops are called registration sites.

  FIG. 4 is a flowchart illustrating a process in which the purchase history management server 1 updates the purchase history database. First, the purchase history management server 1 accesses the mail server 7 as a mail client and acquires an e-mail addressed to the user (step S1). The sender of the obtained e-mail is confirmed, and it is determined whether or not the site is a registered site (step S2). If it is a registered site, the corresponding subroutine extracts the merchandise purchase data, that is, the values of the fields of the respective tables (step S3). Then, the purchase history database is updated with the product purchase data (step S4).

  In step S2, if the source of the acquired e-mail is not a registered site, the contents of the acquired e-mail are analyzed to determine whether the e-mail is a reply mail of the online shop. To do so, it analyzes the contents of the e-mail, searches for keywords and expressions included in general reply mails, and tries to extract product purchase data (step S5).

  For example, keywords such as “order number” and “order number” are searched from the content of the e-mail, and if there is a subsequent number, it is assumed to be the value of the order number. In addition, if there is a name of a certain product following the keywords “product name” and “order details”, it is assumed that the name is a product name. The values of other fields are also obtained by the same analysis.

  If the product purchase data is successfully extracted, it is determined to be a reply mail from the online shop. Then, the purchase history database is updated with the product purchase data (step S4). If the extraction of the merchandise purchase data fails, it is determined that the e-mail is not a reply mail of the merchandise purchase, and the process is terminated (step S6).

  In step S5, even if the values of some fields are not obtained even by analyzing the contents of the e-mail, if it can be determined that the mail is a reply mail from the entire contents, it is estimated that the mail is a reply mail. Reflect the contents in the purchase history database. For example, if the content of the e-mail is as shown in Fig. 5, a character string such as "Order received" or "Thank you" or "Order", "Purchase", or "Product" Keyword exists. This can be a side evidence that the mail is a reply mail. In this case, the values of some of the fields not obtained are left blank.

  In the above embodiment, the reply mail processed by the purchase history management server 1 may be limited to the reply mail transmitted from the registration site. In this case, when a purchase is made at a site other than the registration site, the merchandise purchase data (field values) is manually input on a dedicated web page of the purchase history management server 1.

  The contents of the input product purchase data are compared with the original reply mail to determine the data position procedure. For example, if the input product name (field value) is the word after the second “product” from the beginning of the email, the combination of “product” and “2” is the parameter that determines the procedure. Become. That is, in this procedure, "commodity" is searched twice from the beginning of the sentence, and a word immediately following the second "commodity" across a space or symbol is acquired as a product name.

  After the procedure is determined in this way, this site is thereafter treated as a registration site for the entire purchase history management service. Therefore, even if the site is used for the first time, if another user has already used and registered, it can be automatically reflected in the purchase history database. In addition, the procedure can improve the accuracy of automation by using machine learning and AI.

  Next, a procedure when the user uses the purchase history management service will be described. The purchase history management server 1 functions as a Web server, and provides information on a user's purchase history as a Web page based on information stored in a purchase history database.

  First, using a terminal such as a personal computer 3 or a smartphone, the user logs in to the purchase history management server 1 on the Internet. At that time, the user ID and password registered in the purchase history management server 1 are used.

  When the user logs in to the purchase history management server 1, first, a Web page as shown in FIG. 6 is displayed on the screen of the personal computer 1 of the user. Here, a list of products purchased by the user in the past is displayed. As the initial screen, the displayed purchased items are arranged in a new order.

  Here, when a purchased product is searched by a keyword, displayed products can be narrowed down. In the example of FIG. 7, the result of the search using the keyword “paper A4” is shown. Also, as shown in FIG. 8, when the sorting is changed to “low-price order”, the order is displayed in ascending order of price. In addition, it is possible to narrow down by the place of purchase or by purchase for a designated period. However, since the technique is generally well-known, the details are omitted.

  Note that, in a company, an employee other than the person in charge may purchase a product from the online shop using his / her own email address. However, since it is not the registered address of the purchase history management server 1, the purchase history management server 1 cannot reflect this purchase in the purchase history database.

  Therefore, the purchase history management server 1 is provided with an e-mail address for accepting such an exceptional purchase and reflecting it in the purchase history database. The employee other than the person in charge transfers the reply mail of this online shop to this mail address of the purchase history management server 1. Then, the purchase history management server 1 processes the transferred reply mail in the same manner as the reply mail addressed to the registered mail address, and updates the purchase history database.

  In the first embodiment, the purchase history management device is implemented by the purchase history management server, but in the second embodiment, the purchase history management program implemented in the user's terminal such as the personal computer 1 or the smartphone manages the purchase history. Is performed.

  In this embodiment, the purchase history management program mounted on the user's terminal accesses the mail server 7 using the user ID and the password of the e-mail used for purchasing the goods at the online shop, which is set in advance. Get email. Therefore, since the same operation as that of the mailer is performed, the purchase history management program may be implemented as a part of the function of the mailer.

  In the purchase history management program, a purchase history database equivalent to the purchase history management server 1 described with reference to FIGS. 2 and 3 in the first embodiment is provided. In the first embodiment, the purchase history database is updated using the process described with reference to FIG. Further, a screen equivalent to that shown in FIGS. 5 to 7 is displayed, and a list of products purchased by the user in the past is displayed on the personal computer 1 or the smartphone.

  In the first and second embodiments, the merchandise purchase data is extracted from the reply mail transmitted after the merchandise is purchased in the online shop. However, the required product purchase data is also included in the order completion screen displayed immediately after product purchase. In the third embodiment, when a product is purchased, information on the order completion screen is transmitted to the purchase history management server, and the purchase history management server analyzes the received order completion screen and extracts product purchase data. Subsequent processing is the same as in the first and second embodiments.

  In one implementation, an order completion screen transmission program is implemented as a browser add-on. This add-on adds a send button to the browser. If this transmission button is clicked while the browser is displaying the order completion screen, information on the order completion screen is transmitted to the purchase history management server. Upon receipt of the order completion screen, the purchase history management server analyzes this, extracts product purchase data, and updates the purchase history database as in the first and second embodiments. Further, the purchase history management server displays a screen equivalent to that shown in FIGS. 5 to 7 on the personal computer 1 or the smart phone in response to the user's access, and displays a list of the products that the user has purchased in the past. Is presented.

  As described above, according to the purchase history management apparatus of the present invention, it is possible to list the histories of the products purchased from a plurality of online shops, and to quickly obtain useful information when making a new purchase.

1 Purchase history management server 3 Personal computer 5 Online shop server 7 Mail server

Claims (3)

Means for obtaining messages delivered to users from multiple online shops via the Internet,
Means for extracting a plurality of pieces of information related to product purchase from the obtained message, and storing the plurality of pieces of information in a purchase history database;
In response to a request from the user, from the purchase history database, extract information about a plurality of online shops, and comprises means for presenting the user so that it can be listed,
The request from the user is a request for presenting a plurality of extracted information related to the purchase of goods for a specified keyword, so that the user can list the search result, and the search results are arranged in order of price. the request and seeking to sort seen including,
The plurality of online shops include an online shop in which the source of the reply mail is registered in advance and an unregistered online shop,
When an e-mail from the unregistered online shop is obtained, the contents are analyzed and the keywords and expressions included in the general reply e-mail are searched to locate them near the keywords and expressions. An attempt is made to extract merchandise purchase data, and when merchandise purchase data is extracted, a plurality of pieces of information related to the merchandise purchase are stored in the purchase history database . The purchase history management device is a purchase history management server connected to the Internet and implementing the purchase history database,
Means for acquiring the message is implemented as a mail client function of the purchase history management server, according to claim 1, by accessing the mail server connected to the Internet and obtains the electronic mail as the message purchase history management device. The means for presenting information about the plurality of online shops is implemented as a Web server function of the purchase history management server, and presents information about the plurality of online shops as a Web page based on the contents of the purchase history database. The purchase history management device according to claim 2, wherein

Images