Discussion Forum: Thread 340093

 Author: SDF_Bricks View Messages Posted By SDF_Bricks
 Posted: May 21, 2023 05:13
 Subject: Best way to manage inventory
 Viewed: 123 times
 Topic: Help
 Report:
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

SDF_Bricks (297)

Location:  USA, Illinois
Member Since Contact Type Status
Mar 19, 2004 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: SDH Bricks
I have 200+ sets and several thousands parts, all from buying/collecting Lego
over the past 20 years. There are few things I need to do before listing them
all. For this, what is the best inventory management tool?

1. List is already in excel, Can I upload directly to BrickLink and/or Rebrickable?
2. Rather than looking up each set separately. Is there a way to get price range
from BL given some flags (Used, Complete, ...)
3. Most parts are sorted (separated sets). I ultimately like to get the 'higher
value' sets so it's worth to invest the time and group the sets together.
For example, no point in organizing the Friends sets if those are of low value.
4. I do not have much time to dedicate to this hobby. All sets/parts are stored
in 100+ boxs/oganizers (Ikea and the like). Ideally I'd like to sell all
at once, but need to inventory first to assess fair value.
 Author: PlanetEarthToys View Messages Posted By PlanetEarthToys
 Posted: May 21, 2023 09:10
 Subject: (Cancelled)
 Viewed: 57 times
 Topic: Help
Cancel Message
Cancel
BrickLink
ID Card

PlanetEarthToys (146)

Location:  USA, Arkansas
Member Since Contact Type Status
Aug 24, 2021 Contact Member Seller
Buying Privileges - OKSelling Privileges - Revoked
Store Closed Store: Planet Earth Toys
(Cancelled)
 Author: SylvainLS View Messages Posted By SylvainLS
 Posted: May 21, 2023 09:49
 Subject: Re: Best way to manage inventory
 Viewed: 68 times
 Topic: Help
 Report:
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

SylvainLS (52)

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, SDF_Bricks writes:
  […]
1. List is already in excel, Can I upload directly to BrickLink and/or Rebrickable?

Not “directly.”

BL uses XML files.
I think Rebrickable can use CSV files, but they don’t use the same IDs as BL,
so, even if they take BL XML files, Orders or Wanted Lists, and Studio files,
I’m not sure they take CSV files with BL IDs.

You should be able to export in XML from Excel… but I’ll let you search how to
do it
 Author: 1001bricks View Messages Posted By 1001bricks
 Posted: May 21, 2023 16:08
 Subject: Re: Best way to manage inventory
 Viewed: 59 times
 Topic: Help
 Report:
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

1001bricks (55732)

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, SDF_Bricks writes:
  I have 200+ sets and several thousands parts, all from buying/collecting Lego
over the past 20 years. There are few things I need to do before listing them
all. For this, what is the best inventory management tool?

1. List is already in excel, Can I upload directly to BrickLink and/or Rebrickable?
2. Rather than looking up each set separately. Is there a way to get price range
from BL given some flags (Used, Complete, ...)
3. Most parts are sorted (separated sets). I ultimately like to get the 'higher
value' sets so it's worth to invest the time and group the sets together.
For example, no point in organizing the Friends sets if those are of low value.
4. I do not have much time to dedicate to this hobby. All sets/parts are stored
in 100+ boxs/oganizers (Ikea and the like). Ideally I'd like to sell all
at once, but need to inventory first to assess fair value.

BrickStore is free and open-source.
It can import/export studio, BL files, and rebrickable.
It's really the best way to manage inventory, orders, your collection, etc.