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.

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 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.

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 invoice files in XML format from your carrier. 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 with 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.

Overview

Shipping costs applied to an order are only estimates – not necessarily actual rates charged. For accurate Profit and Loss, you can import actual shipping costs, which will override the estimated costs placed on the order at the time of the label printing. Sellercloud can import UPS, DHL Express, and DHL eCommerce (DHL Global Mail) invoices without the need for reformatting. For all other carriers, you can download and populate a template.

For UPS shipping cost, use the file from UPS called UPS Billing Data File – XML. Pulling the file from UPS requires enrolling here.
DHL Express shipping cost can be calculated during order creation by clicking the Calculate link in the order’s Shipping Method section. However, Sellercloud will only calculate it if a shipping weight was entered. Due to DHL’s less than one lb / more than one lb system, weight is often not entered. Therefore, this tool is essential for orders shipped via DHL.
  1. Go to OrdersImport Shipping Cost.
  2. For UPS, FedEx, and DHL, click their respective tabs.
  3. Choose the invoice file and Import Shipping Cost.

DHL eCommerce (DHL Global Mail) DHL eCommerce through Endicia does not return shipping costs, so Sellercloud cannot automatically add it to orders. Setting the shipping cost on these orders requires importing it:

  1. Go to Orders > Import Tracking Info.
  2. Choose the CD DHL Tracking Cost Import plugin. This plugin may need to be installed on your server; if so, contact Sellercloud Support.
  3. Choose the DHL Ecommerce file > Import Tracking Details.
This process can be automated through a scheduled task. Use the task Import Order with the DHL Shipping Cost plugin.

Other carriers to reconcile all other carriers:

  1. Click Orders > Import Shipping CostDownload Sample.
  2. Populate the columns with the OrderID or the Tracking Number as the identifier, enter the Shipping Cost, and save the file.
  3. Click Choose File to select the populated file.
  4. Click Import Shipping Cost for the carrier to reconcile (Sellercloud handles formats for UPS, UPS Mail Innovations, and DHL Global).

Obtain XML Invoices

To import shipping costs, you need invoice files in XML format from your carrier. 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 with 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.

After the shipping file is imported, Sellercloud updates the shipping cost on the order, and you can see details of the charges.


Was this article helpful?

Need Support?
Can't find the answer you're looking for?
Contact Support