JP5413827B2 - Product master integrated management system, product master integrated management server, and product master integrated management processing program - Google Patents

Description

  The present invention is registered in a plurality of product master management servers for managing order management of products in each region with reference to each product master in which product information is registered, and in each product master of each of the plurality of product master management servers. Product master integrated management system comprising a product master integrated management server that integrates and manages existing products and a wholesaler terminal managed by a wholesaler that wholesales products from producers, and product master integration that constitutes the system The present invention relates to a management server and a product master integrated management program.

  Conventionally, in a store such as a supermarket, a POS system that collects information for grasping the sales status of each product by reading a POS code such as a barcode attached to a product desired to be purchased has been provided. Widely used (see, for example, Patent Document 1-2).

JP 2005-165629 A Japanese Patent Laid-Open No. 2005-228021

  However, some conventional POS systems have different product masters for the same product for each ordering party provided in each of a plurality of regions. When ordering products from a store in the POS system to a wholesaler (such as a fresh food center), the product (product name and product standard (international standard code called JAN (EAN) code)) and region (customer) There is a problem that the product master for each region cannot be integrated and managed because it is decided to designate a supplier in a certain region selected from the list.

  Further, when the product masters are integrated and managed, there is a problem that the load on the server used for the integration becomes large.

  An object of the present invention is to solve the above-described problems, integrate and manage product master data for each region, and suppress the processing load of a server device for integrated management as much as possible. To do.

The product master integrated management system of the present invention includes a plurality of product master management servers for managing order management of products in each region with reference to each product master in which product information is registered, and each of the plurality of product master management servers. A product master integrated management system comprising a product master integrated management server that integrates and manages products registered in a product master, and a wholesaler terminal that is managed by a wholesaler that wholesales products from producers. The product master integrated management server integrates the product name or product category of the product, the standard code of the product, and the product master code for the product in the product master of each of the plurality of product master management servers. Integrated product master storage means for storing the product master, and the product name or product title of the product from the wholesaler terminal. A product master code search means for searching for a product master code of a product master in each region of the corresponding product with reference to the integrated product master in response to a request that presents a key and a standard code, and a product master of each searched region Product master code providing means for providing a code to the wholesaler terminal, and the product master code selected at the wholesaler terminal among the provided product master codes to the product master management server in the corresponding region, seen containing a product master data acquisition means for acquiring the product master data from the master management server corresponding products registered in the product master for, and a product master data providing means for providing a product master data acquired to the wholesaler terminal, In the product master, the order history information indicating the order history of the product is registered as the product information. The product master integrated management server further includes order history information collecting means for collecting the order history information of each product from the plurality of product master management servers, and the number of orders received by the collected order history information is a predetermined number or less. Integrated product master data saving unit for saving the integrated product master data in a save file different from the integrated product master storage unit, and integration for deleting the integrated product master data saved in the save file from the integrated product master storage unit Product master data deleting means .

  With the above configuration, the product master for each region can be integrated and managed, and the processing load of the server device for integrated management can be suppressed as much as possible.

  The product master integrated management server may include a deletion notification unit that notifies the plurality of product master management servers that the integrated product master data has been deleted from the integrated product master storage unit.

In addition, the product master integrated management server of the present invention is registered in each product master of each of a plurality of product master management servers that perform order management of products in each region with reference to each product master in which product information is registered. A product master integrated management server that integrates and manages existing products, the product name or product category of the product, the standard code of the product, and the product for the product in the product master of each of the plurality of product master management servers Integrated product master storage means for storing an integrated product master associated with the master code, and the product name or product category and standard code of the product from the wholesaler terminal managed by the wholesaler who wholesales the product from the producer In response to the presented request, the product mass of the product master in each region of the corresponding product is referred to the integrated product master. Product master code search means for searching for a code, product master code providing means for providing the product master code of each searched region to the wholesaler terminal, and the wholesaler terminal selected from the provided product master codes Product master data acquisition means for presenting the product master code to the product master management server in the corresponding region and acquiring the product master data registered in the product master for the corresponding product from the product master management server, and the acquired product master data only contains the product master data providing means for providing to the wholesaler terminal, the product master, as the product information is registered orders history information indicating the order history of the product, further, the plurality of items Order history information collection means for collecting order history information for each product from the master management server, and collected order history Integrated product master data saving means for saving integrated product master data of products whose order number indicated by the report is a predetermined number or less in a save file different from the integrated product master storage means, and integrated product master data saved in the save file And integrated product master data deleting means for deleting from the integrated product master storage means .

Furthermore, the product master integrated management processing program of the present invention is registered in the product master of each of a plurality of product master management servers that perform order management of products in each region with reference to each product master in which product information is registered. Product master integrated management processing program that executes processing for integrating and managing the products being managed, and the product name of the product from the wholesaler terminal managed by the wholesaler who wholesales the product from the producer on the computer Alternatively, in response to a request for presenting the product category and the product standard code, the product name or product category of the product, the product standard code, and the product master of each of the product master management servers Stored in the integrated product master storage means for storing the integrated product master associated with the product master code. A product master code search process for searching for a product master code of a product master in each region of the corresponding product with reference to the integrated product master, and a product master code providing the product master code of each searched region to the wholesaler terminal Processing and the product master code selected by the wholesaler terminal among the provided product master codes are presented to the product master management server in the corresponding region, and the corresponding product is registered in the product master from the product master management server. Product master data acquisition processing for acquiring existing product master data, and product master data provision processing for providing the acquired product master data to the wholesaler terminal . Order history information indicating an order history is registered, and the computer further includes the plurality of quotients. Order history information collection processing for collecting order history information of each product from the master management server, and integrated product master storage means for integrated product master data of products whose order number indicated by the collected order history information is a predetermined number or less. The integrated product master data saving process to be stored in different save files and the integrated product master data deleting process for deleting the integrated product master data saved in the save file from the integrated product master storage unit are executed.

  ADVANTAGE OF THE INVENTION According to this invention, the merchandise master for every area can be integrated and managed, and the processing load of the server apparatus for integrated management can be suppressed as much as possible.

It is a block diagram which shows the example of a structure of the goods master integrated management system in one embodiment of this invention. It is explanatory drawing which shows the example of POS data. It is explanatory drawing which shows the example of the storage state of the goods master managed about the area A. It is explanatory drawing which shows the example of the storage state of the goods master managed about the area | region B. FIG. It is explanatory drawing which shows the example of the storage state of an integrated goods master. It is a flowchart which shows the example of merchandise master integrated management processing. It is explanatory drawing which shows the example of an all goods master code search screen. It is explanatory drawing which shows the example of a goods master code list screen. It is explanatory drawing which shows the example of a goods master display screen. It is a flowchart which shows the example of an integrated goods master save process. It is a flowchart which shows the example of an information registration process.

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 product master integrated management system 100 according to an embodiment of the present invention. As shown in FIG. 1, the product master integrated management system 100 includes a product master integrated management server 10, product master management servers 11 to 1N (N: any positive integer), store servers 20A and 20B, and a wholesaler. Terminal 30, POS registers 41 </ b> A to 4 </ b> NA, 41 </ b> B to 4 </ b> NB (N: any positive integer), JAN management server 70, and POS master server 80 are included.

  The product master integrated management server 10, product master management servers 11 to 1N, store servers 20A and 20B, wholesaler terminal 30, JAN management server 70, and POS master server 80 are each connected to a communication network 90 such as the Internet. ing. The store server 20A and the POS registers 41A to 4NA are connected to a communication network 60A such as a LAN disposed in the store A, for example. The store server 20B and the POS registers 41B to 4NB are respectively connected to a communication network 60B such as a LAN arranged in the store B, for example.

  In FIG. 1, the store server 20A and the POS registers 41A to 4NA installed in the store A and the store server 20B and the POS registers 41b to 4NB installed in the store B are shown. The product master integrated management system 100 may include a store server installed in a store, a computer that performs POS data intra processing before processing of the store server, and a POS register.

  The product master integrated management server 10, the product master management servers 11 to 1N, the store servers 20A and 20B, the JAN management server 70, and the POS master server 80 are each configured by an information processing device such as a WWW server. The wholesaler terminal 30 is configured by an information processing apparatus such as a personal computer.

  The product master integrated management server 10 is a server managed by a system administrator of the product master integrated management system 100, for example, and executes various processes for integrated management of product masters managed in each region. The product master integrated management server 10 also includes an integrated product master DB 10A that stores various types of information for integrated management of product masters managed in each region. The integrated product master DB 10A may be inside or outside the product master integrated management server 10.

  Each of the product master management servers 11 to 1N is a server managed by an order manager who performs order management of products in a region (Sapporo region, Hakodate region, etc.) in which the product master management server is responsible, and stores product items from stores in each region. Perform various processes related to orders. In addition, the product master management servers 11 to 1N include product master DBs 11A to 1NA in which product masters managed in the areas in charge are stored. The product master DBs 11A to 1NA may be inside or outside the product master management servers 11 to 1N, respectively.

  Store server 20A is managed by a store manager who manages store A, for example, and exchanges information with each POS register 41A-4NA via communication network 60A. The store server 20B is managed by a store manager who manages the store B, for example, and exchanges information with the POS registers 41B to 4NB via the communication network 60B. Since store server 20A and store server 20B have the same configuration, in the following description, store server 20A will be mainly described.

  Each of the POS registers 41A to 4NA is a register installed in a purchase amount payment place provided in the store A. For example, a bar code for a POS system (an example of a POS code: POS bar code) and various functions such as a function of printing purchase contents on a receipt using a product name and a product price specified based on the POS bar code. The POS registers 41B to 4NB are registers installed in the purchase amount payment place provided in the store B, and have the same functions as the POS registers 41A to 4NA. Since the POS registers 41A to 4NA and 41B to 4NB have the same configuration, the POS register 41A will be mainly described in the following description.

  The wholesaler terminal 30 is managed by a wholesaler such as a perishable center, for example, and performs various processes such as a process of collecting merchandise from a merchandise producer and notifying the JAN management server 70 of merchandise information including a JAN code. The wholesaler terminal 30 may be managed not only by the fresh food center but also by a wholesaler such as a retail delivery center. Therefore, the wholesaler terminal 30 may be referred to as a perishable center terminal or a delivery center terminal.

  The JAN management server 70 is managed by a manager who manages the JAN code, and transmits the product information including the JAN code notified from the wholesaler terminal 30 to the POS master server 80 as POS data. Various kinds of processing such as providing product information to the management servers 11 to 1N, collecting product master codes in each region, and notifying the collected product master codes to the product master integrated management server 10 together with corresponding JAN codes Process. The JAN management server 70 includes a DB that stores product information (not shown).

  The POS master server 80 is managed by a management company that manages POS data, and responds to processing for registering product information acquired from the JAN management server 70 as POS data and requests from the store servers 20A and 20B of the stores A and B. In response, various processes such as a process of providing POS data are performed. The POS master server 80 includes a POS master DB 81 in which POS data used in the stores A and B is stored. The POS master DB 81 may be inside or outside the POS master server 80.

  FIG. 2 is an explanatory diagram illustrating an example of POS data. As shown in FIG. 2, the POS data includes a recorded POS code, a corresponding product category (product category), a product name, and a product price. In this example, the “POS code” means that the same code as the JAN code of the corresponding product is used, and is a code set to uniquely identify the predetermined product handled in the attachment. .

  As shown in FIG. 2, classifications such as eggplants, radishes, pork and potatoes are set in the product category. As the product name, the name of the product such as XX eggplant, xx daikon radish, □□ union eggplant, and / or the place of production and the supplier name (manufacturer name) are set. The price is set to the price of the sales unit for each piece or weight.

  The POS data is stored together in the POS master DB 81. Then, each store server 20A, 20B acquires POS data about the products handled (purchased and sold) at its own store from the POS master server 80 in accordance with the operation of the workers at each store A, B, and The acquired POS data is stored in the store server DBs 21A and 21B included in.

  FIG. 3 is an explanatory diagram illustrating an example of a product master stored in a product master DB 11A included in the product master management server 11 that performs order management in the region A. In the product master, a product master code, JAN code, product category, product name, price, and order history that are uniquely assigned to the product in the region A are associated with each product. It is registered. The order history is history information when the corresponding product master management server 11 receives a product from the store server, and relates to orders such as the store name of the store where the product has been ordered, the number of orders for the product, and the date and time of order. Means various information.

  FIG. 4 is an explanatory diagram illustrating an example of a product master stored in a product master DB 12A included in the product master management server 12 that performs order management in the region B. In the product master, the product master code, JAN code, product category, product name, price, and order history that are uniquely assigned to the product in region B are associated with each product and registered. Has been.

  For other regions, similar to the above regions A and B, a product master including a product master code uniquely assigned to the corresponding product in the corresponding region is registered.

  FIG. 5 is an explanatory diagram illustrating an example of the integrated product master stored in the integrated product master DB 10A. In the integrated merchandise master, a merchandise category, a merchandise name, a JAN code, and each merchandise master code uniquely assigned to the corresponding merchandise in each region are registered in association with each other.

Next, the operation of the product master integrated management system 100 of this example will be described.
FIG. 6 is a flowchart showing an example of product master integrated management processing in the product master integrated management system 100 of this example. Here, a case where the product master integrated management server 10 provides a list screen of product master codes of each region in response to a request from the wholesaler terminal 30 will be described as an example, and processing particularly related to the present invention Other than the above, the description may be omitted.

  In the product master integrated management process, first, the wholesaler terminal 30 accesses the product master integrated management server 10 in accordance with the operation of the person in charge X of the wholesaler (step S101). In step S101, for example, the URL is accessed by a URL (Uniform Resource Locator) of a product master integrated management site provided by an administrator of the product master integrated management server 10.

  When there is an access from the wholesaler terminal 30, the product master integrated management server 10 generates an all product master code search screen as shown in FIG. 7, for example, and transmits it to the wholesaler terminal 30 (step S102).

  The wholesaler terminal 30 displays the all product master code search screen from the product master integrated management server 10 on the display device provided therein (step S103). In the all product master code search screen, for example, as shown in FIG. 7, a product category input area 101 for inputting a product category, a JAN code input area 102 for inputting a JAN code, and a search button 103 pressed when performing a search. Etc. are provided.

  When the all product master code search screen is displayed, the person in charge X inputs the product category of the product for which the product master code is desired to be browsed into the product category input area 101 and the JAN code attached to the product. Input to the JAN code input area 102.

  After accepting the input of the merchandise category and JAN code (step S104), when the wholesaler terminal 30 accepts the pressing of the search button 103, the merchandise master integrated management of the merchandise category and JAN code of the merchandise entered by the person in charge X is received. It transmits to the server 10 (step S105).

  Upon receiving the product category and JAN code, the product master integrated management server 10 refers to the integrated product master stored in the integrated product master DB 10A, and uses the received product category and JAN code to determine each region for the product. The product master code at is searched (step S106). Specifically, the integrated product master including the received product category and JAN code is identified from the integrated product master stored in the integrated product master DB 10A, and each registered in the identified integrated product master. Extract the regional product master code. In this example, the product names registered in the specified integrated product master are also extracted.

  When the product master code of each region is searched, the product master integrated management server 10 generates a product master code list screen as shown in FIG. 8 including the extracted product master code display area of each region (step S107). The generated product master code list screen is transmitted to the wholesaler terminal 30 via the communication network 90 (step S108).

  The wholesaler terminal 30 displays the product master code list screen from the product master integrated management server 10 on its own display device (step S109). For example, as shown in FIG. 8, the product master code list screen includes a display area 104 for displaying the product category and JAN code used as the search key, the product name of the corresponding product as a search result, and the product master of each region. A search result display area 105 for displaying codes is provided.

  When the product master code list screen is displayed, the person in charge X browses the product master code of each region displayed on the product master code list screen, and displays the product master code displayed in the search result display area 105. A product master code of an area where browsing of the product master is desired is selected (for example, selected by mouse click).

  When the selection of the product master code is received (step S110), the wholesaler terminal 30 transmits the received product master code to the product master integrated management server 10 (step S111).

  Upon receiving the product master code, the product master integrated management server 10 presents the product master code to the product master server that manages the received product master code among the product master management servers 11 to 1N, Product master data including a product master code presented from the master server is acquired (step S112). For example, when the product master code managed by the product master management server 11 in the region A is received, the product master integrated management server 10 presents the product master code to the product master management server 11 to display the product master code. Product master data including the product master code presented from the master management server 11 is acquired. In this case, the product master management server 11 refers to the product master DB 11A, searches for product master data including the presented product master code, and transmits the product master data to the product master integrated management server 10.

  Upon receiving the product master data, the product master integrated management server 10 generates a product master display screen as shown in FIG. 9 including the product master display area indicated by the received product master data (step S113). The merchandise master display screen is transmitted to the wholesaler terminal 30 via the communication network 90 (step S114).

  The wholesaler terminal 30 displays the merchandise master display screen from the merchandise master integrated management server 10 on its own display device (step S115). For example, as shown in FIG. 9, the product master display screen displays a display area for displaying the region where the displayed product master is managed, a display region 106 for displaying the product master code, and an order history. A display area 107 is provided.

  When the product master display screen is displayed, the person in charge X browses the order history in the corresponding area of the product displayed on the product master display screen and confirms the order status (usage at each store) of the product. To do.

  When the end button (not shown) provided on the product master display screen is pressed, the wholesaler terminal 30 ends the processing here and disconnects from the product master integrated management server 10. Note that it may be possible to return to the product master code list screen and browse the order history in other regions.

  In the above example, the product master code of each region is presented in response to a request from the wholesaler terminal 30, but it is presented in response to a request from another user terminal such as the store server 20A. Also good.

  FIG. 10 is a flowchart showing an example of the integrated product master saving process in the product master integrated management system 100 of this example. Here, the product master integrated management server 10 saves the integrated product master for products with a small number of orders based on the order history information of each product stored in the product master management servers 11 to 1N in each region. It is assumed that the description is omitted except for the processing particularly related to the present invention. This integrated product master saving process is executed, for example, periodically or in response to receiving an execution instruction from an operator.

  In this example, when the product master management servers 11 to 1N in each region receive an order for the product from the store server in the region managed by the region, the order details (ordered product, order quantity, order date and time) Etc.) as an order history.

  In the integrated product master saving process, first, the product master integrated management server 10 collects order history information from the product master management servers 11 to 1N in each region (step S201). That is, the product master management servers 11 to 1N in each region refer to the product master DBs 11A to 1NA managed by the product master management server 10 in response to requests from the product master integrated management server 10, respectively. And the product master code are transmitted to the product master integrated management server 10.

  When the order history information is collected, the product master integrated management server 10 refers to the collected order history, and the number of orders received (for example, the number of orders received during a certain period of time) is less than or equal to a predetermined number (for example, 0 pieces / week, 10 items / week, 10 items / month, 100 items / month, etc.) If the integrated product master data of the specified product is stored in the integrated product master DB 10A, the integrated product master data of the product is stored. The data is stored in a predetermined save file (not shown) (a storage medium different from the integrated product master DB 10A) provided by the user (step S202).

  Next, the product master integrated management server 10 deletes the integrated product master data stored in the save file from the integrated product master DB 10A (step S203).

  Then, the product master integrated management server 10 notifies the product master management servers 11 to 1N in each region of the content of the product deleted from the integrated product master DB 10A (for example, the product master code of the corresponding region) (step S203).

  As described above, the integrated product master data of products that have few orders and are not often used is deleted from the integrated product master DB 10A, and the process of reducing the amount of data stored in the integrated product master DB 10A is executed. Note that the data saved in the save file may be returned to the integrated product master DB 10A, for example, at the discretion of the system administrator when orders increase.

  FIG. 11 is a flowchart showing an example of information registration processing in the product master integrated management system 100 of this example. Here, the JAN management server 70 will be described with respect to processing for transmitting the product information received from the wholesaler terminal 30 to various places, and description may be omitted except for processing particularly related to the present invention. And

  In the information registration process, the JAN management server 70 receives product information from the wholesaler terminal 30 (information related to the product, for example, information including the JAN code, product category, product name, and price of the product) (step) (Y in S301), product information is transmitted to the product master management servers 11 to 1N in each region (step S302), and the product master code assigned to each product is acquired from each product master management server 11 to 1N (step S303). ). In this case, when the product master management servers 11 to 1N receive the product information from the JAN management server 70, each product master management server 11 to 1N assigns a product master code to each product, and stores product master data including the assigned product master code in the product master DB 11A to 11A. A process of registering with 1NA and transmitting the assigned product master code to the JAN management server 70 in association with the JAN code of the corresponding product is performed.

  Next, the JAN management server 70, the product master code assigned by each of the product master management servers 11 to 1N, the JAN code of the corresponding product, and a part of the product information of the corresponding product (at least the product category and (Product name) in association with each other and transmitted to the product master integrated management server 10 (step S304). In this case, the product master integrated management server 10 registers the information received from the JAN management server 70 in the integrated product master DB 10A as integrated product master data.

  Further, the JAN management server 70 transmits POS master data in which the JAN code is the POS code among the product information received from the wholesaler terminal 30 to the POS master server 80 (step S305). In this case, the POS master server 80 registers the received POS master data received from the JAN management server 70 in the POS master DB 81. In this example, since the price of the product is included in the product information, the price is also included in the POS master data as it is. Therefore, the POS master data registered in the POS master DB 81 is set with the same price as the price registered in each of the product master management servers 11 to 1N for the corresponding product.

  As described above, in the above-described embodiment, a plurality of product master management servers 11 to 1N that perform order management of products in each region with reference to each product master in which product information is registered, A product master integrated management server 10 that integrates and manages products registered in the product masters of the plurality of product master management servers, and a wholesaler terminal 30 that is managed by a wholesaler that wholesales products from producers. The product master integrated management server 10 in the product master integrated management system 100 provided includes the product name or product category of the product, the standard code (JAN code) of the product, and the product master of each of the plurality of product master management servers 11 to 1N. Integrated product master D that stores an integrated product master that associates the product master code for the product in 10A, and in response to a request for providing the product name or product category and standard code of the product from the wholesaler terminal 30, the product master code of the product master in each region of the corresponding product is searched with reference to the integrated product master Then, the product master code of each searched region is provided to the wholesaler terminal 30, and the product master code selected by the wholesaler terminal 30 among the provided product master codes is presented to the product master management server 11 of the corresponding region. Since the product master data registered in the product master for the corresponding product is acquired from the product master management server 11 and the acquired product master data is provided to the wholesaler terminal 30, the product master for each region is selected. The processing load of the server device (product master integrated management server 10) that can be managed in an integrated manner So it can be suppressed as much as possible.

  That is, the product master integrated management server 10 includes a product name or product category of the product, a standard code (JAN code) of the product, and a product master for the product in each of the product masters of the plurality of product master management servers 11 to 1N. The integrated product master DB 10A for storing the integrated product master that associates the codes with each other is provided, and the integrated product master is referred to in response to a request from the wholesaler terminal 30 that indicates the product name or product category of the product and the standard code. Since the product master code of the product master in each region of the corresponding product is searched and provided to the wholesaler terminal 30, the product name or product category of the product and the standard code are used for the product in each region. Specific product master codes can be specified and provided. It become to be managed by integrating.

  Since the product master integrated management server 10 is configured to store and manage only the product name or product category and standard code of the product information in the integrated product master DB 10A, the server device for integrated management (product The processing load on the master integrated management server 10) can be suppressed as much as possible.

  In the above-described embodiment, it is assumed that the order history information indicating the order history of the product is registered as the product information in the product master, and the product master integrated management server 10 includes a plurality of product master management servers 11. Collect the order history information of each product from ~ 1N, save the integrated product master data of products whose order number indicated by the collected order history information is a predetermined number or less in a save file different from the integrated product master DB 10A, and save this Since the integrated product master data stored in the file is deleted from the integrated product master DB 10A, the integrated product master data for products that are not used or products that are not used can be saved and excluded from management targets. Server device for integrated management (product master integrated management server 10) without hindering management processing Furthermore it is possible to minimized the processing load.

  In the above-described embodiment, the product master integrated management server 10 notifies the plurality of product master management servers 11 to 1N that the integrated product master data has been deleted from the integrated product master DB 10A. The master management servers 11 to 1N can grasp the products that are normally managed by the integrated product master DB 10A.

  In the above-described embodiment, the product master integrated management server 10 and the JAN management server 70 are separately provided. However, these may be configured by one server device. That is, the product master integrated management server 10 may have a function of the JAN management server 70.

  Although not specifically mentioned in the above-described embodiment, the product master integrated management server 10 performs the various processes described above according to a processing program (product master integrated management processing program) stored in a storage medium included in the product master integrated management server 10. (See FIG. 6 and the like).

  ADVANTAGE OF THE INVENTION According to this invention, in the system which integrates and manages the merchandise master for every area, it is useful for suppressing the processing load of the server apparatus for integrated management as much as possible.

10 product master integrated management server 10A integrated product master DB
11 to 1N Product master management server 20A, 20B Store server 30 Wholesaler terminal 41A to 4NA, 41B to 4NB POS register 60A, 60B, 90 Communication network 70 JAN management server 80 POS master server 100 Product master integrated management system

Claims (6)

A plurality of product master management servers for managing order management of products in each region with reference to each product master in which product information is registered, and products registered in the product masters of the plurality of product master management servers A product master integrated management system comprising a product master integrated management server for integrated management and a wholesaler terminal managed by a wholesaler who wholesales products from producers,
The product master integrated management server
Integrated product master storage that stores an integrated product master that associates the product name or product category of the product, the standard code of the product, and the product master code for the product in the product master of each of the plurality of product master management servers Means,
A product master that searches a product master code of a product master in each region of the corresponding product with reference to the integrated product master in response to a request that presents the product name or product category and standard code of the product from the wholesaler terminal Code search means;
Product master code providing means for providing the wholesaler terminal with the product master code of each searched region;
The product master code registered in the product master from the product master management server by presenting the product master code selected at the wholesaler terminal among the provided product master codes to the product master management server in the corresponding region Product master data acquisition means for acquiring data;
Look contains a merchandise master data providing means for providing the acquired commodity master data to the wholesaler terminal,
In the product master, the order history information indicating the order history of the product is registered as the product information,
The product master integrated management server
Further, order history information collection means for collecting order history information of each product from the plurality of product master management servers,
Integrated product master data saving means for saving integrated product master data of products whose number of orders indicated by the collected order history information is a predetermined number or less in a save file different from the integrated product master storage means;
A product master integrated management system comprising: integrated product master data deleting means for deleting the integrated product master data stored in the save file from the integrated product master storage means . The product master integrated management server, the product master integrated management system of claim 1 further comprising a deletion notification means for notifying the plurality of product master management server that the integrated product master data has been deleted from the integrated product master memory means. Product master integrated management that integrates and manages products registered in the product master of each of multiple product master management servers that manage the order management of products in each region with reference to each product master in which product information is registered A server,
Integrated product master storage that stores an integrated product master that associates the product name or product category of the product, the standard code of the product, and the product master code for the product in the product master of each of the plurality of product master management servers Means,
Each region of the corresponding product with reference to the integrated product master in response to a request indicating the product name or product category and standard code of the product from the wholesaler terminal managed by the wholesaler who wholesales the product from the producer A product master code search means for searching for a product master code of a product master in
Product master code providing means for providing the wholesaler terminal with the product master code of each searched region;
The product master code registered in the product master from the product master management server by presenting the product master code selected at the wholesaler terminal among the provided product master codes to the product master management server in the corresponding region Product master data acquisition means for acquiring data;
Look contains a merchandise master data providing means for providing the acquired commodity master data to the wholesaler terminal,
In the product master, the order history information indicating the order history of the product is registered as the product information,
Further, order history information collection means for collecting order history information of each product from the plurality of product master management servers,
Integrated product master data saving means for saving integrated product master data of products whose number of orders indicated by the collected order history information is a predetermined number or less in a save file different from the integrated product master storage means;
A product master integrated management server comprising: integrated product master data deleting means for deleting the integrated product master data stored in the save file from the integrated product master storage means . The product master integrated management server according to claim 3 , further comprising a deletion notification means for notifying the plurality of product master management servers that the integrated product master data has been deleted from the integrated product master storage means. A process for integrating and managing the products registered in each product master of each of a plurality of product master management servers that perform order management of products in each region with reference to each product master in which product information is registered A product master integrated management processing program to be executed,
On the computer,
In response to a request that presents the product name or product category of the product from the wholesaler terminal managed by the wholesaler who wholesales the product from the producer and the standard code of the product, the product name or product category of the product, The integrated product master stored in the integrated product master storage means for storing the integrated product master in which the standard code of the product and the product master code for the product in the product master of each of the plurality of product master management servers is associated. A product master code search process for searching for a product master code of a product master in each region of the corresponding product with reference to,
Product master code provision processing for providing the wholesaler terminal with the product master code of each searched region;
The product master code registered in the product master from the product master management server by presenting the product master code selected at the wholesaler terminal among the provided product master codes to the product master management server in the corresponding region Product master data acquisition processing to acquire data,
A product master data providing process for providing the acquired product master data to the wholesaler terminal ;
In the product master, the order history information indicating the order history of the product is registered as the product information,
On the computer,
Furthermore, order history information collection processing for collecting order history information of each product from the plurality of product master management servers,
Integrated product master data saving processing for saving integrated product master data of products whose number of orders indicated by the collected order history information is a predetermined number or less in a save file different from the integrated product master storage unit;
A product master integrated management processing program for executing integrated product master data deletion processing for deleting integrated product master data stored in the save file from the integrated product master storage unit . On the computer,
6. The product master integrated management processing program according to claim 5 , further comprising: a deletion notification process for notifying the plurality of product master management servers that the integrated product master data has been deleted from the integrated product master storage unit.

Images