Import Shipping Costs - UPS and DHL Invoices

Shipping costs that are applied to an order are estimated rates and are not necessarily the actual rates charged. The actual shipping costs can be imported for accurate P&L by. Importing the shipping costs will override the estimated costs that have been placed on the order at the time of the label printing. 
Currently, SellerCloud can import UPS, and DHL Express, DHL eCommerce (DHL Global Mail) invoices without the need for reformatting. A template can be downloaded and populated for all other carriers.

UPS and DHL Express

  1. Navigate Orders > Import Shipping Costs
  2. For UPS and DHL, click on the respective tabs.
  3. Choose the invoice and import.
Please Note: 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.

DHL eCommerce (DHL Global Mail)

  1. Navigate Orders > Import Tracking Info.
  2. Select the CD DHL Tracking Cost Import plugin. The plugin 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.  
DHLeCommerce 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.

Other carriers

To reconcile all other carriers, Navigate Orders > Import Shipping Costs. download the sample template and populate the columns. You can use the OrderID or the tracking number as the identifier. Then import the file.

Enabling Invoices using XML Format

  1. DHL ecommerce -  you can request the 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. Once the shipping file is imported, we update the shipping cost on the order and the user can also see details of the charges.

How did we do?