Importing orders in PitneyShip or PitneyShip Pro

You can import a spreadsheet of orders as a CSV file. You can either download a template to use, or use your own format and map your data after import.
Products affected: PitneyShip™, PitneyShip™ Pro

You can import a spreadsheet of orders as a CSV file. You can either download a template to use, or use your own format and map your data after import.

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. From the Home screen or the Shipping & Mailing menu, select Ship Orders.
  2. Select Import .csv.
  3. Select Download our shipment .csv template to download a template to use to format your orders.
  4. Select Download your carrier, sub-carrier accounts and service level values for reference to download a file showing your carrier, sub-carrier accounts, and service level values. Use the information from this file to fill in the Carrier, Sub-Carrier Accounts and Service Level fields in the shipment template.
  5. Input your orders into the shipment template spreadsheet and save it as a CSV file.
  6. Select Browse and select your CSV file.
  7. (Optional) Select Add recipient contact data using my imported data to add the recipients from the imported file to your PitneyShip Pro contacts.
  8. Select Continue.
  9. On the Map Imported Fields screen, match your CSV file fields in the Your Imported Headers column with the PitneyShip Pro fields in the Mapping column.
    The Overrides column allows you to overwrite certain information in your spreadsheet with another value. For instance, if you want to use USPS for your carrier on all orders, you can select USPS in the Overrides column next to Carrier. For Order ID, any value entered in the Overrides column will be added to the beginning of the Order ID with an underscore, for example, MyOverride_11200.
    Map Imported Fields when importing orders
  10. (Optional) Select Remember mapping choices for future imports to save these mapping choices for future imports.
  11. Select Continue.
  12. In the Address verification options window, choose whether to use the suggested, verified addresses or keep the original addresses from the import file. If you choose Use Original, you will need to verify each address individually after importing.
  13. Select Import Orders.
  14. Once the orders are imported, select Done.

Note: Orders that are marked as Already in Process are orders that were imported by someone else. Only the user who imported an order can edit or print a label for it.

UPDATED: April 13, 2023