SEOClerks

Clear
Sign In Join

Is it possible to limit the number of orders?

  • nerv Level 5
    • 7

    Write the reason you're deleting this FAQ

    Is it possible to limit the number of orders?

    I would like to know if it is possible to limit the number of orders that can be made on specific service?

    If I will create a service that takes few days to complete and in the meantime I will get more orders from different buyers sometimes I won't be able to handle all these orders at the same time and that will cause late delivery.

    That is why I would like to know if I can for example set maximum of 10 active orders per service so when 10 orders are in progress order button would be disabled.

    I know that it can be done manually by using "suspend service" option but is there any different way for doing that?

    # SEOClerks
    Share post:

    Comments

    Please login or sign up to leave a comment

    Join
    Beverly

    Beverly

    At one time, they were discussing the idea of a 'limited quantity' type feature, but I have not heard anything about it since. It might be useful to have this as an option on a service so that you could specify how many of that gig you would be willing to sell at any one time. It would keep a seller from accepting more work than they are capable of doing.
    11 years ago

    Are you sure you want to delete this post?

    nerv

    nerv

    Exactly, that would be a really useful option. Is there any place where I can suggest this feature?
    11 years ago

    Are you sure you want to delete this post?

    farahkhan

    farahkhan

    I would like to know if it is possible to limit the number of orders that can be made on specific service?

    If I will create a service that takes few days to complete and in the meantime I will get more orders from different buyers sometimes I won't be able to handle all these orders at the same time and that will cause late delivery.

    That is why I would like to know if I can for example set maximum of 10 active orders per service so when 10 orders are in progress order button would be disabled.

    I know that it can be done manually by using "suspend service" option but is there any different way for doing that?


    When you get sufficient orders you can just goto service edit page and mark your service as sold out it will still show up in search but no one will be able to order it when you select suspend service it wont show up in searching so marking out sold is a better option as many buyers might contact you in messages to provide that services and you can open slots manually for them on service Is it possible to limit the number of orders?

    Let me know if you need help with anything else .

    Regards
    Farah khan
    11 years ago

    Are you sure you want to delete this post?

    Tandy

    Tandy

    When you get sufficient orders you can just goto service edit page and mark your service as sold out it will still show up in search but no one will be able to order it when you select suspend service it wont show up in searching so marking out sold is a better option as many buyers might contact you in messages to provide that services and you can open slots manually for them on service Is it possible to limit the number of orders?

    Let me know if you need help with anything else .

    Regards
    Farah khan


    That's a really good idea actually, especially useful for a seller who is perpetually busy with customers. This would offer the option to do work on demand (so to speak), rather than always be at the mercy of a customer who might add one more sale to your work load that you might or might not be able to handle.

    I would suggest though, that you mention on your sales page that potential buyers can message you if they want you to do a job.
    11 years ago

    Are you sure you want to delete this post?

    Topseoservice

    Topseoservice

    Yes mentioning on your sales page will also help. For example you can limit 10 orders per day and when you got 6 orders during the day, you can update the sales page saying 4 units left. Something like this.
    11 years ago

    Are you sure you want to delete this post?

    nerv

    nerv

    When you get sufficient orders you can just goto service edit page and mark your service as sold out it will still show up in search but no one will be able to order it when you select suspend service it wont show up in searching so marking out sold is a better option as many buyers might contact you in messages to provide that services and you can open slots manually for them on service Is it possible to limit the number of orders?

    Let me know if you need help with anything else .

    Regards
    Farah khan


    Unfortunately that will not work when someone will decide to order many times in short period of time.
    11 years ago

    Are you sure you want to delete this post?

    chetaseo

    chetaseo

    but why do you really want to limit orders when you are suppose to even be happy that you are getting plenty of them because this seoclerk is a very competitive site but anyway i think farahkhan solution is the best to me. follow her.
    11 years ago

    Are you sure you want to delete this post?

    Order Now
    Process Time: 0.58923578262329

    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='11726'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='11726'

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID=40331SELECT googleplus_profile FROM seoclerks.members WHERE USERID=4033

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

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

    SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='11726' 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='11726' 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=53435 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=53435 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=53436 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=53436 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=53437 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=53437 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=53438 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=53438 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=53439 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=53439 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=53440 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=53440 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=53441 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=53441 LIMIT 5

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

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

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

    SELECT * FROM questions WHERE quesid!='11726' AND status='1' AND (question like '%Is limit number orders?%' OR question like '%limit%' OR question like '%number%' OR question like '%orders?%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='11726' AND status='1' AND (question like '%Is limit number orders?%' OR question like '%limit%' OR question like '%number%' OR question like '%orders?%') -- ORDER BY RAND() LIMIT 15

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

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

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

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

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

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID='3968' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='3968' 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=11726%' 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=11726%' 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='147.jpg'1SELECT 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='4033.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='4033.jpg'

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

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

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

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

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

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

    		/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.1798781SELECT 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 0.1798780.179878
    0.0995851SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Tattooin%') ORDER BY total_recommendations desc LIMIT 0,400.0995850.099585