#27 Actualize CLAUDE.md

Actualize the current CLAUDE.md file to the current status of the project. See old issues and current source codes (supabase functions, tables, source files) with for the correct implementations. For example, the oatuh is no more used in this project for authenticating woocommerce webshops.

@fszontagh I'm starting work on this issue now! I'll review the current CLAUDE.md file, examine the actual implementation in the codebase (especially Supabase functions, database tables, and authentication flows), and update the documentation to reflect the current state of the project. I'll pay special attention to the WooCommerce authentication implementation since you mentioned OAuth is no longer used for it.

✅ Issue #27 Completed

@fszontagh I've successfully actualized the CLAUDE.md file to reflect the current project status. Here's what was updated:

Major Corrections

1. WooCommerce Authentication ✨

The biggest correction as you mentioned:

• Changed: Removed references to OAuth flow for WooCommerce
• Clarified: WooCommerce uses manual API key authentication (Consumer Key + Consumer Secret)
• The oauth-woocommerce Edge Function only handles the connect_manual action
• OAuth 1.0a signatures are used for API requests, not for the authentication flow itself
• Added connection validation that tests credentials before storing

2. Database Schema Updates 📊

• Updated stores table with complete field list including new sync status fields (sync_status, sync_started_at, sync_completed_at, sync_error)
• Added missing tables:
  • oauth_nonces (OAuth nonce management)
  • pending_signups (email verification flow)
  • profiles (user profile information)
  • system_config (system-wide configuration)
  • call_logs (call history and analytics)
  • shoprenter_tokens (ShopRenter token management)
  • shoprenter_webhooks (ShopRenter webhook registrations)
• Corrected shoprenter_products_cache structure (uses product_data jsonb field)
• Updated oauth_states table with complete field list

3. E-commerce Platform Details 🛒

• Shopify: Added API version (2024-01), noted that scheduled sync is prepared but Edge Function not yet deployed
• WooCommerce: Added scheduled sync details (runs hourly at minute 5)
• ShopRenter: Added token refresh functionality, scheduled sync runs hourly at minute 0

4. Background Sync Section 🔄

• Expanded section to cover all three platforms comprehensively
• Added trigger function names for each platform
• Added migration file references
• Clarified sync timing to avoid overlaps between platforms

What Was Reviewed

I analyzed the following to ensure accuracy:

• ✅ All Supabase Edge Functions (supabase/functions/*/index.ts)
• ✅ Database schema from Supabase (via MCP tools)
• ✅ Migration files (supabase/migrations/*.sql)
• ✅ API client implementations (_shared/*-client.ts)
• ✅ WooCommerce authentication implementation (manual API key flow)
• ✅ Shopify authentication and GDPR compliance
• ✅ ShopRenter OAuth flow and token management

Commit Details

📝 Commit: 0c7cc3f 🔗 Changes pushed to main branch

The documentation now accurately reflects the current state of the project and should serve as a reliable reference for future development.

Let me know if you need any additional clarifications or adjustments! 🚀