-- ==========================================
-- HIBAJAR - Products Seed Data
-- ==========================================
-- Requires: categories, products tables (from schema.sql)
-- Run after schema setup.
-- ==========================================

INSERT INTO products (id, name, category, type, base_price, image_url, rating, reviews_count, current_status, description, options_json) VALUES
('whole_chicken_master', 'Poulet Entier', 'Poulet Entier', 'regular', 35.00, 'https://images.unsplash.com/photo-1587593810167-a84920ea0781?auto=format&fit=crop&w=600&q=80', 4.9, 240, 'In Stock', 'Poulet entier frais.', NULL),
('chicken_breast_master', 'Blanc de Poulet', 'Morceaux Principaux', 'regular', 65.00, 'https://joyeuxgourmet.fr/wp-content/uploads/2024/01/blanc_poulet-png.webp', 4.8, 290, 'In Stock', 'Blanc de poulet tendre.', NULL),
('chicken_thigh_master', 'Cuisses de Poulet', 'Morceaux Principaux', 'regular', 45.00, 'https://halalfs.com/960-large_default/cuisse-de-poulet-congele-10kg.jpg', 4.8, 110, 'In Stock', 'Cuisses de poulet juteuses.', NULL),
('drumsticks', 'Pilons', 'Morceaux Principaux', 'regular', 40.00, 'https://images.unsplash.com/photo-1615557960916-5f4791effe9d?auto=format&fit=crop&w=600&q=80', 4.8, 150, 'Low Stock', 'Pilons de poulet classiques.', NULL),
('wings', 'Ailes de Poulet', 'Morceaux Principaux', 'regular', 35.00, 'https://images.unsplash.com/photo-1615557960916-5f4791effe9d?auto=format&fit=crop&w=600&q=80', 4.6, 180, 'In Stock', 'Ailes de poulet.', NULL),
('chicken_back', 'Dos de Poulet', 'Morceaux Principaux', 'regular', 20.00, 'https://images.unsplash.com/photo-1615557960916-5f4791effe9d?auto=format&fit=crop&w=600&q=80', 4.5, 30, 'In Stock', 'Dos de poulet.', NULL),
('offal_mix', 'Sélection d''Abats', 'Abats de Poulet', 'regular', 30.00, 'https://images.unsplash.com/photo-1579712267685-42da80f60aa4?auto=format&fit=crop&w=600&q=80', 4.5, 90, 'In Stock', 'Abats de poulet frais.', NULL),
('skewers', 'Brochettes de Poulet', 'Préparations', 'regular', 70.00, 'https://images.unsplash.com/photo-1632778149955-e80f8ceca2e8?auto=format&fit=crop&w=600&q=80', 4.9, 200, 'In Stock', 'Brochettes de poulet.', NULL),
('fillet_preps', 'Déclinaisons de Filet', 'Préparations', 'regular', 70.00, 'https://images.unsplash.com/photo-1615557960916-5f4791effe9d?auto=format&fit=crop&w=600&q=80', 4.8, 150, 'In Stock', 'Déclinaisons de filet.', NULL),
('marinated', 'Morceaux Marinés', 'Préparations', 'regular', 65.00, 'https://images.unsplash.com/photo-1632778149955-e80f8ceca2e8?auto=format&fit=crop&w=600&q=80', 4.8, 130, 'In Stock', 'Morceaux marinés.', NULL),
('beldi_whole_chicken_master', 'Poulet Beldi Entier', 'Poulet Beldi Entier', 'beldi', 85.00, 'https://images.unsplash.com/photo-1549479383-bdcf841d1576?auto=format&fit=crop&w=600&q=80', 5.0, 85, 'Low Stock', 'Poulet Beldi authentique.', NULL),
('beldi_breast', 'Blanc de Poulet Beldi', 'Morceaux Beldi', 'beldi', 130.00, 'https://joyeuxgourmet.fr/wp-content/uploads/2024/01/blanc_poulet-png.webp', 4.8, 45, 'In Stock', 'Blanc de poulet Beldi.', NULL),
('beldi_thighs', 'Cuisses de Poulet Beldi', 'Morceaux Beldi', 'beldi', 95.00, 'https://halalfs.com/960-large_default/cuisse-de-poulet-congele-10kg.jpg', 4.9, 60, 'In Stock', 'Cuisses de poulet Beldi.', NULL),
('beldi_drumsticks', 'Pilons Beldi', 'Morceaux Beldi', 'beldi', 90.00, 'https://images.unsplash.com/photo-1615557960916-5f4791effe9d?auto=format&fit=crop&w=600&q=80', 4.8, 30, 'Out of Stock', 'Pilons Beldi.', NULL)
ON DUPLICATE KEY UPDATE name=VALUES(name), base_price=VALUES(base_price), current_status=VALUES(current_status);
