Website that ranks or sorts sets according to price per piece.

[StudyAnimal]

Hi,

I am looking for a website or even a spreadsheet or something that I can use to easily sort all or some sets by price per set. Sure I could enter the information in a spreadsheet myself, but I am sure someone has done this already.

Even if it just for one theme that would be cool.

Cheers.

[legolijntje]

You can use Brickset; just click a theme in the browse page and at the top of the results, choose sort by price.

Only "disadvantage"; not all sets (especially old ones) have a price.

Edited August 27, 2012 by legolijntje

[StudyAnimal]

You can use Brickset; just click a theme in the browse page and at the top of the results, choose sort by price.

Only "disadvantage"; not all sets (especially old ones) have a price.

Hi, thanks, but unless I am doing something wrong that is sorting only by price, not price per piece. The lego shop lets me sort by price too.

To clarify I want to sort by "price per piece".

Thanks.

[davee123]

BrickSet has this functionality, but it's complex. Check out:

More... -> Advanced queries -> Advanced query builder

Unfortunately, SQL is strange. It doesn't necessarily know how to deal with NULLs, empty values, etc. Plus, BrickSet has "price-per-piece" evaluated in GBP and USD, so you'll have to decide which you want. Then, you'll have to figure out whether you want "of all time" or just "currently available" or "anything from 2012" or, whatever.

Also, I found that the SQL queries won't run unless you save them-- which means you have to be logged in. So if you don't have an account, you'll probably need to make one.

For example, I did one that was:

Price Per Piece in USD > 0

AND

Year Released = 2012

Order by Price Per Piece in USD Ascending

When I tried without the "Price Per Piece in USD > 0", I got a bunch of things that seemingly didn't have prices, which probably meant the database had NULL values, and the ordering was screwed up. Hence, you'll want to limit your query to that which HAS a valid value for "Price per piece in USD".

DaveE

[StudyAnimal]

Excellent, that worked well! Thanks a lot.