select shopifyCursor from newsystem_refund_orders where orderType='shopify' and store='SRI' order by order_created desc limit 1
gid://shopify/Order/5957659656372Exported
INSERT INTO `newsystem_refund_orders` SET   `newSystemOrderID`='gid://shopify/Order/5957659656372' ,`newSystemOrderNumber`='SRI#101951' ,`order_created`='2024-10-17 06:04:54' ,`order_completed`='2024-10-17 06:04:51' ,`order_total`='347.75' ,`order_subtotal`='321.99' ,`payment_detail_status`='PARTIALLY_REFUNDED' ,`taxAmount`='25.76' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1012011532468' ,`refund_date`='2024-10-28 13:41:11' ,`refund_amount`='65.0' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTU3NjU5NjU2MzcyLCJsYXN0X3ZhbHVlIjoiMjAyNC0xMC0xNyAxMzowNDo1MS4xMjk5NzcifQ==' ,`store`='SRI'
gid://shopify/Order/5957990154420Exported
INSERT INTO `newsystem_refund_orders` SET   `newSystemOrderID`='gid://shopify/Order/5957990154420' ,`newSystemOrderNumber`='SRI#101975' ,`order_created`='2024-10-17 10:11:38' ,`order_completed`='2024-10-17 10:11:33' ,`order_total`='139.0' ,`order_subtotal`='139.0' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='0.0' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1028043178164' ,`refund_date`='2024-12-05 15:00:30' ,`refund_amount`='139.0' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTU3OTkwMTU0NDIwLCJsYXN0X3ZhbHVlIjoiMjAyNC0xMC0xNyAxNzoxMTozMy42OTk3NzcifQ==' ,`store`='SRI'
DELETE FROM  `newsystem_refund_orders_product` WHERE   `newSystemOrderID`='gid://shopify/Order/5957990154420' and `store`='SRI'INSERT INTO `newsystem_refund_orders_product` SET   `newSystemOrderID`='gid://shopify/Order/5957990154420' ,`newSystemProductId`='gid://shopify/Product/7418455654580' ,`stockCode`='SRISupraCurlX1' ,`refundLineItem`='gid://shopify/LineItem/14475345494196' ,`quantity`='1' ,`unitPrice`='139.0' ,`store`='SRI'
gid://shopify/Order/5958016237748Exported
INSERT INTO `newsystem_refund_orders` SET   `newSystemOrderID`='gid://shopify/Order/5958016237748' ,`newSystemOrderNumber`='SRI#101980' ,`order_created`='2024-10-17 10:26:38' ,`order_completed`='2024-10-17 10:26:32' ,`order_total`='245.37' ,`order_subtotal`='227.99' ,`payment_detail_status`='PARTIALLY_REFUNDED' ,`taxAmount`='17.38' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1010617450676' ,`refund_date`='2024-10-21 18:09:12' ,`refund_amount`='61.34' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTU4MDE2MjM3NzQ4LCJsYXN0X3ZhbHVlIjoiMjAyNC0xMC0xNyAxNzoyNjozMi45OTM3ODIifQ==' ,`store`='SRI'