select shopifyCursor from newsystem_refund_orders where orderType='shopify' and store='SRI' order by order_created desc limit 1
gid://shopify/Order/6034622873780Exported
INSERT INTO `newsystem_refund_orders` SET `newSystemOrderID`='gid://shopify/Order/6034622873780' ,`newSystemOrderNumber`='SRI#106434' ,`order_created`='2024-11-16 12:25:26' ,`order_completed`='2024-11-16 12:25:23' ,`order_total`='239.9' ,`order_subtotal`='224.99' ,`payment_detail_status`='PARTIALLY_REFUNDED' ,`taxAmount`='14.91' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1021163012276' ,`refund_date`='2024-11-22 17:20:32' ,`refund_amount`='37.31' ,`shopifyCursor`='eyJsYXN0X2lkIjo2MDM0NjIyODczNzgwLCJsYXN0X3ZhbHVlIjoiMjAyNC0xMS0xNiAyMDoyNToyMy4zNzkxNzcifQ==' ,`store`='SRI'
gid://shopify/Order/6034625036468Exported
INSERT INTO `newsystem_refund_orders` SET `newSystemOrderID`='gid://shopify/Order/6034625036468' ,`newSystemOrderNumber`='SRI#106435' ,`order_created`='2024-11-16 12:26:24' ,`order_completed`='2024-11-16 12:26:21' ,`order_total`='242.15' ,`order_subtotal`='224.99' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='17.16' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1025767243956' ,`refund_date`='2024-12-01 20:48:42' ,`refund_amount`='80.0' ,`shopifyCursor`='eyJsYXN0X2lkIjo2MDM0NjI1MDM2NDY4LCJsYXN0X3ZhbHVlIjoiMjAyNC0xMS0xNiAyMDoyNjoyMS45NTU3MjUifQ==' ,`store`='SRI'
INSERT INTO `newsystem_refund_orders` SET `newSystemOrderID`='gid://shopify/Order/6034625036468' ,`newSystemOrderNumber`='SRI#106435' ,`order_created`='2024-11-16 12:26:24' ,`order_completed`='2024-11-16 12:26:21' ,`order_total`='242.15' ,`order_subtotal`='224.99' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='17.16' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1047880433844' ,`refund_date`='2025-01-08 12:23:25' ,`refund_amount`='162.15' ,`shopifyCursor`='eyJsYXN0X2lkIjo2MDM0NjI1MDM2NDY4LCJsYXN0X3ZhbHVlIjoiMjAyNC0xMS0xNiAyMDoyNjoyMS45NTU3MjUifQ==' ,`store`='SRI'
DELETE FROM `newsystem_refund_orders_product` WHERE `newSystemOrderID`='gid://shopify/Order/6034625036468' and `store`='SRI'INSERT INTO `newsystem_refund_orders_product` SET `newSystemOrderID`='gid://shopify/Order/6034625036468' ,`newSystemProductId`='gid://shopify/Product/7416737136820' ,`stockCode`='SRI-DryQ-Ver2' ,`refundLineItem`='gid://shopify/LineItem/14671805481140' ,`quantity`='1' ,`unitPrice`='224.99' ,`store`='SRI'
gid://shopify/Order/6034865127604Exported
INSERT INTO `newsystem_refund_orders` SET `newSystemOrderID`='gid://shopify/Order/6034865127604' ,`newSystemOrderNumber`='SRI#106459' ,`order_created`='2024-11-16 14:16:41' ,`order_completed`='2024-11-16 14:16:37' ,`order_total`='245.8' ,`order_subtotal`='224.99' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='20.81' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1054811029684' ,`refund_date`='2025-01-24 15:51:15' ,`refund_amount`='245.8' ,`shopifyCursor`='eyJsYXN0X2lkIjo2MDM0ODY1MTI3NjA0LCJsYXN0X3ZhbHVlIjoiMjAyNC0xMS0xNiAyMjoxNjozNy4yNzczNzIifQ==' ,`store`='SRI'
DELETE FROM `newsystem_refund_orders_product` WHERE `newSystemOrderID`='gid://shopify/Order/6034865127604' and `store`='SRI'INSERT INTO `newsystem_refund_orders_product` SET `newSystemOrderID`='gid://shopify/Order/6034865127604' ,`newSystemProductId`='gid://shopify/Product/7340264521908' ,`stockCode`='SRI-DryQ-Ver2' ,`refundLineItem`='gid://shopify/LineItem/14672391471284' ,`quantity`='1' ,`unitPrice`='224.99' ,`store`='SRI'