Updating Multiple Existing Places
The CSV Upload feature allows Company Admins to update multiple Places at the same time.
Access CSV Uploads
There are two ways to access CSV Uploads for Places:
- Navigate to your user drop-down menu in the top right hand corner, and then select CSV Uploads.
- In the "Choose Upload Type" menu that appears, select Places. Click the blue "+ CSV Upload" button to continue.
OR
- Navigate to the Places tab from the Navigation Bar
- In the top right hand corner, click on CSV Upload
Update Existing Places
If you'd like to edit multiple Places that already exist in GoSpotCheck, click on "Update Existing Places."
Preparing Your File
To update places that exist within GoSpotCheck today, your file must include the GSC ID in a column header named "id" for every place being updated, along with the following optional column headers of every field you wish to update.
-
name
-
address
-
city
-
state
-
postal_code
-
country
-
custom_id
-
info_URL
-
disabled
-
latitude
-
longitude
-
place_group_[number]
-
place_group_[number]_action
- Plus any additional custom property fields you've added to the system. Formatted as "p_<property_name>". For example, to update a "region" property, the column header should be formatted as "p_region. "
Managing Place Group Associations
Place Groups are logical grouping of places, perhaps by region, retailer, management responsibility, or anything else that is meaningful to you.
To add a place to a Place Group as part of your CSV upload, you can use place_group_[number] as the column header. Place group columns should be formatted incrementally, for example 'place_group_1' and then the next column as 'place_group_2' etc. The values within each column represent the specific place group to which you want to add the place. For example to add a place to the "Large Format Stores" and "North Region" Place Groups, the Place Group portion of your csv file would look like the following:
place_group_1 | place_group_2 |
Large Format Stores | North Region |
If you'd like to remove places from an existing place group as part of your upload, use the "place_group_[number]_action" header with the value of "REMOVE". To remove a place from the "Large Format Stores" Place Group, the Place Group portion of your csv file would look like the following:
place_group_1 | place_group_1_action |
Large Format Stores | REMOVE |
Uploading Your File
- When you are ready to upload a CSV file, click Choose.
- Select the file you want to upload, and then click Open > Next.
- The system verifies that the CSV file you are about to upload contains the required columns. Click into the column name box (highlighted in blue) to match up the required columns and, if necessary, match them up to ones from your file and click OK.
- When finished, click Process CSV. You will receive confirmation that your CSV upload is in process. Once it completes, you see Completed in the status column.
In addition, you will receive an email message that your CSV Upload has completed.
- Click Places to view your Place updates in the system.