select shopifyCursor from newsystem_orders where orderType='shopify' and store = 'SRI' and shopifyCursor!='' order by orderID desc limit 1
DB Cursor --eyJsYXN0X2lkIjo1OTExMTc1Mzk3NTU2LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAxMzo1NDoyMy4yNDU3MzYifQ==eyJsYXN0X2lkIjo1OTExMTc1Mzk3NTU2LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAxMzo1NDoyMy4yNDU3MzYifQ==SRI#98805 processing
rflechas18@gmail.com processing
INSERT INTO `newsystem_customers` ( `newSystemMemberID`, `emailAddress`, `firstName`, `lastName`, `tradingName`, `homePhone`, `mobile`, `street`, `city`, `postCode`, `state`, `country`, `pending`, `middleEntryDate`) VALUES ( 'gid://shopify/Customer/7372541460660','rflechas18@gmail.com', 'Rosanna', 'Licitra', '', '5163694000', '5163694000', '1018 Sunset Avenue ', 'Island Park','11558', 'New York', 'United States', '1', '2026-03-13 14:25:25')gid://shopify/Order/5911207444660Exported
New Cursor --eyJsYXN0X2lkIjo1OTExMjA3NDQ0NjYwLCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAxNDoyMzo0My40NDM1ODQifQ==INSERT INTO `newsystem_orders` SET `newSystemOrderID`='gid://shopify/Order/5911207444660' ,`newSystemOrderNumber`='SRI#98805' ,`newSystemCustomerID`='gid://shopify/Customer/7372541460660' ,`shopify_recommendation`='LOW' ,`order_created`='2024-09-19 07:23:47' ,`newSystemCustomerEmail`='rflechas18@gmail.com' ,`order_completed`='2024-09-19 07:23:43' ,`currency`='USD' ,`order_total`='249.82' ,`order_subtotal`='229.99' ,`total_items`='1' ,`shipping_methods`='shopify' ,`total_shipping`='0.0' ,`payment_detail_title`='Shopify_Payments' ,`payment_detail_status`='PAID' ,`note`='' ,`taxAmount`='19.83' ,`coupon_code`='DRYQFALL' ,`coupon_amount`='70.0' ,`internalPaymentType`='Shopify_Payments' ,`fullfillment_status`='FULFILLED' ,`shipping_country`='United States' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTExMjA3NDQ0NjYwLCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAxNDoyMzo0My40NDM1ODQifQ==' ,`store`='SRI'
Array
(
[newSystemOrderID] => gid://shopify/Order/5911207444660
[newSystemProductId] => gid://shopify/LineItem/14371210330292
[stockCode] => SRI-DryQ-Ver2
[actualCIStockCode] => SRI-DryQ-Ver2
[quantity] => 1
[unitPrice] => 299.99
[discountAmount] => 0.0
[store] => SRI
)
INSERT INTO `newsystem_orders_product` SET `newSystemOrderID`='gid://shopify/Order/5911207444660' ,`newSystemProductId`='gid://shopify/LineItem/14371210330292' ,`stockCode`='SRI-DryQ-Ver2' ,`actualCIStockCode`='SRI-DryQ-Ver2' ,`quantity`='1' ,`unitPrice`='299.99' ,`discountAmount`='0.0' ,`store`='SRI'INSERT INTO `newsystem_order_delivery` SET `newSystemMemberID`='gid://shopify/Customer/7372541460660' ,`newSystemOrderID`='gid://shopify/Order/5911207444660' ,`deliveryFirstName`='Rosanna' ,`deliveryLastName`='Licitra' ,`deliveryPhone`='5163694000' ,`deliveryStreet`='1018 Sunset Avenue ' ,`deliverySuburb`='' ,`deliveryPostCode`='11558' ,`deliveryCountry`='United States' ,`deliveryCity`='Island Park' ,`deliveryState`='New York' ,`store`='SRI'SRI#98806 processing
kim.coop18@gmail.com processing
UPDATE `newsystem_customers` SET `emailAddress`='kim.coop18@gmail.com', `firstName`='Kim', `lastName`='Cooper', `tradingName`='', `homePhone`='6787731631', `mobile`='6787731631', `street`= '2448 Red Wine Oak Drive ', `city`='Braselton', `postCode`='30517', `state`='Georgia', `country`='United States', `pending`='1', `middleEntryDate`='2026-03-13 14:25:25' where `newSystemMemberID`='gid://shopify/Customer/6500574691508'gid://shopify/Order/5911226777780Exported
New Cursor --eyJsYXN0X2lkIjo1OTExMjI2Nzc3NzgwLCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAxNDo0MDoyMC42NjUzNTIifQ==INSERT INTO `newsystem_orders` SET `newSystemOrderID`='gid://shopify/Order/5911226777780' ,`newSystemOrderNumber`='SRI#98806' ,`newSystemCustomerID`='gid://shopify/Customer/6500574691508' ,`shopify_recommendation`='LOW' ,`order_created`='2024-09-19 07:40:24' ,`newSystemCustomerEmail`='kim.coop18@gmail.com' ,`order_completed`='2024-09-19 07:40:20' ,`currency`='USD' ,`order_total`='148.73' ,`order_subtotal`='139.0' ,`total_items`='1' ,`shipping_methods`='shopify' ,`total_shipping`='0.0' ,`payment_detail_title`='Shopify_Payments' ,`payment_detail_status`='PAID' ,`note`='' ,`taxAmount`='9.73' ,`coupon_code`='SUPRACURLFALL' ,`coupon_amount`='60.0' ,`internalPaymentType`='Shopify_Payments' ,`fullfillment_status`='FULFILLED' ,`shipping_country`='United States' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTExMjI2Nzc3NzgwLCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAxNDo0MDoyMC42NjUzNTIifQ==' ,`store`='SRI'
Array
(
[newSystemOrderID] => gid://shopify/Order/5911226777780
[newSystemProductId] => gid://shopify/LineItem/14371251716276
[stockCode] => SRISupraCurlX1
[actualCIStockCode] => SRI-SupraCurl-Ver1-X1
[quantity] => 1
[unitPrice] => 199.00
[discountAmount] => 0.0
[store] => SRI
)
INSERT INTO `newsystem_orders_product` SET `newSystemOrderID`='gid://shopify/Order/5911226777780' ,`newSystemProductId`='gid://shopify/LineItem/14371251716276' ,`stockCode`='SRISupraCurlX1' ,`actualCIStockCode`='SRI-SupraCurl-Ver1-X1' ,`quantity`='1' ,`unitPrice`='199.00' ,`discountAmount`='0.0' ,`store`='SRI'INSERT INTO `newsystem_order_delivery` SET `newSystemMemberID`='gid://shopify/Customer/6500574691508' ,`newSystemOrderID`='gid://shopify/Order/5911226777780' ,`deliveryFirstName`='Kim' ,`deliveryLastName`='Cooper' ,`deliveryPhone`='6787731631' ,`deliveryStreet`='2448 Red Wine Oak Drive ' ,`deliverySuburb`='' ,`deliveryPostCode`='30517' ,`deliveryCountry`='United States' ,`deliveryCity`='Braselton' ,`deliveryState`='Georgia' ,`store`='SRI'SRI#98807 processing
johnson523@icloud.com processing
INSERT INTO `newsystem_customers` ( `newSystemMemberID`, `emailAddress`, `firstName`, `lastName`, `tradingName`, `homePhone`, `mobile`, `street`, `city`, `postCode`, `state`, `country`, `pending`, `middleEntryDate`) VALUES ( 'gid://shopify/Customer/7372952404148','johnson523@icloud.com', 'Cyndi', 'Ruud', '', '2628807813', '2628807813', '900 S Preston Rd Ste50 #369 ', 'Prosper','75078', 'Texas', 'United States', '1', '2026-03-13 14:25:25')gid://shopify/Order/5911231889588Exported
New Cursor --eyJsYXN0X2lkIjo1OTExMjMxODg5NTg4LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAxNDo0NDo1MS41MzQ3ODYifQ==INSERT INTO `newsystem_orders` SET `newSystemOrderID`='gid://shopify/Order/5911231889588' ,`newSystemOrderNumber`='SRI#98807' ,`newSystemCustomerID`='gid://shopify/Customer/7372952404148' ,`shopify_recommendation`='LOW' ,`order_created`='2024-09-19 07:44:55' ,`newSystemCustomerEmail`='johnson523@icloud.com' ,`order_completed`='2024-09-19 07:44:51' ,`currency`='USD' ,`order_total`='248.96' ,`order_subtotal`='229.99' ,`total_items`='1' ,`shipping_methods`='shopify' ,`total_shipping`='0.0' ,`payment_detail_title`='Shopify_Payments' ,`payment_detail_status`='PAID' ,`note`='' ,`taxAmount`='18.97' ,`coupon_code`='DRYQFALL' ,`coupon_amount`='70.0' ,`internalPaymentType`='Shopify_Payments' ,`fullfillment_status`='FULFILLED' ,`shipping_country`='United States' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTExMjMxODg5NTg4LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAxNDo0NDo1MS41MzQ3ODYifQ==' ,`store`='SRI'
Array
(
[newSystemOrderID] => gid://shopify/Order/5911231889588
[newSystemProductId] => gid://shopify/LineItem/14371261513908
[stockCode] => SRI-DryQ-Ver2
[actualCIStockCode] => SRI-DryQ-Ver2
[quantity] => 1
[unitPrice] => 299.99
[discountAmount] => 0.0
[store] => SRI
)
INSERT INTO `newsystem_orders_product` SET `newSystemOrderID`='gid://shopify/Order/5911231889588' ,`newSystemProductId`='gid://shopify/LineItem/14371261513908' ,`stockCode`='SRI-DryQ-Ver2' ,`actualCIStockCode`='SRI-DryQ-Ver2' ,`quantity`='1' ,`unitPrice`='299.99' ,`discountAmount`='0.0' ,`store`='SRI'INSERT INTO `newsystem_order_delivery` SET `newSystemMemberID`='gid://shopify/Customer/7372952404148' ,`newSystemOrderID`='gid://shopify/Order/5911231889588' ,`deliveryFirstName`='Cyndi' ,`deliveryLastName`='Ruud' ,`deliveryPhone`='2628807813' ,`deliveryStreet`='900 S Preston Rd Ste50 #369 ' ,`deliverySuburb`='' ,`deliveryPostCode`='75078' ,`deliveryCountry`='United States' ,`deliveryCity`='Prosper' ,`deliveryState`='Texas' ,`store`='SRI'