Anierato
Level 1
Write the reason you're deleting this FAQ
Hee! Guys
I'm James by name and am new here, please how does it work here?
Are you sure you want to delete this post?



I try to help out as many newbies as possible, but I'm not online every day, so you might not get a response right away lol.
Hi James!
As a buyer/seller you have access to loads of potential customers or services you can purchase. It's pretty simple actually, you just choose the service you want, pay for it, then add the details into the next page and you are ready to submit the info to the seller. If you're a seller yourself, you simply add new services by going to SELLER >> Sell >> Sell a Service and you will open a page where you can input all the information you can think of related to your service. You can even add in some add ons to boost your profits per sale and give buyers a little something extra :)
I would highly suggest you take your time setting up a service, if you're a seller, because that is like handing out your business card to someone. You want your service to look great, have images, and essentially tell the potential buyer that you're the best at what you do and they shouldn't be worried about buying from you. Plenty of people add a wall of text and complain about not getting sales, and it's pretty obvious why they aren't. Would you want to read through a novel of content to figure out what the person is selling? Nope :D
Add a quick snippet of information about your service at the top of the description. Add some bullet points/selling points after the intro, then add some images to prove you can really do what you say you will. If you already have testimonials from buyers, throw those in there as well! Social proof is big when it comes to selling online and I use it whenever I possibly can :D
If you have any other questions about this marketplace please post them and someone will try to give you a detailed answer :) I try to help out as many newbies as possible, but I'm not online every day, so you might not get a response right away lol.
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='28786' | 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='28786' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='827388' | 1 | SELECT * FROM seoclerks.members WHERE USERID='827388' | /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=827388 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=827388 | /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=28786 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=28786
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='28786' 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='28786' 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=187601 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=187601
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=187602 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=187602
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=187616 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=187616
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='28786' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='28786' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='28786' AND status='1' AND (question like '%Introduction seocerks works%' OR question like '%Introduction%' OR question like '%seocerks%' OR question like '%works%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='28786' AND status='1'
AND (question like '%Introduction seocerks works%' OR question like '%Introduction%' OR question like '%seocerks%' OR question like '%works%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='3881' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3881' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='208' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='208' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='5899' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='5899' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='19120' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='19120' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='17130' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='17130' 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=28786%' 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=28786%'
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='466771.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='466771.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='827388.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='827388.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| 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 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 |
akamarvalous
As a prospective buyer, you'll have an abundance of options in the Marketplace to help build your business. Just find the categories that you desire and drill down to the individual services which best fits your needs. There are a lot of reliable freelancers on this site. Take the time to contact them directly for any service that you are interested in. This gives you the chance to check responsiveness and to request samples where applicable.
As a prospective seller, the key early on is to focus on getting clear and detailed services posted that is related to your skillset. I would definitely take some time to browse through some of the services that are currently being listed in your niche to get an idea of what's being offered and at what price. This is a great practice because you may have a unique skillset that's hasn't been offered yet or a skill that hasn't become a victim to oversaturation.
You can find more details about listing guidelines here: https://www.seoclerks.com/listing_guidelines. As a new seller, your priimary focus should be on establishing good communication with potential buyers and producing quality work.
Your seller level will continually increase based on your sales, ratings, affiliate sales, response times and more. You can find more details about seller levels here: https://www.seoclerks.com/userlevels/
Most importantly, have fun and follow people. From a seller perspective on SEOClerks, I'm still climbing the charts myself, so if you have any questions please feel free to ask. Hello James. Welcome to the party [img h=16 w=16]https://www.seoclerks.com/images/emoticon/emoticon-smile.png[/img] As a prospective buyer, you'll have an abundance of options in the Marketplace to help build your business. Just find the categories that you desire and drill down to the individual services which best fits your needs. There are a lot of reliable freelancers on this site. Take the time to contact them directly for any service that you are interested in. This gives you the chance to check responsiveness and to request samples where applicable. As a prospective seller, the key early on is to focus on getting clear and detailed services posted that is related to your skillset. I would definitely take some time to browse through some of the services that are currently being listed in your niche to get an idea of what's being offered and at what price. This is a great practice because you may have a unique skillset that's hasn't been offered yet or a skill that hasn't become a victim to oversaturation. You can find more details about listing guidelines here: [url=https://www.seoclerks.com/listing_guidelines]https://www.seoclerks.com/listing_guidelines[/url]. As a new seller, your priimary focus should be on establishing good communication with potential buyers and producing quality work. Your seller level will continually increase based on your sales, ratings, affiliate sales, response times and more. You can find more details about seller levels here: [url=https://www.seoclerks.com/userlevels/]https://www.seoclerks.com/userlevels/[/url] Most importantly, have fun and follow people. From a seller perspective on SEOClerks, I'm still climbing the charts myself, so if you have any questions please feel free to ask.
Are you sure you want to delete this post?