Data types
Import and export customers
Customer columns, how customers are matched, and what's read-only.
Last updated
Columns
One row per customer: ID, Email, First Name, Last Name, Phone, Note, Tags, Tax Exempt, and the default address: Company, Address 1, Address 2, City, Province Code, Country Code, Zip and Address Phone. Shopify's customer CSV headers work too.
Read-only, exported for reference: Email Marketing, SMS Marketing, Orders Count, Amount Spent, Created At and Updated At.
Matching and checks
- Customers are matched by ID, then Email. Rows that match nothing create a customer (in Create and update or Create only mode).
- Phone numbers need a country code, for example +351 912 345 678.
- Country names such as “Portugal” become codes (PT) automatically.
- Customers with orders can't be deleted.
Marketing consent
Export filters
Filter customers by tag and by created date.
Related guides
- Column reference: the Bulkvane file formatEvery column Bulkvane exports and imports for products, metafields, inventory, customers and collections.
- Import modes: create, update, replace or deleteWhat each of the five import modes does, and when to use it.
- Export and import several data types in one fileOne Excel file with a sheet per data type, exported together and imported as one job per sheet.
- Errors A–ZEvery message Bulkvane shows during an import, what it means, and how to fix it.