SEOClerks

How to get First order.



Write the reason you're deleting this FAQ

How to get First order.

Hello Friends

**I am SUNIT SHARMA from India. I am a freelancer and happy to join the SEOCLERK.COM. I would good to hear new suggestion to improve my GET Order skill. **

Comments

Please login or sign up to leave a comment

Join
godoflinks
Bump your offers, make sure your offers are competitive to others. Make sure they are professionally written.

Try and differentiate yourself from others. For example there are a ton of guest posting services offered out there. I've created a valuable offer proposition for mine which stands out against other $2, $10 cheap and cheerful offers.

It is not easy but good luck with it!!



Are you sure you want to delete this post?

TommyCarey
Hello friend How to get First order.

First off, you'll need to add some services if you really want to make some money here.

How to get First order.


When you start to add your services you will want to make sure they are competitively priced in the beginning so people will test out your services. Not many people want to purchase from a level 1 seller because they are untested, so encourage people to buy, and the easiest way to do that is a low price point. You can always raise your pricing later on after you've gotten some positive reviews, but keep it low in the beginning so people aren't afraid to test the service How to get First order. This is what I did and I now have customers contact me directly if my services aren't available lol. You can build up a good amount of recurring income if you start this way like most of us did, and it's one of the easiest ways to bring in your initial sales and reviews, which is why I always suggest it How to get First order.

When you're setting up your services you will need to format them just right. Use Bold titles, underline key points, use bullet points, etc. If you can make your service look great and keep people reading, they will stick around and likely purchase from you. You don't want to have a wall of text because it will become overwhelming when someone just wants to get snippets of information.

A little trick I like to do, when I have multiple services, is add links each of them within the descriptions of the services.

Example:
Service A
- Link to service B
- Link to service C

Service B
- Link to service A
- Link to service C

Service C
- Link to service A
- Link to service B

I will put these links at the end of the descriptions so people don't see them as intrusive and annoying. The links will be preceded by something like "Here are some more of my services" so people know I offer something else How to get First order.


After all that is done, you might want to try out a homepage feature or category feature. The homepage feature is pretty expensive for people just starting out so I would suggest trying a category feature. With the category feature you can put your service at the top of the category you're listed in and it won't move for 31 days. Normally, a service will move around within the category to give everyone a fighting chance at gaining sales naturally, but if you have a featured spot your service will be stuck at the top and get all of the views for a 31 day period.

I've used a category feature plenty of times and have gotten plenty of sales because of it. I still have recurring orders from the first time I placed my service at the top of the category for 31 days using this paid promotion method.


If I were you:
- Set up a few services
- Make sure the services look pretty and are formatted just right
- Add some custom images to my services
- Link my services together within each of their descriptions
- Use a category feature for a service I think will sell the best
- Use a homepage feature after I've made enough money from the category feature


The homepage feature is tough to get because they are so limited, which is why I always suggest people try out the category featured option first then try to get on the homepage.


I hope that helps you out How to get First order.

- Tommy



Are you sure you want to delete this post?

Order Now
Process Time: 1.0657570362091

Possible Duplicate queries found!
MatchCountSQLScript
SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-864001SELECT 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='29046'1SELECT 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='29046'

/opt/clerks-staging/docroot/viewfaq.php 496 () ()

SELECT * FROM seoclerks.members WHERE USERID='849384'1SELECT * FROM seoclerks.members WHERE USERID='849384'

/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()

SELECT * FROM categories_faq WHERE CATID='42'1SELECT 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=8493841SELECT googleplus_profile FROM seoclerks.members WHERE USERID=849384

/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=29046 LIMIT 51SELECT m.username FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=29046 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='29046' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc1SELECT 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='29046' 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=188153 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=188153 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=188155 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=188155 LIMIT 5

/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

UPDATE questions SET total_views = total_views + 1 WHERE quesid='29046'1UPDATE questions SET total_views = total_views + 1 WHERE quesid='29046'

/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()

SELECT * FROM questions WHERE quesid!='29046' AND status='1' AND (question like '%How order.%' OR question like '%order.%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='29046' AND status='1' AND (question like '%How order.%' OR question like '%order.%') -- ORDER BY RAND() LIMIT 15

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

SELECT * FROM seoclerks.members WHERE USERID='313498' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='313498' limit 1

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

SELECT * FROM seoclerks.members WHERE USERID='1014917' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='1014917' limit 1

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

SELECT * FROM seoclerks.members WHERE USERID='584630' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='584630' limit 1

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

SELECT * FROM seoclerks.members WHERE USERID='578932' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='578932' limit 1

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()

SELECT * FROM seoclerks.members WHERE USERID='801473' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='801473' 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=29046%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID 1SELECT USERID, username FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=29046%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()

SELECT * FROM categories1SELECT * FROM categories

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

select * from categories_software order by name asc1select * 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 asc1select * 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 asc1select * 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='789668.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='789668.png'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='19821.png'1SELECT 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 asc1select * from categories_faq order by name asc

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories()

Invalid SQL

count(*)sql1error_msg

Expensive SQL

Tuning the following SQL could reduce the server load substantially
LoadCountSQLMaxMin

Suspicious SQL

The following SQL have high average execution times
Avg TimeCountSQLMaxMin
0.5005401SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (72) AND gtags like'%Highpr%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.5005400.500540
0.3974021SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (83) AND gtags like'%Voiceoverforscri%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.3974020.397402
0.2269691SELECT 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 (101) AND gtags like'%SMM%' AND type !=99 0.2269690.226969
0.1602071SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND (A.tags LIKE '%Wellspoken%' OR A.skills LIKE '%Wellspoken%') ORDER BY A.lastgigedit desc LIMIT 0,400.1602070.160207
0.1214191SELECT 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 AND (A.tags LIKE '%Wellspoken%' OR A.skills LIKE '%Wellspoken%')0.1214190.121419