# 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](https://descartessystems.aha.io/pages/7630859407371251876) 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](https://help.sellercloud.com/sellercloud-knowledge-base/orders/import-order-shipping-cost~7630859234742865694#Obtain_XML_Invoices).

If you import shipping costs for the same orders more than once, the values from the latest import will overwrite any previous entries.

## 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](https://descartessystems.aha.io/pages/7630838476388116703) will be created.

The shipping cost import for UPS requires a specific file format called **UPS Billing Data File - XML**. To obtain these files, you must enroll your account in the [UPS Billing Centre](https://www.ups.com/media/cs/bill_ctr_user_guide3.pdf).

## Import DHL eCommerce (DHL Global Mail) Shipping Cost

[DHL eCommerce](https://help.sellercloud.com/omnichannel-ecommerce/shipping-with-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](https://descartessystems.aha.io/pages/7630851494839563427) 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](https://descartessystems.aha.io/pages/7630838476388116703) will be created.

### Automatically

To import DHL eCommerce shipping costs automatically:

01. Navigate to **Settings** > **Scheduled Tasks** > **Manage Scheduled Tasks**.
02. Click the green + icon: **Create New Scheduled Task.**
03. 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**.

04. The following message appears at the bottom of your screen: “Scheduled task created successfully. **Click Here** to configure the task details.” - click the link.
05. Click the **Edit** button on the top right.
06. In the **Details** section, click the **Plugin** menu and select **CD DHL Tracking Costs Import**.
07. In the **Import Options** section, choose your preferred import method.
08. In the **Frequency** section, specify the task frequency. For optimal performance, select a range between thirty minutes and one hour.
09. 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](https://descartessystems.aha.io/pages/7630838476388116703) 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](https://descartessystems.aha.io/pages/7630838715868958891).
- **FedEx** - You can download the XML file from [FedEx Billing Online](https://www.fedex.com/en-us/billing-online.html). 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](https://www.ups.com/media/cs/bill_ctr_user_guide3.pdf).