faiz123
Level 1
Write the reason you're deleting this FAQ
I want to know can i category feature my service? And will it help me to sell more?
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 members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400 | 1 | SELECT querystring, added
FROM members_ledger
WHERE
ip = ? AND added>=unix_timestamp(NOW())-86400 | /opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once() |
| 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='25210' | 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='25210' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='627852' | 1 | SELECT * FROM seoclerks.members WHERE USERID='627852' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=627852 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=627852 | /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=25210 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=25210
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='25210' 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='25210' 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=146588 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=146588
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=146702 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=146702
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=146501 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=146501
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=146509 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=146509
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=146527 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=146527
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=152049 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=152049
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='25210' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='25210' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='25210' AND status='1' AND (question like '%How category feature service SeoClerk %' OR question like '%category%' OR question like '%feature%' OR question like '%service%' OR question like '%SeoClerk%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='25210' AND status='1'
AND (question like '%How category feature service SeoClerk %' OR question like '%category%' OR question like '%feature%' OR question like '%service%' OR question like '%SeoClerk%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='2921' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2921' 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 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 members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=25210%' 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=25210%'
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='19821.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='19821.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='585810.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='585810.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='634003.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='634003.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 seoclerks.members WHERE USERID='301993.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='301993.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 |
| 0.191565 | 1 | SELECT COUNT(A.wantid) AS total FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID | 0.191565 | 0.191565 |
TommyCarey
Basically what you'll need to do is go to your services page and click "Category Feature" and you'll be redirected to a page where you can purchase and input your service URL so you can push it to the top of the category.
That path you'll need to take will look like this:
Basically, you'll hover over "SELLER" and a drop down will come out, then hover over "Manage" and a secondary drop down will come out where you can then click on "My Services".
After you click on "My Services" you will come to a page where all of your services are listed, and it will show the amount of sales you've had, active sales, and how many views your service has had. Just below each service you will see various upgrade options, where you can choose "Category Feature" and be directed to the page that allows you to purchase the advertising option.
After clicking "Category Feature" you will be directed to a page that looks like this:
You can do all that, or simply click on this link, which will send you to the page where you can purchase the category feature upgrade: https://www.seoclerks.com/Other/15...vice-for-31-Days
After you click "Order Now ($50)" you will then be directed to a cart where you can use your balance or pay with your preferred payment method. You can actually use your balance and a preferred method if you don't have $50 in your account, which is pretty awesome if I do say so myself
After you pay, you will be asked which Service/URL you'd like to feature and after you submit it, you will be good to go! I did notice that it takes a couple hours at max to see your service featured within the category, but it's all automated so you don't have to worry about user error. The first time I featured my service using the "Category Feature" option, it didn't take more than 30 seconds for everything to go through. The second time I purchased this for my writing service, it took around 90 minutes for everything to go through and be featured, so just be patient
As for increasing your sales, it definitely will
I hope that helps
- Razzy It's actually not too difficult to do, but would be confusing if you've never done it before or if you're a new seller. Basically what you'll need to do is go to your services page and click "Category Feature" and you'll be redirected to a page where you can purchase and input your service URL so you can push it to the top of the category. That path you'll need to take will look like this: [url=https://www.seoclerks.com/files/user/community/000/019/821/SEOclerks Category Feature 1.1514853739.png][url=https://www.seoclerks.com/files/user/community/000/019/821/SEOclerks Category Feature 1.1514853739.png][img]https://www.seoclerks.com/files/user/community/000/019/821/SEOclerks Category Feature 1.1514853739.png[/img][/url][/url] Basically, you'll hover over "SELLER" and a drop down will come out, then hover over "Manage" and a secondary drop down will come out where you can then click on "My Services". After you click on "My Services" you will come to a page where all of your services are listed, and it will show the amount of sales you've had, active sales, and how many views your service has had. Just below each service you will see various upgrade options, where you can choose "Category Feature" and be directed to the page that allows you to purchase the advertising option. [url=https://www.seoclerks.com/files/user/community/000/019/821/SEOclerks Category Feature.1514854531.png][url=https://www.seoclerks.com/files/user/community/000/019/821/SEOclerks Category Feature.1514854531.png][img]https://www.seoclerks.com/files/user/community/000/019/821/SEOclerks Category Feature.1514854531.png[/img][/url][/url] After clicking "Category Feature" you will be directed to a page that looks like this: [img h=10000 w=10000]https://i.gyazo.com/69b4ff5e3c910acf765b864a639f4a08.png[/img] You can do all that, or simply click on this link, which will send you to the page where you can purchase the category feature upgrade: [url=https://www.seoclerks.com/Other/159232/Category-Feature-your-Service-for-31-Days]https://www.seoclerks.com/Other/159232/Category-Feature-your-Service-for-31-Days[/url] After you click "Order Now ($50)" you will then be directed to a cart where you can use your balance or pay with your preferred payment method. You can actually use your balance and a preferred method if you don't have $50 in your account, which is pretty awesome if I do say so myself :D After you pay, you will be asked which Service/URL you'd like to feature and after you submit it, you will be good to go! I did notice that it takes a couple hours at max to see your service featured within the category, but it's all automated so you don't have to worry about user error. The first time I featured my service using the "Category Feature" option, it didn't take more than 30 seconds for everything to go through. The second time I purchased this for my writing service, it took around 90 minutes for everything to go through and be featured, so just be patient :) As for increasing your sales, it definitely will :D I've paid a total of $100 to $120 for my category featured upgrade and a highlighted feature, in order to get my service in front of more people and have clients returning every week for more orders :D Obviously, if you have a better service than the rest, you will have more people coming back for more. Just be sure to do the best you can, over deliver, be responsive, and always be professional and friendly at the same time to anyone who purchases from you or is simply asking you a question on your service or in a PM :) I hope that helps :) - Razzy
Are you sure you want to delete this post?