JP4942395B2 - Product information management system and product information management method - Google Patents

Description

  The present invention relates to a merchandise information management system and a merchandise information management method including a store server to which a POS register is connected and a merchandise information management server that manages merchandise information.

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

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

  However, in the conventional POS system described above, the information obtained by the POS code is an in-store code unique to each store. The chain store generally uses the international standard code format called JAN (EAN) code, but since the in-store codes used for registered products are different, the sales status between chain stores can be monitored. There was a problem that it could not be put together smoothly.

  Although it is conceivable to construct a POS system in which the in-store code is unified, enormous costs and time are required to construct such a POS system, resulting in a lot of economic waste. .

  The present invention solves the above-mentioned problems, can accurately grasp the relevance of codes used between a plurality of stores without unifying the in-store code, and can smoothly sell the sales situation between the plurality of stores. The purpose is to be able to aggregate.

The product information management system of the present invention is a product information management system including a store server to which a POS register is connected and a product information management server for managing product information, the store server being on the product information management server side. Is a POS code that is master-registered in the store, and is a POS code that is initially set in association with a predetermined product in the corresponding store, and is associated with a predetermined product in the POS system in the corresponding store. POS data including the in-store POS code that is a POS code that is currently used and is associated with the master registration POS code that is initially set for the product and can be changed as appropriate at each store. POS data storage means for storing information and product history information including product producers and production locations And sales management for the category which is a constant possible categories, and the store side merchandise sales information storage means for storing the store merchandise sales information including the individual product code to be used in the search of the history information of products, products that consumers purchase An in-store POS code acquisition unit for acquiring an in-store POS code assigned to the master, and a master registration associated with the in-store POS code acquired by the in-store POS code acquisition unit with reference to the POS data Master registration POS code specifying means for specifying a POS code; master registration POS code transmitting means for transmitting the master registration POS code specified by the master registration POS code specifying means to the product information management server via a communication network; By the in-store POS code acquired by the in-store POS code acquisition means And a shop side product sales information storing means for storing information as a shop side merchandise sales information including at least a portion of the product information that is constant, the product information management server, the individual product code, has sold the commodity Master registration POS code correspondence information storage means for storing master registration POS code correspondence information associated with a master registration POS code associated with the in-store POS code used for the product at the store, and a master registration POS code The master registration POS code receiving means for receiving the product, the product history information searching means for searching for the product history information associated with the individual product code corresponding to the received master registration POS code , and the product history information searching means and a product sales information storing means for storing merchandise sales information including at least a portion of the product history information, the shop Sales management category determination means for determining at least one of the store server and the product information management server, according to a predetermined rule, a sales management category according to the product history information searched by the product history information search means; And sales management category registration means for registering the sales management category determined by the sales management category determination means in association with the individual product code in the master registration POS code correspondence information .

  By configuring as described above, it is possible to accurately grasp the relevance of codes used between multiple stores without unifying in-store codes, and smoothly aggregate sales status among multiple stores. can do.

The POS data includes POS categories such as vegetables, meats, and moss that indicate a classification higher than the sales category for merchandise.

The product information management server refers to the master registration POS code correspondence information, and determines whether the sales management category is set in the master registration POS code received by the master registration POS code receiving means. When the sales management category setting determination means determines that the sales management category is not set in the received master registration POS code, the product history information search means receives the management category setting determination means The product history information associated with the individual product code corresponding to the master registration POS code is searched, and the sales management category setting determination means determines that the sales management category is set in the received master registration POS code. The sales management category determining means determines the sales management category according to the product history information. It may be configured to determine the sales management for the category.

The store-side product sales information storage means may be configured to store store-side product sales information including the price of the product specified by the in-store POS code .

The sales management category into which the sold product is classified is indicated by, for example, the producer, production place, manufacturer, or sales source of the product and the product name of the product.

Further, the product information management method of the present invention includes an in-store POS code acquisition process in which a store server connected to a POS register acquires an in-store POS code assigned to a product purchased by a consumer, and the product information A POS code that is master-registered on the management server side and is a POS code that is initially set in association with a predetermined product in the corresponding store, and a predetermined product in the POS system in the corresponding store And an in-store POS code which is a POS code that is currently used in association with the product, is associated with the master registration POS code that is initially set for the product, and can be changed as appropriate at each store. Referring to POS data stored in the POS data storage means for storing the POS data including the in- The master registration POS code specifying process for specifying the master registration POS code associated with the in-store POS code acquired in the tor POS code acquisition process, and the master registration POS code specified in the master registration POS code specifying process Sales management category, which is a category that can be identified by master registration POS code transmission processing that is transmitted to a product information management server that manages product information via a communication network, and product history information including the producer and production location of the product And store-side product sales information storage means for storing store-side product sales information including individual product codes used for searching for product history information, using the in -store POS code acquired in the in-store POS code acquisition process. and the store-side product sales information information including at least a portion of the product information specified Run the shop side merchandise sales information accumulation process of accumulating Te, the product information management server includes a master registration POS code receiving process of receiving the master registration POS code, the individual product code corresponding to the master registration POS code received run the product history information searching process for searching a product history information correlating, and merchandise sales information storing process for storing merchandise sales information including at least a portion of the product history information to which the product history information retrieval means searches And at least one of the store server and the product information management server further determines a sales management category according to the product history information searched in the product history information search process according to a predetermined rule. The sales management category determined in the determination process and the sales management category determination process, and the product code Stored in the master registration POS code correspondence information storage means for storing the master registration POS code correspondence information associated with the master registration POS code associated with the in-store POS code used for the product at the store where the product was sold. A sales management category registration process for registering in association with the individual product code in the master registration POS code correspondence information is executed.

  According to the present invention, it is possible to accurately grasp the relevance of codes used between a plurality of stores without unifying in-store codes, and it is possible to smoothly aggregate sales statuses among a plurality of stores. become able to.

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 information management system 100 according to an embodiment of the present invention. As shown in FIG. 1, the product information management system 100 includes a product information management server 10, store servers 20A and 20B, and POS registers 41A to 4NA and 41B to 4NB (N: any positive integer).

  The merchandise information management server 10, the store server 20A, and the store server 20B are each connected to a communication network 50 such as the Internet. 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 information 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 merchandise information management server 10, the store server 20A, and the store server 20B are each configured by an information processing device such as a WWW server.

  The merchandise information management server 10 is a server managed by a system administrator of the merchandise information management system 100, for example. The merchandise information management server 10 includes a management server DB 11 in which various information such as merchandise history information including product production history and distribution history is stored. I have. The management server DB 11 may be inside or outside the product information management server 10.

  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.

  FIG. 2 is an explanatory diagram illustrating an example of POS data. As shown in FIG. 2, the POS data includes a master registration POS code, an in-store POS code, a POS category indicating a category in the POS system of the corresponding product, a product name, and a price of the product. The “master registration POS code” is a POS code that is master-registered on the product information management server 10 side, and means a POS code that is initially set in association with a predetermined product at the corresponding store. The “master registration POS code” may be a specific standard format such as a JAN format, or may be a store-specific format. The “in-store POS code” is a POS code currently used in association with a predetermined product in the POS system in the corresponding store, and is associated with a master registration POS code that is initially set for the product. The POS code can be changed as appropriate at each store. If the code has not been changed since the setting of the master registration POS code for a certain product, the “master registration POS code” and the “in-store POS code” have the same code content.

  As shown in FIG. 2, a large classification such as vegetables, meat, and moss is set in the POS category. In addition, as the product name, a product name such as radish, pork, potato, and / or supplier name (manufacturer name) is set. The price is set to the price of the sales unit for each piece or weight.

  The POS data is stored in store server DBs 21A and 21B provided in the store servers 20A and 20B, respectively. Further, POS data may have different POS codes and different product names even for the same product depending on the POS system employed in each store.

  FIG. 3 is an explanatory diagram illustrating an example of store-side product sales information indicating information related to sold products. Store-side product sales information is accumulated at each store. The store-side product sales information is information used to grasp the sales status of products at each store, such as sales and the contents of sold products. As shown in FIG. 3, the store-side product sales information includes, for example, an individual product code (traceability code) used for searching for product history information, a sales management category indicating a product category in the store-side product sales information, It includes a POS number indicating a POS register used at the time of sales and a sales time indicating the time when the product was sold. Although not shown in FIG. 3, information such as the price of the corresponding product and a store code indicating the store where the product was sold is also included in the product sales information.

  The individual product code is a code that can specify the production / distribution history information of the corresponding product, and is a code printed on the product or product packaging as a search key in the traceability system. The product history information includes, for example, various information related to the product history such as the product producer, manufacturer, distributor, production location, production date, production date, product name, and store delivery date. Note that the number of digits of the traceability code may be any number, and the number of digits may be different depending on the type of product.

  The sales management category is a category that can be specified by the product production / distribution history information. In this example, the sales management category is specified by the product producer, manufacturer, distributor, or production location, and the product name. For example, in the case of vegetables, fruits, meat, etc., the category for sales management is determined by the production area and the product name, and in the case of processed products, the category for sales management is determined by the manufacturer, distributor, and product name.

  Specifically, the sales time may be the time when the individual product code or the POS code is read, or the time when the sales history of the product is registered in the product sales information. In this example, the sales time is stored to the second unit as shown in FIG. The sales time may consist of “year, day, minute, second”, “day, minute, second”, “minute, second”, “second” ] May be constituted only by.

  FIG. 4 is an explanatory diagram showing an example of sales management category list data. The sales management category list data is data indicating a list of available sales management categories, and is stored in the management server DB 11. As shown in FIG. 4, the sales management category list data is data indicating a list of sales management category names associated with the sales management category code.

  FIG. 5 is an explanatory diagram showing an example of master registration POS code correspondence information. The master registration POS code correspondence information is information indicating the correspondence relation of each master registration POS code set in the POS data of each store server included in the system 100, and is stored in the management server DB 11.

  The master registration POS code correspondence information is assigned in the POS system of the store A to the individual product code, the sales management category code indicating the sales management category into which the product to which the individual product code is assigned is classified. Master registration POS code (store A master registration POS code), the master registration POS code assigned to the product in the store B POS system (store B master registration POS code), and the product to store C POS code (store C master registration POS code) assigned in the POS system.

Next, the operation of the product information management system 100 of this example will be described.
FIG. 6 is a flowchart showing an example of product information management processing in the product information management system 100 of this example. Here, processing when the consumer X purchases the product Y at the store A will be described.

  In the merchandise information management process, first, the POS register 41A reads the in-store POS code attached to the merchandise Y that the consumer X desires to purchase in the store A according to the cashier's operation. The store server 20A acquires the in-store POS code read by the POS register 41 (step S101).

  The in-store POS code is a code such as a barcode attached to each product. The POS register 41A executes a process of reading the in-store POS code and transmitting it to the store server 20A by a code reader such as a barcode reader.

  Next, the POS register 41A reads the individual product code attached to the product Y in accordance with the cashier's operation. The store server 20A acquires the individual product code read by the POS register 41 (step S102). The POS register 41A executes a process of reading the individual product code and transmitting it to the store server 20A by a code reader such as a barcode reader. Note that the code reading device that reads the in-store POS code and the code reading device that reads the individual product code may be the same device or different devices.

  Next, the store server 20A refers to the POS data (see FIG. 2), and specifies a master registration POS code associated with the acquired in-store POS code (step S103).

  Then, the store server 20A transmits the specified master registration POS code and the acquired individual product code to the product information management server 10 (step S104).

  When the product information management server 10 receives the master registration POS code and the individual product code, it is associated with the received master registration POS code or individual product code from the product history information stored in the management server DB 11. Product history information is searched (step S105).

  Next, the product information management server 10 associates the master registration POS code, the individual product code, part or all of the retrieved product history information, and the store code indicating the store A here, which is a store. Sales information is generated and stored (step S106).

  Next, the merchandise information management server 10 refers to the master registration POS code correspondence information (see FIG. 5) and associates the sales management category code with the individual product code or the master registration POS code acquired from the store server 20A. If it is determined (that is, if the sales management category code has already been set), it is decided to classify into the sales management category indicated by the sales management category code (step S107). On the other hand, the merchandise information management server 10 does not have a sales management category code associated with the individual product code or master registration POS code acquired from the store server 20A (that is, the sales management category code has not yet been set). For example, the sales management category is newly determined based on the product history information searched in step S105 (step S107).

  When the sales management category is newly determined, the product information management server 10 determines the sales management category code associated with the determined sales management category, and sells the determined sales management category and sales management category code. While registering in the management category list data, the determined sales management category code is registered in the corresponding location of the individual product code from the store server 20A in the master registration POS code correspondence information.

  When newly determining a sales management category, the product information management server 10 determines according to a predetermined rule set in advance. For example, a new category for sales management will be defined based on the producer or production location and the product name in the product history information. Specifically, "XX farm milk" or "Hokkaido potato" To be determined.

  When the sales management category is determined, the product information management server 10 transmits the determined sales management category and the sales management category code indicating the sales management category to the store server 20A (step S108).

  Upon receipt of the sales management category and the sales management category code, the store server 20A receives the POS data of the product Y specified by the individual product code for the product Y, the in-store POS code, the product in the received sales management category. Store-side product sales information associated with the sales time of Y is registered, and the store-side product sales information stored in the store server 20A is updated (step S109). Further, if the store server 20A has not yet been registered in the correspondence table (for example, data similar to the data shown in FIG. 4) between the sales management category and the sales management category code provided by itself, the store server 20A receives the received sales management category. And a set of sales management category codes are registered in the correspondence table.

  As described above, the sales management category of the product Y sold at the store A is determined, and the product sales information of the product Y is registered. When the consumer X purchases a plurality of products at the store A, the above processing is repeatedly executed, and product sales information for each product is sequentially registered.

  In the above example, the individual product code is used. However, the product history information is searched and the sales management category is determined by using only the master registration POS code without using the individual product code. Also good.

  In the above example, the merchandise information management server 10 determines the sales management category and the sales management category code. However, it may be determined on the store server 20A side. In this case, the merchandise information management server 10 transmits predetermined category determination information used for determining the sales management category among the merchandise history information searched in step S105 to the store server 20A. The sales management category may be determined based on the received category determination information.

  As described above, in the above-described embodiment, the store server 20A acquires the in-store POS code assigned to the product purchased by the consumer, and is associated with the acquired in-store POS code. A store including at least a part of the product information specified by the acquired in-store POS code by specifying the master registration POS code that is specified, transmitting the specified master registration POS code to the product information management server 10 via the communication network 50 Store side product sales information. On the other hand, the merchandise information management server 10 identifies merchandise information of the merchandise from categories registered in advance based on the received master registration POS code, and merchandise sales information including at least a part of the identified merchandise information. Accumulate. With this configuration, it is possible to accurately grasp the relevance of codes used between multiple stores without unifying in-store codes, and smooth sales status between multiple stores and store chains. Can be tabulated.

  That is, since the product information is searched using the master registration POS code associated with the in-store POS code and managed for each store by the product information management server 10, the in-store POS code is used. Even if the code is changed at the store, the product information management server 10 can smoothly search for product information using the master registration POS code without any influence.

  In addition, as described above, the POS code given to the product purchased by the consumer and the individual product code given to the product are acquired and registered in advance based on the acquired individual product code. The product category is determined from the categories, the products sold in the determined category are classified, and the product sales information including the POS data specified by the acquired POS code is accumulated. Products can be classified into more detailed sales management categories and detailed information indicating the sales status can be collected, so that the sales status can be accurately grasped at the store. . In addition, since the function for determining the category from the individual product code is added to the POS system, it is not necessary to modify the POS category in the POS system, and a system capable of classifying products into detailed sales management categories. It can be constructed at low cost.

  In the above-described embodiment, the product sales information including the sales time in seconds when the product is sold is stored, so that the sales situation can be accurately grasped. That is, in the POS system, the sales time can generally be specified only in minutes, but according to the present system 100, the POS system itself can be specified in seconds without any modification. The sales situation can be accurately grasped at low cost.

  Moreover, in embodiment mentioned above, it is set as the structure which the merchandise information management server 10 matches with the POS code | cord | chord acquired from each store side, and individual goods code, and is registered into POS code corresponding | compatible information, and is provided to goods. Since the individual product code is registered in association with each POS code used for the product at each store where the product is sold, the POS code assigned to the same product at each store is stored. It becomes possible to grasp the correspondence. Therefore, for example, when a plurality of stores adopting different POS systems are merged, POS codes can be easily unified (for example, one store matches the other store).

  According to the present invention, it is useful to accurately grasp the relevance of codes used between a plurality of stores without unifying in-store codes, and to smoothly aggregate sales statuses among the plurality of stores. .

It is a block diagram which shows the example of a structure of the merchandise information management system which concerns on 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 shop side goods sales information. It is explanatory drawing which shows the example of the category list data for sales management. It is explanatory drawing which shows the example of master registration POS code corresponding | compatible information. It is a flowchart which shows the example of merchandise information management processing.

Explanation of symbols

10 Product Information Management Server 11 Management Server DB
20A, 20B Store server 41A-4NA, 41B-4NB POS register 50, 60A, 60B Communication network 100 Product information management system

Claims (10)

A product information management system including a store server to which a POS register is connected and a product information management server for managing product information,
The store server
A POS code that is master-registered on the product information management server side, and is a POS code that is initially set in association with a predetermined product in the corresponding store, and a POS system in the corresponding store An in-store POS that is a POS code that is currently used in association with a predetermined product, is a POS code that is associated with a master registration POS code that is initially set for the product and can be changed as appropriate at each store. POS data storage means for storing POS data including a code;
Stores store-side product sales information including a sales management category, which is a category that can be identified by product history information including the product producer and production location, and an individual product code used to search for product history information. Store-side product sales information storage means;
An in-store POS code acquisition means for acquiring an in-store POS code given to a product purchased by a consumer;
Master registration POS code specifying means for specifying a master registration POS code associated with the in-store POS code acquired by the in-store POS code acquisition means with reference to the POS data ;
Master registration POS code transmitting means for transmitting the master registration POS code specified by the master registration POS code specifying means to the product information management server via a communication network;
And a shop side product sales information storing means for storing information including at least a portion as the store merchandise sales information of the commodity information specified by the in-store POS code the in-store POS code acquiring unit has acquired,
The product information management server includes:
Master registration POS that stores master registration POS code correspondence information in which the individual registration code is associated with the master registration POS code associated with the in-store POS code used for the product at the store where the product is sold. Code correspondence information storage means;
A master registration POS code receiving means for receiving a master registration POS code;
Product history information search means for searching for product history information associated with the individual product code corresponding to the received master registration POS code ;
Product sales information storage means for storing product sales information including at least a part of the product history information searched by the product history information search means ,
At least one of the store server and the product information management server,
Sales management category determination means for determining a sales management category according to the product history information searched by the product history information search means according to a predetermined rule;
Product information management comprising: sales management category registration means for registering the sales management category determined by the sales management category determination means in association with the individual product code in the master registration POS code correspondence information. system. The product information management system according to claim 1 , wherein the POS data includes a POS category indicating a classification higher than the sales category with respect to a product, such as vegetables, meat, and moss . The product information management server includes:
Sales management category setting determination means for determining whether or not the sales management category is set in the master registration POS code received by the master registration POS code receiving means with reference to the master registration POS code correspondence information. Including
If the sales management category setting determination means determines that the sales management category is not set in the received master registration POS code, the merchandise history information search means corresponds to the received master registration POS code. Search the product history information associated with the code,
When the sales management category setting determination means determines that the sales management category is set in the received master registration POS code, the sales management category determination means sets the sales management category as the product history information. The merchandise information management system according to claim 1 or 2, wherein the sales management category is determined according to the category . The product information management system according to any one of claims 1 to 3, wherein the store-side product sales information storage unit stores store-side product sales information including a price of a product specified by an in-store POS code. The sales management category into which the sold product is classified is indicated by a producer, a production location, a manufacturer, or a selling source of the product and a product name of the product. The product information management system described in Crab. The store server to which the POS register is connected
An in-store POS code acquisition process for acquiring an in-store POS code assigned to a product purchased by a consumer;
A POS code that is master-registered on the product information management server side, and is a POS code that is initially set in association with a predetermined product in the corresponding store, and a POS system in the corresponding store An in-store POS that is a POS code that is currently used in association with a predetermined product, is a POS code that is associated with a master registration POS code that is initially set for the product and can be changed as appropriate at each store. The master registration POS code associated with the in-store POS code acquired in the in-store POS code acquisition process is referred to by referring to the POS data stored in the POS data storage means for storing the POS data including the code. Master registration POS code identification process to identify;
A master registration POS code transmission process for transmitting the master registration POS code identified in the master registration POS code identification process to a merchandise information management server that manages merchandise information via a communication network;
Stores store-side product sales information including a sales management category, which is a category that can be identified by product history information including the product producer and production location, and an individual product code used to search for product history information. the store side product sales information storage means, information shop side product sales to accumulate as the store merchandise sales information including at least a part of the product information specified by the in-store POS code acquired by the in-store POS code acquisition process Information storage processing,
The product information management server includes:
A master registration POS code reception process for receiving a master registration POS code;
A product history information search process for searching for product history information associated with the individual product code corresponding to the received master registration POS code ;
A product sales information storage process for storing product sales information including at least part of the product history information searched by the product history information search means ;
At least one of the store server and the product information management server further includes:
Sales management category determination processing for determining a sales management category according to the product history information searched in the product history information search processing according to a predetermined rule;
The master registration POS in which the sales management category determined in the sales management category determination process is associated with the individual product code and the in-store POS code used for the product at the store where the product is sold. A sales management category registration process for registering in association with the individual product code in the master registration POS code correspondence information stored in the master registration POS code correspondence information storage means for storing the master registration POS code correspondence information associated with the code; The product information management method characterized by performing . The product information management method according to claim 6 , wherein the POS data includes a POS category that indicates a classification higher than the sales category with respect to a product, such as vegetables, meat, and potatoes . The product information management server includes:
  Sales management category setting determination process for determining whether or not the sales management category is set in the master registration POS code received in the master registration POS code reception process with reference to the master registration POS code correspondence information Run
  If it is determined in the sales management category setting determination process that the sales management category is not set in the received master registration POS code, it corresponds to the received master registration POS code in the product history information search process. Execute the process to search the product history information associated with the individual product code,
  If it is determined in the sales management category setting determination process that a sales management category is set in the received master registration POS code, the sales management category determination process determines that the sales management category is the product. Execute the process to determine the category for sales management according to the history information
  The product information management method according to claim 6 or 7. The product information management method according to any one of claims 6 to 8 , wherein in the store-side product sales information accumulation process, store-side product sales information including a price of a product specified by an in-store POS code is accumulated. The sales management category into which the sold product is classified is indicated by a producer, a production location, a manufacturer, or a selling source of the product and a product name of the product. Product information management method described in Crab.

Images