Discussion Forum: Messages by calsbricks (5779)
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 (5779)

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 (5779)

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: 23 times
 Topic: Selling
View Message
View
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

calsbricks (5779)

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 (5779)

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 (5779)

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.

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