Tracking Multiple Accounts with Excel - How do you do it? - eBay Suspended & PayPal Limited Forums
eBay Suspension & PayPal Limited Forums  
Join Today
Register Subscribe
     

Registration is fast, simple and absolutely free so please, join our community today!


Go Back   Home > Stealth Topics > Multiple eBay & PayPal Accounts

Multiple eBay & PayPal Accounts General discussions on multiple eBay & PayPal accounts, VMs, user accounts, shipping and more.

Reply
 
Thread Tools
  #1  
Old 05-17-2008
Junior Member
 
Join Date: May 2008
Posts: 36
Thanks: 0
Thanked 0 Times in 0 Posts
Activity: 0%
Longevity: 91%
iTrader: (0)
Lightbulb Tracking Multiple Accounts with Excel - How do you do it?

When I first joined this site I couldn't wrap my head around how on earth I would keep all the accounts organized. Pre-suspension it was so easy because all of the info I used was true! But having multiple secret identities... jeebus! I searched the forums for some example spreadsheets others have used, but didn't really find anything I liked. So I made up my own and would like to share! And since I'm new at having multiple ⊗⊗⊗⊗ identities, please give me your input if you think there's more things I need to be keeping track of!! Every little bit of input helps

ebayhateluv and greenbean - how do you guys do it with sticky notes and index cards? You must be very organized! I'm terrible with paper


This is how I keep track of my accounts for now. The data in this spreadsheet is ⊗⊗⊗⊗, for demo purposes. I made it so the accounts automatically change color if they are "Suspended" or cooling down, so I don't accidentally use "infected" information from them or something. I also keep track of the account "age" in days.
I also made sure the fields are in order so when I want to register an account, I can figure out all the ⊗⊗⊗⊗ info in the spreadsheet and then it only takes a minute to copy and paste the stuff during registration.


My IP tracker is basic. The IP colors change if the IP address has become "infected" by a suspended account. And I keep track of the MAC addresses for my router so I can keep re-using the same IP's for each account. For example, jane857 will always have the IP address 55.444.222.33. I prefer keeping the IP's consistent per account, rather than getting a brand new random IP each time. I think it makes it look more believable that the account keeps logging in from the same location.

I also made these on access and linked the IP's to the Account names, but went back to using excel because it uses less system resources on the PC.

So this is what's been working for me so far. All of my new accounts are still active so it seems to be doing its job.

So what do your spreadsheets look like? Lets help each other be more efficient!
Reply With Quote
The complete step-by-step guide to get back to selling today!

  #2  
Old 05-17-2008
Junior Member
 
Join Date: Jan 2008
Posts: 117
Thanks: 0
Thanked 1 Time in 1 Post
Activity: 0%
Longevity: 93%
iTrader: (0)
Default

Wow!
Good Stuff!

I dont think tracking the MAC address is necessary though. (+if it was, im screwed :( )
Reply With Quote
  #3  
Old 05-17-2008
Junior Member
Threadstarter  
 
Join Date: May 2008
Posts: 36
Thanks: 0
Thanked 0 Times in 0 Posts
Activity: 0%
Longevity: 91%
iTrader: (0)
Default

Oh I don't track the MAC address for ebay. I need each MAC address in order to receive the exact same IP address per account. Each account I have has a specific IP address associated with it, but in order to retrieve the same IP each time, I need to know the MAC addy. I think this is a good tip for those of you who have dynamic IP's!

So sneakily enough, I think it makes it looks like each account keeps logging in from the same PC
Reply With Quote
  #4  
Old 05-17-2008
GreenBean's Avatar
Executive [VIP]
 
Join Date: Sep 2007
Posts: 42,343
Thanks: 5,612
Thanked 9,136 Times in 7,105 Posts
Activity: 0%
Longevity: 96%
iTrader: (6)
Default

Double WOW. I like color co-ordination!
__________________
REAP WHAT YOU SOW. LIFE IS SO NOT FAIR.
Reply With Quote
  #5  
Old 05-17-2008
Junior Member
 
Join Date: Jan 2008
Posts: 117
Thanks: 0
Thanked 1 Time in 1 Post
Activity: 0%
Longevity: 93%
iTrader: (0)
Default

Indulge this techie noob.

How do you get the same IP from a MAC address..and how do you get the same MAC address. :D
Reply With Quote
  #6  
Old 05-17-2008
jscan's Avatar
Executive [VIP]
 
Join Date: Jan 2008
Posts: 648
Thanks: 3
Thanked 10 Times in 9 Posts
Activity: 0%
Longevity: 94%
iTrader: (0)
Default

wow thats is great, mine is just a basic excel document, yours is pro great job
Reply With Quote
  #7  
Old 05-18-2008
Junior Member
Threadstarter  
 
Join Date: May 2008
Posts: 36
Thanks: 0
Thanked 0 Times in 0 Posts
Activity: 0%
Longevity: 91%
iTrader: (0)
Default

Quote:
Originally Posted by MasterChief View Post
Indulge this techie noob.

How do you get the same IP from a MAC address..and how do you get the same MAC address. :D
I have a router connected to my modem. When I edit the MAC address of the router, the ISP then assigns an IP address to associate with that MAC address until it expires.

For instance, I'll make a new account called Account2. Before I register anything I make an IP that will associate with it. So I go to my IP spreadsheet, copy one of the old MAC addresses and change a couple letters and numbers so its new and unique. When I restart the modem, a new IP is assigned! So now I use this IP for doing anything online associated with Account2.

Now when I need to go back and edit my old Account1, I change the MAC address back, restart the modem, and my old IP comes back! Keep in mind that Dynamic IP's expire anyway, so eventually a new IP might replace the old one. But whatever it changes to, it will keep using that until that one expires too! And so on.

I like being able choose specifically which IP the modem will be retrieving for me Less IP's to keep track of!

I'm not too good at explaining things, but I hope that makes sense!
Reply With Quote
  #8  
Old 05-18-2008
Junior Member
 
Join Date: Jan 2008
Posts: 117
Thanks: 0
Thanked 1 Time in 1 Post
Activity: 0%
Longevity: 93%
iTrader: (0)
Default

Makes perfect sense, but as I said, Im Noob..

How do you choose the MAC address of the router? Something inbuilt I gotta figure out or a program from the net? I ask cause I got a router at home myself. Never knew I could use it to get a static IP.

Last edited by GreenBean; 05-18-2008 at 05:13 AM.
Reply With Quote
  #9  
Old 05-18-2008
aspkin's Avatar
Administrator
 
Join Date: Jan 2007
Posts: 11,376
Thanks: 3,071
Thanked 4,197 Times in 1,780 Posts
Activity: 16%
Longevity: 100%
iTrader: (24)
Default

Very nice Junkymail, great information!
__________________
Reply With Quote
  #10  
Old 05-18-2008
Junior Member
Threadstarter  
 
Join Date: May 2008
Posts: 36
Thanks: 0
Thanked 0 Times in 0 Posts
Activity: 0%
Longevity: 91%
iTrader: (0)
Default

MasterChief - is your name based on the game Halo? If so, I loved that game lol

Quote:
Originally Posted by MasterChief View Post
Makes perfect sense, but as I said, Im Noob..

How do you choose the MAC address of the router? Something inbuilt I gotta figure out or a program from the net? I ask cause I got a router at home myself. Never knew I could use it to get a static IP.
The program to change the settings is built into your router To access it, you just use your web browser. You can check your manual how to access your routers settings. But for most routers I've owned, the address has been 192.168.0.1 - Just type that where you would normally type the web address. You need to know the username and password as well if you never logged in before. check your manual for those.

So this is what my screen looks like to change the MAC address:


And with that MAC address I always get this IP
Reply With Quote
  #11  
Old 05-18-2008
Junior Member
Threadstarter  
 
Join Date: May 2008
Posts: 36
Thanks: 0
Thanked 0 Times in 0 Posts
Activity: 0%
Longevity: 91%
iTrader: (0)
Default

And thank you everyone for the compliments! I guess the stuff I learned in school came to use, huh?
Reply With Quote
  #12  
Old 05-18-2008
Junior Member
 
Join Date: Apr 2008
Posts: 451
Thanks: 1
Thanked 0 Times in 0 Posts
Activity: 0%
Longevity: 92%
iTrader: (2)
Default

im impressed, good job
ima copy you now =D
thank youuuu
Reply With Quote
  #13  
Old 07-17-2008
Junior Member
 
Join Date: Apr 2008
Posts: 249
Thanks: 14
Thanked 28 Times in 20 Posts
Activity: 0%
Longevity: 92%
iTrader: (2)
Default

Does anyone know if this router mac hack works for comcast??? You may have just solved the "can't change my ip issue" with comcast...Man. I can't wait to go home and try this!
Reply With Quote
  #14  
Old 07-17-2008
philly387's Avatar
Executive [VIP]
 
Join Date: Jul 2008
Posts: 1,634
Thanks: 75
Thanked 133 Times in 82 Posts
Activity: 0%
Longevity: 90%
iTrader: (3)
Send a message via Yahoo to philly387
Default

Quote:
Originally Posted by guitarca18 View Post
Does anyone know if this router mac hack works for comcast??? You may have just solved the "can't change my ip issue" with comcast...Man. I can't wait to go home and try this!
I wouldn't really say it is a "hack". It is just an easy way to change from one IP to another. And yes it will work for Comcast
Reply With Quote
  #15  
Old 07-17-2008
Junior Member
 
Join Date: Oct 2007
Posts: 48
Thanks: 0
Thanked 6 Times in 2 Posts
Activity: 0%
Longevity: 95%
iTrader: (0)
Default

But I could swear that Comcast doesn't work using Dynamic IPs. To receive a new IP, you normally have to get someone on their end to assign a new Ip to you.
Reply With Quote
  #16  
Old 07-21-2008
Junior Member
 
Join Date: Jun 2008
Posts: 8
Thanks: 0
Thanked 1 Time in 1 Post
Activity: 0%
Longevity: 91%
iTrader: (0)
Default

Changing the mac address works great with comcast. Thank a bunch junkymail for the excel template.
Reply With Quote
  #17  
Old 07-22-2008
Exeneva's Avatar
Banned
 
Join Date: Apr 2008
Posts: 337
Thanks: 4
Thanked 8 Times in 4 Posts
Activity: 0%
Longevity: 92%
iTrader: (1)
Default

Junkeymail, would you mind sending me one?
Reply With Quote
  #18  
Old 11-10-2008
aking's Avatar
Executive [VIP]
 
Join Date: Aug 2008
Posts: 2,571
Thanks: 243
Thanked 216 Times in 175 Posts
Activity: 0%
Longevity: 90%
iTrader: (1)
Default

How do people keep listings and sales organized with mulitple accounts? I have about 10 accounts aging and ready to sell but I am only listing on 2 at the moment. I want to list on 4 accounts with about 10 listings each, but I am afraid this will just get too confusing and time consuming. Maybe I will try to things up in excel. Just gradually start adding accounts until I get used to it.

I really feel like I need another router so I can access 2 different ip address's simultaneously.

Does anyone here currently sell on more than 4 accounts? If you could help that would be awesome. Thanks.

Last edited by aking; 11-10-2008 at 12:12 PM.
Reply With Quote
  #19  
Old 11-10-2008
Here We Go Again's Avatar
Executive [VIP]
 
Join Date: Sep 2008
Posts: 2,359
Thanks: 192
Thanked 694 Times in 329 Posts
Activity: 0%
Longevity: 89%
iTrader: (1)
Default

On any given week I am selling on about 4-6 different accounts.
I am running 8-10 accounts as seller accounts. I have 20+ accounts in reserve.
I use Excel to keep all the information straight.
It can get overwhelming at times for sure. You just have to go slow to keep it all straight.
__________________
Once you go Mac you will never go back
Reply With Quote
  #20  
Old 11-10-2008
aking's Avatar
Executive [VIP]
 
Join Date: Aug 2008
Posts: 2,571
Thanks: 243
Thanked 216 Times in 175 Posts
Activity: 0%
Longevity: 90%
iTrader: (1)
Default

Wow, no wonder you are glossing 10,000+/month.

I assume you sell on ebay full time with this many accounts.

Last edited by aking; 11-10-2008 at 09:05 PM.
Reply With Quote
  #21  
Old 11-13-2008
Junior Member
 
Join Date: Sep 2008
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Activity: 0%
Longevity: 89%
iTrader: (0)
Default

I dont have any info manuel w/ my router. Would the best solution then be to spend the $$ just to buy a new one in order to make all the above advice from junkymail regarding changing mac addresses happen?
Reply With Quote
  #22  
Old 11-27-2008
Junior Member
 
Join Date: Sep 2008
Posts: 39
Thanks: 2
Thanked 0 Times in 0 Posts
Activity: 0%
Longevity: 89%
iTrader: (0)
Thumbs up Multiple accounts around same city?

Hi,
is it a good idea to set up say 10 new ebay accounts in a period of about 1 week, all of them with addresses in the same city, say, chicago, or denver, or la, etc.?, or it would be too suspicious to ebay?

Thanks.
Reply With Quote
Reply



Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



Aspkin Group

All times are GMT -5. The time now is 07:08 AM.


Stop the guessing games and learn how you can quickly and easily get back on eBay today!
Read the best selling step-by-step eBay Suspension guide eBay Stealth!
Amazon Suspension? Read Amazon Ghost to get back on Amazon!
vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Ad Management by RedTyger
no new posts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58