SEOClerks

I wish there was a pending order tab



Write the reason you're deleting this FAQ

I wish there was a pending order tab

I wish there was a pending order tab on 'Manage Sales' dashboard that would allow sellers to track orders that a client says he has placed.

Maybe the pending orders tab could tell you what else needs to be done before the order is finalized. For instance, it might say the buyer's credit card is being processed or they still need to provide 'instructions to the seller', etc. I think they already tell you that in an email, but it would be good to have it on the dashboard, especially for sellers who get dozens of orders every day.

It would just be easier if something like that were available.

P.S. The reason I'm worried about this situation is that a buyer has ordered two services from me and it's been well over a day and I still am not able to see the order on my manage sales tab. I can't begin work if it does not show up. And, I know that other sellers have the same issue on occasion.

Comments

Please login or sign up to leave a comment

Join
jabed92
I wish there was a pending order tab on 'Manage Sales' dashboard that would allow sellers to track orders that a client says he has placed.

Maybe the pending orders tab could tell you what else needs to be done before the order is finalized. For instance, it might say the buyer's credit card is being processed or they still need to provide 'instructions to the seller', etc. I think they already tell you that in an email, but it would be good to have it on the dashboard, especially for sellers who get dozens of orders every day.

It would just be easier if something like that were available.

P.S. The reason I'm worried about this situation is that a buyer has ordered two services from me and it's been well over a day and I still am not able to see the order on my manage sales tab. I can't begin work if it does not show up. And, I know that other sellers have the same issue on occasion.



You are right Beverly. I have faced same problem like you. I think it will be better if seoclerk make any solution for sellers.



Are you sure you want to delete this post?

Beverly
You are right Beverly. I have faced same problem like you. I think it will be better if seoclerk make any solution for sellers.

I am very worried about this. Has the clock already started on this job? I hope not as I can't even see it on my dashboard. I wish there was a pending order tab



Are you sure you want to delete this post?

farahkhan
I wish there was a pending order tab on 'Manage Sales' dashboard that would allow sellers to track orders that a client says he has placed.

Maybe the pending orders tab could tell you what else needs to be done before the order is finalized. For instance, it might say the buyer's credit card is being processed or they still need to provide 'instructions to the seller', etc. I think they already tell you that in an email, but it would be good to have it on the dashboard, especially for sellers who get dozens of orders every day.

It would just be easier if something like that were available.

P.S. The reason I'm worried about this situation is that a buyer has ordered two services from me and it's been well over a day and I still am not able to see the order on my manage sales tab. I can't begin work if it does not show up. And, I know that other sellers have the same issue on occasion.

I wish there was a pending order tab

Beverly you can see them here goto manage sales page and goto all orders tab there you will see your pending orders like this in the attachment I wish there was a pending order tab



Are you sure you want to delete this post?

farahkhan
I am very worried about this. Has the clock already started on this job? I hope not as I can't even see it on my dashboard. I wish there was a pending order tab

No the clock will start when he submit info dont worry about that it happens with me all the time I wish there was a pending order tab even one time my buyer submits info after 4-5 days I think and clock started when that buyer submitted the info so you are safe nothing to worry I wish there was a pending order tab



Are you sure you want to delete this post?

anwebservices
If buyer don't start the job, it's not your fault, and you can't really know that you have sale. Yes it can be confusing, i had this situation once because someone bought my service and didn't start it, then after contacting me and asking why don't i do it I wish there was a pending order tab then i had to explain how to start the job and i received notification right away about it to start...



Are you sure you want to delete this post?

jabed92
No the clock will start when he submit info dont worry about that it happens with me all the time I wish there was a pending order tab even one time my buyer submits info after 4-5 days I think and clock started when that buyer submitted the info so you are safe nothing to worry I wish there was a pending order tab


You are right farahkhan. I like your post but it will be better if seoclerks make any solution for this type of problem. I hope it will be better for sellers. Because buyers ordered us but we don't know without checking our email, it is a big problem. Hope seoclerks will fix it. thanks anyway.



Are you sure you want to delete this post?

Vivadh
Well its better to have notification for this issue .. Like when buyer paid for your service u are notified that " someone has purchased your service and they are yet to submit the required information to start your job "" This type notification system is available in another major micro job site and which is infact more helpful for seller.



Are you sure you want to delete this post?

Order Now
Process Time: 9.5171761512756

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID=1471SELECT googleplus_profile FROM seoclerks.members WHERE USERID=147

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

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

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='11768' 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='11768' 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=53636 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=53636 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=53637 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=53637 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=53638 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=53638 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=53639 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=53639 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=53640 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=53640 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=53641 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=53641 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=53642 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=53642 LIMIT 5

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

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

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

SELECT * FROM questions WHERE quesid!='11768' AND status='1' AND (question like '%I pending order tab%' OR question like '%pending%' OR question like '%order%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='11768' AND status='1' AND (question like '%I pending order tab%' OR question like '%pending%' 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='3545' limit 11SELECT 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='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='2537' limit 11SELECT 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='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='2800' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='2800' 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=11768%' 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=11768%' 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='205476.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='205476.png'

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

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

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

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

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

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

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

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

/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
0.9119821SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (42,64,90) AND gtags like'%ANIMATION%' AND type !=99 order by A.lastgigedit desc limit 120, 400.9119820.911982