Jump to content

My First Year as a Lego Reseller and What I've learned from BrickPicker

Recommended Posts

29 minutes ago, Gondorian said:

30 columns does seem a bit excessive!

On my stock sheet, other than what you mention, I track the Condition, where I bought it from, when I bought it, where it is now and a status to reference when I last saw it (to confirm how confident that it is where I think it is). I could add a column for Notes on the condition, but haven't yet.

To name a few:

Purchase outlet, outlet location, distance driven to pick up, price, discount, avg item price (if I bought multiples), order status, part out value with minifigs, part out value without minifigs, # available to sell, # sold ....

 

  • Like 1

Share this post


Link to post
Share on other sites
Just now, Phil B said:

To name a few:

Purchase outlet, outlet location, distance driven to pick up, price, discount, avg item price (if I bought multiples), order status, part out value with minifigs, part out value without minifigs, # available to sell, # sold ....

 

Oh wow. That is detailed.

But is there just one row per set number rather than multiple rows (one per copy of that set)? Sometimes I have bought different sets from 5 or more places and they are in varying conditions. I have a Copy number in the column next to the set number so I know which copy I am referring to.

Share this post


Link to post
Share on other sites
Just now, Gondorian said:

Oh wow. That is detailed.

But is there just one row per set number rather than multiple rows (one per copy of that set)? Sometimes I have bought different sets from 5 or more places and they are in varying conditions. I have a Copy number in the column next to the set number so I know which copy I am referring to.

Every purchase (can be multiple sets) gets a row. I get my averages from a Pivot Table when needed.

Share this post


Link to post
Share on other sites
On 2/8/2017 at 2:45 PM, Phil B said:

Every purchase (can be multiple sets) gets a row. I get my averages from a Pivot Table when needed.

do you get part out value from Bricklink or elsewhere?

Share this post


Link to post
Share on other sites

Hi guys, I'm an investor in Lego sets to, I think that was a great article. But I have same VERY bad news. 

Toys R Us declared bankruptcy!!😞😧 It will take a few months to close the doors, But there going to close down SOON! So see if there's a sale going on at your nearest Toys R Us store, there mite be one! If so, you should take advantage of the sale! 

So get in wile you can, before the Toys R Us stores close!! 

Share this post


Link to post
Share on other sites

Thanks for having taken the time to write this. It contained a lot of good pointers and some perspective to offer me as I dip a toe into this world.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...