select shopifyCursor from newsystem_refund_orders where orderType='shopify' and store='SRI' order by order_created desc limit 1
gid://shopify/Order/5958459719860Exported
INSERT INTO `newsystem_refund_orders` SET `newSystemOrderID`='gid://shopify/Order/5958459719860' ,`newSystemOrderNumber`='SRI#102014' ,`order_created`='2024-10-17 15:11:13' ,`order_completed`='2024-10-17 15:11:08' ,`order_total`='131.35' ,`order_subtotal`='122.0' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='9.35' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1018361872564' ,`refund_date`='2024-11-15 17:46:53' ,`refund_amount`='131.35' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTU4NDU5NzE5ODYwLCJsYXN0X3ZhbHVlIjoiMjAyNC0xMC0xNyAyMjoxMTowOC43Nzg2NzcifQ==' ,`store`='SRI'
DELETE FROM `newsystem_refund_orders_product` WHERE `newSystemOrderID`='gid://shopify/Order/5958459719860' and `store`='SRI'INSERT INTO `newsystem_refund_orders_product` SET `newSystemOrderID`='gid://shopify/Order/5958459719860' ,`newSystemProductId`='gid://shopify/Product/7341676429492' ,`stockCode`='SRI-InfraStyler-Ver2-TE-X1' ,`refundLineItem`='gid://shopify/LineItem/14476540182708' ,`quantity`='1' ,`unitPrice`='122.0' ,`store`='SRI'
gid://shopify/Order/5958687162548Exported
INSERT INTO `newsystem_refund_orders` SET `newSystemOrderID`='gid://shopify/Order/5958687162548' ,`newSystemOrderNumber`='SRI#102028' ,`order_created`='2024-10-17 18:09:10' ,`order_completed`='2024-10-17 18:09:05' ,`order_total`='251.36' ,`order_subtotal`='227.99' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='23.37' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1012380729524' ,`refund_date`='2024-10-29 13:13:59' ,`refund_amount`='251.36' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTU4Njg3MTYyNTQ4LCJsYXN0X3ZhbHVlIjoiMjAyNC0xMC0xOCAwMTowOTowNS43NzY4NDUifQ==' ,`store`='SRI'
DELETE FROM `newsystem_refund_orders_product` WHERE `newSystemOrderID`='gid://shopify/Order/5958687162548' and `store`='SRI'INSERT INTO `newsystem_refund_orders_product` SET `newSystemOrderID`='gid://shopify/Order/5958687162548' ,`newSystemProductId`='gid://shopify/Product/7340264521908' ,`stockCode`='SRI-DryQ-Ver2' ,`refundLineItem`='gid://shopify/LineItem/14477112082612' ,`quantity`='1' ,`unitPrice`='227.99' ,`store`='SRI'
gid://shopify/Order/5959150010548Exported
INSERT INTO `newsystem_refund_orders` SET `newSystemOrderID`='gid://shopify/Order/5959150010548' ,`newSystemOrderNumber`='SRI#102052' ,`order_created`='2024-10-18 03:49:25' ,`order_completed`='2024-10-18 03:49:19' ,`order_total`='246.23' ,`order_subtotal`='227.99' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='18.24' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1018348535988' ,`refund_date`='2024-11-15 17:19:53' ,`refund_amount`='246.23' ,`shopifyCursor`='eyJsYXN0X2lkIjo1OTU5MTUwMDEwNTQ4LCJsYXN0X3ZhbHVlIjoiMjAyNC0xMC0xOCAxMDo0OToxOS4wNjUwODMifQ==' ,`store`='SRI'
DELETE FROM `newsystem_refund_orders_product` WHERE `newSystemOrderID`='gid://shopify/Order/5959150010548' and `store`='SRI'INSERT INTO `newsystem_refund_orders_product` SET `newSystemOrderID`='gid://shopify/Order/5959150010548' ,`newSystemProductId`='gid://shopify/Product/7340264521908' ,`stockCode`='SRI-DryQ-Ver2' ,`refundLineItem`='gid://shopify/LineItem/14478085750964' ,`quantity`='1' ,`unitPrice`='227.99' ,`store`='SRI'