inserting_data_ecommerce_database.sql

-- Inserting data into the Ecommerce Database

INSERT INTO customers (first_name, middle_name, last_name, ssn, birth_date, phone, email, address) VALUES
	('JOHN', 'ROBERT', 'DOE', '123456789', '1990-05-15', '5551234567', 'JOHN.DOE@EXAMPLE.COM', '123 MAIN ST, APT 4B, NEW YORK, NY 12345'),
    ('JANE', 'ALICE', 'SMITH', '987654321', '1985-08-20', '5559876543', 'JANE.SMITH@EXAMPLE.COM', '456 ELM ST, APT 2A, LOS ANGELES, CA 54321'),
    ('MICHAEL', 'JAMES', 'JOHNSON', '456123789', '1992-03-10', '5553334444', 'MICHAEL.J@EXAMPLE.COM', '789 OAK ST, UNIT 10, CHICAGO, IL 98765'),
    ('EMILY', 'GRACE', 'ANDERSON', '789123456', '1988-11-05', '5557778888', 'EMILY.AND@EXAMPLE.COM', '567 BIRCH ST, APT 7C, HOUSTON, TX 45678'),
    ('WILLIAM', 'CHARLES', 'BROWN', '654987321', '1995-07-30', '5551112222', 'WILLIAM.B@EXAMPLE.COM', '234 PINE ST, APT 3D, MIAMI, FL 23456'),
    ('OLIVIA', 'SOPHIA', 'TAYLOR', '987654123', '1990-09-25', '5556667777', 'OLIVIA.T@EXAMPLE.COM', '345 CEDAR ST, UNIT 5, SAN FRANCISCO, CA 56789'),
    ('DAVID', 'JOSEPH', 'MARTINEZ', '321456987', '1986-04-14', '5555455555', 'DAVID.M@EXAMPLE.COM', '456 MAPLE ST, APT 8E, DALLAS, TX 43210'),
    ('SOPHIA', 'ELIZABETH', 'GARCIA', '159753468', '1998-01-03', '5558889999', 'SOPHIA.G@EXAMPLE.COM', '876 WALNUT ST, APT 1F, BOSTON, MA 87654'),
    ('JAMES', 'WILLIAM', 'HERNANDEZ', '753951456', '1987-06-22', '5552223333', 'JAMES.H@EXAMPLE.COM', '567 OAK ST, UNIT 2G, ATLANTA, GA 12345'),
    ('AVA', 'MIA', 'DAVIS', '854796321', '1993-12-12', '5559990000', 'AVA.D@EXAMPLE.COM', '345 ELM ST, APT 6H, SEATTLE, WA 54321'),
    ('BENJAMIN', 'ANDREW', 'WILSON', '159357456', '1989-02-18', '5554445555', 'BENJAMIN.W@EXAMPLE.COM', '123 BIRCH ST, APT 9I, DENVER, CO 98765'),
    ('ISABELLA', 'ELLA', 'LOPEZ', '951753846', '1997-10-07', '5551113333', 'ISABELLA.L@EXAMPLE.COM', '678 CEDAR ST, UNIT 3J, PHILADELPHIA, PA 23456'),
    ('ALEXANDER', 'DANIEL', 'GONZALEZ', '753951469', '1991-07-19', '5555553333', 'ALEXANDER.G@EXAMPLE.COM', '234 PINE ST, APT 5K, PHOENIX, AZ 56789'),
    ('ETHAN', 'SAMUEL', 'PEREZ', '456789123', '1996-05-28', '5556665555', 'ETHAN.P@EXAMPLE.COM', '456 MAPLE ST, UNIT 4L, SAN DIEGO, CA 43210'),
    ('MIA', 'GRACE', 'WILSON', '987654753', '1994-04-08', '5552221111', 'MIA.W@EXAMPLE.COM', '567 OAK ST, APT 7M, AUSTIN, TX 12345'),
    ('LIAM', 'MATTHEW', 'MOORE', '321789654', '1999-08-17', '5559991111', 'LIAM.M@EXAMPLE.COM', '876 WALNUT ST, UNIT 8N, LAS VEGAS, NV 87654'),
    ('CHARLOTTE', 'AVA', 'HARRIS', '753159468', '1986-09-29', '5551114444', 'CHARLOTTE.H@EXAMPLE.COM', '345 ELM ST, APT 1O, SAN ANTONIO, TX 54321'),
    ('NOAH', 'JACOB', 'KING', '852147963', '1992-01-11', '5556661111', 'NOAH.K@EXAMPLE.COM', '123 BIRCH ST, UNIT 2P, NASHVILLE, TN 23456'),
    ('ARIA', 'NORA', 'YOUNG', '951753847', '1997-03-26', '5558881111', 'ARIA.Y@EXAMPLE.COM', '678 CEDAR ST, APT 6Q, RALEIGH, NC 87654'),
    ('ELIJAH', 'WILLIAM', 'LEE', '753951468', '1988-12-03', '5555552222', 'ELIJAH.L@EXAMPLE.COM', '234 PINE ST, APT 8R, TAMPA, FL 56789'),
    ('GRACE', 'AIDEN', 'RODRIGUEZ', '987654987', '1993-05-29', '5553336666', 'GRACE.R@EXAMPLE.COM', '567 ELM ST, APT 1S, ORLANDO, FL 12345'),
    ('LUCAS', 'ELLA', 'HERNANDEZ', '159753951', '1987-04-20', '5557773333', 'LUCAS.H@EXAMPLE.COM', '234 OAK ST, APT 2T, CHARLOTTE, NC 23456'),
    ('LILY', 'JACK', 'GARCIA', '753159753', '1998-03-14', '5556665545', 'LILY.G@EXAMPLE.COM', '123 BIRCH ST, APT 3U, HOUSTON, TX 54321'),
    ('HENRY', 'MICHAEL', 'SCOTT', '852951357', '1991-02-06', '5551117777', 'HENRY.S@EXAMPLE.COM', '345 MAPLE ST, APT 4V, DENVER, CO 98765'),
    ('NORA', 'OLIVER', 'THOMAS', '987951357', '1996-06-23', '5554447777', 'NORA.T@EXAMPLE.COM', '789 PINE ST, APT 5W, MIAMI, FL 12345'),
    ('WILLIAM', 'DANIEL', 'MOORE', '951753123', '1989-07-31', '5553338888', 'WILLIAM.M@EXAMPLE.COM', '456 ELM ST, APT 6X, SAN FRANCISCO, CA 23456'),
    ('AVA', 'ETHAN', 'PEREZ', '123456987', '1995-09-04', '5555554444', 'AVA.P@EXAMPLE.COM', '567 CEDAR ST, APT 7Y, LOS ANGELES, CA 54321'),
    ('MIA', 'JAMES', 'DAVIS', '987654789', '1988-10-25', '5557779999', 'MIA.D@EXAMPLE.COM', '234 OAK ST, APT 8Z, CHICAGO, IL 87654'),
    ('NOAH', 'CHARLOTTE', 'TAYLOR', '159753789', '1997-12-15', '5559992222', 'NOAH.T@EXAMPLE.COM', '567 PINE ST, APT 9A, DALLAS, TX 12345'),
    ('EMMA', 'ELLA', 'WILLIAMS', '951753468', '1999-06-20', '5557771111', 'EMMA.W@EXAMPLE.COM', '345 ELM ST, APT 3B, RALEIGH, NC 54321');

INSERT INTO stocks (location, quantity) VALUES
    ('AISLE 1', 1500),
    ('AISLE 2', 2000),
    ('AISLE 3', 2500),
    ('AISLE 4', 1800),
    ('AISLE 5', 3000),
    ('AISLE 6', 2200);

INSERT INTO products (product_name, category, product_description, quantity, price, evaluation, registration_data, stock_id) VALUES
    ('LAPTOP HP PAVILION', 'NOTEBOOKS AND LAPTOPS', 'HIGH-PERFORMANCE LAPTOP FOR WORK AND ENTERTAINMENT', 100, 899.99, '4', '2023-05-15', 1),
    ('TP-LINK ARCHER AX6000 ROUTER', 'NETWORKS AND WIRELESS', 'DUAL-BAND WIFI 6 ROUTER FOR FAST AND STABLE CONNECTIONS', 300, 299.99, '4', '2025-07-01', 6),
    ('LOGITECH WIRELESS MOUSE', 'PERIPHERALS', 'ERGONOMIC WIRELESS MOUSE WITH PRECISION TRACKING', 200, 29.99, '5', '2023-04-20', 1),
    ('NVIDIA GEFORCE RTX 4090 TI GPU', 'HARDWARE', 'EXTREME GAMING AND RENDERING GRAPHICS CARD', 130, 1299.99, '5', '2024-06-10', 4),
    ('DELL ULTRASHARP 27" MONITOR', 'MONITORS', '27" HIGH-RESOLUTION MONITOR WITH EXCELLENT COLOR ACCURACY', 300, 299.99, '4', '2023-03-10', 1),
    ('AMD RYZEN 7 5800X CPU', 'HARDWARE', 'HIGH-PERFORMANCE CPU FOR GAMING AND PRODUCTIVITY', 150, 349.99, '5', '2023-03-01', 1),
    ('GAMING CHAIR WITH RGB LIGHTS', 'CHAIRS, GAMER TABLE AND OFFICE', 'ERGONOMIC GAMING CHAIR WITH RGB LIGHTING', 50, 249.99, '3', '2023-04-05', 1),
    ('SMART HOME SECURITY CAMERA', 'SMART HOME', 'INDOOR AND OUTDOOR SECURITY CAMERA SYSTEM', 250, 99.99, '4', '2023-04-30', 1),
    ('LOGITECH G PRO X MECHANICAL KEYBOARD', 'PERIPHERALS', 'MECHANICAL GAMING KEYBOARD WITH HOT-SWAPPABLE SWITCHES', 575, 119.99, '4', '2023-07-10', 2),
    ('SAMSUNG 1TB SSD', 'HARDWARE', 'HIGH-SPEED 1TB SSD FOR FASTER STORAGE', 75, 129.99, '3', '2023-05-05', 1),
	('SECRETLAB OMEGA SERIES GAMING CHAIR', 'CHAIRS, GAMER TABLE AND OFFICE', 'COMFORTABLE GAMING CHAIR WITH ADJUSTABLE ARMRESTS', 310, 249.99, '4', '2025-05-01', 6),
    ('RING STICK UP CAM', 'SMART HOME', 'INDOOR AND OUTDOOR SECURITY CAMERA WITH TWO-WAY AUDIO', 170, 149.99, '4', '2025-05-10', 6),
    ('SAMSUNG 8TB NVME SSD', 'HARDWARE', 'HIGH-CAPACITY NVME SSD FOR LARGE DATA STORAGE', 240, 799.99, '5', '2025-06-01', 6),
    ('SONY PLAYSTATION 5', 'VIDEO GAMES', 'NEXT-GEN GAMING CONSOLE FOR IMMERSIVE GAMEPLAY', 175, 499.99, '4', '2023-06-15', 1),
    ('RING VIDEO DOORBELL PRO 2', 'SMART HOME', 'ADVANCED VIDEO DOORBELL WITH 3D MOTION DETECTION', 220, 199.99, '4', '2024-02-10', 3),
	('RING SPOTLIGHT CAM', 'SMART HOME', 'OUTDOOR SECURITY CAMERA WITH MOTION-ACTIVATED SPOTLIGHT', 280, 199.99, '4', '2024-12-10', 5),
    ('SONY PLAYSTATION 5 PRO', 'VIDEO GAMES', 'ENHANCED GAMING CONSOLE FOR 4K GAMING', 175, 599.99, '4', '2023-10-10', 2),
    ('NETGEAR WIFI ROUTER', 'NETWORKS AND WIRELESS', 'HIGH-PERFORMANCE WIFI ROUTER FOR HOME NETWORK', 125, 79.99, '5', '2023-06-20', 1),
    ('HP OFFICEJET PRO PRINTER', 'PERIPHERALS', 'ALL-IN-ONE PRINTER FOR OFFICE NEEDS', 75, 199.99, '3', '2023-07-01', 1),
    ('APPLE MACBOOK AIR', 'NOTEBOOKS AND LAPTOPS', 'THIN AND LIGHTWEIGHT MACBOOK FOR ON-THE-GO USE', 200, 999.99, '5', '2023-07-15', 2),
    ('SAMSUNG 32" CURVED MONITOR', 'MONITORS', '32" CURVED MONITOR WITH IMMERSIVE VIEWING EXPERIENCE', 300, 349.99, '4', '2023-08-01', 2),
    ('INTEL CORE I9-12900K CPU', 'HARDWARE', 'HIGH-END CPU FOR GAMING AND PROFESSIONAL TASKS', 150, 599.99, '5', '2023-08-10', 2),
    ('AROZZI VERONA PRO V2 GAMING CHAIR', 'CHAIRS, GAMER TABLE AND OFFICE', 'RACING-STYLE GAMING CHAIR FOR MAXIMUM COMFORT', 50, 199.99, '3', '2023-09-05', 2),
    ('NEST CAM INDOOR SECURITY CAMERA', 'SMART HOME', 'INDOOR SECURITY CAMERA FOR HOME MONITORING', 250, 129.99, '4', '2023-09-10', 2),
    ('CRUCIAL MX500 2TB SSD', 'HARDWARE', '2TB SATA SSD FOR STORAGE AND PERFORMANCE', 75, 219.99, '3', '2023-10-01', 2),
    ('LINKSYS VELOP MESH WIFI SYSTEM', 'NETWORKS AND WIRELESS', 'WHOLE-HOME MESH WIFI FOR SEAMLESS CONNECTIVITY', 125, 299.99, '5', '2023-11-05', 2),
    ('CANON PIXMA PRO-100 PRINTER', 'PERIPHERALS', 'PROFESSIONAL PHOTO PRINTER FOR HIGH-QUALITY PRINTS', 100, 349.99, '4', '2023-11-10', 2),
    ('ASUS ROG STRIX SCAR 17', 'NOTEBOOKS AND LAPTOPS', 'HIGH-PERFORMANCE GAMING LAPTOP WITH 17-INCH DISPLAY', 200, 1899.99, '5', '2023-12-01', 3),
    ('RAZER NAGA X GAMING MOUSE', 'PERIPHERALS', 'LIGHTWEIGHT GAMING MOUSE WITH 16,000 DPI OPTICAL SENSOR', 80, 69.99, '4', '2023-12-10', 3),
    ('NVIDIA GEFORCE RTX 4090 GPU', 'HARDWARE', 'HIGH-END GRAPHICS CARD FOR EXTREME GAMING AND RENDERING', 180, 999.99, '5', '2024-01-10', 3),
    ('DXRACER RACING SERIES GAMING CHAIR', 'CHAIRS, GAMER TABLE AND OFFICE', 'ERGONOMIC RACING-STYLE CHAIR FOR GAMERS', 400, 279.99, '4', '2024-02-01', 3),
    ('SAMSUNG 2TB NVME SSD', 'HARDWARE', '2TB NVME SSD FOR ULTRA-FAST STORAGE', 300, 349.99, '5', '2024-03-01', 3),
    ('SONY PLAYSTATION VR 2', 'VIDEO GAMES', 'NEXT-GEN VIRTUAL REALITY HEADSET FOR IMMERSIVE GAMING', 230, 299.99, '4', '2024-03-10', 3),
    ('LINKSYS AX6000 WIFI 6 ROUTER', 'NETWORKS AND WIRELESS', 'HIGH-SPEED WIFI 6 ROUTER FOR FAST AND RELIABLE CONNECTIONS', 320, 249.99, '4', '2024-04-01', 3),
    ('EPSON ECOTANK ET-4760 PRINTER', 'PERIPHERALS', 'ECOTANK ALL-IN-ONE PRINTER WITH INK SAVINGS', 320, 399.99, '3', '2024-04-10', 3),
    ('ARLO ULTRA 2 4K SECURITY CAMERA', 'SMART HOME', '4K UHD SECURITY CAMERA WITH COLOR NIGHT VISION', 160, 249.99, '4', '2024-07-10', 4),
    ('ACER PREDATOR HELIOS 500', 'NOTEBOOKS AND LAPTOPS', 'POWERFUL GAMING LAPTOP WITH 4K DISPLAY AND RTX 3080', 150, 1999.99, '5', '2024-05-01', 4),
    ('LOGITECH G PRO WIRELESS MOUSE', 'PERIPHERALS', 'PRO-LEVEL WIRELESS GAMING MOUSE WITH HERO SENSOR', 20, 129.99, '4', '2024-05-10', 4),
    ('DELL ALIENWARE 34" CURVED MONITOR', 'MONITORS', '34" CURVED GAMING MONITOR WITH HIGH REFRESH RATE', 180, 599.99, '4', '2024-06-01', 4),
    ('SECRETLAB TITAN XL GAMING CHAIR', 'CHAIRS, GAMER TABLE AND OFFICE', 'EXTRA-LARGE GAMING CHAIR FOR ULTIMATE COMFORT', 330, 349.99, '4', '2024-07-01', 4),
    ('SAMSUNG 4TB NVME SSD', 'HARDWARE', 'HIGH-CAPACITY NVME SSD FOR DATA STORAGE', 230, 599.99, '5', '2024-08-01', 4),
    ('OCULUS QUEST 3 VR HEADSET', 'VIDEO GAMES', 'NEXT-GEN STANDALONE VR HEADSET FOR GAMING AND EXPERIENCES', 170, 349.99, '4', '2024-08-10', 4),
    ('CANON IMAGEPROGRAF PRO-1000 PRINTER', 'PERIPHERALS', 'PROFESSIONAL 12-COLOR PRINTER FOR PHOTOGRAPHERS AND ARTISTS', 180, 1199.99, '3', '2024-09-10', 4),
    ('HP ENVY X360 LAPTOP', 'NOTEBOOKS AND LAPTOPS', 'CONVERTIBLE LAPTOP WITH AMD RYZEN PROCESSOR', 220, 849.99, '4', '2024-10-01', 5),
    ('LOGITECH MX MASTER 3 MOUSE', 'PERIPHERALS', 'ADVANCED WIRELESS MOUSE FOR PRODUCTIVITY', 160, 99.99, '5', '2024-10-10', 5),
    ('ASUS TUF 27" GAMING MONITOR', 'MONITORS', '27" FULL HD GAMING MONITOR WITH HIGH REFRESH RATE', 190, 249.99, '4', '2025-04-01', 6),
    ('LG 27" 4K IPS MONITOR', 'MONITORS', '27" 4K IPS MONITOR WITH ACCURATE COLOR REPRODUCTION', 280, 299.99, '4', '2024-11-01', 5),
    ('INTEL CORE I7-12700K CPU', 'HARDWARE', 'HIGH-PERFORMANCE CPU FOR GAMING AND CONTENT CREATION', 260, 399.99, '5', '2024-11-10', 5),
    ('HERMAN MILLER AERON CHAIR', 'CHAIRS, GAMER TABLE AND OFFICE', 'ICONIC ERGONOMIC OFFICE CHAIR FOR COMFORT', 400, 1299.99, '4', '2024-12-01', 5),
    ('SANDISK 1TB SSD', 'HARDWARE', '1TB SATA SSD FOR FAST STORAGE AND PERFORMANCE', 320, 149.99, '5', '2025-01-01', 5),
	('NVIDIA GEFORCE RTX 4090 SUPER GPU', 'HARDWARE', 'SUPERCHARGED GAMING GRAPHICS CARD FOR ULTRA SETTINGS', 140, 1499.99, '5', '2025-04-10', 6),
    ('PLAYSTATION VR MEGA PACK', 'VIDEO GAMES', 'VR BUNDLE WITH GAMES AND ACCESSORIES', 310, 199.99, '4', '2025-01-10', 5),
    ('NETGEAR NIGHTHAWK AX12 ROUTER', 'NETWORKS AND WIRELESS', 'AX11000 WIFI 6 ROUTER FOR ULTRA-FAST INTERNET', 430, 399.99, '4', '2025-02-01', 5),
    ('EPSON EXPRESSION PHOTO XP-8600 PRINTER', 'PERIPHERALS', 'PHOTO PRINTER WITH CLARIA PHOTO HD INK', 340, 199.99, '3', '2025-02-10', 5),
    ('ACER PREDATOR TRITON 500', 'NOTEBOOKS AND LAPTOPS', 'THIN AND POWERFUL GAMING LAPTOP WITH RTX 3080', 300, 1699.99, '5', '2025-03-01', 6),
    ('ASUS RT-AX11000 WIFI 6E ROUTER', 'NETWORKS AND WIRELESS', 'TRI-BAND WIFI 6E ROUTER WITH FAST SPEEDS AND EXTENSIVE COVERAGE', 250, 349.99, '4', '2024-09-01', 4),
    ('RAZER DEATHADDER V2 MOUSE', 'PERIPHERALS', 'HIGH-PRECISION GAMING MOUSE WITH RAZER OPTICAL MOUSE SWITCH', 150, 59.99, '4', '2025-03-10', 6),
    ('HTC VIVE COSMOS VR HEADSET', 'VIDEO GAMES', 'HIGH-QUALITY VR HEADSET WITH PRECISE TRACKING', 180, 499.99, '4', '2025-06-10', 6),
    ('LG 34" ULTRAWIDE GAMING MONITOR', 'MONITORS', '34" ULTRAWIDE MONITOR WITH HIGH REFRESH RATE AND G-SYNC', 250, 499.99, '4', '2024-01-05', 3),
    ('CANON PIXMA PRO-10 PRINTER', 'PERIPHERALS', 'PROFESSIONAL PHOTO PRINTER WITH 10-COLOR PIGMENT INK', 220, 699.99, '3', '2025-07-10', 6);

INSERT INTO payments (payment_type) VALUES
    ('CREDIT AND DEBIT CARDS'),
    ('BANK TRANSFERS'),
    ('ECHECKS'),
    ('MOBILE PAYMENTS'),
    ('CRYPTOCURRENCY');
    
INSERT INTO orders (customer_id, order_date, order_status, order_description, shipping, payment_id) VALUES
    (29, '2023-05-15', 'PROCESSING PAYMENT', 'ORDER #001 - LAPTOP HP PAVILION 1UNI, TP-LINK ARCHER AX6000 ROUTER 1UNI, LOGITECH WIRELESS MOUSE 1UNI', 14.76, 1),
    (2, '2023-05-16', 'PROCESSING PAYMENT', 'ORDER #002 - NVIDIA GEFORCE RTX 4090 TI GPU 1UNI, AMD RYZEN 7 5800X CPU 1UNI', 12.45, 2),
    (5, '2023-05-17', 'IN PROGRESS', 'ORDER #003 - DELL ULTRASHARP 27" MONITOR 1UNI, AMD RYZEN 7 5800X CPU 1UNI', 9.82, 3),
    (4, '2023-05-18', 'SENT', 'ORDER #004 - GAMING CHAIR WITH RGB LIGHTS 1UNI', 17.33, 4),
    (5, '2023-05-19', 'DELIVERED', 'ORDER #005 - SMART HOME SECURITY CAMERA 8UNI', DEFAULT, 5),
    (8, '2023-05-20', 'PROCESSING PAYMENT', 'ORDER #006 - LOGITECH G PRO X MECHANICAL KEYBOARD 1UNI, SAMSUNG 1TB SSD 1UNI', 6.91, 1),
    (2, '2023-05-21', 'CANCELED', 'ORDER #007 - SECRETLAB OMEGA SERIES GAMING CHAIR 1UNI', 8.57, 2),
    (3, '2023-05-22', 'PROCESSING PAYMENT', 'ORDER #008 - RING STICK UP CAM 7UNI', 15.24, 3),
    (4, '2023-05-23', 'IN PROGRESS', 'ORDER #009 - SAMSUNG 8TB NVME SSD 1UNI', 11.68, 4),
    (1, '2023-05-24', 'SENT', 'ORDER #010 - SONY PLAYSTATION 5 1UNI, RING VIDEO DOORBELL PRO 2 1UNI', 18.09, 5),
    (1, '2023-05-15', 'PROCESSING PAYMENT', 'ORDER #011 - RING SPOTLIGHT CAM 5UNI', DEFAULT, 1),
    (11, '2023-05-16', 'PROCESSING PAYMENT', 'ORDER #012 - SONY PLAYSTATION 5 PRO 1UNI', 13.50, 2),
    (3, '2023-05-17', 'IN PROGRESS', 'ORDER #013 - NETGEAR WIFI ROUTER 1UNI, HP OFFICEJET PRO PRINTER 1UNI', 19.14, 3),
    (20, '2023-05-18', 'SENT', 'ORDER #014 - APPLE MACBOOK AIR 1UNI, SAMSUNG 32" CURVED MONITOR 1UNI', 4.36, 4),
    (5, '2023-05-19', 'DELIVERED', 'ORDER #015 - INTEL CORE I9-12900K CPU 1UNI, ', DEFAULT, 5),
    (16, '2023-05-20', 'PROCESSING PAYMENT', 'ORDER #016 - AROZZI VERONA PRO V2 GAMING CHAIR 1UNI', 10.75, 1),
    (1, '2023-05-21', 'CANCELED', 'ORDER #017 - NEST CAM INDOOR SECURITY CAMERA 8 UNI', 16.03, 2),
    (8, '2023-05-22', 'PROCESSING PAYMENT', 'ORDER #018 - CRUCIAL MX500 2TB SSD 2UNI', 5.29, 3),
    (29, '2023-05-23', 'IN PROGRESS', 'ORDER #019 - LINKSYS VELOP MESH WIFI SYSTEM 1UNI', 9.15, 4),
    (10, '2023-05-24', 'SENT', 'ORDER #020 - CANON PIXMA PRO-100 PRINTER 1UNI', 8.04, 5),
    (2, '2023-05-25', 'SENT', 'ORDER #021 - ASUS ROG STRIX SCAR 17 2UNI', DEFAULT, 1),
    (12, '2023-05-26', 'DELIVERED', 'ORDER #022 - RAZER NAGA X GAMING MOUSE 1UNI, NVIDIA GEFORCE RTX 4090 GPU 1UNI ', 18.76, 2),
    (26, '2023-05-27', 'PROCESSING PAYMENT', 'ORDER #023 - DXRACER RACING SERIES GAMING CHAIR 1UNI, SAMSUNG 2TB NVME SSD 1UNI ', 14.08, 3),
    (22, '2023-05-28', 'IN PROGRESS', 'ORDER #024 - SONY PLAYSTATION VR 2 1UNI', 10.91, 4),
    (15, '2023-05-29', 'SENT', 'ORDER #025 - LINKSYS AX6000 WIFI 6 ROUTER 1UNI, EPSON ECOTANK ET-4760 PRINTER 1UNI', 6.64, 5),
    (6, '2023-05-30', 'DELIVERED', 'ORDER #026 - ARLO ULTRA 2 4K SECURITY CAMERA 3UNI', 12.39, 1),
    (25, '2023-05-31', 'PROCESSING PAYMENT', 'ORDER #027 - ACER PREDATOR HELIOS 500 1UNI', DEFAULT, 2),
    (18, '2023-06-01', 'CANCELED', 'ORDER #028 - LOGITECH G PRO WIRELESS MOUSE 1UNI, DELL ALIENWARE 34" CURVED MONITOR 1UNI, SECRETLAB TITAN XL GAMING CHAIR 1UNI', 16.87, 3),
    (30, '2023-06-02', 'PROCESSING PAYMENT', 'ORDER #029 - SAMSUNG 4TB NVME SSD 1UNI', 17.62, 4),
    (4, '2023-06-03', 'PROCESSING PAYMENT', 'ORDER #030 - OCULUS QUEST 3 VR HEADSET 1UNI, CANON IMAGEPROGRAF PRO-1000 PRINTER 1UNI', 5.73, 5),
    (21, '2023-06-04', 'IN PROGRESS', 'ORDER #031 - HP ENVY X360 LAPTOP 2 UNI', 19.98, 1),
    (14, '2023-06-05', 'SENT', 'ORDER #032 - LOGITECH MX MASTER 3 MOUSE 1UNI, ASUS TUF 27" GAMING MONITOR 1UNI', DEFAULT, 2),
    (27, '2023-06-06', 'DELIVERED', 'ORDER #033 - LG 27" 4K IPS MONITOR 1UNI', 13.20, 3),
    (24, '2023-06-07', 'PROCESSING PAYMENT', 'ORDER #034 - INTEL CORE I7-12700K CPU 1UNI, HERMAN MILLER AERON CHAIR 1UNI', 11.01, 4),
    (17, '2023-06-08', 'IN PROGRESS', 'ORDER #035 - SANDISK 1TB SSD 1UNI, NVIDIA GEFORCE RTX 4090 SUPER GPU 1UNI, PLAYSTATION VR MEGA PACK 1UNI', 15.79, 5),
    (13, '2023-06-09', 'SENT', 'ORDER #036 - NETGEAR NIGHTHAWK AX12 ROUTER 2UNI, EPSON EXPRESSION PHOTO XP-8600 PRINTER 1UNI', 8.13, 1),
    (23, '2023-06-10', 'CANCELED', 'ORDER #037 - ACER PREDATOR TRITON 500 1UNI, ASUS RT-AX11000 WIFI 6E ROUTER 1UNI, RAZER DEATHADDER V2 MOUSE 1UNI', 18.44, 2),
    (28, '2023-06-11', 'PROCESSING PAYMENT', 'ORDER #038 - HTC VIVE COSMOS VR HEADSET 1UNI', 10.11, 3),
    (9, '2023-06-12', 'PROCESSING PAYMENT', 'ORDER #039 - LG 34" ULTRAWIDE GAMING MONITOR 1UNI', DEFAULT,  4),
    (19, '2023-06-13', 'IN PROGRESS', 'ORDER #040 - CANON PIXMA PRO-10 PRINTER 2UNI', 9.41, 5);
    
INSERT INTO suppliers (company_name, trading_name, ein, phone, email, address) VALUES
    ('ABC ELECTRONICS INC.', 'ABC ELECTRONICS', '123456789', '5555555512', 'INFO@ABC-ELECTRONICS.COM', '123 ELM ST, APT 2D, LOS ANGELES, CA 54321'),
    ('XYZ APPLIANCES LLC', 'XYZ APPLIANCES', '987654321', '4444444456', 'CONTACT@XYZAPPLIANCES.COM', '456 OAK AVE, APT 3C, MIAMI, FL 67890'),
    ('SMITH & CO. HARDWARE', 'SMITH HARDWARE', '246813579', '3333333389', 'SALES@SMITH-HARDWARE.COM', '789 MAIN ST, APT 4B, SAN FRANCISCO, CA 12345'),
    ('JOHNSON TECH SOLUTIONS', 'JOHNSON TECH', '135792468', '6666666690', 'SUPPORT@JOHNSONTECH.COM', '101 PINE RD, APT 1A, CHICAGO, IL 98765'),
    ('GLOBEX ENTERPRISES', 'GLOBEX', '864209731', '7777777777', 'INFO@GLOBEX-ENT.COM', '555 CEDAR ST, APT 5D, DENVER, CO 54321'),
    ('ELITE OFFICE SUPPLIES', 'ELITE SUPPLIES', '908172635', '8888548888', 'SALES@ELITE-SUPPLIES.COM', '999 ELM ST, APT 3A, ATLANTA, GA 67890'),
    ('TECH INNOVATORS INC.', 'TECH INNOVATORS', '384756291', '9999499999', 'CONTACT@TECH-INNOVATORS.COM', '789 BIRCH LN, APT 6C, HOUSTON, TX 12345'),
    ('SWIFT IT SOLUTIONS', 'SWIFT IT', '718293645', '1159211111', 'SUPPORT@SWIFT-IT.COM', '123 OAK AVE, APT 8B, SEATTLE, WA 98765'),
    ('STAR COMPONENTS CORP', 'STAR COMPONENTS', '626363636', '2222221072', 'SALES@STAR-COMPONENTS.COM', '456 PINE RD, APT 7C, PHOENIX, AZ 54321'),
    ('CITY ELECTRONICS LTD.', 'CITY ELECTRONICS', '787878787', '3333333344', 'INFO@CITY-ELECTRONICS.COM', '101 MAIN ST, APT 4D, LOS ANGELES, CA 67890'),
    ('NATIONAL SUPPLIES INC.', 'NATIONAL SUPPLIES', '434343434', '5555451855', 'CONTACT@NATIONAL-SUPPLIES.COM', '555 ELM ST, APT 2C, MIAMI, FL 12345'),
    ('GLOBAL HARDWARE SOLUTIONS', 'GLOBAL HARDWARE', '969696969', '4444444444', 'SALES@GLOBAL-HARDWARE.COM', '789 OAK AVE, APT 5A, SAN FRANCISCO, CA 98765'),
    ('A1 TECH PRODUCTS', 'A1 TECH', '464646464', '6666666666', 'INFO@A1-TECH.COM', '999 MAIN ST, APT 1D, CHICAGO, IL 54321'),
    ('PRIME OFFICE RESOURCES', 'PRIME OFFICE', '727272727', '7602777777', 'SUPPORT@PRIME-OFFICE.COM', '123 BIRCH LN, APT 2A, DENVER, CO 67890'),
    ('TECH WORLD INNOVATIONS', 'TECH WORLD', '919191919', '8888888823', 'CONTACT@TECH-WORLD.COM', '456 ELM ST, APT 3D, ATLANTA, GA 12345'),
    ('SUPERIOR ELECTRONICS LTD.', 'SUPERIOR ELECTRONICS', '545454545', '9999999999', 'SALES@SUPERIOR-ELECTRONICS.COM', '101 PINE RD, APT 5B, HOUSTON, TX 98765'),
    ('GOLDEN SUPPLIES CO.', 'GOLDEN SUPPLIES', '616161616', '1111111198', 'INFO@GOLDEN-SUPPLIES.COM', '555 MAIN ST, APT 1C, SEATTLE, WA 12345'),
    ('FUTURE TECH SOLUTIONS', 'FUTURE TECH', '838383838', '2222222234', 'SUPPORT@FUTURE-TECH.COM', '789 ELM ST, APT 4A, PHOENIX, AZ 67890'),
    ('FIRST CLASS COMPONENTS', 'FIRST CLASS', '454545454', '3333333356', 'CONTACT@FIRST-CLASS.COM', '123 OAK AVE, APT 5D, LOS ANGELES, CA 54321'),
    ('UNIVERSE ELECTRONICS INC.', 'UNIVERSE ELECTRONICS', '343434343', '5555555555', 'SALES@UNIVERSE-ELECTRONICS.COM', '456 MAIN ST, APT 2B, MIAMI, FL 12345');
    
INSERT INTO sellers (company_name, trading_name, ein, phone, email, address) VALUES
    ('ABC SALES INC.', 'ABC SALES', '123456780', '5555555000', 'SALES@ABC-SALES.COM', '234 OAK ST, APT 3A, NEW YORK, NY 12345'),
    ('XYZ DISTRIBUTORS LLC', 'XYZ DISTRIBUTORS', '987654321', '4444444444', 'CONTACT@XYZ-DISTRIBUTORS.COM', '567 BIRCH LN, APT 5B, CHICAGO, IL 67890'),
    ('SMITH & PARTNERS', 'SMITH PARTNERS', '246813579', '3333333000', 'PARTNERS@SMITH.COM', '890 PINE RD, APT 4C, SAN FRANCISCO, CA 54321'),
    ('JOHNSON SALES', 'JOHNSON SALES', '135792468', '6666666000', 'SALES@JOHNSON-SALES.COM', '123 MAIN ST, APT 6D, LOS ANGELES, CA 98765'),
    ('GLOBEX TRADERS', 'GLOBEX TRADERS', '864209731', '7777777000', 'TRADERS@GLOBEX.COM', '456 ELM ST, APT 8B, MIAMI, FL 12345'),
    ('ELITE MERCHANTS', 'ELITE MERCHANTS', '908172635', '8888888000', 'MERCHANTS@ELITE.COM', '789 CEDAR AVE, APT 2A, HOUSTON, TX 67890'),
    ('TECH INNOVATIONS INC.', 'TECH INNOVATIONS', '384756291', '9999999000', 'INFO@TECH-INNOVATIONS.COM', '101 PINE RD, APT 1C, SEATTLE, WA 54321'),
    ('SWIFT SALES SOLUTIONS', 'SWIFT SALES', '718293645', '1111111000', 'SALES@SWIFT-SALES.COM', '555 ELM ST, APT 7D, BOSTON, MA 12345'),
    ('STAR DISTRIBUTORS CORP', 'STAR DISTRIBUTORS', '626363637', '2222222000', 'DISTRIBUTORS@STAR.COM', '666 MAPLE LN, APT 5C, PHOENIX, AZ 67890'),
    ('CITY MERCHANTS LTD.', 'CITY MERCHANTS', '787878788', '3333333001', 'INFO@CITY-MERCHANTS.COM', '888 BIRCH AVE, APT 4A, DENVER, CO 54321'),
    ('NATIONAL TRADERS INC.', 'NATIONAL TRADERS', '434343435', '5555555001', 'TRADERS@NATIONAL.COM', '222 CEDAR RD, APT 2D, ATLANTA, GA 12345'),
    ('GLOBAL SALES SOLUTIONS', 'GLOBAL SALES', '969696961', '4444444001', 'SALES@GLOBAL-SALES.COM', '777 OAK ST, APT 3B, SAN FRANCISCO, CA 67890'),
    ('A1 SALES PRODUCTS', 'A1 SALES', '464646462', '6666666001', 'INFO@A1-SALES.COM', '444 MAIN AVE, APT 6A, LOS ANGELES, CA 54321'),
    ('PRIME DISTRIBUTORS', 'PRIME DISTRIBUTORS', '727272723', '7777777001', 'DISTRIBUTORS@PRIME.COM', '999 PINE LN, APT 1D, MIAMI, FL 12345'),
    ('TECH INNOVATIONS WORLD', 'TECH INNOVATIONS WORLD', '919191918', '8888888001', 'WORLD@TECH-INNOVATIONS.COM', '123 ELM ST, APT 7C, CHICAGO, IL 67890'),
    ('SUPERIOR MERCHANTS LTD.', 'SUPERIOR MERCHANTS', '545454540', '9999999001', 'MERCHANTS@SUPERIOR.COM', '456 BIRCH RD, APT 8A, NEW YORK, NY 54321'),
    ('GOLDEN DISTRIBUTORS CO.', 'GOLDEN DISTRIBUTORS', '616161615', '1111111001', 'DISTRIBUTORS@GOLDEN.COM', '777 MAIN ST, APT 5D, HOUSTON, TX 12345'),
    ('FUTURE SALES SOLUTIONS', 'FUTURE SALES', '838383836', '2222222001', 'SALES@FUTURE-SALES.COM', '555 CEDAR LN, APT 3C, SEATTLE, WA 67890'),
    ('FIRST CLASS TRADERS', 'FIRST CLASS TRADERS', '787878785', '3333333002', 'TRADERS@FIRST-CLASS.COM', '101 OAK AVE, APT 4B, BOSTON, MA 54321'),
    ('UNIVERSE SALES INC.', 'UNIVERSE SALES', '636363634', '5555555002', 'SALES@UNIVERSE-SALES.COM', '789 PINE RD, APT 2C, DENVER, CO 12345');
    
INSERT INTO products_sellers (product_id, seller_id, quantity) VALUES
    (17, 5, 29),
    (12, 20, 14),
    (28, 4, 18),
    (6, 18, 9),
    (21, 3, 7),
    (60, 6, 25),
    (57, 15, 28),
    (45, 20, 14),
    (51, 4, 18),
    (29, 18, 9),
	(21, 17, 7),
    (37, 20, 8),
    (2, 15, 1),
    (10, 19, 13),
    (20, 16, 26),
    (58, 12, 28),
    (27, 20, 14),
    (1, 7, 20),
    (28, 15, 12),
    (3, 18, 6),
    (5, 13, 29),
    (17, 11, 2),
    (33, 8, 23),
    (31, 1, 21);
    
INSERT INTO products_suppliers (product_id, supplier_id, quantity) VALUES
	(1, 1, 50),
	(1, 2, 50),
	(2, 3, 300),
	(3, 4, 300),
	(4, 5, 30),
	(4, 6, 50),
	(4, 7, 50),
	(5, 8, 300),
	(6, 9, 150),
	(7, 10, 50),
	(8, 11, 125),
	(8, 12, 125),
	(9, 13, 175),
	(9, 14, 200),
	(9, 15, 100),
	(9, 16, 100),
	(10, 17, 75),
    (11, 18, 155),
    (11, 19, 155),
    (12, 20, 170),
    (13, 1, 240),
    (14, 2, 175),
    (15, 3, 220), 
    (16, 4, 280),
    (17, 5, 175),
    (18, 6, 125),
    (19, 7, 75),
    (20, 8, 100),
    (20, 9, 100),
    (21, 10, 300),
    (22, 11, 150),
    (23, 12, 50),
    (24, 13, 125),
    (24, 14, 125),
    (25, 15, 75),
    (26, 16, 125),
    (27, 17, 100), 
    (28, 18, 200),
    (29, 19, 80),
    (30, 20, 180),
    (31, 1, 100),
    (31, 2, 100),
    (31, 3, 200),
    (32, 4, 150),
    (32, 5, 150),
    (33, 6, 230),
    (34, 7, 160),
    (34, 8, 160),
    (35, 9, 160),
    (35, 10, 160),
    (36, 11, 160),
    (37, 12, 150),
    (38, 13, 20),
    (39, 14, 180),
    (40, 15, 165),
    (40, 16, 165),
    (41, 17, 230),
    (42, 18, 170),
    (43, 19, 180),
    (44, 20, 220),
    (45, 1, 160),
    (46, 2, 190),
    (47, 3, 280),
    (48, 4, 260),
    (49, 5, 125),
    (49, 6, 125),
    (49, 7, 150),
    (50, 8, 160),
    (50, 9, 160),
    (51, 10, 140),
    (52, 11, 155),
    (52, 12, 155),
    (53, 13, 130),
    (53, 14, 150),
    (53, 15, 150),
    (54, 16, 170),
    (54, 17, 170),
    (55, 18, 150),
    (55, 19, 150),
    (56, 20, 250),
    (57, 1, 150),
    (58, 2, 180),
    (59, 3, 125),
    (59, 4, 125),
    (60, 5, 110),
    (60, 6, 110);
    
INSERT INTO orders_products (order_id, product_id, quantity) VALUES
	(1, 1, 1),
    (1, 2, 1),
    (1, 3, 1),
    (2, 4, 1),
    (3, 5, 1),
    (3, 6, 1),
    (4, 7, 1),
    (5, 8, 4),
    (6, 9, 1),
    (6, 10, 1),
    (7, 11, 1),
    (8, 12, 7),
    (9, 13, 1),
    (10, 14, 1),
    (10, 15, 1),
    (11, 16, 5),
    (12, 17, 1),
    (13, 18, 1),
    (13, 19, 1),
    (14, 20, 1),
    (14, 21, 1),
    (15, 22, 1),
    (16, 23, 1),
    (17, 24, 8),
    (18, 25, 2),
    (19, 26, 1), 
    (20, 27, 1),
    (21, 28, 2),
    (22, 29, 1),
    (22, 30, 1),
    (23, 31, 1),
    (23, 32, 1),
    (24, 33, 1),
    (25, 34, 1),
    (25, 35, 1),
    (26, 36, 3),
    (27, 37, 1),
    (28, 38, 1),
    (28, 39, 1), 
    (28, 40, 1),
    (29, 41, 1),
    (30, 42, 1), 
    (30, 43, 1),
    (31, 44, 2),
    (32, 45, 1),
    (32, 46, 1),
    (33, 47, 1),
    (34, 48, 1),
    (34, 49, 1),
    (35, 50, 1),
    (35, 51, 1),
    (35, 52, 1), 
    (36, 53, 2),
    (36, 54, 1),
    (37, 55, 1),
    (37, 56, 1),
    (37, 57, 1),
    (38, 58, 1),
    (39, 59, 1), 
    (40, 60, 2);