JP2015132938A - Method and system for checking sales price setting information - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a method and a system for checking sales price setting information, capable of checking the validity of a sales price of an article of commerce to be set with fewer errors in a short time.SOLUTION: A computer that checks the validity of sales price setting information on an article of commerce, comprises a storage unit storing therein a master group recording attributes of respective items of the setting information, and executes: an input process of inputting the setting information to the computer from a terminal; a format check process for a data processing unit of the computer to check a format of the input setting information; a master check process of checking integrity of each of the items of the setting information with each corresponding master in the master group; and a set amount checking process of checking an amount of a set value on the basis of a maximum value and a minimum value of previous set amounts recorded in one master in the master group.

Description

  The present invention relates to a method and system for checking sales price setting information of a product.

There are many different ways to determine prices in product sales. In Patent Document 1 below, based on the cost data indicating the cost of the input product and the sales volume data indicating the sales volume of the product, the gross profit rate of the product is determined, and the sales price that is the basis of the product A system for calculating and displaying the value is disclosed. However, in this document, after calculating the sales price, the validity of the price based on the previous set price of the same product or similar products is checked, and the sales master checks the sales attribute information such as product name and sales channel name. Absent. These check operations are conventionally performed manually.

JP 2012-133647 A

  As described above, since the conventional technology does not check the validity of the price based on the past sales price or the sales master regarding the sales attribute information, it is far from being the same or a similar product. In the case of setting a price or checking consistency manually, it takes a long time for the check work, and there is a high possibility of causing an operation error.

  An object of the present invention is to provide a method and a system for checking sales price setting information that can check the validity of the sales price of a product to be set in a short time with few errors.

  The present invention relates to a sales price setting information check method for checking the validity of sales price setting information related to a product using a computer. The computer has a storage unit for storing a master group in which attributes of each item of the setting information are recorded. In this check method, an input process for inputting setting information to the computer by an operator's operation, a format check process in which the data processing unit of the computer checks the format of the input setting information, and each item of the setting information Master check process for checking consistency with each master of the master group corresponding to them, and the amount of the set value based on the maximum value and the minimum value of the past set amount recorded in one master in the master group The set amount check process for checking is executed in this order.

  The product is a communication device, and the master group includes five types of masters: a sales price master, a product master, a sales channel master, a price plan master, and a discount code master. Sales price master check process that checks the consistency between information and sales price master, product master check process that checks the consistency between setting information and product master, and consistency between setting information and sales channel master The sales channel master check process, the charge plan master check process for checking the consistency between the setting information and the charge plan master, and the discount code master check process for checking the consistency between the setting information and the discount code master in this order. It may be configured to execute. The present invention can also be configured as a system that implements the above method.

  According to the present invention, the validity of the selling price of a product to be set can be checked in a short time with few errors.

It is a figure which shows the structure of the check system of the sales price setting information which concerns on embodiment. It is a sales price setting input screen image. Each master to be referred to when checking the sales price setting. It is a processing flow of a sales price setting check. It is an input example of sales price setting. It is an output image of the error message M1. It is an output image of the error message M2. It is an output image of the error message M3. It is an output image of the error message M4. It is an output image of the error message M5.

  Hereinafter, embodiments of the present invention will be described with reference to the drawings. The target product of the present embodiment is a single communication device that is sold in association with a communication carrier when a mobile phone / communication service contract is concluded with a customer. FIG. 1 is a system configuration diagram according to an embodiment of the present invention. The sales price setting information check system 10 includes a sales price setting information check server 1 that checks the validity of the sales price setting information, and a DB server that stores each master for checking each item of the setting information at the time of checking. The management PC 3 of this system connected to the sales price setting information check server 1 via the network 5 (LAN or WAN) and the sales price setting information via the network 6 (WAN). A sales base PC group 4 at each sales base of the communication carrier connected to the check server 1 is arranged.

  Next, the sales price setting information check server 1 will be described with reference to FIG. The check server 1 includes a data processing unit 11 that controls the entire server 1, a communication unit 12 that performs communication with the network 5, an input / output unit 13 that performs input / output of the server 1, and communication with the network 6. It is comprised from the communication part 14 which performs.

  Next, each master stored in the DB server 2 will be described. These masters are a sales price master 21 in which information related to the sales price of a communication device set by a telecommunications carrier throughout the past is registered, a product master 22 in which product codes and product names are registered, a sales channel code of products, and sales. From the sales channel master 23 in which the channel name is registered, the charge plan code for the telephone / communication service and the charge plan name in which the charge plan name is registered, and the discount code master 25 in which the discount code and discount type of the service are registered. Composed.

  Next, detailed contents of each master will be described with reference to FIG. First, the sales price master 21 holds information on sales prices and other sales. The system updates the contents of the master with those values after setting the sales price of the master or checking the validity of the setting information or the revised value at the time of review. The master 21 is composed of a total of eight items: a sales code 311, a product code 312, a sales start date 313, a sales end date 314, a sales price 315, a sales channel code 316, a charge plan code 317, and a discount code 318.

  Among these, the sales code 311 is an identification number for each sales form, the product code 312 is an identification symbol for each product name 322 defined in the product master 22, and the sales start date 313 is the date on which the sales started for that sales form. The sale end date 314 is the date when the sale ends, and the sale price 315 is the sale price of the sale form.

  Further, the sales channel code 316 is an identification symbol for each sales channel name 332 defined in the sales channel master 23, the rate plan code 317 is an identification symbol for each rate plan (payment charge / fixed amount) name 342, and the discount code 318 is a discount code. This is an identification number for each type of discount (combination of registration fee discount 352 / communication fee discount 353) defined in the master 25.

  Next, the table contents of the sales price master 21 in FIG. 3 will be described in detail. The product code 312 is only one type of “S001” corresponding to the product name “device A” when referring to the table of the product master 22. Further, referring to the sales channel master 23, the sales channel code 316 has two types of sales channel names corresponding to “A site” and “B site”. In addition, referring to the charge plan master 24, the charge plan code 317 has two types of charge plan names corresponding to “pay-as-you-go” and “fixed amount”. Furthermore, with reference to the discount code master 25, there are three types of discount codes 318 corresponding to combinations of “registration fee discount” and “communication fee discount”.

  In the sales price master 21, the first two lines (records) whose sales codes are 0001 and 0002 differ in price plan code between the two, so the sales prices are different, but the contents of the other items are the same. . However, both have already been sold with a sales end date of 2012/3/31. On the other hand, the line with the sales code 0003 is a review of only the sales price for the line 0001, and sales are started immediately after the end of the sales of 0001 (2012/4/1).

  In addition, the 0004 row is a review of only the selling price of the 0002 row, and sales are started immediately after the end of the sale of 0002 (2012/4/1). The last line with the sales code 0005 indicates that the sales channel was only AAAA until the previous line, but the sales channel BBBB was also developed from this line and newly added as a sales channel.

  Next, FIG. 4 shows a processing flow of the sales price setting information check. FIG. 5 shows an input example for setting sales price information. A telecommunications carrier who is a user of this system periodically reviews the sales price information of each product or sets new sales price information for each new product announcement and updates the sales price master. At that time, the data processing unit 11 of the sales price setting information check server 1 checks the validity of the sales price to be set. As an example of reviewing and setting the sales price, it is assumed that a new case of inputs 1 to 8 in FIG. 5 is input and set, and the sales price master 21 is updated.

  First, for each input (each line) in FIG. 5, the operator inputs the contents of each item in the format of FIG. 2 from the management PC 3 (S401). Subsequently, the input format is checked (S402). The format of the sales price 315 allows only numeric values, but in input 1, an alphabetic character (“AAAA”) is input. In this case, the process proceeds to the screen error content display process S410 as setting NG, and an error message M1 as shown in FIG. 6 is displayed on the screen of the management PC 3. There is no particular problem with the other inputs (2 to 8).

  If there is no problem in the input format check in S402, the process proceeds to S403 in which consistency with each master is checked. In this check, consistency with the master of each item is confirmed with respect to the code value of each item other than the sales price 315. The product code 312 refers to the product master 22, the sales channel code 316 refers to the sales channel master 23, the fee plan code 317 refers to the fee plan master 24, and the discount code 318 refers to the discount code master 25.

  An error message is displayed if there is a code value entered in each item that does not exist in the master. Here, in the input 2, since “S999”, which is the value input in the product code, does not exist in the product master 22, the screen transitions to the screen error content display processing S 411 as setting NG, and an error message M 2 as shown in FIG. Is displayed on the screen of the management PC 3. There is no particular problem with the other inputs (3 to 8).

  In S403, if the check is OK and the code value of each item exists in each master, the process proceeds to a set price check for each product (S404). For the input sales price 315 in FIG. 5, the sales price master 21 is referred to, and it is confirmed whether the past and current maximum sales prices associated with the input product code have been exceeded. This is because all the set values up to the present are set so as not to exceed the list price because the same product must not exceed the list price in the past and the present.

  In FIG. 3, the sales code whose product code is set in S001 in the sales price master 21 is all records (5 records), of which the sales price 12000 ¥ of the sales code 0001 is the maximum sales price (this price is the fixed price) Is). If the maximum sales price is exceeded, an error message indicating that a sales amount exceeding the maximum sales price has been input is displayed on the screen as the setting NG. Here, in the case of the input 3, the maximum price 12000 ¥ of the sales price set by the product code S001 is compared with the input value 13000 \, and the input value is larger, so the screen error content display processing is set as NG. The process proceeds to S412, and an error message M3 as shown in FIG. 8 is displayed on the screen of the management PC 3.

  In this step, if the check does not exceed the maximum selling price associated with the product code entered in OK, the process proceeds to the set amount check S405 for each channel. In this check, in the same product and the same sales channel, it is confirmed whether or not the input sales price exceeds the currently valid maximum sales price linked to the product code and the sales channel code. If it exceeds, an error message indicating that the maximum selling price is exceeded as the setting NG is displayed on the screen.

  Here, in the sales price master 21, the maximum sales price that is currently valid from the sales start date and the sales end date is the same as the input 4 and the product code S001 and the sales channel code AAAA. Since the input value is larger than the selling price 9000 ¥ of the input 4, the screen transitions to the screen error content display processing S412 as setting NG, and an error message M3 as shown in FIG. 8 is displayed on the screen of the management PC 3.

  In this step, if the check is OK and the input value does not exceed the maximum sales price associated with the entered product code and sales channel code, the process proceeds to the set amount check S406 for each rate plan. Check that the entered sales price does not exceed the maximum sales price associated with the entered same product, same sales channel and same price plan code. The maximum sales price of the same product, the same sales channel and the same price plan code as the input 4 is the sales price 8000 ¥ of the sales code 0003, and the input value 9000 ¥ is larger. The process proceeds to step S412, and an error message M3 as shown in FIG. 8 is displayed on the screen of the management PC 3.

  Also, the same product, the same sales channel and the same price plan code as the input 5 and the maximum sales price is the sales price 5000 ¥ of the sales code 0004, and the input value 7000 ¥ is larger. The process proceeds to the content display process S412 and an error message M3 as shown in FIG. 8 is displayed on the screen of the management PC 3. If the maximum selling price is not exceeded in this step, the process proceeds to a discount code check S407. Check the past and current setting information for the entered discount code. In the case of input 6, there is no problem with the check so far. If the record of input 6 is registered, it will be the first case of registering the discount code 0001.

  However, if the setting of this record is permitted, it will coexist with the existing sales code 0004. Both have the same product, sales channel, and rate plan, but because the discount codes are different, the discount contents are different, resulting in injustice between the two. Accordingly, since the two cannot coexist, the following processing is performed. That is, the existing sales code 0004 is closed and whether or not there is any problem by registering the new input 6 is output to the management PC 3 message in the format of FIG. 9 (S413). Similarly, both the input 7 and the sales code 0005 have the same product, sales channel, and fee plan, but the discount codes are different, so that they cannot coexist.

  Accordingly, the existing sales code 0005 is closed and whether or not there is no problem in newly registering the input 7 is output to the management PC 3 message in the format of FIG. 9 (S413). In the next step S408, it is confirmed whether or not the input sales price is lower than the minimum sales price in the input sales price master linked to the same product and the same sales channel. Since communication devices sold by communication carriers are often associated with mobile phones / communication services, communication devices tend to be set at low cost. Therefore, since the minimum price among the sales prices registered in the sales price master until now is used as a guide, if the set price falls below this minimum price, an alarm message is output and the set value is Encourage a review.

  Here, in the case of the input 8, the setting is made with an amount (0) that is lower than the sales price 5000 of the sales code 0004, which is the minimum sales price in the sales price master linked to the same product and the same sales channel. Then, a message in the format of FIG. 10 urging the review of the input value is output (S414).

  If there is no problem in the check up to S409, the input record shown in FIG. 5 is registered and the sales price master 21 is updated. Conversely, if an error occurs in each step, the input value is reviewed (S415), and the flow process of FIG. 4 is performed again from S401. It should be noted that each sales base PC of the sales base PC group 4 accesses the respective masters 21 to 25 stored in the DB server 2 via the network 6 and the sales price setting value check server 1, and sales price information of each product as needed. Can be referred to.

1. Sales price setting information check server, 2 DB server, 3 management PC,
4 Sales base PC group, 5 networks, 6 networks, 21 Sales price master 22 Product master, 23 Sales channel master, 24 Price plan master 25 Discount code master

Claims (9)

In the sales pricing information check method that checks the validity of the sales pricing information related to products using a computer,
The computer has a storage unit for storing a master group in which attributes of each item of the setting information are recorded,
By the processing of the data processing unit of the computer,
An input step for inputting the setting information to the computer;
A format check step for checking the format of the input setting information;
A master check step for checking consistency between each item of the setting information and each master of the master group corresponding to them;
A sales price setting information characterized by executing a set amount check step for checking the amount of the set value based on a maximum value and a minimum value of past set amounts recorded in one master in the master group. How to check. The product is a communication device;
The master group includes a sales price master, a product master, a sales channel master, a price plan master, and a discount code master,
The master check process includes
A sales price master check process for checking consistency between the setting information and the sales price master;
A product master check step for checking consistency between the setting information and the product master;
A sales channel master check process for checking consistency between the setting information and the sales channel master;
A rate plan master check step for checking consistency between the setting information and the rate plan master;
The method for checking sales price setting information according to claim 1, wherein a discount code master check step for checking consistency between the setting information and the discount code master is executed. The set amount check step includes:
A set amount check process for each product for checking the set amount for each product,
Check the set amount for each sales channel to check the set amount for each sales channel;
A set amount check process for each rate plan for checking the set amount for each rate plan;
A set amount check process for each discount code for checking the set amount for each discount code;
2. The method for checking sales price setting information according to claim 1, wherein a set minimum amount check step for checking a minimum amount of a set value is executed in this order. The set amount check process for each product confirms whether the sales price of the setting information input in the input process does not exceed the maximum sales price to date associated with the same product code,
The set amount check process for each sales channel confirms whether the sales price of the setting information input in the input process exceeds the currently valid maximum sales price linked to the same product code and sales channel. ,
The set price check process for each price plan is that the sales price of the setting information input in the input process does not exceed the currently valid maximum sales price linked to the same product code, sales channel and price plan. Confirmed,
The set amount check process for each discount code has the same product code, sales channel and rate plan as the setting information input in the input process in the registration record of the sales price master, and the discount code is Check if there is something different,
The set value minimum amount check step confirms that the selling price of the setting information input in the input step is larger than the minimum selling price set in the past linked to the same product code and sales channel. The method of checking sales price setting information according to claim 3. In the set price check process for each product, the set price check process for each sales channel, or the set price check process for each price plan, if the sales price of the setting information exceeds the maximum sales price, the terminal device outside the computer 5. The method for checking sales price setting information according to claim 4, wherein an error is displayed on the screen. In the set price check process for each discount code, the registration record of the sales price master has the same product code, sales channel, and rate plan as the setting information input in the input process, and the discount code is When it is confirmed that there is a different registration record, a confirmation message on whether to delete the registration record from the sales price master and newly register the setting information is displayed on the screen of the terminal device outside the computer The method of checking sales price setting information according to claim 4, wherein: In the setting value minimum amount check process, it was confirmed that the sales price of the setting information input in the input process is smaller than the minimum sales price set up to now associated with the same product code and sales channel 5. The method of checking sales price setting information according to claim 4, wherein a message prompting the review of the input value is displayed on a screen of a terminal device outside the computer. Sales price setting information check server for checking the validity of sales price setting information related to a product connected to a management PC via a network, and a master that records attributes of each item of the setting information referred to at the time of the check A DB server storing the group and connected to the check server;
A data processing unit of the sales price setting information check server,
Check the format of the setting information input from the management PC,
Check the consistency between each item of the setting information and each master of the master group corresponding to them,
A sales price setting information check system, wherein the amount of the set value is checked based on a past set amount recorded in one master of the master group. The master group includes a sales price master, a product master, a sales channel master, a price plan master, and a discount code master,
The data processing unit
As the consistency check, check whether the contents of the setting information are registered in each master in the master group,
9. The sales price according to claim 8, wherein as the check based on the past set amount, the amount of the set value is checked based on a maximum value or a minimum value of the set amount registered in the sales price master. Setting information check system.

Images