Import & Export
If you have more than a handful of stores to create in Store Locator, you may find it easier to make use of our import & export capabilities.
Import
To get an example CSV file format, you can first create a CSV export using our export tool.
Columns
The following columns are supported:
| Column | Required | Allowed Values | Notes |
| enabled | yes, no | ||
| name | Yes | This must be unique for each location. When an imported row matches an existing location, this location will be updated instead of creating a new location. | |
| address_full | Yes but can be empty | This field can be used in lieu of using the address, address2, city and county fields separately | |
| address* | First line of the address, will be combined into "address full" upon import | ||
| address2* | Second line of the address, will be combined into "address_full" upon import | ||
| city* | Will be combined into "address_full" upon import | ||
| county* |
Will be combined into "address_full" upon import | ||
| postcode | Yes | |
|
| country | Yes | United States, US, United Kingdom, GB, etc | Accepts country name or 2-digit codes |
| latitude | Can be empty but will be required before displaying the location in the store locator on the storefront. | ||
| longitude | Can be empty but will be required before displaying the location in the store locator on the storefront. | ||
| map_pin_color | Hex color code | Requires prefixing with #, e.g. #FF0000. To use the default pin color, leave it blank. | |
| phone | |||
| url | |||
| image | This should be a WebDAV path, e.g. /dav/content/image.jpg |
||
| channels | Pipe-sepated list of channels, e.g. "Store One|Store Two" | ||
| tags | Pipe-separated list of tags, e.g. "Parking|Wi-Fi|Garden" | ||
| enable_opening_times |
yes, no | ||
| monday_from | closed, 24 hours, 09:00 | ||
| monday_to | closed, 24 hours, 17:30 | HH:MM format | |
| ... repeated for other days of the week | |||
* These address fields are not included when exporting but are supported columns when importing locations. They are an alternative way of populating the address_full field.
There is no column mapping function and so these exact column headings are required in any imported spreadsheet.
Upload
When you're ready, you can then upload your CSV file to create & update your store locations.
If there are any errors, these can be viewed by clicking the warning triangle button
Export
To export your existing store locations, choose the Download button within the Export tab.
