select shopifyCursor from newsystem_refund_orders where orderType='shopify' and store='SRI' order by order_created desc limit 1
gid://shopify/Order/5993223192756Exported
INSERT INTO `newsystem_refund_orders` SET   `newSystemOrderID`='gid://shopify/Order/5993223192756' ,`newSystemOrderNumber`='SRI#103825' ,`order_created`='2024-11-01 15:05:18' ,`order_completed`='2024-11-01 15:05:15' ,`order_total`='238.26' ,`order_subtotal`='224.99' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='13.27' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1035793105076' ,`refund_date`='2024-12-19 14:51:09' ,`refund_amount`='238.26' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTkzMjIzMTkyNzU2LCJsYXN0X3ZhbHVlIjoiMjAyNC0xMS0wMSAyMjowNToxNS41OTgyNjUifQ==' ,`store`='SRI'
DELETE FROM  `newsystem_refund_orders_product` WHERE   `newSystemOrderID`='gid://shopify/Order/5993223192756' and `store`='SRI'INSERT INTO `newsystem_refund_orders_product` SET   `newSystemOrderID`='gid://shopify/Order/5993223192756' ,`newSystemProductId`='gid://shopify/Product/7340264521908' ,`stockCode`='SRI-DryQ-Ver2' ,`refundLineItem`='gid://shopify/LineItem/14569229090996' ,`quantity`='1' ,`unitPrice`='224.99' ,`store`='SRI'
gid://shopify/Order/5993233449140Exported
INSERT INTO `newsystem_refund_orders` SET   `newSystemOrderID`='gid://shopify/Order/5993233449140' ,`newSystemOrderNumber`='SRI#103828' ,`order_created`='2024-11-01 15:12:24' ,`order_completed`='2024-11-01 15:12:21' ,`order_total`='142.38' ,`order_subtotal`='134.0' ,`payment_detail_status`='PARTIALLY_REFUNDED' ,`taxAmount`='8.38' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1039595405492' ,`refund_date`='2024-12-26 17:22:19' ,`refund_amount`='71.0' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTkzMjMzNDQ5MTQwLCJsYXN0X3ZhbHVlIjoiMjAyNC0xMS0wMSAyMjoxMjoyMS40Mjc3NjAifQ==' ,`store`='SRI'
gid://shopify/Order/5993342599348Exported
INSERT INTO `newsystem_refund_orders` SET   `newSystemOrderID`='gid://shopify/Order/5993342599348' ,`newSystemOrderNumber`='SRI#103839' ,`order_created`='2024-11-01 16:30:08' ,`order_completed`='2024-11-01 16:30:05' ,`order_total`='207.59' ,`order_subtotal`='194.0' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='13.59' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1021138206900' ,`refund_date`='2024-11-22 16:10:42' ,`refund_amount`='70.0' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTkzMzQyNTk5MzQ4LCJsYXN0X3ZhbHVlIjoiMjAyNC0xMS0wMSAyMzozMDowNS4xMDEwNzYifQ==' ,`store`='SRI'
INSERT INTO `newsystem_refund_orders` SET   `newSystemOrderID`='gid://shopify/Order/5993342599348' ,`newSystemOrderNumber`='SRI#103839' ,`order_created`='2024-11-01 16:30:08' ,`order_completed`='2024-11-01 16:30:05' ,`order_total`='207.59' ,`order_subtotal`='194.0' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='13.59' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1047944954036' ,`refund_date`='2025-01-08 13:48:10' ,`refund_amount`='137.59' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTkzMzQyNTk5MzQ4LCJsYXN0X3ZhbHVlIjoiMjAyNC0xMS0wMSAyMzozMDowNS4xMDEwNzYifQ==' ,`store`='SRI'
DELETE FROM  `newsystem_refund_orders_product` WHERE   `newSystemOrderID`='gid://shopify/Order/5993342599348' and `store`='SRI'

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

INSERT INTO `newsystem_refund_orders_product` SET   `newSystemOrderID`='gid://shopify/Order/5993342599348' ,`newSystemProductId`='' ,`stockCode`='StyleWrap-X1' ,`refundLineItem`='gid://shopify/LineItem/14569543139508' ,`quantity`='1' ,`unitPrice`='194.0' ,`store`='SRI'