Shipping fee management device, shipping fee management method, and shipping fee management program
The shipping fee management device automates the determination of shipping fees based on delivery destination and product type, reducing the manual workload by using a control unit to calculate and generate shipping fee data, thereby streamlining the management process.
Patent Information
- Application Number
- JP2022133514
- Authority / Receiving Office
- JP · JP
- Patent Type
- Patents
- Current Assignee / Owner
- Filing Date
- 2022-08-24
- Publication Date
- 2026-01-06
- Estimated Expiration
- 2042-08-24
AI Technical Summary
Conventional shipping fee management systems require manual input or modification of shipping costs based on destination and goods type, leading to a heavy workload.
A shipping fee management device that automatically determines shipping fees based on delivery destination and product type using a control unit, including a shipping fee generation determination unit and a shipping fee data creation unit, which calculates and generates shipping fee data based on weighted values for product types and delivery destinations.
Reduces the workload associated with managing shipping fees by automating the calculation process.
Smart Images

Figure 0007794710000001 
Figure 0007794710000002 
Figure 0007794710000003
Abstract
Description
[Technical Field]
[0001] The present invention relates to a shipping fee management device, a shipping fee management method, and a shipping fee management program. [Background technology]
[0002] Systems are known that calculate shipping fees for goods according to a predetermined fee structure. For example, a system has been disclosed that calculates shipping fees according to the addresses of the delivery source and the delivery destination of the goods. [Prior art documents] [Patent documents]
[0003] [Patent Document 1] Japanese Patent Publication No. 2020-126502 Summary of the Invention [Problem to be solved by the invention]
[0004] However, the conventional technology did not automatically calculate shipping costs based on destination information other than the address or the type of goods being delivered, nor did it automatically determine whether shipping costs would be incurred. Therefore, the conventional technology required users to manually input or modify shipping costs based on the destination, type of goods, etc. In other words, the conventional technology imposed a heavy workload on managing shipping costs for goods.
[0005] The present invention has been made in consideration of the above problems, and aims to provide a shipping management device, a shipping management method, and a shipping management program that can reduce the workload related to managing shipping fees for goods. [Means for solving the problem]
[0006] In order to solve the above-mentioned problems and achieve the object, the shipping fee management device of the present invention is a shipping fee management device that includes a control unit and manages shipping fees for items, the control unit including: a shipping fee generation determination unit that determines whether shipping fees are incurred for each sales slip based on the delivery destination or the product type indicated in sales data related to the sales slip, which includes at least the delivery destination of the item, the product type, the product number of the product type, and the unit price of the product for the product number; and a shipping fee data creation unit that creates shipping fee data specifying shipping fees for each sales slip based on the determination result of whether shipping fees are incurred. The shipping fee generation determination unit determines whether shipping fees are incurred for each sales slip based on a delivery destination master that specifies whether each delivery destination is excluded from shipping fee calculations and the delivery destination included in the sales slip. The first decision to make Based on a product type master in which points, which are weighted values for shipping charges for each product type, are registered, the total number of points corresponding to the product type included in the sales slip is calculated for each sales slip, and a sales slip for which the calculated total number of points is equal to or greater than a predetermined threshold is determined to have no shipping charges. The second judgment , and it is determined that no shipping fee is incurred for the sales slip that includes the product type of the part number whose unit price is zero. The third judgment ,of All of the first judgment, the second judgment, and the third judgment By judgment If it is not determined that no shipping charges are incurred, it is determined that shipping charges are incurred for the sales slip, and if it is determined that no shipping charges are incurred by at least one of the first, second, and third determinations, it is determined that no shipping charges are incurred for the sales slip. .
[0009] Furthermore, if the points corresponding to the product type included in the sales slip are not registered in the product type master, the shipping fee determination unit outputs error information indicating that the points are not registered.
[0011] Furthermore, the shipping fee management device according to the present invention is Based on the registered collection schedule data for shipping charges for each sales slip, The system further includes an invoice data generating unit that generates invoice data that defines at least the sales amount and shipping fee for each delivery destination.
[0012] Further, a shipping fee management method according to the present invention is a shipping fee management method that is executed by a shipping fee management device that has a control unit and manages shipping fees for goods, and includes a determination step executed by the control unit to determine whether shipping fees are incurred for each sales slip based on the delivery destination or the product type indicated in sales data related to a sales slip that includes at least the delivery destination of the goods, the product type, the product number of the product type, and the unit price of the product for the product number, and a creation step to create shipping fee data that specifies shipping fees for each sales slip based on the determination result of whether shipping fees are incurred, wherein the determination step determines whether shipping fees are incurred for each sales slip based on a delivery destination master that specifies whether each delivery destination is excluded from shipping fee calculations and the delivery destination included in the sales slip. The first decision to make Based on a product type master in which points, which are weighted values for shipping charges for each product type, are registered, the total number of points corresponding to the product type included in the sales slip is calculated for each sales slip, and a sales slip for which the calculated total number of points is equal to or greater than a predetermined threshold is determined to have no shipping charges. The second judgment , and it is determined that no shipping fee is incurred for the sales slip that includes the product type of the part number whose unit price is zero. The third judgment ,of All of the first judgment, the second judgment, and the third judgment By judgment If it is not determined that no shipping charges are incurred, it is determined that shipping charges are incurred for the sales slip, and if it is determined that no shipping charges are incurred by at least one of the first, second, and third determinations, it is determined that no shipping charges are incurred for the sales slip. .
[0013] A shipping fee management program according to the present invention is a shipping fee management program that is executed by a shipping fee management device that has a control unit and manages shipping fees for goods, and includes: a determination step executed by the control unit to determine whether shipping fees are incurred for each sales slip based on the delivery destination or the product type indicated in sales data related to a sales slip that includes at least the delivery destination of the goods, the product type, the product number of the product type, and the unit price of the product for the product number; and a creation step to create shipping fee data that specifies shipping fees for each sales slip based on the determination result of whether shipping fees are incurred, wherein the determination step determines whether shipping fees are incurred for each sales slip based on a delivery destination master that specifies whether each delivery destination is excluded from shipping fee calculations and the delivery destination included in the sales slip. The first decision to makeBased on a product type master in which points, which are weighted values for shipping charges for each product type, are registered, the total number of points corresponding to the product type included in the sales slip is calculated for each sales slip, and a sales slip for which the calculated total number of points is equal to or greater than a predetermined threshold is determined to have no shipping charges. The second judgment , and it is determined that no shipping fee is incurred for the sales slip that includes the product type of the part number whose unit price is zero. The third judgment ,of All of the first judgment, the second judgment, and the third judgment By judgment If it is not determined that no shipping charges are incurred, it is determined that shipping charges are incurred for the sales slip, and if it is determined that no shipping charges are incurred by at least one of the first, second, and third determinations, it is determined that no shipping charges are incurred for the sales slip. . [Effects of the Invention]
[0014] The present invention has the effect of reducing the workload associated with managing shipping fees for goods. [Brief explanation of the drawings]
[0015] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of a shipping fee management device. [Figure 2A] FIG. 2A is a schematic diagram illustrating an example of the data structure of the delivery destination master. [Figure 2B] FIG. 2B is a schematic diagram illustrating an example of the data structure of the product type master. [Figure 2C] FIG. 2C is a schematic diagram showing an example of the data structure of the product number master. [Figure 2D] FIG. 2D is a schematic diagram illustrating an example of the data structure of the shipping fee generation threshold master. [Figure 2E] FIG. 2E is a schematic diagram illustrating an example of the data structure of the shipping fee master. [Figure 2F] FIG. 2F is a schematic diagram showing an example of the data structure of sales data. [Figure 2G] FIG. 2G is a schematic diagram of an example of the data structure of shipping fee data. [Figure 2H] FIG. 2H is a schematic diagram of an example of the data structure of collection schedule data. [Figure 3] FIG. 3 is a schematic diagram of an example of the calculation result of the total number of points. [Figure 4]FIG. 4 is a flowchart showing an example of the flow of information processing executed by the shipping fee management device of this embodiment. DETAILED DESCRIPTION OF THE INVENTION
[0016] Hereinafter, embodiments of a shipping fee management device, a shipping fee management method, and a shipping fee management program according to the present invention will be described in detail with reference to the accompanying drawings. However, the present invention is not limited to these embodiments.
[0017] [1. Configuration] An example of the configuration of a shipping fee management 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 shipping fee management device 100.
[0018] The shipping fee management device 100 of this embodiment is an information processing device for managing information regarding shipping fees for goods. Goods are items for which shipping fees may be incurred due to transportation, delivery, etc. Goods include, for example, merchandise for sale, but are not limited to, goods. Goods include, for example, non-food items such as contact lenses and home appliances, and food items, but are not limited to these.
[0019] The shipping fee management device 100 is, for example, a commercially available desktop personal computer. The shipping fee management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may also be a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.
[0020] The shipping fee management device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units included in the shipping fee management device 100 are connected to each other so as to be able to communicate with each other via any communication path.
[0021] The communication interface unit 104 communicably connects the shipping fee management 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 the communication line. Here, the network 300 has a function of connecting the shipping fee management device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). The various data stored in the memory unit 106 may also be stored in the server 200, for example.
[0022] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to achieve a pointing device function. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.
[0023] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs that work in conjunction with the OS (Operating System) to issue commands to the CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. The storage unit 106 can be, for example, a memory device such as RAM (Random Access Memory) or ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, etc.
[0024] The storage unit 106 stores, for example, a delivery destination master 106a, a product type master 106b, a product number master 106c, a shipping threshold master 106d, a shipping master 106e, sales data 106f, shipping data 106g, and collection schedule data 106h. The delivery destination master 106a, the product type master 106b, the product number master 106c, the shipping threshold master 106d, the shipping master 106e, sales data 106f, shipping data 106g, and collection schedule data 106h are databases and tables that register various types of information. In this embodiment, the structures of the databases, tables, and data used in this embodiment are described in simplified form. The actual structures of these databases, tables, and data are more complex, but parts not directly related to the present invention are shown in simplified form.
[0025] 2A is a schematic diagram showing an example of the data structure of the delivery destination master 106a. The delivery destination master 106a is a database for managing information related to delivery destinations of goods.
[0026] The delivery destination master 106a is a database that associates, for example, delivery destination codes with non-subject to shipping fee calculation flags. A delivery destination code is identification information for a delivery destination. A non-subject to shipping fee calculation flag is a flag that indicates whether a delivery destination identified by the corresponding delivery destination code is not subject to shipping fee calculation. In FIG. 2A, a flag "0" indicates that the delivery destination is subject to shipping fee calculation. A flag "1" indicates that the delivery destination is not subject to shipping fee calculation.
[0027] In the delivery destination master 106a, flags of types designated in advance by users such as sellers or managers of goods are registered in advance for each delivery destination. For example, users such as sellers or managers of goods may designate in advance that delivery destinations such as major customers or good customers are not included in the shipping fee calculation. The shipping fee management device 100 may associate the flags of types designated in advance by the user with the delivery destination codes of the corresponding delivery destinations and register them in advance in the delivery destination master 106a.
[0028] 2B is a schematic diagram showing an example of the data structure of the product type master 106b. The product type master 106b is a database for managing information related to the product type. In this embodiment, the product type master 106b is a database in which points, which are weighting values for shipping charges for each product type, are registered.
[0029] For example, the product type master 106b is a database that associates product type codes with points. A product type code is identification information for the product type. A point is a weighting value set for the corresponding product type with respect to the occurrence of shipping charges. The larger the point value, the lower the possibility that shipping charges will be incurred for the product type identified by the corresponding product type code. The smaller the point value, the higher the possibility that shipping charges will be incurred for the product type identified by the corresponding product type code.
[0030] In the product type master 106b, points designated in advance by users such as product sellers or managers are registered in advance for each product type. For example, users such as product sellers or managers may designate larger points in advance for new products or high-value-added product types in order to promote sales by reducing the possibility of shipping charges. The shipping fee management device 100 may associate the points designated in advance by the user with the corresponding product type code and register them in advance in the product type master 106b. As shown in FIG. 2B, the product type master 106b may include product types for which points have not been registered, depending on the user's designation status, etc.
[0031] Fig. 2C is a schematic diagram showing an example of the data structure of the part number master 106c. The part number master 106c is a database for managing information related to the part numbers of items. For example, the product type master 106b is a database in which part number codes are registered. A part number code is identification information for a part number. Fig. 2C shows an example of a five-digit code as a part number code.
[0032] One or more product numbers are associated with the product type of an item. In FIG. 2C, the first four digits of the product number code represent the product type code. Specifically, for example, product number code "H0001" is an example of the product number code for product type code "H000". Therefore, it can be said that product number codes corresponding to product types are registered in product number master 106c. Note that product number master 106c may be a database that associates product type codes with product number codes.
[0033] Fig. 2D is a schematic diagram showing an example of the data structure of the shipping fee threshold master 106d. The shipping fee threshold master 106d is a database for managing the threshold for shipping fee occurrence relative to the total number of points. Details of the total number of points will be described later. Fig. 2D shows an example in which "12" is registered as the threshold value.
[0034] 2E is a schematic diagram showing an example of the data structure of the shipping fee master 106e. The shipping fee master 106e is a database for managing shipping fees. FIG. 2E shows an example in which 500 yen is registered as the shipping fee.
[0035] 2F is a schematic diagram showing an example of the data structure of sales data 106f. Sales data 106f is a database for managing information related to the sales of goods for each sales slip. A sales slip includes at least information related to the delivery destination of the goods and the type of goods.
[0036] For example, sales data 106f is a database that associates sales numbers, row numbers, order numbers, delivery destination codes, product code, part number codes, and unit prices. The sales number is sales identification information. The row number is a number assigned to each product number included in the sales. The order number is order identification information. The unit price is information that represents the unit price of an item of a product type identified by the corresponding product code and a product number identified by the corresponding part number code.
[0037] A sales number is assigned to each sales slip. In the sales data 106f shown in FIG. 2F, a group of data corresponding to the same sales number corresponds to the data of one sales slip. That is, FIG. 2F shows an example in which data related to six sales slips identified by sales numbers "30001" through "30006" are registered in the sales data 106f (see A through F in FIG. 2F).
[0038] Hereinafter, the sales slips identified by sales numbers "30001" to "30006" may be referred to as sales slip A to sales slip F, respectively.
[0039] The sales data 106f is created, for example, for each predetermined period, such as each day, in accordance with the sales status of the product. The sales data 106f may be created by an external information processing device that manages the sale of the product for each predetermined period, such as each day, and stored in the storage unit 106. Alternatively, the sales data 106f may be created by the control unit 102 in accordance with the sales status of the product for each predetermined period, such as each day, and stored in the storage unit 106.
[0040] 2G is a schematic diagram of an example of the data structure of the shipping fee data 106g. The shipping fee data 106g is a database for managing shipping fees for each sales slip.
[0041] For example, the shipping fee data 106g is a database that associates sales numbers, order numbers, and shipping fees. The shipping fee data 106g is created by processing by the control unit 102, which will be described later.
[0042] 2H is a schematic diagram of an example of the data structure of the collection schedule data 106h. The collection schedule data 106h is a database for managing original data used when creating invoice data for each delivery destination.
[0043] For example, the collection schedule data 106h is a database that associates sales numbers, invoice numbers, and estimated collection amounts. The invoice number is identification information for the invoice data. The estimated collection amount is the amount to be invoiced to the delivery destination indicated on the sales slip identified by the corresponding sales number. The estimated collection amount includes the sales amount of the item and the calculated shipping fee. The collection schedule data 106h is created by processing by the control unit 102, which will be described later.
[0044] Returning to Figure 1, the explanation will continue. The control unit 102 is a CPU or the like that performs overall control of the shipping fee management device 100. The control unit 102 has an internal memory for storing control programs such as an OS (operating system), programs that define various processing procedures, required data, etc., and executes various information processing operations based on these stored programs.
[0045] In this embodiment, the control unit 102 includes a shipping fee determination unit 102a, a shipping fee data creation unit 102b, and an invoice data generation unit 102c.
[0046] The shipping charge determination unit 102a determines whether shipping charges are incurred for each sales slip, based on the delivery destination and product type indicated in the sales data 106f relating to the sales slip, which includes at least the delivery destination and product type of the product.
[0047] In detail, the shipping charge determination unit 102a determines whether shipping charges are incurred for each sales slip based on the delivery destination master 106a, which specifies whether each delivery destination is exempt from shipping charge calculations, and the delivery destination included in the sales slip.
[0048] The shipping fee determination unit 102a also calculates the total number of points corresponding to the product type included in each sales slip based on the product type master 106b, which registers points that are weighted for shipping fees for each product type.The shipping fee determination unit 102a then determines that no shipping fee will be charged for sales slips for which the calculated total number of points is equal to or exceeds a predetermined threshold.
[0049] Furthermore, if the points corresponding to the product type included in the sales slip are not registered in the product number master 106c, the shipping fee determination unit 102a outputs error information indicating that the points are not registered.
[0050] The sales slip included in the sales data 106f further includes the product number of the product type and the unit price of the product with that product number. The shipping fee determination unit 102a determines that no shipping fee is required for a sales slip that includes a product type with a product number whose unit price is zero.
[0051] The invoice data generating unit 102c generates invoice data that defines at least the sales amount and shipping fee for each delivery destination based on the sales data 106f and shipping fee data 106g generated according to the result of determining whether shipping fees are incurred.
[0052] The flow of processing in the control unit 102 will be described in detail below using a specific example.
[0053] For example, it is assumed that the data shown in each of FIGS. 2A to 2E is registered in each of delivery destination master 106a, product type master 106b, part number master 106c, shipping fee threshold master 106d, and shipping fee master 106e.
[0054] Also, it is assumed that the sales data 106f to be processed is the sales data 106f shown in FIG. 2F.
[0055] As described above, the following description will assume that sales data 106f is generated daily and registered in storage unit 106. As shown in FIG. 2F, the following description will assume that sales data 106f contains data on six sales slips, sales slip A to sales slip F, each identified by a sales number.
[0056] The control unit 102 executes the following process for each sales slip registered in the sales data 106f.
[0057] The shipping fee determination unit 102a determines whether points corresponding to the product type included in the sales slip are registered in the product type master 106b. A product type for which points are registered means that a value representing points is registered in the product type master 106b in association with a product type code. If points corresponding to the product type are not registered in the product type master 106b, the shipping fee determination unit 102a outputs error information indicating that the product type is not registered.
[0058] Furthermore, the shipping fee determination unit 102a determines that a sales slip for which points corresponding to the product type are not registered in the product type master 106b is not subject to shipping fee calculation, i.e., that no shipping fee will be incurred. Note that the shipping fee determination unit 102a may also determine that a sales slip for which points corresponding to the product type are not registered in the product type master 106b is not subject to the creation of invoice data, which will be described later. In this embodiment, an example will be described in which a sales slip for which points corresponding to the product type are not registered in the product type master 106b is not subject to shipping fee calculation, i.e., that no shipping fee will be incurred.
[0059] In the case of the sales data 106f shown in FIG. 2F, for each of the product code "H000" to "H003" included in sales slips A to E, among the sales slips A to F, the corresponding points are registered in the product master 106b (see also FIG. 2B). On the other hand, for the product code " H0 For "04", no corresponding point is registered in the product type master 106b (see also FIG. 2B).
[0060] Therefore, in this case, the shipping fee determination unit 102a determines whether the product code " H0 For sales slip F containing "04", error information indicating that points have not been registered is created. For example, the error information includes information indicating the variety or variety code for which points have not been registered, and a message indicating that points have not been registered.
[0061] The shipping fee generation determination unit 102a then transmits the created error information via the communication interface unit 104 to the information processing device of the user, such as the manager or seller of the product type identified by the product type code included in the sales slip F. By outputting the error information, the shipping fee management device 100 can notify the user of the product type for which points have not been registered, and can prompt the user to register points for that product type.
[0062] Furthermore, the shipping charge determination unit 102a may determine that sales slip F including a product type for which points are not registered is not subject to shipping charge calculation, that is, no shipping charge is incurred.
[0063] On the other hand, shipping fee determination unit 102a determines that sales slips A to E are subject to shipping fee calculation, that is, that shipping fees will be incurred.
[0064] Furthermore, the shipping charge determination unit 102a determines whether shipping charges are incurred for each sales slip based on the delivery destination included in the sales slip and the delivery destination master 106a.
[0065] Specifically, the shipping fee determination unit 102a identifies a shipping fee exemption flag in the delivery destination master 106a that corresponds to the delivery destination code included in the sales slip. If the identified shipping fee exemption flag is a "1" indicating that a shipping fee is not calculated, the shipping fee determination unit 102a determines that the sales slip is not subject to shipping fee calculation, i.e., that no shipping fee is incurred. On the other hand, if the identified shipping fee exemption flag is a "0" indicating that a shipping fee is calculated, the shipping fee determination unit 102a determines that the sales slip is subject to shipping fee calculation, i.e., that shipping fees are incurred.
[0066] In the case of sales data 106f shown in FIG. 2F, of sales slips A through F, the delivery destination codes included in sales slips A through C are "R001" through "R003," respectively. In delivery destination master 106a shown in FIG. 2A, the "except for shipping fee calculation" flags corresponding to these delivery destination codes "R001" through "R003" are set to "0," indicating that shipping fees are subject to calculation. Therefore, shipping fee determination unit 102a determines that sales slips A through C are subject to shipping fee calculation, i.e., that shipping fees are due.
[0067] Similarly, of sales slips A through F, the delivery destination codes included in sales slips E through F are "R001" through "R002," respectively. In delivery destination master 106a shown in FIG. 2A, the "exempt from shipping cost calculation" flags corresponding to these delivery destination codes "R001" through "R002" are set to "0," indicating that shipping costs are subject to calculation. Therefore, shipping cost determination unit 102a determines that sales slips E through F are also subject to shipping cost calculation, i.e., that shipping costs are due.
[0068] On the other hand, among sales slips A to F, the delivery destination code included in sales slip D is "R004." In delivery destination master 106a shown in FIG. 2A, the "Exclude shipping fee calculation" flag corresponding to delivery destination code "R004" is set to "1," indicating that shipping fees are not calculated. Therefore, shipping fee determination unit 102a determines that sales slip D is not subject to shipping fee calculation, meaning that no shipping fees will be incurred.
[0069] Here, sales slip F is determined not to be subject to shipping fee calculation, i.e., no shipping fee will be incurred, based on the above determination of whether points are registered in product type master 106b. Therefore, based on these determinations, shipping fee determination unit 102a determines that, of sales slips A through F, sales slips A through C and sales slip E are subject to shipping fee calculation, i.e., shipping fees will be incurred.
[0070] The shipping charge determination unit 102a also determines whether or not each sales slip contains a product type with a product number whose unit price is zero.
[0071] A product type with an item number with a unit price of zero is a product type for which a user such as a seller or administrator does not wish to collect payment. Examples of products with an item number with a unit price of zero include sample products and substitute products for products desired to be purchased.
[0072] The shipping fee determination unit 102a determines that a sales slip that includes a product type with a zero unit price is not subject to shipping fee calculation, i.e., no shipping fee will be incurred. Also, the shipping fee determination unit 102a determines that a sales slip that does not include a product type with a zero unit price is subject to shipping fee calculation, i.e., shipping fee will be incurred.
[0073] In the case of sales data 106f shown in FIG. 2F, among sales slips A to F, sales slips A, B, D to F do not include any items with product numbers whose unit prices are zero. On the other hand, sales slip C includes an item with product number code "H0023" whose unit price is zero.
[0074] Therefore, the shipping fee determination unit 102a determines that sales slip C is not subject to shipping fee calculation, i.e., that no shipping fee will be incurred. The shipping fee determination unit 102a also determines that sales slip A, sales slip B, and sales slip D to sales slip F are subject to shipping fee calculation, i.e., that shipping fees will be incurred.
[0075] However, sales slip D is determined to be exempt from shipping fee calculation, i.e., no shipping fee will be incurred, based on the above determination using the flag indicating exemption from shipping fee calculation. Furthermore, sales slip F is determined to be exempt from shipping fee calculation, i.e., no shipping fee will be incurred, based on the above determination of whether points are registered in the product type master 106b. Therefore, based on these determinations, the shipping fee determination unit 102a determines that, of sales slips A through F, sales slips A through B and sales slip E are exempt from shipping fee calculation, i.e., shipping fees will be incurred.
[0076] In addition, for each sales slip for which it has determined that points corresponding to the product type included in the sales slip are registered in the product type master 106b, the shipping fee determination unit 102a calculates the total number of points corresponding to the product type included in the sales slip based on the product type master 106b (see Figure 2B).
[0077] In the case of sales data 106f shown in FIG. 2F, of sales slips A to F, for sales slips A to E, points corresponding to the included product types are registered in product type master 106b, as described above.
[0078] Sales slip C is determined to be exempt from shipping cost calculations, i.e., no shipping costs will be incurred, based on the above determination of whether it contains an item with a product number whose unit price is zero. Sales slip D is determined to be exempt from shipping cost calculations, i.e., no shipping costs will be incurred, based on the above determination of the flag indicating that it is exempt from shipping cost calculations. Sales slip F is determined to be exempt from shipping cost calculations, i.e., no shipping costs will be incurred, based on the above determination of whether points are registered in product type master 106b.
[0079] Therefore, the shipping fee occurrence determination unit 102a calculates the total number of points corresponding to the product types included in sales slips A to F that are subject to shipping fee calculation in any of the above multiple types of determinations, i.e., sales slips A to B and sales slip E that are determined to have shipping fees.
[0080] FIG. 3 is a schematic diagram of an example of the calculation result of the total number of points.
[0081] For sales slip A, identified by sales number "30001," the points corresponding to the product code "H000" included in each of the three pairs of product code and item code included is "3" (see Figures 2F and 2B). Therefore, the shipping fee determination unit 102a calculates the total number of points for sales slip A as "9."
[0082] For sales slip B, identified by sales number "30003," the points corresponding to the product code "H001" included in each of the three pairs of product code and item code included is "4." Therefore, the shipping fee determination unit 102a calculates the total number of points for sales slip B as "12."
[0083] For sales slip E, identified by sales number "30005," the points corresponding to the product type code "H000" included in one of the three pairs of product type code and product code included in the slip are "3" (see Figures 2F and 2B). The points corresponding to the product type code "H001" included in each of the remaining two pairs are "4" (see Figures 2F and 2B). Therefore, the shipping fee determination unit 102a calculates the total number of points for sales slip E as "11."
[0084] In this embodiment, the shipping fee determination unit 102a calculates the total number of points for each sales slip by adding points for each pair of a product type code and a product code. However, the method for calculating the total number of points is not limited to this calculation method. For example, assume that the sales data 106f includes the number of items (sales volume) for each product code. In this case, the shipping fee determination unit 102a may calculate the total number of points for each sales slip by multiplying the points corresponding to the product type code included in the pair of a product type code and a product code by the number of corresponding items.
[0085] Next, the shipping fee generation determination unit 102a determines that sales slips whose calculated total points are equal to or greater than the threshold value shown in the shipping fee generation threshold master 106d (see FIG. 2D) are not subject to shipping fee calculation, i.e., do not incur shipping fees.Furthermore, the shipping fee generation determination unit 102a determines that sales slips whose calculated total points are less than the threshold value shown in the shipping fee generation threshold master 106d (see FIG. 2D) are subject to shipping fee calculation, i.e., do incur shipping fees.
[0086] Specifically, of the sales slips A, B, and E for which the total points shown in Figure 3 have been calculated, the shipping fee determination unit 102a determines that sales slip B, whose total points are equal to or greater than the threshold "12" registered in the shipping fee threshold master 106d, is not subject to shipping fee calculation, i.e., that no shipping fee will be charged. Also, of the sales slips A, B, and E for which the total points shown in Figure 3 have been calculated, the shipping fee determination unit 102a determines that sales slip A and sales slip E, whose total points are less than the threshold "12" registered in the shipping fee threshold master 106d, are not subject to shipping fee calculation. elephant, In other words, shipping charges will be incurred Yes It is judged that:
[0087] Then, the shipping fee data creating unit 102b creates shipping fee data 106g that defines the shipping fee for each sales slip, depending on the result of the determination by the shipping fee determination unit 102a as to whether or not shipping fees are incurred.
[0088] Specifically, for sales slips that are determined by at least one of the multiple types of determinations made by the shipping fee generation determination unit 102a to be exempt from shipping fee calculation, i.e., that no shipping fee will be incurred, the shipping fee data creation unit 102b sets information indicating that no shipping fee will be incurred in the shipping fee data 106g. Also, for sales slips that are determined by all of the multiple types of determinations made by the shipping fee generation determination unit 102a to be subject to shipping fee calculation, i.e., that shipping fee will be incurred, the shipping fee data creation unit 102b registers the shipping fee registered in the shipping fee master 106e in the shipping fee data 106g.
[0089] 2G, for sales slip A and sales slip E, which are determined by the shipping fee determination unit 102a to be subject to shipping fee calculation, i.e., to incur shipping fee, the shipping fee data creation unit 102b registers the shipping fee of "500" registered in the shipping fee master 106e in shipping fee data 106g. On the other hand, for sales slips B through D, which are determined to be not subject to shipping fee calculation, i.e., to incur no shipping fee, the shipping fee data creation unit 102b registers a shipping fee of "0" in association with sales numbers "30002" through "30004," which are the identification information for these sales slips. Furthermore, for sales slip F, which is determined to be not subject to shipping fee calculation and not to have shipping fee data created because it includes a product type for which points are not registered, the shipping fee data creation unit 102b does not register data in shipping fee data 106g. The shipping fee data creation unit 102b may also register a shipping fee of "0" for sales slip F in the shipping fee data 106g in association with the sales number "30006" that is the identification information for sales slip F.
[0090] Then, the shipping fee data creating unit 102b generates the collection schedule data 106h. For example, the shipping fee data creating unit 102b generates the collection schedule data 106h shown in FIG.
[0091] As described above, the collection schedule data 106h is a database for managing the original data used when creating invoice data for each sales slip. The shipping fee data creation unit 102b associates the total of the corresponding unit prices indicated in the sales data 106f with the sales number used to identify each sales slip and registers this total as sales in the "planned collection amount" field of the collection schedule data 106h. The shipping fee generation determination unit 102a also associates the corresponding shipping fee indicated in the shipping fee data 106g with the sales number used to identify each sales slip and registers this in the "planned collection amount" field of the collection schedule data 106h. Through these processes, the shipping fee generation determination unit 102a generates collection schedule data 106h, which registers sales and shipping fees for each sales slip identified by the sales number.
[0092] In the example shown in Figure 2H, in the collection schedule data 106h, sales slip A and sales slip E, identified by sales numbers "30001" and "30005," respectively, have sales "300" and shipping fee "500" registered as the planned collection amount. Also, in the collection schedule data 106h, sales slips B through D and sales slip F, identified by sales numbers "30002" through "30004" and "30006," respectively, have sales "300" registered as the planned collection amount, and shipping fee is not registered.
[0093] The invoice data generation unit 102c generates invoice data that specifies at least the sales amount and shipping fee for each delivery destination based on the sales data 106f and the shipping fee data 106g. For example, the invoice data generation unit 102c generates invoice data using the collection schedule data 106h generated based on the sales data 106f and the shipping fee data 106g.
[0094] Specifically, for example, the invoice data generation unit 102c generates invoice data based on the collection schedule data 106h for each predetermined period, such as one month. In more detail, the invoice data generation unit 102c generates invoice data for each delivery destination by aggregating the sales and shipping fees registered in the collection schedule data 106h for each delivery destination identified by a delivery destination code included in a sales slip identified by a sales number registered in the collection schedule data 106h.
[0095] The invoice data generation unit 102c may also aggregate the sales registered in the collection schedule data 106h for each delivery destination identified by a delivery destination code included in a sales slip identified by a sales number registered in the collection schedule data 106h.The invoice data generation unit 102c may then output invoice data in which items other than shipping fees are set to the monitor 114 or the like.The user may input the shipping fee value indicated in the collection schedule data 106h or the shipping fee data 106g for each invoice data by operating the input device 112 while visually checking the monitor 114 and the collection schedule data 106h or the shipping fee data 106g.The invoice data generation unit 102c may then output invoice data including the input shipping fees.
[0096] Next, an example of the flow of information processing executed by the shipping fee management device 100 of this embodiment will be described.
[0097] FIG. 4 is a flowchart showing an example of the flow of information processing executed by the shipping fee management device 100 of this embodiment.
[0098] The shipping fee determination unit 102a reads the sales data 106f from the storage unit 106 (step S100).
[0099] The control unit 102 repeats the processes of steps S102 to S118 for each of one or more sales slips included in the sales data 106f read in step S100.
[0100] Specifically, the shipping fee determination unit 102a determines whether points corresponding to the product type included in the sales slip being processed are registered in the product type master 106b (step S102). If it determines that the points are not registered in the product type master 106b (step S102: No), the process proceeds to step S104. In step S104, the shipping fee determination unit 102a generates and outputs error information indicating that the points are not registered in the product type master 106b (step S104). The process then proceeds to step S116, which will be described later.
[0101] On the other hand, if it is determined that the points are registered in the product type master 106b (step S102: Yes), the process proceeds to step S106.
[0102] In step S106, the shipping charge determination unit 102a determines whether the delivery destination included in the sales slip is a delivery destination that is not subject to shipping charge calculation (step S106).
[0103] The shipping charge determination unit 102a identifies the shipping charge non-calculation flag in the delivery destination master 106a that corresponds to the delivery destination code included in the sales slip. If the identified shipping charge non-calculation flag is a flag "1" indicating that the sales slip is not subject to shipping charge calculation, the shipping charge determination unit 102a determines that the sales slip is not subject to shipping charge calculation, i.e., that no shipping charge is incurred, and makes a positive determination in step S106 (step S106: Yes). The process then proceeds to step S116, which will be described later.
[0104] On the other hand, if the specified non-shipping-subject flag is "0," which indicates that the shipping fee is subject to calculation, the shipping fee determination unit 102a determines that the sales slip is subject to shipping fee calculation, i.e., that shipping fees are incurred, and makes a negative determination in step S106 (step S106: No).Then, the process proceeds to step S108.
[0105] In step S108, the shipping fee determination unit 102a determines whether the sales slip includes a product type with a product number whose unit price is zero (step S108). The shipping fee determination unit 102a makes the determination in step S108 by determining whether a product type with a product number whose unit price is zero is registered in the sales data 106f in association with the sales number, which is the identification information of the sales slip to be processed.
[0106] If the shipping charge determination unit 102a determines that the sales slip contains a product type with a zero unit price (step S108: Yes), it determines that the sales slip is not subject to shipping charge calculation, i.e., no shipping charge will be incurred, and proceeds to step S116, which will be described later.If the shipping charge determination unit 102a determines that the sales slip does not contain a product type with a zero unit price (step S108: No), it determines that the sales slip is subject to shipping charge calculation, i.e., shipping charge will be incurred, and proceeds to step S110.
[0107] In step S110, the shipping fee determination unit 102a calculates the total number of points corresponding to the product type included in the sales slip based on the product type master 106b (step S110).Then, the shipping fee determination unit 102a determines whether the total number of points calculated in step S110 is equal to or greater than the threshold value indicated in the shipping fee threshold master 106d (see FIG. 2D) (step S112).
[0108] If the shipping fee generation determination unit 102a determines that the total number of points is equal to or greater than the threshold (step S112: Yes), it determines that the item is not subject to shipping fee calculation, i.e., no shipping fee will be incurred, and proceeds to step S116, which will be described later.If the shipping fee generation determination unit 102a determines that the total number of points is less than the threshold (step S112: No), it determines that the item is subject to shipping fee calculation, i.e., shipping fee will be incurred, and proceeds to step S114.
[0109] In step S114, the shipping fee data creation unit 102b generates the shipping fee data 106g by registering the shipping fee registered in the shipping fee master 106e in association with the sales number, which is the identification information of the sales slip in the shipping fee data 106g (step S114). Then, the process proceeds to step S118.
[0110] On the other hand, if it is determined that the item is not subject to shipping calculation, i.e., that no shipping fee is incurred, the shipping fee data creation unit 102b generates shipping fee data 106g by registering information indicating a shipping fee of "0" as information indicating no shipping fee, in association with the sales number, which is the sales slip identification information, in shipping fee data 106g (step S116).Then, the process proceeds to step S118.
[0111] Next, the shipping fee data creation unit 102b uses the sales data 106f read in step S100 and the shipping fee data 106g created in step S114 or step S116 to create collection schedule data 106h that defines shipping fees and sales (step S118).
[0112] By repeating the processing of steps S102 to S118 for each of one or more sales slips included in the sales data 106f read by the control unit 102 in step S100, shipping fee data 106g, in which shipping fees for each of the multiple sales slips are registered, and collection schedule data 106h, in which shipping fees and sales for each of the multiple sales slips are registered, are created. Note that the collection schedule data 106h may be generated after the processing of steps S102 to S116 is executed for each of the multiple sales slips.
[0113] Next, the invoice data generation unit 102c determines whether or not to generate invoice data (step S120). For example, the invoice data generation unit 102c makes the determination in step S120 by determining whether or not it is time to generate invoice data. For example, assume that invoice data is generated monthly at a specific time on a specific day within the month. In this case, the invoice data generation unit 102c may make the determination in step S120 by determining whether or not the current timing is a specific time on a predetermined specific day.
[0114] If the determination in step S120 is negative (step S120: No), the process returns to step S100. If the determination in step S120 is positive (step S120: Yes), the process proceeds to step S122.
[0115] In step S122, the invoice data generation unit 102c generates invoice data that specifies at least the sales amount and shipping fee for each delivery destination based on the sales data 106f and the shipping fee data 106g. The invoice data generation unit 102c then outputs the generated invoice data (step S122). This routine then ends.
[0116] As described above, the shipping fee management device 100 of this embodiment is a shipping fee management device that includes a control unit 102 and manages shipping fees for items. The control unit 102 includes a shipping fee determination unit 102a and a shipping fee data creation unit 102b. The shipping fee determination unit 102a determines whether shipping fees are incurred for each sales slip based on the delivery destination and product type indicated in sales data 106f related to the sales slip, which includes at least the delivery destination and product type of the item. The shipping fee data creation unit 102b creates shipping fee data 106g that specifies shipping fees for each sales slip based on the result of the determination of whether shipping fees are incurred.
[0117] In this way, the shipping fee management device 100 of this embodiment determines whether shipping fees are charged for each sales slip based on the delivery destination and product type indicated in sales data 106f related to the sales slip, which includes at least the delivery destination and product type of the item.Then, the shipping fee data creation unit 102b creates shipping fee data 106g that specifies shipping fees for each sales slip based on the result of the determination of whether shipping fees are charged.
[0118] Therefore, the shipping fee management device 100 of this embodiment can determine whether shipping fees will be charged based on the delivery destination and product type, and generate shipping fee data 106g based on the determination result, without the user having to determine whether shipping fees will be charged or correct the input shipping fees based on the delivery destination and product type, etc.
[0119] Therefore, the shipping fee management device 100 of this embodiment can reduce the workload related to managing shipping fees for goods.
[0120] Furthermore, in the shipping fee management device 100 of this embodiment, the shipping fee generation determination unit 102a determines whether or not shipping fees are generated for each sales slip, depending on the delivery destination and product type indicated in the sales data 106f. Therefore, the shipping fee management device 100 of this embodiment can unify the determination criteria and reduce human error, enabling high-precision shipping fee management.
[0121] In addition, in the shipping fee management device 100 of this embodiment, the invoice data generation unit 102c generates invoice data that specifies sales and shipping fees for each delivery destination based on the shipping fee data 106g. In this way, in the shipping fee management device 100 of this embodiment, invoice data is generated based on the shipping fee data 106g that is generated in accordance with the determination result of the shipping fee generation determination unit 102a as to whether or not a shipping fee is regulated, so that it is possible to prevent oversight of fee collection.
[0122] Furthermore, in the shipping fee management device 100 of this embodiment, if the points corresponding to the product type included in the sales slip are not registered in the product type master 106b, error information indicating that the points are not registered is output. Therefore, the shipping fee management device 100 of this embodiment can easily provide the user with information regarding sales slips for which shipping fees could not be calculated.
[0123] Furthermore, the shipping fee management device 100 of this embodiment determines whether shipping fees are incurred for each sales slip based on the shipping destination master 106a, which defines whether each shipping destination is excluded from shipping fee calculations, and the shipping destination included in the sales slip. Therefore, the shipping fee management device 100 of this embodiment can easily manage whether or not a specific shipping destination is excluded from shipping fee calculations.
[0124] Furthermore, the shipping fee management device 100 of this embodiment determines that no shipping fee is required for a sales slip that includes a product type with an item number whose unit price is zero. As described above, a product type with an item number whose unit price is zero is a product type for which a user such as a seller or administrator does not wish to collect payment. Products with a product number whose unit price is zero are, for example, sample products, substitutes for products desired to be purchased, etc.
[0125] Therefore, the shipping fee management device 100 of this embodiment determines that no shipping fee will be charged for sales slips that include product types with item numbers that have a unit price of zero, and can automatically manage sales slips that include product types for which the user does not wish to collect payment as not subject to shipping fee calculations, i.e., as not incurring shipping fees.
[0126] [2. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to the achievement of SDGs Goals 8 and 9.
[0127] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.
[0128] Furthermore, this embodiment can contribute to strengthening control and governance, which can contribute to the achievement of Goal 16 of the SDGs.
[0129] 3. Other Embodiments The present invention may be implemented in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.
[0130] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.
[0131] Furthermore, 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 drawings can be changed as desired unless otherwise specified.
[0132] Furthermore, with regard to the shipping fee management device 100, the components shown in the drawings are functional concepts, and do not necessarily have to be physically configured as shown in the drawings.
[0133] For example, all or any part of the processing functions of the shipping fee management device 100, particularly the processing functions performed by the control unit 102, may be implemented by a CPU and a program interpreted and executed by the CPU, or may be implemented as hardware using wired logic. The program is recorded on a non-transitory computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the shipping fee management device 100 as needed. That is, a computer program for issuing instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM and cooperates with the CPU to form the control unit.
[0134] This computer program may also be stored in an application program server connected to the shipping fee management device 100 via any network, and all or part of it may be downloaded as needed.
[0135] The program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium or configured as a program product. Here, the term "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) disc.
[0136] Furthermore, a "program" is a data processing method written in any language or description method, and does not matter whether it is in the form of source code or binary code. Note that a "program" is not necessarily limited to a single structure, but also includes a structure that is distributed as multiple modules or libraries, or a structure that achieves its function by cooperating with a separate program, such as an OS. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in this embodiment, as well as the installation procedure after reading, can use well-known configurations and procedures.
[0137] The various databases stored in the memory unit 106 are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and providing websites.
[0138] The shipping fee management 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 any peripheral device is connected. The shipping fee management device 100 may also be realized by installing software (including programs, data, etc.) that causes the device to perform the processing described in this embodiment.
[0139] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit depending on various additions or functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Explanation of symbols]
[0140] 100 Shipping Management Device 102 Control section 102a Shipping fee determination section 102b Shipping Data Creation Department 102c Invoice data generation unit
Claims
1. A shipping fee management device that includes a control unit and manages shipping fees for items, The control unit a shipping charge determination unit that determines whether shipping charges are incurred for each sales slip according to the delivery destination or the product type indicated in sales data related to the sales slip, which includes at least the delivery destination of the item, the product type, the product number of the product type, and the unit price of the product number; a shipping fee data creation unit that creates shipping fee data specifying shipping fees for each sales slip according to the result of determining whether shipping fees are incurred; Equipped with The shipping fee generation determination unit a first determination of whether or not a shipping fee is incurred for each sales slip based on a shipping destination master that specifies whether or not each shipping destination is subject to shipping fee calculation and the shipping destination included in the sales slip; a second judgment that calculates, for each sales slip, the total number of points corresponding to the product type included in the sales slip based on a product type master in which points, which are weighted values for shipping charges for each product type, are registered, and judges that no shipping charges will be incurred for the sales slip for which the calculated total number of points is equal to or greater than a predetermined threshold; and, a third judgment of judging that no shipping fee is incurred for the sales slip including the product type of the product number whose unit price is zero; If it is not determined that no shipping charges are incurred in any of the first, second, and third determinations, it is determined that shipping charges are incurred for the sales slip, If it is determined that no shipping fee is required by at least one of the first determination, the second determination, and the third determination, it is determined that no shipping fee is required for the sales slip. Shipping management device.
2. The shipping fee generation determination unit If the points corresponding to the product type included in the sales slip are not registered in the product type master, output error information indicating that the points are not registered. The shipping fee management device according to claim 1.
3. an invoice data generation unit that generates invoice data based on the shipping fee data and that defines at least the sales amount and shipping fee for each delivery destination based on the collection schedule data in which shipping fees for each sales slip are registered; The shipping fee management device according to claim 1 .
4. A shipping fee management method executed by a shipping fee management device that includes a control unit and manages shipping fees for items, Executed by the control unit, a determining step of determining whether or not a shipping fee is required for each sales slip in accordance with the delivery destination or the product type indicated in sales data relating to the sales slip, the sales data including at least the delivery destination of the item, the product type, the product number of the product type, and the unit price of the product number; a creating step of creating shipping fee data specifying shipping fees for each sales slip according to the determination result of whether or not shipping fees are incurred; Including, The determining step a first determination of whether or not a shipping fee is incurred for each sales slip based on a shipping destination master that specifies whether or not each shipping destination is subject to shipping fee calculation and the shipping destination included in the sales slip; a second judgment that calculates, for each sales slip, the total number of points corresponding to the product type included in the sales slip based on a product type master in which points, which are weighted values for shipping charges for each product type, are registered, and judges that no shipping charges will be incurred for the sales slip for which the calculated total number of points is equal to or greater than a predetermined threshold; and, a third judgment of judging that no shipping fee is incurred for the sales slip including the product type of the product number whose unit price is zero; If it is not determined that no shipping charges are incurred in any of the first, second, and third determinations, it is determined that shipping charges are incurred for the sales slip, If it is determined that no shipping fee is required by at least one of the first determination, the second determination, and the third determination, it is determined that no shipping fee is required for the sales slip. Shipping management method.
5. A shipping fee management program executed by a shipping fee management device that includes a control unit and manages shipping fees for goods, Executed by the control unit, a determining step of determining whether or not a shipping fee is required for each sales slip in accordance with the delivery destination or the product type indicated in sales data relating to the sales slip, the sales data including at least the delivery destination of the item, the product type, the product number of the product type, and the unit price of the product number; a creating step of creating shipping fee data specifying shipping fees for each sales slip according to the determination result of whether or not shipping fees are incurred; Including, The determining step a first determination of whether or not a shipping fee is incurred for each sales slip based on a shipping destination master that specifies whether or not each shipping destination is subject to shipping fee calculation and the shipping destination included in the sales slip; a second judgment that calculates, for each sales slip, the total number of points corresponding to the product type included in the sales slip based on a product type master in which points, which are weighted values for shipping charges for each product type, are registered, and judges that no shipping charges will be incurred for the sales slip for which the calculated total number of points is equal to or greater than a predetermined threshold; and, a third judgment of judging that no shipping fee is incurred for the sales slip including the product type of the product number whose unit price is zero; If it is not determined that no shipping charges are incurred in any of the first, second, and third determinations, it is determined that shipping charges are incurred for the sales slip, If it is determined that no shipping fee is required by at least one of the first determination, the second determination, and the third determination, it is determined that no shipping fee is required for the sales slip. Shipping management program.
Citation Information
Patent Citations
Method for calculating carriage sum and medium recording calculation program of carriage sum
JP1999039385A
Delivery control device, and storage medium
JP2002104620A
Automatic delivery charge calculation system and automatic delivery charge calculation method
JP2006252376A
Merchandise sales processor, merchandise sales processing method, and program
JP2016057755A
Providing apparatus, providing method, and providing program
JP2018128871A