KR20010008030A - A method and system for updating electronic commerce shopping mall automatically - Google Patents

Abstract

PURPOSE: A system and a method for automatically updating a shopping mall are provided to reduce the time and the cost for constructing and maintaining a product database, and to upgrade product data by selecting location of product to post only. CONSTITUTION: A product database updating server(101) is connected to a web server(107), and coupled to a unified messaging system(UMS) server(109) and a payment system(111) via a network(121). The web server(107) is connected to a computer(117) for a shopping mall manager(113) and a computer(119) for a visitor(115). A barrier(105) is installed between the computers(117,119). The server(101), connected to a product related database(123a) and a shopping mall related database(125a), includes a product database updating module. The web server(107) is connected to a computer(129) of the manager(113) and a computer(131) of a database manager(135) via a network(127). The server(107) offers the screens for inputting shopping mall information and registering a common product and the product in a catalog.

Description

A METHOD AND SYSTEM FOR UPDATING ELECTRONIC COMMERCE SHOPPING MALL AUTOMATICALLY}

The present invention relates to a method and apparatus for automatically updating a network-based shopping mall, and more particularly, to a method and apparatus for automatically updating a network-based shopping mall in which a product data of a selected product is updated by selecting only a product to be posted in a shopping mall and a product posting location of the product. It is about.

The existing network-based shopping mall updating method collects product image, product feature, and product information of a product to be posted in a shopping mall by a product DB manager of the shopping mall through the Internet or a catalog transmitted from a manufacturer. When a professional person such as a webmaster, a designer, a programmer, and the like store the collected product information in a product database, the shopping mall is updated.

The existing network-based shopping mall updating method has a problem in that a shopping mall manager needs to collect enormous data such as product image, product feature, and detailed introduction of each product and store it in a database.

In addition, the existing network-based shopping mall updating method has a problem that a huge time, effort, cost for the construction and maintenance of the product database.

In addition, the existing network-based shopping mall updating method has a problem that requires a lot of professional personnel, such as a webmaster, designer, programmer for the continuous product information update after the shopping mall is built.

In addition, the existing network-based shopping mall updating method has a problem that can not operate the site smoothly because the product information is not continuously updated in the shopping mall when the professional staff is insufficient after the shopping mall is built.

In addition, the existing network-based shopping mall updating method has a problem that can not quickly update the relevant information about the product.

Accordingly, an object of the present invention is to provide a network-based shopping mall automatic updating method and apparatus for updating a product data of a selected product when the shopping mall manager selects only a product to be posted in the shopping mall and a product posting location of the product.

Another object of the present invention is a network-based shopping mall automatic updating method and apparatus that allows a shopping mall manager to update product information without collecting enormous data such as product images, product features, and detailed introduction of each product after building a shopping mall. To provide.

Still another object of the present invention is to provide a method and apparatus for automatically updating a shopping mall based on a network in which time, effort, and cost for building and maintaining a product database are greatly reduced.

Another object of the present invention is to provide a network-based shopping mall automatic update method and apparatus capable of updating product information quickly and simply.

Another object of the present invention is to secure the flexibility of information that can be displayed only in the shopping mall, such as price information, product discount period, etc. applied to the shopping mall in addition to the built product information network-based shopping mall automatic to support the operation of the store-specific shopping mall An update method and apparatus are provided.

Still another object of the present invention is to add a product for updating the product information by matching each category for posting the product provided by the product database update server and the category to be posted in the shopping mall in advance. Then, a method and apparatus for automatically updating a network-based shopping mall in which the product list and product information are automatically provided in a product list of a classification item of a shopping mall that matches each category for posting a product provided by a product database update server. will be.

A further object of the present invention is to match in advance the table name, field name, table name in the shopping mall, and field name in the product database update server for each item of product information to be updated. The matched information is stored in a product information matching table to provide a method and apparatus for automatically updating a network-based shopping mall in which product related information is automatically updated.

Still another object of the present invention is to provide a network-based shopping mall automatic update method and apparatus that correspond to a manufacturer code, a manufacturer product classification code, and a manufacturer product code for a product, and which provides a web21 product code assigned by the web21.

Still another object of the present invention is to provide a network-based shopping mall automatic update method and apparatus in which a shopping mall is automatically updated through input of the web product code 21.

Another object of the present invention is to provide a network-based shopping mall automatic update method and apparatus for automatically updating a shopping mall by inputting a manufacturer code, a manufacturer product classification code, a manufacturer product code, etc. for a product given by a manufacturer.

1 is a block diagram of a wired network-based shopping mall automatic update system according to an embodiment of the present invention.

2 is a block diagram of a network-based shopping mall automatic update system according to another preferred embodiment of the present invention.

3 is a view showing the configuration of a product database update module according to an embodiment of the present invention.

4 is a diagram illustrating a menu and a function description of shopping mall management according to an exemplary embodiment of the present invention.

5 is a diagram illustrating a menu and function description of shopping mall exhibition management according to an exemplary embodiment of the present invention.

6 is a diagram illustrating a menu and a function description of catalog product management according to an exemplary embodiment of the present invention.

7 is a diagram illustrating a menu and a function description of order management according to an embodiment of the present invention.

8 is a diagram illustrating a menu and a function description of statistical management according to an exemplary embodiment of the present invention.

9 is a diagram illustrating a menu and a function description of information management according to an embodiment of the present invention.

10 is a shopping mall information input screen according to an embodiment of the present invention.

11 is a shopping mall design selection screen according to an embodiment of the present invention.

12 is a catalog product classification classification input screen according to an embodiment of the present invention.

13 is a catalog product classification classification input screen according to an embodiment of the present invention.

14 is a catalog product attribute input screen according to an embodiment of the present invention.

15 is a catalog product overview and attribute input screen according to a preferred embodiment of the present invention.

16 is a catalog product description input screen according to an embodiment of the present invention.

17 is a product classification registration screen according to an embodiment of the present invention.

18 is a general product registration screen according to an embodiment of the present invention.

19A and 19B are catalog product registration screens in accordance with one preferred embodiment of the present invention.

20 is a catalog product input result screen according to an embodiment of the present invention.

21 is a flowchart illustrating a process of inputting shopping mall information by a system manager according to an exemplary embodiment of the present invention.

22 is a flowchart illustrating a process of modifying shopping mall information by a shopping mall manager according to an exemplary embodiment of the present invention.

23 is a flowchart illustrating a process of inputting a catalog product classification code by a system administrator according to an exemplary embodiment of the present invention.

24 is a flowchart illustrating a process of inputting a catalog goods middle classification code by a system administrator according to an exemplary embodiment of the present invention.

25 is a flowchart illustrating a process of inputting a catalog product attribute code by a system administrator according to an exemplary embodiment of the present invention.

26 is a flowchart illustrating a process of inputting a catalog product by a system administrator according to an exemplary embodiment of the present invention.

27 is a flowchart illustrating a process of registering a catalog product to be posted in a shopping mall by a shopping mall manager according to an exemplary embodiment of the present invention.

28 is a flowchart illustrating a process of storing a catalog product in a database by a shopping mall manager according to an exemplary embodiment of the present invention.

29 is a view showing a list of tables included in a product related database and a shopping mall related database according to an exemplary embodiment of the present invention.

30 is a view showing the structure of a product catalog classification table according to an embodiment of the present invention.

31 is a view showing the structure of a product manufacturer table according to an embodiment of the present invention.

32 is a view showing the structure of a catalog product attribute table according to an embodiment of the present invention.

33 is a diagram showing the structure of a catalog details table according to one preferred embodiment of the present invention.

34 is a view showing the structure of a catalog product table according to an embodiment of the present invention.

35 is a view showing the structure of a merchandise classification table according to an embodiment of the present invention.

36 is a diagram showing the structure of an ordered pair table of product classification according to an embodiment of the present invention.

37 is a view showing the structure of a special product order pair table according to an embodiment of the present invention.

38 is a diagram showing the structure of a product information table according to an embodiment of the present invention.

39 is a diagram showing the structure of a merchandise database conversion module according to an embodiment of the present invention.

40 illustrates a storage relationship between a table and a structure of a classification item matching screen according to an exemplary embodiment of the present invention.

FIG. 41 is a view showing a table storage relationship and a structure of a product information matching screen to be updated according to an embodiment of the present invention. FIG.

42 is a view showing the configuration of a catalog product registration (Web21 code input) screen according to an embodiment of the present invention.

43 is a diagram showing the configuration of a catalog product registration (manufacturing code input) screen according to a preferred embodiment of the present invention.

44 is a flowchart illustrating a process of matching a classification code of Web21 and a classification code of a shopping mall according to an exemplary embodiment of the present invention.

45 is a flowchart illustrating a process of matching a web21 table name, a field name, a table name of a shopping mall, and a field name for product information to be updated according to an exemplary embodiment of the present invention.

46 is a flowchart illustrating a process of updating a shopping mall related database of a shopping mall in which a shopping mall is opened in a product database updating server through input of a web21 code according to an exemplary embodiment of the present invention.

FIG. 47 is a flowchart illustrating a process of generating a product-related web page of a shopping mall in which a shopping mall is opened in a product database update server through input of a Web21 code according to an embodiment of the present invention. FIG.

48 is a flowchart illustrating a process of updating a shopping mall related database of a shopping mall in which a shopping mall is opened in a product database update server through a manufacturer code input according to an exemplary embodiment of the present invention.

49 is a flowchart illustrating a process of generating a product-related web page of a shopping mall in which a shopping mall is opened in a product database update server through a manufacturer code input according to an exemplary embodiment of the present invention.

50 is a flowchart illustrating a process of generating a web page for a catalog product to be posted in a shopping mall by a shopping mall manager according to an exemplary embodiment of the present invention.

51 is a flowchart illustrating a process of providing product information regarding a catalog product to be posted in a shopping mall and a product posting location to a separate shopping mall server according to an exemplary embodiment of the present invention.

<Explanation of symbols for main parts of drawing>

101; Commodity database update server 105; firewall

103; Commodity database update module 107; Web server

109; UMS server 111; Billing system

113; Shopping mall manager 115; visitor

123; Product relations database 125; Mall Related Databases

133; System administrator 135; Commodity database manager

According to an aspect of the present invention to achieve the above object, in the product database update server to automatically update the shopping mall based on the network, the product database conversion module in response to the request of the shopping mall manager to manage the shopping mall And receiving the product selection information from the shopping mall manager, searching and transmitting the catalog product information corresponding to the product selection information and the corresponding basic classification item, wherein the basic classification item is classified by the product database update server. Means an item, the product database conversion module, when executed in the shopping mall, receives classification item matching information from the shopping mall manager to generate a classification item matching table, wherein the classification item matching table corresponds to a basic classification item and a corresponding item. Mall classification And an item; when receiving the catalog product information and the corresponding basic classification item from the product database update server, converting the basic classification item into a shopping mall classification item using the classification item matching table, and converting the shopping mall. A network-based shopping mall automatic updating method for updating a shopping mall by using a classification item and the catalog product information, and an apparatus and system corresponding to the method may be provided.

According to another aspect of the present invention to achieve the above object, in the product database update server to automatically update the shopping mall on the basis of the network, by receiving the classification item matching information from the shopping mall manager to obtain a classification item matching table Generate, wherein the classification item matching table includes a basic classification item and a shopping mall classification item corresponding thereto, and receives product selection information from the shopping mall manager, and catalog product information corresponding to the product selection information and corresponding items. A network-based shopping mall automatic updating method of searching for a basic classification item, converting the basic classification item into a shopping mall classification item using the classification item matching table, and updating the shopping mall using the shopping mall classification item and the catalog product information; Corresponding to the above method An apparatus and system can be provided.

According to another aspect of the present invention to achieve the above object, in the product database update server to automatically update the shopping mall based on the network, receiving the product selection information from the shopping mall manager, the product selection information Provides a network-based shopping mall automatic updating method for retrieving the catalog product information corresponding to the basic classification items corresponding to the catalog goods information, and updating the shopping mall by using the basic classification items and the catalog product information, apparatus and system corresponding to the method can do.

The catalog product information includes a manufacturer product code of a product, and may include at least one of a product image, a large classification code, a middle classification code, an attribute code, a manufacturer code, a manufacturer product type code, and a product introduction content corresponding to the product. have.

The product selection information may be a manufacturer code or a manufacturer product code given by the manufacturer.

The product selection information may be a manufacturer code, a manufacturer product classification code, or a manufacturer product code assigned by the manufacturer.

The product selection information may be a Web21 product code given by Web21.

The web 21 product code may be previously matched with a manufacturer code, a manufacturer product classification code, and a manufacturer product code by the product database update server.

The product selection information may be information corresponding to at least one product or information corresponding to a specific product group.

The catalog product information may be registered by at least one of a product database manager, a manufacturer, and a supplier of the product database update server, and stored in a product related database coupled with the product database update server.

When the product database conversion module is executed in the shopping mall or the product database update server, the product database conversion module receives database matching information from the shopping mall manager to generate a database matching table, wherein the database matching table is a basic database item and a corresponding shopping mall database item. It may include.

The basic database item may include a product related table and fields stored in a product related database coupled with the product database update server.

The shopping mall database item may be a product related table and a field stored in a shopping mall related database coupled with the shopping mall server.

The network may be a wired or wireless network.

Next, preferred embodiments of the present invention will be described in detail with reference to the accompanying drawings.

1 is a block diagram of a wired network-based shopping mall automatic update system according to an embodiment of the present invention.

Referring to FIG. 1, the product database update server 101 is combined with a web server 107, a UMS server (Unified Messaging System server) 109, a payment system (through a network 121). 111).

The computer 117 of the shopping mall manager 113 and the computer 119 of the visitor 115 are connected to the web server 107 via the network 121.

A firewall 105 is provided between the web server 107 and the computer 117 of the shopping mall manager 113 and the computer 119 of the visitor 115.

The merchandise database update server 101 includes a merchandise database update module 103 and is combined with a merchandise related database 123a and a shopping mall related database 125a.

The computer 129 of the system manager 133 and the computer 131 of the product database manager 135 are connected to the web server 107 via the network 127.

The web server 107 provides a shopping mall information input screen (refer to FIG. 10 below) in which the system manager 133 can create a shopping mall of a store that a user wants to open a shopping mall related to a product through a network.

In addition, the web server 107 provides a general product registration screen (see FIG. 18 below) in which the shopping mall manager 113 may register general products through the network 121.

In addition, the web server 107 provides a catalog product registration screen (see FIGS. 19A and 19B below) in which the shopping mall manager 113 may register a catalog product through the network 121.

In addition, the web server 107 is a catalog product classification classification input screen, catalog product middle classification input screen, catalog product attribute input screen, catalog product summary and attribute input screen, catalog that allows a product database administrator to build a catalog product in a product related database A product detailed description input screen is provided (see FIGS. 12, 13, 14, 15, and 16 below).

The product database updating module 103 receives the shopping mall establishment related information received from the system manager 133 and opens the shopping mall for the store, or receives the information modification request of the shopping mall from the shopping mall manager 113 and modifies the shopping mall information. .

In addition, the product database update module 103 receives the product classification code related information, the middle classification code related information, the product attribute code related information, the catalog product related information from the merchandise database manager 135, and stores it in the merchandise related database 123a. Information is extracted from the product related database 123a.

In addition, the product database updating module 103 receives a general product related information storage request from the shopping mall manager 113 and stores the request in the product related database 123a.

In addition, when the shopping mall is opened in the product database update server, the product database update module 103 extracts the catalog product list and transmits the catalog product list to the shopping mall manager 113 when the shopping mall manager 113 receives the catalog product list request.

In addition, the shopping mall manager 113 receives the product selection information and the product posting position of the catalog product to be posted in the shopping mall and stores the received information in the shopping mall related database 125a corresponding to the shopping mall. The product posting position means a position where the corresponding product is posted in a classification item having a hierarchical structure. For example, for a product named XXCCYY, which is a CPU of Company A mounted on the computer's mainboard, within the computer-related product classification system, when the major category is the basic device and the middle category is to be posted to the CPU, the code corresponding to each category is This can be information indicating where to publish. The article may also have a plurality of posting locations. For example, CCDDQQ, a women's wear of Company B, may be simultaneously posted on a posting location where a large category is women-related merchandise, and a mid-class category is clothing, and a posting location where a major category is a special product.

Here, UMS [UMS] is a system that stores and manages all message types of various types such as voice, fax, and e-mail in a single logical mailbox, and the messages are not only PCs but also various communication media such as telephones, faxes, and mobile phones. Can be accessed. It also integrates wired and wireless telephones and data communications networks to search, compose and exchange different types of messages, including voicemail, fax and e-mail, all in one mailbox, so users only need to learn one interface regardless of message type. .

The background of UMS has been developed based on different technologies such as voice communication technology and data communication technology.However, with the emergence of Voice Over Internet Protocol (VoIP), a technology that can process data digitally and process it as text information, This is because the distinction between voice communication and data communication is blurred. The convergence of voice and data has led to the emergence of solutions that enable the effective management and interactive use of numerous messages in any form. In addition, the development and rapid spread of the Internet technology is changing the communication service base to the Internet.

As the market of companies, telecommunications, etc. changes rapidly, users have a desire to integrate and process various types of information that come to them, and the system that satisfies these user requirements as well as cost is the next generation. UMS, also known as Computer-Telephony Integration (CTI) technology.

The following <Example 1> and <Example 2> are the embodiments with respect to FIG.

In <Embodiment 1> and <Embodiment 2>, a shopping mall is established in the product database update server 101. FIG.

Here, <Embodiment 1> is an embodiment in which the product information and the posting location are stored in the shopping mall related database 125a corresponding to the shopping mall, corresponding to the product selection information and the posting location selected by the shopping mall manager. Is an embodiment of generating a web page for each product with respect to the product information and the posting position.

In <Embodiment 1> and <Embodiment 2>, the process of the shopping mall manager 113 of the store opening the shopping mall on the product database update server 101 is as described below.

The shopping mall manager 113 accesses the web server 107 of the product database update server 101 through the network 121 and receives a store opening page request. When the store establishment page corresponding to the store establishment page request is transmitted to the mall manager 113, the mall manager 113 inputs store information to each item of the store establishment page. The merchandise database update server 101 receives the entered store information, and the system manager 133 of the merchandise database update server 101 approves the opening of the store. Then, the store is added to the list of stores in the product related database 123a coupled with the product database update server 101, and the shopping mall related database 125a for the store is generated, and the web server 107 displays the store for the store. Web program related files are created.

Here, a separate URL is assigned to the shopping mall, and the database items related to the catalog product related classification system and the product information of the shopping mall related database 125a are combined with the product database update server 101 and the product related database 123a. It is generated in the same form as the classification system and product information.

When a store is generated as described above, the visitor 115 may visit a store opened in the product database update server 101 through the network 121 to purchase a product or use a service.

The commodity database manager 135 displays a large classification input screen (see FIG. 12 below) for a catalog product provided by the web server 107 of the commodity database update server 101, and a middle classification input screen (see FIG. 13 below). Information on various products through the attribute code input screen (see FIG. 14 below), the product summary and the attribute input screen (see FIG. 15 below), and the product detail description input screen (see FIG. 16 below). Build in advance.

The shopping mall manager 113 who opens a shopping mall in the product database related server 101 through the catalog product data thus constructed selects a product and a product posting location as follows to update the shopping mall.

The manager 113 of the shopping mall first logs in to the shopping mall manager screen (not shown) through the network 121 to the web server 107 of the product database update server 101.

When the shopping mall manager 113 who successfully logs in to the manager screen requests a catalog product registration screen as shown in FIGS. 19A and 19B, the product database update server 101 transmits a catalog product registration screen corresponding to the request.

The shopping mall manager 113 selects a category for a product to be registered in the shopping mall. Then, a catalog product corresponding to the classification item is extracted from the catalog product table of FIG. 34 of the product related database 123a coupled with the product database update server 101, and the catalog product list screen is displayed to the shopping mall manager 113. Is sent.

The shopping mall manager 113 may select a product to be posted in its shopping mall from the catalog product list on the received catalog product list screen, and apply differently to each shopping mall such as a sale price, a discount price, a consumer price, and a discount period for the posted product. Enter the information you can.

After adding the location where the product will be posted among the product classification items of the shopping mall, and clicking the register the selected catalog product button, the shopping mall is updated in different ways in <Example 1> and <Example 2>, and each is as follows. .

<Example 1>; Opening a shopping mall in the product database update server 101 (stores product information in a shopping mall related database corresponding to the shopping mall).

The product selection information and the product posting position are transmitted to the product database update server 101.

The merchandise database update server 101 then performs a catalog merchandise table (see FIG. 34 below) and a catalog merchandise detail table (see FIG. 33 below) of the merchandise related database 123a coupled with the merchandise database update server 101. Extract product information on the selected product list from the list.

The merchandise database update module 103 uses the extracted merchandise information as an order pair table (refer to FIG. 36 below) of a merchandise classification in the mall related database 125a corresponding to the mall, and a special merchandise order pair table (refer to FIG. 37 below). , A product information table (see FIG. 38 below), and the like.

<Example 2>; The shopping mall is opened in the product database update server 101 (creating a web page for each product in a web server combined with the product database update server).

The product selection information and the product posting position are transmitted to the product database update server 101 of the shopping mall.

The merchandise database update server 101 then uses the catalog merchandise table (see FIG. 34 below) and the catalog merchandise detail table of the merchandise related database 123a coupled with the merchandise database update server 101 (see FIG. 33 below). ) Extracts product information on the selected product list.

The commodity database update module 103 arranges the commodity information extracted in the commodity according to a screen form of a predetermined shopping mall to generate a web page corresponding to the commodity of the shopping mall.

1 may be applied in the same manner to a wireless mobile terminal device of a shopping mall manager, a visitor, a system manager, and a product database manager based on a wireless network.

2 is a block diagram of a network-based shopping mall automatic update system according to another preferred embodiment of the present invention.

2, the product database update server 101, the product database update module 103, the firewall 105, the web server 107, the UMS server 109, the payment system 111, and the shopping mall manager 113. , Visitor 115, computer of a shopping mall manager 117, computer 119 of a visitor, network 121, system manager 133, product database manager 135, system manager computer 129, product database manager The computer 131 and the network 127 are the same as described above with reference to FIG. 1.

The product database update module 103 receives a catalog product list request from the shopping mall manager 113 when the shopping mall includes a shopping mall server 201 separate from the product database update server 101, and extracts the catalog product list. Send to the shopping mall manager 113. Then, the shopping mall manager 113 receives the product selection information and the product posting position of the catalog product to be posted in the shopping mall. Then, the product information corresponding to the received product selection information is extracted from the product code database 123b, and the extracted product information and the product posting position are transmitted to the shopping mall server 201.

When the shopping mall server 201 receives the product information and the product posting position, the product database conversion module 203 updates the product database in advance through the product information matching screen 4101 to be updated in the following price product information input portion 1907. Each field value of the goods-related tables set between the server 101 and the shopping mall server 201 is updated.

Here, the received product information and the product posting location are stored in a shopping mall related database 125b coupled with the shopping mall server 201 or a web page for a product on a web server (not shown) coupled with the shopping mall server 201. Is generated and the shopping mall is updated.

The following <Example 3>, <Example 4>, <Example 5>, and <Example 6> are the embodiments with respect to FIG.

<Embodiment 3>, <Embodiment 4>, and <Embodiment 5> and <Embodiment 6> all relate to a shopping mall automatic update method performed in a state where there is a product database update server 101 and a separate shopping mall server 201. Example.

<Embodiment 3> and <Embodiment 4> are embodiments of a shopping mall automatic updating method performed in a state where the product database conversion module is transmitted from the product database update server 101 and provided in the shopping mall server.

<Embodiment 5> and <Embodiment 6> are embodiments of a shopping mall automatic updating method performed in a state where the product database conversion module is provided in the product database update server 101.

Here, <Embodiment 3> is an embodiment in which the product information received from the product database update server 101 is stored in the shopping mall related database 125b coupled to the shopping mall server 201. <Embodiment 4> is an embodiment in which a web page for each product is generated for the received product information in a web server (not shown) coupled with the shopping mall server 201.

<Embodiment 5> is an embodiment in which the product information received from the product database update server is stored in the shopping mall related database 125b coupled to the shopping mall server 201. <Embodiment 6> is an embodiment in which a web page for each product is generated with respect to the received product information in a web server (not shown) coupled with the shopping mall server 201.

The catalog goods related classification system of the shopping mall related database 125b coupled with the shopping mall server 201 and the database items related to the product information are the goods related database 123b coupled with the goods database update server 101 for automatic shopping mall update. It may be associated in advance in the same form as the classification system and product information.

In addition, the shopping mall manager may match each of the classification scheme provided by the product database update server and the classification scheme of the shopping mall, and the matching items may be generated in the classification item matching table for updating the product information.

The merchandise database manager 135 of the merchandise database update server 101 can display a large category input screen, a middle classification input screen, an attribute code input screen, and a merchandise summary for catalog products provided by the web server 107 of the merchandise database update server 101. And information about various products is pre-built through an attribute input screen and a product detailed description input screen.

The shopping mall manager 113 of the shopping mall server 201, which has previously cooperated with the product database update server 101, selects the product and the product posting position as described below to update the shopping mall.

The manager 113 of the shopping mall first logs in to the shopping mall manager screen (not shown) through the network 121 to the web server 107 of the product database update server 101.

When the shopping mall manager 113 who successfully logs in to the manager screen requests a catalog product registration screen as shown in FIGS. 19A and 19B, the product database update server 101 transmits a catalog product registration screen corresponding to the request.

The shopping mall manager 113 selects a category for a product to be registered in the shopping mall. Then, a catalog product corresponding to the classification item is extracted from the catalog product table of FIG. 34 of the product related database 123b coupled with the product database update server 101, and the catalog product list screen is displayed to the shopping mall manager 113. Is sent.

The shopping mall manager 113 may select a product to be posted in its shopping mall from the catalog product list on the received catalog product list screen, and apply differently to each shopping mall such as a sale price, a discount price, a consumer price, and a discount period for the posted product. Enter the information you can.

After adding the location where the product will be posted among the merchandise classification items of the shopping mall, and clicking the register the selected catalog product button, in <Example 3>, <Example 4>, <Example 5>, and <Example 6> The shopping mall is updated in another way, each as follows.

<Example 3>; There is a shopping mall server 201 separate from the product database update server 101 and a product database conversion module is provided in the shopping mall server 201 (stores product information in the shopping mall related database 125b of the shopping mall).

The product selection information and the product posting position are transmitted to the product database update server 101 of the shopping mall.

The merchandise database update server 101 then performs a catalog merchandise table (see FIG. 34 below) and a catalog merchandise detail table (see FIG. 33 below) of the merchandise related database 123b coupled with the merchandise database update server 101. Extract product information on the selected product list from the list.

The product database update module 103 transmits the extracted product information to the shopping mall server 201.

Then, the product database conversion module 203 of the shopping mall server 201 extracts a shopping mall classification item corresponding to the basic classification item of the received product information from the classification item matching table of the shopping mall related database.

The merchandise database conversion module 203 extracts a table name and a field name to be updated in the shopping mall related database from the database matching table.

The product information and a shopping mall classification item are stored in a product related table of a shopping mall related database 125b coupled with a shopping mall server.

<Example 4>; There is a shopping mall server 201 separate from the product database update server 101 and a product database conversion module is provided in the shopping mall server 201 (a web server (not shown) coupled with the shopping mall server 201) to each product. Web page generation).

The product selection information and the product posting position are transmitted to the product database update server 101 of the shopping mall.

The merchandise database update server 101 then performs a catalog merchandise table (see FIG. 34 below) and a catalog merchandise detail table (see FIG. 33 below) of the merchandise related database 123b coupled with the merchandise database update server 101. Extract product information on the selected product list from the list.

The shopping mall server 201 generates the web page corresponding to the product of the shopping mall by receiving the extracted product information and arranging it according to a preset screen form of the shopping mall.

<Example 5>; There is a shopping mall server 201 separate from the commodity database update server 101 and a commodity database conversion module is provided in the commodity database update server 101 (store commodity information in a mall related database 125b of a mall).

The product selection information and the product posting position are transmitted to the product database update server 101 of the shopping mall.

The merchandise database update server 101 then performs a catalog merchandise table (see FIG. 34 below) and a catalog merchandise detail table (see FIG. 33 below) of the merchandise related database 123b coupled with the merchandise database update server 101. Extract product information on the selected product list from the list.

The product database conversion module 203 of the product database update server 101 extracts a shopping mall classification item corresponding to the basic classification item of the received product information from the classification item matching table of the shopping mall related database.

The merchandise database conversion module 203 extracts a table name and a field name to be updated in the shopping mall related database from the database matching table.

The product information and the shopping mall classification item are stored in a product related table of the shopping mall related database 125b coupled with the shopping mall server 201.

<Example 6>; There is a shopping mall server 201 separate from the product database update server 101 and a product database conversion module is provided in the product database update server 101 (web server (not shown) combined with a shopping mall server) for each product. Web page generation).

The product selection information and the product posting position are transmitted to the product database update server 101 of the shopping mall.

The merchandise database update server 101 then performs a catalog merchandise table (see FIG. 34 below) and a catalog merchandise detail table (see FIG. 33 below) of the merchandise related database 123b coupled with the merchandise database update server 101. Extract product information on the selected product list from the list.

The commodity database update server 101 receives the extracted commodity information and arranges it according to a preset screen form of the mall to generate a web page corresponding to the commodity in the mall server 201.

2 may be applied in the same manner to a wireless mobile terminal device of a shopping mall manager, a visitor, a system manager, and a product database manager based on a wireless network.

As described above, in the <Embodiment 1> and <Embodiment 2> of FIG. 1, and <Embodiment 3> and <Embodiment 4> of FIG. 2, the shopping mall manager 113 updates the product information of the shopping mall. Then, the product database update server 101 transmits the price for providing the product information according to the contents previously associated with the store in which the shopping mall is opened to the payment system 111 through the network 121. The updated product information is transmitted to the shopping mall manager 113 through a UMS server 109 through a fax, an e-mail, a message of a mobile phone, and the like.

3 is a view showing the configuration of a product database update module according to an embodiment of the present invention.

Referring to FIG. 3, the product database update module 315 is composed of a transmission unit 301, a reception unit 303, an interface unit 305, a memory unit 307, and a database processing unit 305.

The database processing unit 305 extracts information from the product related database 311 and the shopping mall related database 313 and transmits the information to the transmission unit 301, or transmits the information transmitted from the receiving unit 303 to the product related database 123 (hereinafter, referred to as 123). Represents 123a and 123b) or a shopping mall related database 125 (hereinafter, 125 represents 125a and 125b).

4 is a diagram illustrating a menu and function description of shopping mall management according to an exemplary embodiment of the present invention.

Referring to FIG. 4, the shopping mall management 401 includes menus such as shopping mall information management 403, shopping mall template management 405, and product introduction management 407.

5 is a diagram illustrating a menu and a function description of shopping mall exhibition management according to an exemplary embodiment of the present invention.

Referring to FIG. 5, the product display management 501 includes menus such as product classification management 503 and product management 505.

6 is a diagram illustrating a menu and a function description of catalog product management according to an exemplary embodiment of the present invention.

Referring to FIG. 6, the catalog product management 601 is constituted by a catalog service menu 603.

7 is a diagram illustrating a menu and a function description of order management according to an embodiment of the present invention.

Referring to FIG. 7, the order management 701 is composed of menus such as payment management 703 and delivery management 705.

8 is a diagram illustrating a menu and a function description of statistics management according to an exemplary embodiment of the present invention.

Referring to Fig. 8, the statistics management 801 is composed of menus such as order statistics 803, connection status 805, and the like.

9 is a diagram illustrating a menu and a function description of information management according to an embodiment of the present invention.

Referring to Fig. 9, information management 901 is composed of menus such as member management 903, news management 905, database management 907, e-mail document management 909, and the like.

10 is a shopping mall information input screen according to an embodiment of the present invention.

Referring to FIG. 10, the store information input portion 1003 of the shopping mall information input screen 1001 may include a shopping mall name, a shopping mall identifier (hereinafter referred to as a shopping mall ID), a shopping mall description, a shopping mall name, a business start time, a business end time, and a temporary time. It includes items such as closing date, temporary closing date, order amount based on excellent membership, business number and representative.

Upon receiving a request for opening a shopping mall and corresponding information from a shopping mall manager who wants to open a new shopping mall, the system manager inputs shopping mall-related information on the shopping mall information input screen and opens a new shopping mall.

When the store generation button 1005 is pressed, a new shopping mall is created with the contents input or selected by the system administrator.

When the initialization button 1007 is pressed, each item of a screen input or selected by the system administrator is changed to an initial value so that the shopping mall-related information can be re-entered.

11 is a shopping mall design selection screen according to an embodiment of the present invention.

Referring to FIG. 11, the shopping mall design selection screen 1101 includes a top menu configuration 1103, a left menu configuration 1105, a main screen 1107, a product detail screen 1109, and a template selection portion 1111. have.

12 is a catalog product classification classification input screen according to an embodiment of the present invention.

12, in the left frame of the catalog product classification classification input screen 1201, the classification code input 1203, the classification code input 1205, the manufacturer code input 1207, the specification code input 1209, and the catalog input (not shown). City), manufacturer modifications (not shown), and catalog list (not shown).

The catalog product large classification input screen 1201 is comprised of the large classification code, the large classification code name input part 1211, and the large classification code list display part 1213.

13 is a catalog product classification classification input screen according to an exemplary embodiment of the present invention.

Referring to FIG. 13, the catalog goods middle classification input screen 1301 includes a large category selection portion 1303, a middle classification code input portion 1305, a middle classification code name input portion 1307, a middle classification code list display portion 1309, and a completion button. It consists of 1311.

14 is a catalog product attribute input screen according to an exemplary embodiment of the present invention.

Referring to FIG. 14, the catalog product attribute input screen 1401 includes an attribute list display portion 1403, a large classification display portion 1405, an attribute code input portion 1407, an attribute code name input portion 1409, and attribute code descriptions. It consists of an input portion 1411.

15 is a catalog product summary and attribute input screen according to a preferred embodiment of the present invention.

Referring to FIG. 15, the catalog product summary and attribute input screen 1501 includes a model name input portion 1503, specification information input portion 1505, a cancel button 1507, a ReSet button 1509, and a next button ( 1511).

16 is a catalog product detail input screen according to an embodiment of the present invention.

Referring to Fig. 16, the catalog product detail description input screen 1601 includes a section description title input section 1603, a picture file attachment section 1605, a picture file arrangement setting section 1607, a section description input section 1609, A description add button 1611, cancel button 1613, ReSet (initialization) button 1615, and next button 1615 are configured.

17 is a product classification registration screen according to an embodiment of the present invention.

Referring to FIG. 17, the product classification registration screen 1701 includes a classification code portion 1703, a classification name input portion 1705, a sub classification list template selecting portion 1707, a sample list template selecting portion 1709, and whether to display or not. A portion 1711, a classification image portion 1713, a classification image information input portion 1715, a classification information input portion 1725, a correction button 1719, a reentry button 1721, and a delete button 1723. have.

18 is a general product registration screen according to an embodiment of the present invention.

Referring to FIG. 18, the general product registration screen 1801 is a screen for registering a product not provided by the product database update server.

The general product registration screen 1801 includes a product information input portion 1803 such as a product code, a product name, a product summary, a product display division, a consumer, a product image, a product information modification button 1805, a reset button 1807, and a voice. It consists of a record button 1809.

19A and 19B are catalog product registration screens according to an exemplary embodiment of the present invention.

19A and 19B, the catalog product registration screen 1901 may include a manufacturer selection part 1901, a product classification selection part 1905, a price product information input part 1907, a product registration setting part 1915, The product posting position selection portion 1909, the selected product posting position display portion 1911, and the selected catalog product registration button 1913 are configured.

20 is a catalog product input result screen according to an exemplary embodiment of the present invention.

Referring to FIG. 20, the catalog product input result screen 20 includes a cash selling price 20, a card selling price 20, a quantity selection part 20, a shopping cart button 20, and a product detail introduction part 20. It is.

21 is a flowchart illustrating a process of inputting shopping mall information by a system manager according to an exemplary embodiment of the present invention.

Referring to FIG. 21, when receiving shopping mall information from the system manager (S2101), an error of the received store information is checked (S2103). For example, it is checked whether a non-numeric character or a special symbol is included in an item to be input numerically among the inputted shopping mall information, and whether a postal code input as shopping mall information is correct.

If there is an error as a result of the check, a shopping mall information input error message is transmitted to the system administrator (S2107).

If there is no error as a result of the check, a shopping mall database is generated (S2109), a shopping mall file is generated (S2111), and a shopping mall creation completion message is transmitted to the system administrator (S2113).

22 is a flowchart illustrating a process of modifying shopping mall information by a shopping mall manager according to an exemplary embodiment of the present invention.

Referring to FIG. 22, a shopping mall ID, a shopping mall manager ID, and a password are received from the shopping mall manager (S2201). The shopping mall manager ID and password received from the shopping mall related database 125 coupled with the product database update server are checked (S2203).

If the shopping mall manager ID and password received as a result of the check are incorrect, the administrator screen login failure message is transmitted to the shopping mall manager (S2209).

If the shopping mall manager ID and password received as a result of the check are transmitted, the shopping mall information modification screen is transmitted (S2211).

When receiving shopping mall information or a shopping mall design modification request from a shopping mall manager (S2213), the received shopping mall information or shopping mall design information is stored in the shopping mall relation database 125 coupled with a product database update server (S2215).

23 is a flowchart illustrating a process of inputting a catalog product classification code by a system administrator according to an exemplary embodiment of the present invention.

Referring to FIG. 23, when a large classification code and a large classification code name are received from a merchandise database manager (S2301), the same large classification code is extracted from the merchandise related database 123 coupled with the merchandise database update server (S2303).

If there is a large classification code identical to the large classification code received as a result of the extraction, a message indicating that there is the same large classification code is transmitted (S2307).

If there is no large classification code identical to the large classification code received as a result of the extraction, the large classification code received in the product related database 123 coupled with the product database updating server is stored (S2309).

24 is a flowchart illustrating a process of inputting a catalog goods middle classification code by a system administrator according to an exemplary embodiment of the present invention.

Referring to FIG. 24, upon receiving the selected major classification code, the entered middle classification code, and the middle classification code name (S2401), the same classification code is extracted from the product related database 123 coupled with the product database update server (S2403). )do.

If there is a middle classification code that is identical to the middle classification code received as a result of the extraction, a message indicating that there is the same middle classification code is transmitted (S2407).

If there is no middle classification code identical to the middle classification code received as a result of the extraction, the middle classification code received in the product related database 123 coupled with the product database updating server is stored (S2409).

25 is a flowchart illustrating a process of inputting a catalog product attribute code by a system administrator according to an exemplary embodiment of the present invention.

Referring to FIG. 25, a large and medium classification code for a catalog product is received from a product database manager (S2501), and a product attribute code for a catalog product is received (S2503).

The product attribute code received from the product related database 123 coupled with the product database update server is extracted (S2505).

If the product attribute code received as a result of the extraction is already registered, a message that there is the same product attribute code from the product database manager is transmitted (S2509).

If there is no registered product attribute code received as a result of the extraction, the received product attribute code is stored in the product related database 123 coupled with the product database update server (S2511).

26 is a flowchart illustrating a process of inputting a catalog product by a system administrator according to an exemplary embodiment of the present invention.

Referring to FIG. 26, a large and medium classification of a catalog product is received from a product database manager (S2601), a product summary of the catalog product is received (S2603), and a detailed description of the catalog product is received (S2605).

When a description addition request is received from the product database manager (S2607), a detailed description of the catalog product is received again (S2605).

If there is no request for adding a description from the product database manager, a large classification, a middle classification, a product summary, and a detailed description of the catalog product received in the product related database 123 coupled with the product database update server are stored (S2609).

27 is a flowchart illustrating a process of registering a catalog product to be posted in a shopping mall by a shopping mall manager according to an exemplary embodiment of the present invention.

Referring to FIG. 27, when receiving the use catalog product database from the shopping mall manager (S2701), the shopping mall manager determines whether to use the product catalog database (S2703).

If the shopping mall manager does not use the catalog database as a result of the determination, the shopping mall manager receives the product information input by the shopping mall manager (S2705) and stores the received product information in the shopping mall related database 125a coupled with the product database update server (S2715). do.

As a result of the determination, when the shopping mall manager uses the catalog database, a product classification code and a middle classification code are received from the shopping mall manager (S2707).

A catalog product list corresponding to the large classification code and the middle classification code received from the product related database 123 coupled with the product database update server is extracted (S2709).

The extracted catalog product list is transmitted to the shopping mall manager (S2711).

Upon receiving the product selection information and the product posting position to be registered in the shopping mall from the shopping mall manager (S2713), the received product selection information and the product posting position are stored in the shopping mall related database 125a coupled with the product database update server (S2715). )do. Here, the product selection information may be 'manufacturer code and manufacturer's product code', 'manufacturer code, manufacturer's product classification code, manufacturer's product code', and 'webs21 product code granted by web21'.

A product corresponding to the stored product selection information is extracted from a shopping mall related database corresponding to the shopping mall and provided to a product list of the product posting location. When a visitor of a shopping mall requests information about the product, product information about the product selection information is extracted from a shopping mall related database and provided to the visitor.

Here, the product information is a product code, a product image, a major classification code, a middle classification code, an attribute code, a manufacturer code, a manufacturer product classification code, a manufacturer product code, and a product introduction content.

28 is a flowchart illustrating a process of storing a catalog product in a database by a shopping mall manager according to an exemplary embodiment of the present invention.

Referring to FIG. 28, a product classification, a middle classification, and a manufacturer are received from a shopping mall manager (S2801). The product attribute code and the product code are received from the shopping mall manager (S2803). Here, the product code may be 'manufacturer code and manufacturer's product code', 'manufacturer code, manufacturer's product classification code, manufacturer's product code', and 'webs21 product code granted by web21'.

From the shopping mall related database 125 coupled with the product database update server, the same information as the large classification, the middle classification, the manufacturer, the product attribute code, and the product code received in the shopping mall of the shopping mall manager is extracted (S2805).

If there is the same information as the classification, the classification, the manufacturer, the product attribute code, the product code received as a result of the extraction, and transmits a message to the shopping mall manager that there is the same information registered in the shopping mall (S2809).

If there is no same information as the classification, the classification, the manufacturer, the product attribute code, and the product code received as a result of the extraction, the classification, the classification, the manufacturer, the product attribute code, the product received in the shopping mall related database 125 coupled with the product database update server The code is stored (S2811).

29A and 29B are diagrams showing a list of tables included in a product related database and a shopping mall related database according to an exemplary embodiment of the present invention.

29A and 29B, the merchandise related database 123 includes a merchant table 2903, a store table 2905, a template table 2907, a shopping cart table 2909, a shopping cart detail table 2911, and an order table ( 2913), order detail table 2915, division code table 2917, notice table 2919, member table 2921, product catalog classification table 2913, product manufacturer table 2925, catalog product attribute table ( 2927), a catalog detail description table 2929, and a catalog product table 2927.

The shopping mall related database 125 includes a merchandise classification table 2935, a merchandise classification pair table 2937, a special merchandise ordered pair table 2939, a merchandise information table 2941, a merchandise attribute table 2943, and a merchandise- merchandise classification attribute. A table 2945, a product attribute group table 2927, a product classification item table 2959, and a BBS information table (bulletin board information table) 2955.

30 is a diagram showing the structure of a product catalog classification table according to an embodiment of the present invention.

Referring to FIG. 30, the product catalog classification table 2913 includes information such as a catalog classification ID (catalog classification identifier), a catalog classification name, a higher catalog classification ID (upper catalog classification identifier), a catalog classification, and the like.

The catalog classification ID (catalog classification identifier) is a primary key to which each piece of information in the product catalog classification table 2913 is distinguished.

31 is a diagram showing the structure of a product manufacturer table according to an embodiment of the present invention.

Referring to FIG. 31, the product manufacturer table 2925 includes information such as a manufacturer ID (manufacturer identifier), a catalog classification ID (catalog classification identifier), a manufacturer name, a catalog name, and the like.

The manufacturer ID (manufacturer identifier) and catalog classification ID (catalog classification identifier) are primary keys for distinguishing each piece of information from the product manufacturer table 2925.

32 is a diagram showing the structure of a catalog product attribute table according to an embodiment of the present invention.

Referring to FIG. 32, catalog product attribute table 2927 includes information such as catalog classification ID (catalog classification identifier), attribute ID (attribute identifier), attribute name, attribute description, attribute display (attribute display status) or the like. .

The catalog classification ID (catalog classification identifier) and the attribute ID (attribute identifier) are primary keys to which respective pieces of information of the catalog product attribute table 2927 are distinguished.

33 is a diagram showing the structure of a catalog detailed description table according to an embodiment of the present invention.

Referring to FIG. 33, the catalog detail description table 2929 includes a manufacturer ID (manufacturer identifier), a catalog product ID (catalog product identifier), a description add SEQ (description add sequence), a detailed description title, a picture position, a picture file name, and a picture. Includes information such as file description.

The manufacturer ID (manufacturer identifier), catalog product ID (catalog product identifier), and description addition SEQ (description addition sequence) are primary keys for distinguishing each piece of information in the catalog detail description table 2927.

34 is a diagram showing the structure of a catalog product table according to an embodiment of the present invention.

Referring to FIG. 34, the catalog product table 2927 includes a catalog classification ID (catalog classification identifier), a product name (model name), a catalog classification, a product catalog ID, a product level, a product picture, a product last input date, an attribute code 1, and an attribute code. 2, attribute code 3, attribute code 4, attribute code 5 and the like.

The catalog classification ID (catalog classification identifier) and the product name (model name) are primary keys for distinguishing respective pieces of information from the catalog product table 2927.

35 is a diagram showing the structure of a merchandise classification table according to an embodiment of the present invention.

Referring to FIG. 35, the product classification table 2935 includes information such as a product classification ID (product classification identifier), a product classification form, a higher product classification ID (higher product classification identifier), and a product classification name.

The product classification ID (product classification identifier) is a primary key for distinguishing each piece of information in the product classification table 2935.

36 is a diagram showing the structure of an ordered pair table of product classification according to an embodiment of the present invention.

Referring to FIG. 36, the order pair table 2937 of the product classification includes information such as a product classification ID (product classification identifier), a product ID (product identifier), and the like.

The merchandise classification ID (merchandise classification identifier) and the merchandise ID (merchandise identifier) are primary keys for distinguishing respective pieces of information from the ordered pair table 2937 of the merchandise classification.

37 is a view showing the structure of a special product order pair table according to an embodiment of the present invention.

Referring to FIG. 37, the special product order pair table 2939 includes information such as a special product classification ID (special product classification identifier), a product ID (product identifier), importance, start date, end date, event subject, event content, and the like.

The special merchandise classification ID (special merchandise classification identifier) and the merchandise ID (merchandise identifier) are primary keys for distinguishing respective pieces of information from the special merchandise order pair table 2939.

38 is a diagram showing the structure of a product information table according to an embodiment of the present invention.

Referring to Fig. 38, the merchandise information table 2941 includes a merchandise ID (merchandise identifier), a product name, a unit, a consumer, a sale price, a discount price, a discount start date, a discount last date, a small image, a middle image, a large image file, and an image. Includes information such as description, product brief description, product description, presence of exhibits, presence of attributes, presence of merchandise.

The product ID (product identifier) is a primary key for distinguishing each piece of information in the product information table 2941.

39 is a diagram showing the structure of a product database conversion module according to an embodiment of the present invention.

Referring to Fig. 39, the merchandise database conversion module 203 is composed of a transmission unit 3901, a reception unit 3803, a conversion unit 3905, a database processing unit 3907, and a memory unit 3907.

The transmitter 3901 transmits the information received from the converter 3905 to another site through a network.

The receiving unit 3403 receives the information from the product database generation server 101 and sends the information to the conversion unit 3905.

The conversion unit 3905 refers to a rule for commonizing the database field format stored in the memory unit. The conversion unit 3905 converts the product update information received by the receiving unit 3403 to the catalog product related table and field information of the product related database 123 of the product database update server 101 and to the shopping mall related database of the shopping mall server 201 ( Change it to fit the table and field information saved in 125b).

The memory unit 3909 stores rules for commonizing the database field formats that can be processed by the converter 3905.

The database processor 3907 extracts information from the shopping mall relation database 125b coupled with the shopping mall server, or stores the information received by the receiver 3403 and converted by the converter 3905 in the shopping mall relation database 125b.

40 is a diagram illustrating a storage relationship between a table and a structure of a classification item matching screen according to an exemplary embodiment of the present invention.

Referring to FIG. 40, a classification item matching screen 4001 may include a product classification selection part 4003, a shopping mall product classification selection part 4005, and a registered classification item matching list display part 4017 of the web 21 providing catalog product information. ), A new folder button 4011, a move button 4013, a delete button 4015, and a shopping mall classification ID (shopping mall classification identifier) input portion 4033.

In the product classification selection portion 4003 of the web 21, a large classification, a middle classification, and a lower classification list in which the products of the web 21 are classified are displayed. The shopping mall manager may select a major category, a middle category, and a lower category of the web 21 to match the mall category.

The shopping mall product classification selection part 4005 shows a product classification system of the shopping mall. The merchandise classification system can be extended to major classification, middle classification, small classification 1, ...

The merchandise classification system may be created by the shopping mall manager in the same manner as creating, moving, and deleting a folder in the Windows Explorer using the new folder button 4011, the move button 4013, and the delete button 4015.

The registered classification item matching list display portion 4017 shows a matching list of the selected product classification item of the product classification selection part 4003 of the web 21 and the selected product classification item of the shopping mall product classification selection part 4005. Here, the list displayed in the registered classification item matching list display portion 4017 is information stored in the classification item matching table of the shopping mall related database.

When the new folder button 4011 is clicked on, a screen for generating a classification item appears in the shopping mall product classification selection part 4005.

When the move button 4013 is clicked on, a screen for moving a specific classification item of the shopping mall product classification selection portion 4005 to another location of the shopping mall product classification selection portion 4005 appears.

When the delete button 4015 is clicked on, a screen asking whether to delete a specific classification item of the shopping mall product classification selection part 4005 appears.

The shopping mall classification ID (shopping mall classification identifier) input part 4033 is a part which inputs the shopping mall classification ID (shopping mall classification identifier) corresponding to the classification item selected by the shopping mall product classification selection part 4005.

For example, after a shopping mall manager who manages a shopping mall called a happy shopping mall logs in to a shopping mall manager, a classification system of a shopping mall and a classification system provided by the web 21 are set through a classification item matching screen as shown in FIG. 40.

The shopping mall manager first uses the new folder button 4011, the move button 4013, and the delete button 4015 to classify the classification item system of the shopping mall product classification selection part 4005 into a common product (large classification code B00) and a male related product (large classification). Code C00), women-related goods (classification code D00). In addition, a list of clothing (middle classification code D01) and accessories (middle classification code D02) is generated as a middle classification list that is a child of women-related products (classification code D00).

In the product classification selection portion 4003 of the web 21, the shopping mall manager selects a classification item whose major classification is clothing (large classification code 300) and whose middle classification is women's clothing (middle classification code 302). Then, in the shopping mall product classification selection part 4005, a classification item in which the major category is women-related goods (large classification code D00) and the middle classification is clothing (middle classification code D01) is selected. Here, the shopping mall manager intends to register women-related goods and clothing of the happy shopping mall as a category corresponding to clothing and women's clothing in the classification system of Web21.

In order to register a matching classification item, information may be stored by clicking a register button (not shown). In addition, when an event is defined, the classification item is selected in the product classification selection part 4003 of the web 21 and stored by executing an event such as double-clicking the classification item to be registered in the shopping mall product classification selection part 4005. You can do that.

The matching information is stored in the database. The classification code '300' and the classification ID '302' and the shopping mall classification ID (shopping mall classification identifier) input part of the classification item having the major classification code '300' and the middle classification code '302' are stored in the Web21 classification code table. Information of 'PDD0001' input at 4033 is stored in the classification item matching table. Here, the classification item matching table stores information in which the classification item of the product database update server and the classification item of the corresponding shopping mall are matched at the request of the shopping mall manager.

As described above, the classification item matching information on the stored product is processed and stored with the product information according to the classification system in which the classification item is matched when the shopping mall manager later registers the product information of the catalog product registered on the web21. It can be convenient to use. That is, when the shopping mall manager selects products to which product information is to be added later, each of the products is automatically added to the product posting classification item of the shopping mall that matches the position in the product posting classification item of the product database update server.

The list of matching classification items stored as described above is displayed on the registered classification item matching list display portion 4017.

41 is a view showing a structure of a product information matching screen to be updated and a table storage relationship according to an embodiment of the present invention.

Referring to FIG. 41, the product information matching screen 4101 to be updated includes a field information display portion 4103 and a shopping mall product field input portion 4105 of a specific table of the web 21, an add button 4125 to a list to be updated, and a match. Configured field list display portion 4127 and the like.

The field information display portion 4103 of the specific table is a portion in which a list of field names and field descriptions of the specific table selected by the shopping mall manager is displayed among the table list of the product-related database of the web 21.

In this case, the field selection part 4105 of the field to which the product information is to be updated is checked in order to automatically update the product information of the shopping mall.

Click on the detail view icon 4107 in each field to display detailed information about each field in the table.

The shopping mall product field input part 4105 is a part for inputting a field of a product related table that matches the field selected by the field information display part 4103 of the specific table. The product information of the field input to the shopping mall product field input portion 4105 is automatically updated based on the value of the selected field.

When the Add to list to be updated button 4125 is clicked, the specific field of the specific table selected in the field information display portion 4103 of the specific table and the specific field of the specific table of the shopping mall entered in the mall product field input portion 4105 Matching information is stored in a shopping mall related database.

In the matched field list display portion 4127, a field list of the matched shopping mall table is displayed as described above.

For example, it is assumed that the shopping mall manager of the happy shopping mall selects the Catalog_Goods table 2929 from the table list of the product database update server and moves to the product information matching screen 4101 to be updated.

The field selection portion 4105 of the field called Good_ID (product name) is checked in the field list of the Catalog_Goods table 2929 shown in the field information display portion 4103 of the specific table.

In the happy shopping mall product table, 'Product' is input in the table name input part 4111, 'ProductName' is input in the field name input part 4113, 'Product name' is selected in the field description input part 4115, and a field type is selected. In the part 4117, 'Varchar' is input, in the field length input part 4119, '100' is input, in the field, NULL value is not selected in the selectable part 4121, 'NULL is not allowed', and the KEY is selected part 4123 Let's say you chose 'not KEY'.

If you click the Add to list to update button (4125), the 'Good_ID' field of the 'Catalog_Good' table 2931 of the product-related database combined with the product database update server and the 'Product' of the shopping mall. The matching information of the 'ProductName' field of the table is stored as 4129 in the product information matching table of the shopping mall related database 125. Here, the product information matching table stores information in which the table name and field name of the product database update server match the table name and field name of the corresponding shopping mall at the request of the shopping mall manager.

42 is a diagram showing the configuration of a catalog product registration (WebS21 code input) screen according to an embodiment of the present invention.

Referring to FIG. 42, the catalog product registration (web21 code input) screen 4201 may be a web21 product code input part 4203, a product-related amount input part 4205, a product posting position selection part 4207, and be registered. And a product posting position display portion 4209, an add button 4213, a delete button 4215, and a product information registration button 4217 at the product posting position.

The catalog product registration (web21 code input) screen 4201 allows a shopping mall manager to register a product to be updated by inputting a web21 code when the shopping mall manager already knows the web21 code of the product to update the product information. Part.

The web 21 product code input portion 4203 is a portion for inputting a web 21 product code. Here, the shopping mall manager should know the Web21 product code for the product in advance.

In the product-related amount input portion 4205, information such as a selling price, a discounted price, a consumer price, a discount period, etc. to be applied in a shopping mall is input to the product input in the web21 product code input portion 4203.

In the product posting location selection portion 4207, a classification system for displaying a product in a shopping mall is displayed, and the shopping mall manager may select a specific item from the classification system.

In the product posting position display portion 4209 to be registered, a list set as a position to which a product input in the WebS21 product code input portion 4203 is displayed, is displayed in the shopping mall classification system shown in the product posting position selection portion 4207.

When the add button 4213 is clicked on, the specific classification item selected in the product posting position selection portion 4207 is added to the product posting position display portion 4209 to be registered.

When the delete button 4215 is clicked on, a specific classification item selected from the classification items of the product posting position display portion 4209 to be registered is deleted from the product posting position list to be registered.

When the product information registration button 4217 is clicked on the product posting position, the product input in the Web21 product code input portion 4203 is added to the shopping mall posting classification item portion set in the product posting position display portion 4209 to be registered. .

Then, when the visitor accesses the shopping mall site and clicks one of the shopping mall posting classification items, the inputted product is displayed in the product list.

Here, as a method of inputting a product code for a specific product, a method of inputting the web21 product code of FIG. 42 and a method of inputting the manufacturer product code of FIG. 43 may be provided. The matching information of the web 21 product code and the manufacturer product code may be stored in a product related database coupled with the product database update server in advance.

43 is a diagram showing the configuration of a catalog product registration (manufacturing code input) screen according to an embodiment of the present invention.

Referring to FIG. 43, the catalog product registration (manufacturer code input) screen 4301 includes a manufacturer product code input part 4303, a product-related amount input part 4305, a product posting location selection part 4307, and a product posting to be registered. A position display portion 4309, an add button 4313, a delete button 4315, and a product information registration button 4317 at a product posting position are included.

The catalog product registration (manufacturer code input) screen 4301 is a part for allowing a shopping mall manager to register a product to be updated by inputting a manufacturer code when the shopping mall manager already knows a manufacturer code of a product to be updated.

The manufacturer product code input part 4303 is a part for inputting a manufacturer product code. Here, the shopping mall manager should be known in advance the manufacturer product code for a particular product.

The product-related amount input portion 4305 is a portion for inputting information such as a selling price, a discounted price, a consumer price, a discount period, etc. applied to a product input by the manufacturer product code input portion 4203.

In the product posting location selection part 4307, a classification system for posting a product in a shopping mall is displayed, and the shopping mall manager may select a specific item from the classification system.

In the product posting position display part 4309 to be registered, a list set as a location where a product input in the manufacturer product code input part 4303 is displayed in the classification system of the shopping mall shown in the product posting location selection part 4307 is displayed.

When the add button 4313 is clicked on, the specific classification item selected in the product posting position selection portion 4307 is added to the product posting position display portion 4309 to be registered.

When the delete button 4315 is clicked on, the specific classification item selected from the classification items of the product posting position display portion 4309 to be registered is deleted from the product posting position list to be registered.

If the product information registration button 4317 is clicked on the product posting position, the product input in the manufacturer product code input portion 4303 is added to the shopping mall posting classification item portion set in the product posting position display portion 4309 to be registered.

Then, when the visitor accesses the shopping mall site and clicks one of the shopping mall posting classification items, the inputted product is displayed in the product list.

FIG. 44 is a flowchart illustrating a process of matching a classification code of a shopping mall 21 with a classification code of a shopping mall according to an exemplary embodiment of the present invention.

Referring to FIG. 44, a large classification, a middle classification of a web 21, and a classification ID (a classification identifier of a shopping mall) of a shopping mall are received (S4401). Then, the web 21 classification ID corresponding to the large and medium classification of the web 21 received from the product related database 123 coupled with the product database update server is extracted (S4403). The extracted WebS21 classification ID and the classification ID of the shopping mall are stored in the classification item matching table (S4405).

45 is a flowchart illustrating a process of matching a web21 table name, a field name, a table name of a shopping mall, and a field name for product information to be updated according to an exemplary embodiment of the present invention.

Referring to FIG. 45, a field ID of a commodity table of the web 21 and field related information of a shopping mall corresponding to the field ID are received (S4501).

The product database then displays information such as the field type, field length, NULL (no input) of the field associated with the merchandise table, and the KEY (where each piece of information stored in the table is to be distinguished from other information). The rule for commonizing the database field format is stored in operation S4503 by comparing the information of the data in the product related database coupled with the update server.

The table name, field ID, shopping mall table name, and field ID of the web 21 are stored in the product information matching table to be updated (S4505).

46 is a flowchart illustrating a process of updating a shopping mall related database of a shopping mall in which a shopping mall is opened in a product database update server by inputting a web21 code according to an exemplary embodiment of the present invention.

Referring to FIG. 46, a web 21 product code, a sale price, a discount price, a consumer, a discount period, and a product posting position are received (S4601).

Then, the value of the product information field corresponding to the received WebS21 product code and to be updated in the shopping mall is extracted from the product related database 123 (S4603).

The values of the extracted product information field are stored according to the corresponding field of the shopping mall related database (S4605).

FIG. 47 is a flowchart illustrating a process of generating a product-related web page of a shopping mall in which a shopping mall is opened in a product database update server through input of a Web21 code according to an exemplary embodiment of the present invention.

Referring to FIG. 47, a web 21 product code, a sale price, a discount price, a consumer, a discount period, and a product posting position are received (S4601).

Then, the value of the product information field corresponding to the received WebS21 product code and to be updated in the shopping mall is extracted from the product related database 123 (S4603).

The values of the extracted product information field are arranged according to the screen template of the shopping mall to generate a product related web page in a shopping mall related file portion of the web server coupled with the product database update server (S4701).

48 is a flowchart illustrating a process of updating a shopping mall related database of a shopping mall in which a shopping mall is opened in a product database update server through a manufacturer code input according to an exemplary embodiment of the present invention.

Referring to FIG. 48, a manufacturer product code, a sale price, a discount price, a consumer, a discount period, and a product posting position are received (S4801).

Then, values corresponding to the received manufacturer product codes are extracted from the product related database 123 in step S4803.

The extracted product information field values are stored according to the corresponding field of the shopping mall related database 125 (S4805).

49 is a flowchart illustrating a process of generating a product-related web page of a shopping mall in which a shopping mall is opened in a product database update server through a manufacturer code input according to an exemplary embodiment of the present invention.

Referring to FIG. 49, a manufacturer product code, a sale price, a discount price, a consumer, a discount period, and a product posting position are received (S4801).

Then, values corresponding to the received manufacturer product codes are extracted from the product related database 123 in step S4803.

The values of the extracted product information field are arranged according to the screen template of the shopping mall to generate a product-related web page in a shopping mall-related file portion of the web server coupled with the product database update server (S4901).

50 is a flowchart illustrating a process of generating a web page for a catalog product to be posted in a shopping mall by a shopping mall manager according to an exemplary embodiment of the present invention.

Referring to FIG. 50, steps S2701 to S2713 are the same as those described with reference to FIG. 27.

Here, the process from step S5001 will be described.

The catalog product information corresponding to the product code from the product related database 123 is updated (S5001).

In operation S5003, a product-related web page in which the product information input by the shopping mall manager or the catalog product information extracted from the product-related database is arranged in accordance with the shopping mall template in the shopping mall-related file portion of the web server coupled with the product database update server (S5003). .

51 is a flowchart illustrating a process of providing product information regarding a catalog product to be posted in a shopping mall and a product posting location to a separate shopping mall server according to an exemplary embodiment of the present invention.

Referring to FIG. 51, steps S2713 to S2713 and S5001 are the same as those described with reference to FIGS. 27 and 50.

FIG. 51 is a flowchart illustrating a case in which a shopping mall is opened in a shopping mall server separate from the product database update server and previously associated with the catalog product information.

The process from step S5101 will be described here.

The product information input by the shopping mall manager or the catalog product information extracted from the product related database 123 in the shopping mall-related file portion of the web server coupled with the product database update server (S5101) are transmitted to the shopping mall server (S5103). )do.

When the shopping mall server receives the product information and the product posting position, the shopping mall server extracts a table name and a field name corresponding to the shopping mall related database from the product information matching table, and stores the product information in the field of the extracted table.

By the method set by the shopping mall, a product web page corresponding to the product information and the product posting location may be generated in a web server coupled with the shopping mall server, and the product web page may be transmitted in response to a visitor's request.

The present invention is not limited to the above embodiments, and many variations are possible by those skilled in the art within the spirit of the present invention.

As described above, according to the present invention, when the shopping mall manager selects only a product to be posted in the shopping mall and a product posting location of the product, the shopping mall manager may provide a network-based shopping mall automatic updating method and apparatus for updating the product data of the selected product. .

Also, according to the present invention, after the shopping mall is built, the shopping mall manager can update the product information without collecting enormous data such as product image, product feature, and detailed introduction of each product. Can be provided.

In addition, according to the present invention, it is possible to provide a method and apparatus for automatically updating a network-based shopping mall in which time, effort, and cost for building and maintaining a product database are greatly reduced.

In addition, according to the present invention, it is possible to provide a network-based shopping mall automatic update method and apparatus that can quickly and simply update the product information.

In addition, according to the present invention, the network-based shopping mall automatic update to support the operation of the shop-specific shopping mall by securing the flexibility for information that can be displayed only in the shopping mall, such as price information, product discount period, etc. applied in the shopping mall in addition to the built product information A method and apparatus can be provided.

In addition, according to the present invention, each category for posting a product provided by the product database update server and the category to be posted in the shopping mall are matched in advance, and the product information is updated. Then, a method and an apparatus for automatically updating a network-based shopping mall in which the product list and product information are automatically provided in a product list of a classification item of a shopping mall that matches each category for posting a product provided by a product database update server may be provided. Can be.

According to the present invention, for each item of product information to be updated, a table name, a field name in the product database update server, a table name in the shopping mall, and a field name are previously matched. Then, a network-based shopping mall automatic updating method and apparatus for generating a product information field conversion rule corresponding to the shopping mall and automatically updating the product-related information may be provided.

In addition, according to the present invention, it is possible to provide a network-based shopping mall automatic update method and apparatus corresponding to a manufacturer code, a manufacturer product classification code, a manufacturer product code for a product, and provides a web21 product code assigned by the web21.

In addition, according to the present invention, it is possible to provide a network-based shopping mall automatic update method and apparatus in which the shopping mall is automatically updated through the input of the web 21 product code.

In addition, according to the present invention, it is possible to provide a network-based shopping mall automatic update method and apparatus for automatically updating a shopping mall by inputting a manufacturer code, a manufacturer product classification code, a manufacturer product code, etc. for a product assigned by a manufacturer.

Claims (20)

In the method of automatically updating the shopping mall based on the network in the product database update server, Transmitting a product database conversion module in response to a request of a shopping mall manager who manages the shopping mall; Receiving product selection information from the shopping mall manager; Searching and transmitting the catalog product information corresponding to the product selection information and the corresponding basic classification item, wherein the basic classification item means a classification item of the product database update server. Including, When the product database conversion module is executed in the shopping mall, Receiving classification item matching information from the shopping mall manager to generate a classification item matching table, wherein the classification item matching table includes a basic classification item and a shopping mall classification item corresponding thereto; Converting the basic classification item into a shopping mall classification item using the classification item matching table when receiving the catalog product information and a corresponding basic classification item from the product database update server; Updating the shopping mall by using the shopping mall classification item and the catalog product information; Will run Network-based shopping mall automatic update method characterized in that. In the method of automatically updating the shopping mall based on the network in the product database update server, Receiving classification item matching information from the shopping mall manager to generate a classification item matching table, wherein the classification item matching table includes a basic classification item and a shopping mall classification item corresponding thereto; Receiving product selection information from the shopping mall manager; Retrieving catalog product information corresponding to the product selection information and a basic classification item corresponding thereto; Converting the basic classification item into a shopping mall classification item using the classification item matching table; Updating the shopping mall by using the shopping mall classification item and the catalog product information; Will run Network-based shopping mall automatic update method characterized in that. In the method of automatically updating the shopping mall based on the network in the product database update server, Receiving product selection information from the shopping mall manager; Retrieving catalog product information corresponding to the product selection information and a basic classification item corresponding thereto; Updating the shopping mall by using the basic classification item and the catalog product information Comprising Network-based shopping mall automatic update method characterized in that. The method according to any one of claims 1 to 3, The catalog product information Contains the manufacturer's product code for the product, At least one of a product image, a major classification code, a middle classification code, an attribute code, a manufacturer code, a manufacturer product type code, and a product introduction content corresponding to the product. Network-based shopping mall automatic update method characterized in that. The method according to any one of claims 1 to 3, The product selection information Manufacturer code assigned by manufacturer, manufacturer product code Network-based shopping mall automatic update method characterized in that. The method according to any one of claims 1 to 3, The product selection information Manufacturer code, manufacturer product classification code, manufacturer product code assigned by the manufacturer Network-based shopping mall automatic update method characterized in that. The method according to any one of claims 1 to 3, The product selection information Being a catalog product code granted by a product database update server Network-based shopping mall automatic update method characterized in that. The method of claim 7, wherein The catalog product code is Matched with a manufacturer code, a manufacturer product classification code, and a manufacturer product code by the product database update server Network-based shopping mall automatic update method characterized in that. The method according to any one of claims 1 to 3, The product selection information Information corresponding to at least one product or information corresponding to a specific product group Network-based shopping mall automatic update method characterized in that. The method according to any one of claims 1 to 3, The catalog product information Registered by at least one of the product database manager, manufacturer, supplier of the product database update server, Stored in a product related database associated with the product database update server Network-based shopping mall automatic update method characterized in that. The method according to claim 1 or 2, The product database conversion module When executed in the shopping mall or the product database update server, Receiving database matching information from the shopping mall manager to generate a database matching table, wherein the database matching table includes a basic database item and a corresponding shopping mall database item; Containing more Network-based shopping mall automatic update method characterized in that. The method of claim 11, The default database entry is Comprising goods-related tables and fields stored in a goods-related database associated with the goods database update server Network-based shopping mall automatic update method characterized in that. The method of claim 11, The mall database item is Product related tables and fields stored in a shopping mall related database coupled to the shopping mall server Network-based shopping mall automatic update method characterized in that. The method according to any one of claims 1 to 3, The network is Being a wired or wireless network Network-based shopping mall automatic update method characterized in that. An apparatus for automatically updating a shopping mall based on a network in a product database update server, Means for transmitting a product database conversion module in response to a request of a shopping mall manager who manages the shopping mall; Means for receiving product selection information from the shopping mall manager; Means for searching for and transmitting catalog product information corresponding to the product selection information and a corresponding basic classification item, wherein the basic classification item means a classification item of the product database update server. And When the product database conversion module is executed in the shopping mall, Receiving classification item matching information from the shopping mall manager to generate a classification item matching table, wherein the classification item matching table includes a basic classification item and a shopping mall classification item corresponding thereto; Converting the basic classification item into a shopping mall classification item using the classification item matching table when receiving the catalog product information and a corresponding basic classification item from the product database update server; Updating the shopping mall by using the shopping mall classification item and the catalog product information; Will run Network-based shopping mall automatic update device, characterized in that. The memory that stores the program, A processor coupled with the memory to execute the program, Including but not limited to: The processor by the program, Transmitting a product database conversion module in response to a request of a shopping mall manager who manages the shopping mall; Receiving product selection information from the shopping mall manager; Searching and transmitting the catalog product information corresponding to the product selection information and the corresponding basic classification item, wherein the basic classification item means a classification item of the product database update server. Run it, When the product database conversion module is executed in the shopping mall, Receiving classification item matching information from the shopping mall manager to generate a classification item matching table, wherein the classification item matching table includes a basic classification item and a shopping mall classification item corresponding thereto; Converting the basic classification item into a shopping mall classification item using the classification item matching table when receiving the catalog product information and a corresponding basic classification item from the product database update server; Updating the shopping mall by using the shopping mall classification item and the catalog product information; Will run Network-based shopping mall automatic update system, characterized in that. An apparatus for automatically updating a shopping mall based on a network in a product database update server, Means for receiving classification item matching information from the shopping mall manager to generate a classification item matching table, wherein the classification item matching table includes a basic classification item and a shopping mall classification item corresponding thereto; Means for receiving product selection information from the shopping mall manager; Means for retrieving catalog product information corresponding to the product selection information and a basic category item corresponding thereto; Means for converting the basic classification item into a shopping mall classification item using the classification item matching table; Means for updating the shopping mall by using the shopping mall classification item and the catalog product information Having Network-based shopping mall automatic update device, characterized in that. The memory that stores the program, A processor coupled with the memory to execute the program, Including but not limited to: The processor by the program, Receiving classification item matching information from the shopping mall manager to generate a classification item matching table, wherein the classification item matching table includes a basic classification item and a shopping mall classification item corresponding thereto; Receiving product selection information from the shopping mall manager; Retrieving catalog product information corresponding to the product selection information and a basic classification item corresponding thereto; Converting the basic classification item into a shopping mall classification item using the classification item matching table; Updating the shopping mall by using the shopping mall classification item and the catalog product information; Will run Network-based shopping mall automatic update system, characterized in that. An apparatus for automatically updating a shopping mall based on a network in a product database update server, Means for receiving product selection information from the shopping mall manager; Means for retrieving catalog product information corresponding to the product selection information and a basic category item corresponding thereto; Means for updating the shopping mall by using the basic classification item and the catalog product information Having Network-based shopping mall automatic update device, characterized in that. The memory that stores the program, A processor coupled with the memory to execute the program, Including but not limited to: The processor by the program, Receiving product selection information from the shopping mall manager; Retrieving catalog product information corresponding to the product selection information and a basic classification item corresponding thereto; Updating the shopping mall by using the basic classification item and the catalog product information Will run Network-based shopping mall automatic system, characterized in that.