select shopifyCursor from newsystem_orders where orderType='shopify' and store = 'SRI' and shopifyCursor!='' order by orderID desc limit 1
DB Cursor --eyJsYXN0X2lkIjo1OTEwNTk3MzcwMDM2LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAwMjo1NjoxOC4zNjk2MjIifQ==eyJsYXN0X2lkIjo1OTEwNTk3MzcwMDM2LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAwMjo1NjoxOC4zNjk2MjIifQ==SRI#98774 processing
georgiapeachlover@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/7368828649652','georgiapeachlover@gmail.com', 'Cathy', 'Humphries', '', '6619043154', '6619043154', '129 White Oak Ridge ', 'Ellijay','30540', 'Georgia', 'United States', '1', '2026-01-26 16:35:36')gid://shopify/Order/5910610935988Exported
New Cursor --eyJsYXN0X2lkIjo1OTEwNjEwOTM1OTg4LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAwMzoxMDozMS43NTY1MDcifQ==INSERT INTO `newsystem_orders` SET `newSystemOrderID`='gid://shopify/Order/5910610935988' ,`newSystemOrderNumber`='SRI#98774' ,`newSystemCustomerID`='gid://shopify/Customer/7368828649652' ,`shopify_recommendation`='LOW' ,`order_created`='2024-09-18 20:10:34' ,`newSystemCustomerEmail`='georgiapeachlover@gmail.com' ,`order_completed`='2024-09-18 20:10:31' ,`currency`='USD' ,`order_total`='210.79' ,`order_subtotal`='197.0' ,`total_items`='1' ,`shipping_methods`='shopify' ,`total_shipping`='0.0' ,`payment_detail_title`='Shopify_Payments' ,`payment_detail_status`='PAID' ,`note`='' ,`taxAmount`='13.79' ,`coupon_code`='STYLEWRAPFALL' ,`coupon_amount`='82.0' ,`internalPaymentType`='Shopify_Payments' ,`fullfillment_status`='FULFILLED' ,`shipping_country`='United States' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTEwNjEwOTM1OTg4LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAwMzoxMDozMS43NTY1MDcifQ==' ,`store`='SRI'
Array
(
[newSystemOrderID] => gid://shopify/Order/5910610935988
[newSystemProductId] => gid://shopify/LineItem/14370129379508
[stockCode] => StyleWrap-X1
[actualCIStockCode] => StyleWrap-X1
[quantity] => 1
[unitPrice] => 279.00
[discountAmount] => 0.0
[store] => SRI
)
INSERT INTO `newsystem_orders_product` SET `newSystemOrderID`='gid://shopify/Order/5910610935988' ,`newSystemProductId`='gid://shopify/LineItem/14370129379508' ,`stockCode`='StyleWrap-X1' ,`actualCIStockCode`='StyleWrap-X1' ,`quantity`='1' ,`unitPrice`='279.00' ,`discountAmount`='0.0' ,`store`='SRI'INSERT INTO `newsystem_order_delivery` SET `newSystemMemberID`='gid://shopify/Customer/7368828649652' ,`newSystemOrderID`='gid://shopify/Order/5910610935988' ,`deliveryFirstName`='Cathy' ,`deliveryLastName`='Humphries' ,`deliveryPhone`='6619043154' ,`deliveryStreet`='129 White Oak Ridge ' ,`deliverySuburb`='' ,`deliveryPostCode`='30540' ,`deliveryCountry`='United States' ,`deliveryCity`='Ellijay' ,`deliveryState`='Georgia' ,`store`='SRI'SRI#98775 processing
mvyas721@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/7368944025780','mvyas721@gmail.com', 'Meera', 'Vyas', '', '4085293790', '4085293790', '1469 San Juan Ave ', 'San Jose','95110', 'California', 'United States', '1', '2026-01-26 16:35:36')gid://shopify/Order/5910635774132Exported
New Cursor --eyJsYXN0X2lkIjo1OTEwNjM1Nzc0MTMyLCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAwMzozOTowNi43MDY1NDIifQ==INSERT INTO `newsystem_orders` SET `newSystemOrderID`='gid://shopify/Order/5910635774132' ,`newSystemOrderNumber`='SRI#98775' ,`newSystemCustomerID`='gid://shopify/Customer/7368944025780' ,`shopify_recommendation`='LOW' ,`order_created`='2024-09-18 20:39:09' ,`newSystemCustomerEmail`='mvyas721@gmail.com' ,`order_completed`='2024-09-18 20:39:06' ,`currency`='USD' ,`order_total`='262.49' ,`order_subtotal`='239.99' ,`total_items`='1' ,`shipping_methods`='shopify' ,`total_shipping`='0.0' ,`payment_detail_title`='Shopify_Payments' ,`payment_detail_status`='PAID' ,`note`='' ,`taxAmount`='22.5' ,`coupon_code`='' ,`coupon_amount`='0.0' ,`internalPaymentType`='Shopify_Payments' ,`fullfillment_status`='FULFILLED' ,`shipping_country`='United States' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTEwNjM1Nzc0MTMyLCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAwMzozOTowNi43MDY1NDIifQ==' ,`store`='SRI'
Array
(
[newSystemOrderID] => gid://shopify/Order/5910635774132
[newSystemProductId] => gid://shopify/LineItem/14370177351860
[stockCode] => SRI-DryQ-Ver2
[actualCIStockCode] => SRI-DryQ-Ver2
[quantity] => 1
[unitPrice] => 224.99
[discountAmount] => 0.0
[store] => SRI
)
INSERT INTO `newsystem_orders_product` SET `newSystemOrderID`='gid://shopify/Order/5910635774132' ,`newSystemProductId`='gid://shopify/LineItem/14370177351860' ,`stockCode`='SRI-DryQ-Ver2' ,`actualCIStockCode`='SRI-DryQ-Ver2' ,`quantity`='1' ,`unitPrice`='224.99' ,`discountAmount`='0.0' ,`store`='SRI'INSERT INTO `newsystem_order_delivery` SET `newSystemMemberID`='gid://shopify/Customer/7368944025780' ,`newSystemOrderID`='gid://shopify/Order/5910635774132' ,`deliveryFirstName`='Meera' ,`deliveryLastName`='Vyas' ,`deliveryPhone`='4085293790' ,`deliveryStreet`='1469 San Juan Ave ' ,`deliverySuburb`='' ,`deliveryPostCode`='95110' ,`deliveryCountry`='United States' ,`deliveryCity`='San Jose' ,`deliveryState`='California' ,`store`='SRI'SRI#98776 processing
pkypkf@yahoo.com processing
INSERT INTO `newsystem_customers` ( `newSystemMemberID`, `emailAddress`, `firstName`, `lastName`, `tradingName`, `homePhone`, `mobile`, `street`, `city`, `postCode`, `state`, `country`, `pending`, `middleEntryDate`) VALUES ( 'gid://shopify/Customer/7367571767476','pkypkf@yahoo.com', 'Pam', 'Fair', '', '9374750060', '9374750060', '7001 Hill Station Road ', 'Goshen','45122', 'Ohio', 'United States', '1', '2026-01-26 16:35:36')gid://shopify/Order/5910638264500Exported
New Cursor --eyJsYXN0X2lkIjo1OTEwNjM4MjY0NTAwLCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAwMzo0MjowOC42MDY2NDAifQ==INSERT INTO `newsystem_orders` SET `newSystemOrderID`='gid://shopify/Order/5910638264500' ,`newSystemOrderNumber`='SRI#98776' ,`newSystemCustomerID`='gid://shopify/Customer/7367571767476' ,`shopify_recommendation`='LOW' ,`order_created`='2024-09-18 20:42:12' ,`newSystemCustomerEmail`='pkypkf@yahoo.com' ,`order_completed`='2024-09-18 20:42:08' ,`currency`='USD' ,`order_total`='203.74' ,`order_subtotal`='189.0' ,`total_items`='1' ,`shipping_methods`='shopify' ,`total_shipping`='0.0' ,`payment_detail_title`='Shopify_Payments' ,`payment_detail_status`='PAID' ,`note`='' ,`taxAmount`='14.74' ,`coupon_code`='STEAMSTYLERFALL' ,`coupon_amount`='70.0' ,`internalPaymentType`='Shopify_Payments' ,`fullfillment_status`='FULFILLED' ,`shipping_country`='United States' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTEwNjM4MjY0NTAwLCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAwMzo0MjowOC42MDY2NDAifQ==' ,`store`='SRI'
Array
(
[newSystemOrderID] => gid://shopify/Order/5910638264500
[newSystemProductId] => gid://shopify/LineItem/14370181120180
[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/5910638264500' ,`newSystemProductId`='gid://shopify/LineItem/14370181120180' ,`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/7367571767476' ,`newSystemOrderID`='gid://shopify/Order/5910638264500' ,`deliveryFirstName`='Pam' ,`deliveryLastName`='Fair' ,`deliveryPhone`='9374750060' ,`deliveryStreet`='7001 Hill Station Road ' ,`deliverySuburb`='' ,`deliveryPostCode`='45122' ,`deliveryCountry`='United States' ,`deliveryCity`='Goshen' ,`deliveryState`='Ohio' ,`store`='SRI'