SEOClerks

Clear
Sign In Join

Why custom order is not showing in my sales page?

  • bloggersjoy Level 1
    • 13

    Write the reason you're deleting this FAQ

    Why custom order is not showing in my sales page?

    Hello Everyone,

    Someone placed a custom order offer for me to make a 3D animated video. I have accepted the offer but the problem is that this order is neither showing on my sales page, nor the payment of this order is showing on my upcoming payments. Additionally there is no deliver button or complete order button for this order on the custom order page. Please help how to deliver this order and is the payment safe for this order.

    Thank You

    #SEOClerk #CustomOr SEOClerks
    Share post:

    Comments

    Please login or sign up to leave a comment

    Join
    Beverly

    Beverly

    Hi BloggersJoy,

    I checked into this issue. The buyer has created the custom offer but not paid.

    This message is still showing via the buyer's page.

    Why custom order is not showing in my sales page?

    Please ask the buyer to click the 'pay for your order' button which will create the order. No order will be created until buyer pays. You will see the 'order number' listed on the custom order once paid, which will link to the order page.

    If you have additional questions or need help with anything else, please contact our 24/7 support desk at: https://ionicware.zendesk.com/
    6 years ago

    Are you sure you want to delete this post?

    bloggersjoy

    bloggersjoy

    In case, if the buyer refuses to pay before I send the video then I will also not send his video if there is no payment guarantee so will the buyer be able to write any review in such a situation. Please suggest.
    6 years ago

    Are you sure you want to delete this post?

    Beverly

    Beverly

    The buyer will not have the option to leave a rating until order is completed. Though first, buyer would need to pay for and start the order. I have rechecked on this issue and no order has been created, such as 'pay for your order' is still showing. My suggestion would be to not send the video to buyer until you have a confirmed order page created, otherwise there is no guarantee of being paid.

    When the buyer pays, the 'custom order' (private message) page will update to show this message:

    The buyer has purchased the following service.

    View the orders here: (order #)

    You will see the order number and can click to visit the order page and deliver the video or product that buyer has paid for.
    6 years ago

    Are you sure you want to delete this post?

    bloggersjoy

    bloggersjoy

    Thanks Sir, Although I have worked on his video but I will not send him any files till he does not confirm the order.
    6 years ago

    Are you sure you want to delete this post?

    BoostReputation

    BoostReputation

    They must not paid for the order yet.
    6 years ago

    Are you sure you want to delete this post?

    BoostReputation

    BoostReputation

    Also do not start work till the time you see a payment, It is kind of illusion where we take agreement as payment.
    6 years ago

    Are you sure you want to delete this post?

    bloggersjoy

    bloggersjoy

    Thanks I am following your advice.
    6 years ago

    Are you sure you want to delete this post?

    elfuegoDigitals

    elfuegoDigitals

    Helo, It is i who requested a job from blogersjoy, i have been offline due to network issues in this part of the world. this is the my first time of requesting a job on SEO clerk, please do i have total control of my funds after paying but i am not satisfied with the job i got
    6 years ago

    Are you sure you want to delete this post?

    bloggersjoy

    bloggersjoy

    If the buyer is not satisfied due to any reasons, even if the reasons are his own personal, I return 50% of the project amount but I do not work for that buyer in future. I return only 50% because this is mostly done by freelancers who take job from others at reduced price and then show as if they are not satisfed and want to take money back.
    6 years ago

    Are you sure you want to delete this post?

    Beverly

    Beverly

    Hi elfuegoDigitals, you will have five days to fully review any delivery made by the seller. If you are dissatisfied, you can reject the delivery. We encourage buyer and seller to work through any issues, as per our Terms of Service. However, if no remedy is available, you may ask for a cancellation from within your order page. You may also contact our 24/7 support desk for help with any problem order.
    6 years ago

    Are you sure you want to delete this post?

    Order Now
    Process Time: 0.29214906692505

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

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID=395011SELECT googleplus_profile FROM seoclerks.members WHERE USERID=39501

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

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

    SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='29657' 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='29657' 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=189229 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=189229 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=189231 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=189231 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=189237 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=189237 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=189247 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=189247 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=189238 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=189238 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=189239 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=189239 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=189246 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=189246 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=189253 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=189253 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=189254 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=189254 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=189286 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=189286 LIMIT 5

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

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

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

    SELECT * FROM questions WHERE quesid!='29657' AND status='1' AND (question like '%Why custom order showing sales page?%' OR question like '%custom%' OR question like '%order%' OR question like '%showing%' OR question like '%sales%' OR question like '%page?%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='29657' AND status='1' AND (question like '%Why custom order showing sales page?%' OR question like '%custom%' OR question like '%order%' OR question like '%showing%' OR question like '%sales%' OR question like '%page?%') -- ORDER BY RAND() LIMIT 15

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

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

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

    SELECT * FROM seoclerks.members WHERE USERID='3545' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='3545' 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 11SELECT 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 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='3084' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='3084' 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=29657%' 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=29657%' 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='39501.jpg'1SELECT profilepicture FROM seoclerks.members WHERE USERID='39501.jpg'

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

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