⚠️ Nuclear Delete - All Testimonials

IMPORTANT: Client-side deletion is blocked by Row Level Security (RLS). You must use SQL to delete testimonials directly in Supabase.

⚠️ Why Client-Side Deletion Doesn't Work

Your Supabase RLS policies only allow anon (anonymous) users to read testimonials, but not to delete them. Only authenticated users can delete, but the admin tools use the anon key.

Solution: Run SQL directly in Supabase SQL Editor (bypasses RLS).

Steps to Delete Testimonials:

  1. Open Supabase Dashboard → Go to your project
  2. Click "SQL Editor" in the left sidebar
  3. Copy the SQL below and paste it into the editor
  4. Click "Run" to execute
  5. Refresh your website (Ctrl+Shift+R)

SQL to Delete ALL Testimonials:

-- Delete ALL testimonials
DELETE FROM testimonials;

-- Verify deletion
SELECT COUNT(*) as remaining_testimonials FROM testimonials;

Alternative: Delete Only Sample Testimonials

-- Delete only sample testimonials
DELETE FROM testimonials
WHERE customer_name IN (
    'Marie Dubois',
    'James Thompson',
    'Sophie Laurent',
    'David Chen',
    'Emma Wilson'
);

-- Verify deletion
SELECT COUNT(*) as remaining_testimonials FROM testimonials;

After Running SQL:

  1. Hard refresh your browser: Ctrl + Shift + R
  2. Check View All Testimonials to verify
  3. Import your real reviews using Import Your Reviews
📋 View All Testimonials (Check Before/After)