Discussion Forum: Catalog: Message 1454839
 Previous Message   Next Message 
 Author: hpoort View Messages Posted By hpoort
 Posted: Feb 15, 2024 07:37
 Subject: Re: Is there an easy way to pull catalogue data?
 Viewed: 44 times
 Topic: Catalog
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

hpoort (416)

Location:  Netherlands, Groningen
Member Since Contact Type Status
Oct 11, 2014 Contact Member Buyer
Buying Privileges - OK
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

Message is in Reply To:

View Thread Is there an easy way to pull catalogue data? - NoGravitasHere (35)
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 [...]
(4 months ago, Feb 15, 2024, to Catalog)

Message Has 1 Reply:

View Thread Re: Is there an easy way to pull catalogue data? - NoGravitasHere (35)
Oh you legend, this is exactly what I needed! Now to figure out how to dump this data into Google Sheets... Thanks!
(4 months ago, Feb 17, 2024, to Catalog)

4 Messages in this Thread:

 Msg 1 - NoGravitasHere (35) 4 months ago Feb 15, 2024 to Catalog
 Msg 2 - Stellar (3536) 4 months ago Feb 15, 2024 to Catalog
 Msg 3 « - hpoort (416) 4 months ago Feb 15, 2024 to Catalog
 Msg 4 - NoGravitasHere (35) 4 months ago Feb 17, 2024 to Catalog

 Previous Message   Next Message 

Entire thread on one page
This message and all its replies on one page