select shopifyCursor from newsystem_refund_orders where orderType='shopify' and store='SRI' order by order_created desc limit 1
gid://shopify/Order/5900376015028Exported
INSERT INTO `newsystem_refund_orders` SET   `newSystemOrderID`='gid://shopify/Order/5900376015028' ,`newSystemOrderNumber`='SRI#98097' ,`order_created`='2024-09-12 18:30:15' ,`order_completed`='2024-09-12 18:30:14' ,`order_total`='217.19' ,`order_subtotal`='197.0' ,`payment_detail_status`='PARTIALLY_REFUNDED' ,`taxAmount`='20.19' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1005801570484' ,`refund_date`='2024-09-27 13:08:11' ,`refund_amount`='108.0' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTAwMzc2MDE1MDI4LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xMyAwMTozMDoxNC4wMDAwMDAifQ==' ,`store`='SRI'
gid://shopify/Order/5900767068340Exported
INSERT INTO `newsystem_refund_orders` SET   `newSystemOrderID`='gid://shopify/Order/5900767068340' ,`newSystemOrderNumber`='SRI#98108' ,`order_created`='2024-09-13 02:02:16' ,`order_completed`='2024-09-13 02:02:11' ,`order_total`='253.55' ,`order_subtotal`='229.99' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='23.56' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1005863010484' ,`refund_date`='2024-09-27 17:34:33' ,`refund_amount`='253.55' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTAwNzY3MDY4MzQwLCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xMyAwOTowMjoxMS4wOTk2NDcifQ==' ,`store`='SRI'
DELETE FROM  `newsystem_refund_orders_product` WHERE   `newSystemOrderID`='gid://shopify/Order/5900767068340' and `store`='SRI'INSERT INTO `newsystem_refund_orders_product` SET   `newSystemOrderID`='gid://shopify/Order/5900767068340' ,`newSystemProductId`='gid://shopify/Product/7340264521908' ,`stockCode`='SRI-DryQ-Ver2' ,`refundLineItem`='gid://shopify/LineItem/14349638926516' ,`quantity`='1' ,`unitPrice`='229.99' ,`store`='SRI'
gid://shopify/Order/5901462470836Exported
INSERT INTO `newsystem_refund_orders` SET   `newSystemOrderID`='gid://shopify/Order/5901462470836' ,`newSystemOrderNumber`='SRI#98167' ,`order_created`='2024-09-13 11:48:40' ,`order_completed`='2024-09-13 11:48:37' ,`order_total`='250.4' ,`order_subtotal`='229.99' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='20.41' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1010006556852' ,`refund_date`='2024-10-18 14:43:10' ,`refund_amount`='250.4' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTAxNDYyNDcwODM2LCJsYXN0X3ZhbHVlIjoiMjAyNC0wOS0xMyAxODo0ODozNy4xNDczMjIifQ==' ,`store`='SRI'
DELETE FROM  `newsystem_refund_orders_product` WHERE   `newSystemOrderID`='gid://shopify/Order/5901462470836' and `store`='SRI'INSERT INTO `newsystem_refund_orders_product` SET   `newSystemOrderID`='gid://shopify/Order/5901462470836' ,`newSystemProductId`='gid://shopify/Product/7340264521908' ,`stockCode`='SRI-DryQ-Ver2' ,`refundLineItem`='gid://shopify/LineItem/14351087468724' ,`quantity`='1' ,`unitPrice`='229.99' ,`store`='SRI'