select shopifyCursor from newsystem_orders where orderType='shopify' and store = 'SRI' and shopifyCursor!='' order by orderID  desc limit 1
DB Cursor --eyJsYXN0X2lkIjo1OTEwMTA1ODE3MjY4LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOCAxOTo1NzozOS4xMDE3MDgifQ==eyJsYXN0X2lkIjo1OTEwMTA1ODE3MjY4LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOCAxOTo1NzozOS4xMDE3MDgifQ==
SRI#98729 processing
kbanks9180@att.net processing
UPDATE `newsystem_customers`   SET `emailAddress`='kbanks9180@att.net', `firstName`='karen', `lastName`='banks', `tradingName`='', `homePhone`='+1 214-663-5445', `mobile`='+1 214-663-5445',  `street`= '3417 Paintbrush Path ', `city`='Melissa', `postCode`='75454', `state`='Texas', `country`='United States', `pending`='1', `middleEntryDate`='2025-12-10 18:08:22' where `newSystemMemberID`='gid://shopify/Customer/6828998918324'
gid://shopify/Order/5910108504244Exported


Warning:  Trying to access array offset on value of type null in /home/nepsols/sri.nepsols.com/old/api-orders.php on line 605


New Cursor --eyJsYXN0X2lkIjo1OTEwMTA4NTA0MjQ0LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOCAxOTo1OTo0MS40MTQyOTQifQ==INSERT INTO `newsystem_orders` SET   `newSystemOrderID`='gid://shopify/Order/5910108504244' ,`newSystemOrderNumber`='SRI#98729' ,`newSystemCustomerID`='gid://shopify/Customer/6828998918324' ,`shopify_recommendation`='LOW' ,`order_created`='2024-09-18 12:59:44' ,`newSystemCustomerEmail`='kbanks9180@att.net' ,`order_completed`='2024-09-18 12:59:41' ,`currency`='USD' ,`order_total`='17.0' ,`order_subtotal`='17.0' ,`total_items`='1' ,`shipping_methods`='' ,`total_shipping`='0' ,`payment_detail_title`='PayPal' ,`payment_detail_status`='PAID' ,`note`='' ,`taxAmount`='0.0' ,`coupon_code`='' ,`coupon_amount`='0.0' ,`internalPaymentType`='PayPal' ,`fullfillment_status`='UNFULFILLED' ,`shipping_country`='' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTEwMTA4NTA0MjQ0LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOCAxOTo1OTo0MS40MTQyOTQifQ==' ,`store`='SRI'
Array
(
    [newSystemOrderID] => gid://shopify/Order/5910108504244
    [newSystemProductId] => gid://shopify/LineItem/14368993050804
    [stockCode] => Warranty
    [actualCIStockCode] => Warranty
    [quantity] => 1
    [unitPrice] => 17.00
    [discountAmount] => 0.0
    [store] => SRI
)
INSERT INTO `newsystem_orders_product` SET   `newSystemOrderID`='gid://shopify/Order/5910108504244' ,`newSystemProductId`='gid://shopify/LineItem/14368993050804' ,`stockCode`='Warranty' ,`actualCIStockCode`='Warranty' ,`quantity`='1' ,`unitPrice`='17.00' ,`discountAmount`='0.0' ,`store`='SRI'INSERT INTO `newsystem_order_delivery` SET   `newSystemMemberID`='gid://shopify/Customer/6828998918324' ,`newSystemOrderID`='gid://shopify/Order/5910108504244' ,`deliveryFirstName`='karen' ,`deliveryLastName`='banks' ,`deliveryPhone`='+12146635445' ,`deliveryStreet`='3417 Paintbrush Path ' ,`deliverySuburb`='' ,`deliveryPostCode`='75454' ,`deliveryCountry`='United States' ,`deliveryCity`='Melissa' ,`deliveryState`='Texas' ,`store`='SRI'SRI#98730 processing
charming5509@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/7367202242740','charming5509@gmail.com', 'Charles', 'Nichols', '', '8033226829', '8033226829', '307 North Wilson Street ', 'Rock Hill','29730', 'South Carolina', 'United States', '1', '2025-12-10 18:08:22')
gid://shopify/Order/5910108635316Exported

New Cursor --eyJsYXN0X2lkIjo1OTEwMTA4NjM1MzE2LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOCAxOTo1OTo0Mi45MjM5MTQifQ==INSERT INTO `newsystem_orders` SET   `newSystemOrderID`='gid://shopify/Order/5910108635316' ,`newSystemOrderNumber`='SRI#98730' ,`newSystemCustomerID`='gid://shopify/Customer/7367202242740' ,`shopify_recommendation`='LOW' ,`order_created`='2024-09-18 12:59:46' ,`newSystemCustomerEmail`='charming5509@gmail.com' ,`order_completed`='2024-09-18 12:59:42' ,`currency`='USD' ,`order_total`='246.09' ,`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`='16.1' ,`coupon_code`='DRYQFALL' ,`coupon_amount`='70.0' ,`internalPaymentType`='Shopify_Payments' ,`fullfillment_status`='FULFILLED' ,`shipping_country`='United States' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTEwMTA4NjM1MzE2LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOCAxOTo1OTo0Mi45MjM5MTQifQ==' ,`store`='SRI'
Array
(
    [newSystemOrderID] => gid://shopify/Order/5910108635316
    [newSystemProductId] => gid://shopify/LineItem/14368993247412
    [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/5910108635316' ,`newSystemProductId`='gid://shopify/LineItem/14368993247412' ,`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/7367202242740' ,`newSystemOrderID`='gid://shopify/Order/5910108635316' ,`deliveryFirstName`='Donna' ,`deliveryLastName`='Garrett' ,`deliveryPhone`='8033226829' ,`deliveryStreet`='307 North Wilson Street ' ,`deliverySuburb`='' ,`deliveryPostCode`='29730' ,`deliveryCountry`='United States' ,`deliveryCity`='Rock Hill' ,`deliveryState`='South Carolina' ,`store`='SRI'SRI#98731 processing
ccgarage1557@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/7367264075956','ccgarage1557@gmail.com', 'Bobby', 'Creel', '', '13184526742', '13184526742', '1557 hwy 3101 ', 'Jonesville','71343', 'Louisiana', 'United States', '1', '2025-12-10 18:08:22')
gid://shopify/Order/5910133538996Exported

New Cursor --eyJsYXN0X2lkIjo1OTEwMTMzNTM4OTk2LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOCAyMDoxNjo0NC44MDc0NTIifQ==INSERT INTO `newsystem_orders` SET   `newSystemOrderID`='gid://shopify/Order/5910133538996' ,`newSystemOrderNumber`='SRI#98731' ,`newSystemCustomerID`='gid://shopify/Customer/7367264075956' ,`shopify_recommendation`='LOW' ,`order_created`='2024-09-18 13:16:49' ,`newSystemCustomerEmail`='ccgarage1557@gmail.com' ,`order_completed`='2024-09-18 13:16:44' ,`currency`='USD' ,`order_total`='256.32' ,`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`='26.33' ,`coupon_code`='DRYQFALL' ,`coupon_amount`='70.0' ,`internalPaymentType`='Shopify_Payments' ,`fullfillment_status`='FULFILLED' ,`shipping_country`='United States' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTEwMTMzNTM4OTk2LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOCAyMDoxNjo0NC44MDc0NTIifQ==' ,`store`='SRI'
Array
(
    [newSystemOrderID] => gid://shopify/Order/5910133538996
    [newSystemProductId] => gid://shopify/LineItem/14369049444532
    [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/5910133538996' ,`newSystemProductId`='gid://shopify/LineItem/14369049444532' ,`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/7367264075956' ,`newSystemOrderID`='gid://shopify/Order/5910133538996' ,`deliveryFirstName`='Bobby' ,`deliveryLastName`='Creel' ,`deliveryPhone`='13184526742' ,`deliveryStreet`='1557 hwy 3101 ' ,`deliverySuburb`='' ,`deliveryPostCode`='71343' ,`deliveryCountry`='United States' ,`deliveryCity`='Jonesville' ,`deliveryState`='Louisiana' ,`store`='SRI'