-- ============================================================
-- Cafe Chiya Munch & Restaurant — Starter Menu
-- ============================================================
-- IMPORTANT — read this first:
-- I could not access your actual published prices (your digital menu
-- at meromenu.com/chiyamunch is a JavaScript app I can't read directly).
-- The CATEGORIES and ITEM NAMES below are grounded in real research on
-- your cafe (your own business description + reviews naming specific
-- items). The PRICES are realistic placeholder estimates for a Pokhara
-- cafe, NOT your real prices — you know those exactly since it's your
-- own business. Treat this as a fast starting skeleton to edit, not a
-- finished menu.
--
-- HOW TO USE:
-- Option A (fast): Import this directly via phpMyAdmin → SQL tab.
-- Option B (safer if unsure about your DB): Add these manually via
--   Menu → Categories, then Menu → Add Item in the POS admin UI,
--   using this file as your checklist/reference instead.
--
-- After importing, go to Menu → Add Item (or Edit) for each item and
-- correct the price to match what you actually charge.
-- ============================================================

-- Categories
INSERT INTO categories (name, created_at, updated_at) VALUES
('Chiya (Tea)', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('Coffee', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('Breakfast', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('Momo', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('Fast Food & Snacks', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('Salads', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('Bakery', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP),
('Juices & Cold Beverages', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);

-- Chiya (Tea)
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Masala Chiya', 40, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Chiya (Tea)';
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Milk Tea', 35, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Chiya (Tea)';
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Black Tea', 25, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Chiya (Tea)';
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Moringa Tea', 60, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Chiya (Tea)';
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Lemongrass Tea', 60, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Chiya (Tea)';
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Blue Pea Tea', 70, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Chiya (Tea)';
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Ginger Tea', 40, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Chiya (Tea)';
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Lemon Honey Ginger Tea', 55, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Chiya (Tea)';

-- Coffee
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Black Coffee', 80, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Coffee';
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Milk Coffee', 90, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Coffee';
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Cappuccino', 150, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Coffee';
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Cafe Latte', 150, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Coffee';
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Americano', 120, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Coffee';
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Cold Coffee', 160, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Coffee';

-- Breakfast
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Bread Omelette', 120, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Breakfast';
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Aloo Paratha with Curd', 150, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Breakfast';
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Sel Roti Set', 130, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Breakfast';
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'French Toast', 140, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Breakfast';
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Chiya Munch Healthy Breakfast Set', 220, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Breakfast';

-- Momo
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Veg Steamed Momo', 150, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Momo';
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Chicken Steamed Momo', 180, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Momo';
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Buff Momo', 170, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Momo';
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Fried Momo (Chicken)', 200, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Momo';
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Jhol Momo', 190, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Momo';

-- Fast Food & Snacks
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Veg Chowmein', 150, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Fast Food & Snacks';
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Chicken Chowmein', 190, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Fast Food & Snacks';
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Mini Pizza (Veg)', 220, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Fast Food & Snacks';
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Mini Pizza (Chicken)', 260, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Fast Food & Snacks';
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Veg Sandwich', 140, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Fast Food & Snacks';
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Spring Roll', 130, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Fast Food & Snacks';

-- Salads
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Fresh Garden Salad', 140, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Salads';
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Seasonal Fruit Salad', 160, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Salads';

-- Bakery
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Muffin', 90, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Bakery';
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Cookies (3 pcs)', 80, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Bakery';
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Cake Slice', 150, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Bakery';

-- Juices & Cold Beverages
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Fresh Fruit Juice (Seasonal)', 150, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Juices & Cold Beverages';
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Mango Shake', 180, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Juices & Cold Beverages';
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Lemon Soda', 100, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Juices & Cold Beverages';
INSERT INTO products (category_id, name, price, track_inventory, stock_qty, low_stock_threshold, is_active, created_at, updated_at)
SELECT id, 'Iced Tea', 110, 0, 0, 5, 1, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP FROM categories WHERE name = 'Juices & Cold Beverages';
