Integration of SOFORT.COM Payment doesn't work

  • Profile Image
    klasphilipp
    Asked on August 15, 2018 at 08:36 AM

    Dear all,

    I tried a lot of resolvement but nothing works. 

    We want to use SOFORT.COM for payment in our ford (ID: 82263535939365). We already integrated Config-Key and are ready to use within "SOFORT-System (productive)". But there is no chance to get back transaction information.

    SOFORT tells us, that there is no "success_url" provided in request and in project settings. Which one do we have to provide.

    Can you please help? This ist really urgent, because we want so start our project.

    Thanks a lot!

  • Profile Image
    ashwin_d
    Answered on August 15, 2018 at 10:36 AM

    I am sorry for the trouble cause to you. Have you followed all the steps mentioned in the following guide:  https://www.jotform.com/help/514-How-to-integrate-Sofort-with-your-form

    I did check your form but I do not see any Sofort payment tool added in your form #82263535939365. Please add the payment tool in your form to list your products or other options and only then the payment will be processed. 

    I would suggest you to please go through the guide which I have shared above and ensure that you have followed the steps in your Sofort account and also in your form as well.


  • Profile Image
    klasphilipp
    Answered on August 16, 2018 at 02:42 AM

    Hello Ashwin,

    thanks a lot for your help. I followed the instruction and tried it a few times with new forms and new SOFORT-projects and so on, but it didn‘t work.

    the problem seems to be, that Jotform doesn‘t get any payment response from SOFORT. 

    All submissions are registered as „payment incomplete“. This status doesn‘t change.

    SOFORT says, Jotform has to provide a URL, which has to be edited within SOFORT backend, that both - Form and payment are able to communicate.

    Is it possible for you to check any other integrations within your clientship to see what could be wrong at my form?

    yesterday I disabled payment option because we had to go live. I can enable a testform, if that helps. The payment doesn‘t work in any form...

    thanks for your help!

  • Profile Image
    ashwin_d
    Answered on August 16, 2018 at 04:16 AM

    Do you mean to say that the form is not redirected to Sofort or the submissions just ended up in incomplete payments?

    Since you have already contacted Sofort, can you also please confirm if the payment was successfully received in Sofort. I would also suggest you to please create a test form with Sofort payment tool and we will take a look.

    We will wait for your response.

  • Profile Image
    york
    Answered on August 16, 2018 at 04:49 AM

    Hi, we are able to run test transactions successfully. 

    I also updated this guide about test transactions: https://www.jotform.com/help/514-How-to-integrate-Sofort-with-your-form

    In addition, please send us a screenshot of your project details excluding the confidential information.

    Thank you.

  • Profile Image
    klasphilipp
    Answered on August 16, 2018 at 06:01 AM

    It ends up in incomplete payments. Payment in Sofort was partly received successfully, but only real bookings (3 pcs.).

    Please find some screenshots attached. hopefully you can provide help.. There is no answer from SOFORT until now. 

    Testform in testmode is: https://form.jotformeu.com/82271476184360

    Thank you!

    Screenshots: https://1drv.ms/f/s!Am2awWeeCLJXjyQJj9FWSckiseOL

  • Profile Image
    york
    Answered on August 16, 2018 at 06:56 AM

    Thank you for the screenshots.

    Firstly, a transaction will only be displayed outside of incomplete payments if the payment status is received as you see in the image.

    1534416330received payment.png

    In addition, Success URL is the URL that directs to the thank you page. It is provided to Sofort from Jotform's back-end once the end user clicks submit button and Sofort's payment page is opened. After the flow at Sofort's payment page is completed, the user is directed to the success URL provided therefore the thank you page is displayed to the user.

    1534415816Screen Shot 2018-08-16 at 13.2


    Here is an error displayed indicating no success url is provided in request, because the request is not sent from Jotform as I mentioned, it is sent by the Sofort's interface itself upon clicking the button in the image.

    I just noticed if there is an e-mail notification enabled for the project, Jotform is not notified by the payment status changed to "Payment Received", so I updated the user guide accordingly.

    Could you please create one more project by following the instructions in the user guide carefully and make a test transaction as indicated in the user guide?

    Thank you very much for your cooperation and we will be waiting for your response.

  • Profile Image
    klasphilipp
    Answered on August 16, 2018 at 10:19 AM

    Hi York,

    I spoke to SOFORTS Dev team. They looked at the backend API calls and told me, that API calls seem to be wrong here.

    See below (red):

    <?xml version="1.0" encoding="UTF-8"?>

    <multipay version="1.0">

      <su/>

      <currency_code>EUR</currency_code>

      <reasons>

        <reason>FoXXXX 82XXXXXXXXXXXX</reason>

        <reason>SuXXXXXXXXXX 41XXXXXXXXXXXXXXXXX</reason>

      </reasons>

      <success_url>https://submit.jotformeu.com/complete.php?sid=4102367332443967594</success_url>

      <success_link_redirect>1</success_link_redirect>

      <abort_url>https://submit.jotformeu.com/form/82271476184360</abort_url>

      <notification_urls>

        <notification_url notify_on="received">https://submit.jotformeu.com/ipns/sofort.php?formID=82271476184360&amp;submissionID=4102367332443967594&amp;paymentType=donation&amp;currency=EUR&amp;amount=&amp;configKey= 173232%3A456490%3A95b7d41de427d956fd3660976b555fe5</notification_url>

      </notification_urls>

      <amount>10</amount>

      <project_id>456490</project_id>

    </multipay>


    It has to be:

    <notification_url notify_on="pending">https://submit.jotformeu.com/ipns/sofort.php?formID=82271476184360&amp;submissionID=4102367332443967594&amp;paymentType=donation&amp;currency=EUR&amp;amount=&amp;configKey= 173232%3A456490%3A95b7d41de427d956fd3660976b555fe5</notification_url>

    because SOFORT has no view on our bank account. They only can see transactions on an bank account from "Deutsche Handelsbank". There it is correct, that notification_url notify_on is "received".

    Any other bank accounts are not monitored by SOFORT. They can't see, if money was transferred - they can only see, that money is in charge for the submission ID but can't change status to "received".

    Is it possible, that this is the case?

  • Profile Image
    klasphilipp
    Answered on August 16, 2018 at 10:25 AM

    P.S.: We just need to get an "order"/"positive submission" from our form after every transaction and users has to get a confirmation about their positive registration / submission.

    I also made a new TEST Project called "TEST SOFORT" at Jotform under https://form.jotformeu.com/82274514039355 and released a new test project unter "TEST Jotform" on SOFORT's side. Please check again...

  • Profile Image
    klasphilipp
    Answered on August 16, 2018 at 11:00 AM

    P.P.S.: I have to correct my comment above. Status which Jotform responses back to SOFORT should be as follows:notify_on="untraceable" because we don't have a traceable bank account.

    Here is a link to API documentation of SOFORT: https://www.sofort.com/integrationCenter-eng-DE/content/view/full/2513/#h5-5

    Please have a look at Table 5: Parameter definition of response to transaction data request



  • Profile Image
    Kevin_G
    Answered on August 16, 2018 at 12:34 PM

    Your comments will be passed to our developer, we  will keep you updated via this thread.

    Thanks.

  • Profile Image
    york
    Answered on August 16, 2018 at 01:20 PM

    Hi, thank you very much for providing us the necessary information.

    I applied the change to our back-end. From now on, our back-end will process transactions with status "untraceable" as well as "received".

    However, I am not able replicate untraceable transactions in the testing environment. So, could you please tell me if the issue is fixed right now?

    Thank you.

  • Profile Image
    klasphilipp
    Answered on August 20, 2018 at 08:27 AM

    Hi, it doesn't work - your system is still answering as follows:

    <?xml version="1.0" encoding="UTF-8"?>

    <multipay version="1.0">

      <su/>

      <currency_code>EUR</currency_code>

      <reasons>

        <reason>FoXXXX 82XXXXXXXXXXXX</reason>

        <reason>SuXXXXXXXXXX 41XXXXXXXXXXXXXXXXX</reason>

      </reasons>

      <success_url>https://submit.jotformeu.com/complete.php?sid=4105769178927050018</success_url>

      <success_link_redirect>1</success_link_redirect>

      <abort_url>https://submit.jotformeu.com/form/82274514039355</abort_url>

      <notification_urls>

        <notification_url notify_on="received">https://submit.jotformeu.com/ipns/sofort.php?formID=82274514039355&amp;submissionID=4105769178927050018&amp;paymentType=product&amp;currency=EUR&amp;amount=&amp;configKey= 173232%3A456644%3A95b7d41de427d956fd3660976b555fe5</notification_url>

      </notification_urls>

      <amount>10</amount>

      <project_id>456644</project_id>

    </multipay>

  • Profile Image
    ashwin_d
    Answered on August 20, 2018 at 10:34 AM

    Your message has reached my colleague @york. We will get back to you as soon as we have any update on this.

  • Profile Image
    klasphilipp
    Answered on August 22, 2018 at 04:05 AM

    Hey all together, we still need feedback on this topic urgently!!!

  • Profile Image
    ashwin_d
    Answered on August 22, 2018 at 05:28 AM

    I am sending a note to my colleague @york. He will get back to you as soon as he is back online. 

  • Profile Image
    york
    Answered on August 22, 2018 at 05:23 PM

    I added a new option to the payment integration wizard.

    1534972673Screen_Shot_2018-08-23_at_00_0

    Please remove Sofort field and add it back to form, then choose pending payments from the dropdown you see in the image.

    The submission will leave incomplete payments section right after the user completes the payment flow and gets to thank you page. (This process might take up to 10 minutes.)



  • Profile Image
    klasphilipp
    Answered on August 28, 2018 at 04:22 AM

    Hi York, this issue seems to be fixed now. Thanks a lot! I have tested it with several constellations and every way works pretty fine.

    Philipp

  • Profile Image
    york
    Answered on August 28, 2018 at 04:28 AM

    Thanks for informing us Philipp.

    Please let us know if you have any other questions.