Import Order Shipping Cost

Overview

Shipping rates quoted by your carrier are estimates based on information supplied during order creation. However, it’s important to keep in mind that other shipping charges not included in the initial estimate may also apply. Such charges could often occur due to additional services, differences in weight or dimensions, and more. Because of these factors, your final Shipping Cost may differ from the initial estimate. 

To maintain accurate order data and Profit and Loss records, Sellercloud allows you to import the updated shipping costs for each carrier. See the last section of this article to learn how to Obtain XML Invoices.

Import UPS, FedEx, or DHL Shipping Costs

To import shipping costs for UPS, FedEx, or DHL:

1. Go to Orders > Tools > Import Order Info Via File.
2. Select Import Shipping Costs.
3. Set the Shipping Cost Type to UPS, UPS Mail Innovations, FedEx, or DHL.
4. Click File and select the appropriate invoice file.
   
5. Click Import. A Queued Job will be created.

Import DHL eCommerce (DHL Global Mail) Shipping Cost

DHL eCommerce does not return shipping costs, which means that Sellercloud cannot automatically add them to orders. To set the shipping cost for such orders, ask Sellercloud Support for a custom plugin that imports the standard DHL file and updates the FinalShippingFee on your packages. 

Once the plugin is installed, you can import shipping costs manually or automatically.

Manually

To import DHL eCommerce shipping costs manually:

1. Go to Orders > Tools > Import Order Info Via File.
2. Select Import Tracking via Plugin.
   
3. Select the Company.
4. Set the Plugin to CD DHL Tracking Costs Import.
5. Click File and select your DHL eCommerce file.
6. Click Import. A Queued Job will be created.

Automatically

To import DHL eCommerce shipping costs automatically:

1. Navigate to Settings > Scheduled Tasks > Manage Scheduled Tasks.
2. Click the green + icon: Create New Scheduled Task.
3. Complete as follows:
   
   1. Click Task Type and select Import Order Tracking.
   2. Set the Task Name.
   3. Select the Company.
   4. Select the Start Time.
   5. Click CREATE.
4. The following message appears at the bottom of your screen: “Scheduled task created successfully. Click Here to configure the task details.” – click the link.
5. Click the Edit button on the top right.
6. In the Details section, click the Plugin menu and select CD DHL Tracking Costs Import.
7. In the Import Options section, choose your preferred import method.
8. In the Frequency section, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
9. In the General section, click the Enable button.
10. Click Save on the top right.
    

Import Other Carrier Shipping Costs

To import shipping costs for any other carrier, download and populate the default template:

1. Go to Orders > Tools > Import Order Info Via File.
2. Set the Shipping Cost Type to Generic.
3. Click the Download icon to download the template.
   
4. Populate these columns in the template and save the file: 
   1. OrderID or TrackingNumber as the identifier
   2. ShippingCost
5. Click File and upload the updated template file.
6. Click Import. A Queued Job will be created.

Obtain XML Invoices

To import shipping costs, you need the respective invoice files from your carrier in XML format. To get XML invoices:

• DHL eCommerce – You can request XML invoices from your DHL account representative. DHL will set up an FTP account, and Sellercloud can get the files from there using a Scheduled Task.
• FedEx – You can download the XML file from FedEx Billing Online. Click Search/Download to search for Invoices, select your Template and File Type (XML). Then click Create Download.
• UPS – You can configure your UPS account to generate XML files and then download them from the UPS Billing Centre.