TCGplayer’s help center describes the bulk route in three short articles: How do I export shipping info for customer orders?, Importing Shipping Info for Customer Orders, and the Shipping Guidelines. This page puts them in the order you do them. The steps follow those articles as of October 23, 2026; Seller Portal button names can change, so match them to what you see on your Orders tab.
The short answer
- Export: in your Seller Portal, open the Orders tab, select the orders you are shipping and press Export Shipping.
- Add tracking: put each tracking number on the row for its Order Number. TCGplayer says the Order Number and the Tracking Number are the only required fields.
- No tracking? For an order that does not need it, put the word Shipped where the tracking number goes and enter a carrier. TCGplayer says a carrier must be entered to ship an order without tracking.
- Import: upload the updated file with the shipping-info import on the Orders tab. TCGplayer applies the tracking numbers and sets the matching orders to Shipped.
- Required tracking: orders over $49.99 need a tracking number, and you get an error if it is missing. Orders over $250 also need signature confirmation.
How to add tracking numbers to TCGplayer orders in bulk
Export the orders. On the Orders tab, select the orders you are about to ship and press Export Shipping. Save the CSV. It is the same file you use to print address labels and packing slips.
Buy postage and collect the numbers. Buy the labels in Pirate Ship, USPS, PayPal or your carrier account. Copy each tracking number together with its TCGplayer order number, so you can match them without guessing.
Fill in the file. Open the export in Excel or Google Sheets and put each tracking number on the row for its Order Number. Do not change the Order Number column, do not delete the header row, and keep the other columns as TCGplayer wrote them. If an order appears on more than one row, give each of its rows the same tracking number.
Handle the envelope orders. For a low-value order in a plain white envelope, write Shipped where the tracking number goes and fill in the carrier. Do this only for orders of $49.99 or less. Anything over $49.99 needs a real tracking number.
Import and check. Upload the saved file with the shipping-info import on the Orders tab. Then look at your orders: the ones in the file should show as shipped with their tracking numbers. Try one or two orders the first time, before you upload a whole day.
Keep long tracking numbers from breaking in Excel
A USPS tracking number is about 22 digits. Excel treats it as a number, keeps only the first 15 digits and shows it as something like 9.40011E+21, so the number you import is wrong. Before you paste, select the tracking column and format it as Text (in Google Sheets: Format, Number, Plain text). A tool that builds the file for you avoids the problem, because the numbers stay text from start to finish.
The faster way: build the import file in your browser
If you already use TCG Speed Shipper for labels, the same export does this job. Load your Export Shipping CSV, open the tracking panel, paste your tracking numbers (one per line in label order, or order# tracking# pairs), click Match to Orders, then Download TCGplayer import file.
- The file is your own export with the Tracking # and Carrier columns filled in, so every other column stays as TCGplayer wrote it.
- The carrier (USPS, UPS or FedEx) is read from the shape of each number.
- Envelope orders without a number can be marked Shipped in one tick.
- An order over $49.99 with no tracking number gets a warning before you upload.
- It runs in your browser, so the file is not uploaded to us.
Buying postage on Pirate Ship? Download the Pirate Ship CSV of just your tracked orders first, buy the labels, then drop Pirate Ship's shipment export back on the page (full steps: TCGplayer orders with Pirate Ship). The steps for printing the labels themselves are in How to print TCGplayer shipping labels. The first time you use any tool for this, upload one order and check it in your Seller Portal before you upload a batch.
Which orders need tracking?
TCGplayer’s guidance depends on order value:
| TCGplayer order value | Guidance | In the import file |
|---|---|---|
| Under $20 | Tracking is not required. | A stamped envelope can be marked Shipped with a carrier. |
| $20.01 to $49.99 | Tracking is recommended. | Add the number if you have one. |
| Over $49.99 | Tracking is required. | A tracking number on the row, or the import shows an error. |
| Over $250 | Tracking and signature confirmation are required. | A tracking number from a service with signature confirmation. |
TCGplayer’s help center says tracking is required on orders over $49.99, so a $49.99 order can still go untracked and a $50.00 order cannot. The full wording is in the seller shipping guidelines. A plain stamp is not tracking: see TCGplayer order tracking explained for what counts.
If the import shows an error
- A tracking number is missing on an order over $49.99. Add it to the row and import again.
- An order did not change. Check that its Order Number cell was not edited, sorted away from its row or changed by the spreadsheet.
- A number looks wrong. If it ends in zeros or shows
E+21, the column was a number column. Re-enter it as text. - The file is not accepted at all. Re-export from the Orders tab and start again from the untouched file. Keep the header row exactly as it came.
- An order still says “shipping not confirmed.” See what “shipping not confirmed” means.
Common mistakes
- Typing tracking numbers in label order after sorting the sheet, so numbers land on the wrong orders. Match by Order Number.
- Writing Shipped without a carrier.
- Marking an order over $49.99 Shipped instead of giving it a real number.
- Saving the file as something other than CSV, or opening it in a tool that rewrites the headers.
- Waiting until the end of the week. Enter tracking as soon as you have it.
FAQ
How do I add tracking numbers to TCGplayer orders in bulk?
Export your orders from the Orders tab with Export Shipping, put each tracking number on the row for its Order Number, then upload the updated file with the shipping-info import in your Seller Portal. TCGplayer applies the numbers and sets the matching orders to Shipped.
Which columns does the TCGplayer shipping import need?
TCGplayer’s help article says the Order Number and the Tracking Number are the only required fields. Keep the file as the export wrote it: do not rename the headers, delete the header row or change the Order Number column.
How do I mark an order shipped when it has no tracking number?
Put the word Shipped where the tracking number goes and enter a carrier. TCGplayer says a carrier must be entered to ship an order without tracking. This suits low-value envelope orders only: orders over $49.99 need tracking. See TCGplayer order tracking explained.
What happens if I leave out tracking on an order over $49.99?
TCGplayer’s shipping guidelines require tracking over $49.99, and its import article says you get an error when you import without a required tracking number. Add the number and import again. See the seller shipping guidelines.
Why does my tracking number turn into 9.40011E+21 in Excel?
Excel treats a long tracking number as a number, keeps only 15 digits and shows the rest in scientific notation or as zeros. Format the tracking column as Text before you paste the numbers, or build the file in a tool that keeps them as text.
Can I use tracking numbers from Pirate Ship, USPS or PayPal?
Yes. The number comes from wherever you bought the postage. TCGplayer’s help center describes downloading tracking information from your shipping label provider and uploading it, so the order of work is: buy postage, copy the numbers, fill the file, import it.