JP4855326B2 - Code management system and code management method - Google Patents

Description

  In the present invention, a product specification identification code for identifying a product when the product is produced or manufactured is assigned, and a code management server that performs code management of the product in each retail chain, and each retail chain The present invention relates to a code management system and a code management method including a retail chain server that separately manages various types of information about products.

  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 used in each chain store and the product master number are associated with each other in a one-to-one relationship, it is logically possible to accurately obtain information on the corresponding product from the in-store code in each chain store. It becomes.

  However, in practice, the information included in the product chart indicated by the product master is not managed by the chain store server, but is collectively managed by a separately installed product master server. For this reason, for example, when searching for information contained in the product chart of a product in a chain store, even if the product master number is used each time a search request is made, the information is accessed by accessing the product master server each time. There is a problem that it is impossible to search for information contained in the product chart of the product in a short time.

  SUMMARY OF THE INVENTION An object of the present invention is to solve the above-described problems, and to search and accurately check information included in a product chart in a short time.

  The code management system 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 management server that performs code management of the product in each retail chain; A code management system including a retail chain server that separately manages various types of information related to the product in a retail chain, wherein the code management server is a retail chain of a product supply destination indicated by the product specification identification code An in-store code issuing means for issuing an in-store code for identifying the product, an in-store code issued by the in-store code issuing means, a product name of the product, a product specification identification code of the product, A code management DB that stores code management information including a factory-specific symbol that indicates the factory of the product , Referring to the product record acquisition means for acquiring the product chart of the product to which the product specification identification code is assigned, and the code management information of the code management DB, the in-store code and the factory unique symbol are An in-store code distribution unit that distributes the product information indicated by the product chart acquired by the chart acquisition unit to each retail chain of the product supply destination, and the plurality of retail chain servers are distributed by the in-store code distribution unit A retail chain product master DB that stores a retail chain product master in which an in-store code and a factory-specific symbol, and product information indicated by the product chart are associated with the product category of the product, and a search target product Search request information including the assigned in-store code and factory-specific symbol The retail chain product includes the search request information receiving means to be received, and the product information indicated by the product chart of the product associated with the in-store code and the factory unique symbol included in the search request information received by the search request information receiving means. The product information output means for referring to the retail chain product master stored in the master DB and the in-store code included in the search request information are included in the retail chain product master. Is the same as the product to be searched with respect to the code management server when the factory unique symbol included in the retail chain product master is different from the factory unique symbol associated with the in-store code in the retail chain product master A factory-specific symbol that contains all of the factory-specific symbols for products in the product category List creation request means for requesting creation of a list, and the product information output means further includes list output means for outputting the factory-specific symbol list acquired from the code management server, and the list output means The product information indicated by the product chart of the product selected and designated based on the factory unique symbol attached to the product to be searched among the products for which the factory unique symbol is output is further output.

  By configuring as described above, the product information in the product chart can be searched in a short time using the in-store code on the local retail chain server without accessing the product master server, and the in-store code is supported. For products that are attached but are different from those that have factory-specific symbols associated in advance, a list showing the list of factory-specific symbols is presented to the same product category that includes the search target product. It becomes possible to search the product information of the product to which it belongs in a short time, and to confirm it accurately.

  The list output means may be configured to output a warning to notify a search error together with the output of the factory specific symbol list.

  Further, the list output means may be configured to output the factory unique symbol list including display of the same product category name as the search target product.

  Further, the list output means may be configured to display the factory-specific symbol list including a code selection / designation area that displays the factory-specific symbols in a selectable manner.

  The search request information accepting means of the retail chain server accepts search request information further including date information related to a date of a product to be searched, and the product information output means receives the attribute information of the product based on the date information. You may be set as the structure output with merchandise information.

  The retail chain server includes a search request information specifying screen display means for displaying a search request information specifying screen including a search request information specifying area in which the in-store code, the factory unique symbol, and the date information can be specified. May be.

  The code management server includes a manufacturer management information acquisition unit for acquiring manufacturer management information including a product specification identification code given to the product by a manufacturer that has produced or manufactured the product and the manufacturing site unique symbol, and the manufacturer management information acquisition It may be configured to include a manufacturer management DB for storing manufacturer management information acquired by the means.

  The merchandise information indicated by the merchandise chart includes the merchandise name of the merchandise, the material used for the merchandise, the material used in the production or manufacture of the merchandise, the quantity of the material used, and the quantity of the material. The product information output means of the retail chain server includes, as product information indicated by the product chart, the product name of the product, the material used for the product, and the material used in the production or manufacture of the product And a quantity search request accepting means for accepting a quantity search request, and in response to the quantity search request accepting means accepting a quantity search request, the quantity of the material used and the quantity of the material It may be configured to include a quantity search means for searching, and a quantity information output means for outputting quantity information including the quantity of the used material searched by the quantity search means and the quantity of the material.

  In addition, the code management method of the present invention is provided with a product specification identification code for identifying the product when the product is produced or manufactured, and a code management server that performs code management of the product in each retail chain; A code management method executed by a retail chain server that separately manages various information related to the product in each retail chain, wherein the code management server is a supply destination of the product indicated by the product specification identification code In-store code issuing process for issuing an in-store code for identifying the product in the retail chain, the in-store code issued in the in-store code issuing process, the product name of the product, and the product specification identification code of the product Code management information including a manufacturing site unique symbol indicating the manufacturing site of the product and stored in the code management DB. Refer to the code management information stored in the code management DB in the code management information storage process, the product chart acquisition process for acquiring the product chart of the product to which the product specification identification code is assigned, and the code management information storage process And executing the in-store code distribution process for distributing the in-store code and the factory-specific symbol to each retail chain of the product supply destination together with the product information indicated by the product chart acquired in the product chart acquisition process. In addition, the plurality of retail chain servers include an in-store code and a factory-specific symbol distributed in the in-store code distribution process, and product information indicated by the product chart in association with a product category of the product. Retail chain product master storage processing for storing existing retail chain product master in the retail chain product master DB A search request information receiving process for receiving search request information including an in-store code and a factory-specific symbol assigned to the search target product, and an instrument included in the search request information received in the search request information receiving process. The merchandise information indicated by the merchandise chart of the merchandise associated with the accord and the factory-specific symbol is output with reference to the retail chain merchandise master stored in the retail chain merchandise master DB in the retail chain merchandise master storage processing. The product information output process and the in-store code included in the search request information are included in the retail chain product master, and the factory-specific symbol included in the search request information is the in-store code in the retail chain product master. If it is different from the factory-specific symbol associated with Execute list creation request processing to request the production management server to create a factory-specific symbol list that includes all of the factory-specific symbols for products included in the same product category as the search target product. The product information output process further executes a list output process for outputting the factory unique symbol list acquired from the code management server, and among the products for which the factory unique symbol is output in the list output process, Product information indicated by the product chart of the product selected and designated based on the factory-specific symbol attached to the product to be searched is further output.

  According to the present invention, it is possible to search and accurately check information included in a product chart in a short time.

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: any positive integer), and producer servers 51 to 5N (N : Any positive integer). The code management server 10, the merchandise master server 20, the retail store servers 31 to 3N, and the producer servers 51 to 5N are each connected to a communication network 40 such as the Internet.

  The code management server 10, the merchandise master server 20, the retail store servers 31 to 3N, and the producer servers 51 to 5N 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 a product specification identification code (manufacturing code) given to the product when the product is produced or manufactured, and the product A factory-specific symbol (manufacturer code) indicating a factory (manufacturing factory, etc.) and an in-store code used in each retail store are issued and managed.

  The code management server 10 includes a code management DB (database) 11 in which code management information is stored, and a maker production management DB 12 in which maker production management information is stored. The code management information is information for managing the relationship between the manufacturing code and the in-store code used in each retail store, and includes, for example, the above-mentioned manufacturing site specific symbol and the product name of the product indicated by the manufacturing code. Is done.

  The manufacturer production management information includes a manufacturing code given to the product by the manufacturer (for example, the producer servers 51 to 5N) when the product is produced or manufactured, a product name of the product indicated by the manufacturing code, It includes the name of the manufacturer that produced or manufactured the product, and the unique symbol of the factory. 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. . In this case, the manufacturer production management information may be transmitted to the code management server 10 after being periodically updated by the producer servers 51 to 5N, for example.

  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 the merchandise and a manufacturing code assigned to the merchandise (see FIG. 7). 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 a retail chain manager who manages each of the retail chains A to N, for example, and stores the POS information used in each of the retail chains A to N. With ~ 3Na. The retail store servers 31 to 3N are installed, for example, in retail chains A to N, respectively.

  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 price pay station, for example, attached to a product) Reads POS system barcode (an example of POS code: hereinafter referred to as “POS barcode”) and prints purchase details on the receipt using the product name and product price specified based on the POS barcode. And a computer that performs POS data intra processing before the processing of the retail store servers 31 to 3N is connected.

  Each of the producer servers 51 to 5N is managed by a production manager in each manufacturer, for example, and transmits the above-described manufacturer production management information to the code management server 10 via the communication network 40. Although not shown, the producer servers 51 to 5N are connected to a manufacturer terminal (for example, a computer) included in each manufacturer's manufacturing factory, production line, or a producer associated with the manufacturer.

  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, for example, a product name, an in-store 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 issued by the code management server 10 and then distributed to the retail store server 31 and is currently used in association with a predetermined product in the POS system in the corresponding retail chain A. The in-store code may be issued by the code management server 10 or may be independently issued by each retail store server 31 to 3N and collected and managed by the code management server 10.

  In this POS information, as shown in FIG. 2, for example, as the product name of the product, the product name and / or supplier name (manufacturer name) such as canned A, canned B, canned C, seasoning B, beef A, etc. Is set. In addition, for example, the price of the sales unit for each product number and weight is set as 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 issued by the code management server 10 are set in the POS information so that the POS system can be identified when the product specifications are different even for the same product, depending on the POS system employed in each store. ing. Note that the same in-store code may be issued and set for the same product.

  3-5 is explanatory drawing which shows the example of the retail chain goods master stored in retail chain goods master DB31a-3Na with which each retail store server 31-3N installed in the retail chains AC is equipped. The retail chain C is not shown in FIG. As shown in FIGS. 3 to 5, the retail chain product master, for example, combines the product name, in-store code, icon data indicating the corresponding product, and when the in-store code is distributed by the code management server 10. It includes product medical record data including at least a part of data of the delivered product medical record, a manufacturer code that is an example of a factory-specific symbol, a product arrival date, a product expiration date, and product attribute information.

  The merchandise medical record data only needs to include at least a part of the data indicating the merchandise corresponding to the in-store code in the merchandise chart shown in FIG. ~ N indicates the date of arrival of the product, and the attribute information is, for example, information indicating the number of products received to each retail chain A to N and the destination. The icon data is image data representing, for example, a photograph of the corresponding product, and the expiration date of the product indicates the expiration date of the expiration date of the corresponding product. This expiration date may be set not in units of days but in units of months, weeks, hours, minutes, and seconds.

  The manufacturer code is a code that can specify the manufacturing site of the product. For products manufactured or manufactured at the same manufacturing site, the same manufacturer code is assigned even if the product category or product type is different. The In this example, for example, as shown in FIG. 3, the same manufacturer code “456000111” is assigned to the product names “Canned A” and “Canned B”, and “Canned C” and “Canned D” , “Canned A” and “canned B” and “canned C” and “canned D” are products manufactured at the same factory, for example, “canned A”. "And" Canned C "are products manufactured at different factories.

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

  FIG. 6 is an explanatory diagram illustrating an example of code management information stored in the code management DB 11. As shown in FIG. 6, the code management information includes an in-store code for identifying a product category, a product name, a manufacturing code, a manufacturer code, and a product indicated by the manufacturing code for each retail chain A to N. And are associated information. Therefore, if the product name and the production code are the same product, each retail chain A to N is managed by the same in-store code, or if the product name is the same but the production code is different, Each retail chain A to N is managed by a different in-store code.

  The product category of the product represents a category for classifying the product. For example, “canned A” to “canned D” are classified as “canned”, and “seasoning B” is classified as “seasoning”. In addition, the product category may be classified, for example, according to the type of product (such as food that is stored for a long period of time or food that requires heating).

  FIG. 7 is an explanatory diagram showing an example of the contents of the product chart stored in the product master DB 21. As shown in FIG. 7, the product chart includes, for example, the product name of the corresponding product, a manufacturing code uniquely assigned to the product, a product chart code uniquely assigned to the product, The used material used in the product is associated with the used material amount information indicating the amount of each used material. In addition, material (fertilizer, agricultural chemicals, feed, veterinary medicine, etc.) used when the corresponding product is produced or manufactured and its usage (for example, daily usage, etc.) are appropriately determined by the material. May be included in the product chart.

Next, the operation of the code management system 100 of this example will be described.
FIG. 8 is a flowchart illustrating an example of code management information registration / distribution processing executed by the code management server 10 in the code management system 100 of the present example. The code management information registration / distribution process is performed when the code management server 10 distributes a new in-store code to each of the retail chains A to N, for example, when a new product is handled or the product specification is changed. In addition, an instruction is given by the operator of the code management server 10, or it is executed periodically (for example, once a day in the early morning or late at night).

  In the code management information registration / distribution process, first, the code management server 10 newly creates (manufactured from the previous acquisition) of the manufacturer production management information stored in the manufacturer production management DB. Management information is read (step S101).

  Next, the code management server 10 newly registers the product name, the manufacturing code, and the manufacturer 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, respectively. Search for the in-store code included in the management information and identify the product for each retail chain A to N in the registered manufacturing code. If not yet registered in the code management information, a new in-store code Issued in association with each other (step S102), the in-store codes of the retail chains A to N corresponding to the newly registered manufacturing code are registered in the code management information (step S103).

  Next, the code management server 10 selects at least a product chart associated with the manufacturing code in advance based on the newly registered manufacturing code from the product master stored in the product master DB 21 of the product master server 20. Product chart data including a part of the data is acquired (step S104). In this step S104, product chart data including all data of the product chart associated with the corresponding manufacturing code may be acquired.

  The code management server 10 acquires the in-store code in the retail store servers 31 to 3N of the retail chains A to N that issued the in-store code in step S102 and the manufacturer code acquired in step S101 and the step S104. Delivered together with the merchandise chart (step S105).

  In this example, for example, when there is a change in the material used for the corresponding product and the product specification is changed, a manufacturing code not included in the manufacturer production management information is newly assigned to the manufacturer production management. Registered in DB12. When a new manufacturing code is assigned, 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.

  Furthermore, a new in-store code that can be identified for each retail chain A to N and is different from each other is issued and stored in the code management DB 11. Then, for example, when a new in-store code is issued, a manufacturer code and new product chart data are distributed to each retail store server 31 to 3N of the product supply destination together with this in-store code, and the retail chain product master DB 31a to 3Na A new in-store code is registered in the POS information at the same time, and a new in-store code, a manufacturer code, and product chart data are associated and registered in the retail chain product master.

  In this example, in-store codes in the retail chains A to N and in the retail store servers 31 to 3N are the same for the same product name (for example, products such as XX croquette, XX canned food, etc.) Differently, it is assumed that the product can be identified. Note that the same in-store code may be set for the same product name in one retail chain or retail store server.

  FIG. 9 is a flowchart illustrating an example of a product search process executed by each of the retail store servers 31 to 3N in the code management system 100 of the present example. Here, among the retail store servers 31 to 3N, the retail store server 31 is a product to which an in-store code is assigned, and the in-store code, manufacturer code, or date information (for example, designated by the operator at the retail chain terminal) An example will be described in which product information such as materials used is searched based on the arrival date and the expiration date.

  First, the operator of the retail store server 31 displays the search condition designation area 101 on the search condition designation screen as shown in FIG. 10 displayed on the display screen of the display device provided in the retail chain terminal or the display device provided in the retail chain server. For example, the search condition is specified by inputting an in-store code assigned to a product to be searched, a manufacturer code attached to the product, and date information regarding the product. When the search condition is specified, for example, the product name of the product specified as the search target and the manufacturing code of the product are displayed in the search target confirmation area 102 of the search condition specifying screen.

  That is, when the retail store server 31 receives the specification of the search condition from the operator, the retail store server 31 searches for the product name and the manufacturing code using the retail chain product master (and POS information), and displays it in the search target confirmation area 102. I do. 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 of the retail chain terminal. When the search execution button 103 is pressed, the retail store server 31 searches the product record data of the retail chain product master according to the designated in-store code, manufacturer code, and date information.

  For example, as shown in FIG. 11, 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, the retail store product master (and POS information) is used to store the in-store code, manufacturer code, date information of the product associated with the selected icon, A product name, a manufacturing code, and the like are searched for and displayed in the search target confirmation area 102.

  In addition, as the date information associated with the corresponding product, for example, when there is no input of date information in the search condition designation area 101, the retail store server 31 uses the latest expiration date as the search condition. The process of automatically determining and displaying in the search target confirmation area 102 is performed. When the search execution button 103 is pressed, the retail store server 31 selects the retail chain product master according to the designated in-store code, manufacturer code, and date information (here, the expiration date of the most recent date). Search product chart data for.

  In FIG. 10, the in-store code (for example, A0009122) (and date information (for example, A0009122) of the product “canned D” handled in the retail chain A of the retail store server 31 is displayed in the search condition specifying area 101 of the search condition specifying screen. (June 05, 2007)) is input, the product name “canned D” and the production code “000413” of the product designated as the search target are displayed in the search target confirmation area 102. . In FIG. 11, since an icon that can be designated is displayed in the search condition designation area 101 of the search condition designation screen, the product name and the manufacturing code are similarly displayed in the search target confirmation area 102.

  First, in the product search process, the retail store server 31 specifies an in-store code (for example, A0009122) and a manufacturer code (for example, 456000111) (and date information (and so on) according to designation from an operator who operates an input device such as a mouse of a retail chain terminal. Search request information including, for example, June 10, 2007) is received (step S201). In step S201, it is assumed that an in-store code and a manufacturer code are accepted as search request information.

  Next, the retail store server 31 refers to the retail chain product master in the retail chain product master DB 31a and determines whether there is a product associated with the in-store code and the manufacturer code received in step S201. (Step S202). If it is determined that there is a product associated with the received in-store code (Y in step S202), the product chart data of the retail chain product master is searched based on the product's manufacturing code (step S206), and this is the case. A product chart is obtained from the product chart data (step S207).

  On the other hand, referring to the retail chain product master of the retail chain product master DB 31a, if it is determined that there is no product associated with the received in-store code but associated with the manufacturer code (N in step S202). ) The retail store server 31 displays a display area for displaying an error message indicating that there is no product corresponding to the received in-store code and a manufacturer code of a product included in the same product category as the product in a selectable manner. The search result screen information for displaying the search result screen provided with the code selection designation area for displaying the manufacturer code list acquired from the code management server 10 is generated, and the search result screen based on the generated search result screen information Is displayed on the display screen of the retail chain terminal (step S203). As described above, the retail store server 31 is an in-store code in which the in-store code assigned to the search target product is included in the retail chain product master. If it is determined that the product has a manufacturer code different from the manufacturer code (N in step S202), the received in-store code is presented and a request to create a manufacturer code list is sent to the code management server 10. Do. In response to the creation request, the code management server 10 creates a manufacturer code list for displaying a list of manufacturer codes of products included in the same product category as the product corresponding to the presented in-store code in a selectable manner. It transmits to the retail store server 31.

  The retail store server 31 may display a search result screen based on the generated search result screen information on the display screen of the display device provided in itself, in addition to the display device provided in the retail chain terminal. For example, as shown in FIG. 12, the search result screen is displayed in an error display area 104 for displaying a search error, a manufacturer code list display area 105 for displaying a manufacturer code list, and a manufacturer code list display area 105. Among the manufacturer codes, a determination button 106 for instructing a product search for a product of the manufacturer code selected based on the manufacturer code assigned to the search target product, and an end button for instructing the end of the product search 107 is provided. The operator determines which one of the manufacturer codes included in the manufacturer code list is to be selected based on the manufacturer code attached to the actual product brought as a search target. For example, the same manufacturer code as the manufacturer code attached to the product, a part of the same manufacturer code, or the like is selected.

  Then, the retail store server 31 accepts the specification of the manufacturer code when the manufacturer code listed in the manufacturer code list display area 105 on the search result screen is selected and the determination button 106 is pressed (step S204). With reference to the retail chain product master, the product chart data of the product with the production code in the same product category associated with the specified manufacturer code is retrieved or acquired (step S205), and the product is obtained from the corresponding product chart data. A medical record is acquired (step S207). In step S205, when the retail store server 31 searches the retail chain product master, the product chart data of the product with the production code in the same product category associated with the designated manufacturer code is the retail chain product. If it does not exist in the master, an acquisition request for the product chart data of the product with the production code associated with the designated manufacturer code is transmitted to the code management server 10. In response to this acquisition request, the code management server 10 acquires the corresponding product chart data from the product master server 20 and transmits it to the retail store server 31. In this way, if the product chart data of the product of the production code in the same product category associated with the designated manufacturer code does not exist in the retail chain product master, the corresponding product chart from the code management server 10. Get the data.

  In the search result screen in FIG. 12, in the error display area 104, a display sentence indicating a search error “Products corresponding to the specified search target in-store code and search target manufacturer code are not normally handled in this chain. “Please select the manufacturer code attached to the search target product from the following manufacturer code list acquired from the code management server 10.” is displayed, and the in-store code “ A list of manufacturer codes of products in the same product category as the product “canned D” indicated by “A0009122” is displayed, and an example in which the same manufacturer code (for example, 456000111) is selected is shown. Yes.

  The retail store server 31 has a search result screen provided with a display area for product search result information including the product name, the material used, and the material used in the production (or manufacture) of the product indicated by the acquired product chart. The search result screen information for displaying the search results screen information is generated, for example, the display order of the used materials and materials is determined as necessary, and the search result screen based on the generated search result screen information is displayed on the retail chain terminal display screen. Displayed above (step S208).

  The display order is determined according to, for example, a predetermined determination rule. Here, the display order is displayed in descending order of priority determined for each product. This priority order is registered in, for example, a display order determination table and stored in another DB provided in the retail store server 31.

  The retail store server 31 may display a search result screen based on the generated search result screen information on the display screen of the display device provided in itself, in addition to the display device provided in the retail chain terminal. As shown in FIG. 13, for example, the search result screen includes a search condition display area 201 for displaying search conditions, a search result display area 202 for displaying search results, and a quantity for instructing a search for the amount of materials and materials used. A search instruction button 203 is provided. In this example, used materials and materials are displayed in the search result display area 202 in a display order designated in advance.

  The search result screen in FIG. 13 shows the expiration date (determined by) determined by the in-store code “A0009122” and the manufacturer code “456000111” and date information as the product search conditions by the manufacturer code specified through the above steps S204 to S205. An example of a search result when “June 15, 2007” is selected is shown. As shown in FIG. 13, as a search result, the product indicated by the in-store code “A0009122” is the product name “Canned D” and the date of determination “June 15” is the expiration date. The code “000413” and the product chart code “KA00062” are used, and are shown to have been manufactured at the manufacturing plant “XX factory”.

  In addition, the materials used for the “canned D” are “taraba rice cake”, “seasoning α” and “seasoning β”, and the materials used when producing (or manufacturing) the “canned D” It is shown that they were “preservative A”, “preservative B”, “dye stabilizer A” and the like. In this example, based on the in-store code and maker code (and date information) issued by the code management server 10 and distributed to each retail chain A to N, for example, a manufacturing code (commodity chart code) for each product having the same product name. ) Is updated or changed, or even if the same in-store code is assigned but the manufacturer code is different, the product information (materials used, materials, etc.) of the product is stored locally. If there is no relevant information in the local area after the search, the search is performed in conjunction with the code management server 10 and the search can be performed without accessing the product master server 20. This makes it possible to search for product information quickly and accurately in a short time.

  Moreover, in this example, even if the merchandise to which the in-store code issued by the code management server 10 and distributed to each retail chain A to N is given, the manufacturer code is different due to, for example, an incorrect supply destination. For the product as well, it is considered that the product is the most appropriate one selected arbitrarily based on the product category of the product and all the manufacturer codes included in the code management information of the code management server 10 included in the product category. Product information (used materials, materials, etc.) of products (products considered to be most relevant) can be searched without accessing the product master server 20, and similarly, high-speed product information can be searched in a short time. It becomes possible.

  Furthermore, the retail store server 31 determines whether or not the quantity search execution button 203 has been pressed by the operator on the search result screen of FIG. 13 (step S209), and determines that it has been pressed (Y in step S209). , Extract the quantity information indicating the amount of materials used and materials of the corresponding product from the product chart, generate search result screen information for redisplaying the search result screen with the display area of the extracted quantity information, For example, after determining the materials to be used and the display order of the materials as necessary, the search result screen based on the generated search result screen information is re-displayed on the display screen of the retail chain terminal (step S210) to search for products. It is determined whether or not to end the process (step S211). When it is determined that the process is to be ended (Y in step S211), this flowchart is used. To terminate the product search process of the communication.

  Even when it is determined in step S209 that the quantity search execution button 203 has not been pressed (N in step S209), it is determined whether or not to end the product search process (step S211). Similarly (Y in step S211), the product search process is terminated. If it is determined that the process is not to be ended (N in step S211), for example, the process proceeds to step S201 and the subsequent processes are repeated.

  The display order is determined according to a predetermined determination rule, for example. 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 may redisplay the search result screen based on the generated search result screen information on the display screen of the display device provided in the retail chain server 31 in addition to the display device provided in the retail chain terminal. As shown in FIG. 14, for example, the search result screen is provided with a search condition display area 201 for displaying search conditions and a search result display area 202 for displaying search results. Then, as shown in FIG. 14, in the search result display area 202, the used material and its amount, and the material and its amount are displayed.

  In this example, used materials and materials are displayed in the search result display area 202 in a display order designated in advance, for example. Here, as shown in FIG. 14, the data are displayed in order from the one with the largest amount. Depending on the display order determination rule, for example, as shown in FIG. 15, “condiment β” having a higher priority may be displayed in order. The priority order may be determined by the system administrator, for example, by raising the price of 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 perform display such as displaying from the higher priority order set in advance, and displaying the same priority order from the larger amount.

  As shown in FIG. 14, as a search result, in addition to the information shown in FIG. 13, the amount of each material such as “taraba rice cake” used in the product “canned D” and the product “canned D” The amount of each material used in the production (or manufacture) of the is shown. Based on the search result, it is possible to confirm the material and material used for the product name “canned D” having the same product name, product category, in-store code, and manufacturer code as the search target, and the amount of the material and material.

  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. Although not shown, based on the date information entered on the search condition specification screen, the product attribute information (information such as the number of products received and the destination) included in the retail chain product master is displayed on the search result screen. You may make it display by searching.

  As described above, in the above-described embodiment, the code management server 10 of the code management system 100 uses the product in each retail chain A to N of the product supply destination indicated by the product specification identification code (manufacturing code). Code management information including the issued in-store code, the product name of this product, the product specification identification code of this product, and the manufacturer code indicating the manufacturing site of this product. A product chart of a product stored in the code management DB 11 and provided with a product specification identification code is acquired, and the in-store code and the manufacturer code are indicated by the acquired product chart by referring to the code management information of the code management DB 11 The information is distributed to the retail chains A to N of the goods supply destination together with the information, and the retail store servers 31 to 3 N are Stored in the retail chain product master DBs 31a to 3Na is a retail chain product master in which the store code, the manufacturer code, and the product information indicated by the product chart are associated with the product category of the product, and is assigned to the search target product. Search request information including the in-store code and manufacturer code that is stored, and refer to the retail chain product master for the product information indicated by the product chart of the product associated with the in-store code and manufacturer code included in the received search request information The in-store code included in the search request information is included in the retail chain product master, and the manufacturer code included in the search request information is associated with the in-store code in the retail chain product master. Different from the manufacturer code If it is, the code management server 10 is requested to create a maker code list including all of the maker codes for the products included in the same product category as the product to be searched, and obtained from the code management server 10 Output the manufacturer code list, and further output the product information indicated by the product chart of the product selected and specified based on the manufacturer code list attached to the search target product among the products for which the manufacturer code list is output Since it is configured, the product information of the product chart can be searched in a short time using the in-store code and the manufacturer code in the code management server 10 or the local retail store servers 31 to 3N without accessing the product master server 20 And the in-store code is associated with the manufacturer code For products that are different from the ones associated in advance, by displaying a list showing a list of manufacturer codes, product information of products belonging to the same product category including the search target product can be searched in a short time. And the searcher can be confirmed accurately. In addition, since the code management server 10 also distributes the product information indicated by the product chart when distributing the in-store code, the processing load of the code management server 10 does not occur during the search without causing high-load processing in the code management server 10 Can be reduced.

  Note that the product specification identification code (manufacturing code) has different specifications such as product name, raw materials used, secondary raw materials, additives, allergens, manufacturing factories, target sales areas (for example, for the Kansai area), and packaging designs. This is an identification code uniquely assigned to a product. 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. The manufacturer code is an example of a factory-specific symbol.

  In the above-described embodiment, the retail store servers 31 to 3N are configured to output a warning to notify a search error together with the output of the manufacturer code (see FIG. 12). Even when a search for a product that does not correspond to an in-store code and a manufacturer code is performed on the 3N side, various situations such as the next option related to the search can be easily grasped.

  Further, in the above-described embodiment, the retail store servers 31 to 3N output a manufacturer code list including the display of the same product category name as the product to be searched together with the manufacturer code (see FIG. 12). Even if the retail store servers 31 to 3N search for a product for which the in-store code and the manufacturer code are not associated, it is possible to easily grasp various situations such as the next option related to the search. Can do.

  In the above-described embodiment, the retail store servers 31 to 3N display a manufacturer code list including a manufacturer code list display area 105 that displays a list of manufacturer codes that can be selected and specified (see FIG. 12). Therefore, it is possible to easily select and specify the manufacturer code based on the manufacturer code attached to the search target product.

  In the above-described embodiment, the retail store servers 31 to 3N accept search request information further including date information related to the date of the product to be searched, and product attribute information based on this date information (number of products received) Since the information is output together with the product information, the retail store servers 31 to 3N can search for various information related to the product in more detail.

  In the embodiment described above, the search request information designation screen includes a search request information designation area (see 101 in FIG. 10) in which the retail store servers 31 to 3N can designate an in-store code, a manufacturer code, and date information. Since the retail store servers 31 to 3N can specify the search request information easily.

  In the above-described embodiment, the code management server 10 acquires the manufacturer production management information including the product specification identification code and the manufacturer code assigned to the product by the manufacturer that manufactured or manufactured the product. Since the production management information is stored in the manufacturer production management DB 12, when the product specification identification code is newly assigned, the new product specification identification code, the manufacturer code, the product name, etc. are stored on the code management server 10 side. Can be managed collectively.

  In one 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, The retail store servers 31 to 3N search for the product name of the product, the material used for the product, and the material used during the production or manufacture of the product as product information indicated by the product chart. After output as a result, in response to accepting a quantity search request, search the quantity of material used and the quantity of material, and output quantity information including the quantity of material used and the quantity of material searched Since it is configured to be able to do this, it is possible to easily search and present the material of the product and the amount of the material within the local area.

  In the above-described embodiment, the in-store code is used. However, instead of the in-store code issued and managed by the code management server 10 or together with the in-store code, each product indicated by the product specification identification code is displayed. You may make it utilize the figure code etc. which can be identified in the retail chains A-N, respectively. That is, instead of the in-store code, or together with the in-store code, a privately-used graphic code that can identify a product in each retail chain A to N may be issued and managed.

  According to the present invention, it is useful for searching and accurately confirming information contained in a product chart of each product using an in-store code and a manufacturer code in a short time.

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 a retail chain goods master. 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 and delivery 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 a search result screen.

Explanation of symbols

10 Code management server 11 Code management DB
12 Manufacturer production management DB
20 Product Master Server 21 Product Master DB
31-3N Retail store server 31a-3Na Retail chain product master DB
40 Communication network 51-5N Producer server 100 Code management system

Claims (16)

A product specification identification code for identifying the product when the product is produced or manufactured is assigned, and a code management server for managing the code of the product in each retail chain; and A code management system including a retail chain server that manages various information about products,
The code management server
An in-store code issuing means for issuing an in-store code for identifying the product in each retail chain of the supply destination of the product indicated by the product specification identification code;
A code for storing code management information including an in-store code issued by the in-store code issuing means, a product name of the product, a product specification identification code of the product, and a manufacturing site unique symbol indicating the manufacturing site of the product Management DB,
A product chart acquisition means for acquiring a product chart of a product to which the product specification identification code is attached;
Referring to the code management information in the code management DB, distribute the in-store code and the manufacturing site unique symbol to each retail chain of the product supply destination together with the product information indicated by the product chart acquired by the product chart acquisition means Including in-store code distribution means
The plurality of retail chain servers are:
A retail chain product that stores a retail chain product master in which the in-store code and the factory-specific symbol distributed by the in-store code distribution unit and the product information indicated by the product chart are associated with the product category of the product. Master DB,
Search request information accepting means for accepting search request information including an in-store code and a factory-specific symbol assigned to a search target product;
The retail information stored in the retail chain product master DB is stored in the retail chain product master DB with the product information indicated by the product record of the product associated with the in-store code and the factory specific symbol included in the search request information received by the search request information receiving unit Product information output means for outputting by referring to the chain product master,
The in-store code included in the search request information is included in the retail chain product master, and the factory-specific symbol included in the search request information is associated with the in-store code in the retail chain product master. If it is different from the factory unique symbol, the code management server has a factory unique symbol list including all of the factory unique symbols for products included in the same product category as the product to be searched. Each including a list creation request means for requesting creation,
The product information output means includes
A list output means for outputting the factory-specific symbol list acquired from the code management server;
Further output the product information indicated by the product chart of the product selected and designated based on the manufacturing site unique symbol attached to the product to be searched out of the products for which the manufacturing site specific symbol is output by the list output means. A code management system characterized by The code management system according to claim 1, wherein the list output means outputs a warning to notify a search error together with the output of the factory specific symbol list. The code management system according to claim 1, wherein the list output unit outputs the factory-specific symbol list including display of the same product category name as the search target product. The code management according to any one of claims 1 to 3, wherein the list output means displays the factory-specific symbol list including a code selection / designation area in which the factory-specific symbols can be selected and displayed as a list. system. The search request information accepting means of the retail chain server accepts search request information further including date information related to a date of a product to be searched,
The code management system according to any one of claims 1 to 4, wherein the product information output unit outputs attribute information of the product based on the date information together with the product information. The retail chain server is
The code management system according to claim 5, further comprising a search request information designation screen display means for displaying a search request information designation screen including a search request information designation area capable of designating the in-store code, the factory unique symbol, and the date information. . The code management server
Manufacturer management information acquisition means for acquiring manufacturer management information including a product specification identification code and a factory specific symbol given to the product by the manufacturer that produced or manufactured the product;
The code management system according to any one of claims 1 to 6, further comprising a manufacturer management DB for storing manufacturer management information acquired by the manufacturer management information acquisition means. The merchandise information indicated by the merchandise chart includes the merchandise name of the merchandise, the material used for the merchandise, the material used in the production or manufacture of the merchandise, the quantity of the material used, and the quantity of the material. Including
The merchandise information output means of the retail chain server outputs the merchandise name of the merchandise, the material used for the merchandise, and the material used in the production or manufacture of the merchandise as merchandise information indicated by the merchandise chart. And
A quantity search request accepting means for accepting a quantity search request;
A quantity search means for searching for the quantity of the used material and the quantity of the material in response to the quantity search request accepting means accepting the quantity search request;
The code management system according to any one of claims 1 to 7, further comprising: quantity information output means for outputting quantity information including the quantity of the used material searched by the quantity search means and the quantity of the material. . A product specification identification code for identifying the product when the product is produced or manufactured is assigned, and a code management server for managing the code of the product in each retail chain; and A code management method executed by a retail chain server that manages various information related to products,
The code management server is
An in-store code issuing process for issuing an in-store code for identifying the product in each retail chain of the product supply destination indicated by the product specification identification code;
Code management of code management information including the in-store code issued in the in-store code issuing process, the product name of the product, the product specification identification code of the product, and the manufacturing site unique symbol indicating the manufacturing site of the product Code management information storage processing stored in the DB;
A product chart acquisition process for acquiring a product chart of a product to which the product specification identification code is attached;
Product information indicated by the product chart acquired in the product chart acquisition process by referring to the code management information stored in the code management DB in the code management information storage process and indicating the in-store code and the manufacturing site specific symbol And an in-store code distribution process for distributing to each retail chain to which the product is supplied,
The plurality of retail chain servers are
A retail chain product master that includes the in-store code and the factory-specific symbol distributed in the in-store code distribution process and the product information indicated by the product chart in association with the product category of the product is defined as a retail chain product master. Retail chain product master storage processing stored in DB,
A search request information receiving process for receiving search request information including an in-store code and a factory-specific symbol assigned to a search target product;
The merchandise information indicated by the merchandise chart of the merchandise associated with the in-store code and the factory unique symbol included in the search request information received in the search request information receiving process is retailed in the retail chain merchandise master storage process. Product information output processing for outputting with reference to the retail chain product master stored in the chain product master DB,
The in-store code included in the search request information is included in the retail chain product master, and the factory-specific symbol included in the search request information is associated with the in-store code in the retail chain product master. If it is different from the factory unique symbol, the code management server has a factory unique symbol list including all of the factory unique symbols for products included in the same product category as the product to be searched. Execute list creation request processing to request creation,
In the product information output process,
Further executing a list output process for outputting the factory-specific symbol list acquired from the code management server;
The product information indicated by the product chart of the product selected and designated based on the factory unique symbol attached to the product to be searched out of the products for which the factory unique symbol is output in the list output process is further output. A code management method characterized by the above. The code management method according to claim 9, wherein in the list output process, a warning output for notifying a search error is performed together with the output of the factory specific symbol list. The code management method according to claim 9 or 10, wherein in the list output process, the factory-specific symbol list including display of the same product category name as the search target product is output. The code management according to any one of claims 9 to 11, wherein in the list output process, the factory-specific symbol list including a code selection specification area for displaying the factory-specific symbols in a selectable manner is displayed. Method. In the search request information reception process of the retail chain server, the search request information further including date information related to the date of the product to be searched is received,
The code management method according to any one of claims 9 to 12, wherein in the product information output process, attribute information of the product based on the date information is output together with the product information. The retail chain server is
The code management according to claim 13, wherein search request information designation screen display processing for displaying a search request information designation screen including a search request information designation area capable of designating the in-store code, the factory unique symbol, and the date information is executed. Method. The code management server
Manufacturer management information acquisition processing for acquiring manufacturer management information including a product specification identification code and a factory-specific symbol given to the product by the manufacturer that produced or manufactured the product;
The code management method according to any one of claims 9 to 14, wherein a manufacturer management information storage process of storing the manufacturer management information acquired in the manufacturer management information acquisition process in a manufacturer management DB is executed. The merchandise information indicated by the merchandise chart includes the merchandise name of the merchandise, the material used for the merchandise, the material used in the production or manufacture of the merchandise, the quantity of the material used, and the quantity of the material. Including
In the merchandise information output process of the retail chain server, the merchandise information indicated by the merchandise chart outputs the merchandise name of the merchandise, the material used for the merchandise, and the material used in the production or manufacture of the merchandise. And
A volume search request acceptance process for accepting a quantity search request;
A quantity search process for searching for the quantity of the used material and the quantity of the material in response to receiving the quantity search request in the quantity search request reception process;
The code according to any one of claims 9 to 15, wherein a quantity information output process for outputting quantity information including the quantity of the used material searched in the quantity search process and the quantity of the material is executed. Management method.

Images