select shopifyCursor from newsystem_refund_orders where orderType='shopify' and store='SRI' order by order_created desc limit 1
gid://shopify/Order/5958237192372Exported
INSERT INTO `newsystem_refund_orders` SET   `newSystemOrderID`='gid://shopify/Order/5958237192372' ,`newSystemOrderNumber`='SRI#101992' ,`order_created`='2024-10-17 12:44:47' ,`order_completed`='2024-10-17 12:44:42' ,`order_total`='245.66' ,`order_subtotal`='227.99' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='17.67' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1038471856308' ,`refund_date`='2024-12-24 17:36:07' ,`refund_amount`='245.66' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTU4MjM3MTkyMzcyLCJsYXN0X3ZhbHVlIjoiMjAyNC0xMC0xNyAxOTo0NDo0Mi41MzM3MjIifQ==' ,`store`='SRI'
DELETE FROM  `newsystem_refund_orders_product` WHERE   `newSystemOrderID`='gid://shopify/Order/5958237192372' and `store`='SRI'INSERT INTO `newsystem_refund_orders_product` SET   `newSystemOrderID`='gid://shopify/Order/5958237192372' ,`newSystemProductId`='gid://shopify/Product/7340264521908' ,`stockCode`='SRI-DryQ-Ver2' ,`refundLineItem`='gid://shopify/LineItem/14475978604724' ,`quantity`='1' ,`unitPrice`='227.99' ,`store`='SRI'
gid://shopify/Order/5958407684276Exported
INSERT INTO `newsystem_refund_orders` SET   `newSystemOrderID`='gid://shopify/Order/5958407684276' ,`newSystemOrderNumber`='SRI#102009' ,`order_created`='2024-10-17 14:34:59' ,`order_completed`='2024-10-17 14:34:55' ,`order_total`='247.94' ,`order_subtotal`='227.99' ,`payment_detail_status`='PARTIALLY_REFUNDED' ,`taxAmount`='19.95' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1012014350516' ,`refund_date`='2024-10-28 13:48:29' ,`refund_amount`='86.77' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTU4NDA3Njg0Mjc2LCJsYXN0X3ZhbHVlIjoiMjAyNC0xMC0xNyAyMTozNDo1NS43NjMxMjYifQ==' ,`store`='SRI'
gid://shopify/Order/5958432391348Exported
INSERT INTO `newsystem_refund_orders` SET   `newSystemOrderID`='gid://shopify/Order/5958432391348' ,`newSystemOrderNumber`='SRI#102010' ,`order_created`='2024-10-17 14:52:17' ,`order_completed`='2024-10-17 14:52:12' ,`order_total`='131.76' ,`order_subtotal`='122.0' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='9.76' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1015366647988' ,`refund_date`='2024-11-08 17:19:37' ,`refund_amount`='131.76' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTU4NDMyMzkxMzQ4LCJsYXN0X3ZhbHVlIjoiMjAyNC0xMC0xNyAyMTo1MjoxMi41NzI4NDUifQ==' ,`store`='SRI'
DELETE FROM  `newsystem_refund_orders_product` WHERE   `newSystemOrderID`='gid://shopify/Order/5958432391348' and `store`='SRI'INSERT INTO `newsystem_refund_orders_product` SET   `newSystemOrderID`='gid://shopify/Order/5958432391348' ,`newSystemProductId`='gid://shopify/Product/7341676429492' ,`stockCode`='SRI-InfraStyler-Ver2-TE-X1' ,`refundLineItem`='gid://shopify/LineItem/14476476809396' ,`quantity`='1' ,`unitPrice`='122.0' ,`store`='SRI'