|
 |
| | | Author: | LegoGuyX  | | Posted: | Dec 30, 2021 19:16 | | Subject: | download price guides for multiple parts? | | Viewed: | 101 times | | Topic: | Price Guide | |
|
| BrickLink newbie here, and I’m not a seller. I’m writing a program to make Lego
mosaics from pictures. I’d like the code to automatically estimate the price
of the 1x1 round tiles used to make the mosaic in order to explore the tradeoffs
between the appearance of the mosaic and the price of the parts.
Is there a way I can download price guides for 1x1 round tiles (or any other
parts)? I know I can get a price guide interactively on BrickLink (e.g. https://www.bricklink.com/catalogPG.asp?itemType=P&itemNo=98138&itemSeq=1&colorID=105&v=P&priceGroup=Y&prDec=2),
but this would be tedious to do for ~35 different colors, it’s not conveniently
downloadable, and prices will change over time.
BrickStock is intriguing, because it can update a parts database from BrickLink.
One thing I tried was BrickStock’s feature to import a BrickLink shopping cart.
I made a shopping cart on BrickLink with each of the tile colors I want. But
BrickStock couldn’t import the cart from the BrickLink URL.
Other ideas?
|
|
|
| | | | | |
| | | | | Author: | bricksonmove | | Posted: | Dec 30, 2021 19:20 | | Subject: | Re: download price guides for multiple parts? | | Viewed: | 33 times | | Topic: | Price Guide | |
|
| In Price Guide, LegoGuyX writes:
| | BrickLink newbie here, and I’m not a seller. I’m writing a program to make Lego
mosaics from pictures. I’d like the code to automatically estimate the price
of the 1x1 round tiles used to make the mosaic in order to explore the tradeoffs
between the appearance of the mosaic and the price of the parts.
Is there a way I can download price guides for 1x1 round tiles (or any other
parts)? I know I can get a price guide interactively on BrickLink (e.g. https://www.bricklink.com/catalogPG.asp?itemType=P&itemNo=98138&itemSeq=1&colorID=105&v=P&priceGroup=Y&prDec=2),
but this would be tedious to do for ~35 different colors, it’s not conveniently
downloadable, and prices will change over time.
BrickStock is intriguing, because it can update a parts database from BrickLink.
One thing I tried was BrickStock’s feature to import a BrickLink shopping cart.
I made a shopping cart on BrickLink with each of the tile colors I want. But
BrickStock couldn’t import the cart from the BrickLink URL.
Other ideas?
|
use the want feature and make different lists for each project. what that does
is search for the cheapest option for your parts
|
|
|
| | | | | | | | | |
| | | | | | | Author: | LegoGuyX | | Posted: | Dec 30, 2021 19:27 | | Subject: | Re: download price guides for multiple parts? | | Viewed: | 26 times | | Topic: | Price Guide | |
|
| | | use the want feature and make different lists for each project. what that does
is search for the cheapest option for your parts
|
Hi bricksonmove - thanks for this suggestion. I should clarify that I want this
price estimate to be done programmatically, without having to manually poke around
on BrickLink. I'd like the program to suggest several different mosaics from
the same input image (such as using fewer different colors), which would each
have a different parts list. Then I want the program to estimate the cost of
each one automatically. For example if "Dark Blue" is especially expensive, I'd
like to automatically see how much the total price would come down if I replaced
"Dark Blue" with just "Blue". To do this, I'd like data with the prices of
all the different colors for round 1x1 tiles.
|
|
|
| | | | | | | | | | | | | |
| | | | | | | | | Author: | psusaxman2000 | | Posted: | Dec 30, 2021 20:57 | | Subject: | Re: download price guides for multiple parts? | | Viewed: | 36 times | | Topic: | Price Guide | |
|
| In Price Guide, LegoGuyX writes:
| | | | use the want feature and make different lists for each project. what that does
is search for the cheapest option for your parts
|
Hi bricksonmove - thanks for this suggestion. I should clarify that I want this
price estimate to be done programmatically, without having to manually poke around
on BrickLink. I'd like the program to suggest several different mosaics from
the same input image (such as using fewer different colors), which would each
have a different parts list. Then I want the program to estimate the cost of
each one automatically. For example if "Dark Blue" is especially expensive, I'd
like to automatically see how much the total price would come down if I replaced
"Dark Blue" with just "Blue". To do this, I'd like data with the prices of
all the different colors for round 1x1 tiles.
|
I don't know of a programmatic way of doing it, but you could always just
look up the six month average of each of the parts and just input it into your
program. I can imagine that they fluctuate that much over the course of time.
|
|
|
| | | | | |
| | | | | Author: | LegoGuyX | | Posted: | Dec 30, 2021 22:18 | | Subject: | Re: download price guides for multiple parts? | | Viewed: | 38 times | | Topic: | Price Guide | |
|
| I got a private message suggesting BrickStore for this task, and it did what
I needed. You can make a BrickLink XML file of the parts you're interested
in, with quantity 1 for each. Then you import this file to BrickStore, and it
shows you the average price of each part. You can export this data as XML. It's
not completely automatic, because you have to manually import the BrickLink XML
and manually export the BrickStore result, but this is OK, because prices don't
change all that fast (I hope). In the end, you have a file with the average price
of each part.
Based on BrickStore, I'm recommending against using many Dark Azure 1x1 round
tiles for your projects, because the average price is outrageous at $0.26. (See
screenshot.) Yikes. 
|
|
|
| | | | | |
| | | | | Author: | hpoort | | Posted: | Dec 31, 2021 02:21 | | Subject: | Re: download price guides for multiple parts? | | Viewed: | 41 times | | Topic: | Price Guide | |
|
| In Price Guide, LegoGuyX writes:
| | BrickLink newbie here, and I’m not a seller. I’m writing a program to make Lego
mosaics from pictures. I’d like the code to automatically estimate the price
of the 1x1 round tiles used to make the mosaic in order to explore the tradeoffs
between the appearance of the mosaic and the price of the parts.
Is there a way I can download price guides for 1x1 round tiles (or any other
parts)? I know I can get a price guide interactively on BrickLink (e.g. https://www.bricklink.com/catalogPG.asp?itemType=P&itemNo=98138&itemSeq=1&colorID=105&v=P&priceGroup=Y&prDec=2),
but this would be tedious to do for ~35 different colors, it’s not conveniently
downloadable, and prices will change over time.
BrickStock is intriguing, because it can update a parts database from BrickLink.
One thing I tried was BrickStock’s feature to import a BrickLink shopping cart.
I made a shopping cart on BrickLink with each of the tile colors I want. But
BrickStock couldn’t import the cart from the BrickLink URL.
Other ideas?
|
Use Studio.
If not for making the mosaic, it does make a cache of Bricklink's part prices
as well, one .json file in the folder C:\Users\{USERNAME}\AppData\Local\Stud.io\BLBrickMetaInfo\
for each part shape it displays in the palette when the option 'hide unavailable
colors' is checked.
Like for example file 98138
{"AvailableColors":[{"colorId":1,"priceInfo":{"newSold":0.0602530763872765,"newStock":0.0745420944558522,"usedSold":0.055065452475811,"usedStock":0.0675807787903894,"currency":"EUR","lastUpdatedTime":"12/19/2021
15:13:43","IsNeedUpdate":false}},{"colorId":2,"priceInfo":{"newSold":0.0753616200578592,"newStock":0.0921664548919949,"usedSold":0.0816111111111111,"usedStock":0.10527972027972,"currency":"EUR","lastUpdatedTime":"12/19/2021
15:13:43","IsNeedUpdate":false}},{"colorId":3,"priceInfo":...
...
...
,{"colorId":223,"priceInfo":{"newSold":0.065985401459854,"newStock":0.0821328671328671,"usedSold":0.0372727272727273,"usedStock":0.0877777777777778,"currency":"EUR","lastUpdatedTime":"12/19/2021
15:13:43","IsNeedUpdate":false}},{"colorId":228,"priceInfo":{"newSold":0.07296875,"newStock":0.0907910750507099,"usedSold":0.085,"usedStock":0.194137931034483,"currency":"EUR","lastUpdatedTime":"12/19/2021
15:13:43","IsNeedUpdate":false}}],"Weight":"0.11","DimX":"1.00","DimY":"1.00","DimZ":"0.00","LastUpdatedTime":"12/19/2021
14:55:28","IsNeedToUpdate":false}
|
|
|
| | | | | | | | | |
| | | | | | | Author: | LegoGuyX | | Posted: | Dec 31, 2021 14:06 | | Subject: | Re: download price guides for multiple parts? | | Viewed: | 31 times | | Topic: | Price Guide | |
|
| | |
Use Studio.
If not for making the mosaic, it does make a cache of Bricklink's part prices
as well, one .json file in the folder C:\Users\{USERNAME}\AppData\Local\Stud.io\BLBrickMetaInfo\
for each part shape it displays in the palette when the option 'hide unavailable
colors' is checked.
Like for example file 98138
{"AvailableColors":[{"colorId":1,"priceInfo":{"newSold":0.0602530763872765,"newStock":0.0745420944558522,"usedSold":0.055065452475811,"usedStock":0.0675807787903894,"currency":"EUR","lastUpdatedTime":"12/19/2021
15:13:43","IsNeedUpdate":false}},{"colorId":2,"priceInfo":{"newSold":0.0753616200578592,"newStock":0.0921664548919949,"usedSold":0.0816111111111111,"usedStock":0.10527972027972,"currency":"EUR","lastUpdatedTime":"12/19/2021
15:13:43","IsNeedUpdate":false}},{"colorId":3,"priceInfo":...
...
...
,{"colorId":223,"priceInfo":{"newSold":0.065985401459854,"newStock":0.0821328671328671,"usedSold":0.0372727272727273,"usedStock":0.0877777777777778,"currency":"EUR","lastUpdatedTime":"12/19/2021
15:13:43","IsNeedUpdate":false}},{"colorId":228,"priceInfo":{"newSold":0.07296875,"newStock":0.0907910750507099,"usedSold":0.085,"usedStock":0.194137931034483,"currency":"EUR","lastUpdatedTime":"12/19/2021
15:13:43","IsNeedUpdate":false}}],"Weight":"0.11","DimX":"1.00","DimY":"1.00","DimZ":"0.00","LastUpdatedTime":"12/19/2021
14:55:28","IsNeedToUpdate":false}
|
Thanks for the clever idea. This also looks like a good way to do what I want.
John
|
|
|
|
|
|
USA, Washington
Australia, Victoria
Netherlands, Groningen