JP2017151822A - Device, method and program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a common classification for integration analysis of selling history information from plural sellers.SOLUTION: A device comprises: a classification storage part for storing mapping between a common classification of selling objects common to plural shops, and individual classification of the selling objects in each shop of the plural shops; an individual classification acquisition part for acquiring an individual classification in one shop in the selling objects sold in one shop of the plural shops; a conversion part for referring to the classification storage part for converting the acquired individual classification into a corresponding common classification; and a history recording part for recording selling history information containing the common classification converted by the conversion part in a selling history database.SELECTED DRAWING: Figure 1

Description

  The present invention relates to an apparatus, a method, and a program.

There is known a method of accumulating a history of selling a sales object such as a product to a consumer and analyzing a consumption trend or the like (for example, see Patent Documents 1 to 4).
[Patent Document 1] JP 2013-235613 [Patent Document 2] JP 2014-219785 [Patent Document 3] JP 2013-109470 [Patent Document 4] JP 2008-522252 A

  In analyzing the history, classification information that appropriately classifies the sales target is required. However, the classification of products and the like may be different for each seller, which has been an obstacle to acquiring history from a plurality of sellers and analyzing them in an integrated manner.

  In the first aspect of the present invention, an apparatus for recording sales histories at a plurality of stores, the common classification of sales targets common to the plurality of stores, and the individual classification of sales targets at each of the plurality of stores A classification storage unit that stores associations with each other, an individual classification acquisition unit that acquires an individual classification in one store, and a classification storage unit for a sales target sold in one store among a plurality of stores A conversion unit that converts the acquired individual classification into a corresponding common classification, and a history recording unit that records sales history information including the common classification converted by the conversion unit in a sales history database, A method implemented by an apparatus and a program used for the apparatus are provided.

  The summary of the invention does not enumerate all the features of the present invention. In addition, a sub-combination of these feature groups can also be an invention.

1 shows a system 10 according to the present embodiment. An example of the processing flow of the apparatus 100 which concerns on this embodiment is shown. An example of the sales information which the individual classification acquisition part 110 acquires is shown. An example of the correspondence stored in the sales target master database 56 is shown. An example of an individual classification code is shown. Another example of an individual classification code is shown. An example of a common classification code is shown. An example of a correspondence relationship between an individual classification code, a common classification code, and a classification code is shown. 2 shows an exemplary configuration of a computer 1900 according to the present embodiment.

  Hereinafter, the present invention will be described through embodiments of the invention, but the following embodiments do not limit the invention according to the claims. In addition, not all the combinations of features described in the embodiments are essential for the solving means of the invention.

  FIG. 1 shows a system 10 according to this embodiment. The system 10 acquires sales information from a plurality of stores that sell the sales target, and records sales histories at the plurality of stores based on the sales information. The system 10 includes a plurality of store terminals 40, a sales history database 44, a history management server 46, a sales target master database 56, and an apparatus 100.

  The store terminal 40 is provided in a store 42 of a seller that sells products and / or services (also referred to as “sales target”), and one or more stores are connected to the apparatus 100 via the network 43, and the POS A terminal or a computer having an equivalent function.

  Here, the plurality of stores 42 may be stores of different sellers. For example, the plurality of stores 42 are a convenience store operated by one or a plurality of distributors (for example, a franchisor or a store management company), a restaurant operated by one or a plurality of distributors, and one or a plurality of sales. A supermarket operated by a vendor, a drug store operated by one or more vendors, a department store operated by one or more vendors, a drug store operated by one or more vendors, one or more sales Gas stations operated by vendors, rental shops operated by one or more vendors, recycling shops operated by one or more vendors, and other stores operated by one or more vendors / May include at least some of the service providers, each with a different sales It may have a classification of. Here, the classification of the sales object for each store 42 is an individual classification. The individual classification may be different for each store 42.

  When the store terminal 40 sells a sales target at the store 42, the store terminal 40 transmits sales information including information related to the sales target to the device 100. For example, the store terminal 40 may transmit sales information including the purchaser's ID, the name of the sales target, and the individual classification indicating the classification of the sales target in the store 42 to the device 100.

  The sales history database 44 receives the sales history information including the common classification of the sales object common to a plurality of stores converted from the individual classification for each store 42 by the apparatus 100 from the apparatus 100 and stores it.

  The history management server 46 is a computer such as a server computer, and is connected to the store terminal 40 and the device 100 via the network 43 and manages one or a plurality of store terminals 40 provided in each store. The history management server 46 performs sales processing based on the sales history information transmitted from the device 100 and records the sales history information in the sales history database 44. For example, for each sales process, the history management server 46 receives the sales history information including the purchaser ID, the name of the sales target, the common classification of the sales target, etc. from the apparatus 100 and stores it in the sales history database 44. Good.

  The network 43 includes various networks such as the Internet, a wide area network (WAN), a local area network, or a combination thereof. The network 43 may include a connection by at least one of a wired network and a wireless network at each connection point.

  The sales target master database 56 includes a sales target code used centrally by a plurality of vendors for identifying sales targets, a classification code used centrally by a plurality of vendors for classifying sales targets, and / or Alternatively, the association with the classification name is stored. For example, the sales target master database 56 stores a JIC (Japan Article Number Number) code and a JICFS / IFDB (JAFS (Jan Item Code File Service) master name and / or classification code of a sales target in association with each other. Jan Item Code File Service / Integrated Flexible Data Base (hereinafter also simply referred to as JICFS).

  The network 58 includes various networks such as the Internet, a wide area network (WAN), a local area network, or a combination thereof. The network 58 may include a connection by at least one of a wired network and a wireless network at each connection point. For example, the network 58 may be realized by the Internet.

  Here, the network 43 may be realized by a dedicated line separated from the network 58. The network 43 and the network 58 may be the same network (for example, the Internet).

  The apparatus 100 is a computer such as a server computer, and is used for recording sales histories at a plurality of stores 42. For example, the apparatus 100 generates a sales history including a common classification of a sales target common to a plurality of stores from sales information including different individual classifications received from the plurality of stores 42 and stores the sales history in the sales history database 44. The apparatus 100 includes an individual classification acquisition unit 110, a classification storage unit 130, a conversion unit 150, a history recording unit 170, an input unit 180, and a correspondence change unit 190.

  The individual classification acquisition unit 110 acquires sales information from each of the plurality of stores 42. For example, the individual classification acquisition unit 110 is a sales target sold at one store 42 from the store terminal 40 of one store 42 among the plurality of stores 42 (for example, sales target “Konbu soy sauce 100 ml manufactured by XX Co.”). ) Of sales information at the one store. The individual classification acquisition unit 110 acquires, for a sales target sold at one store 42, sales information including an individual classification that can be used for the classification of the sales target at one store 42.

  For example, the individual classification acquisition unit 110 uses, as an individual classification, an individual classification code that is a classification of a sales target in one store 42 (for example, a seasoning classification “FDSNSS” for a sales target “manufactured kelp soy sauce 100 ml”). , At least one of individual sales target codes (for example, a 13-digit numeric code “491xxxxxxxxxxxx” identifying the sales target “Konbu Soy Sauce 100 ml” manufactured by XX Co., Ltd.)) that is the identification information of the sales target sold in one store 42 Sales information including one may be acquired. The individual classification acquisition unit 110 supplies the acquired sales information to the conversion unit 150.

  The classification storage unit 130 stores a correspondence between a common classification of sales targets common to the plurality of stores 42 and an individual classification of sales targets in each of the plurality of stores 42. The common classification is at least partially common to the classification code of the sales target master database 56 (for example, the classification code of JICFS), and may have a common classification code indicating the common classification of the sales target. The common classification may have a common classification name that is at least partially in common with the classification name of the sales target master database 56 (for example, the classification name of JICFS).

  For example, the classification storage unit 130 stores the common classification code and / or common classification name of the sales object and the individual classification code indicating the individual classification of the sales object in association with each other as the first association. The user of the apparatus 100 acquires individual classification codes of a plurality of stores 42 from the seller of each store 42, generates a common classification in advance based on the JICFS classification, etc., and uses the acquired individual classification code and the previously generated common classification. Based on this, the first association may be determined and stored in the classification storage unit 130 in advance.

  In addition, for example, the classification storage unit 130 associates the individual sales target code for identifying the sales target as the individual classification with the common classification of the sales target specified by the individual sales target code as the second correlation. May be memorized. The user of the apparatus 100 acquires the individual sales target codes of the plurality of stores 42 from the seller of each store 42, generates a common classification in advance based on the JICFS classification and the like, and the generated common sales target code and the common generated in advance. The second association may be determined based on the classification and stored in the classification storage unit 130 in advance.

  The classification storage unit 130 may store the association between the individual sales target code for identifying the sales target as the individual classification and the individual classification code specified by the individual sales target code as the third association. The user of the device 100 may acquire information on the third association relating to the plurality of stores 42 from the seller of each store 42 and store it in the classification storage unit 130 in advance.

  The conversion unit 150 refers to the classification storage unit 130 and converts the acquired individual classification into a corresponding common classification. For example, the conversion unit 150 uses the first association in the classification storage unit 130 to convert the individual classification code in one store 42 to be sold into a corresponding common classification. For example, the conversion unit 150 converts the individual classification code into a common classification code indicating a common classification in all of the plurality of stores 42 to be sold.

  In addition, for example, the conversion unit 150 refers to the third association in the classification storage unit 130 and converts the individual sales target code included in the individual classification in one sales target store 42 into a corresponding individual classification code. . Further, the conversion unit 150 converts the individual classification code converted using the first association in the classification storage unit 130 into a corresponding common classification code.

  Further, for example, the conversion unit 150 refers to the classification storage unit 130 and converts the individual sales target code at one store 42 to be sold into the corresponding common classification code using the second association. It's okay. As a result of referring to the classification storage unit 130, the conversion unit 150 may supply the one individual classification to the correspondence changing unit 190 when there is no common classification corresponding to the individual classification in one store 42 to be sold. The conversion unit 150 generates sales history information including at least a part of the common classification and sales information obtained by the conversion, and supplies the sales history information to the history recording unit 170.

  Further, the conversion unit 150 may query the sales target master database 56 for a sales target code (for example, a JAN code included in JICFS) corresponding to the individual sales target code in one sales target store 42. . When there is a sales target code corresponding to the individual sales target code, the conversion unit 150 classifies the classification code corresponding to the sales target code (for example, the classification code corresponding to the sales target code (JAN code) on JICFS) or the classification The name may be acquired from the sales target master database 56 and used as a common classification code.

  The history recording unit 170 records the sales history information including the common classification converted by the conversion unit 150 in the sales history database 44. For example, for the sales target sold at one store 42, the history recording unit 170 stores the sales information including the purchaser's ID, the name of the sales target, the sales date and time, the sales location, and the like. The common classification code converted from the classification may be acquired from the conversion unit 150, and these pieces of information may be recorded in the sales history database 44 via the history management server 46 as sales history information about the sales target.

  The input unit 180 inputs an instruction from the user of the device 100. For example, the input unit 180 instructs to change the correspondence relationship in the first to third associations stored in the classification storage unit 130 and / or generates a new correspondence relationship in the first to third associations. Enter instructions. The input unit 180 supplies the input instruction to the correspondence changing unit 190.

  The correspondence changing unit 190 changes the correspondence relationship between the common classification and the individual classification in the classification storage unit 130 in accordance with an instruction from the user input to the input unit 180. In addition, when the conversion unit 150 refers to the classification storage unit 130 and there is no common classification corresponding to one individual classification, the correspondence changing unit 190 selects a new common classification corresponding to the one individual classification. You may remember.

  As described above, according to the apparatus 100 of the present embodiment, the individual classification of the sales target that is included in the sales information and is different for each store 42 is converted into the common classification, and the common classification is stored in the sales history database 44 and accumulated. be able to. Therefore, according to the apparatus 100, it is possible to analyze the sales history information of the sales target in a plurality of different stores 42 in an integrated manner by the common classification.

  The one or more elements included in the system 10 may be a distributed system using a plurality of computers. For example, the history management server 46 and the device 100 may each be realized by a plurality of computers. A plurality of elements included in the system 10 may be realized by a single computer. For example, at least a part of the functions of the history management server 46 and at least a part of the functions of the apparatus 100 may be realized by one computer.

  FIG. 2 shows an example of a processing flow of the apparatus 100 according to the present embodiment. The apparatus 100 converts the individual classification into the common classification by executing the processes of S110 to S230, and records the sales history information including the common classification.

  First, in S <b> 110, the individual classification acquisition unit 110 acquires sales information of a sales target sold in one store 42 from the store terminal 40 of one store 42. For example, the individual classification acquisition unit 110 sells information related to sales to be sold and can be used for analysis of purchase tendency of the purchaser and / or marketing for the purchaser together with the individual classification. Obtain as information.

  As an example, the individual classification acquisition unit 110 includes purchaser identification information (for example, an ID of a membership card presented by the purchaser), a name of a sales target (for example, a product name), and the store terminal 40 to be sold. Sales information including individual classification, sales date and time, sales store, sales volume, sales price, discount information, purchaser attributes (for example, gender and age group), etc. You may acquire from store terminal 40.

  FIG. 3 shows an example of sales information acquired by the individual classification acquisition unit 110. As illustrated, the individual classification acquisition unit 110, as an example of sales information, purchaser identification information (customer ID: xxxxxxxx), sales date (20xx year xx month xx date), and sales store (convenience store A ○ ○ Stores may be acquired for each sales process. The individual classification acquisition unit 110 also acquires sales information including the individual classification for each of one or a plurality of sales objects sold in each sales process. For example, the individual classification acquisition unit 110 acquires sales information including individual sales target codes for each sales target as the individual classification of each sales target sold.

  Here, the individual sales target code may be identification information given to each sales target for each of the plurality of stores 42 or for each seller of the plurality of stores 42. For example, the individual sales target code used in at least one store 42 may be a JAN code used in JICFS. In addition, the individual sales target code used in at least one store 42 may include an identification code (also referred to as “JAN similar code”) in which a code is assigned in a format according to the JAN code for a classification that does not exist in JICFS. Further, the individual sales target code used in at least one store 42 may include an identification code unique to the store 42 that is not related to the JAN code. Further, the individual sales target code used in at least one store 42 may include the name of the sales target in the one store 42. In this case, the sales information of the sales target may include the name of the sales target separately from the individual classification.

  Here, when the number of digits of the identification code used for identifying the sales object is small, the identification code assigned to the product at a certain store 42 is accidentally identified with the same or different product used at another store 42. May match the code. For example, the identification code (123456) assigned to “PB milk 500 ml” at convenience store A may match the identification code (123456) assigned to “20 headache drugs” at drug store B. Therefore, the individual classification acquisition unit 110 stores the identification code of the sales object received from the store 42 (for example, 123456 for 500 ml of PB milk) in order to prevent duplication of the identification code between different stores 42. 42 (for example, 30000123456) to which the store identification code assigned to 42 (for example, 30000 for convenience store A) is added may be acquired as the individual sales target code.

  In FIG. 3, the individual classification acquisition unit 110 acquires the individual sales target code (identification code 4911xxxxxxxx), the sales quantity (2 pieces), and the sales amount (400 yen) for the first product as sales information. The individual sales target code (identification code 4915xxxxxxxx), the sales quantity (100 g), and the sales price (150 yen) for the second product are acquired as sales information. Hereinafter, a case where the individual classification acquisition unit 110 acquires an individual sales target code as an individual classification of each sales target will be described as an example. The individual classification acquisition unit 110 supplies the sales information including the acquired individual sales target code to the conversion unit 150.

  Subsequent to S110, the apparatus 100 executes the loop processing shown in S130 to S210 for each sales target included in the sales information. For example, when the sales information includes a first sales target and a second sales target, the apparatus 100 performs the processing of S130 to S210 for the first sales target, and further, S130 to S210 for the second sales target. Execute the process.

  In S <b> 130, the conversion unit 150 determines whether the individual sales target code in the sales target store 42 included in the sales information acquired in S <b> 110 is registered as a sales target code in the sales target master database 56 outside the device 100. Confirm. For example, the conversion unit 150 checks whether there is a JAN code included in the JICFS of the sales target master database 56 that matches an individual sales target code (for example, an identification code 4911xxxxxxxx).

  FIG. 4 shows an example of the correspondence stored in the sales target master database 56. In this example, the sales target master database 56 stores associations between JAN codes used as identification information for products and the like by a plurality of distributors and JICFS classification codes having a hierarchical structure. As an example, the sales target master database 56 has a large classification “category name: food / classification code: 100000” and a middle classification “classification name: processed food / classification code: 110000” for a JAN code assigned to a certain soy sauce product. ”And the subcategory“ category name: seasoning / category code: 110100 ”and the subcategory“ category name: soy sauce / category code: 110101 ”stored in association with each other and stored in the JAN code assigned to the beer beverage On the other hand, it is subordinate to the large classification “classification name: food / classification code: 100,000”, the middle classification “classification name: beverage / kind / classification code: 140000”, and the small classification “classification name: alcoholic beverage / classification code: 140600”. The subcategory “classification name: beer / classification code: 140641” is stored in association with each other.

  Next, in S150, the process branches based on the confirmation result in S130. For example, when the individual sales target code acquired in S110 is registered in the sales target master database 56, the conversion unit 150 advances the process to S160. When the individual sales target code is not registered in the sales target master database 56, the conversion unit 150 advances the processing to S170.

  In S160, the conversion unit 150 converts the individual sales object code included in the sales information acquired in S110 into a classification code based on the sales object master database 56. For example, the conversion unit 150 refers to the association between the sales target code and the classification code and / or the classification name stored in the sales target master database 56, and corresponds to the individual sales target code included in the sales information acquired in S110. A classification code (for example, “110101”) and / or a classification name (for example, “soy sauce”) on JICFS is acquired. The conversion unit 150 uses the classification code obtained by the conversion as a common classification code.

  A seller who operates and manages the store 42 may adopt JICFS, a classification system including at least a part or all of JICFS, or a classification system similar to JICFS as a classification of sales targets. According to the apparatus 100 of this embodiment, the classification code etc. corresponding to the sales object by such a seller can be acquired by the process of S160.

  In S <b> 170, the conversion unit 150 converts the classification storage unit 130 into the individual classification code from the individual sales target code in one store 42 to be sold. For example, the conversion unit 150 refers to the third association in the classification storage unit 130 and converts the individual sales target code into the individual classification code. Thereby, the conversion unit 150 obtains an individual classification code used for classifying the sales target at the one store from the individual sales target code used for identifying the sales target at the one store 42.

  FIG. 5 shows an example of the individual classification code. For example, a distributor (for example, convenience store A) that operates at least one of the plurality of stores 42 is an individual in which sales targets are classified in a system different from the classification such as JICFS stored in the sales target master database 56. Use classification codes.

  In the example of FIG. 5, for the canned beer product, the lower level of the large classification “individual classification name: beverage / individual classification code: DR00000” and the middle classification “individual classification name: beer / individual classification code: DRBR000”. Is assigned a small classification “Individual classification name: canned beer / Individual classification code: DRBR001”, and for soy sauce products, a large classification “Individual classification name: Food / Individual classification code: FD0000” and medium classification A small classification “individual classification name: seasoning / individual classification code: FDSNSS” located in a lower hierarchy of “individual classification name: seasoned food / individual classification code: FDSN00” is assigned.

  FIG. 6 shows another example of the individual classification code. For example, another seller (for example, drugstore B) that operates at least one of the plurality of stores 42 has a classification system different from the classification such as JICFS stored in the sales target master database 56 and the classification of FIG. , Use the individual classification code that classifies the sales target.

  In the example of FIG. 6, for canned beer products sold for each can, a large classification “individual classification name: sake / individual classification code: AL0000” and a middle classification “individual classification name: beer / individual classification”. A small classification “Individual Classification Name: Single Can / Individual Classification Code: ALBE01”, which is located in the lower hierarchy of “Code: ALBE00”, is assigned. For soy sauce products, a large classification “Individual Classification Name: Food / Individual Classification Code: “FO0000” and medium classification “Individual classification name: general food / individual classification code: FOFD00” Subordinate classification “Individual classification name: soy sauce, soy sauce, dashi, miso / individual classification code: FOFD21” are assigned. It is done.

  For example, in S170, the conversion unit 150 converts the individual sales target code into one of the individual classification codes located in the lower classification of the lowest layer in the classification of FIG. 5 or FIG.

  Next, in S180, the conversion unit 150 checks whether or not the individual classification code converted in S170 can be converted into a common classification common to the plurality of stores 42. For example, in the first association in the classification storage unit 130, the conversion unit 150 sets the common classification code and / or common classification name corresponding to the individual classification code converted in S190 to the first association in the classification storage unit 130. It is confirmed whether it is included in. If it is determined that the individual classification code can be converted into the common classification, the conversion unit 150 advances the process to S210. If not, the conversion unit 150 supplies the individual classification code to the correspondence change unit 190 and advances the process to S200. .

  In S <b> 200, the correspondence change unit 190 generates a new common classification corresponding to one individual classification code received from the conversion unit 150, adds it to the first association, and stores it in the classification storage unit 130. For example, the correspondence changing unit 190 identifies, as an approximate common classification code, a common classification code in which another individual classification code having the same upper classification as that of one individual classification code is associated in the first association, A new common classification code is generated in the lower hierarchy of the upper hierarchy to which the common classification code belongs.

  As an example, it is sold at the store 42 of the drug store B, and the small classification FOFD21 (soy sauce, soy sauce, dashi, miso) of the lower level of the medium classification FOFD00 (general food) is assigned as the individual classification code (B) of the drug store B The soy sauce produced will be described as an example. Here, there is no appropriate classification code corresponding to the individual classification code: FOFD21 (soy sauce, soy sauce, dashi, miso) (for example, the classification code of the fine classification of JICFS), and it corresponds in the first association of the classification storage unit 130 It is assumed that no common classification code exists.

  In this case, first, the correspondence changing unit 190 sets the individual classification code: FOFD31 of another product assigned to the middle classification FOFD00 (general food) of the upper hierarchy of the individual classification code: FOFD21 (soy sauce, soy sauce, dashi, miso). Common salt code: 110109 (salt) assigned to (salt) in the first association is specified as an approximate common classification code, and upper layer classification of the approximate common classification code: 110100 (seasoning) lower layer A new common classification code: 110199 (seasoning / unknown) may be generated.

  Further, the correspondence changing unit 190 is another individual classification code that is not associated with the common classification code, and has the same upper layer classification (for example, the middle classification FOFD00) as the individual classification code that has already generated a new common classification code. (That is, when a new common classification code is to be generated in duplicate), instead of generating a new common classification code, the generated new common classification code: 110199 The individual classification code may be associated with (seasoning / unknown). As a result, the apparatus 100 collects the sales objects into one classification when the common classification code is not associated with the individual classification code and / or when there is no appropriate common classification code for the individual classification code. Sales history information can be recorded.

  FIG. 7 shows an example of the common classification code in this embodiment. The classification storage unit 130 may store the classification code of the sales target master database 56 illustrated in FIG. 4 and the common classification code generated by the correspondence changing unit 190 in S200. In the example of FIG. 7, a common classification code of “seasoning / unknown (110199)” is added to the subcategory of the subcategory: “seasoning (110100)” with respect to the classification of JICFS illustrated in FIG. 4. Subclass: A common classification code of “alcoholic / unknown (110499)” is added to the subclass of “alcoholic beverage (140600)”. As described above, the classification storage unit 130 assigns and stores a new common classification code for individual classifications that are not associated with conventional classifications such as JICFS.

  In S210, the conversion unit 150 converts the individual classification code converted in S190 into a common classification common to the plurality of stores 42. For example, the conversion unit 150 may convert the individual classification code into the common classification code and / or the common classification name with reference to the first association in the classification storage unit 130. That is, the conversion unit 150 converts the individual sales target code in one sales target store 42 into a common classification such as a common classification code by executing the processes of S190 to S210.

  FIG. 8 shows an example of the correspondence relationship between the common classification code, the individual classification code, and the classification code. The common classification may include a part or all of a classification such as JICFS stored in the sales target master database 56. For example, the classification storage unit 130 holds the same code “140631” as the classification code “140631” of “beer” in JICFS as a common classification code, and stores this as the individual classification code (A) “DRBR001 (can) of convenience store A "Corresponding to beer)", and the individual classification code (B) of convenience store B "ALBE01 (corresponding to a single can)" and "ALBE11 (corresponding to 6 can packs)" are correlated as the first correlation You may remember.

  Furthermore, a classification not included in the classification stored in the sales target master database 56 may be included. For example, the classification storage unit 130 stores a common classification code that does not exist in the classification code in association with the individual classification code in a hierarchy corresponding to the lowest hierarchy of the classification code. In the example of FIG. 8, the individual classification code (A) of the convenience store A shown in FIG. 5 and the classification code matching the “FDSNSS (corresponding to“ seasoning ”)” and the individual of the drug store B shown in FIG. A classification code that matches the classification code (B) “FODF21 (corresponding to“ soy sauce, soy sauce, dashi, miso ”)” exists in the lowest hierarchy (fine classification) such as JIFCS stored in the sales target master database 56 do not do.

  The classification storage unit 130 corresponds to the individual classification code (A) “FDSNSS (corresponding to“ seasoning ”)” and the individual classification code (B) “FODF21 (corresponding to“ soy sauce / tsuyu / dashi / miso ”)”. Subsequently, the common classification code “110199 (“ condiment / unknown ”)” is stored in the hierarchy corresponding to the lowest hierarchy (fine classification) of the classification code. Thereby, even if there is no classification corresponding to the individual classification code (for example, “FDSNSS” on JICFS), the conversion unit 150 can convert the individual classification code into a common classification code or the like.

  In S230, the history recording unit 170 records the sales history information including the common classification in the sales history database 44. For example, the conversion unit 150 replaces the individual classification included in the sales information of the sales target acquired from the individual classification acquisition unit 110 with the common classification, and adds a part or all of the sales information of the sales target excluding the individual classification. The sales history information is supplied to the history recording unit 170.

  As an example, the conversion unit 150 includes the purchaser's identification information, the name of the sales target, the common classification code or the common classification name of the sales target, the sales date / time, the sales store, the sales quantity, the sales amount, the discount information, and the purchaser's Sales history information including attributes and the like may be supplied to the history recording unit 170. The history recording unit 170 records the sales history information received from the conversion unit 150 in the sales history database 44.

  Thus, the apparatus 100 of this embodiment receives the sales information of the sales object sold at one store 42 from the store terminal 40 by executing the processing of S110 to S230, and selects the individual classification included in the sales information. The sales history information including the common classification is stored in the sales history database 44 after conversion into the common classification. In particular, in the example of FIG. 2, the apparatus 100 receives the individual sales target code of the sales target as the individual classification, and uses the individual sales target code at the one store 42 using the third association of the classification storage unit 130. The individual classification code is converted into a common classification code using the first association of the classification storage unit 130, and the sales history information including the common classification code is stored in the sales history database 44. .

  Instead, the individual classification acquisition unit 110 of the apparatus 100 receives the sales information including the individual classification code of the sales target used in the store 42 as the individual classification from the store terminal 40, and the conversion unit 150 stores the sales information in the classification storage unit 130. The individual classification code may be converted into a common classification code or the like using the stored first association. In addition, the individual classification acquisition unit 110 of the device 100 receives sales information including the individual sales target code at the one sales target store 42 as the individual classification from the store terminal 40, and the conversion unit 150 is stored in the classification storage unit 130. The individual sales target code may be directly converted into a common classification code using the second association.

  In FIG. 2, it has been described that the device 100 processes one piece of sales information from one store 42, but the device 100 may process a plurality of pieces of sales information from a plurality of stores 42.

  FIG. 9 shows an example of the configuration of a computer 1900 according to this embodiment. A computer 1900 according to this embodiment functions as the apparatus 100. In addition, the computer connected to the network 43 as the store terminal 40 and / or the history management server 46 may have the same configuration as the computer 1900.

  A computer 1900 according to this embodiment is connected to a CPU peripheral unit having a CPU 2000, a RAM 2020, a graphic controller 2075, and a display device 2080 that are connected to each other by a host controller 2082, and to the host controller 2082 by an input / output controller 2084. An input / output unit having a communication interface 2030, a hard disk drive 2040, and a DVD drive 2060, a ROM 2010 connected to an input / output controller 2084, a flash memory drive 2050, and a legacy input / output unit having an input / output chip 2070. .

  The host controller 2082 connects the RAM 2020 to the CPU 2000 and the graphic controller 2075 that access the RAM 2020 at a high transfer rate. The CPU 2000 operates based on programs stored in the ROM 2010 and the RAM 2020 and controls each unit. The graphic controller 2075 acquires image data generated by the CPU 2000 or the like on a frame buffer provided in the RAM 2020 and displays it on the display device 2080. Instead of this, the graphic controller 2075 may include a frame buffer for storing image data generated by the CPU 2000 or the like.

  The input / output controller 2084 connects the host controller 2082 to the communication interface 2030, the hard disk drive 2040, and the DVD drive 2060, which are relatively high-speed input / output devices. The communication interface 2030 communicates with other devices via a network by wire or wireless. The communication interface functions as hardware that performs communication. The hard disk drive 2040 stores programs and data used by the CPU 2000 in the computer 1900. The DVD drive 2060 reads a program or data from the DVD 2095 and provides it to the hard disk drive 2040 via the RAM 2020.

  The input / output controller 2084 is connected to the ROM 2010, the flash memory drive 2050, and the relatively low-speed input / output device of the input / output chip 2070. The ROM 2010 stores a boot program that the computer 1900 executes at startup and / or a program that depends on the hardware of the computer 1900. The flash memory drive 2050 reads a program or data from the flash memory 2090 and provides it to the hard disk drive 2040 via the RAM 2020. The input / output chip 2070 connects the flash memory drive 2050 to the input / output controller 2084 and inputs / outputs various input / output devices via, for example, a parallel port, a serial port, a keyboard port, a mouse port, and the like. Connect to controller 2084.

  A program provided to the hard disk drive 2040 via the RAM 2020 is stored in a recording medium such as a flash memory 2090, a DVD 2095, or an IC card and provided by a user. The program is read from the recording medium, installed in the hard disk drive 2040 in the computer 1900 via the RAM 2020, and executed by the CPU 2000.

  A program installed in the computer 1900 and causing the computer 1900 to function as at least a part of the apparatus 100 includes at least one of an individual classification acquisition module, a conversion module, a history recording module, an input module, and a correspondence change module. These programs or modules may work on the CPU 2000 or the like to cause the computer 1900 to function as the individual classification acquisition unit 110, the conversion unit 150, the history recording unit 170, the input unit 180, and the correspondence change unit 190, respectively.

  When the information processing described in these programs is read into the computer 1900, it works on the CPU 2000 or the like, which is a specific means in which the software and the various hardware resources described above cooperate, and the computer 1900 is individually It functions as a classification acquisition unit 110, a conversion unit 150, a history recording unit 170, an input unit 180, and a correspondence change unit 190. And the specific apparatus 100 according to the intended use is constructed | assembled by implement | achieving the calculation or processing of the information according to the intended use of the computer 1900 in this embodiment by these specific means.

  As an example, when communication is performed between the computer 1900 and an external device or the like, the CPU 2000 executes a communication program loaded on the RAM 2020 and executes a communication interface based on the processing content described in the communication program. A communication process is instructed to 2030. Under the control of the CPU 2000, the communication interface 2030 reads transmission data stored in a transmission buffer area or the like provided on a storage device such as the RAM 2020, the hard disk drive 2040, the flash memory 2090, or the DVD 2095, and transmits it to the network. Alternatively, the reception data received from the network is written into a reception buffer area or the like provided on the storage device. As described above, the communication interface 2030 may transfer transmission / reception data to / from the storage device by a DMA (direct memory access) method. Instead, the CPU 2000 transfers the storage device or the communication interface 2030 as a transfer source. The transmission / reception data may be transferred by reading the data from the data and writing the data to the communication interface 2030 or the storage device of the transfer destination.

  Further, the CPU 2000 DMAs all or necessary portions of files or databases stored in an external storage device such as the hard disk drive 2040, the DVD drive 2060 (DVD 2095), the flash memory drive 2050 (flash memory 2090), or the like. The data is read into the RAM 2020 by transfer or the like, and various processes are performed on the data on the RAM 2020. Then, CPU 2000 writes the processed data back to the external storage device by DMA transfer or the like. In such processing, since the RAM 2020 can be regarded as temporarily holding the contents of the external storage device, in the present embodiment, the RAM 2020 and the external storage device are collectively referred to as a memory, a storage unit, or a storage device. The classification storage unit 130 may be realized by such an external storage device or the like.

  For example, the storage unit of the apparatus 100 appropriately stores data received from and / or provided to the individual classification acquisition unit 110, the conversion unit 150, the history recording unit 170, the input unit 180, and the correspondence change unit 190. Good. For example, the storage unit may receive and store the individual classification that the individual classification acquisition unit 110 supplies to the conversion unit 150.

  Various types of information such as various programs, data, tables, and databases in the present embodiment are stored on such a storage device and are subjected to information processing. Note that the CPU 2000 can also store a part of the RAM 2020 in the cache memory and perform reading and writing on the cache memory. Even in such a form, the cache memory bears a part of the function of the RAM 2020. Therefore, in the present embodiment, the cache memory is also included in the RAM 2020, the memory, and / or the storage device unless otherwise indicated. To do.

  In addition, the CPU 2000 performs various operations, such as various operations, information processing, condition determination, information search / replacement, etc., described in the present embodiment, specified for the data read from the RAM 2020 by the instruction sequence of the program. Is written back to the RAM 2020. For example, when performing the condition determination, the CPU 2000 determines whether or not the various variables shown in the present embodiment satisfy the conditions such as large, small, above, below, equal, etc., compared to other variables or constants. If the condition is satisfied (or not satisfied), the program branches to a different instruction sequence or calls a subroutine.

  Further, the CPU 2000 can search for information stored in a file or database in the storage device. For example, in the case where a plurality of entries in which the attribute value of the second attribute is associated with the attribute value of the first attribute are stored in the storage device, the CPU 2000 displays the plurality of entries stored in the storage device. The entry that matches the condition in which the attribute value of the first attribute is specified is retrieved, and the attribute value of the second attribute that is stored in the entry is read, thereby associating with the first attribute that satisfies the predetermined condition The attribute value of the specified second attribute can be obtained.

  In addition, when a plurality of elements are listed in the description of the embodiment, elements other than the listed elements may be used. For example, when “X executes Y using A, B, and C”, X may execute Y using D in addition to A, B, and C.

  As mentioned above, although this invention was demonstrated using embodiment, the technical scope of this invention is not limited to the range as described in the said embodiment. It will be apparent to those skilled in the art that various modifications or improvements can be added to the above-described embodiment. It is apparent from the scope of the claims that the embodiments added with such changes or improvements can be included in the technical scope of the present invention.

  The order of execution of each process such as operations, procedures, steps, and stages in the apparatus, system, program, and method shown in the claims, the description, and the drawings is particularly “before” or “prior to”. It should be noted that the output can be realized in any order unless the output of the previous process is used in the subsequent process. Regarding the operation flow in the claims, the description, and the drawings, even if it is described using “first”, “next”, etc. for convenience, it means that it is essential to carry out in this order. It is not a thing.

DESCRIPTION OF SYMBOLS 10 System 40 Store terminal 42 Store 43 Network 44 Sales history database 46 History management server 56 Sales object master database 58 Network 100 apparatus 110 Individual classification acquisition part 130 Classification memory | storage part 150 Conversion part 170 History recording part 180 Input part 190 Corresponding change part 1900 Computer 2000 CPU
2010 ROM
2020 RAM
2030 Communication interface 2040 Hard disk drive 2050 Flash memory drive 2060 DVD drive 2070 Input / output chip 2075 Graphic controller 2080 Display device 2082 Host controller 2084 Input / output controller 2090 Flash memory 2095 DVD

Claims (12)

An apparatus for recording sales histories at a plurality of stores,
A classification storage unit that stores a correspondence between a common classification of sales objects common to the plurality of stores and an individual classification of the sales objects in each of the plurality of stores;
An individual classification acquisition unit that acquires an individual classification in the one store for a sales target sold in one of the plurality of stores;
A conversion unit that refers to the classification storage unit and converts the acquired individual classification into the corresponding common classification;
A history recording unit that records the sales history information including the common classification converted by the conversion unit in a sales history database;
A device comprising: The classification storage unit stores a common classification code indicating the common classification of the sales target in association with an individual classification code indicating the individual classification,
The individual classification acquisition unit acquires sales information including an individual classification code in the one store of the sales target sold in the one store,
The apparatus according to claim 1, wherein the conversion unit converts the individual classification code into a corresponding common classification code. The individual classification acquisition unit acquires sales information including an individual sales target code in the one store to be sold in the one store,
The classification storage unit stores a common classification code indicating the common classification of the sales target and an individual classification code indicating the individual classification in association with each other, and an individual sales target code for identifying the sales target as the individual classification; Storing the correspondence with the individual classification code specified by the individual sales target code;
The conversion unit refers to the classification storage unit, converts the individual sales target code in the one store to be sold into the corresponding individual classification code, and converts the converted individual classification code into the corresponding common classification code Convert to
The apparatus of claim 1. The individual classification acquisition unit acquires sales information including an individual sales target code in the one store to be sold in the one store,
The classification storage unit stores an association between an individual sales target code for identifying a sales target as the individual classification and a common classification code of a sales target specified by the individual sales target code,
The conversion unit refers to the classification storage unit and converts the individual sales target code in the one store to be sold into the corresponding common classification code.
The apparatus of claim 1. The individual classification includes a name in the one store to be sold,
The apparatus according to claim 3 or 4. The converter is
Whether the individual sales target code in the one store of the sales target is registered as a sales target code in an external sales target master database that stores correspondence between sales target codes and classification codes used by a plurality of sellers Check
When the individual sales target code is registered in the sales target master database, the individual sales target code is converted into a classification code based on the sales target master database and used as the common classification code.
The apparatus according to any one of claims 3 to 5. When the individual sales target code is not registered in the sales target master database, the conversion unit converts the individual sales target code in the one store of the sales target into the common classification code.
The apparatus according to claim 6. The classification storage unit stores a common classification code that does not exist in the classification code in association with the individual classification in a hierarchy corresponding to the lowest hierarchy of the classification code.
The apparatus according to claim 7. In accordance with an instruction from the user, further comprising a correspondence changing unit that changes the correspondence between the common classification and the individual classification,
Apparatus according to any one of claims 1 to 8. The correspondence changing unit stores a new common class corresponding to the one individual class in the class storage unit when there is no common class corresponding to the individual class.
The apparatus according to claim 9. A method for recording sales histories at a plurality of stores executed by a computer,
An individual classification acquisition stage for acquiring an individual classification in the one store for a sales target sold in one of the plurality of stores;
Corresponding to the acquired individual classification with reference to a classification storage unit that stores a correspondence between the common classification of the sales target common to the plurality of stores and the individual classification of the sales target in each of the plurality of stores Converting to the common classification
Sales history information including the common classification converted in the conversion step, a history recording step for recording in a sales history database;
A method comprising: When executed, a computer for recording sales history at multiple stores,
A classification storage unit that stores a correspondence between a common classification of sales objects common to the plurality of stores and an individual classification of the sales objects in each of the plurality of stores;
An individual classification acquisition unit that acquires an individual classification in the one store for a sales target sold in one of the plurality of stores;
A conversion unit that refers to the classification storage unit and converts the acquired individual classification into the corresponding common classification;
A history recording unit that records the sales history information including the common classification converted by the conversion unit in a sales history database;
Program to make it work.

Images