Add multiple locations to ActivityHero using import templates. Save time and streamline your setup process by uploading all your locations in bulk with just a few simple steps.
For an overview of importing in ActivityHero for an idea about how locations, activities, sessions, and other data are related to each other check out our help article How do I import data into ActivityHero?
Import New Locations
1. Download the sample templates from the link below, and read the instructions on how to use the spreadsheet.
2. Edit the locations template making sure all of the required fields are complete.
- A name for the location, address, city, state, and zip code are all required information.
- Leave the location_id blank. ActivityHero will automatically create a location_id after upload.
- The location name should be unique. If the location_name matches an existing location in ActivityHero, the location will be updated instead of creating a new location.
3. Upload your CSV file by clicking the Upload a new file button. Be sure to select the Location file type.
4. After uploading your CSV file, click the Validate button to see if your data is ready for import.
5. If there are errors, you will see Validation Failed. Click View Report to inspect the reason for the failure. Correct any errors, and then repeat step 3. For tips on frequent validation errors check out the section below.
6. When the file is validated successfully, the green 'Run' button will be available. Select this button to begin importing your information. This can take a few minutes, and changes may not be seen in the marketplace right away.
Common Location Validation Errors
Below is a list of common validation errors and how you might address them:
Creating new Location
Missing Data - One of the most frequent issues when importing new locations is missing data in required fields. To avoid this, make sure to carefully check your template for all necessary fields before exporting it as a CSV.
Location Data Fields
Data fields (* required fields)
- location_name * - If the session is online, there is no need to add address, city, state or zip code.
- is_main_location (yes or no)
- location_address *
- location_city *
- location_state (State should be a two letter abbreviation like CA or TX.) *
- location_zip *
- location_country
- Location_phone
Contact support@activityhero.com if you have questions or problems.