select shopifyCursor from newsystem_orders where orderType='shopify' and store = 'SRI' and shopifyCursor!='' order by orderID desc limit 1
DB Cursor --eyJsYXN0X2lkIjo1OTEyNzg0MDExNDQ0LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMCAxNDo0MzoxNi44OTAwNjAifQ==eyJsYXN0X2lkIjo1OTEyNzg0MDExNDQ0LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMCAxNDo0MzoxNi44OTAwNjAifQ==SRI#98894 processing
bonk0115@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/7380440481972','bonk0115@gmail.com', 'Bonnie', 'Kay', '', '5204714713', '5204714713', '3861 E. Placita de Peri ', 'Tucson','85718-7430', 'Arizona', 'United States', '1', '2026-06-12 12:12:40')gid://shopify/Order/5912794169524Exported
New Cursor --eyJsYXN0X2lkIjo1OTEyNzk0MTY5NTI0LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMCAxNDo1MDo1NC4yMjU5ODYifQ==INSERT INTO `newsystem_orders` SET `newSystemOrderID`='gid://shopify/Order/5912794169524' ,`newSystemOrderNumber`='SRI#98894' ,`newSystemCustomerID`='gid://shopify/Customer/7380440481972' ,`shopify_recommendation`='LOW' ,`order_created`='2024-09-20 07:51:00' ,`newSystemCustomerEmail`='bonk0115@gmail.com' ,`order_completed`='2024-09-20 07:50:54' ,`currency`='USD' ,`order_total`='249.54' ,`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.55' ,`coupon_code`='DRYQFALL' ,`coupon_amount`='70.0' ,`internalPaymentType`='Shopify_Payments' ,`fullfillment_status`='FULFILLED' ,`shipping_country`='United States' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTEyNzk0MTY5NTI0LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMCAxNDo1MDo1NC4yMjU5ODYifQ==' ,`store`='SRI'
Array
(
[newSystemOrderID] => gid://shopify/Order/5912794169524
[newSystemProductId] => gid://shopify/LineItem/14374497779892
[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/5912794169524' ,`newSystemProductId`='gid://shopify/LineItem/14374497779892' ,`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/7380440481972' ,`newSystemOrderID`='gid://shopify/Order/5912794169524' ,`deliveryFirstName`='Bonnie' ,`deliveryLastName`='Kay' ,`deliveryPhone`='5204714713' ,`deliveryStreet`='3861 E. Placita de Peri ' ,`deliverySuburb`='' ,`deliveryPostCode`='85718-7430' ,`deliveryCountry`='United States' ,`deliveryCity`='Tucson' ,`deliveryState`='Arizona' ,`store`='SRI'SRI#98895 processing
johncurrylee4@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/7380571619508','johncurrylee4@gmail.com', 'John', 'Lee', '', '2022881198', '2022881198', '20116 St Louis Rd ', 'Purcellville','20132', 'Virginia', 'United States', '1', '2026-06-12 12:12:40')gid://shopify/Order/5912813863092Exported
New Cursor --eyJsYXN0X2lkIjo1OTEyODEzODYzMDkyLCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMCAxNTowNjowOS43MzQ0NTcifQ==INSERT INTO `newsystem_orders` SET `newSystemOrderID`='gid://shopify/Order/5912813863092' ,`newSystemOrderNumber`='SRI#98895' ,`newSystemCustomerID`='gid://shopify/Customer/7380571619508' ,`shopify_recommendation`='LOW' ,`order_created`='2024-09-20 08:06:14' ,`newSystemCustomerEmail`='johncurrylee4@gmail.com' ,`order_completed`='2024-09-20 08:06:09' ,`currency`='USD' ,`order_total`='243.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`='13.8' ,`coupon_code`='DRYQFALL' ,`coupon_amount`='70.0' ,`internalPaymentType`='Shopify_Payments' ,`fullfillment_status`='FULFILLED' ,`shipping_country`='United States' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTEyODEzODYzMDkyLCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMCAxNTowNjowOS43MzQ0NTcifQ==' ,`store`='SRI'
Array
(
[newSystemOrderID] => gid://shopify/Order/5912813863092
[newSystemProductId] => gid://shopify/LineItem/14374539985076
[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/5912813863092' ,`newSystemProductId`='gid://shopify/LineItem/14374539985076' ,`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/7380571619508' ,`newSystemOrderID`='gid://shopify/Order/5912813863092' ,`deliveryFirstName`='John' ,`deliveryLastName`='Lee' ,`deliveryPhone`='2022881198' ,`deliveryStreet`='20116 St Louis Rd ' ,`deliverySuburb`='' ,`deliveryPostCode`='20132' ,`deliveryCountry`='United States' ,`deliveryCity`='Purcellville' ,`deliveryState`='Virginia' ,`store`='SRI'SRI#98896 processing
jennylang5@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/7379708772532','jennylang5@gmail.com', 'Jennifer', 'Lang', '', '4044833077', '4044833077', '4323 Revere Cir ', 'Marietta','30062', 'Georgia', 'United States', '1', '2026-06-12 12:12:40')gid://shopify/Order/5912816386228Exported
New Cursor --eyJsYXN0X2lkIjo1OTEyODE2Mzg2MjI4LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMCAxNTowNzo0NC4zMzE2MjEifQ==INSERT INTO `newsystem_orders` SET `newSystemOrderID`='gid://shopify/Order/5912816386228' ,`newSystemOrderNumber`='SRI#98896' ,`newSystemCustomerID`='gid://shopify/Customer/7379708772532' ,`shopify_recommendation`='LOW' ,`order_created`='2024-09-20 08:07:49' ,`newSystemCustomerEmail`='jennylang5@gmail.com' ,`order_completed`='2024-09-20 08:07:44' ,`currency`='USD' ,`order_total`='131.44' ,`order_subtotal`='124.0' ,`total_items`='1' ,`shipping_methods`='shopify' ,`total_shipping`='0.0' ,`payment_detail_title`='Shopify_Payments' ,`payment_detail_status`='PAID' ,`note`='' ,`taxAmount`='7.44' ,`coupon_code`='STYLERFALL' ,`coupon_amount`='45.0' ,`internalPaymentType`='Shopify_Payments' ,`fullfillment_status`='FULFILLED' ,`shipping_country`='United States' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTEyODE2Mzg2MjI4LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0yMCAxNTowNzo0NC4zMzE2MjEifQ==' ,`store`='SRI'
Array
(
[newSystemOrderID] => gid://shopify/Order/5912816386228
[newSystemProductId] => gid://shopify/LineItem/14374545588404
[stockCode] => SRI-InfraStyler-Ver2-TE-X1
[actualCIStockCode] => SRI-InfraStyler-Ver2-TE-X1
[quantity] => 1
[unitPrice] => 169.00
[discountAmount] => 0.0
[store] => SRI
)
INSERT INTO `newsystem_orders_product` SET `newSystemOrderID`='gid://shopify/Order/5912816386228' ,`newSystemProductId`='gid://shopify/LineItem/14374545588404' ,`stockCode`='SRI-InfraStyler-Ver2-TE-X1' ,`actualCIStockCode`='SRI-InfraStyler-Ver2-TE-X1' ,`quantity`='1' ,`unitPrice`='169.00' ,`discountAmount`='0.0' ,`store`='SRI'INSERT INTO `newsystem_order_delivery` SET `newSystemMemberID`='gid://shopify/Customer/7379708772532' ,`newSystemOrderID`='gid://shopify/Order/5912816386228' ,`deliveryFirstName`='Jennifer' ,`deliveryLastName`='Lang' ,`deliveryPhone`='4044833077' ,`deliveryStreet`='4323 Revere Cir ' ,`deliverySuburb`='' ,`deliveryPostCode`='30062' ,`deliveryCountry`='United States' ,`deliveryCity`='Marietta' ,`deliveryState`='Georgia' ,`store`='SRI'