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:

1. From your Binder POS Portal, go to Products
2. Click Import CSV
3. 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:

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:

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

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:

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: