Keeping a portfolio updated on platforms like Sedo, Afternic, and Dan can be a challenge. With sales and expiries happening on a regular basis, it can be easy to fall behind on updates. It is important to keep these portfolios updated so you don’t accidentally sell a domain name you previously sold or let expire.
I try to keep my portfolio updated in real time. When I sell a name on Dan, for example, I try to immediately delete the listing on Sedo and Afternic. When I let a domain name expire, I remove the listing from all platforms once I receive the final cancelation email. They key word is *try* and names sometimes slip through the cracks. Every once in a while I will do a comparison of my sale portfolios against my inventory list.
I am not a pro at Excel, but I want to share a step by step guide for how I am able to identify the names I previously sold or let expire that I forgot to remove from sales platforms:
- Step 1: Paste my current inventory list in column A of a new Excel spreadsheet.
- Step 2: Export data from sale platform. There is a different method for each platform.
- Step 3: Copy the domain names listed for sale and paste them into column B of the Excel spreadsheet.
- Step 4: Highlight column A and B.
- Step 5: On the Home section of the Excel spreadsheet, click “Conditional Formatting.”
- Step 6: Select “Highlight Cells Rules” from the dropdown menu.
- Step 7: Click “Duplicate Values.”
- Step 8: From the dropdown menu, select “Format only unique or duplicate values” formatted with light red fill.
- Step 9: Compare the sales platform portfolio to inventory.
- Step 10: If a domain name from the sales platform portfolio does not have red fill (highlight), it means it is not in the inventory list. The means the domain name was sold, expired, or there is a typo on one of the lists.
- Step 11: Delete any domain names that are no longer in inventory.
When I did this for my Sedo sales portfolio today, I found seven domain names listed for sale that should be deleted. Four had previously expired and three were about to expire. Importantly, this method requires that the inventory list is accurate.
Keeping a sales portfolio updated will help prevent a seller from selling a domain name that he or she no longer owns. There may be other better ways to do this, but this is how I do it.
I need to do this. Thank you for sharing the formulas. Very helpful Elliot.
You’re welcome.
There may be easier ways, but I found this helpful and not too difficult.
Very useful how-to! Thanks for sharing Elliot!
It had been a while since I had used Excel and last week enumerating a part of the domain portfolio went well.
There was still a lot to do, your post has gone very well.
Thanks for sharing Elliott!
I just download all the domains from my registrars, delete all the domains in Dan afternic sedo and let it sit empty for 2 days and upload the fresh domains back.
Easy peasy
Do that every 2 mths
And I put all my domains at minimum offer at $4999 ,this is to avoid low ballers.
The default is $20 and you gonna get spams
I sold so my hand reg domains….
Have you tried Domain.io? It does this for you — it monitors your portfolio by frequently checking the pricing on Dan/Afternic/Sedo and notifying you of any discrepancies. You can manage and adjust your portfolio pricing in one place and then export the individual CSVs to update Dan/Afternic/Sedo.
No I am not willing to share that information/data with a third party platform.