dipto
Level 1
Write the reason you're deleting this FAQ
Hello,
I'm new in SeoClerks. Generally have not much sell. I'm Google and Amazon SEO expert. How can i boost by sell on seoclerks?
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='22153' | 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='22153' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='548698' | 1 | SELECT * FROM seoclerks.members WHERE USERID='548698' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=548698 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=548698 | /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=22153 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=22153
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='22153' 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='22153' 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=116032 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=116032
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=131079 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=131079
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=131078 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=131078
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='22153' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='22153' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='22153' AND status='1' AND (question like '%How I Boost Sell SeoClerks%' OR question like '%Boost%' OR question like '%Sell%' OR question like '%SeoClerks%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='22153' AND status='1'
AND (question like '%How I Boost Sell SeoClerks%' OR question like '%Boost%' OR question like '%Sell%' OR question like '%SeoClerks%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='1323' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1323' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='9' limit 1 | 1 | SELECT 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='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='1643' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1643' 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 1 | 1 | SELECT 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=22153%' 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=22153%'
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='526322.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='526322.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
And there has been quite a lot of stuff posted to the FAQ recently and in the past months on how to get more sales. One way is to make sure you are bumping your service(s) every day. You can advertise your service(s) even more with category highlighting too. But the best way really is to do SEO and promotion, advertising of them in various ways. Using social media, using forums etc etc.
If you're an SEO expert, that shouldn't be too hard for you. I checked out your profile. I see you have only 1 service. I checked it out and it doesn't appear to really go into much detail about what it offers and how it can help people. If possible (and I say this for your benefit) you should add more details to it about what it actually is you're selling there, what you'll actually do for people, what it is they'll actually be getting and how it will help and benefit them. This will greatly boost your sales of that service.
Another thing you can do, and something that will give people more confidence in you as a seller, is to verify your phone number and also verify your physical address as well. Also by doing this, you can receive alerts of new services that are on sale and other stuff. Not to mention, periodically receive a card in the post from SEOClerks with a $5.00 coupon code.
It's like unlimited free spending money just for doing that and the other benefits that doing that comes with too.
Hope this helps and to your success!
Mike. Hi Dipto and welcome to SEOClerks! And good on you for posting to the Community here, that puts you one step ahead of the rest! And by doing so, and by being active on the Community FAQ here, you can establish yourself as an expert in your niche/industry, by being helpful and answering peoples questions. At the same time, you'll be promoting yourself and your services too since a link appears in all your posts (discussions and responses) to your profile. And there has been quite a lot of stuff posted to the FAQ recently and in the past months on how to get more sales. One way is to make sure you are bumping your service(s) every day. You can advertise your service(s) even more with category highlighting too. But the best way really is to do SEO and promotion, advertising of them in various ways. Using social media, using forums etc etc. If you're an SEO expert, that shouldn't be too hard for you. I checked out your profile. I see you have only 1 service. I checked it out and it doesn't appear to really go into much detail about what it offers and how it can help people. If possible (and I say this for your benefit) you should add more details to it about what it actually is you're selling there, what you'll actually do for people, what it is they'll actually be getting and how it will help and benefit them. This will greatly boost your sales of that service. :) Another thing you can do, and something that will give people more confidence in you as a seller, is to verify your phone number and also [url=https://www.seoclerks.com/faq/9981/How-To-Verify-Your-Address-And-The-Benefits-Of-Doing-That]verify your physical address[/url] as well. Also by doing this, you can receive alerts of new services that are on sale and other stuff. Not to mention, periodically receive a card in the post from SEOClerks with a $5.00 coupon code. It's like unlimited free spending money just for doing that and the other benefits that doing that comes with too. :) Hope this helps and to your success! Mike.
Are you sure you want to delete this post?