SEOClerks

First time seoclerks member often face this issue



Write the reason you're deleting this FAQ

First time seoclerks member often face this issue

Hello as i am seller i have seen many orders canceled by the seller due to some mistake of one of the seoclerks feature..

First time user when placing the first of their order they are not aware to start the order by writing something on it to start on it.

After few days the order canceled by the member as its not delivered.

The seller can't deliver it even the buyer paid the seller unless and until its started.

Many of my orders canceled as buyer thought i can't able to deliver it. So this issues need to be fixed. Separate feature to be implemented where i can see not started order so that i can msg them to start the order or completely disable that system...

Comments

Please login or sign up to leave a comment

Join
danigo
yeah, i think it is the big issues for us as seller, do you ever met this problem before?
i thought it is quite difficult, happy experiencing,,
may you can discuss with us



Are you sure you want to delete this post?

sayan162
yes i have faced this issue many times...i think the feature is enabled for such services where buyer requirement is needed but not in all cases where no buyer requirement is needed..i would be happy if seoclerks development team can find some solution for it..its loss for both the sellers and buyers and also seoclerks due to this small issue.



Are you sure you want to delete this post?

Beverly
As a seller there is a lot you can do to instruct the novice buyer on how to use the site; for instance, you might include a link to a how to video or tutorial on how to 'start' the INCOMPLETE order.

Sometimes written instructions are ignored by the buyer. Though at least one seller that I know includes this technique for starting the order in his actual service description. And, he's one of the biggest sellers on the SEOClerks Marketplace. So maybe he's on to something.



Are you sure you want to delete this post?

MusicMoguls
Nice question, thank you. I have run into this issue before and I just end up messaging the client to let them know that in order for me to start their order, they must sumbit details. Maybe Seoclerks can put some kind pop up screen after they place their order, to inform the buyer that nothing can be started by the seller unless they submit details first. Hopefully this can help you a little bit and maybe admin will consider something like this! Thanks again Sayan!



Are you sure you want to delete this post?

sayan162
Thanks a lot i am waiting for this issue to get solved..

Anyways thanks alot,,,

what is your name?



Are you sure you want to delete this post?

Beverly
I'm not against this kind of thing, but with that being said, every little update takes time and energy away from the big updates. Even if it seems like a little tweak, it's probably not. And, even adding one little line of text here or there takes time. Actual coding is involved.

As a seller, you have a responsibility instruct your buyers extensively in the 'instructions' box on exactly how to start that order. Or, if you know which buyer that it is with an incomplete order, then message them with good details on how to start that order. Don't expect a novice buyer to know how this is done, most don't/won't and will blame you for not receiving the followers/likes/whatever even if it's the buyer's fault for not providing those initial details on the INCOMPLETE order.

Little does a buyer know, the order never reaches the seller if they can't do that one simple thing, login and add their information. It's your job to inform them.



Are you sure you want to delete this post?

sayan162
Its okay but many buyer not understand English properly..many buyer ask question where to write it..

If seller waste time on buyer and guiding them how to place order then replying to others who need actual support regarding my services will be delayed. I have been here 1 year and i usually avoided this issue but last month many orders canceled due to this.

I am receiving many order daily so its very hard for me to keep checking mails of every orders..I came to know when the order been canceled by the buyer.

This will take time to be fixed but i am sure every seller faced this issue atleast one time on seoclerks.



Are you sure you want to delete this post?

Jhon012
u knw somtimes da seoclerks administer cancel da order after i submit i dnt knw y



Are you sure you want to delete this post?

sayan162
thats is paypal dispute issue or payment error thats why its been cancelled..



Are you sure you want to delete this post?

mostakinhossain
Nice question, thank you. I have run into this issue before and I just end up messaging the client to let them know that in order for me to start their order, they must sumbit details. Maybe Seoclerks can put some kind pop up screen after they place their order, to inform the buyer that nothing can be started by the seller unless they submit details first. Hopefully this can help you a little bit and maybe admin will consider something like this! Thanks again Sayan!



Are you sure you want to delete this post?

Cristian
Maybe SEOclerks should have a first order introduction tutorial. Where the seller is guided by a special structure that only appears on the first order.
Much like those registrations apps and games that guide you until you set up your first "something". After this first guide and tutorial, there should be a message, "you are now ready to use SEOclerks marketplace".

I doubt many of the new clients know how to reach their active orders section.



Are you sure you want to delete this post?

siriuskuddo
yap, yesterday one of my buyer do that.he ask me with a message , why job not started.and Im telling her to check her order, and yap, he not writing something get make job started,



Are you sure you want to delete this post?

Order Now
Process Time: 0.104159116745

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID=1309321SELECT googleplus_profile FROM seoclerks.members WHERE USERID=130932

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

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

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='18832' 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='18832' 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=104056 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=104056 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=104058 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=104058 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=104070 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=104070 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=104063 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=104063 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=104065 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=104065 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=104072 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=104072 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=104074 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=104074 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=104052 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=104052 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=104054 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=104054 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=104079 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=104079 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=104164 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=104164 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=185953 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=185953 LIMIT 5

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

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

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

SELECT * FROM questions WHERE quesid!='18832' AND status='1' AND (question like '%First time seoclerks member face issue%' OR question like '%First%' OR question like '%time%' OR question like '%seoclerks%' OR question like '%member%' OR question like '%face%' OR question like '%issue%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='18832' AND status='1' AND (question like '%First time seoclerks member face issue%' OR question like '%First%' OR question like '%time%' OR question like '%seoclerks%' OR question like '%member%' OR question like '%face%' OR question like '%issue%') -- ORDER BY RAND() LIMIT 15

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

SELECT * FROM seoclerks.members WHERE USERID='9' limit 11SELECT 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='1364' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='1364' limit 1

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

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

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

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

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

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

/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='139192.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='139192.png'

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

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

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

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

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

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

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

SELECT * FROM seoclerks.members WHERE USERID='541625.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='541625.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.3693661SELECT 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.viewcount desc LIMIT 0,400.3693660.369366
0.3543831SELECT 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.3543830.354383