Webapps

TCGPlayer ID Generator

A simple JavaScript app that leverages Scryfall API to generate a list of TCGPlayer_IDs based on two inputs: a MTG set, and list of collector numbers. TCGPlayer_IDs are the preferred ID for tracking unique prints of a card, which in turn enables better tracking of prices for a given collection.


MTG Importer

Another simple JavaScript app, but this one includes an output of additional relevant fields from Scryfall. Personally, I use an R version of this script to then insert into a MySQL db for inventory tracking.


SQL from TCGPlayer_ID

Simple script that takes in a comma-separated list of TCGPlayer_IDs and generates a series of INSERT statements to populate a MySQL DB table 'inventory' with the specified cards