select shopifyCursor from newsystem_refund_orders where orderType='shopify' and store='SRI' order by order_created desc limit 1
gid://shopify/Order/5994068639924Exported
INSERT INTO `newsystem_refund_orders` SET `newSystemOrderID`='gid://shopify/Order/5994068639924' ,`newSystemOrderNumber`='SRI#103893' ,`order_created`='2024-11-02 06:19:53' ,`order_completed`='2024-11-02 06:19:48' ,`order_total`='245.8' ,`order_subtotal`='224.99' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='20.81' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1019460649140' ,`refund_date`='2024-11-18 17:16:04' ,`refund_amount`='245.8' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTk0MDY4NjM5OTI0LCJsYXN0X3ZhbHVlIjoiMjAyNC0xMS0wMiAxMzoxOTo0OC4zMjk2NDkifQ==' ,`store`='SRI'
DELETE FROM `newsystem_refund_orders_product` WHERE `newSystemOrderID`='gid://shopify/Order/5994068639924' and `store`='SRI'INSERT INTO `newsystem_refund_orders_product` SET `newSystemOrderID`='gid://shopify/Order/5994068639924' ,`newSystemProductId`='gid://shopify/Product/7340264521908' ,`stockCode`='SRI-DryQ-Ver2' ,`refundLineItem`='gid://shopify/LineItem/14571237605556' ,`quantity`='1' ,`unitPrice`='224.99' ,`store`='SRI'
gid://shopify/Order/5994283073716Exported
INSERT INTO `newsystem_refund_orders` SET `newSystemOrderID`='gid://shopify/Order/5994283073716' ,`newSystemOrderNumber`='SRI#103932' ,`order_created`='2024-11-02 09:04:29' ,`order_completed`='2024-11-02 09:04:26' ,`order_total`='240.74' ,`order_subtotal`='224.99' ,`payment_detail_status`='PARTIALLY_REFUNDED' ,`taxAmount`='15.75' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1033988210868' ,`refund_date`='2024-12-16 15:54:13' ,`refund_amount`='84.0' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTk0MjgzMDczNzE2LCJsYXN0X3ZhbHVlIjoiMjAyNC0xMS0wMiAxNjowNDoyNi40ODgzMjgifQ==' ,`store`='SRI'
gid://shopify/Order/5994492657844Exported
INSERT INTO `newsystem_refund_orders` SET `newSystemOrderID`='gid://shopify/Order/5994492657844' ,`newSystemOrderNumber`='SRI#103968' ,`order_created`='2024-11-02 11:00:11' ,`order_completed`='2024-11-02 11:00:08' ,`order_total`='121.98' ,`order_subtotal`='114.0' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='7.98' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1027046736052' ,`refund_date`='2024-12-03 19:06:04' ,`refund_amount`='121.98' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTk0NDkyNjU3ODQ0LCJsYXN0X3ZhbHVlIjoiMjAyNC0xMS0wMiAxODowMDowOC40OTIwMzMifQ==' ,`store`='SRI'
DELETE FROM `newsystem_refund_orders_product` WHERE `newSystemOrderID`='gid://shopify/Order/5994492657844' and `store`='SRI'INSERT INTO `newsystem_refund_orders_product` SET `newSystemOrderID`='gid://shopify/Order/5994492657844' ,`newSystemProductId`='gid://shopify/Product/7166505779380' ,`stockCode`='SRI-InfraStyler-Ver2-TE-X1' ,`refundLineItem`='gid://shopify/LineItem/14572308562100' ,`quantity`='1' ,`unitPrice`='114.0' ,`store`='SRI'