Price batch revision support device, price batch revision support method, and price batch revision support program

Abstract

To provide a collective price revision support device that provides support for a collective price revision of products having the same product attribute (e.g. product number).SOLUTION: In the present embodiment, (1) information that matches an extraction condition designated on a screen by an operator is extracted in reference to a product master including a product number and a product price master including a bundle price, and thus, a plurality of specifications including a product number and a bundle price of each product are displayed on the screen, (2) when the bundle price included in a certain one of the displayed specifications, is changed by the operator, the specification that includes the same product number as that of the certain specification is identified, (3) the bundle price included in the identified specification is also changed to the changed bundle price included in the certain specification, and (4) the changed bundle price included in the specification for which the bundle price change has been required, is reflected in the product price master. Accordingly, the bundle prices are collectively revised.SELECTED DRAWING: Figure 8

Description

Technical Field

[0001] The present invention relates to a price batch revision support device, a price batch revision support method, and a price batch revision support program.

Background Art

[0002] Patent Document 1 aims to provide a management means for products that can efficiently change the prices of products on display at a storefront without performing operations such as replacing the price tags of all products when managing products on display at a storefront whose prices may change over time (see paragraph 0004 of Patent Document 1, etc.). A management system and a management method for products on display at a storefront are disclosed.

Prior Art Documents

Patent Documents

[0003]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0004] As described in the above Patent Document 1, in the retail industry, it is extremely important to accurately and simply change prices.

[0005] Here, for products with many color and size differences within the same product attribute (same product number, etc.) (for example, glasses), the number of products increases. In this case, if a person in charge manually revises the prices in the master to perform price revision, since the number of products subject to price revision is large, there is a problem that the work burden becomes large and mistakes are likely to occur.

[0006] The present invention has been made in view of the above problems, and an object of the present invention is to provide a price batch revision support device, a price batch revision support method, and a price batch revision support program that can support batch revision of prices for products having the same product attribute (product number, etc.).

Means for Solving the Problem

[0007] In order to solve the above-described problems and achieve the object, the price batch revision support apparatus according to the present invention is a price batch revision support apparatus including a control unit and a storage unit. In the storage unit, a product master including product attribute information for identifying the attributes of a product and a price master including price information about the product are stored. The control unit refers to the product master and the price master, extracts information that matches the extraction conditions specified by an operator on a screen for performing a price revision, and thereby displays a plurality of details for each product including the product attribute information and the price information on the screen. The detail display means includes: when the price information for a certain detail is changed by the operator among the plurality of details displayed by the detail display means, detail identification means for identifying details including the same product attribute information as the product attribute information included in the certain detail for which the price information has been changed; price change means for changing the price information included in the details identified by the detail identification means to the changed price information included in the certain detail; and batch revision means for performing batch revision of the price information by reflecting the changed price information included in the detail that is the target of the change of the price information in the price master.

[0008] Further, in the price batch revision support apparatus according to the present invention, the price information is a single-item price that is the price when the product is sold as a single item and a set sales price that is the price when the product is sold as a set with another product. The control unit, for the plurality of details including the product attribute information, the single-item price, and the set sales price displayed by the detail display means, when a predetermined difference is set by the operator on the screen, calculates a changed set sales price by subtracting the set difference from the single-item price, and further includes set price calculation means for changing the set sales price included in the plurality of details to the calculated changed set sales price.

[0009] Further, in the price batch revision support device according to the present invention, the price information includes the purchase unit price of the product, the single product price which is the price when the product is sold as a single item, and the set sales price which is the price when the product is sold in a set with other products. The storage unit further stores an authority management master for managing the range of the price information for which each operator has the change authority. The detail display means displays the plurality of details on the screen in a manner that only the set sales price can be changed by the operator for whom a narrow change authority is set in the authority management master, and displays the plurality of details on the screen in a manner that all of the purchase unit price, the single product price, and the set sales price can be changed by the operator for whom a wide change authority is set in the authority management master.

[0010] Further, in the price batch revision support device according to the present invention, when the operator designates on the screen that the changed price information is to be applied from the current time, the batch revision means overwrites the price information before the change in the price master with the price information after the change. When the operator designates on the screen that the changed price information is to be applied from a certain future time, the batch revision means newly adds a record including the future date input by the operator on the screen and the changed price information to the price master while leaving the record including the price information before the change in the price master.

[0011] Also, in the price batch revision support method according to the present invention, it is a price batch revision support method executed by an information processing apparatus including a control unit and a storage unit. In the storage unit, a product master including product attribute information for identifying the attributes of products and a price master including price information about the products are stored. In the control unit, by referring to the product master and the price master and extracting information that matches the extraction conditions specified by an operator on a screen for performing price revision, a detail display step of displaying a plurality of details for each product, including the product attribute information and the price information, on the screen; a detail identification step of identifying details including the same product attribute information as the product attribute information included in a certain detail when the price information about the certain detail is changed by the operator among the plurality of details displayed in the detail display step; a price change step of changing the price information included in the details identified in the detail identification step to the changed price information included in the certain detail; and a batch revision step of performing batch revision of the price information by reflecting the changed price information included in the detail that is the target of the change of the price information in the price master. It is characterized by including these steps.

[0012] Also, in the price batch revision support program according to the present invention, it is a price batch revision support program for causing an information processing apparatus including a control unit and a storage unit to execute. In the storage unit, a product master including product attribute information for identifying the attributes of products and a price master including price information about the products are stored. For execution by the control unit, by referring to the product master and the price master and extracting information that matches the extraction conditions specified by an operator on a screen for performing price revision, a detail display step of displaying a plurality of details for each product, including the product attribute information and the price information, on the screen; a detail identification step of identifying details including the same product attribute information as the product attribute information included in a certain detail when the price information about the certain detail is changed by the operator among the plurality of details displayed in the detail display step; a price change step of also changing the price information included in the details identified in the detail identification step to the changed price information included in the certain detail; and a batch revision step of performing batch revision of the price information by reflecting the changed price information included in the detail that is the target of the change of the price information in the price master. It is characterized by including these steps.

Effects of the Invention

[0013] According to the present invention, there is an effect that it is possible to support batch revision of prices for products having the same product attributes (such as product numbers).

Brief Description of the Drawings

[0014]

Figure 1

Figure 2

Figure 3

Figure 4

Figure 5

Figure 6

Figure 7

Figure 8

Figure 9

Figure 10

Figure 11

Figure 12

Figure 13

Figure 14

Figure 15

Figure 16

Figure 17

Embodiments for Carrying Out the Invention

[0015] Hereinafter, embodiments of a price batch revision support device, a price batch revision support method, and a price batch revision support program according to the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited by this embodiment.

[0016] [1. Summary] (1) Problem In the retail industry (such as glasses, apparel, mass home appliances, and sundries), even for products with the same unit price and the same product number (model number), the color and size may be different. Therefore, when revising the price, it was necessary for the buyer (purchasing staff) or the operator in the merchandise department to revise the unit price for each individual product in the product unit price master.

[0017] However, depending on the combination of color and size, even though the product numbers are the same, it is necessary to revise the unit prices of dozens of products in the product unit price master. Therefore, the load of revision is extremely high, and incorrect unit price revisions may be made due to input errors or missed checks, and incorrect unit price information may be deployed to the stores.

[0018] When incorrect unit price information is deployed to the stores, the salesperson will notice the error in the unit price information when entering sales at the actual store POS terminal, which may affect store operations and customer service. Also, when the salesperson discovers incorrect unit price information, revisions to the product unit price master and master distribution to each store are carried out, but such revisions and such distributions have taken time.

[0019] To prevent such problems, there is also a method of preparing master data outside the system using Excel or the like and accepting it. However, because it is outside the system, various controls are ineffective, and as a result, there are problems such as unit price registration errors and the need for operator skills.

[0020] In particular, for example, in the eyewear industry, it is often the case that sets of frames and lenses are sold. For the frames during set sales, the unit price of the product (set sales price) may be set lower than that of the frames during single-item sales. In this case, if the set sales price is to be manually revised, since there are many color and size differences in the frames, it will be extremely labor-intensive. For this reason, there has been a desire to enable batch revision of the set sales price of the frames.

[0021] (2) Outline of this embodiment Therefore, in this embodiment, for example, as a UI (User Interface) operated by a buyer (purchasing staff) or an operator in the merchandise department, products extracted based on arbitrary extraction conditions (such as product number, color, and size) can be displayed on the screen.

[0022] On this screen, the unit price information set at the current time can be confirmed. Also, when the unit price of a certain product on this screen is changed, the unit price can be batch-changed for other products having the same product number. And if a predetermined difference is input on this screen, a new set sales price can be automatically calculated based on the unit price of the product and the input difference.

[0023] (3) Effects of this embodiment As a result, for example, it has been successful in reducing the work load and correction errors when performing the work of correcting the unit price in the product unit price master. Also, it has been successful in eliminating sales input with incorrect unit price information, receipt issuance deficiencies, and unnecessary customer service responses that occurred due to incorrect unit price information being master-distributed to the store. And even operators with low skills can perform the work of correcting the unit price by referring to the products displayed on the screen. Hereinafter, the specific configuration and operation will be described.

[0024] [2. Configuration] An example of the configuration of the price batch revision support device 100 according to this embodiment will be described with reference to FIG. 1. FIG. 1 is a block diagram showing an example of the configuration of the price batch revision support device 100.

[0025] The price batch revision support device 100 is a commercially available desktop personal computer. Note that the price batch revision support device 100 is not limited to a stationary information processing device such as a desktop personal computer, and may be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), smartphone, or tablet personal computer.

[0026] The price batch revision support device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each unit included in the price batch revision support device 100 is communicably connected via an arbitrary communication path.

[0027] The communication interface unit 104 communicably connects the price batch revision support device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via a communication line. Here, the network 300 has a function of communicably connecting the price batch revision support device 100 and the server 200 to each other, and is, for example, the Internet or a LAN (Local Area Network). Note that data such as various masters described later may be stored in the server 200, for example.

[0028] An input / output interface unit 108 is connected to an input device 112 and an output device 114. As the output device 114, in addition to a monitor (including a household TV), a speaker or a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that collaborates with the mouse to realize a pointing device function can be used. In the following, there may be cases where the output device 114 is described as the monitor 114, and the input device 112 is described as the keyboard 112 or the mouse 112.

[0029] The storage unit 106 stores various databases, tables, files, and the like. In the storage unit 106, a computer program for giving commands to the CPU (Central Processing Unit) in cooperation with the OS (Operating System) to perform various processes is recorded. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory)·ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, and an optical disk can be used.

[0030] The storage unit 106 includes, for example, a product master 106a, a product unit price master 106b as a price master, and an assignee master 106c as an authority management master.

[0031] As shown in FIG. 3, the product master 106a includes, for example, product identification information (product code and product name) for identifying a product, product attribute information (brand and item number) for identifying the attributes of the product, product characteristic information (color and size) for identifying the characteristics of the product, the supplier of the product, a classification (product classification) for identifying the type of the product, and the like.

[0032] The product number is a convenient identification code for grouping multiple products that have the same shape, design, etc., but differ in color, size, etc. For example, in the example of the product master 106a in FIG. 3, the four spectacle frames with product codes: A00001 to A00004 have different colors and sizes from each other, but the same shape and design, so the same product number "ABC-AA" has been assigned.

[0033] As shown in FIG. 3, the unit product price master 106b includes, for example, the product identification information (product code), price information about the product, the revision date of the price information, and so on. As shown in FIG. 3, the price information refers to the purchase unit price of the product, the unit price which is the price when the product is sold as a single item, and the set sales price which is the price when the product is sold as a set with other products, etc.

[0034] The unit price and the set sales price will be described. For example, the spectacle frame may be sold as a single item, or on the other hand, may be sold as a set with spectacle lenses. The price of the spectacle frame in the former case is the unit price, and the price of the spectacle frame in the latter case is the set sales price. Usually, the set sales price is lower than the unit price.

[0035] In the industry of retailing glasses, there are many practical demands to revise the set sales price in units of the product number. However, according to the price batch revision support device 100 according to the present embodiment, it is possible to meet such demands.

[0036] As shown in FIG. 12, the person in charge master 106c includes, for example, person-in-charge identification data (person-in-charge code and person-in-charge name) for identifying the person in charge, the department to which the person in charge belongs, a classification (menu authority) indicating whether each person in charge has the authority to change the price information, a classification (purchase authority) indicating the scope within which each person in charge has the authority to change the price information, and so on.

[0037] The menu authority will be described. When the menu authority indicates that the person in charge does not have the authority to change the price information (0: none), the person in charge cannot open the input screen for price revision. In contrast, when the menu authority indicates that the person in charge has the authority to change the price information (1: yes), the person in charge can open the input screen and change the price information.

[0038] The purchasing authority will be described. When the purchasing authority indicates a narrow change authority (0: none), the person in charge can only change the set selling price among the price information. In contrast, when the purchasing authority indicates a broad change authority (1: yes), the person in charge can change all of the purchase unit price, the single item price, and the set selling price among the price information.

[0039] The control unit 102 is a CPU or the like that comprehensively controls the price batch revision support device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs defining various processing procedures, and required data, and executes various information processes based on these stored programs.

[0040] Functionally conceptually, the control unit 102 includes, for example: (1) a detail display unit 102a as detail display means for displaying, on the screen, a plurality of details for each product, including the product attribute information and the price information, by extracting information that matches the extraction conditions specified by the operator on the screen for price revision with reference to the product master and the price master; (2) a detail identification unit 102b as detail identification means for identifying, among the plurality of details displayed by the detail display means, the details that include the same product attribute information as the product attribute information included in a certain detail when the price information for the certain detail is changed by the operator; (3) a price change unit 102c as price change means for changing the price information included in the details identified by the detail identification means to the changed price information included in the certain detail; (4) a set price calculation unit 102d as set price calculation means for calculating a changed set sales price by subtracting the set difference from the unit price when a predetermined difference is set on the screen by the operator for the plurality of details including the product attribute information, the unit price, and the set sales price displayed by the detail display means, and changing the set sales price included in the plurality of details to the calculated changed set sales price; and (5) a batch revision unit 102e as batch revision means for performing batch revision of the price information by reflecting the changed price information included in the details that are the target of the price information change in the price master.

[0041] The detail display unit 102a refers to the product master 106a including the product attribute information (e.g., product number) and the like and the product unit price master 106b including the price information and the like, and extracts information that matches the extraction conditions specified by the operator on the screen for price revision, thereby displaying, on the screen, a plurality of details for each product, including the product attribute information and the price information (corresponding to steps S1 and S2 in FIG. 2).

[0042] The details display section 102a may display the details according to the purchasing authority set in the person-in-charge master 106c. That is, the details display section 102a displays only the set selling price in a modifiable manner for an operator with narrow modification authority (purchasing authority = 0: none) set in the person-in-charge master 106c, and displays the plurality of details on the screen. In contrast, for an operator with broad modification authority (purchasing authority = 1: yes) set in the person-in-charge master 106c, the details display section 102a displays all of the purchase unit price, the unit price, and the set selling price in a modifiable manner for the operator, and displays the plurality of details on the screen.

[0043] When the price information for a certain detail in the plurality of details displayed by the details display section 102b is changed by the operator, the details identification section 102b identifies the details including the same product attribute information as the product attribute information included in the certain detail where the price information has been changed (corresponding to step S3A in FIG. 2).

[0044] The price change section 102c also changes the price information included in the details identified by the details identification section 102b to the changed price information included in the certain detail (corresponding to step S3A in FIG. 2).

[0045] When a predetermined difference is set on the screen by the operator for the plurality of details including the product attribute information, the unit price, and the set selling price displayed by the details display section 102a, the set price calculation section 102d calculates the changed set selling price by subtracting the set difference from the unit price. Then, the set price calculation section 102d changes the set selling price included in the plurality of details to the calculated changed set selling price (corresponding to step S3B in FIG. 2).

[0046] The batch revision section 102e performs batch revision of the price information by reflecting the changed price information included in the details that are the target of the change of the price information in the product unit price master 106b (corresponding to step S4 in FIG. 2).

[0047] The bulk revision unit 102e may perform a bulk revision of the price information by updating the product unit price master 106b in any of the following two methods. That is, when the operator designates on the screen that the changed price information is to be applied from the current time (current price revision), the bulk revision unit 102e overwrites the price information before the change in the product unit price master 106b with the price information after the change. On the other hand, when the operator designates on the screen that the changed price information is to be applied from a certain future point in time (bulk price revision), the bulk revision unit 102e leaves the record including the price information before the change in the product unit price master 106b, and newly adds to the product unit price master 106b a record including the future date input by the operator on the screen and the price information after the change.

[0048] [3. Specific Examples of Processing] In this section, specific examples of the processing according to this embodiment will be described. The flow of the processing is as shown in FIG. 2. That is, first, the target products are narrowed down (step S1 in FIG. 2), and then the target products and price information are displayed (step S2 in FIG. 2). Next, a bulk price change (step S3A in FIG. 2) or a bulk price change using a difference (step S3B in FIG. 2) is performed for products with the same product number. Finally, the changed price is reflected in the product unit price master 106b (step S4 in FIG. 2).

[0049] [3-1. Narrowing Down of Products (Step S1)] First, the target products are narrowed down based on conditions such as product category, brand, product number, supplier, manufacturer, and current unit price. Details will be described below.

[0050] As shown in FIG. 4, in the extraction condition area surrounded by a dotted line frame on the input screen (hereinafter simply referred to as the "input screen") for performing the selling price revision process, the product category "1: Sunglass Frame", the brand "BR001", and the reference date "2021 / 12 / 01" are input.

[0051] In this example, although not input as extraction conditions, the supplier, product number, manufacturer, etc. may be input. Also, for the unit price, set sales price, purchase unit price, and gross profit, after the amount is input, extraction can be performed under either the condition of being equal to or higher than the input amount or being equal to or lower than the input amount.

[0052] After the extraction conditions are input and the "F11: Display" in the lower right of the input screen in FIG. 4 is pressed, the display described in [3-2] below is executed.

[0053] [3-2. Display of Target Products and Price Information (Step S2)] Next, on the horizontal axis, the brand, product number, color, and size of each product are expanded, and further, the purchase unit price, unit price, and set sales price of each product are also displayed together. This will be described in detail below.

[0054] Assume that the input extraction conditions are as described in [3-1]. Also, assume that the product master 106a and the product unit price master 106b are preset with the contents shown in FIG. 3. Note that in the product unit price master 106b in FIG. 3, the product specified by the product code "C00001" is a contact lens that is not subject to set sales. Whether it is subject to set sales depends on the product category. For products that are not subject to set sales, as shown by hatching the "2,500 yen" in the lower right of the product unit price master 106b in FIG. 3, the set sales price is set to the same price as the unit price, and the set sales price cannot be changed. Hereinafter, the processing performed by the detailed display unit 102a will be described.

[0055] The detailed display unit 102a extracts, from the product master 106a in FIG. 3, six records hatched in the product master 106a shown again in FIG. 5 as records including the product category "1: Glasses Frame" and the brand "BR001" input as extraction conditions in [3-1].

[0056] Subsequently, the detailed display section 102a extracts, as the records including the product codes among the six records obtained in the previous paragraph, the six records indicated by hatching in the product unit price master 106b shown again in FIG. 5 from the product unit price master 106b in FIG. 3.

[0057] Note that there are two records including the product code "A00001" in the product unit price master 106b in FIG. 5. Thus, when there are two or more records including the same product code, the detailed display section 102a extracts the record including the latest revision date at the reference date "2021 / 12 / 01" input as the extraction condition in [3-1]. Specifically, referring to the product unit price master 106b in FIG. 5, among the two records including the same product code "A00001", the revision date in one record is "2015 / 04 / 01" and the revision date in the other record is "2020 / 04 / 01". Therefore, the detailed display section 102a extracts the latter record.

[0058] Then, based on the six records extracted from the product master 106a and the six records extracted from the product unit price master 106b, the detailed display section 102a displays six details as shown in the lower half of the input screen in FIG. 6. In the items of the six displayed details, product, brand, item number, color, and size are information based on the records extracted from the product master 106a, while the previous revision date, purchase unit price, unit price, and set sales price are information based on the records extracted from the product unit price master 106b.

[0059] Note that the detailed display section 102a displays the details having the same information together in the priority order of brand > item number > product CD. In the example shown in the lower half of the input screen in FIG. 6, the detailed display section 102a displays the six details including the brand "BR001" together, and further among them, the four details including the item number "ABC-AA" together, while the two details including the item number "ABC-BB" together.

[0060] [3-3. Batch price change for products with the same item number (Step S3A)] In this section, an example will be described in which when the price of one product is changed, the prices of other products with the same product number are also changed in a batch. The details will be described below.

[0061] First, as shown in FIG. 7, the check box of "Batch Set of the Same Product Number" at the upper part of the input screen is turned on. Subsequently, the revised set sales price is input. In this example, as shown by the dotted line frame in the column of "Revised Set Price" in FIG. 8, among the six details displayed by the detail display section 102a as [3-2], for the detail of the product code "A00001", it is assumed that the set sales price is changed from 1,550 yen to 1,600 yen.

[0062] When the price change described in the previous paragraph is made, as shown in FIG. 8, the detail identification section 102b identifies three details, namely, the detail of the product code "A00002", the detail of the product code "A00003", and the detail of the product code "A00004", as the details including the product number "ABC-AA" that includes the detail of the product code "A00001" whose set sales price has been changed.

[0063] In the example of the previous paragraph, an example has been described in which the detail identification section 102b identifies the details including the same product number as the product number included in the detail for which the price change has been made. That is, the case where the specific key is only the product number has been described, but the specific key is not limited to this. For example, it may be a combination of brand and product number, or a combination of supplier, brand, and product number. By using the specific key of the combination of supplier, brand, and product number, it is also possible to handle the case where products are purchased from multiple suppliers.

[0064] Then, after the revised set sales price of 1,600 yen for the detail of the product code "A00001" is input and the Enter key is pressed, the price change section 102c also changes the set sales price of 1,550 yen included in the three details identified by the detail identification section 102b to 1,600 yen, as shown on the right side of FIG. 8. That is, the price change section 102c changes the prices of other products with the same product number in a batch.

[0065] Finally, after the operator confirms that the changed set selling price displayed on the input screen is correct, if there are no problems, the operator presses "F12: Update". As a result, the changed set selling price is reflected in the product unit price master 106b. By adopting such an operation that once requires the operator's confirmation before updating the product unit price master 106b, registration errors can be prevented.

[0066] As shown in FIG. 9, when the set selling price of a certain detail is changed with the check box of "Bulk Set of the Same Product Number" at the upper part of the input screen not being set to ON, as shown on the right side of FIG. 9, only for that certain detail, the set selling price is changed. That is, the processing by the detail identification section 102b and the price change section 102c described above is not executed.

[0067] [3-4. Bulk Price Change Using the Difference (Step S3B)] In this section, an example in which the set selling price is changed using the difference from the unit price will be described. The details will be described below.

[0068] When a difference (discount amount) is input into the "Unit Price Difference" surrounded by a dotted line frame in the upper right of the input screen shown in FIG. 10 and "F12: Update" surrounded by a dotted line frame in the lower right of the same screen is pressed, the changed set selling price is calculated using the input difference.

[0069] Specifically, as shown in FIG. 11, when -300 yen is input as the discount amount of the glasses frame when the glasses frame is sold as a set with the glasses lens and "F12: Update" is pressed, the set price calculation section 102d subtracts 300 yen from the unit price of 1,800 yen of the glasses frame to calculate the changed set selling price of 1,500 yen of the glasses frame.

[0070] In this way, the operator can change the set selling price of the glasses frame from 1,550 yen to 1,500 yen by changing the discount amount of the glasses frame at the time of set sales from 250 yen to 300 yen.

[0071] In addition, when a difference is entered in the "Unit Price Difference" on the input screen, the changed set sales price entered in the "Revised Set Price" on the input screen is ignored, and the process by the set price calculation unit 102d is executed. That is, the difference entered in the "Unit Price Difference" takes precedence over the price directly entered in the "Revised Set Price" in terms of processing.

[0072] [3-5. Restrictions on Change Authority Set for Each Responsible Person] In this section, examples of restrictions on change authority set for each responsible person will be described. Responsible persons include, for example, those at the head office, those in the purchasing department (so-called buyers), those in the merchandise department, and those who conduct sales at the store.

[0073] Specifically, it will be described using the responsible person master 106c in FIG. 12. Those for whom "1: Yes" is set as the menu authority in the responsible person master 106c in FIG. 12, that is, Sato, Tanaka, and Yamamoto, can open the input screen and change the price information. On the other hand, those for whom "0: No" is set as the menu authority in the responsible person master 106c in FIG. 12, that is, Suzuki, Watanabe, and Hiramoto, cannot open the input screen and, as a result, cannot change the price information.

[0074] Next, there are also differences in the range of price information changes that Sato, Tanaka, and Yamamoto can make, so it will be explained. As shown in the responsible person master 106c in FIG. 12, as the purchasing authority, "0: No" is set for Tanaka and Yamamoto belonging to the merchandise department, while "1: Yes" is set for Sato belonging to the purchasing department.

[0075] In this case, as shown in FIG. 13, the detail display unit 102a can only change the set sales price for Tanaka and Yamamoto belonging to the merchandise department, while the purchase unit price and unit price are locked and cannot be changed, and a plurality of details are displayed.

[0076] On the other hand, as shown in FIG. 14, the detailed display unit 102a displays a plurality of details for Sato belonging to the purchasing department in a manner that allows all of the purchase unit price, unit price, and set sales price to be changed. Note that the batch price change for the same product number product described in [3-3] is applicable not only to the set sales price but also to the purchase unit price and unit price.

[0077] [3-6. Reflection of the Changed Price in the Product Unit Price Master 106b (Step S4)] Finally, the changed price set in the details by the processes in [3-3] and [3-4] is reflected in the product unit price master 106b. The operator can perform this reflection by specifying either the "Current Price Revision" or "Batch Price Revision" method as shown by the dotted line frame in the upper left of the input screen in FIG. 15.

[0078] First, the price revision when "Current Price Revision" is specified will be explained. "Current Price Revision" is a method of price revision in which the price before change in the record including the previous revision date in the product unit price master 106b is overwritten (UPDATE) with the price after change.

[0079] Specifically, as shown in FIG. 16, when the "Current Price Revision" on the input screen is checked ON and the set sales price after change of 1,600 yen is set for 6 details, the batch revision unit 102e first identifies the 6 records hatched in the product unit price master 106b in FIG. 16 as the records including the product codes "A00001" to "A00006" respectively included in the 6 details.

[0080] Then, as shown by the dotted line frame in the product unit price master 106b in FIG. 16, the batch revision unit 102e overwrites the set sales price before change of 1,550 yen in the identified 6 records with the set sales price after change of 1,600 yen.

[0081] Next, the price revision when "batch price revision" is specified will be described. "Batch price revision" is a method of price revision in which records including the price after the change are newly added (INSERTed) while leaving the records including the price before the change in the product unit price master 106b.

[0082] Specifically, as shown in FIG. 17, when the check box for "batch price revision" on the input screen is turned ON and the future date "2022 / 01 / 01" is entered as the "batch price revision date", and then the set sales price of 1,600 yen after the change is set for 6 details, the batch revision unit 102e newly adds 6 records including the input future date "2022 / 01 / 01" and the set sales price of 1,600 yen after the change to the product unit price master 106b of FIG. 17 as shown by being surrounded by a dotted line frame. As a result, for products sold after 2022 / 01 / 01, the set sales price of 1,600 yen after the change will be applied.

[0083] [4. Summary of this Embodiment] As described above, according to the price batch revision support device 100 according to this embodiment, mainly as described in [3-3] and [3-6], it is possible to support batch price revision for products having the same product attributes (product number, etc.). As a result, when revising the price, it is not necessary for the person in charge to manually revise the price information of each product in the master (in this example, the product unit price master 106b). As a result, the work load and mistakes during price revision can be significantly reduced. Also, for example, after batch revising the prices of products A to F belonging to the same product number, it becomes possible to perform operations such as manually changing the price of product B to a different price.

[0084] In addition, according to the price batch revision support device 100 according to the present embodiment, as mainly described in [3-4] and [3-6], it is possible to perform batch revision of the set sales price by inputting the difference (discount amount) from the unit price. Thus, even if the person in charge does not clearly recognize the revised set sales price, as long as the discount amount from the unit price can be recognized, batch revision of the set sales price can be performed.

[0085] And, according to the price batch revision support device 100 according to the present embodiment, as mainly described in [3-5], it is possible to set for each person in charge whether a price change is possible and, if it is possible, to what range it can be changed. Thereby, it is possible to ensure that batch revision of the price is performed in a state where security is ensured.

[0086] [5. Contribution to the Sustainable Development Goals (SDGs) Led by the United Nations] According to the present embodiment, since it can contribute to improving business efficiency and promoting appropriate business judgment of the enterprise, it is possible to contribute to Goals 8 and 9 of the SDGs.

[0087] Also, according to the present embodiment, since it can contribute to reducing waste loss and promoting paperless and digitalization, it is possible to contribute to Goals 12, 13, and 15 of the SDGs.

[0088] Also, according to the present embodiment, since it can contribute to strengthening control and governance, it is possible to contribute to Goal 16 of the SDGs.

[0089] [6. Other Embodiments] The present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims, in addition to the above-described embodiments.

[0090] For example, among the processes described in the embodiments, all or part of the processes described as being automatically performed can be manually performed, or all or part of the processes described as being manually performed can be automatically performed by a known method.

[0091] Also, regarding the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and the drawings, they can be arbitrarily changed unless otherwise specified.

[0092] Regarding the price batch revision support device 100, each of the illustrated components is a functional concept and does not necessarily have to be physically configured as shown in the drawings.

[0093] For example, regarding the processing functions provided by the price batch revision support device 100, especially each processing function performed by the control unit, all or any part of them may be realized by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware by wired logic. Note that the program is recorded on a non-transitory computer-readable recording medium including programmed instructions for causing an information processing apparatus to execute the processes described in this embodiment, and is mechanically read by the price batch revision support device 100 as needed. That is, in a storage unit such as a ROM or an HDD (Hard Disk Drive), a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded. This computer program is executed by being loaded into the RAM and constitutes the control unit in cooperation with the CPU.

[0094] Also, this computer program may be stored in an application program server connected to the price batch revision support device 100 via an arbitrary network, and all or part of it can be downloaded as needed.

[0095] Also, a program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium, or may be configured as a program product. Here, this "recording medium" includes any "portable physical medium" such as a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), an EEPROM (registered trademark) (Electrically Erasable and Programmable Read Only Memory), a CD-ROM (Compact Disk Read Only Memory), an MO (Magneto-Optical disk), a DVD (Digital Versatile Disk), and a Blu-ray (registered trademark) Disc.

[0096] Also, the "program" is a data processing method described in any language or description method, and is not limited to a form such as source code or binary code. Note that the "program" is not necessarily limited to being configured as a single entity, and also includes those that are distributedly configured as a plurality of modules or libraries, or those that achieve their functions in cooperation with other separate programs represented by an OS. Regarding the specific configuration, reading procedure, and installation procedure after reading for reading the recording medium in each device shown in the embodiment, well-known configurations and procedures can be used.

[0097] The various databases and the like stored in the storage unit are storage means such as a memory device such as a RAM or a ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk, and store various programs, tables, databases, and web page files used for various processes and website provision.

[0098] Further, the price batch revision support device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which an arbitrary peripheral device is connected. Further, the price batch revision support device 100 may be realized by installing software (including a program or data, etc.) for realizing the processing described in this embodiment in the device.

[0099] Furthermore, the specific form of the distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in arbitrary units according to various additions or according to the functional load. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

Industrial Applicability

[0100] The present invention is useful in all industries, but is particularly useful in industries that conduct multi-store expansions in retail (such as the eyewear industry, apparel industry, home appliance mass retail industry, and miscellaneous goods industry, etc.).

Explanation of Signs

[0101] 100 Price batch revision support device 102 Control unit 102a Detail display unit 102b Detail specifying unit 102c Price change unit 102d Set price calculation unit 102e Batch revision unit 104 Communication interface unit 106 Storage unit 106a Product master 106b Product unit price master 106c Person in charge master 108 Input / output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims

1. A price batch revision support device including a control unit and a storage unit, wherein the storage unit stores a product master including product attribute information for identifying attributes of a product, a price master including price information about the product, and the control unit extracts information that matches extraction conditions specified by an operator on a screen for performing a price revision by referring to the product master and the price master, and thereby displays, on the screen, a plurality of details for each product, including the product attribute information and the price information, by means of detail display means; detail identification means for identifying, in the plurality of details displayed by the detail display means, details including the same product attribute information as the product attribute information included in a certain detail for which the price information has been changed by the operator; price change means for changing the price information included in the details identified by the detail identification means to the changed price information included in the certain detail; batch revision means for performing a batch revision of the price information by reflecting the changed price information included in the detail that is the target of the change of the price information in the price master; characterized by comprising the above, and a price batch revision support device.

2. The price information is a unit price when the product is sold as a single item and a set selling price when the product is sold as a set with other products, and the control unit calculates a changed set selling price by subtracting the set difference set by the operator on the screen from the unit price, and changes the set selling price included in the plurality of details to the calculated changed set selling price, for the plurality of details including the product attribute information, the unit price, and the set selling price, displayed by the detail display means, by means of set price calculation means; characterized by further comprising the above, and the price batch revision support device according to Claim 1.

3. The price information is the purchase unit price of the product, the unit price when the product is sold as a single item, and the set selling price when the product is sold as a set with other products, wherein the storage unit further stores a privilege management master for managing the range of the price information for which each operator has a change privilege, and the detail display means ​ ​ For an operator with a narrow change authority set in the authority management master, only the set selling price can be changed by the operator in a manner that enables such change, and a plurality of details are displayed on the screen. For an operator with a broad change authority set in the authority management master, all of the purchase unit price, the unit price, and the set selling price can be changed by the operator in a manner that enables such change, and a plurality of details are displayed on the screen. The price batch revision support device according to claim 1 or 2, characterized by the above.

4. The batch revision means When it is specified by the operator on the screen that the changed price information is to be applied from the current time, the price information before the change in the price master is overwritten with the changed price information. When it is specified by the operator on the screen that the changed price information is to be applied from a certain future time, while leaving the record including the price information before the change in the price master, a record including the future date input by the operator on the screen and the changed price information is newly added to the price master. The price batch revision support device according to any one of claims 1 to 3, characterized by the above.

5. A price batch revision support method executed by an information processing device including a control unit and a storage unit, wherein the storage unit stores a product master including product attribute information for identifying the attributes of products, and a price master including price information about the products, and in the control unit, a detail display step of referring to the product master and the price master and extracting information that matches the extraction conditions specified by the operator on the screen for price revision, and displaying a plurality of details for each product including the product attribute information and the price information on the screen; a detail identification step of identifying details including the same product attribute information as the product attribute information included in a certain detail whose price information has been changed by the operator among the plurality of details displayed in the detail display step; a price change step of changing the price information included in the details identified in the detail identification step to the changed price information included in the certain detail. A batch revision step of batch-revising the price information by reflecting the revised price information including the details subject to the change of the price information in the price master; including; A price batch revision support method characterized by.

6. A price batch revision support program for causing an information processing apparatus including a control unit and a storage unit to execute, In the storage unit, A product master including product attribute information for identifying the attributes of a product, A price master including price information about the product, Are stored, In the control unit, By referring to the product master and the price master and extracting information that matches the extraction conditions specified by the operator on the screen for performing price revision, a detail display step of displaying a plurality of details for each product including the product attribute information and the price information on the screen; In the plurality of details displayed in the detail display step, when the price information for a certain detail is changed by the operator, a detail identification step of identifying the details including the same product attribute information as the product attribute information included in the certain detail where the price information is changed; A price change step of changing the price information included in the details identified in the detail identification step to the revised price information included in the certain detail; A batch revision step of batch-revising the price information by reflecting the revised price information including the details subject to the change of the price information in the price master; Causing to execute, A price batch revision support program characterized by.

Images