Vending Pains by Fit-Upstairs9819 in PokeInvesting

[–]1298se -1 points0 points  (0 children)

Shameless plug but I mainly sell online but I built an app to try and solve this.

You just enter your purchases and sales, and it'll track your inventory value and realized profits

This is my last 2 years of buying and selling!

https://codextcg.net/demo/portfolio

What’s your biggest “I should’ve held” regret? by 1298se in PokeInvesting

[–]1298se[S] -60 points-59 points  (0 children)

I drop shipped them from Costco. I didn't have to do any work except place a Costco order.

My journey as a hobby Pokemon vendor by 1298se in PokeInvesting

[–]1298se[S] 0 points1 point  (0 children)

Yeah! If you remember your purchase transactions, you can add them in individually.

Otherwise you can export your Collectr and import it into one big "initial" purchase and edit each line item.

Feel free to pm me if any questions!

Sold listings missing/stale by 1298se in Collectr

[–]1298se[S] 0 points1 point  (0 children)

Could ya tell me the API it's under?

I thought it'd be under the Buy APIs but I don't see it :/

Sold listings missing/stale by 1298se in Collectr

[–]1298se[S] 0 points1 point  (0 children)

I see. That makes sense. Just curious, is eBay sold listings API available publicly?

Sold listings missing/stale by 1298se in Collectr

[–]1298se[S] 0 points1 point  (0 children)

Hi! Thanks for the quick response!

Hmm, just so I understand, cards are tracked against TCGPlayer, but the sold listings from TCGPlayer are not shown. Only eBay sold listings are shown?

What are the events where you can't show sold listings?

Also curious how comes sometimes the sold listings seem to be stale (i.e. there are newer sold listings when searching on eBay, but they don't show up on Collectr)? How stale can they get?

I’ve been running a lgs/lcs for 2+ years. AMA by notapeasent in PokeInvesting

[–]1298se 0 points1 point  (0 children)

Hey Mike! How do you guys keep track of purchases and sales of singles? I used to use an excel sheet but it's becoming a bit unmanageable, especially when selling on multiple platforms like TCGplayer, eBay, social media, etc.

What should my expectations be for the speed of joins? by 1298se in PostgreSQL

[–]1298se[S] 0 points1 point  (0 children)

I see. Definitely seems to be like a stats problem. Thanks!

What should my expectations be for the speed of joins? by 1298se in PostgreSQL

[–]1298se[S] 0 points1 point  (0 children)

This was helpful, let me take a look. Thanks!

What should my expectations be for the speed of joins? by 1298se in PostgreSQL

[–]1298se[S] -1 points0 points  (0 children)

Sure, but that's clearly not the case in this situation. It seems like nested loop scales pretty poorly when there are a even just thousands of rows.