I need a program that processes multiple files data and mines certain information. This is to update prices and inventory multiple times a day.
My product list has the following headers
Product Code
Product Name
Department
Inventory
Retail Price
Wholesale Price
Cost Price
Profit Margin
Price Change
Profit/Loss
I have a list of product codes and product names that need wholesale price and inventory values mined from multiple distributor csv, xml, xls, and txt files.
They are …
