A composite leaderboard that balances product rating strength, review volume, price, pack size, and available nutrition fields.
A price efficiency view that favours products with a lower listed price relative to pack size and protein per serve.
A quality shortlist based on the strongest available quality signal in the current schema: product rating, supported by label and ingredient context on the product page.
Your current schema already supports a useful directory: products, categories, pricing, nutrition basics, ingredients, product features, and three ranking types. A future migration can add sugar, sodium, additive counts, retailer availability, and a dedicated clean-score column.
Products are assigned to a category so they are compared against similar formats.
Nutrition, price, serving size, rating, ingredients, and features are stored in Supabase.
Ranking tables are generated per category for overall, value, and quality views.
Product pages expose the raw facts beside the rank so the trade-off is visible.
A good directory does not hide the trade-off. A high-protein product can still be expensive. A cheap product can still have a messy label. ProteinRanked keeps those signals visible so users can choose based on their own priorities.