Combining multiple supplier CSVs into a uniform CSV output file

How To
, ,
1

Hi Community,

I’m working on a scenario that will ideally achieve the following import, data sort, aggregation, and export task.

Instructions:

  1. Fetch four different supplier CSVs from four different folders on the same FTP.

  2. Collect EAN, price, stock, title and supplier name from each CSV (column names and locations differ on each file, so may need to be assigned manually).

  3. A duplicate EAN search is then needed across all CSVs. If multiple suppliers are selling the same EAN, the module should assign the cheapest supplier’s pricing and stock to the aggregated output file (and exclude other suppliers that share the same EAN). This task is not necessary for duplicates within the same supplier file.

  4. The uniformly structured, aggegated file should then be uploaded to a specific folder on the FTP directory.

Many Thanks in advance for any help/ advice.