Discussion Forum: Thread 322197

 Author: CSC View Messages Posted By CSC
 Posted: Jun 7, 2022 20:46
 Subject: Check wanted list against my inventory
 Viewed: 64 times
 Topic: Wanted
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

CSC (729)

Location:  USA, Washington
Member Since Contact Type Status
Feb 5, 2021 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Not Just Collectibles
Is there a way to check which parts I already have that are on my wanted list?

Thanks
 Author: 1001bricks View Messages Posted By 1001bricks
 Posted: Jun 7, 2022 20:48
 Subject: Re: Check wanted list against my inventory
 Viewed: 32 times
 Topic: Wanted
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

1001bricks (52490)

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 Wanted, CSC writes:
  Is there a way to check which parts I already have that are on my wanted list?

You can also do this using BrickStore
 Author: CSC View Messages Posted By CSC
 Posted: Jun 7, 2022 20:52
 Subject: Re: Check wanted list against my inventory
 Viewed: 33 times
 Topic: Wanted
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

CSC (729)

Location:  USA, Washington
Member Since Contact Type Status
Feb 5, 2021 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Not Just Collectibles
In Wanted, 1001bricks writes:
  In Wanted, CSC writes:
  Is there a way to check which parts I already have that are on my wanted list?

You can also do this using BrickStore

Merci beaucoup, that worked.
 Author: Akir View Messages Posted By Akir
 Posted: Jun 8, 2022 11:13
 Subject: Re: Check wanted list against my inventory
 Viewed: 27 times
 Topic: Wanted
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Akir (123)

Location:  Austria, Steiermark
Member Since Contact Type Status
Dec 28, 2020 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Some Old Bricks
In Wanted, 1001bricks writes:
  In Wanted, CSC writes:
  Is there a way to check which parts I already have that are on my wanted list?

You can also do this using BrickStore

How exactly do you do that? I guess you can subtract one (wanted) list from another
(inventory) list and check which parts don't go into the negative numbers,
but that seems clumsy to me - is there an easier way?
 Author: 1001bricks View Messages Posted By 1001bricks
 Posted: Jun 8, 2022 11:15
 Subject: Re: Check wanted list against my inventory
 Viewed: 25 times
 Topic: Wanted
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

1001bricks (52490)

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 Wanted, stearns writes:
  In Wanted, 1001bricks writes:
  In Wanted, CSC writes:
  Is there a way to check which parts I already have that are on my wanted list?

You can also do this using BrickStore

How exactly do you do that? I guess you can subtract one (wanted) list from another
(inventory) list and check which parts don't go into the negative numbers,
but that seems clumsy to me - is there an easier way?

You remove from your Wanted-List all your shop.

In your WL, the lots with numbers zero or negative are to be deleted.
Just sort by Qty, delete all this.

In short, it takes 2 or 3 clicks to do the whole.
 Author: Akir View Messages Posted By Akir
 Posted: Jun 8, 2022 12:19
 Subject: Re: Check wanted list against my inventory
 Viewed: 25 times
 Topic: Wanted
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Akir (123)

Location:  Austria, Steiermark
Member Since Contact Type Status
Dec 28, 2020 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Some Old Bricks
In Wanted, 1001bricks writes:
  In Wanted, stearns writes:
  In Wanted, 1001bricks writes:
  In Wanted, CSC writes:
  Is there a way to check which parts I already have that are on my wanted list?

You can also do this using BrickStore

How exactly do you do that? I guess you can subtract one (wanted) list from another
(inventory) list and check which parts don't go into the negative numbers,
but that seems clumsy to me - is there an easier way?

You remove from your Wanted-List all your shop.

In your WL, the lots with numbers zero or negative are to be deleted.
Just sort by Qty, delete all this.

In short, it takes 2 or 3 clicks to do the whole.

Thanks, though not quite what I meant - I have my inventory as a BrickStock file.
If I now decide to build something new and make a wanted list with the necessary
pieces, is there a quick way to check the inventory against that wanted list
to find out what I need to buy?
 Author: 1001bricks View Messages Posted By 1001bricks
 Posted: Jun 8, 2022 12:33
 Subject: Re: Check wanted list against my inventory
 Viewed: 27 times
 Topic: Wanted
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

1001bricks (52490)

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 Wanted, stearns writes:
  In Wanted, 1001bricks writes:
  In Wanted, stearns writes:
  In Wanted, 1001bricks writes:
  In Wanted, CSC writes:
  Is there a way to check which parts I already have that are on my wanted list?

You can also do this using BrickStore

How exactly do you do that? I guess you can subtract one (wanted) list from another
(inventory) list and check which parts don't go into the negative numbers,
but that seems clumsy to me - is there an easier way?

You remove from your Wanted-List all your shop.

In your WL, the lots with numbers zero or negative are to be deleted.
Just sort by Qty, delete all this.

In short, it takes 2 or 3 clicks to do the whole.

Thanks, though not quite what I meant - I have my inventory as a BrickStock file.

Yes, CTRL+I, CTRL+S


  If I now decide to build something new and make a wanted list with the necessary
pieces, is there a quick way to check the inventory against that wanted list
to find out what I need to buy?

Yes, as I wrote.

Open the shop inventory, open the WL.
Go to the WL, use the "-" minus button, substract the shop inventory.
Sort the WL by Qty.
Remove zero and negative values, it remains ONLY what you've to buy.
 Author: Akir View Messages Posted By Akir
 Posted: Jun 8, 2022 14:31
 Subject: Re: Check wanted list against my inventory
 Viewed: 35 times
 Topic: Wanted
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Akir (123)

Location:  Austria, Steiermark
Member Since Contact Type Status
Dec 28, 2020 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Some Old Bricks
In Wanted, 1001bricks writes:
  In Wanted, stearns writes:
  In Wanted, 1001bricks writes:
  In Wanted, stearns writes:
  In Wanted, 1001bricks writes:
  In Wanted, CSC writes:
  Is there a way to check which parts I already have that are on my wanted list?

You can also do this using BrickStore

How exactly do you do that? I guess you can subtract one (wanted) list from another
(inventory) list and check which parts don't go into the negative numbers,
but that seems clumsy to me - is there an easier way?

You remove from your Wanted-List all your shop.

In your WL, the lots with numbers zero or negative are to be deleted.
Just sort by Qty, delete all this.

In short, it takes 2 or 3 clicks to do the whole.

Thanks, though not quite what I meant - I have my inventory as a BrickStock file.

Yes, CTRL+I, CTRL+S


  If I now decide to build something new and make a wanted list with the necessary
pieces, is there a quick way to check the inventory against that wanted list
to find out what I need to buy?

Yes, as I wrote.

Open the shop inventory, open the WL.
Go to the WL, use the "-" minus button, substract the shop inventory.
Sort the WL by Qty.
Remove zero and negative values, it remains ONLY what you've to buy.

Right, now I get it, was thinking the wrong way round - thanks again!