Hello,
I need to build the inventory file which I am receiving from different vendors in csv link format. I want to convert those data into the one standardize format where I can upload into my system.
So what I want is as per below...
1. Download the raw data from each vendor who has gave us the csv link.
2. Paste the data into dedicated tabs and run the existing formula to calculate price, SOH (National), Web Price
3. Convert the data for standardized inventory file for ready to upload in our system.
4. Create report for new products to be added into the system and populate the information in each specified columns for the new product upload template.
I know there are many steps and processes involving in this project. I am not sure it can be done via Access or Excel but I need to create solution where we can upload this data daily.
Currently due to time consuming of gathering this information we are doing two times a week.
Appreciate your help in this regards.
I need to build the inventory file which I am receiving from different vendors in csv link format. I want to convert those data into the one standardize format where I can upload into my system.
So what I want is as per below...
1. Download the raw data from each vendor who has gave us the csv link.
2. Paste the data into dedicated tabs and run the existing formula to calculate price, SOH (National), Web Price
3. Convert the data for standardized inventory file for ready to upload in our system.
4. Create report for new products to be added into the system and populate the information in each specified columns for the new product upload template.
I know there are many steps and processes involving in this project. I am not sure it can be done via Access or Excel but I need to create solution where we can upload this data daily.
Currently due to time consuming of gathering this information we are doing two times a week.
Appreciate your help in this regards.
Last edited by a moderator: