-- Insert sample data into categories table
INSERT INTO categories (name, description) VALUES
('Handicrafts', 'Traditional Nepali handicrafts'),
('Accessories', 'Nepali accessories and jewelry'),
('Art', 'Traditional Nepali and Tibetan art');

-- Insert sample data into products table
INSERT INTO products (name, description, price, quantity, category_id, image_path) VALUES
('Hand Embroidery', 'Traditional Nepali Handicraft', 49.99, 20, 1, 'images/products/Hand_embroidery.jpg'),
('Lung Ta', 'Symbolic Tibetan Prayer Flag', 29.99, 30, 1, 'images/products/Lung_ta.jpg'),
('Doko', 'Traditional Nepali Bamboo Basket', 39.99, 15, 1, 'images/products/Doko.jpg'),
('Khukuri', 'Iconic Nepali Gurkha Knife', 59.99, 10, 1, 'images/products/Khukuri.png'),
('Panche Baaja', 'Traditional Nepali Musical Instrument', 79.99, 5, 1, 'images/products/panche_baaja.jpg'),
('Dhaka Topi', 'Traditional Nepali Hat', 24.99, 25, 2, 'images/products/Dhaka_topi.jpg'),
('Dhaka Scarf', 'Exquisite Nepali Fabric', 34.99, 20, 2, 'images/products/Dhaka_scarf.jpg'),
('Handmade Necklace', 'Authentic Nepali Jewelry', 39.99, 15, 2, 'images/products/Handmade_necklace.jpg'),
('Thangka', 'Traditional Tibetan Buddhist Painting', 99.99, 10, 3, 'images/products/thangka.jpeg');
