select shopifyCursor from newsystem_refund_orders where orderType='shopify' and store='SRI' order by order_created desc limit 1
gid://shopify/Order/5951453692084Exported
INSERT INTO `newsystem_refund_orders` SET   `newSystemOrderID`='gid://shopify/Order/5951453692084' ,`newSystemOrderNumber`='SRI#101474' ,`order_created`='2024-10-13 06:33:26' ,`order_completed`='2024-10-13 06:33:23' ,`order_total`='246.23' ,`order_subtotal`='227.99' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='18.24' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1022449451188' ,`refund_date`='2024-11-25 18:49:15' ,`refund_amount`='246.23' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTUxNDUzNjkyMDg0LCJsYXN0X3ZhbHVlIjoiMjAyNC0xMC0xMyAxMzozMzoyMy4xODE1NzgifQ==' ,`store`='SRI'
DELETE FROM  `newsystem_refund_orders_product` WHERE   `newSystemOrderID`='gid://shopify/Order/5951453692084' and `store`='SRI'INSERT INTO `newsystem_refund_orders_product` SET   `newSystemOrderID`='gid://shopify/Order/5951453692084' ,`newSystemProductId`='gid://shopify/Product/7041246068916' ,`stockCode`='SRI-DryQ-Ver2' ,`refundLineItem`='gid://shopify/LineItem/14459693727924' ,`quantity`='1' ,`unitPrice`='227.99' ,`store`='SRI'
gid://shopify/Order/5951578177716Exported
INSERT INTO `newsystem_refund_orders` SET   `newSystemOrderID`='gid://shopify/Order/5951578177716' ,`newSystemOrderNumber`='SRI#101491' ,`order_created`='2024-10-13 08:30:51' ,`order_completed`='2024-10-13 08:30:48' ,`order_total`='243.09' ,`order_subtotal`='227.99' ,`payment_detail_status`='PARTIALLY_REFUNDED' ,`taxAmount`='15.1' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1010608799924' ,`refund_date`='2024-10-21 17:17:13' ,`refund_amount`='40.51' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTUxNTc4MTc3NzE2LCJsYXN0X3ZhbHVlIjoiMjAyNC0xMC0xMyAxNTozMDo0OC4xNzQxMjUifQ==' ,`store`='SRI'
gid://shopify/Order/5951586074804Exported
INSERT INTO `newsystem_refund_orders` SET   `newSystemOrderID`='gid://shopify/Order/5951586074804' ,`newSystemOrderNumber`='SRI#101492' ,`order_created`='2024-10-13 08:36:47' ,`order_completed`='2024-10-13 08:36:42' ,`order_total`='242.24' ,`order_subtotal`='227.99' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='14.25' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1013289746612' ,`refund_date`='2024-11-01 17:51:12' ,`refund_amount`='242.24' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTUxNTg2MDc0ODA0LCJsYXN0X3ZhbHVlIjoiMjAyNC0xMC0xMyAxNTozNjo0Mi45MDUwNTcifQ==' ,`store`='SRI'
DELETE FROM  `newsystem_refund_orders_product` WHERE   `newSystemOrderID`='gid://shopify/Order/5951586074804' and `store`='SRI'INSERT INTO `newsystem_refund_orders_product` SET   `newSystemOrderID`='gid://shopify/Order/5951586074804' ,`newSystemProductId`='gid://shopify/Product/7340264521908' ,`stockCode`='SRI-DryQ-Ver2' ,`refundLineItem`='gid://shopify/LineItem/14460004761780' ,`quantity`='1' ,`unitPrice`='227.99' ,`store`='SRI'