select shopifyCursor from newsystem_refund_orders where orderType='shopify' and store='SRI' order by order_created desc limit 1
gid://shopify/Order/6023691731124Exported
INSERT INTO `newsystem_refund_orders` SET `newSystemOrderID`='gid://shopify/Order/6023691731124' ,`newSystemOrderNumber`='SRI#105910' ,`order_created`='2024-11-13 18:06:08' ,`order_completed`='2024-11-13 18:06:04' ,`order_total`='343.42' ,`order_subtotal`='323.99' ,`payment_detail_status`='PARTIALLY_REFUNDED' ,`taxAmount`='19.43' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1027614572724' ,`refund_date`='2024-12-04 17:29:10' ,`refund_amount`='90.0' ,`shopifyCursor`='eyJsYXN0X2lkIjo2MDIzNjkxNzMxMTI0LCJsYXN0X3ZhbHVlIjoiMjAyNC0xMS0xNCAwMjowNjowNC43MjcyODQifQ==' ,`store`='SRI'
gid://shopify/Order/6024511717556Exported
INSERT INTO `newsystem_refund_orders` SET `newSystemOrderID`='gid://shopify/Order/6024511717556' ,`newSystemOrderNumber`='SRI#105931' ,`order_created`='2024-11-13 23:25:50' ,`order_completed`='2024-11-13 23:25:46' ,`order_total`='123.41' ,`order_subtotal`='114.0' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='9.41' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1028133290164' ,`refund_date`='2024-12-05 17:39:11' ,`refund_amount`='123.41' ,`shopifyCursor`='eyJsYXN0X2lkIjo2MDI0NTExNzE3NTU2LCJsYXN0X3ZhbHVlIjoiMjAyNC0xMS0xNCAwNzoyNTo0Ni40MDc2MDAifQ==' ,`store`='SRI'
DELETE FROM `newsystem_refund_orders_product` WHERE `newSystemOrderID`='gid://shopify/Order/6024511717556' and `store`='SRI'INSERT INTO `newsystem_refund_orders_product` SET `newSystemOrderID`='gid://shopify/Order/6024511717556' ,`newSystemProductId`='gid://shopify/Product/7341676429492' ,`stockCode`='SRI-InfraStyler-Ver2-TE-X1' ,`refundLineItem`='gid://shopify/LineItem/14648442945716' ,`quantity`='1' ,`unitPrice`='114.0' ,`store`='SRI'
gid://shopify/Order/6024768520372Exported
INSERT INTO `newsystem_refund_orders` SET `newSystemOrderID`='gid://shopify/Order/6024768520372' ,`newSystemOrderNumber`='SRI#105937' ,`order_created`='2024-11-14 03:08:24' ,`order_completed`='2024-11-14 03:08:19' ,`order_total`='417.63' ,`order_subtotal`='393.99' ,`payment_detail_status`='PARTIALLY_REFUNDED' ,`taxAmount`='23.64' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1018322223284' ,`refund_date`='2024-11-15 16:31:10' ,`refund_amount`='52.73' ,`shopifyCursor`='eyJsYXN0X2lkIjo2MDI0NzY4NTIwMzcyLCJsYXN0X3ZhbHVlIjoiMjAyNC0xMS0xNCAxMTowODoxOS4zMDU4MDEifQ==' ,`store`='SRI'