Aizad
Level 1
Write the reason you're deleting this FAQ
I thought it would be best to learn from PRO's..
" Can any one here could guide me towards how to get my first order; what's the catch! Should I advert my services outside the seoclerks or should I wait for it to come to me".
Thanks.
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?
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='20799' | 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='20799' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='434408' | 1 | SELECT * FROM seoclerks.members WHERE USERID='434408' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM categories_faq WHERE CATID='42' | 1 | SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='42' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType() |
| SELECT * FROM seoclerks.members WHERE USERID=434408 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=434408 | /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=20799 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=20799
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='20799' 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='20799' 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=113211 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=113211
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=188730 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=188730
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=113232 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=113232
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=113292 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=113292
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=113773 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=113773
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=146530 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=146530
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=146555 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=146555
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='20799' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='20799' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='20799' AND status='1' AND (question like '%How order?%' OR question like '%order?%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='20799' AND status='1'
AND (question like '%How order?%' 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='19824' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='19824' 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='29659' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='29659' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='19291' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='19291' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='12835' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='12835' 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=20799%' 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=20799%'
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='272.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='272.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='856477.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='856477.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| 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='134.png' | 1 | SELECT 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='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='589438.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='589438.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 |
idealmike
It's hard, but it's not impossible to get your first sales. And I've helped lots of people on here before that were new sellers to get their first orders. By providing them with tips and tricks to go about getting them. I'll try to put them here in a condensed version. Basically, you want to make sure your service descriptions and the images you use in them are 100% unique. It needs to look good with text formatting and highlighting and the like. And also videos can really help too. Service descriptions that have videos in them sell a lot more than those that don't. And try to use a long description that puts some emphasis on the details of that actual service. People like details and they like to see samples and examples of work and stuff like that so the more of that you can put in your service descriptions the better!
And on to your seller profile. I see you are phone verified so that's cool. You could also go one step further and get address verified as well. Doing that will not only add another level of security to your account, (and score you another $5 coupon code too) but also increase the trust that people have in you as a seller. Likewise, increasing your post and response count on here can also give people more confidence in you as a seller. In fact, the Community Discussions here are your way and chance to establish yourself as an expert in your niche. And you want people to think you're an expert at what you do so that they will be more likely to buy from you. That's why your discussions and responses are linked to from your profile.
And one other tip I'll leave you with, which is the best of them all for some sellers. Is to make your service very cheap. Very cheap. Like $1. I know that might seem daft to you. But it will help you to get sales and then get feedback for that rendered service. Once you have some good feedback ratings for it, you can increase the price a little bit more and more. That's worked well for me and for many others here.
Okay that's that, I hope you'll follow these tips and advices and apply them and good luck at finding success on SEOClerks!
Anyone can if they just apply themselves.
Cheers!
Mike. Hi Aizad, welcome to SEOClerks! Thanks for posting your question. I think it's one that many new sellers here find themselves asking from time to time. Especially when and or if they are selling some of the same services that some much more established sellers here are already providing. So how to get people to buy your services when you have no ratings, no recommendations or any kind of trust with people yet? Because that's what it's all about is how much people trust you based on how many ratings, recommendations etc etc that you have. So it can be hard for a new seller to get sales for their new services they haven't got any previous sales for. And as such, no ratings (feedback) or any recommendations on their profile from people. And buyers look at this as a way of knowing which seller to go with for a service. It's hard, but it's not impossible to get your first sales. And I've helped lots of people on here before that were new sellers to get their first orders. By providing them with tips and tricks to go about getting them. I'll try to put them here in a condensed version. Basically, you want to make sure your service descriptions and the images you use in them are 100% unique. It needs to look good with text formatting and highlighting and the like. And also videos can really help too. Service descriptions that have videos in them sell a lot more than those that don't. And try to use a long description that puts some emphasis on the details of that actual service. People like details and they like to see samples and examples of work and stuff like that so the more of that you can put in your service descriptions the better! And on to your seller profile. I see you are phone verified so that's cool. You could also go one step further and [url=https://www.seoclerks.com/faq/9981/How-To-Verify-Your-Address-And-The-Benefits-Of-Doing-That]get address verified[/url] as well. Doing that will not only add another level of security to your account, (and score you another $5 coupon code too) but also increase the trust that people have in you as a seller. Likewise, increasing your post and response count on here can also give people more confidence in you as a seller. In fact, the [url=https://www.seoclerks.com/faq/][b]Community Discussions[/b][/url] here are your way and chance to establish yourself as an expert in your niche. And you want people to think you're an expert at what you do so that they will be more likely to buy from you. That's why your discussions and responses are linked to from your profile. :) And one other tip I'll leave you with, which is the best of them all for some sellers. Is to make your service very cheap. Very cheap. Like $1. I know that might seem daft to you. But it will help you to get sales and then get feedback for that rendered service. Once you have some good feedback ratings for it, you can increase the price a little bit more and more. That's worked well for me and for many others here. :) Okay that's that, I hope you'll follow these tips and advices and apply them and good luck at finding success on SEOClerks! Anyone can if they just apply themselves. :) Cheers! Mike.
Are you sure you want to delete this post?