Skip to main content

How to Edit Store Locations for Store Locator

  1. Update this google sheet - add the location name, lat / long coordinates, address, type, geomety type, and image.

Google sheet:
https://docs.google.com/spreadsheets/d/1T-ANptBFEuTw-KA0eyiV6ZT1jQsBtQiVLjxRuO8sGtA/edit?gid=0#gid=0

Make sure to add Feature and Point for every location in the spreadsheet. Basically, how it is laid out on the sheet, is how it needs to be for every location added.

You can use this tool to get the latitude and longitude coordinates:
https://www.mapdevelopers.com/geocode_tool.php

  1. When the sheet is done being edited, download a CSV
  2. Upload to CSV file here https://www.convertcsv.com/csv-to-json.htm

Click choose file and upload the CSV file

Select the RESULT DATA button and copy

The data you just copied will be going into the metafield. In the admin panel of the shopify store, select the retail locations page.

https://admin.shopify.com/store/shop-campania/pages/86940483667"

Use the Map Data metafield.

Highlight all of the data there, then DELETE.

Add this code is at the top (copy/paste) - like the screenshot below

{"type":"FeatureCollection","features":
INSERT CSV HERE
}

Delete the INSERT CSV HERE text and that is where you will paste the code from the csv converter website

Then, click DONE. The locations will then update on the front end of the website.