Topic: Added "Tcgplayer ID" and "Scryfall ID" optional columns to CSV export

The post title actually covers it. 2 new optional columns in the csv export.

Re: Added "Tcgplayer ID" and "Scryfall ID" optional columns to CSV export

Big fan of this update. Thank you, Sebi!

~S~

Re: Added "Tcgplayer ID" and "Scryfall ID" optional columns to CSV export

Can you add serialized doctor who cards?

Re: Added "Tcgplayer ID" and "Scryfall ID" optional columns to CSV export

Hey, thanks for that! Does this mean that the deckbox csv import also uses the scryfall guid to identify cards now? As far as I could tell it had used the card name and set name to identify cards on deckbox csv imports, is that right? I just sometimes run into trouble because the app I use to scan cards uses slightly different names for the sets sometimes (mostly just for Commander sets or promos) and then I run into trouble when I try to import them here.
Either way, thanks for the update!

Re: Added "Tcgplayer ID" and "Scryfall ID" optional columns to CSV export

YonderPeasant wrote:

Hey, thanks for that! Does this mean that the deckbox csv import also uses the scryfall guid to identify cards now? As far as I could tell it had used the card name and set name to identify cards on deckbox csv imports, is that right? I just sometimes run into trouble because the app I use to scan cards uses slightly different names for the sets sometimes (mostly just for Commander sets or promos) and then I run into trouble when I try to import them here.
Either way, thanks for the update!

If the csv is generated from deckbox, the printing id is used. Scryfall id is only used in the Manabox importer right now. What app / what format are you using to generate the csv?

Re: Added "Tcgplayer ID" and "Scryfall ID" optional columns to CSV export

Awesome!  Much appreciated Sebi.

Re: Added "Tcgplayer ID" and "Scryfall ID" optional columns to CSV export

sebi wrote:
YonderPeasant wrote:

Hey, thanks for that! Does this mean that the deckbox csv import also uses the scryfall guid to identify cards now? As far as I could tell it had used the card name and set name to identify cards on deckbox csv imports, is that right? I just sometimes run into trouble because the app I use to scan cards uses slightly different names for the sets sometimes (mostly just for Commander sets or promos) and then I run into trouble when I try to import them here.
Either way, thanks for the update!

If the csv is generated from deckbox, the printing id is used. Scryfall id is only used in the Manabox importer right now. What app / what format are you using to generate the csv?

It's an iOS app called Card Binder. The csv it exports has slightly different columns to what the Deckbox CSV import allows

export_type;scryfall_uuid;set_code;quantity;foil_quantity;card_name;set_name;cardMarketId;english_card_name;lang;collector_number

But it's alright, I wrote my own program that takes in that app's csv and outputs a csv that I can import into Deckbox.
The only problem I have is when the set names don't match, e.g. for Core Set 2015 my app uses "Magic 2015" and Deckbox uses "Magic 2015 Core Set", and then I get an error when I try to import it. It's okay, though, I've got a big if-else that substitutes the wrong set names for the right ones ^^

Re: Added "Tcgplayer ID" and "Scryfall ID" optional columns to CSV export

Hey Sebi, I appreciate all you do for the site and have used it for dozens of trades already, as well as useful organization tools.  I recently sold a large portion of my collection to a friend, who will then be listing a bunch of it on TCGplayer.  I thought it would be convenient to use the new option for adding "TCGplayer ID" to the CSV file I exported so that he could use that same CSV file (with a few changes to its headers to match TCGplayer's) to batch upload to TCGplayer.  Several tries and edits later, I've realized that the TCGplayer ID function that you've recently added does not match TCGplayer's current card ID.  Not only is it currently inaccurate in its most basic TCGplayer ID of a near mint non-foil version of a card from a given set, but it also does not change with changes in card condition or foiling as TCGplayer's ID does.  A number of the product names and set names don't match either.  I assume that there's probably some small coding adjustment to be made because deckbox already successfully pulls data from TCGplayer according to condition and premium finish when evaluating and sorting one's own tradelist.  Although, the only way I was able to discover the difference in ID numbers was, after repeated upload attempts, downloading TCGplayer's CSV file of all possible card listings and their matching ID numbers and comparing it to my own collection's CSV.  A quick search through reddit and it confirms that downloading the inventory CSV from TCGplayer is the only way to get accurate card ID values (which is absolutely ridiculous.  I mean, really TCGplayer, just list the ID's on the card info page.....).  I'm not sure how much time a fix for this would require, but I'm sure other people would find the improved accuracy convenient if converting their own collection in order to batch upload to TCGplayer.  I'll attach a screenshot that shows an example of the difference.  On the left of the image will be highlighted TCGplayer's card ID according to the CSV I downloaded from their site, and on the right is the CSV I downloaded from deckbox with the TCGplayer ID according to deckbox in the first column.  Notice that the ID is the same for 8th ed planar portal for all 3 conditions listed from deckbox, whereas TCGplayer has a unique ID for each condition and foiling on the left side.  Thanks in advance either way.

Mark

Post's attachments

TCGplayerIDvsDeckbox.png 433.3 kb, file has never been downloaded. 

You don't have the permssions to download the attachments of this post.

Re: Added "Tcgplayer ID" and "Scryfall ID" optional columns to CSV export

Hello,

The tcgplayer id I export is the product id for the printing. It does not vary with condition and stuff. It's the id that gets in the url when you link to a printing on tcgplayer (even from their site). It's the same one that scryfall has in their API & that they use to link to tcgplayer.