Order Shipping Cost Import


Overview

Shipping rates quoted by your carrier are estimates based on the information you have supplied. Other shipping charges may apply, and your final Shipping Cost may differ from the estimate, which will cause discrepancies in your orders’ Profit and Loss reports.

Because it is important to keep accurate order data, Sellercloud allows you to import the actual Shipping Costs for each carrier as described below.


Import UPS, FedEx, or DHL Shipping Costs

  1. Go to Orders > Tools > Import Order Info.
  2. From the Import Order panel, select Import UPS Shipping Costs, Import FedEx Shipping Costs, or Import DHL Shipping Costs for UPS, FedEx, or DHL, respectively.Import Shipping Costs Options for Fedex, UPS, and DHL
  3. Click on the File field, select the appropriate invoice file, and click Import.Import Shipping Costs Button
When you import the shipping cost for UPS, the specific UPS file called UPS Billing Data File- XML is used for import. Before you download that file template, you should enroll in UPS billing data.

Import DHL eCommerce (DHL Global Mail) Shipping Cost

Sellercloud cannot automatically add the DHL Global Mail Shipping Cost to orders, since DHL eCommerce does not return shipping costs. To set the shipping cost for these orders, ask the Sellercloud Support Team for a custom import plugin. Once the requested plugin is installed, follow the steps below.

  1. Go to Orders > ToolsImport Order Info.
  2. From the Import Order panel, select the Import Tracking via Plugin option.Import tracking via plugin
  3. In the Import Tracking via Plugin panel, select the Company.
  4. In the Plugin field, select CD DHL Tracking Costs Import.
  5. Click on the File field, and select your DHL Ecommerce file.
  6. Click Import.Import Shipping Costs

Import Other Carrier Shipping Costs

To import Shipping Costs for any other carrier, you can download and populate the default template. To download and import the ready-to-use file:

  1. Go to Orders > Tools > Import Order Info.
  2. From the Import Order panel, select Import Shipping Costs.Import Shipping Costs for Other Carriers
  3. On the Import Shipping Costs panel, click on the Download icon to download the template.
  4. Complete the template file by populating the following columns: OrderID or Tracking Number (as the identifier), and Shipping Cost. Save the file.
  5. Return to Import Shipping Costs, and upload the saved template from the File.
  6. Click Import. The import will be submitted to the queued jobs list.Import File Template

Request XML-Format Invoices

CARRIER PROCEDURE
DHL ecommerce You can request XML-format invoices from your DHL account representative. An FTP account is set up by DHL. Sellercloud picks up the dropped files with the help of a scheduled task.
UPS You can configure the generation of XMP-files within your UPS account. Then, you can download these XML-files from the UPS billing portal.
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.

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

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.


Was this article helpful?

Related Articles