LordLoki
Level 3
Write the reason you're deleting this FAQ
Hello
I have recently started my journey as a seller here and I look forward to learning (and improving) from the more experienced members.
>>> This is the link to my second listing on SEOClerk
However:
1. I am not getting any sales or any enquiries either.
2. I am doing boosts twice a day
Can you please suggest what can be improved, how can I get more sales quickly and how to make it a better experience for the buyers overall?
Thanks
LordLoki
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='30566' | 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='30566' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='508287' | 1 | SELECT * FROM seoclerks.members WHERE USERID='508287' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=508287 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=508287 | /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=30566 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=30566
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='30566' 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='30566' 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=191524 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=191524
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=191519 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=191519
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=191520 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=191520
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=191514 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=191514
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='30566' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='30566' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='30566' AND status='1' AND (question like '%Please provide constructive criticism service listing%' OR question like '%Please%' OR question like '%provide%' OR question like '%constructive%' OR question like '%criticism%' OR question like '%service%' OR question like '%listing%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='30566' AND status='1'
AND (question like '%Please provide constructive criticism service listing%' OR question like '%Please%' OR question like '%provide%' OR question like '%constructive%' OR question like '%criticism%' OR question like '%service%' OR question like '%listing%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='2077' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2077' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='3080' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3080' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='9399' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='9399' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='6628' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='6628' 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=30566%' 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=30566%'
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='885500.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='885500.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='147.jpg' | 1 | SELECT 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='508287.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='508287.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='805244.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='805244.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 |
sai89
1 Boost your Service daily
2 active online
3 Ask your Buyers to give a rating about service
Having the perfect sales page is like a good 3-course meal. First, you want the starter which is your title and header description. It needs to be well punctuated and well pronounced containing everything it needs to and no more. Then you have the mains which are the part of your sales page that explains exactly what the service is, what you’ll be doing and what the customer gets etc. Then you have the dessert which could be your guarantee and contact details etc. It all needs to be well laid out, nicely and correctly formatted, no sloppy spelling mistakes or grammar errors. If you’re not a native English writer/speaker then get someone who is to proofread it for you.
So having a good sales page will help you to sell more but its only half the trick. You will need to have a well-established profile as well and be a Level 3 seller at the minimum if you are to really stand a chance of getting the buyers. And to do that you’ll have to meet those minimum requirements once again as well. Fortunately, these requirements that SEOClerks have set out are not that hard to get and many people have managed to meet them all quite quickly and go on to sell many services.
Know that it’s not just recommended to level up as a seller because of the rating it gives you but doing so actually gives you more and more benefits each time too. SEOClerks have dedicated a whole page to explaining User Levels and what the minimum requirements of how to attain each are here here some tips which help me a lot 1 Boost your Service daily 2 active online 3 Ask your Buyers to give a rating about service Having the perfect sales page is like a good 3-course meal. First, you want the starter which is your title and header description. It needs to be well punctuated and well pronounced containing everything it needs to and no more. Then you have the mains which are the part of your sales page that explains exactly what the service is, what you’ll be doing and what the customer gets etc. Then you have the dessert which could be your guarantee and contact details etc. It all needs to be well laid out, nicely and correctly formatted, no sloppy spelling mistakes or grammar errors. If you’re not a native English writer/speaker then get someone who is to proofread it for you. So having a good sales page will help you to sell more but its only half the trick. You will need to have a well-established profile as well and be a Level 3 seller at the minimum if you are to really stand a chance of getting the buyers. And to do that you’ll have to meet those minimum requirements once again as well. Fortunately, these requirements that SEOClerks have set out are not that hard to get and many people have managed to meet them all quite quickly and go on to sell many services. Know that it’s not just recommended to level up as a seller because of the rating it gives you but doing so actually gives you more and more benefits each time too. SEOClerks have dedicated a whole page to explaining User Levels and what the minimum requirements of how to attain each are here
Are you sure you want to delete this post?