Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


These support forums are now closed for new topics and comments.
Please head on over to http://eureka.ucommerce.net/ for support.

  • Paul A 133 posts 368 karma points
    May 14, 2014 @ 00:07
    Paul A
    0

    Orders stuck in "New Order"... End up in Requires Attention

    Hi

    Putting orders through to SagePay, deferred payments. That part works fine. Checkout.config is running (well, the final command is send-email which is working). But, order remains in New Orders, even after completing payment on SagePay. 

    If I manually try to manually change New Order -> Completed order in uCommerce I get: 

    Completed order  New order => Completed order.
    Completed order 4059 : Cannot authorise this transaction.

    The log says: The purchase order with order number '<ordernumber>' could not be found.

    Thanks for any help! Please help! 

  • Paul A 133 posts 368 karma points
    May 14, 2014 @ 00:51
    Paul A
    0
  • Paul A 133 posts 368 karma points
    May 16, 2014 @ 00:43
    Paul A
    0

    I'm also getting (when trying to change New Order -> Completed): 

    4028 : The related transaction cannot be found.

    Anyone?

  • Paul A 133 posts 368 karma points
    May 18, 2014 @ 12:39
    Paul A
    0

    SagePay say:

    The error is returned when the related VPS TX ID you have provided Sage Pay does not match the VPS TX ID of the original transaction. 
    Is this a uCommerce bug? 
  • Tim 168 posts 372 karma points
    May 18, 2014 @ 17:22
    Tim
    0

    That error sounds very much like it's coming from SagePay itself. It sounds daft but is it possible that you're taking the payment twice i.e. setting the payment method without setting "requestPayment" to false and then having it try and process it again during checkout?

    Also, have you turned on debugging mode? If you have what's in the logs?

    You can also check the transaction's VPS TX ID by looking at the payment provider reference within the payments table IIRC.

  • Paul A 133 posts 368 karma points
    May 18, 2014 @ 18:29
    Paul A
    0

    Hi, 

    Thanks for reply.

    Yes, that's a SagePay err (been on phone to them a few times too). 

    I checked uCommerce_Payment table, and can see data for SecurityKey, VPSTxId and TxAuthNo (for an order I created today... I tried to complete in uCommerce and it bounced New -> Requires Attention with message above). 

    You first para made me go check the process... I've edited so as to skip the Shipping Method step. It's a course booking website so no Shipping. I lifted the code from Shipping.cshtml to Address.cshtml (I used all the Avenue files and changed little else)

    TransactionLibrary.CreateShipment(8, overwriteExisting: true);
    TransactionLibrary.ExecuteBasketPipeline();
    HttpContext.Current.Response.Redirect("Payment.aspx");

    Is that OK to do?

     

  • Paul A 133 posts 368 karma points
    May 18, 2014 @ 19:58
    Paul A
    0

    Been on phone to Sage Pay again The VPSTxId in the DB on the order I'm trying to complete matches what they have. Fails with "4028 : The related transaction cannot be found.". They keep asking me to check format the data is being sent, which I obviously don't have access too. Any ideas?

  • Tim 168 posts 372 karma points
    May 18, 2014 @ 20:15
    Tim
    0

    It sounds like an error in uCommerce then, what version are you running? I'll take a peak at their logic around that bit.

  • Paul A 133 posts 368 karma points
    May 18, 2014 @ 20:37
    Paul A
    0

    Hi, 

    Umbraco 6.1.6

    In Package, 2 uCommerce versions are listed. 5.2.3.14050 and 5.3.0.14057. And in case it matters Avenue 3.0.1.14013 was installed.

     

     

  • Søren Spelling Lund 1797 posts 2786 karma points
    May 21, 2014 @ 09:59
    Søren Spelling Lund
    0

    Hi Paul,

    What does your SagePay.config look like (remember not to include password and merchant ids :)).

  • Paul A 133 posts 368 karma points
    May 21, 2014 @ 10:36
    Paul A
    0
    <?xml version="1.0"?>
    <sagePayPaymentMethodService
        vendor="xxxx"
        txType="DEFERRED"
        debug="true"
        testMode="LIVE"
        successUrl="_____/success.aspx"
        abortUrl="_____/abort.aspx"
    failureUrl="_____/payment-fail-decline.aspx"
    notificationURL="(auto)" />
  • Paul A 133 posts 368 karma points
    May 31, 2014 @ 00:43
    Paul A
    100

    Problem was eventually solved by updating uCommerce v6 from v5.3.

  • Paul A 133 posts 368 karma points
    Jun 01, 2014 @ 01:48
    Paul A
    0

    Update: that didn't really fix anything. payments get moved to 'completed' but payment is not taken from bank. 

Please Sign in or register to post replies

Write your reply to:

Draft