-- Monaco USA Portal 2026 - Fix Email Template Styling -- Update all email templates with proper text centering and styling -- ============================================ -- UPDATE DUES REMINDER TEMPLATES -- ============================================ -- 30 days before due reminder UPDATE public.email_templates SET body_html = '

Dear {{first_name}},

This is a friendly reminder that your Monaco USA membership dues will be due on {{due_date}}.

Payment Details:

Amount Due: {{amount}}

Due Date: {{due_date}}

Member ID: {{member_id}}

Bank Transfer Details:

Account Holder: {{account_holder}}

Bank: {{bank_name}}

IBAN: {{iban}}

Reference: {{member_id}}

You can also view your payment status and history in the member portal:

View My Account

Thank you for being a valued member of Monaco USA!

' WHERE template_key = 'dues_reminder_30'; -- 7 days before due reminder UPDATE public.email_templates SET body_html = '

Dear {{first_name}},

Your Monaco USA membership dues will be due in 7 days on {{due_date}}.

Payment Information:

Amount: {{amount}}

Due Date: {{due_date}}

Bank Transfer Details:

Account Holder: {{account_holder}}

Bank: {{bank_name}}

IBAN: {{iban}}

Reference: {{member_id}}

Pay Now

Questions? Contact us at contact@monacousa.org

' WHERE template_key = 'dues_reminder_7'; -- 1 day before due reminder UPDATE public.email_templates SET body_html = '

Dear {{first_name}},

Your Monaco USA membership dues are due tomorrow ({{due_date}}).

Payment Required:

Amount: {{amount}}

Bank Transfer Details:

Account Holder: {{account_holder}}

Bank: {{bank_name}}

IBAN: {{iban}}

Reference: {{member_id}}

To maintain your active membership status and continued access to member benefits, please ensure payment is made by the due date.

Pay Now

' WHERE template_key = 'dues_reminder_1'; -- Overdue notice UPDATE public.email_templates SET body_html = '

Dear {{first_name}},

Your Monaco USA membership dues are now {{days_overdue}} days overdue.

Overdue Payment:

Amount: {{amount}}

Original Due Date: {{due_date}}

Days Overdue: {{days_overdue}}

Grace Period: You have {{grace_days_remaining}} days remaining in your grace period. After this, your membership status will be changed to inactive.

Please remit payment as soon as possible to maintain your membership benefits.

Bank Transfer Details:

Account Holder: {{account_holder}}

Bank: {{bank_name}}

IBAN: {{iban}}

Reference: {{member_id}}

Pay Now

' WHERE template_key = 'dues_overdue'; -- Grace period warning UPDATE public.email_templates SET body_html = '

Dear {{first_name}},

Your grace period ends in {{grace_days_remaining}} days.

Your membership dues of {{amount}} were due on {{due_date}} and are now {{days_overdue}} days overdue.

If payment is not received by {{grace_end_date}}, your membership status will automatically change to INACTIVE and you will lose access to member benefits.

Please make your payment immediately to avoid interruption:

Bank Transfer Details:

Account Holder: {{account_holder}}

Bank: {{bank_name}}

IBAN: {{iban}}

Reference: {{member_id}}

Pay Now - Urgent

' WHERE template_key = 'dues_grace_warning'; -- Inactive notice UPDATE public.email_templates SET body_html = '

Dear {{first_name}},

Due to non-payment of membership dues, your Monaco USA membership has been marked as INACTIVE.

Status Change:

Previous Status: Active

New Status: Inactive

Outstanding Amount: {{amount}}

As an inactive member, you will no longer have access to:

To reactivate your membership, please pay your outstanding dues:

Bank Transfer Details:

Account Holder: {{account_holder}}

Bank: {{bank_name}}

IBAN: {{iban}}

Reference: {{member_id}}

Reactivate My Membership

If you believe this is an error or have questions, please contact us at contact@monacousa.org

' WHERE template_key = 'dues_inactive_notice'; -- ============================================ -- UPDATE EVENT REMINDER TEMPLATE -- ============================================ UPDATE public.email_templates SET body_html = '

Hi {{first_name}},

This is a friendly reminder that {{event_title}} is happening tomorrow!

Event Details:

Date: {{event_date}}

Time: {{event_time}}

Location: {{event_location}}

{{#if guest_count}}

You''re bringing {{guest_count}} guest(s)

{{/if}}

We look forward to seeing you there!

View Event Details

Can''t make it? Please update your RSVP so we can offer your spot to someone on the waitlist.

' WHERE template_key = 'event_reminder_24hr'; -- ============================================ -- UPDATE RSVP CONFIRMATION TEMPLATE (content-only version) -- ============================================ -- Note: The original is a full HTML template, so we'll create a content-only version -- that works with wrapInMonacoTemplate -- Update waitlist promotion to be content-only with proper styling UPDATE public.email_templates SET body_html = '

Dear {{first_name}},

Great news! A spot has opened up for {{event_title}} and you have been moved from the waitlist to confirmed!

Event Details

Date: {{event_date}}

Location: {{event_location}}

We look forward to seeing you there!

Best regards,
The Monaco USA Team

' WHERE template_key = 'waitlist_promotion';