Export marketing support device and export marketing support program
The export sales support device and program use EC site data to predict profits and streamline operations by calculating gross profit rates and amounts, addressing inefficiencies in existing systems and reducing the need for market research.
Patent Information
- Application Number
- JP2024074208
- Authority / Receiving Office
- JP · JP
- Patent Type
- Applications
- Current Assignee / Owner
- Filing Date
- 2024-05-01
- Publication Date
- 2025-11-14
AI Technical Summary
Existing export sales systems fail to predict profits accurately and are inefficient due to the need for extensive market research and complex administrative procedures, leading to risks like dead stock and increased time and effort.
An export sales support device and program that utilize EC sites in both the export destination and origin countries to acquire product information, calculate gross profit rates and amounts based on lowest prices, sales commissions, shipping fees, and past sales data, and streamline operations by displaying and transmitting relevant information to delivery companies.
Enables efficient profit prediction without market research and streamlines export operations by calculating gross profit margins and amounts, reducing administrative burdens and enhancing operational efficiency.
Smart Images

Figure 2025169498000001_ABST
Abstract
Description
[Technical Field]
[0001] The present invention relates to an export sales support device and an export sales support program, and more particularly to an export sales support device and an export sales support program that support the prediction of profits that can be obtained through export sales and the improvement of the efficiency of export operations. [Background technology]
[0002] For example, commercial transactions involving the export of goods from Japan to other countries have been conducted for some time. In such so-called export businesses, it is generally necessary to visit the export destination country and conduct market research to determine the presence and level of demand for the exported goods, the sales situation of similar goods, etc., which requires a lot of time and money. In addition, if the market research is insufficient, there is a risk of having dead stock in the foreign country. In addition, the administrative procedures and accounting procedures related to the export of goods are complicated, which requires a lot of time and effort.
[0003] Patent document 1 discloses a sales management system that includes a domestic communication means for receiving product sales requests from a manufacturer terminal, a management means for assigning first management information to each of the products when a product sales request is received, an overseas communication means for requesting an overseas business device to determine whether the products can be sold and receiving second management information assigned to products that can be sold as a response, and a management information storage means for linking and storing the first management information and the second management information for each of the products, and the management means manages overseas sales involving export of the products from Japan to overseas based on the linked first management information and second management information.
[0004] The purpose of Patent Document 1 is simply to simplify the administrative work in export businesses, but it does not take into consideration the prediction of profits that can be earned from the sale of export goods.
[0005] Patent Document 2 discloses a product information acquisition unit that acquires first product information including the name and quantity of the export product, the export country, and a selling price from a seller of the export product; an estimate calculation unit that calculates a first estimated price by adding a transportation cost for transporting the export product of the name and quantity to the export country indicated in the first product information to the selling price; an information presentation unit that presents export product information including the name and quantity of the export product and the first estimated price to a purchaser in the export country; and a product information acquisition unit that acquires first product information including the name and quantity of the export product, the export country, and a selling price from a seller of the export product. The export support device disclosed includes an order processing unit that receives orders for export items and places orders for the received export items with the seller, and a document data creation unit that creates document data necessary for exporting the export items, wherein the product information acquisition unit further acquires second product information regarding the contents of the export items to be shipped after the order processing unit places an order for the export items, the estimate calculation unit calculates a second estimate based on the second product information, and the document data creation unit creates the document data based on the second estimate.
[0006] In Patent Document 2, when the export item is, for example, agricultural produce, a second estimate is presented if the condition of the export item changes, such as the item deteriorating, between the time the first estimate is presented and the time the export item is shipped, but this does not take into account any predictions of the profits that may be earned from the sale of the export item. [Prior art documents] [Patent documents]
[0007] [Patent Document 1] Japanese Patent Application Publication No. 2018-173758 [Patent Document 2] Patent Publication No. 2021-068146 Summary of the Invention [Problem to be solved by the invention]
[0008] An object of the present invention is to provide an export sales support device and an export sales support program that support the prediction of profits that can be obtained from export sales and also support the improvement of the efficiency of export operations. [Means for solving the problem]
[0009] The export sales support device of the first aspect of the present invention is configured to cooperate with an export destination country EC site and an export origin country EC site, and includes an export destination country information acquisition means for acquiring, from the export destination country EC site, export destination country product information including at least the lowest price information in the export destination country for the specified product, sales commission information, size information, and sales ranking information, based on identification information that uniquely identifies the product; an export origin country information acquisition means for acquiring, from the export origin country EC site, the lowest price information in the export origin country for the specified product, based on the identification information that uniquely identifies the specified product; and a sales ranking information acquisition means for acquiring, from the export origin country EC site, the lowest price information in the export origin country for the specified product, based on the size information. The system is characterized by comprising a shipping fee information acquisition means for receiving shipping fee information for a product, a sales number estimation means for estimating the past sales number of the specified product from the sales ranking information, a gross profit rate calculation means for calculating the gross profit rate of the specified product based on at least the lowest price information in the export destination country, the sales commission information, the lowest price information in the export origin country, and the shipping fee information, and a gross profit amount calculation means for calculating the gross profit amount of the specified product based on the sales number estimated by the sales number estimation means, the lowest price information in the export destination country, the sales commission information, the lowest price information in the export origin country, and the shipping fee information.
[0010] The export sales support device of the second aspect of the present invention is configured to cooperate with an export destination country EC site and an export origin country EC site, and to acquire from the export destination country EC site, export destination country product information including at least export destination country lowest price information, sales commission information, size information, and sales ranking information for each identified product, based on identification information that uniquely identifies a seller who is selling on the export destination country EC site, and based on identification information that uniquely identifies each product that the identified seller is selling on the export destination country EC site; and an export origin country information acquisition means that acquires from the export origin country EC site, based on identification information that uniquely identifies each identified product, lowest price information in the export destination country for each identified product. The system is characterized by comprising country information acquisition means, shipping information acquisition means for receiving shipping information for each of the specified products based on the dimension information, sales number estimation means for estimating past sales numbers for each of the specified products from the sales ranking information, gross profit rate calculation means for calculating gross profit rates for each of the specified products based on at least the lowest price information for each of the export destination countries, the sales commission information, the lowest price information for each of the export origin countries, and the shipping information, and gross profit amount calculation means for calculating gross profit amounts for each of the specified products based on the sales numbers estimated by the sales number estimation means, the lowest price information for each of the export destination countries, the sales commission information, the lowest price information for each of the export origin countries, and the shipping information.
[0011] The export sales support device of the third aspect of the present invention is characterized in that it is connected to a delivery company terminal so as to be able to communicate with each other, and is equipped with a display means for displaying sales product information including at least identification information that uniquely identifies the identified product, the purchase quantity of the identified product, and supplier information of the identified product, and a sales product information transmission means for transmitting the sales product information to the delivery company terminal.
[0012] An export sales support program according to a fourth aspect of the present invention includes the steps of: linking a computer communicably connected to an export destination country EC site and an export origin country EC site with the export destination country EC site and the export origin country EC site; acquiring, from the export destination country EC site, export destination country product information including at least the lowest price information in the export destination country for the specified product, sales commission information, size information, and sales ranking information for the specified product, based on identification information that uniquely identifies the specified product; and acquiring, from the export origin country EC site, the lowest price information in the export origin country for the specified product, based on the identification information that uniquely identifies the specified product. a step of acquiring information on the size of the specified product based on the size information; a step of accepting shipping information for the specified product based on the size information; a step of estimating the past sales volume of the specified product from the sales ranking information; a step of calculating the gross profit rate of the specified product based on at least the lowest price information in the export destination country, the sales commission information, the lowest price information in the export origin country, and the shipping information; and a step of calculating the gross profit amount of the specified product based on the sales volume estimated by the sales volume estimation means, the lowest price information in the export destination country, the sales commission information, the lowest price information in the export origin country, and the shipping information. [Effects of the Invention]
[0013] According to the first aspect of the present invention, for an export product, information on the lowest price in the export destination country, sales commission information, size information, sales ranking information, and information on the lowest price in the export origin country are obtained, and shipping information and estimated past sales figures are obtained. From this information, the gross profit margin and gross profit amount of the product are calculated, making it possible to efficiently predict the profit to be obtained from the export sale of the product without having to go to the export destination country to conduct market research, etc.
[0014] According to the second aspect of the present invention, export destination country product information is obtained based on identification information that uniquely identifies the seller who is listing the product on the export destination country's e-commerce site, making it possible to obtain export destination country product information for all products listed by a specific person in one go, thereby making export operations more efficient.
[0015] According to the third aspect of the present invention, sales product information including at least product identification information, product purchase quantity, and product supplier information is displayed on a display unit based on the acquired export destination country product information and export origin country product information or based on information input from an input unit (not shown), and then transmitted to a delivery company terminal. This makes it easier to entrust export operations such as packaging, labeling, boxing, invoice and slip creation, and customs clearance to a delivery company, thereby making it possible to streamline export operations.
[0016] According to the fourth aspect of the present invention, for an export product, information on the lowest price in the export destination country, sales commission information, size information, sales ranking information, and information on the lowest price in the export origin country are obtained, and shipping information and estimated past sales figures are obtained, and the gross profit rate and gross profit amount of the product are calculated from this information, making it possible to efficiently predict the profit to be obtained from the export sale of the product without having to go to the export destination country to conduct market research, etc. [Brief explanation of the drawings]
[0017] [Figure 1] 1 is a block diagram showing an example of the configuration of an export sales support device according to a preferred embodiment of the present invention; [Figure 2] FIG. 10 is a diagram showing an example of a display screen for export destination country product information and export origin country product information according to the present invention. [Figure 3] FIG. 10 is a diagram showing an example of a display screen of sales product information according to the present invention. [Figure 4] 3 is a flowchart showing an example of processing in the export sales support program of the present invention. DETAILED DESCRIPTION OF THE INVENTION
[0018] Hereinafter, a first embodiment of the present invention will be described with reference to the drawings.
[0019] Fig. 1 shows an example of the configuration of an export sales support device 1 of the present invention. Note that Fig. 1 also shows examples of the second and third aspects of the present invention.
[0020] The export sales support device 1 is mounted on, for example, a computer. The computer includes a memory configured with a CPU (Central Processing Unit) and RAM (Random Access Memory) (not shown), a HDD (Hard Disk Drive), an input device configured with a keyboard, touch panel, etc., and an output device configured with a display, printer, etc. The HDD stores the export sales support program of the present invention, etc. The CPU reads the export sales support program from the HDD to the memory and executes it, thereby realizing the functions of the export sales support device 1.
[0021] The export sales support device 1 includes an export destination country information acquisition unit 2, an export origin country information acquisition unit 3, a shipping fee information acquisition unit 4, a sales quantity estimation unit 5, a gross profit margin calculation unit 6, and a gross profit amount calculation unit 7, and preferably also includes a display unit 8 and a sales product information transmission unit 9.
[0022] In this invention, the term "destination country" refers to the country to which goods are exported and sold, and the term "origin country" refers to the country from which the goods are sent to the country to be exported and sold. For example, if goods are exported from Japan to the United States for sale, the United States is the destination country and Japan is the origin country.
[0023] In this invention, an EC (electronic commerce) site is a website that sells products and services over the Internet, and includes so-called EC malls, that is, shopping mall-type EC sites where multiple companies and shops set up or sell products, and specifically includes, for example, those known as "Amazon," "Rakuten Market," "Yahoo Shopping," etc.
[0024] In the present invention, the destination country EC site 10 refers to an EC site whose purpose is to sell to consumers in the destination country, and the origin country EC site 11 refers to an EC site whose purpose is to sell to consumers in the origin country. While Fig. 1 shows one destination country EC site 10 and one origin country EC site 11, it is assumed that there are not just one destination country EC site 10 and one origin country EC site 11, but multiple destination country EC sites 10 and multiple origin country EC sites 11, and as will be described later, the export sales support device 1 can be linked to multiple destination country EC sites 10 and multiple origin country EC sites 11.
[0025] The export sales support device 1 is linked to the destination country EC site 10 and the origin country EC site 11. Here, linkage means, for example, that the export sales support device 1 is connected to the destination country EC site 10 and the origin country EC site 11 so that they can communicate with each other or are linked via an API (Application Programming Interface), thereby enabling the export sales support device 1 to acquire information from the destination country EC site 10 and the origin country EC site 11.
[0026] As shown in Fig. 2, the export destination country information acquisition unit 2 acquires export destination country product information from the export destination country e-commerce site 10 based on identification information that uniquely identifies the product (referred to as "product identification information" in Figs. 2 and 3), including at least the lowest price information in the export destination country for the identified product (referred to as "lowest price in the U.S." in Figs. 2 and 3), sales commission information (referred to as "U.S. e-commerce commission" in Fig. 2), dimensional information (referred to as "packaging size" in Figs. 2 and 3), and sales ranking information. Here, the identification information that uniquely identifies the product is, for example, a product code that uniquely identifies the product. More specifically, for example, if the export destination country e-commerce site 10 is "Amazon" in the U.S., the identification information that uniquely identifies the product is the identification information called "ASIN" (Amazon Standard Identification Number). The export destination country product information can include the lowest price information in the export destination country, sales commission information, size information, and sales ranking information, as well as the name of the product (not shown in Figures 2 and 3), an image of the product (not shown in Figures 2 and 3), listing application information indicating whether or not an listing application for the product needs to be submitted to the export destination country's e-commerce site 10, return rate information for the product, information on the estimated past sales of the product estimated by the sales number estimation unit 5 described below, and information on the number of sellers of the product on the export destination country's e-commerce site 10 (referred to as "8 American e-commerce companies in the past 180 days" in Figure 2). The information on the number of sellers of the product on the export destination country's e-commerce site 10 can be seen as the number of competitors in the export sale of the product.
[0027] The lowest price information in the export destination country is information on the lowest price among the sales prices on the export destination country's e-commerce site 10 per unit of a product identified by identification information that uniquely identifies the product. The lowest price information in the export destination country can also be acquired as information on the lowest price of the identified product within a specific past period, for example, the most recent 90 days. In this way, by acquiring the lowest price information in the export destination country as information on the lowest price within the most recent specific period, it becomes possible to grasp more accurate information on the lowest price. The lowest price information in the export destination country can also be acquired as two pieces of information: information on the lowest past price of the identified product and information on the lowest past price within a specific past period.
[0028] The sales commission information is information regarding the amount of commission that the destination country EC site 10 collects from the person (hereinafter simply referred to as the export seller) who exports and sells using the export sales support device 1 when one product identified by identification information that uniquely identifies the product is sold on the destination country EC site.
[0029] Dimensional information is information indicating the size of each product identified by identification information that uniquely identifies the product, and can be, for example, information on the width, depth, height, and weight of the product when packaged.
[0030] Sales ranking information is ranking information regarding the number of units sold in the past of a product identified by identification information that uniquely identifies the product, and specifically, it is information that ranks products classified in the same genre, category, type, or item as the product in question in descending order of sales volume, and can be obtained as text information such as "1st place," "2nd place," etc., but can also be obtained as line graph information as shown in Figure 2. (Note that the line graph in Figure 2 is provided for reference only and does not reflect actual figures.) Furthermore, sales ranking information can be obtained as sales ranking information for the past day, week, or month by specifying a specific period.
[0031] As shown in Fig. 2, the export origin country information acquisition unit 3 acquires the lowest price information in the export origin country for the specified product (referred to as "lowest price in Japan" in Figs. 2 and 3) based on identification information that uniquely identifies the specified product from the export origin country EC site 11. Here, the identification information that uniquely identifies the specified product is, for example, a product code that uniquely identifies the product identified based on identification information that uniquely identifies the product from the destination country EC site 10. More specifically, for example, if the export origin country EC site 11 is "Amazon" in Japan, identification information called "ASIN" (Amazon Standard Identification Number) corresponds to the identification information that uniquely identifies the product.
[0032] The identification information that uniquely identifies the product is identification information used in the e-commerce site 10 of the export destination country, and the identification information that uniquely identifies the identified product is identification information used in the e-commerce site 11 of the export origin country. The identification information that uniquely identifies the product and the identification information that uniquely identifies the identified product can use the same identification information as in the example above, but the identification information that uniquely identifies the product and the identification information that uniquely identifies the identified product can also use different identification information, for example, a JAN (Japanese Article Number) code if Japan is the export origin country. However, the identification information that uniquely identifies the product and the identification information that uniquely identifies the identified product must uniquely identify the same product.
[0033] The lowest price information in the exporting country is information on the lowest price currently available for one product identified by identification information that uniquely identifies the product at the exporting country's e-commerce site 11. As will be described later, products to be exported are purchased in the exporting country based on the lowest price information in the exporting country.
[0034] For example, when the export country is Japan, the export origin country information acquisition unit 3 can use the JAN code or the like to search or browse multiple export origin country EC sites 11 ("Export origin country EC site information (EC site A, EC site B, EC site C)" in Figure 2) to acquire information on the cheapest lowest price in the export origin country from the multiple export origin country EC sites 11. Furthermore, when the export origin country is Japan, for example, the export origin country information acquisition unit 3 can also use the JAN code or the like to acquire information on the number of sellers of the product on the export origin country EC site 11, as shown as "Currently 10 Japanese EC Companies" in Figure 2.
[0035] The shipping fee information acquisition unit 4 receives shipping fee information based on the dimensional information. The shipping fee information is referred to as "shipping fee" in FIG. 2 . The shipping fee information can be assumed shipping fee information, which is approximately equivalent to the shipping fee from the exporting country to the exporting country for each identified product. Specifically, for example, the shipping fee from the shipping location of the exporting country's e-commerce site 11 to the exporting seller (or the delivery company, if delivery is outsourced to a delivery company) when purchasing the product from the exporting country's e-commerce site 11, plus the shipping fee from the exporting seller (or the delivery company, if delivery is outsourced to a delivery company) to the collection location of the exporting country's e-commerce site 10. More specifically, for example, for such assumed shipping fee information, multiple assumed shipping fee information corresponding to each dimensional information is calculated in advance. That is, assumed shipping fee information according to the product's dimensions is prepared. The assumed shipping fee information corresponding to the dimensional information is input as shipping fee information from an input unit (not shown) by referring to the dimensional information. The shipping fee information acquisition unit 4 receives this as shipping fee information based on the dimensional information.
[0036] The sales number estimation unit 5 estimates the past sales number of a product identified from the sales ranking information. As described above, the sales ranking information is ranking information on the number of sales units among similar products during a specific period, and is acquired as text, graph information, or the like. When the sales ranking information is text information indicating a ranking of sales units, for example, when the previous ranking was "10th" and the current ranking is "7th," the point at which the ranking rises to a higher position is considered to be one unit of the product sold, and this is estimated as the past sales number of the product. Also, when the sales ranking information is line graph information indicating fluctuations in the ranking of sales units, and the line of the graph declines as the ranking rises to a higher position, the portion of the line that declines to the right between the previous point and the current point is considered to be a rise in the ranking, and one unit of the product is sold, and this is estimated as the past sales number of the product. For example, if there is sales ranking information that shows the fluctuations in sales ranking over a 30-day period using a line graph, and there are 15 parts that decline to the right, the sales quantity estimation unit 5 estimates that 15 units of the product were sold during that 30-day period.
[0037] The gross profit margin calculation unit 6 calculates the gross profit margin of the specified product based on at least the lowest price information of the export destination country, the sales commission information, the lowest price information of the export origin country, and the shipping fee information.
[0038] Gross profit is calculated by subtracting cost of sales from sales, and gross profit margin is calculated by dividing gross profit by sales.
[0039] The gross profit margin calculation unit 6 regards the lowest price information in the export destination country as the sales amount per unit of the product, and regards the sales commission information, the lowest price information in the export origin country, and the shipping fee information as the cost of sales per unit of the product, calculates the gross profit per unit of the product by subtracting the sales commission information, the lowest price information in the export origin country, and the shipping fee information from the lowest price information in the export destination country, and calculates the gross profit margin of the product by dividing the gross profit by the lowest price information in the export destination country.
[0040] The gross profit calculation unit 7 calculates the gross profit of the identified product based on the sales number estimated by the sales number estimation unit 6, the lowest price information in the export destination country, the sales commission information, the lowest price information in the export origin country, and the shipping information. Similar to the gross profit rate calculation unit 6, the gross profit calculation unit 7 regards the lowest price information in the export destination country as the sales amount per product, and regards the sales commission information, the lowest price information in the export origin country, and the shipping information as the cost of sales per product. Therefore, the gross profit calculation unit 7 multiplies the lowest price information in the export destination country by the sales number estimated by the sales number estimation unit 6 to calculate the sales amount of the product in the period estimated by the sales number estimation unit 6, multiplies the sales commission information, the lowest price information in the export origin country and the shipping fee information by the sales number estimated by the sales number estimation unit 6 to calculate the cost of sales of the product in the period estimated by the sales number estimation unit 6, and subtracts the cost of sales from the sales amount to calculate the gross profit amount for the product in the period estimated by the sales number estimation unit 6.
[0041] The export sales support device 1 of the present invention can preferably include an exchange rate adjustment unit (not shown). When different currencies are used in the export destination country and the export origin country, as shown in Figures 2 and 3, the lowest price information for the export destination country, sales commission information, etc. can be displayed in the currency of the export destination country, and other price information can be displayed in the currency of the export origin country. On the other hand, the exchange rate adjustment unit can unify the currency to either the currency of the export destination country or the currency of the export origin country based on the exchange rate information input from the input unit. For example, the gross profit rate calculation unit 6 and the gross profit amount calculation unit 7 can calculate the gross profit rate and gross profit amount, respectively, based on the unified price information.
[0042] As described above, according to the first aspect of the present invention, for an export product, information on the lowest price in the export destination country, sales commission information, size information, sales ranking information, and information on the lowest price in the export origin country are obtained, and shipping information and estimated past sales figures are obtained, and the gross profit rate and gross profit amount of the product are calculated from this information, making it possible to efficiently predict the profit to be obtained from the export sale of the product without having to go to the export destination country to conduct market research, etc.
[0043] Next, a second embodiment of the present invention will be described. The second embodiment of the present invention is similar to the first embodiment of the present invention unless otherwise specified.
[0044] In a second aspect of the present invention, the export sales support device 1 cooperates with the export destination country EC site 10 and the export origin country EC site 11, and the export destination country information acquisition unit 2 acquires, from the export destination country EC site 10, export destination country product information including at least the lowest export destination country price information, sales commission information, size information, and sales ranking information for each identified product, based on identification information that uniquely identifies a seller who is selling on the export destination country EC site 10, and based on identification information that uniquely identifies each product that the identified seller is selling on the export destination country EC site 10, and the export origin country information acquisition unit 3 acquires, from the export origin country EC site 11, identification information that uniquely identifies each identified product, based on identification information that uniquely identifies each identified product. a shipping information acquisition unit (4) receives shipping information for each specified product based on the size information; a sales quantity estimation unit (5) estimates the past sales number of each specified product from each sales ranking information; a gross profit calculation unit (6) calculates the gross profit rate of each specified product based on at least the lowest price information for each export destination country, the sales commission information, the lowest price information for each export origin country, and the shipping information; and a gross profit calculation unit (7) calculates the gross profit amount of each specified product based on each sales number estimated by the sales quantity estimation means, the lowest price information for each export destination country, the sales commission information, the lowest price information for each export origin country, and the shipping information.
[0045] In the second aspect of the present invention, the identification information that uniquely identifies the seller who is selling on the destination country EC site 10 can be, for example, the URL of the shop that the seller opens on the destination country EC site 10, also known as the seller URL.
[0046] The second aspect of the present invention differs from the first aspect of the present invention in that the export destination country information acquisition unit 2 can acquire export destination country product information for each product that an identified seller lists on the export destination country EC site 10 in bulk based on identification information that uniquely identifies the seller.
[0047] As described above, according to the second aspect of the present invention, export destination country product information is obtained based on identification information that uniquely identifies the seller who is listing the product on the export destination country EC site 10, making it possible to obtain export destination country product information for all products listed by a specific person in one go, thereby making it possible to streamline export operations.
[0048] Next, the third embodiment of the present invention will be described. The parts of the third embodiment of the present invention that are not particularly mentioned are the same as those of the first or second embodiment of the present invention.
[0049] In a third aspect of the present invention, the export sales support device 1 is connected to the delivery company terminal 12 so as to be able to communicate with each other, as shown in FIG. 1, and is equipped with a display unit 8 that displays sales product information including at least identification information that uniquely identifies the identified product (referred to as "product identification information" in FIG. 3), the number of purchases of the identified product, and supplier information of the identified product (such as the supplier's name or supplier's URL), as well as a sales product information transmission unit 9 that transmits the sales product information to the delivery company terminal 12, as shown in FIG. 3.
[0050] The delivery company terminal 12 is a terminal used by a business that receives products to be exported from the export origin country e-commerce site 11 using the export sales support device 1 and delivers them to a collection point on the destination country e-commerce site 10, and this terminal is, for example, a computer that includes a memory such as a CPU (Central Processing Unit) and RAM (Random Access Memory), a storage device such as an HDD (Hard Disk Drive), an input device such as a keyboard or touch panel, and an output device such as a display or printer. Although only one delivery company terminal 12 is shown in Figure 1, delivery can be entrusted to multiple delivery companies, and multiple delivery company terminals 12 can also exist.
[0051] The purchase quantity of the specified product means the quantity to be purchased for export sale of the product that can be purchased at the lowest price in the exporting country based on the exporting country's lowest price information. The "Purchase price" in Figure 3 is essentially the same value as the exporting country's lowest price information.
[0052] The supplier information of the identified product is information about the seller of the product that can be purchased at the lowest price in the exporting country based on the lowest price information in the exporting country, and is, for example, information about the name of the seller or the URL of the seller.
[0053] The sales product information may include identification information that uniquely identifies the identified product, the number of purchases of the identified product, and supplier information for the identified product, as well as information such as the purchase date, purchase price, total purchase amount, and product category.
[0054] The display unit 8 displays sales product information including at least identification information that uniquely identifies the identified product, the purchase quantity of the product, and supplier information of the product based on the acquired export destination country product information and export origin country lowest price information, and also displays sales product information based on information input from an input unit (not shown) as appropriate. Therefore, some sales product information can be displayed without input from the input unit, and can be input from the input unit as appropriate and as needed, thereby reducing the work of inputting sales product information.
[0055] The sales product information transmission unit 9 transmits the above-mentioned sales product information to the delivery company terminal 12.
[0056] As described above, according to the third aspect of the present invention, sales product information including at least product identification information, product purchase quantity, and product supplier information is transmitted to the delivery company terminal 12, making it easier to entrust export operations such as packaging, labeling, boxing, invoice and slip creation, and customs clearance to the delivery company, thereby making it possible to streamline export operations.
[0057] Next, the fourth aspect of the present invention, that is, the export sales support program of the present invention, will be described with reference to FIGS.
[0058] The export sales support program of the present invention causes a computer communicably connected to the EC site of the export destination country and the EC site of the export source country to execute the following steps.
[0059] The export sales support program causes a computer to execute step 1 of coordinating with an e-commerce site 10 of an export destination country and an e-commerce site 11 of an export source country.
[0060] The export sales support program causes a computer to execute step 2 of acquiring, from the export destination country e-commerce site 10, product information for the identified product, including at least the lowest price information for the export destination country (lowest price in the United States: $164.82), sales commission information (US EC commission: $23.86), size information (packaging size: 2.80 cm x 8.00 cm x 9.80 cm, 0.14 kg), and sales ranking information, based on identification information that uniquely identifies the product (product identification information 123456abc). Note that here, the lowest price information for the export destination country uses the product's lowest past price, not the lowest price for the product in the most recent 90 days, but in the present invention, it is of course also possible to use the lowest price for the product in the most recent 90 days as the lowest price information for the export destination country.
[0061] The export sales support program causes the computer to execute step 3 of obtaining the lowest price information for the identified product in the export country (lowest price in Japan: 14,824.00 yen) from the export country e-commerce site 11 based on identification information that uniquely identifies the identified product (product identification information 123456abc).
[0062] The export sales support program causes the computer to execute step 4, which receives shipping information (shipping fee 1,908 yen) based on the dimension information (packing size 2.80 cm x 8.00 cm x 9.80 cm 0.14 kg).
[0063] The export sales support program causes the computer to execute step 5, which estimates the past sales numbers of the product identified from the sales ranking information (estimated sales numbers: 10 units in the past 30 days, 27 units in the past 90 days, and 62 units in the past 180 days).
[0064] The export sales support program causes the computer to execute step 6 of calculating the gross profit margin of the identified product based on at least the lowest price information in the export destination country (lowest price in the United States: $164.82), sales commission information (US EC commission: $23.86), lowest price information in the export origin country (lowest price in Japan: 14,824.00 yen), and shipping information (shipping fee: 1,908 yen).
[0065] Specifically, in step 6, for example, the export sales support program first converts the lowest price information in the export destination country (lowest price in the United States: $164.82) and sales commission information (US EC commission: $23.86) into the lowest price information in the export destination country (lowest price in the United States: ¥24,723) and sales commission information (US EC commission: ¥3,579) based on the exchange rate information entered from the input means, for example, 1 dollar = ¥150.
[0066] In step 6, the gross profit margin of the product is then calculated by performing the following calculation: [Formula 1] 24,723 yen - 3,579 yen - 14,824 yen - 1,908 yen = 4,412 yen (gross profit per item) [Formula 2] 4,412 yen ÷ 24,723 yen = 17.84% (gross profit margin) The export sales support program causes the computer to execute step 7, for example, assuming that 10 units of the product will be sold over 30 days or 10 units of the product will be sold, in which the computer calculates the gross profit amount (44,120 yen) of the identified product based on the sales number estimated by the sales number estimation means (estimated sales number: 10 units in the past 30 days), the lowest price information for the export destination country (lowest price in the United States: 24,723 yen), sales commission information (US EC commission: 3,579 yen), the lowest price information for the export source country (lowest price in Japan: 14,824.00 yen), and shipping information (shipping fee: 1,908 yen).
[0067] Specifically, step 7 calculates the gross profit amount of the product (here, for 30 days or when 10 units of the product are sold) by executing the following formula: [Formula 3] 24,723 yen x 10 units - (3,579 yen + 14,824 yen + 1,908 yen x 10 units) = 44,120 yen (gross profit) As described above, according to the fourth aspect of the present invention, by obtaining information on the lowest price in the export destination country, sales commission information, size information, sales ranking information, and lowest price information in the export origin country for an export product, and obtaining shipping information and estimated past sales figures, the gross profit margin and gross profit amount of the product are calculated from this information, making it possible to efficiently predict the profit to be obtained from the export sale of the product without having to go to the export destination country to conduct market research, etc. [Explanation of symbols]
[0068] 1 Export sales support equipment 2 Export destination country information acquisition department 3 Export Country Information Acquisition Department 4. Shipping Information Acquisition Section 5 Sales Estimation Department 6 Gross profit rate calculation department 7 Gross Profit Calculation Department 8 Display 9. Sales Product Information Transmission Department 10. E-commerce sites in export destination countries 11. Exporting country e-commerce site 12 Delivery company terminal
Claims
1. In cooperation with the e-commerce sites of the export destination country and the export origin country, an export destination country information acquisition means for acquiring, from the export destination country EC site, export destination country product information including at least the lowest export destination country price information, sales commission information, size information, and sales ranking information of the identified product based on identification information that uniquely identifies the product; an export origin country information acquisition means for acquiring, from the export origin country EC site, lowest price information for the specified product in the export origin country based on identification information that uniquely identifies the specified product; a shipping fee information acquisition means for receiving shipping fee information for the specified product based on the size information; a sales number estimation means for estimating the past sales number of the identified product from the sales ranking information; a gross profit margin calculation means for calculating a gross profit margin of the specified product based on at least the lowest price information of the export destination country, the sales commission information, the lowest price information of the export origin country, and the shipping fee information; An export sales support device characterized by comprising a gross profit calculation means for calculating the gross profit of the specified product based on the sales number estimated by the sales number estimation means, the lowest price information in the export destination country, the sales commission information, the lowest price information in the export origin country, and the shipping fee information.
2. In cooperation with the e-commerce sites of the export destination country and the export origin country, an export destination country information acquisition means for acquiring, from the export destination country EC site, export destination country product information including at least the lowest export destination country price information, sales commission information, size information, and sales ranking information for each identified product, based on identification information that uniquely identifies a seller who is selling the product on the export destination country EC site, and based on identification information that uniquely identifies each product that the identified seller is selling on the export destination country EC site; an export origin country information acquisition means for acquiring, from the export origin country EC site, lowest price information in the export origin country for each of the specified products based on identification information that uniquely identifies each of the specified products; a shipping fee information acquisition means for receiving shipping fee information for each of the specified products based on the dimension information; a sales number estimation means for estimating the past sales number of each of the identified products from the sales ranking information of each of the identified products; a gross profit margin calculation means for calculating a gross profit margin for each of the specified products based on at least the lowest price information for each export destination country, the sales commission information, the lowest price information for each export origin country, and the shipping fee information; An export sales support device characterized by comprising a gross profit calculation means for calculating a gross profit for each of the specified products based on the sales numbers estimated by the sales number estimation means, the lowest price information for each of the export destination countries, the sales commission information, the lowest price information for each of the export origin countries, and the shipping fee information.
3. It is connected to the delivery company terminal so that they can communicate with each other, a display means for displaying sales product information including at least identification information for uniquely identifying the specified product, the purchase quantity of the specified product, and supplier information of the specified product; 3. The export sales support device according to claim 1, further comprising a sales product information transmitting means for transmitting the sales product information to the delivery company terminal.
4. A computer that is connected to the EC site of the export destination country and the EC site of the export origin country so that it can communicate with them, a step of linking the export destination country e-commerce site and the export source country e-commerce site; acquiring, from the EC site of the export destination country, product information for the specified product, including at least the lowest price information for the export destination country, sales commission information, size information, and sales ranking information for the specified product, based on identification information that uniquely identifies the product; acquiring, from the EC site of the export origin country, lowest price information of the specified product in the export origin country based on identification information that uniquely identifies the specified product; receiving shipping information for the identified product based on the size information; a step of estimating the past sales volume of the identified product from the sales ranking information; calculating a gross profit margin for the specified product based on at least the lowest price information for the export destination country, the sales commission information, the lowest price information for the export origin country, and the shipping fee information; An export sales support program for executing a step of calculating the gross profit amount of the identified product based on the sales number estimated by the sales number estimation means, the lowest price information in the export destination country, the sales commission information, the lowest price information in the export origin country, and the shipping fee information.
Citation Information
Patent Citations
Selling management system and selling management method
JP2018173758A
Export support device, export support system and export support method
JP2021068146A