+ Full Online Supermarket System

PROJECT NAME: Amkeni Traders – Full Online Supermarket System (Mombasa) -------------------------------------------------- OBJECTIVE: Build a complete production-ready commerce platform including: - Customer shopping app (frontend) - Full backend system (database + APIs) - Admin dashboard (fully functional) - Preloaded inventory system - WhatsApp + M-Pesa integration IMPORTANT: This must NOT be UI-only. It must be a fully working business system. -------------------------------------------------- BRAND IDENTITY: Name: Amkeni Traders Colors: - Primary: #0B8F3A (Green) - Secondary: #FFA500 (Orange) - Accent: #06682A - Background: #F7F7F7 / #FFFFFF Style: - Clean - Mobile-first - Fast ordering focused - High trust UI Logo: - Simple shopping cart icon + text "Amkeni Traders" - Green primary, orange highlights -------------------------------------------------- DATABASE (MANDATORY - FULL RELATIONAL SYSTEM) TABLE: users - id - name - phone (unique) - role (customer/admin) - created_at TABLE: addresses - id - user_id - address_line - area - notes - is_default TABLE: categories - id - name TABLE: suppliers - id - name - phone - location TABLE: products - id - name - category_id - price_retail - price_wholesale - stock_quantity - image_url - supplier_id - is_active TABLE: orders - id - user_id - address_id - total_amount - delivery_fee - final_amount - payment_method (mpesa / cod) - status (received / preparing / out_for_delivery / delivered) - created_at TABLE: order_items - id - order_id - product_id - quantity - price_at_time IMPORTANT: - All data must persist after refresh - Full CRUD required for all tables -------------------------------------------------- NAVIGATION SYSTEM (CRITICAL FIX) Implement proper routing: Back button logic: IF history exists → go back ELSE → go to homepage (/) Must work across: - product page - cart - checkout - categories - admin pages -------------------------------------------------- CUSTOMER APP (FRONTEND) HOMEPAGE: - Header: "Amkeni Traders" centered, large - Cart icon top right HERO: - "Fast Grocery Delivery in Mombasa – Same Day" - Trust points: - Pay on Delivery - Delivered in Hours - Best Prices - CTA: Start Order Now SECTIONS: - Popular Items (horizontal scroll carousel) - Bundles (horizontal scroll) - Repeat Orders - Categories grid: Snacks, Drinks, Groceries, Cleaning, Baby GLOBAL: - Floating WhatsApp button -------------------------------------------------- PRODUCT PAGE: - Image - Name - Price - Discount badge - Stock indicator - Add to cart button - Frequently bought together (carousel) - WhatsApp order button -------------------------------------------------- CART: - Editable items - Quantity adjust - Summary (subtotal, delivery, discount, total) - Upsell suggestions - Delivery time estimate (2–4 hrs) - Buttons: - Checkout - WhatsApp Order -------------------------------------------------- CHECKOUT: - One-page checkout - Fields: - Name - Phone - Address - Delivery: - Same day / scheduled - Payment: - M-Pesa (default) - Cash on Delivery - Confirm Order button - WhatsApp confirmation option -------------------------------------------------- ORDER FLOW: - Confirmation page - Tracking status: - Received - Out for delivery - Delivered -------------------------------------------------- ADMIN DASHBOARD (FULL FUNCTIONALITY REQUIRED) Route: /admin PRODUCTS: - Add product - Edit product - Delete product - Assign category + supplier - Set retail + wholesale price ORDERS: - View all orders - Update order status - View customer details SUPPLIERS: - Add suppliers - Assign products ANALYTICS: - Revenue - Top selling products - Order count IMPORTANT: All changes must persist in database. -------------------------------------------------- INVENTORY (PRELOAD DATA FROM FMCG SUPPLIER MODEL) Populate system with starter products: CATEGORY: SNACKS - Bugles Corn Snacks (Chilli, BBQ, Original) - Alpenliebe Candy (Caramel, Eclairs) - Bazooka Gum & Lollipops - Biscuits (Marie, Crackers) - Cakes (ANI Star Cake) CATEGORY: DRINKS - Acacia Fruit Drinks (Apple, Mango, Strawberry) - Carbonated drinks - Juice packs - Soft drink bulk packs CATEGORY: GROCERIES - Ajab Maize Flour - Ajab Baking Flour - Rice - Pasta - Sugar sachets - Semolina CATEGORY: SPREADS & CONDIMENTS - Honey - Peanut butter - Pickles (Branston) - Cooking sauces - Spices CATEGORY: HOUSEHOLD - Mops - Cleaning agents - Metal polish - Laundry products -------------------------------------------------- CORE FEATURES: - WhatsApp ordering integration (global button) - Repeat last order - Bundle pricing system - Multi-supplier product sourcing - Mobile-first UI -------------------------------------------------- PERFORMANCE REQUIREMENTS: - Fast loading - Minimal clicks (max 3 steps to checkout) - Optimized for mobile users - Smooth UI interactions -------------------------------------------------- ACCEPTANCE TEST (MUST PASS): NAVIGATION: - Back button works everywhere ADMIN: - Add product → refresh → still exists - Edit product → updates correctly - Orders visible and editable ORDER FLOW: - Place order → saved in DB - Status updates work -------------------------------------------------- FINAL GOAL: Build a fully functional, scalable commerce system for Amkeni Traders that can immediately be used for real sales in Mombasa. NOT a prototype. NOT a UI mockup. A working business system. Sample site:https://amkeni-trade-flow.base44.app https://amkeni-trade-flow.base44.app/home