1. Purpose

This document describes how to configure UPS WorldShip to import shipments from the Freight export generated by PrintIQ. (see https://printiq.zohodesk.com/portal/en/kb/articles/v46-shipping-export-to-worldship-and-shipping-manager-ups-fedex for support on export process out of PIQ)

• Automatically create UPS shipments

• Support blind shipping

• Use ShipmentID as the primary reference so UPS end-of-day data can be re-imported into our system.

2. Prerequisites

• UPS WorldShip installed and configured

• Access to the CSV export file generated by PrintIQ (e.g. PIQ_Freight_YYYY_MM_DD.csv)

• Network or local folder where the export file will be placed each day

• This mapping assumes:

  • Delivery_Type has been parsed to a clean UPS service name (e.g., “UPS Ground”)

  • Address_State is a 2-letter state code when shipping within the US

  • Weight is in pounds

3. CSV Field Overview

The export contains (by default) the following columns:

• ShipmentID

• Job

• Company_Name (internal customer; not sent to UPS)

• Title

• Product_Number

• Weight

• Number_of_Packages

• Delivery_Type (parsed to true UPS service name)

• Delivery_Option

• Contact_Name

• Contact_Phone

• Contact_Email

• Address_Name (display name for the ship-to, used for blind shipping)

• Address_Line_1

• Address_Line_2

• Address_Line_3

• Address_State

• Address_City

• Address_Postcode

• Address_Country

• Bill_Transportation_To

• Payor_Account_Number

• Dispatch_Instructions

4. Field Mapping Summary

4.1 Ship To (Recipient)

4.2 Shipment-Level Fields

4.3 Package-Level Fields

5. Creating the Custom Import Map in WorldShip

Step 1 – Open Map Editor

1. Launch UPS WorldShip.

2. In the main menu, go to:
   Import/Export Data → Create/Edit Map.

Step 2 – Create New Shipment Import Map

1. Click New.

2. Choose Import Map.

3. Select Shipment as the map type.

4. For data type, choose Delimited File (CSV).

5. Browse to a sample PIQ_Freight CSV file and select it.

6. Click Next.

WorldShip will read the header row and display all your CSV columns.

6. Mapping Fields in WorldShip

WorldShip’s map editor typically shows:

• Left panel: CSV fields

• Right panel: UPS Shipment fields

You assign a CSV field to a UPS field by double-clicking or dragging.

6.1 Map Ship To Fields

Map as follows:

• Ship To → Company ⇨ Address_Name

• Ship To → Name ⇨ Contact_Name

• Ship To → Address 1 ⇨ Address_Line_1

• Ship To → Address 2 ⇨ Address_Line_2

• Ship To → Address 3 ⇨ Address_Line_3

• Ship To → City ⇨ Address_City

• Ship To → State ⇨ Address_State

• Ship To → Postal Code ⇨ Address_Post_Code

• Ship To → Country/Territory ⇨ Address_Country

• Ship To → Telephone ⇨ Contact_Phone

If using email notifications:

• Quantum View → Email Address ⇨ Contact_Email

6.2 Map Shipment Fields

Map as follows:

• Reference → Reference 1 ⇨ ShipmentID

• Reference → Reference 2 ⇨ Job

• Service → Service Type ⇨ Delivery_Type

• Billing → Bill Type ⇨ Bill_Transportation_To

• Billing → Account Number ⇨ Payor_Account_Number

• Shipment → Instructions ⇨ Dispatch_Instructions

Do not map Company_Name (this stays internal and supports blind shipping).

6.3 Map Package Fields

• Package → Weight ⇨ Weight

• Package → Number of Packages ⇨ Number_of_Packages

This allows a single row to generate multiple package labels for a shipment.

7. Saving the Map

1. Click Finish or Save in the Map Editor.

2. Name the map (e.g., PrintIQ_Freight_Import).

3. Confirm and close the Map Editor.

8. Running the Batch Import

Each time you have a new PIQ_Freight CSV file:

1. Ensure the file is in the expected folder.

2. Open WorldShip.

3. Go to Import/Export Data → Batch Import.

4. Select the PrintIQ_Freight_Import map.

5. Choose the specific CSV file to import.

6. Run the import.

WorldShip will:

• Create shipments based on the CSV

• Generate labels based on your print setup

• Track shipments using ShipmentID as Reference 1

9. Testing Checklist

Before you go live:

1. Create a test CSV with several rows (single-box and multi-box).

2. Run the Batch Import using the new map.

3. Open the imported shipments in WorldShip and verify:

   • Correct ship-to name and address

   • Correct UPS service (e.g., Ground, 2nd Day Air)

   • Correct number of packages and weights

   • Correct Reference 1 (ShipmentID) and Reference 2 (Job)

4. Print labels and confirm:

   • Blind shipping shows Address_Name

   • Tracking numbers can be matched back to ShipmentID in your system when you import the file output from UPS (after you run EOD)

Once verified, the process is ready for production use.