DBHunter
Infinity Member
Golden Member
- Joined
- August 23, 2025
- Messages
- 1,850
- Reaction score
- 3,246
- Points
- 113
- Thread Author
- #1
Website - ppobox.com
Format - .SQL
Size sql file - 9GB
Date - 2023
All Rows - 2kk
Download:
Quote:INSERT INTO `shipment` (`id`, `id_var_copy`, `webstore_order_id`, `user_id`, `date`, `shipment_type`, `ppono`, `ppoaddress`, `zoho_id`, `customer_notes`, `recepient_name`, `recepient_company`, `recepient_email`, `recepient_address`, `recepient_city`, `recepient_state`, `recepient_country`, `recepient_pincode`, `recepient_phoneno`, `recepient_mobileno`, `order_no`, `marketplace_orderId`, `delivery_co`, `tracking_no`, `description`, `product_upc`, `total_value`, `insurance_value`, `shipper_name`, `shipper_state`, `shipper_tel`, `consignee_email`, `shipper_payment`, `sender_address`, `sender_address1`, `sender_city`, `sender_state`, `sender_country`, `sender_pincode`, `time_created`, `weight`, `hold_consolidate`, `repackage`, `package_status`, `payment_status`, `invoice`, `ppobox_notes`, `assesseble_value`, `total_amount`, `amount_paid_type`, `transaction_id`, `general_hold`, `locked`, `points`, `total_rewardpoints`, `used_rewardpoints`, `barcode`, `print_lable`, `item_type_name`, `is_update`, `upnold`, `MRP`, `SKU`, `IEC_code_of_recipient`, `GSTIN_num_of_recipient`, `created`, `modified`, `payment_mode`, `icc_fees_date`, `total_amount_old`, `discount_coupon_name_id`, `discounted_amount`, `hash_key`, `zoho_hit_limit`) VALUES
Format - .SQL
Size sql file - 9GB
Date - 2023
All Rows - 2kk
Quote:INSERT INTO `shipment` (`id`, `id_var_copy`, `webstore_order_id`, `user_id`, `date`, `shipment_type`, `ppono`, `ppoaddress`, `zoho_id`, `customer_notes`, `recepient_name`, `recepient_company`, `recepient_email`, `recepient_address`, `recepient_city`, `recepient_state`, `recepient_country`, `recepient_pincode`, `recepient_phoneno`, `recepient_mobileno`, `order_no`, `marketplace_orderId`, `delivery_co`, `tracking_no`, `description`, `product_upc`, `total_value`, `insurance_value`, `shipper_name`, `shipper_state`, `shipper_tel`, `consignee_email`, `shipper_payment`, `sender_address`, `sender_address1`, `sender_city`, `sender_state`, `sender_country`, `sender_pincode`, `time_created`, `weight`, `hold_consolidate`, `repackage`, `package_status`, `payment_status`, `invoice`, `ppobox_notes`, `assesseble_value`, `total_amount`, `amount_paid_type`, `transaction_id`, `general_hold`, `locked`, `points`, `total_rewardpoints`, `used_rewardpoints`, `barcode`, `print_lable`, `item_type_name`, `is_update`, `upnold`, `MRP`, `SKU`, `IEC_code_of_recipient`, `GSTIN_num_of_recipient`, `created`, `modified`, `payment_mode`, `icc_fees_date`, `total_amount_old`, `discount_coupon_name_id`, `discounted_amount`, `hash_key`, `zoho_hit_limit`) VALUES
(104906, '44469', NULL, 16821, '2015-04-28', 1, 377568, 1, NULL, NULL, 'sonia parasnis', NULL, 'ravipatel986@gmail.com', 'Fever 104FM, Tower 2, 7th floor, India Bulls Finance Center Senapati Bapat Marg, Elphinstone Road Mumbai maharashtra 400013 INDIA', '', '', '', '', '9004088298', '', 'null', NULL, NULL, 'null', 'Multivitamin Supplement 120 Count', NULL, 5.97, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-28 00:00:00', NULL, 0, 0, '', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, '44469', NULL, NULL, NULL, NULL, '2015-06-29 14:35:10', '2020-11-17 10:45:51', NULL, NULL, NULL, '', 0.00, NULL, 4),
(104907, '44470', NULL, 16821, '2015-04-28', 1, 377568, 1, NULL, NULL, 'sulekha bhardwaj', NULL, 'ravipatel986@gmail.com', 'c-11 , navrachna apartment east arjun nagar shahdra delhi 110032 INDIA', '', '', '', '', '9953050759', '', 'null', NULL, NULL, 'null', 'Creations Heat Tamer Protective Spray 236ml', NULL, 2.19, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-28 00:00:00', NULL, 0, 0, '', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, '44470', NULL, NULL, NULL, NULL, '2015-06-29 14:35:10', '2020-11-17 10:45:51', NULL, NULL, NULL, '', 0.00, NULL, 4),
(104908, '44471', NULL, 16821, '2015-04-28', 1, 377568, 1, NULL, NULL, 'ruchi khanna', NULL, 'ravipatel986@gmail.com', 'apex hospital SP 4-6, MALVIYA NAGAR JAIPUR RAJASTHAN 302017 INDIA', '', '', '', '', '9829188373', '', 'null', NULL, NULL, 'null', 'Correxion Deep Wrinkle Night Cream 1Ounce', NULL, 10.13, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-28 00:00:00', NULL, 0, 0, '', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, '44471', NULL, NULL, NULL, NULL, '2015-06-29 14:35:10', '2020-11-17 10:45:51', NULL, NULL, NULL, '', 0.00, NULL, 4),
(104909, '44472', NULL, 16821, '2015-04-28', 1, 377568, 1, NULL, NULL, 'kanchan verma', NULL, 'ravipatel986@gmail.com', '12 -C mall avenue lucknow uttar pradesh 226001 INDIA', '', '', '', '', '9670006000', '', 'null', NULL, NULL, 'null', 'Skin AntiWrinkle Night Cream 41ml', NULL, 6.19, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-28 00:00:00', NULL, 0, 0, '', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, '44472', NULL, NULL, NULL, NULL, '2015-06-29 14:35:10', '2020-11-17 10:45:51', NULL, NULL, NULL, '', 0.00, NULL, 4),
(104910, '44473', NULL, 16821, '2015-04-28', 1, 377568, 1, NULL, NULL, 'Megha Ramesh', NULL, 'ravipatel986@gmail.com', 'Happy Creative Services (India) Pvt Ltd, City Center, No. 40, CMH Road, Indiranagar Bangalore karnataka 560038 INDIA', '', '', '', '', '9731914542', '', 'null', NULL, NULL, 'null', 'Creations Heat Tamer Protective Spray 236ml', NULL, 2.19, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-28 00:00:00', NULL, 0, 0, '', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, '44473', NULL, NULL, NULL, NULL, '2015-06-29 14:35:11', '2020-11-17 10:45:51', NULL, NULL, NULL, '', 0.00, NULL, 4),
(104911, '44474', NULL, 16821, '2015-04-28', 1, 377568, 1, NULL, NULL, 'Meenu Shrivastava', NULL, 'ravipatel986@gmail.com', 'E7/739 Arera Colony Lala Lajpat Rai Society Bhopal Madhya Pradesh 462016 INDIA', '', '', '', '', '9560911333', '', 'null', NULL, NULL, 'null', 'Gel Original 250ml', NULL, 3.78, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-28 00:00:00', NULL, 0, 0, '', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, '44474', NULL, NULL, NULL, NULL, '2015-06-29 14:35:11', '2020-11-17 10:45:51', NULL, NULL, NULL, '', 0.00, NULL, 4),
(104912, '44475', NULL, 16821, '2015-04-28', 1, 377568, 1, NULL, NULL, 'Geetika Higgins', NULL, 'ravipatel986@gmail.com', '303, Aparna Chandradeep, Road No. 7, Banjara Hills, Near Rat Banjara Hills Hyderabad TELANGANA 500034 INDIA', '', '', '', '', '8008377442', '', 'null', NULL, NULL, 'null', 'Latch Assist Nipple Everter', NULL, 3.30, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-28 00:00:00', NULL, 0, 0, '', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, '44475', NULL, NULL, NULL, NULL, '2015-06-29 14:35:11', '2020-11-17 10:45:51', NULL, NULL, NULL, '', 0.00, NULL, 4),
(104913, '44476', NULL, 16821, '2015-04-28', 1, 377568, 1, NULL, NULL, 'Prashanth MUTHYALA', NULL, 'ravipatel986@gmail.com', 'HNO: 2-3-364/B PLOT 12 SAI NAGAR NAGOLA Hyderabad TELANGANA 500068 INDIA', '', '', '', '', '9177234308', '', 'null', NULL, NULL, 'null', 'Gel Original 250ml', NULL, 3.78, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-28 00:00:00', NULL, 0, 0, '', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, '44476', NULL, NULL, NULL, NULL, '2015-06-29 14:35:11', '2020-11-17 10:45:51', NULL, NULL, NULL, '', 0.00, NULL, 4),
(104914, '44478', NULL, 16821, '2015-04-28', 1, 377568, 1, NULL, NULL, 'simranjit s chadha', NULL, 'ravipatel986@gmail.com', '3329 ranjit nagar new delhi Delhi 110008 INDIA', '', '', '', '', '9873870789', '', 'null', NULL, NULL, 'null', 'Acne Stress Control PowerCream Wash 6 Ounce', NULL, 3.62, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-28 00:00:00', NULL, 0, 0, '', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, '44478', NULL, NULL, NULL, NULL, '2015-06-29 14:35:11', '2020-11-17 10:45:51', NULL, NULL, NULL, '', 0.00, NULL, 4),
(104915, '44479', NULL, 16821, '2015-04-28', 1, 377568, 1, NULL, NULL, 'Vishvedeep Bhat', NULL, 'ravipatel986@gmail.com', 'House number 2038/1 SECTOR 47 C Chandigarh CHANDIGARH 160047 INDIA', '', '', '', '', '9999043510', '', 'null', NULL, NULL, 'null', 'Maximum Strength 025 Oz', NULL, 2.58, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-28 00:00:00', NULL, 0, 0, '', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, '44479', NULL, NULL, NULL, NULL, '2015-06-29 14:35:11', '2020-11-17 10:45:51', NULL, NULL, NULL, '', 0.00, NULL, 4),
(104916, '44480', NULL, 16821, '2015-04-28', 1, 377568, 1, NULL, NULL, 'USMAN SIDDIQI', NULL, 'ravipatel986@gmail.com', '474 / 7B SITAPUR ROAD SAHAR COLONY LUCKNOW UP 226020 INDIA', '', '', '', '', '91 9415414183', '', 'null', NULL, NULL, 'null', 'Softener100ct', NULL, 8.88, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-28 00:00:00', NULL, 0, 0, '', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, '44480', NULL, NULL, NULL, NULL, '2015-06-29 14:35:11', '2020-11-17 10:45:51', NULL, NULL, NULL, '', 0.00, NULL, 4),
(104917, '44481', NULL, 16821, '2015-04-28', 1, 377568, 1, NULL, NULL, 'Jacob John', NULL, 'ravipatel986@gmail.com', 'L904, Concorde Manhattans, Neeladri Nagar Electronic City Phase1 Bangalore Karnataka 560100 INDIA', '', '', '', '', '919448750124', '', 'null', NULL, NULL, 'null', 'Strength Filling Material Cherry Flavor 1 Each', NULL, 1.38, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-28 00:00:00', NULL, 0, 0, '', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, '44481', NULL, NULL, NULL, NULL, '2015-06-29 14:35:11', '2020-11-17 10:45:51', NULL, NULL, NULL, '', 0.00, NULL, 4),
(104918, '44482', NULL, 16821, '2015-04-28', 1, 377568, 1, NULL, NULL, 'K A Prasad', NULL, 'ravipatel986@gmail.com', '6-3 mouli towers chandra mouli Puram , Benz circle Vijayawada Andhra Pradesh 520010 INDIA', '', '', '', '', '9985966996', '', 'null', NULL, NULL, 'null', 'Calming Comfort Bath Pack of 1 532Ml', NULL, 4.32, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-28 00:00:00', NULL, 0, 0, '', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, '44482', NULL, NULL, NULL, NULL, '2015-06-29 14:35:11', '2020-11-17 10:45:51', NULL, NULL, NULL, '', 0.00, NULL, 4),
(104919, '44483', NULL, 16821, '2015-04-28', 1, 377568, 1, NULL, NULL, 'Mohan Tambe', NULL, 'ravipatel986@gmail.com', '232/25, 1st floor, 5th cross, CBI Road, Ganganagar, near Union Bank of India Bangalore KARNATAKA 560032 INDIA', '', '', '', '', '9886061806', '', 'null', NULL, NULL, 'null', 'Advanced Probiotic Capsules 60 Count', NULL, 7.03, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-28 00:00:00', NULL, 0, 0, '', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, '44483', NULL, NULL, NULL, NULL, '2015-06-29 14:35:11', '2020-11-17 10:45:51', NULL, NULL, NULL, '', 0.00, NULL, 4),
(104920, '44484', NULL, 16821, '2015-04-28', 1, 377568, 1, NULL, NULL, 'Savari Mariyan', NULL, 'ravipatel986@gmail.com', '6/14, 4th Main Street, Teachers colony, Ariyakulam village KTC Nagar, Near maathamaaligai TIRUNELVELI Tamil nadu 627011 INDIA', '', '', '', '', '8220535462', '', 'null', NULL, NULL, 'null', 'Clean Floss PicksFresh Mint150 ct', NULL, 1.66, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-28 00:00:00', NULL, 0, 0, '', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, '44484', NULL, NULL, NULL, NULL, '2015-06-29 14:35:11', '2020-11-17 10:45:51', NULL, NULL, NULL, '', 0.00, NULL, 4),
(104921, '44485', NULL, 16821, '2015-04-28', 1, 377568, 1, NULL, NULL, 'p vinodh', NULL, 'ravipatel986@gmail.com', 'ROOM NO A-325 ARYABHATA HOSTEL(IIT-C) IIT BHU NEAR HYDERABAD GATE VARANASI UTTAR PRADESH 221005 INDIA', '', '', '', '', '8573974743', '', 'null', NULL, NULL, 'null', 'Sport Spf 50 Family Size Sunscreen Lotion 12Fluid Ounce', NULL, 5.70, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2015-04-28 00:00:00', NULL, 0, 0, '', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, '44485', NULL, NULL, NULL, NULL, '2015-06-29 14:35:11', '2020-11-17 10:45:51', NULL, NULL, NULL, '', 0.00, NULL, 4),
INSERT INTO `address_book` (`id`, `user_id`, `type`, `name`, `address1`, `address2`, `city`, `state`, `country`, `pincode`, `phoneno`, `mobileno`, `webstore_ref`, `time_created`, `created`, `modified`) VALUES
(8390, 20908, 1, 'Devansh Bhatia', 'B/101, Rameshwar Tower, Shimpoli Road, Borivali (W)', '', 'Mumbai', 'Maharashtra', 'IND', '400092', '02228991195', '9773393233', '', '2012-12-05 02:49:18', '2015-06-13 16:02:41', '2015-05-13 14:18:38'),
(8391, 20909, 1, 'SUDIP KUMAR SEN', '51/2B SOUTH ROAD, SANTOSHPUR, JADAVPUR,', '', 'KOLKATA', 'West Bengal', 'IND', '700075', '919007848333', '9007848333', '', '2012-12-04 10:54:52', '2015-06-13 16:02:41', '2015-05-13 14:18:38'),
(8392, 20910, 1, 'Shubhra Nath', '34, K. G Bose Sarani\n2nd Floor, Near Gol Kali Mandir \nBeliaghata', '', 'Kolkatta', 'West Bengal', 'IND', '700085', '03323727070', '900823122', '', '2012-12-04 10:44:56', '2015-06-13 16:02:41', '2015-05-13 14:18:38'),
(8393, 20911, 1, 'Ganesh babu M', 'Flat A-0001, Marvel Apoorva Apartment,\n4/12, Kalasathamman Koil street,\nRamapuram', '', 'Chennai', 'Tamilnadu', 'IND', '600089', '04422492042', '9445006019', '', '2012-12-04 10:14:20', '2015-06-13 16:02:41', '2015-05-13 14:18:38'),
(8394, 20912, 1, 'Amit Dixit', '333 Shriniketan CGHS, Plot 1, Sector 7, Dwarka', '', 'New Delhi', 'Delhi', 'IND', '110075', '01145562992', '9818062992', '', '2012-12-04 09:05:36', '2015-06-13 16:02:41', '2015-05-13 14:18:38'),
(8395, 20913, 1, 'RAJITHA MULPURI', 'M.Rajitha plot no-171,Flat no-501, Ritesh Premier Towers,vasavi nagar, kharkana,secundrabad andhra pradesh-500003\nSecunderabad\nAndhra Pradesh - 500003 , India\nContact no : 8885933246', '', 'SECUNDERABAD', 'Andhra Pradesh', 'IND', '500003', '0408885933246', '8885933246', '', '2012-12-04 08:26:26', '2015-06-13 16:02:41', '2015-05-13 14:18:38'),
(8396, 20914, 1, 'Ram Kumar C', 'Nextwave Multimedia Pvt. Ltd, No.1A, 2nd Street,\nDr. Tirumurthy Nagar, \nNungambakkam', '', 'Chennai', 'Tamilnadu', 'IND', '600034', '04425951591', '9042173669', '', '2012-12-04 07:03:29', '2015-06-13 16:02:41', '2015-05-13 14:18:38'),
(8397, 20915, 1, 'Dhaval Panchal', '14th Tulsi Niwas,Sainath Road,Near Telephone Exchange,Malad WestMumbai - 400064', '', 'Mumbai', 'Maharashtra', 'IND', '400064', '02228822998', '9870926720', '', '2012-12-04 04:43:33', '2015-06-13 16:02:41', '2015-07-11 08:32:33'),
(8398, 20916, 1, 'Ashvini Kumar Saxena', 'Flat #104, Royal Palms\n3 Main, L. B. Shastri Nagar', '', 'Bangalore', 'Karnataka', 'IND', '560017', '8025236261', '9198804230', '', '2012-12-04 02:37:57', '2015-06-13 16:02:41', '2015-05-13 14:18:38'),
(8399, 20917, 1, 'arjun kohli', 'B-1/A-3, IIT CAMPUS, HAUZ KHAS', '', 'NEW DELHI', 'Delhi', 'IND', '110016', '01126581627', '9953662626', '', '2012-12-04 02:27:44', '2015-06-13 16:02:41', '2015-05-13 14:18:38'),
Download:
To see this hidden content, you need to "Reply & React" with one of the following reactions: