convert-nookplaza-text-to-nookexchange-ids.ps1

# $items is all.json ($items = ConvertFrom-Json (Get-Content .\all.json -Raw))
# $mylist is a newline-separated list, the clipboard output of nookplaza lists with the first two lines removed
# this is a mess (besides not actually working
$j = 0
$items = $items | Sort-Object name
$mylist = $mylist | Sort-Object
$mylist | % -Begin{$j=0} {$_ -match "([^,]+),? ?`"?([^`"]*)?`"?,?(.*)?" | Out-null; 
  while($items[$j].name.CompareTo($Matches[1].toLower()) -lt 0) {$j++;}; 
  if ($items[$j].name.CompareTo($Matches[1].toLower()) -eq 0) { 
    $variant = "0"; 
    if ($items[$j].variants -and $Matches[2]) {
      $id = ($items[$j].variants|Sort-Object internalId -Top 1).internalId#default internalId is min
      if ($Matches[2].Contains(",")){$v=($Matches[2]-split",")[0]}else{$v=$Matches[2]}#ignore pattern
      $variantObj=@($items[$j].variants|?{$_.variation-eq$v})
      if ($variantObj[0].variantId) {$variant = $variantObj[0].variantId} else {$id=$variantObj[0].internalId;$variant="0"}
      if ($variant.Contains("_")) {$variant = ($variant -split "_")[0]}
      if ($id) {Write-Host("["+$id+","+$variant+",4],")-NoNewLine}
    } else {
      if ($items[$j].internalId) {
        Write-Host ("["+$items[$j].internalId+",0,4],") -NoNewline
      } elseif ($items[$j].variants) {#some models have internalid on variant for some reason
        $id = ($items[$j].variants|Sort-Object internalId -Top 1).internalId
        Write-Host ("["+$id+",0,4],") -NoNewline
      } else {$items[$j]}
    }
  };
}

generated

[12619,0,4],[3948,3,4],[10933,0,4],[383,3,4],[383,0,4],[3686,0,4],[7554,0,4],[7555,0,4],[7556,0,4],[3821,0,4],[11884,0,4],[846,0,4],[55,0,4],[849,0,4],[3993,4,4],[1317,0,4],[9163,0,4],[1337,0,4],[510,0,4],[13018,0,4],[11866,0,4],[3949,4,4],[3949,0,4],[11689,0,4],[5523,0,4],[3956,2,4],[3956,0,4],[3950,2,4],[3950,0,4],[3954,0,4],[3951,0,4],[3951,1,4],[3953,0,4],[3953,1,4],[3959,0,4],[4134,0,4],[8922,0,4],[8226,0,4],[8225,0,4],[8227,0,4],[9923,0,4],[5806,0,4],[9921,0,4],[8481,0,4],[8480,0,4],[1753,5,4],[1753,0,4],[14532,0,4],[1899,2,4],[1899,0,4],[2740,3,4],[2740,1,4],[2740,0,4],[9167,0,4],[9168,0,4],[2010,1,4],[2010,2,4],[153,0,4],[4093,1,4],[4093,0,4],[590,0,4],[4677,0,4],[330,0,4],[165,0,4],[9860,0,4],[1330,0,4],[4226,2,4],[4226,0,4],[7820,0,4],[1229,0,4],[4030,3,4],[4030,0,4],[9584,1,4],[9584,0,4],[9584,2,4],[9584,3,4],[1341,0,4],[204,0,4],[11996,0,4],[11997,0,4],[9271,0,4],[9273,0,4],[8721,0,4],[4098,0,4],[8560,0,4],[8559,0,4],[8561,0,4],[864,0,4],[331,0,4],[331,1,4],[333,0,4],[12137,0,4],[13822,0,4],[7599,0,4],[8567,0,4],[5722,0,4],[11663,0,4],[1430,0,4],[870,1,4],[171,0,4],[683,2,4],[4597,0,4],[10883,0,4],[1853,0,4],[1852,2,4],[875,0,4],[11283,0,4],[1202,0,4],[3967,2,4],[12485,0,4],[11890,0,4],[8298,1,4],[11024,0,4],[4730,0,4],[11455,0,4],[8279,0,4],[8282,0,4],[4608,0,4],[8731,0,4],[5816,0,4],[8734,0,4],[8733,0,4],[1277,0,4],[11322,0,4],[889,0,4],[13,0,4],[1433,0,4],[4081,4,4],[2562,2,4],[2562,0,4],[7392,3,4],[7392,0,4],[3672,2,4],[3672,0,4],[498,0,4],[498,0,4],[8019,0,4],[8016,0,4],[4122,1,4],[1708,0,4],[7136,1,4],[7136,2,4],[7136,0,4],[896,0,4],[896,1,4],[896,5,4],[5663,0,4],[11807,0,4],[8230,0,4],[4719,4,4],[9244,0,4],[4255,0,4],[9243,0,4],[2012,1,4],[2012,0,4],[2012,2,4],[7264,3,4],[7264,0,4],[1816,3,4],[1816,0,4],[8970,0,4],[4731,0,4],[8969,0,4],[3177,0,4],[4012,0,4],[6030,0,4],[2770,1,4],[9146,0,4],[3538,0,4],[4073,0,4],[717,0,4],[4006,0,4],[9502,1,4],[9502,4,4],[1778,0,4],[3684,0,4],[918,3,4],[918,4,4],[920,0,4],[13830,0,4],[3663,0,4],[8434,0,4],[8743,0,4],[1112,0,4],[1112,2,4],[5736,0,4],[5696,0,4],[9791,0,4],[7446,0,4],[146,5,4],[146,3,4],[9568,3,4],[4009,3,4],[4009,0,4],[9725,0,4],[1783,2,4],[1783,0,4],[931,0,4],[501,0,4],[4412,2,4],[6044,0,4],[11256,0,4],[5643,0,4],[11254,0,4],[11255,0,4],[9452,0,4],[9454,0,4],[9453,0,4],[9451,0,4],[4576,0,4],[1161,0,4],[1161,1,4],[8940,0,4],[4408,0,4],[10124,0,4],[10123,0,4],[915,0,4],[915,3,4],[4491,0,4],[5810,0,4],[3624,3,4],[3624,1,4],[3999,0,4],[5803,0,4],[3998,0,4],[4000,0,4],[4000,2,4],[4001,0,4],[3996,4,4],[3996,0,4],[3618,0,4],[9391,0,4],[1829,4,4],[1829,2,4],[5317,0,4],[7618,0,4],[7619,0,4],[7617,0,4],[937,0,4],[390,0,4],[3784,0,4],[3784,1,4],[3783,3,4],[11440,0,4],[11437,0,4],[9782,0,4],[11441,0,4],[4187,0,4],[9011,0,4],[11430,0,4],[4611,0,4],[1868,5,4],[1868,0,4],[3590,3,4],[3590,1,4],[4137,4,4],[4138,4,4],[4139,2,4],[4142,3,4],[4441,3,4],[4144,3,4],[4143,3,4],[4143,0,4],[4141,6,4],[1798,0,4],[13251,3,4],[13251,1,4],[13251,0,4],[2020,3,4],[2020,1,4],[2020,0,4],[2020,2,4],[3400,1,4],[3400,0,4],[10747,0,4],[10745,0,4],[4451,0,4],[462,0,4],[11025,0,4],[11026,0,4],[13252,2,4],[13252,6,4],[1495,2,4],[1495,4,4],[1495,0,4],[1495,5,4],[12181,0,4],[2554,3,4],[2554,6,4],[2554,5,4],[4109,0,4],[4133,0,4],[2823,0,4],[1802,5,4],[2319,0,4],[1803,6,4],[7789,0,4],[674,0,4],[12439,0,4],[675,0,4],[950,3,4],[692,0,4],[12446,0,4],[5614,0,4],[7654,1,4],[4071,1,4],[4071,0,4],[10891,0,4],[10890,0,4],[86,0,4],[9540,0,4],[8111,0,4],[3269,0,4],[11987,0,4],[9909,0,4],[9907,0,4],[8738,0,4],[954,0,4],[4110,1,4],[10035,0,4],[10038,0,4],[9581,0,4],[9684,0,4],[1598,3,4],[1598,0,4],[287,2,4],[955,0,4],[955,2,4],[12069,0,4],[7171,0,4],[11155,0,4],[1288,0,4],[1288,5,4],[1288,1,4],[2772,0,4],[8238,0,4],[11549,0,4],[11550,0,4],[9224,0,4],[9225,0,4],[9222,0,4],[4101,3,4],[4101,2,4],[4101,0,4],[11045,0,4],[11048,0,4],[3135,0,4],[13357,0,4],[9525,0,4],[742,0,4],[742,3,4],[14142,0,4],[12486,0,4],[3581,2,4],[3583,2,4],[3583,0,4],[3225,0,4],[10843,0,4],[1243,1,4],[1243,2,4],[4359,0,4],[8565,0,4],[8564,0,4],[14266,0,4],[4094,1,4],[4094,2,4],[2561,0,4],[7135,2,4],[3622,1,4],[7260,4,4],[7260,0,4],[8756,0,4],[50,0,4],[9920,0,4],[1177,0,4],[1177,1,4],[4381,0,4],[12063,0,4],[4099,0,4],[4099,1,4],[4372,0,4],[3961,1,4],[3961,0,4],[464,0,4],[464,0,4],[12484,0,4],[599,0,4],[6034,0,4],[10244,3,4],[10244,0,4],[4135,2,4],[4135,0,4],[7838,0,4],[8590,0,4],[8591,0,4],[4403,0,4],[11590,0,4],[8789,0,4],[8938,0,4],[8935,0,4],[10191,0,4],[10194,0,4],[8508,0,4],[8138,0,4],[11846,0,4],[4104,0,4],[4104,2,4],[8515,0,4],[9767,0,4],[9767,4,4],[2555,0,4],[2556,0,4],[1631,1,4],[1631,0,4],[1624,3,4],[1628,0,4],[729,0,4],[4649,0,4],[3251,0,4],[3251,1,4],[7280,3,4],[7280,0,4],[12053,0,4],[9861,0,4],[8401,0,4],[4230,3,4],[4230,0,4],[4282,0,4],[1411,1,4],[1411,0,4],[12624,0,4],[4454,0,4],[3472,0,4],[11897,0,4],[11901,0,4],[11898,0,4],[5,0,4],[8681,0,4],[3140,0,4],[1875,2,4],[582,0,4],[582,0,4],[11099,0,4],[12136,0,4],[11958,0,4],[1620,0,4],[1348,1,4],[1348,3,4],[5196,0,4],[7229,1,4],[7229,0,4],[3960,0,4],[7282,2,4],[987,2,4],[167,0,4],[11894,0,4],[11896,0,4],[5322,0,4],[12165,0,4],[8512,0,4],[10230,0,4],[10252,0,4],[8189,0,4],[4254,0,4],[793,0,4],[10045,0,4],[5176,0,4],[9664,0,4],[3968,0,4],[13376,0,4],[13373,0,4],[4113,0,4],[5287,0,4],[1892,0,4],[5564,0,4],[690,3,4],[9038,0,4],[1836,1,4],[1836,7,4],[5464,0,4],[3973,3,4],[3973,0,4],[3972,3,4],[3972,0,4],[3970,3,4],[3970,2,4],[7797,0,4],[8415,2,4],[7796,0,4],[3974,0,4],[3971,3,4],[3971,2,4],[3971,0,4],[13412,0,4],[997,4,4],[997,0,4],[12535,0,4],[400,0,4],[3399,0,4],[64,0,4],[1627,0,4],[5931,0,4],[1456,0,4],[791,0,4],[724,0,4],[13249,6,4],[13249,0,4],[10965,0,4],[7803,0,4],[7804,1,4],[7581,0,4],[4016,0,4],[8911,0,4],[8933,0,4],[5173,0,4],[11259,0,4],[8680,0,4],[1432,3,4],[1621,4,4],[338,3,4],[4168,0,4],[12451,0,4],[12441,0,4],[12457,0,4],[2013,0,4],[2014,1,4],[2014,0,4],[9866,0,4],[7148,0,4],[3471,1,4],[2335,4,4],[4265,0,4],[3621,0,4],[112,0,4],[113,0,4],[412,0,4],[116,0,4],[4080,4,4],[11144,0,4],[4555,0,4],[8504,0,4],[11447,0,4],[8705,0,4],[8703,0,4],[11644,0,4],[11647,0,4],[8954,0,4],[1029,2,4],[1029,1,4],[3492,0,4],[8686,0,4],[8688,0,4],[8687,0,4],[4392,1,4],[4392,0,4],[8693,0,4],[4118,2,4],[4118,0,4],[3138,0,4],[144,4,4],[144,0,4],[11098,0,4],[4121,0,4],[5471,0,4],[10162,0,4],[10165,0,4],[12033,0,4],[8431,0,4],[1866,0,4],[5128,0,4],[7262,0,4],[1042,2,4],[9503,0,4],[1319,2,4],[1319,0,4],[1043,1,4],[1043,3,4],[1043,2,4],[1043,0,4],[8981,0,4],[4292,0,4],[7450,0,4],[3231,0,4],[7451,0,4],[13250,0,4],[9766,0,4],[4123,0,4],[9069,0,4],[1050,5,4],[1050,0,4],[698,0,4],[9565,0,4],[9565,3,4],[5807,0,4],[832,0,4],[4722,1,4],[4129,4,4],[4129,2,4],[52,0,4],[109,0,4],[2614,0,4],[11127,0,4],[11128,0,4],[31,0,4],[1870,3,4],[1870,0,4],[8056,0,4],[805,0,4],[805,2,4],[648,0,4],[1058,0,4],[8689,0,4],[3573,0,4],[12332,0,4],[48,0,4],[5261,0,4],[9213,0,4],[11870,0,4],[10007,0,4],[7425,0,4],[7420,0,4],[4398,0,4],[9250,0,4],[9251,0,4],[9252,0,4],[9254,0,4],[9248,0,4],[9253,0,4],[3350,0,4],[7790,0,4],[7284,1,4],[1567,3,4],[3654,0,4],[3819,0,4],[1127,2,4],[4111,0,4],[4111,2,4],[8523,0,4],[7061,0,4],[5399,0,4],[11055,0,4],[11054,0,4],[1131,0,4],[1111,0,4],[3947,3,4],[3947,4,4],[3947,0,4],[7526,0,4],[3946,1,4],[3946,3,4],[3946,2,4],[3946,4,4],[3946,0,4],[4154,0,4],[688,1,4],[12021,0,4],[3965,1,4],[4023,0,4],[725,1,4],[725,2,4],[689,0,4],[5147,0,4],[11513,0,4],[11515,0,4],[2352,0,4],[4077,2,4],[4077,4,4],[4490,0,4],[6046,0,4],[9674,0,4],[4247,0,4],[7257,0,4],[7802,2,4],[7801,0,4],[3577,0,4],[1185,4,4],[3681,4,4],[1082,5,4],[1082,0,4],[11614,0,4],[11613,0,4],[8119,0,4],[592,0,4],[6820,0,4],[13823,0,4],[12574,0,4],[1268,0,4],[12084,0,4],[8844,0,4],[4105,0,4],[1881,4,4],[1881,0,4],[3348,0,4],[3348,3,4],[11679,0,4],[11680,0,4],[10202,0,4],[5420,0,4],[10208,0,4],[6040,0,4],[8925,0,4],[5733,0,4],[11341,0,4],[10046,0,4],[8543,0,4],[7861,0,4],[7858,0,4],[513,0,4],[4102,1,4],[4102,0,4],[13246,2,4],[13246,1,4],[13246,0,4],[3282,3,4],[3282,5,4],[3282,0,4],[1092,0,4],[3697,4,4],[4338,2,4],[4338,3,4],[4452,0,4],[928,1,4],[928,0,4],[3785,0,4],[4671,0,4],[3822,0,4],[9080,0,4],[7845,1,4],[4013,0,4],[4485,0,4],[13243,0,4],[13243,4,4],[13243,7,4],[7183,0,4],[8330,0,4],[9574,0,4],[7394,0,4],[4053,0,4],[4053,2,4],[4052,0,4],[4046,5,4],[4046,0,4],[4054,4,4],[4047,5,4],[4050,0,4],[4048,0,4],[4049,0,4],[12326,0,4],[504,0,4],[12138,0,4],[2713,4,4],[4140,0,4],[4140,3,4],[4028,0,4],[4456,0,4],[1125,0,4],[2610,0,4],[1888,3,4],[1888,0,4],[11185,0,4],[1644,7,4],[1644,0,4],[1851,0,4],[57,0,4],[4029,0,4],[4607,0,4],[11220,0,4],[10059,0,4],[10067,0,4],[8684,0,4],[8685,0,4],[5645,0,4],[11975,0,4],[7568,0,4],[1117,0,4],[9149,0,4],[2599,0,4],[3689,0,4],[65,0,4],[2,0,4],[11869,0,4],[1328,2,4],[4365,0,4],[5873,0,4],[11402,0,4],[11400,0,4],[9218,0,4],[23,0,4],[1126,0,4],[1606,0,4],[13930,1,4],[1128,6,4],[3443,2,4],[667,1,4],[3980,3,4],[4015,2,4],[4017,3,4],[4017,0,4],[12572,0,4],[9127,0,4],[1045,0,4],[1845,2,4],[1845,0,4],[5338,5,4],[7975,0,4],[9006,0,4],[6026,0,4],[9005,0,4],[9088,0,4],[9083,0,4],[1326,0,4],[11483,0,4],[5327,0,4],[4738,0,4],[4738,1,4],[12453,0,4],[12443,0,4],[687,0,4],[3310,0,4],[11282,0,4],[1434,0,4],[5132,0,4],[8953,0,4],[8951,0,4],[6885,0,4],[6889,0,4],[6884,0,4],[10082,0,4],[5566,0,4],[971,2,4],[11497,0,4],[11495,0,4],[1145,0,4],[3416,3,4],[3416,1,4],[5138,0,4],[3619,6,4],[5760,0,4],[4418,0,4],[8388,0,4],[8702,0,4],[5203,0,4],[1153,0,4],[4083,0,4],[732,0,4],[4087,0,4],[4089,0,4],[734,0,4],[4092,3,4],[4092,0,4],[4084,0,4],[12949,0,4],[13223,0,4],[207,0,4],[207,0,4],[11528,0,4],[8132,0,4],[2775,0,4],[546,0,4],[6053,0,4],[3617,2,4],[3617,0,4],[4019,5,4],[4019,2,4],[1217,0,4],[5825,0,4],[4685,0,4],[2593,0,4],[4652,0,4],[9658,0,4],[3095,0,4],[9657,0,4],[9655,0,4],[9656,0,4],[652,0,4],[652,0,4],[3398,0,4],[11943,0,4],[11943,1,4],[677,0,4],[676,0,4],[678,0,4],[10145,0,4],[10147,0,4],[7488,0,4],[4070,2,4],[3816,3,4],[9777,0,4],[9781,0,4],[4744,0,4],[4147,0,4],[6902,0,4],[5199,0,4],[7765,0,4],[9937,0,4],[11823,0,4],[7189,4,4],[7189,0,4],[7190,3,4],[7190,0,4],[3702,2,4],[3702,0,4],[3701,0,4],[3701,3,4],[3584,3,4],[3584,1,4],[3442,1,4],[3442,4,4],[132,0,4],[6904,0,4],[7868,5,4],[3268,0,4],[3328,0,4],[3489,0,4],[8117,0,4],[7976,0,4],[7979,0,4],[3696,0,4],[9033,0,4],[9034,0,4],[59,0,4],[1171,4,4],[3616,3,4],[4068,3,4],[4440,0,4],[8275,0,4],[2776,1,4],[2776,0,4],[787,1,4],[787,0,4],[704,0,4],[7391,0,4],[3467,1,4],[3467,0,4],[3467,2,4],[1186,0,4],[8782,0,4],[1181,0,4],[10767,0,4],[10929,0,4],[5134,0,4],[5337,0,4],[4762,0,4],[4763,0,4],[4754,0,4],[4754,2,4],[4758,1,4],[4758,0,4],[4759,4,4],[4761,0,4],[4756,0,4],[4753,0,4],[8750,0,4],[8719,0,4],[2592,0,4],[13247,3,4],[13247,4,4],[278,0,4],[278,0,4],[2329,0,4],[4114,0,4],[4114,1,4],[4072,1,4],[4072,0,4],[7528,0,4],[7528,2,4],[7525,0,4],[8455,0,4],[4574,0,4],[8457,0,4],[5129,0,4],[3078,3,4],[3623,2,4],[3623,0,4],[3334,0,4],[411,0,4],[4033,1,4],[4033,0,4],[85,0,4],[85,3,4],[7499,0,4],[533,3,4],[533,0,4],[11237,0,4],[1199,4,4],[1199,2,4],[1199,0,4],[7231,0,4],[5670,0,4],[6983,0,4],[5434,0,4],[3388,0,4],[8271,0,4],[9769,0,4],[4428,0,4],[3706,0,4],[4524,0,4],[8502,0,4],[1211,0,4],[1211,2,4],[1211,5,4],[10011,0,4],[10010,0,4],[4025,4,4],[4025,0,4],[833,5,4],[1081,0,4],[9619,0,4],[4026,0,4],[907,2,4],[4395,0,4],[8465,0,4],[11951,0,4],[10118,0,4],[5609,0,4],[11179,0,4],[4563,0,4],[10997,0,4],[5775,0,4],[1744,0,4],[5165,0,4],[8417,2,4],[5927,0,4],[11100,0,4],[1232,1,4],[1232,0,4],[2326,0,4],[10276,0,4],[689,0,4],[688,0,4],[12460,0,4],[6909,0,4],[12402,0,4],[12401,0,4],[12403,0,4],[12408,0,4],[12405,0,4],[12407,0,4],[12411,0,4],[12404,0,4],[12409,0,4],[12406,0,4],[12410,0,4],[1452,0,4],[3463,0,4],[8479,0,4],[3245,0,4],[8477,0,4],[8478,0,4],[3446,0,4],[1840,1,4],[4116,0,4],[4116,5,4],[10886,0,4],[5297,0,4],[7379,0,4],[5809,0,4],[11476,0,4],[11471,0,4],[5655,0,4],[11462,0,4],[27,0,4],[4117,0,4],[683,0,4],[682,0,4],[684,0,4],[15,0,4],[4124,1,4],[492,0,4],[492,0,4],[18,0,4],[8826,0,4],[172,0,4],[172,0,4],[172,0,4],[62,0,4],[62,0,4],[2558,0,4],[3205,0,4],[3205,3,4],[1565,0,4],[38,0,4],[12741,0,4],[11429,0,4],[3313,0,4],[4270,0,4],[4132,0,4],[11575,0,4],[7836,0,4],[10969,0,4]

new.ps1

# $items is all.json ($items = ConvertFrom-Json (Get-Content .\all.json -Raw))
# $mylist is a newline-separated list, the clipboard output of nookplaza lists with the first two lines removed
# this is a mess (besides not actually working
$nookexchange_filters = @("housewares", "misc", "wall_mounted", "walls", "floors", "rugs", "other", "fencing", "tops", "bottoms", "dresses", "hats", "accs", "socks", "shoes", "bags", "umbrellas", "wetsuits", "fossils", "art", "photos", "posters", "music", "tools", "diy")
$filter = $true
$items = ConvertFrom-Json (Get-Content .\all.json -Raw)
$items = $items | Sort-Object name
$mylist | % -Begin{$j=0} {
  # ex. Wedding welcome board, "Cute, Message"
  $_ -match "(?<itemname>[^,]+)(?:, `"?(?<variant>[^`",]+)(?:, (?<pattern>[^`"]+))?`")?" | Out-null
  # advance the item db index until we get to this item
  while($items[$j].name -lt $Matches.itemname.toLower()) {$j++}
  # time to pattern match against the item entry
  $i = $items[$j]
case 1: all.json[374] "outdoor bench" 
              patternCustomize: true 
              variants: nonempty
              handling: search matching (variation, pattern) and use variant=variant index; id=variant.internalId
case 2: all.json[417] "pull-up-bar stand"
              patternCustomize: false
              variants: nonempty
              handling: search matching (variation) and use variant=variant index; id=variant.internalId
case 3: all.json[2829] "DAL tee"
              patternCustomize: field no existe
              variants: nonempty (length=1)
              handling: id=variants[0].internalId, variant=0
case 4: all.json[3947] "slip-on loafers"
              patternCustomize: field no existe
              variants: nonempty (length>1)
              handling: search matching (variation), id=MINIMUM VARIANT INTERNAL ID!!!, variant=variant index
  $id = 0
  $variant = 0
  if ("variants" -notin  $i.PSObject.Properties.Name) {
    # simple (special?) objects
    $id = $i.internalId; $variant = 0
  } elseif ("patternCustomize" -notin  $i.PSObject.Properties.Name) {
    # clothing etc.; use minimum variant internal id
    $id = ($i.variants | Sort-Object internalId -Top 1).internalId
    if (($i.variants.length -gt 1) -and ("variant" -in  $Matches.PSObject.Properties.Name)) {
      
    }
  }
$j = 0
$items = $items | Sort-Object name
$mylist = $mylist | Sort-Object
$mylist | % -Begin{$j=0} {$_ -match "([^,]+),? ?`"?([^`"]*)?`"?,?(.*)?" | Out-null; 
  while($items[$j].name.CompareTo($Matches[1].toLower()) -lt 0) {$j++;}; 
  if ($items[$j].name.CompareTo($Matches[1].toLower()) -eq 0) { 
    $variant = "0"; 
    if ($items[$j].variants -and $Matches[2]) {
      $id = ($items[$j].variants|Sort-Object internalId -Top 1).internalId#default internalId is min
      if ($Matches[2].Contains(",")){$v=($Matches[2]-split",")[0]}else{$v=$Matches[2]}#ignore pattern
      $variantObj=@($items[$j].variants|?{$_.variation-eq$v})
      if ($variantObj[0].variantId) {$variant = $variantObj[0].variantId} else {$id=$variantObj[0].internalId;$variant="0"}
      if ($variant.Contains("_")) {$variant = ($variant -split "_")[0]}
      if ($id) {Write-Host("["+$id+","+$variant+",4],")-NoNewLine}
    } else {
      if ($items[$j].internalId) {
        Write-Host ("["+$items[$j].internalId+",0,4],") -NoNewline
      } elseif ($items[$j].variants) {#some models have internalid on variant for some reason
        $id = ($items[$j].variants|Sort-Object internalId -Top 1).internalId
        Write-Host ("["+$id+",0,4],") -NoNewline
      } else {$items[$j]}
    }
  };
}

successful manual input

[13821,0,4],[13828,0,4],[4463,0,4],[12619,0,4],[3948,0,4],[12579,0,4],[5315,1,4],[383,0,4],[3686,0,4],[4366,1,4],[4366,2,4],[4366,3,4],[3821,0,4],[5295,1,4],[846,0,4],[56,0,4],[849,0,4],[3993,4,4],[1317,0,4],[5519,2,4],[1337,0,4],[7867,0,4],[13018,0,4],[3949,0,4],[3949,4,4],[5523,0,4],[5523,1,4],[3956,0,4],[3956,2,4],[3950,0,4],[3950,2,4],[3954,0,4],[3951,0,4],[3951,1,4],[3953,0,4],[3953,1,4],[3959,0,4],[4134,0,4],[3228,7,4],[5710,2,4],[8226,0,4],[8225,0,4],[8227,0,4],[5806,0,4],[5806,1,4],[5806,3,4],[3262,1,4],[3262,2,4],[1753,0,4],[14532,0,4],[1899,4,4],[2740,0,4],[2740,1,4],[2740,3,4],[1501,0,4],[9698,0,4],[5818,2,4],[5818,3,4],[2010,1,4],[2010,2,4],[3554,0,4],[4093,0,4],[10742,0,4],[4677,0,4],[330,0,4],[1266,0,4],[9860,0,4],[1330,0,4],[4226,0,4],[4226,2,4],[3165,4,4],[1229,0,4],[4030,0,4],[4030,3,4],[9584,0,4],[9584,1,4],[9584,2,4],[9584,3,4],[1341,0,4],[3406,0,4],[10906,2,4],[10906,3,4],[4364,2,4],[4364,4,4],[4545,1,4],[4098,0,4],[3198,1,4],[3198,2,4],[3198,3,4],[864,0,4],[331,0,4],[333,0,4],[12137,0,4],[13822,0,4],[7599,0,4],[4401,2,4],[5722,0,4],[5722,1,4],[1430,0,4],[3582,0,4],[3582,1,4],[870,1,4],[682,0,4],[683,0,4],[4597,0,4],[5296,2,4],[1853,0,4],[1853,2,4],[1852,2,4],[875,0,4],[11283,0,4],[1202,0,4],[7037,0,4],[7098,0,4],[3967,2,4],[12485,0,4],[5693,3,4],[8298,5,4],[12398,0,4],[12447,0,4],[12438,0,4],[12414,0,4],[14009,0,4],[12445,0,4],[12421,0,4],[14007,0,4],[12417,0,4],[12413,0,4],[12419,0,4],[14008,0,4],[12415,0,4],[12436,0,4],[14005,0,4],[14006,0,4],[12420,0,4],[12418,0,4],[12437,0,4],[12517,0,4],[4600,2,4],[4730,0,4],[4730,1,4],[4363,1,4],[4363,4,4],[4608,0,4],[5816,0,4],[5816,1,4],[5816,3,4],[5816,4,4],[1277,0,4],[4434,1,4],[889,0,4],[1429,0,4],[1433,0,4],[4081,4,4],[2562,0,4],[2562,2,4],[7392,0,4],[7392,3,4],[3672,0,4],[3672,2,4],[7163,0,4],[3578,2,4],[3578,5,4],[4122,3,4],[1708,0,4],[7136,0,4],[7136,1,4],[7136,2,4],[896,0,4],[896,1,4],[896,5,4],[5663,0,4],[5663,1,4],[3233,2,4],[4719,4,4],[4255,0,4],[4255,2,4],[4255,3,4],[2012,0,4],[2012,1,4],[2012,2,4],[7264,0,4],[7264,1,4],[1816,0,4],[1816,24,4],[4731,0,4],[4731,2,4],[4731,3,4],[3177,0,4],[6030,0,4],[4012,0,4],[2770,1,4],[3538,0,4],[3538,2,4],[4073,0,4],[717,0,4],[4006,0,4],[9502,1,4],[9502,4,4],[3229,0,4],[1778,0,4],[3684,0,4],[918,3,4],[918,4,4],[920,0,4],[13830,0,4],[3663,0,4],[3663,2,4],[5665,1,4],[1112,0,4],[1112,2,4],[5736,0,4],[5696,0,4],[5170,2,4],[3464,2,4],[146,3,4],[146,5,4],[9568,3,4],[4009,0,4],[4009,3,4],[4602,1,4],[1783,0,4],[1783,6,4],[931,0,4],[7230,0,4],[4412,2,4],[6044,0,4],[5643,0,4],[5643,1,4],[5643,2,4],[5643,3,4],[5643,4,4],[4576,0,4],[4576,1,4],[4576,2,4],[4576,3,4],[4576,4,4],[1161,0,4],[1161,1,4],[5202,2,4],[4408,0,4],[4725,3,4],[4725,4,4],[915,0,4],[915,3,4],[4491,0,4],[1792,0,4],[5810,0,4],[3624,1,4],[3624,3,4],[3999,0,4],[3995,2,4],[3995,4,4],[5803,0,4],[3998,0,4],[4000,0,4],[4000,2,4],[4001,0,4],[3996,0,4],[3996,4,4],[3618,0,4],[3258,6,4],[1829,0,4],[1829,4,4],[12128,0,4],[12130,0,4],[12125,0,4],[685,0,4],[5317,0,4],[5317,1,4],[5317,2,4],[5317,3,4],[937,0,4],[1797,0,4],[3784,0,4],[3784,1,4],[3783,3,4],[4274,1,4],[4274,4,4],[4745,1,4],[4326,1,4],[2403,2,4],[2403,4,4],[4246,1,4],[4611,0,4],[1868,0,4],[1868,5,4],[3590,7,4],[3590,21,4],[4137,4,4],[4138,4,4],[4139,2,4],[4142,3,4],[4441,3,4],[4144,9,4],[4143,0,4],[4143,3,4],[4141,6,4],[1798,0,4],[13251,0,4],[13251,1,4],[13251,3,4],[2020,0,4],[2020,3,4],[2020,9,4],[3400,0,4],[3400,1,4],[941,8,4],[5145,2,4],[5145,4,4],[4451,0,4],[1750,0,4],[5244,1,4],[5244,2,4],[13252,2,4],[13252,6,4],[1495,0,4],[1495,1,1],[1495,2,4],[1495,3,1],[1495,4,4],[1495,5,4],[12174,3,4],[4109,0,4],[4133,0,4],[2554,3,4],[2554,5,4],[2554,6,4],[2823,0,4],[1802,20,4],[2319,0,4],[1803,36,4],[7789,0,4],[12449,0,4],[12439,0,4],[12455,0,4],[950,24,4],[12448,0,4],[12446,0,4],[5614,0,4],[7654,1,4],[4071,0,4],[4071,1,4],[5351,3,4],[5351,4,4],[86,0,4],[5459,2,4],[3269,0,4],[3269,3,4],[5204,1,4],[5204,3,4],[4548,1,4],[9847,1,4],[954,0,4],[4110,1,4],[9645,2,4],[9645,5,4],[9581,0,4],[9581,3,4],[1598,0,4],[1598,3,4],[287,2,4],[955,0,4],[955,2,4],[9841,2,4],[7171,0,4],[4425,2,4],[3820,1,4],[1288,0,4],[1288,1,4],[1288,5,4],[2772,0,4],[3435,1,4],[4721,3,4],[4721,4,4],[3222,1,4],[3222,3,4],[3222,4,4],[4101,0,4],[4101,8,4],[4101,12,4],[5301,1,4],[5301,4,4],[13772,0,4],[13776,0,4],[13774,0,4],[13778,0,4],[13767,0,4],[13777,0,4],[13770,0,4],[13775,0,4],[3135,0,4],[13357,0,4],[5404,4,4],[13826,0,4],[742,0,4],[14142,0,4],[3581,0,4],[12486,0,4],[3583,0,4],[3583,2,4],[3225,0,4],[1243,1,4],[1243,2,4],[8611,2,4],[4359,0,4],[4207,0,4],[4207,2,4],[4094,1,4],[4094,2,4],[14266,0,4],[7135,2,4],[3622,4,4],[7260,0,4],[7260,4,4],[5925,2,4],[5804,4,4],[50,0,4],[1177,0,4],[1177,1,4],[4381,0,4],[9844,5,4],[4099,0,4],[4099,1,4],[4372,0,4],[3961,0,4],[3961,1,4],[5719,0,4],[12484,0,4],[8031,0,4],[6034,0,4],[10244,0,4],[10244,3,4],[4135,0,4],[4135,2,4],[7838,0,4],[4403,0,4],[4403,1,4],[4403,2,4],[5172,1,4],[4410,5,4],[5174,1,4],[5174,5,4],[4307,1,4],[4307,4,4],[4567,3,4],[4344,1,4],[5299,1,4],[4104,0,4],[4212,1,4],[9767,0,4],[9767,4,4],[2555,0,4],[2556,0,4],[1631,0,4],[1631,1,4],[1624,3,4],[1628,0,4],[729,0,4],[4649,0,4],[3251,0,4],[3251,1,4],[7280,0,4],[7280,3,4],[9861,0,4],[9861,2,4],[3676,2,4],[4282,0,4],[4230,0,4],[4230,3,4],[1411,0,4],[1411,1,4],[12624,0,4],[13824,0,4],[4454,0,4],[7035,0,4],[3472,0,4],[5683,1,4],[5683,2,4],[5683,3,4],[6,0,4],[3140,0,4],[3140,1,4],[1875,2,4],[530,0,4],[11099,0,4],[12136,0,4],[9832,2,4],[1620,0,4],[1348,1,4],[1348,3,4],[5196,0,4],[7229,0,4],[7229,1,4],[3960,0,4],[7282,10,4],[987,2,4],[3675,0,4],[6093,1,4],[6093,3,4],[5322,0,4],[9855,1,4],[3694,2,4],[5435,1,4],[7040,0,4],[5659,1,4],[8189,0,4],[4254,0,4],[793,0,4],[2572,7,4],[5182,0,4],[5176,0,4],[5176,1,4],[3968,0,4],[13029,2,4],[13029,5,4],[4113,0,4],[5287,0,4],[1892,0,4],[5564,0,4],[690,0,4],[4792,3,4],[1836,1,4],[1836,7,4],[5464,0,4],[3973,0,4],[3973,3,4],[3972,0,4],[3972,3,4],[3970,2,4],[3970,3,4],[7797,0,4],[8415,2,4],[7796,0,4],[3974,0,4],[3971,0,4],[3971,2,4],[3971,3,4],[13015,5,4],[997,0,4],[997,4,4],[12535,0,4],[4107,0,4],[3399,0,4],[1626,0,4],[1627,0,4],[1838,0,4],[3943,0,4],[13353,0,4],[5931,0,4],[1456,0,4],[2596,0,4],[791,0,4],[724,0,4],[13249,0,4],[13249,6,4],[12256,0,4],[3704,4,4],[7682,0,4],[7803,0,4],[7804,1,4],[4519,1,4],[4016,0,4],[9876,4,4],[9887,4,4],[4517,1,4],[5173,0,4],[5173,3,4],[5667,3,4],[3070,2,4],[1432,3,4],[13831,0,4],[1621,4,4],[338,3,4],[2670,0,4],[2704,2,4],[7788,0,4],[12451,0,4],[12441,0,4],[12457,0,4],[2013,0,4],[2014,0,4],[2014,1,4],[9866,0,4],[7148,0,4],[3471,1,4],[2335,4,4],[4265,0,4],[3621,0,4],[4042,0,4],[4035,0,4],[5973,0,4],[4038,0,4],[4080,4,4],[4257,4,4],[4555,0,4],[4555,1,4],[5708,3,4],[4222,1,4],[4222,3,4],[6016,3,4],[6016,6,4],[7681,0,4],[4396,1,4],[1029,5,4],[1029,10,4],[13221,0,4],[3586,0,4],[3492,0,4],[3492,1,4],[3492,2,4],[3492,3,4],[4392,0,4],[4392,1,4],[4332,2,4],[4118,0,4],[4118,2,4],[3138,0,4],[1500,0,4],[1500,12,4],[9699,0,4],[144,0,4],[11098,0,4],[4121,0,4],[5471,0,4],[5471,1,4],[5471,4,4],[10914,1,4],[4717,2,4],[1866,0,4],[5128,0,4],[7262,0,4],[1042,2,4],[9503,0,4],[1319,0,4],[1319,2,4],[1043,0,4],[1043,1,4],[1043,2,4],[1043,3,4],[4292,0,4],[4292,1,4],[3231,0,4],[3231,1,4],[3231,2,4],[3231,3,4],[4123,0,4],[13250,0,4],[3122,0,4],[9766,0,4],[5168,6,4],[1050,0,4],[1050,5,4],[698,0,4],[9565,0,4],[9565,3,4],[5807,0,4],[7139,0,4],[7144,0,4],[7145,0,4],[8762,2,4],[8762,3,4],[8763,2,4],[7146,0,4],[7510,2,4],[7141,0,4],[7138,0,4],[7140,0,4],[4722,1,4],[4129,2,4],[4129,4,4],[52,0,4],[109,0,4],[2614,0,4],[11127,0,4],[11128,0,4],[32,0,4],[335,1,4],[336,0,4],[1870,0,4],[1870,18,4],[4267,5,4],[805,0,4],[7174,0,4],[1058,0,4],[3573,0,4],[3573,1,4],[12332,0,4],[7152,0,4],[4799,1,4],[8464,0,4],[48,0,4],[5261,0,4],[3460,7,4],[5364,1,4],[12543,0,4],[4741,5,4],[3171,2,4],[3171,7,4],[4398,2,4],[9654,0,4],[9761,0,4],[3350,0,4],[3350,1,4],[7284,0,4],[1567,3,4],[3819,0,4],[3654,0,4],[4111,0,4],[4111,2,4],[1127,2,4],[4715,3,4],[7061,0,4],[5399,0,4],[5399,2,4],[5399,3,4],[1131,0,4],[1111,0,4],[3947,0,4],[3947,21,4],[3947,28,4],[7526,0,4],[3946,0,4],[3946,28,4],[4154,0,4],[688,0,4],[10910,1,4],[3965,4,4],[4023,0,4],[1499,0,4],[1499,8,4],[9700,0,4],[725,5,4],[725,10,4],[689,0,4],[5147,0,4],[5147,2,4],[5147,4,4],[2352,0,4],[4077,2,4],[4077,4,4],[4490,0,4],[6046,0,4],[6046,1,4],[4247,0,4],[7257,0,4],[7802,10,4],[7801,0,4],[3577,0,4],[1185,4,4],[3681,4,4],[1082,0,4],[1082,5,4],[5362,1,4],[5362,2,4],[3612,0,4],[3802,0,4],[3237,2,4],[13823,0,4],[12574,0,4],[1268,0,4],[9827,2,4],[5664,3,4],[4105,0,4],[1881,0,4],[1881,4,4],[3348,0,4],[3348,3,4],[5474,1,4],[5474,2,4],[5420,0,4],[5420,1,4],[5420,7,4],[6040,0,4],[5811,2,4],[5733,0,4],[4303,3,4],[4716,1,4],[3172,7,4],[4661,1,4],[4661,4,4],[7393,0,4],[4102,0,4],[4102,5,4],[13246,0,4],[13246,1,4],[13246,2,4],[3282,0,4],[3282,3,4],[3282,5,4],[1092,0,4],[3697,4,4],[4338,2,4],[4338,3,4],[4452,0,4],[2559,0,4],[928,0,4],[928,1,4],[3785,0,4],[4671,0,4],[3822,0,4],[5198,3,4],[7845,1,4],[4013,0,4],[4485,0,4],[13243,0,4],[13243,4,4],[13243,7,4],[7183,0,4],[4728,1,4],[7394,0,4],[7394,6,4],[4053,0,4],[4053,2,4],[4052,0,4],[4046,0,4],[4046,5,4],[4054,4,4],[4047,5,4],[4050,0,4],[4048,0,4],[4049,0,4],[13242,0,4],[12326,0,4],[7045,0,4],[12138,0,4],[12565,0,4],[2713,20,4],[5432,1,4],[4140,0,4],[4140,9,4],[4028,0,4],[4456,0,4],[1125,0,4],[2609,1,4],[1888,0,4],[1888,3,4],[4235,2,4],[1889,4,4],[13293,0,4],[1644,0,4],[1644,56,4],[1851,0,4],[1103,0,4],[4029,0,4],[4607,0,4],[4607,1,4],[12472,0,4],[5617,7,4],[6892,1,4],[3385,1,4],[3385,2,4],[5645,0,4],[7304,2,4],[5621,2,4],[1117,0,4],[5306,0,4],[3685,1,4],[2599,0,4],[3689,0,4],[66,0,4],[2,0,4],[5137,3,4],[1328,2,4],[4365,0,4],[5873,0,4],[5873,3,4],[5873,5,4],[4407,1,4],[24,0,4],[1126,0,4],[1606,0,4],[13930,1,4],[1128,6,4],[3443,2,4],[667,1,4],[13829,0,4],[3980,0,4],[4015,0,4],[4017,0,4],[4017,3,4],[12572,0,4],[2672,1,4],[7036,0,4],[7100,0,4],[1045,0,4],[5200,2,4],[5200,7,4],[7142,0,3],[1845,0,4],[1845,2,4],[5338,8,4],[3056,7,4],[6026,0,4],[6026,2,4],[6026,3,4],[1326,0,4],[4453,5,4],[5327,0,4],[4738,0,4],[4738,1,4],[12453,0,4],[12443,0,4],[12459,0,4],[3310,0,4],[3310,6,4],[1434,0,4],[5132,0,4],[3387,1,4],[3387,3,4],[5566,0,4],[5566,1,4],[5566,2,4],[5566,3,4],[5566,6,4],[13832,0,4],[971,2,4],[4551,3,4],[4551,5,4],[1145,0,4],[3416,1,4],[3416,3,4],[5138,0,4],[3619,6,4],[5760,0,4],[4418,0,4],[4560,1,4],[8702,0,4],[5203,0,4],[1153,0,4],[4083,0,3],[12951,0,3],[4087,0,3],[4089,0,3],[13222,0,3],[4088,0,3],[4092,0,3],[4084,0,3],[12949,0,3],[4090,0,3],[13223,0,3],[4086,0,3],[5305,1,4],[4171,2,4],[2775,0,4],[546,0,4],[6053,0,4],[3617,0,3],[4019,2,4],[4019,5,4],[1217,0,4],[693,0,4],[5825,0,4],[4685,0,4],[2593,0,4],[4652,0,4],[3095,0,4],[3095,1,4],[3095,2,4],[3095,3,4],[3095,4,4],[11941,0,4],[12450,0,4],[12440,0,4],[12456,0,4],[3398,0,4],[11943,0,4],[5561,4,4],[5561,6,4],[7488,0,4],[4070,2,4],[3816,3,4],[4744,0,4],[4744,2,4],[4744,6,4],[2655,3,4],[5199,0,4],[5199,1,4],[3383,4,4],[6045,1,4],[8613,3,4],[7189,0,4],[7189,4,4],[7190,0,4],[7190,3,4],[3702,0,4],[3702,6,4],[3701,0,4],[3701,3,4],[3584,1,4],[3584,3,4],[3442,1,4],[3442,4,4],[132,0,4],[6904,0,4],[13827,0,4],[13825,0,4],[7868,5,4],[3268,0,4],[3328,0,4],[3489,0,4],[3489,2,4],[3671,1,4],[3671,4,4],[3696,0,4],[4578,2,4],[4578,3,4],[1170,0,4],[1171,4,4],[3616,3,4],[4069,0,4],[4068,15,4],[1779,0,4],[4440,0,4],[3474,4,4],[2776,0,4],[2776,1,4],[787,0,4],[787,1,4],[704,0,4],[7391,0,4],[3467,0,4],[3467,4,4],[3467,8,4],[1186,0,4],[4223,1,4],[1181,0,4],[5311,1,4],[5304,4,4],[5134,0,4],[5337,0,4],[4762,0,4],[4763,0,4],[4754,0,4],[4754,2,4],[4758,0,4],[4758,1,4],[4759,4,4],[4761,0,4],[4756,0,4],[4753,0,4],[13833,0,4],[5826,2,4],[4502,3,4],[2592,0,4],[13247,3,4],[13247,4,4],[5635,0,3],[2329,0,3],[4114,0,4],[4114,1,4],[4072,0,4],[4072,1,4],[7528,0,4],[7528,2,4],[7525,0,4],[4574,0,4],[4574,1,4],[4574,3,4],[5129,0,4],[3078,3,4],[3623,0,4],[3623,2,4],[13241,0,4],[13248,0,4],[3334,0,4],[5975,0,3],[4033,0,4],[4033,1,4],[85,0,4],[85,3,4],[7499,0,4],[533,0,4],[5388,1,4],[1199,0,4],[1199,2,4],[1199,4,4],[7231,0,3],[5670,0,3],[6983,0,4],[5434,0,4],[13449,0,4],[13820,0,4],[3388,0,4],[3388,2,4],[9769,0,4],[4428,0,4],[3706,0,4],[4524,0,4],[4524,1,4],[1211,0,4],[1211,2,4],[1211,5,4],[5167,1,4],[5167,2,4],[4308,0,4],[4025,0,4],[833,25,4],[1081,0,4],[9619,0,4],[907,2,4],[4395,0,4],[8465,0,4],[9834,5,4],[9768,2,4],[4723,3,4],[5609,0,4],[11179,0,4],[4563,0,4],[5775,0,4],[5775,1,4],[1744,0,4],[5165,0,4],[8417,2,4],[3986,2,4],[3986,5,4],[3428,0,4],[3428,3,4],[11100,0,4],[5927,0,4],[1232,0,4],[1232,1,4],[12454,0,4],[12444,0,4],[12460,0,4],[2326,0,3],[5808,7,4],[6909,0,4],[12402,0,4],[12401,0,4],[12403,0,4],[12408,0,4],[12405,0,4],[12407,0,4],[12411,0,4],[12404,0,4],[12409,0,4],[12406,0,4],[12410,0,4],[1452,0,4],[3463,0,4],[3245,0,4],[3245,1,4],[3245,2,4],[3245,3,4],[3446,0,3],[3444,0,4],[1840,1,4],[4116,0,4],[4116,5,4],[5297,0,4],[5297,1,4],[7379,0,4],[5809,0,4],[5809,1,4],[5809,6,4],[5655,0,4],[5655,1,4],[28,0,4],[12412,0,4],[4117,0,4],[12452,0,4],[12442,0,4],[12458,0,4],[1558,0,3],[2558,0,3],[3205,0,3],[1565,0,3],[3206,0,3],[1913,0,3],[4124,0,3],[7133,0,3],[2605,0,3],[3439,0,3],[8826,0,3],[3436,0,3],[12741,0,4],[3313,0,4],[3313,3,4],[4270,0,3],[4132,0,4],[13245,0,4],[3451,5,4],[7836,0,4],[7047,0,4],[4734,1,4]