sharojit
Level 1
Write the reason you're deleting this FAQ
I order a package here. But the seller didn't responded to me yet. It's already 36hrs over. What should I do now? I cannot hire someone else until he/she didn't respond, then I cannot track the task by this seller. It's a guaranteed gig so that I ordered. This is my first time ordering here. Quite bad experiences
Are you sure you want to delete this post?
Are you sure you want to delete this post?
Yeah, that's what I already did. I ask for mutual cancellation and it's was done before this issue approval here :)
Are you sure you want to delete this post?
great then, hope you luck with your project buddy :)
Are you sure you want to delete this post?
Are you sure you want to delete this post?
| 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='28869' | 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='28869' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='819902' | 1 | SELECT * FROM seoclerks.members WHERE USERID='819902' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=819902 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=819902 | /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=28869 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=28869
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='28869' 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='28869' 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=187799 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=187799
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=187806 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=187806
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=187789 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=187789
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=187792 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=187792
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=187793 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=187793
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=187794 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=187794
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='28869' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='28869' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='28869' AND status='1' AND (question like '%Seller answering order%' OR question like '%Seller%' OR question like '%answering%' OR question like '%order%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='28869' AND status='1'
AND (question like '%Seller answering order%' OR question like '%Seller%' OR question like '%answering%' 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='2255' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2255' 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 1 | 1 | SELECT 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='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='3545' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3545' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='4022' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='4022' 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=28869%' 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=28869%'
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='19821.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='19821.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='819902.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='819902.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='98496.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='98496.png' | /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() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
TommyCarey
Contact the seller
I will always contact sellers if I've never purchased from them. I will see how quickly they respond and slightly judge their professionalism based on the time it takes them to get back to me. If it takes more than 24 hours for a response, I usually forget about them and never "favorite" their service. I will give some additional time if I message them late on a Friday since a lot of us try not to work 8+ hours on a weekend.
When I do get a response from the person I like to assess them based on their response. If I ask a complicated question, something they should be able to answer easily, and all I get back is "Yes" as their response then I won't work with them. It doesn't take much to give a detailed answer to a potential buyer and when they don't take that little bit of time I get to thinking they won't take time on my order.
Filtering is your friend
When I'm searching for a new service that I'm looking to test out I will always filter out level 1 sellers. Don't get me wrong, I've found plenty of level 1 sellers, purchased from them, and watched their levels go up to X in time but I don't usually risk a money site with level 1 sellers.
If you filter out level 1, or even level 1 and 2 sellers, you're more likely to get an order finished by someone who has been here for a while and has done plenty of orders. They know what they're doing, have plenty of good reviews, and have done many more orders than a level 1 seller.
In a case where the seller is nonresponsive
You can always request a mutual cancellation and hope the seller agrees to it. I've run into a few sellers who keep claiming the work is being done and cancel my request. All I'll do then is re-open the mutual cancellation and tell them to cancel the order because they have already messed up or gone over the agreed upon time. If they don't go through with the cancellation I will then open it up to the administration team and let them deal with the problem.
You can only do so much with a seller who isn't performing the work before you have to bring in the big guns lol
Understand Timeframes and Timezones
You could order something on Friday night but that could be Saturday morning for the seller and they might not work on the weekends. If you don't get a response by Monday (your time) then they likely don't run their services as professionally as they should. Give some grace time to people on the other side of the world and also know that an SEO service takes a bit of time, so don't bother people if their time is almost up lol.
I get a lot of SEO clients bug me a few days after I start working on their campaigns and I always have to remind them that my services take at least 30 days before they will get a report. I'm not going to break up a campaign and send multiple reports like I used to. I would send out weekly reports, get 100s of questions from the client, and that 30 day TAT actually takes 45 days because of all their questions. Instead, I send them 1 report and answer all questions at the end so I don't have to go over something twice lol
I hope that helps you out with your next order
- Tommy I see you went through with a mutual cancellation and it already went through before this discussion went live :) [center][size=150][b]Next time you should do the following before ordering:[/b][/size][/center] [size=100][u][b]Contact the seller[/b][/u][/size] I will always contact sellers if I've never purchased from them. I will see how quickly they respond and slightly judge their professionalism based on the time it takes them to get back to me. If it takes more than 24 hours for a response, I usually forget about them and never "favorite" their service. I will give some additional time if I message them late on a Friday since a lot of us try not to work 8+ hours on a weekend. When I do get a response from the person I like to assess them based on their response. If I ask a complicated question, something they should be able to answer easily, and all I get back is "Yes" as their response then I won't work with them. It doesn't take much to give a detailed answer to a potential buyer and when they don't take that little bit of time I get to thinking they won't take time on my order. [size=100][u][b]Filtering is your friend[/b][/u][/size] When I'm searching for a new service that I'm looking to test out I will always filter out level 1 sellers. Don't get me wrong, I've found plenty of level 1 sellers, purchased from them, and watched their levels go up to X in time but I don't usually risk a money site with level 1 sellers. If you filter out level 1, or even level 1 and 2 sellers, you're more likely to get an order finished by someone who has been here for a while and has done plenty of orders. They know what they're doing, have plenty of good reviews, and have done many more orders than a level 1 seller. [size=100][u][b]In a case where the seller is nonresponsive[/b][/u][/size] You can always request a mutual cancellation and hope the seller agrees to it. I've run into a few sellers who keep claiming the work is being done and cancel my request. All I'll do then is re-open the mutual cancellation and tell them to cancel the order because they have already messed up or gone over the agreed upon time. If they don't go through with the cancellation I will then open it up to the administration team and let them deal with the problem. You can only do so much with a seller who isn't performing the work before you have to bring in the big guns lol :D [size=100][b]Understand Timeframes and Timezones[/b][/size] You could order something on Friday night but that could be Saturday morning for the seller and they might not work on the weekends. If you don't get a response by Monday (your time) then they likely don't run their services as professionally as they should. Give some grace time to people on the other side of the world and also know that an SEO service takes a bit of time, so don't bother people if their time is almost up lol. I get a lot of SEO clients bug me a few days after I start working on their campaigns and I always have to remind them that my services take at least 30 days before they will get a report. I'm not going to break up a campaign and send multiple reports like I used to. I would send out weekly reports, get 100s of questions from the client, and that 30 day TAT actually takes 45 days because of all their questions. Instead, I send them 1 report and answer all questions at the end so I don't have to go over something twice lol :D Some clients don't like this, but they know what they're getting into before purchasing since it's in all my TOS and explained on everything I sell, so they can't really complain :D I hope that helps you out with your next order :) - Tommy
Are you sure you want to delete this post?