| Discussion Forum: Thread 320661 |
|
 |
| | | Author: | yorbrick  | | Posted: | May 3, 2022 07:33 | | Subject: | Percentage off in inventory | | Viewed: | 57 times | | Topic: | Selling | |
|
| Is there a setting that I cannot find to give a possibly more normal calculation
of the percentage off for a whole category you see in the inventory section of
a store?
Currently it reports the average percentage off of each lot, irrespective of
price and number of items in the lot. Is it possible to flick a setting somewhere
and get it to report the value of (total original - total current) / total original
x 100% ?
For example,
2 items in one lot at £25, with 20% off.
1 item in another lot at £1.
1 item in another lot at £1.
That inventory price was £52, and is now £42.
I would say that whole category has 19.2% off (or 19% if rounding). Whereas BL
reports it as just 7% off using (20%+0%+0%)/3. The percentage is a bit misleading
especially if you have lots of low value, small qty lots not on sale.
|
|
|
|
| | | | | |
| | | | | Author: | wildchicken13 | | Posted: | May 3, 2022 16:45 | | Subject: | Re: Percentage off in inventory | | Viewed: | 22 times | | Topic: | Selling | |
|
| In Selling, yorbrick writes:
| | Is there a setting that I cannot find to give a possibly more normal calculation
of the percentage off for a whole category you see in the inventory section of
a store?
Currently it reports the average percentage off of each lot, irrespective of
price and number of items in the lot. Is it possible to flick a setting somewhere
and get it to report the value of (total original - total current) / total original
x 100% ?
For example,
2 items in one lot at £25, with 20% off.
1 item in another lot at £1.
1 item in another lot at £1.
That inventory price was £52, and is now £42.
I would say that whole category has 19.2% off (or 19% if rounding). Whereas BL
reports it as just 7% off using (20%+0%+0%)/3. The percentage is a bit misleading
especially if you have lots of low value, small qty lots not on sale.
|
I don't know if BrickLink supports this natively, but this is fairly easy
to do using Excel.
|
|
|
| | | | | | | | | |
| | | | | | | Author: | yorbrick | | Posted: | May 3, 2022 18:30 | | Subject: | Re: Percentage off in inventory | | Viewed: | 27 times | | Topic: | Selling | |
|
| In Selling, wildchicken13 writes:
| | In Selling, yorbrick writes:
| | Is there a setting that I cannot find to give a possibly more normal calculation
of the percentage off for a whole category you see in the inventory section of
a store?
Currently it reports the average percentage off of each lot, irrespective of
price and number of items in the lot. Is it possible to flick a setting somewhere
and get it to report the value of (total original - total current) / total original
x 100% ?
For example,
2 items in one lot at £25, with 20% off.
1 item in another lot at £1.
1 item in another lot at £1.
That inventory price was £52, and is now £42.
I would say that whole category has 19.2% off (or 19% if rounding). Whereas BL
reports it as just 7% off using (20%+0%+0%)/3. The percentage is a bit misleading
especially if you have lots of low value, small qty lots not on sale.
|
I don't know if BrickLink supports this natively, but this is fairly easy
to do using Excel.
|
Yeah, each one is fairly easy to do in my head too, but that means doing them
one by one with no way to quickly scan down that column to see if I've made
a serious error after automating a sale price.
Plus it is one of those things I think I'd prefer not to see at all rather
than calculated in a weird way.
|
|
|
| | | | | | | | | | | | | |
| | | | | | | | | Author: | Stellar | | Posted: | May 4, 2022 04:50 | | Subject: | Re: Percentage off in inventory | | Viewed: | 17 times | | Topic: | Selling | |
|
| In Selling, yorbrick writes:
| | In Selling, wildchicken13 writes:
| | In Selling, yorbrick writes:
| | Is there a setting that I cannot find to give a possibly more normal calculation
of the percentage off for a whole category you see in the inventory section of
a store?
Currently it reports the average percentage off of each lot, irrespective of
price and number of items in the lot. Is it possible to flick a setting somewhere
and get it to report the value of (total original - total current) / total original
x 100% ?
For example,
2 items in one lot at £25, with 20% off.
1 item in another lot at £1.
1 item in another lot at £1.
That inventory price was £52, and is now £42.
I would say that whole category has 19.2% off (or 19% if rounding). Whereas BL
reports it as just 7% off using (20%+0%+0%)/3. The percentage is a bit misleading
especially if you have lots of low value, small qty lots not on sale.
|
I don't know if BrickLink supports this natively, but this is fairly easy
to do using Excel.
|
Yeah, each one is fairly easy to do in my head too, but that means doing them
one by one with no way to quickly scan down that column to see if I've made
a serious error after automating a sale price.
Plus it is one of those things I think I'd prefer not to see at all rather
than calculated in a weird way.
|
On BrickStock you can import your store with two clicks and sort by the Sale
column to make a quick check.
|
|
|
|
|
|
|
United Kingdom, England
USA, Illinois
Spain, Comunidad Valenciana