Use the FILTERED CSV Tool On TCGplayer Instead of the Pricing Tab!

Рет қаралды 1,731

7 күн бұрын

** If you decide to emulate the pricing strategy I use in the video, please PLEASE be careful. This will price cards with $0 TCGplayer Direct Low at $.10 - even if they are $100 cards! I am not typically listing cards like that, so I'm not usually in much risk of making a mistake like this, but please be careful and use your brain when listing this way! **
I am more than secure enough to admit when I have done something wrong. And I am more than humble enough to do whatever I can to undo the wrong that I have done. I know that I am not entirely at fault for this, as TCGplayer has done nothing to let anyone know that this issue is real, that it is avoidable, and that this tool of theirs - that I've been recommending AND using for YEARS - is inherently flawed and will create inventory issues for anyone using it. But I do honestly feel I should have used a more critical thinking mindset when examining this tool in the past. That was a much younger, much less wise, Chase from eons passed though. I'm doing what I can to let you know now so you can either correct the issue for yourself, or never fall prey to the trap that is the Pricing tab.
TCGplayer's surprisingly good tutorial article about using filtered csv listing here: help.tcgplayer.com/hc/en-us/a...
🔔 Don't forget to subscribe and hit the notification bell to stay updated on our latest videos!
If you found this video helpful, give it a thumbs up and share it with fellow online store owners!
Share your experiences and thoughts in the comments below. We'd love to hear from you!
My website www.tcgbulkkings.com is the central hub to all my various social media enterprises. If you want to buy from the Shop or sell bulk to me, make sure you at least have a Free account, and if you want to support what I'm doing, or just get a decent discount in the Shop and a bit of free merch, go ahead and sign up for one of the Memberships! Cheers!
"If you make sales to get customers, rather than get customers to make sales...
You make the customer the goal." ~Alex Hormozi
Hey, it's not exactly card related, but trips to the post office or to buy that next collection cost gas, right? That's a real concern if you have to travel an hour or more to pick up your next bulk haul. Why not save some gas with the Upside app? It finds you cash back deals at gas stations, convenience stores, and restaurants all around you. Use my invitation code "TCG8275" when you sign up to get an extra $.15 per gallon cash back on your first transaction! Support yourself, and support the channel!
CardDealerPro: www.carddealerpro.com Use the code "TCGBulkKings" when signing up to Card Dealer Pro to receive 500 FREE Scans! Now scanning TCG cards and Non-sport cards!
Shop for supplies from BCW here: www.bcwsupplies.com/?acc=tcgb... . They have your solution for boxes, sleeves, team bags and top loaders, deckboxes, &c. Use code "tcgbulkkings" at checkout to get 10% off your order and help support my channel!
If you're looking for BCW Supplies but live in the UK, then follow this link for CollectorFit: collectorfit.com/?ref=Rnu61Ey... . They also have a 10% off coupon for using my code 'tcgbulkkings', and can import anything you'd need.
Shop for cards from me at these places:
TCG Bulk Kings Shop: tcgbulkkings.com/shop/
TCGplayer: tcgbulkkings.tcgplayerpro.com/
TCG Bulk Kings on Ebay: www.ebay.com/str/tcgbulkkings
TCG Bulk Kings on BuySportsCards: www.buysportscards.com/Seller...
Boltless Shelf Unit: sovrn.co/wex73l1
Use the shelves from two of these to make the shelves as I have them in the video. This is an affiliate link, so I'll get a little kickback if you get them through this link. But you don't have to obviously, these were just the most affordable ones I could find that fit my specs
FREE Card Conditioning Template: tinyurl.com/38bvtnpt
**Subscribe for more TCG bulk news, value, and just plain fun: / @tcgbulkkings **
Epson Eco-Tank ET-2803: sovrn.co/138fwfs
A serious time saver, pick up a self-inking return address stamp here: sovrn.co/z6cas43
To try out the original green card shipping protection, check out Shipping Shields: shippingshieldus.com/?ref=753 If you make a purchase through this link, or following from my Shop on my website, I get a little bit of a commission, which really helps me out in the long run.
Obviously, some of the links above are affiliate links, which will involve me getting a commission if you buy something from them. It's cool either way though, you don't have to get anything. If you need any of these kinds of things though, and you want to support me, consider doing so through one of these links.

Пікірлер: 67

@VA-ng2ve 4 күн бұрын

One major issue with that specific if statement. You are going by direct low only. Sometimes there is no direct low price. So it will set it to 10 cents. When the market price is say 30 cents. If you instead get the highest value of market price and direct low, then set it to 10 cents, that will stop that. There will always be a marketplace price, but not always a direct low price. As for setting it via the pricing tab, you can do that if you don't have any cards in it. And or if you constantly refresh your RI and orders page before you save any changes. That will make sure you don't have any issues. But the .csv import will be easier/more fool proof of not having extra cards in inventory.

@TCGBulkKings 4 күн бұрын

Yeah I've realized it's got some potential issues with the spreadsheet jiggery-pokery. I'll mess around with it and update you all on what I eventually settle on, as well as try to make sure it or some version of it works with most popular spreadsheet programs

@keepthehobbyalive3647 3 күн бұрын

@@VA-ng2ve is there anyway to set in the mass price tool to go to direct low and if it’s not there to do market price?

@Rubiksguy 7 сағат бұрын

You can also start typing the set name and it jumps right to it. Don’t need to scroll all the way

@Mutoforma 5 күн бұрын

They should probably just change the "Total Qty" field to "Add to Qty", and adjust their logic accordingly.

@TCGBulkKings 5 күн бұрын

That is one EXTREMELY LOGICAL solution to this on TCGplayer's end, yes

@VA-ng2ve 4 күн бұрын

@@TCGBulkKings The total quantity is there to show you how much you already have in stock. It is useful information. If you don't need it, and or it may confuse you, you can simply delete the column and it will not hurt anything when you upload the .csv

@TCGBulkKings 4 күн бұрын

@@VA-ng2ve I believe what is meant is that TCGplayer should modify their pricing tab page to have 'add to qty' as the field you enter, rather than 'total qty'

@VA-ng2ve 4 күн бұрын

@@TCGBulkKings Yeah if the Pricing page had an add qty as well, that would help quite a bit. I'd say they also need the tcgdirect low price on the pricing page as well.

@andrewkrause2179 3 күн бұрын

There is an issue with TCGplayer where if a item goes into a buyers cart and the payment is declined it will remove it from your inventory but not actually sell your card. Now you will have a card in your inventory that isn't listed on TCGplayer anymore. I believe there are more issues than just payment declined, but that is the only one I know for sure.

@TCGBulkKings 3 күн бұрын

Oh, this is like the opposite of ghost inventory. Zombie inventory? Lol

@RPT111 4 күн бұрын

You are the seller TCG Bulk Kings??? Dude! You have a great shop! I didn't even watch the whole video before I left this comment.

@TCGBulkKings 4 күн бұрын

Yeah, that's me /homestarrunner Thanks for your kind words! Which shop or marketplace have you seen me on, if you don't mind me asking?

@RPT111 4 күн бұрын

@@TCGBulkKings TCGplayer. You're channel was just now suggested on my home page. I didn't even know you had one.

@superheman 3 күн бұрын

I ended up doing my statement like this "=IF(L2

@TheCardFatherTCG 5 күн бұрын

I just had to cancel an order because of the "Ghost Inventory" issue and that it is consistently becoming an issue. I've escalated this to TCGPlayer a few times with no response. Thanks James for bring this to light!

@TCGBulkKings 5 күн бұрын

Like I said, I was under the impression that zero inventory issues were systemic, but all human errors (I'm much more prone to blame myself for things, rather than what appears to be a well designed system). But this turned out to be a clearly defined case - that I had been pointing people towards - in which you will necessarily eventually create ghost inventory.

@TheCardFatherTCG 5 күн бұрын

@@TCGBulkKings Absolutely! Especially for games that aren't in Quicklist. I'm also in the GAP program and consistently been telling my advocate about this issue. The other problem is that hitting save after entering on the pricing tab doesn't update the pricing tab. You have to refresh multiple times for the new inventory to show. I've been having to shut off my inventory when I'm uploading new quantities to keep from this issue occurring.

@TCGBulkKings 5 күн бұрын

Then I strongly suggest swearing off the Pricing tab and use this filtered csv method instead =]

@kylekppack7978 5 күн бұрын

Very neat! I list a lot with the scanner app though. I just ordered the new tcgarchivist machine and im hoping it helps with scanning speed. Constant battle trying to get all inventory online.

@PalatopiaTCG 5 күн бұрын

Thank you so much! The price floor formula you shared just saved me tons of annoying scrolling and copy pasting! :)

@TCGBulkKings 5 күн бұрын

Just be careful you aren't adding cards at low prices that are actually high value but don't have a Direct Low price - this was just pointed out to me, and isn't usually an issue for me, but definitely something to be aware of =] Glad to be helpful!

@keepthehobbyalive3647 3 күн бұрын

@@TCGBulkKings how do you know this information though without checking one by one every card?

@TCGBulkKings 3 күн бұрын

@@keepthehobbyalive3647 they don't make it easy. I've learned recently that you can see the direct low price on the filtered csv that I describe in the video. I have two rules for my direct games timing in massprice, one that references market price to catch everything, then a rule referencing direct low to catch all the Direct product

@keepthehobbyalive3647 3 күн бұрын

@@TCGBulkKings only way is to use csv files I am assuming right?

@TCGBulkKings 3 күн бұрын

@@keepthehobbyalive3647 to see beforehand what's in direct, yeah, other than checking each card individually x.x

@christhemagnif 3 күн бұрын

One cool thing I’ll probably use this for is to bulk add floor prices to sets. I’m sure I can add my floor price to all the $0.01 cards much faster on the csv than in the pricing tab.

@TCGBulkKings 3 күн бұрын

For sure, with the power of spreadsheets =]

@KingZarathus 5 күн бұрын

Thanks for the update, this looks like a much better way! For setting the price it should also work as: =MAX(.1,J2) I'm not in direct so I'll probably do it as; =MAX(.1,K2-1.22)

@TCGBulkKings 5 күн бұрын

I'm going to have to fiddle with it, that's just where I'm at now. I've been made aware I might be pricing things at $.10 that are actually highly valuable but just don't have a Direct Low price, so I'm going to play around with it and find something that works better for me

@MysteriousSoulreaper 5 күн бұрын

Excellent video, very thorough, and appreciate you admitting you've technically been giving bad advice (compared to the alternative mentioned here).

@TCGBulkKings 5 күн бұрын

Hey, I'm just glad to be helpful. If I'm doing /not/ that, then I've got to fix it. Thanks for your kind words! =]

@tjpalme4298 2 күн бұрын

Hey there dude, thanks for the vid this is helpful. I just got invited into the seller development program the other day. How has your experience been with that so far?

@TCGBulkKings 2 күн бұрын

It's been okay. My biggest issues involve being able to spend enough time to do the things I want to do, rather than a lot of the efficiencies they were recommending at first. I'm already doing things like organizing my inventory properly and batching processes, things like that. So my biggest takeaways are things like this - pieces of information I didn't know that I didn't know. Definitely worth the time, as there is always room for another voice of wisdom to take from whatever might help

@christhemagnif 3 күн бұрын

Man I wish my sales velocity was such that this would be a problem 😂

@TCGBulkKings 3 күн бұрын

I believe in you

@le_med 5 күн бұрын

You just need a save button always showing on the page in the top of the page centered hovering or on the right of each column. It is TCG s problem and they should fix it

@TCGBulkKings 5 күн бұрын

I mean, there is always a button, but even so, you'd need a refresh button too, and that's just so tedious. It should just be able to account for items that sell while editing the inventory. Honestly, it should just do the csv thing in the background, but with the in-browser interface

@TheBuffetBar 3 күн бұрын

This caught me too. Took me awhile to figure it out

@TCGBulkKings 3 күн бұрын

I never did, on my own, had to make an embarrassing video about how it was really all your own faults and then get called out on it x.x

@TheBuffetBar 3 күн бұрын

@@TCGBulkKings I learned it and then it was also confirmed to me during a GAP session. Live and learn I guess but at least you had the courage to eat your own words. Not everyone would.

@TCGBulkKings 3 күн бұрын

@@TheBuffetBar honestly, I love finding out I'm working out I've screwed something up, as long as it isn't like existentially drastic. I've learned this about as immensely and fully as one can, won't be making mistakes like this anymore lol

@bad_dreams2346 5 күн бұрын

Ive had this issue as well. I have found that if i fill my orders out before i add inventory, it negates the issue. Im definitely going to try the csv method however, now that im much better at excel than i was. I always seemed to use the inventory tab, never used the pricing tab, other than mass price.

@TCGBulkKings 5 күн бұрын

The main issues I'm referring to is receiving orders while the Pricing tab is open and actively modifying the inventory, not orders received earlier or on a previous day. If even these are causing issues with the Pricing tab, then this issue is much worse than I thought.

@bad_dreams2346 4 күн бұрын

@TCGBulkKings yessir. I began to blame tcgplayer on this, but as you said, it's all really human error, just in the way we are interacting with a "dumb" system. It simply doesn't know any better. When your using the xls, it's an add to, getting around that "dumb" part of the system, which you did a fantastic job explaining btw. I changed my system on how I do it, through inventory, I stick to only adding the exact number of cards I'm adding, regardless of whatever it says I have. It seems to work. As by that time I've already sorted my cards going in to my left, and where they are going into card boxes on my right. This way, the ones that sell mid stroke, as it were, look erroneous, until that order is filled. It also gives me a quick check on that total as I physically put them in inventory. Excel seems easier.

@keepthehobbyalive3647 3 күн бұрын

Do you know why when using the mass pricing tool that it wouldn’t change some of the cards to the floor price that you named but it does it for a lot of the others?

@TCGBulkKings 3 күн бұрын

Usually if the rule is triggering off of something that doesn't have a value. I found that if I was tying prices to Direct Low, and it for some reason didn't have a Direct Low price (either because TCGplayer didn't have any stock or no Direct sellers had the card listed), then it would just skip changing that price

@keepthehobbyalive3647 3 күн бұрын

@@TCGBulkKings ok I do have it set to TCG direct low and then a floor of .10 but I noticed a card sold for .04 and had no idea why

@TachibanaTengoku 5 күн бұрын

I'm gonna be honest, I really don't think it would actually work that way using pricing tab, and I have some store credit to test this if you want to. We will decide on a card beforehand and I will purchase it when you have it open in pricing tab, after my purchase goes through you hit save and see if it increases incorrectly I manually list or use csvs anyways I pretty much never use pricing tab because it doesn't work that well for how I sort my digimon

@TCGBulkKings 5 күн бұрын

I brought it up with someone at TCGplayer, and they confirmed this issue exists, and directed me to using csv listing instead =[ But I'm not against a real-world test if you wanna do that sometime via Discord

@VitoD226 5 күн бұрын

Unrelated question - do you do international sales on TCGplayer? If not, why?

@TCGBulkKings 5 күн бұрын

I don't, mainly because I don't want to figure out shipping. I offer free shipping on my domestic orders, and don't want to have to figure out a shipping price for int'l orders for different countries. Most of my orders are shipped without tracking too, being mostly relatively inexpensive cards. Also, in a past life, selling used books, I had a lot of issues with international orders and customs and things not arriving (or being claimed that they hadn't arrived). If you are not in the US and want to order something from my website, let me know and we can get it figured out, but there are too many variables to have blanket international shipping policies on platforms I don't exclusively own myself.

@VitoD226 4 күн бұрын

@@TCGBulkKings thanks for the answer! I’m an American seller and was curious on how to expand. Your channel has helped alot.

@Ifyouhavethecoin 5 күн бұрын

Didn't know this but with my scanner and software thankfully i don't have to mess with that

@TCGBulkKings 5 күн бұрын

Yeah, this is more an issue for those still on the way up. Scanners have their own issues =]

@mtgmocksman1407 5 күн бұрын

21000 emails? Seeing that drives me mental

@TCGBulkKings 5 күн бұрын

Lololol! I wish I had the patience to delete all the "such and such has sold on tcgplayer" and "this and that has successfully been listed on ebay" emails. I have learned to ignore them too hard to bother with setting up filters x.x

@le_med 2 күн бұрын

I looked at your shop and you don t list conditions for the cards. Is that on purpose or because you don t have the time. I only looked at your magic cards maybe for others its different but I m interested in hearing why

@TCGBulkKings 2 күн бұрын

I /do/ list conditions for the cards? I have struggled with how to efficiently include a full description of each card's particular wear, but the condition of each card is listed in the description.