Hey there Grinders!
I’ve realized that, while I love my process for adding listings to my inventory system, I really REALLY don’t love adding sales to my inventory system, as it adds a lot of extra steps to the process of shipping orders. Or else it’s super tedious.
So I’m trying to figure out a way to automate to some extent the extraction of all the info I need in order to add sold cards to my Sold page, and thus have it auto populate through to my Master sheet.
It would be super nice if there were some kind of extractable csv that had selected orders on it, and what cards were sold on each of those orders, and what the price breakdown was between each of those cards. But that’s not available from TCGplayer. The best version of this involves getting some info from csv’s to download, and the rest of the info from either the packing slips or else the order pages themselves. But manually typing all this adds a huge amount of work to each order, far outweighing the work involved in actually pulling, packing, and shipping said orders.
Trying to do something with Character Recognition to extract text from the PDF, but it’s really inelegant and kind of driving me up the wall.
If you have any suggestions, any processes that work for you, feel free to let me know.
Cheers!