SEOClerks

Clear
Sign In Join

Hire Me or Custom Order on SEOclerks Profiles - Proposal Debate

  • Cristian Level X3
    • 10

    Write the reason you're deleting this FAQ

    Hire Me or Custom Order on SEOclerks Profiles - Proposal

    Since my recent activity on Community Discussions here on SEOclerks, I've notice I'm starting to get a lot of activity in my Inbox. People contact me with different problems and issues.

    At the moment I suspended all my past services for various reasons, but overall I just want to re-invent myself here by developing something completely new for the future.

    In the meantime, I would still like people to contact me for various SEO jobs, but I don't want to publish some specific service, so it would be nice to have a general service feature, like a "Hire Me" kind of thing or a "Custom Offer" a buyer may want to make to get an answer, quick fix or even a complex custom job.

    The buyer should have the options to accept, refuse or just continue negotiating with the potential client.

    This will also give buyers a good inside into what buyers really need and want and create normal services accordantly.

    What do you guys this of such a feature?

    #New #Feature #Custom #Order #Hire #Media #Profile SEOClerks
    Share post:

    Comments

    Please login or sign up to leave a comment

    Join
    MusicMoguls

    MusicMoguls

    I Like this idea buyers can just ask you for what they want instead of offering a generic service. This is different from a want to buy and shouldn't be associated with this feature. Want to buy is more of a bidding war for something someone wants. What your talking about is a private way for a buyer to ask a seller for something that fits their needs. They should be able to describe what they want and a price they want to pay. The seller should be able to counter and once an agreement is made the service should begin. This type of innovation will set us apart from other market places and i think its a great idea Bravo. Thanks for Sharing.
    10 years ago

    Are you sure you want to delete this post?

    Cristian

    Cristian

    Yes, exactly, you got everything right to the point!
    10 years ago

    Are you sure you want to delete this post?

    idealmike

    idealmike

    Yes Request a Custom Job! Hire Me or Custom Order on SEOclerks Profiles - Proposal

    I placed that as a possible future feature suggestion. It came about because sometimes I get clients request custom work from me or want one of my services but done in a more tailored, unique way for them.

    Also I saw it as a feature on another site that I shall not mention here of which I found to be a good feature in a way both for buyers and sellers. However while the idea seems to get majority thumbs up it was pointed out that you can do that with a WTB. A person can create a WTB which details everything they need which anyone can then bid on.

    This is good but some buyers want to be covert and discreet and don't want to say what they want in public on a WTB that anyone can bid on and would prefer it to be for one seller only all done without needing to create a WTB.

    I believe this would be a good feature for buyers and sellers that could go on to get us all a lot more sales and bring more money into the site as well. (Especially for you coders and programmers and designers out there!) Sure there is WTB section. And sure a feature like that would need building/coding/testing etc to streamline it. I guess it could just be something as simple as a form they fill out detailing what they want along with a field on how much they are willing to pay for it. Or perhaps they could click the link then fill it out and the seller replies with a price and the buyer can choose to accept it or not. Or even the buyer could respond with a counter offer or set the price for it from the start. Then when all is agreed, buyer pays and the order starts and the seller provides and delivers it as normal.

    There are a lot of things to take into consideration actually to make something like that come about. I guess you could borrow some of the fields from the new WTB form such as title, description, amount will pay and any files/attachments whatever too.

    And there are some points to consider about how people might abuse that system somehow. But if the seller had ultimate control on whether a custom job is worth doing for the price the buyer has stated (or could negotiate). He could just accept or reject it! Hire Me or Custom Order on SEOclerks Profiles - Proposal

    And man, that would be boom!

    If it don't turn into a deal and sale, it don't.
    If it don't break nothing or upset any sellers.
    What is there to loose when there is the possibility to gain much more in sales for us from it? Hire Me or Custom Order on SEOclerks Profiles - Proposal

    That's my look on it anyway. Hire Me or Custom Order on SEOclerks Profiles - Proposal

    Mike.
    10 years ago

    Are you sure you want to delete this post?

    Cristian

    Cristian

    I forgot about your "feature request" Mike! Seems I was on-board with it since then. But I wouldn't put the button under the profile name, I would put this feature just like a service only it needs to look like SC official stuff.

    Glad I'm not the only one thinking this may be a great feature, I'm sure there are plenty out there thinking the same way.
    10 years ago

    Are you sure you want to delete this post?

    Lynne

    Lynne

    I think this would be an amazing feature and would add so much value to this marketplace.

    Yes I remember Mike's suggestion too and I loved it.

    I don't use WTB's because I usually only want to order from certain sellers. Yes call me fussy or whatever but I know what I want and I know what I like and I have very high standards. If I find a seller that I like that sells the sort of thing I am looking for but perhaps I want something a little more tailored to suit my needs then I would love the opportunity to be able to request it.
    10 years ago

    Are you sure you want to delete this post?

    Everett

    Everett

    This has been suggested once before, and I think the answer was "Want to Buys" if I remember correctly. However, as a marketplace grows, and all the changes that surrounds it, I believe this feature would be very beneficial to the marketplace, and the entire community. There are some cons of this feature though, for instance a seller could possibly be spammed with "hire me" requests, unless there was a cap per user, like possibly 3 hire me requests per day.

    If this feature were to ever be created it probably should function the same as like the bumps, like where you need to do certain activity to gain a certain amount of "bids" to be able to create custom jobs for a seller, this is to prevent gaming of the system, and other issues that may occur.

    Also, another con is probably SEO related, as a custom job the service won't rank very well, or even rank at all. So if you like to rank your services on google or other search engines.
    10 years ago

    Are you sure you want to delete this post?

    Cristian

    Cristian

    This is very different from a WTB, the seller will contact one buyer directly and propose a custom order. This feature should be available on all profiles if the seller chooses to enable it.
    Some requirements should be met of course, but other than that I don't see any potential problems, only gains.
    10 years ago

    Are you sure you want to delete this post?

    procoder

    procoder

    I agree, hire me feature would be cool to have, because they can hire you for anything they want, and then seller will have to accept or reject it, this feature it's just a good thing because I'm sure that will help all of us to earn something extra. Also I think that "hire me" requests should be limited somehow, or seller can set a limit to request that he can receive per day.

    Doing this will protect sellers from fake request, and also I think that buyers must have enough balance on their account before hiring a seller, now I know that some of them may prefer to pay directly via credit cards, or other payment gateway. However, this feature must have some requirements that must be met in order to use it.
    10 years ago

    Are you sure you want to delete this post?

    RaduV

    RaduV

    Sounds like a great idea, having the possibility to negotiate the price before the service is created will be amazing. It will be a cool feature to have because it will give them the possibility to request any service from you without having actually a live version of the service.

    I am supporting this feature and probably will bring us more sales.
    10 years ago

    Are you sure you want to delete this post?

    vinaya

    vinaya

    That's a great idea. I have not done many jobs on SEO Clerk, however, because of my participation in a discussion I get traffic on my services. Participating in the discussion is a good way to attract the potential buyers. People can still create a Custom job offer through WTB feature, however, there is no feature to create a custom job offer to a specific freelancer. The services you list on your page are also in a way "Hire Me" feature.
    8 years ago

    Are you sure you want to delete this post?

    Order Now
    Process Time: 0.79282402992249

    Possible Duplicate queries found!
    MatchCountSQLScript
    SELECT * FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='19973'1SELECT q.*, c.seo as CatSEO, c.name as CatName, c.parentid FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='19973'

    		/opt/clerks-staging/docroot/viewfaq.php 496 () ()

    SELECT * FROM seoclerks.members WHERE USERID='134'1SELECT * FROM seoclerks.members WHERE USERID='134'

    		/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()

    SELECT * FROM seoclerks.members WHERE USERID=1341SELECT googleplus_profile FROM seoclerks.members WHERE USERID=134

    		/opt/clerks-staging/docroot/include/functions/main.php 16914 GetGooglePlusProfileFromId() ()

    SELECT * FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=19973 LIMIT 51SELECT m.username FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=19973 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='19973' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc1SELECT a.answer, a.USERID, a.upvotes, a.downvotes, a.ansid, a.parentid, a.combined_votes, a.date_answered, b.username, b.userlevel, b.profilepicture FROM answers a, seoclerks.members b WHERE a.quesid='19973' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc

    		/opt/clerks-staging/docroot/viewfaq.php 1245 () ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=109033 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=109033 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=109050 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=109050 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=109042 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=109042 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=109052 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=109052 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=109063 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=109063 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=109034 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=109034 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=109051 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=109051 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=109056 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=109056 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=109472 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=109472 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=144308 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=144308 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    UPDATE questions SET total_views = total_views + 1 WHERE quesid='19973'1UPDATE questions SET total_views = total_views + 1 WHERE quesid='19973'

    		/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()

    SELECT * FROM questions WHERE quesid!='19973' AND status='1' AND (question like '%Hire Custom Order SEOclerks Profiles - Proposal %' OR question like '%Hire%' OR question like '%Custom%' OR question like '%Order%' OR question like '%SEOclerks%' OR question like '%Profiles%' OR question like '%Proposal%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='19973' AND status='1' AND (question like '%Hire Custom Order SEOclerks Profiles - Proposal %' OR question like '%Hire%' OR question like '%Custom%' OR question like '%Order%' OR question like '%SEOclerks%' OR question like '%Profiles%' OR question like '%Proposal%') -- ORDER BY RAND() LIMIT 15

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

    SELECT * FROM seoclerks.members WHERE USERID='750' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='750' limit 1

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

    SELECT * FROM seoclerks.members WHERE USERID='1159' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='1159' limit 1

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

    SELECT * FROM seoclerks.members WHERE USERID='2537' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='2537' limit 1

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

    SELECT * FROM seoclerks.members WHERE USERID='1323' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='1323' limit 1

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

    SELECT * FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=19973%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID 1SELECT USERID, username FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=19973%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

    SELECT * FROM categories1SELECT * FROM categories

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

    select * from categories_software order by name asc1select * from categories_software order by name asc

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories()

    select * from categories_wanttobuy order by name asc1select * from categories_wanttobuy order by name asc

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories()

    select * from categories_wanttotrade order by name asc1select * from categories_wanttotrade order by name asc

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories()

    SELECT * FROM seoclerks.members WHERE USERID='139192.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='139192.png'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='134.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='134.png'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='272.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='272.jpg'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='306632.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='306632.jpg'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='2951.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='2951.jpg'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='377074.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='377074.png'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='6.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='6.jpg'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='585810.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='585810.jpg'

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    select * from categories_faq order by name asc1select * from categories_faq order by name asc

    		/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()

    Invalid SQL

    count(*)sql1error_msg

    Expensive SQL

    Tuning the following SQL could reduce the server load substantially
    LoadCountSQLMaxMin
    0.3899162SELECT COUNT(A.wantid) AS total FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID 0.2069630.182953

    Suspicious SQL

    The following SQL have high average execution times
    Avg TimeCountSQLMaxMin
    0.2911771SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID ORDER BY A.bdays desc LIMIT 0,400.2911770.291177
    0.2859221SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID ORDER BY A.viewcount desc LIMIT 0,400.2859220.285922
    0.1949582SELECT COUNT(A.wantid) AS total FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID 0.2069630.182953