Shopify
Copper People10 fieldsHow to import Shopify data into Copper
Import your Shopify customers into Copper. The template combines First Name and Last Name into Copper's single name field, then maps email, phone, company, the per-customer Note column, and the billing address block to Copper's snake_case fields. Copper calls contacts People.
Field-by-field mapping
This is the complete column mapping from Shopify to Copper. The left column is the header in your CSV export. The right column is the Copper field it should map to.
| Shopify column | Copper field | |
|---|---|---|
| First Name + Last Name | Name*name Copper uses a single name field on the People record, so we combine the two Shopify columns into one. TransformFirst Name and Last Name combined with a space | |
| Emailemail TransformLowercased and trimmed | ||
| Phone | Phone Numberphone_number TransformStandardized to international format (+1, +44, etc.) | |
| Company | Company Namecompany_name | |
| Address1 | Streetaddress_street | |
| City | Cityaddress_city | |
| Province | Stateaddress_state | |
| Zip | Postal Codeaddress_postal_code | |
| Country | Countryaddress_country | |
| Note | Detailsdetails Shopify's per-customer notes land in Copper's native Details field on the Person. The free text is preserved verbatim. |
Required by Copper.
Columns we don't use
Your Shopify export includes 4 columns this template doesn't map. Each one below explains why, plus the workaround if you want the data in Copper.
- Total Spent
Copper doesn't have a default lifetime-value field on People. Lifetime value is typically tracked through Opportunities in Copper's data model.
If you need it. Add a custom currency field on the Copper Person called Total Spent, then re-run this template to map it. Or attach a Note with the spend total to each Person.
- Total Orders
Copper doesn't have a default order-count field on People.
If you need it. Add a custom number field on the Copper Person called Total Orders, then re-run this template to map it.
- Tags
Shopify tags export as a comma-separated string. Copper uses its own Tags feature, which is applied after import.
If you need it. After import, apply Copper Tags matching your Shopify tag values using Copper's bulk-edit tools.
- Accepts Email Marketing
Copper doesn't have a built-in email-marketing opt-in flag on People.
If you need it. Filter rows where Accepts Email Marketing is 'no' before upload to avoid importing opted-out customers, or add a custom checkbox field on the Copper Person to track it.
Formatting and cleanup
Shopify exports rarely match the format Copper expects. Fix these before you import.
- 1.Combines First Name and Last Name into Copper's single name field
- 2.Lowercases and trims email addresses
- 3.Standardizes phone numbers to international format (+1, +44, etc.)
- 4.Maps Shopify's billing address block to Copper's address_* fields (Province to address_state, Zip to address_postal_code)
Or skip the manual work
Operelio runs this cleanup and mapping for you. Upload your Shopify export and download a clean, import-ready file for Copper.
Shopify to Copper FAQ
How do I export my Shopify customers?
In your Shopify admin, go to Customers, click Export, choose 'All customers', and select CSV format.
Why do you combine First Name and Last Name?
Copper People records use a single name field. The template combines the two Shopify columns with a space so each Person displays correctly.
What about Shopify tags and purchase data?
Tags, Total Spent, and Total Orders don't have default Copper fields. See 'Columns we don't use' below for the workarounds. Copper Tags handle tags, and custom fields handle the spend data.
What about unsubscribed Shopify customers?
Filter rows where Accepts Email Marketing is 'no' before upload to avoid importing customers who've opted out of marketing emails.
Will this create duplicate People in Copper?
Copper deduplicates People on email by default. Customers with matching emails update the existing record. New emails create new People.
