To ensure the data types of your custom fields match between WooCommerce and Dotdigital, follow these steps:
1. Review WooCommerce custom field types:
- Text fields in WooCommerce typically correspond to Text type in Dotdigital
- Number fields in WooCommerce should map to Numeric type in Dotdigital
- Date fields should use the Date type in Dotdigital (using ISO 8601 format)
- Boolean fields can use the Yes/No type in Dotdigital[5]
2. Create matching custom data fields in Dotdigital:
- Go to Settings > Contacts > Contact data fields in Dotdigital
- Select the "Custom data fields" tab and click "NEW DATA FIELD"
- Choose the appropriate data type that corresponds to your WooCommerce field[5]
3. Map WooCommerce fields to Dotdigital:
- In Dotdigital, go to Connect and select the WooCommerce tile
- Select the "Field mapping" tab
- Under "Custom fields", map each WooCommerce custom field to the corresponding Dotdigital custom data field[2]
4. Pay attention to specific field types:
- Ensure date fields use the correct format (ISO 8601) in both systems
- For numeric fields, make sure the data in WooCommerce is actually numeric before mapping
5. Verify data sync:
- After mapping, allow a sync to occur
- Check a few sample contacts in Dotdigital to ensure the data has transferred correctly
6. Handle any mismatches:
- If you discover a mismatch, you may need to delete the custom field in Dotdigital and recreate it with the correct data type
- Then re-map the field and resync the data[5]
Remember, if the data types don't match, the sync may fail for that particular field[2]. It's crucial to set up the correct data types from the beginning to ensure smooth data transfer between WooCommerce and Dotdigital.
Citations:[1] https://support.dotdigital.com/en/articles/8199778-understanding-the-sync-process-from-woocommerce-to-dotdigital
[2] https://support.dotdigital.com/en/articles/8199779-map-woocommerce-customer-custom-fields-to-dotdigital-custom-data-fields
[3] https://support.dotdigital.com/en/articles/8199783-map-woocommerce-customer-data-to-dotdigital-contact-data-fields
[4] https://zapier.com/apps/dotdigital/integrations/woocommerce
[5] https://support.dotdigital.com/en/articles/8198833-create-delete-and-edit-custom-data-fields