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 /edit do 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

  1. Select a method.
  2. Add or import stores.
  3. Make sure that you can see the stores in Stores.
  4. For Google Sheets, start a manual sync.
  5. 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.