SEOClerks

Clear
Sign In Join

What is our mistake??????? Too much cancellation. Pls do something Admins

  • parag4485 Level 1
    • 8

    Write the reason you're deleting this FAQ

    What is our mistake??????? Too much cancellation. Pls do something Admins

    Hello everyone,

    Still there is no solution for fraud buyers. today mine 3 orders(130$) canceled after delivery. What is our mistake? Due to that we cant identify Real & Fraud buyers. Please take a stand for solution. Atleast seller can get 50% of order value then its also ok but we are loosing too much

    #Admin #Facebook SEOClerks
    Share post:

    Comments

    Please login or sign up to leave a comment

    Join
    Ahove

    Ahove

    Hey parag4485

    Yes it still happen some time.but not like before that fraud is found and stop that.problem is this is online business nothing is permanent hare.but admin have to be more stricket in this things.they have to instant cancel those fraud orders otherwise we get loss every time.hope SeoClerks do some thing for us.because we loss too much for this.

    Thanks
    Ahove
    12 years ago

    Are you sure you want to delete this post?

    ultimate

    ultimate

    The buyer rating stats are to help us, sellers, to identify frauds.
    SEOClerks gives us a day time to decide whether or not we would like to work with the buyer.
    12 years ago

    Are you sure you want to delete this post?

    parag4485

    parag4485

    Buyers doing fraud after placing 2-3 legit orders so we cant able to trace them. first they are gaining trust after they are using illegal methods for buying so we not able to trace him by rating.
    12 years ago

    Are you sure you want to delete this post?

    Jaredseven

    Jaredseven

    The only way to stop/slow down cancelations is to warn other sellers about buyers that you have canceled orders or have canceled an order on you. This is not a fool-proof plan, but it should at least cut down some of the order cancelations that happen.
    12 years ago

    Are you sure you want to delete this post?

    Sean101

    Sean101

    50% of what? If the buyer cancels the order, he gets all his money back, so there is no order cash left to pay you 50% of. What is our mistake??????? Too much cancellation. Pls do something Admins

    That said, the buyer does not have the ability to force cancel orders, so if you have delivered the service and they cancel the delivery of it, just deliver it again, all they can do is review the order (you get your cash), do nothing (you get you cash once days have passed) or keep canceling the the delivery. If they do just keep canceling the delivery each time you re-deliver that order page, then just make sure your proof of work is on the order page and report tit, a staff member will look at the order and can decide to end the order in your favour. What is our mistake??????? Too much cancellation. Pls do something Admins
    12 years ago

    Are you sure you want to delete this post?

    Godskid

    Godskid

    I had the same issue a few days ago. Guy buys traffic then after I give traffic, he tells me he wants to cancel. After talking to him a even giving him more traffic, I understood that he is fraudulent and I angrily forced cancelation on the order. I'm sure he must have been happy.
    12 years ago

    Are you sure you want to delete this post?

    rankontop

    rankontop

    what about the sellers who mark it complete & ask for feedback when the job in reality is not done or completed. Ive seen this alot and it just happened today & now i know they are scammers and we are left with unfinished work.
    12 years ago

    Are you sure you want to delete this post?

    Order Now
    Process Time: 0.47003507614136

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID=586391SELECT googleplus_profile FROM seoclerks.members WHERE USERID=58639

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

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

    SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='7799' 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='7799' 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=35000 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=35000 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=34946 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=34946 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=34951 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=34951 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=34950 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=34950 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=34984 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=34984 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=35004 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=35004 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=35065 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=35065 LIMIT 5

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

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

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

    SELECT * FROM questions WHERE quesid!='7799' AND status='1' AND (question like '% mistake??????? cancellation. Pls Admins %' OR question like '%mistake???????%' OR question like '%cancellation.%' OR question like '%Admins%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='7799' AND status='1' AND (question like '% mistake??????? cancellation. Pls Admins %' OR question like '%mistake???????%' OR question like '%cancellation.%' OR question like '%Admins%') -- ORDER BY RAND() LIMIT 15

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    Suspicious SQL

    The following SQL have high average execution times
    Avg TimeCountSQLMaxMin
    0.3567052SELECT 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.3647550.348655
    0.1425981SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 75941 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%seo seoaudit seoreport auditreport websiteaudit%' ) LIMIT 40.1425980.142598
    0.1420231SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 10214 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Facebook Forum Forumsignature Forumsoftware%' ) LIMIT 40.1420230.142023
    0.0518201SELECT quesid, question, seo, userid FROM questions WHERE quesid!='7799' AND status='1' AND (question like '% mistake??????? cancellation. Pls Admins %' OR question like '%mistake???????%' OR question like '%cancellation.%' OR question like '%Admins%') -- ORDER BY RAND() LIMIT 150.0518200.051820