SEOClerks

New feature request Buyer Statistics?



Write the reason you're deleting this FAQ

New feature request Buyer Statistics?

Hi members of this amazing site
We all know negative feedback can ruin the sellers in no time.
This is partly the sellers fault and partly the fault of abusive buyers.
As this site is getting more populer it is only a matter of time till we start seeing trolls who abuse the sellers.
My suggestion is that we should have a system where we can see the buyers stats
1 How many positive/negative feedback they have submitted
2 How many times he had opted for the guarantee feature
If we could have this info the sellers could protect them selfs from the trolls
What is your opinion?

Comments

Please login or sign up to leave a comment

Join
Recommendables
i would surely love that as a seller as long as the buyers dont delete that old accounts and create a new one instead everytime they make a purchase >New feature request Buyer Statistics?



Are you sure you want to delete this post?

aliciamosely
its a very good suggesstion. there must be a system to protect sellers as well



Are you sure you want to delete this post?

ashrafonline
nice suggestion, if seoclerks implement this, sellers get benift of this



Are you sure you want to delete this post?

klo1029
Yes This Is A Nice Suggestion, I Also Got Ruined By One Buyer, Even I COmpleted Its Order He Still Left A Negative Feedback And Now I Have Only One Negative Feedback..! New feature request Buyer Statistics?



Are you sure you want to delete this post?

trafficsmania
When you first start to sell services even 1 negative feedback can ruin your rating and credibility thus affecting your future sales(if any)
I am selling services on several sites and the only time when I got negative feedback was when the buyer either misinterpreted or tryed to force me to cancell his order so he can get his money back.
The grate thing about SEOclerks is that we have the guaranteed feature , I would rather give the money back to a trolling buyer than have my rating ruined
Whith the new feature we would be able to see how many orders has the buyer made and how many times he invoced the guarantee and his rating would be based upon it
SO if a member buys 10 services and invoces guarantee on 8 of them he is clearly abusing, this is not good for nobody, the site dosn;t get his commition and the seller just worked for free



Are you sure you want to delete this post?

exjordanary
Good idea. I have also suggested the idea of a "Buyer Block List" where Sellers can add Abusive Buyers to their own individual List of Buyers that they don't want to sell to.
There can also be a Community Blacklist where Sellers can add and Report Abusive Buyers.
I have also suggested in the past the Ability for Sellers to also Leave Feedback for Buyers. That way, instead of having to look up a Buyer's Stats, past purchases, etc. - You can count on other Sellers who have left Feedback for these Buyers to judge for you by simply looking at that buyers Feedback.
If BOTH Systems are implemented, then you can set your own preferred Feedback thresholds on your Individual Block List - so that only Buyers with a certain amount of Feedback can Purchase your service by default.
This would save you the time of having to even look at a Buyer's Feedback.

Hope this helps,
-exjordanary



Are you sure you want to delete this post?

alimalik87
Very Good Suggestion, If SEOClerks implement this It will Rocks, All sellers will get the benefits from this



Are you sure you want to delete this post?

bmimms1
build your social media with my gigs: https://www.seoclerks.com/user/bmimms1



Are you sure you want to delete this post?

Order Now
Process Time: 0.40715098381042

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='2752'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='2752'

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

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

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

SELECT * FROM seoclerks.members WHERE USERID=110301SELECT googleplus_profile FROM seoclerks.members WHERE USERID=11030

/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=2752 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=2752 LIMIT 5

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

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='2752' 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='2752' 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=12146 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=12146 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=12106 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=12106 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=12119 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=12119 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=12125 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=12125 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=12132 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=12132 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=12142 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=12142 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=12329 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=12329 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=12435 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=12435 LIMIT 5

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

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

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

SELECT * FROM questions WHERE quesid!='2752' AND status='1' AND (question like '%New feature request Buyer Statistics?%' OR question like '%feature%' OR question like '%request%' OR question like '%Buyer%' OR question like '%Statistics?%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='2752' AND status='1' AND (question like '%New feature request Buyer Statistics?%' OR question like '%feature%' OR question like '%request%' OR question like '%Buyer%' OR question like '%Statistics?%') -- ORDER BY RAND() LIMIT 15

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

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

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

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

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

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID='1628' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='1628' 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=2752%' 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=2752%' 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='10788.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='10788.jpg'

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

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

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

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

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

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

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

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID='10190.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='10190.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

Suspicious SQL

The following SQL have high average execution times
Avg TimeCountSQLMaxMin