You can now paste addresses into Ordoro that will auto-format to our address fields in Orders, RMAs, Warehouse addresses, and Supplier addresses. 

NOTE: The Paste Address field does not support phone numbers and email addresses at this time. 

We auto-format all US addresses and support auto-formatting the following International addresses: 

  • US
    Person Name
    Company Name
    1 Certain Street
    More Street Details
    Any City ST 90210-9999
  • Australia
    Person Name
    Company Name
    1 Certain Street
    More Street Details
    Any City NSW 1234
  • Canada
    Person Name
    Company Name
    1 Certain Street
    More Street Details
    Any City ON L3R 9P6
  • UK
    Person Name
    Company Name
    1 Certain Street
    More Street Details
    London
    SO31 4NG
  • All other types
    Person Name
    Company Name
    Street 1
    Street 2
    City
    State
    Zip
    Country

Please use the following key when pasting addresses into the Paste Address field:

1 line pasted

line 1

becomes

{
  "street1": "line 1"
}

Note: If the City, State, and Zip fields have information entered before updating line 1, these fields will clear out. 
If you need to update Street 1 only, we suggest clearing out the Street 1 field and pasting in the new address directly. 

2 lines pasted

line 1
<city/state/zip>

becomes

{
  "street1": "line 1",
  "city": "city part of line",
  "state": "state part of line",
  "zip": "zip part of line",
  "country": "country code determined from city/state/zip pattern",
}

NOTE: The City, State, and Zip must be in a comma separated or space separated format.

Examples:
City,State,Zip (comma separated)
City, State, Zip (comma and space separated)
OR
City State Zip (space separated)

We do not support the following format:
CityStateZip (no spaces or commas)

3 lines pasted

line 1
line 2
<city/state/zip>

becomes

{
  "name": "line 1",
  "street1": "line 2",
  "city": "city part of line",
  "state": "state part of line",
  "zip": "zip part of line",
  "country": "country code determined from city/state/zip pattern",
}

4 lines pasted

line 1
line 2
line 3
<city/state/zip>

becomes

{
  "name": "line 1",
  "street1": "line 2",
  "street2": "line 3",
  "city": "city part of line",
  "state": "state part of line",
  "zip": "zip part of line",
  "country": "country code determined from city/state/zip pattern",
}

5 lines pasted

line 1
line 2
line 3
line 4
<city/state/zip>

becomes

{
  "name": "line 1",
  "company": "line 2",
  "street1": "line 3",
  "street2": "line 4",
  "city": "city part of line",
  "state": "state part of line",
  "zip": "zip part of line",
  "country": "country code determined from city/state/zip pattern",
}

6 lines pasted

line 1
line 2
line 3
line 4
<city/state/zip>
country

becomes

{
  "name": "line 1",
  "company": "line 2",
  "street1": "line 3",
  "street2": "line 4",
  "city": "city part of line",
  "state": "state part of line",
  "zip": "zip part of line",
  "country": "country code determined from city/state/zip pattern",
}

7 lines pasted

line 1
line 2
line 3
line 4
line 5
line 6
line 7

becomes

{
  "name": "line 1",
  "street1": "line 2",
  "street2": "line 3",
  "city": "line 4",
  "state": "line 5",
  "zip": "line 6",
  "country": "country code determined from line 7",
}

8 lines pasted

line 1
line 2
line 3
line 4
line 5
line 6
line 7
line 8

becomes

{
  "name": "line 1",
  "company": "line 2",
  "street1": "line 3",
  "street2": "line 4",
  "city": "line 5",
  "state": "line 6",
  "zip": "line 7",
  "country": "country code determined from line 8",
}

Custom Pasted

If you only have partial information for multiple lines in the key, you can leave a blank row for any missing line. For instance, if you only have the company name, contact name, street address (Line 1), and city/state/ZIP, but do not have a second address line (Line 2), you should follow the 5 line key shown above, but leave Line 2 blank. Here’s an example:

Allison Krauss  
Peter's Putt Putt Company  
1234 Holey Lane  
  
Austin, TX, 78705

This will configure as shown below: