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

[@VA-ng2ve]

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]

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]

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

[@FaryaWolyo_]

@@keepthehobbyalive3647 Yes, but it requires multiple rules. What I do is set price floors by category for cards. So for example the process looks like: 1. I have a rule for all modern foils that sets them to market price. If market price is below $0.12, it instead sets them to $0.12. (By using a "fixed value" minimum of $0.12) 2. Run a second rule that targets all of the same expansions and exact same print type. With this rule, have it set your prices to "current TCG Marketplace price," but on the minimum tab use "TCGP Direct low" When you do it this way and there's a Direct low, your price won't be lower than it. However, you can otherwise maintain your price floors for different print types and eras of cards. Best of both. Pro Tips: Give your rules naming conventions that help you identify what order to run them in, such as: 1.) Modern Foils (Market-Fixed) 2.) Modern Foils (Current-Direct) Create your rules in the ORDER you want to run them, because you'll end up making enough that you'll have to go through multiple pages and refreshes in order to run all of them, and because there's not currently any way to reorganize your rules... Finally, to speed up the process of using mass price (since the website is a bit sluggish) when navigating between rule pages DON'T simply click "rules" and then select the page tab. Instead, use the URL in your browser to navigate faster. Want to go straight to page 4 because you have 10 rules to run there? Copy and paste your page 4 url. Or, change the URL number to 3/2 in order to change what page you're navigating to. Hope this helps, this is all of my MassPrice wisdom! :)

[@FaryaWolyo_]

@@keepthehobbyalive3647 I gave a super detailed explanation and it didn't go through. :(

[@Mutoforma]

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

[@TCGBulkKings]

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

[@VA-ng2ve]

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

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

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

[@superheman]

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

[@superheman]

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.

[@TheCardFatherTCG]

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]

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]

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

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

[@RPT111]

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]

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]

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

[@andrewkrause2179]

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]

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

[@superheman]

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]

Seems legit 😂

[@Rubiksguy]

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

[@Palatopia]

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

[@TCGBulkKings]

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]

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

[@TCGBulkKings]

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

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

[@TCGBulkKings]

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

[@KingZarathus]

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]

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

[@christhemagnif]

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]

For sure, with the power of spreadsheets =]

[@le_med]

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]

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

[@kylekppack7978]

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.

[@MysteriousSoulreaper]

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

[@TCGBulkKings]

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

[@christhemagnif]

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

[@TCGBulkKings]

I believe in you

[@tjpalme4298]

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]

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

[@TheBuffetBar]

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

[@TCGBulkKings]

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]

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

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

[@DeathgripsCards]

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]

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]

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

[@vegasmoney7247]

I haven’t seen a video on it or maybe I just haven’t found it yet. I’m getting direct soon and I had some questions. Do you have a floor price for inputting cards into your inventory? How do you price your items for direct. I’ve recently been putting everything in my inventory and setting the floor of commons/uncommons at .05 cents. Sparingly some have sold but I’m worried once I go direct things like this could be bad for how feed are structured through direct. I was wondering if you had any recommendations as I’m slowly trying to piece together more information from your videos

[@TCGBulkKings]

I've talked about this a lot, but yeah, I do have a floor price. I experiment with this up and down sometimes. Currently I'm not listing below $.10, but sometimes I've been at $.05. My breakeven on non-Direct orders is around $.10 of product, so that's where I'm sitting right now. I don't see there being a problem with the Direct fee structure if you go to $.05 though, I think you get paid out $.03 for orders of $.05, so really not too bad

[@TachibanaTengoku]

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]

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

[@Ifyouhavethecoin]

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

[@TCGBulkKings]

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

[@bad_dreams2346]

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]

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]

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

[@mtgmocksman1407]

21000 emails? Seeing that drives me mental

[@TCGBulkKings]

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

[@BENDEL420]

This helped me a lot, but have a question, I added the floor price function to excel. Can I add a second function that says I add .04 to any card inventory less than .24? I don’t seem to be combing them correctly or something

[@TCGBulkKings]

I'm sure you can figure something out, but I'm not really sure what you're looking for at the end, so I can't advise you specifically. You might have to do an extra column or two of price manipulation to get it to work the way you want. Best of luck!

[@BENDEL420]

@@TCGBulkKings I want to add .02 to the marketplace price of all my inventory that’s under .24$. Thanks I’ll keep trying.

[@VitoD226]

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

[@TCGBulkKings]

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]

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

[@DeathgripsCards]

What excel program are you using I tried to do this with Google Sheets and I couldn't get it to work

[@TCGBulkKings]

I usually use Open Office. I think with Google Sheets and Excel you have to use commas instead of semicolons, elsewise the formulas may be slightly different, you'll have to check in the documentation for the program you're using unfortunately

[@keepthehobbyalive3647]

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]

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]

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

[@le_med]

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]

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.

[@Julnlecs86]

I would have watched the 30 minute video.

[@TCGBulkKings]

💜