How can I check a buyer's history before accepting order?

sanfora Level 1

July 31, 2016, 3:07 pm

Write the reason you're deleting this FAQ

How can I check a buyer's history before accepting order?

Is it possible to check a buyer's history before I accept or deliver an order? If so, tell me how

Comments

Please login or sign up to leave a comment

Join

ajlancer

Hi sanfora thanks for your question. I understand why you expecting buyer history before accept or deliver order. Actually buyer does not need or require you to accept order before placing. If he wants, he can place order anytime without informing you. But, if you would like to aware about buyer previous history how he act with other seller, you must to go his profile to check previous history. You cannot realize for new buyer as level 1, who did not purchased order before. But, for old buyer of SEOclerks marketplace, you can see rating from another seller. Or, you can see how much buyer percentage he has at this moment. Only you can check by buyer profile, no other way.

I think this topic will help you to understand buyer activity before start work.
https://www.seoclerks.com/faq/9961...safe-as-a-seller

Regards by Ajlancer

10 years ago

Are you sure you want to delete this post?

Lynne

Hi Sanfora.

Buyers get ratings and recommendations from sellers just like buyers do.

If you to a buyers profile you can see the Level and their ratings. They also get recommendations from sellers which you can also view on their profile.

10 years ago

Are you sure you want to delete this post?

EliteWriter

Just go to their profile where you will be able to see their rating, how long they have been members of the site, as well as their level. Beneath this there are also User Details where you can see statuses, any discussions or responses they might have made on community discussions which can be pretty insightful on what kind of person they are. If they got recommendations you can also see them on their public profile page. I also recommend clicking on any of their services because even though they are listed as buyers, they might also sell something on the site. You can see any comments made over there as well.

10 years ago

Are you sure you want to delete this post?

Avg Time	Count	SQL	Max	Min
0.119448	1	SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%diginer%') ORDER BY total_recommendations desc LIMIT 0,40	0.119448	0.119448

SEOClerks

How can I check a buyer's history before accepting order?

How can I check a buyer's history before accepting order?

Comments

Please login or sign up to leave a comment

ajlancer

Lynne

EliteWriter

Invalid SQL

Expensive SQL

Suspicious SQL

Match	Count	SQL	Script
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='18504'	1	SELECT 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='18504'	/opt/clerks-staging/docroot/viewfaq.php 496 () ()
SELECT * FROM seoclerks.members WHERE USERID='60292'	1	SELECT * FROM seoclerks.members WHERE USERID='60292'	/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
SELECT * FROM seoclerks.members WHERE USERID=60292	1	SELECT googleplus_profile FROM seoclerks.members WHERE USERID=60292	/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=18504 LIMIT 5	1	SELECT m.username FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=18504 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='18504' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc	1	SELECT 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='18504' 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=102483 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102483 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=102491 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102491 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=102579 LIMIT 5	1	SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=102579 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
UPDATE questions SET total_views = total_views + 1 WHERE quesid='18504'	1	UPDATE questions SET total_views = total_views + 1 WHERE quesid='18504'	/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
SELECT * FROM questions WHERE quesid!='18504' AND status='1' AND (question like '%How I check buyer\'s history accepting order?%' OR question like '%check%' OR question like '%buyer\'s%' OR question like '%history%' OR question like '%accepting%' OR question like '%order?%') -- ORDER BY RAND() LIMIT 15	1	SELECT quesid, question, seo, userid FROM questions WHERE quesid!='18504' AND status='1' AND (question like '%How I check buyer\'s history accepting order?%' OR question like '%check%' OR question like '%buyer\'s%' OR question like '%history%' OR question like '%accepting%' OR question like '%order?%') -- ORDER BY RAND() LIMIT 15	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM seoclerks.members WHERE USERID='1490' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='1490' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='9' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='9' 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 1	1	SELECT 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='1001' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='1001' 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=18504%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID	1	SELECT USERID, username FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=18504%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM categories	1	SELECT * FROM categories	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()
select * from categories_software order by name asc	1	select * 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 asc	1	select * 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 asc	1	select * 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='4987.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='4987.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
SELECT * FROM seoclerks.members WHERE USERID='306632.jpg'	1	SELECT 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='212316.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='212316.jpg'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()
select * from categories_faq order by name asc	1	select * from categories_faq order by name asc	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()