TCGCSV

Ahoy!

This website is a hobby project that exposes categories, groups, products, and prices from TCGPlayer's API. The results are shared here for folks who can't get access to TCGPlayer's API. All responses used to generate the content on this website are cached as unmodified JSON text-files. The CSV's that I've put together DO have my personal affiliate links in there.

You can see my terraform learnings, AWS infrastructure, and open source mess for this website on Github

You can join this discord to contact me, get updates, and talk about what would be cool to have next!

If you would like to support this project, you can become a member on Patreon to help keep the lights on!

Files

TCGPlayer has 4 tiers of information.

At the root are Categories. Each category roughly translates to a card game or a collection of merchandise.
categoryId: 3 is Pokemon
Each category has Groups. Each group roughly translates to a set in a card game.
groupId: 3170 is Pokemon's - SWSH12: Silver Tempest set.
Each group has Products. Products can be sealed boxes, packs, or individual cards!
Products have nested "extendedData" which is where TCGPlayer usually stores a card's text, rarity, and set number.
Products have separate Market Price objects available in a parallel collection that need to be joined via a productId.
productId: 451396 is Lugia VSTAR
Past this point, Products have "SKUs". A SKU is combination of a Product, Language, Printing, and Condition. However, this project does not share information about SKUs. This means that you will not be able to get prices for each condition of a card.

Root information

Categories Categories.csv

Category information

Category Name	Category ID	Files

Ahoy!

Updates

Files