| Discussion Forum: Thread 353959 |
|
 |
| | | Author: | NoGravitasHere  | | Posted: | Feb 15, 2024 02:51 | | Subject: | Is there an easy way to pull catalogue data? | | Viewed: | 96 times | | Topic: | Catalog | | Status: | Open | |
|
| I have a shitty old spreadsheet where I track the market (and insurance) values
of Bionicle masks, and I've just been doing entries manually. It's due
for an update, but I've started using BrickStore for a lot of this sort of
stuff in the meantime. I know BrickStore has pricing functionality, I use it
pretty often but I'm still a novice with the program in general.
Is there an easy way to grab the entire BrickLink 'known' Bionicle Kanohi
Mask catalogue in one fell swoop, or do I still need to add masks individually
through BrickStore/wanted list/whatever? There's like ~540 items to add just
for G1, and that's gonna suck to input manually, even with auto pricing!
Cheers
James @ PSPS
|
|
|
| | | | | |
| | | | | Author: | Stellar | | Posted: | Feb 15, 2024 04:12 | | Subject: | Re: Is there an easy way to pull catalogue data? | | Viewed: | 46 times | | Topic: | Catalog | |
|
| In Catalog, NoGravitasHere writes:
| | I have a shitty old spreadsheet where I track the market (and insurance) values
of Bionicle masks, and I've just been doing entries manually. It's due
for an update, but I've started using BrickStore for a lot of this sort of
stuff in the meantime. I know BrickStore has pricing functionality, I use it
pretty often but I'm still a novice with the program in general.
Is there an easy way to grab the entire BrickLink 'known' Bionicle Kanohi
Mask catalogue in one fell swoop, or do I still need to add masks individually
through BrickStore/wanted list/whatever? There's like ~540 items to add just
for G1, and that's gonna suck to input manually, even with auto pricing!
Cheers
James @ PSPS
|
Upvote and comment on this suggestion:
https://github.com/rgriebl/brickstore/issues/668
https://www.bricklink.com/catalogList.asp?catType=P&catString=235
|
|
|
| | | | | |
| | | | | Author: | hpoort | | Posted: | Feb 15, 2024 07:37 | | Subject: | Re: Is there an easy way to pull catalogue data? | | Viewed: | 42 times | | Topic: | Catalog | |
|
| In Catalog, NoGravitasHere writes:
| | I have a shitty old spreadsheet where I track the market (and insurance) values
of Bionicle masks, and I've just been doing entries manually. It's due
for an update, but I've started using BrickStore for a lot of this sort of
stuff in the meantime. I know BrickStore has pricing functionality, I use it
pretty often but I'm still a novice with the program in general.
Is there an easy way to grab the entire BrickLink 'known' Bionicle Kanohi
Mask catalogue in one fell swoop, or do I still need to add masks individually
through BrickStore/wanted list/whatever? There's like ~540 items to add just
for G1, and that's gonna suck to input manually, even with auto pricing!
Cheers
James @ PSPS
|
Use the catalog download page (https://www.bricklink.com/catalogDownload.asp)
to download a list of all part numbers, do some Excel trickery (filters + string
concatenation only) and thus transform it into an xml to upload a wanted list.
Once you have your wanted list, you can find the top 20 parts for sale for each
of the entries, for instance go to https://www.bricklink.com/wantedDetail.asp?showOld=Y&catType=P&wantedMoreID=0
|
|
|
| | | | | | | | | |
| | | | | | | Author: | NoGravitasHere | | Posted: | Feb 17, 2024 14:41 | | Subject: | Re: Is there an easy way to pull catalogue data? | | Viewed: | 44 times | | Topic: | Catalog | |
|
| Oh you legend, this is exactly what I needed! Now to figure out how to dump this
data into Google Sheets...
Thanks!
|
|
|
|
|
|
New Zealand, Canterbury
Spain, Comunidad Valenciana
Netherlands, Groningen