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.
phone
email
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"
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.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us