Building the Inventory File

ankrups

Board Regular
Joined
Mar 14, 2006
Messages
125
Office Version
  1. 2021
Platform
  1. Windows
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.
 
Last edited by a moderator:
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)
 
Upvote 0

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
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.
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,216,500
Messages
6,131,016
Members
449,615
Latest member
Nic0la

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top