No Orders Since One Months Plz Help Me Through This !

HawlettServices Level 1

November 5, 2019, 9:08 am

Write the reason you're deleting this FAQ

No Orders Since One Months Plz Help Me Through This !

Its Been Quite One Month , Hence I Didn't Received An Order , Lowering My Price Didn't Work . Plz Help me . Thank You .

Comments

Please login or sign up to leave a comment

Join

TommyCarey

Hey there,

Looking at your reviews it seems you've had at least 3 sales in the last month, which isn't bad for how many services you have and your level

No Orders Since One Months Plz Help Me Through This !

I see you're offering SEO and Backlink related services, which can be spun in 1,000+ different ways, so if I were you I would break down your services even more so people are more likely to stumble upon them.

You can sell individual links with DA 20+ or even higher than that for $1 to $XXX depending on how high the DA goes. If you're using software to find all of these backlink locations, you can sell that as a service and help people find competitors' links so they can duplicate that process. You can also sell your competitors backlinks as a service and build all of them (or as many as possible) so you can help your customer outrank their competitors using the same tactics they are already using to rank

If you know how to do all of this, you likely know how to set up a WordPress site, and that means you can start building PBNs for people at a cheap price. You can use various web 2.0 platforms and build PBNs then include Wordpress sites as well as other free blogging platforms into the rotation.

Start promoting an affiliate link aimed at your own services so you can kill two birds with one stone. You can promote your affiliate link, get some sales, and get some referrals all at the same time. If you were to promote your service URL, without the affiliate code in it, you might lose sales and send them to other freelancers here. If you were to swap that out with your affiliate URL you would make at least 10% from every order you refer to this platform

Not many people like clicking on affiliate URLs, but there's a trick to do this with social media that will get them to click lol

You can simply set up a 301 redirect from one of your unused websites, aim it at your affiliate link, and that will place the cookie on the persons computer so you get credit for the sale if they make a purchase. This helps because when you post on something like Facebook, Twitter, or any other platform you will post a link to your own website and the people who click on it will get redirected lol

This will make sure the person doesn't get turned off by your affiliate link and type the domain name right into their browser to avoid cookie placement and you not getting credit for the referral. If they type your domain right into the address bar, they will get redirected, and they can't avoid you muahahaha

Hey there, Looking at your reviews it seems you've had at least 3 sales in the last month, which isn't bad for how many services you have and your level :) I see you're offering SEO and Backlink related services, which can be spun in 1,000+ different ways, so if I were you I would break down your services even more so people are more likely to stumble upon them. You can sell individual links with DA 20+ or even higher than that for $1 to $XXX depending on how high the DA goes. If you're using software to find all of these backlink locations, you can sell that as a service and help people find competitors' links so they can duplicate that process. You can also sell your competitors backlinks as a service and build all of them (or as many as possible) so you can help your customer outrank their competitors using the same tactics they are already using to rank :D If you know how to do all of this, you likely know how to set up a WordPress site, and that means you can start building PBNs for people at a cheap price. You can use various web 2.0 platforms and build PBNs then include Wordpress sites as well as other free blogging platforms into the rotation. Start promoting an affiliate link aimed at your own services so you can kill two birds with one stone. You can promote your affiliate link, get some sales, and get some referrals all at the same time. If you were to promote your service URL, without the affiliate code in it, you might lose sales and send them to other freelancers here. If you were to swap that out with your affiliate URL you would make at least 10% from every order you refer to this platform :) Not many people like clicking on affiliate URLs, but there's a trick to do this with social media that will get them to click lol :D You can simply set up a 301 redirect from one of your unused websites, aim it at your affiliate link, and that will place the cookie on the persons computer so you get credit for the sale if they make a purchase. This helps because when you post on something like Facebook, Twitter, or any other platform you will post a link to your own website and the people who click on it will get redirected lol :D This will make sure the person doesn't get turned off by your affiliate link and type the domain name right into their browser to avoid cookie placement and you not getting credit for the referral. If they type your domain right into the address bar, they will get redirected, and they can't avoid you muahahaha :D

6 years ago

Are you sure you want to delete this post?

Avg Time	Count	SQL	Max	Min
0.411956	1	SELECT 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 (93) AND gtags like'%3dbox%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 40	0.411956	0.411956

SEOClerks

No Orders Since One Months Plz Help Me Through This !

No Orders Since One Months Plz Help Me Through This !

Comments

Please login or sign up to leave a comment

TommyCarey

Invalid SQL

Expensive SQL

Suspicious SQL

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='29413'	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='29413'	/opt/clerks-staging/docroot/viewfaq.php 496 () ()
SELECT * FROM seoclerks.members WHERE USERID='805545'	1	SELECT * FROM seoclerks.members WHERE USERID='805545'	/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=805545	1	SELECT googleplus_profile FROM seoclerks.members WHERE USERID=805545	/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=29413 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=29413 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='29413' 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='29413' 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=188844 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=188844 LIMIT 5	/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()
UPDATE questions SET total_views = total_views + 1 WHERE quesid='29413'	1	UPDATE questions SET total_views = total_views + 1 WHERE quesid='29413'	/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()
SELECT * FROM questions WHERE quesid!='29413' AND status='1' AND (question like '%No Orders Months Plz !%' OR question like '%Orders%' OR question like '%Months%') -- ORDER BY RAND() LIMIT 15	1	SELECT quesid, question, seo, userid FROM questions WHERE quesid!='29413' AND status='1' AND (question like '%No Orders Months Plz !%' OR question like '%Orders%' OR question like '%Months%') -- ORDER BY RAND() LIMIT 15	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM seoclerks.members WHERE USERID='12006' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='12006' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='2513' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='2513' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='2255' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='2255' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='8325' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='8325' limit 1	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture()
SELECT * FROM seoclerks.members WHERE USERID='1303' limit 1	1	SELECT profilepicture FROM seoclerks.members WHERE USERID='1303' 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=29413%' 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=29413%' 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 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()