|
|
| | Author: | Teup | Posted: | Nov 9, 2015 10:20 | Subject: | Show +/-value report when parting out | Viewed: | 107 times | Topic: | Suggestions | Status: | Open | Vote: | [Yes|No] | |
|
| Sellers who want to keep track of their profit ratio (whether for personal insight
or for bookkeeping purposes) will always run into this same problem:
You just parted out $100 worth of parts, yes..
but..
your existing lots were updated with new prices. This means that although you
may now calculate your profit rate based on that $100, you have no idea what
just happened to the profit rate of the old bit of inventory.
To me it would seem fairly easy for Bricklink to compute an additional line,
"Value of existing inventory was modified with -$25" or, "Value of inventory
has increased with $75"
This information is much more interesting than the value of the bit you just
added. This way, you can calculate your actual profit rate, which will otherwise
always be obscured by the consolidation effects. In fact, you could theoretically
be running with a zero profit rate, without that ever appearing to you.
It is easily calculated, and can also be manually calculated - just look at the
difference in value before and after adding.
|
|
|
| | | | | |
| | | | Author: | Leftoverbricks | Posted: | Nov 9, 2015 10:37 | Subject: | Re: Show +/-value report when parting out | Viewed: | 28 times | Topic: | Suggestions | |
|
| In Suggestions, Teup writes:
| Sellers who want to keep track of their profit ratio (whether for personal insight
or for bookkeeping purposes) will always run into this same problem:
You just parted out $100 worth of parts, yes..
but..
your existing lots were updated with new prices. This means that although you
may now calculate your profit rate based on that $100, you have no idea what
just happened to the profit rate of the old bit of inventory.
To me it would seem fairly easy for Bricklink to compute an additional line,
"Value of existing inventory was modified with -$25" or, "Value of inventory
has increased with $75"
This information is much more interesting than the value of the bit you just
added. This way, you can calculate your actual profit rate, which will otherwise
always be obscured by the consolidation effects. In fact, you could theoretically
be running with a zero profit rate, without that ever appearing to you.
It is easily calculated, and can also be manually calculated - just look at the
difference in value before and after adding.
|
I do this all the time:
(1) before parting out a set I make a note of current inventory ("My inventory
total value after sale (Category Average): EUR xxx") This is InvOld
(2) part out my set and write down the POV (Part Out Value)
(3) go back to the inventory page (reload page) and check inventory total again
= invNew
Now compare the difference: (invNew-invOld) - (invOld+POV) and you're done!
Martin
|
|
|
| | | | | | | | | |
| | | | | | Author: | Teup | Posted: | Nov 9, 2015 10:53 | Subject: | Re: Show +/-value report when parting out | Viewed: | 28 times | Topic: | Suggestions | |
|
| In Suggestions, Leftoverbricks writes:
| In Suggestions, Teup writes:
| Sellers who want to keep track of their profit ratio (whether for personal insight
or for bookkeeping purposes) will always run into this same problem:
You just parted out $100 worth of parts, yes..
but..
your existing lots were updated with new prices. This means that although you
may now calculate your profit rate based on that $100, you have no idea what
just happened to the profit rate of the old bit of inventory.
To me it would seem fairly easy for Bricklink to compute an additional line,
"Value of existing inventory was modified with -$25" or, "Value of inventory
has increased with $75"
This information is much more interesting than the value of the bit you just
added. This way, you can calculate your actual profit rate, which will otherwise
always be obscured by the consolidation effects. In fact, you could theoretically
be running with a zero profit rate, without that ever appearing to you.
It is easily calculated, and can also be manually calculated - just look at the
difference in value before and after adding.
|
I do this all the time:
(1) before parting out a set I make a note of current inventory ("My inventory
total value after sale (Category Average): EUR xxx") This is InvOld
(2) part out my set and write down the POV (Part Out Value)
(3) go back to the inventory page (reload page) and check inventory total again
= invNew
Now compare the difference: (invNew-invOld) - (invOld+POV) and you're done!
Martin
|
Yeah, I'm going to do this as well from now on
I hope this will be implemented, as it's useful for almost all sellers, and
it currently has to be done manually in a side window while it's the classic
school example of what computers are for.... computing
|
|
|
| | | | | | | | | | | | | |
| | | | | | | | Author: | Leftoverbricks | Posted: | Nov 9, 2015 11:10 | Subject: | Re: Show +/-value report when parting out | Viewed: | 22 times | Topic: | Suggestions | |
|
| In Suggestions, Teup writes:
| In Suggestions, Leftoverbricks writes:
| In Suggestions, Teup writes:
|
|
snip
|
it currently has to be done manually in a side window while it's the classic
school example of what computers are for.... computing
|
Yeah, you are absolutely right there!
|
|
| | | | | |
| | | | Author: | FigBits | Posted: | Nov 9, 2015 11:22 | Subject: | Re: Show +/-value report when parting out | Viewed: | 29 times | Topic: | Suggestions | |
|
| In Suggestions, Teup writes:
| Sellers who want to keep track of their profit ratio (whether for personal insight
or for bookkeeping purposes) will always run into this same problem:
You just parted out $100 worth of parts, yes..
but..
your existing lots were updated with new prices. This means that although you
may now calculate your profit rate based on that $100, you have no idea what
just happened to the profit rate of the old bit of inventory.
To me it would seem fairly easy for Bricklink to compute an additional line,
"Value of existing inventory was modified with -$25" or, "Value of inventory
has increased with $75"
This information is much more interesting than the value of the bit you just
added. This way, you can calculate your actual profit rate, which will otherwise
always be obscured by the consolidation effects. In fact, you could theoretically
be running with a zero profit rate, without that ever appearing to you.
It is easily calculated, and can also be manually calculated - just look at the
difference in value before and after adding.
|
This would get solved with a slightly simpler, but more comprehensive update:
Allow access to historical inventory information.
Right now, there is a snapshot on the My Inventory page that shows the total
items, lots, categories, original price, sale price, and my cost for the current
inventory. But ONLY for the CURRENT inventory. All we need is a field that allows
us to see what these numbers were at some point in the past.
This would be very handy for seeing how inventory has grown over time, (or how
profit margins have changed, etc).
--
Marc.
|
|
|
| | | | | | | | | |
| | | | | | Author: | Pher | Posted: | Nov 9, 2015 11:41 | Subject: | Re: Show +/-value report when parting out | Viewed: | 21 times | Topic: | Suggestions | |
|
| In Suggestions, FigBits writes:
| In Suggestions, Teup writes:
| Sellers who want to keep track of their profit ratio (whether for personal insight
or for bookkeeping purposes) will always run into this same problem:
You just parted out $100 worth of parts, yes..
but..
your existing lots were updated with new prices. This means that although you
may now calculate your profit rate based on that $100, you have no idea what
just happened to the profit rate of the old bit of inventory.
To me it would seem fairly easy for Bricklink to compute an additional line,
"Value of existing inventory was modified with -$25" or, "Value of inventory
has increased with $75"
This information is much more interesting than the value of the bit you just
added. This way, you can calculate your actual profit rate, which will otherwise
always be obscured by the consolidation effects. In fact, you could theoretically
be running with a zero profit rate, without that ever appearing to you.
It is easily calculated, and can also be manually calculated - just look at the
difference in value before and after adding.
|
This would get solved with a slightly simpler, but more comprehensive update:
Allow access to historical inventory information.
Right now, there is a snapshot on the My Inventory page that shows the total
items, lots, categories, original price, sale price, and my cost for the current
inventory. But ONLY for the CURRENT inventory. All we need is a field that allows
us to see what these numbers were at some point in the past.
This would be very handy for seeing how inventory has grown over time, (or how
profit margins have changed, etc).
--
Marc.
|
Hi Marc!
That's a lot of data, isn't it?
To the OP: Thumbs up!
Regards
|
|
|
| | | | | | | | | | | | | |
| | | | | | | | Author: | FigBits | Posted: | Nov 9, 2015 12:02 | Subject: | Re: Show +/-value report when parting out | Viewed: | 21 times | Topic: | Suggestions | |
|
| In Suggestions, Pher writes:
| In Suggestions, FigBits writes:
| In Suggestions, Teup writes:
| Sellers who want to keep track of their profit ratio (whether for personal insight
or for bookkeeping purposes) will always run into this same problem:
You just parted out $100 worth of parts, yes..
but..
your existing lots were updated with new prices. This means that although you
may now calculate your profit rate based on that $100, you have no idea what
just happened to the profit rate of the old bit of inventory.
To me it would seem fairly easy for Bricklink to compute an additional line,
"Value of existing inventory was modified with -$25" or, "Value of inventory
has increased with $75"
This information is much more interesting than the value of the bit you just
added. This way, you can calculate your actual profit rate, which will otherwise
always be obscured by the consolidation effects. In fact, you could theoretically
be running with a zero profit rate, without that ever appearing to you.
It is easily calculated, and can also be manually calculated - just look at the
difference in value before and after adding.
|
This would get solved with a slightly simpler, but more comprehensive update:
Allow access to historical inventory information.
Right now, there is a snapshot on the My Inventory page that shows the total
items, lots, categories, original price, sale price, and my cost for the current
inventory. But ONLY for the CURRENT inventory. All we need is a field that allows
us to see what these numbers were at some point in the past.
This would be very handy for seeing how inventory has grown over time, (or how
profit margins have changed, etc).
--
Marc.
|
Hi Marc!
That's a lot of data, isn't it?
|
It isn't. I'd say less than 20 bytes for each time an inventory gets
updated. (This forum message, on the other hand, uses about 2100 bytes!) So one
Gb of storage would allow for about 60 million updates.
--
Marc.
|
|
|
| | | | | | | | | |
| | | | | | Author: | Etown | Posted: | Nov 9, 2015 20:45 | Subject: | Re: Show +/-value report when parting out | Viewed: | 22 times | Topic: | Suggestions | |
|
| In Suggestions, FigBits writes:
| In Suggestions, Teup writes:
| Sellers who want to keep track of their profit ratio (whether for personal insight
or for bookkeeping purposes) will always run into this same problem:
You just parted out $100 worth of parts, yes..
but..
your existing lots were updated with new prices. This means that although you
may now calculate your profit rate based on that $100, you have no idea what
just happened to the profit rate of the old bit of inventory.
To me it would seem fairly easy for Bricklink to compute an additional line,
"Value of existing inventory was modified with -$25" or, "Value of inventory
has increased with $75"
This information is much more interesting than the value of the bit you just
added. This way, you can calculate your actual profit rate, which will otherwise
always be obscured by the consolidation effects. In fact, you could theoretically
be running with a zero profit rate, without that ever appearing to you.
It is easily calculated, and can also be manually calculated - just look at the
difference in value before and after adding.
|
This would get solved with a slightly simpler, but more comprehensive update:
Allow access to historical inventory information.
Right now, there is a snapshot on the My Inventory page that shows the total
items, lots, categories, original price, sale price, and my cost for the current
inventory. But ONLY for the CURRENT inventory. All we need is a field that allows
us to see what these numbers were at some point in the past.
This would be very handy for seeing how inventory has grown over time, (or how
profit margins have changed, etc).
--
Marc.
|
Hi Marc,
I love this idea. I would find it very useful. Please create a suggestion for
this specifically and I would be happy to support it.
Ron
|
|
|
|
|
|