INSERT INTO sources (slug, display_name, type, commission_rate, is_active)
VALUES ('aliexpress', 'AliExpress Affiliate', 'manual', '7-9%', 1)
ON DUPLICATE KEY UPDATE display_name = VALUES(display_name);

INSERT INTO products (source, external_id, name, brand, category, price, currency, country, description, images_json, rating, stock_status, affiliate_url, fetched_at, expires_at)
VALUES
('aliexpress', '1005011592959182', 'Ali Plus 2026 SS Sailor Maxi Kids Cotton Outfits Embroidery Removable White Collar Girls Boys Matching Clothes', 'AliExpress', 'kids-fashion', 30.55, 'USD', 'BD', 'Ali Plus 2026 SS Sailor Maxi Kids Cotton Outfits Embroidery Removable White Collar Girls Boys Matching Clothes', '["https://ae-pic-a1.aliexpress-media.com/kf/S9d3d5c2c46d64137be5ee928dfa04c6bT.jpg"]', 4.71, 'in_stock', 'https://s.click.aliexpress.com/e/_c3Llk2ht', '2026-08-04 16:21:02', '2026-09-03 16:21:02'),
('aliexpress', '1005011573219689', 'AS SS26 Robe Collection Floral Printing Girls Robe Smocking Dress Patchwork Boys Familly Match Clothing', 'AliExpress', 'kids-fashion', 23.9, 'USD', 'BD', 'AS SS26 Robe Collection Floral Printing Girls Robe Smocking Dress Patchwork Boys Familly Match Clothing', '["https://ae-pic-a1.aliexpress-media.com/kf/S8f9442dbbafc4f4387d9b128b2c79a20j.jpg"]', 4.5, 'in_stock', 'https://s.click.aliexpress.com/e/_c4aPi0R9', '2026-08-04 16:21:02', '2026-09-03 16:21:02'),
('aliexpress', '1005011584716206', 'Ali Plus SS26 cotton cherries embroidered collection  baby boys girls pajama and nightgown', 'AliExpress', 'kids-fashion', 23.02, 'USD', 'BD', 'Ali Plus SS26 cotton cherries embroidered collection  baby boys girls pajama and nightgown', '["https://ae-pic-a1.aliexpress-media.com/kf/S4661eaec57a64d4592361fabdf8de63d3.jpg"]', 4.85, 'in_stock', 'https://s.click.aliexpress.com/e/_c3hrjrIX', '2026-08-04 16:21:02', '2026-09-03 16:21:02'),
('aliexpress', '1005011580425861', 'AS New Kids Shoes Children Beige Shoes Baby Boys Leather Shoes Toddler Princess Flats Girls Oxford Fashion Platform Mary Jane', 'AliExpress', 'kids-fashion', 26.79, 'USD', 'BD', 'AS New Kids Shoes Children Beige Shoes Baby Boys Leather Shoes Toddler Princess Flats Girls Oxford Fashion Platform Mary Jane', '["https://ae-pic-a1.aliexpress-media.com/kf/Sb9422cb296ea4777955c0b7028cddbffI.jpg"]', 4.75, 'in_stock', 'https://s.click.aliexpress.com/e/_c4M4JdSJ', '2026-08-04 16:21:02', '2026-09-03 16:21:02'),
('aliexpress', '1005011587892016', 'AS SS26 Cotton Striped Family Matching Collection kids Pjs Rompers Sets children pajamas nightgown', 'AliExpress', 'kids-fashion', 20.78, 'USD', 'BD', 'AS SS26 Cotton Striped Family Matching Collection kids Pjs Rompers Sets children pajamas nightgown', '["https://ae-pic-a1.aliexpress-media.com/kf/S54904d0211fe40389c040621ab087d14e.jpg"]', 5.0, 'in_stock', 'https://s.click.aliexpress.com/e/_c3ZZqruT', '2026-08-04 16:21:02', '2026-09-03 16:21:02'),
('aliexpress', '1005011603428597', 'Ali Co SS26  cotton soft kids set summer boys girls fashion casual clothing pjs baby girl romper footie teen girl dress', 'AliExpress', 'kids-fashion', 20.44, 'USD', 'BD', 'Ali Co SS26  cotton soft kids set summer boys girls fashion casual clothing pjs baby girl romper footie teen girl dress', '["https://ae-pic-a1.aliexpress-media.com/kf/S149c61048d034a4c9db4b519039d1eccu.jpg"]', 4.75, 'in_stock', 'https://s.click.aliexpress.com/e/_c3xyjEDh', '2026-08-04 16:21:02', '2026-09-03 16:21:02'),
('aliexpress', '1005011587019875', 'Ali Co SS26 Green Denim collection Cotton boys girls clothing dress skirt shirt and overalls-RESTOCK COMING EARLY MAY', 'AliExpress', 'kids-fashion', 20.34, 'USD', 'BD', 'Ali Co SS26 Green Denim collection Cotton boys girls clothing dress skirt shirt and overalls-RESTOCK COMING EARLY MAY', '["https://ae-pic-a1.aliexpress-media.com/kf/Sd12eb21e34344b8c8d42b4abfdfd2a39w.png"]', 4.84, 'in_stock', 'https://s.click.aliexpress.com/e/_c2xyy19V', '2026-08-04 16:21:02', '2026-09-03 16:21:02'),
('aliexpress', '1005011915072572', 'Summer Baby Clothes Hollow Out Turn-down Collar Knitted Sweater Cardigan Shorts Set Baby Sweater Two-piece Set Dgukym', 'AliExpress', 'kids-fashion', 20.03, 'USD', 'BD', 'Summer Baby Clothes Hollow Out Turn-down Collar Knitted Sweater Cardigan Shorts Set Baby Sweater Two-piece Set Dgukym', '["https://ae-pic-a1.aliexpress-media.com/kf/Se60d310ce2624bf596ddcae9d6281d77i.jpg"]', 5.0, 'in_stock', 'https://s.click.aliexpress.com/e/_c3NXTUPd', '2026-08-04 16:21:02', '2026-09-03 16:21:02')
ON DUPLICATE KEY UPDATE price = VALUES(price), affiliate_url = VALUES(affiliate_url), fetched_at = VALUES(fetched_at), expires_at = VALUES(expires_at);
