GuidesAdminMenu Management

Menu Management

Admin users can manage the full menu through MenuManagementView, including adding, editing, and deleting items and ingredients.

Access

Available only to users with role = 'admin'.

Modes

Items Mode

Manage menu items:

  • View all items with category filter chips
  • Toggle availability (same as employee)
  • Add new items: Name, description, price, category, featured flag
  • Edit items: Update any field
  • Delete items: Remove from menu

Ingredients Mode

Manage modifiers (ingredients):

  • View all modifiers grouped by modifier group
  • Toggle availability (same as employee)
  • Add new modifiers: Name, price adjustment, group, default flag
  • Edit modifiers: Update any field
  • Delete modifiers: Remove from modifier group

Category Filters

Items can be filtered by category:

  • All
  • Coffee
  • Tea
  • Food

Database Operations

Adding Items

INSERT INTO menu_items (category_id, name, description, base_price, is_featured, is_available)
VALUES ('category-uuid', 'Mocha', 'Espresso with chocolate', 545, true, true);

Adding Modifiers

INSERT INTO modifiers (group_id, name, price_adjustment, is_default, is_available)
VALUES ('group-uuid', 'Hazelnut Syrup', 60, false, true);

Linking Items to Modifier Groups

INSERT INTO item_modifier_groups (menu_item_id, modifier_group_id)
VALUES ('item-uuid', 'group-uuid');

Pricing

All prices are stored in cents (integer):

  • $4.95 → 495
  • $0.80 → 80
  • $1.00 → 100

This avoids floating-point precision issues in financial calculations.

AnalyticsEmployee Performance