Guests’ phone is not stored

  • Resolved alexrossth

    (@alexrossth)


    5 months ago

    Hi.

    I’m straggling with capturing guests’ phone numbers. I get First name, Last name, Email, shipping info if provided. But the phone is not even stored in DB. I can see no phone in plugin’s dashboard. Moreover, “phone” field in DB for guest users contains “NULL”.

    I didn’t modified the checkout, the phone field is “billing_phone” as by default.

Viewing 1 replies (of 1 total)
  • Thread Starter alexrossth

    (@alexrossth)

    5 months ago

    Thank you, plugin support!

    So, to fix the issue you need to edit includes/class-wcal-guest-ac.php line 281.

    Was:

    'INSERT INTO ' . $wpdb->prefix . 'ac_guest_abandoned_cart_history_lite( billing_first_name, billing_last_name, email_id, billing_zipcode, shipping_zipcode, shipping_charges ) VALUES ( %s, %s, %s, %s, %s, %s )'

    Should be:

    'INSERT INTO ' . $wpdb->prefix . 'ac_guest_abandoned_cart_history_lite( billing_first_name, billing_last_name, email_id, phone, billing_zipcode, shipping_zipcode, shipping_charges ) VALUES ( %s, %s, %s, %s, %s, %s, %s )',

    • This reply was modified 5 months ago by alexrossth.
Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.