JP5052160B2 - Code management system - Google Patents

Description

  The present invention relates to a code management server that performs code management to identify the same product among products that are individually assigned an in-store code in each retail chain, and a manufacturer that is managed by a manufacturer that produces or manufactures the product. The present invention relates to a code management system including a product server.

  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 system according to the present invention includes a code management server that performs code management to identify the same product among products that are individually assigned an in-store code in each retail chain, and a manufacturer that produces or manufactures the product. A code management system including a managed manufacturer product server, wherein the manufacturer product server includes a product identification code given to the product when the product is produced or manufactured, and a product indicated by the product identification code. A manufacturer product management DB for storing manufacturer product management information including a manufacturer code assigned to each manufacturer, manufacturer code receiving means for receiving specification of a manufacturer code assigned to a search target product, and receiving the manufacturer code The product identification code corresponding to the manufacturer code received by the means is displayed as the manufacturer product. Product identification code search means for searching with reference to the physical DB, search request information transmission means for sending search request information including the product identification code searched by the product identification code search means, and search results from the code management server Search result information output means for outputting information, and the code management server includes code management information including the product identification code and an in-store code assigned to the product indicated by the product identification code in each retail chain. Code management information including a code management DB to be stored, search request receiving means for receiving search request information from the search request information transmitting means, and a product identification code included in the search request information received by the search request receiving means Code tube for searching the code management DB and extracting part or all of the searched code management information An information search and extraction unit, and the search result information transmitting means for transmitting a part or all of the code management information said code management information retrieval extracting means has extracted as the search result information, to the product by the manufacturer that produced or manufactured products Manufacturer management information acquisition means for acquiring manufacturer management information including the assigned product identification code; 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 the chain, and a product master for managing the product chart Product chart of the product indicated by the product chart number acquired by the retail store information acquisition means from the server In association with the product identification information acquired by the product medical record information acquisition unit among the product identification codes registered in the code management DB, In-store code registration means for registering the in-store code acquired by the retail store information acquisition means .

  By configuring as described above, the manufacturer side that produces or manufactures the product uses the manufacturer code as a key and uses the manufacturer code as a key for each product indicated by the in-store code that is assigned and used separately among multiple stores. The identity can be easily confirmed. Accordingly, it is possible to smoothly aggregate sales statuses among a plurality of stores.

  The maker product management information includes a maker code application period, the code management information includes an in-store code application period, and the maker product server includes a date receiving unit that receives designation of a search date, The code search means searches for a product identification code associated with the application period including the date received by the date reception means from among the product identification codes corresponding to the manufacturer code received by the manufacturer code reception means, The search request information transmitting unit transmits search request information including the product identification code searched by the product identification code searching unit and the date received by the date receiving unit, and the code management information search extracting unit is configured to transmit the search request information. Among the product identification codes included in the information, the applicable period including the date included in the search request information is You may search the code management information including product identification code that has been assigned.

  The code management server is an application period setting unit for registering or updating an application period of an 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 included.

  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.

  According to the present invention, on the maker side that produces or manufactures the merchandise, the identity of each merchandise indicated by the in-store code that is separately assigned and used among a plurality of stores without using the maker code as a key. It becomes possible to confirm easily.

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 product master server 20, retail store servers 31 to 3N (N: an arbitrary positive integer), and manufacturer product servers 51 and 52. Including. The code management server 10, the product master server 20, the retail store servers 31 to 3N, and the manufacturer product servers 51 and 52 are each connected to a communication network 40 such as the Internet.

  The code management server 10, the product master server 20, the retail store servers 31 to 3N, and the manufacturer product servers 51 and 52 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. Also, the manufacturer production management information is periodically transmitted from the manufacturer product servers 51 and 52 managed by the manufacturers A and B, for example, to the code management server 10 via the communication network and accumulated in the manufacturer production management DB 12. The

  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.

  The manufacturer product servers 51 and 52 are managed by manufacturers A and B that produce or manufacture products, respectively, and a manufacturer management DB 51a that stores manufacturer product management information including various information related to products that are produced or manufactured and shipped. , 52a. The manufacturer management DBs 51a and 52a may be inside or outside the manufacturer product servers 51 and 52, respectively. In this example, the two maker product servers 51 and 52 are provided. However, any number of maker product servers may be provided.

  FIG. 2 is an explanatory diagram showing an example of manufacturer product management information stored in the manufacturer management DB 51a provided in the manufacturer product server 51 managed by the manufacturer A. As shown in FIG. 2, the manufacturer product management information includes a product name and a JAN code assigned to the product by the manufacturer A when the product is produced or manufactured (in this example, it means “product identification code”). And the manufacturer code and the application period are associated with each other. The manufacturer code is a code that is uniquely assigned to each product produced or manufactured by each manufacturer. The manufacturer code may be a specific standard format such as the JAN format, or may have a format unique to the manufacturer. There may be. The application period means the period that is applied to the product with the corresponding manufacturer code, and if it is still applied, the period end date cannot be determined and “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.

  FIG. 3 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. 3, 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. 3, as the product name, a product name such as canned food A and seasoning A and / or a supplier name (manufacturer name) are set. 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. 4 is an explanatory diagram illustrating an example of code management information stored in the code management DB 11. As shown in FIG. 4, 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. 5 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. 6 is a flowchart illustrating an example of a product search process executed by the code management system 100 of this example. In this case, a product to which a manufacturer code (for example, a production number) designated by an operator of the manufacturer product server 51 is assigned and which is sold with a separate in-store code assigned in each retail chain is searched. An example will be described.

  In the product search process, the manufacturer product server 51 accepts a manufacturer code (for example, “X0003457”) input by the operator by operating the input device provided therein (step S201). In addition, the manufacturer product server 51 receives a search target date (for example, October 15, 2006) input by an operator through an operation of an input device included in the manufacturer product server 51 (step S202).

  Next, the manufacturer product server 51 refers to the manufacturer management DB 51a, associates it with the manufacturer code received in step S101, and includes the JAN code (for example, the date received in step S202 during the application period). "000123") is retrieved and extracted (step S203).

  Then, the manufacturer product server 51 transmits the search request information including the searched JAN code and the search target date received in step S202 to the code management server 10 via the communication network 40 (step S204).

  The code management server 10 receives the search request information from the manufacturer product server 51, and receives the JAN code and search target date included in the received search request information (step S205).

  Next, the code management server 10 refers to the code management DB 11, associates the code management information that is associated with the JAN code received in step S205 and includes the date received in step S205 during the application period. Search and extract (step S206). Then, the code management server 10 transmits the search result (searched code management information) to the manufacturer product server 51 via the communication network 40 (step S207).

  The manufacturer product server 51 receives the code management information that is the search result from the code management server 10, generates search result screen information based on the received code management information, and displays the search result screen information on the display screen of its own display device. A search result screen indicated by the search result screen information is displayed (step S208). For example, as shown in FIG. 7, the search result screen includes a search condition display area 201 for displaying search conditions and a search result display area 202 for displaying search results.

  FIG. 7 shows an example of a search result when the manufacturer code “X0003457” and the date “October 15, 2006” are designated as the search conditions. As shown in FIG. 7, as a search result, the product identification information corresponding to the manufacturer code “X0003457” is the JAN code “000123”, and the product indicated by the JAN code “000123” is the product name “canned A”. On the designated date “October 15”, it is shown that separate in-store codes were used in the five retail chains A, B, D, F, and H, respectively. As a result of the search, the product with the product name “canned A” to which the manufacturer code “X0003457” is assigned by the manufacturer A is assigned the JAN code “000123” on October 15, 2006, and each retail chain A , B, D, F, and H, it can be confirmed that the in-store code displayed in the area 202 was applied and sold.

  In the above example, the date is accepted in step S202. However, for example, as shown in FIG. 8, a range of dates to be searched may be accepted. In this case, the maker product server 51 refers to the maker management DB 51a and associates the JAN code that is associated with the maker code received in step S101 and includes the date range received in step S202 during the application period. Search and extract (step S203). Further, the manufacturer product server 51 transmits the search request information including the searched JAN code and the search target date range received in step S202 via the communication network 40. (Step S204). The code management server 10 searches the code management DB 11 for code management information associated with the JAN code received in step S205 and including the date range received in step S205 during the application period. Are extracted (step S206). The search result screen displayed on the manufacturer product server 51 is, for example, as shown in FIG.

  FIG. 9 shows an example of a search result when the manufacturer code “X0003457” and the date range “October 15-18, 2006” are designated as the search conditions. As shown in FIG. 9, as a search result, the product identification information is the JAN code “000123”, the product indicated by the JAN code is the product name “canned A”, and in the retail chain A, 15th and 16th to 18th. It is shown that separate in-store codes are applied to the day, and that the same four in-store codes were used during the specified period in the other four retail chains B, D, F, and H. As a result of the search, the product with the product name “canned A” to which the manufacturer code “X0003457” is assigned is assigned the JAN code “000123” on October 15 to 18, 2006, and each retail chain A , B, D, F, and H, it can be confirmed that the in-store code displayed in the area 202 was applied and 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 manufacturer product server 51 indicates the product identification code (JAN code) given to the product when the product is produced or manufactured, and the product identification code. A maker product management DB 51a for storing maker product management information including a maker code assigned to each maker for a product is provided, and designation of a maker code given to a search target product is received and corresponds to the received maker code. The product identification code is searched with reference to the manufacturer product management DB 51a, the search request information including the searched product identification code is transmitted, and the search result information from the code management server 10 is output (for example, displayed). . In addition, the code management server 10 includes a code management DB 11 that stores code management information including a product identification code and an in-store code assigned to the product indicated by the product identification code in each retail chain. The search request information is received, the code management information including the product identification code included in the received search request information is searched with reference to the code management DB 11, and a part or all of the searched code management information is extracted. A part or all of the extracted code management information is transmitted to the manufacturer product server 51 as search result information. Therefore, on the maker side that produces or manufactures the product, it is easy to check the identity of each product indicated by the in-store code that is assigned and used separately among multiple stores without using the manufacturer code as a key. Will be able to. Accordingly, it is possible to smoothly aggregate sales statuses among a plurality of stores.

  In the above-described embodiment, the manufacturer product management information includes the application period of the manufacturer code, the code management information includes the application period of the in-store code, and the manufacturer product server 51 accepts the specification of the date to be searched, and the manufacturer code Search for the product identification code associated with the application period including the received date among the product identification codes corresponding to, send the search request information including the searched product identification code and the received date, the code management server 10 is configured to search for code management information including a product identification code associated with an application period including a date included in the search request information among the product identification codes included in the search request information. So, on the specified date, search for the in-store code applied to the product indicated by the corresponding product identification code. It can be output, so the identity of the goods in the retail chains in the specified date 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 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 embodiment described above, 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.

  According to the present invention, on the maker side that produces or manufactures the merchandise, the identity of each merchandise indicated by the in-store code that is separately assigned and used among a plurality of stores without using the maker code as a key. Useful for easy confirmation.

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 manufacturer goods management information. 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 Product Master Server 31 to 3N Retail Store Server 40 Communication Network 51, 52 Manufacturer Product Server 100 Code Management System

Claims (5)

A code management server that performs code management to specify the same product among products that are individually assigned an in-store code in each retail chain, and a manufacturer product server that is managed by a manufacturer that produces or manufactures the product A code management system comprising:
The manufacturer product server is
A manufacturer product management DB that stores manufacturer product management information including a product identification code given to the product when the product is produced or manufactured, and a manufacturer code given to each manufacturer by the product indicated by the product identification code When,
A manufacturer code receiving means for receiving specification of a manufacturer code given to a search target product;
Product identification code search means for searching for a product identification code corresponding to the manufacturer code received by the manufacturer code reception means with reference to the manufacturer product management DB;
Search request information transmitting means for transmitting search request information including the product identification code searched by the product identification code search means;
Search result information output means for outputting search result information from the code management server,
The code management server
A code management DB for storing code management information including the product identification code and an in-store code assigned to each product in the retail chain to the product indicated by the product identification code;
Search request accepting means for accepting search request information from the search request information transmitting means;
The code management information including the product identification code included in the search request information received by the search request receiving means is searched with reference to the code management DB, and a part or all of the searched code management information is extracted. Code management information retrieval and extraction means;
Search result information transmitting means for transmitting a part or all of the code management information extracted by the code management information search extracting means as the search result information ;
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;
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 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 information acquisition unit among the product identification codes registered in the code management DB; A code management system characterized by including: The manufacturer product management information includes a manufacturer code application period,
The code management information includes an application period of the in-store code,
The manufacturer product server includes a date receiving means for receiving specification of a date to be searched,
The product identification code search means searches for the product identification code associated with the application period including the date received by the date reception means from among the product identification codes corresponding to the manufacturer code received by the manufacturer code reception means. ,
The search request information transmission means transmits search request information including the product identification code searched by the product identification code search means and the date received by the date reception means,
The code management information search and extraction means includes a code including a product identification code associated with the application period including the date included in the search request information among the product identification codes included in the search request information. The code management system according to claim 1, wherein the management information is searched. The code management server
And association with the product identification code is product chart acquisition means has acquired out of product identification codes registered in said code management DB, according to claim 1 or includes the application period setting means for registering or updating the application period of the installation Accord The code management system according to claim 2 . The code management system according to any one of claims 1 to 3 , 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 system according to any one of claims 1 to 4 , wherein the code management information includes a product name of a product to which a product identification code is assigned.

Images