Import Shipping Costs - UPS and DHL Invoices
Shipping costs that are 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.
UPS and DHL Express
- Navigate Orders > Import Shipping Cost.
- For UPS and DHL, click their respective tabs.
- 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:
- Navigate Orders > Import Tracking Info.
- Choose the CD DHL Tracking Cost Import plugin. This plugin may need installing on your server; if so, contact SellerCloud Support.
- Choose the DHL Ecommerce file and Import Tracking Details.
To reconcile all other carriers:
- Click Orders > Import Shipping Cost > Download Sample.
- Populate the columns with the OrderID or the Tracking Number as the identifier, enter the ShippingCost, and save the file.
- Click Choose File to select the populated file.
- Click Import Shipping Cost for the carrier to reconcile (SellerCloud handles formats for UPS, UPS Mail Innovations, and DHL Global).
Enabling invoices using XML format
- DHL ecommerce - You can request XML format invoices from your DHL account representative. An FTP account is setup by DHL, ftp.dhlglobalmail.com to drop off the files, and SellerCloud picks them up using a scheduled task.
- 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.
- After the shipping file is imported, we update the shipping cost on the order and you can see details of the charges.