| Discussion Forum: Thread 330787 |
|
 |
| | | Author: | donaia  | | Posted: | Nov 28, 2022 04:40 | | Subject: | How to buy mixed new white elements cheaply | | Viewed: | 70 times | | Topic: | Buying | |
|
| Hello - I'm keen to buy 6 of as many white elements as I can find for an
art project, as cheaply as possible. I've searched the forum for an efficient
way to do this, but can't find anything. I'm keen to find a listing of
the cheapest new price for each element in the UK, without visiting individual
stores. Or if there is another way to do this efficiently I'm all ears. Thanks
in advance for your thoughts.
|
|
| | | | | |
| | | | | Author: | yorbrick | | Posted: | Nov 28, 2022 05:07 | | Subject: | Re: How to buy mixed new white elements cheaply | | Viewed: | 30 times | | Topic: | Buying | |
|
| In Buying, donaia writes:
| | Hello - I'm keen to buy 6 of as many white elements as I can find for an
art project, as cheaply as possible. I've searched the forum for an efficient
way to do this, but can't find anything. I'm keen to find a listing of
the cheapest new price for each element in the UK, without visiting individual
stores. Or if there is another way to do this efficiently I'm all ears. Thanks
in advance for your thoughts.
|
Breadth of inventory and cheapest don't really go together. You can add all
the parts you want to a wants list and try doing it that way.
Bear in mind postage will typically be about £4 or so if you are doing a parcel
(it will be cheaper if you are buying smaller parts that can go large letter).
So if a store is a couple of pennies more expensive per part than the cheapest,
then it doesn't matter too much unless you can order multiple hundreds from
someone else so the saving covers the extra postage. And if the cheapest doesn't
have much inventory, the postage won't be worth shopping with them.
|
|
|
| | | | | |
| | | | | Author: | hpoort | | Posted: | Nov 28, 2022 07:06 | | Subject: | Re: How to buy mixed new white elements cheaply | | Viewed: | 38 times | | Topic: | Buying | |
|
| In Buying, donaia writes:
| | Hello - I'm keen to buy 6 of as many white elements as I can find for an
art project, as cheaply as possible. I've searched the forum for an efficient
way to do this, but can't find anything. I'm keen to find a listing of
the cheapest new price for each element in the UK, without visiting individual
stores. Or if there is another way to do this efficiently I'm all ears. Thanks
in advance for your thoughts.
|
You'll need some off-site tinkerin. Start with:
(1a) download the catalog of all 74115 parts as csv at https://www.bricklink.com/catalogDownload.asp?utm_content=subnav
or
(1b) extract the 14036 part numbers from the 71 pages at https://www.bricklink.com/catalogList.asp?v=0&pg=1&colorPart=1&catType=P
(configure it to show the maximum of 200 lines per page)
then (in a spreadsheet):
(2) manipulate this to extract the part numbers you are interested in (e.g. you
might want to skip all parts numbers that have a 'p' in their number
when you don't want decorated parts).
(3) manipulate further to format the part numbers in the Bricklink wanted list
format (https://www.bricklink.com/help.asp?helpID=207). You'll need to split
it into manageable chunks of 1000 lots and have to set the color to white (1),
the maximum to 6 and perhaps the max price to something acceptable for you to
eliminate the rare and expensive parts.
then back to Bricklink:
(4) copy-paste the wanted list xmls at https://www.bricklink.com/wantedXML.asp?showOld=Y
or upload them at https://www.bricklink.com/v2/wanted/upload.page?utm_content=subnav
(5) use the classic wanted list function 'search by shop' to locate the
shops that have the most unique lots of your wanted list: https://www.bricklink.com/wantedShop.asp?showOld=Y&wantedMoreMultiple=&qs=
It is not a ready-made solution, but this make your task doable in a few hours.
I hope this helps.
|
|
|
| | | | | | | | | |
| | | | | | | Author: | SylvainLS | | Posted: | Nov 28, 2022 07:20 | | Subject: | Re: How to buy mixed new white elements cheaply | | Viewed: | 32 times | | Topic: | Buying | |
|
| In Buying, hpoort writes:
| | In Buying, donaia writes:
| | Hello - I'm keen to buy 6 of as many white elements as I can find for an
art project, as cheaply as possible. I've searched the forum for an efficient
way to do this, but can't find anything. I'm keen to find a listing of
the cheapest new price for each element in the UK, without visiting individual
stores. Or if there is another way to do this efficiently I'm all ears. Thanks
in advance for your thoughts.
|
You'll need some off-site tinkerin. Start with:
(1a) download the catalog of all 74115 parts as csv at https://www.bricklink.com/catalogDownload.asp?utm_content=subnav
|
Small simplification here: on the same page, download the “Part and Color Codes”
list instead, then only keep the entries with the colour White.
There’ll be doublets but at least you can easily filter by colour.
|
|
|
| | | | | | | | | | | | | |
| | | | | | | | | Author: | hpoort | | Posted: | Nov 28, 2022 12:07 | | Subject: | Re: How to buy mixed new white elements cheaply | | Viewed: | 23 times | | Topic: | Buying | |
|
| In Buying, SylvainLS writes:
| | In Buying, hpoort writes:
| | In Buying, donaia writes:
| | Hello - I'm keen to buy 6 of as many white elements as I can find for an
art project, as cheaply as possible. I've searched the forum for an efficient
way to do this, but can't find anything. I'm keen to find a listing of
the cheapest new price for each element in the UK, without visiting individual
stores. Or if there is another way to do this efficiently I'm all ears. Thanks
in advance for your thoughts.
|
You'll need some off-site tinkerin. Start with:
(1a) download the catalog of all 74115 parts as csv at https://www.bricklink.com/catalogDownload.asp?utm_content=subnav
|
Small simplification here: on the same page, download the “Part and Color Codes”
list instead, then only keep the entries with the colour White.
There’ll be doublets but at least you can easily filter by colour.
|
Good idea, but the PCC list is far from complete if you are also interested in
older parts.
Of the 16K non-patterned parts in the catalogDownload, only 7K have any PCC and
9K do not. Only 1650 of these have a PCC for White.
|
|
|
| | | | | | | | | | | | | | | | | |
| | | | | | | | | | | Author: | SylvainLS | | Posted: | Nov 28, 2022 12:32 | | Subject: | Re: How to buy mixed new white elements cheaply | | Viewed: | 20 times | | Topic: | Buying | |
|
| In Buying, hpoort writes:
| | […]
Good idea, but the PCC list is far from complete if you are also interested in
older parts.
Of the 16K non-patterned parts in the catalogDownload, only 7K have any PCC and
9K do not. Only 1650 of these have a PCC for White.
|
Oh yeah, I should have checked the numbers¹.
OTOH, parts with no PCC at all generaly mean old, rare and expensive.
(¹ BTW, among the parts without ‘pattern’ in their name, I count 9k with a PCC
and 7.4k without (so I think you swapped the numbers  ). And 2178 of the 9k
have a White PCC… here I don’t know where the 528 parts are.)
|
|
| | | | | |
| | | | | Author: | wildchicken13 | | Posted: | Nov 28, 2022 12:35 | | Subject: | Re: How to buy mixed new white elements cheaply | | Viewed: | 22 times | | Topic: | Buying | |
|
| In Buying, donaia writes:
| | Hello - I'm keen to buy 6 of as many white elements as I can find for an
art project, as cheaply as possible. I've searched the forum for an efficient
way to do this, but can't find anything. I'm keen to find a listing of
the cheapest new price for each element in the UK, without visiting individual
stores. Or if there is another way to do this efficiently I'm all ears. Thanks
in advance for your thoughts.
|
Make a wanted list with six of each element
|
|
|
|
|
|
United Kingdom, England
Netherlands, Groningen
France, Nouvelle-Aquitaine
USA, Illinois