Have your locations in a spreadsheet? We make it easy to import them and keep them up to date. Drop in your file, match your columns to Storepoint fields, and you're good to go.
Each location needs a name and an address. Every other column is up to you.
| Store | Street address | Products |
|---|---|---|
| Whole Foods Market | 10 Columbus Circle, New York, NY 10019, USA | Coffee, Tea |
| Whole Foods Market | 525 N Lamar Blvd, Austin, TX 78703, USA | Coffee |
| Galeries Lafayette | 40 Boulevard Haussmann, 75009 Paris, France | Coffee, Gift sets |
| KaDeWe | Tauentzienstraße 21-24, 10789 Berlin, Germany | Tea |
| David Jones | 86-108 Castlereagh St, Sydney NSW 2000, Australia | Coffee, Tea |
A few tips:
- Use the full street address. We use it to place each location in the right spot on the map.
- Address in separate columns, like Street, City, and Postal code, works too. Match each one to its field in step 2.
- Delete any totals or notes below your list.
- Want buttons or extra text on your locations? Create custom fields before you start.
- Save as CSV (
.csv) or Excel (.xlsxor.xls). In an Excel file, we read the first sheet.
Using Google Sheets? Download the sheet as CSV or Excel. Or connect the sheet, and changes come in by themselves.
Starting from nothing? Our template has the usual columns ready.
Using custom fields? In Storepoint, select Download starter template beside the import box. That one includes them.
We save your file as a source. When your list changes, you upload the new version, and your locator updates to match.
- In Storepoint, open Locations > Imports & syncs.
- Select CSV / Excel.
- Drop your file in the box, or select Browse files.
- Check the Source name, such as "Retailers".
- Select Continue.
If you import more than one file, give each one its own source, such as one for each distributor. Each source saves its setup. When a distributor sends a new report, just drop it in. Only that distributor's locations change.
To add a source, select New source.
Use a one-time import insteadIf you'll make changes in Storepoint from now on, not in a spreadsheet.
A one-time import adds your locations, and that's it. We don't use the file again. When something changes, you edit the location in Storepoint.
It's handy when you move from another store locator, or when you add a batch of new locations to the ones you already have.
- In Storepoint, open Locations > Imports & syncs.
- Select One-time import.
- Drop your file in the box, or select Browse files.
- Select Continue.
Then follow steps 2 and 3.
We match your columns for you, like this:
- Storeimports as Name
- Street addressimports as Address
- Productsimports as Tags
Match anything customers should filter by, like products or services, to Tags. After you import, you can sort your tags into filters. See how tags become filters.
For extra details, like a button or more text, match your column to a custom field. Create the custom field before you start.
- Check each column under Imports as, and change any you want.
- Make sure one column goes to Name and one goes to Address.
- For a column you don't need, choose Do not import.
- Select Preview import.
Nothing changes until you select Import locations.
The preview shows a sample of your locations, and what will change.
- Check the names and addresses under Sample locations.
- Check how many locations we'll add, update, and remove.
- If something looks wrong, select Edit mapping.
- Select Import locations.
You can leave the page while the import runs.
Check: Select View locations. Your new locations are in the list.
That's it. Your locations are live.
Already have the locator on your website? It shows them as soon as the import finishes. You don't change any code.
When your list changes, or you get a new distributor report or export, upload the new version. We update your locations to match it.
- Open Locations > Imports & syncs.
- Find your source.
- Drop your full updated file on Upload an updated file.
- Check the preview.
- Select Confirm update.
If you used a one-time importEdit locations in Storepoint, or replace your whole list with a new file.
To edit a location:
- Open Locations > All locations.
- Select the location.
- Change its details.
- Select Save Changes.
To replace your whole list with a new file:
- Delete all your locations.
- Import the new file with CSV / Excel, as in step 1.
From then on, you can update it with the steps above.
Only Name and Address are required. Everything else is up to you. Match each column in step 2.
For city, state, postal code, country, phone, email, website, and description, just match the column. These need a little more:
TagsWhat customers filter by, like products or services.
Match your column to Tags. In each cell, put commas between tags, such as Coffee, Tea.
You can match more than one column to Tags, such as Products and Services. We combine them for each location.
After you import, open Tags & Filters and sort your tags into groups. Each group becomes its own filter. For example, a Products filter with Coffee and Tea, and a Services filter with Delivery. New tags start in the Default group. Set up your filters.
Opening hoursOne column for each day.
Match each day's column to its field, such as Monday Hours. In each cell, enter the hours, such as 9:00am - 5:00pm, or enter Closed.
Closed for lunch? Put a comma between the times: 9:00am - 12:00pm, 1:00pm - 5:00pm. See Opening hours for more formats.
PhotosUse a link to the image file itself.
Match the column to Image URL. Each link must open the image file, such as https://example.com/images/store-photo.jpg. A link to a photo page or album doesn't work. See Location images for help.
Latitude and longitudeOptional. We find the spot from the address.
You don't need these. We find each location's spot on the map from its address.
Add them if an address is hard to find, such as a new building or a rural road. Or add them if you already have exact coordinates you want to use.
Match both Latitude and Longitude. Keep the address matched too. Customers still see the address in your locator.
Custom fieldsButtons, extra text, and more. Create them first.
Custom fields add extra details to your locations, such as a Book now button, a second phone number, or a note about parking.
- Create your custom fields in Storepoint before you import.
- In step 2, find them under Your custom fields in the Imports as list.
For a button or an icon link, put the full web address in each cell. For text or a phone number, put the value. A field shows only on locations that have a value.
Draft locationsHide a location until it's ready.
Match a column to Status (Published/Draft). Enter Draft to hide a location. To show it, enter Published or leave the cell empty.
Stuck? Email us at [email protected]. Attach your file, and we'll help you finish.
If I import the same file twice, do I get duplicates?
No. If a row has the same name and address as a location you already have, we update that location.
If you change a name or address in your file, we add it as a new location and remove the old one.
After a one-time import, the old one stays. Delete it in All locations.
My file lists each store once for every product. Does that work?
Yes. Many distributor reports look like this. Match your product or SKU column to Tags. Rows with the same store name and address become one location, with all their products as tags.
| Store | Street address | Product |
|---|---|---|
| Whole Foods Market | 525 N Lamar Blvd, Austin, TX 78703, USA | Coffee |
| Whole Foods Market | 525 N Lamar Blvd, Austin, TX 78703, USA | Tea |
Shoppers can then filter by product. See Store locator from distributor reports.
A location didn't show up after the import. Why?
We couldn't find its address on the map, so we skipped it. Check the address in your file, or add its latitude and longitude. Then upload the file again.
If it's in All locations but not on your locator, check that it isn't a draft.
Do I need to change the code on my website?
No. Your locator shows the new locations as soon as the import finishes.
Do I have to use your template or column names?
No. Use your own headings, and match them in step 2. For columns you don't need, choose Do not import.
How many locations can I import?
Your plan sets the limit. To see it, open Account > Subscription.
Can my spreadsheet update my map by itself?
A file needs a new upload for each change. For updates that come in by themselves, connect a Google Sheet. Scheduled syncing starts on Pro.
Can I edit imported locations in Storepoint?
Yes. You may need to select Edit anyway first. Your next upload can replace that edit, so make lasting changes in your spreadsheet. See where to make lasting changes.
After a one-time import, edit them like any other location.
What if the import stops with an error?
Read the message on the import screen. Check your file type, your Name and Address columns, and your matches.
Some locations may have changed before the error. Check All locations before you try again. If you're stuck, email us the message and your file.
Facebook, Instagram, and XA full link or just the handle.
Match each column to Facebook, Instagram, or X / Twitter. In each cell, put a full link, such as
https://instagram.com/wholefoods, or just the handle, such as@wholefoods.