Write the reason you're deleting this FAQ
Hi! This tutorial is going to be on what coupons are and how to use them. This applies to both sellers and buyers, so be sure to read my instructions carefully so as not to get confused. Coupons are used for giving your buyers a discount, if you're a seller, and getting a discount on service, if you're a buyer. Coupons are a great new addition to SEOClerks because now people can offer discounts to specific people or users who are maybe a little bit skeptical about your service. It's also great if you're buyer doesn't have enough funds to buy your service. The text and video tutorials are posted below.
Text + Pictures









Are you sure you want to delete this post?
Are you sure you want to delete this post?
Below, is a Screenshot on How to Redeem "Store Credit" Coupons (for us Users who give out $5 Coupons - this helps New Users Find where to Enter their Code:
[U]CLICK ON SCREENSHOT BELOW for FULL SIZE[/U]:
[url=https://www.seoclerks.com/files/user/images/Coupon-Redeem2.png][url=https://www.seoclerks.com/files/user/images/Coupon-Redeem2.png][IMG]https://www.seoclerks.com/files/user/images/Coupon-Redeem2.png[/IMG][/url][/URL]
Are you sure you want to delete this post?
[U][B]How to EMBED your Coupon that you created for your Service into a SINGLE URL:[/B][/U]
Let's Say your Service URL was:
[U][url]https://www.seoclerks.com/Traffic/7579/Guarantee-Targeted-Ad-Clicks-for-0-03-CPC-or-Less-on-Real-Human-Traffic-4-LIFE[/url][/U]
And you created a 20% Coupon Code for the above Service called: "[I]TwentyOFF[/I]"
The SINGLE URL BELOW would AUTOMATICALLY APPLY the 20% Discount to your Gig WITHOUT having to give out your Coupon Code or Display it Publicly:
[url]https://www.seoclerks.com/order?id=7579&coupon=[/url][I]TwentyOFF
[/I]
Simply Take the Unique Service ID which is Found AFTER the "Category" in the Service URL:
[B][COLOR=#ff0000]7579[/COLOR][/B]/Guarantee-Targeted-Ad-Clicks-for-0-03-CPC-or-Less-on-Real-Human-Traffic-4-LIFE
and Put the Coupon Code [I][COLOR=#ff0000]TwentyOFF[/COLOR] [/I]at the End:
[url]https://www.seoclerks.com/order?id=[/url][COLOR=#ff0000]7579[/COLOR]&coupon=[I][COLOR=#ff0000]TwentyOFF[/COLOR][/I]
[COLOR=#404040]You can even embed your Affiliate ID:
[url]https://www.seoclerks.com/[/url][/COLOR][COLOR=#ff0000]linkin/3764[/COLOR][COLOR=#404040]/order?id=[/COLOR][COLOR=#ff0000]7579[/COLOR][COLOR=#404040]&coupon=[/COLOR][COLOR=#ff0000][I]TwentyOFF[/I][/COLOR]
I use it on Gigs such as [U][B][url=https://www.seoclerks.com/Traffic/7579/Guarantee-Targeted-Ad-Clicks-for-0-03-CPC-or-Less-on-Real-Human-Traffic-4-LIFE]THIS GIG HERE[/URL][/B]
[B]You'll see this Button: [/B]
[url=http://goo.gl/mV4Ng6][url=https://www.seoclerks.com/files/user/images/_40-OFF-NEW-Theme_button.png][IMG]https://www.seoclerks.com/files/user/images/_40-OFF-NEW-Theme_button.png[/IMG][/url][/URL]
[/U]
Where I give Users Access to my Coupon URL after they have Shared or Tweeted about my Gig
Hope this helps,
[url=http://communityclerks.com/wp-content/uploads/2013/09/eXjordanary-600_LQ.png][IMG]http://communityclerks.com/wp-content/uploads/2013/09/eXjordanary-600_LQ.png[/IMG][/url]
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='12072' | 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='12072' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='4022' | 1 | SELECT * FROM seoclerks.members WHERE USERID='4022' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=4022 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=4022 | /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=12072 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=12072
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='12072' 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='12072' 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=55719 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=55719
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=55720 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=55720
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=55721 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=55721
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=55722 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=55722
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=55723 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=55723
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=55724 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=55724
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=55725 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=55725
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=142472 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=142472
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='12072' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='12072' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='12072' AND status='1' AND (question like '%Tutorial: Coupons (Text Video)%' OR question like '%Tutorial:%' OR question like '%Coupons%' OR question like '%(Text%' OR question like '%Video)%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='12072' AND status='1'
AND (question like '%Tutorial: Coupons (Text Video)%' OR question like '%Tutorial:%' OR question like '%Coupons%' OR question like '%(Text%' OR question like '%Video)%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='16780' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='16780' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='288525' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='288525' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='2459' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2459' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='112607' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='112607' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='25812' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='25812' 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=12072%' 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=12072%'
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='632.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='632.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='8709.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='8709.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='3764.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3764.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='604194.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='604194.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.098728 | 1 | SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Search-engine%') ORDER BY total_recommendations desc LIMIT 0,40 | 0.098728 | 0.098728 |
ralph101
Are you sure you want to delete this post?