Location File Import Specifications for in PitneyShip Enterprise, PitneyTrack Inbound, PitneyAnalytics, and the 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. |
|
|
No |
Email Address |
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 |
No limit |
|
* If ISReturnAddressSame is set to False, then ReturnAddressLine1, ReturnCityTownArea, ReturnStateProvince, RetunrPostalCode are required.
UPDATED: February 01, 2024