Check a CSV before replacement

What this article helps you do

Preview the CSV with Delete existing stores uploaded through CSV selected.

Before you start

• Your CSV has the required name and address columns.
• Delete existing stores uploaded through CSV replaces only prior CSV-imported stores.
• Mapstore keeps manual stores during a replacement import.

Step-by-step instructions

1. Test the CSV with the replacement option selected

1. Select your CSV in Stores -> Bulk.
2. Select Delete existing stores uploaded through CSV.
3. Click Test CSV.

The preview shows the replacement plan and its deletions without store changes.

2. Check the import summary

The preview shows:

• Rows ready - Rows that Mapstore can process
• Planned changes - Stores that Mapstore plans to create, update, delete, or leave unchanged
• Skipped rows - Rows that failed, such as a missing name or address
• Warnings - Geocoding work and other issues to review

Fix all skipped rows before a replacement. Use the row numbers in the summary to find and correct those rows in your CSV.

3. Verify required columns and data

Make sure that each row has:

• A value in the name column (or alias like store_name)
• A value in the address column (or alias like full_address)

Mapstore skips a row if one of these cells is empty. Remove empty rows or add the missing values.

4. Check geocoding behavior

If your CSV has no lat or lng, a correct Google Maps API key is necessary for address geocoding. Without the key, Mapstore does not add coordinates. It cannot show these rows on the map. See Fix stores without map coordinates.

5. Start the replacement import

After you correct skipped rows and verify the preview:

1. Go to Stores -> Bulk.
2. Upload the same or updated CSV.
3. Check Delete existing stores uploaded through CSV.
4. Click Upload.
5. Read the confirmation message.
6. Continue with the import.

Manual stores stay. Mapstore removes only stores from a previous CSV import.

6. Keep a backup

Before a replacement, export the current stores or keep a copy of your CSV. You can import the copy again.

How to verify it worked

1. Make sure that the import summary has the expected count.
2. Make sure that the summary has no unexpected skipped rows.
3. Make sure that the Stores list matches your CSV.
4. Make sure that the store-locator map shows the locations.
5. Make sure that Mapstore kept the necessary manual stores.

Troubleshooting

Related articles

• Replace CSV-imported stores
• Move stores to Mapstore
• Fix skipped CSV rows
• Fix stores without map coordinates
• Preview a CSV import or Google Sheets sync