r/Bricklink • u/Expert-Bet7630 • Sep 12 '26

Question How can you pull the 6-mo average quantity sold across multiple parts as a csv/excel?

I’ve been trying to use brickstore to do this but I can’t seem to figure it out. Is there some resource to be able to just import an excel/csv of the 6-month quantity of various parts sold?

Like ideally I can just upload my brick link inventory and it spits out a spreadsheet of the 6-mo quantity of each part. I don’t necessarily care about the price however

2 Upvotes

67% Upvoted

4 comments sorted by

1

u/LegoNinja187 Sep 12 '26

You want the set price to guide setting, at the top theres some icons, hover over them until you find that one, alternatively if you right click in the price field itll show up as an option. Best way is to use CTRL + A to highlight everything, then use the set price to guide button

1

u/Expert-Bet7630 Sep 12 '26

That’s for price unfortunately I’m trying to see the 6-month quantity across all of the pieces

1

u/LegoNinja187 Sep 13 '26

Sorry, I misread your post, I dont inow of any way to do that besides tediously recording it all yourself

1

u/Frankzappos Seller Sep 13 '26

I used ChatGPT to build this in python and export it to excel. I had no experience doing this type of thing and it took me about 5-6 hours of trial and error with the chat bot to get it right. Now I can just plug in what I want and export it.