Importing DataUpdated 2026-08-25
Choose how to add stores
What this article helps you do
Compare the four ways Mapstore adds and updates stores.
Before you start
- Mapstore is installed.
Select a method
1. Manual entry
Manual entry adds one store at a time.
- Use Stores to add or edit one store at a time.
- You control each field.
- Mapstore records the store source as manual.
2. CSV file upload
CSV file upload reads a file from your computer.
- Go to Stores -> Bulk.
- Select Upload a CSV file.
- Upload your CSV.
- Include the required name and address columns.
- Mapstore immediately processes files with 1,000 rows or fewer.
- Mapstore processes larger files in the background.
- Use Delete existing stores uploaded through CSV when you must replace earlier CSV imports.
Each update requires a new file selection and upload.
3. CSV URL import
CSV URL import reads a public CSV file from a URL.
- Go to Stores -> Bulk.
- Select Import from a CSV URL.
- Paste the URL to a CSV file or a published Google Sheets CSV export.
- Use the same columns as a file upload.
- The URL must return CSV without a sign-in page.
4. Google Sheets sync
Google Sheets sync reads a published Google Sheets CSV URL on a schedule or by manual sync.
- Go to Stores -> Bulk.
- Find the Google Sheets sync section.
- Paste the published CSV URL (from File -> Share -> Publish to web, with
output=csv). - Do not use the edit link. URLs with
/editdo not work. - Enable sync.
- Start the first sync to import stores.
- Select up to five daily sync times in 15-minute steps. Mapstore uses the shop timezone.
How to verify it worked
- Select a method.
- Add or import stores.
- Make sure that you can see the stores in Stores.
- For Google Sheets, start a manual sync.
- Make sure that the stores match the sheet.
Troubleshooting
| Issue | Fix |
|---|---|
| Google Sheets URL rejected | Use the published CSV URL, not the edit URL. See Prepare a Google Sheet. |
| CSV rows skipped | Make sure that each row has name and address. See Fix skipped CSV rows. |