Once you have your locations set up within UpKeep, you can also use our Update Feature to make mass updates to your locations! So if you need to bulk update any details to locations you’ve already created, you can do that with this feature!
NOTE: The CSV template used to update your parts is different from the one used to import new parts!
How to Bulk Update Locations
- Navigate to your Locations section
- Click on Import
- Then, click on Download Current Locations
- Open the CSV in Excel/Google Sheets
- Do not remove or make any changes in Column A
- Remove any rows or columns that you otherwise do not need to update
- Save the CSV file
- Upload that CSV under Locations > Import > “Drop CSV here” or “Choose File”
NOTE: You can change or update existing information and add new information to empty columns, but you cannot erase or delete existing information!
TIP: Use the History tab to check your previous import history and well as what errors you may have run into!
NOTE: There are certain columns you can or cannot make changes to.
NOTE: The ID refers to a unique, UpKeep assigned ID. You can find each 10-character ID in the URL when clicking into the location/asset/part/etc. All IDs can also be found when exporting each data set in Column A of the CSV!
A – ID
NOTE: Do NOT make any changes in this column.
B – Name
SCWH – Carlsbad Building
Name or title of this location/building, text+number values
C – Address
2505 Palomar Airport Rd, Carlsbad, CA 92011
Full Address of this location
D – Longitude
E – Latitude
F – Created By
The email of the user that created this location
G – Parent Location Name
Note: You can leave this field blank if you are updating this location into a sub-location
H – Parent Location ID
This is the 10-character unique ID of the Parent location that you will assign this location to
I – Assigned To
Name or email of the user that is assigned to this location
J – Assigned To ID
This is the 10-character unique ID of the user(s) assigned to this location
K – Team Assigned
Tier 1 Maintenance team|Admins
Name of the team that will be assigned to this location
L – Team Assigned ID
This is the 10-character unique ID of the team(s) assigned to this location
M – Customer Assigned
Names of the customers assigned to this location
N – Customer Assigned ID
This is the 10-character unique ID of the customer(s) assigned to this location
O – Vendor
P – Vendor Assigned ID
This is the 10-character unique ID of the vendor(s) assigned to this location
Q – Created On
06/25/2020 16:00:49 PDT
The original date this location was created within UpKeep
R – Updated On
06/25/2020 16:00:49 PDT
The date of the last time this location was updated within UpKeep
TIP: If you experience any errors, try using the History tab under Import to see what rows may have failed and why!