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. Click Shipping & Mailing > Certified Mail > Import ERR List.
2. Select Upload File.
3. Click .csv under Download a 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
4. Click Download carrier and sub-carrier account information. This will download two reference files to use when completing the ERR list.
   • carrierAndServiceMapping.csv
   • carrierAndSubCarrierMapping.csv
5. Enter your ERR shipment requests into in the err_shipment template.
   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	carrierAndSubCarrierMapping	B`	Service ID
   Q	Package Type	carrierAndSubCarrierMapping	D	Packaging Type ID
   AF	Special Service	carrierAndSubCarrierMapping

   1. Use the following values for these required fields:

   ERR List column letter	ERR list column header	Value (options are shown in the header)
   AF	Special Service	ERR
   AH	ERR Output	Coversheet, Label
   AI	Coversheet Size	10, 6X9, 6X9.5, 9.5X12

6. Save the template spreadsheet as a CSV file.
7. When you are ready to upload your file, drag-and-drop it to the dialog box, or select Click to select .csv, select your file, and select Open.
8. Click Upload.
9. If you used the Pitney Bowes template, click Confirm Mapping.
   If you did not use the Pitney Bowes 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 could select Letter for the Package Type for all of the packages in your file.
   • If you want to save these mapping choices for future imports, select Remember mapping choices for future imports.
10. In the Address verification options dialog box, select the verification option you want, then click Import Orders.
11. Click Load batch.
12. Correct any errors in your shipping requests.
    • Shipments are grouped by Label and Coversheet. If any shipments in a group need correction, you will not be able to print. Expand the group, 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.
      

1. Make the correction(s) and click Save Changes. If you cannot print, there are still errors that must be corrected.
2. Click the Print button.
3. Select the printer options, then click Print.

Related topics

• Downloading ERR Mail Merge files