Discussion Forum: Thread 318595

 Author: ccroxton View Messages Posted By ccroxton
 Posted: Mar 17, 2022 17:28
 Subject: What pieces are low or out of stock?
 Viewed: 655 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

ccroxton (178)

Location:  USA, Texas
Member Since Contact Type Status
Mar 3, 2018 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Seller Ships to My Country Store: Hill Country Bricks
Is there a query for BL to find out which parts are low stock or out of stock?
I have looked at the API, and it seems to cover a seller's own shop pretty
well, but I am talking about discovering which parts are OOS in North America
for the entire site.
 Author: tons_of_bricks View Messages Posted By tons_of_bricks
 Posted: Mar 17, 2022 17:36
 Subject: Re: What pieces are low or out of stock?
 Viewed: 97 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

tons_of_bricks (12768)

Location:  USA, Missouri
Member Since Contact Type Status
Jan 12, 2016 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Seller Ships to My Country Store: Tons of Bricks (GDM)
In Help, ccroxton writes:
  Is there a query for BL to find out which parts are low stock or out of stock?
I have looked at the API, and it seems to cover a seller's own shop pretty
well, but I am talking about discovering which parts are OOS in North America
for the entire site.

I think that would be pretty much impossible to figure out. What would be considered
low? If there was only 1000 of the basic technic pins available in the US, that
would be excruciatingly low. Yet, if there was 1000 for some of the older rarer
pieces, that would be considered quite high.
 Author: ccroxton View Messages Posted By ccroxton
 Posted: Mar 17, 2022 17:39
 Subject: Re: What pieces are low or out of stock?
 Viewed: 73 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

ccroxton (178)

Location:  USA, Texas
Member Since Contact Type Status
Mar 3, 2018 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Seller Ships to My Country Store: Hill Country Bricks
In Help, firestar246 writes:
  In Help, ccroxton writes:
  Is there a query for BL to find out which parts are low stock or out of stock?
I have looked at the API, and it seems to cover a seller's own shop pretty
well, but I am talking about discovering which parts are OOS in North America
for the entire site.

I think that would be pretty much impossible to figure out. What would be considered
low? If there was only 1000 of the basic technic pins available in the US, that
would be excruciatingly low. Yet, if there was 1000 for some of the older rarer
pieces, that would be considered quite high.

I would probably use the wanted list qty vs in stock qty. That is another issue;
BL tells you how many LOTS are offered, not the qty, because they only do qty
by color.

Even just figuring out which pieces are OOS would be an excellent starting point!
 Author: yorbrick View Messages Posted By yorbrick
 Posted: Mar 17, 2022 17:40
 Subject: Re: What pieces are low or out of stock?
 Viewed: 74 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

yorbrick (1185)

Location:  United Kingdom, England
Member Since Contact Type Status
Apr 11, 2011 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Seller Does Not Ship to My Country Store: Yorbricks
In Help, ccroxton writes:
  Is there a query for BL to find out which parts are low stock or out of stock?
I have looked at the API, and it seems to cover a seller's own shop pretty
well, but I am talking about discovering which parts are OOS in North America
for the entire site.

If that was possible and there was a source where you could buy the parts to
sell for high profits, then someone would already be doing it.
 Author: ccroxton View Messages Posted By ccroxton
 Posted: Mar 17, 2022 18:00
 Subject: Re: What pieces are low or out of stock?
 Viewed: 70 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

ccroxton (178)

Location:  USA, Texas
Member Since Contact Type Status
Mar 3, 2018 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Seller Ships to My Country Store: Hill Country Bricks
In Help, yorbrick writes:
  In Help, ccroxton writes:
  Is there a query for BL to find out which parts are low stock or out of stock?
I have looked at the API, and it seems to cover a seller's own shop pretty
well, but I am talking about discovering which parts are OOS in North America
for the entire site.

If that was possible and there was a source where you could buy the parts to
sell for high profits, then someone would already be doing it.

If you don't try, then it never will get done! Or are you saying that even
if you knew how, you would not share it?
 Author: SylvainLS View Messages Posted By SylvainLS
 Posted: Mar 17, 2022 18:11
 Subject: Re: What pieces are low or out of stock?
 Viewed: 64 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 Seller Does Not Ship to My Country Store: BuyerOnly
BrickLink Discussions Moderator (?)
In Help, ccroxton writes:
  In Help, yorbrick writes:
  In Help, ccroxton writes:
  Is there a query for BL to find out which parts are low stock or out of stock?
I have looked at the API, and it seems to cover a seller's own shop pretty
well, but I am talking about discovering which parts are OOS in North America
for the entire site.

If that was possible and there was a source where you could buy the parts to
sell for high profits, then someone would already be doing it.

If you don't try, then it never will get done! Or are you saying that even
if you knew how, you would not share it?

1. Would you share if you knew?

2. Don’t people quit more easily when they don’t know a solution exists?  So
saying there’s a solution is almost like sharing it.

3. More simply, I think Yorrick meant that if a store had all the rarer parts
for sale, it’d be known.
 Author: ccroxton View Messages Posted By ccroxton
 Posted: Mar 17, 2022 18:22
 Subject: Re: What pieces are low or out of stock?
 Viewed: 60 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

ccroxton (178)

Location:  USA, Texas
Member Since Contact Type Status
Mar 3, 2018 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Seller Ships to My Country Store: Hill Country Bricks
In Help, SylvainLS writes:
  In Help, ccroxton writes:
  In Help, yorbrick writes:
  In Help, ccroxton writes:
  Is there a query for BL to find out which parts are low stock or out of stock?
I have looked at the API, and it seems to cover a seller's own shop pretty
well, but I am talking about discovering which parts are OOS in North America
for the entire site.

If that was possible and there was a source where you could buy the parts to
sell for high profits, then someone would already be doing it.

If you don't try, then it never will get done! Or are you saying that even
if you knew how, you would not share it?

1. Would you share if you knew?

2. Don’t people quit more easily when they don’t know a solution exists?  So
saying there’s a solution is almost like sharing it.

3. More simply, I think Yorrick meant that if a store had all the rarer parts
for sale, it’d be known.

Actually, yes, I would share it!
I have always been known for wanting something that does not yet exist.
If we all quit because there was no known solution, then there would be no electricity,
car tires, or any of the 1000s of inventions over the years. Necessity is the
mother of invention!
 Author: ccroxton View Messages Posted By ccroxton
 Posted: Mar 17, 2022 18:52
 Subject: Re: What pieces are low or out of stock?
 Viewed: 48 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

ccroxton (178)

Location:  USA, Texas
Member Since Contact Type Status
Mar 3, 2018 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Seller Ships to My Country Store: Hill Country Bricks
In Help, ccroxton writes:
  In Help, SylvainLS writes:
  In Help, ccroxton writes:
  In Help, yorbrick writes:
  In Help, ccroxton writes:
  Is there a query for BL to find out which parts are low stock or out of stock?
I have looked at the API, and it seems to cover a seller's own shop pretty
well, but I am talking about discovering which parts are OOS in North America
for the entire site.

If that was possible and there was a source where you could buy the parts to
sell for high profits, then someone would already be doing it.

If you don't try, then it never will get done! Or are you saying that even
if you knew how, you would not share it?

1. Would you share if you knew?

2. Don’t people quit more easily when they don’t know a solution exists?  So
saying there’s a solution is almost like sharing it.

3. More simply, I think Yorrick meant that if a store had all the rarer parts
for sale, it’d be known.

Actually, yes, I would share it!
I have always been known for wanting something that does not yet exist.
If we all quit because there was no known solution, then there would be no electricity,
car tires, or any of the 1000s of inventions over the years. Necessity is the
mother of invention!

IF it helps anyone, https://www.bricklink.com/catalogList.asp?pg=1&catLike=W&viewWanted=Y&sortBy=N&sortAsc=A&sz=200&catType=P&v=1
returns a list of all wanted parts, in itemid order.
 Author: ccroxton View Messages Posted By ccroxton
 Posted: Mar 17, 2022 21:15
 Subject: Re: What pieces are low or out of stock?
 Viewed: 54 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

ccroxton (178)

Location:  USA, Texas
Member Since Contact Type Status
Mar 3, 2018 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Seller Ships to My Country Store: Hill Country Bricks
In Help, ccroxton writes:
  In Help, ccroxton writes:
  In Help, SylvainLS writes:
  In Help, ccroxton writes:
  In Help, yorbrick writes:
  In Help, ccroxton writes:
  Is there a query for BL to find out which parts are low stock or out of stock?
I have looked at the API, and it seems to cover a seller's own shop pretty
well, but I am talking about discovering which parts are OOS in North America
for the entire site.

If that was possible and there was a source where you could buy the parts to
sell for high profits, then someone would already be doing it.

If you don't try, then it never will get done! Or are you saying that even
if you knew how, you would not share it?

1. Would you share if you knew?

2. Don’t people quit more easily when they don’t know a solution exists?  So
saying there’s a solution is almost like sharing it.

3. More simply, I think Yorrick meant that if a store had all the rarer parts
for sale, it’d be known.

Actually, yes, I would share it!
I have always been known for wanting something that does not yet exist.
If we all quit because there was no known solution, then there would be no electricity,
car tires, or any of the 1000s of inventions over the years. Necessity is the
mother of invention!

IF it helps anyone, https://www.bricklink.com/catalogList.asp?pg=1&catLike=W&viewWanted=Y&sortBy=N&sortAsc=A&sz=200&catType=P&v=1
returns a list of all wanted parts, in itemid order.

See https://brickset.com/parts/platform-System/page-20 for a list of each system
part, with each color, picture, and how many sets it was used in. Rarity does
not seem to equate to value; rather the demand for the part. 41855 in yellow
only appeared in 7 sets, but is also only woth abt 4c!
 Author: SylvainLS View Messages Posted By SylvainLS
 Posted: Mar 17, 2022 19:00
 Subject: Re: What pieces are low or out of stock?
 Viewed: 57 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 Seller Does Not Ship to My Country Store: BuyerOnly
BrickLink Discussions Moderator (?)
In Help, ccroxton writes:
  […]
  1. Would you share if you knew?

2. Don’t people quit more easily when they don’t know a solution exists?  So
saying there’s a solution is almost like sharing it.

3. More simply, I think Yorrick meant that if a store had all the rarer parts
for sale, it’d be known.

Sorry Yorbrick, the B fell somehow….


  Actually, yes, I would share it!
I have always been known for wanting something that does not yet exist.
If we all quit because there was no known solution, then there would be no electricity,
car tires, or any of the 1000s of inventions over the years. Necessity is the
mother of invention!

We aren’t talking about inventing something, we’re talking about a way to identify
rare LEGO pieces and a supply source for them.  Not a world changing feat


Say you have a list of the rarer parts.  What do you do with it?
If it’s not to grab them, when people don’t yet know they are rare, to resell
at a higher price, what’s the purpose?
Is it for collecting them “only”?  (Quote marks because collecting is giving
value to what you own.  Not necessarily resale value for you… at first.)

If you have a supply for them, why would you share it?  So that your competitors
(other sellers or other collectors) can grab them before you?
That’s very altruistic but not very effective for your own purposes.

And if you have the list but no supply, then what do you have?  A list of parts
to watch for.  And again why would you share it with your competitors?


Now, if you want the list just for the sake of having the list, you can compile
it yourself with a little patience: visit all the parts/sets/gears in the catalogue
one by one and see if there’s stock to match the demand….
 Author: ccroxton View Messages Posted By ccroxton
 Posted: Mar 17, 2022 19:24
 Subject: Re: What pieces are low or out of stock?
 Viewed: 56 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

ccroxton (178)

Location:  USA, Texas
Member Since Contact Type Status
Mar 3, 2018 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Seller Ships to My Country Store: Hill Country Bricks
In Help, SylvainLS writes:
  In Help, ccroxton writes:
  […]
  1. Would you share if you knew?

2. Don’t people quit more easily when they don’t know a solution exists?  So
saying there’s a solution is almost like sharing it.

3. More simply, I think Yorrick meant that if a store had all the rarer parts
for sale, it’d be known.

Sorry Yorbrick, the B fell somehow….


  Actually, yes, I would share it!
I have always been known for wanting something that does not yet exist.
If we all quit because there was no known solution, then there would be no electricity,
car tires, or any of the 1000s of inventions over the years. Necessity is the
mother of invention!

We aren’t talking about inventing something, we’re talking about a way to identify
rare LEGO pieces and a supply source for them.  Not a world changing feat


Say you have a list of the rarer parts.  What do you do with it?
If it’s not to grab them, when people don’t yet know they are rare, to resell
at a higher price, what’s the purpose?
Is it for collecting them “only”?  (Quote marks because collecting is giving
value to what you own.  Not necessarily resale value for you… at first.)

If you have a supply for them, why would you share it?  So that your competitors
(other sellers or other collectors) can grab them before you?
That’s very altruistic but not very effective for your own purposes.

And if you have the list but no supply, then what do you have?  A list of parts
to watch for.  And again why would you share it with your competitors?


Now, if you want the list just for the sake of having the list, you can compile
it yourself with a little patience: visit all the parts/sets/gears in the catalogue
one by one and see if there’s stock to match the demand….

There is no way anyone has that kind of time! I don't know about you guys,
but I am not out to corner the market. And I believe in helping others. I can't
count the number of people I taught, over the phone, to use the internet. It
is so basic to us now, but back then, you actually had to type the entire URL,
or you got a 404. http://www.ford.com Now all you have to do is type Ford in
the URL bar and almost every browser in modern use will pull up the Ford website.

I did not expect a bunch of snarky comments, and I don't want to continue
this discussion.
 Author: SylvainLS View Messages Posted By SylvainLS
 Posted: Mar 17, 2022 20:40
 Subject: Re: What pieces are low or out of stock?
 Viewed: 52 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 Seller Does Not Ship to My Country Store: BuyerOnly
BrickLink Discussions Moderator (?)
In Help, ccroxton writes:
  […]
There is no way anyone has that kind of time! I don't know about you guys,
but I am not out to corner the market. And I believe in helping others. I can't
count the number of people I taught, over the phone, to use the internet. It
is so basic to us now, but back then, you actually had to type the entire URL,
or you got a 404. http://www.ford.com Now all you have to do is type Ford in
the URL bar and almost every browser in modern use will pull up the Ford website.

I did not expect a bunch of snarky comments, and I don't want to continue
this discussion.

None of that was snarky and it’s not about not helping others.  On the contrary,
we tried to explain to you why it’s not easy to compile such a general list,
and why it’s not available.

Apparently, from another post of yours, you have lots of old parts to sort. 
From that, I suppose that you want to have a handy short list of rare parts to
search for in your bulk to pick them first.
Well, I’ve another bad news that you’ll take as a snarky comment: it wouldn’t
be efficient.

1. What are the chances you have the rarest pieces?  By definition, they are
rare, why would you have more of them than the other sellers, some of them having
a much much bigger stock than you?
2. You need to sort your parts anyway (digging 10 times in a big pile of bricks
for the 10 rarest parts would take more time than sorting the big pile first). 
While doing that, you can check their prices and stocks on BL.
3. Once you’ve sorted your parts, you’ve already increased their value, even
if you sell them in bulk.
 Author: ccroxton View Messages Posted By ccroxton
 Posted: Mar 17, 2022 21:29
 Subject: Re: What pieces are low or out of stock?
 Viewed: 80 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

ccroxton (178)

Location:  USA, Texas
Member Since Contact Type Status
Mar 3, 2018 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Seller Ships to My Country Store: Hill Country Bricks
In Help, SylvainLS writes:
  In Help, ccroxton writes:
  […]
There is no way anyone has that kind of time! I don't know about you guys,
but I am not out to corner the market. And I believe in helping others. I can't
count the number of people I taught, over the phone, to use the internet. It
is so basic to us now, but back then, you actually had to type the entire URL,
or you got a 404. http://www.ford.com Now all you have to do is type Ford in
the URL bar and almost every browser in modern use will pull up the Ford website.

I did not expect a bunch of snarky comments, and I don't want to continue
this discussion.

None of that was snarky and it’s not about not helping others.  On the contrary,
we tried to explain to you why it’s not easy to compile such a general list,
and why it’s not available.

Apparently, from another post of yours, you have lots of old parts to sort. 
From that, I suppose that you want to have a handy short list of rare parts to
search for in your bulk to pick them first.
Well, I’ve another bad news that you’ll take as a snarky comment: it wouldn’t
be efficient.

1. What are the chances you have the rarest pieces?  By definition, they are
rare, why would you have more of them than the other sellers, some of them having
a much much bigger stock than you?
2. You need to sort your parts anyway (digging 10 times in a big pile of bricks
for the 10 rarest parts would take more time than sorting the big pile first). 
While doing that, you can check their prices and stocks on BL.
3. Once you’ve sorted your parts, you’ve already increased their value, even
if you sell them in bulk.

I understand your thought process, but you do not understand mine.
The question was simply, HOW does one do this? Not, WHY should one do this!

As far as sorting tubs of Lego, I have developed a system that allows me to sort
a shoebox full of parts in under 5 minutes, so a 50 pound tub takes about 4-5
hours. Getting them listed is a whole nother problem! Yes, I have looked at spreadsheet
uploads, and the fact that BL combines itemid for many different part numbers
makes that almost impossible for me. I do not think like most people, and I have
accepted my handicap.
 Author: starbeanie View Messages Posted By starbeanie
 Posted: Mar 17, 2022 22:02
 Subject: Re: What pieces are low or out of stock?
 Viewed: 68 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

starbeanie (10842)

Location:  USA, Virginia
Member Since Contact Type Status
Jan 23, 2004 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Seller Ships to My Country Store: Starbeanie's Bricks
HOW does one do this?
Create a SQl Database, write a software program in C#, and hand tweak the values
for:

"What would be considered low? If there was only 1000 of the basic technic pins
available in the US, that would be excruciatingly low. Yet, if there was 1000
for some of the older rarer pieces, that would be considered quite high."

This last part taking a long time and personal knowledge/bias. So consider just
limiting it to certain categories instead of everything.

It is doable and can be done. But the hundreds of hours spent developing it probably
is not worth the possible monetary gain.



Regarding inventory upload, I would recommend Brickstore.



In Help, ccroxton writes:
  In Help, SylvainLS writes:
  In Help, ccroxton writes:
  […]
There is no way anyone has that kind of time! I don't know about you guys,
but I am not out to corner the market. And I believe in helping others. I can't
count the number of people I taught, over the phone, to use the internet. It
is so basic to us now, but back then, you actually had to type the entire URL,
or you got a 404. http://www.ford.com Now all you have to do is type Ford in
the URL bar and almost every browser in modern use will pull up the Ford website.

I did not expect a bunch of snarky comments, and I don't want to continue
this discussion.

None of that was snarky and it’s not about not helping others.  On the contrary,
we tried to explain to you why it’s not easy to compile such a general list,
and why it’s not available.

Apparently, from another post of yours, you have lots of old parts to sort. 
From that, I suppose that you want to have a handy short list of rare parts to
search for in your bulk to pick them first.
Well, I’ve another bad news that you’ll take as a snarky comment: it wouldn’t
be efficient.

1. What are the chances you have the rarest pieces?  By definition, they are
rare, why would you have more of them than the other sellers, some of them having
a much much bigger stock than you?
2. You need to sort your parts anyway (digging 10 times in a big pile of bricks
for the 10 rarest parts would take more time than sorting the big pile first). 
While doing that, you can check their prices and stocks on BL.
3. Once you’ve sorted your parts, you’ve already increased their value, even
if you sell them in bulk.

I understand your thought process, but you do not understand mine.
The question was simply, HOW does one do this? Not, WHY should one do this!

As far as sorting tubs of Lego, I have developed a system that allows me to sort
a shoebox full of parts in under 5 minutes, so a 50 pound tub takes about 4-5
hours. Getting them listed is a whole nother problem! Yes, I have looked at spreadsheet
uploads, and the fact that BL combines itemid for many different part numbers
makes that almost impossible for me. I do not think like most people, and I have
accepted my handicap.
 Author: Shiny_Stuff View Messages Posted By Shiny_Stuff
 Posted: Mar 17, 2022 23:17
 Subject: Re: What pieces are low or out of stock?
 Viewed: 84 times
 Topic: Selling
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Shiny_Stuff (1288)

Location:  USA, New York
Member Since Contact Type Status
Aug 14, 2016 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Seller Ships to My Country Store: Shiny Stuff
In Help, starbeanie writes:
  HOW does one do this?
Create a SQl Database, write a software program in C#, and hand tweak the values
for:

"What would be considered low? If there was only 1000 of the basic technic pins
available in the US, that would be excruciatingly low. Yet, if there was 1000
for some of the older rarer pieces, that would be considered quite high."

This last part taking a long time and personal knowledge/bias. So consider just
limiting it to certain categories instead of everything.

It is doable and can be done. But the hundreds of hours spent developing it probably
is not worth the possible monetary gain.


I suspect very strongly that there are a handful of BL shops that DO make use
of such custom designed software. Especially one well-known BL shop based in
Portugal and possibly other shops located in Germany.

Some BL shops do nearly as much buying as selling, with the goal of obtaining
inventory to re-list for more money. Those are the ones that likely use software
to determine what to purchase.

I will even admit to doing that, too, as do many many BL sellers here. I do
not have any fancy software; I generally just focus on a few items that I think
will be good items to have in my inventory and that I can resell for more money
-- sometimes the gain is only a few pennies (example: buy for 3 cents and
re-list in my shop for 8 cents), but other times the potential gain is much higher.


BL sellers buying from other sellers with the intent to resell has been happening
since BrickLink began. So much of the same money on BrickLink recirculates over
and over among sellers, but hopefully, in the end, it benefits the final buyers
by having more stock available in a single shop. It also benefits BL in the
fees collected more than once on the exact same items.

____
 Author: wildchicken13 View Messages Posted By wildchicken13
 Posted: Mar 18, 2022 01:12
 Subject: Re: What pieces are low or out of stock?
 Viewed: 86 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

wildchicken13 (876)

Location:  USA, Illinois
Member Since Contact Type Status
Aug 11, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Seller Ships to My Country Store: Wild Chicken
In Help, starbeanie writes:
  HOW does one do this?
Create a SQl Database, write a software program in C#, and hand tweak the values
for:

"What would be considered low? If there was only 1000 of the basic technic pins
available in the US, that would be excruciatingly low. Yet, if there was 1000
for some of the older rarer pieces, that would be considered quite high."

This last part taking a long time and personal knowledge/bias. So consider just
limiting it to certain categories instead of everything.

That sounds like a fun project actually. Devise some sort of "rarity index" for
measuring the rarity of a particular part. A simple example would be the average
price divided by the total quantity. For example,

 
Part No: 2780  Name: Technic, Pin with Short Friction Ridges
* 
2780 Technic, Pin with Short Friction Ridges
Parts: Technic, Pin {Black}

Average Price = $0.0266
Total Quantity = 9,818,544
Rarity Index = 0.0000000027

 
Minifig No: sw0107  Name: Boba Fett (Cloud City - Printed Arms & Legs)
* 
sw0107 (Inv) Boba Fett (Cloud City - Printed Arms & Legs)
Minifigures: Star Wars: Star Wars Episode 4/5/6

Average Price = $3,641.2343
Total Quantity = 6
Rarity Index = 606.87

 
Gear No: goldbrick  Name: 14 Karat Gold Brick
* 
goldbrick 14 Karat Gold Brick
Gear: Decoration

Average Price = Undefined
Total Quantity = 0
Rarity Index = Undefined

With more sophistication, you could also take into account the years that a part
was produced, but this is just a simple example.
 Author: 1001bricks View Messages Posted By 1001bricks
 Posted: Mar 17, 2022 22:31
 Subject: Re: What pieces are low or out of stock?
 Viewed: 53 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

1001bricks (52387)

Location:  France, Provence-Alpes-Côte d'Azur
Member Since Contact Type Status
Sep 6, 2005 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Seller Ships to My Country Store: 1001bricks
  I understand your thought process, but you do not understand mine.
The question was simply, HOW does one do this? Not, WHY should one do this!

How ???

There's maybe a handful of people that may do approximately what you're
talking about.
But none will ever tell you how - that's obvious!

But this doesn't mean it helps them in any way.
If it's for selling - I think there are far easier strategies and tactics.
Like heavy a ton of cash hee hee

But you CAN do this list.

Download BrickStore, free and open-source.
Learn how to use it, make lists of parts that have the highest prices (usualy
reveals the rarity).

Use filters, play, try your ideas, and do make this list - for whatever reason
you have.
But it probably won't help you, see above.

But again BrickLink cannot provide such list, because, it basically has no really
(universal) meaning.

HTH?
 Author: wildchicken13 View Messages Posted By wildchicken13
 Posted: Mar 18, 2022 00:44
 Subject: Re: What pieces are low or out of stock?
 Viewed: 58 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

wildchicken13 (876)

Location:  USA, Illinois
Member Since Contact Type Status
Aug 11, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Seller Ships to My Country Store: Wild Chicken
In Help, ccroxton writes:
  I understand your thought process, but you do not understand mine.
The question was simply, HOW does one do this? Not, WHY should one do this!

Ah, but you see, the why is more important than the how.

I have no doubt that it is possible to compile a list of all of the rare and/or
expensive parts on BrickLink. I will get you started:

 
Part No: 95342pb01  Name: Chicken, Narrow Base with Black Eyes and Red Comb and Wattle Pattern
* 
95342pb01 Chicken, Narrow Base with Black Eyes and Red Comb and Wattle Pattern
Parts: Animal, Land {Tan}
 
Part No: 6588  Name: Technic, Gearbox 2 x 4 x 3 1/3
* 
6588 Technic, Gearbox 2 x 4 x 3 1/3
Parts: Technic, Gear {Red}
 
Part No: 84599  Name: Electric 9V Battery Box Power Functions (Rechargeable) with Dark Bluish Gray Bottom
* 
84599 Electric 9V Battery Box Power Functions (Rechargeable) with Dark Bluish Gray Bottom
Parts: Electric, Battery Box {Light Bluish Gray}
 
Part No: 3063  Name: Brick, Round Corner 2 x 2 Macaroni with Stud Notch
* 
3063 Brick, Round Corner 2 x 2 Macaroni with Stud Notch
Parts: Brick, Round {Trans-Clear}
 
Part No: 2878c02  Name: Train Wheel RC, Holder with 2 Black Train Wheel RC Train and Chrome Silver Train Wheel RC Train, Metal Axle (2878 / 57878 / x1687)
* 
2878c02 (Inv) Train Wheel RC, Holder with 2 Black Train Wheel RC Train and Chrome Silver Train Wheel RC Train, Metal Axle (2878 / 57878 / x1687)
Parts: Wheel {Light Bluish Gray}
 
Part No: 2871b  Name: Train Motor 9V Decorative Side with Open Hub Points (fits RC Train Motor) - Stepped Ends
* 
2871b Train Motor 9V Decorative Side with Open Hub Points (fits RC Train Motor) - Stepped Ends
Parts: Train {Light Bluish Gray}
 
Part No: 4025  Name: Train Bogie Plate (Tile, Modified 6 x 4 with 5mm Pin)
* 
4025 Train Bogie Plate (Tile, Modified 6 x 4 with 5mm Pin)
Parts: Train {Black}
 
Part No: 2920  Name: Train Coupling
* 
2920 Train Coupling
Parts: Train {Black}
 
Part No: 73092  Name: Magnet Cylindrical
* 
73092 Magnet Cylindrical
Parts: Magnet {Black}
 
Part No: 2377  Name: Window 1 x 2 x 2 Plane
* 
2377 Window 1 x 2 x 2 Plane
Parts: Window {Light Bluish Gray}
 
Part No: 4862  Name: Glass for Window 1 x 2 x 2 Plane
* 
4862 Glass for Window 1 x 2 x 2 Plane
Parts: Window, Glass & Shutter {Trans-Clear}
 
Part No: 4036  Name: Glass for Train Window 1 x 2 x 3
* 
4036 Glass for Train Window 1 x 2 x 3
Parts: Window, Glass & Shutter {Trans-Brown (Old Trans-Black)}
 
Part No: 6567c01  Name: Windscreen 2 x 6 x 2 Train with Fixed Trans-Clear Glass
* 
6567c01 Windscreen 2 x 6 x 2 Train with Fixed Trans-Clear Glass
Parts: Windscreen {Red}
 
Part No: 4185  Name: Technic Wedge Belt Wheel (Pulley)
* 
4185 Technic Wedge Belt Wheel (Pulley)
Parts: Wheel {Red}
 
Part No: 30663  Name: Vehicle, Steering Wheel Small, 2 Studs Diameter
* 
30663 Vehicle, Steering Wheel Small, 2 Studs Diameter
Parts: Vehicle {Yellow}
 
Part No: 30373  Name: Slope, Inverted 65 6 x 6 x 2 Quad with Cutouts
* 
30373 Slope, Inverted 65 6 x 6 x 2 Quad with Cutouts
Parts: Slope, Inverted {White}
 
Part No: 33078  Name: Hot Dog / Sausage
* 
33078 Hot Dog / Sausage
Parts: Food & Drink {Nougat}

But I struggle to understand why anyone would want to do such a thing. Sure,
there are stores that specialize in rare parts:

https://store.bricklink.com/MMillere
https://store.bricklink.com/Give.Me.A.Brick

But it is not a super profitable endeavor and it requires holding onto inventory
for years, possibly decades, in order for it to appreciate by an appreciable
amount.

Furthermore, as others have mentioned, they are probably not willing to share
their secrets. Most BrickLink sellers won't even say where they get their
parts from. So do not expect much help from the forum.

Sorry.
 Author: WildBricks View Messages Posted By WildBricks
 Posted: Mar 18, 2022 09:18
 Subject: Re: What pieces are low or out of stock?
 Viewed: 57 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

WildBricks (6346)

Location:  USA, Georgia
Member Since Contact Type Status
May 9, 2016 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Seller Ships to My Country Store: Wild Bricks GA
  I do not think like most people, and I have accepted my handicap.

Thinking differently is NOT a handicap! (My hubby is an INTP personality type.)

Your question has a lot of merit. It's one of those things that would be
a very useful SELLER'S TOOL. We should be able to use the data available
to help us streamline our inventory towards our specific niche. This is the exact
sort of information that makes companies successful.

Don't let the haters and the trolls knock you down. We need people who look
at the world in a different way. It's how society moves forward and makes
discoveries.
 Author: wildchicken13 View Messages Posted By wildchicken13
 Posted: Mar 18, 2022 09:51
 Subject: Re: What pieces are low or out of stock?
 Viewed: 39 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

wildchicken13 (876)

Location:  USA, Illinois
Member Since Contact Type Status
Aug 11, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Seller Ships to My Country Store: Wild Chicken
In Help, WildBricks writes:
  
  I do not think like most people, and I have accepted my handicap.

Thinking differently is NOT a handicap! (My hubby is an INTP personality type.)

Your question has a lot of merit. It's one of those things that would be
a very useful SELLER'S TOOL. We should be able to use the data available
to help us streamline our inventory towards our specific niche. This is the exact
sort of information that makes companies successful.

Don't let the haters and the trolls knock you down. We need people who look
at the world in a different way. It's how society moves forward and makes
discoveries.

I have never used it before, but I imagine that this would not be terribly difficult
to do using the BrickLink API. Don't expect BrickLink to release its advanced
"seller tools" anytime soon. Call me complacent if you will, but one of the things
I have learned over the years is the you cannot expect BrickLink to do anything.
 Author: yorbrick View Messages Posted By yorbrick
 Posted: Mar 18, 2022 09:54
 Subject: Re: What pieces are low or out of stock?
 Viewed: 41 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

yorbrick (1185)

Location:  United Kingdom, England
Member Since Contact Type Status
Apr 11, 2011 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Seller Does Not Ship to My Country Store: Yorbricks
  Your question has a lot of merit. It's one of those things that would be
a very useful SELLER'S TOOL. We should be able to use the data available
to help us streamline our inventory towards our specific niche. This is the exact
sort of information that makes companies successful.

If it is your niche then presumably you already have some expertise in it and
have an advantage over other pickers because of that expertise. If such a tool
existed, it would be available to everyone. Your niche becomes everyone's
area of expertise at the press of a button and the advantage due to knowledge
is gone.

Just search for "BOLO reseller" on youtube and there are many people hearing
about specific items (be on look out) that they have little knowledge of, except
that they are valuable. Fortunately it hasn't really got to LEGO parts yet
and there is still work required in finding specific valuable LEGO parts in a
plastic haystack, but has already occurred in LEGO sets that are easier to flip.
 Author: wildchicken13 View Messages Posted By wildchicken13
 Posted: Mar 18, 2022 10:06
 Subject: Re: What pieces are low or out of stock?
 Viewed: 55 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

wildchicken13 (876)

Location:  USA, Illinois
Member Since Contact Type Status
Aug 11, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Seller Ships to My Country Store: Wild Chicken
In Help, yorbrick writes:
  
  Your question has a lot of merit. It's one of those things that would be
a very useful SELLER'S TOOL. We should be able to use the data available
to help us streamline our inventory towards our specific niche. This is the exact
sort of information that makes companies successful.

If it is your niche then presumably you already have some expertise in it and
have an advantage over other pickers because of that expertise. If such a tool
existed, it would be available to everyone. Your niche becomes everyone's
area of expertise at the press of a button and the advantage due to knowledge
is gone.

Just search for "BOLO reseller" on youtube and there are many people hearing
about specific items (be on look out) that they have little knowledge of, except
that they are valuable. Fortunately it hasn't really got to LEGO parts yet
and there is still work required in finding specific valuable LEGO parts in a
plastic haystack, but has already occurred in LEGO sets that are easier to flip.

I think this is true of the stock market as well. There is an advantage in receiving
information before everyone else does. That is the reason why some trading companies
move their headquarters to be closer to the stock exchange. The microsecond advantage
gained by being closer to the exchange can translate into significant profits.

For this situation, I blame the French: https://youtu.be/cPeVsniB7b0

However, the idea is not really new, only the technology used to carry it out.
 Author: 1001bricks View Messages Posted By 1001bricks
 Posted: Mar 18, 2022 11:30
 Subject: Re: What pieces are low or out of stock?
 Viewed: 44 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

1001bricks (52387)

Location:  France, Provence-Alpes-Côte d'Azur
Member Since Contact Type Status
Sep 6, 2005 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Seller Ships to My Country Store: 1001bricks
  For this situation, I blame the French: https://youtu.be/cPeVsniB7b0

You're lucky I don't talk to BrickLink Certified Professional Forum Trolls!
 Author: 1001bricks View Messages Posted By 1001bricks
 Posted: Mar 18, 2022 11:22
 Subject: Re: What pieces are low or out of stock?
 Viewed: 45 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

1001bricks (52387)

Location:  France, Provence-Alpes-Côte d'Azur
Member Since Contact Type Status
Sep 6, 2005 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Seller Ships to My Country Store: 1001bricks
  Don't let the haters and the trolls knock you down. We need people who look
at the world in a different way. It's how society moves forward and makes
discoveries.


Again - this list CAN be done by ANY, with THEIR own criteria and objectives.

A generic list wouldn't be of any help.

So yes, people wishing it should do it, without complaining it doesn't exist.
I agree with you on this
 Author: popsicle View Messages Posted By popsicle
 Posted: Mar 18, 2022 12:47
 Subject: Re: What pieces are low or out of stock?
 Viewed: 108 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

popsicle (6664)

Location:  USA, Washington
Member Since Contact Type Status
Feb 21, 2006 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Seller Ships to My Country Store: ConstrucToys
In Help, WildBricks writes:
  
  I do not think like most people, and I have accepted my handicap.

Thinking differently is NOT a handicap! (My hubby is an INTP personality type.)

Your question has a lot of merit. It's one of those things that would be
a very useful SELLER'S TOOL. We should be able to use the data available
to help us streamline our inventory towards our specific niche. This is the exact
sort of information that makes companies successful.

It is a good question that does have merit. Such a tool would obviously be “very
useful” to resellers among others. But this info is out there to be had, for
anyone willing to do the work. That there's not such a lazy man’s
tool here, helps to distinguish vendors and that’s a good thing. In other words,
those that put in the time and effort (including with the most valuable of business
assets, information) will excel.

Personally, I feel it’s just another in a longline of ideas designed to make
our lives easier, though subsequently also promote our laziness-of-mind. E.g.
tell me what to do (I’ll just do that) - level the playing field (competing
is too daunting)
- and imho, the most deleterious of these: tell me the facts
(so I know what to think and how to react)

A utilitarian albeit unwise tool, if realized.

  
Don't let the haters and the trolls knock you down. We need people who look
at the world in a different way. It's how society moves forward and makes
discoveries.

Well said
 Author: eileenkeeney View Messages Posted By eileenkeeney
 Posted: Mar 18, 2022 14:38
 Subject: Re: What pieces are low or out of stock?
 Viewed: 61 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

eileenkeeney (1610)

Location:  USA, Oregon
Member Since Contact Type Status
Oct 4, 2010 Contact Member Buyer
Buying Privileges - OK
In Help, ccroxton writes:
   I do not think like most people, and I have
accepted my handicap.

I might have a similar "handicap" although I don't consider mine a "handicap"
but actually a useful attribute. Once I found the right career it served me
well.

I think it is possible, but it would take a lot of work to set up, and the value
of the results may not be worth the effort to automate the process.
 Author: peregrinator View Messages Posted By peregrinator
 Posted: Mar 17, 2022 20:57
 Subject: Re: What pieces are low or out of stock?
 Viewed: 52 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

peregrinator (776)

Location:  USA, New Jersey
Member Since Contact Type Status
Jan 21, 2003 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Seller Ships to My Country Store: Faber Family Bricks
In Help, SylvainLS writes:
  Sorry Yorbrick, the B fell somehow….

Alas poor Yorbrick! I knew him, Horatio...
 Author: SylvainLS View Messages Posted By SylvainLS
 Posted: Mar 17, 2022 21:05
 Subject: Re: What pieces are low or out of stock?
 Viewed: 44 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 Seller Does Not Ship to My Country Store: BuyerOnly
BrickLink Discussions Moderator (?)
In Help, peregrinator writes:
  In Help, SylvainLS writes:
  Sorry Yorbrick, the B fell somehow….

Alas poor Yorbrick! I knew him, Horatio...

One B or no B, that is the question
 Author: yorbrick View Messages Posted By yorbrick
 Posted: Mar 18, 2022 05:45
 Subject: Re: What pieces are low or out of stock?
 Viewed: 49 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

yorbrick (1185)

Location:  United Kingdom, England
Member Since Contact Type Status
Apr 11, 2011 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Seller Does Not Ship to My Country Store: Yorbricks
In Help, ccroxton writes:
  In Help, yorbrick writes:
  In Help, ccroxton writes:
  Is there a query for BL to find out which parts are low stock or out of stock?
I have looked at the API, and it seems to cover a seller's own shop pretty
well, but I am talking about discovering which parts are OOS in North America
for the entire site.

If that was possible and there was a source where you could buy the parts to
sell for high profits, then someone would already be doing it.

If you don't try, then it never will get done! Or are you saying that even
if you knew how, you would not share it?

I know which parts I can buy, I know which are valuable and I know which are
worth picking up.

In a lot of buy to sell situations, it used to be that knowledge was useful,
whether it is lego, other toys, video games, DVDs, furniture. As soon as widely
available solutions exist to find out what something is worth or what is worth
picking up, those items disappear very quickly if priced low enough as people
without any knowledge can quickly scan a barcode or image search in place of
knowledge, and every with the tool is an expert at everything.
 Author: Elkenwood View Messages Posted By Elkenwood
 Posted: Mar 17, 2022 19:00
 Subject: Re: What pieces are low or out of stock?
 Viewed: 71 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Elkenwood (174)

Location:  Canada, Saskatchewan
Member Since Contact Type Status
Jun 28, 2013 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Seller Ships to My Country Store: Rocket V8 Bricks
In Help, ccroxton writes:
  Is there a query for BL to find out which parts are low stock or out of stock?
I have looked at the API, and it seems to cover a seller's own shop pretty
well, but I am talking about discovering which parts are OOS in North America
for the entire site.

As others have said, low stock is relative to the specific piece.

A good place to look for what's desirable is by searching the wanted list
statistics:
https://www.bricklink.com/catalogStatsWanted.asp?itemType=M

In terms of just general parts, dark & light blueish gray sells extremely well
because it's used a lot in mocs and purchasable instructions; castles, city,
star wars, military, landscaping, etc.

Stock on a lot of vintage items is getting bare too. Most sellers don't want
to go through the ordeal of sorting through bulk, used vintage lots, most just
like to part new things out. Depends if you have the patience for that though.
 Author: ccroxton View Messages Posted By ccroxton
 Posted: Mar 17, 2022 19:19
 Subject: Re: What pieces are low or out of stock?
 Viewed: 57 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

ccroxton (178)

Location:  USA, Texas
Member Since Contact Type Status
Mar 3, 2018 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Seller Ships to My Country Store: Hill Country Bricks
In Help, Elkenwood writes:
  In Help, ccroxton writes:
  Is there a query for BL to find out which parts are low stock or out of stock?
I have looked at the API, and it seems to cover a seller's own shop pretty
well, but I am talking about discovering which parts are OOS in North America
for the entire site.

As others have said, low stock is relative to the specific piece.

A good place to look for what's desirable is by searching the wanted list
statistics:
https://www.bricklink.com/catalogStatsWanted.asp?itemType=M

In terms of just general parts, dark & light blueish gray sells extremely well
because it's used a lot in mocs and purchasable instructions; castles, city,
star wars, military, landscaping, etc.

Stock on a lot of vintage items is getting bare too. Most sellers don't want
to go through the ordeal of sorting through bulk, used vintage lots, most just
like to part new things out. Depends if you have the patience for that though.

Thank you for the helpful answer! I have almost 2000 pounds of used bricks to
sort! SO far I have pulled about 30 pounds of parts made before 1980, but I have
not listed them yet.
 Author: 1001bricks View Messages Posted By 1001bricks
 Posted: Mar 17, 2022 19:52
 Subject: Re: What pieces are low or out of stock?
 Viewed: 55 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

1001bricks (52387)

Location:  France, Provence-Alpes-Côte d'Azur
Member Since Contact Type Status
Sep 6, 2005 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Seller Ships to My Country Store: 1001bricks
  Thank you for the helpful answer! I have almost 2000 pounds of used bricks to
sort! SO far I have pulled about 30 pounds of parts made before 1980, but I have
not listed them yet.

Then I'd recommend you to start the shop opening process now as it
can take 3/4 weeks
 Author: i_r_on View Messages Posted By i_r_on
 Posted: Mar 18, 2022 10:48
 Subject: Re: What pieces are low or out of stock?
 Viewed: 47 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

i_r_on (415)

Location:  Turkey
Member Since Contact Type Status
Sep 14, 2020 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Seller Ships to My Country Store: ironbrickempire
In Help, ccroxton writes:
  Is there a query for BL to find out which parts are low stock or out of stock?
I have looked at the API, and it seems to cover a seller's own shop pretty
well, but I am talking about discovering which parts are OOS in North America
for the entire site.

Answer to the question "What will be rare" is much more valuable I think, given
the data an AI may give the answer to that question with a certain degree of
success. In the end it's the Lego that decides if there will be any production
to certain part or not.