chips_migrate.js

const fs = require("fs")
const jSmall = require("./json/rics_updated_product_list_small.json");  //  
const jClasses = require("./json/rics_export_classes.json");  //  
const jSkus = require("./json/rics_export_skus.json");  //  

let aOut = []
let sOut = ""

jSmall.forEach(function( sProd ){
    let aItems = sProd.split(",")
    console.log( aItems[1] + " | " +  aItems[10] )
    aItems[10] = getClass( aItems[1] )
    aItems.join(",")
    aOut.push( aItems )
})

function getClass( _sSku ){
    let sRetVal = jSkus.filter(function( sSku ){
        let aLine = sSku.split( "," )
        return ( aLine[0] == _sSku )
    })[0]
    if( sRetVal ) return "QQQQQQ" + sRetVal.split( "," )[9]
    return "N/A"
}

aOut.forEach(function( sProd ){
    sOut = sOut + sProd + "\n"
})

try {
  fs.writeFileSync('./csv/nd_products.csv', sOut);
} catch (err) {
  console.error(err);
}