WooCommerce
Pipedrive Contacts4 fieldsHow to import WooCommerce data into Pipedrive
Move your WooCommerce customers into Pipedrive. This template combines first_name and last_name into Pipedrive's single Name field, then maps email, phone, and billing_company to a Pipedrive organization. Pipedrive uses a leaner contact model than WooCommerce's customer export, so the address block and ecommerce columns don't have a Pipedrive home. The section below explains what to do with each one if you need it.
Field-by-field mapping
This is the complete column mapping from WooCommerce to Pipedrive. The left column is the header in your CSV export. The right column is the Pipedrive field it should map to.
| WooCommerce column | Pipedrive field | |
|---|---|---|
| first_name + last_name | Name*name Pipedrive uses a single Name field on the contact, so we combine the two WooCommerce columns into one. Transformfirst_name and last_name combined with a space | |
| Emailemail TransformLowercased and trimmed | ||
| billing_phone | Phonephone TransformStandardized to international format (+1, +44, etc.) | |
| billing_company | Organizationorg_name Matched to an existing Pipedrive organization, or a new one is created. |
Required by Pipedrive.
Columns we don't use
Your WooCommerce export includes 12 columns this template doesn't map. Each one below explains why, plus the workaround if you want the data in Pipedrive.
- billing_address_1, billing_city, billing_state, billing_postcode, billing_country
Pipedrive contacts don't store address fields by default. Addresses live on organizations in Pipedrive's data model.
If you need it. If you need the address on the contact, add custom address fields in Pipedrive and re-run this template. Otherwise associate the contact with a Pipedrive organization that holds the address.
- shipping_address_1, shipping_city, shipping_state, shipping_postcode, shipping_country
WooCommerce exports a full shipping address block alongside the billing block. Pipedrive contacts don't have a default home for either address block.
If you need it. Add custom address fields on the Pipedrive organization, or skip shipping data and rely on billing address only.
- order_count
WooCommerce records how many orders each customer has placed. Pipedrive contacts don't have a default order-count field.
If you need it. Add a custom number field on the Pipedrive contact called Order Count, then re-run this template to map it. Or track this on a Deal in Pipedrive instead.
- total_spent
WooCommerce records lifetime spend per customer. Pipedrive contacts don't have a default lifetime-value field.
If you need it. Add a custom monetary field on the Pipedrive contact called Total Spent, then re-run this template to map it. Or track lifetime value on Deals in Pipedrive instead.
Formatting and cleanup
WooCommerce exports rarely match the format Pipedrive expects. Fix these before you import.
- 1.Combines first_name and last_name into Pipedrive's single Name field
- 2.Lowercases and trims email addresses
- 3.Standardizes phone numbers to international format (+1, +44, etc.)
- 4.Matches billing_company to an existing Pipedrive organization, or creates a new one
Or skip the manual work
Operelio runs this cleanup and mapping for you. Upload your WooCommerce export and download a clean, import-ready file for Pipedrive.
WooCommerce to Pipedrive FAQ
How do I export customers from WooCommerce?
In your WordPress admin, go to WooCommerce > Customers, then click the Download button at the top-right of the page to export to CSV. You can also use WooCommerce > Reports > Customers for the legacy export view.
Why do you combine first_name and last_name?
Pipedrive contacts use a single Name field, not separate first/last. The template combines the two WooCommerce columns with a space so each contact record displays correctly.
How is billing_company handled?
Billing company names match against existing Pipedrive organizations. If no match exists, the template creates a new organization and links the contact to it. Customers without a billing_company become contacts not linked to any organization.
What about WooCommerce order data?
Order count and lifetime spend appear in the export but don't have default Pipedrive contact fields. See 'Columns we don't use' below for the custom-field workaround.
Will this create duplicate contacts in Pipedrive?
Pipedrive's import dedupes on Name plus one of email, phone, or organization. A WooCommerce customer matches an existing Pipedrive contact when the name and either email or organization align. Customers whose billing name differs from the existing Pipedrive contact create a new contact even when the email matches.
