JP6855536B2 - Server device, program, product data setting system and price display setting method - Google Patents

Description

An embodiment of the present invention relates to a server device , a program , a product data setting system, and a price display setting method .

Conventionally, an application for realizing a shopping site such as an online supermarket is provided by an ASP service (Application Service Provider Service).

Prior to the recent revision of the consumption tax rate, in addition to the previously required total amount display (display at the consumption tax price), tax-excluded display is now permitted. However, when displaying tax-excluded items, it is necessary to take measures to prevent them from being mistaken for total amount display.

Until now, in the above-mentioned applications, the display method of the product price has been the total amount display. However, due to the revision of the consumption tax rate, tax-excluded display has become possible, so how to display the price (for example, whether to display the tax-included price or the tax-excluded price mainly) depends on the service user. It is different.

An object to be solved by the present invention is to provide a server device and a program for realizing a shopping site in which a user can easily change the display method of a product price.

The server device of the embodiment provides a shopping site, and includes a tax information acquisition means, a product information acquisition means, a selling price display setting means, and a selling price calculation means. The tax information acquisition means is one of the tax categories and means that the unit price of the product includes tax, and the other is one of the above tax categories and means that the unit price of the product does not include tax. Different for each combination of at least two types of the tax category, one or more types of tax, and the combination of the tax category and the tax rate, which is one of the tax categories and is not taxable. Get information from the tax master that is stored in association with the identifier. The product information acquisition means acquires information from the product master stored in association with the product information that identifies the product, the unit price of the product, and the identifier related to the product. The selling price display setting means inputs a designation for displaying both or one of a numerical value including tax and a numerical value excluding tax as the price per product to be displayed on the product introduction screen of the shopping site. Accept by editing operation to any position of. When displaying the product introduction screen, the selling price calculation means specifies the price per product as received by the selling price display setting means, the unit price of the information acquired by the product information acquisition means, and the product. said tax classification and the rate the tax information obtaining means said identifier associated of the information which the information acquisition means has acquired acquires, calculated on the basis of.

The program of the embodiment causes the computer of the server device that provides the shopping site to function as a tax information acquisition means, a product information acquisition means, a selling price display setting means, and a selling price calculation means. The tax information acquisition means is one of the tax categories and means that the unit price of the product includes tax, and the other is one of the above tax categories and means that the unit price of the product does not include tax. Different for each combination of at least two types of the tax category, one or more types of tax, and the combination of the tax category and the tax rate, which is one of the tax categories and is not taxable. Get information from the tax master that is stored in association with the identifier. The product information acquisition means acquires information from the product master stored in association with the product information that identifies the product, the unit price of the product, and the identifier related to the product. The selling price display setting means inputs a designation for displaying both or one of a numerical value including tax and a numerical value excluding tax as the price per product to be displayed on the product introduction screen of the shopping site. Accept by editing operation to any position of. When displaying the product introduction screen, the selling price calculation means specifies the price per product as received by the selling price display setting means, the unit price of the information acquired by the product information acquisition means, and the product. said tax classification and the rate the tax information obtaining means said identifier associated of the information which the information acquisition means has acquired acquires, calculated on the basis of.

FIG. 1 is a block diagram showing a functional configuration of the server device of the embodiment. FIG. 2 is a diagram showing an example of a tax master of the embodiment. FIG. 3 is a diagram showing an example of the product master of the embodiment. FIG. 4 is a diagram showing an example of the template management table of the embodiment. FIG. 5 is a diagram showing an example of the setting screen of the embodiment. FIG. 6 is a flowchart showing the flow of the selling price display setting process executed by the control unit of the embodiment.

The embodiment will be described with reference to the drawings. FIG. 1 is a block diagram showing a functional configuration of the server device 1 of the embodiment. The server device 1 provides a shopping site (for example, a net supermarket). A shopping site is a web page that sells goods via communication via a computer network (eg, the Internet).

The server device 1 includes a control unit 10, a first storage unit 20, and a second storage unit 30. Further, the server device 1 includes an input device such as a keyboard and a mouse for accepting operations by a user (such as an administrator of a net supermarket) and a display device such as an LCD (Liquid Crystal Display) (both not shown). There is.

The control unit 10 is composed of a CPU (Central Processing Unit), a ROM (Read Only Memory), a RAM (Random Access Memory) (all not shown), and the like.
The ROM stores various programs and various data executed by the CPU. The RAM temporarily stores data and programs when the CPU executes various programs. The CPU controls each part (including the input device and the display device) of the server device 1 by expanding the program read from the ROM into the RAM and executing the program.

The control unit 10 functions as a tax information acquisition means 11, a product information acquisition means 12, a selling price display setting means 13, and a selling price calculating means 14 by executing a program stored in the ROM by the CPU.

The first storage unit 20 and the second storage unit 30 are composed of storage devices such as an HDD (Hard Disk Drive) and a memory, for example.

The first storage unit 20 stores the tax master 21 and the product master 22. FIG. 2 is a diagram showing an example of the tax master 21 of the embodiment. FIG. 3 is a diagram showing an example of the product master 22 of the embodiment. The tax information acquisition means 11 of the control unit 10 acquires information from the tax master 21. The product information acquisition means 12 acquires information from the product master 22.

The tax master 21 stores as tax information the tax classification of the product and the tax rate of the tax classification in association with each other. Further, the tax master 21 also stores a different tax number (identifier) for each combination of the tax classification and the tax rate. The tax number is a unique key. The tax classification is, for example, internal tax, external tax, tax exemption, and the like. The tax rate is 8%, which is the new consumption tax rate, 5%, which is the consumption tax rate before the revision, and 0%, which indicates tax exemption. Only these non-overlapping combinations have tax number types.

The product master 22 stores the unit price of the product and the tax specific information that specifies the tax classification and the tax rate of the product in association with the information that identifies the product. In the present embodiment, the product information that identifies the product is used as the product code or product name, and the tax number is used as the tax specific information. The product code is a unique key. The product master 22 further stores the template number.

The template number is the number of the template 31. There are a plurality of templates 31, and they are stored in the second storage unit 30. Template 31 records the appearance of the product introduction screen (not shown). The product introduction screen is a screen viewed by a purchaser who purchases a product using the net super service provided by the server device 1, and shows the purchaser one or more pieces of information including at least the selling price. Here, the selling price is a numerical value shown to the customer of the shopping site as the price of the product. The template 31 defines the positions and sizes of various parts on the product introduction screen, and also defines the selling price display method. The template 31 is the format information of the product introduction screen.

FIG. 4 is a diagram showing an example of the template management table 32 of the embodiment. The template management table 32 is stored in the second storage unit 30. The template management table 32 stores the template number and the tax number related to the template number in association with each other. In this embodiment, a plurality of templates 31 can be set for one tax number.

FIG. 5 is a diagram showing an example of the setting screen 100 of the embodiment. The setting screen 100 accepts the setting of the selling price display method on the product introduction screen. More specifically, the control unit 10 changes the display content of the setting screen 100 according to the user's operation received by the input device. The setting screen 100 has a number designation unit 110, a template display unit 120, and a material display unit 130.

The template 31 is created by the selling price display setting means 13. The selling price display setting means 13 displays the setting screen 100 on the display device and accepts the operation by the user on the input device. As a result, the selling price display setting means 13 modifies the appearance of the product introduction screen. Further, in this modification, the selling price display setting means 13 accepts the designation of whether the selling price is mainly indicated by the tax-included price or the tax-excluded price. More specifically, the control unit 10 acquires the contents specified by the user through the operation on the input device.

The number designation unit 110 has a tax number designation field 111 and a template number designation field 112. Each of the designated fields 111 and 112 is a combo box, and the options are displayed in a selectable manner. The tax number designation field 111 is a field for accepting the designation of the tax number existing in the tax master 21. The template number designation field 112 is a field for accepting the designation of the template number existing in the template management table 32. The contents based on the template 31 corresponding to the numbers displayed in the designated fields 111 and 112 are displayed on the template display unit 120 of the setting screen 100.

The template display unit 120 has a product image area 121, a selling price area 122, and a save button 123. The product image area 121 shows a guideline such as the position, size, and shape of an area for displaying an image for introducing a product. The selling price area 122 shows a guideline of a position for displaying the selling price, and displays the contents designated as the selling price display method. The save button 123 accepts an operation for saving (overwriting or newly registering) changes in the specified contents made to the selling price area 122.

The material display unit 130 has a method selection button 131 and a character string selection button 132. The method selection button 131 accepts an operation of selecting one of the selling price display methods of the unit price display, the tax-excluded display, and the tax-included display. When the method selection button 131 is selected, the selling price display setting means 13 displays the selected display method in the selling price area 122. The character string selection button 132 accepts an operation of displaying each character string in the selling price area 122.

The selling price calculation means 14 is a numerical value (that is, selling price) shown on the product introduction screen as the price of the product when the data of the product introduction screen is distributed to the display device such as the PC (Personal Computer) of the purchaser (net super service user). Is calculated according to the template 31.

FIG. 6 is a flowchart showing the flow of the selling price display setting process executed by the control unit 10. This process is started by displaying the setting screen 100. In this process, the control unit 10 first accepts the designation of the tax number (step S1). When the user writes the tax number in the tax number designation field 111, the control unit 10 acquires the template number associated with the tax number from the template management table 32 and displays it in the template number designation field 112 as an option. The control unit 10 includes "new" at the top of the options.

Next, the control unit 10 accepts the designation of the template (step S2). When the user selects one of the options in the template number designation field 112, the control unit 10 displays the content corresponding to the selection on the template display unit 120 (step 3) and accepts editing of the selling price area 122 (step S4). ).

More specifically, when "new" is selected in step 2, the standard content (base template) is displayed in step S3, and the creation of a new template 31 in which the standard content is modified is accepted in step S4. .. When a specific template number is specified in step S2, the content of the template 31 with the template number is displayed (step S3), and modification of the template 31 is accepted (step S4).

Next, the control unit 10 waits for an operation on the save button 123 (No in step S5). When the user presses the save button 123 (Yes in step S5), the control unit 10 determines whether the selling price area 122 has been edited (step S6). When the selling price area 122 has been edited (Yes in step S6), the control unit 10 saves the edited contents (step S7).

Here, if the designation in step S2 is "new", the control unit 10 saves the edited content with a new template number. If the designation in step S2 is a specific template number, the control unit 10 overwrites and saves the template 31 of the number with the edited contents.

Then, the control unit 10 ends the process. If the selling price area 122 has not been edited in step S6 (No in step S6), the control unit 10 ends the process.

The method of editing the selling price area 122 received in step S4 will be described below. To display the unit price excluding tax in the selling price area 122, enter "@ unit price excluding tax". To display the unit price including tax, enter "@ unit price including tax". Next, a numerical value (selling price) indicating the price of the product when these "@ unit price tax excluded" or "@ unit price tax included" is entered in the selling price area 122 will be described.

When displaying the product introduction screen, the selling price calculation means 14 confirms the unit price and the tax number of the product by the product master 22. For example, the unit price of a product whose tax number is "04" in the product master 22 is exempt from tax as determined by the tax master 21. In this case, the selling price calculation means 14 sets the numerical value displayed in "@ unit price tax excluded" in the selling price area 122 as the unit price itself of the product master 22. Further, for the same product, the selling price calculation means 14 assumes that the numerical value to be displayed in "@ unit price including tax" in the selling price area 122 is the unit price of the product master 22 plus the tax amount. This tax amount is the value obtained by multiplying the unit price by the tax rate determined by the tax master 21.

Further, the unit price of the product whose tax number is "03" in the product master 22 is tax-included as determined by the tax master 21. In this case, the selling price calculation means 14 sets the numerical value displayed in "@ unit price including tax" in the selling price area 122 as the unit price itself of the product master 22. Further, for the same product, the selling price calculation means 14 assumes that the numerical value to be displayed in "@ unit price tax excluded" in the selling price area 122 is obtained by subtracting the tax amount from the unit price of the product master 22. This tax amount is a value obtained by dividing the unit price by the tax rate determined by the tax master 21.

In the selling price area 122, in addition to the numerical value indicating the price of the product, a character string attached to the numerical value can be displayed. Enter the character string with "" "in front and behind. Also, enter "<br>" at the position where you want to start a new line.

For example, if you want to display the selling price of a product with a tax-excluded price of 100 yen after the "price of 100 yen" with a line break like "(108 yen including tax) by shipping fee", the following (Example 1) in the selling price area 122 Fill in as follows.
"Price" @ unit price tax excluded "yen"<br>"(taxincluded" @ unit price tax included "yen) shipping not included"
… (Example 1)

In filling in the above (Example 1) in the selling price area 122, the user may directly enter the text in the selling price area 122, or drag and drop the method selection button 131 and the character string selection button 132 into the selling price area 122. You may.

The method selection button 131 includes "tax excluded", "tax included", and "unit price". For example, when the "tax excluded" method selection button 131 is dragged and dropped into the selling price area 122, the selling price display setting means 13 writes "@ unit price tax excluded" at the drop position. Similarly, when the "tax-included" method selection button 131 is dragged and dropped into the selling price area 122, the selling price display setting means 13 writes "@ unit price including tax" in the drop position. Further, when the method selection button 131 of the "unit price" is dragged and dropped into the selling price area 122, the selling price display setting means 13 writes "@ unit price" in the drop position. In this case, the unit price of the product master 22 is displayed as it is regardless of the tax number of the product master 22.

The character string selection button 132 includes "price", "yen", "tax included", "tax excluded", "shipping included", "shipping not included", "sale", "recommended", and other blank characters (spaces). ), Line breaks, parentheses, etc.

For example, when the character string selection button 132 of "price" is dragged and dropped into the selling price area 122, the selling price display setting means 13 writes "" price "" in the drop position. That is, when dragging and dropping the character string selection button 132 (excluding the line feed mark), the selling price display setting means 13 fills in the selected character string with "" "in front of and behind it. However, if the line feed mark is dragged and dropped, enter "<br>".

As described above, according to the server device and the program of the present embodiment, it is possible to realize a shopping site in which the user can easily change the display method of the product price. That is, depending on the characteristics of the product and the tax classification, the user can select the one that seems to be effective from the tax-included display or the tax-excluded display as the selling price to be mainly displayed. Here, in the selling price area 122, only one of the tax-included display and the tax-excluded display may be displayed, or both may be displayed. When both are displayed, both the tax-included display and the tax-excluded display may be displayed in the same column, or as in the present embodiment, the parentheses of the tax-included display and the tax-excluded display are displayed as subordinates. There may be a difference in the display method, such as placing it after the person who writes it and mainly displays it.

Further, according to the present embodiment, a character string can be added to the price display. That is, even if the shopping site is provided by the ASP service, "sale", "recommended", "limited time", etc. can be displayed flexibly.

In the embodiment, the tax master 21, the product master 22, the template 31, and the template management table 32 are stored in the first storage unit 20 and the second storage unit 30 included in the server device 1. , These may be stored in a storage unit provided outside the server device 1.

Further, in the embodiment, the tax master 21 and the product master 22 are stored in the same first storage unit 20, and the template 31 and the template management table 32 are stored in the same second storage unit 30. , The tax master 21 and the product master 22 may be stored in different storage units, and similarly, the template 31 and the template management table 32 may be stored in different storage units. On the contrary, the tax master 21, the product master 22, the template 31, and the template management table 32 may all be stored in the same storage unit.

Further, in the embodiment, a plurality of templates 31 can be set for one tax number, but in the implementation, only one template 31 may be set for one tax number. In this case, since the tax number can play the role of the template number, the template number is unnecessary in the product master 22 and the template management table 32 is unnecessary. Further, in the implementation, the same setting is used as the price display method of all products without having a plurality of templates, and the setting of the one display method is accepted by the selling price display setting means 13. You may. In this case, the display method is the same regardless of the tax number of the product master 22.

Further, in the embodiment, the new registration of the template is performed when "new" is selected from the options of the template number designation field 112, the selling price area 122 of the standard content is edited, and the save button 123 is pressed. However, it is not limited to this. In the implementation, for example, when a specific template number is specified from the options in the template number designation field 112, in the present embodiment, the single save button 123 is made into two, a new registration button and an overwrite save button. By pressing the new registration button, the edited contents of the template 31 with the specified template number may be saved as a new template 31 with a different template number.

Further, in the embodiment, editing by drag and drop was introduced as an example of the method of editing the selling price area 122, but in the implementation, a predetermined character string is displayed at the cursor position of the selling price area 122 by pressing the buttons 131 and 132. It may be added, or it may be another method.

Then, in the embodiment, the selling price calculation means 14 calculates the selling price when the product introduction screen is displayed, but in the implementation, the selling price is calculated in advance prior to the display of the product introduction screen and stored in a predetermined storage unit. You may let me do it. As a destination for storing the selling price, for example, a selling price column may be provided in the product master 22 of the first storage unit 20.

The server device of this embodiment includes a control device such as a CPU, a storage device such as a ROM (Read Only Memory) or RAM, an external storage device such as an HDD or a CD drive device, a display device such as a display device, and a keyboard. It is equipped with input devices such as a mouse and a mouse, and has a hardware configuration that uses a normal computer.

The program executed by the server device of this embodiment is a file in an installable format or an executable format and is read by a computer such as a CD-ROM, a flexible disk (FD), a CD-R, or a DVD (Digital Versatile Disk). It is recorded and provided on a possible recording medium.

Further, the program executed by the server device of the present embodiment may be stored on a computer connected to a network such as the Internet and provided by downloading via the network. Further, the program executed by the server device of the present embodiment may be configured to be provided or distributed via a network such as the Internet.

Further, the program of the present embodiment may be configured to be provided by incorporating it into a ROM or the like in advance.

The program executed by the server device of the present embodiment has a modular configuration including the above-mentioned parts (tax information acquisition means 11, product information acquisition means 12, selling price display setting means 13, selling price calculating means 14). When the CPU (processor) executes the program, the tax information acquisition means 11, the product information acquisition means 12, the selling price display setting means 13, and the selling price calculating means 14 are generated on the main storage device.

Although some embodiments of the present invention have been described, these embodiments are presented as examples and are not intended to limit the scope of the invention. These novel embodiments can be implemented in various other embodiments, and various omissions, replacements, and changes can be made without departing from the gist of the invention. These embodiments and modifications thereof are included in the scope and gist of the invention, and are also included in the scope of the invention described in the claims and the equivalent scope thereof.

1 ... Server device,
10 ... Control unit,
11 ... Tax information acquisition means, 12 ... Product information acquisition means,
13 ... Selling price display setting means, 14 ... Selling price calculation means,
20 ... First memory,
21 ... Tax master, 22 ... Product master,
30 ... Second memory,
31 ... template, 32 ... template management table,
100 ... Setting screen,
110 ... Numbering part,
111 ... Tax number specification field, 112 ... Template number specification field,
120 ... Template display,
121 ... Product image area, 122 ... Selling price area, 123 ... Save button,
130 ... Material display,
131 ... Method selection button, 132 ... Character string selection button.

Japanese Unexamined Patent Publication No. 2012-113654

Claims (6)

A server device that provides a shopping site
Internal tax, which is one of the tax categories and means that the unit price of goods includes tax, external tax, which is one of the tax categories and means that the unit price of goods does not include tax, and the tax. At least two of the tax categories, which are one of the categories and are not taxable, are associated with one or more types of tax rates and different identifiers for each combination of the tax categories and the tax rates. Tax information acquisition means to acquire information from the stored tax master,
A product information acquisition means for acquiring information from a product master in which product information that identifies a product, a unit price of the product, and the identifier related to the product are associated and stored.
As the price per product to be displayed on the product introduction screen of the shopping site, a designation for displaying both or one of a numerical value including tax and a numerical value excluding tax can be specified at an arbitrary position in the input area. Selling price display setting means accepted by editing operation,
When displaying the product introduction screen, the price per product is specified by the selling price display setting means, the unit price of the information acquired by the product information acquisition means, and the product information acquisition means. said tax classification and the rate the identifier the tax information acquisition means associated to get out of the information, the sales price calculating means for calculating, based on,
A server device that comprises. The selling price display setting means can access a storage unit that stores a template that records the appearance of the product introduction screen, acquires the template from the storage unit, modifies the template according to the designation, and modifies the template. The server device according to claim 1, wherein the later template is overwritten and saved or newly registered in the storage unit. The server device according to claim 2, wherein the template also includes setting the position or size of an area for displaying an image of a product. The computer of the server device that provides the shopping site,
Internal tax, which is one of the tax categories and means that the unit price of goods includes tax, external tax, which is one of the tax categories and means that the unit price of goods does not include tax, and the tax. At least two of the tax categories, which are one of the categories and are not taxable, are associated with one or more types of tax rates and different identifiers for each combination of the tax categories and the tax rates. Tax information acquisition means to acquire information from the stored tax master,
A product information acquisition means for acquiring information from a product master in which product information that identifies a product, a unit price of the product, and the identifier related to the product are associated and stored.
As the price per product to be displayed on the product introduction screen of the shopping site, a designation for displaying both or one of a numerical value including tax and a numerical value excluding tax can be specified at an arbitrary position in the input area. Selling price display setting means accepted by editing operation,
When displaying the product introduction screen, the price per product is specified by the selling price display setting means, the unit price of the information acquired by the product information acquisition means, and the product information acquisition means. said tax classification and the rate the identifier the tax information acquisition means associated to get out of the information, the sales price calculating means for calculating, based on,
A program that functions as. A product data setting system that provides a shopping site
Internal tax, which is one of the tax categories and means that the unit price of goods includes tax, external tax, which is one of the tax categories and means that the unit price of goods does not include tax, and the tax. At least two of the tax categories, which are one of the categories and are not taxable, are associated with one or more types of tax rates and different identifiers for each combination of the tax categories and the tax rates. Tax information acquisition means to acquire information from the stored tax master,
A product information acquisition means for acquiring information from a product master in which product information that identifies a product, a unit price of the product, and the identifier related to the product are associated and stored.
As the price per product to be displayed on the product introduction screen of the shopping site, a designation for displaying both or one of a numerical value including tax and a numerical value excluding tax can be specified at an arbitrary position in the input area. Selling price display setting means accepted by editing operation,
When displaying the product introduction screen, the price per product is specified by the selling price display setting means, the unit price of the information acquired by the product information acquisition means, and the product information acquisition means. said tax classification and the rate the identifier the tax information acquisition means associated to get out of the information, the sales price calculating means for calculating, based on,
Product data setting system with. It is a price display setting method executed by the product data setting system that provides a shopping site.
Internal tax, which is one of the tax categories and means that the unit price of goods includes tax, external tax, which is one of the tax categories and means that the unit price of goods does not include tax, and the tax. At least two of the tax categories, which are one of the categories and are not taxable, are associated with one or more types of tax rates and different identifiers for each combination of the tax categories and the tax rates. The tax information acquisition step to acquire information from the stored tax master,
A product information acquisition step of acquiring information from a product master in which product information that identifies a product, a unit price of the product, and the identifier related to the product are associated and stored.
As the price per product to be displayed on the product introduction screen of the shopping site, a designation for displaying both or one of a numerical value including tax and a numerical value excluding tax can be specified at an arbitrary position in the input area. The selling price display setting step accepted by editing operation and
When displaying the product introduction screen, the price per product is specified by the selling price display setting step, the unit price of the information acquired by the product information acquisition step, and the product information acquisition step. said tax classification and the rate said tax information acquiring step identifier is associated to get out of the information, the sales price calculation step of calculating, based on,
Price display setting method including.

Images