select shopifyCursor from newsystem_orders where orderType='shopify' and store = 'SRI' and shopifyCursor!='' order by orderID  desc limit 1
DB Cursor --eyJsYXN0X2lkIjo1OTExMjg4MjUwNTQ4LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAxNToyOTo0Mi42MjgyNjkifQ==eyJsYXN0X2lkIjo1OTExMjg4MjUwNTQ4LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAxNToyOTo0Mi42MjgyNjkifQ==
SRI#98815 processing
denbydawson@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/7373332578484','denbydawson@gmail.com', 'Denby', 'Dawson', '', '8082788747', '8082788747', '3408 Eono St ', 'Lihue','96766', 'Hawaii', 'United States', '1', '2026-04-18 03:12:54')
gid://shopify/Order/5911312072884Exported

New Cursor --eyJsYXN0X2lkIjo1OTExMzEyMDcyODg0LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAxNTo0ODoyOC4wMDAwMDAifQ==INSERT INTO `newsystem_orders` SET   `newSystemOrderID`='gid://shopify/Order/5911312072884' ,`newSystemOrderNumber`='SRI#98815' ,`newSystemCustomerID`='gid://shopify/Customer/7373332578484' ,`shopify_recommendation`='LOW' ,`order_created`='2024-09-19 08:48:29' ,`newSystemCustomerEmail`='denbydawson@gmail.com' ,`order_completed`='2024-09-19 08:48:28' ,`currency`='USD' ,`order_total`='129.84' ,`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`='5.84' ,`coupon_code`='' ,`coupon_amount`='0.0' ,`internalPaymentType`='Shopify_Payments' ,`fullfillment_status`='FULFILLED' ,`shipping_country`='United States' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTExMzEyMDcyODg0LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAxNTo0ODoyOC4wMDAwMDAifQ==' ,`store`='SRI'
Array
(
    [newSystemOrderID] => gid://shopify/Order/5911312072884
    [newSystemProductId] => gid://shopify/LineItem/14371440099508
    [stockCode] => SRI-InfraStyler-Ver2-TE-X1
    [actualCIStockCode] => SRI-InfraStyler-Ver2-TE-X1
    [quantity] => 1
    [unitPrice] => 121.00
    [discountAmount] => 0.0
    [store] => SRI
)
INSERT INTO `newsystem_orders_product` SET   `newSystemOrderID`='gid://shopify/Order/5911312072884' ,`newSystemProductId`='gid://shopify/LineItem/14371440099508' ,`stockCode`='SRI-InfraStyler-Ver2-TE-X1' ,`actualCIStockCode`='SRI-InfraStyler-Ver2-TE-X1' ,`quantity`='1' ,`unitPrice`='121.00' ,`discountAmount`='0.0' ,`store`='SRI'INSERT INTO `newsystem_order_delivery` SET   `newSystemMemberID`='gid://shopify/Customer/7373332578484' ,`newSystemOrderID`='gid://shopify/Order/5911312072884' ,`deliveryFirstName`='Denby' ,`deliveryLastName`='Dawson' ,`deliveryPhone`='8082788747' ,`deliveryStreet`='3408 Eono St ' ,`deliverySuburb`='' ,`deliveryPostCode`='96766' ,`deliveryCountry`='United States' ,`deliveryCity`='Lihue' ,`deliveryState`='Hawaii' ,`store`='SRI'SRI#98816 processing
mpoage@comcast.net processing
INSERT INTO `newsystem_customers`  ( `newSystemMemberID`,  `emailAddress`, `firstName`, `lastName`, `tradingName`, `homePhone`, `mobile`,  `street`, `city`, `postCode`, `state`, `country`, `pending`, `middleEntryDate`)  VALUES ( 'gid://shopify/Customer/6497353466036','mpoage@comcast.net', 'Michelle', 'Poage-Oldroyd', '', '3015186949', '3015186949', '14024 Clopper Road ', 'Boyds','20841', 'Maryland', 'United States', '1', '2026-04-18 03:12:54')
gid://shopify/Order/5911315742900Exported

New Cursor --eyJsYXN0X2lkIjo1OTExMzE1NzQyOTAwLCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAxNTo1MTo0Ny41ODU1NTYifQ==INSERT INTO `newsystem_orders` SET   `newSystemOrderID`='gid://shopify/Order/5911315742900' ,`newSystemOrderNumber`='SRI#98816' ,`newSystemCustomerID`='gid://shopify/Customer/6497353466036' ,`shopify_recommendation`='LOW' ,`order_created`='2024-09-19 08:51:52' ,`newSystemCustomerEmail`='mpoage@comcast.net' ,`order_completed`='2024-09-19 08:51:47' ,`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`='eyJsYXN0X2lkIjo1OTExMzE1NzQyOTAwLCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAxNTo1MTo0Ny41ODU1NTYifQ==' ,`store`='SRI'
Array
(
    [newSystemOrderID] => gid://shopify/Order/5911315742900
    [newSystemProductId] => gid://shopify/LineItem/14371448651956
    [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/5911315742900' ,`newSystemProductId`='gid://shopify/LineItem/14371448651956' ,`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/6497353466036' ,`newSystemOrderID`='gid://shopify/Order/5911315742900' ,`deliveryFirstName`='Michelle' ,`deliveryLastName`='Poage-Oldroyd' ,`deliveryPhone`='3015186949' ,`deliveryStreet`='14024 Clopper Road ' ,`deliverySuburb`='' ,`deliveryPostCode`='20841' ,`deliveryCountry`='United States' ,`deliveryCity`='Boyds' ,`deliveryState`='Maryland' ,`store`='SRI'SRI#98817 processing
monica_morana@yahoo.com processing
UPDATE `newsystem_customers`   SET `emailAddress`='monica_morana@yahoo.com', `firstName`='Monica', `lastName`='Morana', `tradingName`='', `homePhone`='(650) 302-6033', `mobile`='(650) 302-6033',  `street`= '1300 Main St ', `city`='Montara', `postCode`='94037', `state`='California', `country`='United States', `pending`='1', `middleEntryDate`='2026-04-18 03:12:54' where `newSystemMemberID`='gid://shopify/Customer/6497558102196'
gid://shopify/Order/5911325835444Exported


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 --eyJsYXN0X2lkIjo1OTExMzI1ODM1NDQ0LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAxNTo1OToyOC4wNDU4OTgifQ==INSERT INTO `newsystem_orders` SET   `newSystemOrderID`='gid://shopify/Order/5911325835444' ,`newSystemOrderNumber`='SRI#98817' ,`newSystemCustomerID`='gid://shopify/Customer/6497558102196' ,`shopify_recommendation`='LOW' ,`order_created`='2024-09-19 08:59:31' ,`newSystemCustomerEmail`='monica_morana@yahoo.com' ,`order_completed`='2024-09-19 08:59:28' ,`currency`='USD' ,`order_total`='17.0' ,`order_subtotal`='17.0' ,`total_items`='1' ,`shipping_methods`='' ,`total_shipping`='0' ,`payment_detail_title`='Shopify_Payments' ,`payment_detail_status`='PAID' ,`note`='' ,`taxAmount`='0.0' ,`coupon_code`='' ,`coupon_amount`='0.0' ,`internalPaymentType`='Shopify_Payments' ,`fullfillment_status`='UNFULFILLED' ,`shipping_country`='' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTExMzI1ODM1NDQ0LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAxNTo1OToyOC4wNDU4OTgifQ==' ,`store`='SRI'
Array
(
    [newSystemOrderID] => gid://shopify/Order/5911325835444
    [newSystemProductId] => gid://shopify/LineItem/14371471655092
    [stockCode] => Warranty
    [actualCIStockCode] => Warranty
    [quantity] => 1
    [unitPrice] => 17.00
    [discountAmount] => 0.0
    [store] => SRI
)
INSERT INTO `newsystem_orders_product` SET   `newSystemOrderID`='gid://shopify/Order/5911325835444' ,`newSystemProductId`='gid://shopify/LineItem/14371471655092' ,`stockCode`='Warranty' ,`actualCIStockCode`='Warranty' ,`quantity`='1' ,`unitPrice`='17.00' ,`discountAmount`='0.0' ,`store`='SRI'INSERT INTO `newsystem_order_delivery` SET   `newSystemMemberID`='gid://shopify/Customer/6497558102196' ,`newSystemOrderID`='gid://shopify/Order/5911325835444' ,`deliveryFirstName`='Monica' ,`deliveryLastName`='Morana' ,`deliveryPhone`='6503026033' ,`deliveryStreet`='1300 Main Street ' ,`deliverySuburb`='' ,`deliveryPostCode`='94037' ,`deliveryCountry`='United States' ,`deliveryCity`='Montara' ,`deliveryState`='California' ,`store`='SRI'