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 Integration Module - UPS
Introduction Please note * Each individual provider is different and requires different information that must be obtained prior to setting up in print IQ. * All integration are configurable from one screen in print IQ that is available on the main ...Freight Integration Module - FedEx
Introduction Please note * Each individual provider is different and requires different information that must be obtained prior to setting up in print IQ. * All integration are configurable from one screen in print IQ that is available on the main ...Freight - 3rd Party Shipping with Single Use Accounts
Introduction printIQ supports both single-use and pre-configured third-party shipping accounts, allowing customers and internal users to specify alternative billing accounts for freight. This feature ensures accurate shipping charge ...Automated FedEx and UPS Label Printing
Introduction Consignment labels from FedEx and / or UPS can be configured to print automatically on ‘download’. After the consignment has been created… Clicking the label file will automatically download it, send it to the printer and delete it from ...