Workflow guide
Shopify Customer CSV Import Cleanup
Map customer columns, normalize emails, find duplicates, validate consent fields and export a cleaner Shopify customer CSV.
Clean customer CSV rows before import so invalid emails, duplicate customers, and consent fields are visible first.
Quick checklist
- 1Map customer fields before cleaning rows if the source file is not Shopify-shaped.
- 2Normalize emails, names, phones, and explicit consent values.
- 3Download both the clean customer CSV and the issue report before import.
Who this workflow is for
Shopify merchants, CRM operators, email list owners, migration assistants, and VAs moving customer lists into Shopify.
Input files you need
- Customer CSV from an old store, CRM, email tool, spreadsheet, or Shopify export
- Optional source fields for phone, first name, last name, email consent, and SMS consent
Output files and reports
- Clean Shopify customer CSV
- Customer import issue report
- Mapped customer CSV when source headers need conversion
Run the workflow
- 1Paste the source customer CSV into the header mapper if the fields are not Shopify-shaped.Open Shopify CSV Header Mapper
- 2Confirm customer field mappings in the customer import cleaner.Open Shopify Customer CSV Import Cleaner
- 3Run the cleaner and review invalid emails, duplicates, and consent warnings.
- 4Download the clean CSV and issue report before importing manually in Shopify.
Checks performed
- Email column mapping and basic email validity
- Duplicate email and duplicate phone rows
- Consent values normalized from yes/no, true/false, 1/0, or y/n
- Blank consent fields that should be reviewed before import
Limits and boundaries
- Does not infer consent where the source file does not contain explicit consent data.
- Does not import customers into Shopify.
- Does not migrate passwords, order history, or account states.