-- Seed data export (business data only; excludes users/auth tables)
-- Generated by data export script

USE shop_inventory;

SET FOREIGN_KEY_CHECKS = 0;

-- products: 121 row(s)
INSERT INTO `products` (`id`, `design_code`, `design_type`, `selling_price`, `active`, `created_at`) VALUES
(1, '8116', 'Kaftan Denim themed', '1000.00', 1, '2026-09-28 16:21:35'),
(2, '3511', 'Two piece Linen like', '1100.00', 1, '2026-09-28 16:21:35'),
(3, '250623', '2 piece linen type round neck buttons with attached flower', '1000.00', 1, '2026-09-28 16:21:35'),
(4, '250639', '2 piece double breast type ve neck with one button', '1000.00', 1, '2026-09-28 16:21:35'),
(5, '250653', '2 piece v  neck suit type with flower', '1000.00', 1, '2026-09-28 16:21:35'),
(6, '260105', '2 piece straight striped', '1000.00', 1, '2026-09-28 16:21:35'),
(7, '6203', 'Maxi lace type neck and bottom with belt', '800.00', 1, '2026-09-28 16:21:35'),
(8, '6231', 'Maxi Ve neck button and belt', '800.00', 1, '2026-09-28 16:21:35'),
(9, '2631', 'Maxi', '650.00', 1, '2026-09-28 16:21:35'),
(10, '2569', 'Jump suit flowers', '650.00', 1, '2026-09-28 16:21:35'),
(11, '25615', 'Maxi', '650.00', 1, '2026-09-28 16:21:35'),
(12, '2637', 'Maxi', '650.00', 1, '2026-09-28 16:21:35'),
(13, '23299', 'Kaftan without buttons type', '650.00', 1, '2026-09-28 16:21:35'),
(14, '23268', 'Kaftan with buttons type', '650.00', 1, '2026-09-28 16:21:35'),
(15, '8862', 'Maxi long stripes v neck with belt', '700.00', 1, '2026-09-28 16:21:35'),
(16, '2323', '2 piece Linen', '900.00', 1, '2026-09-28 16:21:35'),
(17, '26208', '2 piececrepe/polyster type rough', '1000.00', 1, '2026-09-28 16:21:35'),
(18, '6820', 'Sweaters', '1000.00', 1, '2026-09-28 16:21:35'),
(19, '#005', 'Long dress flowers  v neck', '750.00', 1, '2026-09-28 16:21:35'),
(20, '3109', 'Maxi floral square neckline', '650.00', 1, '2026-09-28 16:21:35'),
(21, '3111', 'Maxi floral square neck line with elastic', '650.00', 1, '2026-09-28 16:21:35'),
(22, '6057', '2 piece Linen Sister', '1100.00', 1, '2026-09-28 16:21:35'),
(23, 'Sunny ylong 1', '2 piece satin type full boutton top', '800.00', 1, '2026-09-28 16:21:35'),
(24, '3108', 'Striped Belted Shirt Dress', '800.00', 1, '2026-09-28 16:21:35'),
(25, '6052', '2 piece Crepe/poly type V neck buttons with belt', '1100.00', 1, '2026-09-28 16:21:35'),
(26, '2834', '2 piece crepe/poly type with stripped top', '1100.00', 1, '2026-09-28 16:21:35'),
(27, '6062', '2 piece blazer co-ord Set Linen', '1100.00', 1, '2026-09-28 16:21:35'),
(28, '647999', 'Kam', '2500.00', 1, '2026-09-28 16:23:41'),
(29, 'U297', 'Kam', '760.00', 1, '2026-09-28 16:24:18'),
(34, '3511', '2 piece flowers short top', '850.00', 1, '2026-09-28 20:42:44'),
(35, '250623', '2 piece linen type round neck buttons with attached flowers', '1000.00', 1, '2026-09-28 20:42:44'),
(36, '250639', '2 piece double breast type v neck with one button', '1000.00', 1, '2026-09-28 20:42:44'),
(37, '6231', 'Maxi V neck button and belt', '800.00', 1, '2026-09-28 20:42:44'),
(38, '23297', 'Kaftan without buttons type', '650.00', 1, '2026-09-28 20:42:44'),
(39, '2323', '2 piece track different codes', '1100.00', 1, '2026-09-28 20:42:44'),
(40, '26208', '2 piece crepe/polyester type rough', '1000.00', 1, '2026-09-28 20:42:44'),
(41, '6820', 'Long dress flowers v neck', '750.00', 1, '2026-09-28 20:42:44'),
(42, '23268', '2 piece satin type full button top', '800.00', 1, '2026-09-28 20:42:44'),
(43, '3102', '2 piece drawstring set soft crepe/poly', '1200.00', 1, '2026-09-28 20:42:44'),
(44, '2834', '2 piece crepe/poly type with striped top', '1100.00', 1, '2026-09-28 20:42:44'),
(45, '53380', '2 piece track set cotton type', '1300.00', 1, '2026-09-28 20:42:44'),
(46, '3102', '2 piece drawstring set crepe/poly', '1100.00', 1, '2026-09-28 20:42:44'),
(47, '60041', 'Maxi backless neck strap', '1150.00', 1, '2026-09-28 20:42:44'),
(48, '6185', '2 piece track set cotton type', '1100.00', 1, '2026-09-28 20:42:44'),
(49, '9210', 'Maxi, Backless, neck strap, mistari up down', '1075.00', 1, '2026-09-28 20:42:44'),
(50, '9290', 'Sun dress short', '725.00', 1, '2026-09-28 20:42:44'),
(51, '2380', 'Maxi, horizontal strips, short lines 3 colours', '950.00', 1, '2026-09-28 20:42:44'),
(52, '227', 'Maxi, sunshine yellow, ghoroha lacy divisions za ghorofa sleeve', '850.00', 1, '2026-09-28 20:42:44'),
(53, '25101', 'Sun Dress short Zebra Print', '875.00', 1, '2026-09-28 20:42:44'),
(54, '3111', 'Maxi floral square neck line with elastic', '775.00', 1, '2026-09-28 20:42:44'),
(55, '3120', 'Halter Neck Maxi Dress', '850.00', 1, '2026-09-28 20:42:44'),
(56, '2601', 'Abaya style Maxi', '850.00', 1, '2026-09-28 20:42:44'),
(57, '8815', 'Short Dress', '875.00', 1, '2026-09-28 20:42:44'),
(58, '8815-2', 'Short dress print version', '1100.00', 1, '2026-09-28 20:42:44'),
(59, '8851', 'White Forest Print T-shirt dress', '900.00', 1, '2026-09-28 20:42:44'),
(60, '2615', 'Sleeveless white Floral Maxi dress', '800.00', 1, '2026-09-28 20:42:44'),
(61, '7074', '2 piece wrap Top and palazzo pants suit - Boss lady style', '1175.00', 1, '2026-09-28 20:42:44'),
(62, '6308', 'Floral Boho Maxi dress with Rhine stone', '925.00', 1, '2026-09-28 20:42:44'),
(63, '2693', 'Shift Dress', '975.00', 1, '2026-09-28 20:42:44'),
(64, 'mzee', 'Sleeveless Jacket', '1125.00', 1, '2026-09-28 20:42:44'),
(65, '79413', 'White halter neck tiered Maxi-dress', '1025.00', 1, '2026-09-28 20:42:44'),
(66, '78445', 'Halter Neck Backless Boho Floral Maxi dress', '875.00', 1, '2026-09-28 20:42:44'),
(67, '47911', 'Scarfs/shawls', '825.00', 1, '2026-09-28 20:42:44'),
(68, '23441', 'Two yellow boots', '2200.00', 1, '2026-09-28 21:10:02'),
(69, '8876', 'Two piece linien', '2400.00', 1, '2026-09-28 21:37:46'),
(72, '4501', 'Floral cotton midi dress', '750.00', 1, '2026-09-29 10:41:11'),
(73, '7821', 'Two piece ribbed lounge set', '950.00', 1, '2026-09-29 10:41:11'),
(74, '3165', 'Long sleeve pleated dress', '850.00', 1, '2026-09-29 10:41:11'),
(75, '9042', 'Loose fit denim jumpsuit', '1050.00', 1, '2026-09-29 10:41:11'),
(76, '5210', 'Floral wrap maxi dress', '900.00', 1, '2026-09-29 10:41:11'),
(77, '7432', 'Satin blouse with wide trousers', '1050.00', 1, '2026-09-29 10:41:11'),
(78, '2684', 'Short sleeve printed jumpsuit', '800.00', 1, '2026-09-29 10:41:11'),
(79, '6119', 'Embroidered long kaftan', '1000.00', 1, '2026-09-29 10:41:11'),
(80, '4826', 'Striped button front dress', '750.00', 1, '2026-09-29 10:41:11'),
(81, '8351', 'Two piece floral skirt set', '1000.00', 1, '2026-09-29 10:41:11'),
(82, '2907', 'Denim shirt dress with belt', '925.00', 1, '2026-09-29 10:41:11'),
(83, '7145', 'Loose floral maxi dress', '825.00', 1, '2026-09-29 10:41:11'),
(84, '3562', 'Sleeveless pleated jumpsuit', '900.00', 1, '2026-09-29 10:41:11'),
(85, '9021', 'Two piece linen co-ord set', '1150.00', 1, '2026-09-29 10:41:11'),
(86, '4380', 'Animal print maxi dress', '875.00', 1, '2026-09-29 10:41:11'),
(87, '6254', 'Short floral summer dress', '700.00', 1, '2026-09-29 10:41:11'),
(88, '7814', 'High waist palazzo set', '1050.00', 1, '2026-09-29 10:41:11'),
(89, '2649', 'Plain cotton kaftan', '725.00', 1, '2026-09-29 10:41:11'),
(90, '5937', 'Two piece crepe blouse set', '1150.00', 1, '2026-09-29 10:41:11'),
(91, '3418', 'Belted shirt maxi dress', '925.00', 1, '2026-09-29 10:41:11'),
(92, '8762', 'Floral short sleeve dress', '800.00', 1, '2026-09-29 10:41:11'),
(93, '4175', 'Two piece satin trouser set', '1100.00', 1, '2026-09-29 10:41:11'),
(94, '6321', 'Denim sleeveless maxi dress', '975.00', 1, '2026-09-29 10:41:11'),
(95, '2856', 'Soft crepe floral jumpsuit', '1050.00', 1, '2026-09-29 10:41:11'),
(96, '7510', 'Long sleeve buttoned kaftan', '850.00', 1, '2026-09-29 10:41:11'),
(97, '3942', 'Polka dot midi dress', '700.00', 1, '2026-09-29 10:41:11'),
(98, '6817', 'Two piece cotton tracksuit', '900.00', 1, '2026-09-29 10:41:11'),
(99, '5208', 'Floral chiffon maxi', '850.00', 1, '2026-09-29 10:41:11'),
(100, '3179', 'Ruffle sleeve blouse', '600.00', 1, '2026-09-29 10:41:11'),
(101, '8420', 'Two piece blazer trouser set', '1250.00', 1, '2026-09-29 10:41:11'),
(102, '6043', 'Plain sleeveless jumpsuit', '800.00', 1, '2026-09-29 10:41:11'),
(103, '7295', 'Long floral kimono', '775.00', 1, '2026-09-29 10:41:11'),
(104, '4683', 'Butterfly print maxi dress', '900.00', 1, '2026-09-29 10:41:11'),
(105, '9157', 'Two piece printed co-ord', '1050.00', 1, '2026-09-29 10:41:11'),
(106, '2504', 'Linen button down dress', '875.00', 1, '2026-09-29 10:41:11'),
(107, '7736', 'Floral halter neck dress', '850.00', 1, '2026-09-29 10:41:11'),
(108, '5312', 'Crepe palazzo two piece', '1150.00', 1, '2026-09-29 10:41:11'),
(109, '6905', 'Backless floral maxi dress', '1200.00', 1, '2026-09-29 10:41:11'),
(110, '3827', 'Short denim summer dress', '775.00', 1, '2026-09-29 10:41:11'),
(111, '8164', 'Floral belt waist jumpsuit', '1025.00', 1, '2026-09-29 10:41:11'),
(112, '2948', 'Long sleeve printed kaftan', '725.00', 1, '2026-09-29 10:41:11'),
(113, '7306', 'Two piece linen trouser set', '975.00', 1, '2026-09-29 10:41:11'),
(114, '4159', 'Floral pleated midi dress', '825.00', 1, '2026-09-29 10:41:11'),
(115, '8621', 'Satin long sleeve dress', '925.00', 1, '2026-09-29 10:41:11'),
(116, '5093', 'Loose fit cotton jumpsuit', '775.00', 1, '2026-09-29 10:41:11'),
(117, '6734', 'Two piece floral co-ord set', '1100.00', 1, '2026-09-29 10:41:11'),
(118, '3285', 'Short printed wrap dress', '700.00', 1, '2026-09-29 10:41:11'),
(119, '9472', 'Beaded evening maxi dress', '1300.00', 1, '2026-09-29 10:41:11'),
(120, '5816', 'Cotton shirt dress with belt', '850.00', 1, '2026-09-29 10:41:11'),
(121, '2467', 'Two piece soft linen set', '1000.00', 1, '2026-09-29 10:41:11'),
(122, '7194', 'Floral spaghetti strap maxi', '800.00', 1, '2026-09-29 10:41:11'),
(123, '8650', 'Denim co-ord jacket set', '1200.00', 1, '2026-09-29 10:41:11'),
(124, '4358', 'Plain crepe maxi dress', '825.00', 1, '2026-09-29 10:41:11'),
(125, '6284', 'Floral button front jumpsuit', '925.00', 1, '2026-09-29 10:41:11'),
(126, '3526', 'Two piece printed palazzo set', '1125.00', 1, '2026-09-29 10:41:11'),
(127, '9047', 'Lace trim sleeveless maxi', '1000.00', 1, '2026-09-29 10:41:11');

-- suppliers: 96 row(s)
INSERT INTO `suppliers` (`id`, `name`, `phone`, `created_at`) VALUES
(1, 'Lily B017', NULL, '2026-09-28 16:21:35'),
(2, 'Ella 083', NULL, '2026-09-28 16:21:35'),
(3, 'Juan 115', NULL, '2026-09-28 16:21:35'),
(4, 'Hon Da 068', NULL, '2026-09-28 16:21:35'),
(5, 'O&D Lisa 58-59', NULL, '2026-09-28 16:21:35'),
(6, 'Li Tuan 221A', NULL, '2026-09-28 16:21:35'),
(7, 'Bo Hao 189A', NULL, '2026-09-28 16:21:35'),
(8, 'Y o Yo A35', NULL, '2026-09-28 16:21:35'),
(9, 'Yanzi B4 110', NULL, '2026-09-28 16:21:35'),
(10, 'Yan 140 Shengdu', NULL, '2026-09-28 16:21:35'),
(11, 'Fei ShangLisa 151', NULL, '2026-09-28 16:21:35'),
(12, 'Fei Shang Lisa 151', NULL, '2026-09-28 16:21:35'),
(13, 'Amanda 313', NULL, '2026-09-28 16:21:35'),
(14, 'Sunny Ylong 2119', NULL, '2026-09-28 16:21:35'),
(15, 'Fei Shang Lisa', NULL, '2026-09-28 16:21:35'),
(16, 'Amanda', NULL, '2026-09-28 16:21:35'),
(17, 'Kenha', NULL, '2026-09-28 16:23:41'),
(19, 'Otieno', NULL, '2026-09-28 17:13:25'),
(35, 'Lily Tracksuits', NULL, '2026-09-28 20:42:44'),
(39, 'Fei Shanglsa 151', NULL, '2026-09-28 20:42:44'),
(41, 'Sunny Yong 2119', NULL, '2026-09-28 20:42:44'),
(42, 'Coco 229 1A 0803', NULL, '2026-09-28 20:42:44'),
(46, 'Coco A083', NULL, '2026-09-28 20:42:44'),
(48, 'Sandy', NULL, '2026-09-28 20:42:44'),
(50, 'Miya', NULL, '2026-09-28 20:42:44'),
(52, 'Bo Hao', NULL, '2026-09-28 20:42:44'),
(53, 'Danae', NULL, '2026-09-28 20:42:44'),
(54, 'Wan Yue 235', NULL, '2026-09-28 20:42:44'),
(55, 'Fei Shang', NULL, '2026-09-28 20:42:44'),
(57, 'Ladyee 028', NULL, '2026-09-28 20:42:44'),
(58, 'Li Tuan', NULL, '2026-09-28 20:42:44'),
(62, 'Liu 218', NULL, '2026-09-28 20:42:44'),
(63, 'Lily Chen Fashions', NULL, '2026-09-28 20:42:44'),
(64, 'Hong Da', NULL, '2026-09-28 20:42:44'),
(65, 'Flying down clothing', NULL, '2026-09-28 20:42:44'),
(66, 'Jian Guangda c17', NULL, '2026-09-28 20:42:44'),
(67, 'Cindy Jian Guangda C16', NULL, '2026-09-28 20:42:44'),
(68, 'Qian Qin YIwu', NULL, '2026-09-28 20:42:44'),
(69, 'Hot and Cold', NULL, '2026-09-28 21:10:02'),
(70, 'Mwaniki', NULL, '2026-09-28 21:37:46'),
(71, 'Fashion Hub A12', NULL, '2026-09-29 10:41:11'),
(72, 'Grace Collection B08', NULL, '2026-09-29 10:41:11'),
(73, 'Mercy Wear C14', NULL, '2026-09-29 10:41:11'),
(74, 'Starline D22', NULL, '2026-09-29 10:41:11'),
(75, 'Queen Style E17', NULL, '2026-09-29 10:41:11'),
(76, 'Beauty Lane F09', NULL, '2026-09-29 10:41:11'),
(77, 'Modern Closet G31', NULL, '2026-09-29 10:41:11'),
(78, 'Rose Fashion H15', NULL, '2026-09-29 10:41:11'),
(79, 'Classic Wear J07', NULL, '2026-09-29 10:41:11'),
(80, 'Lovely Styles K19', NULL, '2026-09-29 10:41:11'),
(81, 'Trend House L24', NULL, '2026-09-29 10:41:11'),
(82, 'Sunrise Fashion M11', NULL, '2026-09-29 10:41:11'),
(83, 'Elite Collection N18', NULL, '2026-09-29 10:41:11'),
(84, 'Angel Boutique P05', NULL, '2026-09-29 10:41:11'),
(85, 'Star Boutique Q27', NULL, '2026-09-29 10:41:11'),
(86, 'Prime Fashion R13', NULL, '2026-09-29 10:41:11'),
(87, 'Classic Trends S16', NULL, '2026-09-29 10:41:11'),
(88, 'Ladies Choice T21', NULL, '2026-09-29 10:41:11'),
(89, 'Fashion World U06', NULL, '2026-09-29 10:41:11'),
(90, 'Perfect Wear V12', NULL, '2026-09-29 10:41:11'),
(91, 'Queen''s Closet W09', NULL, '2026-09-29 10:41:11'),
(92, 'Elegant Styles X18', NULL, '2026-09-29 10:41:11'),
(93, 'First Choice Y25', NULL, '2026-09-29 10:41:11'),
(94, 'Glory Fashion Z03', NULL, '2026-09-29 10:41:11'),
(95, 'Top Lady A29', NULL, '2026-09-29 10:41:11'),
(96, 'Blue Rose B16', NULL, '2026-09-29 10:41:11'),
(97, 'Style Point C25', NULL, '2026-09-29 10:41:11'),
(98, 'Fashion Plus D11', NULL, '2026-09-29 10:41:11'),
(99, 'Lady Choice E06', NULL, '2026-09-29 10:41:11'),
(100, 'Smart Ladies F23', NULL, '2026-09-29 10:41:11'),
(101, 'Graceful Wear G08', NULL, '2026-09-29 10:41:11'),
(102, 'Comfort Fashion H26', NULL, '2026-09-29 10:41:11'),
(103, 'Dream Closet J14', NULL, '2026-09-29 10:41:11'),
(104, 'Fashion Avenue K03', NULL, '2026-09-29 10:41:11'),
(105, 'Unique Style L17', NULL, '2026-09-29 10:41:11'),
(106, 'Women World M28', NULL, '2026-09-29 10:41:11'),
(107, 'Best Choice N07', NULL, '2026-09-29 10:41:11'),
(108, 'Luxury Ladies P19', NULL, '2026-09-29 10:41:11'),
(109, 'Everyday Fashion Q04', NULL, '2026-09-29 10:41:11'),
(110, 'Pretty Lady R22', NULL, '2026-09-29 10:41:11'),
(111, 'Style Masters S11', NULL, '2026-09-29 10:41:11'),
(112, 'Fashion Choice T18', NULL, '2026-09-29 10:41:11'),
(113, 'Ladies Corner U23', NULL, '2026-09-29 10:41:11'),
(114, 'Modern Ladies V05', NULL, '2026-09-29 10:41:11'),
(115, 'Trend Ladies W14', NULL, '2026-09-29 10:41:11'),
(116, 'Chic Fashion X07', NULL, '2026-09-29 10:41:11'),
(117, 'Perfect Lady Y20', NULL, '2026-09-29 10:41:11'),
(118, 'Elite Ladies Z15', NULL, '2026-09-29 10:41:11'),
(119, 'Style Avenue A24', NULL, '2026-09-29 10:41:11'),
(120, 'Fashion Sisters B10', NULL, '2026-09-29 10:41:11'),
(121, 'Charming Wear C21', NULL, '2026-09-29 10:41:11'),
(122, 'Smart Style D18', NULL, '2026-09-29 10:41:11'),
(123, 'Lovely Lady E13', NULL, '2026-09-29 10:41:11'),
(124, 'First Lady F07', NULL, '2026-09-29 10:41:11'),
(125, 'Modern Woman G19', NULL, '2026-09-29 10:41:11'),
(126, 'Grace Boutique H04', NULL, '2026-09-29 10:41:11');

-- store_receipts: 107 row(s)
INSERT INTO `store_receipts` (`id`, `receipt_date`, `invoice_number`, `supplier_id`, `created_at`) VALUES
(1, '2026-09-28 00:00:00', 'Inv 234', 17, '2026-09-28 16:23:41'),
(2, '2026-09-22 00:00:00', 'Inv 236', 17, '2026-09-28 16:24:18'),
(3, '2026-09-28 00:00:00', 'KE32869', 19, '2026-09-28 17:13:25'),
(7, '2026-09-28 00:00:00', 'KE3421', 1, '2026-09-28 20:42:44'),
(8, '2026-09-28 00:00:00', 'KE36751', 2, '2026-09-28 20:42:44'),
(9, '2026-09-28 00:00:00', 'KE39622', 2, '2026-09-28 20:42:44'),
(10, '2026-09-28 00:00:00', 'KE40534', 2, '2026-09-28 20:42:44'),
(11, '2026-09-28 00:00:00', 'KE38217', 2, '2026-09-28 20:42:44'),
(12, '2026-09-28 00:00:00', 'KE37383', 2, '2026-09-28 20:42:44'),
(13, '2026-09-28 00:00:00', 'KE37694', 3, '2026-09-28 20:42:44'),
(14, '2026-09-28 00:00:00', 'KE35034', 4, '2026-09-28 20:42:44'),
(15, '2026-09-28 00:00:00', 'KE32993', 4, '2026-09-28 20:42:44'),
(16, '2026-09-28 00:00:00', 'KE32851', 5, '2026-09-28 20:42:44'),
(17, '2026-09-28 00:00:00', 'KE35613', 6, '2026-09-28 20:42:44'),
(18, '2026-09-28 00:00:00', 'KE37358', 7, '2026-09-28 20:42:44'),
(19, '2026-09-28 00:00:00', 'KE33151', 35, '2026-09-28 20:42:44'),
(20, '2026-09-28 00:00:00', 'ME34608', 8, '2026-09-28 20:42:44'),
(21, '2026-09-28 00:00:00', 'KE32891', 9, '2026-09-28 20:42:44'),
(22, '2026-09-28 00:00:00', 'KE38773', 10, '2026-09-28 20:42:44'),
(23, '2026-09-28 00:00:00', 'KE35546', 39, '2026-09-28 20:42:44'),
(24, '2026-09-28 00:00:00', 'KE34806', 13, '2026-09-28 20:42:44'),
(25, '2026-09-28 00:00:00', 'KE39225', 41, '2026-09-28 20:42:44'),
(26, '2026-09-28 00:00:00', 'KE39647', 42, '2026-09-28 20:42:44'),
(27, '2026-09-28 00:00:00', 'KE42335', 15, '2026-09-28 20:42:44'),
(28, '2026-09-28 00:00:00', 'KE39889', 16, '2026-09-28 20:42:44'),
(29, '2026-09-28 00:00:00', 'KE41719', 35, '2026-09-28 20:42:44'),
(30, '2026-09-28 00:00:00', 'KE44185', 46, '2026-09-28 20:42:44'),
(31, '2026-09-28 00:00:00', 'KE44185', 16, '2026-09-28 20:42:44'),
(32, '2026-09-28 00:00:00', 'KE39607', 48, '2026-09-28 20:42:44'),
(33, '2026-09-28 00:00:00', 'KE37871', 48, '2026-09-28 20:42:44'),
(34, '2026-09-28 00:00:00', 'KE44894', 50, '2026-09-28 20:42:44'),
(35, '2026-09-28 00:00:00', 'KE46233', 50, '2026-09-28 20:42:44'),
(36, '2026-09-28 00:00:00', 'KE45677', 52, '2026-09-28 20:42:44'),
(37, '2026-09-28 00:00:00', 'KE39941', 53, '2026-09-28 20:42:44'),
(38, '2026-09-28 00:00:00', 'KE48461', 54, '2026-09-28 20:42:44'),
(39, '2026-09-28 00:00:00', 'KE39310', 55, '2026-09-28 20:42:44'),
(40, '2026-09-28 00:00:00', 'KE35335', 55, '2026-09-28 20:42:44'),
(41, '2026-09-28 00:00:00', 'KE49542', 57, '2026-09-28 20:42:44'),
(42, '2026-09-28 00:00:00', 'KE47973', 58, '2026-09-28 20:42:44'),
(43, '2026-09-28 00:00:00', 'KE4091', 58, '2026-09-28 20:42:44'),
(44, '2026-09-28 00:00:00', 'KE34068', 58, '2026-09-28 20:42:44'),
(45, '2026-09-28 00:00:00', 'KE42217', 58, '2026-09-28 20:42:44'),
(46, '2026-09-28 00:00:00', 'KE33460', 62, '2026-09-28 20:42:44'),
(47, '2026-09-28 00:00:00', 'KE49609', 63, '2026-09-28 20:42:44'),
(48, '2026-09-28 00:00:00', 'KE49283', 64, '2026-09-28 20:42:44'),
(49, '2026-09-28 00:00:00', 'KE48432', 65, '2026-09-28 20:42:44'),
(50, '2026-09-28 00:00:00', 'KE47490', 66, '2026-09-28 20:42:44'),
(51, '2026-09-28 00:00:00', 'KE47490', 67, '2026-09-28 20:42:44'),
(52, '2026-09-28 00:00:00', 'KE250806', 68, '2026-09-28 20:42:44'),
(53, '2026-09-28 00:00:00', 'KE20001', 69, '2026-09-28 21:10:02'),
(54, '2026-09-28 00:00:00', 'KE2003', 70, '2026-09-28 21:37:46'),
(57, '2024-02-14 00:00:00', 'INV21456', 71, '2026-09-29 10:41:11'),
(58, '2024-03-27 00:00:00', 'INV23891', 72, '2026-09-29 10:41:11'),
(59, '2024-05-09 00:00:00', 'INV25173', 73, '2026-09-29 10:41:11'),
(60, '2024-06-22 00:00:00', 'INV27435', 74, '2026-09-29 10:41:11'),
(61, '2024-08-05 00:00:00', 'INV29684', 75, '2026-09-29 10:41:11'),
(62, '2024-09-19 00:00:00', 'INV31872', 76, '2026-09-29 10:41:11'),
(63, '2024-11-03 00:00:00', 'INV33945', 77, '2026-09-29 10:41:11'),
(64, '2024-12-18 00:00:00', 'INV35126', 78, '2026-09-29 10:41:11'),
(65, '2025-01-11 00:00:00', 'INV36784', 79, '2026-09-29 10:41:11'),
(66, '2025-02-26 00:00:00', 'INV38429', 80, '2026-09-29 10:41:11'),
(67, '2025-04-13 00:00:00', 'INV40163', 81, '2026-09-29 10:41:11'),
(68, '2025-05-29 00:00:00', 'INV41752', 82, '2026-09-29 10:41:11'),
(69, '2025-07-07 00:00:00', 'INV43286', 83, '2026-09-29 10:41:11'),
(70, '2025-08-24 00:00:00', 'INV45139', 84, '2026-09-29 10:41:11'),
(71, '2025-10-16 00:00:00', 'INV46825', 85, '2026-09-29 10:41:11'),
(72, '2025-12-02 00:00:00', 'INV48271', 86, '2026-09-29 10:41:11'),
(73, '2026-01-21 00:00:00', 'INV49736', 87, '2026-09-29 10:41:11'),
(74, '2026-02-08 00:00:00', 'INV51384', 88, '2026-09-29 10:41:11'),
(75, '2026-03-17 00:00:00', 'INV52849', 89, '2026-09-29 10:41:11'),
(76, '2026-04-04 00:00:00', 'INV54127', 90, '2026-09-29 10:41:11'),
(77, '2026-05-23 00:00:00', 'INV55763', 91, '2026-09-29 10:41:11'),
(78, '2026-06-12 00:00:00', 'INV57294', 92, '2026-09-29 10:41:11'),
(79, '2026-07-28 00:00:00', 'INV58942', 93, '2026-09-29 10:41:11'),
(80, '2026-08-06 00:00:00', 'INV60418', 94, '2026-09-29 10:41:11'),
(81, '2026-09-15 00:00:00', 'INV62173', 95, '2026-09-29 10:41:11'),
(82, '2023-10-03 00:00:00', 'INV18392', 96, '2026-09-29 10:41:11'),
(83, '2023-11-18 00:00:00', 'INV19745', 97, '2026-09-29 10:41:11'),
(84, '2023-12-29 00:00:00', 'INV20583', 98, '2026-09-29 10:41:11'),
(85, '2024-01-07 00:00:00', 'INV21164', 99, '2026-09-29 10:41:11'),
(86, '2024-04-25 00:00:00', 'INV24691', 100, '2026-09-29 10:41:11'),
(87, '2024-07-12 00:00:00', 'INV28147', 101, '2026-09-29 10:41:11'),
(88, '2024-10-30 00:00:00', 'INV32518', 102, '2026-09-29 10:41:11'),
(89, '2025-03-14 00:00:00', 'INV39725', 103, '2026-09-29 10:41:11'),
(90, '2025-06-09 00:00:00', 'INV42561', 104, '2026-09-29 10:41:11'),
(91, '2025-09-27 00:00:00', 'INV46182', 105, '2026-09-29 10:41:11'),
(92, '2025-11-11 00:00:00', 'INV47639', 106, '2026-09-29 10:41:11'),
(93, '2026-02-19 00:00:00', 'INV50627', 107, '2026-09-29 10:41:11'),
(94, '2026-04-25 00:00:00', 'INV54831', 108, '2026-09-29 10:41:11'),
(95, '2026-07-09 00:00:00', 'INV58046', 109, '2026-09-29 10:41:11'),
(96, '2026-09-22 00:00:00', 'INV61784', 110, '2026-09-29 10:41:11'),
(97, '2023-05-05 00:00:00', 'INV15629', 111, '2026-09-29 10:41:11'),
(98, '2023-06-21 00:00:00', 'INV16943', 112, '2026-09-29 10:41:11'),
(99, '2023-08-16 00:00:00', 'INV18175', 113, '2026-09-29 10:41:11'),
(100, '2023-09-28 00:00:00', 'INV19068', 114, '2026-09-29 10:41:11'),
(101, '2024-02-13 00:00:00', 'INV22183', 115, '2026-09-29 10:41:11'),
(102, '2024-05-31 00:00:00', 'INV25947', 116, '2026-09-29 10:41:11'),
(103, '2024-08-17 00:00:00', 'INV30152', 117, '2026-09-29 10:41:11'),
(104, '2024-11-26 00:00:00', 'INV34479', 118, '2026-09-29 10:41:11'),
(105, '2025-03-08 00:00:00', 'INV39064', 119, '2026-09-29 10:41:11'),
(106, '2025-05-20 00:00:00', 'INV41438', 120, '2026-09-29 10:41:11'),
(107, '2025-08-04 00:00:00', 'INV44671', 121, '2026-09-29 10:41:11'),
(108, '2025-10-23 00:00:00', 'INV47093', 122, '2026-09-29 10:41:11'),
(109, '2026-01-10 00:00:00', 'INV48925', 123, '2026-09-29 10:41:11'),
(110, '2026-03-26 00:00:00', 'INV53217', 124, '2026-09-29 10:41:11'),
(111, '2026-06-14 00:00:00', 'INV56938', 125, '2026-09-29 10:41:11'),
(112, '2026-08-30 00:00:00', 'INV61052', 126, '2026-09-29 10:41:11');

-- store_receipt_items: 114 row(s)
INSERT INTO `store_receipt_items` (`id`, `receipt_id`, `product_id`, `quantity`, `landing_price`, `selling_price`) VALUES
(1, 1, 28, 32, '2000.00', '2500.00'),
(2, 2, 29, 77, '700.00', '760.00'),
(3, 3, 2, 20, '882.00', '1100.00'),
(7, 7, 1, 9, '729.00', '1000.00'),
(8, 8, 34, 25, '578.00', '850.00'),
(9, 9, 35, 28, '748.00', '1000.00'),
(10, 10, 36, 6, '698.00', '1000.00'),
(11, 11, 5, 11, '720.00', '1000.00'),
(12, 12, 6, 21, '708.00', '1000.00'),
(13, 13, 7, 14, '579.00', '800.00'),
(14, 13, 37, 35, '578.00', '800.00'),
(15, 14, 9, 39, '453.00', '650.00'),
(16, 15, 10, 30, '508.00', '650.00'),
(17, 15, 11, 6, '426.00', '650.00'),
(18, 14, 12, 32, '510.00', '650.00'),
(19, 16, 38, 8, '435.00', '650.00'),
(20, 16, 14, 31, '437.00', '650.00'),
(21, 17, 15, 35, '518.00', '700.00'),
(22, 18, 16, 35, '606.00', '900.00'),
(23, 19, 39, 20, '635.00', '1100.00'),
(24, 20, 40, 35, '808.00', '1000.00'),
(25, 21, 18, 30, '619.00', '1000.00'),
(26, 22, 41, 26, '540.00', '750.00'),
(27, 23, 20, 10, '491.00', '650.00'),
(28, 23, 21, 34, '510.00', '650.00'),
(29, 24, 22, 39, '782.00', '1100.00'),
(30, 25, 42, 11, '529.00', '800.00'),
(31, 26, 43, 10, '910.00', '1200.00'),
(32, 27, 24, 28, '505.00', '800.00'),
(33, 28, 25, 40, '819.00', '1100.00'),
(34, 28, 44, 38, '785.00', '1100.00'),
(35, 29, 45, 20, '671.00', '1300.00'),
(36, 30, 25, 39, '876.00', '1100.00'),
(37, 31, 46, 10, '876.00', '1100.00'),
(38, 31, 27, 32, '787.00', '1100.00'),
(39, 32, 47, 16, '881.00', '1150.00'),
(40, 33, 48, 18, '878.00', '1100.00'),
(41, 34, 49, 27, '861.00', '1075.00'),
(42, 35, 50, 8, '502.00', '725.00'),
(43, 36, 51, 11, '740.00', '950.00'),
(44, 37, 52, 9, '660.00', '850.00'),
(45, 38, 53, 34, '709.00', '875.00'),
(46, 39, 54, 5, '625.00', '775.00'),
(47, 40, 55, 40, '646.00', '850.00'),
(48, 41, 56, 38, '653.00', '850.00'),
(49, 42, 57, 35, '704.00', '875.00'),
(50, 43, 58, 5, '859.00', '1100.00'),
(51, 44, 59, 35, '697.00', '900.00'),
(52, 45, 60, 23, '499.00', '800.00'),
(53, 46, 61, 30, '853.00', '1175.00'),
(54, 47, 62, 10, '653.00', '925.00'),
(55, 48, 63, 10, '780.00', '975.00'),
(56, 49, 64, 22, '806.00', '1125.00'),
(57, 50, 65, 26, '863.00', '1025.00'),
(58, 51, 66, 12, '693.00', '875.00'),
(59, 52, 67, 15, '661.00', '825.00'),
(60, 53, 68, 2, '2000.00', '2200.00'),
(61, 54, 69, 2, '2000.00', '2400.00'),
(64, 57, 72, 18, '520.00', '750.00'),
(65, 58, 73, 27, '680.00', '950.00'),
(66, 59, 74, 14, '590.00', '850.00'),
(67, 60, 75, 31, '775.00', '1050.00'),
(68, 61, 76, 22, '625.00', '900.00'),
(69, 62, 77, 16, '715.00', '1050.00'),
(70, 63, 78, 35, '548.00', '800.00'),
(71, 64, 79, 19, '735.00', '1000.00'),
(72, 65, 80, 28, '495.00', '750.00'),
(73, 66, 81, 24, '705.00', '1000.00'),
(74, 67, 82, 33, '665.00', '925.00'),
(75, 68, 83, 21, '575.00', '825.00'),
(76, 69, 84, 17, '620.00', '900.00'),
(77, 70, 85, 36, '790.00', '1150.00'),
(78, 71, 86, 29, '610.00', '875.00'),
(79, 72, 87, 12, '455.00', '700.00'),
(80, 73, 88, 25, '735.00', '1050.00'),
(81, 74, 89, 32, '480.00', '725.00'),
(82, 75, 90, 20, '810.00', '1150.00'),
(83, 76, 91, 38, '650.00', '925.00'),
(84, 77, 92, 15, '535.00', '800.00'),
(85, 78, 93, 34, '745.00', '1100.00'),
(86, 79, 94, 23, '690.00', '975.00'),
(87, 80, 95, 30, '725.00', '1050.00'),
(88, 81, 96, 26, '575.00', '850.00'),
(89, 82, 97, 20, '465.00', '700.00'),
(90, 83, 98, 37, '620.00', '900.00'),
(91, 84, 99, 13, '585.00', '850.00'),
(92, 85, 100, 42, '390.00', '600.00'),
(93, 86, 101, 18, '875.00', '1250.00'),
(94, 87, 102, 27, '550.00', '800.00'),
(95, 88, 103, 34, '510.00', '775.00'),
(96, 89, 104, 16, '630.00', '900.00'),
(97, 90, 105, 39, '720.00', '1050.00'),
(98, 91, 106, 22, '605.00', '875.00'),
(99, 92, 107, 31, '580.00', '850.00'),
(100, 93, 108, 24, '795.00', '1150.00'),
(101, 94, 109, 17, '825.00', '1200.00'),
(102, 95, 110, 36, '525.00', '775.00'),
(103, 96, 111, 28, '715.00', '1025.00'),
(104, 97, 112, 33, '495.00', '725.00'),
(105, 98, 113, 26, '670.00', '975.00'),
(106, 99, 114, 19, '560.00', '825.00'),
(107, 100, 115, 41, '635.00', '925.00'),
(108, 101, 116, 23, '525.00', '775.00'),
(109, 102, 117, 29, '760.00', '1100.00'),
(110, 103, 118, 36, '470.00', '700.00'),
(111, 104, 119, 11, '895.00', '1300.00'),
(112, 105, 120, 32, '585.00', '850.00'),
(113, 106, 121, 27, '710.00', '1000.00'),
(114, 107, 122, 18, '540.00', '800.00'),
(115, 108, 123, 21, '850.00', '1200.00'),
(116, 109, 124, 35, '565.00', '825.00'),
(117, 110, 125, 14, '625.00', '925.00'),
(118, 111, 126, 30, '780.00', '1125.00'),
(119, 112, 127, 24, '695.00', '1000.00');

-- dispatches: 62 row(s)
INSERT INTO `dispatches` (`id`, `dispatch_date`, `destination`, `notes`, `created_at`, `source_shop`, `transfer_type`) VALUES
(1, '2026-09-28 00:00:00', 'Delivarance Church Store', 'root', '2026-09-28 16:46:40', 'Delivarance Church Store', 'transfer'),
(2, '2026-09-28 00:00:00', 'Towhid-G56', 'Given to Ken', '2026-09-28 17:24:10', 'Delivarance Church Store', 'dispatch'),
(8, '2026-09-28 00:00:00', 'Towhid-G56', 'Given to Ken', '2026-09-28 21:13:09', 'Delivarance Church Store', 'dispatch'),
(9, '2026-09-28 00:00:00', 'Towhid-G56', NULL, '2026-09-28 21:40:35', 'Delivarance Church Store', 'dispatch'),
(10, '2026-09-28 00:00:00', 'Kababa', NULL, '2026-09-28 21:48:40', 'Delivarance Church Store', 'dispatch'),
(23, '2026-09-29 00:00:00', 'Tansim-G27', 'Caroline', '2026-09-29 09:49:42', 'Delivarance Church Store', 'dispatch'),
(24, '2026-01-15 00:00:00', 'Tansim-G28', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV15629', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(25, '2026-01-16 00:00:00', 'Tansim-G28', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV16943', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(26, '2026-04-25 00:00:00', 'Tansim-G30', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV18175', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(27, '2026-01-09 00:00:00', 'Tansim-G27', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV18392', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(28, '2026-09-29 00:00:00', 'Tansim-G30', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV19068', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(29, '2026-09-29 00:00:00', 'Tansim-G28', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV19745', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(30, '2025-10-12 00:00:00', 'Tansim-G8', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV20583', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(31, '2025-10-20 00:00:00', 'KH-G23', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV21164', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(32, '2026-01-04 00:00:00', 'Tansim-G8', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV21456', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(33, '2026-02-15 00:00:00', 'Tansim-G27', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV22183', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(34, '2026-09-29 00:00:00', 'KH-G23', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV23891', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(35, '2026-09-29 00:00:00', 'Tansim-G30', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV24691', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(36, '2025-11-13 00:00:00', 'Tansim-G8', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV25173', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(37, '2025-12-04 00:00:00', 'Towhid-G56', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV25947', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(38, '2026-06-13 00:00:00', 'Towhid-G56', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV27435', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(39, '2025-12-29 00:00:00', 'Towhid-G56', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV28147', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(40, '2025-10-17 00:00:00', 'Tansim-G30', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV29684', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(41, '2025-10-11 00:00:00', 'Tansim-G28', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV30152', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(42, '2026-01-18 00:00:00', 'KH-G23', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV31872', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(43, '2025-11-27 00:00:00', 'Tansim-G27', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV32518', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(44, '2025-10-08 00:00:00', 'Towhid-G56', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV33945', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(45, '2026-05-24 00:00:00', 'Tansim-G8', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV34479', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(46, '2026-06-07 00:00:00', 'KH-G23', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV35126', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(47, '2026-08-27 00:00:00', 'Tansim-G28', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV36784', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(48, '2026-03-17 00:00:00', 'Tansim-G30', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV38429', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(49, '2026-09-08 00:00:00', 'Tansim-G28', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV39064', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(50, '2026-05-23 00:00:00', 'Tansim-G8', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV39725', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(51, '2026-09-05 00:00:00', 'Tansim-G30', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV40163', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(52, '2025-11-06 00:00:00', 'Tansim-G8', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV41438', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(53, '2026-04-09 00:00:00', 'Tansim-G30', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV41752', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(54, '2026-09-29 00:00:00', 'Tansim-G8', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV42561', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(55, '2026-09-29 00:00:00', 'Tansim-G30', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV43286', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(56, '2025-12-21 00:00:00', 'Tansim-G27', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV44671', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(57, '2025-11-02 00:00:00', 'Towhid-G56', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV45139', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(58, '2026-07-27 00:00:00', 'Towhid-G56', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV46182', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(59, '2026-05-31 00:00:00', 'Tansim-G8', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV46825', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(60, '2026-03-27 00:00:00', 'KH-G23', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV47093', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(61, '2026-09-29 00:00:00', 'Towhid-G56', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV47639', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(62, '2026-05-30 00:00:00', 'Tansim-G28', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV48271', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(63, '2026-07-23 00:00:00', 'Tansim-G8', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV48925', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(64, '2026-09-29 00:00:00', 'Tansim-G8', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV49736', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(65, '2026-03-20 00:00:00', 'Towhid-G56', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV50627', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(66, '2026-08-21 00:00:00', 'Tansim-G27', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV51384', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(67, '2026-09-29 00:00:00', 'Tansim-G30', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV52849', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(68, '2026-04-22 00:00:00', 'KH-G23', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV53217', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(69, '2026-09-29 00:00:00', 'Tansim-G28', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV54127', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(70, '2026-06-28 00:00:00', 'Tansim-G28', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV54831', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(71, '2026-07-06 00:00:00', 'KH-G23', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV55763', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(72, '2026-09-21 00:00:00', 'Tansim-G28', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV56938', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(73, '2026-09-10 00:00:00', 'Tansim-G30', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV57294', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(74, '2026-07-20 00:00:00', 'Towhid-G56', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV58046', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(75, '2026-09-27 00:00:00', 'Tansim-G27', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV58942', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(76, '2026-08-17 00:00:00', 'KH-G23', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV60418', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(77, '2026-08-30 00:00:00', 'Tansim-G8', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV61052', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(78, '2026-09-24 00:00:00', 'Tansim-G8', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV61784', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch'),
(79, '2026-09-28 00:00:00', 'Towhid-G56', 'SYSTEM PREVIEW SAMPLE: test-only stock transfer INV62173', '2026-09-29 10:45:51', 'Delivarance Church Store', 'dispatch');

-- dispatch_items: 62 row(s)
INSERT INTO `dispatch_items` (`id`, `dispatch_id`, `product_id`, `quantity`) VALUES
(1, 1, 28, 5),
(2, 2, 2, 5),
(8, 8, 52, 3),
(9, 9, 22, 2),
(10, 10, 11, 4),
(23, 23, 53, 30),
(24, 24, 112, 16),
(25, 25, 113, 11),
(26, 26, 114, 6),
(27, 27, 97, 7),
(28, 28, 115, 16),
(29, 29, 98, 14),
(30, 30, 99, 7),
(31, 31, 100, 22),
(32, 32, 72, 7),
(33, 33, 116, 8),
(34, 34, 73, 10),
(35, 35, 101, 7),
(36, 36, 74, 6),
(37, 37, 117, 12),
(38, 38, 75, 11),
(39, 39, 102, 12),
(40, 40, 76, 6),
(41, 41, 118, 14),
(42, 42, 77, 4),
(43, 43, 103, 13),
(44, 44, 78, 13),
(45, 45, 119, 5),
(46, 46, 79, 8),
(47, 47, 80, 13),
(48, 48, 81, 10),
(49, 49, 120, 17),
(50, 50, 104, 8),
(51, 51, 82, 15),
(52, 52, 121, 10),
(53, 53, 83, 7),
(54, 54, 105, 15),
(55, 55, 84, 5),
(56, 56, 122, 7),
(57, 57, 85, 15),
(58, 58, 106, 7),
(59, 59, 86, 10),
(60, 60, 123, 8),
(61, 61, 107, 9),
(62, 62, 87, 4),
(63, 63, 124, 16),
(64, 64, 88, 9),
(65, 65, 108, 10),
(66, 66, 89, 16),
(67, 67, 90, 10),
(68, 68, 125, 5),
(69, 69, 91, 19),
(70, 70, 109, 6),
(71, 71, 92, 5),
(72, 72, 126, 14),
(73, 73, 93, 16),
(74, 74, 110, 17),
(75, 75, 94, 8),
(76, 76, 95, 9),
(77, 77, 127, 10),
(78, 78, 111, 13),
(79, 79, 96, 10);

-- shop_stock: 62 row(s)
INSERT INTO `shop_stock` (`product_id`, `quantity`, `shop_name`) VALUES
(1, 0, 'Blue Sk-G39'),
(2, 5, 'Towhid-G56'),
(11, 4, 'Kababa'),
(22, 0, 'Towhid-G56'),
(52, 3, 'Towhid-G56'),
(53, 20, 'Tansim-G27'),
(72, 5, 'Tansim-G8'),
(73, 7, 'KH-G23'),
(74, 3, 'Tansim-G8'),
(75, 6, 'Towhid-G56'),
(76, 4, 'Tansim-G30'),
(77, 3, 'KH-G23'),
(78, 10, 'Towhid-G56'),
(79, 5, 'KH-G23'),
(80, 8, 'Tansim-G28'),
(81, 7, 'Tansim-G30'),
(82, 10, 'Tansim-G30'),
(83, 5, 'Tansim-G30'),
(84, 3, 'Tansim-G30'),
(85, 7, 'Towhid-G56'),
(86, 7, 'Tansim-G8'),
(87, 3, 'Tansim-G28'),
(88, 6, 'Tansim-G8'),
(89, 9, 'Tansim-G27'),
(90, 8, 'Tansim-G30'),
(91, 8, 'Tansim-G28'),
(92, 3, 'KH-G23'),
(93, 9, 'Tansim-G30'),
(94, 4, 'Tansim-G27'),
(95, 7, 'KH-G23'),
(96, 5, 'Towhid-G56'),
(97, 6, 'Tansim-G27'),
(98, 11, 'Tansim-G28'),
(99, 4, 'Tansim-G8'),
(100, 14, 'KH-G23'),
(101, 5, 'Tansim-G30'),
(102, 9, 'Towhid-G56'),
(103, 10, 'Tansim-G27'),
(104, 5, 'Tansim-G8'),
(105, 1, 'Tansim-G8'),
(106, 6, 'Towhid-G56'),
(107, 6, 'Towhid-G56'),
(108, 8, 'Towhid-G56'),
(109, 4, 'Tansim-G28'),
(110, 14, 'Towhid-G56'),
(111, 7, 'Tansim-G8'),
(112, 12, 'Tansim-G28'),
(113, 5, 'Tansim-G28'),
(114, 4, 'Tansim-G30'),
(115, 8, 'Tansim-G30'),
(116, 4, 'Tansim-G27'),
(117, 10, 'Towhid-G56'),
(118, 10, 'Tansim-G28'),
(119, 4, 'Tansim-G8'),
(120, 14, 'Tansim-G28'),
(121, 5, 'Tansim-G8'),
(122, 5, 'Tansim-G27'),
(123, 5, 'KH-G23'),
(124, 13, 'Tansim-G8'),
(125, 4, 'KH-G23'),
(126, 9, 'Tansim-G28'),
(127, 8, 'Tansim-G8');

-- sales: 120 row(s)
INSERT INTO `sales` (`id`, `sale_date`, `payment_method`, `customer_reference`, `created_at`, `user_id`, `shop_name`) VALUES
(1, '2026-09-28 00:00:00', 'Cash', NULL, '2026-09-28 16:48:47', NULL, 'Delivarance Church Store'),
(2, '2026-09-28 00:00:00', 'Cash', 'Johnny', '2026-09-28 16:49:30', NULL, 'Delivarance Church Store'),
(3, '2026-09-28 00:00:00', 'Cash', 'Johnny', '2026-09-28 17:29:05', NULL, 'Delivarance Church Store'),
(10, '2026-09-28 00:00:00', 'Cash', 'James', '2026-09-28 21:13:52', 49, 'Delivarance Church Store'),
(11, '2026-09-28 00:00:00', 'Cash', 'James', '2026-09-28 21:41:32', 49, 'Towhid-G56'),
(14, '2026-09-28 00:00:00', 'Cash', NULL, '2026-09-28 22:33:41', 1, 'Delivarance Church Store'),
(15, '2026-09-29 00:00:00', 'Cash', 'William Ruto', '2026-09-29 09:50:01', 49, 'Tansim-G27'),
(16, '2026-09-29 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV15629-STORE', '2026-09-29 10:45:51', 2, 'Delivarance Church Store'),
(17, '2026-03-07 00:00:00', 'Other', 'PREVIEW-SAMPLE-INV15629-SHOP', '2026-09-29 10:45:51', 13, 'Tansim-G28'),
(18, '2026-05-02 00:00:00', 'Card', 'PREVIEW-SAMPLE-INV16943-STORE', '2026-09-29 10:45:51', 1, 'Delivarance Church Store'),
(19, '2026-09-29 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV16943-SHOP', '2026-09-29 10:45:51', 2, 'Tansim-G28'),
(20, '2026-09-29 00:00:00', 'Other', 'PREVIEW-SAMPLE-INV18175-STORE', '2026-09-29 10:45:51', 49, 'Delivarance Church Store'),
(21, '2026-08-24 00:00:00', 'Other', 'PREVIEW-SAMPLE-INV18175-SHOP', '2026-09-29 10:45:51', 1, 'Tansim-G30'),
(22, '2026-07-27 00:00:00', 'Other', 'PREVIEW-SAMPLE-INV18392-STORE', '2026-09-29 10:45:51', 2, 'Delivarance Church Store'),
(23, '2026-09-06 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV18392-SHOP', '2026-09-29 10:45:51', 13, 'Tansim-G27'),
(24, '2026-09-29 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV19068-STORE', '2026-09-29 10:45:51', 1, 'Delivarance Church Store'),
(25, '2026-09-29 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV19068-SHOP', '2026-09-29 10:45:51', 1, 'Tansim-G30'),
(26, '2026-09-29 00:00:00', 'Other', 'PREVIEW-SAMPLE-INV19745-STORE', '2026-09-29 10:45:51', 1, 'Delivarance Church Store'),
(27, '2026-09-29 00:00:00', 'Card', 'PREVIEW-SAMPLE-INV19745-SHOP', '2026-09-29 10:45:51', 2, 'Tansim-G28'),
(28, '2026-08-30 00:00:00', 'Cash', 'PREVIEW-SAMPLE-INV20583-STORE', '2026-09-29 10:45:51', 1, 'Delivarance Church Store'),
(29, '2026-01-08 00:00:00', 'Cash', 'PREVIEW-SAMPLE-INV20583-SHOP', '2026-09-29 10:45:51', 13, 'Tansim-G8'),
(30, '2026-04-22 00:00:00', 'Card', 'PREVIEW-SAMPLE-INV21164-STORE', '2026-09-29 10:45:51', 49, 'Delivarance Church Store'),
(31, '2026-05-16 00:00:00', 'Card', 'PREVIEW-SAMPLE-INV21164-SHOP', '2026-09-29 10:45:51', 13, 'KH-G23'),
(32, '2026-03-23 00:00:00', 'Card', 'PREVIEW-SAMPLE-INV21456-STORE', '2026-09-29 10:45:51', 2, 'Delivarance Church Store'),
(33, '2026-06-15 00:00:00', 'Cash', 'PREVIEW-SAMPLE-INV21456-SHOP', '2026-09-29 10:45:51', 49, 'Tansim-G8'),
(34, '2026-07-29 00:00:00', 'Other', 'PREVIEW-SAMPLE-INV22183-STORE', '2026-09-29 10:45:51', 49, 'Delivarance Church Store'),
(35, '2026-09-29 00:00:00', 'Other', 'PREVIEW-SAMPLE-INV22183-SHOP', '2026-09-29 10:45:51', 2, 'Tansim-G27'),
(36, '2026-09-29 00:00:00', 'Other', 'PREVIEW-SAMPLE-INV23891-STORE', '2026-09-29 10:45:51', 49, 'Delivarance Church Store'),
(37, '2026-09-29 00:00:00', 'Card', 'PREVIEW-SAMPLE-INV23891-SHOP', '2026-09-29 10:45:51', 2, 'KH-G23'),
(38, '2026-09-29 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV24691-STORE', '2026-09-29 10:45:51', 1, 'Delivarance Church Store'),
(39, '2026-09-29 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV24691-SHOP', '2026-09-29 10:45:51', 49, 'Tansim-G30'),
(40, '2026-05-19 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV25173-STORE', '2026-09-29 10:45:51', 1, 'Delivarance Church Store'),
(41, '2026-09-29 00:00:00', 'Cash', 'PREVIEW-SAMPLE-INV25173-SHOP', '2026-09-29 10:45:51', 49, 'Tansim-G8'),
(42, '2026-08-25 00:00:00', 'Card', 'PREVIEW-SAMPLE-INV25947-STORE', '2026-09-29 10:45:51', 2, 'Delivarance Church Store'),
(43, '2026-06-15 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV25947-SHOP', '2026-09-29 10:45:51', 2, 'Towhid-G56'),
(44, '2026-06-30 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV27435-STORE', '2026-09-29 10:45:51', 2, 'Delivarance Church Store'),
(45, '2026-07-26 00:00:00', 'Other', 'PREVIEW-SAMPLE-INV27435-SHOP', '2026-09-29 10:45:51', 2, 'Towhid-G56'),
(46, '2026-01-12 00:00:00', 'Other', 'PREVIEW-SAMPLE-INV28147-STORE', '2026-09-29 10:45:51', 2, 'Delivarance Church Store'),
(47, '2026-05-14 00:00:00', 'Other', 'PREVIEW-SAMPLE-INV28147-SHOP', '2026-09-29 10:45:51', 1, 'Towhid-G56'),
(48, '2026-09-29 00:00:00', 'Cash', 'PREVIEW-SAMPLE-INV29684-STORE', '2026-09-29 10:45:51', 2, 'Delivarance Church Store'),
(49, '2025-12-11 00:00:00', 'Cash', 'PREVIEW-SAMPLE-INV29684-SHOP', '2026-09-29 10:45:51', 49, 'Tansim-G30'),
(50, '2026-07-03 00:00:00', 'Cash', 'PREVIEW-SAMPLE-INV30152-STORE', '2026-09-29 10:45:51', 13, 'Delivarance Church Store'),
(51, '2026-08-15 00:00:00', 'Card', 'PREVIEW-SAMPLE-INV30152-SHOP', '2026-09-29 10:45:51', 1, 'Tansim-G28'),
(52, '2026-05-16 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV31872-STORE', '2026-09-29 10:45:51', 13, 'Delivarance Church Store'),
(53, '2026-09-29 00:00:00', 'Other', 'PREVIEW-SAMPLE-INV31872-SHOP', '2026-09-29 10:45:51', 2, 'KH-G23'),
(54, '2026-03-14 00:00:00', 'Other', 'PREVIEW-SAMPLE-INV32518-STORE', '2026-09-29 10:45:51', 1, 'Delivarance Church Store'),
(55, '2026-09-29 00:00:00', 'Other', 'PREVIEW-SAMPLE-INV32518-SHOP', '2026-09-29 10:45:51', 49, 'Tansim-G27'),
(56, '2025-11-06 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV33945-STORE', '2026-09-29 10:45:51', 13, 'Delivarance Church Store'),
(57, '2025-11-29 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV33945-SHOP', '2026-09-29 10:45:51', 49, 'Towhid-G56'),
(58, '2026-09-13 00:00:00', 'Card', 'PREVIEW-SAMPLE-INV34479-STORE', '2026-09-29 10:45:51', 49, 'Delivarance Church Store'),
(59, '2026-07-14 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV34479-SHOP', '2026-09-29 10:45:51', 13, 'Tansim-G8'),
(60, '2026-08-26 00:00:00', 'Card', 'PREVIEW-SAMPLE-INV35126-STORE', '2026-09-29 10:45:51', 2, 'Delivarance Church Store'),
(61, '2026-09-09 00:00:00', 'Cash', 'PREVIEW-SAMPLE-INV35126-SHOP', '2026-09-29 10:45:51', 2, 'KH-G23'),
(62, '2026-09-14 00:00:00', 'Cash', 'PREVIEW-SAMPLE-INV36784-STORE', '2026-09-29 10:45:51', 49, 'Delivarance Church Store'),
(63, '2026-09-06 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV36784-SHOP', '2026-09-29 10:45:51', 13, 'Tansim-G28'),
(64, '2026-09-24 00:00:00', 'Card', 'PREVIEW-SAMPLE-INV38429-STORE', '2026-09-29 10:45:51', 49, 'Delivarance Church Store'),
(65, '2026-03-18 00:00:00', 'Other', 'PREVIEW-SAMPLE-INV38429-SHOP', '2026-09-29 10:45:51', 1, 'Tansim-G30'),
(66, '2026-09-29 00:00:00', 'Cash', 'PREVIEW-SAMPLE-INV39064-STORE', '2026-09-29 10:45:51', 13, 'Delivarance Church Store'),
(67, '2026-09-23 00:00:00', 'Cash', 'PREVIEW-SAMPLE-INV39064-SHOP', '2026-09-29 10:45:51', 49, 'Tansim-G28'),
(68, '2026-07-07 00:00:00', 'Cash', 'PREVIEW-SAMPLE-INV39725-STORE', '2026-09-29 10:45:51', 13, 'Delivarance Church Store'),
(69, '2026-07-27 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV39725-SHOP', '2026-09-29 10:45:51', 1, 'Tansim-G8'),
(70, '2026-09-16 00:00:00', 'Other', 'PREVIEW-SAMPLE-INV40163-STORE', '2026-09-29 10:45:51', 2, 'Delivarance Church Store'),
(71, '2026-09-11 00:00:00', 'Cash', 'PREVIEW-SAMPLE-INV40163-SHOP', '2026-09-29 10:45:51', 1, 'Tansim-G30'),
(72, '2026-09-03 00:00:00', 'Other', 'PREVIEW-SAMPLE-INV41438-STORE', '2026-09-29 10:45:51', 1, 'Delivarance Church Store'),
(73, '2026-01-04 00:00:00', 'Cash', 'PREVIEW-SAMPLE-INV41438-SHOP', '2026-09-29 10:45:51', 13, 'Tansim-G8'),
(74, '2026-09-19 00:00:00', 'Cash', 'PREVIEW-SAMPLE-INV41752-STORE', '2026-09-29 10:45:51', 2, 'Delivarance Church Store'),
(75, '2026-04-30 00:00:00', 'Other', 'PREVIEW-SAMPLE-INV41752-SHOP', '2026-09-29 10:45:51', 49, 'Tansim-G30'),
(76, '2026-09-29 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV42561-STORE', '2026-09-29 10:45:51', 49, 'Delivarance Church Store'),
(77, '2026-09-29 00:00:00', 'Card', 'PREVIEW-SAMPLE-INV42561-SHOP', '2026-09-29 10:45:51', 2, 'Tansim-G8'),
(78, '2026-09-29 00:00:00', 'Other', 'PREVIEW-SAMPLE-INV43286-STORE', '2026-09-29 10:45:51', 1, 'Delivarance Church Store'),
(79, '2026-09-29 00:00:00', 'Other', 'PREVIEW-SAMPLE-INV43286-SHOP', '2026-09-29 10:45:51', 1, 'Tansim-G30'),
(80, '2026-01-10 00:00:00', 'Other', 'PREVIEW-SAMPLE-INV44671-STORE', '2026-09-29 10:45:51', 13, 'Delivarance Church Store'),
(81, '2026-09-29 00:00:00', 'Card', 'PREVIEW-SAMPLE-INV44671-SHOP', '2026-09-29 10:45:51', 13, 'Tansim-G27'),
(82, '2026-07-07 00:00:00', 'Card', 'PREVIEW-SAMPLE-INV45139-STORE', '2026-09-29 10:45:51', 1, 'Delivarance Church Store'),
(83, '2026-09-20 00:00:00', 'Card', 'PREVIEW-SAMPLE-INV45139-SHOP', '2026-09-29 10:45:51', 13, 'Towhid-G56'),
(84, '2026-08-20 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV46182-STORE', '2026-09-29 10:45:51', 13, 'Delivarance Church Store'),
(85, '2026-08-30 00:00:00', 'Cash', 'PREVIEW-SAMPLE-INV46182-SHOP', '2026-09-29 10:45:51', 13, 'Towhid-G56'),
(86, '2026-05-31 00:00:00', 'Cash', 'PREVIEW-SAMPLE-INV46825-STORE', '2026-09-29 10:45:51', 2, 'Delivarance Church Store'),
(87, '2026-07-07 00:00:00', 'Cash', 'PREVIEW-SAMPLE-INV46825-SHOP', '2026-09-29 10:45:51', 13, 'Tansim-G8'),
(88, '2026-05-01 00:00:00', 'Other', 'PREVIEW-SAMPLE-INV47093-STORE', '2026-09-29 10:45:51', 49, 'Delivarance Church Store'),
(89, '2026-03-30 00:00:00', 'Other', 'PREVIEW-SAMPLE-INV47093-SHOP', '2026-09-29 10:45:51', 1, 'KH-G23'),
(90, '2026-09-29 00:00:00', 'Card', 'PREVIEW-SAMPLE-INV47639-STORE', '2026-09-29 10:45:51', 2, 'Delivarance Church Store'),
(91, '2026-09-29 00:00:00', 'Card', 'PREVIEW-SAMPLE-INV47639-SHOP', '2026-09-29 10:45:51', 1, 'Towhid-G56'),
(92, '2026-09-29 00:00:00', 'Cash', 'PREVIEW-SAMPLE-INV48271-STORE', '2026-09-29 10:45:51', 2, 'Delivarance Church Store'),
(93, '2026-09-21 00:00:00', 'Cash', 'PREVIEW-SAMPLE-INV48271-SHOP', '2026-09-29 10:45:51', 13, 'Tansim-G28'),
(94, '2026-08-06 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV48925-STORE', '2026-09-29 10:45:51', 49, 'Delivarance Church Store'),
(95, '2026-09-29 00:00:00', 'Other', 'PREVIEW-SAMPLE-INV48925-SHOP', '2026-09-29 10:45:51', 49, 'Tansim-G8'),
(96, '2026-09-29 00:00:00', 'Card', 'PREVIEW-SAMPLE-INV49736-STORE', '2026-09-29 10:45:51', 13, 'Delivarance Church Store'),
(97, '2026-09-29 00:00:00', 'Card', 'PREVIEW-SAMPLE-INV49736-SHOP', '2026-09-29 10:45:51', 13, 'Tansim-G8'),
(98, '2026-09-29 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV50627-STORE', '2026-09-29 10:45:51', 13, 'Delivarance Church Store'),
(99, '2026-08-18 00:00:00', 'Other', 'PREVIEW-SAMPLE-INV50627-SHOP', '2026-09-29 10:45:51', 1, 'Towhid-G56'),
(100, '2026-09-29 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV51384-STORE', '2026-09-29 10:45:51', 13, 'Delivarance Church Store'),
(101, '2026-08-25 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV51384-SHOP', '2026-09-29 10:45:51', 49, 'Tansim-G27'),
(102, '2026-09-29 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV52849-STORE', '2026-09-29 10:45:51', 49, 'Delivarance Church Store'),
(103, '2026-09-29 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV52849-SHOP', '2026-09-29 10:45:51', 13, 'Tansim-G30'),
(104, '2026-09-29 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV53217-STORE', '2026-09-29 10:45:51', 13, 'Delivarance Church Store'),
(105, '2026-09-29 00:00:00', 'Other', 'PREVIEW-SAMPLE-INV53217-SHOP', '2026-09-29 10:45:51', 1, 'KH-G23'),
(106, '2026-09-29 00:00:00', 'Other', 'PREVIEW-SAMPLE-INV54127-STORE', '2026-09-29 10:45:51', 1, 'Delivarance Church Store'),
(107, '2026-09-29 00:00:00', 'Cash', 'PREVIEW-SAMPLE-INV54127-SHOP', '2026-09-29 10:45:51', 13, 'Tansim-G28'),
(108, '2026-09-29 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV54831-STORE', '2026-09-29 10:45:51', 13, 'Delivarance Church Store'),
(109, '2026-08-04 00:00:00', 'Other', 'PREVIEW-SAMPLE-INV54831-SHOP', '2026-09-29 10:45:51', 49, 'Tansim-G28'),
(110, '2026-09-29 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV55763-STORE', '2026-09-29 10:45:51', 2, 'Delivarance Church Store'),
(111, '2026-09-26 00:00:00', 'Card', 'PREVIEW-SAMPLE-INV55763-SHOP', '2026-09-29 10:45:51', 2, 'KH-G23'),
(112, '2026-09-28 00:00:00', 'Card', 'PREVIEW-SAMPLE-INV56938-STORE', '2026-09-29 10:45:51', 1, 'Delivarance Church Store'),
(113, '2026-09-28 00:00:00', 'Cash', 'PREVIEW-SAMPLE-INV56938-SHOP', '2026-09-29 10:45:51', 49, 'Tansim-G28'),
(114, '2026-09-13 00:00:00', 'Other', 'PREVIEW-SAMPLE-INV57294-STORE', '2026-09-29 10:45:51', 2, 'Delivarance Church Store'),
(115, '2026-09-13 00:00:00', 'Other', 'PREVIEW-SAMPLE-INV57294-SHOP', '2026-09-29 10:45:51', 49, 'Tansim-G30'),
(116, '2026-09-04 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV58046-STORE', '2026-09-29 10:45:51', 13, 'Delivarance Church Store'),
(117, '2026-09-03 00:00:00', 'Card', 'PREVIEW-SAMPLE-INV58046-SHOP', '2026-09-29 10:45:51', 2, 'Towhid-G56'),
(118, '2026-09-29 00:00:00', 'Cash', 'PREVIEW-SAMPLE-INV58942-STORE', '2026-09-29 10:45:51', 1, 'Delivarance Church Store'),
(119, '2026-09-28 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV58942-SHOP', '2026-09-29 10:45:51', 1, 'Tansim-G27'),
(120, '2026-08-29 00:00:00', 'Other', 'PREVIEW-SAMPLE-INV60418-STORE', '2026-09-29 10:45:51', 1, 'Delivarance Church Store'),
(121, '2026-09-16 00:00:00', 'Card', 'PREVIEW-SAMPLE-INV60418-SHOP', '2026-09-29 10:45:51', 2, 'KH-G23'),
(122, '2026-09-03 00:00:00', 'Cash', 'PREVIEW-SAMPLE-INV61052-STORE', '2026-09-29 10:45:51', 1, 'Delivarance Church Store'),
(123, '2026-09-14 00:00:00', 'Cash', 'PREVIEW-SAMPLE-INV61052-SHOP', '2026-09-29 10:45:51', 2, 'Tansim-G8'),
(124, '2026-09-24 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV61784-STORE', '2026-09-29 10:45:51', 49, 'Delivarance Church Store'),
(125, '2026-09-24 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV61784-SHOP', '2026-09-29 10:45:51', 49, 'Tansim-G8'),
(126, '2026-09-28 00:00:00', 'Cash', 'PREVIEW-SAMPLE-INV62173-STORE', '2026-09-29 10:45:51', 2, 'Delivarance Church Store'),
(127, '2026-09-29 00:00:00', 'Paybill', 'PREVIEW-SAMPLE-INV62173-SHOP', '2026-09-29 10:45:51', 2, 'Towhid-G56'),
(128, '2026-09-29 00:00:00', 'Cash', 'Edna', '2026-09-29 11:10:17', 96, 'Tansim-G8');

-- sale_items: 120 row(s)
INSERT INTO `sale_items` (`id`, `sale_id`, `product_id`, `quantity`, `unit_price`, `total`) VALUES
(1, 1, 28, 1, '2500.00', '2500.00'),
(2, 2, 28, 1, '2500.00', '2500.00'),
(3, 3, 28, 2, '2500.00', '5000.00'),
(10, 10, 52, 1, '850.00', '850.00'),
(11, 11, 22, 2, '1100.00', '2200.00'),
(14, 14, 52, 3, '850.00', '2550.00'),
(15, 15, 53, 10, '875.00', '8750.00'),
(16, 16, 112, 4, '725.00', '2900.00'),
(17, 17, 112, 4, '725.00', '2900.00'),
(18, 18, 113, 3, '975.00', '2925.00'),
(19, 19, 113, 6, '975.00', '5850.00'),
(20, 20, 114, 4, '825.00', '3300.00'),
(21, 21, 114, 2, '825.00', '1650.00'),
(22, 22, 97, 3, '700.00', '2100.00'),
(23, 23, 97, 1, '700.00', '700.00'),
(24, 24, 115, 10, '925.00', '9250.00'),
(25, 25, 115, 8, '925.00', '7400.00'),
(26, 26, 98, 3, '900.00', '2700.00'),
(27, 27, 98, 3, '900.00', '2700.00'),
(28, 28, 99, 1, '850.00', '850.00'),
(29, 29, 99, 3, '850.00', '2550.00'),
(30, 30, 100, 3, '600.00', '1800.00'),
(31, 31, 100, 8, '600.00', '4800.00'),
(32, 32, 72, 2, '750.00', '1500.00'),
(33, 33, 72, 2, '750.00', '1500.00'),
(34, 34, 116, 4, '775.00', '3100.00'),
(35, 35, 116, 4, '775.00', '3100.00'),
(36, 36, 73, 5, '950.00', '4750.00'),
(37, 37, 73, 3, '950.00', '2850.00'),
(38, 38, 101, 4, '1250.00', '5000.00'),
(39, 39, 101, 2, '1250.00', '2500.00'),
(40, 40, 74, 2, '850.00', '1700.00'),
(41, 41, 74, 3, '850.00', '2550.00'),
(42, 42, 117, 7, '1100.00', '7700.00'),
(43, 43, 117, 2, '1100.00', '2200.00'),
(44, 44, 75, 7, '1050.00', '7350.00'),
(45, 45, 75, 5, '1050.00', '5250.00'),
(46, 46, 102, 4, '800.00', '3200.00'),
(47, 47, 102, 3, '800.00', '2400.00'),
(48, 48, 76, 3, '900.00', '2700.00'),
(49, 49, 76, 2, '900.00', '1800.00'),
(50, 50, 118, 5, '700.00', '3500.00'),
(51, 51, 118, 4, '700.00', '2800.00'),
(52, 52, 77, 1, '1050.00', '1050.00'),
(53, 53, 77, 1, '1050.00', '1050.00'),
(54, 54, 103, 7, '775.00', '5425.00'),
(55, 55, 103, 3, '775.00', '2325.00'),
(56, 56, 78, 5, '800.00', '4000.00'),
(57, 57, 78, 3, '800.00', '2400.00'),
(58, 58, 119, 1, '1300.00', '1300.00'),
(59, 59, 119, 1, '1300.00', '1300.00'),
(60, 60, 79, 4, '1000.00', '4000.00'),
(61, 61, 79, 3, '1000.00', '3000.00'),
(62, 62, 80, 6, '750.00', '4500.00'),
(63, 63, 80, 5, '750.00', '3750.00'),
(64, 64, 81, 3, '1000.00', '3000.00'),
(65, 65, 81, 3, '1000.00', '3000.00'),
(66, 66, 120, 6, '850.00', '5100.00'),
(67, 67, 120, 3, '850.00', '2550.00'),
(68, 68, 104, 1, '900.00', '900.00'),
(69, 69, 104, 3, '900.00', '2700.00'),
(70, 70, 82, 6, '925.00', '5550.00'),
(71, 71, 82, 5, '925.00', '4625.00'),
(72, 72, 121, 3, '1000.00', '3000.00'),
(73, 73, 121, 5, '1000.00', '5000.00'),
(74, 74, 83, 4, '825.00', '3300.00'),
(75, 75, 83, 2, '825.00', '1650.00'),
(76, 76, 105, 7, '1050.00', '7350.00'),
(77, 77, 105, 6, '1050.00', '6300.00'),
(78, 78, 84, 4, '900.00', '3600.00'),
(79, 79, 84, 2, '900.00', '1800.00'),
(80, 80, 122, 4, '800.00', '3200.00'),
(81, 81, 122, 2, '800.00', '1600.00'),
(82, 82, 85, 8, '1150.00', '9200.00'),
(83, 83, 85, 8, '1150.00', '9200.00'),
(84, 84, 106, 4, '875.00', '3500.00'),
(85, 85, 106, 1, '875.00', '875.00'),
(86, 86, 86, 4, '875.00', '3500.00'),
(87, 87, 86, 3, '875.00', '2625.00'),
(88, 88, 123, 5, '1200.00', '6000.00'),
(89, 89, 123, 3, '1200.00', '3600.00'),
(90, 90, 107, 5, '850.00', '4250.00'),
(91, 91, 107, 3, '850.00', '2550.00'),
(92, 92, 87, 1, '700.00', '700.00'),
(93, 93, 87, 1, '700.00', '700.00'),
(94, 94, 124, 5, '825.00', '4125.00'),
(95, 95, 124, 3, '825.00', '2475.00'),
(96, 96, 88, 5, '1050.00', '5250.00'),
(97, 97, 88, 3, '1050.00', '3150.00'),
(98, 98, 108, 6, '1150.00', '6900.00'),
(99, 99, 108, 2, '1150.00', '2300.00'),
(100, 100, 89, 3, '725.00', '2175.00'),
(101, 101, 89, 7, '725.00', '5075.00'),
(102, 102, 90, 3, '1150.00', '3450.00'),
(103, 103, 90, 2, '1150.00', '2300.00'),
(104, 104, 125, 3, '925.00', '2775.00'),
(105, 105, 125, 1, '925.00', '925.00'),
(106, 106, 91, 3, '925.00', '2775.00'),
(107, 107, 91, 11, '925.00', '10175.00'),
(108, 108, 109, 4, '1200.00', '4800.00'),
(109, 109, 109, 2, '1200.00', '2400.00'),
(110, 110, 92, 1, '800.00', '800.00'),
(111, 111, 92, 2, '800.00', '1600.00'),
(112, 112, 126, 5, '1125.00', '5625.00'),
(113, 113, 126, 5, '1125.00', '5625.00'),
(114, 114, 93, 6, '1100.00', '6600.00'),
(115, 115, 93, 7, '1100.00', '7700.00'),
(116, 116, 110, 4, '775.00', '3100.00'),
(117, 117, 110, 3, '775.00', '2325.00'),
(118, 118, 94, 6, '975.00', '5850.00'),
(119, 119, 94, 4, '975.00', '3900.00'),
(120, 120, 95, 8, '1050.00', '8400.00'),
(121, 121, 95, 2, '1050.00', '2100.00'),
(122, 122, 127, 5, '1000.00', '5000.00'),
(123, 123, 127, 2, '1000.00', '2000.00'),
(124, 124, 111, 5, '1025.00', '5125.00'),
(125, 125, 111, 6, '1025.00', '6150.00'),
(126, 126, 96, 3, '850.00', '2550.00'),
(127, 127, 96, 5, '850.00', '4250.00'),
(128, 128, 105, 8, '1050.00', '8400.00');

SET FOREIGN_KEY_CHECKS = 1;