Building the Inventory File

[ankrups]

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.

 

[gelu]

open a new excel
check if it does import of csv in PQ

if yes then (in your old file) check again the link you have in the Source step under Applied Steps (start restart the file and Excel also)

 

[ankrups]

So just to give you an idea, the link which vendor has provided, downloads the file in .zip format from where I need to open the folder and then can able to access the .CSV file.

Hope this helps.

 

[gelu]

That is the issue then.
You have to provide PQ with the csv file.
Unzip it on a folder
point PQ to the csv file in that folder as a source