===========================================
Robust CSV Import Script for Orders
===========================================

✓ Table truncated
Starting import...
✗ Error at row 6: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'product_name' at row 1 (Connection: mysql, Host: localhost, Port: 3306, Database: they9636_G4.20, SQL: insert into `orders` (`user_id`, `product_name`, `category`, `price`, `city`, `rating`, `created_at`, `updated_at`) values (1, Hippo Car Charger ALF 3 PD 38W Power Delivery Fast Quick Charging 3.0 Casan Colokan Mobil Type C Android Iphone Micro Lightning QC Dual Port USB A USB C Blue Ponsel Pengisi Adapter Kompatibel Semua Perangkat Android IP Tablet TWS Bluetooth, Car Charger Adapter, 69900, Jakarta Pusat, 5, 2026-01-29 05:47:15, 2026-01-29 05:47:15))
✗ Error at row 48: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'product_name' at row 1 (Connection: mysql, Host: localhost, Port: 3306, Database: they9636_G4.20, SQL: insert into `orders` (`user_id`, `product_name`, `category`, `price`, `city`, `rating`, `created_at`, `updated_at`) values (2, AMINO 60W PD QC Super Fast Car charger Dual Port Quick Charging Power / Car Charger Mobil Fast charging Type C PD+USB Quick Charge / Dual-Port USB-A Mini Car Charger Lapotp Untuk xiaomi oppo samsung vivo, Car Charger Adapter, 102500, Jakarta Barat, 4.9, 2026-01-29 05:47:15, 2026-01-29 05:47:15))
✗ Error at row 82: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'product_name' at row 1 (Connection: mysql, Host: localhost, Port: 3306, Database: they9636_G4.20, SQL: insert into `orders` (`user_id`, `product_name`, `category`, `price`, `city`, `rating`, `created_at`, `updated_at`) values (1, Charger Mobil Motor 3 Port USB Type C Super Fast Charging QC 3.0 PD45W Metal Stainless dengan Teknologi Power Delivery 45W dan 3 Keunggulan: Temperature Protection, Fireproof Material, dan Short-Circuit Protection, GaN Charger (High Tech), 62000, Kab. Bekasi, 4.9, 2026-01-29 05:47:15, 2026-01-29 05:47:15))
✗ Error at row 91: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'product_name' at row 1 (Connection: mysql, Host: localhost, Port: 3306, Database: they9636_G4.20, SQL: insert into `orders` (`user_id`, `product_name`, `category`, `price`, `city`, `rating`, `created_at`, `updated_at`) values (3, Type C | USB 5V to Colokan Lighter Mobil 12 V Converter Kabel Adaptor untuk DVR Mobil-charger Elektronik Aksesoris Mobil Cocok Dashcam GPS Lampu LED Perangkat Meningkatkan Jalur Konversi Adaptor Pengisi Daya 12V 2A Converter Cigarette Lighter Socket Wall, Kabel Data, 39600, Jakarta Barat, 4.8, 2026-01-29 05:47:15, 2026-01-29 05:47:15))
✓ Processed 100 records...
✓ Processed 200 records...
✓ Processed 300 records...
✓ Processed 400 records...
✓ Processed 500 records...
✓ Processed 600 records...
✓ Processed 700 records...
✓ Processed 800 records...
✓ Processed 900 records...
✓ Processed 1000 records...
✓ Processed 1100 records...

===========================================
IMPORT COMPLETED
Total processed: 1217
Total inserted: 1193
Errors: 24
===========================================