Discussion Forum: Messages by calsbricks (5833)
Redisplay Messages: Compact | Brief | All | Full      Show Messages: All | Without Replies

 Author: calsbricks View Messages Posted By calsbricks
 Posted: Oct 16, 2019 09:51
 Subject: Re: Inventory and revenue management
 Viewed: 26 times
 Topic: Selling
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (5833)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Selling, JLRSextra writes:
  Wow. that is an extensive database. thanks for sharing the screenshots. That
must of taken many development hours.

I use Brickstock to manage inventory and pricing. I can easily adjust pricing
in Brickstock and upload the changes to Bricklink easily.

When processing a new batch for sale, I can start a new inventory or Part
Outs sets using Brickstock. It is super easy. But it doesn't do everything,
nor does it interface with every field provided by Bricklick (like the Cost field).

I do a monthly download from Bricklink of my sales in Excel format.
https://www.bricklink.com/orderExcel.asp?orderType=received

I then put that data into an Excel spreadsheet. Through a series of data calculations,
I figure out my sales total, bricklink fees, PayPal fees and finally net profit.
It's very manual.

Sounds good - we have tried to move as far away as possible from 'manual'
and have automated as much as we can at present without getting a programmer
involved. We, like many others, had hoped by now Bricklink would have been offering
something to help the sellers, after all we are a business , just like them,
but alas that hasn't happened.

We get all our stats from our system as well as P&L statements at the end of
each period. Our cost field is a very important field and unlike both Bricklink
and Brickstock we use it heavily. We know the cost we paid for each set and can
work out individual cost prices or just look at the totals. Our inventory is
held at cost so our accountants are happy with our methodology for that. As for
the used Lego which we buy in bulk - we know the weight and how much it cost
for the lot so we can easily keep track of the 'profitability' of each
lot we buy.

It could be easier, of course but we are comfortable with it as it is.
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Oct 16, 2019 09:19
 Subject: Re: Inventory and revenue management
 Viewed: 23 times
 Topic: Selling
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (5833)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Selling, honglonglong writes:
  In Selling, calsbricks writes:
  In Selling, honglonglong writes:
  I probably posted before but didn't get any answers. How do people manage
their inventories and track ins and outs of money etc? I find tracking money
flow helpful in terms of deciding more purchases, and deciding reasonable price
etc. I want a centralized place to track orders, stocks, purchases, and they
should be tied to lego specifics too (e.g. num of pieces, weight, etc). What
BL provides is part of what I want, not all.

I have been using a spreadsheet to track sets I bought and sold manually, but
it is fairly limited unless you spend a lot of time writing it. For example I
didn't track PayPal fees and shipping etc. And if I were to trade parts,
that would be more difficult and time consuming to track every piece using spreadsheet.

I have attached a link to 3 screenshots covering sales orders, purchases and
products within our subsystem

https://www.dropbox.com/s/sry9qj31gdeoy6k/Access_Screenshots.pdf?dl=0

Some get populated via an import of data and some do not. All bricklink activity
is maintained via this system independent of Bricklink.

This looks cool; thanks for sharing. I assume writing this system took non-trivial
time, which is more than justified if the business volume goes big. For starters
like me (my current annual orders are like 10, for contexts), do you have any
suggestions?

Gulp ! A lot can be done in Access without any programming skills (I am not a
programmer) but you do need an understanding of how relational databases work.
Other than that I suggest you join the bandwagon to get Bricklink to provide
these kinds of things in the long awaited and overdue sellers tools (Promised
in 2013 at the takeover/acquisition nothing to date other than a new promise
that it will be included with Bricklink XP, as, when and if that ever gets released,
debugged, and operational). I really would not hold my breath on that one, though
- find yourswelf an Access programmer and let him help you or write it for you.
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Oct 16, 2019 09:14
 Subject: Re: Inventory and revenue management
 Viewed: 24 times
 Topic: Selling
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (5833)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Selling, honglonglong writes:
  In Selling, calsbricks writes:
  In Selling, honglonglong writes:
  I probably posted before but didn't get any answers. How do people manage
their inventories and track ins and outs of money etc? I find tracking money
flow helpful in terms of deciding more purchases, and deciding reasonable price
etc. I want a centralized place to track orders, stocks, purchases, and they
should be tied to lego specifics too (e.g. num of pieces, weight, etc). What
BL provides is part of what I want, not all.

I have been using a spreadsheet to track sets I bought and sold manually, but
it is fairly limited unless you spend a lot of time writing it. For example I
didn't track PayPal fees and shipping etc. And if I were to trade parts,
that would be more difficult and time consuming to track every piece using spreadsheet.

We have our own internally written system as do many others as Bricklink do not
offer any real tools do do this.

We use a combination of Brickstock and an Access application which tracks all
orders both sales and purchases as well as inventory, pricing etc. It took a
while to develop but it works fine and is very independent of what Bricklink
do/

I saw Brickstock mentioned in previous posts; will give it a try. Curious what
lacks in Brickstock that makes you use another application along?

Brickstock has its limitations and our system removes those, however Bricklink
also has its limitations and our internal system addresses those. Brickstocks
real strength is in its ability to read the catalogue and tie the info together
with the image files. We use those images in our order picking sheets and if
you download an order directly from Bricklink you do not get the image file.
You can get it if you just print the order details to a pdf file but because
you cannot really alter the printouts that you get there and they are paper consuming
we bring the orders into Brickstock and print from there (Not to paper, by the
way).

It would be a wonderful thing if Bricklink actually thought about the sellers
and tried to make the system both easier to use less cumbersome, more informative
and much more parameter driven but alas that is not to be.

Good luck with your efforts.
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Oct 16, 2019 08:33
 Subject: Re: Buyer wants to pay me offline
 Viewed: 60 times
 Topic: Help
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (5833)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Help, Statentkt writes:
  Thanks in advance for your help. A buyer Is asking me for my PayPal account
because he wishes to pay me offsite. If I give it to him am I putting myself
in jeopardy?
Andrea

Over 7000 orders paid for by offsite Paypal - never a single problem. We do not
use Paypal onsite due to its address validation procedures.
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Oct 16, 2019 07:25
 Subject: Re: Inventory and revenue management
 Viewed: 65 times
 Topic: Selling
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (5833)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Selling, honglonglong writes:
  I probably posted before but didn't get any answers. How do people manage
their inventories and track ins and outs of money etc? I find tracking money
flow helpful in terms of deciding more purchases, and deciding reasonable price
etc. I want a centralized place to track orders, stocks, purchases, and they
should be tied to lego specifics too (e.g. num of pieces, weight, etc). What
BL provides is part of what I want, not all.

I have been using a spreadsheet to track sets I bought and sold manually, but
it is fairly limited unless you spend a lot of time writing it. For example I
didn't track PayPal fees and shipping etc. And if I were to trade parts,
that would be more difficult and time consuming to track every piece using spreadsheet.

I have attached a link to 3 screenshots covering sales orders, purchases and
products within our subsystem

https://www.dropbox.com/s/sry9qj31gdeoy6k/Access_Screenshots.pdf?dl=0

Some get populated via an import of data and some do not. All bricklink activity
is maintained via this system independent of Bricklink.
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Oct 16, 2019 03:45
 Subject: Re: Inventory and revenue management
 Viewed: 47 times
 Topic: Selling
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (5833)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In Selling, honglonglong writes:
  I probably posted before but didn't get any answers. How do people manage
their inventories and track ins and outs of money etc? I find tracking money
flow helpful in terms of deciding more purchases, and deciding reasonable price
etc. I want a centralized place to track orders, stocks, purchases, and they
should be tied to lego specifics too (e.g. num of pieces, weight, etc). What
BL provides is part of what I want, not all.

I have been using a spreadsheet to track sets I bought and sold manually, but
it is fairly limited unless you spend a lot of time writing it. For example I
didn't track PayPal fees and shipping etc. And if I were to trade parts,
that would be more difficult and time consuming to track every piece using spreadsheet.

We have our own internally written system as do many others as Bricklink do not
offer any real tools do do this.

We use a combination of Brickstock and an Access application which tracks all
orders both sales and purchases as well as inventory, pricing etc. It took a
while to develop but it works fine and is very independent of what Bricklink
do/
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Oct 15, 2019 11:14
 Subject: Re: market data
 Viewed: 40 times
 Topic: General
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (5833)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In General, Bricks_NW_UK writes:
  Is Nexon / Bricklink still up for sale?

Not according to the web, but you never know. He called off the sale cause no
one bid met his expectations. The last article we saw was in the Korean Times
and said he did not rule out selling at another time.
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Oct 15, 2019 09:16
 Subject: Re: market data
 Viewed: 32 times
 Topic: General
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (5833)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In General, WildBricks writes:
  I think what we are seeing here is the umbrella/layering affect of modern corporations.
The admin, programers & developers are based in California. That $1.7 figure
is based on all of the holdings of the next level up of corporation that is in
New Jersey. That company obviously has several other smaller companies beneath
it that sell other things besides LEGOs. "This organization primarily operates
in the Toys and Games (Including Dolls and Models), Mail Order business / industry
within the Miscellaneous Retail sector. "

You are of course correct on all fronts. What a myriad of entanglement.
  



In General, 1974 writes:
  No Bill, what's odd is that you said you've done "exhaustive search"
and this is new to you?

I just went to my Paypal account, found BL's actual business name (that included
the phonenumber) through the fees I pay

Then hit google and viola! Several databases turned up with almost similar info

I've found very little on the IRS website, just this :

https://www.irs.gov/businesses/corporations/sohobricks-corporation

Can't really do the same with TLG (The LEGO Group) as it's a private
company and also owns a ton of other companies (most outside Denmark) and it's
a very large family to boot

But it's safe to say KIRKBI could burn down every LEGO factory, park and
the entire town of Billund (airport included), rebuild it and it would not make
_that_ great a dent in their fortune. That fond is loaded, like Mærsk kinda loaded


Cheers,

Ole


In General, calsbricks writes:

  How very odd - New Jersey? - we thought they were based on the West Coast e.g.
California. The revenue is also not in line with that data we have from their
accounts. 17 People ? Somehow I doubt that. The mystery thickens.
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Oct 15, 2019 09:14
 Subject: Re: market data
 Viewed: 33 times
 Topic: General
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (5833)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In General, 1974 writes:
  No Bill, what's odd is that you said you've done "exhaustive search"
and this is new to you?

Our searches etc never looked at Bricklnk on its own only on the parent company
which is legally based in Belgium and their accounts can be purchased for about
£15. Our initial interest was more on the state of their affairs rather than
their location - so exhaustive research yes - to find the details we gathered.,
Complete research on Bricklink - no - so this is a new revelation to us. Their
store appears to be in California but their offices are in NJ ?? which, quite
honestly doesn't make a huge amount of sense. 17 People employed - I somehow
greatly disbelieve that and so do most others who have had to wait anxiously
and patiently for answers to bug issues, non-deliveries,etc.

  
I just went to my Paypal account, found BL's actual business name (that included
the phonenumber) through the fees I pay

Then hit google and viola! Several databases turned up with almost similar info


  
I've found very little on the IRS website, just this :

It does not appear they are required to file accounts with the IRS (Not sure
why but the audited accounts are filed in Korea - their auditors being Price
Waterhouse. NXC, the parent company appears to just be an investment vehicle
for the owners movements. Nexon also comes into this somewhere, but the accounts
are not revealing sufficient details.


As is usually the case with these investment conglomerates they do not make it
easy to get a reasonable leel of detail onther than figures.


  
https://www.irs.gov/businesses/corporations/sohobricks-corporation

Can't really do the same with TLG (The LEGO Group) as it's a private
company and also owns a ton of other companies (most outside Denmark) and it's
a very large family to boot

But it's safe to say KIRKBI could burn down every LEGO factory, park and
the entire town of Billund (airport included), rebuild it and it would not make
_that_ great a dent in their fortune. That fond is loaded, like Mærsk kinda loaded


Cheers,

Ole

Anyway well done on your efforts - we have learned something enw today.
  

In General, calsbricks writes:

  How very odd - New Jersey? - we thought they were based on the West Coast e.g.
California. The revenue is also not in line with that data we have from their
accounts. 17 People ? Somehow I doubt that. The mystery thickens.
 Author: calsbricks View Messages Posted By calsbricks
 Posted: Oct 15, 2019 08:25
 Subject: Re: market data
 Viewed: 41 times
 Topic: General
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (5833)

Location:  United Kingdom, England
Member Since Contact Type Status
Aug 12, 2008 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: CalsBricks
In General, mwright5 writes:
  In General, calsbricks writes:
  In General, 1974 writes:
  This is public data, maybe you can find something in there?

http://www.buzzfile.com/business/Bricklink-949-825-6653

There's annual sales (1,7 million USD) and number of employees (17)

Cheers,

Ole

How very odd - New Jersey? - we thought they were based on the West Coast e.g.
California. The revenue is also not in line with that data we have from their
accounts. 17 People ? Somehow I doubt that. The mystery thickens.

(Plot Thickens) Well, the owner's phone number is listed on that link.
I'm sure he'd be more than happy to help with this, and would love to
hear from us.

Absolutely - Cheaper for you to call than us

How about aq conference call where we can all speak to him
  

  
  

In General, JustTheBrick writes:
  Hi,

I am trying to get some data on the market size of Bricklink, such as total annual
sales or even an annual report of the Corporation itself, but can't really
find anything relevant. I know Lego make about £1.2b profit annually, and that
there are about 1.2million members on Bricklink but struggling to find any more
relevant numbers. Can anyone help?

Next Page: 5 More | 10 More | 25 More | 50 More | 100 More