What can you do to activate pending order?

ajlancer Level X³

June 4, 2016, 4:40 am

Write the reason you're deleting this FAQ

What can you do to activate pending order?

Each day many buyers come to Seoclerks marketplace to purchase service and many of them are new members. So, when they purcahse service, they don't know how to start the order with required information they need to provide to seller. That's how order get stuck in "Pending" status, sometime for long time.

If you as a seller note some of these pending orders without required information, best option is to contact buyer as soon as possible and ask for needed information, so you can proceed with your work. just leave simple message on sales conversation page or send to inbox.

For example:
Title of message: Hi, your order #05050505 is still pending
In the message body you can mention service he / her bought and ask for required information to be submitted as soon as possible so you can start your work. That's how sale will be activated from pending to active.

Let me know if you need any more help.
Thanks by Ajlancer

Comments

Please login or sign up to leave a comment

Join

anwebservices

Very good point Ajlancer. Hopefully new members will find this tutorial before they make one of this mistakes. And also, sellers now get idea how to fix a problem like this if it occur.

10 years ago

Are you sure you want to delete this post?

EliteWriter

Yes, this is one of the most tiresome things I face here. Unfortunately many buyers are not aware of it. They think that once they have bought a service there is nothing else for them to do. Once I had an order that was ordered more than three months before, and the buyer realized that he wanted to submit the instructions all those weeks later. As sellers we get an email that someone bought a service from us, but it is only until the buyer submits the instructions that we are able to access the order. I wish this procedure could be improved as I get so many orders which remain pending, and I do not fancy the fact that I get two emails for each order to be honest. Moreover some buyers, even after being contacted still did not understand what they had to do. There were a couple of occasions when they thought I was trying to make them place an order twice! Obviously that was not the case but since there are several who are not that good at understanding english it is increasingly difficult to make this procedure clear to them, or at least that was what happened to me.

10 years ago

Are you sure you want to delete this post?

Avg Time	Count	SQL	Max	Min
0.310306	1	SELECT 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,40	0.310306	0.310306

SEOClerks

What can you do to activate pending order?

What can you do to activate pending order?

Comments

Please login or sign up to leave a comment

anwebservices

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='9982'	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='9982'	/opt/clerks-staging/docroot/viewfaq.php 496 () ()
SELECT * FROM seoclerks.members WHERE USERID='4987'	1	SELECT * FROM seoclerks.members WHERE USERID='4987'	/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
SELECT * FROM seoclerks.members WHERE USERID=4987	1	SELECT googleplus_profile FROM seoclerks.members WHERE USERID=4987	/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=9982 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=9982 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='9982' 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='9982' 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=39039 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=39039 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=39040 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=39040 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
UPDATE questions SET total_views = total_views + 1 WHERE quesid='9982'	1	UPDATE questions SET total_views = total_views + 1 WHERE quesid='9982'	/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
SELECT * FROM questions WHERE quesid!='9982' AND status='1' AND (question like '% activate pending order?%' OR question like '%activate%' OR question like '%pending%' OR question like '%order?%') -- ORDER BY RAND() LIMIT 15	1	SELECT quesid, question, seo, userid FROM questions WHERE quesid!='9982' AND status='1' AND (question like '% activate pending order?%' OR question like '%activate%' 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='24930' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='24930' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='30' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='30' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='4674' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='4674' 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 1	1	SELECT 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='10788' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='10788' 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=9982%' 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=9982%' 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='254580.jpg'	1	SELECT 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='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()