• We would like to welcome Sprezzabox to the Styleforum family as an official Affiliate Vendor! SprezzaBox is a monthly subscription service for men, delivering a unique selection of fashion and lifestyle accessories right to your doorstep.

  • STYLE. COMMUNITY. GREAT CLOTHING.

    Bored of counting likes on social networks? At Styleforum, you’ll find rousing discussions that go beyond strings of emojis.

    Click Here to join Styleforum's thousands of style enthusiasts today!

Something I made - eBay Search Creator

XenoX101

Distinguished Member
Joined
Aug 25, 2008
Messages
4,763
Reaction score
20
Hello So the deal is I've made this spreadsheet in excel that collates a bunch of brands, clothing items and sizing into a convenient search web address and/or search string. It took me about 2 months and is the first time I've had to delve into macros, to be honest if I knew of the time and effort I'd end up spending on this thing I wouldn't have bothered, but its done now and I'm pretty happy with the result. Have a play, see if you can make some use of it, it has the capability for a large number of keywords so you have plenty of space to add your own and I've written the macro so that you do not need to touch any code to add keywords, just follow the instructions on Sheet2. I will post updates as they happen and certainly welcome any feedback you can give on the program, even if its just to say that you are using it. Btw, the categories you see are of your own choice, I simply left my choices in there as an example Also I am aware that narrowing your searches will lead to missed opportunities, but its a balancing act, you can broaden the amount of brands you search and then be more specific about what sizes you want. Experiment. Notable Features: Brand Concatentation - combine up to 70 brands into a single search string Preset Keywords + Create your own - choose preset item keywords or create your own Unlimited Characters - the generated web address means you can exceed the 300 character search box limit to a very high and so far unknown number of maximum characters Generates Search Web Address - creates a simply copy>paste web address for the search eBay Search Creator 1.0 Screenshots
Download from Slingfile from Mega Upload from Easy Share from SendSpace
 

ppllzz

Distinguished Member
Joined
May 27, 2008
Messages
4,315
Reaction score
69
ebay has a saved search feature... i do all my searches once, save them, and get an email every evening with my search. good effort with this though, maybe someone will use it
 

DLester

Distinguished Member
Joined
Dec 16, 2008
Messages
6,624
Reaction score
6,034
^^^Same here. I save my searches on ebay and get daily emails.
 

XenoX101

Distinguished Member
Joined
Aug 25, 2008
Messages
4,763
Reaction score
20
Yes, search saving is great on eBay, however this tool is for creating custom search strings from pre-entered brands and preset items and sizes, it doesn't replace search saving functionality and on the contrary works with it. It is able to collate up to 70 brands into an eBay search and add whatever keywords/sizing you want. You can also search thousands of characters at a time - something only doable through the web address (search box has 300 character limitation).
 

ppllzz

Distinguished Member
Joined
May 27, 2008
Messages
4,315
Reaction score
69
oh so it can search for multiple brands at once? is this a computer trick?
 

XenoX101

Distinguished Member
Joined
Aug 25, 2008
Messages
4,763
Reaction score
20
Yes, nah but if you're searching for a large number of brands it's a pain in the ass doing it through the web address, just use my tool to add them all to the web address for you, plus this way you can see them as a list instead of as a continous line and you can add/remove them from the list and regenerate the web address in a second. If you're not using the web address you will be limited to only 300 characters, which may not be enough for all the brands + paramaters you want to search.
 

robbie

Pleading Poverty
Joined
May 3, 2007
Messages
6,424
Reaction score
55
that is actually very cool xenon... i don't know that I am savvy enough to use it properly. but cool none the less.
 

driveslowk

Distinguished Member
Joined
Feb 28, 2009
Messages
4,298
Reaction score
506
Originally Posted by robbie
that is actually very cool xenon... i don't know that I am savvy enough to use it properly. but cool none the less.

+1
 

wmmk

Distinguished Member
Joined
Jun 13, 2008
Messages
2,689
Reaction score
8
Seems like a possibly useful tool, and it was nice of xeno to share it. I know he's usually pretty prentious, but one-starring any thread he posts seems pretty douche-y.
 

Kique

Senior Member
Joined
Nov 12, 2008
Messages
144
Reaction score
0
Pretty cool actually. I usually search for a specific item on ebay, but for the times I need to do a broader search this could be useful I guess.
 

Stazy

Distinguished Member
Joined
Sep 6, 2006
Messages
7,194
Reaction score
439
Nicely done. I won't use it because I hate ebay but I appreciate the effort that went into making it.
 

mulansauce

Distinguished Member
Joined
Mar 1, 2008
Messages
1,937
Reaction score
1
Originally Posted by Stazy
Nicely done. I won't use it because I hate ebay but I appreciate the effort that went into making it.

+1
 

Styleforum is proudly sponsored by

Featured Sponsor

How wide do you like your leg opening on your trousers?

  • 7”

    Votes: 85 17.7%
  • 7.5”

    Votes: 154 32.0%
  • 8”

    Votes: 140 29.1%
  • 8.5”

    Votes: 54 11.2%
  • 9”

    Votes: 24 5.0%
  • 9.5”

    Votes: 11 2.3%
  • 10”

    Votes: 4 0.8%
  • 10.5”

    Votes: 9 1.9%

Related Threads

Forum statistics

Threads
433,532
Messages
9,313,097
Members
195,428
Latest member
nhuqwasdmkog
Top