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

Description

  The present invention provides a code for performing code management for a product to which a product specification identification code for identifying the product is given when the product is produced or manufactured, and an in-store code is separately assigned in each retail chain The present invention relates to a management server and a code management method.

  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

  In the conventional POS system described above, the information obtained by the POS code is an in-store code unique to each store. In the chain store, an international standard code format called JAN (EAN) code is generally used. However, in-store codes with different registered corresponding products are used.

  On the other hand, a product master is created for each product sold in each chain store, and a product master number is assigned to each product master. This merchandise master number can uniquely identify the merchandise sold at each chain store.

  Therefore, if the in-store code and the product master number used in each chain store are associated with each other on a one-to-one basis, it is possible to accurately obtain information on the corresponding product from the in-store code in each chain store.

  However, in practice, for example, in the case where only some materials in a product such as a side dish or a bento are changed, the product master number is given separately, but the in-store code continues without being changed. Therefore, there is a problem that accurate information about the corresponding product cannot be obtained from the in-store code.

  This invention solves the problem mentioned above, and makes it possible to accurately confirm information of each product indicated by an in-store code that is separately assigned and used between a plurality of stores without being unified. Objective.

  The code management server of the present invention is provided with a product specification identification code for identifying a product when the product is produced or manufactured, and a code for a product to which an in-store code is separately assigned in each retail chain A code management server for managing the product specification identification code, an in-store code given to each product in the retail chain to the product indicated by the product specification identification code, and a range of a shelf life of the product indicated by the product specification identification code Search request information reception means for receiving code management DB for storing code management information including a period corresponding to a best-before date and a search request information including an in-store code assigned to the search target product and the best-before date of the product And the in-store code included in the search request information received by the search request information receiving means The code management information associated with the expiration date corresponding period including the expiration date included in the search request information is searched with reference to the code management DB, and the product included in the searched code management information Using the product specification identification code specifying means for specifying the specification identification code and the product specification identification code specified by the product specification identification code specifying means, the product chart of the product to which the product specification identification code is assigned is acquired. Product chart acquisition means, display order determination means for determining the display order of product information including the materials used for the product indicated by the product chart acquired by the product chart acquisition means and the specifications of the materials used, and the product chart acquisition At least the material used in the product information indicated by the product chart obtained by the means is output by designating the display order determined by the display order determining means. Product information output means, specification search request reception means for receiving a search request for specifications of the material used, and search for specifications of the material used in response to the specification search request reception means receiving a specification search request It is characterized by comprising specification retrieval means and specification information output means for outputting the specification information including the specifications of the used materials retrieved by the specification retrieval means.

  By configuring as described above, it becomes possible to search for information of each product indicated by the in-store code that is separately given and used among a plurality of stores without unification by the in-store code and the expiration date. Can be confirmed accurately.

  The search request information receiving means receives search request information transmitted from a retail chain server managed in each retail chain via a communication network, and the retail chain server can specify an in-store code and a shelf life Search request information specifying screen display means for displaying a search request information specifying screen including a search request information specifying area, and search request information for transmitting the search request information specified on the search request information specifying screen via a communication network A transmission unit may be included.

  The search request information specifying screen display means may be configured to display an icon associated with a predetermined in-store code and a predetermined best-before date in the search request information specifying area so as to be specified.

  The icon is formed by, for example, an image that can identify the corresponding product.

  Manufacturer management information acquisition means for acquiring manufacturer management information including a product specification identification code assigned to the product by a manufacturer who has produced or manufactured the product, and the manufacturer management information acquired by the manufacturer management information acquisition means is the code management DB. It may be configured to include manufacturer management information registering means registered in

  Retail store information acquisition means for acquiring retail store information including an in-store code and a product specification identification code of a product to which the in-store code is assigned from each retail chain server managed in each retail chain, and the code management DB In-store code registration means for registering the in-store code acquired by the retail store information acquisition means in association with the product specification identification code acquired by the retail store information acquisition means among the product specification identification codes registered in It may be configured to include.

  The code management information may be configured to include a retail chain name indicating the retail chain to which the in-store code is assigned.

  The code management information may include a product name of a product to which a product specification identification code is assigned.

  The merchandise information indicated by the merchandise chart includes the merchandise name of the corresponding merchandise and the amount of the material used. A quantity search request receiving means for outputting a used material and receiving a quantity search request; and a quantity search means for searching for a quantity of the used material in response to the quantity search request receiving means receiving a quantity search request. And a quantity information output means for outputting quantity information including the quantity of the used material searched by the quantity search means.

  The display order determining means may be configured to determine the display order so that the used materials are displayed from the one with the larger amount of the used materials searched by the quantity search means.

  The display order determining means may be configured to determine the display order so that the materials used are displayed in descending order of priority according to a predetermined priority order.

  In addition, the code management method of the present invention provides a product specification identification code for identifying a product when the product is produced or manufactured, and a product to which an in-store code is separately assigned in each retail chain. Is a code management method for performing the code management of the search request information receiving process for receiving the search request information including the in-store code given to the search target product and the expiration date of the product, and the search request information receiving process Code management information that includes the in-store code included in the search request information received at, and is associated with the expiration date corresponding period including the expiration date included in the search request information, the product specification identification code, and the product The in-store code given to each retail chain to the product indicated by the specification identification code and the product specification identification The code management DB that stores the code management information that stores the expiration date corresponding period indicating the range of the expiration date of the product indicated by the service code is searched, and the product specification identification code included in the searched code management information is retrieved. Using the product specification identification code to be identified and the product specification identification code identified in the product specification identification code to obtain the product chart of the product to which the product specification identification code is assigned Processing, display order determination processing for determining the display order of the product information indicated by the product chart acquired in the product chart acquisition processing, and product information indicated by the product chart acquired in the product chart acquisition processing, the display order And product information output processing for designating and outputting the display order determined in the determination processing.

  According to the present invention, it is possible to accurately confirm information on each product indicated by an in-store code that is separately given 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 a server managed by a system administrator of the code management system 100, for example, and is used at a manufacturing code given to a product when the product is produced or manufactured, or at each retail store. It manages in-store code.

  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 manufacturing code and the in-store code used at each retail store. The manufacturer production management information includes the manufacturing code given to the product by the manufacturer when the product is produced or manufactured, the product name of the product indicated by the manufacturing 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, periodically from the manufacturer terminal (not shown) managed by each manufacturer to the code management server 10 via the communication network 40 and accumulated 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 merchandise master includes a merchandise master number (an example of a merchandise chart code) for uniquely identifying a merchandise and a manufacturing code assigned to the merchandise (see FIG. 5). 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 N, and stores the POS information used in each of the retail chains A to N. 3Na is provided. The retail store servers 31 to 3N are installed in the retail chains A to N, for example. Although not shown in the retail store servers 31 to 3N, a POS register used in each retail chain A to N (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.

  Each of the retail store servers 31 to 3N includes, for example, a label printing pasting device (not shown) for printing a matter related to a product on a label and pasting the printed label on the corresponding product.

  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 manufacturing code, 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, as the product name, a product name such as lunch box A, seasoning A, and / or supplier name (manufacturer name) is 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. 3 is an explanatory diagram illustrating an example of a retail chain product master 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 retail chain product master includes a product name, an in-store code, icon data indicating the corresponding product, the date of arrival of the product, and the expiration date of the product. The icon data is, for example, image data such as a photograph of the corresponding product.

  The retail chain product master is a retail chain product master managed in each retail chain A to N, and each retail chain product master DB 31a to 3Na provided in each of the store servers 31 to 3N and the retail store servers 31 to 3N. Is stored in each.

  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, the code management information is associated with a product name, a manufacturing code, a retail chain name, an in-store code, and an expiration date corresponding period that is a corresponding period of the expiration date of the product indicated by the manufacturing code. Information. The expiry date corresponding period means a period in which the expiry date of the product to which the applicable manufacturing code (or the product chart code associated with the manufacturing code) is assigned indicates the range of the applicable date. Is still being produced or manufactured, the end date of the period cannot be determined, so “continuing use (applied)” is set. Note that the expiration date corresponding period may be managed not in units of days but in units of months, weeks, hours, minutes, and seconds.

  FIG. 5 is an explanatory diagram illustrating an example of a product chart stored in the product master DB 21. As shown in FIG. 5, in the product chart, the product name of the product, the manufacturing code uniquely assigned to the product, the product chart code uniquely assigned to the product, and the product This is information in which used materials, used material amount information indicating the amount of each used material, and used material specification information indicating the specification of each used material are associated with each other. The specification information of the materials used is information indicating the specifications regarding the energy (calories), raw materials, additives, allergens, etc. of the materials used (for example, each raw material product or semi-finished product (eggaki, boiled beans, paste, etc.)) means.

Next, the operation of the code management system 100 of this example will be described.
FIG. 6 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 an operator of the code management server 10 or periodically (for example, once a day in the early 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 the manufacturing code included in the acquired manufacturer production management information in the corresponding items of the code management information stored in the code management DB 11, and the corresponding taste. The start date is registered in the item corresponding to the time limit, and since the end date is undetermined, “use in progress” is registered (step S102). Note that the end date may be registered by the code management server 10 in accordance with an instruction from the manufacturer's terminal.

  Next, the code management server 10 acquires POS information newly registered (registered after the previous acquisition) from each of the retail store servers 31 to 3N (step S103). In step S103, only the manufacturing code and the in-store code may be acquired from the POS information.

  Next, the code management server 10 registers the in-store code and the retail chain name in association with the code management information including the manufacturing code included in the POS information acquired in step S103 (step S104). If the in-store code is already associated with the code management information including the manufacturing code included in the POS information, the code management information including the manufacturing code included in the POS information is copied, and then the in-store code or retail The in-store code and retail chain name are registered by updating the chain name to that included in the POS information.

  In this example, for example, when the material used for the corresponding product is changed, the manufacturing code included in the maker production management information is updated and registered in the maker production management DB 12. When the manufacturing code is updated, a new product chart for the corresponding product is created and stored in the product master DB 21. This product chart includes a newly added product chart code. Then, when the manufacturing code is updated, this is notified to the retail store servers 31 to 3N, and the manufacturing code in the POS information is updated. In this example, it is assumed that the in-store code is not updated in the retail store servers 31 to 3N for products having the same product name (for example, products such as XX croquette and XX lunch box are not changed).

  FIG. 7 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, a case will be described as an example where merchandise information such as materials used is retrieved for a merchandise to which an in-store code designated by the operator of the retail store server 31 has been assigned and a merchandise with a designated expiration date. .

  First, the operator of the retail store server 31 inputs the in-store code assigned to the search target product and the expiration date of the product in the search condition specification area 101 of the search condition specification screen as shown in FIG. To specify the search condition. When the search condition is specified, the search target confirmation area 102 of the search condition specification screen displays the product name of the product specified as the search target and the manufacturing code of the product. That is, when the retail store server 31 receives specification of the search condition from the operator, the retail store server 31 searches for the product name and the production code using the POS information and the retail chain product master, and displays it in the search target confirmation area 102. . When the operator confirms the specified content of the search condition, the operator presses the search execution button 103 by operating an input device such as a mouse. When the search execution button 103 is pressed, the retail store server 31 transmits the designated in-store code and expiration date to the code management server 10.

  For example, as shown in FIG. 9, the search condition designation screen displays icons for each selectable product in the search condition designation area 101, and the search target product can be selected by designating the icon. Good. In this case, when the retail store server 31 accepts the selection of the icon, it searches for the in-store code, the product name, and the manufacturing code of the product associated with the selected icon using the POS information and the retail chain product master. Then, a process for displaying in the search target confirmation area 102 is performed. Further, the retail store server 31 performs a process of determining, as a search condition, a best-before date that is the most recent date among the best-before dates associated with the corresponding product, and displaying it in the search target confirmation area 102. When the search execution button 103 is pressed, the retail store server 31 transmits the designated in-store code and expiration date to the code management server 10.

  In the product search process, the code management server 10 receives search request information including an in-store code (for example, A00000023) and a shelf life (for example, March 23, 2007) from the retail store server 31 via the communication network 40 ( Step S301).

  Next, the code management server 10 refers to the code management DB 11 and is associated with the in-store code received in step S301, and the code management in which the expiration date received in step S301 is included in the expiration date corresponding period. Information is searched and extracted (step S302).

  Next, the code management server 10 selects the manufacturing code included in the code management information extracted in step S302, so that the in-store code received in step S301 is used in step S301. The manufacturing code assigned to the product with the expiration date received is specified (step S303).

  Next, the code management server 10 presents the production code specified in step S303 to the product master server 20, and the product chart code associated with the production code presented from the product master server 20 is given. The merchandise medical record that is stored is acquired (step S304).

  Then, the code management server 10 generates search result screen information for displaying a search result screen provided with a display area for the product search result information including the product name and used material indicated by the acquired product chart, and is necessary. Accordingly, the display order of the materials used is determined, the determined display order is designated, and the generated search result screen information is transmitted to the retail store server 31 (step S305). The display order is determined according to a predetermined determination rule. Here, for example, it is assumed that the items are displayed in order from the one with the highest priority determined in advance for each product. This priority order is registered in, for example, a display order determination table and stored in a DB included in the code management server 10. The retail store server 31 displays the search result screen indicated by the received search result screen information on the display screen of the display device provided in itself. For example, as shown in FIG. 10, the search result screen searches for a search condition display area 201 for displaying a search condition, a search result display area 202 for displaying a search result, and a quantity of used material and a specification of used material. A search instruction button 203 is provided. In this example, the materials used are displayed in the search result display area 202 in the designated order.

  FIG. 10 shows an example of a search result when the in-store code “A0000025” and the expiration date “March 23, 2007” are designated as the search conditions. As shown in FIG. 10, as a search result, the product indicated by the in-store code “A00000023” is the product name “Bento A” and the specified date “March 23” is the expiration date, the production code “000123” and a commercial chart code “KA00045” are used, and it is shown that the material used for “Bento A” is “eggaki”, “fried chicken” and the like. In this example, based on the in-store code and the expiration date that are independently assigned to each retail chain, even if the manufacturing code (commodity chart code) has been updated, the material used for the product is searched. It becomes possible.

  Furthermore, when the code management server 10 receives the quantity / specification search instruction information indicating that the search instruction button 203 has been pressed by the operator on the search result screen of FIG. The search result screen information for extracting the quantity information indicating the quantity and the specification information indicating the specification of the material used from the product chart and displaying the search result screen provided with the display area for the extracted quantity information and the specification information is displayed. The display order of the used material and the specification information is determined again if necessary, the determined display order is designated, and the generated search result screen information is transmitted to the retail store server 31 (step S306). The display order is determined according to a predetermined determination rule. Here, for example, in order according to a predetermined decision rule, such as from one with a large amount of material used, one with a large amount of material, or one with a small amount, or one with a predetermined high priority. It will be displayed. The retail store server 31 displays the search result screen indicated by the received search result screen information on the display screen of the display device provided in itself. For example, as shown in FIG. 11, 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. Then, as shown in FIG. 11, in the search result display area 202, the used material, its amount, and the specification of the used material are displayed. In this example, the search result display area 202 displays the materials used, their amounts, and uses in the specified order. Here, as shown in FIG. 11, the materials used are displayed in order from the one with the largest amount. Depending on the display order decision rule, for example, as shown in FIG. 12, “high-ranking chicken” may be displayed in order from the highest priority. The priority order may be determined by the system administrator, for example, by raising the product manufactured by the sponsor company. Note that there are a plurality of display order determination rules, and each determination rule may have a priority. In this way, it is possible to display from the higher priority order set in advance, and to display the same priority order from the larger amount.

  As shown in FIG. 11, as a search result, in addition to the information shown in FIG. 10, the amount of each material such as “eggaki” used in the product “Bento A” and the product “Bento A” The specifications of each material used are shown. Based on this search result, the material used for the trade name “Bento A”, the amount of the material, and the specification of the material can be confirmed.

  In the above example, a part of the product chart is extracted and displayed on the search result screen. However, the entire contents of the product chart 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.

  In the above example, the search result screen is displayed on the retail store server 31, but the above-described search is performed when product-related information is printed on the label by the label print pasting device provided in the retail store server 31. Display information on the result screen and information that can be grasped at the retail store may be printed on a label and attached to the corresponding product. In this case, for example, as shown in FIG. 13, for example, the label for the lunch box A includes an in-store code, a shelf life, a price, a product name, a manufacturing code, a product chart code, a used material, a used material quantity, a used material specification, and the like. Is printed.

  As described above, in the above-described embodiment, the code management server 10 includes the product specification identification code (manufacturing code) and the in-store code assigned to the product indicated by the product specification identification code in each retail chain. And a code management DB 11 for storing code management information including a shelf life period indicating a range of the shelf life of the product indicated by the product specification identification code, and an in-store code assigned to the search target product and the product Retrieving search request information including the expiration date, including the in-store code included in the received search request information, and code management information associated with the expiration date corresponding period including the expiration date included in the search request information, Search by referring to the code management DB 11 and specify the product specification identification code included in the searched code management information After that, using the specified product specification identification code, obtain the product chart of the product to which the product specification identification code is assigned, and specify the material used for the product indicated by the acquired product chart and the specifications of the material used. In response to receiving a search request for specifications of materials used by determining the display order of the product information to be included, outputting at least the material used in the product information indicated by the acquired product chart, specifying the determined display order Therefore, the in-store code that is assigned and used separately among multiple stores without unification is shown because the specification information including the specification of the used material that has been searched is output. Information on each product can be easily searched using the in-store code and the expiration date as a search key, and can be confirmed accurately. Further, the search results can be displayed in a desired display order, and the material to be displayed with priority can be displayed at a position where it can be easily seen. Furthermore, it is possible to search and display the use of the material used for the product, and to easily search for detailed information on the product.

  The product specification identification code is unique for each product with different specifications such as product name, raw materials used, secondary raw materials, additives, allergens, manufacturing plant, target sales area (for example, for the Kansai area), and packaging design. It is an identification code given to. That is, when a specification (data file) as described above is updated in a certain product, a new product specification identification code is given. The production code is an example of a product specification identification code.

  In the above-described embodiment, the code management server 10 receives the search request information transmitted via the communication network 40 from the retail chain server 31 managed in each retail chain, and the retail chain server 31 A search request information designation screen including a search request information designation area (see 101 in FIG. 8) in which the in-store code and the expiration date can be designated is displayed, and the search request information designated on the search request information designation screen is displayed on the communication network. Since it is configured to transmit via 40, the search request information can be easily specified on the retail chain server 31 side.

  In the above-described embodiment, the retail chain server 31 displays an icon associated with a predetermined in-store code and a predetermined best-before date in the search request information specifying area (see 101 in FIG. 9) so that it can be specified. Since it is configured, the search request information can be specified very easily on the retail chain server 31 side.

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

  In the embodiment described above, the retail store in which the code management server 10 includes the in-store code and the product specification identification code of the product to which the in-store code is assigned from each retail chain server managed in each retail chain. Since the information is acquired and the acquired in-store code is registered in association with the acquired product specification identification code among the product specification identification codes registered in the code management DB 11, a new installation is performed in each retail chain. When an accord is given, the in-store code can be registered in the code management DB 11 as code management information in which a retail chain name or the like is associated with an appropriate product specification identification code.

  In the embodiment described above, the product information indicated by the product chart includes the product name of the product, the material used for the product, the material used in the production or manufacture of the product, the amount of the material used, and the material. The code management server 10 outputs, as search results, the product name of the product, the material used for the product, and the material used in the production or manufacture of the product as the product information indicated by the product chart. After that, in response to accepting the quantity search request, the quantity of the used material and the quantity of the material are searched, and the quantity information including the searched quantity of the used material and the quantity of the material is output. Therefore, it is possible to easily search and present the material of the product and the quantity of the material.

  Further, in the above-described embodiment, when the code management server 10 is configured to determine the display order so that the used materials are displayed from the one with the larger amount of searched used materials, the amount is large. Since the materials used are displayed in order, it is possible to display the search results in an easy-to-read manner.

  Further, in the above-described embodiment, when the code management server 10 is configured to determine the display order so that the materials are displayed from the one with the larger amount of the retrieved materials, the materials are ordered in descending order of the amounts. Is displayed, so that the search result can be displayed in an easily viewable manner.

  Further, in the above-described embodiment, the code management server 10 is configured to determine the display order so that the used materials and materials are displayed from the higher priority according to the predetermined priority. In this case, it is possible to display, for example, a material that should be preferentially displayed, such as a material manufactured by a cooperating company, at a position where it can be easily viewed.

  In the above-described embodiment, the in-store code is used. However, the code management information is assigned to the product indicated by the product specification identification code in each retail chain instead of the in-store code or together with the in-store code. The figure 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 accurately confirming information on each product indicated by an in-store code that is separately given 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 a retail chain goods master. It is explanatory drawing which shows the example of code management information. It is explanatory drawing which shows the example of the content of a merchandise chart. 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 condition designation | designated screen. It is explanatory drawing which shows the example of a search condition designation | designated screen. It is explanatory drawing which shows the example of a search result screen. It is explanatory drawing which shows the example of a search result screen. It is explanatory drawing which shows the example of a search result screen. It is explanatory drawing which shows the example of the printing information on the label affixed on goods.

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 (20)

It is a code management server that manages codes for products that are assigned product specification identification codes for identifying the products when they are produced or manufactured, and that are individually assigned in-store codes in each retail chain. And
A code including the product specification identification code, an in-store code assigned to the product indicated by the product specification identification code in each retail chain, and an expiration date corresponding period indicating the range of the expiration date of the product indicated by the product specification identification code A code management DB for storing management information;
Search request information receiving means for receiving search request information including an in-store code given to a search target product and the expiration date of the product;
Code management information including the in-store code included in the search request information received by the search request information receiving unit and associated with the expiration date corresponding period including the expiration date included in the search request information is stored in the code management DB. A product specification identification code specifying means for searching for and specifying a product specification identification code included in the searched code management information,
Using the product specification identification code specified by the product specification identification code specifying means, and obtaining a product chart of the product to which the product specification identification code is assigned;
Display order determining means for determining the display order of the product information including the material used for the product indicated by the product chart acquired by the product chart and the specifications of the material used;
Commodity information output means for designating and outputting at least the materials used in the commodity information indicated by the commodity chart acquired by the commodity chart obtaining means by specifying the display order determined by the display order determining means;
Specification search request accepting means for accepting a search request for specifications of the material used;
In response to the specification search request receiving means receiving a specification search request, specification search means for searching for specifications of the materials used;
The code management server, comprising: specification information output means for outputting specification information including the specifications of the used materials searched by the specification search means. The search request information receiving means receives search request information transmitted via a communication network from a retail chain server managed in each retail chain,
The retail chain server is
A search request information specifying screen display means for displaying a search request information specifying screen including a search request information specifying area capable of specifying an in-store code and an expiration date;
The code management server according to claim 1, further comprising: search request information transmitting means for transmitting search request information specified on the search request information specifying screen via a communication network. The code management server according to claim 2, wherein the search request information designation screen display means displays an icon associated with a predetermined in-store code and a predetermined expiration date in the search request information specification area so as to be specified. The code management server according to claim 3, wherein the icon is formed by an image that can identify the corresponding product. Manufacturer management information acquisition means for acquiring manufacturer management information including a product specification identification code given to the product by the manufacturer that produced or manufactured the product;
5. 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 specification identification code of a product to which the in-store code is assigned from each retail chain server managed in each retail chain;
An in-store code for registering the in-store code acquired by the retail store information acquisition unit in association with the product specification identification code acquired by the retail store information acquisition unit among the product specification identification codes registered in the code management DB The code management server according to claim 5, further comprising registration means. The code management server according to any one of claims 1 to 6, 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 7, wherein the code management information includes a product name of a product to which a product specification identification code is assigned. The product information indicated by the product chart includes the product name of the product and the amount of the material used,
The product information output means outputs the product name of the product and the material used for the product as product information indicated by the product chart,
A quantity search request accepting means for accepting a quantity search request;
In response to the quantity search request receiving means receiving a quantity search request, a quantity search means for searching the quantity of the material used;
The code management server according to claim 1, further comprising quantity information output means for outputting quantity information including the quantity of the used material searched by the quantity search means. The code management server according to claim 9, wherein the display order determination unit determines the display order so that the used materials are displayed from the one with the larger amount of the used materials searched by the quantity search unit. The said display order determination means determines a display order so that use material may be displayed from the one with a higher priority according to the predetermined priority. The one in any one of Claims 1-9 Code management server. This is a code management method for managing codes for products to which product specification identification codes for identifying the products are given when the products are produced or manufactured, and for which in-store codes are separately assigned in each retail chain. And
A search request information receiving process for receiving search request information including an in-store code given to the search target product and the expiration date of the product;
Code management information including the in-store code included in the search request information received in the search request information reception process and associated with the expiration date corresponding period including the expiration date included in the search request information, the product specification Code management information including an identification code, an in-store code given in each retail chain to the product indicated by the product specification identification code, and an expiration date corresponding period indicating the range of the expiration date of the product indicated by the product specification identification code A product specification identification code specifying process for searching with reference to the stored code management DB and specifying a product specification identification code included in the searched code management information;
Using the product specification identification code specified in the product specification identification code specifying process, and obtaining a product chart of the product to which the product specification identification code is assigned;
A display order determination process for determining a display order of product information including the material used for the product indicated by the product chart acquired in the product chart acquisition process and the specifications of the material used;
Product information output processing for designating and outputting at least the materials used in the product information indicated by the product chart acquired in the product chart acquisition processing by specifying the display order determined in the display order determination processing;
A specification search request reception process for receiving a search request for the specification of the material used;
A specification search process for searching for specifications of the materials used in response to the specification search request reception process receiving a specification search request;
A specification information output process for outputting specification information including the specifications of the used material searched by the specification search process. In the search request information reception process, search request information transmitted from a retail chain server managed in each retail chain via a communication network is received,
The retail chain server is
Search request information specification screen display processing for displaying a search request information specification screen including a search request information specification area in which an in-store code and an expiration date can be specified;
The code management method according to claim 12, wherein search request information transmission processing for transmitting the search request information specified on the search request information specifying screen via a communication network is executed. The code management method according to claim 13, wherein in the search request information designation screen display process, an icon associated with a predetermined in-store code and a predetermined best-before date is displayed in the search request information designation area so as to be designated. The code management method according to claim 14 , wherein the icon is formed by an image capable of specifying the corresponding product. Manufacturer management information acquisition processing for acquiring manufacturer management information including a product specification identification code given to the product by the manufacturer that produced or manufactured the product;
The code management method according to any one of claims 12 to 15 , further comprising: a manufacturer management information registration process for registering the manufacturer management information acquired in the manufacturer management information acquisition process in the code management DB. Retail store information acquisition processing for acquiring retail store information including an in-store code and a product specification identification code of a product to which the in-store code is assigned from each retail chain server managed in each retail chain;
The in-store code acquired in the retail store information acquisition process is registered in association with the product specification identification code acquired in the retail store information acquisition process among the product specification identification codes registered in the code management DB. The code management method according to claim 16 , further comprising: an in-store code registration process. The product information indicated by the product chart includes the product name of the product and the amount of the material used,
In the product information output process, as the product information indicated by the product chart, the product name of the product and the material used for the product are output,
A volume search request acceptance process for accepting a quantity search request;
A quantity search process for searching for a quantity of the used material in response to receiving a quantity search request in the quantity search request reception process;
The code management method according to any one of claims 12 to 17 , further comprising: a quantity information output process that outputs quantity information including the quantity of the used material searched in the quantity search process. The code management method according to claim 18, wherein in the display order determination process, the display order is determined so that the used materials are displayed from the one with the larger amount of the used materials searched in the quantity search process. In the display order determination processing according to the priority order is predetermined, the higher priority, claims 12 to determine the display order so that the material used is displayed according to any of claims 18 Code management method.

Images