WO2021153867A1

WO2021153867A1 - Integrated open market management system using search keyword

Info

Publication number: WO2021153867A1
Application number: PCT/KR2020/010523
Authority: WO
Inventors: 박선민
Original assignee: 뉴21커뮤니티(주)
Priority date: 2020-01-29
Filing date: 2020-08-10
Publication date: 2021-08-05
Also published as: KR20210096936A

Abstract

The present invention relates to an integrated open market management system comprising: a user terminal which is used by a user and can communicate through wired and wireless communication networks; a database for storing data; and an integrated management server which communicates with the user terminal and an open market server, and which, when there is a request for sales information about rival companies that sell the same item as a search keyword input from the user terminal, connects to the open market server to collect data related to the sales of the other companies that sell the corresponding item, stores the collected data in the database, analyzes the sales-related data stored in the database, and provides the user terminal with the analyzed information in a visualized form. According to the present invention, there is an effect that the data collected from the open market is stored in a database and visualized, and thus can be used in efficient marketing strategy analysis based on big data.

Description

Open market integrated management system using search keywords

The present invention relates to an integrated open market management technology, and more particularly, an open market integration capable of collecting and analyzing big data for products registered in the open market, and visualizing digitized data in various graphs or charts. It's about management skills.

Recently, the online shopping market continues to grow, and sellers who want to sell products register and sell products in domestic and foreign open markets. At this time, the seller rarely sells one product in one open market, and registers and manages several open markets for a lot of exposure and sales of the product. For example, open market sellers (sellers) register their products in domestic open markets such as Auction, Gmarket, 11st, Interpark, and overseas open markets such as Taobao (China), Tikkun (Japan), and Amazon (USA). Manage and sell.

Meanwhile, in recent years, as the use of social services and the amount of smart devices are increased, data is increasing exponentially. Accordingly, interest in big data technology that collects and analyzes a large amount of data to extract meaningful data and analyzes the results is increasing.

Big data encompasses a huge amount of data sets that are difficult to handle with existing management and analysis systems, analysis techniques for such data sets, and visualization platform technology. Companies can utilize meaningful big data only through the process of acquiring, storing, processing, analyzing, and expressing structured and unstructured data generated in various ways.

Amazon has optimized services and logistics by identifying patterns in online shopping mall customer data, and is currently building offline customer data to discover additional personalized services. In addition, by developing a 'book recommendation system' in an online shopping mall, discount coupons are provided while recommending books that are expected to be read by customers, or they are delivered to a logistics warehouse near the customer's address by preparing delivery before purchasing (AnticipatoryShipping). Recently, the offline unmanned grocery store 'Amazon Go' has been expanded and offline customer data is being built, such as measuring the body type and size of customers for 20 weeks to understand changes in body shape.

The domestic big data and analytics market is expected to grow at an average annual rate of 10.9% over the next five years, and is expected to reach a size of about 2.2 trillion won in 2022. The growth of big data is because collecting and analyzing data flows in real time while coping with the rapidly changing business environment is becoming an important topic compared to the past. seems to have contributed to

The present invention has been devised to solve the above problems, and an object of the present invention is to provide an open market monitoring system capable of collecting, analyzing, monitoring, and visualizing big data based on open market search keywords.

Objects of the present invention are not limited to the objects mentioned above, and other objects not mentioned will be clearly understood by those skilled in the art from the following description.

The open market integrated management system of the present invention for achieving the above object is a terminal used by a user, a user terminal that is a terminal capable of communicating through a wired/wireless communication network, a database for storing data, and the user terminal and the open market server When there is a request for sales information about a competitor who sells the same item as the search keyword entered from the user terminal, it accesses the open market server and collects and collects sales related data of other companies selling the item. and an integrated management server that stores one data in the database, analyzes sales-related data stored in the database, and visualizes the analyzed information to provide to the user terminal.

The integrated management server may collect sales-related data including product numbers, product names, current prices, list prices, purchase quantities, remaining quantities, and ratings of other companies by using a crawling program.

The integrated management server accesses the open market server and accesses the web page of the corresponding open market, collects data including a link to the sales page of another company selling the item from the accessed web page, and links to the sales page of the company You can access the sales webpage of the relevant company and collect sales-related data including product number, product name, current price, list price, purchase quantity, remaining quantity, and rating.

The crawling program may be executed at regular intervals.

According to the present invention, there is an effect that can be utilized for efficient marketing strategy analysis based on big data by databaseizing and visualizing the data collected in the open market.

In addition, according to the present invention, there is an effect of securing price competitiveness by quickly checking the product information of competitors in fierce sales competition in the open market. In other words, it is possible to preoccupy an advertisement position above competitors in each open market and to improve sales efficiency based on big data analysis.

1 schematically shows the configuration of an open market integrated management system according to an embodiment of the present invention.

2 and 3 are examples of web page screens of an open market according to an embodiment of the present invention.

4 illustrates a table existing in a database according to an embodiment of the present invention.

5 illustrates basic fields of all tables of a database according to an embodiment of the present invention.

6 to 12 illustrate a crawling program according to an embodiment of the present invention.

13 to 16 illustrate data collected in the open market integrated management system according to an embodiment of the present invention.

17 to 19 illustrate a crawling program according to an embodiment of the present invention.

20 is an example of a web page screen of an open market according to an embodiment of the present invention.

21 and 25 are examples of UI screens of a user terminal according to an embodiment of the present invention.

26 to 30 are diagrams for explaining a process of adjusting the ranking of an open market search result according to an embodiment of the present invention.

The open market integrated management system of the present invention is a terminal used by a user, and communicates with a user terminal that is a terminal capable of communicating through a wired/wireless communication network, a database for storing data, and the user terminal and the open market server, and the user terminal When there is a request for sales information about a competitor who sells the same item as the search keyword entered from and an integrated management server that analyzes the sales-related data stored in the database, visualizes the analyzed information, and provides it to the user terminal.

Since the present invention can have various changes and can have various embodiments, specific embodiments are illustrated in the drawings and described in detail. However, this is not intended to limit the present invention to specific embodiments, and it should be understood to include all modifications, equivalents and substitutes included in the spirit and scope of the present invention.

The terms used in the present application are only used to describe specific embodiments, and are not intended to limit the present invention. The singular expression includes the plural expression unless the context clearly dictates otherwise. In the present application, terms such as “comprise” or “have” are intended to designate that a feature, number, step, operation, component, part, or combination thereof described in the specification exists, but one or more other features It should be understood that this does not preclude the existence or addition of numbers, steps, operations, components, parts, or combinations thereof.

Unless defined otherwise, all terms used herein, including technical or scientific terms, have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs. Terms such as those defined in commonly used dictionaries should be interpreted as having a meaning consistent with the meaning in the context of the related art, and should not be interpreted in an ideal or excessively formal meaning unless explicitly defined in the present application. does not

In addition, in the description with reference to the accompanying drawings, the same components are assigned the same reference numerals regardless of the reference numerals, and the overlapping description thereof will be omitted. In describing the present invention, if it is determined that a detailed description of a related known technology may unnecessarily obscure the gist of the present invention, the detailed description thereof will be omitted.

Referring to FIG. 1 , the open market integrated management system of the present invention includes a user terminal 100 , an integrated management server 200 , and a database 210 .

The user terminal 100 is a terminal used by a user, and is a terminal capable of communicating through a wired/wireless communication network. For example, the user terminal 100 may be implemented as a desktop PC, a laptop computer, a smart phone, a mobile phone, a mobile phone, a tablet PC, or the like.

The database (Database, DB) 210 stores data collected by the integrated management server 200 .

The integrated management server 200 communicates with the user terminal 100 and the open market server 300, and when there is a request for sales information for a competitor selling an item such as a search keyword inputted from the user terminal 100, open It accesses the market server 300 and collects sales-related data of other companies selling the item, stores the collected data in the database 210 , and analyzes and analyzes the sales-related data stored in the database 210 . Information is visualized and provided to the user terminal 100 .

In the present invention, the integrated management server 200 collects sales-related data including product numbers, product names, current prices (discount prices), list prices, purchase quantities, remaining quantities, and ratings of other companies using a crawling program. can

The integrated management server 200 accesses the open market server 300 to access the web page of the corresponding open market. Then, data including a link to a sales page of another company that sells the item from the accessed web page is collected. Then, by accessing the sales web page of the company through the link to the sales page of the company, sales-related data including product number, product name, current price, list price, purchase quantity, remaining quantity, and rating are collected.

In an embodiment of the present invention, the crawling program may be executed at regular intervals. For example, a crawling program may be automatically executed every hour by the Windows scheduler.

Referring to FIG. 2 , an example of a screen accessing a web page of an open market is shown. For example, in the present invention, the html of a web page can be accessed using the BeautifulSoup library in Python.

In the embodiment of FIG. 2 , it is assumed that 8 PowerClick products selling items such as Jeonnam Open Market are competitors, and link-itemcards of tag a including links to the competitors' sales pages are collected.

3 is an example of a screen accessed through a link to a competitor sales page collected in the corresponding open market. When accessing a competitor sales web page, product number, product name, current price (discount price), list price, purchase quantity, remaining quantity, rating, etc. collect data from

For example, the crawling program may be automatically executed every hour by the Windows scheduler, and data collected by the crawling program are continuously stored in the database 210 .

In Figure 4, jn_garlic is a table for collecting information on Jeonnam Open Market Garlic (B645700635), jn_rice is a table for collecting information on Jeonnam Open Market Rice (B559165061), and jn_tomato is a table for collecting information on Jeonnam Open Market Tomato (B326593090). This is a table to collect, powerclick_garlic is a table that collects product information of 8 power clicks of garlic, powerclick_rice is a table that collects product information of 8 power clicks of rice, and powerclick_tomato is a table that collects product information of 8 power clicks of tomato It is a table.

In addition, jn_garlic2, jn_rice2, jn_tomato2, powerclick_garlic2, powerclick_rice2, and powerclick_tomato2 represent a table in which existing product information such as product number, name, discount price, list price, purchase quantity, remaining quantity, and rating are collected from the number of additional reviews.

In Fig. 5, prod_num is the index of the collected information, gatherTime is the date and time of data collection, prod_code is the product number, prod_name is the name of the product, prod_star_rating is the rating of the product, and prod_current_price is the current sales page. It is the stated price, prod_original_price is the list price of the product, prod_buy_num is the sales quantity of the product, and prod_remain_num is the remaining quantity of the product.

In addition, a prod_review_count field is added to the jn_garlic2, jn_rice2, jn_tomato2, powerclick_garlic2, powerclick_rice2, and powerclick_tomato2 tables that collect the number of reviews.

In the present invention, data is collected using a crawling program.

6 to 12 illustrate a crawling program according to an embodiment of the present invention. Here, FIG. 12 exemplifies the program code for collecting the number of reviews.

13 exemplifies 10 data values collected from the [jn_garlic] table.

14 exemplifies 10 data values collected from the [powerclick_garlic] table.

15 exemplifies 10 data values collected from the [jn_garlic2] table.

14 exemplifies 10 data values collected from the [powerclick_garlic2] table.

In an embodiment of the present invention, if you want to collect additional products in addition to the data of garlic, rice, and tomato products that are fixedly collected, input the name of the product you want to add to the 'items' table of the database, and the power of the product is You can collect information about 8 clicks products. An example of a crawling program for this is as follows.

In the present invention, there are cases in which the web page structure of the open market is different, and accordingly, a case in which specific data items cannot be collected may occur.

In the embodiment of FIG. 20 , items that can be collected from the sales page and the power click list page in the open market are product number, name, discount price, list price, sales quantity, and number of reviews. However, it is not possible to collect rating items on the web page of this open market.

In the present invention, the collected data is analyzed and visualized through the user terminal 100 .

21 and 25 are examples of user interface (UI) screens of a user terminal according to an embodiment of the present invention.

21 is an example of a screen of a dashboard web page, in which a specific product can be selected.

In addition, as an example of a screen when a tomato is selected in FIG. 22 , product information of a competitor can be checked at a glance. On this screen, 'Confirm changes in competitor sales' and 'Confirm competitor's selling price' buttons are provided in the upper right corner of this screen.

If the 'confirm competitor's selling price' button is selected in FIG. 22, the screen of FIG. 23 is displayed.

23 is an example of a screen in which the discount price and list price charts of competitors are displayed in a bar graph format.

24 is an example of a screen for inputting a product code of a competitor in order to 'confirm change in the number of sales of a competitor'.

25 is an example of a screen in which 'confirmation of changes in the number of sales by competitors' is selected.

As shown in FIGS. 24 and 25 , the change in the sales quantity of a competitor can be checked after entering the competitor's product code.

In FIG. 25 , the quantity of the number of sales for each time period is displayed in the form of a line graph.

In the present invention, when a search result ranking is lower than that of a competitor, a method for solving the problem is proposed.

26 is an example of a screen of an open market web page, which is an example of a screen searched for with the keyword 'songpyeon'.

In FIG. 26, it can be seen that the exposure ranking of the competitor's product is 2nd, and the exposure ranking of its own product is 4th.

FIG. 27 checks the Request URL screen in the example of the web page screen of FIG. 26 and checks the data to be collected by checking the html code.

And FIG. 28 is a code showing a program processing and databaseization process for adjusting the exposure order.

29 is an example of a monitoring screen comparing the rankings of the company's product and the competitor's product.

30 is a program for setting an amount so that a keyword search result can be exposed higher than that of a competitor's product and transmitting it to the open market.

As such, in the present invention, by analyzing the results exposed when searching for keywords in the open market, when a competitor's product is exposed at a higher rank than its own, the advertisement amount is set so that the company's product is exposed at a higher rank to be displayed in the open market. can be sent automatically.

Although the present invention has been described above using several preferred embodiments, these examples are illustrative and not restrictive. Those of ordinary skill in the art to which the present invention pertains will understand that various changes and modifications can be made without departing from the spirit of the present invention and the scope of the appended claims.

Claims

A terminal used by a user, comprising: a user terminal, which is a terminal capable of communicating through a wired/wireless communication network;

a database for storing data; and

It communicates with the user terminal and the open market server, and when there is a request for sales information on a competitor that sells the same item as the search keyword input from the user terminal, it accesses the open market server and sells other companies selling the item. An integrated management server that collects related data, stores the collected data in the database, analyzes sales-related data stored in the database, and visualizes the analyzed information to provide it to the user terminal

Open market integrated management system including
The method according to claim 1,

The integrated management server uses a crawling program to collect sales-related data including product numbers, product names, current prices, list prices, purchase quantities, remaining quantities, and ratings of other companies by using a crawling program. system.
3. The method according to claim 2,

The integrated management server accesses the open market server and accesses the web page of the corresponding open market, collects data including a link to the sales page of another company that sells the item from the accessed web page, and links the sales page of the company An integrated open market management system, characterized in that by accessing the sales webpage of the corresponding company through the collection of sales-related data including product number, product name, current price, list price, purchase quantity, remaining quantity, and rating.
3. The method according to claim 2,

The crawling program is an open market integrated management system, characterized in that it is executed at regular intervals.