We have over 100 Manufacturers that send us inventory reports on excel sheets. Problem is that it takes too long to update. So here is what we need. We will have about 100 emails a week with excel files, or possibly some pdf's that need to be converted to excel. These files will need to be dumped into a folder. In this folder we will have a sheet containing our SKU field (unique id) and our Manufacturers part number. We need to have these 100 sheets (or more) automatically mapped to our sku number and create a single file with inventory.
1) Access Script written to build a single file inventory list based upon the inventory on many different sheets. Common field will be mapped on each sheet.
2) A script written to auto download emails containing filed into a folder that will auto generate the inventory.
3) Exception report A - Items listed on Manufacturers sheet that we dont have (items to be added to website)
3B) Exception Report B - Items listed on our sheet that manufacturers dont have (items that are discontinued and should be removed)
3C) Exception Report C - Generate list of manufacturers that did not send report - based upon a list of all manufacturers - So if 70 out of 100 manufacturers sent the file - we need to identify the 30 that did not send it.
4) All sites have the same products IDS - but items appear in multiple sites. We need to have the file generate for each of the 4 websites.
All of this is similar to an auto V LOOOK UP type feature. But we need a high level of autmation here.
There may be situations where we have options on an item and the item from the manufacturer and ours are not exact. We need some way to handle these situations.