Sql © Chucky Credits Database Apps.shopifyrepublic.com [Dump Shops] 10Gb
HTML:
INSERT INTO `payment_log` (`pl_id`, `pl_shop`, `pl_email`, `pl_customer_name`, `pl_total_amount`, `pl_payment_txn_id`, `pl_shopify_order_id`, `pl_message`, `pl_is_payment_success`, `pl_is_order_success`, `pl_ip_address`, `pl_add_date`) VALUES
(21172, 'iwillinspire.myshopify.com', 'carolyn.chaney@earthlink.net', 'Carolyn Chaney', '41.16', 'DJiZdohQu9X3jH0a53XExfaCF3bZY', '2849112948797', '', '1', '1', '70.126.211.254', '1603655572'),
(21173, 'n3vapor.myshopify.com', 'dougndyber@gmail.com', 'Douglas Dyber', '45.7', 'duc0b439u3Dmgzn5O9Q46RHdF4cZY', '2841133613090', '', '1', '1', '69.122.115.40', '1603656965'),
(21174, 'hemp-living-usa.myshopify.com', 'smashley429@gmail.com', 'Ashley Brownson', '110.61', 'fTA3ocA0ny09rnhnxS3lvYZecLOZY', '2988024561863', '', '1', '1', '2600:387:b:3::47', '1603658569'),
(21175, 'good-cbd-shop.myshopify.com', 'cheyennerene96@gmail.com', 'Leo Messing', '106.05', 'tGICdAKehBVXT5ND0XMNp8YX07PZY', '2898036326551', '', '1', '1', '2600:387:0:504::18', '1603658644'),
(21176, 'kurativ-premium-cbd.myshopify.com', 'amberdhall1977@gmail.com', 'Amber Hall', '197.96', 'Tz1CF8QG4K5sSGjoyoazFx0tlidZY', '2833205788811', '', '1', '1', '70.119.211.159', '1603658912'),
(21177, 'hemp-living-usa.myshopify.com', 'wrightshanef@gmail.com', 'Shane Wright', '79.9', '75cBN8nvJbR5UWCKL0La9LW6jOUZY', '2988032950471', '', '1', '1', '2600:387:9:5::9d', '1603659572'),
(21178, 'hemp-living-usa.myshopify.com', 'sean.wright.vortex@gmail.com', 'Sean Wright', '99.9', 'VEByU2Gn17X5JvZUc2Jx6vL37wVZY', '2988037144775', '', '1', '1', '99.69.213.10', '1603660177'),
(21179, 'conners-clinic.myshopify.com', 'Images3512@yahoo.com', 'Julia Auerbach ', '49.27', 'nzS1So32HPU1KQnyFKB6unYqh4EZY', '2853779669158', '', '1', '1', '2601:441:4e00:7c70:e0ed:2b84:9625:cec5', '1603661019'),
(21180, 'conners-clinic.myshopify.com', 'nfonger@gmail.com', 'Nicole Fonger', '33', 'RmhVWUcWaG4D7uIZRKRdsp2msmbZY', '2853789663398', '', '1', '1', '204.9.16.181', '1603661540'),
(21181, 'candy-corals.myshopify.com', 'mlegault04@gmail.com', 'MIKE LEGAULT', '322.89', 'tGyhaW5rwbRjMW8FqOF4M6abJpKZY', '2795549098139', '', '1', '1', '72.39.30.203', '1603663410'),
(21182, 'candy-corals.myshopify.com', 'picart_rebecca@hotmail.com', 'Rebecca Picart', '86.4', 'fDcj9Ol7lCLSTcq1BwSEG5JRO1WZY', '2795572953243', '', '1', '1', '72.53.74.163', '1603664483'),
(21183, 'uc-industries.myshopify.com', 'Jdmn121094@yahoo.com', 'Janson Neff', '105', 'lOotGpyJhNozzAJm6FSLG9WGkLSZY', '2608054960230', '', '1', '1', '2601:900:8201:1660:5d63:d61b:b9d6:447e', '1603664837'),
(21184, 'trove-2020.myshopify.com', 'pciganer@gmail.com', 'Patrick Ciganer', '150.92', 'toFEZHuGGSiCRWAcYFNuBQWTYD8YY', '2859197300826', '', '1', '1', '174.16.142.125', '1603665698'),
(21185, 'topsail-hemp.myshopify.com', 'rubenhunt64@gmail.com', 'Jerry Hunt', '63.02', '9e40eJgrCWEaf9wh3Dw5G28oJAMZY', '2860396085412', '', '1', '1', '2600:1015:b16e:f22b:5071:57dd:99ae:9179', '1603666655'),
(21186, 'uc-industries.myshopify.com', 'Rleliefe@asu.edu', 'Ryan Leliefeld ', '112', 'dUF9QBooAuzR4odBTq8bprmdIiSZY', '2608097460326', '', '1', '1', '2600:1011:b103:6d60:314f:e835:8f71:1cb7', '1603666711'),
(21187, 'hemp-living-usa.myshopify.com', 'nate97.ray@gmail.com', 'Nathaniel Alarcon', '14.95', 'PDAJaVOgAdKNLcO6swEGxHrwGhAZY', '2988087410887', '', '1', '1', '173.174.228.150', '1603667145'),
(21188, 'conners-clinic.myshopify.com', 'pjkenkel@gmail.com', 'Patrick Kenkel', '45.6', '52vzpW7Oak4d6ZDYVfTRbcYQP0GZY', '2853897044134', '', '1', '1', '71.246.212.200', '1603667462'),
(21189, 'n3vapor.myshopify.com', 'jstratton46@icloud.com', 'Jennifer Stratton', '25.11', '9WoCS6kiugJ3XFmglUUSM5XjK0OZY', '2841292046370', '', '1', '1', '74.74.75.231', '1603667915'),
(21190, 'good-cbd-shop.myshopify.com', 'Eabswooper@aol.com', 'Eileen Bowen ', '131.65', '1CGnzMXeHrGKlSpOiq1k9JbgbBZZY', '2898295259287', '', '1', '1', '71.176.253.2', '1603668228'),
(21191, 'tims-naturals.myshopify.com', 'jebratman@gmail.com', 'Jean Bratman', '76.05', '7VOJ0AK8QtANxkwkgPyu1mxdksWZY', '2830943486113', '', '1', '1', '69.143.170.222', '1603668376'),
(21192, 'haraflow.myshopify.com', 'dannygordon_28@hotmail.com', 'Daniel Gordon', '3.09', 'ts1xApkQwi3PUGjfwJBrsvGJacRZY', '2473512566922', '', '1', '1', '65.120.178.170', '1603668417'),
DROP TABLE IF EXISTS `t1_payment`;
CREATE TABLE `t1_payment` (
`id` double NOT NULL AUTO_INCREMENT,
`shop_url` text NOT NULL,
`shoplogo` text NOT NULL,
`t1_username` text NOT NULL,
`t1_password` text NOT NULL,
`t1_scripts` text NOT NULL,
`t1_additional_content` text NOT NULL,
`t1_is_address_unify` enum('No','Yes') NOT NULL DEFAULT 'No',
`t1_is_enable_pincode_limit` enum('No','Yes') NOT NULL DEFAULT 'No',
`created_at` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `t1_payment` (`id`, `shop_url`, `shoplogo`, `t1_username`, `t1_password`, `t1_scripts`, `t1_additional_content`, `t1_is_address_unify`, `t1_is_enable_pincode_limit`, `created_at`) VALUES
(1, 'demo-t1-payment-v2-1-republic.myshopify.com', '', 'demo', 'password', '', '', 'No', 'Yes', '2020-03-31 17:36:01'),
(2, 'mrcbdshop-com.myshopify.com', '', 'mrcbdshopweb42', 'Hello123123@', '', 'Charges on your statements will appear as RuckusGallery442031295876', 'No', 'No', '2020-05-01 15:13:55'),
(3, 'vape-vandal.myshopify.com', '', 'vapevandal', 'oklonmlrs96', '', 'Charges on your statements will appear as VapeVandal442031296421', 'No', 'No', '2020-05-04 14:54:35'),
(4, 'happyhousecbd.myshopify.com', '', 'Happyhousecbd', 'Planet72#', '', 'Charges on your statements will appear as HappyHouse442031296279', 'Yes', 'No', '2020-05-04 15:19:18'),
(5, 'honeybolt.myshopify.com', 'https://cdn.shopify.com/s/files/1/0105/5116/4987/t/23/assets/canonlogo.png?v=1583249690', 'honeybolt', 'T1payments!', '', 'Charges on your statements will appear as HoneyBolt442037462117', 'No', 'No', '2020-03-03 15:34:52'),
(6, 'sokiss.myshopify.com', 'https://cdn.shopify.com/s/files/1/0272/2090/1948/t/4/assets/canonlogo.png?v=1580756597', 'sokisscbd', 'sokiss123', '', 'Charges will appear as Sokiss442037467311', 'No', 'No', '2020-02-03 19:00:29'),
(7, 'simply-owl-natural-products.myshopify.com', 'https://cdn.shopify.com/s/files/1/1560/1729/t/11/assets/canonlogo.png?v=1584728536', 'simplyowlnaturalweb45', 'integrations123', '', 'Charges on your banking statements will appear as SimplyOwl442031292336', 'No', 'No', '2020-03-20 18:22:17'),
(8, 'le-pet-luxe.myshopify.com', 'https://cdn.shopify.com/s/files/1/0034/9238/0784/t/2/assets/canonlogo.png?v=1579177375', 'LEPETLUXEWEB30', 'Intg123456', '', '', 'No', 'No', '2020-01-16 12:23:00'),
(9, 'austin-vibes.myshopify.com', '', 'austinvibes', 'Tata123101!!++', '', 'Charges on your statement will appear as: AustinVibes442031290834', 'No', 'Yes', '2020-06-01 16:58:54'),
(10, 'longhousehemp.myshopify.com', '', ' longhousehempweb51', 'Hello123123@', '', 'Charges on your statements will appear as LonghouseHmp442031298174', 'No', 'No', '2020-06-10 16:42:09'),
(11, 'cbdmn.myshopify.com', '', 'cbdmnstore', 'Keenan14329!', '', 'Charges on your statements will appear as CDMNStore442031291315', 'Yes', 'No', '2020-06-16 09:00:09'),
(12, 't1-payment-demo.myshopify.com', '', 'demo', 'password', '', '', 'No', 'No', '2020-06-18 14:45:33'),
(13, 'hendriks-scientific-usa.myshopify.com', '', 'hsus@Web8', 'Requested@84', '', '', 'No', 'No', '2020-07-22 15:44:19'),
--- End of bundle --- ', '988831655bb5de309112112d412216b4', 'shopify_payments', 0, 44.97, 44.97, 521, 0, 'USD', 0, '', 'kelleyephoto@Gmail.com', 'https://www.dipwell.co/15408825/orders/988831655bb5de309112112d412216b4/authenticate?key=b8400314fe1afee6130051adf47d0543', '', '14809068339357', '', '90384', '[]', 'direct', 'web', '100.40.208.111', 'Kelley', 'Enderley', '39 Parkwood Blvd', '', 'Poughkeepsie', '12603', 'New York', 'United States', '', '41.6844629', '-73.9143735', 'Kelley Enderley', 'US', 'NY', 'Kelley', 'Enderley', '39 Parkwood Blvd', 'United States', 'Poughkeepsie', '12603', '', '8457971598', 'Kelley Enderley', '-73.9143735', '41.6844629', 'New York', 'US', 'NY', '', 0, '', 1, '#90384', 'https://www.google.com/', '/?gclid=CjwKCAjw8MD7BRArEiwAGZsrBf-c-1QoC56gui4VULbtASkzi_UW6iIrCIwEFMFFyAnrEp0oDmE0yhoCc14QAvD_BwE', 'd4fc0bdfca4336d46369fd6626f622aa', 44.97, 'USD', 'paid', 1, 0, '0000-00-00 00:00:00', '', '2020-09-28 00:25:06', '', '', 'en', '', '', 44.97, '6f371eb8a125a8a26443f77d37318d93', '', '', '580111', '100.40.208.111', 'en-us', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_7 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.1.2 Mobile/15E148 Safari/604.1', '', 0, 0, '3276569411722', 'Kelleyephoto@gmail.com', '2020-04-29 20:26:09', 1, 'Kelley', 'Enderley', 3, '', 'enabled', 155.79, '2753321009309', '', 0, '2020-09-28 00:25:08', '39 Parkwood Blvd', '', 'Receiving updates in Messenger', '#90384', 'USD', '2020-04-29 20:26:09', 'single_opt_in', 'Kelley', 'Enderley', '', 0, 'Kelley Enderley', 'Poughkeepsie', 'New York', 'United States', '12603', '8457971598', 'NY', 'US', 'United States', '', 'timelesslacquer.myshopify.com'),
(83116, '2753321468061', 'emjones807@gmail.com', '0000-00-00 00:00:00', '2020-09-28 00:25:17', '2020-09-28 00:25:08', '89385', ' Glitter Collection, Dip Color Powder, GL17- Classic Collection, Dip Color Powder, CL55- Classic Collection, Dip Color Powder, CL24- Classic Collection, Dip Color Powder, CL2- ', 'bff7056ec3368902877503a4e0a68ab7', 'shopify_payments', 0, 35.88, 35.88, 339, 0, 'USD', 0, '', 'emjones807@gmail.com', 'https://www.dipwell.co/15408825/orders/bff7056ec3368902877503a4e0a68ab7/authenticate?key=104e73b7ea7aa4db0420fcfc555553f6', '', '14809057493149', '', '90385', '[]', 'direct', 'web', '136.32.118.177', 'Emily', 'Jones', '13031 Grand Avenue', '', 'Kansas City', '64145', 'Missouri', 'United States', '', '38.8909122', '-94.5922106', 'Emily Jones', 'US', 'MO', 'Emily', 'Jones', '13031 Grand Avenue', 'United States', 'Kansas City', '64145', '', '(913) 375-8425', 'Emily Jones', '-94.5922106', '38.8909122', 'Missouri', 'US', 'MO', '', 0, '', 0, '#90385', 'https://www.google.com/', '/', '0bca344fa33a741457497bb5deb253b9', 35.88, 'USD', 'paid', 1, 0, '0000-00-00 00:00:00', '', '2020-09-28 00:25:16', '', '', 'en', '', '', 35.88, 'f4a6adf6d8953d7f4e51cfd0192f9762', '', '', '580111', '136.32.118.177', 'en-us', 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_0 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0 Mobile/15E148 Safari/604.1', '', 414, 715, '4162401304733', 'emjones807@gmail.com', '2020-09-28 00:18:15', 1, 'Emily', 'Jones', 1, '', 'disabled', 35.88, '2753321468061', '', 1, '2020-09-28 00:25:18', '13031 Grand Avenue', '', '', '#90385', 'USD', '2020-09-28 00:18:15', 'single_opt_in', 'Emily', 'Jones', '', 0, 'Emily Jones', 'Kansas City', 'Missouri', 'United States', '64145', '(913) 375-8425', 'MO', 'US', 'United States', '', 'timelesslacquer.myshopify.com'),
(83117, '2753355907229', 'mayers2804@gmail.com', '0000-00-00 00:00:00', '2020-09-28 00:38:36', '2020-09-28 00:38:29', '89386', 'NEON COLLECTION, DIP COLOR POWDER, NE20\r\n ---Notes stored on: /cart---\r\n ---properties size(0)---\r\n ---URL: /products/neon-collection-dip-color-powder-ne20?variant=38957921488---\r\n ---Product ID: 9505010192---\r\n ---SKU: D CO2 020---\r\n ---Variant ID: 38957921488---\r\n \r\n --------- End of bundle ---------\r\n \r\n NEON COLLECTION, DIP COLOR POWDER, NE19\r\n ---Notes stored on: /cart---\r\n ---properties size(0)---\r\n ---URL: /products/dip-nails-color-powder-neon-ne19?variant=38954850192---\r\n ---Product ID: 9504765328---\r\n ---SKU: D CO2 019---\r\n ---Variant ID: 38954850192---\r\n \r\n --------- End of bundle ---------\r\n \r\n CLASSIC COLLECTION, DIP COLOR POWDER, CL63\r\n ---Notes stored on: /cart---\r\n ---properties size(0)---\r\n ---URL: /products/dip-nails-color-powder-naturale-cl63?variant=13333113733171---\r\n ---Product ID: 1480558641203---\r\n ---SKU: D CO4 063---\r\n ---Variant ID: 13333113733171---\r\n \r\n --------- End of bundle ---------\r\n \r\n NATURAL, DIP NAIL POWDER\r\n ---Notes stored on: /cart---\r\n ---properties size(0)---\r\n ---URL: /products/dip-nails-natural-acrylic-powder-dipwell?variant=35733663248---\r\n ---Product ID: 9021361488---\r\n ---SKU: D POW 002---\r\n ---Variant ID: 35733663248---\r\n \r\n --------- End of bundle ---------\r\n \r\n GLITTER COLLECTION, DIP COLOR POWDER, GL45\r\n ---Notes stored on: /cart---\r\n ---properties size(0)---\r\n ---URL: /products/dip-nails-color-powder-naturale-gl45?variant=13333113569331---\r\n ---Product ID: 1480558444595---\r\n ---SKU: D CO3 045---\r\n ---Variant ID: 13333113569331---\r\n \r\n --------- End of bundle ---------\r\n \r\n GLITTER COLLECTION, DIP COLOR POWDER, GL12\r\n ---Notes stored on: /cart---\r\n ---properties size(0)---\r\n ---URL: /products/dip-nails-color-powder-glitter-gl12?variant=38954851728---\r\n ---Product ID: 9504766160---\r\n ---SKU: D CO3 012---\r\n ---Variant ID: 38954851728---\r\n \r\n --------- End of bundle ---------\r\n \r\n BASE & FINISH, DIP NAIL POWDER\r\n ---Notes stored on: /cart---\r\n ---properties size(0)---\r\n ---URL: /products/dip-nails-base-finish-dipping-nail-powder-dipwell?variant=35733608848---\r\n ---Product ID: 9021347088---\r\n ---SKU: D POW 006---\r\n ---Variant ID: 35733608848---\r\n \r\n --------- End of bundle ---------\r\n \r\n ACTIVATOR, STEP 3, DIP NAIL LIQUID\r\n ---Notes stored on: /cart---\r\n ---properties size(0)---\r\n ---URL: /products/dip-nails-activator-step-3-dipping-nail-liquids-dipwell?variant=35733320272---\r\n ---Product ID: 9021298448---\r\n ---SKU: D LIQ 003-S---\r\n ---Variant ID: 35733320272---\r\n \r\n --------- End of bundle ---------', '96ec4ee1382806bafe277719567a7989', 'shopify_payments', 0, 60.76, 60.76, 639, 0, 'USD', 0, '', 'mayers2804@gmail.com', 'https://www.dipwell.co/15408825/orders/96ec4ee1382806bafe277719567a7989/authenticate?key=ad61b3444533d4d987ebfc3ad177b012', '', '14809087443101', '', '90386', '[]', 'direct', 'web', '73.75.176.172', 'Michele', 'Mayers', '1100 W Glenn Trail', '', 'Elk Grove Village', '60007', 'Illinois', 'United States', '', '42.0016261', '-88.0410847', 'Michele Mayers', 'US', 'IL', 'Michele', 'Mayers', '1100 W Glenn Trail', 'United States', 'Elk Grove Village', '60007', '', '(224) 659-2721', 'Michele Mayers', '-88.0410847', '42.0016261', 'Illinois', 'US', 'IL', '', 0, '', 1, '#90386', '', '/', '868853c22503898701a3e3a02db92612', 70.76, 'USD', 'paid', 1, 10, '0000-00-00 00:00:00', '', '2020-09-28 00:38:35', '', '', 'en', '', '', 60.76, '530a16de5e54689a73b5d7a67d56e33a', '', '', '580111', '73.75.176.172', 'en-us', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_6) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.1.2 Safari/605.1.15', '382871face6e92aa78007e4caf3d9779', 1440, 744, '4162233172125', 'mayers2804@gmail.com', '2020-09-28 00:04:12', 1, 'Michele', 'Mayers', 1, '', 'enabled', 60.76, '2753355907229', '', 0, '2020-09-28 00:38:38', '1100 W Glenn Trail', '', '', '#90386', 'USD', '2020-09-28 00:04:12', 'single_opt_in', 'Michele', 'Mayers', '', 0, 'Michele Mayers', 'Elk Grove Village', 'Illinois', 'United States', '60007', '(224) 659-2721', 'IL', 'US', 'United States', '', 'timelesslacquer.myshopify.com'),
(83118, '2753356660893', 'mikaela398@yahoo.com', '0000-00-00 00:00:00', '2020-09-28 00:38:56', '2020-09-28 00:38:50', '89387', ' Classic Collection, Dip Color Powder, CL65- Pastel Collection, Dip Color Powder, PA20- Naturale Collection, Dip Color Powder, NA19- Brushes - Dip Liquids- Jelly Pusher- ', '38a7686ec07763d680a1223d24a8f23c', 'shopify_payments', 0, 41.67, 38.85, 299, 2.82, 'USD', 0, '', 'mikaela398@yahoo.com', 'https://www.dipwell.co/15408825/orders/38a7686ec07763d680a1223d24a8f23c/authenticate?key=c8bb165902eb4fbd7f1baf9f7170b0a2', '', '14809105694877', '', '90387', '[]', 'direct', 'web', '172.4.38.187', 'Mikaela', 'Payne', '33054 Rhine Avenue', '', 'Temecula', '92592', 'California', 'United States', '', '33.4668249', '-117.0831602', 'Mikaela Payne', 'US', 'CA', 'Mikaela', 'Payne', '33054 Rhine Avenue', 'United States', 'Temecula', '92592', '', '(858) 230-2517', 'Mikaela Payne', '-117.0831602', '33.4668249', 'California', 'US', 'CA', '', 0, '', 1, '#90387', 'https://linkin.bio/dipwellnails', '/', '7b1b0de344a4810731f08667a622f7f0', 38.85, 'USD', 'paid', 1, 0, '0000-00-00 00:00:00', '', '2020-09-28 00:38:55', '', '', 'en', '', '', 41.67, '83427c4ec3f0d8b9469e1fb45fc0630d', '', '', '580111', '172.4.38.187', 'en-us', 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_0_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Mobile/15E148 Instagram 160.1.0.31.120 (iPhone10,5; iOS 14_0_1; en_US; en-US; scale=2.61; 1080x1920; 246979827)', '', 414, 628, '3883286855837', 'mikaela398@yahoo.com', '2020-08-10 14:02:53', 1, 'Mikaela', 'Payne', 2, '', 'enabled', 80.26, '2753356660893', '', 1, '2020-09-28 00:38:57', '33054 Rhine Avenue', '', '', '#90387', 'USD', '2020-08-10 14:02:53', 'single_opt_in', 'Mikaela', 'Payne', '', 0, 'Mikaela Payne', 'Temecula', 'California', 'United States', '92592', '(858) 230-2517', 'CA', 'US', 'United States', '', 'timelesslacquer.myshopify.com'),
(83119, '2753363607709', 'magbag53@outlook.com', '0000-00-00 00:00:00', '2020-09-28 00:41:23', '2020-09-28 00:41:15', '89388', ' Classic Collection, Dip Color Powder, CL7- Pastel Collection, Dip Color Powder, PA02- Classic Collection, Dip Color Powder, CL46- Naturale Collection, Dip Color Powder, NA16- Classic Collection, Dip Color Powder, CL66- ', 'cf69e87aa05d221503510896e764f645', 'shopify_payments', 0, 43.32, 40.37, 424, 2.95, 'USD', 0, '', 'magbag53@outlook.com', 'https://www.dipwell.co/15408825/orders/cf69e87aa05d221503510896e764f645/authenticate?key=d565a6846728fa0793ec5f14f53388be', '', '14808994840733', '', '90388', '[]', 'direct', 'web', '185.59.221.78', 'Margaret', 'dalton', '2410 Sweet Sage Street', '', 'Chula Vista', '91915', 'California', 'United States', '', '32.6239982', '-116.9525711', 'Margaret dalton', 'US', 'CA', 'Margaret', 'dalton', '2410 Sweet Sage Street', 'United States', 'Chula Vista', '91915', '', '(619) 708-1513', 'Margaret dalton', '-116.9525711', '32.6239982', 'California', 'US', 'CA', '', 0, '', 1, '#90388', '', '/?smile_deep_link=reward_fulfillment_details&smile_deep_link_data=191177941', '83e70afb24a1ba0dd9486743f46f5335', 44.85, 'USD', 'paid', 1, 4.48, '0000-00-00 00:00:00', '', '2020-09-28 00:41:22', '', '', 'en', '', '', 43.32, '79d4cb362afcf8f313d68a4a752f25cb', '', '', '580111', '185.59.221.78', 'en-US,en;q=0.9', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.102 Safari/537.36', '235911497cfb02a9887444f172c25bd1', 1200, 652, '4113220567197', 'magbag53@outlook.com', '2020-09-22 23:16:43', 1, 'Margaret', 'dalton', 2, '', 'enabled', 91.55, '2753363607709', '', 1, '2020-09-28 00:41:25', '2410 Sweet Sage Street', '', '', '#90388', 'USD', '2020-09-28 00:31:13', 'unknown', 'Margaret', 'dalton', '', 0, 'Margaret dalton', 'Chula Vista', 'California', 'United States', '91915', '(619) 708-1513', 'CA', 'US', 'United States', '', 'timelesslacquer.myshopify.com'),
(83120, '2753377435805', 'carol.alcantar97@gmail.com', '0000-00-00 00:00:00', '2020-09-28 00:46:44', '2020-09-28 00:46:43', '89389', 'NATURALE COLLECTION, DIP COLOR POWDER, NA01\r\n ---Notes stored on: /cart---\r\n ---properties size(0)---\r\n ---URL: /products/dip-nails-color-powder-naturale-na1?variant=38954846544---\r\n ---Product ID: 9504762896---\r\n ---SKU: D CO1 001---\r\n ---Variant ID: 38954846544---\r\n \r\n --------- End of bundle ---------\r\n \r\n CLASSIC COLLECTION, DIP COLOR POWDER, CL40\r\n ---Notes stored on: /cart---\r\n ---properties size(0)---\r\n ---URL: /products/dip-nails-color-powder-classic-cl40?variant=38954870352---\r\n ---Product ID: 9504771472---\r\n ---SKU: D CO4 040---\r\n ---Variant ID: 38954870352---\r\n \r\n --------- End of bundle ---------\r\n \r\n NATURALE COLLECTION, DIP COLOR POWDER, NA08\r\n ---Notes stored on: /cart---\r\n ---properties size(0)---\r\n ---URL: /products/dip-nails-color-powder-naturale-na8?variant=38954847056---\r\n ---Product ID: 9504763408---\r\n ---SKU: D CO1 008---\r\n ---Variant ID: 38954847056---\r\n \r\n --------- End of bundle ---------\r\n \r\n NATURALE COLLECTION, DIP COLOR POWDER, NA19\r\n ---Notes stored on: /cart---\r\n ---properties size(0)---\r\n ---URL: /products/dip-nails-color-powder-naturale-na19?variant=13333111341107---\r\n ---Product ID: 1480557723699---\r\n ---SKU: D CO1 019---\r\n ---Variant ID: 13333111341107---\r\n \r\n --------- End of bundle ---------', '610e09f98d330c25f06116b0f897eb72', 'shopify_payments', 0, 35.88, 35.88, 339, 0, 'USD', 0, '', 'carol.alcantar97@gmail.com', 'https://www.dipwell.co/15408825/orders/610e09f98d330c25f06116b0f897eb72/authenticate?key=cd18f6f301258850de3c1ebd543112b0', '', '14809120866461', '', '90389', '[]', 'direct', 'web', '107.216.189.171', 'Carol', 'Alcantar', '2523 Olde White Ln', '', 'Charlotte', '28226', 'North Carolina', 'United States', '', '35.1181367', '-80.7800424', 'Carol Alcantar', 'US', 'NC', 'Carol', 'Alcantar', '2523 Olde White Ln', 'United States', 'Charlotte', '28226', '', '7042907118', 'Carol Alcantar', '-80.7800424', '35.1181367', 'North Carolina', 'US', 'NC', '', 0, '', 1, '#90389', '', '/', 'b08d55f706a8ee3c4d66b9d2b7c7cdf5', 35.88, 'USD', 'paid', 1, 0, '0000-00-00 00:00:00', '', '2020-09-28 00:46:43', '', '', 'en', '', '', 35.88, '1e514e34624d13a3425507fc355bea24', '', '', '580111', '107.216.189.171', 'en-us', 'Mozilla/5.0 (iPhone; CPU iPhone OS 14_0_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/14.0 Mobile/15E148 Safari/604.1', '', 375, 635, '3894347006109', 'carol.alcantar97@gmail.com', '2020-08-13 02:13:34', 1, 'Carol', 'Alcantar', 2, '', 'disabled', 80.85, '2753377435805', '', 1, '2020-09-28 00:46:45', '2523 Olde White Ln', '', '', '#90389', 'USD', '2020-08-13 02:14:36', 'single_opt_in', 'Carol', 'Alcantar', '', 0, 'Carol Alcantar', 'Charlotte', 'North Carolina', 'United States', '28226', '7042907118', 'NC', 'US', 'United States', '', 'timelesslacquer.myshopify.com'),
(83121, '2753389920413', 'kriisssyy@hotmail.com', '0000-00-00 00:00:00', '2020-09-28 00:51:32', '2020-09-28 00:51:24', '89390', ' Sealer, Step 4, Dip Nail Liquid- Activator, Step 3, Dip Nail Liquid- Classic Collection, Dip Color Powder, CL9- Naturale Collection, Dip Color Powder, NA14- Glitter Collection, Dip Color Powder, GL17- ', 'e8e037c0924402d7f1369c85ad07720a', 'shopify_payments', 0, 37.85, 37.85, 345, 0, 'USD', 0, '', 'kriisssyy@hotmail.com', 'https://www.dipwell.co/15408825/orders/e8e037c0924402d7f1369c85ad07720a/authenticate?key=49d32795cbabec053c723e2f7ca99f2f', '', '14809153601693', '', '90390', '[]', 'direct', 'web', '107.242.117.28', 'Kristyn', 'Lashoff', '5 Hudson ave', '', 'Rensselaer', '12144', 'New York', 'United States', '', '42.6177236', '-73.7301906', 'Kristyn Lashoff', 'US', 'NY', 'Kristyn', 'Lashoff', '5 Hudson ave', 'United States', 'Rensselaer', '12144', '', '+15189471517', 'Kristyn Lashoff', '-73.7301906', '42.6177236', 'New York', 'US', 'NY', '', 0, '', 1, '#90390', 'https://www.google.com/', '/', '4f8ac4ac20cc1039317c6d31da4262b4', 42.85, 'USD', 'paid', 1, 5, '0000-00-00 00:00:00', '', '2020-09-28 00:51:31', '', '', 'en', '', '', 37.85, '651f4694d94af554847e88d246d76dec', '', '', '580111', '107.242.117.28', 'en-US,en;q=0.9', 'Mozilla/5.0 (Linux; Android 10; LM-G820) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.125 Mobile Safari/537.36', 'f9bff7880e6600301c36359b5cde7468', 0, 0, '3197410476170', 'Kriisssyy@hotmail.com', '2020-04-13 23:14:12', 1, 'Kristyn', 'Lashoff', 5, '', 'enabled', 189.46, '2753389920413', '', 1, '2020-09-28 00:51:34', '5 Hudson ave', '', '', '#90390', 'USD', '2020-04-13 23:14:12', 'single_opt_in', 'Kristyn', 'Lashoff', '', 0, 'Kristyn Lashoff', 'Rensselaer', 'New York', 'United States', '12144', '+15189471517', 'NY', 'US', 'United States', '', 'timelesslacquer.myshopify.com'),
INSERT INTO `webhook_log_wimo` (`wlw_id`, `wlw_shop_order_id`, `wlw_wimo_task_id`, `wlw_wimo_task_totalPrice`, `wlw_wimo_task_status`, `wlw_wimo_task_json`, `wlw_add_date`, `in_queue`, `in_aramex`, `res_importSo`, `is_editSoHeader_aramex`, `res_editSoHeader`, `after_dispatch_price_change`) VALUES
(212342, '2296693293107', '6634902', '152.81', 'Succeeded', '{\"taskId\":6634902,\"data\":{\"task\":{\"id\":6634902,\"awb\":\"2006277989622888\",\"details\":\"#LQF50448 | 2296693293107 | HImalyan Pink Salt - 2 | Organic Mango Pickle (Oil Free) - 1 | Yellow Zuchini - 1 | Okra \\\"Lady Fingers\\\" - 1 | Organic Gluten-Free Tricolour Spaghetti - 1 | Koko Coconut Milk Unsweetened - 2 | Organic Free Range Eggs 10 Pcs - 1\",\"customerNotes\":null,\"totalPrice\":152.81,\"leftToBePaid\":152.81,\"deliveryPrice\":null,\"currency\":\"AED\",\"inventory\":null,\"priority\":582051,\"cancelReason\":null,\"cancelSubReason\":null,\"quantity\":1,\"sentETA\":false,\"eta\":0,\"etaText\":null,\"serviceTime\":null,\"uuid\":\"B1T1XM2eP\",\"startedAt\":\"2020-07-28T10:47:40.000Z\",\"completedAt\":\"2020-07-28T10:51:39.000Z\",\"lastLocationLat\":null,\"lastLocationLng\":null,\"collectPayment\":true,\"completeBefore\":\"2020-07-28T17:00:00.000Z\",\"completeAfter\":\"2020-07-28T05:00:00.000Z\",\"pickupTask\":false,\"arrivalTime\":null,\"mobileTaskForm\":null,\"route\":\"task-route/1595933499356-1595933499.178165\",\"sendNotifications\":true,\"driverArrived\":true,\"arrivedAt\":\"2020-07-28T10:48:28.000Z\",\"taskWillBeDelayed\":false,\"taskDelayed\":false,\"numberOfAttempts\":1,\"lastAssignedAt\":\"2020-07-27T10:19:24.000Z\",\"returnedAt\":null,\"cancelledAt\":null,\"pickedUpAt\":null,\"readyToDispatchAt\":null,\"senderName\":null,\"firstReceivedIn\":null,\"pickUpFrom\":null,\"runsheetCreatedBy\":null,\"weight\":null,\"reference\":null,\"deliveryStatus\":null,\"createdAt\":\"2020-07-27T08:40:06.000Z\",\"updatedAt\":\"2020-07-28T10:51:39.000Z\",\"ownerId\":1888,\"fulfillerId\":1888,\"userId\":8974,\"returnById\":null,\"teamId\":null,\"customerId\":2158336,\"statusId\":9,\"paymentTypeId\":3,\"owner\":{\"id\":1888,\"name\":\"QualityFood.ae\",\"email\":\"omar.osman@qualityfood.ae\",\"phone\":\"+971554997353\"},\"fulfiller\":{\"id\":1888,\"name\":\"QualityFood.ae\",\"email\":\"omar.osman@qualityfood.ae\",\"phone\":\"+971554997353\"},\"user\":{\"id\":8974,\"name\":\"Noor Hassan\",\"phone\":\"+971559650095\"},\"team\":null,\"customer\":{\"id\":2158336,\"name\":\"Annie Khan\",\"address\":null,\"addressSecondLine\":null,\"email\":null,\"phone\":\"0508954792\",\"lat\":null,\"lng\":null,\"createdAt\":\"2019-11-11T06:40:02.000Z\",\"updatedAt\":\"2019-11-11T06:40:02.000Z\",\"companyId\":1888},\"status\":{\"id\":9,\"name\":\"Succeeded\"},\"paymentType\":{\"id\":3,\"name\":\"Prepaid\"},\"address\":{\"lat\":25.3242234,\"lng\":55.3736981,\"address\":\"Al khan corniche - 1703 , beach tower 2 \",\"addressSecondLine\":null,\"city\":\"Sharjah\",\"area\":\"Sharjah \",\"country\":\"AE\",\"streetNumber\":\"Al khan corniche\",\"streetName\":\"1703 , beach tower 2 \",\"postalCode\":null,\"instructions\":null,\"nickname\":null},\"notes\":[{\"id\":4432126,\"note\":null,\"image\":\"task-signatures/1595933500062-IMG_signatures_20200728105139196.jpg\",\"type\":3,\"createdAt\":\"2020-07-28T10:51:40.000Z\",\"updatedAt\":\"2020-07-28T10:51:40.000Z\",\"userId\":8974,\"taskId\":6634902,\"user\":{\"id\":8974,\"name\":\"Noor Hassan\"}},{\"id\":4432127,\"note\":null,\"image\":\"task-photos/1595933500269-IMG_images_20200728105139187.jpg\",\"type\":2,\"createdAt\":\"2020-07-28T10:51:40.000Z\",\"updatedAt\":\"2020-07-28T10:51:40.000Z\",\"userId\":8974,\"taskId\":6634902,\"user\":{\"id\":8974,\"name\":\"Noor Hassan\"}}],\"customFields\":[{\"id\":10509146,\"fieldKey\":\"ispartiallypaid\",\"fieldType\":\"DROPDOWN\",\"fieldValue\":\"No\"}],\"timelines\":[{\"location\":null,\"arg\":null,\"id\":54006465,\"type\":\"TASK_CREATED\",\"action\":\"Task created\",\"createdAt\":\"2020-07-27T08:40:06.000Z\",\"driverName\":null,\"amountCollected\":null,\"collectionMethod\":null},{\"location\":{\"city\":\"QualityFood Distribution Center\"},\"arg\":{},\"id\":54011722,\"type\":\"TASK_ASSIGNED\",\"action\":\"Task assigned\",\"createdAt\":\"2020-07-27T10:19:24.000Z\",\"driverName\":\"Noor Hassan\",\"amountCollected\":0,\"collectionMethod\":\"Prepaid\"},{\"location\":{\"city\":\"QualityFood Distribution Center\"},\"arg\":{},\"id\":54067417,\"type\":\"TASK_STARTED\",\"action\":\"Task started\",\"createdAt\":\"2020-07-28T10:47:40.000Z\",\"driverName\":\"Noor Hassan\",\"amountCollected\":0,\"collectionMethod\":\"Prepaid\"},{\"location\":{\"city\":\"QualityFood Distribution Center\"},\"arg\":{},\"id\":54067457,\"type\":\"DRIVER_ARRIVED\",\"action\":\"Driver arrived\",\"createdAt\":\"2020-07-28T10:48:28.000Z\",\"driverName\":\"Noor Hassan\",\"amountCollected\":0,\"collectionMethod\":\"Prepaid\"},{\"location\":{\"city\":\"QualityFood Distribution Center\"},\"arg\":{},\"id\":54067657,\"type\":\"TASK_COMPLETED_SUCCESSFULLY\",\"action\":\"Task completed successfully\",\"createdAt\":\"2020-07-28T10:51:39.000Z\",\"driverName\":\"Noor Hassan\",\"amountCollected\":152.81,\"collectionMethod\":\"Prepaid\"},{\"location\":{\"city\":\"QualityFood Distribution Center\"},\"arg\":{},\"id\":54067658,\"type\":\"TASK_EDITED\",\"action\":\"Task edited\",\"createdAt\":\"2020-07-28T10:51:39.000Z\",\"driverName\":\"Noor Hassan\",\"amountCollected\":0,\"collectionMethod\":\"Prepaid\"},{\"location\":{\"city\":\"QualityFood Distribution Center\"},\"arg\":{},\"id\":54067659,\"type\":\"SMS_SENT\",\"action\":\"Sms has been sent to Annie Khan\",\"createdAt\":\"2020-07-28T10:51:39.000Z\",\"driverName\":\"Noor Hassan\",\"amountCollected\":0,\"collectionMethod\":\"Prepaid\"}]}}}', '2020-07-28 10:51:41', 0, 0, NULL, 0, NULL, 0),
(212343, '2296693293107', '6634902', '152.81', 'Succeeded', '{\"taskId\":6634902,\"data\":{\"task\":{\"id\":6634902,\"awb\":\"2006277989622888\",\"details\":\"#LQF50448 | 2296693293107 | HImalyan Pink Salt - 2 | Organic Mango Pickle (Oil Free) - 1 | Yellow Zuchini - 1 | Okra \\\"Lady Fingers\\\" - 1 | Organic Gluten-Free Tricolour Spaghetti - 1 | Koko Coconut Milk Unsweetened - 2 | Organic Free Range Eggs 10 Pcs - 1\",\"customerNotes\":null,\"totalPrice\":152.81,\"leftToBePaid\":152.81,\"deliveryPrice\":null,\"currency\":\"AED\",\"inventory\":null,\"priority\":582051,\"cancelReason\":null,\"cancelSubReason\":null,\"quantity\":1,\"sentETA\":false,\"eta\":0,\"etaText\":null,\"serviceTime\":null,\"uuid\":\"B1T1XM2eP\",\"startedAt\":\"2020-07-28T10:47:40.000Z\",\"completedAt\":\"2020-07-28T10:51:39.000Z\",\"lastLocationLat\":null,\"lastLocationLng\":null,\"collectPayment\":true,\"completeBefore\":\"2020-07-28T17:00:00.000Z\",\"completeAfter\":\"2020-07-28T05:00:00.000Z\",\"pickupTask\":false,\"arrivalTime\":null,\"mobileTaskForm\":null,\"route\":\"task-route/1595933499356-1595933499.178165\",\"sendNotifications\":true,\"driverArrived\":true,\"arrivedAt\":\"2020-07-28T10:48:28.000Z\",\"taskWillBeDelayed\":false,\"taskDelayed\":false,\"numberOfAttempts\":1,\"lastAssignedAt\":\"2020-07-27T10:19:24.000Z\",\"returnedAt\":null,\"cancelledAt\":null,\"pickedUpAt\":null,\"readyToDispatchAt\":null,\"senderName\":null,\"firstReceivedIn\":null,\"pickUpFrom\":null,\"runsheetCreatedBy\":null,\"weight\":null,\"reference\":null,\"deliveryStatus\":null,\"createdAt\":\"2020-07-27T08:40:06.000Z\",\"updatedAt\":\"2020-07-28T10:51:39.000Z\",\"ownerId\":1888,\"fulfillerId\":1888,\"userId\":8974,\"returnById\":null,\"teamId\":null,\"customerId\":2158336,\"statusId\":9,\"paymentTypeId\":3,\"owner\":{\"id\":1888,\"name\":\"QualityFood.ae\",\"email\":\"omar.osman@qualityfood.ae\",\"phone\":\"+971554997353\"},\"fulfiller\":{\"id\":1888,\"name\":\"QualityFood.ae\",\"email\":\"omar.osman@qualityfood.ae\",\"phone\":\"+971554997353\"},\"user\":{\"id\":8974,\"name\":\"Noor Hassan\",\"phone\":\"+971559650095\"},\"team\":null,\"customer\":{\"id\":2158336,\"name\":\"Annie Khan\",\"address\":null,\"addressSecondLine\":null,\"email\":null,\"phone\":\"0508954792\",\"lat\":null,\"lng\":null,\"createdAt\":\"2019-11-11T06:40:02.000Z\",\"updatedAt\":\"2019-11-11T06:40:02.000Z\",\"companyId\":1888},\"status\":{\"id\":9,\"name\":\"Succeeded\"},\"paymentType\":{\"id\":3,\"name\":\"Prepaid\"},\"address\":{\"lat\":25.3242234,\"lng\":55.3736981,\"address\":\"Al khan corniche - 1703 , beach tower 2 \",\"addressSecondLine\":null,\"city\":\"Sharjah\",\"area\":\"Sharjah \",\"country\":\"AE\",\"streetNumber\":\"Al khan corniche\",\"streetName\":\"1703 , beach tower 2 \",\"postalCode\":null,\"instructions\":null,\"nickname\":null},\"notes\":[{\"id\":4432126,\"note\":null,\"image\":\"task-signatures/1595933500062-IMG_signatures_20200728105139196.jpg\",\"type\":3,\"createdAt\":\"2020-07-28T10:51:40.000Z\",\"updatedAt\":\"2020-07-28T10:51:40.000Z\",\"userId\":8974,\"taskId\":6634902,\"user\":{\"id\":8974,\"name\":\"Noor Hassan\"}},{\"id\":4432127,\"note\":null,\"image\":\"task-photos/1595933500269-IMG_images_20200728105139187.jpg\",\"type\":2,\"createdAt\":\"2020-07-28T10:51:40.000Z\",\"updatedAt\":\"2020-07-28T10:51:40.000Z\",\"userId\":8974,\"taskId\":6634902,\"user\":{\"id\":8974,\"name\":\"Noor Hassan\"}}],\"customFields\":[{\"id\":10509146,\"fieldKey\":\"ispartiallypaid\",\"fieldType\":\"DROPDOWN\",\"fieldValue\":\"No\"}],\"timelines\":[{\"location\":null,\"arg\":null,\"id\":54006465,\"type\":\"TASK_CREATED\",\"action\":\"Task created\",\"createdAt\":\"2020-07-27T08:40:06.000Z\",\"driverName\":null,\"amountCollected\":null,\"collectionMethod\":null},{\"location\":{\"city\":\"QualityFood Distribution Center\"},\"arg\":{},\"id\":54011722,\"type\":\"TASK_ASSIGNED\",\"action\":\"Task assigned\",\"createdAt\":\"2020-07-27T10:19:24.000Z\",\"driverName\":\"Noor Hassan\",\"amountCollected\":0,\"collectionMethod\":\"Prepaid\"},{\"location\":{\"city\":\"QualityFood Distribution Center\"},\"arg\":{},\"id\":54067417,\"type\":\"TASK_STARTED\",\"action\":\"Task started\",\"createdAt\":\"2020-07-28T10:47:40.000Z\",\"driverName\":\"Noor Hassan\",\"amountCollected\":0,\"collectionMethod\":\"Prepaid\"},{\"location\":{\"city\":\"QualityFood Distribution Center\"},\"arg\":{},\"id\":54067457,\"type\":\"DRIVER_ARRIVED\",\"action\":\"Driver arrived\",\"createdAt\":\"2020-07-28T10:48:28.000Z\",\"driverName\":\"Noor Hassan\",\"amountCollected\":0,\"collectionMethod\":\"Prepaid\"},{\"location\":{\"city\":\"QualityFood Distribution Center\"},\"arg\":{},\"id\":54067657,\"type\":\"TASK_COMPLETED_SUCCESSFULLY\",\"action\":\"Task completed successfully\",\"createdAt\":\"2020-07-28T10:51:39.000Z\",\"driverName\":\"Noor Hassan\",\"amountCollected\":152.81,\"collectionMethod\":\"Prepaid\"},{\"location\":{\"city\":\"QualityFood Distribution Center\"},\"arg\":{},\"id\":54067658,\"type\":\"TASK_EDITED\",\"action\":\"Task edited\",\"createdAt\":\"2020-07-28T10:51:39.000Z\",\"driverName\":\"Noor Hassan\",\"amountCollected\":0,\"collectionMethod\":\"Prepaid\"},{\"location\":{\"city\":\"QualityFood Distribution Center\"},\"arg\":{},\"id\":54067659,\"type\":\"SMS_SENT\",\"action\":\"Sms has been sent to Annie Khan\",\"createdAt\":\"2020-07-28T10:51:39.000Z\",\"driverName\":\"Noor Hassan\",\"amountCollected\":0,\"collectionMethod\":\"Prepaid\"}]}}}', '2020-07-28 10:51:41', 0, 0, NULL, 0, NULL, 0),
(212344, '2296693293107', '6634902', '152.81', 'Succeeded', '{\"taskId\":6634902,\"data\":{\"task\":{\"id\":6634902,\"awb\":\"2006277989622888\",\"details\":\"#LQF50448 | 2296693293107 | HImalyan Pink Salt - 2 | Organic Mango Pickle (Oil Free) - 1 | Yellow Zuchini - 1 | Okra \\\"Lady Fingers\\\" - 1 | Organic Gluten-Free Tricolour Spaghetti - 1 | Koko Coconut Milk Unsweetened - 2 | Organic Free Range Eggs 10 Pcs - 1\",\"customerNotes\":null,\"totalPrice\":152.81,\"leftToBePaid\":152.81,\"deliveryPrice\":null,\"currency\":\"AED\",\"inventory\":null,\"priority\":582051,\"cancelReason\":null,\"cancelSubReason\":null,\"quantity\":1,\"sentETA\":false,\"eta\":0,\"etaText\":null,\"serviceTime\":null,\"uuid\":\"B1T1XM2eP\",\"startedAt\":\"2020-07-28T10:47:40.000Z\",\"completedAt\":\"2020-07-28T10:51:39.000Z\",\"lastLocationLat\":null,\"lastLocationLng\":null,\"collectPayment\":true,\"completeBefore\":\"2020-07-28T17:00:00.000Z\",\"completeAfter\":\"2020-07-28T05:00:00.000Z\",\"pickupTask\":false,\"arrivalTime\":null,\"mobileTaskForm\":null,\"route\":\"task-route/1595933499356-1595933499.178165\",\"sendNotifications\":true,\"driverArrived\":true,\"arrivedAt\":\"2020-07-28T10:48:28.000Z\",\"taskWillBeDelayed\":false,\"taskDelayed\":false,\"numberOfAttempts\":1,\"lastAssignedAt\":\"2020-07-27T10:19:24.000Z\",\"returnedAt\":null,\"cancelledAt\":null,\"pickedUpAt\":null,\"readyToDispatchAt\":null,\"senderName\":null,\"firstReceivedIn\":null,\"pickUpFrom\":null,\"runsheetCreatedBy\":null,\"weight\":null,\"reference\":null,\"deliveryStatus\":null,\"createdAt\":\"2020-07-27T08:40:06.000Z\",\"updatedAt\":\"2020-07-28T10:51:39.000Z\",\"ownerId\":1888,\"fulfillerId\":1888,\"userId\":8974,\"returnById\":null,\"teamId\":null,\"customerId\":2158336,\"statusId\":9,\"paymentTypeId\":3,\"owner\":{\"id\":1888,\"name\":\"QualityFood.ae\",\"email\":\"omar.osman@qualityfood.ae\",\"phone\":\"+971554997353\"},\"fulfiller\":{\"id\":1888,\"name\":\"QualityFood.ae\",\"email\":\"omar.osman@qualityfood.ae\",\"phone\":\"+971554997353\"},\"user\":{\"id\":8974,\"name\":\"Noor Hassan\",\"phone\":\"+971559650095\"},\"team\":null,\"customer\":{\"id\":2158336,\"name\":\"Annie Khan\",\"address\":null,\"addressSecondLine\":null,\"email\":null,\"phone\":\"0508954792\",\"lat\":null,\"lng\":null,\"createdAt\":\"2019-11-11T06:40:02.000Z\",\"updatedAt\":\"2019-11-11T06:40:02.000Z\",\"companyId\":1888},\"status\":{\"id\":9,\"name\":\"Succeeded\"},\"paymentType\":{\"id\":3,\"name\":\"Prepaid\"},\"address\":{\"lat\":25.3242234,\"lng\":55.3736981,\"address\":\"Al khan corniche - 1703 , beach tower 2 \",\"addressSecondLine\":null,\"city\":\"Sharjah\",\"area\":\"Sharjah \",\"country\":\"AE\",\"streetNumber\":\"Al khan corniche\",\"streetName\":\"1703 , beach tower 2 \",\"postalCode\":null,\"instructions\":null,\"nickname\":null},\"notes\":[{\"id\":4432126,\"note\":null,\"image\":\"task-signatures/1595933500062-IMG_signatures_20200728105139196.jpg\",\"type\":3,\"createdAt\":\"2020-07-28T10:51:40.000Z\",\"updatedAt\":\"2020-07-28T10:51:40.000Z\",\"userId\":8974,\"taskId\":6634902,\"user\":{\"id\":8974,\"name\":\"Noor Hassan\"}},{\"id\":4432127,\"note\":null,\"image\":\"task-photos/1595933500269-IMG_images_20200728105139187.jpg\",\"type\":2,\"createdAt\":\"2020-07-28T10:51:40.000Z\",\"updatedAt\":\"2020-07-28T10:51:40.000Z\",\"userId\":8974,\"taskId\":6634902,\"user\":{\"id\":8974,\"name\":\"Noor Hassan\"}}],\"customFields\":[{\"id\":10509146,\"fieldKey\":\"ispartiallypaid\",\"fieldType\":\"DROPDOWN\",\"fieldValue\":\"No\"}],\"timelines\":[{\"location\":null,\"arg\":null,\"id\":54006465,\"type\":\"TASK_CREATED\",\"action\":\"Task created\",\"createdAt\":\"2020-07-27T08:40:06.000Z\",\"driverName\":null,\"amountCollected\":null,\"collectionMethod\":null},{\"location\":{\"city\":\"QualityFood Distribution Center\"},\"arg\":{},\"id\":54011722,\"type\":\"TASK_ASSIGNED\",\"action\":\"Task assigned\",\"createdAt\":\"2020-07-27T10:19:24.000Z\",\"driverName\":\"Noor Hassan\",\"amountCollected\":0,\"collectionMethod\":\"Prepaid\"},{\"location\":{\"city\":\"QualityFood Distribution Center\"},\"arg\":{},\"id\":54067417,\"type\":\"TASK_STARTED\",\"action\":\"Task started\",\"createdAt\":\"2020-07-28T10:47:40.000Z\",\"driverName\":\"Noor Hassan\",\"amountCollected\":0,\"collectionMethod\":\"Prepaid\"},{\"location\":{\"city\":\"QualityFood Distribution Center\"},\"arg\":{},\"id\":54067457,\"type\":\"DRIVER_ARRIVED\",\"action\":\"Driver arrived\",\"createdAt\":\"2020-07-28T10:48:28.000Z\",\"driverName\":\"Noor Hassan\",\"amountCollected\":0,\"collectionMethod\":\"Prepaid\"},{\"location\":{\"city\":\"QualityFood Distribution Center\"},\"arg\":{},\"id\":54067657,\"type\":\"TASK_COMPLETED_SUCCESSFULLY\",\"action\":\"Task completed successfully\",\"createdAt\":\"2020-07-28T10:51:39.000Z\",\"driverName\":\"Noor Hassan\",\"amountCollected\":152.81,\"collectionMethod\":\"Prepaid\"},{\"location\":{\"city\":\"QualityFood Distribution Center\"},\"arg\":{},\"id\":54067658,\"type\":\"TASK_EDITED\",\"action\":\"Task edited\",\"createdAt\":\"2020-07-28T10:51:39.000Z\",\"driverName\":\"Noor Hassan\",\"amountCollected\":0,\"collectionMethod\":\"Prepaid\"},{\"location\":{\"city\":\"QualityFood Distribution Center\"},\"arg\":{},\"id\":54067659,\"type\":\"SMS_SENT\",\"action\":\"Sms has been sent to Annie Khan\",\"createdAt\":\"2020-07-28T10:51:39.000Z\",\"driverName\":\"Noor Hassan\",\"amountCollected\":0,\"collectionMethod\":\"Prepaid\"}]}}}', '2020-07-28 10:51:41', 0, 0, NULL, 0, NULL, 0),
(212345, '2295947427891', '6631171', '491', 'Unassigned', '{\"taskId\":6631171,\"data\":{\"task\":{\"id\":6631171,\"awb\":\"2006263934920888\",\"details\":\"#LQF50420 | 2295947427891 | Oyster King Mushroom - 1 | Little Gem Lettuce - 1 | Bird Red Chilli - 1 | Thyme - 1 | Tomato Beef - 2 | Green Marrow - 2 | Organic Cucumber - 2 | Rosemary - 1 | Mint Leaves - 1 | Green Broccoli - 1 | Cauliflower - 1 | Green Li\",\"customerNotes\":null,\"totalPrice\":491,\"leftToBePaid\":491,\"deliveryPrice\":null,\"currency\":\"AED\",\"inventory\":null,\"priority\":582022,\"cancelReason\":null,\"cancelSubReason\":null,\"quantity\":1,\"sentETA\":false,\"eta\":0,\"etaText\":null,\"serviceTime\":null,\"uuid\":\"SkDZeOogP\",\"startedAt\":null,\"completedAt\":null,\"lastLocationLat\":null,\"lastLocationLng\":null,\"collectPayment\":true,\"completeBefore\":\"2020-07-29T17:00:00.000Z\",\"completeAfter\":\"2020-07-29T05:00:00.000Z\",\"pickupTask\":false,\"arrivalTime\":null,\"mobileTaskForm\":null,\"route\":null,\"sendNotifications\":true,\"driverArrived\":false,\"arrivedAt\":null,\"taskWillBeDelayed\":false,\"taskDelayed\":false,\"numberOfAttempts\":0,\"lastAssignedAt\":null,\"returnedAt\":null,\"cancelledAt\":null,\"pickedUpAt\":null,\"readyToDispatchAt\":null,\"senderName\":null,\"firstReceivedIn\":null,\"pickUpFrom\":null,\"runsheetCreatedBy\":null,\"weight\":null,\"reference\":null,\"deliveryStatus\":null,\"createdAt\":\"2020-07-26T21:05:03.000Z\",\"updatedAt\":\"2020-07-28T10:56:11.000Z\",\"ownerId\":1888,\"fulfillerId\":5217,\"userId\":null,\"returnById\":null,\"teamId\":null,\"customerId\":2804858,\"statusId\":1,\"paymentTypeId\":2,\"owner\":{\"id\":1888,\"name\":\"QualityFood.ae\",\"email\":\"omar.osman@qualityfood.ae\",\"phone\":\"+971554997353\"},\"fulfiller\":{\"id\":5217,\"name\":\"Aramex\",\"email\":\"wmaramex@getnada.com\",\"phone\":null},\"user\":null,\"team\":null,\"customer\":{\"id\":2804858,\"name\":\"Ahmed Ebrahim\",\"address\":null,\"addressSecondLine\":null,\"email\":null,\"phone\":\"0501262567\",\"lat\":null,\"lng\":null,\"createdAt\":\"2020-05-31T15:15:04.000Z\",\"updatedAt\":\"2020-05-31T15:15:04.000Z\",\"companyId\":1888},\"status\":{\"id\":1,\"name\":\"Unassigned\"},\"paymentType\":{\"id\":2,\"name\":\"Collect Credit Card\"},\"address\":{\"lat\":24.2368473,\"lng\":55.7241144,\"address\":\"Al Ain city , Shabhanat alkhabisi , Alghaf street - Complex 171 , Villa 11\",\"addressSecondLine\":null,\"city\":\"Al Ain\",\"area\":\"Al Ain city \",\"country\":\"AE\",\"streetNumber\":\"Al Ain city , Shabhanat alkhabisi , Alghaf street \",\"streetName\":\"Complex 171 , Villa 11\",\"postalCode\":null,\"instructions\":null,\"nickname\":null},\"notes\":[],\"customFields\":[{\"id\":10502962,\"fieldKey\":\"ispartiallypaid\",\"fieldType\":\"DROPDOWN\",\"fieldValue\":\"No\"}],\"timelines\":[{\"location\":null,\"arg\":null,\"id\":53982800,\"type\":\"TASK_CREATED\",\"action\":\"Task created\",\"createdAt\":\"2020-07-26T21:05:03.000Z\",\"driverName\":null,\"amountCollected\":null,\"collectionMethod\":null},{\"location\":{\"city\":\"QualityFood Distribution Center\"},\"arg\":{},\"id\":54050388,\"type\":\"TASK_EDITED\",\"action\":\"Task edited\",\"createdAt\":\"2020-07-28T05:15:22.000Z\",\"driverName\":null,\"amountCollected\":0,\"collectionMethod\":\"Collect Credit Card\"}]}}}', '2020-07-28 10:56:13', 0, 0, NULL, 0, NULL, 0),
(212346, '2296126472243', '6631209', '283.25', 'Unassigned', '{\"taskId\":6631209,\"data\":{\"task\":{\"id\":6631209,\"awb\":\"2006267005522888\",\"details\":\"#LQF50426 | 2296126472243 | Acai Puree All Natural - Frozen 3.2 KG bucket - 1 | Organic Original Peanut Butter Sweet - 1\",\"customerNotes\":null,\"totalPrice\":283.25,\"leftToBePaid\":283.25,\"deliveryPrice\":null,\"currency\":\"AED\",\"inventory\":null,\"priority\":582027,\"cancelReason\":null,\"cancelSubReason\":null,\"quantity\":1,\"sentETA\":false,\"eta\":0,\"etaText\":null,\"serviceTime\":null,\"uuid\":\"HJmWGqslD\",\"startedAt\":null,\"completedAt\":null,\"lastLocationLat\":null,\"lastLocationLng\":null,\"collectPayment\":true,\"completeBefore\":\"2020-07-29T17:00:00.000Z\",\"completeAfter\":\"2020-07-29T05:00:00.000Z\",\"pickupTask\":false,\"arrivalTime\":null,\"mobileTaskForm\":null,\"route\":null,\"sendNotifications\":true,\"driverArrived\":false,\"arrivedAt\":null,\"taskWillBeDelayed\":false,\"taskDelayed\":false,\"numberOfAttempts\":0,\"lastAssignedAt\":null,\"returnedAt\":null,\"cancelledAt\":null,\"pickedUpAt\":null,\"readyToDispatchAt\":null,\"senderName\":null,\"firstReceivedIn\":null,\"pickUpFrom\":null,\"runsheetCreatedBy\":null,\"weight\":null,\"reference\":null,\"deliveryStatus\":null,\"createdAt\":\"2020-07-26T23:30:03.000Z\",\"updatedAt\":\"2020-07-28T10:56:11.000Z\",\"ownerId\":1888,\"fulfillerId\":5217,\"userId\":null,\"returnById\":null,\"teamId\":null,\"customerId\":3019265,\"statusId\":1,\"paymentTypeId\":1,\"owner\":{\"id\":1888,\"name\":\"QualityFood.ae\",\"email\":\"omar.osman@qualityfood.ae\",\"phone\":\"+971554997353\"},\"fulfiller\":{\"id\":5217,\"name\":\"Aramex\",\"email\":\"wmaramex@getnada.com\",\"phone\":null},\"user\":null,\"team\":null,\"customer\":{\"id\":3019265,\"name\":\"Aysha Almansouri\",\"address\":null,\"addressSecondLine\":null,\"email\":null,\"phone\":\"0509387788\",\"lat\":null,\"lng\":null,\"createdAt\":\"2020-07-26T23:30:03.000Z\",\"updatedAt\":\"2020-07-26T23:30:03.000Z\",\"companyId\":1888},\"status\":{\"id\":1,\"name\":\"Unassigned\"},\"paymentType\":{\"id\":1,\"name\":\"Collect Cash\"},\"address\":{\"lat\":24.2126478,\"lng\":55.6596107,\"address\":\"Al Markhaniya - villa 63 street 5\",\"addressSecondLine\":null,\"city\":\"Al Ain\",\"area\":\"Al Ain\",\"country\":\"AE\",\"streetNumber\":\"Al Markhaniya\",\"streetName\":\"villa 63 street 5\",\"postalCode\":null,\"instructions\":null,\"nickname\":null},\"notes\":[],\"customFields\":[{\"id\":10502982,\"fieldKey\":\"ispartiallypaid\",\"fieldType\":\"DROPDOWN\",\"fieldValue\":\"No\"}],\"timelines\":[{\"location\":null,\"arg\":null,\"id\":53983082,\"type\":\"TASK_CREATED\",\"action\":\"Task created\",\"createdAt\":\"2020-07-26T23:30:03.000Z\",\"driverName\":null,\"amountCollected\":null,\"collectionMethod\":null},{\"location\":{\"city\":\"QualityFood Distribution Center\"},\"arg\":{},\"id\":54050379,\"type\":\"TASK_EDITED\",\"action\":\"Task edited\",\"createdAt\":\"2020-07-28T05:14:59.000Z\",\"driverName\":null,\"amountCollected\":0,\"collectionMethod\":\"Collect Cash\"}]}}}', '2020-07-28 10:56:13', 0, 0, NULL, 0, NULL, 0),
(
INSERT INTO `customers_master` (`id`, `shopify_customer_id`, `shopify_customer_email`, `shopify_customer_first_name`, `shopify_customer_last_name`, `shopify_customer_phone`, `shopify_customer_phone2`, `shopify_customer_gender`, `shopify_customer_email_gender`, `shopify_customer_notes`, `status`) VALUES
(71749, '2955812110407', 'conniepo@mac.com', 'Connie', 'Cali-Poutre', '+19088896230', NULL, '', '', '', 1),
(71750, '2955812143175', 'paris1818@comcast.net', 'Paris', 'Bradford', '+12677732810', NULL, '', '', '', 1),
(71751, '2955812175943', 'baileybeki@yahoo.com', 'rebecca', 'holt', '+16784994238', NULL, '', '', '', 1),
(71752, '2955812208711', 'ann_queen@us.aflac.com', 'Ann', 'Queen', NULL, NULL, '', '', '', 1),
(71753, '2955812241479', 'rubyjohnson930@yahoo.com', 'Ruby', 'Johnson', '+19732105992', NULL, '', '', '', 1),
(71754, '2955812274247', 'christina.crader@sbseniorliving.com', 'Christina', 'Crader', NULL, NULL, '', '', '', 1),
(71755, '2955812307015', 'jburt@plymouth.k12.ma.us', 'Jane', 'Burt', '+15088304400', NULL, '', '', '', 1),
(71756, '2955812339783', 'ogethers@gmail.com', 'Octavia', 'Gethers', '+18438994739', NULL, '', '', '', 1),
(71757, '2955812438087', 'sfowler@rhmail.org', 'Kelly', 'Kane', '+18039802083', NULL, '', '', '', 1),
(71758, '2955812470855', 'fbarblyn313@aol.com', 'barbara', 'fields', '+17164407229', NULL, '', '', '', 1),
(71759, '2955812569159', 'activities_goldengaldesnursing.com@gmail.com', 'Ashley', 'Molina', '+13056538427', NULL, '', '', '', 1),
(71760, '2955812601927', 'kgrummel@hotmail.com', 'KATHLEEN', 'GRUMMEL', NULL, NULL, '', '', '', 1),
(71761, '2955812634695', 'aertz1025@gmail.com', 'Anna', 'Ertz', '+13197506192', NULL, '', '', '', 1),
(71762, '2955812667463', 'goodshepherdhumanesociety@yahoo.com', 'Tracellen', 'Kelly', '+14792539115', NULL, '', '', '', 1),
(71763, '2955812700231', 'willettarichie@comcast.net', 'Willetta', 'Richie', '+19049828609', NULL, '', '', '', 1),
(71764, '2955812732999', 'katie.a.partington@gmail.com', 'Katie', 'Partington', '+18172395030', NULL, '', '', '', 1),
(71765, '2955812765767', 'mydreams76@yahoo.com', 'Gerald', 'Johnson', '+19033601594', NULL, '', '', '', 1),
(71766, '2955812798535', 'lmcintire5@bellsouth.net', 'LISA', 'MCINTIRE', '+16626869860', NULL, '', '', '', 1),
(71767, '2955812831303', 'proudheartmama@yahoo.com', 'SARA', 'BIASUTTI', '+18018155194', NULL, '', '', '', 1),-----------------------------------------------'\_______________________________________________________
---------------------------------------------------------------------------------------------Size - 10gb
---------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------
---------------------------------------------------------------------------'\_______________________________________________________
Last edited by a moderator:
, cool stuff!
