JP5108360B2 - 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 The in-store code issuing means for issuing an in-store code for uniquely identifying the product at the in-store code, the in-store code issued by the in-store code issuing means, the product name of the product, and the product specification identification code of the product A code management DB for storing code management information including the product specification identification code Product record acquisition means for acquiring the product chart of the product to which the product is attached, and the product information indicated by the product chart acquired by the product chart acquisition means with reference to the code management information in the code management DB And an in-store code distribution means for distributing to the retail chain server to which the product is supplied, wherein the plurality of retail chain servers include an in-store code distributed by the in-store code distribution means, and product information indicated by the product chart The retail chain product master DB that stores the retail chain product master including the search request information receiving unit that receives the search request information including the in-store code given to the search target product, and the search request information receiving unit The in-store code included in the search request information is associated Product information indicated by the items chart of the product, characterized in that it comprises respectively a product information output means for outputting the reference to the retail chain article master.

  By configuring as described above, the product information of the product chart can be searched in a short time using the in-store code in the local retail chain server without accessing the product master server, and is accurately confirmed. be able to.

  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 may include a search request information specifying screen display unit that displays a search request information specifying screen including a search request information specifying area in which the in-store code and the date information can be specified.

  The code management server includes manufacturer management information acquisition means for acquiring manufacturer management information including a product specification identification code assigned to the product by a manufacturer that manufactured or manufactured the product, and manufacturer management acquired by the manufacturer management information acquisition means. A maker management DB that stores information may be included.

  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 An in-store code issuing process for issuing an in-store code for uniquely identifying the product in each retail chain; the in-store code issued in the in-store code issuing process; the product name of the product; Code management information storage processing for storing code management information including the product specification identification code in the code management DB; With reference to the code management information stored in the code management DB in the code management information storing process and the code management information storing process for acquiring the product chart of the product to which the product specification identification code is assigned, the in-store code is And an in-store code distribution process for distributing to the retail chain server to which the product is supplied together with the product information indicated by the product chart acquired in the product chart acquisition process, wherein the plurality of retail chain servers include the in-store code The retail chain product master storage process for storing the retail chain product master including the in-store code distributed in the distribution process and the product information indicated by the product chart in the retail chain product master DB, and the search target product Search request information receiving process for receiving search request information including in-store code The product information indicated by the product chart of the product associated with the in-store code included in the search request information received in the search request information reception process is stored in the retail chain product DB in the retail chain product master storage process. And a merchandise information output process for outputting with reference to the retail chain merchandise master.

  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 is used at a manufacturing code given to a product when the product is produced or manufactured, or at each retail store. In-store code issuance and management.

  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 at each retail store, and includes, for example, the product name of the product indicated by the manufacturing code.

  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, Including the name of the manufacturer that produced or manufactured the product. 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, 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, 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. .

  In this POS information, as shown in FIG. 2, for example, the product name and / or supplier name (manufacturer name) such as canned A, canned B, canned C, seasoning B, and beef A are set as the product name. Is done. 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 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.

  3-5 is explanatory drawing which shows the example of the retail chain goods master stored in the retail chain goods master DB with which each retail store server installed in the retail chains A-C 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 chart data including at least a part of data of the delivered product chart, product arrival date, 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 that the product has been received, 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 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 is information in which a product name, a manufacturing code, and an in-store code for uniquely identifying the product indicated by the manufacturing code for each of the retail chains A to N are associated. It is. Therefore, even if the product name and production code are the same, they are managed by different in-store codes for the retail chains A to N.

  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 processing is performed when, for example, a new in-store code is distributed to each retail chain A to N when a new product is handled or when the specification of the product is changed. An instruction is given by ten operators or 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 and the production 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, and the code management information The in-store code included in the store is searched, and the product can be uniquely identified for each retail chain A to N with the registered production code, and the in-store code that is not yet registered in the code management information is issued in association with each other. Then, 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.

  Then, the code management server 10 distributes the individual in-store code together with the product chart acquired in step S104 to the retail store servers 31 to 3N of the retail chains A to N that have issued the in-store code in step S102 (step S104). 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 is uniquely identifiable for each of the retail chains A to N and that is different for each of the newly assigned manufacturing codes is issued and stored in the code management DB 11. When a new in-store code is issued, new merchandise chart data is distributed to each retail store server 31 to 3N of the merchandise supply destination together with this in-store code, and new POS information in the retail chain merchandise master DBs 31a to 3Na is added. A new in-store code is registered, and a new in-store code and merchandise record data are associated and registered in the retail chain merchandise 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 uniquely identified.

  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 a newly distributed in-store code is assigned, and the in-store code and date information designated by the operator at the retail chain terminal A case will be described as an example where product information such as materials used is searched based on (for example, arrival date, expiration date, etc.).

  First, the operator of the retail store server 31 enters, for example, a product to be searched in the search condition specification area 101 of the search condition specification screen as shown in FIG. 10 displayed on the display screen of the display device included in the retail chain terminal. The search condition is designated by inputting the in-store code assigned to the item 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 chart data of the retail chain product master according to the designated in-store 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, the product name, and the manufacturing code of the product associated with the selected icon. Is retrieved 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 determines the product chart of the retail chain product master according to the designated in-store code and date information (here, the expiration date of the most recent date). Search for data.

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

  Next, the retail store server 31 refers to the retail chain product master of the retail chain product master DB 31a, and searches for the product chart data of the product of the manufacturing code associated with the in-store code received in step S201 ( Step S202), a product chart is obtained from the corresponding product chart data (Step S203).

  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 S204).

  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. For example, as shown in FIG. 12, 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. 12 shows an example of the search result when the in-store code “A00000023” and the expiration date “Determined by June 15, 2007” based on the date information are specified as the search conditions. ing. As shown in FIG. 12, as a search result, the product indicated by the in-store code “A00000023” is the product name “canned A” and the designated date “06/15” is the expiration date. The code “000125” and the product chart code “KA00048” are used.

  In addition, the materials used in “Canned A” are “Taraba rice cake”, “Seasoning α”, and “Seasoning β”, and the materials used when producing (or manufacturing) the “Canned A” 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 date information) issued by the code management server 10 and distributed to each of the retail chains A to N, for example, a manufacturing code (commodity chart code) is updated for a product having the same product name. Alternatively, even if it has been changed, the product information (used materials, materials, etc.) of the product can be searched locally without accessing the product master server 20. Thereby, high-speed product information can be searched in a short time.

  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. 12 (step S205), and if it is determined that it has been pressed (Y in step S205). , 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 displayed again on the display screen of the retail chain terminal (step S206), and this flowchart The series of product search processing by is terminated. Even when it is determined in step S205 that the quantity search execution button 203 has not been pressed (N in step S205), the product search process is terminated.

  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. 13, for example, this 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. 13, in the search result display area 202, the used material and its quantity, and the material and its quantity 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. 13, the data are displayed in order from the largest amount. Depending on the display order determination rule, for example, as shown in FIG. 14, “seasoning β” 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. 13, as a search result, in addition to the information shown in FIG. 12, the amount of each material such as “taraba rice cake” used in the product “canned food A” and the product “canned food A” The amount of each material used in the production (or manufacture) of the is shown. Based on this search result, it is possible to confirm the materials and materials used in the trade name “canned A” and the amount of the materials and materials.

  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 the product, and the product specification identification code of the product is stored in the code management DB 11 The product chart of the product to which the specification identification code is assigned is acquired, the code management information in the code management DB 11 is referred to, and the in-store code is stored together with the product information indicated by the acquired product chart in the retail chain A to which the product is supplied. And the retail point servers 31 to 3N distribute the in-store code and the product information indicated by the product chart. Stored retail chain product masters are stored in the retail chain product master DBs 31a to 3Na, search request information including in-store codes assigned to search target products is received, and in-store codes included in the received search request information are associated with each other. Since the product information indicated by the product chart of the product being sold is output with reference to the retail chain product master, the product information of the product chart can be accessed from the local retail point servers 31-1 without accessing the product master server 20. It is possible to search in 3N using an in-store code in a short time, and it can be confirmed accurately. Further, 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 on the code management server 10 is reduced without causing processing in the code management server 10 during search. be able to.

  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.

  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 above-described embodiment, the retail store servers 31 to 3N display a search request information specifying screen including a search request information specifying area (see 101 in FIG. 10) in which an in-store code and date information can be specified. Since it is configured, it is possible to easily specify search request information on the retail store servers 31 to 3N side.

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

  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. A graphic code or the like that can be uniquely identified in each of the retail chains A to N may be used. In other words, instead of the in-store code or together with the in-store code, a privately used graphic code that can uniquely identify a product in each retail chain A to N may be issued and managed.

  INDUSTRIAL APPLICABILITY 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 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.

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

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 uniquely identifying the product in each retail chain of the product supply destination indicated by the product specification identification code;
A code management DB that stores code management information including the in-store code issued by the in-store code issuing means, the product name of the product, and the product specification identification code of the product;
A product chart acquisition means for acquiring a product chart of a product to which the product specification identification code is attached;
An in-store code distribution unit that refers to the code management information in the code management DB and distributes the in-store code to the retail chain server of the product supply destination together with the product information indicated by the product chart acquired by the product chart acquisition unit; Including
The plurality of retail chain servers are:
A retail chain product master DB that stores a retail chain product master including the in-store code distributed by the in-store code distribution unit and the product information indicated by the product chart;
Search request information receiving means for receiving search request information including an in-store code assigned to a search target product;
Product information output means for outputting the product information indicated by the product chart of the product associated with the in-store code included in the search request information received by the search request information receiving means with reference to the retail chain product master; Code management system characterized by including each. 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 claim 1, 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 2, 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 and the date information. The code management server
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;
The code management system according to any one of claims 1 to 3, further comprising a manufacturer management DB that stores 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 4, further comprising: 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. . 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 uniquely identifying the product in each retail chain of the product supply destination indicated by the product specification identification code;
A code management information storage process for storing in the code management DB code management information including 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;
A product chart acquisition process for acquiring a product chart of a product to which the product specification identification code is attached;
With reference to the code management information stored in the code management DB in the code management information storage process, the in-store code is supplied together with the product information indicated by the product chart acquired in the product chart acquisition process. In-store code distribution processing to be distributed to the retail chain server of
The plurality of retail chain servers are
A retail chain product master storage process for storing a retail chain product master including the in-store code distributed in the in-store code distribution process and the product information indicated by the product chart in a retail chain product master DB;
Search request information reception processing for receiving search request information including an in-store code assigned to a search target product;
The product information indicated by the product chart of the product associated with the in-store code included in the search request information received in the search request information receiving process is stored in the retail chain product master DB in the retail chain product master storage process. A code management method comprising: executing a product information output process for outputting by referring to a stored retail chain product master. 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 claim 6, 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 method according to claim 7, 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 and the date information is executed. The code management server
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 6 to 8, wherein a maker management information storage process of storing the maker management information acquired in the maker management information acquisition process in a maker 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 6 to 9, 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