select shopifyCursor from newsystem_refund_orders where orderType='shopify' and store='SRI' order by order_created desc limit 1
gid://shopify/Order/6009019105460Exported
INSERT INTO `newsystem_refund_orders` SET `newSystemOrderID`='gid://shopify/Order/6009019105460' ,`newSystemOrderNumber`='SRI#105396' ,`order_created`='2024-11-10 18:39:11' ,`order_completed`='2024-11-10 18:39:04' ,`order_total`='245.8' ,`order_subtotal`='224.99' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='20.81' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1028107993268' ,`refund_date`='2024-12-05 16:47:00' ,`refund_amount`='245.8' ,`shopifyCursor`='eyJsYXN0X2lkIjo2MDA5MDE5MTA1NDYwLCJsYXN0X3ZhbHVlIjoiMjAyNC0xMS0xMSAwMjozOTowNC44OTk1ODEifQ==' ,`store`='SRI'
DELETE FROM `newsystem_refund_orders_product` WHERE `newSystemOrderID`='gid://shopify/Order/6009019105460' and `store`='SRI'INSERT INTO `newsystem_refund_orders_product` SET `newSystemOrderID`='gid://shopify/Order/6009019105460' ,`newSystemProductId`='gid://shopify/Product/7340264521908' ,`stockCode`='SRI-DryQ-Ver2' ,`refundLineItem`='gid://shopify/LineItem/14607868297396' ,`quantity`='1' ,`unitPrice`='224.99' ,`store`='SRI'
gid://shopify/Order/6009040240820Exported
INSERT INTO `newsystem_refund_orders` SET `newSystemOrderID`='gid://shopify/Order/6009040240820' ,`newSystemOrderNumber`='SRI#105399' ,`order_created`='2024-11-10 18:57:46' ,`order_completed`='2024-11-10 18:57:42' ,`order_total`='142.04' ,`order_subtotal`='134.0' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='8.04' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1031339016372' ,`refund_date`='2024-12-11 17:57:33' ,`refund_amount`='142.04' ,`shopifyCursor`='eyJsYXN0X2lkIjo2MDA5MDQwMjQwODIwLCJsYXN0X3ZhbHVlIjoiMjAyNC0xMS0xMSAwMjo1Nzo0Mi4zNDEzNTQifQ==' ,`store`='SRI'
DELETE FROM `newsystem_refund_orders_product` WHERE `newSystemOrderID`='gid://shopify/Order/6009040240820' and `store`='SRI'INSERT INTO `newsystem_refund_orders_product` SET `newSystemOrderID`='gid://shopify/Order/6009040240820' ,`newSystemProductId`='gid://shopify/Product/7418431176884' ,`stockCode`='SRI-SupraCurl-Ver1-X1' ,`refundLineItem`='gid://shopify/LineItem/14607921414324' ,`quantity`='1' ,`unitPrice`='134.0' ,`store`='SRI'
gid://shopify/Order/6009098174644Exported
INSERT INTO `newsystem_refund_orders` SET `newSystemOrderID`='gid://shopify/Order/6009098174644' ,`newSystemOrderNumber`='SRI#105404' ,`order_created`='2024-11-10 19:50:47' ,`order_completed`='2024-11-10 19:50:42' ,`order_total`='242.54' ,`order_subtotal`='224.99' ,`payment_detail_status`='REFUNDED' ,`taxAmount`='17.55' ,`fullfillment_status`='FULFILLED' ,`refund_id`='gid://shopify/Refund/1056802341044' ,`refund_date`='2025-01-31 12:46:07' ,`refund_amount`='242.54' ,`shopifyCursor`='eyJsYXN0X2lkIjo2MDA5MDk4MTc0NjQ0LCJsYXN0X3ZhbHVlIjoiMjAyNC0xMS0xMSAwMzo1MDo0Mi43MTQ1MTEifQ==' ,`store`='SRI'
DELETE FROM `newsystem_refund_orders_product` WHERE `newSystemOrderID`='gid://shopify/Order/6009098174644' and `store`='SRI'INSERT INTO `newsystem_refund_orders_product` SET `newSystemOrderID`='gid://shopify/Order/6009098174644' ,`newSystemProductId`='gid://shopify/Product/7340264521908' ,`stockCode`='SRI-DryQ-Ver2' ,`refundLineItem`='gid://shopify/LineItem/14608065167540' ,`quantity`='1' ,`unitPrice`='224.99' ,`store`='SRI'