How can I add or modify location data in bulk?
Table of Contents
1. Navigate to the Location Hub, select the locations you wish to update by checking all or some of the checkboxes on the left-most side of the location list, then click "Export".
2. An excel will be generated containing your location data.
Important:
- The first two columns contain the identifiers
- The location identifier must match the Google Store Code before connecting your Google account.
- Location Identifiers must be unique within each Business.
- DO NOT change the identifiers with the import function.
Changing an identifier must be done on the location directly in the platform.
If the existing locations do not have an identifier, you will not be able to use the import function. Otherwise you will end up creating duplicates.
3. When adding new locations with the import function, make sure you add the correct Business Identifier (Column A) for the Business where you wish to add the location, and a unique Location Identifier (Column B) for each new location.
When creating new locations, ensure the following fields are filled out:
- status (Column C): set you location to ACTIVE or CLOSED
- addressDisplay (Column AJ):
true = your location has a physical address
false = you would like to hide the address of your location on the listings.
- autosync (Column AK):
true = your location's data will be synced as soon as you click "Save"
false = you will be required to manually click on "Sync" every time you change location data.
- Address format: streetandnumber / address line 1 (Column E) - must only contain street and street number.
Any additional information must be stored in addressextra (Column L).
If you have questions on how to populate this document, you can refer to this link and this checklist.
Important:
Do not remove the additional sheets (Events/Products/Menu/People)
Tip: If you are performing location updates, you are able to import only the relevant columns and remove the rest, except for the businessidentifier (Column A) and identifier (Column B).
4. When your locations are ready, navigate to the Locations tab within the Location Hub and click on 'Add location' > 'Excel'.
5. Click 'Select File' and choose the file with your new and/or updated location data from your computer.
6. You will be asked to match the columns and fields from your file with the fields in Uberall. If you haven't changed or added any new column headers, all matches should be made by default.
7. Import preview allows you to review how many entities will be created and/or updated as a result of your import. Ensure this matches your expectations.
8. Click 'Start Import'. Your locations will be created/updated as soon as the file has finished importing.
Error Messages
If there were any issues when importing the locations you will be notified.
To read more about common error messages and how to fix click here.
If you want to learn more about tips and tricks when using the import function click here.
If you would like to use your own file format, please follow the instructions specified here.