INSERT INTO categories(name, slug, description, sort_order, meta_title, meta_description) VALUES
('Candies','candies','Colorful sugar candies with irresistible flavors that stay fresh longer. Perfect for kids, retailers, and bulk sales with consistent quality.',1,'Candies Manufacturer in Nashik | Anshul Food Products','Colorful sugar candies from Anshul Food Products for retail and bulk supply.'),
('Imli Pearls','imli-pearls','Sweet and tangy imli pearls offering real tamarind taste, chewy texture, strong packing, and long shelf life for steady customer demand.',2,'Imli Pearls Manufacturer | Anshul Food Products','Sweet and tangy imli pearls for retailers, distributors and bulk buyers.'),
('Coco Minies','coco-minies','Chewy coconut candies made with real coconut for natural flavor, smooth sweetness, and consistent texture.',3,'Coco Minies | Anshul Food Products','Coco Minies confectionery products available for online and bulk orders.'),
('Fun Chews','fun-chews','Soft chewy chocolates in multiple flavors with rich taste, attractive size, and reliable quality for store sales.',4,'Fun Chews Chocolate | Anshul Food Products','Soft chewy chocolates for retailers and distributors.'),
('Mini Cone','mini-cone','Chocolate cone products designed as quick treats for children, retailers, and impulse purchase counters.',5,'Mini Cone Chocolate | Anshul Food Products','Mini cone chocolate products from Anshul Food Products.'),
('Chocolates','chocolates','Crispy and cone-style chocolate treats with rich cocoa taste and strong packaging for retail shelves.',6,'Chocolates Manufacturer in Nashik | Anshul Food Products','Crispy bite and chocolava cone products from Anshul Food Products.'),
('Jelly Lollipops','jelly-lollipops','Fruity jelly lollipops with bright colours and long shelf life, ideal for kids and retail counters.',7,'Jelly Lollipops Manufacturer | Anshul Food Products','Jelly lollipop confectionery products from Anshul Food Products, Nashik.');

INSERT INTO products(category_id, name, slug, sku, short_description, description, ingredients, shelf_life, weight, price, mrp, stock_quantity, is_featured, meta_title, meta_description) VALUES
(1,'Candies','candies','AFP-CANDIES-001','Colorful sugar candies with irresistible flavors that stay fresh longer.','Colorful sugar candies manufactured with consistent quality, reliable packing, and retailer-friendly pricing. Perfect for kids, retail counters, and bulk sales.','Sugar, glucose syrup, permitted colours and flavours','As per packaging','Retail Pack',1.00,1.00,500,1,'Candies | Anshul Food Products','Buy colorful sugar candies from Anshul Food Products, Nashik.'),
(2,'Imli Pearls','imli-pearls','AFP-IMLI-001','Sweet and tangy imli pearls offering real tamarind taste.','Sweet and tangy imli pearls with chewy texture, strong packing, and long shelf life for steady customer demand. Ideal for retailers and bulk buyers.','Tamarind, sugar, salt, spices and permitted ingredients','As per packaging','Retail Pack',1.00,1.00,500,1,'Imli Pearls | Anshul Food Products','Sweet and tangy imli pearls for online orders and distributor supply.'),
(3,'Coco Minies','coco-minies','AFP-COCO-001','Chewy coconut candies made with real coconut for natural flavor.','Coco Minies are smooth, chewy coconut candies with consistent texture, fresh taste, and attractive retail value.','Coconut, sugar, glucose syrup and permitted ingredients','As per packaging','Retail Pack',1.00,1.00,500,1,'Coco Minies | Anshul Food Products','Coco Minies confectionery products by Anshul Food Products.'),
(4,'Fun Chews','fun-chews','AFP-FUN-001','Soft chewy chocolates in multiple flavors.','Soft chewy chocolates with rich taste, attractive size, reliable quality, and fast-moving appeal for stores and children.','Sugar, cocoa solids, milk solids, glucose syrup and permitted flavours','As per packaging','Retail Pack',5.00,5.00,300,1,'Fun Chews | Anshul Food Products','Soft chewy chocolates from Anshul Food Products.'),
(5,'Mini Cone','mini-cone','AFP-CONE-001','Crunchy mini cones filled with smooth chocolate, available in six flavors.','Crunchy mini cones filled with smooth chocolate. Six exciting flavors, strong presentation, and long shelf life ideal for retail counters.','Chocolate compound, wafer cone, milk solids and permitted flavours','As per packaging','Retail Pack',5.00,5.00,300,1,'Mini Cone Chocolate | Anshul Food Products','Mini Cone chocolate products for retail and bulk orders.'),
(6,'Crispy Bite','crispy-bite','AFP-CRISPY-001','Heart-shaped chocolate with crispy rice inside.','Heart-shaped chocolate with crispy rice inside. Light crunch, rich cocoa taste, and strong packing that keeps freshness intact.','Cocoa solids, crisped rice, sugar, milk solids and permitted flavours','As per packaging','Retail Pack',2.00,2.00,400,1,'Crispy Bite Chocolate | Anshul Food Products','Heart-shaped crispy rice chocolate from Anshul Food Products, Nashik.'),
(6,'Chocolava Cones','chocolava-cones','AFP-LAVA-001','Cone-shaped chocolate treat with a soft, lava-style chocolate centre.','Chocolava Cones are a premium cone-shaped chocolate treat with a soft, lava-style chocolate centre, attractive presentation, and reliable quality for fast-selling retail counters.','Chocolate compound, wafer cone, cocoa solids, milk solids and permitted flavours','As per packaging','Retail Pack',10.00,10.00,200,1,'Chocolava Cones | Anshul Food Products','Premium cone-style chocolate treat from Anshul Food Products, Nashik.'),
(7,'Jelly Lollipops','jelly-lollipops','AFP-JELLY-001','Sweet jelly lollipops with fruity flavors and bright colours.','Sweet jelly lollipops with fruity flavors, bright colours, and a chewy jelly centre. Long shelf life and strong packing make them ideal for steady retail demand.','Sugar, glucose syrup, fruit flavours, permitted colours','As per packaging','Retail Pack',5.00,5.00,300,1,'Jelly Lollipops | Anshul Food Products','Fruity jelly lollipops for retailers and bulk buyers, from Anshul Food Products.');

INSERT INTO product_images(product_id, image_url, alt_text, sort_order) VALUES
(1,'/uploads/products/candies.webp','Candies by Anshul Food Products',1),
(2,'/uploads/products/imli-pearls.webp','Imli Pearls by Anshul Food Products',1),
(3,'/uploads/products/coco-minies.webp','Coco Minies by Anshul Food Products',1),
(4,'/uploads/products/fun-chews.webp','Fun Chews by Anshul Food Products',1),
(5,'/uploads/products/mini-cone.webp','Mini Cone by Anshul Food Products',1),
(6,'/uploads/products/crispy-bite.webp','Crispy Bite by Anshul Food Products',1),
(7,'/uploads/products/chocolava-cones.webp','Chocolava Cones by Anshul Food Products',1),
(8,'/uploads/products/jelly-lollipops.webp','Jelly Lollipops by Anshul Food Products',1);

INSERT INTO blogs(title, slug, excerpt, content, featured_image, meta_title, meta_description, status, published_at) VALUES
('Why Consistency Builds Trust in Chocolate Manufacturing','why-consistency-builds-trust-in-chocolate-manufacturing','Consistency helps retailers trust product taste, packaging and supply.','Consistent taste, strong packaging, and dependable supply help retailers sell with confidence. At Anshul Food Products, every batch is handled with quality-focused processes so customers receive reliable chocolates and confectionery products.','/uploads/blogs/consistency-chocolate-manufacturing.webp','Why Consistency Builds Trust in Chocolate Manufacturing','Learn why consistency is important in chocolate and confectionery manufacturing.','published',NOW()),
('How Flavor Variety Helps Retailers Increase Chocolate Sales','how-flavor-variety-helps-retailers-increase-chocolate-sales','Flavor variety improves repeat sales and attracts different customers.','Retailers need products that attract children, families, and impulse buyers. A strong mix of candies, imli pearls, coco minies, and chewy chocolates gives stores more ways to meet customer demand.','/uploads/blogs/flavor-variety-retail-sales.webp','How Flavor Variety Helps Retailers Increase Chocolate Sales','See how flavor variety helps retailers sell more confectionery products.','published',NOW()),
('Why Packaging Quality Matters in Chocolate Manufacturing','why-packaging-quality-matters-in-chocolate-manufacturing','Good packaging protects taste, freshness, and storage stability.','Packaging quality matters because confectionery products must stay fresh during storage and transport. Reliable packaging reduces damage and helps retailers maintain product quality on shelves.','/uploads/blogs/packaging-quality-chocolate.webp','Why Packaging Quality Matters in Chocolate Manufacturing','Understand why packaging quality is important in chocolate manufacturing.','published',NOW());

INSERT INTO settings(setting_key, setting_value) VALUES
('brand_name','Anshul Food Products'),
('hero_title','Premium Chocolate Manufacturing in Nashik'),
('hero_subtitle','Manufacturing chocolates and confectionery products that people enjoy and retailers trust.'),
('support_phone','+917020176702'),
('support_email','anshulfoodproduct@gmail.com'),
('whatsapp_number','917020176702'),
('business_hours','Daily : 9.30AM to 7PM'),
('business_address','312/0367, New Aurangabad Road, Thorat Mala, Kailas Nagar, Nashik Maharashtra 422003'),
('footer_description','ANSHUL FOOD PRODUCTS manufactures chocolates and confectionery trusted for taste, quality, and strong packaging. Serving retailers and distributors across Nashik and Pan India.'),
('about_text','At ANSHUL FOOD PRODUCTS, we focus on manufacturing chocolates and confectionery products that people enjoy and retailers trust. Our products are made with quality ingredients, controlled processes, and reliable packaging to maintain taste, freshness, and stability during storage and transport.');
