JP2012118749A - International shipping support system, international shipping support method and international shipping support program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide an international shipping support system, international shipping support method and international shipping support program for reducing time and efforts when shipping an article overseas.SOLUTION: If an HS code is registered correspondingly to a JAN code acquired together with shipping destination information, the HS code is acquired by a control section 21 of an overseas shipping support server 20 but if not, HS code estimation processing is executed on the basis of the JAN code. During the HS code estimation processing, if there is an HS code corresponding to an article name of the JAN code, the HS code is specified by the control section 21 but if there is no corresponding HS code, an HS code of an article name coincident with keywords included in the names of a middle classification and a large classification of JAN codes is extracted. The control section 21 acquires a tax rate in a shipping destination country corresponding to the extracted or estimated HS code, specifies the tax rate or a range of tax rates and outputs it to a user terminal 10.

Description

  The present invention relates to an international shipping support system, an international shipping support method, and an international shipping support program used when a product is delivered to a foreign country.

  When shipping a product overseas, unlike domestic cases, information other than the product shipping destination, sender, and product name is required. For example, it is necessary to describe the number, weight, price, product classification, etc. of the product to be shipped on the delivery label. In addition, it is necessary to confirm whether or not the product is not subject to import restrictions in the destination country. Therefore, a legal compliance check system for imported products for determining regulated products has been studied (see, for example, Patent Document 1). In the technology described in this document, a comparison table is created in which HS codes as classification identifiers of international trade products are associated with items, and this correspondence table is used to check whether imported products are not regulated products by a computer. To do.

Japanese Patent Laying-Open No. 2009-98914 (first page, FIG. 9)

  Even if the product does not fall under the regulation, it is necessary to prepare a customs declaration accurately in order to ship the product overseas. If the customs declaration is not correctly created, customs inspection takes time and goods are not delivered smoothly to the shipping destination. However, since the contents of the declaration to the customs differ depending on the raw materials and materials of the product, it is difficult to accurately grasp the product and create an appropriate declaration.

  The present invention has been made to solve the above-described problems, and provides an international shipping support system, an international shipping support method, and an international shipping support program for reducing the trouble of delivering goods overseas. is there.

  In order to solve the above-mentioned problem, the invention described in claim 1 is directed to a commodity information data storage means in which a commodity name of the commodity is associated with a commodity identifier, and a classification identifier of an international trade commodity. Trade classification data storage means associated with the name of the international trade product, tariff rate data storage means for storing the classification identifier of the international trade product and the tariff rate corresponding to the destination country, the product identifier and the international trade product An international shipping support system for supporting international delivery of users, comprising product identifier conversion data storage means stored in association with the classification identifier and control means connected to the user terminal, the control means comprising: When the shipping destination information and the product identifier of the product to be delivered are acquired from the user terminal, the international trade corresponding to this product identifier is stored in the product identifier conversion data storage means. Means for searching for product category identifiers, and means for acquiring, for each category identifier, the tariff rate of the destination country included in the destination information from the tariff rate data storage means when a plurality of category identifiers are extracted. If a single tariff rate can be determined in the acquired tariff rate, this tariff rate is output to the user terminal, and if a single tariff rate cannot be determined, the range of the extracted tariff rates And a means for outputting to a user terminal.

According to a second aspect of the present invention, in the international shipping support system according to the first aspect, the control means records a classification identifier of an international trade commodity corresponding to the commodity identifier in the commodity identifier conversion data storage means. In the case where there is not, it is further characterized by further comprising means for specifying the product type of the product identifier and searching the trade classification data storage unit for the classification identifier of the international trade product including the keyword corresponding to the product type. To do.

  According to a third aspect of the present invention, in the international shipping support system according to the first or second aspect, the control means is a shipping in which the attention information of the product in which the failure has occurred in the delivery history information is recorded for the product identifier. The gist is connected to the caution history data storage means, and the control means outputs the caution information of the product specified by the product identifier to the user terminal.

  According to a fourth aspect of the present invention, in the international shipping support system according to the third aspect, the control means stores a standard number of days required for delivery for each destination country, and the shipping attention history data storage means stores Is the number of days of arrival when the delivery history information is delayed from the required number of days of delivery for the product identifier, and the control means specifies the standard required number of days of delivery in the destination country of the destination information. If it is possible to specify the means for outputting to the user terminal, the means for searching for the arrival date of the product identifier of the goods to be delivered in the shipping attention history data storage means, and the arrival days, the delivery may take time. The gist is to output the fact that there is a characteristic to the user terminal.

  In the invention according to claim 5, the product information data storage means in which the product name of the product is associated with the product identifier, and the name of the international trade product is associated with the classification identifier of the international trade product. Trade classification data storage means, tariff rate data storage means for storing the tariff rate corresponding to the classification identifier of the international trade product and the destination country, the merchandise identifier and the classification identifier of the international trade product are stored in association with each other A method for supporting international delivery of a user using an international shipping support system comprising control means connected to a product identifier conversion data storage means and a user terminal, wherein the control means uses When the shipping destination information and the product identifier of the product to be delivered are acquired from the customer terminal, the product identifier conversion data storage means stores the international trade product corresponding to the product identifier. Retrieving a class identifier, and extracting a plurality of classification identifiers from the tariff rate data storage means, obtaining a tariff rate of a destination country included in the destination information for each classification identifier; and If a single tariff rate can be determined for the acquired tariff rate, this tariff rate is output to the user terminal. If a single tariff rate cannot be determined, the extracted tariff rate range is used. And the step of outputting to the person terminal.

  In the invention described in claim 6, the product information data storage means in which the product name of the product is associated with the product identifier, and the name of the international trade product is associated with the classification identifier of the international trade product. Trade classification data storage means, tariff rate data storage means for storing the tariff rate corresponding to the classification identifier of the international trade product and the destination country, the merchandise identifier and the classification identifier of the international trade product are stored in association with each other A program for supporting international delivery of a user using an international shipping support system including control means connected to a product identifier conversion data storage means and a user terminal, wherein the control means is used. When the shipping destination information and the merchandise identifier of the merchandise to be delivered are acquired from the customer terminal, the international trade corresponding to the merchandise identifier is stored in the merchandise identifier conversion data storage means. Means for retrieving the classification identifier of the product, means for acquiring the tariff rate of the shipping destination country included in the shipping destination information for each classification identifier from the tariff rate data storage means when a plurality of classification identifiers are extracted, and If a single tariff rate can be determined in the acquired tariff rate, this tariff rate is output to the user terminal. If a single tariff rate cannot be determined, the range of the extracted tariff rates is set. The gist is to function as a means for outputting to a user terminal.

(Function)
According to the present invention, when the control unit acquires the shipping destination information and the product identifier of the product to be delivered from the user terminal, the control unit classifies the international trade product corresponding to the product identifier in the product identifier conversion data storage unit. Search for an identifier. When the plurality of classification identifiers are extracted, the control means acquires the tariff rate of the shipping destination country included in the shipping destination information for each classification identifier from the tariff rate data storage means. The control means outputs the tariff rate to the user terminal when the single tariff rate can be determined in the acquired tariff rate, and when the single tariff rate cannot be determined, the extracted tariff rate is output. The rate range is output to the user terminal. For this reason, since the tariff rate specified via the classification identifier of the international trade product is output from the product identifier, the user can easily grasp the more accurate tariff rate.

  According to the present invention, when the classification identifier of the international trade product corresponding to the product identifier is not recorded in the product identifier conversion data storage unit, the control unit specifies the product type of the product identifier, The trade classification data storage means is searched for a classification identifier of the international trade product including a keyword corresponding to a product type. For this reason, even if the classification identifier of the international trade commodity corresponding to the commodity identifier is not recorded, the classification identifier corresponding to the commodity type of the commodity specified by the commodity identifier is specified, and the tariff rate is specified from this classification identifier. be able to.

  According to the present invention, the control means outputs attention information of the product specified by the product identifier to the user terminal. For this reason, the user can grasp the caution information about the product from the past history of the same product as the product to be delivered.

  According to the present invention, the control means specifies the standard number of days required for delivery in the destination country of the destination information and outputs it to the user terminal. The control unit searches the shipping attention history data storage unit for the arrival days of the product identifier of the product to be delivered. When the number of days of arrival can be specified, the control means outputs to the user terminal that delivery may take time. For this reason, the user can grasp the standard number of days required for delivery in the destination country, and can grasp whether delivery takes time from the record information.

  According to the present invention, it is possible to reduce time and labor when delivering a product overseas.

The schematic block diagram explaining the structure of the overseas shipment assistance system of embodiment. It is explanatory drawing explaining the data structure recorded on each data memory | storage part of embodiment, (a) is a code conversion data memory | storage part, (b) is a dispatch warning article data memory | storage part, (c) is commodity tariff rate data A storage unit (d) shows a delivery record data storage unit. It is explanatory drawing explaining the data structure recorded on each data storage part of embodiment, (a) is a JAN code comprehensive product information data storage part, (b) is a tariff rate data storage part, (c) is a delivery condition. A data storage part is shown. Explanatory drawing explaining the process sequence of the dispatch request reception process of embodiment. Explanatory drawing explaining the process sequence of the legal revision corresponding | compatible process of embodiment. Explanatory drawing explaining the process sequence of the results information update process of embodiment.

Hereinafter, an embodiment embodying the present invention will be described with reference to FIGS. In the present embodiment, a case will be described in which processing for shipping products from Japan to overseas is supported as an international shipping support system. The international shipping support system of this embodiment provides information specified using a JAN code (Japan Article Number code) as a product identifier to a user. This JAN code is composed of a code specifying a company and a product item, and a chuck digit. This product item code is composed of a 6-digit identification number indicating a common name (for example, “cocoa” or “coffee”). Among the 6-digit identification number, the upper 4 digits indicate the middle classification of the product (for example, a name such as “taste beverage”), and the upper 2 digits of the 4-digit indicate the major classification of the product (for example, Names such as “beverage”). In the following, this product item code is handled in the JAN code.

  As shown in FIG. 1, an overseas shipping support server 20 as an international shipping support system is connected to a user terminal 10 via the Internet. The user terminal 10 is a computer terminal used by a user who ships a product, and includes a display, a keyboard, and a mouse. The product information acquired from the overseas shipping support server 20 and shipping destination information necessary for shipping are displayed on the display. The keyboard and mouse are used when inputting data such as a shipping destination, a sender, and a JAN code for specifying a product. Further, the user terminal 10 is connected to a printing apparatus (not shown). This printing apparatus is used when printing a delivery label or an invoice.

  The overseas shipping support server 20 includes a control unit 21, a code conversion data storage unit 23, a shipping precaution product data storage unit 24, a commodity tariff rate data storage unit 25, and a delivery record data storage unit 26. The code conversion data storage unit 23 functions as a product identifier conversion data storage unit, and the shipping caution product data storage unit 24 functions as a shipping caution history data storage unit.

  The control unit 21 includes a CPU, a RAM, a ROM, and the like (not shown), and each process of request reception processing, product information identification processing, tariff rate identification processing, delivery date calculation processing, law revision update processing, and performance information update processing, which will be described later. It is the control means which performs. Then, by executing the international shipping support program for this purpose, the control unit 21 causes the request receiving means 211, the product information specifying means 212, the tariff rate specifying means 213, the delivery days calculating means 214, the law amendment updating means 215, and the results. It functions as information updating means 216 and the like.

  The request reception unit 211 acquires shipping destination information and shipping merchandise information from the user terminal 10. Further, the request accepting unit 211 transmits to the user terminal 10 print data for printing the mail availability data, the delivery label, and the invoice.

  The merchandise information specifying unit 212 acquires information about the shipping merchandise based on the JAN code of the shipping merchandise information acquired from the user terminal 10. The merchandise information specifying means 212 stores a JAN code table and an HS code table, and also functions as a trade classification data storage means. The JAN code table is data in which a JAN code is associated with a name. The HS code table is data in which the HS code and the product name are associated with each other. Here, the HS code is an ordinary code created for the purpose of unifying international trade product names and classifications globally in the “Harmonized Commodity Description and Coding System”. This is a 6-digit identification number. A product name (for example, a name such as “soy sauce”) can be specified by the 6-digit identification number. The upper four-digit identification number of the HS code indicates a product type (for example, a name such as “mixed seasoning”) that is a major classification for this classification. That is, the HS code table includes the product type associated with the HS code.

The tariff rate specifying means 213 specifies the tariff rate for the product in the shipping destination country (the country where the shipping address is located). In this embodiment, the tariff rate is specified based on the HS code.
The delivery days calculation means 214 calculates the number of days required to deliver the product to the shipping destination. The delivery days calculation means 214 stores a delivery days table in which delivery days (standard delivery days required for arrival at the shipping destination) are recorded for each country identifier.

The law amendment / update means 215 provides information on regulated products (dangerous goods and other items that cannot be shipped, conditional shipping products, etc.) stored in the shipping attention product data storage unit 24 in accordance with revisions to laws and regulations in each country. Update.

  The record information update unit 216 updates the data stored in each data storage unit (23 to 26) using the record data that has been delivered. The record information update unit 216 stores the allowable number of days that can allow the delivery delay.

  As shown in FIG. 2A, the code conversion data storage unit 23 stores a code conversion record 230 in which a JAN code and an HS code are associated with each other. The code conversion record 230 is recorded when the HS code corresponding to the JAN code can be specified. The code conversion record 230 includes data relating to the JAN code, HS code, and English name.

A JAN code for specifying a product is recorded in the JAN code data area.
An HS code corresponding to this JAN code is recorded in the HS code data area. When a plurality of different HS codes are associated with one JAN code, a plurality of HS codes are recorded in this HS code data area.
In the English name data area, data relating to the product name (in English) specified by the JAN code is recorded.

  As shown in FIG. 2 (b), the shipment notice item data storage unit 24 stores a restricted item record 241 and a shipment note history record 242. The restricted item record 241 stores data related to the names of items for which prohibition of shipping and conditions are regulated by laws and regulations. The restricted item record 241 is recorded when a restricted item is newly registered. The restricted item record 241 includes data on a product name, a country identifier, a shipping availability flag, a shipping condition presence / absence flag, packaging requirements, and restricted items.

In the product name data area, data relating to the product name of each product is recorded.
In the country identifier data area, data relating to an identifier (country identifier) for specifying each country is recorded.

In the shipping availability flag data area, a flag (a shipping enabled flag or a shipping disabled flag) for determining whether or not this product can be shipped to this country is recorded.
In the shipping condition presence / absence flag data area, data relating to a flag for determining whether or not there is a condition for shipping this product (shipping condition present flag / shipping condition absent flag) is recorded.

In the packaging requirement data area, data relating to the conditions necessary for packaging of products in order to ship products with shipping conditions to this country is recorded.
In the regulation item data area, data relating to the laws and regulations and the date of amendment for the product which cannot be shipped in the destination country or which has the shipping condition is recorded.

  The shipping notice history record 242 is delivery history data in which a failure occurs during delivery. This shipping attention history record 242 is recorded when a delivery status described later is “storage” or “return”, or when a significant delay (unacceptable delay) occurs even if the delivery status is “delivered”. The The shipping attention history record 242 includes data regarding the JAN code, the destination country identifier, the arrival date, the delivery history, and the remarks. The delivery history includes date and time, status, and data relating to the base.

In the JAN code data area, data related to the JAN code for specifying the product is recorded.
In the shipping country identifier data area, data relating to a country identifier for specifying the shipping country of this product is recorded.

In the arrival date data area, data relating to the required number of days (the number of days actually required) from the acceptance of the product to arrival at the shipping destination is recorded.
In the date / time data area, data related to the date and time when the status of the product is changed is recorded.

  In the status data area, status (identifier) data for specifying the delivery status of the product is recorded. For example, the delivery status such as status “underwriting”, “waiting for customs clearance inspection”, “delivered”, “storage”, “return”, etc. is recorded. The status “underwriting” indicates a state where a delivery item is collected. The status “waiting for customs inspection” indicates a state in which the vehicle has arrived at the destination country and is waiting for customs inspection. The status “delivered” indicates a state of arrival at the shipping destination. The status “stored” indicates a state where it has not arrived at the shipping destination for some reason, and the status “returned” indicates a state where it has been returned to the country for some reason.

In the base data area, data relating to a base identifier for specifying the handling base where the status of the product is registered is recorded.
In the remark data area, data relating to failure information that has occurred in the shipment of the product is recorded.

  As shown in FIG. 2C, the merchandise tariff rate data storage unit 25 stores merchandise tariff rate records 250 relating to the tariff rates of merchandise specified by JAN codes for each country. The merchandise tariff rate record 250 is recorded when the merchandise identified by the JAN code is shipped to a new destination country and the tariff rate can be identified. The commodity tariff rate record 250 includes data regarding the JAN code, HS code, country identifier, and tariff rate.

In the JAN code data area and HS code data area, data related to the JAN code and HS code are recorded.
In the country identifier data area, data relating to the country identifier for specifying the destination country is recorded.
In the tariff rate data area, data relating to the tariff rate of the product specified by the JAN code is recorded.

  As shown in FIG. 2D, the delivery record data storage unit 26 stores a delivery record record 260 relating to the delivery history of the product that has been delivered. This delivery record record 260 is recorded when a record information update process described later is performed. The delivery record 260 records data related to JAN code, HS code, shipping product name, shipping destination country identifier, total price, quantity, tariff rate, history, and arrival days. The history includes data related to date / time, status, and location.

  In the JAN code data area and the HS code data area, data relating to the JAN code and HS code for specifying the delivered product are recorded.

In the shipping product name data area, data relating to the product name of the shipped product is recorded.
In the shipping country identifier data area, data relating to a country identifier for specifying the shipping country of this product is recorded.

In the total price data area and the quantity data area, the total price of the product delivered by this delivery,
Data on the number is recorded respectively.
In the tariff rate data area, data relating to the tariff rate for products shipped to the destination country is recorded.

In the date / time data area, status data area, and base data area, the date and time when the new status of this product was registered, the registered status, and data related to the base identifier of the handling base that registered this status are recorded. Is done.
In the arrival date data area, data relating to the required number of days (the number of days actually required) from the acceptance of the product to arrival at the shipping destination is recorded.

  On the other hand, the overseas shipping support server 20 shown in FIG. 1 is connected to a JAN code management server 30, a law disclosure server 40, a tariff rate disclosure server 50, and a delivery management server 60.

  The JAN code management server 30 is a computer system of a distribution system development center that manages JAN codes, and includes a JAN code general product information data storage unit 32 as product information data storage means. The JAN code general merchandise information data storage unit 32 stores a JAN code management record 320 as shown in FIG. This JAN code management record 320 is recorded when a code is assigned according to the application. The JAN code management record 320 includes data regarding the JAN code, size, weight, product name, price, number of products, country of origin, and expiration date.

In the JAN code data area, data relating to the JAN code of each product is recorded.
In the size data area, data relating to the size (vertical, horizontal, depth) of the product specified by the JAN code is recorded.

In the weight data area, data relating to the weight of the product is recorded.
In the product name data area, data related to the ordinary name of the product is recorded.
In the price data area, data relating to the price of this product is recorded.
In the product quantity data area, data relating to the number of products included in the set is recorded in the set sales.

In the country of origin data area, data relating to the country of origin of this product is recorded.
In the expiration date data area, data relating to the expiration date of this product is recorded. When the product is a food, data relating to the expiration date is recorded.

  The law disclosure server 40 is a server that publishes laws related to imports in each country, and includes a law data storage unit 42. In the law data storage unit 42, data relating to the product names of the regulated products in each country and data relating to the date of revision of the law are recorded.

  The tariff rate disclosure server 50 is a computer system that publishes laws and regulations relating to tariff rates in each country, and includes a tariff rate data storage unit 52 as a tariff rate data storage means. The tariff rate data storage unit 52 stores a tariff rate record 520 as shown in FIG. The tariff rate record 520 includes data regarding the importing country, the HS code, and the tariff rate.

In the importing country data area, data relating to a country identifier for specifying a shipping country (importing country) of goods is recorded.
In the HS code data area, data relating to the HS code assigned to the product is recorded.
In the tariff rate data area, data relating to the tariff rate for this product is recorded.

  The delivery management server 60 is a computer system for managing delivery status and includes a delivery status data storage unit 62. The delivery status data storage unit 62 stores a delivery status record 620 as shown in FIG. The delivery status record 620 includes data relating to the tracking identifier, JAN code, HS code, shipping product name, shipping destination, sender, total price, number, tariff rate, and delivery history. The delivery history includes date and time, status, and data relating to the base. The data relating to the delivery history includes a base identifier of a handling base where the delivery management server 60 handles the product (an underwriting base where a delivery item is sent out, a customs base, a delivery base which has jurisdiction over delivery of a shipping address), Every time the date / time and status at that time are received, it is additionally updated.

In the tracking identifier data area, data relating to a management identifier for specifying this delivery is recorded.
In the JAN code data area and HS code data area, data relating to the JAN code and HS code for specifying the product delivered in each delivery is recorded. In the HS code data area, the HS code at the time of delivery request is recorded, but when it is corrected by a customs officer during delivery, the corrected data is recorded.

In the shipping product name data area, data relating to the product name of the shipped product is recorded.
In the shipping address data area, data (name, address and country name of the shipping address) for specifying the shipping address of this product is recorded.

In the sender data area, data for specifying the sender of the product (name, address, and country of the sender) is recorded.
In the total price data area and the number data area, data related to the total price and the number of products delivered by this delivery are recorded.

In the tariff rate data area, data related to the tariff rate on the product is recorded.
In the date / time data area, status data area, and base data area, the date and time when the new status of this product was registered, the contents of the status, and data related to the base identifier of the handling base that registered this status are recorded. The

  Next, an international shipping support process performed using the above-described overseas shipping support system will be described with reference to FIGS. Here, first, the shipping request reception processing when the control unit 21 of the overseas shipping support server 20 receives a shipping request from a user who ships products overseas will be described with reference to FIG. Next, the law revision handling process and the result information update process that the control unit 21 of the overseas shipping support server 20 periodically executes will be described with reference to FIGS. 5 and 6.

(Shipping request acceptance process)
First, the shipping request reception process will be described with reference to FIG. In this shipping request reception process, the user operates the mouse and keyboard of the user terminal 10 to obtain a shipping request reception screen from the overseas shipping support server 20. This shipping request acceptance screen includes an input field for inputting information such as shipping destination information, sender information and shipping merchandise information, an information acquisition button, and a shipping request button. The shipping destination information includes the name and address of the shipping destination and the name of the country where the address is located. The sender information includes the sender's name, address, and country name where the address is located. The shipping product information includes the JAN code of the product to be shipped, the product name (English name) in English, content, price, country of origin, and the like.

  The control unit 21 of the overseas shipping support server 20 executes processing for acquiring shipping destination information and JAN code (step S1-1). Specifically, the user inputs shipping destination information, sender information, and JAN code in each input field on the shipping request reception screen, and selects an information acquisition button. The user terminal 10 transmits the input shipping destination information and JAN code to the overseas shipping support server 20. The request receiving unit 211 of the control unit 21 of the overseas shipping support server 20 acquires shipping destination information and a JAN code.

  The control unit 21 of the overseas shipping support server 20 executes a product information search process based on the JAN code (step S1-2). Specifically, the product information specifying unit 212 of the control unit 21 transmits a product information request including this JAN code to the JAN code management server 30. The JAN code management server 30 extracts a JAN code management record 320 in which the JAN code included in the information request is recorded. Then, the JAN code management server 30 transmits a product information response including information recorded in the JAN code management record 320 to the overseas shipping support server 20. The control unit 21 of the overseas shipping support server 20 acquires product information (size, weight, product name, price, number of products, country of origin, and expiration date) corresponding to the JAN code by this product information response.

  The control unit 21 of the overseas shipping support server 20 determines whether or not attention is required for shipping (step S1-3). Specifically, the merchandise information specifying unit 212 of the control unit 21 specifies a ship-to country identifier included in the ship-to information. The merchandise information specifying means 212 searches the shipping precaution product data storage unit 24 for a restricted product record 241 in which the product name associated with the JAN code and the specified country identifier are recorded. The merchandise information specifying means 212 searches the shipping attention product data storage unit 24 for the shipping attention history record 242 in which the JAN code and the specified country identifier are recorded.

  Here, when the corresponding regulated item record 241 or shipping attention history record 242 is extracted, the product information specifying unit 212 determines whether or not this product can be shipped and whether or not there is a shipping condition. Specifically, when the shipping prohibition flag is recorded in the extracted restricted product record 241, the product information specifying unit 212 acquires the restricted matter data from the restricted product record 241 and sets the message “unshipable”. Correlate and temporarily store in memory.

  Further, when the shipment condition present flag is recorded in the restricted item record 241, the product information specifying unit 212 acquires the packaging requirement data included in this record, and associates it with the message “with shipment condition” in the memory. Temporarily store.

  Further, when the shipping attention history record 242 is extracted, the merchandise information specifying unit 212 acquires the remark data and the arrival date included in this record, and temporarily stores them in the memory in association with the message “Failure during delivery”. To do.

  Here, the control unit 21 of the overseas shipping support server 20 executes an alarm output process (step S1-4) when it is determined that attention is required for shipping ("YES" in step S1-3). Specifically, the request receiving unit 211 of the control unit 21 generates warning screen data including restriction item data, packaging requirement data, or remarks data, and a message associated with each item, and the user terminal 10 Send to. In this case, the request receiving unit 211 transmits a screen control command to the user terminal 10 in which the shipping request button on the shipping request reception screen cannot be selected when transmitting a “shipping impossible” message. Furthermore, when remark data is transmitted, the number of arrival days is also transmitted.

The user terminal 10 displays a warning screen on the display. On this alert screen,
The message of “shipping not possible”, “shipping condition exists”, or “failure during delivery” stored in the memory, and the regulations, packaging requirements, or remarks associated with each message are displayed. When the message “shipping impossible” is displayed, the shipping request button is deleted on the shipping request reception screen.

  On the other hand, when it is determined that attention is not necessary for shipping (in the case of “NO” in step S1-3), or after the alarm output process (step S1-4) is finished, the control unit 21 of the overseas shipping support server 20 It is determined whether there is an HS code registration (step S1-5). Specifically, the product information specifying unit 212 of the control unit 21 searches whether or not the code conversion record 230 in which the JAN code is recorded is recorded in the code conversion data storage unit 23. Here, when the corresponding code conversion record 230 can be extracted, the HS code is registered. In this case (in the case of “YES” in step S1-5), the control unit 21 of the overseas shipping support server 20 executes an HS code acquisition process (step S1-6). Specifically, the product information specifying unit 212 of the control unit 21 acquires the HS code and the English name included in the extracted code conversion record 230.

  On the other hand, when the HS code is not registered (in the case of “NO” in Step S1-5), the control unit 21 of the overseas shipping support server 20 executes the HS code estimation process based on the JAN code (Step S1). -7). Specifically, the product information specifying unit 212 of the control unit 21 searches for an HS code corresponding to the product name acquired in step S1-2. Here, when the HS code having the same product name can be extracted, the product information specifying unit 212 estimates the extracted HS code as the HS code of the product.

  On the other hand, when the HS code having the same product name cannot be extracted, the product information specifying unit 212 uses the JAN code table to identify the middle class name and the large class name corresponding to the identification number of the upper digit of the JAN code. Identify. Then, the product information specifying unit 212 extracts, in the HS code table, the HS code of the product name that matches the keyword included in the name of the middle category or the large category. The merchandise information specifying unit 212 estimates the extracted HS code as the HS code of the merchandise. Here, when a plurality of HS codes are extracted, the merchandise information specifying unit 212 stores all the extracted HS codes in the memory in association with the JAN codes.

  Next, the control unit 21 of the overseas shipping support server 20 executes a tariff rate acquisition process in the destination country for each acquired HS code (step S1-8). Specifically, first, the tariff rate specifying means 213 of the control unit 21 searches for the merchandise tariff rate record 250 in which the JAN code and the destination country identifier are recorded. Here, when the corresponding product tariff rate record 250 is extracted, the tariff rate specifying means 213 specifies the tariff rate included in this record as the tariff rate of this product. In this case, when a plurality of product tariff rate records 250 are extracted, all tariff rates are specified.

  On the other hand, if the corresponding product tariff rate record 250 is not extracted, the tariff rate specifying means 213 transmits a tariff rate confirmation request to the tariff rate disclosure server 50. Here, the tariff rate specifying unit 213 includes the acquired HS code (step S1-6) or the estimated HS code (step S1-7) and the destination country identifier in the tariff rate confirmation request. In this case, when there are a plurality of acquired or estimated HS codes, all these HS codes are included in the tariff rate confirmation request.

  The tariff rate disclosure server 50 extracts a tariff rate record 520 in which each HS code and country identifier included in the tariff rate confirmation request is recorded. Then, the tariff rate disclosure server 50 transmits the tariff rate confirmation result including the tariff rate for each HS code to the overseas shipping support server 20. The control unit 21 of the overseas shipping support server 20 acquires the tariff rate for each HS code based on the received tariff rate confirmation result.

  Next, the control unit 21 of the overseas shipping support server 20 determines whether the tariff rate can be determined (step S1-9). Here, when only a single tariff rate is acquired corresponding to the HS code acquired in step S1-8, the tariff rate specifying means 213 of the control unit 21 determines that the tariff rate can be determined.

  Here, when the tariff rate can be determined (in the case of “YES” in step S1-9), the control unit 21 of the overseas shipping support server 20 executes a tariff rate determination process (step S1-10). ). Specifically, the tariff rate specifying means 213 of the control unit 21 temporarily stores the acquired tariff rate in the memory as the tariff rate of this product.

  On the other hand, when a single tariff rate cannot be determined by acquiring a plurality of different tariff rates (in the case of “NO” in step S1-9), the control unit 21 of the overseas shipping support server 20 determines the tariff rate range. Calculation processing is executed (step S1-11). Specifically, the tariff rate specifying means 213 of the control unit 21 specifies the lowest tariff rate and the highest tariff rate among the plurality of acquired tariff rates.

  Next, the control unit 21 of the overseas shipping support server 20 executes processing for calculating the number of delivery days until the arrival at the shipping destination (step S1-12). Specifically, the delivery days calculation means 214 of the control unit 21 acquires the delivery days associated with the destination country identifier from the delivery days table. Further, the delivery days calculation means 214 searches the delivery record data storage unit 26 for a delivery record record 260 in which this JAN code is recorded. When the corresponding delivery record record 260 is extracted, the arrival days included in this are acquired.

  Next, the control unit 21 of the overseas shipping support server 20 executes output processing of the tariff rate and the number of delivery days (step S1-13). Specifically, the request receiving means 211 of the control unit 21 determines the tariff rate determined in step S1-10 or the minimum and maximum tariff rates calculated in step S1-11 and the number of delivery days acquired in step S1-12. The output information including the above is transmitted to the user terminal 10. If the request reception means 211 acquires the arrival days in step S1-12, the request reception means 211 also includes the arrival days in the output information. The user terminal 10 displays the acquired output information on the shipping acceptance screen. Thereby, the user can grasp | ascertain a tariff rate and the delivery days.

  When the shipping request button is selected by the user on the delivery acceptance screen, the user terminal 10 sends the shipping destination information, the sender information, and the shipping product information displayed on the delivery acceptance screen to the overseas shipping support server 20. Send to.

  The control unit 21 of the overseas shipping support server 20 executes a delivery label and invoice issuance process (step S1-14). Specifically, the control unit 21 transmits a shipping request including the received shipping destination information, sender information, and product information to the delivery management server 60. The delivery management server 60 gives a new tracking identifier to the shipping request. Next, the delivery management server 60 generates a delivery status record 620 that records the tracking identifier, the shipping destination information, the sender information, and the product information, and registers the delivery status record 620 in the delivery status data storage unit 62. The delivery management server 60 transmits this tracking identifier to the overseas shipping support server 20.

The control unit 21 of the overseas shipping support server 20 generates label print data for printing a delivery label and invoice print data for printing an invoice. Here, the control unit 21 extracts items necessary for the delivery label and the invoice in the tracking identifier, the shipping destination information, the sender information and product information, and the delivery management identifier acquired from the delivery management server 60. Then, print data and invoice print data are generated by inserting these extracted items into the label template and invoice template items. Then, the control unit 21 transmits the generated label print data and invoice print data to the user terminal 10. The user terminal 10 displays a preview screen on the display using the received label print data and invoice print data. The user terminal 10 transmits these print data to the printing apparatus in accordance with an instruction from the user, and prints the delivery label and the invoice in the printing apparatus. Thus, the shipping request acceptance process ends.

(Legal revision processing)
Next, the legal revision processing will be described with reference to FIG. The control unit 21 of the overseas shipping support server 20 executes this legal revision processing periodically (for example, once a month) for each country.

  First, the control unit 21 of the overseas shipping support server 20 executes a search process for the latest information of the law disclosure server (step S2-1). Specifically, the law amendment update unit 215 of the control unit 21 searches the law data storage unit 42 of the law disclosure server 40 for the law applied on the current day.

  Next, the control unit 21 of the overseas shipping support server 20 determines whether or not the latest information matches (step S2-2). More specifically, the law amendment / update means 215 of the control unit 21 regulates the product name for which shipping is not permitted or the shipping conditions are specified in the law applied on the current day, and the country identifier of the target country is recorded. The product record 241 is compared with the product name recorded with the flag indicating that no shipment is possible or the flag indicating that there is a shipment condition. Further, the law amendment / update means 215 compares the packaging requirement specified in the new law with the packaging requirement of the same product name in the restricted product record 241 in which the flag for shipping condition is recorded.

  In the comparison result, when the product name in the regulated product record 241 matches all the non-shipable products and packaging requirements specified in the law applied on the current day (in the case of “YES” in step S2-2) Then, the control unit 21 of the overseas shipping support server 20 ends the law revision handling process.

  On the other hand, in the case of products that cannot be shipped or packaging requirements, if the specifications in the laws and regulations applied on the current day do not match the contents recorded in the restricted product record 241 (in the case of “NO” in step S2-2), overseas shipping The control unit 21 of the support server 20 executes a process for updating the restricted item record (step S2-3). Specifically, if the product name defined in the law is not included in the restricted item record 241 in which the flag indicating that shipment is not possible or the flag indicating that there is a shipment condition is included, the law revision / update means 215 of the control unit 21 Then, a new restricted product record 241 including the product name and the flag indicating that shipment is not possible or the flag indicating that there is a shipping condition is generated and recorded. In addition, when the product name in which the flag indicating that shipment is not possible (shipping condition flag) is recorded in the regulated product record 241 is not included in the product for which the shipment is prohibited by law or the shipping condition is specified, the law amendment update means 215. Deletes the restricted item record 241 including the product name.

  When the packaging requirements for the same product name are different, the law amendment / update means 215 records the packaging requirements of the new law in the packaging requirement data area of the regulated product record 241. By executing the above processing for all countries, the legal amendment processing is completed.

(Result information update process)
Next, the result information update process will be described with reference to FIG. The control unit 21 of the overseas shipping support server 20 executes the result information update process periodically (for example, once a day).

First, the control unit 21 of the overseas shipping support server 20 executes a delivery end information search process using the tracking identifier (step S3-1). Specifically, the record information update unit 216 of the control unit 21 has a delivery status in which the previous day is recorded in the latest date and time, and the status of the latest date is recorded as “delivered”, “returned”, or “storage”. The record 620 is searched in the delivery status data storage unit 62.

As a result of the search, if there is no corresponding delivery end information (in the case of “NO” in step S3-2), the control unit 21 of the overseas shipping support server 20 ends the result information update process.
On the other hand, when there is corresponding delivery end information (in the case of “YES” in step S3-2), the control unit 21 of the overseas shipping support server 20 repeatedly executes the following processing using the extracted delivery end information. To do.

  First, the control unit 21 of the overseas shipping support server 20 executes a delivery end information recording process (step S3-3). Specifically, the record information update unit 216 of the control unit 21 specifies the shipping destination country identifier of the acquired delivery management information, generates a delivery record record 260, and stores it in the delivery record data storage unit 26. Then, the record information update unit 216 records the JAN code, HS code, shipping product name, total price, number, tariff rate, and delivery history in the delivery record record 260.

  Next, the control unit 21 of the overseas shipping support server 20 executes a process for calculating the arrival days (step S3-4). Specifically, when the status of the delivery end information is already delivered, the result information update unit 216 of the control unit 21 requires the time from the date of the “underwriting” status to the date of the “delivered” status. The arrival days are calculated from the number of days and recorded in the delivery record record 260.

  Next, the control unit 21 of the overseas shipping support server 20 determines whether or not to newly record code conversion data (step S3-5). Specifically, the record information update unit 216 of the control unit 21 searches the code conversion data storage unit for the code conversion record 230 in which the JAN code and the HS code included in the delivery end information are recorded. Here, when the code conversion record 230 in which the JAN code and the HS code are associated with each other is extracted, the record information update unit 216 determines that it is not necessary to newly record the code conversion data (step S3). "NO" in -5).

  On the other hand, when the code conversion record 230 in which the JAN code and the HS code are associated with each other cannot be extracted and it is determined that the code conversion data needs to be newly recorded (in the case of “YES” in step S3-5) Then, the control unit 21 of the overseas shipping support server 20 executes a new code conversion data recording process (step S3-6). Specifically, the record information update unit 216 of the control unit 21 searches the code conversion data storage unit 23 for the code conversion record 230 in which the JAN code is recorded.

  Here, when the corresponding code conversion record 230 is extracted, the record information update unit 216 records the HS code included in the delivery end information in the HS code data area of the code conversion record 230.

  On the other hand, when the corresponding code conversion record 230 is not extracted, the record information update unit 216 generates a code conversion record 230 including the JAN code and HS code included in the delivery end information and records it in the code conversion data storage unit 23. To do. Further, the record information update unit 216 inquires of the JAN code management server 30 about the product name of the JAN code. The JAN code management server 30 extracts the JAN code management record 320 including the JAN code, and transmits the product name to the overseas shipping support server 20. The overseas shipping support server 20 machine translates the acquired product name into an English name and records it in the generated code conversion record 230.

  Next, the record information update unit 216 searches the commodity tariff rate data storage unit 25 for the commodity tariff rate record 250 including the JAN code, HS code, and destination country identifier recorded in the delivery record record 260. Here, when the matching product tariff rate record 250 is not extracted, the record information update unit 216 newly generates the product tariff rate record 250 and records it in the product tariff rate data storage unit 25. Further, the record information update unit 216 records the JAN code, HS code, destination country identifier, and tariff rate of the delivery end information in the commodity tariff rate record 250.

  Next, the control unit 21 of the overseas shipping support server 20 determines whether or not failure information is recorded in the delivery history (step S3-7). Specifically, when the status of the recorded delivery record 260 is “return” or “storage”, the record information update unit 216 of the control unit 21 determines that the failure information is recorded in the delivery history. . Furthermore, when the arrival days of the delivery record record 260 are delayed by a predetermined allowable number of days or more with respect to the delivery days, the record information update unit 216 records failure information in the delivery history. Judge.

Here, when failure information is recorded in the delivery (in the case of “YES” in step S3-7), the control unit 21 of the overseas shipping support server 20 executes a process of updating the shipping attention history record ( Step S3-8). Specifically, the record information update unit 216 of the control unit 21 newly generates a shipment notice history record 242 including the JAN code, the destination country identifier and the history of the delivery record record 260, and the shipment notice item data storage unit 24. Furthermore, when the history status of the shipping attention history record 242 includes “return” (or “storage”), the record information update means 216 sends “return” (or “storage”) to the shipping attention history. Recorded in the remarks data area of the record 242. If the “Return” and “Storage” are not recorded in the history status of the newly recorded shipping attention history record 242, the record information update unit 216 displays “significantly” in the remarks data area of the shipping attention history record 242. Record "delay".
And the control part 21 of the overseas dispatch assistance server 20 will complete | finish a performance information update process, if the above-mentioned step S3-3-S3-8 are performed about all the extracted delivery completion information.

According to this embodiment, the following effects can be obtained.
(1) In the present embodiment, the control unit 21 of the overseas shipping support server 20 acquires the HS code when the HS code is registered corresponding to the JAN code acquired together with the shipping destination information (step S1). -6). The control unit 21 acquires the tariff rate in the destination country corresponding to the acquired HS code, and when the tariff rate can be fixed to one tariff rate, determines the tariff rate and outputs it to the user terminal (step S1- 8-S1-10, S1-13). For this reason, since the tariff rate specified from the JAN code through the HS code is output, the user can easily grasp the more accurate tariff rate.

(2) In the present embodiment, when the HS code corresponding to the JAN code acquired together with the shipping destination information is not registered, the control unit 21 of the overseas shipping support server 20 determines the HS code based on the JAN code. An estimation process is executed (step S1-7). In this HS code estimation process, the control unit 21 searches for the HS code corresponding to the product name of the JAN code, and if there is a matching HS code, estimates the HS code of this product. On the other hand, if there is no matching HS code, the control unit 21 acquires the names of the medium and large classifications of this JAN code in the JAN code table, and the HS code of the product name that matches the keyword included in this name. Are extracted in the HS code table. The control unit 21 acquires the tariff rate in the destination country for each acquired HS code, calculates the tariff rate confirmation or the tariff rate range, and outputs it to the user terminal 10. For this reason, even if the HS code corresponding to the JAN code is not recorded, the HS code corresponding to the product type of the product specified by the JAN code is specified, and a single tariff rate or tariff rate is determined from this HS code. A range can be specified.

  (3) In the present embodiment, the control unit 21 of the overseas shipping support server 20 acquires the delivery days of the destination country identifier from the delivery days table. Furthermore, the control unit 21 extracts the arrival days of the delivery record 260 in which this JAN code is recorded. The control unit 21 transmits these delivery days and arrival days to the user terminal 10. For this reason, the user can know the delivery days of this product, and can grasp the arrival days when there is a significant delay.

  (4) In the present embodiment, the control unit 21 of the overseas shipping support server 20 includes product information (product size, weight, product name, price, number of products, country of origin, corresponding to the JAN code acquired together with the shipping destination information. And the expiration date) are acquired from the JAN code management server 30 (step S1-2). The control unit 21 executes an alarm output process when attention is required for handling based on the product name associated with the JAN code (step S1-4). For this reason, since the user acquires the product information stored in advance in association with the JAN code from the JAN code general product information data storage unit 32, the user can easily acquire information necessary for international delivery. Can do.

Moreover, you may change the said embodiment as follows.
In the above embodiment, the overseas shipping support server 20 executes the shipping request reception process, but may execute the delivery status inquiry reception process. In this case, when the overseas shipping support server 20 receives a confirmation request for the delivery status from the user terminal 10, the delivery status of the product having the same JAN code may be provided to the user as reference information. Specifically, when receiving the delivery status confirmation request including the tracking identifier from the user terminal 10, the control unit 21 of the overseas shipping support server 20 transmits the tracking identifier to the delivery management server 60. The delivery management server 60 extracts the delivery status record 620 including this tracking identifier and transmits it to the overseas shipping support server 20.

  The control unit 21 of the overseas shipping support server 20 searches the delivery record data storage unit 26 for a delivery record record 260 including the country identifier and the JAN code received from the delivery management server 60. When the corresponding delivery record record 260 is extracted, the control unit 21 acquires the delivery history and the arrival days of the delivery record record 260. Then, the control unit 21 transmits the delivery history received from the delivery management server 60 and other delivery history and arrival days acquired from the JAN code to the user terminal 10. Thereby, the user can grasp the past delivery status information about the same product as the delivered product.

  In the above embodiment, the shipping attention history record 242 is stored in association with the JAN code. Not limited to this, it may be stored in association with the HS code or the product name. In this case, the control unit 21 acquires or estimates the HS code of this product before determining whether or not it is a handling precaution. Then, the control unit 21 searches for a shipping attention history record 242 including the specified HS code and product name. Thereby, even if the product has not been shipped to the country, it is possible to notify the user from the HS code or the product name that there is a possibility that a failure may occur during the delivery.

  In the above embodiment, the control unit 21 of the overseas shipping support server 20 acquires the delivery end information from one delivery management server 60. However, the control unit 21 of the overseas shipping support server 20 may acquire the delivery end information from the delivery management server 60 managed by each of the plurality of delivery companies. In this case, the control unit 21 of the overseas shipping support server 20 analyzes the characteristics (for example, arrival days for each region, status registration interval, etc.) according to each delivery company for each shipping product and notifies the user. be able to.

  DESCRIPTION OF SYMBOLS 10 ... User terminal, 20 ... Overseas dispatch support server, 21 ... Control part, 23 ... Code conversion data storage part, 24 ... Shipment caution data storage part, 25 ... Commodity tariff rate data storage part, 26 ... Delivery performance data storage 30 ... JAN code management server, 32 ... JAN code general product information data storage unit, 40 ... law disclosure server, 42 ... law data storage unit, 50 ... tariff rate disclosure server, 52 ... tariff rate data storage unit, 60 ... Delivery management server, 62 ... Delivery status data storage unit, 211 ... Request accepting means, 212 ... Product information specifying means, 213 ... Tariff rate specifying means, 214 ... Delivery days calculating means, 215 ... Legal amendment updating means, 216 ... Performance information Update means.

Claims (6)

Product information data storage means in which the product name of this product is associated with the product identifier;
Trade classification data storage means in which the name of the international trade product is associated with the classification identifier of the international trade product;
Tariff rate data storage means for storing the classification identifier of the international trade product and the tariff rate corresponding to the destination country;
Commodity identifier conversion data storage means for storing the commodity identifier and the classification identifier of the international trade commodity in association with each other;
An international shipping support system comprising a control means connected to a user terminal and supporting international delivery of users,
The control means includes
When obtaining the shipping destination information and the product identifier of the product to be delivered from the user terminal, means for searching the classification identifier of the international trade product corresponding to the product identifier in the product identifier conversion data storage means;
When extracting a plurality of classification identifiers, means for acquiring, for each classification identifier, the tariff rate of the destination country included in the destination information from the tariff rate data storage means;
If a single tariff rate can be determined in the acquired tariff rate, this tariff rate is output to the user terminal. If a single tariff rate cannot be determined, the range of the extracted tariff rates is set. An international shipping support system comprising means for outputting to a user terminal.   When the classification identifier of the international trade product corresponding to the product identifier is not recorded in the product identifier conversion data storage unit, the control unit specifies the product type of the product identifier and corresponds to the product type 2. The international shipping support system according to claim 1, further comprising means for searching the trade classification data storage means for a classification identifier of the international trade product including a keyword. The control means is connected to the shipping attention history data storage means for recording the attention information of the commodity in which the failure has occurred in the delivery history information for the commodity identifier,
The international shipping support system according to claim 1, wherein the control unit outputs attention information of a product specified by the product identifier to the user terminal. The control means stores a standard delivery time for each destination country,
In the shipping attention history data storage means, for the product identifier, the arrival history when the delivery history information is delayed from the required delivery days is recorded in the delivery history information.
The control means
A means for specifying the standard delivery days in the shipping country of the shipping address information and outputting it to the user terminal;
Means for retrieving the arrival date of the product identifier of the product to be delivered in the shipping attention history data storage means;
The international shipping support system according to claim 3, wherein when the number of arrival days can be specified, the fact that delivery may take time is output to the user terminal. Product information data storage means in which the product name of this product is associated with the product identifier;
Trade classification data storage means in which the name of the international trade product is associated with the classification identifier of the international trade product;
Tariff rate data storage means for storing the classification identifier of the international trade product and the tariff rate corresponding to the destination country;
Commodity identifier conversion data storage means for storing the commodity identifier and the classification identifier of the international trade commodity in association with each other;
A method for supporting international delivery of a user using an international shipping support system provided with a control means connected to a user terminal,
The control means includes
When acquiring the shipping destination information and the product identifier of the product to be delivered from the user terminal, searching the product identifier conversion data storage means for the classification identifier of the international trade product corresponding to the product identifier;
If a plurality of classification identifiers are extracted, obtaining the tariff rate of the shipping destination country included in the shipping destination information for each classification identifier from the tariff rate data storage means;
If a single tariff rate can be determined in the acquired tariff rate, this tariff rate is output to the user terminal. If a single tariff rate cannot be determined, the range of the extracted tariff rates is set. And a step of outputting to a user terminal. Product information data storage means in which the product name of this product is associated with the product identifier;
Trade classification data storage means in which the name of the international trade product is associated with the classification identifier of the international trade product;
Tariff rate data storage means for storing the classification identifier of the international trade product and the tariff rate corresponding to the destination country;
Commodity identifier conversion data storage means for storing the commodity identifier and the classification identifier of the international trade commodity in association with each other;
A program for supporting international delivery of users using an international shipping support system having a control means connected to a user terminal,
The control means;
Means for retrieving the classification identifier of the internationally traded product corresponding to the product identifier in the product identifier conversion data storage means when acquiring the shipping destination information and the product identifier of the product to be delivered from the user terminal;
When a plurality of classification identifiers are extracted, from the tariff rate data storage means, a means for acquiring the tariff rate of the destination country included in the destination information for each classification identifier, and a single item in the acquired tariff rate If the tariff rate can be determined, this tariff rate is output to the user terminal, and if a single tariff rate cannot be determined, it functions as a means for outputting the extracted tariff rate range to the user terminal. International shipping support program characterized by

Images