select shopifyCursor from newsystem_refund_orders where orderType='shopify' and store='SRI' order by order_created desc limit 1
gid://shopify/Order/5992963014836Exported
INSERT INTO `newsystem_refund_orders` SET   `newSystemOrderID`='gid://shopify/Order/5992963014836' ,`newSystemOrderNumber`='SRI#103791' ,`order_created`='2024-11-01 12:20:45' ,`order_completed`='2024-11-01 12:20:41' ,`order_total`='214.08' ,`order_subtotal`='194.0' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='20.08' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1027695050932' ,`refund_date`='2024-12-05 05:52:08' ,`refund_amount`='214.08' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTkyOTYzMDE0ODM2LCJsYXN0X3ZhbHVlIjoiMjAyNC0xMS0wMSAxOToyMDo0MS45OTM0MjgifQ==' ,`store`='SRI'
DELETE FROM  `newsystem_refund_orders_product` WHERE   `newSystemOrderID`='gid://shopify/Order/5992963014836' 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/5992963014836' ,`newSystemProductId`='' ,`stockCode`='StyleWrap-X1' ,`refundLineItem`='gid://shopify/LineItem/14568547811508' ,`quantity`='1' ,`unitPrice`='194.0' ,`store`='SRI'
gid://shopify/Order/5993030811828Exported
INSERT INTO `newsystem_refund_orders` SET   `newSystemOrderID`='gid://shopify/Order/5993030811828' ,`newSystemOrderNumber`='SRI#103800' ,`order_created`='2024-11-01 13:00:50' ,`order_completed`='2024-11-01 13:00:44' ,`order_total`='242.54' ,`order_subtotal`='224.99' ,`payment_detail_status`='PARTIALLY_REFUNDED' ,`taxAmount`='17.55' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1036395217076' ,`refund_date`='2024-12-20 17:00:41' ,`refund_amount`='83.0' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTkzMDMwODExODI4LCJsYXN0X3ZhbHVlIjoiMjAyNC0xMS0wMSAyMDowMDo0NC41NjIyMDgifQ==' ,`store`='SRI'
gid://shopify/Order/5993146974388Exported
INSERT INTO `newsystem_refund_orders` SET   `newSystemOrderID`='gid://shopify/Order/5993146974388' ,`newSystemOrderNumber`='SRI#103813' ,`order_created`='2024-11-01 14:13:04' ,`order_completed`='2024-11-01 14:12:59' ,`order_total`='238.49' ,`order_subtotal`='224.99' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='13.5' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1015371530420' ,`refund_date`='2024-11-08 17:47:03' ,`refund_amount`='238.49' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTkzMTQ2OTc0Mzg4LCJsYXN0X3ZhbHVlIjoiMjAyNC0xMS0wMSAyMToxMjo1OS44NTM2NjkifQ==' ,`store`='SRI'
DELETE FROM  `newsystem_refund_orders_product` WHERE   `newSystemOrderID`='gid://shopify/Order/5993146974388' and `store`='SRI'INSERT INTO `newsystem_refund_orders_product` SET   `newSystemOrderID`='gid://shopify/Order/5993146974388' ,`newSystemProductId`='gid://shopify/Product/7041246068916' ,`stockCode`='SRI-DryQ-Ver2' ,`refundLineItem`='gid://shopify/LineItem/14569026879668' ,`quantity`='1' ,`unitPrice`='224.99' ,`store`='SRI'