Pricing from suppliers website

[Clueless401]

Hi everyone,

Is it possible to create a list of parts i order from a specific vendors website that includes the listing price LIVE from the website.

Note: this vendor updates prices on a regular basis.

 

[Legacy 456155]

Sure, it's possible. Most of our vendors provide price lists, exporting, and/or a web API to fetch info at will. Have you checked with your vendor for a more straight-forward solution? If you create a custom solution, you are at the mercy of the the web page developers - having to respond to any changes that they make. The slightest change may break your code.

 

[Clueless401]

Sure, it's possible. Most of our vendors provide price lists, exporting, and/or a web API to fetch info at will. Have you checked with your vendor for a more straight-forward solution? If you create a custom solution, you are at the mercy of the the web page developers - having to respond to any changes that they make. The slightest change may break your code.

YES! they did send me something, but i dpnt know how to use it! what should i do?

 

[Legacy 456155]

What might that something be?
Can you post an example?

 

[Legacy 456155]

Probably outta stick with your new thread.

In/Out of stock spread sheet

Please note i have very little experience with Excel. I have a Net Price File effective October 1, 2020. This file contains the standard list x multiplier and special Gspec pricing. This was given to me from one of our vendors. And have no clue what that means! How can i use this to set up a...

www.mrexcel.com

 

[Clueless401]

Probably outta stick with your new thread.

In/Out of stock spread sheet

Please note i have very little experience with Excel. I have a Net Price File effective October 1, 2020. This file contains the standard list x multiplier and special Gspec pricing. This was given to me from one of our vendors. And have no clue what that means! How can i use this to set up a...

www.mrexcel.com

YES, i ordered some books for beginners on Amazon.com. i ordered one that was to advance for me at first. here is the spread sheet the vendor send me. Note: this is a few parts from a list containing thousands of parts! im in way over my head on this one, lol!

My Vision is to create a first in first out inventory using this list they send me. It would be ideal to have multiple tables that work together to record different data.

I dont know if it is possible. But i would like to create a stock inventory list that is attached to a transactions list and transmittal form. i work with engineers and they are assigned various projects. We take out parts from our inventory and assign them to a project. Pretty much the engineers are my customers....I need to keep track of what is coming into and out of stock as well as record and charge the project the parts are going to. it would equal out to 3 different sheets, i think!...One would be the transmittal, the transmittal will ask for project numbers, names and parts from stock or ordered parts and automatically update our stock on a separate sheet and at the same time add or charge the project it is going to on a separate sheet containing the transactions that will be later sent to our accountant on a monthly basis. It would be nice if rather then having them on multiple sheets, if they could be on separate workbooks entirely. This is because i would like to give access to some of this data to our engineers and techs so that they can check if we have parts in stock that they might need for a project or they can order them. Also, if i am away or on vacation, it can run while i am away! it is important that i create this thing to work and be understandable so that anyone can use it. I would like the inventory system to pretty much run itself so that i can move on to working on more complex projects, i would like to grow in the organization and it will not be possible unless i get this inventory running correctly how i envision it.

i will get it done, i know i will. i just want to get it done now or as soon as possible and do not care about working on my own time.

these are the instructions they gave me:
Instructions for electronic net files:
PRICE FILE HEADINGS:
A=PART NUMBER
B=DESCRIPTION
C=PRODUCT MULTIPLIER
D=PACK QUANTITY
E=LIST PRICE
F=SUGGESTED DEALER NET
G=YOUR COST
H=@SUBJECT TO US DOT SHIPPING and LABELING REQUIREMENTS
&QTY CHANGE
* =Must order by carton
# = Check availability
I=UPC CODES

00-00051-01	ENCLOSURE ELECTRONIC; JOHNSON CONTROLS ENVIRO-TEC® (ETI OF LARGO; FL) - VAV ELECTRONIC ENCLOSURE	BNET	1​	93.00​	46.50​	28.83​		66201154783​
00-00052-01	COVER ELECTRONIC CONTROL; JOHNSON CONTROLS ENVIRO-TEC (ETI OF LARGO; FL) - VAV ELECTRONIC ENCLOSURE	BNET	1​	88.00​	44.00​	27.28​		66201154784​
00-E0010	ZERO LINE - NPS; ZERO LINE - NPS	ESUR	1​	0.00​	0.00​	0.00​		78502874330​
00-E00NM	ZERO LINE ITEM - NAOMI; ZERO LINE ITEM - NAOMI	ESUR	1​	0.00​	0.00​	0.00​		78502881101​
01-E606-01	RELAY MODULE 4 CHANNEL; RELAY MODULE 4 CHANNEL	PVEN	1​	373.00​	186.50​	115.63​		66201152231​
01-E624	RE-TRANSMISSIONMOD 4-20MA; RE-TRANSMISSIONMOD 4-20MA	PVEN	1​	2927.00​	1463.50​	907.37​		66201152232​
01-E922-0	MINI RDU RS485; MINI RDU RS485	PVEN	1​	1104.00​	552.00​	342.24​		66201152233​
01-E922-00	BLANK PLATE; BLANK PLATE	PVEN	1​	70.00​	35.00​	21.70​		66201152234​
01-E922-99	19 INCH RDU SUBRACK; 19 INCH RDU SUBRACK	PVEN	1​	352.00​	176.00​	109.12​		66201152235​
02 - 2002 - 01P	STRAIGHT UNION FOR MICRO; STRAIGHT UNION FOR MICRO	PVEN	10​	294.00​	147.00​	91.14​	*	66201152498​
02 - 3000 - 06	STAINLESS STEEL SAMPLE PT; STAINLESS STEEL SAMPLE PT	PVEN	1​	338.00​	169.00​	104.78​		66201152236​
02-FL01-01	SCINTERED EOL FILTER; SCINTERED EOL FILTER	PVEN	1​	84.00​	42.00​	26.04​		66201152237​
02-FL56	FILTER ELEMENTREPLACEMENT; FILTER ELEMENTREPLACEMENT	PVEN	1​	152.00​	76.00​	47.12​		66201152239​
0202-054	AXIS CMERA STATION - 4; CAMERA BASE LICENSE	PVEN	1​	1301.00​	650.50​	403.31​		66201115905​
025-36432-00	YORK TEMP; YORK TEMP	PVEN	1​	49.98​	24.99​	15.49​
0288-004	VIDEO ENCODER 1 INPUT	PVEN	1​	1301.00​	650.50​	403.31​		66201130505​
0291-004	VIDEO ENCODER 4 INPUTS	PVEN	1​	2931.00​	1465.50​	908.61​		66201130508​
0318-004	IP CAMERA PTZ 35X OUTDOOR	PVEN	1​	9777.00​	4888.50​	3030.87​		66201130514​
0329-001	IP CAMERA 2.8MM; POE; IP CAMERA 2.8MM; POE	PVEN	1​	1138.00​	569.00​	352.78​		66201130519​
0336-001	IP FXD CAMDOME TAMPER RES	PVEN	1​	1301.00​	650.50​	403.31​		66201130520​

 

[Legacy 456155]

I dont know if it is possible.

Sure it is. Especially with your refreshing attitude. I appreciate your enthusiasm. Johnson Controls is one of my suppliers as well. We use them for some of our fire alarm packages.

Are you certain that you want to roll this out in Excel? Access would be a MUCH better fit IMO, though it's not mandatory. Since you are just beginning, you might want to choose the better app to begin with. Are you constrained by requirements to use Excel? Is Access an option? Though Access might seem somewhat mysterious to those who are primarily familiar with spreadsheets, even with the learning curve, it will be easier to accomplish your current goal using Access instead of Excel. Either way, you should find no problem getting some help here. If you decide to go with Access, post in the Access forum or ask a moderator to move your post. There are several talented Access people that regularly visit. I'm fairly decent with Access and OK with Excel.

I have a couple of questions for you.

1. Do you order all of the stock in question through a single vendor? If not, I have some more questions on this point.
2. Do you need to maintain static pricing at the project level? For example, if you add 10 of item XYZ to Project ABC for $10.00 each, do the prices remain static (order cost) or do the prices update (after assignment, within the project) in response to the current vendor price? I have seen the static option used more often than not. Using the static option complicates your strategy a bit because you may have like items differing in value. This alone justifies using something more suitable than Excel.

Whatever you choose, my advice is to keep your project a simple as possible. You can add some bling AFTER you get it functional.

 

[Clueless401]

Sure it is. Especially with your refreshing attitude. I appreciate your enthusiasm. Johnson Controls is one of my suppliers as well. We use them for some of our fire alarm packages.

Are you certain that you want to roll this out in Excel? Access would be a MUCH better fit IMO, though it's not mandatory. Since you are just beginning, you might want to choose the better app to begin with. Are you constrained by requirements to use Excel? Is Access an option? Though Access might seem somewhat mysterious to those who are primarily familiar with spreadsheets, even with the learning curve, it will be easier to accomplish your current goal using Access instead of Excel. Either way, you should find no problem getting some help here. If you decide to go with Access, post in the Access forum or ask a moderator to move your post. There are several talented Access people that regularly visit. I'm fairly decent with Access and OK with Excel.

I have a couple of questions for you.

1. Do you order all of the stock in question through a single vendor? If not, I have some more questions on this point.
2. Do you need to maintain static pricing at the project level? For example, if you add 10 of item XYZ to Project ABC for $10.00 each, do the prices remain static (order cost) or do the prices update (after assignment, within the project) in response to the current vendor price? I have seen the static option used more often than not. Using the static option complicates your strategy a bit because you may have like items differing in value. This alone justifies using something more suitable than Excel.

Whatever you choose, my advice is to keep your project a simple as possible. You can add some bling AFTER you get it functional.

Im sure the prices update once or twice a year. There is a lot of things i need to figure out as you can notice. However, i chose excel as a startup point and once i master excel (im giving myself a year to master), i will move on to mastering access.

we do use other vendors and i know access would make everything a lot simpler. just need to have something ready now and evolve it to something better and faster.