SMS Consent on import from Woo
If I read the code and DB structure right, every imported customer from Woo will be silently set to have given SMS consent and the billing phone pulled in.
ALTER TABLE ... ADD sms_status VARCHAR(50) NULL DEFAULT 'sms_subscribed'
This seems problematic as we have an extensive customer base going back many years, none of whom have given SMS consent.
Secondly, I'm not seeing any settings for obtaining SMS consent. There's a newsletter signup for email at Woo checkout, but no SMS consent checkbox.
Is there any guidance on why SMS consent is silently assumed, and what is best practice to distinguish between email and SMS consent?
I've passed this on to the developers.
I'm also not finding any sync between billing_phone and FluentCRM when the phone number is updated in My Account. The other address fields are synced. This looks like a bug.
Plugin: FluentCRM (Free) v3.1.7
File: wp-content/plugins/fluent-crm/app/Hooks/Handlers/AutoSubscribeHandler.php
Function: syncWooAddressUpdate(), lines 312–351
$addressData = $customer->get_billing(); $updateData = [ 'user_id' => $userId, 'address_line_1' => $addressData['address_1'], 'address_line_2' => $addressData['address_2'], 'city' => $addressData['city'], 'state' => $addressData['state'], 'country' => $addressData['country'], 'postal_code' => $addressData['postcode'] ];
This means that the phone number remains stale.
Suggested fix: add 'phone' => $addressData['phone'], to the $updateData array at line 329.