select shopifyCursor from newsystem_orders where orderType='shopify' and store = 'SRI' and shopifyCursor!='' order by orderID desc limit 1
DB Cursor --eyJsYXN0X2lkIjo1OTEzMDUyMjgzMDYwLCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMCAxNzo0NjoxNC4wODk1MTgifQ==eyJsYXN0X2lkIjo1OTEzMDUyMjgzMDYwLCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMCAxNzo0NjoxNC4wODk1MTgifQ==SRI#98914 processing
happyjem2018@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/7364037771444','happyjem2018@gmail.com', 'Jennifer', 'Mendelson', '', '4695007420', '4695007420', '38679 Dahlia Way ', 'Palm Desert','92211', 'California', 'United States', '1', '2026-06-17 15:48:43')gid://shopify/Order/5913075876020Exported
New Cursor --eyJsYXN0X2lkIjo1OTEzMDc1ODc2MDIwLCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMCAxODowMToyMS44ODcyOTgifQ==INSERT INTO `newsystem_orders` SET `newSystemOrderID`='gid://shopify/Order/5913075876020' ,`newSystemOrderNumber`='SRI#98914' ,`newSystemCustomerID`='gid://shopify/Customer/7364037771444' ,`shopify_recommendation`='LOW' ,`order_created`='2024-09-20 11:01:27' ,`newSystemCustomerEmail`='happyjem2018@gmail.com' ,`order_completed`='2024-09-20 11:01:21' ,`currency`='USD' ,`order_total`='252.53' ,`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`='22.54' ,`coupon_code`='DRYQFALL' ,`coupon_amount`='70.0' ,`internalPaymentType`='Shopify_Payments' ,`fullfillment_status`='FULFILLED' ,`shipping_country`='United States' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTEzMDc1ODc2MDIwLCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMCAxODowMToyMS44ODcyOTgifQ==' ,`store`='SRI'
Array
(
[newSystemOrderID] => gid://shopify/Order/5913075876020
[newSystemProductId] => gid://shopify/LineItem/14375105953972
[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/5913075876020' ,`newSystemProductId`='gid://shopify/LineItem/14375105953972' ,`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/7364037771444' ,`newSystemOrderID`='gid://shopify/Order/5913075876020' ,`deliveryFirstName`='Jennifer' ,`deliveryLastName`='Mendelson' ,`deliveryPhone`='4695007420' ,`deliveryStreet`='7042 Young Road NW ' ,`deliverySuburb`='' ,`deliveryPostCode`='98502' ,`deliveryCountry`='United States' ,`deliveryCity`='Olympia' ,`deliveryState`='Washington' ,`store`='SRI'SRI#98915 processing
jeritate@sbcglobal.net processing
INSERT INTO `newsystem_customers` ( `newSystemMemberID`, `emailAddress`, `firstName`, `lastName`, `tradingName`, `homePhone`, `mobile`, `street`, `city`, `postCode`, `state`, `country`, `pending`, `middleEntryDate`) VALUES ( 'gid://shopify/Customer/7381843837108','jeritate@sbcglobal.net', 'Jeri', 'Tate', '', '+19372668514', '+19372668514', '11167 Ashbury Meadows Dr ', 'Dayton','45458-6403', 'Ohio', 'United States', '1', '2026-06-17 15:48:43')gid://shopify/Order/5913089900724Exported
New Cursor --eyJsYXN0X2lkIjo1OTEzMDg5OTAwNzI0LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMCAxODowODo0MC40NzYyMjgifQ==INSERT INTO `newsystem_orders` SET `newSystemOrderID`='gid://shopify/Order/5913089900724' ,`newSystemOrderNumber`='SRI#98915' ,`newSystemCustomerID`='gid://shopify/Customer/7381843837108' ,`shopify_recommendation`='LOW' ,`order_created`='2024-09-20 11:08:45' ,`newSystemCustomerEmail`='jeritate@sbcglobal.net' ,`order_completed`='2024-09-20 11:08:40' ,`currency`='USD' ,`order_total`='247.92' ,`order_subtotal`='229.99' ,`total_items`='1' ,`shipping_methods`='shopify' ,`total_shipping`='0.0' ,`payment_detail_title`='PayPal' ,`payment_detail_status`='PAID' ,`note`='' ,`taxAmount`='17.93' ,`coupon_code`='DRYQFALL' ,`coupon_amount`='70.0' ,`internalPaymentType`='PayPal' ,`fullfillment_status`='FULFILLED' ,`shipping_country`='United States' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTEzMDg5OTAwNzI0LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMCAxODowODo0MC40NzYyMjgifQ==' ,`store`='SRI'
Array
(
[newSystemOrderID] => gid://shopify/Order/5913089900724
[newSystemProductId] => gid://shopify/LineItem/14375134396596
[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/5913089900724' ,`newSystemProductId`='gid://shopify/LineItem/14375134396596' ,`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/7381843837108' ,`newSystemOrderID`='gid://shopify/Order/5913089900724' ,`deliveryFirstName`='Jeri' ,`deliveryLastName`='Tate' ,`deliveryPhone`='+19372668514' ,`deliveryStreet`='11167 Ashbury Meadows Dr ' ,`deliverySuburb`='' ,`deliveryPostCode`='45458-6403' ,`deliveryCountry`='United States' ,`deliveryCity`='Dayton' ,`deliveryState`='Ohio' ,`store`='SRI'SRI#98916 processing
jeribaker123@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/7381842297012','jeribaker123@gmail.com', 'Jeri', 'Baker', '', '9048441648', '9048441648', '11313 Princessa Ln ', 'Jacksonville','32218', 'Florida', 'United States', '1', '2026-06-17 15:48:43')gid://shopify/Order/5913091047604Exported
New Cursor --eyJsYXN0X2lkIjo1OTEzMDkxMDQ3NjA0LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMCAxODowOToyNy4xNzg5NTkifQ==INSERT INTO `newsystem_orders` SET `newSystemOrderID`='gid://shopify/Order/5913091047604' ,`newSystemOrderNumber`='SRI#98916' ,`newSystemCustomerID`='gid://shopify/Customer/7381842297012' ,`shopify_recommendation`='LOW' ,`order_created`='2024-09-20 11:09:28' ,`newSystemCustomerEmail`='jeribaker123@gmail.com' ,`order_completed`='2024-09-20 11:09:27' ,`currency`='USD' ,`order_total`='247.24' ,`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`='17.25' ,`coupon_code`='DRYQFALL' ,`coupon_amount`='70.0' ,`internalPaymentType`='Shopify_Payments' ,`fullfillment_status`='FULFILLED' ,`shipping_country`='United States' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTEzMDkxMDQ3NjA0LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMCAxODowOToyNy4xNzg5NTkifQ==' ,`store`='SRI'
Array
(
[newSystemOrderID] => gid://shopify/Order/5913091047604
[newSystemProductId] => gid://shopify/LineItem/14375137378484
[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/5913091047604' ,`newSystemProductId`='gid://shopify/LineItem/14375137378484' ,`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/7381842297012' ,`newSystemOrderID`='gid://shopify/Order/5913091047604' ,`deliveryFirstName`='Jeri' ,`deliveryLastName`='Baker' ,`deliveryPhone`='9048441648' ,`deliveryStreet`='11313 Princessa Ln ' ,`deliverySuburb`='' ,`deliveryPostCode`='32218' ,`deliveryCountry`='United States' ,`deliveryCity`='Jacksonville' ,`deliveryState`='Florida' ,`store`='SRI'