Importing an ERR List in PitneyShip Pro or PitneyShip Enterprise

You can import a CSV file of ERRs so that you can print the labels and coversheets for them all at once, or perform a mail merge using your own process.

The features and options you see may vary depending upon your role and subscription. If you have any questions regarding your permissions, please contact your administrator.

1. Select Shipping & Mailing > Import ERR List.
2. Select Upload File.
3. Click .csv template or .xlsx template. This will download a template to use to for the ERR list you upload. Make sure your pop-up blocker is disabled for SendPro Enterprise.
   • err_shipment.csv or err_shipment.xlsx – after your enter data into the template, you will upload it to PitneyShip
4. Click Download your carrier and sub-carrier accounts and service level values for reference. This will download two reference files to use when completing the ERR list. The data in these files is used to complete the ERR import file or template. These files are unique for each PitneyShip account. Examples of those files are shown below. The highlighted sections will be used in the file you are importing into PitneyShip.
   • carrierAndServiceMapping.csv – this file contains the unique Service and Packaging Type names
     
   • carrierAndSubCarrierMapping.csv – this file contains the unique Sub Carrier ID for each account
     
5. Enter your ERR Import requests into in the err_shipment template. Use the highlighted columns in the examples of the carrierAndServiceMapping.csv and carrierAndSubCarrierMapping.csv files to locate the data for the required fields in the err_shipment template. Below is an example of the err_shipment template filled in with the Sub Carrier ID, Service, And Packaging type from the mapping files.
   
   1. Refer to the reference files to populate these required fields:
   

   Populate this column		With this value
   ERR List column letter	ERR list column header	Reference file	Column letter	Column header
   O	Sub Carrier ID	carrierAndSubCarrierMapping	B	ID,Sub
   P	Service	carrierAndServiceMapping	B	Service
   Q	Package Type	carrierAndServiceMapping	D	Packaging Type

   1. Use the following values for these required fields

   ERR_Shipment column	ERR_Shipment column header	Value (options are shown in the header)
   A	Shipment ID	Can be a reference number or other unique identifier – will vary according to your preference
   AE	Special Service	ERR, E-Certified
   AG	ERR Output	Coversheet, Label
   AH	Coversheet Size	10, 6X9, 6X9.5, 9.5X12

6. Save the template spreadsheet as a CSV file.
7. Click Choose File, select your file, then click Open.
8. Click Continue.
9. In the Map Imported Fields window, if you used your own template, you may have to map the headings from your file to the PitneyShip Enterprise field names.
   • Map your file column headers to our field names.
     • Use Overrides to override the data in your file with a single value for all of the imported records. For example, you can select a Cost Account or add Shipping Notes that will apply to all the records in your file. Or, instead of filling out all the fields in the err_shipment template as shown below, use Overrides to save time by applying the same carrier’s package type and service to all the records in the import.
       
   • If you want to save these mapping choices for future imports, select Remember mapping choices for future imports.

1. Click Import ERR List.
2. Correct any errors.
   • Shipments are grouped by Label and Coversheet. If any shipments in a group need correction, you will not be able to print. Click either the Coversheet or Label tab to view the uploaded data. hover your mouse over the Attention Required text to see the message, then click the text to open the shipping record and make the correction.
     
3. Make the corrections and click Save Changes. If the Print button is disabled, that means that more corrections are needed.
4. To print a single transaction in the ERR List, click the Print icon for that transaction. To print some or all the transactions, check the boxes next to the date for each transaction you need to print, or check the box next Transaction Date to select all transaction in the ERR List. Then select Print Coversheet and Stamp or Print Shipping Label depending on what type of transactions were uploaded.
5. Select the printer options, then select Print.

Related topics

• Downloading ERR Mail Merge files