SEOClerks

Clear
Sign In Join

Small changes in Order Links

  • ionicware Level X5
    • 16

    Write the reason you're deleting this FAQ

    Small changes in Order Links

    Previously, when linked to the order URL a user that was not logged would be redirected to the homepage. This is bad for sales and especially bad for any website that links directly to their service order URLs. Now the unlogged user is forwarded to the login page, which allows the user to click through to registration. Once registration or login is completed, the user is then returned to your order URL.

    When clicking Order from your service page, the same flow occurs. Previously, clicking order from your service page when not logged in would return the user to your service page, not to the order URL.

    Finally, you can now add your affiliate link directly to the order URL as per the standard format /linkin/xxx/ - https://www.seoclerks.com/linkin/1/order?id=468

    # Announcements
    Share post:

    Comments

    Please login or sign up to leave a comment

    Join
    SeoExpertts

    SeoExpertts

    Great improvement, thank you.
    13 years ago

    Are you sure you want to delete this post?

    Recommendables

    Recommendables

    oh i didnot knew that we could directly promote order page ... i just use to promote the gig page thats it ... well now i think a deep linking would enable a better promotion Small changes in Order Links
    13 years ago

    Are you sure you want to delete this post?

    mike719

    mike719

    Great! This always drove me nuts!! Thank you :-)
    13 years ago

    Are you sure you want to delete this post?

    ITKING

    ITKING

    nice move. Thanks
    13 years ago

    Are you sure you want to delete this post?

    cyberxcrime

    cyberxcrime

    Great..... Small changes in Order Links
    13 years ago

    Are you sure you want to delete this post?

    smartservices76

    smartservices76

    greatSmall changes in Order Links
    13 years ago

    Are you sure you want to delete this post?

    Tommy Matalino

    Tommy Matalino

    Cool Jordan. Is there a way we could make any link our affiliate link without manually adding "?id=xxx"?
    13 years ago

    Are you sure you want to delete this post?

    Sean101

    Sean101

    Nice Small changes in Order Links
    Thanks for sorting this out Jordan. Small changes in Order Links
    13 years ago

    Are you sure you want to delete this post?

    robin

    robin

    Supper*Supper*Supper*Supper*Supper*
    Thanks for sorting this out Jordan.
    13 years ago

    Are you sure you want to delete this post?

    consultingpro

    consultingpro

    Nice fix to generate sales and not frustration for buyer or for seller, to a competitor's gig.
    13 years ago

    Are you sure you want to delete this post?

    spotlightseo

    spotlightseo

    Thanks jordan
    13 years ago

    Are you sure you want to delete this post?

    Sunil

    Sunil

    Thats What all of us wanted ..
    This Order page redirection functions Benefits are ..

    1- Rate of registrations will be increase from affiliate links ...
    2- Chances of instant order at the time of click will also increase ...


    Suggestions ..

    Its my view i dont know you will like it or not ,Jordon Brother.

    1- Is that possible to add any highlighted link or button of main service page Likes/Collect for future .. this is because when some one come to order page and suppose he.she dont have time or money to purchase then they can collect this gig for future ...

    Think about it ......
    13 years ago

    Are you sure you want to delete this post?

    exjordanary

    exjordanary

    Thats What all of us wanted ..
    This Order page redirection functions Benefits are ..

    1- Rate of registrations will be increase from affiliate links ...
    2- Chances of instant order at the time of click will also increase ...


    Suggestions ..

    Its my view i dont know you will like it or not ,Jordon Brother.

    1- Is that possible to add any highlighted link or button of main service page Likes/Collect for future .. this is because when some one come to order page and suppose he.she dont have time or money to purchase then they can collect this gig for future ...

    Think about it ......



    Yeah, or better yet, how about if there's a Coupon Code for any particular Gig, perhaps instead of the User having to Enter it (or remember it), they can simply Do any Social Action (share, tweet, like, etc) to Redeem Gig's Coupon Code!!
    Then, it will automatically be entered for them too!!

    And maybe the Seller's Affiliate Link would be included in the Social Share the Buyer does to reveal Seller's Coupon - so the Seller can hope to get affiliates for giving the Discount!! Win-Win!!


    Be sure to Visit the Pages from the SEOClerks Blog by Clicking on each Image Below for FREE Promotion and Exposure for your Services:
    Small changes in Order LinksSmall changes in Order Links
    Small changes in Order LinksSmall changes in Order Links
    Small changes in Order LinksSmall changes in Order Links
    13 years ago

    Are you sure you want to delete this post?

    sspseoservices

    sspseoservices

    That is nice discover. It is really great idea. i think for this change seoclerks will grow their sales also.
    12 years ago

    Are you sure you want to delete this post?

    futuren

    futuren

    Great dicision!
    Thanks Small changes in Order Links
    12 years ago

    Are you sure you want to delete this post?

    Order Now
    Process Time: 1.7682099342346

    Possible Duplicate queries found!
    MatchCountSQLScript
    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='10472'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='10472'

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID=11SELECT googleplus_profile FROM seoclerks.members WHERE USERID=1

    		/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=10472 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=10472 LIMIT 5

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

    SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='10472' 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='10472' 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=45631 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=45631 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=45632 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=45632 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=45633 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=45633 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=45634 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=45634 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=45635 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=45635 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=45636 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=45636 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=45637 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=45637 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=45639 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=45639 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=45640 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=45640 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=45641 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=45641 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=45642 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=45642 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=45643 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=45643 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=45644 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=45644 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=45645 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=45645 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=45646 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=45646 LIMIT 5

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

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

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

    SELECT * FROM questions WHERE quesid!='10472' AND status='1' AND (question like '%Small Order Links%' OR question like '%Small%' OR question like '%Order%' OR question like '%Links%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='10472' AND status='1' AND (question like '%Small Order Links%' OR question like '%Small%' OR question like '%Order%' OR question like '%Links%') -- ORDER BY RAND() LIMIT 15

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

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID='632' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='632' 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=10472%' 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=10472%' 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='12260.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='12260.jpg'

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

    SELECT * FROM seoclerks.members WHERE USERID='10788.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='10788.jpg'

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

    SELECT * FROM seoclerks.members WHERE USERID='1490.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='1490.png'

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

    SELECT * FROM seoclerks.members WHERE USERID='9874.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='9874.jpg'

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

    SELECT * FROM seoclerks.members WHERE USERID='6777.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='6777.jpg'

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

    SELECT * FROM seoclerks.members WHERE USERID='43.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='43.jpg'

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

    SELECT * FROM seoclerks.members WHERE USERID='1856.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='1856.jpg'

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

    SELECT * FROM seoclerks.members WHERE USERID='18566.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='18566.jpg'

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

    SELECT * FROM seoclerks.members WHERE USERID='1364.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='1364.jpg'

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

    SELECT * FROM seoclerks.members WHERE USERID='3084.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='3084.png'

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

    SELECT * FROM seoclerks.members WHERE USERID='3764.png'1SELECT 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='23819.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='23819.jpg'

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

    SELECT * FROM seoclerks.members WHERE USERID='114873.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='114873.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.3937691SELECT 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 (82) AND gtags like'%Traffic%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.3937690.393769
    0.1109271SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%siteaudit%') ORDER BY total_recommendations desc LIMIT 0,400.1109270.110927