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

Abstract

<P>PROBLEM TO BE SOLVED: To easily identify each commodity indicated by an in-store code, the in-store codes being individually used in a plurality of stores. <P>SOLUTION: A code management server 10 includes a code management DB 11 for storing code management information including commodity identification codes (JAN codes) given to commodities when producing or manufacturing the commodities, in-store codes given to the commodities indicated by the commodity identification codes at each retail chain, and the application period of the in-store codes. The commodity identification code given to the commodity to be retrieved and the range of dates are designated. The code management information including the commodity identification code associated with the application period including at least a portion of the range of dates accepted, among the commodity identification codes accepted, is retrieved by referring to the code management DB 11. The code management information retrieved is extracted and outputted. <P>COPYRIGHT: (C)2008,JPO&INPIT

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 for storing code management information including a product identification code given to the product, an in-store code given to the product indicated by the product identification code in each retail chain, and an application period of the in-store code Received by the management DB, a product identification code receiving means for receiving a specification of a product identification code assigned to a search target product, a date range receiving means for receiving a specification of a date range to be searched, and the product identification code receiving means Includes at least part of the date range accepted by the date range acceptance means of the product identification code. Code management information search and extraction means for searching for code management information including a product identification code associated with the application period with reference to the code management DB and extracting part or all of the searched code management information; And code management information output means for outputting part or all of the code management information extracted by the code management information search and extraction means.

  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 output unit, for example, for the product indicated by the product identification code received by the product identification code receiving unit, the in-store code used within the date range received by the date range receiving unit, and the in-store code The retail chain name used is output, and the application period within the date range of the in-store code used in a part of the date range received by the date range receiving means is output.

  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, and the manufacturer management information acquired by the manufacturer management information acquisition means in the code management DB It may be configured to include manufacturer management information registration means for registration.

  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, and manages the product chart Product chart information acquisition means for acquiring the 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 the product master server, and the product registered in the code management DB It may be configured to include an in-store code registration unit that registers the in-store code acquired by the retail store information acquisition unit in association with the product identification code acquired by the product chart acquisition unit among the identification codes.

  It is configured to include an application period setting unit that registers or updates the application period of the in-store code in association with the product identification code acquired by the product chart acquisition unit among the product identification codes registered in the code management DB. May be.

  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 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 The product identification code reception process for receiving the specification of the product identification code assigned to the date, the date range reception process for receiving the specification of the date range to be searched, and the date among the product identification codes received in the product identification code reception process Product that is given to the product when the product is produced or manufactured with code management information including the product identification code associated with the application period including at least a part of the date range received in the range reception process An identification code, and an in-store code assigned to the product indicated by the product identification code in each retail chain; A code management information search and extraction process for extracting a part or all of the searched code management information by searching with reference to a code management DB storing code management information including the application period of the in-store code; and the code management information And a code management information output process for outputting a part or all of the code management information extracted by the search extraction process.

  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 and a manufacturer production management DB 12 that stores manufacturer production management information. 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 code management DB 11 and the manufacturer production management DB 12 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 including various information related to the merchandise such as merchandise history information including the production history and distribution history of the merchandise is stored. The product master includes a product master 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 canned foods 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 after 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).

  Then, the code management server 10 displays the search result screen on the display screen of the display device provided therein (step S204). For example, as shown in FIG. 6, the search result screen is provided with a search condition display area 201 for displaying the search conditions and a search result display area 202 for displaying the search results.

  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 “canned 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 “Canned 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 the above example, the date is accepted in step S202. However, for example, as shown in FIG. 6, a range of dates 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. 7 shows an example of the 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. 7, as a search result, the product indicated by the JAN code “000123” is the product name “canned 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. As a result of this search, the in-store code displayed in the area 202 is applied to the product with the product name “Canned 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 an in-store code given to each product in the retail chain and an application period of the in-store code, and specifying a product identification code given to the search target product Code management information including a product identification code associated with an application period including at least a part of the received date range among the received product identification codes. The code management information extracted by extracting part or all of the searched code management information Since it is configured to output a part or all, it is possible to easily confirm the identity of each product indicated by the in-store code that is separately assigned and used among a plurality of stores without being unified. . Accordingly, it is possible to smoothly aggregate sales statuses among a plurality of stores.

  Moreover, in embodiment mentioned above, it is set as the structure which the code management server 10 searches the code | cord | chord management information containing the product identification code with which the application period containing the received date range is matched among the received product identification codes. Therefore, it is possible to search and extract the in-store code applied to the product indicated by the corresponding product identification code within the specified date range, and the identity of the product in each retail chain within the specified date range Can be easily confirmed. 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 in the designated date range”.

  In the above-described embodiment, the code management server 10 uses the in-store code used within the received date range and the retail chain name that uses the in-store code for the product indicated by the received product identification code. And the applicable period within the date range of the in-store code used in part of the accepted date range is output, so the product indicated by the corresponding product identification code within the specified date range Even if the in-store code applied to is changed, it is possible to easily confirm which in-store code was applied in which period.

  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.

  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 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
20 merchandise master server 31 to 3N retail store server 40 communication network 100 code management system

Claims (15)

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 including a product identification code assigned to the product when the product is produced or manufactured, an in-store code assigned to the product indicated by the product identification code in each retail chain, and an application period of the in-store code A code management DB for storing management information;
Product identification code accepting means for accepting designation of a product identification code given to a product to be searched;
A date range accepting means for accepting specification of a date range to be searched;
Code management information including a product identification code associated with the application period including at least a part of the date range received by the date range receiving unit among the product identification codes received by the product identification code receiving unit, A code management information search and extraction means for searching by referring to the code management DB and extracting a part or all of the searched code management information;
A code management information output means for outputting part or all of the code management information extracted by the code management information search and extraction means; The code management information output means uses the in-store code used in the date range accepted by the date range acceptance means for the product indicated by the product identification code accepted by the product identification code acceptance means, and the in-store code. 2. The code management server according to claim 1, wherein the code management server outputs an application period within the date range of the in-store code used in a part of the date range accepted by the date range acceptance unit. . 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;
The code management server according to claim 1, further comprising manufacturer management information registration means for registering 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;
A product chart information acquisition unit 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 unit from the product master server that manages the product chart;
An in-store code registration unit for registering the in-store code acquired by the retail store information acquisition unit in association with the product identification code acquired by the product chart acquisition unit among the product identification codes registered in the code management DB; The code management server according to claim 3. 5. An application period setting unit that registers or updates an application period of an in-store code in association with a product identification code acquired by a product chart acquisition unit among the product identification codes registered in the code management DB. Code management server. The code management server according to any one of claims 1 to 5, wherein the code management information includes a retail chain name indicating a retail chain to which an in-store code is assigned. The code management server according to any one of claims 1 to 6, wherein the code management information includes a product name of a product to which a product identification code is assigned. 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;
A date range acceptance process that accepts the specification of the date range to be searched;
Code management information including a product identification code associated with the application period including at least a part of the date range received in the date range reception process among the product identification codes received in the product identification code reception process. A product identification code assigned to the product when the product is produced or manufactured, an in-store code assigned to the product indicated by the product identification code in each retail chain, and an application period of the in-store code A code management information search / extraction process for searching with reference to a code management DB for storing code management information and extracting a part or all of the searched code management information;
A code management information output process for outputting a part or all of the code management information extracted in the code management information search and extraction process. In the code management information output process, for the product indicated by the product identification code received in the product identification code reception process, the in-store code used in the date range received in the date range reception process, and the in-store code 9. The retail chain name used is output, and an application period within the date range of the in-store code used in a part of the date range received in the date range reception process is output. Code management method. Manufacturer management information acquisition processing for acquiring manufacturer management information including a product identification code given to the product by the manufacturer that produced or manufactured the product;
10. The code management method according to claim 8, further comprising: manufacturer management information registration processing for registering 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;
A product chart information acquisition process 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 managing the product chart;
An in-store code registration process 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 acquisition process among the product identification codes registered in the code management DB The code management method according to claim 10. 12. An application period setting process for registering or updating an application period of an in-store code in association with the product identification code acquired in the product chart acquisition process among the product identification codes registered in the code management DB. The code management method described. The code management method according to any one of claims 8 to 12, wherein the code management information includes a retail chain name indicating a retail chain to which an in-store code is assigned. The code management method according to any one of claims 8 to 13, wherein the code management information includes a product name of a product to which a product identification code is assigned. The code management information includes a graphic code that is given to each product in the retail chain to the product indicated by the product identification code instead of or together with the in-store code. Code management method.

Images