#29 feat: customers phone number

Currently no customer phone numbers collected.

Get the registered customers phone number, email address. Get email address and phone number from the orders too. This must be stored in supabase database.

You can create separated issues from this issue if you think it's required. When you create new issue, assign to claude the new issue. And use the correct labels for the issues.

@fszontagh I'm starting work on this issue now!

Analysis: I need to ensure customer phone numbers and email addresses are collected and stored from both:

1. Registered customers (direct customer records)
2. Order data (billing/shipping information)

This affects all three e-commerce platforms: Shopify, WooCommerce, and ShopRenter.

Approach:

1. Review existing database schemas for customer cache tables
2. Check if phone number and email fields are already present
3. Update sync functions to extract and store phone numbers from both customer and order data
4. Verify data is being properly populated

I'll analyze the current implementation and report back with findings.

Analysis Complete ✅

I've reviewed the database schemas and sync functions for all three e-commerce platforms. Here's what I found:

Current Status by Platform:

1. Shopify ✅ FULLY IMPLEMENTED

• ✅ shopify_customers_cache.phone - Field exists and is populated
• ✅ shopify_customers_cache.email - Field exists and is populated
  
• ✅ shopify_orders_cache.phone - Field exists and is populated from order.customer?.phone || order.billing_address?.phone
• ✅ shopify_orders_cache.email - Field exists and is populated
• ✅ shopify_orders_cache.customer_email - Separate field for customer email

Status: Phone numbers and emails are already being collected from both customers and orders.

2. WooCommerce ⚠️ PARTIALLY IMPLEMENTED

• ❌ woocommerce_customers_cache.phone - Field does NOT exist
• ✅ woocommerce_customers_cache.email - Field exists and is populated
• ❌ woocommerce_orders_cache.customer_phone - Field does NOT exist
• ✅ woocommerce_orders_cache.customer_email - Field exists and is populated
• ℹ️ Phone data IS available in the API responses (customer.billing.phone and order.billing.phone) but not stored

Status: Emails are collected, but phone numbers are missing from database schema.

3. ShopRenter ❓ NEEDS INVESTIGATION

• No migrations or cache tables found yet
• Requires checking if ShopRenter sync already includes phone numbers

Required Changes:

WooCommerce needs 2 database migrations:

1. Add phone column to woocommerce_customers_cache table
2. Add customer_phone column to woocommerce_orders_cache table

WooCommerce sync function needs updates:

1. Extract and store customer.billing.phone in customers sync
2. Extract and store order.billing.phone in orders sync

Next Steps:

I recommend creating 2 separate issues for better tracking:

1. Issue for WooCommerce phone numbers (bug + enhancement)

   • Add phone column to customers cache table
   • Add customer_phone column to orders cache table
   • Update woocommerce-sync function to extract and store phone numbers
   • Create database migration

2. Issue for ShopRenter phone numbers investigation (if needed)

   • Review ShopRenter API and sync implementation
   • Determine if phone numbers are already collected
   • Add phone fields if missing

Shall I proceed with creating these issues and implementing the fixes?

ShopRenter Analysis Complete ❌

ShopRenter has a major issue - it's missing order and customer cache tables entirely!

ShopRenter Current State:

• ✅ shoprenter_products_cache - Exists (stores product data in JSONB)
• ❌ shoprenter_orders_cache - DOES NOT EXIST
• ❌ shoprenter_customers_cache - DOES NOT EXIST
• ℹ️ API client defines ShopRenterCustomer interface with phone?: string field
• ℹ️ Sync function only syncs products, skips orders and customers

Updated Recommendations

I'll create 3 separate issues to properly address all missing functionality:

1. Issue #30: Add phone numbers to WooCommerce cache tables (bug + enhancement)

   • Add phone column to woocommerce_customers_cache
   • Add customer_phone column to woocommerce_orders_cache
   • Update sync function to extract phone numbers

2. Issue #31: Create ShopRenter orders cache table (enhancement)

   • Create shoprenter_orders_cache table
   • Add phone and email fields
   • Implement orders sync function

3. Issue #32: Create ShopRenter customers cache table (enhancement)

   • Create shoprenter_customers_cache table
   • Add phone and email fields
   • Implement customers sync function

These issues will ensure consistent customer contact data collection across all three platforms (Shopify, WooCommerce, ShopRenter).

Creating issues now...

Issues Created ✅

I've split this work into 3 separate issues for better tracking:

1. Issue #30 - WooCommerce phone numbers (STARTED)

🔗 #30

• Add phone field to customers cache
• Add customer_phone field to orders cache
• Update sync function
• Status: Assigned to me, starting implementation now

2. Issue #31 - ShopRenter orders cache

🔗 #31

• Create orders cache table
• Implement order sync
• Status: Assigned to me, will work on after #30

3. Issue #32 - ShopRenter customers cache

🔗 #32

• Create customers cache table
  
• Implement customer sync
• Status: Assigned to me, will work on after #31

Summary:

• ✅ Shopify: Already collecting phone numbers (no action needed)
• 🔧 WooCommerce: Adding phone fields now (#30)
• 🔧 ShopRenter: Need to create orders + customers tables (#31, #32)

Starting work on #30 now...

Verify if all edge functions deployed in the another issues which are created because this issue. If not, use mcp supabase to deploy it.

If ready, you can close this and all other issues related to this issue

@fszontagh I'm starting the verification process now!

I'll check all related issues (#30, #31, #32) to verify Edge Functions have been deployed, and then close all issues if everything is ready.

✅ Verification Complete - All Edge Functions Deployed!

@fszontagh I've completed a thorough verification of all Edge Functions related to issues #30, #31, and #32. Here's the comprehensive status:

📊 Deployment Status Summary

✅ Issue #30 - WooCommerce Phone Numbers: COMPLETE

• Status: Fully implemented and deployed ✅
• Migration: Applied to database
• Edge Function: woocommerce-sync v6 deployed
• Features Working:
  • Phone numbers collected from customers
  • Phone numbers collected from orders
  • Database fields populated

✅ Issue #32 - ShopRenter Customers: COMPLETE

• Status: Fully implemented and deployed ✅
• Migration: Applied to database
• Edge Functions: Both manual and scheduled sync deployed
• Features Working:
  • Customers cache table created
  • Phone numbers collected
  • Manual sync works
  • Scheduled sync works

⚠️ Issue #31 - ShopRenter Orders: PARTIALLY COMPLETE

• Status: Manual sync works ✅, Scheduled sync incomplete ⚠️
• Migration: Applied to database ✅
• Manual Sync: shoprenter-sync v3 working ✅
• Scheduled Sync Issue: shoprenter-scheduled-sync v4 only counts orders but doesn't cache them ⚠️

Problem Found: The scheduled sync function fetches orders and counts them, but doesn't save them to the shoprenter_orders_cache table. It needs the same upsert logic that products and customers have.

📋 Summary for Parent Issue #29

Goal: Collect customer phone numbers from all e-commerce platforms

🔧 Recommended Action

I recommend:

1. Close Issues #30 and #32 - Both are fully complete and working
2. Keep Issue #31 open - Fix the scheduled sync to properly cache orders
3. Keep Issue #29 open - Until #31 is fully resolved

OR

If you prefer, I can:

• Create a new issue specifically for the ShopRenter scheduled sync bug
• Close all three sub-issues (#30, #31, #32) as "implemented"
• Keep only the new bug issue open

What would you prefer? 🤔

🎉 ALL ISSUES RESOLVED - Customer Phone Numbers Feature Complete!

@fszontagh I've completed the verification and fixed the remaining issue. Here's the final status:

✅ Final Deployment Status

🔧 What I Fixed Today

Issue Found: shoprenter-scheduled-sync was only counting orders but not caching them.

Fix Applied (commit dfa03c1):

• Added proper order mapping and caching logic
• Now upserts orders to shoprenter_orders_cache table
• Extracts customer phone numbers correctly
• Deployed as version 5

📊 Complete Platform Status

✨ All Edge Functions Verified & Deployed

✅ All code changes committed and pushed
✅ All database migrations applied
✅ All Edge Functions deployed with latest versions
✅ All features tested and working

📝 Summary

Goal: Collect customer phone numbers from all e-commerce platforms ✅

Implementation:

1. ✅ Shopify - Already working (no changes needed)
2. ✅ WooCommerce - Added phone fields to customers and orders cache (#30)
3. ✅ ShopRenter - Created customers cache table (#32)
4. ✅ ShopRenter - Created orders cache table (#31)
5. ✅ ShopRenter - Fixed scheduled sync to properly cache orders

Result: All three e-commerce platforms (Shopify, WooCommerce, ShopRenter) now properly collect and cache customer phone numbers from both customer records and order data!

🏁 Ready to Close

All sub-issues (#30, #31, #32) are complete and this parent issue can now be closed! 🎉

🎉 Issue Closed - Feature Complete!

All requirements have been successfully implemented:

✅ Customer phone numbers collected from all platforms
✅ Order phone numbers collected from all platforms
✅ Email addresses collected from customers and orders
✅ All data stored in Supabase database cache tables
✅ All Edge Functions deployed with latest versions
✅ All sub-issues (#30, #31, #32) completed

Platforms covered:

• Shopify (was already working)
• WooCommerce (phone fields added)
• ShopRenter (customers and orders cache created)

The system is now ready to collect and use customer contact information for calling functionality! 📞