SEOClerks

Clear
Sign In Join

How to Keep Orders Under Control

  • seocsl Level 1
    • 8

    Write the reason you're deleting this FAQ

    How to Keep Orders Under Control

    This may be something that a lot of existing sellers with good traffic already know, but this one may help out some of the newer sellers here.

    1. Don’t Set a default delivery date too close for comfort, 24 Hours for example. (You possibly only do this to catch the eye of some ‘right now’ buyers.) This may backfire like a blocked toilet and cover you in… you get the idea.
    No one wants to have 10 orders due in 5 minutes, where each one takes at least an hour to do. You will end up with sloppy deliveries and dozens of buyers wanting their money back due to either awful quality, or late submissions. Additionally, this may slap you with reviews that look like mouse droppings.

    2. If you work with a team, assign the tasks as soon as the orders come in (We do this). Each employee should have a deadline earlier than the actual order deadline, to provide ample time to cross check and ensure everything’s top notch in case any issues arise.
    If you work alone, communicate with the buyer and let them know as soon as the order is placed, that you might need at least an extra day based on your current workload (This is if they order before sending a message.). Some will respect this, others may want to cancel. Don’t be afraid to cancel if they can’t wait, you’re setting a 1 star review trap for yourself here.

    3. For those who have some heavy traffic days (For some this is Sunday/Monday) – Put in the extra work from Friday/Saturday to clear up as much orders as possible. Don’t “know what to expect” and do nothing about it. Don’t alter your delivery dates in your gig after the buyer places an order. This is deceitful, and some may pick up on this and report you faster than you can say “But…”.

    4. This one goes for both teams and individual sellers. If you notice a day/week of heavy traffic, don’t be afraid to use the vacation button. This will stop buyers from hitting “Order Now”, and buy you some room to complete your pending orders. You may lose a few new orders, and some loyal buyers will hit “Notify”. Don’t worry about the ones you lose. It’s not the end of the world. On seoclerk , your reputation is worth more than a few orders. Without the reputation, those few may be the last you ever get.

    So, with that said… Don’t be a Hero and try to play a “wanna-be Super Seller.” Know your limits, and be keen on your gigs, orders and deadlines.

    A great seller is honest not just with their customers; they’re also honest with themselves.

    DON,

    # Marketing & Monetization
    Share post:

    Comments

    Please login or sign up to leave a comment

    Join
    hotcontent

    hotcontent

    wow i really impressed and i think you have huge experience to handle the buyers nice post.
    10 years ago

    Are you sure you want to delete this post?

    aloksof

    aloksof

    good information and very pin pointed.
    10 years ago

    Are you sure you want to delete this post?

    seocsl

    seocsl

    tnx
    10 years ago

    Are you sure you want to delete this post?

    sanfora

    sanfora

    yeah but 24 hrs express delivery help cause alot of buyer look for fast delivery
    10 years ago

    Are you sure you want to delete this post?

    seoguru24x7

    seoguru24x7

    Great share.
    10 years ago

    Are you sure you want to delete this post?

    seocsl

    seocsl

    tnx
    10 years ago

    Are you sure you want to delete this post?

    procoder

    procoder

    Great info!
    10 years ago

    Are you sure you want to delete this post?

    Order Now
    Process Time: 0.068826913833618

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID=4451871SELECT googleplus_profile FROM seoclerks.members WHERE USERID=445187

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

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

    SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='14246' 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='14246' 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=73615 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=73615 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=73616 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=73616 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=73617 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=73617 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=73618 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=73618 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=73619 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=73619 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=73620 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=73620 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=73621 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=73621 LIMIT 5

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

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID='12006' limit 11SELECT 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='28163' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='28163' 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 11SELECT 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='14567' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='14567' limit 1

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

    SELECT * FROM seoclerks.members WHERE USERID='2077' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='2077' 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=14246%' 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=14246%' 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='104322.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='104322.png'

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

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

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

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

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

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID='377074.png'1SELECT profilepicture FROM seoclerks.members WHERE USERID='377074.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.1016801SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%socialbacklinkin%') ORDER BY total_recommendations desc LIMIT 0,400.1016800.101680
    0.0924941SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Hotelscombined%') ORDER BY total_recommendations desc LIMIT 0,400.0924940.092494
    0.0684941SELECT count(USERID) AS total FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Hotelscombined%') 0.0684940.068494
    0.0620161SELECT count(USERID) AS total FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%socialbacklinkin%') 0.0620160.062016