select shopifyCursor from newsystem_refund_orders where orderType='shopify' and store='SRI' order by order_created desc limit 1
gid://shopify/Order/5965222248628Exported
INSERT INTO `newsystem_refund_orders` SET   `newSystemOrderID`='gid://shopify/Order/5965222248628' ,`newSystemOrderNumber`='SRI#102491' ,`order_created`='2024-10-21 17:16:05' ,`order_completed`='2024-10-21 17:16:01' ,`order_total`='330.59' ,`order_subtotal`='299.99' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='30.6' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1028085219508' ,`refund_date`='2024-12-05 16:05:02' ,`refund_amount`='330.59' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTY1MjIyMjQ4NjI4LCJsYXN0X3ZhbHVlIjoiMjAyNC0xMC0yMiAwMDoxNjowMS43NzczOTMifQ==' ,`store`='SRI'
DELETE FROM  `newsystem_refund_orders_product` WHERE   `newSystemOrderID`='gid://shopify/Order/5965222248628' and `store`='SRI'INSERT INTO `newsystem_refund_orders_product` SET   `newSystemOrderID`='gid://shopify/Order/5965222248628' ,`newSystemProductId`='gid://shopify/Product/7340264521908' ,`stockCode`='SRI-DryQ-Ver2' ,`refundLineItem`='gid://shopify/LineItem/14492518875316' ,`quantity`='1' ,`unitPrice`='299.99' ,`store`='SRI'
gid://shopify/Order/5965847756980Exported
INSERT INTO `newsystem_refund_orders` SET   `newSystemOrderID`='gid://shopify/Order/5965847756980' ,`newSystemOrderNumber`='SRI#102531' ,`order_created`='2024-10-22 05:42:25' ,`order_completed`='2024-10-22 05:42:21' ,`order_total`='245.46' ,`order_subtotal`='227.99' ,`payment_detail_status`='PARTIALLY_REFUNDED' ,`taxAmount`='17.47' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1025768128692' ,`refund_date`='2024-12-01 21:00:56' ,`refund_amount`='60.0' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTY1ODQ3NzU2OTgwLCJsYXN0X3ZhbHVlIjoiMjAyNC0xMC0yMiAxMjo0MjoyMS4wNjc4ODcifQ==' ,`store`='SRI'
gid://shopify/Order/5965943767220Exported
INSERT INTO `newsystem_refund_orders` SET   `newSystemOrderID`='gid://shopify/Order/5965943767220' ,`newSystemOrderNumber`='SRI#102546' ,`order_created`='2024-10-22 07:20:39' ,`order_completed`='2024-10-22 07:20:36' ,`order_total`='248.22' ,`order_subtotal`='227.99' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='20.23' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1026907930804' ,`refund_date`='2024-12-03 15:16:57' ,`refund_amount`='248.22' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTY1OTQzNzY3MjIwLCJsYXN0X3ZhbHVlIjoiMjAyNC0xMC0yMiAxNDoyMDozNi41MTkwODkifQ==' ,`store`='SRI'
DELETE FROM  `newsystem_refund_orders_product` WHERE   `newSystemOrderID`='gid://shopify/Order/5965943767220' and `store`='SRI'INSERT INTO `newsystem_refund_orders_product` SET   `newSystemOrderID`='gid://shopify/Order/5965943767220' ,`newSystemProductId`='gid://shopify/Product/7340264521908' ,`stockCode`='SRI-DryQ-Ver2' ,`refundLineItem`='gid://shopify/LineItem/14494099701940' ,`quantity`='1' ,`unitPrice`='227.99' ,`store`='SRI'