JP5154856B2 - Code management server and code management method - Google Patents

Description

  The present invention relates to a code management server and a code management method for performing code management in order to specify the same product among products to which an in-store code is separately assigned in each retail chain.

  Conventionally, in a store such as a supermarket, a POS system that collects information for grasping the sales status of each product by reading a POS code such as a barcode attached to a product desired to be purchased has been provided. Widely used (see, for example, Patent Document 1-2).

JP 2005-165629 A Japanese Patent Laid-Open No. 2005-228021

  However, in the conventional POS system described above, the information obtained by the POS code is an in-store code unique to each store. The chain store generally uses the international standard code format called JAN (EAN) code, but since the corresponding in-store codes for registered products are used separately, they are sold at each chain store. There is a problem in that the identity of a product cannot be determined, and for example, the sales situation of a product cannot be smoothly summarized.

  Although it is conceivable to construct a POS system in which the in-store code is unified, enormous costs and time are required to construct such a POS system, resulting in a lot of economic waste. .

  The present invention solves the above-described problems, and makes it possible to easily confirm the identity of each product indicated by an in-store code that is separately assigned and used between a plurality of stores without being unified. With the goal.

The code management server of the present invention is a code management server that performs code management in order to specify the same product among products that are individually assigned an in-store code in each retail chain, and the product is produced or manufactured. A code management DB for storing code management information including a product identification code assigned to the product and an in-store code assigned to the product indicated by the product identification code in each retail chain, and an advertisement site An advertisement DB for storing advertisement link information for linking to a file, a manufacturer management information acquisition means for acquiring manufacturer management information including a product identification code assigned to the product by the manufacturer that manufactured or manufactured the product, The manufacturer management information acquired by the manufacturer management information acquisition means is registered in the code management DB. Management information registration means, and retail store information acquisition means for acquiring retail store information including an in-store code and a product chart number of a product to which the in-store code is assigned from each retail chain server managed in each retail chain; Product record information for acquiring a product identification code registered in the product record of the product indicated by the product record number acquired by the retail store information acquisition unit from the product master server that manages the product chart including various information related to the product The in-store code acquired by the retail store information acquisition unit is registered in association with the product identification code acquired by the product chart information acquisition unit among the product identification codes registered in the code management DB. Among the in-store code registration means and the product identification code registered in the code management DB And association with the product identification code is product chart information acquisition means has acquired, receiving a Rolling setting means for registering or updating the application period of the installation Accord, the designation of the product identification code is assigned in the search Product Product An identification code receiving unit and a code for searching for code management information including the product identification code received by the product identification code receiving unit with reference to the code management DB, and extracting a part or all of the searched code management information Management information search extraction means, and an advertisement search code related to the search target product, and the generated advertisement search out of the search codes respectively included in the plurality of advertisement link information stored in the advertisement DB Search for a search code that matches the code, and extract ad link information that contains the searched search code as a candidate Link information search / extraction means, output means for outputting part or all of the code management information extracted by the code management information search / extraction means, and part or all of the advertisement link information extracted by the advertisement link information search / extraction means It is characterized by including.

  With the configuration described above, it is possible to easily confirm the identity of each product indicated by the in-store code that is separately assigned and used between a plurality of stores without being unified. Accordingly, it is possible to smoothly aggregate sales statuses among a plurality of stores.

  The code management information includes an application period of the in-store code, and includes a date receiving unit that receives designation of a date to be searched, and the code management information search and extraction unit includes the product identification code received by the product identification code receiving unit. It may be configured to search for code management information including a product identification code associated with the application period including the date received by the date receiving unit.

  The code management information may further include a retail chain name indicating a retail chain to which an in-store code is assigned. Further, the code management information may further include a product name of a product to which a product identification code is assigned.

  The advertisement link information search and extraction unit generates an advertisement search code by encoding a category or a product name of a search target product into an EUC code, and generates the generated advertisement from the search codes represented in advance by the EUC code. The search code that matches the search code may be searched.

  Accepts address information for linking to advertising sites and files and advertising target product information about the target product, generates search code related to the target product, and includes the generated search code An advertisement link information registration unit that registers information in the advertisement DB may be included.

The code management method of the present invention is a code management method for performing code management in order to specify the same product among products that are individually assigned an in-store code in each retail chain, and is a search target product When the product is produced or manufactured, the product identification code receiving process for receiving the designation of the product identification code assigned to the product and the code management information including the product identification code received in the product identification code receiving process Code management DB that stores code management information that stores code management information including the product identification code assigned to the product and the in-store code assigned to the product indicated by the product identification code in each retail chain. Code management information search extraction process that extracts part or all of information, and advertisement search related to the search target product Generated advertisements out of the search codes included in each of the plurality of advertisement link information stored in the advertisement DB that stores advertisement link information for generating links to advertisement sites and files Search for a search code that matches the search code, extract advertisement link information including the searched search code as a candidate for placement, and code management information extracted by the code management information search and extraction process and some or all of the, seen including part or an output process of outputting the whole of the extracted advertisement link information in the advertising link information search and extraction process, further, to the product by the manufacturer that produced or manufactured products Acquired by the manufacturer management information acquisition process for acquiring the manufacturer management information including the assigned product identification code and the manufacturer management information acquisition process. Manufacturer management information registration processing for registering manufacturer management information in the code management DB, and an in-store code and a product chart number of a product to which the in-store code is assigned from each retail chain server managed in each retail chain The retail store information acquisition process for acquiring the retail store information and the product chart of the product indicated by the product record number acquired in the retail store information acquisition process from the product master server that manages the product chart including various information related to the product Corresponding to the product identification code acquired in the product medical record information acquisition process among the product identification codes registered in the code management DB, the product medical record information acquisition process for acquiring the registered product identification code, An in-store code registration process for registering the in-store code acquired in the retail store information acquisition process; An application period setting process for registering or updating the application period of the in-store code in association with the product identification code acquired in the product chart information acquisition process among the product identification codes registered in the code management DB It is characterized by that.

  According to the present invention, it is possible to easily confirm the identity of each product indicated by an in-store code that is separately assigned and used between a plurality of stores without being unified.

Hereinafter, an embodiment of the present invention will be described with reference to the drawings.
FIG. 1 is a block diagram showing an example of the configuration of a code management system 100 according to an embodiment of the present invention. As shown in FIG. 1, the code management system 100 includes a code management server 10, a merchandise master server 20, and retail store servers 31 to 3N (N: any positive integer). The code management server 10, the product master server 20, and the retail store servers 31 to 3N are each connected to a communication network 40 such as the Internet, for example.

  The code management server 10, the merchandise master server 20, and the retail store servers 31 to 3N are each configured by an information processing device such as a WWW server.

  The code management server 10 is, for example, a server managed by a system administrator of the code management system 100. When the product is produced or manufactured, a product identification code (for example, JAN code) given to the product or each retail store It manages the in-store code used in.

  The code management server 10 includes a code management DB 11 that stores code management information, a manufacturer production management DB 12 that stores manufacturer production management information, and an advertisement DB 13 that stores link advertisement information (advertisement link information). Yes. The code management information is information for managing the relationship between the product identification code and the in-store code used in each retail store. The manufacturer production management information includes the product identification code given to the product by the manufacturer when the product is produced or manufactured, the product name of the product indicated by the product identification code, and the name of the manufacturer that produced or manufactured the product. Including. The link advertisement information is information for linking to an advertisement site or file. The code management DB 11, the manufacturer production management DB 12, and the advertisement DB 13 may be inside or outside the code management server 10. The manufacturer production management information is transmitted, for example, from a manufacturer terminal (not shown) managed by each manufacturer, for example, to the code management server 10 via a communication network periodically and stored in the manufacturer production management DB 12.

The merchandise master server 20 includes a merchandise master DB 21 in which a merchandise master (product chart) including various information related to the merchandise such as merchandise history information including merchandise production history and distribution history is stored. The product master includes a product master number (product chart number) for uniquely identifying the product and a product identification code assigned to the product. The product master DB 21 may be inside or outside the product master server 20.

  Each of the retail store servers 31 to 3N is managed by, for example, a retail chain manager who manages each of the retail chains A to X, and stores the POS information used in each of the retail chains A to X. 3Na is provided. The retail store servers 31 to 3N are installed, for example, in the retail chains A to X, respectively. Although not shown in the retail store servers 31 to 3N, a POS register used in each of the retail chains A to X (a register installed at a purchase amount payment place, for example, for a POS system attached to a product) Various functions such as reading a bar code (an example of a POS code: hereinafter referred to as a POS bar code) and printing purchase contents on a receipt using a product name and a product price specified based on the POS bar code Or a computer that performs POS data intra processing before the processing of the retail store servers 31 to 3N.

  FIG. 2 is an explanatory diagram illustrating an example of POS information stored in the retail chain product master DB 31a included in the retail store server 31 installed in the retail chain A. As shown in FIG. 2, the POS information includes a product name, an in-store code, a product chart number, and a product price. The in-store code may be a specific standard format such as a JAN format, or may have a store-specific format. The in-store code is a POS code that is currently used in association with a predetermined product in the POS system in the corresponding retail chain A.

  As shown in FIG. 2, the names of products such as shellfish A and seasonings A and / or supplier names (manufacturer names) are set as the product names. Moreover, the price of the sales unit for every number and weight is set to the price.

  The POS information is stored in each retail chain product master DB 31a to 3Na provided in each retail store server 31 to 3N. Also, different in-store codes may be set for the POS information even for the same product depending on the POS system employed in each store.

  FIG. 3 is an explanatory diagram illustrating an example of code management information stored in the code management DB 11. As shown in FIG. 3, in the code management information, a product name, a JAN code (meaning “product identification code” in this example), a retail chain name, an in-store code, and an application period are associated with each other. Information. The application period means the period applied to the product with the corresponding in-store code, and if it is still applied, the period end date cannot be determined, so “continuing use (applied)” is set. . The application period may be managed not in units of days but in units of months, weeks, hours, minutes, and seconds.

Next, the operation of the code management system 100 of this example will be described.
FIG. 4 is a flowchart illustrating an example of code management information registration processing executed by the code management server 10 in the code management system 100 of the present example. The code management information registration process is executed, for example, when instructed by the operator of the code management server 10 or periodically (for example, once a day early in the morning or late at night).

  In the code management information registration process, the code management server 10 firstly, manufacturer production management information that has been newly registered (registered since the last acquisition) among the manufacturer production management information stored in the manufacturer production management DB 12. Is read (step S101).

  Next, the code management server 10 newly registers the product name and JAN code included in the acquired manufacturer production management information in the corresponding item of the code management information stored in the code management DB 11 (step S102).

  Next, the code management server 10 acquires POS information newly registered (registered since the previous acquisition) and POS information whose registration has been deleted from each of the retail store servers 31 to 3N (step S103). ). In step S103, only the product chart number and the in-store code may be acquired from the POS information. In this example, the registration date and the registration deletion date of the POS information are also acquired in step S103.

  Next, the code management server 10 presents the product chart number included in the POS information acquired in step S103, and requests the product master server 20 to confirm the JAN code corresponding to the presented product chart number. The JAN code associated with the product chart number indicated by the POS information acquired in step S103 is acquired from the product master server 20 (step S104).

  In the case of new registration, the code management server 10 registers the in-store code included in the POS information acquired in step S103 in association with the JAN code acquired in step S104, and applies it. The beginning of the period is registered (step S105). Further, in the case of end registration, the code management server 10 associates the JAN code acquired in step S104 with the in-store code included in the POS information acquired in step S103, and ends the application period. Is registered (step S105).

  FIG. 5 is a flowchart illustrating an example of a product search process executed by the code management server 10 in the code management system 100 of the present example. Here, as an example, a product to which a JAN code designated by an operator of the code management server 10 is assigned and which is sold with a separate in-store code assigned in each retail chain is searched. explain.

  In the product search process, the code management server 10 receives a JAN code input by an operator by operating an input device provided therein (step S201). In addition, the code management server 10 accepts a search target date (for example, October 15, 2006) input by an operator by operating an input device included in the code management server 10 (step S202).

  Next, the code management server 10 refers to the code management DB 11 and associates the code management information that is associated with the JAN code received in step S201 and includes the date received in step S202 during the application period. Search and extract (step S203).

  Next, the code management server 10 specifies a keyword (link advertisement search keyword) used for a search for an advertisement (link advertisement) to be linked (step S204). In step S204, the product name of the product associated with the JAN code received in step S201 (the product to be searched in step S203) and the category of the product are specified as the link advertisement search keyword. In this example, a product name (for example, shell A, shell B) and a product category (for example, shell) are specified as a link advertisement search keyword. In addition, the link advertisement search keyword specified in step S204 may be one or plural.

  When the link advertisement search keyword is specified, the code management server 10 searches for a link advertisement (step S205). The process in step S205 will be described in detail later.

  Then, the code management server 10 displays the search result screen on the display screen of the display device provided in itself (step S206). For example, as shown in FIG. 6, the search result screen includes a search condition display area 201 for displaying search conditions, a search result display area 202 for displaying search results, and a link advertisement for displaying the link advertisement searched in step S205. A display area 203 is provided.

  FIG. 6 shows an example of a search result when the JAN code “000123” and the date “October 15, 2006” are designated as the search conditions. As shown in FIG. 6, as a search result, the product indicated by the JAN code “000123” is the product name “shellfish A”, and on the designated date “October 15”, five retail chains A, B, In D, F, and H, it is shown that separate in-store codes were used. Based on this search result, the product with the product name “shellfish A” is sold on October 15, 2006 with the in-store code displayed in the area 202 in each retail chain A, B, D, F, H. Can be confirmed. In this example, a link advertisement is displayed on the search result screen. As shown in FIG. 6, the link advertisement related to “shellfish” is accurately retrieved and posted.

  FIG. 7 is a flowchart showing a specific example of the link advertisement search process (step S205). In the link advertisement search process, first, the code management server 10 converts the link advertisement search keyword specified in step S204 into an advertisement search code (step S205a). In this example, in step S205a, an advertisement search code is created by encoding the link advertisement search keyword (eg, shellfish) specified in step S204 into EUC (Extended UNIX Code: “UNIX” is a registered trademark). . For example, the link advertisement search keyword “shellfish” is converted into an advertisement search code “% B3% AD”.

  Next, the code management server 10 refers to, for example, the link advertisement registration table as shown in FIG. 8 and includes the advertisement search code generated in step S205a and the link advertisement information stored in the link advertisement registration table. The link advertisement information including the search code that matches the advertisement search code is searched by comparing the search code with the search code (step S205b).

  As shown in FIG. 8, a plurality of link advertisement information in which a product category, a product name, file specifying data, and a search code are associated is registered in the link advertisement registration table. The file specifying data means information indicating an address or file name for specifying the location of an advertisement site or file (information indicating an address for accessing the corresponding advertisement site or file). In this example, the search code is code information in which the corresponding category and product name are encoded in EUC.

  Then, the code management server 10 determines link advertisement information to be posted on the search result screen from the link advertisement information searched in step S205b (step S205c). The determination method here may be any method. For example, it may be possible to select at random or according to some priority order. Note that all the link advertisement information searched in step S205b may be selected.

  FIG. 9 is a flowchart illustrating an example of link advertisement registration processing. In the link advertisement registration process, when the code management server 10 receives the link advertisement registration request information (step S301), the code for search is determined from the category and the product name of the advertisement target product included in the received link advertisement registration request information. Is generated (step S302).

  The link advertisement registration request information includes, for example, the product name of the advertisement target product, the category of the product, the file specifying data indicating the site and file name for the advertisement where the advertisement of the advertisement target product is posted, and the link advertisement information. And information indicating that registration is requested. The link advertisement registration request information is transmitted from the terminal device managed by the advertiser to the code management server 10 via the communication network, for example.

  In step S302, when the code management server 10 receives the link advertisement registration request information in step S301, the code management server 10 encodes the product name and category included in the received link advertisement registration request information into EUC, thereby enabling the search code. Is generated.

  Then, the code management server 10 registers the link advertisement information in which the various types of information included in the received link advertisement registration request information and the generated search court are associated with each other in the link advertisement registration table (step S303). ). In this way, link advertisement information is sequentially registered in the link advertisement registration table.

  In the above example, the date is accepted in step S202. However, as shown in FIG. 10, for example, a date range to be searched may be accepted. In this case, the code management server 10 refers to the code management DB 11 and is associated with the JAN code received in step S201, and the code management information including the date range received in step S202 during the application period. Are retrieved and extracted (step S205). The search result screen is, for example, as shown in FIG.

  FIG. 11 shows an example of a search result when the JAN code “000123” and the date range “October 15-18, 2006” are designated as the search conditions. As shown in FIG. 11, as a search result, the product indicated by the JAN code “000123” is the product name “shellfish A”, and in the retail chain A, separate in-store codes are applied on the 15th and the 16th to the 18th. In the other four retail chains B, D, F, and H, it is shown that the same in-store code was used during the designated period. Based on this search result, the in-store code displayed in the area 202 is applied to the product with the product name “shellfish A” in each retail chain A, B, D, F, H on October 15-18, 2006. It can be confirmed that it was sold.

  In the above example, a part of the code management information is extracted and displayed on the search result screen. However, the entire code management information may be extracted and displayed on the search result screen. In the above example, the search result screen is displayed. However, the search result screen may be printed, or the search result may be output by voice.

  As described above, in the above-described embodiment, the code management server 10 includes a product identification code (JAN code) given to a product when the product is produced or manufactured, and the product identification code. A code management DB 11 for storing code management information including in-store codes assigned in each retail chain to the indicated product, accepting designation of the product identification code given to the search target product, and accepting the received product identification code Is searched with reference to the code management DB 11, an advertisement search code related to the search target product is generated, and the search is included in each of the plurality of advertisement link information stored in the advertisement DB 13. Search for a search code that matches the generated advertisement search code, and include the searched search code. Link information is extracted as a publication candidate, and it is configured to output part or all of the extracted code management information and part or all of the extracted advertisement link information. It becomes possible to easily confirm the identity of each product indicated by the in-store code assigned and used. Accordingly, it is possible to smoothly aggregate sales statuses among a plurality of stores. In addition, since the link advertisement information search process is performed using code data that encodes the product name and product category, for example, irrelevant link advertisement information in which the product name or category is written in English or Roman letters is searched. It can be prevented from being published. Therefore, the targeted advertisement can be retrieved and extracted more accurately, and the advertising effect can be enhanced.

  Specifically, when the product category is “shellfish”, a file name in English display such as “XX Shell.html” is generally given, but companies, organizations, A similar file name including “Shell” may be given depending on the name of the region. In such a case, if the search is simply performed by the file name, a lot of unrelated link advertisement information is searched, and the advertisement effect is reduced. On the other hand, in the above-described embodiment, the search processing of the link advertisement information is performed by the code data in which the product name and the product category are encoded. Therefore, “shell” in Japanese is appropriately searched as a keyword. The target advertisement can be searched and extracted more accurately. Therefore, the advertising effect can be enhanced.

  In the above-described embodiment, the code management server 10 generates an advertisement search code by encoding the category or product name of the search target product into the EUC code, and the search code represented in advance by the EUC code. Among them, since the search code that matches the generated advertisement search code is searched, the target advertisement can be searched and extracted more accurately, and the advertising effect can be enhanced. The EUC code is an example, and may be encoded into a code according to another standard such as Shift JIS.

  In the above-described embodiment, the code management server 10 accepts address information for linking to an advertisement site or file and advertisement target product information related to the target advertisement item, and searches related to the target advertisement item. Since the advertisement code is generated and the advertisement link information including the generated search code is registered in the advertisement DB 13, the advertisement link information can be easily registered.

  In the above-described embodiment, the code management server 10 is configured to search for code management information including a product identification code associated with an application period including the received date among the received product identification codes. The in-store code applied to the product indicated by the corresponding product identification code on the specified date can be searched and extracted, and the identity of the product in each retail chain on the specified date can be easily confirmed Will be able to. Specifically, for example, it can be easily confirmed that “the product A indicated by the product identification code was sold in the retail chains A, B, and C on the designated day”.

  In the above-described embodiment, the code management server 10 acquires manufacturer management information including a product identification code assigned to the product by the manufacturer that manufactured or manufactured the product, and the acquired manufacturer management information is stored in the code management DB 11. Therefore, when a new product identification code is assigned, the new product identification code and product name can be registered in the code management DB 11.

  In the above-described embodiment, the code management server 10 includes the in-store code and the product chart number of the product to which the in-store code is assigned from each retail chain server 31 to 3N managed in each retail chain. Products that acquire retail store information, acquire a product identification code registered in the product chart of the product indicated by the acquired product chart number from the product master server 20 that manages the product chart, and are registered in the code management DB 11 Since the acquired in-store code is registered in association with the acquired product identification code among the identification codes, when a new in-store code is assigned in each retail chain, or the product to which the in-store code is applied is changed The code management information in the code management DB 11 can be appropriately updated.

  In the embodiment described above, the code management server 10 associates the product identification code acquired from the product master server 20 among the product identification codes registered in the code management DB 11, and sets the application period of the in-store code. Since it is configured to be registered or updated, the application period in the code management information of the code management DB 11 is appropriately updated when a new in-store code is assigned in each retail chain or when an in-store code application product is changed. It becomes possible to do.

  In the above-described embodiment, the in-store code is used. However, the code management information is a figure that is given to the product indicated by the product identification code in each retail chain instead of the in-store code or together with the in-store code. The code may be included. That is, a graphic code that is used privately in each retail chain may be used instead of or together with the in-store code.

  Although not mentioned in the above-described embodiment, the link advertisement information may include information posted on the linked site. In this case, if the file name is displayed in English or Roman characters in the information posted on the linked site, in the link advertisement registration process, the file name is converted to Japanese, then encoded into EUC code, The encoded data may be registered as a part of the link advertisement information. That is, the file name posted on the link destination site may be renamed and registered in the EUC code. In such a configuration, in order to easily identify the contents of the link advertisement information, for example, when the operator tries to display the screen for viewing the link advertisement information, it is included in the link advertisement information. It is desirable to decode and display all the EUC codes in batch.

  INDUSTRIAL APPLICABILITY According to the present invention, it is useful for easily confirming the identity of each product indicated by an in-store code that is separately assigned and used between a plurality of stores without being unified.

It is a block diagram which shows the example of a structure of the code management system which concerns on one embodiment of this invention. It is explanatory drawing which shows the example of POS information. It is explanatory drawing which shows the example of code management information. It is a flowchart which shows the example of a code management information registration process. It is a flowchart which shows the example of goods search processing. It is explanatory drawing which shows the example of a search result screen. It is a flowchart which shows the example of a link advertisement search process. It is explanatory drawing which shows the example of a link advertisement registration table. It is a flowchart which shows the example of a link advertisement registration process. It is a flowchart which shows the example of goods search processing. It is explanatory drawing which shows the example of a search result screen.

Explanation of symbols

10 Code management server 11 Code management DB
13 Advertising DB
20 merchandise master server 31 to 3N retail store server 40 communication network 100 code management system

Claims (10)

A code management server that performs code management in order to identify the same product among products that are individually assigned an in-store code in each retail chain,
A code management DB that stores code management information including a product identification code assigned to the product when the product is produced or manufactured, and an in-store code assigned to the product indicated by the product identification code in each retail chain When,
An ad DB that stores ad link information for linking to ad sites and files;
Manufacturer management information acquisition means for acquiring manufacturer management information including a product identification code assigned to the product by the manufacturer that produced or manufactured the product;
Manufacturer management information registration means for registering the manufacturer management information acquired by the manufacturer management information acquisition means in the code management DB;
Retail store information acquisition means for acquiring retail store information including an in-store code and a product chart number of a product to which the in-store code is assigned from each retail chain server managed in each retail chain;
Product chart information acquisition that acquires a product identification code registered in the product chart of the product indicated by the product chart number acquired by the retail store information acquisition means from a product master server that manages a product chart including various information related to the product Means,
In-store code registration means for registering the in-store code acquired by the retail store information acquisition means in association with the product identification code acquired by the product medical record information acquisition means among the product identification codes registered in the code management DB When,
An application period setting unit that registers or updates an application period of an in-store code in association with the product identification code acquired by the product chart information acquisition unit among the product identification codes registered in the code management DB;
Product identification code accepting means for accepting designation of a product identification code given to a product to be searched;
Code management information search and extraction means for searching for code management information including the product identification code received by the product identification code receiving means with reference to the code management DB and extracting a part or all of the searched code management information; ,
A search code that generates an advertisement search code related to a search target product and matches the generated advertisement search code among the search codes respectively included in the plurality of advertisement link information stored in the advertisement DB And an ad link information search and extraction means for extracting ad link information including the searched search code as a placement candidate,
Characterized in that it includes a part or all of the code management information extracted by the code management information search and extraction means and an output means for outputting a part or all of the advertisement link information extracted by the advertisement link information search and extraction means. Code management server. Code management information includes the application period of the in-store code,
Including date accepting means for accepting designation of the date to be searched,
The code management information search and extraction unit includes code management information including a product identification code associated with the application period including the date received by the date receiving unit among the product identification codes received by the product identification code receiving unit. The code management server according to claim 1. The code management information includes the retail chain name indicating the retail chain that is giving the in-store code.
The code management server according to claim 1 or 2 . The code management server according to any one of claims 1 to 3 , wherein the code management information includes a product name of a product to which a product identification code is assigned. The advertisement link information search and extraction unit generates an advertisement search code by encoding a category or a product name of a search target product into an EUC code, and generates the generated advertisement from the search codes represented in advance by the EUC code. The code management server according to any one of claims 1 to 4, wherein a search code that matches the search code is searched. Accepts address information for linking to advertising sites and files and advertising target product information about the target product, generates search code related to the target product, and includes the generated search code The code management server according to claim 5 , further comprising advertisement link information registration means for registering information in the advertisement DB. A code management method for performing code management in order to identify the same product among products that are individually assigned an in-store code in each retail chain,
A product identification code acceptance process for accepting designation of a product identification code given to a product to be searched;
The code management information including the product identification code received in the product identification code receiving process includes the product identification code given to the product when the product is produced or manufactured, and the product indicated by the product identification code for each retail A code management information search and extraction process for searching by referring to a code management DB that stores code management information including in-store codes assigned in the chain, and extracting part or all of the searched code management information;
Search that is included in each of the multiple advertisement link information stored in the advertisement DB that generates the advertisement search code related to the search target product and stores the advertisement link information for linking to the advertisement site or file A search code that matches the generated ad search code, and an ad link information search and extraction process that extracts ad link information including the searched search code as a placement candidate;
Seen containing a part or all of the code management information extracted by said code management information search and extraction process, and an output processing portion or outputting the whole of the advertisement link information search and extraction extracted advertisement link information in the process ,
Furthermore, a manufacturer management information acquisition process for acquiring manufacturer management information including a product identification code given to the product by the manufacturer that produced or manufactured the product;
Manufacturer management information registration processing for registering the manufacturer management information acquired in the manufacturer management information acquisition processing in the code management DB;
Retail store information acquisition processing for acquiring retail store information including an in-store code and a product chart number of a product to which the in-store code is assigned from each retail chain server managed in each retail chain;
Product chart information for acquiring a product identification code registered in the product chart of the product indicated by the product chart number acquired in the retail store information acquisition process from the product master server that manages the product chart including various information related to the product Acquisition process,
An in-store code for registering the in-store code acquired in the retail store information acquisition process in association with the product identification code acquired in the product chart information acquisition process among the product identification codes registered in the code management DB Registration process,
An application period setting process for registering or updating the application period of the in-store code in association with the product identification code acquired in the product chart information acquisition process among the product identification codes registered in the code management DB A code management method characterized by the above. Code management information includes the application period of the in-store code,
Includes a date acceptance process that accepts the specification of the date to search,
In the code management information search and extraction process, a code including a product identification code associated with the application period including the date received in the date reception process among the product identification codes received in the product identification code reception process The code management method according to claim 7, wherein the management information is searched. In the advertisement link information search and extraction process, an advertisement search code is generated by encoding a category or a product name of a search target product into an EUC code. The code management method according to claim 7 or 8, wherein a search code that matches the search code is searched. Accepts address information for linking to advertising sites and files and advertising target product information about the target product, generates search code related to the target product, and includes the generated search code The code management method according to claim 9 , further comprising an advertisement link information registration process for registering information in the advertisement DB.

Images