select shopifyCursor from newsystem_refund_orders where orderType='shopify' and store='SRI' order by order_created desc limit 1
gid://shopify/Order/5972981416116Exported
INSERT INTO `newsystem_refund_orders` SET   `newSystemOrderID`='gid://shopify/Order/5972981416116' ,`newSystemOrderNumber`='SRI#103051' ,`order_created`='2024-10-26 09:57:33' ,`order_completed`='2024-10-26 09:57:29' ,`order_total`='200.09' ,`order_subtotal`='187.0' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='13.09' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1035391402164' ,`refund_date`='2024-12-18 17:56:08' ,`refund_amount`='200.09' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTcyOTgxNDE2MTE2LCJsYXN0X3ZhbHVlIjoiMjAyNC0xMC0yNiAxNjo1NzoyOS4yNDE0OTYifQ==' ,`store`='SRI'
DELETE FROM  `newsystem_refund_orders_product` WHERE   `newSystemOrderID`='gid://shopify/Order/5972981416116' and `store`='SRI'INSERT INTO `newsystem_refund_orders_product` SET   `newSystemOrderID`='gid://shopify/Order/5972981416116' ,`newSystemProductId`='gid://shopify/Product/7414843637940' ,`stockCode`='SRI-InfraroseSteamStyler-Ver1' ,`refundLineItem`='gid://shopify/LineItem/14509617840308' ,`quantity`='1' ,`unitPrice`='187.0' ,`store`='SRI'
gid://shopify/Order/5973065171124Exported
INSERT INTO `newsystem_refund_orders` SET   `newSystemOrderID`='gid://shopify/Order/5973065171124' ,`newSystemOrderNumber`='SRI#103057' ,`order_created`='2024-10-26 10:42:53' ,`order_completed`='2024-10-26 10:42:48' ,`order_total`='247.65' ,`order_subtotal`='227.99' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='19.66' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1021174710452' ,`refund_date`='2024-11-22 18:03:49' ,`refund_amount`='247.65' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTczMDY1MTcxMTI0LCJsYXN0X3ZhbHVlIjoiMjAyNC0xMC0yNiAxNzo0Mjo0OC4zNzA4MzQifQ==' ,`store`='SRI'
DELETE FROM  `newsystem_refund_orders_product` WHERE   `newSystemOrderID`='gid://shopify/Order/5973065171124' and `store`='SRI'INSERT INTO `newsystem_refund_orders_product` SET   `newSystemOrderID`='gid://shopify/Order/5973065171124' ,`newSystemProductId`='gid://shopify/Product/7340264521908' ,`stockCode`='SRI-DryQ-Ver2' ,`refundLineItem`='gid://shopify/LineItem/14509823951028' ,`quantity`='1' ,`unitPrice`='227.99' ,`store`='SRI'
gid://shopify/Order/5973090500788Exported
INSERT INTO `newsystem_refund_orders` SET   `newSystemOrderID`='gid://shopify/Order/5973090500788' ,`newSystemOrderNumber`='SRI#103061' ,`order_created`='2024-10-26 10:57:11' ,`order_completed`='2024-10-26 10:57:06' ,`order_total`='247.42' ,`order_subtotal`='227.99' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='19.43' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1022431133876' ,`refund_date`='2024-11-25 17:50:13' ,`refund_amount`='247.42' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTczMDkwNTAwNzg4LCJsYXN0X3ZhbHVlIjoiMjAyNC0xMC0yNiAxNzo1NzowNi45MDA5NTgifQ==' ,`store`='SRI'
DELETE FROM  `newsystem_refund_orders_product` WHERE   `newSystemOrderID`='gid://shopify/Order/5973090500788' and `store`='SRI'INSERT INTO `newsystem_refund_orders_product` SET   `newSystemOrderID`='gid://shopify/Order/5973090500788' ,`newSystemProductId`='gid://shopify/Product/7340264521908' ,`stockCode`='SRI-DryQ-Ver2' ,`refundLineItem`='gid://shopify/LineItem/14509887029428' ,`quantity`='1' ,`unitPrice`='227.99' ,`store`='SRI'