select shopifyCursor from newsystem_orders where orderType='shopify' and store = 'SRI' and shopifyCursor!='' order by orderID desc limit 1
DB Cursor --eyJsYXN0X2lkIjo1OTE0NjEwNTY1MzAwLCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMSAxNzoxMTozMi41NDE2ODMifQ==eyJsYXN0X2lkIjo1OTE0NjEwNTY1MzAwLCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMSAxNzoxMTozMi41NDE2ODMifQ==SRI#99016 processing
rruhnke@verizon.net processing
INSERT INTO `newsystem_customers` ( `newSystemMemberID`, `emailAddress`, `firstName`, `lastName`, `tradingName`, `homePhone`, `mobile`, `street`, `city`, `postCode`, `state`, `country`, `pending`, `middleEntryDate`) VALUES ( 'gid://shopify/Customer/7387436613812','rruhnke@verizon.net', 'Robin', 'Ruhnke', '', '+19413568216', '+19413568216', '6919 Westchester Citcle ', 'Lakewood Ranch','34202', 'Florida', 'United States', '1', '2026-07-27 15:09:38')gid://shopify/Order/5914613940404Exported
New Cursor --eyJsYXN0X2lkIjo1OTE0NjEzOTQwNDA0LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMSAxNzoxMzozMy4wNTEyMTcifQ==INSERT INTO `newsystem_orders` SET `newSystemOrderID`='gid://shopify/Order/5914613940404' ,`newSystemOrderNumber`='SRI#99016' ,`newSystemCustomerID`='gid://shopify/Customer/7387436613812' ,`shopify_recommendation`='LOW' ,`order_created`='2024-09-21 10:13:36' ,`newSystemCustomerEmail`='rruhnke@verizon.net' ,`order_completed`='2024-09-21 10:13:33' ,`currency`='USD' ,`order_total`='202.23' ,`order_subtotal`='189.0' ,`total_items`='1' ,`shipping_methods`='shopify' ,`total_shipping`='0.0' ,`payment_detail_title`='PayPal' ,`payment_detail_status`='REFUNDED' ,`note`='' ,`taxAmount`='13.23' ,`coupon_code`='STEAMSTYLERFALL' ,`coupon_amount`='70.0' ,`internalPaymentType`='PayPal' ,`fullfillment_status`='FULFILLED' ,`shipping_country`='United States' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTE0NjEzOTQwNDA0LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMSAxNzoxMzozMy4wNTEyMTcifQ==' ,`store`='SRI'
Array
(
[newSystemOrderID] => gid://shopify/Order/5914613940404
[newSystemProductId] => gid://shopify/LineItem/14378344513716
[stockCode] => SRI-InfraroseSteamStyler-Ver1
[actualCIStockCode] => SRI-InfraroseSteamStyler-Ver1
[quantity] => 1
[unitPrice] => 259.00
[discountAmount] => 0.0
[store] => SRI
)
INSERT INTO `newsystem_orders_product` SET `newSystemOrderID`='gid://shopify/Order/5914613940404' ,`newSystemProductId`='gid://shopify/LineItem/14378344513716' ,`stockCode`='SRI-InfraroseSteamStyler-Ver1' ,`actualCIStockCode`='SRI-InfraroseSteamStyler-Ver1' ,`quantity`='1' ,`unitPrice`='259.00' ,`discountAmount`='0.0' ,`store`='SRI'INSERT INTO `newsystem_order_delivery` SET `newSystemMemberID`='gid://shopify/Customer/7387436613812' ,`newSystemOrderID`='gid://shopify/Order/5914613940404' ,`deliveryFirstName`='Robin' ,`deliveryLastName`='Ruhnke' ,`deliveryPhone`='+19413568216' ,`deliveryStreet`='6919 Westchester Citcle ' ,`deliverySuburb`='' ,`deliveryPostCode`='34202' ,`deliveryCountry`='United States' ,`deliveryCity`='Lakewood Ranch' ,`deliveryState`='Florida' ,`store`='SRI'SRI#99017 processing
jhart1987@live.com processing
INSERT INTO `newsystem_customers` ( `newSystemMemberID`, `emailAddress`, `firstName`, `lastName`, `tradingName`, `homePhone`, `mobile`, `street`, `city`, `postCode`, `state`, `country`, `pending`, `middleEntryDate`) VALUES ( 'gid://shopify/Customer/7387436941492','jhart1987@live.com', 'Joan', 'Hart', '', '5184217883', '5184217883', '4 Windmill Way ', 'Cohoes','12047', 'New York', 'United States', '1', '2026-07-27 15:09:38')gid://shopify/Order/5914614104244Exported
New Cursor --eyJsYXN0X2lkIjo1OTE0NjE0MTA0MjQ0LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMSAxNzoxMzozNi4xNDM3MTQifQ==INSERT INTO `newsystem_orders` SET `newSystemOrderID`='gid://shopify/Order/5914614104244' ,`newSystemOrderNumber`='SRI#99017' ,`newSystemCustomerID`='gid://shopify/Customer/7387436941492' ,`shopify_recommendation`='LOW' ,`order_created`='2024-09-21 10:13:40' ,`newSystemCustomerEmail`='jhart1987@live.com' ,`order_completed`='2024-09-21 10:13:36' ,`currency`='USD' ,`order_total`='248.39' ,`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.4' ,`coupon_code`='DRYQFALL' ,`coupon_amount`='70.0' ,`internalPaymentType`='Shopify_Payments' ,`fullfillment_status`='FULFILLED' ,`shipping_country`='United States' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTE0NjE0MTA0MjQ0LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMSAxNzoxMzozNi4xNDM3MTQifQ==' ,`store`='SRI'
Array
(
[newSystemOrderID] => gid://shopify/Order/5914614104244
[newSystemProductId] => gid://shopify/LineItem/14378344841396
[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/5914614104244' ,`newSystemProductId`='gid://shopify/LineItem/14378344841396' ,`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/7387436941492' ,`newSystemOrderID`='gid://shopify/Order/5914614104244' ,`deliveryFirstName`='Joan' ,`deliveryLastName`='Hart' ,`deliveryPhone`='5184217883' ,`deliveryStreet`='4 Windmill Way ' ,`deliverySuburb`='' ,`deliveryPostCode`='12047' ,`deliveryCountry`='United States' ,`deliveryCity`='Cohoes' ,`deliveryState`='New York' ,`store`='SRI'SRI#99018 processing
meimudie@hotmail.com processing
INSERT INTO `newsystem_customers` ( `newSystemMemberID`, `emailAddress`, `firstName`, `lastName`, `tradingName`, `homePhone`, `mobile`, `street`, `city`, `postCode`, `state`, `country`, `pending`, `middleEntryDate`) VALUES ( 'gid://shopify/Customer/7387458175156','meimudie@hotmail.com', 'Martha', 'Minier', '', '+12063909312', '+12063909312', '2522 31st Avenue South ', 'Seattle','98144', 'Washington', 'United States', '1', '2026-07-27 15:09:38')gid://shopify/Order/5914620559540Exported
New Cursor --eyJsYXN0X2lkIjo1OTE0NjIwNTU5NTQwLCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMSAxNzoxNzoyOS4wOTg3NjYifQ==INSERT INTO `newsystem_orders` SET `newSystemOrderID`='gid://shopify/Order/5914620559540' ,`newSystemOrderNumber`='SRI#99018' ,`newSystemCustomerID`='gid://shopify/Customer/7387458175156' ,`shopify_recommendation`='LOW' ,`order_created`='2024-09-21 10:17:35' ,`newSystemCustomerEmail`='meimudie@hotmail.com' ,`order_completed`='2024-09-21 10:17:29' ,`currency`='USD' ,`order_total`='253.79' ,`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`='23.8' ,`coupon_code`='DRYQFALL' ,`coupon_amount`='70.0' ,`internalPaymentType`='Shopify_Payments' ,`fullfillment_status`='FULFILLED' ,`shipping_country`='United States' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTE0NjIwNTU5NTQwLCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMSAxNzoxNzoyOS4wOTg3NjYifQ==' ,`store`='SRI'
Array
(
[newSystemOrderID] => gid://shopify/Order/5914620559540
[newSystemProductId] => gid://shopify/LineItem/14378360930484
[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/5914620559540' ,`newSystemProductId`='gid://shopify/LineItem/14378360930484' ,`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/7387458175156' ,`newSystemOrderID`='gid://shopify/Order/5914620559540' ,`deliveryFirstName`='Martha' ,`deliveryLastName`='Minier' ,`deliveryPhone`='+12063909312' ,`deliveryStreet`='2522 31st Avenue South ' ,`deliverySuburb`='' ,`deliveryPostCode`='98144' ,`deliveryCountry`='United States' ,`deliveryCity`='Seattle' ,`deliveryState`='Washington' ,`store`='SRI'