Discussion Forum: Thread 351504 |
|
|
| | Author: | Tdejacob | Posted: | Dec 13, 2023 16:01 | Subject: | Keeping track of sales | Viewed: | 146 times | Topic: | Selling | |
|
| Hello everyone,
I started selling on bricklink in April of this year and am curious how you all
keep track of total sales/sales that are older than 6 months. I have screenshots
of my order screens that are older than 6 months to keep track but was wondering
should I use Excel to keep track or are there any other methods you all use?
Thank you!
-Jake
|
|
| | | | | |
| | | | Author: | peregrinator | Posted: | Dec 13, 2023 16:20 | Subject: | Re: Keeping track of sales | Viewed: | 49 times | Topic: | Selling | |
|
| In Selling, Tdejacob writes:
| Hello everyone,
I started selling on bricklink in April of this year and am curious how you all
keep track of total sales/sales that are older than 6 months. I have screenshots
of my order screens that are older than 6 months to keep track but was wondering
should I use Excel to keep track or are there any other methods you all use?
Thank you!
-Jake
|
Personally I use Excel. But I don't trouble about the details (e.g., exactly
which parts went with what order). You can download data regarding older orders,
by the way - but that doesn't include the detail information.
|
|
| | | | | |
| | | | Author: | kwalk45 | Posted: | Dec 13, 2023 18:09 | Subject: | Re: Keeping track of sales | Viewed: | 55 times | Topic: | Selling | |
|
| In Selling, Tdejacob writes:
| Hello everyone,
I started selling on bricklink in April of this year and am curious how you all
keep track of total sales/sales that are older than 6 months. I have screenshots
of my order screens that are older than 6 months to keep track but was wondering
should I use Excel to keep track or are there any other methods you all use?
Thank you!
-Jake
|
I download all my sales once a month place into a google sheet (same as excel)
I track shipping recieved vs paid, total sales, total lots and total pieces I
track buyers by username only and city and state. Be aware orders purge after
a while hence the once a month process. I started in Feb first orders were in
Mar. It does help to keep you motivated when you see your orders over a period
of time. I dont mess with what individual pieces sell I think chasing those would
be a waste of time.
|
|
|
| | | | | |
| | | | Author: | kittybrickz | Posted: | Dec 13, 2023 19:48 | Subject: | Re: Keeping track of sales | Viewed: | 35 times | Topic: | Selling | |
|
| I use Google sheets because it is available away from my computer.
I log the date, order number, type of product (sets/MF/parts), shipping cost,
paypal fee, bricklink fee, taxes if any, packing cost, total expenditures, total
price listed, price paid, total profit.
I like using spreadsheets because you can use formulas to add up costs and profit
and see the bottom line. So for each order you add to the list it will change
the bottom line.
|
|
| | | | | |
| | | | Author: | ErwinNL | Posted: | Dec 14, 2023 04:05 | Subject: | Re: Keeping track of sales | Viewed: | 52 times | Topic: | Selling | |
|
| In Selling, Tdejacob writes:
| Hello everyone,
I started selling on bricklink in April of this year and am curious how you all
keep track of total sales/sales that are older than 6 months. I have screenshots
of my order screens that are older than 6 months to keep track but was wondering
should I use Excel to keep track or are there any other methods you all use?
Thank you!
-Jake
|
I made BLS Manager for this, a free Windows application that downloads all order
and inventory information, you can use it to track and manage orders, pick them,
and more.
Feel free to give it a try.
|
|
| | | | | |
| | | | Author: | OurBricks | Posted: | Dec 14, 2023 10:46 | Subject: | Re: Keeping track of sales | Viewed: | 31 times | Topic: | Selling | |
|
| I use the Brick Seller app for this. It will keep all your order data. I have
order data from 2016. It also has a number of graphs/charts to analyze order
data over time.
Here is a link to the Forum post about it: https://www.bricklink.com/message.asp?ID=1437228
If you are not familiar with Brick Seller, you can find a link to it on the BrickLink
Inventory Software links page here: https://www.bricklink.com/links.asp?catID=9
Rick
In Selling, Tdejacob writes:
| Hello everyone,
I started selling on bricklink in April of this year and am curious how you all
keep track of total sales/sales that are older than 6 months. I have screenshots
of my order screens that are older than 6 months to keep track but was wondering
should I use Excel to keep track or are there any other methods you all use?
Thank you!
-Jake
|
|
|
|
|
|
|
|