Importing an External CSV in BinderPOS :

Importing an External CSV

You may also have access to CSVs not originally from BinderPOS. These may be CSVs that you have created yourself, they may be a result of migrating from a previous POS software, or from some other means. These CSVs are also capable of being easily integrated into our software. You'll notice a button located on Products > Import CSV. Alongside allowing for the import of BinderPOS CSVs, this button can also be used for:

TCG Player App Uploads
- https://app.tcgplayer.com/
TCG Player Seller Portal
- CSVs exported from here can be directly imported through this section.
Card Sorter Robot(s)
Manually Created

While previous iterations of our POS required different steps to be taken when importing BinderPOS CSVs vs. other external CSVs, we are happy to announce that this has been changed. Now the process is the same for the importation of all CSVs

When importing these CSVs, it is still vital to make sure that they are set up correctly and have Product and Shopify IDs. If the format doesn't match, or if there are any missing headers, then the imports will fail. Exports from the TCG Player seller portal can be imported directly, but it is important to note that they will always add inventory and never overwrite existing quantities.

Remember: Your product CSV can't exceed 10MB. If you get an error when trying to upload a new CSV file, please check to make sure that it doesn't exceed the size limit

Below you will find a quick review of the steps needed to easily import your external (non-BinderPOS) CSVs:

From your Binder POS Portal, go to Products
Click Import CSV
Click the window to choose a file or drag and drop

TCG Player Import Specifics:

If your CSV is coming from TCG Player, it will have the following two options: TCG Player App and TCG Player Pro

TCG Player App Import Specifics:

Column Title	Description	Data Requirements
SKU	Here, you will input the TCG Player card SKU	Required. Can't be blank or missing
Name	Here, you will enter the card's name	Required, but can be blank
Product ID	Here, you will enter the card's product ID	Required, but can be blank
Language	Here, you will enter the card's language	Required, but can be blank
Printing	Here, you will enter the card's printing edition	Required, but can be blank
Condition	Here, you will enter the card's condition	Required, but can be blank
Quantity	Here, you will enter the card's quantity to be added to your store's inventory. Will be overwritten if the Set Stock* column is included*	Required. Can't be blank or missing

The extra fields that come in the TCG Pro CSV download are fine to include. Our system only cares about the four rows noted below.

TCG Player Pro Import Specifics:

Column Title	Description	Data Requirements
TCG Player ID	Here, you will input the TCG Player SKU ID of the item to update	Required. Can't be blank or missing
Product Line	Here, you will input the product line	Required, but not used
Product Name	Here, you will input the product's name	Required, but not used
Add to Quantity	Here, you will input the quantity that gets added to the store's inventory. Will be overwritten if the Set Stock* column is included*	Required. Can't be blank or missing

If you are a new customer, it is important to note that you will need to make sure to rename your Total Quantity column to Add to Quantity. Following this, delete the original Add to Quantity column. This will make sure it matches and that our system can find the correct column.

Some IDs no longer match for new sets due to TCG Players' new API restrictions. This will cause some singles in the imports to fail

Card Sorter Robot(s) Import Specifics:

We also support CSV importing from any of several card sorting robots. If you use any of the following formats, this option is available to you:

Cardcastle Cardbot
ROCA Sorter
Magic Sorter
Scryfall

This option is only available for MTG cards

Column Title	Description	Data Requirements
ID	Here, you will input the Scryfall ID of the card	Required. Can’t be blank or missing
Quantity	Here, you will have the card quantity needed to add to your store's inventory. This will add stock to existing inventory and will be overwritten if the Set Stock* column is included*	Required. Can’t be blank or missing
Foil	This section will appear as True or False to indicate whether the card is foiled or not. This section is case sensitive	Required. Can’t be blank or missing
Condition	This will be the card's condition that matches your store's settings, such as Near Mint	Required. Can’t be blank or missing
Language	This will be the language of your card	Required, but not used

Multi Store CSV Imports:

Please note that, for store to store imports, the store uploading the adjustment must be set up with the proper catalogs from BinderPOS. There are two new fields on your existing CSV exports; they should support the cross store importing and allow you to make workbook modifications to any tools that you are already using.

While this is true, it also means that custom products are not supported at this time. If you have a store carrying Pokémon (Store A), and another that does not (Store B), you cannot cross import any Pokémon cards from Store A into Store B

Because we are actively working to standardize these catalog pushes, these errors shouldn't be encountered, but if a store is missing a card from our catalog, it will reject the line item and produce an error similar to the following:

pkms | 198 | New 2 | failed | Game Type + Binder ID + Variant Title does not match any available products

If you're processing uploads using the existing supported format, you will begin to see more failed lines with informative error messages indicating the source of the failure/problem column. An example of how these error messages may look can be found below:

1| Abyssal Nightstalker | 86 | EN | 99999999 | 10.11 | failed | SKU does not match any available products