How to Reprice Your TCGPlayer Singles EASY! Pricing with Spreadsheet Formulas

[@TheTimtwnsnd]

Didnt expect to see excel tips on my fav tcg channel - they really do mean it when they say Card n ALL amirite

[@brandonbarnhart5372]

My CSV file doesn’t have the column My Store Price. What am I missing?

[@videogametrader]

Great video. Thanks. I do have a couple questions. #1. I may have missed it. But once you do this update the first time. I assume, before you download your next "current" CSV from TCG Player, you need to delete your existing "previous" file and rename your "current" file to "previous". #2 Do you know an easy way to make the pricing calculation be an if statement so that if the reference price is under $3 it will be one calculation, Over $20 another calculation and then a final calculation if between $3 & $20? I may try and get Chat GPT to help me figure that one out. If I figure it out before you do I'll let you know. Thanks again for the video.

[@CNA-Games]

copied from FB group: 1: I rename previous to yesterday's date and put it in a folder for the month so I can keep all price update files. (not that I use them in any capacity or anything, but maybe that day will come eventually). I delete the current sheet (today's CSV export from TCGPlayer), and rename the output csv from the spreadsheet to previous so it is ready for use for the next price update. 2. that sounds like something to add to your marketplace price formula or multiplier (if you decide to use one). Would look something like: =IF([BASE PRICE]>20, (equation for over $20), IF([BASE PRICE]

[@Ifyouhavethecoin]

Why do this over something like using the mass price tool?

[@CNA-Games]

This process allows you to increase and decrease prices based on your own inventory history (along with setting variable price floors based on stock quantity), and gives you the ability to set your pricing using more data points with more customization options than what mass price offers.

[@videogametrader]

Mass Price doesn't give you enough choices. And only so many automatic rules. What I like about this is that it prices every card, even if you don't have it.

[@kyleip6204]

How do you change your store name?