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

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

Күн бұрын

** 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.

Пікірлер: 73

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

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 11 күн бұрын

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 10 күн бұрын

@@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?

@Mutoforma 12 күн бұрын

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

@TCGBulkKings 12 күн бұрын

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

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

@@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 12 күн бұрын

@@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 11 күн бұрын

@@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.

@RPT111 11 күн бұрын

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 11 күн бұрын

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 11 күн бұрын

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

@andrewkrause2179 10 күн бұрын

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 10 күн бұрын

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

@superheman 3 күн бұрын

i had replied with this to my old comment, but to give it more visibility, i'll post it on its own again, hope it helps someone. I just got into the direct program today, so I had to come revisit this. In excel I settled this with an ifs statement with the understanding that directly is generally higher than tcg low, and i still want to undercut. =IFS(L2=L2,J2-0.01,L2>0.05,L2-0.01) Ifs work by IF the statement is true, then make the value whatever after the comma, it's just 2 parts that escapes on the then if met unlike a normal if then else. so first part is the low under a nickel which is my floor price, if so set to .05, else if check if tcg direct is higher than or equal to low, then sets to direct minus a penny elseif it's neither extreme and just a standard pricing so i check over .05 and make it the tcg low minus a penny. and that's what i'm currently going with. Open to feedback.

@TCGBulkKings 3 күн бұрын

Seems legit 😂

@Rubiksguy 7 күн бұрын

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

@TheCardFatherTCG 12 күн бұрын

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 12 күн бұрын

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 12 күн бұрын

@@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 12 күн бұрын

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

@superheman 10 күн бұрын

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

@superheman 3 күн бұрын

I just got into the direct program today, so I had to come revisit this. In excel I settled this with an ifs statement with the understanding that directly is generally higher than tcg low, and i still want to undercut. =IFS(L2=L2,J2-0.01,L2>0.05,L2-0.01) Ifs work by IF the statement is true, then make the value whatever after the comma, it's just 2 parts that escapes on the then if met unlike a normal if then else. so first part is the low under a nickel which is my floor price, if so set to .05, else if check if tcg direct is higher than or equal to low, then sets to direct minus a penny elseif it's neither extreme and just a standard pricing so i check over .05 and make it the tcg low minus a penny. and that's what i'm currently going with. Open to feedback.

@christhemagnif 10 күн бұрын

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 10 күн бұрын

For sure, with the power of spreadsheets =]

@kylekppack7978 12 күн бұрын

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.

@KingZarathus 12 күн бұрын

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 12 күн бұрын

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

@PalatopiaTCG 12 күн бұрын

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

@TCGBulkKings 12 күн бұрын

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 10 күн бұрын

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

@TCGBulkKings 10 күн бұрын

@@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 10 күн бұрын

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

@TCGBulkKings 10 күн бұрын

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

@christhemagnif 10 күн бұрын

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

@TCGBulkKings 10 күн бұрын

I believe in you

@le_med 12 күн бұрын

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 12 күн бұрын

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

@tjpalme4298 9 күн бұрын

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 9 күн бұрын

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

@MysteriousSoulreaper 12 күн бұрын

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

@TCGBulkKings 12 күн бұрын

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! =]

@TheBuffetBar 11 күн бұрын

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

@TCGBulkKings 10 күн бұрын

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 10 күн бұрын

@@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 10 күн бұрын

@@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 12 күн бұрын

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 12 күн бұрын

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 12 күн бұрын

@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.

@DeathgripsCards 4 күн бұрын

Awesome video, thanks so much for all the help throughout your videos, do you ever have trouble getting a hold of TCGplayer help staff? They seem to have begun to ignore me no matter what I do. Have you ever had to deal with a problem like this with them?

@TCGBulkKings 4 күн бұрын

I have only rarely had to reach out to them, and they have usually gotten back with me within a day or two. I have heard anecdotes of people who have a really hard time with dealing with TCGplayer help though. Wish I had some advice to give you that wasn't just "be both tenacious and patient" =[ Hope it gets resolved for you soon

@DeathgripsCards 3 күн бұрын

@@TCGBulkKings thanks for the answer, its awful they just ignore me until i throw a fit and then they half ass an answer, like maybe i wouldn't build up into having such an attitued if i was answered even the 5th time I asked.

@Ifyouhavethecoin 12 күн бұрын

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

@TCGBulkKings 12 күн бұрын

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

@keepthehobbyalive3647 10 күн бұрын

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 10 күн бұрын

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 10 күн бұрын

@@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

@mtgmocksman1407 12 күн бұрын

21000 emails? Seeing that drives me mental

@TCGBulkKings 12 күн бұрын

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

@TachibanaTengoku 12 күн бұрын

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 12 күн бұрын

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 12 күн бұрын

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

@TCGBulkKings 12 күн бұрын

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 12 күн бұрын

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

@le_med 9 күн бұрын

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 9 күн бұрын

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.