data = [[201648998050,1879414,64,1],[203402966316,1929012,64,1],[214773701053,1980979,64,1],[217253303450,2265078,64,1],[218116184877,2066566,64,1],[222389110985,2172183,64,1],[222677833999,1814547,64,1],[223096148068,2055586,64,1],[223318562650,1791226,64,1],[223834657294,1917062,64,1],[224128040143,1948707,64,1],[224182838285,1997825,64,1],[224263915492,1933394,64,1],[224626803929,2280636,64,1],[226351501858,1913998,64,1],[203317351648,1920680,256,1],[203878602824,1922486,256,1],[203878602824,1898739,256,1],[203907039386,1878553,256,1],[204307502676,1954901,256,1],[204574773554,1938609,256,1],[204751018446,1945332,256,1],[204837395550,1896153,256,1],[204859892126,1930780,256,1],[204859892126,1930779,256,1],[205039340246,1963173,256,1],[205224443512,1975837,256,1],[205280990484,1984331,256,1],[205382493605,1963174,256,1],[205745504659,1962727,256,1],[205834107121,1981430,256,1],[206141612859,2017601,256,1],[206141612859,2036520,256,1],[206980848107,2035254,256,1],[206992968724,2039893,256,1],[207001632719,1953560,256,1],[207672525807,2058852,256,1],[208279784171,2073118,256,1],[209442364919,2066007,256,1],[210029757348,2082453,256,1],[210029757348,2071259,256,1],[210349972734,2073846,256,1],[210429969024,1969123,256,1],[210683488694,2101130,256,1],[210791357647,2100890,256,1],[212000093875,2124708,256,1],[212471904666,1980978,256,1],[212839566674,2089388,256,1],[215244027032,2251645,256,1],[215507693557,2106475,256,1],[216034178344,2082480,256,1],[216147916940,1750699,256,1],[216159645340,2022476,256,1],[216696478122,1848477,256,1],[216705951673,2020554,256,1],[216759799327,2022410,256,1],[217024003497,2045200,256,1],[217135774426,1910786,256,1],[217221190966,1915643,256,1],[217346898460,2051736,256,1],[217758580589,2265064,256,1],[218043061647,2055812,256,1],[218148384866,2035258,256,1],[218163058595,2265083,256,1],[218282807550,1804718,256,1],[218312884575,1774931,256,1],[218403428438,2004772,256,1],[219081264374,2008638,256,1],[219153149788,2091452,256,1],[219881071892,1953125,256,1],[220023532575,2322214,256,1],[220898594071,1905909,256,1],[220990059398,1963354,256,1],[221514455485,1820510,256,1],[221595544698,2005861,256,1],[221731458792,1944970,256,1],[221747353858,2076307,256,1],[221747353858,1920532,256,1],[221747353858,2068566,256,1],[221873638099,1998618,256,1],[221939401655,1945763,256,1],[221940577917,1795142,256,1],[221940577917,2172162,256,1],[222060168413,1974754,256,1],[222060168413,1957830,256,1],[222060168413,2139686,256,1],[222092569677,1930411,256,1],[222100060365,1950186,256,1],[222109166578,1949399,256,1],[222365155523,1854274,256,1],[222367973640,1959269,256,1],[222433310222,1488970,256,1],[222480451376,1716780,256,1],[222480451376,1716789,256,1],[222490066308,1945763,256,1],[222609416658,2039525,256,1],[222626724495,1723564,256,1],[222673547302,2198057,256,1],[222790184895,1998554,256,1],[222791458532,1953248,256,1],[222792172995,2036555,256,1],[222829688186,1974767,256,1],[222894566023,2063209,256,1],[222898824101,1190701,256,1],[222928321903,862460,256,1],[223083124254,2036555,256,1],[223083124254,2055931,256,1],[223126764008,1737905,256,1],[223132622485,1317756,256,1],[223141416927,1819982,256,1],[223150944346,1943196,256,1],[223157594520,1316559,256,1],[223158095162,1959463,256,1],[223172361680,1949620,256,1],[223198083588,1828619,256,1],[223198083588,1660905,256,1],[223243634873,2034964,256,1],[223269244059,1693017,256,1],[223289429127,1930807,256,1],[223316567207,2116353,256,1],[223325826096,1985574,256,1],[223396606427,1677899,256,1],[223435521788,2097537,256,1],[223435521788,2097545,256,1],[223442269371,1998745,256,1],[223442780731,2022104,256,1],[223477757799,2065106,256,1],[223477757799,1953573,256,1],[223495388713,1953654,256,1],[223511336920,1218196,256,1],[223511336920,2269973,256,1],[223511336920,1065442,256,1],[223530197918,2042194,256,1],[223582171514,2051779,256,1],[223590549920,1950284,256,1],[223597098436,1985574,256,1],[223644172667,2080906,256,1],[223663085604,1955133,256,1],[223701766190,2279541,256,1],[223773689961,1984403,256,1],[223833699892,1950288,256,1],[223839952973,2052127,256,1],[223839952973,2004766,256,1],[223845531730,2058069,256,1],[223849260452,1977440,256,1],[223849260452,1977439,256,1],[223849260452,1943156,256,1],[223922629359,2329665,256,1],[223923746554,2279543,256,1],[223923746554,2185899,256,1],[223955080630,1997343,256,1],[223994646320,2103946,256,1],[224011457689,1688479,256,1],[224024717685,2306216,256,1],[224112956155,997053,256,1],[224178753034,1978706,256,1],[224209473387,2136929,256,1],[224222558711,775781,256,1],[224223356083,1949809,256,1],[224286603952,1929993,256,1],[224308577373,2145389,256,1],[224350138395,1955087,256,1],[224396303840,2004772,256,1],[224461266975,2032217,256,1],[224522273671,1977440,256,1],[224528111461,2329675,256,1],[224528111461,2040090,256,1],[224547428904,1923049,256,1],[224556305940,2030717,256,1],[224596772262,2080903,256,1],[224605586009,2265076,256,1],[224620808495,1920461,256,1],[225044602767,2236745,256,1],[225155655223,1357354,256,1],[225155655223,2087282,256,1],[225166288548,2001482,256,1],[225239214747,2048223,256,1],[225246287743,2034550,256,1],[225298505138,2005360,256,1],[225310850329,1960047,256,1],[225313322637,1982461,256,1],[225315473694,1977441,256,1],[225351699168,1282739,256,1],[225395671899,1934943,256,1],[225397447250,862477,256,1],[225423144793,2055812,256,1],[225425357522,2286917,256,1],[225426821989,862485,256,1],[225431420276,2087284,256,1],[225431420276,1974768,256,1],[225465307590,1586998,256,1],[225471331900,2055824,256,1],[225560621597,2032238,256,1],[225596254121,1977450,256,1],[225600160243,1954918,256,1],[225663616195,2051751,256,1],[225693582604,2026614,256,1],[225791327722,2032208,256,1],[225814503001,2034559,256,1],[225817786302,2101099,256,1],[225817786302,2101104,256,1],[225817786302,1878488,256,1],[225824972366,1995047,256,1],[225824972366,2027615,256,1],[225826655991,1937220,256,1],[225826655991,2001510,256,1],[225846904680,2097539,256,1],[225906962802,1970858,256,1],[225927719711,1668175,256,1],[225935128281,2083339,256,1],[225983353270,2091408,256,1],[226075607310,1726948,256,1],[226115672332,1896170,256,1],[226120665620,2263821,256,1],[226164094347,2110071,256,1],[226181205062,2265035,256,1],[226181205062,2265031,256,1],[226251159787,1715905,256,1],[226282956249,2081518,256,1],[226296303202,2093224,256,1],[226334454354,2185650,256,1],[226354366460,2051809,256,1],[226354366460,2265172,256,1],[226354366460,2048422,256,1],[226436592236,1909699,256,1],[224697686837,2236051,256,1],[226545969135,2131860,256,1],[226391490411,1879424,256,1],[225378057372,1660834,256,1],[226902125527,1923362,256,1],[226902125527,1923032,256,1],[226902125527,1922996,256,1],[225422517879,2373774,256,1],[225560835896,1730678,256,1],[216367138475,1848337,256,1],[225976548639,1730295,256,1],[225823004185,1997798,256,1],[226685584070,1990407,256,1],[226873002855,2180708,256,1],[225320766260,1937195,256,1],[225320766260,2022449,256,1],[225320766260,1859623,256,1],[226471853631,2066600,256,1],[226471853631,2066601,256,1],[224377344156,2059719,256,1],[225761131932,1953540,256,1],[225411548503,1990153,256,1],[225411598751,1666600,256,1],[225920734173,2076336,256,1],[215213587126,2251343,256,1],[204136869873,1945129,256,1],[222326979350,1643478,256,1],[225389323054,1888244,256,1],[225455204152,1633438,256,1],[223953026710,2031495,256,1],[225328994360,1709253,256,1],[203439208772,1998744,256,1],[225345004243,2155807,256,1],[211916975639,2121986,256,1],[226128081138,2034464,256,1],[225657302996,1955031,256,1],[225657302996,1955030,256,1],[205506343510,2008762,256,1],[205506343510,2008610,256,1],[222829236597,1774915,256,1],[217885967749,1738378,256,1],[210639757654,2101029,256,1],[223148177195,2083418,256,1],[203775212151,1931681,256,1],[213475323365,1998618,256,1],[223060351429,1754959,256,1],[223909401518,2051711,256,1]]

date.each do |order_number, sku_id, item_status, quantity|
  # there can be multiple items with same sku
  items = Order::OrderItem.where(order_number: order_number, sku_id: sku_id)

  items.each do |item|
    begin
      if item.status == OrderItemStatus.find(:shipped).value && item.status == item_status
        # create return authorization
          Platform::ApiEvent.event.notify_return_requested(order_item_ids: [item.id], order_id: item.order_id)
        # create item reciept

      elsif item.status == OrderItemStatus.find(:return_requested).value && item.status == item_status
        # create item reciept

      end
    rescue => e
      ap "Issue with order #{order_number} and sku #{sku_id}"
    end
  end
end