'''Do not make any visual modifications. The phrases I write are commands to understand what I want, not to be written down. Understand their content well, then execute what is required.'''
Please fix the production categories API error.
Current error in Chrome DevTools / Supabase logs:
GET /rest/v1/categories → 401
Postgres error: 42501
permission denied for table categories
This is happening on the public storefront.
IMPORTANT:
- Do NOT disable RLS.
- Do NOT use the service_role key in the frontend.
- Do NOT expose any secret/service key to the browser.
- Do NOT change the database structure.
- Do NOT delete existing RLS policies.
- Do NOT break the existing category_translations system.
- Do NOT break English/French/German language switching.
- Do NOT change the website design.
- Do NOT change product functionality.
- Do NOT change admin permissions.
Please inspect the existing `categories` table RLS policies and the frontend query that reads categories.
The public storefront needs permission to SELECT/read the category data required to display:
- Categories menu
- Category listing
- Product category filters
- Category pages
- Category translations/localized names
Keep INSERT, UPDATE and DELETE protected so only authorized admin users can modify categories.
Also inspect `category_translations` because the storefront uses localized category names. Make sure the public/anonymous user can safely SELECT the required translation rows.
Important:
Create only the minimum necessary SELECT policies.
Do not create duplicate policies if an appropriate policy already exists.
Do not make the tables publicly writable.
After making the fix:
1. Test the actual production website.
2. Verify `GET /rest/v1/categories` returns HTTP 200 instead of 401.
3. Verify category names display correctly.
4. Verify English/French/German switching still works.
5. Verify category filtering still works.
6. Verify admin users can still create/edit/delete categories according to their existing permissions.
7. Check Supabase logs and confirm the `42501 permission denied for table categories` error is gone.
Before finishing, tell me:
- Which RLS policy/policies were missing or incorrect.
- What exact policy was added/modified.
- Which tables were affected.
- Confirm that RLS remains enabled.
- Confirm that no service_role key was exposed.

Wholesale food distribution
Quality groceries, sourced for professionals.
Discover hundreds of authentic products at wholesale prices. Fast delivery across Europe, dedicated account support.
Fast delivery
Orders shipped within 48h across France & Europe.
Quality sourcing
Direct partnerships with trusted producers.
Wholesale pricing
Volume discounts for retailers & professionals.
Dedicated support
A real human on the phone, every business day.
Shop by category
Curated selections from pantry staples to specialty goods.
Featured products
Bestsellers chosen by our buyers this season.
Testimonials
Trusted by retailers across Europe
What our wholesale partners say about working with us.
Fast shipping, fair prices and the catalogue is always up to date. Verodav has become our go-to wholesale supplier.
S
Sophie M.
Independent retailer
The quality is consistent and customer service responds within hours. My shelves stay stocked without any stress.
K
Karim B.
Boutique owner
Smooth ordering, clean packaging, and great margins. Highly recommended for any reseller starting out.
É
Élodie R.
Reseller
We've worked with several wholesalers — Verodav is by far the most reliable. The team really cares.
M
Marc L.
Grocery shop
Wide selection and competitive pricing. Our customers love the products we source from them.
N
Nadia T.
Independent retailer
Newsletter
Get our weekly catalogue
Weekly catalogue, new arrivals & wholesale offers.








