Shipping Response CSV Import (UPS & FedEx)

After using the Shipping Export functionality to export delivery details to send to your shipping provider (see KB Article Shipping Export to WorldShip® and Shipping Manager® (UPS & FedEx), you will receive a response from them depicting the tracking number assigned to each delivery and optionally a price.

If there are other details pertaining to the deliveries, they will need to be removed before importing.

CSV Upload File

The CSV upload file should consist of either 2 or 3 columns.

      Column Name       Description

      ShipmentID       The unique Delivery Identifier.

      TrackingNumbers       Unique Consignment Numbers from your Shipping provider.

      Price (optional)       Optional Shipping Cost Price to be applied to the consignment.

Wise Words

Ensure the ShipmentID values do not have thousand comma separators.

(select Column, Right Click on it and select Format Cells and set Category to ‘General’ are formatted as ‘General’…

These columns must be titled as shown below. The order of the columns does not matter.

Each row corresponds with a delivery in printIQ.

If there are multiple products on the delivery, they can be separated in the TrackingNumbers entry with commas. The contents of this column are imported in their entirety into The Consignment Note field.

If the Shipping Export / Import has been enabled on your system, you should see an Import Consignments button on the Dispatch Board:

Click on this to open the Import Consignment modal:

The modal will present the results of the consignment import:If there are errors, they are detailed per consignment.

If there are errors, they are detailed per consignment:

Entries that could be imported, will have imported successfully.

If there is a price set against the consignment, this is applied to the Actual Shipping field on the delivery record. This does not affect the quoted or invoiced price to the Customer.

• Related Articles

• Shipping Export to WorldShip and Shipping Manager (UPS & FedEx)

  ‘Shipping Export’ provides an efficient solution for high volume businesses and international freight. Shipping entries can be exported directly from the Dispatch Board to your freight suppliers that accept a CSV formatted import for rapid ...

• Freight - Blind Shipping

  Overview Blind Ship allows you to specify a virtual ‘From’ address on your delivery labels. This means that the dispatch ‘Origin’ details are ‘masked’ so that the delivery appears to have come from a different location. Brokers who wish to give the ...

• Deliveries - Upload Shipping/Dispatch Information on Quote and Job Details

  Introduction Often job can require multiple deliveries. These can be added manually but they can also be done in bulk, via a csv upload. The upload can be completed at both quote and job level. Quote On the quotes ‘Order Details’ page, the ‘Freight’ ...

• Freight - 3rd Party Shipping

  Introduction 3rd party shipping allows printIQ to use ‘Customers Supplied Credentials’ for shipping rates and services. Essentially the shipping is being booked on and invoiced directly to the customer from the freight provider. When a 3rd party ...

• Dispatch Board - Freight by Product

  Overview This article covers the Dispatch Board for systems configured to price freight by product (‘Old’ Freight). For systems using freight by cart, refer KB article Dispatch Board – Address (Cart) Based ‘Freight by Product’ is basically a freight ...