Discussion Forum: Thread 333271

 Author: 1977_mauro View Messages Posted By 1977_mauro
 Posted: Jan 13, 2023 01:37
 Subject: Most wanted list per item of one category
 Viewed: 89 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

1977_mauro (3378)

Location:  Germany, Baden-Württemberg
Member Since Contact Type Status
Feb 19, 2009 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Mauro's Revenge
Hi all,

is there a chance to get such a list?

For sure, I can have a list of one category like this one:

https://www.bricklink.com/catalogStatsWanted.asp?itemType=P&catID=5

But this list differentiates between the colors of the same item. I would need
to have this list without this differentiation.

Thanks in advance
Mauro
 Author: 1977_mauro View Messages Posted By 1977_mauro
 Posted: Jan 15, 2023 12:30
 Subject: Re: Most wanted list per item of one category
 Viewed: 34 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

1977_mauro (3378)

Location:  Germany, Baden-Württemberg
Member Since Contact Type Status
Feb 19, 2009 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Mauro's Revenge
No ideas?

In Help, 1977_mauro writes:
  Hi all,

is there a chance to get such a list?

For sure, I can have a list of one category like this one:

https://www.bricklink.com/catalogStatsWanted.asp?itemType=P&catID=5

But this list differentiates between the colors of the same item. I would need
to have this list without this differentiation.

Thanks in advance
Mauro
 Author: 1977_mauro View Messages Posted By 1977_mauro
 Posted: Jan 17, 2023 08:57
 Subject: Re: Most wanted list per item of one category
 Viewed: 30 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

1977_mauro (3378)

Location:  Germany, Baden-Württemberg
Member Since Contact Type Status
Feb 19, 2009 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Mauro's Revenge
last call...

In Help, 1977_mauro writes:
  No ideas?

In Help, 1977_mauro writes:
  Hi all,

is there a chance to get such a list?

For sure, I can have a list of one category like this one:

https://www.bricklink.com/catalogStatsWanted.asp?itemType=P&catID=5

But this list differentiates between the colors of the same item. I would need
to have this list without this differentiation.

Thanks in advance
Mauro
 Author: 1001bricks View Messages Posted By 1001bricks
 Posted: Jan 17, 2023 10:02
 Subject: Re: Most wanted list per item of one category
 Viewed: 20 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

1001bricks (52305)

Location:  France, Provence-Alpes-Côte d'Azur
Member Since Contact Type Status
Sep 6, 2005 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: 1001bricks
In Help, 1977_mauro writes:
  last call...

I don't think it's available.
But you could copy/paste this list of bricks in an Excel (or Access table) and
group by reference while adding the On Lists totals? That'd give give you
what you wish?
 Author: 1977_mauro View Messages Posted By 1977_mauro
 Posted: Jan 17, 2023 10:34
 Subject: Re: Most wanted list per item of one category
 Viewed: 28 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

1977_mauro (3378)

Location:  Germany, Baden-Württemberg
Member Since Contact Type Status
Feb 19, 2009 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Mauro's Revenge
Sure, I can do that. I am trying out to see what are the most wanted parts and
thus need most storage place.

In Help, 1001bricks writes:
  In Help, 1977_mauro writes:
  last call...

I don't think it's available.
But you could copy/paste this list of bricks in an Excel (or Access table) and
group by reference while adding the On Lists totals? That'd give give you
what you wish?
 Author: SylvainLS View Messages Posted By SylvainLS
 Posted: Jan 17, 2023 11:19
 Subject: Re: Most wanted list per item of one category
 Viewed: 18 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

SylvainLS (46)

Location:  France, Nouvelle-Aquitaine
Member Since Contact Type Status
Apr 25, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: BuyerOnly
BrickLink Discussions Moderator (?)
In Help, 1977_mauro writes:
  Sure, I can do that. I am trying out to see what are the most wanted parts and
thus need most storage place.

Hmm, there can be two reasons they are most wanted:
— they are rare, and therefore you don’t need a lot of storage place,
— they are sold as fast as the the stock is replenished, and therefore you don’t
need a lot of storage place.

On the contrary, parts that are least wanted aren’t sold and therefore accumulate
in your store and need more storage place.