KR102545604B1 - System for managing open market - Google Patents

Abstract

The present invention relates to an open market management system. The open market management system includes: a seller terminal which is a terminal which can communicate by connecting to a wired or wireless communication network, and is used by a seller; and an application providing server which communicates with the seller terminal through a wired or wireless communication network and provides the seller terminal with a dedicated application for managing products registered by the seller in the open market. According to the present invention, the present invention contributes to the convenience of sellers by automatically setting advertising costs for products by time zone in the open market.

Description

Open market management system {System for managing open market}

The present invention relates to an open market management technology, and more particularly, to open market-related management, such as advertising expenses, inventory, and product statistics, by companies entering the open market.

An open market is a general term for e-commerce sites that allow individuals or small businesses to directly sell products to buyers through stores opened online. Unlike general Internet shopping malls operated by home shopping, department stores, or large mart companies, open markets have the advantage of low product prices because products can be sold directly to buyers without intermediate distribution margins between product manufacturers and sellers.

Recently, the online shopping market continues to grow, and sellers who want to sell products register and sell products in domestic and international open markets. At this time, it is rare for a seller to sell one product in one open market, and register and manage multiple open markets for high product exposure and sales. For example, open market sellers (sellers) sell their products in domestic open markets such as Coupang, Auction, Gmarket, 11th Street, and Interpark, and overseas open markets such as Taobao (China), Tikkun (Japan), and Amazon (USA). You can register, manage, and proceed with sales.

A seller who has registered a product in the open market pays advertising fees to the open market to run advertisements, receives various statistical data such as sales and profits related to product sales from the open market side, and manages product sales through the open market. In addition, it manages the products registered in the open market, such as managing the inventory of multiple products registered in the open market, determining the investment value of each product, and establishing a marketing strategy.

In the case of an open market, the number of visitors and sales vary depending on the time of day. Therefore, it is necessary to set an appropriate advertising cost according to the time zone, but conventionally, there was an inconvenience that the seller had to connect to the open market site every time and set the advertising cost for each time zone. In addition, since the statistical data related to product sales provided by the open market is limited, there is a limitation in establishing a marketing strategy by analyzing the statistical data related to the product, so the seller has to separately analyze the data related to product sales, which is inconvenient.

Korean Registered Patent No. 10-1463974

The present invention has been made to solve the above problems, and the purpose of the present invention is to provide an open market management system that automatically sets advertising costs for products by time zone in an open market and provides various statistical analysis reports related to product sales. there is

The object of the present invention is not limited to the object mentioned above, and other objects not mentioned will be clearly understood by those skilled in the art from the description below.

The present invention for achieving the above object relates to an open market management system, which is a terminal capable of communicating by accessing a wired/wireless communication network, which communicates with a seller terminal used by a seller and the seller terminal through a wired/wireless communication network, and allows the seller to open market It includes an application providing server that provides a dedicated application for managing products registered to the seller terminal.

The application providing server may provide, through the dedicated application, a statistical menu for all products displaying product statistics information related to product sales, including the total number of sales for each product and the amount of advertising money spent.

The application providing server includes warehouse inventory, open market inventory, total sales quantity, advertisement sales quantity, natural sales quantity, sales, sales profit, advertisement start date, execution advertisement cost, advertisement conversion sales, advertisement conversion sales rate, advertisement conversion sales profit, advertisement A statistical menu for all products including net income from conversion sales, net income from conversion sales to advertisements, and net income items may be provided.

The application providing server may provide a sales ranking through a search keyword of each product by date in the statistics menu for all products.

The application providing server provides a function for setting advertisement costs for each time period through the dedicated application, and when the advertisement costs for each time period are set, it accesses the open market server accordingly to set and execute the advertisement costs for each time period.

According to the present invention, by automatically setting advertising costs for products for each time period in an open market, there is an effect of contributing to seller's convenience.

In addition, according to the present invention, it is possible to more easily establish a product marketing strategy by providing various statistical analysis reports related to product sales.

In addition, according to the present invention, by providing inventory management information and sales ranking information for each product, there is an effect of improving quality management and easily determining investment value.

1 conceptually illustrates the configuration of an open market management system according to an embodiment of the present invention.
2 to 12 show examples of screens in which a dedicated application is executed in a seller terminal in an open market management system according to an embodiment of the present invention.
13 is a flowchart illustrating a method of calculating overall product statistics through a dedicated application in an open market management system according to an embodiment of the present invention.

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

Terms used in this application are only used to describe specific embodiments, and are not intended to limit the present invention. Singular expressions include plural expressions unless the context clearly dictates otherwise. In this application, the terms "include" or "have" are intended to designate that there is a feature, number, step, operation, component, part, or combination thereof described in the specification, but one or more other features It should be understood that the presence or addition of numbers, steps, operations, components, parts, or combinations thereof is not precluded.

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 the present 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 unless explicitly defined in the present application, it should not be interpreted in an ideal or excessively formal meaning. don't

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

The present invention relates to an open market management system, which is a terminal capable of communicating by accessing a wired/wireless communication network, for communicating with a seller terminal used by a seller and a seller terminal through a wired/wireless communication network, and for managing products registered by a seller in an open market. It includes an application providing server that provides a dedicated application to the seller terminal.

The application providing server may provide, through the dedicated application, a statistical menu for all products displaying product statistics information related to product sales, including the total number of sales for each product and the amount of advertising money spent.

The application providing server includes warehouse inventory, open market inventory, total sales quantity, advertisement sales quantity, natural sales quantity, sales, sales profit, advertisement start date, execution advertisement cost, advertisement conversion sales, advertisement conversion sales rate, advertisement conversion sales profit, advertisement A statistical menu for all products including net income from conversion sales, net income from conversion sales to advertisements, and net income items may be provided.

The application providing server may provide a sales ranking through a search keyword of each product by date in the statistics menu for all products.

The application providing server provides a function for setting advertisement costs for each time period through the dedicated application, and when the advertisement costs for each time period are set, it accesses the open market server accordingly to set and execute the advertisement costs for each time period.

1 conceptually illustrates the configuration of an open market management system according to an embodiment of the present invention.

Referring to FIG. 1 , the open market management system in the present invention includes an application providing server 100 and a seller terminal 200 .

The application providing server 100 communicates with the seller terminal 200 through a wired/wireless communication network and provides the seller terminal 200 with a dedicated application for managing products registered by the seller in the open market.

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

In one embodiment of the present invention, the application providing server 100 provides a statistical menu for all products displaying product statistical information related to product sales, including the total number of sales for each product and the advertising cost spent, through a dedicated application. can

More specifically, the application providing server 100 includes warehouse inventory, open market inventory, total sales quantity, advertisement sales quantity, natural sales quantity, sales, sales profit, advertisement start date, execution advertisement cost, advertisement conversion sales, advertisement conversion sales rate, It is possible to provide an entire product statistical menu including profit from advertisement conversion sales, net income from advertisement conversion sales, net profit from advertisement conversion sales, and net income items.

The application providing server 100 may provide a sales ranking through a search keyword of each product by date in the product statistics menu.

The application providing server 100 provides a function for setting advertisement costs for each time period through a dedicated application, and when the advertisement costs for each time period are set, it can connect to the open market server accordingly to set and execute the advertisement costs for each time period.

In one embodiment of the present invention, the application providing server 100 provides a function for setting advertisement costs for each time period through a dedicated application, and when the advertisement cost for each time period is set, the application providing server 100 accesses the open market server 10 accordingly, Advertising expenses can be set and executed.

The application providing server 100 may provide a product statistical report related to product sales, including the total number of sales for each product and the amount of advertising expenses executed, through a dedicated application.

The application providing server 100 may provide an inventory management function for each product through a dedicated application.

The application providing server 100 may provide a sales ranking of each product in the open market through a dedicated application.

2 to 12 show examples of screens in which a dedicated application is executed in a seller terminal in an open market management system according to an embodiment of the present invention, and are examples of screens illustrating Coupang as an open market.

2 is an example of a main screen that appears when an ID and password are entered and logged in.

In the screen example of FIG. 2, menus such as “inventory management, sourcing, product management, ordering from China, logistics information, design schedule, total product statistics, sales ranking management, advertising amount management, margin calculator” are displayed on the left side. Among them, when the 'advertising amount management' menu is selected, a screen example as shown in FIG. 3 is displayed.

3 is a screen example of the 'advertising amount management' menu.

In the screen example of FIG. 3 , the seller can arbitrarily set advertising costs as 'midnight amount' indicating advertising cost to be executed at midnight and 'afternoon amount' indicating advertising cost to be executed in the afternoon time zone. For example, the midnight time zone can be defined as 0:00 to 15:00, and the afternoon time zone can be defined as 15:00 to 24:00.

As described above, in the present invention, the application providing server 100 may provide a screen for setting different advertisement costs for each time period. Then, by accessing the open market server 100, the advertising cost is automatically executed according to the advertising cost for each set time slot.

In the screen example of FIG. 3, the midnight time zone is a time zone with relatively low sales, and the afternoon zone is a time zone with relatively high sales. Therefore, it is possible to more efficiently execute open market advertising costs by setting a higher advertisement cost in the afternoon time zone than in the midnight time zone.

For example, in the case of the 'Rosie Stell Zigzag Sweatshirt' item in FIG. 3 , it can be seen that 10,000 won is set as the midnight amount and 30,000 won is set as the afternoon amount.

4 and 5 are examples of screens showing the 'statistics of all products' menu.

In the screen examples of FIGS. 4 and 5, order number, person in charge, product name, option name, scheduled arrival, warehouse inventory, Coupang inventory, total sales quantity, advertisement sales quantity, natural sales quantity, sales, sales profit, advertisement start date, execution advertisement cost, Items such as ad conversion sales, ad conversion sales rate, ad conversion sales profit, ad conversion sales net income, ad conversion sales net rate, and net income are included in the overall product statistics menu.

Here, the total sales volume is the total sales volume of the product, the advertising sales volume is the sales volume of the corresponding product through advertising, the natural sales volume is the sales volume of the corresponding product without advertising, and the sales profit is the sales volume of the corresponding product represents the profit generated from

In addition, the execution advertising cost is the advertising cost executed for the product, and the advertising conversion sales represent the sales of the product sold through the advertisement. it's all inclusive For example, ad conversion sales include all sales generated from other products sold through links marked as related products in advertisements for that product.

And, the advertisement conversion sales rate represents the ratio of advertisement conversion sales to execution advertisement cost.

Profits from advertisement conversion sales represent the total amount of profits generated from sales of products sold through corresponding advertisements.

Net profit from ad conversion sales is the amount obtained by subtracting advertising expenses from ad conversion revenue.

The net profit margin from advertisement conversion sales represents the ratio of the net profit from advertising conversion sales to the execution advertisement cost.

Net profit represents the amount obtained by subtracting advertising expenses from sales profit.

As such, in the present invention, the application providing server 100 provides the advertisement conversion sales profit, the advertisement conversion sales net profit, and the advertisement conversion sales net profit ratio in the overall product statistical report. Therefore, in the present invention, by providing information such as sales and net income generated through advertisements of a certain product in the open market, the effect of advertisements can be easily confirmed and can be usefully used for product advertisement strategy and marketing strategy establishment. there is.

In the screen example of FIG. 4, looking at the case of the product 'Lodge fast charging cable c-type 2m 6ea', the total sales quantity is 26, the advertisement sales quantity is 18, the natural sales quantity is 8, the sales amount is 491,400 won, and the sales profit is It is 60,892 won. In addition, the advertisement start date is December 16, 2021, the execution advertisement cost is 100,045 won, the advertisement conversion sales is 340,200, the advertisement conversion sales rate is 341%, the advertisement conversion sales profit is 42,156 won, and the advertising conversion sales net profit is -57,889 won, the ad conversion sales net profit rate is -58%, and the net profit is -39,153 won.

In addition, in the screen example of FIG. 4, scheduled stock is the quantity of products to be stocked, warehouse inventory is the quantity of stock in the warehouse, Coupang stock is the quantity of stock in Coupang, an open market, and sales rank represents the sales order of products. . Here, the sales ranking is calculated using various indicators such as sales, sales volume, and number of clicks in the open market.

As such, in the present invention, the application providing server 100 crawls data from the open market server 10 and provides an inventory management function including inventory information, warehouse inventory, and open market inventory information. By doing this, it is possible to easily grasp the inventory of the product and improve the quality control of the product.

In addition, the application providing server 100 may confirm the investment value of the corresponding product by providing a sales ranking for the product.

In the example of the 'Statistics of All Products' screen of FIG. 5 , the number in parentheses next to each product name indicates the number of options for the corresponding product.

For example, in the screen example of FIG. 6, if 'Roji National Cover Type Mosquito Repellent Cradle 10 (4)' is clicked, as shown in the screen example of FIG. Delivery)', 'Normal type 10 pieces (Rocket delivery), 'Cover type 10 pieces', 'Normal type 10 pieces'.

In the screen example of FIG. 5 , the application providing server 100 provides 'last 5 days sales average' data, which is a sales average for the last 5 days for each product.

In this case, if it is predicted that inventory will be insufficient in the future based on the data of 'sales average for the last 5 days', a red circle is displayed in the data item 'sales average for the last 5 days'. For example, by comparing the value (A) obtained by multiplying the 'sales average for the last 5 days' by 14, the number of days in a two-week period, and the sum of 'warehouse inventory' and 'Coupang inventory', which is open market inventory (B), If A is large, a red circle is displayed in the 'last 5-day sales average' data.

In the screen example of FIG. 5 , sales by applying coupons are sales reflecting the use of coupons by consumers when purchasing a corresponding product, and can be referred to as actual sales. Therefore, based on the coupon applied sales data, sales profit, net profit, etc. are calculated.

In the screen example of FIG. 5 , when each product name item is clicked, a 'summary sales statistics summary' pop-up window of the corresponding product is provided.

8 to 10 illustrate example screens of a 'Summary of Sales Statistics per Day' pop-up window displayed as a result of clicking on the product name 'Rosie Universal Bed Mobile Phone Cradle' item.

In the screen examples of FIGS. 8 to 10, a daily sales statistics summary pop-up window screen for the product 'Rosie Universal Bed Phone Cradle' is exemplified, specifically, keyword sales ranking by date for the product, total sales volume, advertising sales volume, nature Sales volume, revenue, sales profit, net income, ad impressions, number of impressions, number of clicks, advertising cost, cost per click, conversion rate, sales volume, BEP (Break Even Point), cost per conversion, conversion revenue, ad conversion sales profit, ad conversion Items such as net income from sales are displayed.

Here, the number of impressions is the number of times a product is exposed to an advertisement for each day, the number of clicks is the number of times an advertisement is clicked, and the cost per click is a value obtained by dividing the advertisement cost by the number of clicks. The conversion rate is the number of sales divided by the number of clicks.

In the screen examples of FIGS. 8 to 10 , a function of displaying the sales ranking for each keyword by date can be confirmed. For example, on May 5, 2022, the sales ranking of the keyword 'cell phone holder' is '2-3', and the sales ranking of the keyword 'mobile phone holder' is '2-2'. Here, '2-3' represents the third product order of the second page on the product sales screen of the open market site.

In the present invention, in order to implement the function of displaying the sales ranking for each keyword by date, the application providing server 100 periodically crawls the sales screen of the corresponding product in the open market server 100, and the crawled sales screen information is used to calculate and display the sales ranking for each keyword on that date. As such, in the present invention, by proposing a function of showing the sales ranking for each keyword by date, it can be usefully used to select an advertising keyword and establish a marketing plan.

And, if '+' is clicked next to each date, as shown in the example screens of FIGS. 11 and 12 , statistical data on specific search areas and non-search areas on the corresponding date are displayed. Here, the search area is statistical data related to sales of a corresponding product through keyword search, and the non-search area is statistical data related to sales of a corresponding product when keyword search is not performed. For example, in the non-search area for product A, on the sales screen of product B on an open market site, sales for product A are generated by entering through the 'View seller's other products' menu of a seller selling product B. This is the case when sales of product A are generated by entering through the 'View related products' menu provided at the bottom of the sales screen of product B.

In the screen examples of FIGS. 11 and 12 , statistical data for specific keyword search areas and non-search areas on May 2, 2022 are displayed. Specifically, in the search area, the number of impressions, clicks, advertising cost, cost per click, conversion rate, BEP, cost per conversion, Statistical data such as conversion sales, profits from advertising conversion sales, and net profits from advertising conversion sales are displayed.

In the screen examples of FIGS. 11 and 12, keywords in the search area are examples of 'cell phone holder', 'bed mobile phone holder', 'cell phone holder', and 'smart phone holder', and the number of impressions and clicks for each keyword by date Statistical data such as number, ad cost, cost per click, conversion rate, BEP, cost per conversion, conversion sales, profit from ad conversion sales, and net income from ad conversion sales are displayed. In addition, statistical data such as the number of impressions, clicks, advertising cost, cost per click, conversion rate, BEP, cost per conversion, conversion sales, profit from conversion to advertisement, and net profit from conversion to advertisement for each keyword in the non-search area by date are provided. indicated.

Therefore, in the present invention, statistical data on product sales in the search area through keyword search by date and statistical data on product sales in the non-search area are displayed on one screen, so that statistical data can be easily analyzed and confirmed.

13 is a flowchart illustrating a method of calculating overall product statistics through a dedicated application in an open market management system according to an embodiment of the present invention.

Referring to FIG. 13, when a dedicated application is executed in the seller terminal 200, and a user is logged in by entering an ID and password on the dedicated application (S101), when sales for a specific product occur (S103), the application The provision server 100 checks whether or not sales through advertisements (S105).

If it is sales through advertisement, it is checked whether it is sales through keyword search set by the user (S107). If it is sales through keyword search set by the user, search area statistics for each keyword reflecting this are calculated (S109), and otherwise, non-search area statistics are calculated (S111).

If it is not sales through advertising, natural sales statistics reflecting this are calculated (S113).

The present invention has been described above using several preferred embodiments, but these embodiments are illustrative and not limiting. Those skilled 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 rights set forth in the appended claims.

100 Application providing server 200 Merchant terminal
10 Open Market Server

Claims (5)

As a terminal capable of communicating by accessing a wired or wireless communication network, a seller terminal used by a seller; and
An application providing server that communicates with the seller terminal through a wired/wireless communication network and provides a dedicated application for managing products registered in an open market by the seller to the seller terminal,
The application providing server provides a statistical menu for all products displaying product statistical information related to product sales, including the total number of sales for each product and the advertising cost spent, through the dedicated application;
The application providing server includes warehouse inventory, open market inventory, total sales quantity, advertisement sales quantity, natural sales quantity, sales, sales profit, advertisement start date, execution advertisement cost, advertisement conversion sales, advertisement conversion sales rate, advertisement conversion sales profit, advertisement Provides a statistical menu for all products, including net income from conversion sales, net income from conversion sales to advertisements, and net income items;
Here, the total sales volume is the total sales volume of the product, the advertising sales volume is the sales volume of the corresponding product through advertising, the natural sales volume is the sales volume of the corresponding product without advertising, and the sales profit is the sales volume of the corresponding product It represents the profit generated from the advertisement, and the advertising expenditure is the advertising expenditure executed for the product, and the advertising conversion sales represent the sales of the product sold through the advertisement, not only the sales of the product, but also other products sold through the advertisement of the product. It includes all sales of products, and the advertisement conversion sales rate represents the ratio of advertising conversion sales to the advertising expenditure, and the advertising conversion sales profit represents the total amount of profits generated from the sales of products sold through the advertisement, and the advertising conversion sales Net income is the amount obtained by subtracting advertising expenses from advertisement conversion sales, net profit ratio from advertising conversion sales represents the ratio of net income from advertising conversion sales to advertising expenses executed, and net income represents the amount obtained by subtracting execution advertising expenses from sales profits,
The application providing server provides a sales ranking through search keywords of each product by date in the product statistics menu,
The application providing server provides a function for setting advertisement costs for each time slot through the dedicated application, and when the advertisement costs for each time period are set, accesses the open market server accordingly to set and execute the advertisement costs for each time period;
The application providing server crawls data from the open market server through the dedicated application to provide an inventory management function including scheduled arrival, warehouse inventory, and open market inventory information,
The application providing server provides 'last 5 days sales average' data, which is the sales average for the last 5 days for each product, through the dedicated application. If it is predicted to be insufficient, a red circle is displayed in the data item 'Sales average for the last 5 days',
The application providing server periodically crawls the sales screen of the product in the open market server, calculates the sales ranking for each keyword on the corresponding date using the crawled sales screen information, displays it through the dedicated application, and displays it on the specific date If is selected, statistical data for specific search areas and non-search areas on that date are displayed, where the search area is statistical data related to sales of the product through keyword search, and the non-search area is statistical data related to sales of the corresponding product through keyword search. Statistical data related to sales of the product in the case of
When a dedicated application is executed in the seller terminal, and a user is logged in by inputting an ID and password on the dedicated application, and sales for a specific product occur, the application providing server checks whether sales are through advertisements, If it is sales through advertisement, it is checked whether it is sales through keyword search set by the user. If it is sales through keyword search set by the user, search area statistics by keyword reflecting this are calculated. And, if it is not sales through advertising, an open market management system characterized in that for calculating natural sales statistics reflecting this.
delete delete delete delete

Images