Import Shipping Costs - UPS and DHL Invoices

Shipping costs that are applied to an order are only estimates and not necessarily actual rates charged.

You can import actual shipping costs for accurate P&L. Importing shipping costs will override estimated costs placed on the order at the time of the label printing. 

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

UPS and DHL Express

DHL Express Shipping Costs can be calculated during the order creation by clicking on the Calculate link next to the shipping rates. However, it will only calculate if a shipping weight was entered. Because of DHL's less than one lb/more than one lb. system, the weight is often not entered. Therefore, this tool is essential for orders shipped via DHL.
For UPS shipping cost, please use file "UPS Billing Data File - XML" from UPS. To be able to pull the file from UPS you need to enroll here.
  1. Navigate Orders > Import Shipping Costs.
  2. For UPS and DHL, click the respective tabs.
  3. Choose the invoice and import.

DHL eCommerce (DHL Global Mail)

DHL eCommerce through Endicia does not return shipping costs, so SellerCloud cannot add it to the orders automatically. To set the shipping cost on these orders, you must import it.
  1. Navigate Orders > Import Tracking Info.
  2. Select the CD DHL Tracking Cost Import plugin (this may need to be installed on your server by SellerCloud Support).
  3. Choose the DHL Ecommerce file and import.

This 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 Costs > Download Sample.
  2. Populate columns with either order ID or tracking number as the identifier, enter the shipping cost, and save the file.
  3. Click Import Shipping Cost for the carrier to reconcile (SellerCloud handles formats for UPS, UPS Mail Innovations, and DHL Global).
  4. Click Choose File to select the populated file > Click Import Shipping Cost.

Enabling Invoices using XML Format

  1. DHL ecommerce -  You can request XML Format Invoices from your DHL account representative. An FTP account is setup by DHL, to drop off the files, and SellerCloud picks them up using a scheduled task.
  2. UPS -  You can configure this on your account and it will generate XML files. You can download these XML files from the UPS billing portal.
  3. After the shipping file is imported, we update the shipping cost on the order and you can see details of the charges.

How did we do?