Importing Shipping Costs and Carrier Invoices

Click here for information on this function in Sellercloud’s original interface.

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.

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 Orders > Import 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 Cost > Download 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).

---

Enabling invoices using XML format

1. DHL ecommerce— You can request XML format invoices from your DHL account representative. An FTP account is set up by DHL, ftp.dhlglobalmail.com, 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. 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, select Create Download. 
4. After the shipping file is imported, Sellercloud updates the shipping cost on the order and you can see details of the charges.

---

Importing carrier shipping costs

Shipping costs that are applied to an order are only estimates; they are not actual rates charged. To view specific 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, FedEx, 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.

When importing shipping costs for UPS and DHL:

• UPS shipping cost imports use the file from UPS called UPS Billing Data File- XML. Pulling the file from UPS requires enrolling in UPS billing data.
• DHL Express shipping cost can be calculated during order creation by clicking the Calculate link in the order’s Shipping Method section.

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 Orders > Tools > Import Order Info.
2. For UPS, FedEx, and DHL, click either Import UPS Shipping Costs, Import FedEx Shipping Costs, or Import DHL Shipping Costs.
3. Click to upload file > Choose invoice file > Import.

Importing DHL eCommerce (DHL Global Mail) shipping cost

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. This plugin may need to be installed on your server; if so, contact Sellercloud Support.  

1. Go to Orders > Tools > Import Order Info > Import Tracking via Plugin.
2. Select Company. For Plugin, select CD DHL Tracking Costs Import v 1.0.0.2.
3. Click to upload file > Select your DHL Ecommerce File > Import.

This process can be automated through a scheduled task. Use the task Import Order with the DHL Shipping Cost plugin.  

Importing other carrier shipping costs

To reconcile all other carriers:

1. Go to Orders > Tools > Import Order Info > Import Shipping Costs.
2. Create a template > Populate the columns with OrderID or the Tracking Number as the identifier > Enter Shipping Cost > Save.
3. Return to Sellercloud > Click to upload file > Import.
4.  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

1. DHL ecommerce— You can request XML format invoices from your DHL account representative. An FTP account is set up by DHL, ftp.dhlglobalmail.com, 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. 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, select Create Download. 
4. After the shipping file is imported, Sellercloud updates the shipping cost on the order and you can see details of the charges.