Help me create a new service

rofiqul14 Level 1

October 31, 2016, 8:48 pm

Write the reason you're deleting this FAQ

Help me create a new service

I am a new seller at SEOClerk. I need help to create a new service. I have heard that others are having trouble creating services too. Please tell me the process of creating a service. What services should I sell or what will be popular? What are good words to use to win orders.

Thanks
Rofiqul

Comments

Please login or sign up to leave a comment

Join

procoder

Hello rofiqul14,

Welcome to SEOClerks! I don't know what problems are you talking about, but if you're facing technical problems while creating services I think you will need to contact with support team for that, or if you want to know how to create a service, take a look to the link that chetaseo mentioned.

Now as per what services should you offer, well think about what services are you able to offer to your clients, simply go with what you know to do better and what you love to do as that's the most important thing. All services have its own popularity and clients, build your reputation here and you'll see that popularity it's in your hand. And don't forget that we all have started from 0. Wish you good luck, to your success!

Thank you,
Procoder

9 years ago

Are you sure you want to delete this post?

Beverly

Hey procoder, I absolutely agree with you on this! You have to go with what you love in terms of freelance services or you will just end up miserable. I have dabbled in SEO related work, backlink building and just hate it! It makes me tired, I don't feel good doing it. It's boring. But get me on a forum and I thrive as I love talking to people! So for that reason, I made the unusual choice to offer forum posting and blog commenting services. I had the best success with new forum owners. And, my posts were always appreciated. I always tried to go above and beyond what was expected and hopefully more than my 'competition' - which by the way, there are not many good quality writers in the forum posting section. So a person who can write well and research a lot is likely to earn well with that. Some days, I was so busy at my paid forum posting jobs from SEOClerks that I did not have time for lunch! That shows you what a good niche it is to work in. Now, that's just something that worked for me. But I bet there are others who would find forum posting boring or would rather do other things with a computer and it's great if you can find one or two good things that work for you - if not writing, then coding or blogging or making Youtube videos or graphics. If you love it enough, your enthusiasm for that service will show through and you will earn very well with your clients.

9 years ago

Are you sure you want to delete this post?

chetaseo

follow this link for instructions on how to do so; https://ionicware.zendesk.com/hc/en-us/articles/206815117-How-to-create-a-service
if you have any other questions or issues, contact the seoclerks team for more explanation or clarification; https://ionicware.zendesk.com/hc/en-us/requests/new

9 years ago

Are you sure you want to delete this post?

Avg Time	Count	SQL	Max	Min
0.157276	1	SELECT count(A.PID) as total from posts A , seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND A.USERID=C.USERID AND category IN (91,15,16,67,92,93,94,95,96,97,98,99,100,101,102) AND gtags like'%ariticlewriting%' AND type !=99	0.157276	0.157276

SEOClerks

Help me create a new service

Help me create a new service

Comments

Please login or sign up to leave a comment

procoder

Beverly

chetaseo

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='20262'	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='20262'	/opt/clerks-staging/docroot/viewfaq.php 496 () ()
SELECT * FROM seoclerks.members WHERE USERID='524716'	1	SELECT * FROM seoclerks.members WHERE USERID='524716'	/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()
SELECT * FROM seoclerks.members WHERE USERID=524716	1	SELECT googleplus_profile FROM seoclerks.members WHERE USERID=524716	/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=20262 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=20262 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='20262' 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='20262' 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=110359 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=110359 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=110372 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=110372 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=110354 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=110354 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
UPDATE questions SET total_views = total_views + 1 WHERE quesid='20262'	1	UPDATE questions SET total_views = total_views + 1 WHERE quesid='20262'	/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
SELECT * FROM questions WHERE quesid!='20262' AND status='1' AND (question like '%Help create service%' OR question like '%Help%' OR question like '%create%' OR question like '%service%') -- ORDER BY RAND() LIMIT 15	1	SELECT quesid, question, seo, userid FROM questions WHERE quesid!='20262' AND status='1' AND (question like '%Help create service%' OR question like '%Help%' OR question like '%create%' OR question like '%service%') -- ORDER BY RAND() LIMIT 15	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM seoclerks.members WHERE USERID='632' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='632' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='1159' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='1159' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='3644' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='3644' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='3302' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='3302' 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=20262%' 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=20262%' 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='377074.png'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='377074.png'	/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='198791.jpg'	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='198791.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()