samstone6688
Level 1
Write the reason you're deleting this FAQ
I'm a new seller on SEOClerks and would love some tips on making more sales and earning more money as a seller. I would love to hear your experience on being a better seller.
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?
The perfect description is creative, clear and you should provide value right from the start. Here are some tips to help you out..
The screenshots below will show you how to bump your service.
In the beginning of your career you'll need reviews. Below I'll show you a great way to squeeze out more sales and get even more reviews. Actually, this is something you should do once in awhile, even if you rake in 50+ sales per day..
Response time often plays a major role when buyers decides to hire you or not. A seller with less response time is often hired before others having longer response time. It's a fact and it's quite logical. Here you will learn why and how to decrease your response time.
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='9899' | 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='9899' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='388831' | 1 | SELECT * FROM seoclerks.members WHERE USERID='388831' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=388831 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=388831 | /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=9899 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=9899
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='9899' 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='9899' 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=38559 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=38559
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=38561 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=38561
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=38565 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=38565
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=38577 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=38577
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=38609 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=38609
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=38713 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=38713
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=39001 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=39001
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=146481 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=146481
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='9899' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='9899' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='9899' AND status='1' AND (question like '%How I sales SEOClerks seller?%' OR question like '%sales%' OR question like '%SEOClerks%' OR question like '%seller?%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='9899' AND status='1'
AND (question like '%How I sales SEOClerks seller?%' OR question like '%sales%' OR question like '%SEOClerks%' OR question like '%seller?%')
-- 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='3290' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3290' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='957' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='957' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='498' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='498' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='3160' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3160' 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=9899%' 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=9899%'
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='311920.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='311920.jpg' | /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='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='4987.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='4987.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='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 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
Also, the price needs to be fair and reasonable too. Not overpriced but also not under priced either. You don't want to devalue your service by providing it at too cheap a price. If you make it too cheap, it actually devalues the service just by the price. So that's one thing to get right.
Make sure your services are very well presented. Use the right combination of font, font size and colour. Underline and bold important words. Use bullet points to put across the most important parts of your service. Make sure there are no spelling mistakes or grammar errors. Use high quality images only and never use low quality images. A mans service is a reflection of his personality! ;)
Then there's the customer service that you offer. You should treat all your customers like pure gold. After all, they are the ones that are enabling you to eat and pay your bills and put new shoes on your feet. Treat all buyers with high regard and esteem and always work hard to make sure that they are treated very well and always go the extra mile to make people happy. This will reflect on you because they will return to buy your service again or your other services too if they see them. Knowing how good your support is they are likely to buy again.
Remember too, to bump your services every day. You get 5 free bumps per day and can earn new bumps by logging in everyday, completing orders on time, generating affiliate sales or by posting comments on forum threads. Bump your services regularly every day around the time when you think most of your likely buyers will be online. This is usually in the late afternoon between 5-7 as most people get home around that time, have their dinner and then come onto SEOClerks to buy some SEO service for whatever reason.
Of course, there is also the paid feature option where you can pay a small fee to have your service highlighted in the lists or even category featured so that it's highlighted in the category that the service is in. That is one way to get an advantage over other similar services because people are much more likely to buy it if it's been featured/highlighted but again, that all depends on the quality of the gig description etc.
I hope that you will consider these tips and they provide to be useful to you! Well, first things first, you need to provide services that are in high demand. And those services should be unique unlike any other service. Even if the service is similar to other high selling services on here, it needs to have something about it that makes it unique that none of the other similar services are offering. Also, the price needs to be fair and reasonable too. Not overpriced but also not under priced either. You don't want to devalue your service by providing it at too cheap a price. If you make it too cheap, it actually devalues the service just by the price. So that's one thing to get right. Make sure your services are very well presented. Use the right combination of font, font size and colour. Underline and bold important words. Use bullet points to put across the most important parts of your service. Make sure there are no spelling mistakes or grammar errors. Use high quality images only and never use low quality images. A mans service is a reflection of his personality! ;) Then there's the customer service that you offer. You should treat all your customers like [b]pure gold[/b]. After all, they are the ones that are enabling you to eat and pay your bills and put new shoes on your feet. Treat all buyers with high regard and esteem and always work hard to make sure that they are treated very well and always go the extra mile to make people happy. This will reflect on you because they will return to buy your service again or your other services too if they see them. Knowing how good your support is they are likely to buy again. Remember too, to bump your services every day. You get 5 free bumps per day and can earn new bumps by logging in everyday, completing orders on time, generating affiliate sales or by posting comments on forum threads. Bump your services regularly every day around the time when you think most of your likely buyers will be online. This is usually in the late afternoon between 5-7 as most people get home around that time, have their dinner and then come onto SEOClerks to buy some SEO service for whatever reason. Of course, there is also the paid feature option where you can pay a small fee to have your service highlighted in the lists or even category featured so that it's highlighted in the category that the service is in. That is one way to get an advantage over other similar services because people are much more likely to buy it if it's been featured/highlighted but again, that all depends on the quality of the gig description etc. I hope that you will consider these tips and they provide to be useful to you!
Are you sure you want to delete this post?