FAQ about the bulk upload function
Table of Contents
One of the ways to add or modify location data is via a bulk upload, which is importing the information using a spreadsheet. Here you will find some of the frequently asked questions about this topic:
Can I use my own Excel file to import location data?
It is possible to use your own Excel sheet instead of our template when bulk importing location data. However, you must name each column in your file as each of the Location Data Fields supported by our platform.
As soon as you have inserted all the data in the document, go back to the Locations tab and click on Import.
You will be asked to match the fields of your document with the fields of our app. Make sure to review them and click on "Continue". Your locations will be created as soon as the file has finished importing.
Please note that you can match each column to only one of our platform's fields. Also, this step needs to be repeated every time you upload a file this way.
Important:
Make sure that the format of the values, e.g. Dates and Opening Hours, are entered according to our requirements.
You can always refer to our own template if you are in doubt.
Can I delete locations or change their status in a bulk upload?
In order to change the status of locations in bulk, you will have to import a file containing the locations as well as the new statuses you would like to assign to them.
The options are:
- INACTIVE
- CANCELLED
You cannot delete locations from your account. If you would like to have your locations completely removed from our platform, our Support team can help you with the request.
Can I reactivate locations in a bulk upload?
Locations can be manually reactivated. However, you are only able to do it for one location at a time:
- From the Locations tab, please access the location you would like to reactivate
- Under its profile, you need to click the button Reactivate Location (right corner)
If you have numerous locations that need to be reactivated, please contact our Support Team to assist you.
Can I change the Location Identifier of my locations via a bulk upload?
In case you have erroneously imported the same Location Identifier for several locations, it is not possible to revert it using through the import feature.
If the import file containing locations that already existed within our platform, and whose Location ID was changed (becoming different than the one we had), the system will consider the imported Locations as new ones and will create them instead of editing the existing ones.
As a result, two or more locations will have the same content but different Location Identifiers. Duplicates will not be able to be published in directories.
In order to change Location Identifiers, you will have to manually do it in our platform (one at a time) or by contacting our Support Team with the request to change the IDs in bulk.
How can I modify my location's coordinates?
If you need to change the coordinates, you can change it directly in the platform as explained here.
Alternatively, you can use the Import feature, as explained in the steps below:
- Click on the Locations tab on the menu
- Get the location data export file, by clicking Export
- Update the latitude and longitude for the affected location(s) by updating the columns "lat" and "lng" in the export file and save it
- Click Import and upload the updated file
What columns are required when uploading a bulk file?
The columns "identifier" and "businessIdentifier" are required when uploading a bulk-edited file.
All other columns can be safely removed if they are to remain as-is, as long as all data including the column titles are removed. Any blank cells in a named and recognized column will replace the existing data for that location with a null value.