Location File Import Specifications for in PitneyShip Enterprise, PitneyTrack Inbound, PitneyAnalytics, and the Locker Management Module

Specifications for importing Location files into in PitneyShip Enterprise, PitneyTrack Inbound, PitneyAnalytics, and the Locker Management Module
Products affected: PitneyShip® Enterprise, PitneyTrack® Inbound, PitneyAnalytics™, Locker Management Module

Enterprise administrators can import shared locations into the system automatically on a fixed schedule from an SFTP server. The following are the field specifications for location import files.

Field Name

Required

Description

Example

Length

Other Requirements or Comments

DivisionID

Yes

The unique identifier for the Division

M0jjlWn0Bw9

Maximum 50

The Division must already exist in the system. Divisions will not be created through the import process. Division names are case-sensitive. You can find this ID in the Edit Division window.

LocationID

No

The unique identifier for the Location

WQjjrqvVqlo

Maximum 50

If the location does not already exist, the system will create a new Location. For existing locations, you can find this value by exporting your Divisions & Locations.

Name

Yes

Location Name

Main Office

Maximum 100

No character or format restrictions

Company

Yes

Company Name

Pitney Bowes

Maximum 100

No character or format restrictions

Phone

Yes

Phone Number

9876543210

Maximum 25

Numbers only. No hyphens, spaces, periods, parentheses, or other punctuation are allowed.

AddressLine1

Yes

Address Line 1

123 Street

Maximum 100

No character or format restrictions

AddressLine2

No

Address Line 2

Block A

Maximum 100

No character or format restrictions

AddressLine3

No

Address Line 3

Apartment 123

Maximum 100

No character or format restrictions

CityTownArea

Yes

City

New York

Maximum 100

No character or format restrictions

StateProvinceRegion

Yes

State, Province, or Region

New York

Maximum 100

No character or format restrictions

CountryCode

Yes

Country Code

US

2

2-character Country Code

PostalCode

Yes

ZIP Code or Postal Code

16065

Maximum 25

No character or format restrictions

ShipToBPN

Yes

Your Pitney Bowes Business Partner Number (BPN)

0012345678

Maximum 15

The BPN is a 10-digit number starting with 00. If you don’t know your BPN, you can find it under Settings > Divisions and Locations. Expand your division and look in the Account Number column.

Email

No

Email Address

[email protected]

No limit

 

ISReturnAddressSame

TRUE

True or False 

TRUE

No limit

Specifies that Return Address details are the same as specified for Address Line items. Must be in uppercase.

RLName

No

Return Location Name

California

Maximum 100

 

ReturnCompany

No

Return Company Name

Amazon

No limit

 

ReturnAddressLine1

Yes

Return Address Line 1

123 Street

Maximum 100

No character or format restrictions

ReturnAddressLine2

No

Return Address Line 2

Block A

Maximum 100

No character or format restrictions

ReturnAddressLine3

No

Return Address Line 3

Ground Floor

Maximum 100

No character or format restrictions

ReturnCityTownArea

Yes

Return City

New York

Maximum 100

No character or format restrictions

ReturnStateProvinceRegion

Yes

Return State, Province, or Region

New York

Maximum 100

No character or format restrictions

ReturnCountryCode

Yes

Return Country Code

US

2

2-character Country Code

ReturnPostalCode

Yes

Return ZIP Code or Postal Code

160065

Maximum 25

No character or format restrictions

ReturnPhone

Yes

Return Phone Number

9876543210

Maximum 25

Numbers only. No hyphens, spaces, periods, parentheses, or other punctuation are allowed.

ReturnEmail

No

Return Email Address

[email protected]

No limit

 

* If ISReturnAddressSame is set to False, then ReturnAddressLine1, ReturnCityTownArea, ReturnStateProvince, RetunrPostalCode are required.

UPDATED: February 01, 2024