|
 |
| | | Author: | Ziegelmeister  | | Posted: | Mar 15, 2024 23:45 | | Subject: | Individual lot sales history | | Viewed: | 119 times | | Topic: | Help | |
|
| Is there a way to pull up the sales history of a specific lot? I have a handful
that sell out within days of restocking, but I want to do a deep dive and see
if there are any others that might be getting lost in the mix.
I can see when it last sold, but that doesn't help. I want to see how many
are being bought each time and in what quantity.
|
|
| | | | | |
| | | | | Author: | 1001bricks | | Posted: | Mar 16, 2024 01:34 | | Subject: | Re: Individual lot sales history | | Viewed: | 25 times | | Topic: | Help | |
|
| In Help, Ziegelmeister writes:
| | Is there a way to pull up the sales history of a specific lot? I have a handful
that sell out within days of restocking, but I want to do a deep dive and see
if there are any others that might be getting lost in the mix.
|
Download free open source BrickStore, import your inventory, sort by Lot ID.
That's it - you'll see most recent and oldest lots.
How can any seller still not use BrickStore?
|
|
| | | | | | | | | |
| | | | | | | Author: | Ziegelmeister | | Posted: | Mar 16, 2024 02:13 | | Subject: | (Cancelled) | | Viewed: | 27 times | | Topic: | Help | |
|
| | (Cancelled) |
|
| | | | | | | | | | | | | |
| | | | | | | | | Author: | 1001bricks | | Posted: | Mar 16, 2024 02:20 | | Subject: | (Cancelled) | | Viewed: | 21 times | | Topic: | Help | |
|
| | (Cancelled) |
|
| | | | | | | | | |
| | | | | | | Author: | Ziegelmeister | | Posted: | Mar 16, 2024 02:19 | | Subject: | Re: Individual lot sales history | | Viewed: | 27 times | | Topic: | Help | |
|
| In Help, 1001bricks writes:
| | In Help, Ziegelmeister writes:
| | Is there a way to pull up the sales history of a specific lot? I have a handful
that sell out within days of restocking, but I want to do a deep dive and see
if there are any others that might be getting lost in the mix.
|
Download free open source BrickStore, import your inventory, sort by Lot ID.
That's it - you'll see most recent and oldest lots.
How can any seller still not use BrickStore?
|
Oh wait, I don't think I was clear.
I want to know every transaction for this lot.
Say it's Lot 555 for a pink heart tile. I can go to the price guide and
look for all the yellow squares to show my sales; so that data is stored on the
back end. But can I just somehow pull up Lot 555 and see in table format every
time I sold it and the quantity?
|
|
|
| | | | | | | | | | | | | |
| | | | | | | | | Author: | 1001bricks | | Posted: | Mar 16, 2024 02:23 | | Subject: | Re: Individual lot sales history | | Viewed: | 26 times | | Topic: | Help | |
|
| In Help, Ziegelmeister writes:
| | In Help, 1001bricks writes:
| | In Help, Ziegelmeister writes:
| | Is there a way to pull up the sales history of a specific lot? I have a handful
that sell out within days of restocking, but I want to do a deep dive and see
if there are any others that might be getting lost in the mix.
|
Download free open source BrickStore, import your inventory, sort by Lot ID.
That's it - you'll see most recent and oldest lots.
How can any seller still not use BrickStore?
|
Oh wait, I don't think I was clear.
I want to know every transaction for this lot.
Say it's Lot 555 for a pink heart tile. I can go to the price guide and
look for all the yellow squares to show my sales; so that data is stored on the
back end. But can I just somehow pull up Lot 555 and see in table format every
time I sold it and the quantity?
|
Ah this? No, nowhere.
For a few years it appeared on BrickLink (probably mostly for debugging Inventories),
but then it was removed.
But the oldest lots will show you lots which didn't sell.
Or are old and selling but you're restocking permanently - chances are low
|
|
|
| | | | | | | | | | | | | | | | | |
| | | | | | | | | | | Author: | Ziegelmeister | | Posted: | Mar 16, 2024 02:27 | | Subject: | Re: Individual lot sales history | | Viewed: | 25 times | | Topic: | Help | |
|
| In Help, 1001bricks writes:
| | Ah this? No, nowhere.
For a few years it appeared on BrickLink (probably mostly for debugging Inventories),
but then it was removed.
But the oldest lots will show you lots which didn't sell.
Or are old and selling but you're restocking permanently - chances are low
|
Aaaaah... Well shoot.
I started tracking a few of the ones I'm aware of as they come through but
I'm sure there are insights in the rest of the data. I guess I can write
a script that will scrape data from the order page moving forward.
Thanks for your help anyway.
|
|
| | | | | |
| | | | | Author: | popsicle | | Posted: | Mar 16, 2024 10:04 | | Subject: | (Cancelled) | | Viewed: | 33 times | | Topic: | Help | |
|
| | (Cancelled) |
|
| | | | | | | | | |
| | | | | | | Author: | Ziegelmeister | | Posted: | Mar 16, 2024 10:52 | | Subject: | Re: Individual lot sales history | | Viewed: | 23 times | | Topic: | Help | |
|
| In Help, popsicle writes:
| | If you’ve used the “My Remarks” for these lots as we do (example: location in
inventory, etc) then you can dig out your entire sales history for any given
item or lot, using the Inventory Download feature: https://www.bricklink.com/invExcel.asp
It’s clumsy, but it works if you’re compelled to find out.
|
Hmm.... So close. Unless I'm missing something. I do use Remarks but
this is only showing me my current inventory and when it last sold. Not every
time it sold. This could be useful though for other reasons.
|
|
| | | | | | | | | | | | | |
| | | | | | | | | Author: | popsicle | | Posted: | Mar 16, 2024 11:06 | | Subject: | Re: Individual lot sales history | | Viewed: | 29 times | | Topic: | Help | |
|
| In Help, Ziegelmeister writes:
| | In Help, popsicle writes:
| | If you’ve used the “My Remarks” for these lots as we do (example: location in
inventory, etc) then you can dig out your entire sales history for any given
item or lot, using the Inventory Download feature: https://www.bricklink.com/invExcel.asp
It’s clumsy, but it works if you’re compelled to find out.
|
Hmm.... So close. Unless I'm missing something. I do use Remarks but
this is only showing me my current inventory and when it last sold. Not every
time it sold. This could be useful though for other reasons.
|
You're not missing anything. I'm conflating two different goals and making
sense of neither. What happens when you get to be my age and try to handle far
too many things at once. This morning is one of those times. Not fun to witness
Disregard my post for now. I'm heading out the door to get my workout done
before I miss it altogether. When I get back, give me some time to ponder any
possible angles more deeply.
-popsicle
|
|
|
| | | | | | | | | | | | | | | | | |
| | | | | | | | | | | Author: | popsicle | | Posted: | Mar 16, 2024 11:09 | | Subject: | Re: Individual lot sales history | | Viewed: | 29 times | | Topic: | Help | |
|
| In Help, popsicle writes:
| | In Help, Ziegelmeister writes:
| | In Help, popsicle writes:
| | If you’ve used the “My Remarks” for these lots as we do (example: location in
inventory, etc) then you can dig out your entire sales history for any given
item or lot, using the Inventory Download feature: https://www.bricklink.com/invExcel.asp
It’s clumsy, but it works if you’re compelled to find out.
|
Hmm.... So close. Unless I'm missing something. I do use Remarks but
this is only showing me my current inventory and when it last sold. Not every
time it sold. This could be useful though for other reasons.
|
You're not missing anything. I'm conflating two different goals and making
sense of neither. What happens when you get to be my age and try to handle far
too many things at once. This morning is one of those times. Not fun to witness
Disregard my post for now. I'm heading out the door to get my workout done
before I miss it altogether. When I get back, give me some time to ponder any
possible angles more deeply.
-popsicle
|
Until then, I'll cancell my advise so that it doesn't further misguide
anyone else. I'll try and repost what I come with here, later.
|
|
|
| | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | Author: | popsicle | | Posted: | Mar 16, 2024 14:48 | | Subject: | Re: Individual lot sales history | | Viewed: | 30 times | | Topic: | Help | |
|
| In Help, popsicle writes:
| | In Help, popsicle writes:
| | In Help, Ziegelmeister writes:
| | In Help, popsicle writes:
| | If you’ve used the “My Remarks” for these lots as we do (example: location in
inventory, etc) then you can dig out your entire sales history for any given
item or lot, using the Inventory Download feature: https://www.bricklink.com/invExcel.asp
It’s clumsy, but it works if you’re compelled to find out.
|
Hmm.... So close. Unless I'm missing something. I do use Remarks but
this is only showing me my current inventory and when it last sold. Not every
time it sold. This could be useful though for other reasons.
|
You're not missing anything. I'm conflating two different goals and making
sense of neither. What happens when you get to be my age and try to handle far
too many things at once. This morning is one of those times. Not fun to witness
Disregard my post for now. I'm heading out the door to get my workout done
before I miss it altogether. When I get back, give me some time to ponder any
possible angles more deeply.
-popsicle
|
Until then, I'll cancell my advise so that it doesn't further misguide
anyone else. I'll try and repost what I come with here, later.
|
Yeah, I don't see a BL method or clever workaround to glean that info. Not
as you say, beyond the Price Guide's 6 month (sometimes longer) history,
or as Sylvain suggests, third-party tools.
Really don't know why I thought I'd come up with something Just had
that sense, now come to my senses, if that makes any sense other than nonsense
I'm gonna keep efforting it. Can't help it, given that now nagging sense.
|
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | Author: | Ziegelmeister | | Posted: | Mar 16, 2024 15:03 | | Subject: | Re: Individual lot sales history | | Viewed: | 30 times | | Topic: | Help | |
|
| LOL! Don't even worry about it, I appreciate the effort. I did a search
through my email history for the ones I know I move a lot of and I was able to
get what I needed for those.
My goal however was to see if there were things I might not have noticed or forgot
about.
I've only had ~310 orders so far so I can just pull everything through email
history if push comes to shove.
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | | | Author: | popsicle | | Posted: | Mar 16, 2024 15:47 | | Subject: | Re: Individual lot sales history | | Viewed: | 40 times | | Topic: | Help | |
|
| In Help, Ziegelmeister writes:
| | LOL! Don't even worry about it, I appreciate the effort. I did a search
through my email history for the ones I know I move a lot of and I was able to
get what I needed for those.
My goal however was to see if there were things I might not have noticed or forgot
about.
I've only had ~310 orders so far so I can just pull everything through email
history if push comes to shove.
|
Yeah, I've understood that route for order history grabs, from folks here
in the forum going back awhile. Seems the long way around, but as you say, at
least you arrive
From a perhaps unreasonably ever-BL-optimist's standpoint, it's just
a shame that it can't be added as another seller tool here.
|
|
|
|
|
USA, Ohio
France, Provence-Alpes-Côte d'Azur
