CSV import skipped rows, mapped columns wrong, or changed the wrong items
CSV import previews column mapping and supports Merge versus Replace; Merge matches by normalized section + item name.
What you may be seeing
- Import preview skips rows, merges duplicates, or the result is not what the spreadsheet author expected.
What usually causes it
- Item-name column is not mapped.
- Header detection/mapping is wrong for the file.
- Rows do not contain usable names/prices.
- Duplicate section+name rows collapse with the last value winning.
- Replace was chosen when Merge was intended.
Do this
- Choose the CSV and inspect the preview before importing.
- Confirm whether the first row is a header and map the columns explicitly; an Item name mapping is required.
- Read the skipped-row/duplicate summary in the preview and fix the source data or mapping if needed.
- Choose Merge to update matched section+item names while preserving sold-out flags/bindings and creating new items.
- Choose Replace only when you intentionally want to wipe the existing menu and rebuild it from the import.
You know it is fixed when
- The preview count/mapping matches expectations and the resulting menu contains the expected updated/created items.
Search phrases this guide covers
CSV import broken · rows skipped · duplicate items · merge vs replace · wrong CSV columns · wipe menu
