TWI489402B - Method and apparatus for adjusting foreground class of e - commerce website - Google Patents

Description

Method and device for adjusting foreground category of e-commerce website

The present invention relates to the field of electronic commerce, and more particularly to a method and apparatus for adjusting a foreground category for a large e-commerce website.

The current merchandise categories of e-commerce sites include: foreground categories and back-end categories. Among them, the background category refers to the multi-level commodity category relationship recorded in the transaction flow of the e-commerce website, which is used for transaction classification statistics and is relatively stable. For example, the upper-end background category "mobile phone" can also include background categories such as "Nokia Nokia mobile phone", "domestic mobile phone", "Samsung mobile phone", etc., thereby forming a multi-level product category.

The foreground category refers to the multi-level product category relationship displayed on the product presentation page of the e-commerce website, and is used for web page presentation guidance. Usually, the foreground category can be composed of one or more background categories, and can be adjusted by the operation manager to be flexible. For example, you can put "Nokia mobile phone", "domestic mobile phone", "Samsung mobile phone" in the background category into the foreground category of "hot mobile phone", and guide the user through the foreground category of "hot mobile phone". Go to the corresponding product page.

At present, the e-commerce website's log system can generally collect user clicks on various pages, including category pages, product pages, etc.; the back-end Oracle ORACLE database of e-commerce websites can generally retain all user transaction records.

However, at present, the operation management personnel can only see the overall transaction status of the e-commerce website and the transaction status of various commodities, but it is impossible to know which front-end category the user has browsed to the product information. That is to say, the organizational structure of the foreground category is reasonable, and whether it can display various types of products to users well, thereby increasing the volume of goods. Therefore, there is an urgent need for a tool to check which foreground category adjustments, including changes or redefinitions, can achieve more significant results to guide operations.

The embodiment of the invention provides a method and a device for adjusting the foreground category of an e-commerce website, which can adjust the foreground category according to actual conditions, obtain a good product display effect, and improve the transaction volume of the commodity.

A method for adjusting a foreground category of an e-commerce website, comprising: obtaining a transaction record of each background category in a set period of the back-end database record of the e-commerce website, determining a user who purchases goods in each background category; and finding the user The foreground category that is clicked during the set period; the number of times each foreground category is clicked by the user is separately counted; the foreground category structure is re-adjusted according to the statistical result.

According to the above method of the present invention, the lookup of the foreground category that the user clicks during the set period specifically includes: determining a user ID of the user according to the transaction record, and acquiring a set period of the log system record of the e-commerce website. All the users click on the click status record of each foreground category, and according to the user ID and the click status record, determine the foreground category that the user clicks in the set period; or when the user purchases the goods in the background category, The foreground category that the user clicks is determined according to the user access path, and the foreground category that the user clicks in the set period is directly determined.

According to the above method of the present invention, each foreground category includes at least one background category, and each background category belongs to at least one foreground category.

According to the above method of the present invention, after the re-adjustment of the foreground category structure according to the statistical result, the method further comprises: counting the total transaction volume of the commodity in the e-commerce website in the next set period, and verifying the total transaction volume by statistics. The adjusted foreground category structure.

A front-end category organization device for an e-commerce website, comprising: a determining module, configured to obtain a transaction record of each background category in a set period of the back-end database record of the e-commerce website, and determine to purchase goods in each back-end category a search module, configured to search for a foreground category determined by the determining module and clicked by the user during the set period; and a statistical module, configured to separately count the number of times each foreground category is clicked by the user; The adjustment module is used to adjust the foreground category structure according to the statistical result.

According to the above apparatus of the present invention, the search module includes: a first search unit and a second search unit; the first search unit is configured to determine a user ID of the user according to the transaction record; and acquire the e-commerce website During the set period recorded by the log system, all users click on the click status record of each foreground category; then, according to the user ID and the click status record, the foreground category that the user clicks in the set period is determined; the second search unit, When the user purchases the product in the background category, the foreground category that the user clicks is determined according to the user access path, and the foreground category that the user clicks in the set period is directly determined.

The device of the present invention further includes: a verification module, configured to calculate a total transaction volume of the commodity in the e-commerce website in the next set period, and verify the adjusted foreground category structure by the total transaction volume.

The method and device for adjusting the foreground category of the e-commerce website provided by the embodiment of the present invention determine the purchase of the goods in each background category by obtaining the transaction records of the background categories in the set period of the background database record of the e-commerce website. The user searches for the foreground category that the user clicks during the set period; separately counts the number of times each foreground category is clicked by the user; and adjusts the foreground category structure according to the statistical result. Through the above method, the related data of the foreground category click status and the background category transaction status are obtained, and the influence of the foreground category on the background transaction is counted, and the decision support is provided for the scientific and reasonable organization of the foreground category relationship of the e-commerce website; As a result, an organizational structure of a more optimized foreground category can be obtained. The optimized front-end category organization structure can better guide users to browse various products displayed on the website and increase the transaction volume of the website products.

The foreground category adjustment method of the e-commerce website provided by the embodiment of the present invention is as shown in FIG. 1 , which associates the user's click status of the foreground category of the e-commerce website with the transaction status of the goods in the background category, and searches for The front-end categories that the users who purchased the products in each background category clicked on, and then counted the number of times each front-end category was purchased by the user in the corresponding background category, thereby determining the number of clicks in the foreground category to the background. The extent of the impact of commodity transactions in the category. Among them, each background category corresponds to a commodity.

The method of the present invention is applied to the system shown in FIG. 2, which may include the client terminal 11, the server 10, and the backend repository 12 of the e-commerce website foreground. The background database 12 may be disposed in the server 10 or may be disposed in a separate server. The client 11 captures the user's click status and transmits it to the server 10; the background database 12 records the transaction status of the goods in the background category. The invention realizes the association between the click status of the foreground category of the e-commerce website and the transaction status of the goods in the background category through the server.

Each foreground category includes at least one background category, and each background category belongs to at least one foreground category.

A list of the foreground category and the background category are stored in the server, and a foreground category is associated with the background category included in the server, and each backend category and the foreground category to which it belongs are also said. A mapping relationship is established between the backend categories that can be associated with the included backend category when the foreground category is clicked.

For example: the foreground category "hot phone" can include the background category "Nokia mobile phone", "Samsung mobile phone", "domestic mobile phone", etc., that is, the foreground category "hot mobile phone" and the background category "Nokia mobile phone", "Samsung There is a mapping relationship between mobile phones and domestic mobile phones.

The foreground category "promotional mobile phone" may include the background category "domestic mobile phone", "Nokia mobile phone", etc., that is, the foreground category "promotional mobile phone" is mapped with the background category "domestic mobile phone" and "Nokia mobile phone" respectively. relationship.

The foreground category "hot camera" can include the background categories "Sony Camera", "Kodak Camera", "Samsung Camera", etc., that is, the foreground category "Top Camera" and the background category "Sony Camera", "Kodak Camera" respectively. There is a mapping relationship between "Samsung Camera".

The foreground category "Promotion Camera" may include the background category "Sony Camera", "Samsung Camera", etc., that is, the foreground category "Promotion Camera" is established between the background category "Sony Camera" and "Samsung Camera", respectively. Mapping relations.

The implementation process of the embodiment of the present invention is as shown in FIG. 3, and the execution steps are as follows: Step S101: Acquire a transaction record of the commodities in each subsequent category in the set period of the background database record of the e-commerce website.

The back-end ORACLE database of the e-commerce website stores the purchase records of the products in each background category, wherein each record contains at least the background category to which the purchased product belongs and the user who purchased the product and the corresponding user ID. .

Step S102: Determine a user who purchases goods in each background category.

Since the transaction record contains user information such as the user ID, it is easy to determine the user who purchased the products in each background category.

Step S103: Find the foreground category that the user who purchased the products in each background category clicks within the set period. The following two situations are included:

(1) After obtaining the transaction record of the set period, the user ID matches all the users recorded in the foreground log system in the set period to click the record of the click status of each foreground category to determine the user who purchases the products in each background category in the set period. The foreground category of the click inside. Specifically include:

(i) Obtaining a click record of all the users in the foreground category during the set period of the log system record of the e-commerce website.

The log system of the e-commerce website can record the click status of each foreground category by the user. Among them, the click status record at least includes the user ID of each foreground category.

(iii) determining, according to the determined user ID and the obtained click status record, the foreground category that the user who purchased the products in each background category clicks within the set period.

Among them, the order of execution of (i) and (ii) is in no particular order.

(2) When the user purchases the goods in the background category, the foreground category that the user is currently viewing is recorded. Specifically, according to the access path of the user recorded in the address bar of the e-commerce website, the foreground category that the user browsed (ie, clicked) when purchasing the product is determined, thereby directly determining the foreground class that the user clicks in the set period. Head.

Step S104: respectively count the number of times the user of each foreground category is purchased by the user in each background category.

It is counted that the number of times the user who purchased the products in each background category clicks on the foreground category A1 is x1; the number of times the user who purchased the products in each background category clicks on the foreground category A2 is x2; The number of times the user of the item in the category clicks on the foreground category A3 is x3;

Step S105: Adjust the foreground category structure according to the statistical result.

According to the statistical results, the influence of each foreground category on the commodity transactions in the background category is analyzed. According to the analysis results, the organizational structure of the foreground category is re-planned and adjusted, and the optimized foreground category organization structure is obtained.

Reorganizing the organizational structure of the foreground category can include: adding or less foreground categories, and adding or subtracting included backend categories in existing foreground categories.

For example, when there is a large number of clicks in a foreground class and a large volume is generated for the products in the included background category, other background categories related to the background categories included above may be added to the In the foreground category, to increase the volume of goods in other background categories, the mapping relationship between the other background categories and the foreground category is established.

When the number of clicks in a foreground class is relatively small, and the volume of the goods in the included background category is relatively small, the background category included in the part can be deleted, and the deleted background category is added to other foreground categories. In order to increase its trading volume. Deleting the background category contained in the foreground category essentially removes the mapping between the two.

When there is a large number of clicks in a certain foreground category used by a certain category of products, and the volume of the goods in the included background category is relatively large, you can refer to the foreground category to increase the items of other categories. The corresponding foreground category. For example, the foreground category "hot phone" has a large number of clicks. When the volume of the products in the background category of the included mobile phone category is relatively large, you can refer to this mode as other categories of products such as laptops. Products, add the appropriate foreground categories, such as "hot laptops" and so on.

After reorganizing the foreground category structure according to the statistical result, the verification process may also be included: verifying whether the optimized foreground category organization structure improves the transaction volume.

The total transaction volume of the e-commerce website in the next set period is counted, and the reorganized foreground category structure is verified by the total transaction volume, whether the better display effect is achieved and the transaction volume is improved.

The following is a detailed example through a specific example, the specific process shown in Figure 4, including the following steps:

Step S201: Obtaining the purchase record of the goods in the saved background category from the background database of the e-commerce website is as follows: background category: domestic mobile phone, purchaser is user 3, user ID is ID3; background category: Nokia mobile phone, The purchaser is user 2, the user ID is ID2; the background category: Nokia mobile phone, the purchaser is user 4, the user ID is ID4; the background category: Nokia mobile phone, the purchaser is user 1, the user ID is ID1; the background category : Sony camera, the purchaser is user 8, user ID is ID8; background category: Sony camera, purchaser is user 7, user ID is ID7; background category: Samsung camera, purchaser is user 5, user ID is ID5 Backstage category: Samsung camera, purchaser is user 6, user ID is ID6; background category: Samsung camera, purchaser is user 9, user ID is ID9;

Step S202: determining that the user who purchased the products in the background category involved in the acquired purchase record is as follows: the user who purchases the goods in the background category “domestic mobile phone” has the user 3; the product in the purchase background category “Nokia mobile phone” There are user 1, user 2 and user 4; the user of the back-end category "Sony Camera" has the user 7 and the user 8; the purchase of the product in the background category "Samsung Camera" has the user 5, the user 6 and the user 9; ......

Step S203: Search for the foreground category that the determined user clicks in the set period.

For example, the first mode given in the above step S103 is adopted: the user ID matches all the click records recorded by the front-end log system in the set period, and the determined user clicks in the set period. The foreground category.

(i) The click record of all users clicking each foreground category in the set period obtained from the log system of the e-commerce website is as follows: Click the user ID of the foreground category "Top Phone": ID3, ID4, ... IDm; The user IDs of the foreground category "promotional mobile phone" are: ID1, ID2, ID3, ID4...IDn; the user IDs of the foreground category "hot camera" are: ID5, ID7, ID8...IDk; click on the foreground category" The user ID of the promotional camera is: ID5, ID6, ID8, ID9...IDj;......

(ii) Determine the user ID of the product purchased in each background category as follows: the user ID corresponding to the user who purchases the product in the background category "domestic mobile phone" has ID3; the user who purchases the product in the background category "Nokia mobile phone" The corresponding user IDs include ID1, ID2, and ID4; the user ID corresponding to the user who purchases the product in the background category "Sony Camera" has ID7 and ID8; and the user corresponding to the user who purchases the product in the background category "Samsung Camera" ID has ID5, ID6 and ID9;......

(iii) determining, according to the determined user ID and the obtained click status record, the foreground category that the user who purchased the products in each background category clicks in the set period, as follows: determining that the user 1 purchases according to ID1 The product in the background category "Nokia mobile phone", and clicked the foreground category "promotional mobile phone" in the set period; according to ID2, it is determined that the user 2 purchased the product in the background category "Nokia mobile phone", and In the set period, the foreground category "promotional mobile phone" is clicked; according to ID3, it is determined that user 3 purchases the product in the background category "domestic mobile phone", and in the set period, the foreground category "promotional mobile phone" and "hot" are clicked. According to ID4, it is determined that the user 4 purchases the product in the background category "Nokia mobile phone", and clicks the foreground category "promotional mobile phone" and "hot mobile phone" in the set period; the user 5 purchase is determined according to the ID5 The item in the background category "Samsung Camera", and in the set period, clicked the foreground category "Promotion Camera" and "Top Camera"; according to ID6, it is determined that User 6 has purchased The item in the category "Samsung Camera", and clicked the foreground category "Promotion Camera" in the set period; according to ID7, it is determined that the user 7 purchased the item in the background category "Sony Camera", and in the setting During the period, the foreground category "hot camera" was clicked; according to ID8, it was determined that user 8 purchased the item in the background category "Sony Camera", and in the set period, the foreground category "promotional camera" and "hot camera" were clicked. According to ID9, it is determined that the user 9 purchased the product in the background category "Samsung Camera", and clicked the foreground category "Promotion Camera" within the set period;

For example, in the second manner given in step S103, when the user purchases the product in the background category, the user is directly determined according to the access path of the user recorded in the address bar of the e-commerce website. The foreground category of the click inside is as follows: For example, when user 1 purchases the product in the background category "Nokia mobile phone", the front-end category "promotional mobile phone" is browsed; user 2 purchases the background category "Nokia mobile phone". The goods, the front-end category "promotional mobile phone"; user 3 purchased the products in the background category "domestic mobile phone", the front-end category "promotional mobile phone" and "hot mobile phone"; user 4 purchased the background class The items in the "Nokia Mobile" show the front-end categories "Promotional Mobile Phone" and "Top Mobile Phone"; User 5 purchased the products in the background category "Samsung Camera" and browsed the front-end category "Promotional Camera". And "hot camera"; user 6 purchased the product in the background category "Samsung Camera", and browsed the foreground category "Promotion Camera"; User 7 purchased the product in the background category "Sony Camera" The front-end category "Top Camera" was viewed; User 8 purchased the products in the background category "Sony Camera", and the front-end categories "Promotion Camera" and "Top Camera" were viewed; User 9 purchased the background category " The products in the Samsung camera, the front-end category "promotional camera";

Step S204: respectively, counting the number of times the user of each foreground category is determined by the above is as follows: the number of times the user who purchased the products in each background category clicks on the foreground category "hot mobile phone" is 2; The number of times the user of the item clicks on the foreground category "promotional phone" is 4; the number of times the user who purchased the item in each background category clicks on the foreground category "hot camera" is 3; the purchase of the item in each background category is purchased. The number of times the user clicks on the foreground category "Promotion Camera" is 4;

Step S205: Adjust the foreground category structure according to the statistical result.

For example, due to the number of clicks on “promotional mobile phone” and “promotional camera”, the background category “Samsung mobile phone” is added to the foreground category “promotional mobile phone”, and the background category “Kodak camera” is added to the foreground class. In the "promotional camera", to increase its trading volume; that is, establish a background category "Samsung mobile phone" to join the foreground category "promotional mobile phone", and the background category "Kodak camera" and the foreground category "promotion" The mapping relationship between the cameras.

Step S206: Counting the total transaction volume of the goods in the e-commerce website in the next set period, verifying the reorganized foreground category structure, whether the better display effect is achieved, and the transaction volume is improved.

According to the foreground category adjustment method of the e-commerce website of the present invention, a foreground category adjustment device for an e-commerce website can be constructed, and the structure thereof is as shown in FIG. 5, including: a determination module 101, a search module 102, and a statistical model. Group 103 and adjustment module 104.

The determining module 101 is configured to obtain a transaction record of each background category in a set period of the background database record of the e-commerce website, and determine a user who purchases the goods in each background category.

The search module 102 is configured to search for the foreground category determined by the determining module 101 and clicked by the user within the set period.

Preferably, the search module further includes: a first search unit 1021 and a second search unit 1022.

The first searching unit 1021 is configured to determine, according to the transaction record obtained by the determining module 101, the user ID of the user who purchased the products in each background category; and obtain all the user clicks in the setting period of the log system record of the e-commerce website. The click status record of the foreground category; then, according to the obtained click status record and the determined user ID, the foreground category that the user who purchased the products in each background category clicks within the set period is determined.

The second searching unit 1022 is configured to determine, according to the user access path, the foreground category that the user clicks when the user purchases the product in the background category, and directly determine the foreground category that the user clicks in the setting period.

The statistics module 103 is configured to separately count the number of clicks of the user users who purchase the products in each background category determined by each foreground category.

The adjustment module 104 is configured to adjust the foreground category structure according to the statistical result.

The foreground category adjustment device of the e-commerce website further includes: a verification module 105, configured to collect the total transaction volume of the e-commerce website in the next set period, and verify the adjusted foreground class by the total transaction volume. Structure.

The method and device for adjusting the foreground category of the e-commerce website provided by the embodiment of the present invention establishes the association between the click status of the foreground category and the transaction status of the goods in the background category by the user ID or the access path when the user purchases, and obtains the foreground class. The impact of the transaction on the goods in the back-end category provides decision support for the scientific and reasonable organization of the front-end category relationship of the e-commerce website; according to the actual statistical results, the foreground category can be adjusted to obtain a more optimized organization of the foreground category. Structure, through the optimized front-end category organization structure, can better guide users to browse various products displayed on the website, obtain good product display effects, and increase the transaction volume of website products.

The above is only a preferred embodiment of the present invention, but the scope of the present invention is not limited thereto, and any person skilled in the art can easily think of changes within the technical scope disclosed by the present invention. Replacement or application to other similar devices is intended to be covered by the scope of the present invention. Therefore, the scope of protection of the present invention should be determined by the scope of protection of the patent application.

10. . . server

11. . . user terminal

12. . . Background database

101. . . Determine module

102. . . Search module

103. . . Statistical module

104. . . Adjustment module

105. . . Verification module

1021. . . First search unit

1022. . . Second search unit

1 is a schematic diagram of a principle of a foreground category adjustment method of an e-commerce website according to an embodiment of the present invention;

2 is a schematic structural diagram of a system in which a method of the present invention is applied in an embodiment of the present invention;

3 is a flowchart of a method for adjusting a foreground category of an e-commerce website according to an embodiment of the present invention;

4 is a flow chart of a specific example of an embodiment of the present invention;

FIG. 5 is a schematic structural diagram of a foreground category adjustment apparatus of an e-commerce website according to an embodiment of the present invention.

Claims (7)

A method for adjusting a foreground category of an e-commerce website, comprising: obtaining a transaction record of each background category in a set period of the background database record of the e-commerce website, and determining a user who purchases goods in each background category; Find the foreground category that the user clicks in the set period; separately count the number of times each foreground category is clicked by the user; and re-adjust the foreground category structure according to the statistical result. The method of claim 1, wherein the finding the foreground category that the user clicks during the setting period comprises: determining a user ID of the user according to the transaction record, and obtaining a log of the e-commerce website. During the set period of the system record, all users click on the click status record of each foreground category, and according to the user ID and the click status record, determine the foreground category that the user clicks in the set period; or purchase the background category in the user. When the product is in the middle, the foreground category that the user clicks is determined according to the user access path, and the foreground category that the user clicks in the set period is directly determined. The method of claim 2, wherein each foreground category includes at least one background category, and each background category belongs to at least one foreground category. The method of any one of claims 1 to 3, wherein the re-adjusting the foreground category structure according to the statistical result further comprises: counting the total transaction of the commodity in the e-commerce website in the next set period The amount, the adjusted foreground category structure is verified by the calculated total volume. A front-end category organization device for an e-commerce website, comprising: a determining module, configured to obtain a transaction record of each background category in a set period of the background database record of the e-commerce website, and determine to purchase each background class a user of the item; a search module for finding a foreground category determined by the determining module for the user to click during the set period; and a statistical module for separately counting each foreground category by the user The number of clicks; the adjustment module is used to adjust the foreground category structure based on the statistical results. The device of claim 5, wherein the search module comprises: a first search unit and a second search unit; the first search unit is configured to determine a user ID of the user according to the transaction record; and obtain The user of the e-commerce website records the click status record of each foreground category in the set period of the log system record; and then determines the foreground category that the user clicks in the set period according to the user ID and the click status record; The second searching unit is configured to determine, according to the user access path, the foreground category that the user clicks when the user purchases the product in the background category, and directly determine the foreground category that the user clicks in the setting period. The device of claim 5 or 6, wherein the method further comprises: a verification module, configured to calculate a total transaction volume of the commodity in the e-commerce website in the next set period, and verify and adjust the total volume through the statistics. After the foreground category structure.