select shopifyCursor from newsystem_orders where orderType='shopify' and store = 'SRI' and shopifyCursor!='' order by orderID  desc limit 1
DB Cursor --eyJsYXN0X2lkIjo1OTEwNjM4MjY0NTAwLCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAwMzo0MjowOC42MDY2NDAifQ==eyJsYXN0X2lkIjo1OTEwNjM4MjY0NTAwLCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAwMzo0MjowOC42MDY2NDAifQ==
SRI#98777 processing
pugliesern@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/7368963752116','pugliesern@gmail.com', 'Heidi', 'Pugliese', '', '2035181720', '2035181720', '193 Summit Wood Drive ', 'Berlin','06037', 'Connecticut', 'United States', '1', '2026-01-26 16:37:32')
gid://shopify/Order/5910645178548Exported

New Cursor --eyJsYXN0X2lkIjo1OTEwNjQ1MTc4NTQ4LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAwMzo1MTo1MS4wMDAwMDAifQ==INSERT INTO `newsystem_orders` SET   `newSystemOrderID`='gid://shopify/Order/5910645178548' ,`newSystemOrderNumber`='SRI#98777' ,`newSystemCustomerID`='gid://shopify/Customer/7368963752116' ,`shopify_recommendation`='LOW' ,`order_created`='2024-09-18 20:51:54' ,`newSystemCustomerEmail`='pugliesern@gmail.com' ,`order_completed`='2024-09-18 20:51:51' ,`currency`='USD' ,`order_total`='244.59' ,`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`='14.6' ,`coupon_code`='' ,`coupon_amount`='0.0' ,`internalPaymentType`='Shopify_Payments' ,`fullfillment_status`='FULFILLED' ,`shipping_country`='United States' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTEwNjQ1MTc4NTQ4LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAwMzo1MTo1MS4wMDAwMDAifQ==' ,`store`='SRI'
Array
(
    [newSystemOrderID] => gid://shopify/Order/5910645178548
    [newSystemProductId] => gid://shopify/LineItem/14370196619444
    [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/5910645178548' ,`newSystemProductId`='gid://shopify/LineItem/14370196619444' ,`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/7368963752116' ,`newSystemOrderID`='gid://shopify/Order/5910645178548' ,`deliveryFirstName`='Heidi' ,`deliveryLastName`='Pugliese' ,`deliveryPhone`='2035181720' ,`deliveryStreet`='193 Summit Wood Drive ' ,`deliverySuburb`='' ,`deliveryPostCode`='06037' ,`deliveryCountry`='United States' ,`deliveryCity`='Berlin' ,`deliveryState`='Connecticut' ,`store`='SRI'SRI#98778 processing
ddimitrova2@yahoo.com processing
UPDATE `newsystem_customers`   SET `emailAddress`='ddimitrova2@yahoo.com', `firstName`='Darina', `lastName`='Nedelcheva', `tradingName`='', `homePhone`='+359 89 872 6411', `mobile`='+359 89 872 6411',  `street`= '142 Santa Clara Dr, unit 14 ', `city`='Naples', `postCode`='34104', `state`='Florida', `country`='United States', `pending`='1', `middleEntryDate`='2026-01-26 16:37:32' where `newSystemMemberID`='gid://shopify/Customer/7201554825396'
gid://shopify/Order/5910683386036Exported


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 --eyJsYXN0X2lkIjo1OTEwNjgzMzg2MDM2LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAwNDoyNzowMy41ODAwODAifQ==INSERT INTO `newsystem_orders` SET   `newSystemOrderID`='gid://shopify/Order/5910683386036' ,`newSystemOrderNumber`='SRI#98778' ,`newSystemCustomerID`='gid://shopify/Customer/7201554825396' ,`shopify_recommendation`='LOW' ,`order_created`='2024-09-18 21:27:06' ,`newSystemCustomerEmail`='ddimitrova2@yahoo.com' ,`order_completed`='2024-09-18 21:27:03' ,`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`='eyJsYXN0X2lkIjo1OTEwNjgzMzg2MDM2LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAwNDoyNzowMy41ODAwODAifQ==' ,`store`='SRI'
Array
(
    [newSystemOrderID] => gid://shopify/Order/5910683386036
    [newSystemProductId] => gid://shopify/LineItem/14370258419892
    [stockCode] => Warranty
    [actualCIStockCode] => Warranty
    [quantity] => 1
    [unitPrice] => 17.00
    [discountAmount] => 0.0
    [store] => SRI
)
INSERT INTO `newsystem_orders_product` SET   `newSystemOrderID`='gid://shopify/Order/5910683386036' ,`newSystemProductId`='gid://shopify/LineItem/14370258419892' ,`stockCode`='Warranty' ,`actualCIStockCode`='Warranty' ,`quantity`='1' ,`unitPrice`='17.00' ,`discountAmount`='0.0' ,`store`='SRI'INSERT INTO `newsystem_order_delivery` SET   `newSystemMemberID`='gid://shopify/Customer/7201554825396' ,`newSystemOrderID`='gid://shopify/Order/5910683386036' ,`deliveryFirstName`='Darina' ,`deliveryLastName`='Nedelcheva' ,`deliveryPhone`='+359898726411' ,`deliveryStreet`='190 14 Th AVE NW ' ,`deliverySuburb`='' ,`deliveryPostCode`='34120' ,`deliveryCountry`='United States' ,`deliveryCity`='Naples' ,`deliveryState`='Florida' ,`store`='SRI'SRI#98779 processing
dlknotek@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/7369188540596','dlknotek@yahoo.com', 'Diane', 'Knotek', '', '6026966408', '6026966408', '10725 N De La Warr Cir ', 'Mequon','53092', 'Wisconsin', 'United States', '1', '2026-01-26 16:37:32')
gid://shopify/Order/5910696001716Exported

New Cursor --eyJsYXN0X2lkIjo1OTEwNjk2MDAxNzE2LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAwNDo0NDoyOC41MzY0NTUifQ==INSERT INTO `newsystem_orders` SET   `newSystemOrderID`='gid://shopify/Order/5910696001716' ,`newSystemOrderNumber`='SRI#98779' ,`newSystemCustomerID`='gid://shopify/Customer/7369188540596' ,`shopify_recommendation`='LOW' ,`order_created`='2024-09-18 21:44:31' ,`newSystemCustomerEmail`='dlknotek@yahoo.com' ,`order_completed`='2024-09-18 21:44:28' ,`currency`='USD' ,`order_total`='347.09' ,`order_subtotal`='328.99' ,`total_items`='2' ,`shipping_methods`='shopify' ,`total_shipping`='0.0' ,`payment_detail_title`='Shopify_Payments' ,`payment_detail_status`='PAID' ,`note`='' ,`taxAmount`='18.1' ,`coupon_code`='DRYQFALL' ,`coupon_amount`='140.0' ,`internalPaymentType`='Shopify_Payments' ,`fullfillment_status`='FULFILLED' ,`shipping_country`='United States' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTEwNjk2MDAxNzE2LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xOSAwNDo0NDoyOC41MzY0NTUifQ==' ,`store`='SRI'
Array
(
    [newSystemOrderID] => gid://shopify/Order/5910696001716
    [newSystemProductId] => gid://shopify/LineItem/14370281390260
    [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/5910696001716' ,`newSystemProductId`='gid://shopify/LineItem/14370281390260' ,`stockCode`='SRI-DryQ-Ver2' ,`actualCIStockCode`='SRI-DryQ-Ver2' ,`quantity`='1' ,`unitPrice`='299.99' ,`discountAmount`='0.0' ,`store`='SRI'Array
(
    [newSystemOrderID] => gid://shopify/Order/5910696001716
    [newSystemProductId] => gid://shopify/LineItem/14370291187892
    [stockCode] => SRI-InfraStyler-Ver2-TE-X1
    [actualCIStockCode] => SRI-InfraStyler-Ver2-TE-X1
    [quantity] => 1
    [unitPrice] => 169.00
    [discountAmount] => 70.0
    [store] => SRI
)
INSERT INTO `newsystem_orders_product` SET   `newSystemOrderID`='gid://shopify/Order/5910696001716' ,`newSystemProductId`='gid://shopify/LineItem/14370291187892' ,`stockCode`='SRI-InfraStyler-Ver2-TE-X1' ,`actualCIStockCode`='SRI-InfraStyler-Ver2-TE-X1' ,`quantity`='1' ,`unitPrice`='169.00' ,`discountAmount`='70.0' ,`store`='SRI'INSERT INTO `newsystem_order_delivery` SET   `newSystemMemberID`='gid://shopify/Customer/7369188540596' ,`newSystemOrderID`='gid://shopify/Order/5910696001716' ,`deliveryFirstName`='Diane' ,`deliveryLastName`='Knotek' ,`deliveryPhone`='6026966408' ,`deliveryStreet`='10725 N De La Warr Cir ' ,`deliverySuburb`='' ,`deliveryPostCode`='53092' ,`deliveryCountry`='United States' ,`deliveryCity`='Mequon' ,`deliveryState`='Wisconsin' ,`store`='SRI'