Importing Data Updated 2026-02-22

Understand skipped rows and import warnings

What this article helps you do

Understand why some rows are skipped during CSV import and how to fix them. This also covers cases where the upload succeeds but a few rows are left out.

Before you start

  • You have run a CSV import (file or URL) in Stores -> Bulk
  • You’ve seen a summary indicating skipped rows or warnings

Step-by-step instructions

1. Why rows are skipped

Mapstore requires two columns for every valid store row: name and address. Rows missing either field are skipped.

Common reasons:

  • Missing required field(s): name - The row has no value in the name column (or equivalent).
  • Missing required field(s): address - The row has no value in the address column (or equivalent).
  • Missing required field(s): name, address - Both are empty or missing.

2. How to read the import summary

After import (especially for smaller files processed immediately), the summary shows:

  • How many stores were imported
  • How many rows were skipped
  • For each skipped row: the row number (header is row 1) and the reason

Use the row numbers to find and fix those rows in your CSV.

3. Fix missing name or address

  1. Open your CSV in a spreadsheet or text editor.
  2. Find the skipped rows (the summary gives row numbers).
  3. Ensure each row has values in both the name and address columns.
  4. Fix obvious formatting problems, such as broken quotes, extra separators, or malformed values.
  5. Remove empty rows or fill them in.
  6. Save the file again as CSV and re-import.

4. Understand warnings

Warnings may appear for non-blocking issues, such as:

  • Column name variations or aliases
  • Minor formatting quirks that were corrected automatically

Warnings do not prevent import, but you can adjust your CSV to avoid them if you prefer.

How to verify it worked

  • Re-import after fixing the CSV.
  • The summary should show fewer or no skipped rows.
  • All intended stores appear under Stores.

Common issues and fixes

IssueFix
”Missing required field(s): name”Add a name column or ensure every row has a store name.
”Missing required field(s): address”Add an address column or ensure every row has a full address.
Row numbers don’t match my sheetRow 1 is usually the header. Count from the top; adjust if your tool uses different numbering.
Column not recognizedUse standard names: name, address, phone, etc. See Preparing a CSV file for store import.
Rows fail with processing errorsCheck the affected rows for broken quotes, extra separators, or invalid characters, then export the file as CSV again.
Skipped rows keep repeatingRecheck the exact row numbers from the latest import summary and validate those same rows again.