Import stores from a CSV file

What this article helps you do

Upload a CSV file to import store locations into Mapstore. Use this method for one import or for infrequent updates.

Before you start

• You have a CSV file with store data.
• Each row has the required name and address columns.
• Optional columns include phone, email, website, description, and filters. See Prepare a CSV file.

Step-by-step instructions

1. Go to Stores -> Bulk

1. In Mapstore, go to Stores.
2. Open Bulk.

The CSV upload section has File and URL options.

2. Select File mode

Select Upload a CSV file (or File) as the import method.

3. Prepare and upload

1. Make sure that the CSV has a header row with name and address.
2. Drag and drop your CSV file into the drop zone, or click to select it.
3. If you want to replace previously CSV-imported stores with this CSV, check Delete existing stores uploaded through CSV.
4. Click Test CSV to preview the import without a change to store data.
5. Review the planned changes and skipped rows.
6. If necessary, fix the file.
7. Test the file again.
8. Click Upload.

4. Start a replacement import

If you checked Delete existing stores uploaded through CSV, Mapstore shows a confirmation message. Continue with the import.

5. Wait for processing

• Mapstore immediately processes files with 1,000 rows or fewer and shows a success message.
• Mapstore processes larger files in the background.
• Mapstore sends an email only when it skips rows or the import fails.

How to verify it worked

1. Go to Stores.
2. Make sure that you can see your locations.
3. If Mapstore skipped rows, use the row numbers and causes in the import summary.
4. Open the store locator on the storefront.
5. Make sure that you can see the stores on the map.

Troubleshooting

Related articles

• Prepare a CSV file
• Import stores from a CSV URL
• Replace CSV-imported stores
• Fix skipped CSV rows
• Preview a CSV import or Google Sheets sync