select shopifyCursor from newsystem_refund_orders where orderType='shopify' and store='SRI' order by order_created desc limit 1
gid://shopify/Order/5990562889908Exported
INSERT INTO `newsystem_refund_orders` SET `newSystemOrderID`='gid://shopify/Order/5990562889908' ,`newSystemOrderNumber`='SRI#103613' ,`order_created`='2024-10-31 03:33:39' ,`order_completed`='2024-10-31 03:33:35' ,`order_total`='245.77' ,`order_subtotal`='227.99' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='17.78' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1022445519028' ,`refund_date`='2024-11-25 18:34:37' ,`refund_amount`='245.77' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTkwNTYyODg5OTA4LCJsYXN0X3ZhbHVlIjoiMjAyNC0xMC0zMSAxMDozMzozNS4xMTc4NzQifQ==' ,`store`='SRI'
DELETE FROM `newsystem_refund_orders_product` WHERE `newSystemOrderID`='gid://shopify/Order/5990562889908' and `store`='SRI'INSERT INTO `newsystem_refund_orders_product` SET `newSystemOrderID`='gid://shopify/Order/5990562889908' ,`newSystemProductId`='gid://shopify/Product/7416737136820' ,`stockCode`='SRI-DryQ-Ver2' ,`refundLineItem`='gid://shopify/LineItem/14562965127348' ,`quantity`='1' ,`unitPrice`='227.99' ,`store`='SRI'
gid://shopify/Order/5990718275764Exported
INSERT INTO `newsystem_refund_orders` SET `newSystemOrderID`='gid://shopify/Order/5990718275764' ,`newSystemOrderNumber`='SRI#103631' ,`order_created`='2024-10-31 06:50:17' ,`order_completed`='2024-10-31 06:50:14' ,`order_total`='133.59' ,`order_subtotal`='125.0' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='8.59' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1021171826868' ,`refund_date`='2024-11-22 17:50:50' ,`refund_amount`='133.59' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTkwNzE4Mjc1NzY0LCJsYXN0X3ZhbHVlIjoiMjAyNC0xMC0zMSAxMzo1MDoxNC4yMDY0MjYifQ==' ,`store`='SRI'
DELETE FROM `newsystem_refund_orders_product` WHERE `newSystemOrderID`='gid://shopify/Order/5990718275764' and `store`='SRI'INSERT INTO `newsystem_refund_orders_product` SET `newSystemOrderID`='gid://shopify/Order/5990718275764' ,`newSystemProductId`='gid://shopify/Product/7872421003444' ,`stockCode`='StyleWrapPro-X1' ,`refundLineItem`='gid://shopify/LineItem/14563307290804' ,`quantity`='1' ,`unitPrice`='125.0' ,`store`='SRI'
gid://shopify/Order/5991024754868Exported
INSERT INTO `newsystem_refund_orders` SET `newSystemOrderID`='gid://shopify/Order/5991024754868' ,`newSystemOrderNumber`='SRI#103654' ,`order_created`='2024-10-31 10:38:15' ,`order_completed`='2024-10-31 10:38:12' ,`order_total`='483.34' ,`order_subtotal`='455.98' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='27.36' ,`fullfillment_status`='UNFULFILLED' ,`refund_id`='gid://shopify/Refund/1012950761652' ,`refund_date`='2024-10-31 12:03:06' ,`refund_amount`='483.34' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTkxMDI0NzU0ODY4LCJsYXN0X3ZhbHVlIjoiMjAyNC0xMC0zMSAxNzozODoxMi4yMjE4ODQifQ==' ,`store`='SRI'
DELETE FROM `newsystem_refund_orders_product` WHERE `newSystemOrderID`='gid://shopify/Order/5991024754868' and `store`='SRI'INSERT INTO `newsystem_refund_orders_product` SET `newSystemOrderID`='gid://shopify/Order/5991024754868' ,`newSystemProductId`='gid://shopify/Product/7041246068916' ,`stockCode`='SRI-DryQ-Ver2' ,`refundLineItem`='gid://shopify/LineItem/14564041818292' ,`quantity`='2' ,`unitPrice`='455.98' ,`store`='SRI'