Write the reason you're deleting this FAQ
This is perhaps one of the most annoying things happening here on SEOClerks.
Sellers with late delivery and huge feedback and punctual sellers also with huge feedback... No distinction between them!
I'm not saying that we should allow negative feedback if the seller is late, maybe that would be too much and very strict. But at the same time, it is frustrating to see sellers, let's say with 30-40%+ late delivery and punctual sellers without that problem to be apparently on the same level...
This is especially true with cheap services...
I purchased quite a few services and too many sellers have this problem(!!!)
What about showing statistics with late delivery / total orders:
For a 500 feedback, 205 late delivery would be:
205/500 = 41.0% Late Delivery Rate
Much worse than a seller with the same feedback but only 59 late delivery, for example:
59/500 = 11.8% Late Delivery Rate
What do you guys think about this problem?
Are you sure you want to delete this post?
Are you sure you want to delete this post?
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='20634' | 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='20634' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='65703' | 1 | SELECT * FROM seoclerks.members WHERE USERID='65703' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=65703 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=65703 | /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=20634 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=20634
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='20634' 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='20634' 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=112390 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=112390
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=112396 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=112396
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=112504 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=112504
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=112520 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=112520
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=133534 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=133534
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='20634' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='20634' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='20634' AND status='1' AND (question like '%Statistics Late Delivery? Cases These...%' OR question like '%Statistics%' OR question like '%Late%' OR question like '%Delivery?%' OR question like '%Cases%' OR question like '%These...%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='20634' AND status='1'
AND (question like '%Statistics Late Delivery? Cases These...%' OR question like '%Statistics%' OR question like '%Late%' OR question like '%Delivery?%' OR question like '%Cases%' OR question like '%These...%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='17031' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='17031' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='11030' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='11030' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='14567' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='14567' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='16780' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='16780' 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=20634%' 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=20634%'
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='6160.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='6160.png' | /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 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='2951.jpg' | 1 | SELECT 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='617077.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='617077.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() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
| Avg Time | Count | SQL | Max | Min |
hitmeasap
This is a great suggestion in my opinion! - Too many sellers are stating 1-2 days delivery, but in reality, most of them delivers in 2-4 days all the time, and they do this on all their orders too. - The biggest reason they state less delivery time is due to the fact that they'll get more orders by stating a lower delivery time compared to a higher one. - Sure, they do it with the risk of getting negative feedbacks too, for late deliveries, but most of these sellers have hundreds or even thousands of previous positive reviews, and most buyers doesn't care if their orders is a few hours or perhaps a day late, as long as they get what they've ordered.. And when they get what they've paid for, then they'll also leave a positive review. - So these sellers are actually using the system to benefit themselves.
I think it's unfair, unethical and it's also terrible. - Sure, I can definitely see why someone could be late with one of their deliveries, and that's just life. Things can happen. But when you deliver 5-6 or 7 orders out of 10 late.. Then you should also be punished for doing so. But that's not the fact today. - Today, literally nothing happens, except the "risk" of negative feedbacks for late deliveries, these sellers take by operating the way they do.
I would love to see some sort of indication like you've suggested. I'm not interested in working with people who's late on a regular basis and today, you'll just need to take a chance as a buyer.
Good suggestion & hopefully something like this will be implemented shortly.
Best Regards,
hitmeasap Hey clerkboy3, This is a great suggestion in my opinion! - Too many sellers are stating 1-2 days delivery, but in reality, most of them delivers in 2-4 days all the time, and they do this on all their orders too. - The biggest reason they state less delivery time is due to the fact that they'll get more orders by stating a lower delivery time compared to a higher one. - Sure, they do it with the risk of getting negative feedbacks too, for late deliveries, but most of these sellers have hundreds or even thousands of previous positive reviews, and most buyers doesn't care if their orders is a few hours or perhaps a day late, as long as they get what they've ordered.. And when they get what they've paid for, then they'll also leave a positive review. - So these sellers are actually using the system to benefit themselves. I think it's unfair, unethical and it's also terrible. - Sure, I can definitely see why someone could be late with one of their deliveries, and that's just life. Things can happen. But when you deliver 5-6 or 7 orders out of 10 late.. Then you should also be punished for doing so. But that's not the fact today. - Today, literally nothing happens, except the "risk" of negative feedbacks for late deliveries, these sellers take by operating the way they do. I would love to see some sort of indication like you've suggested. I'm not interested in working with people who's late on a regular basis and today, you'll just need to take a chance as a buyer. Good suggestion & hopefully something like this will be implemented shortly. Best Regards, hitmeasap
Are you sure you want to delete this post?