Magento 2.X : Add custom columns to sales_order_paymentSales Grid, adding columns from different SQL tableshow to add custom button in sale viewSales Order Grid - Can't export custom columnsMagento add Custom order statusDisplaying columns in Sales Order GridMagento Add value in custom column of sales_flat_order tableHow to add a Customer Attribute in a custom module using declarative schema in Magento 2.3?Magento Custom button add Custom Controller URL

What's the point of fighting monsters in Zelda BotW?

What to do about my 1-month-old boy peeing through diapers?

What should be done with the carbon when using magic to get oxygen from carbon dioxide?

Is there a better way to use C# dictionaries than TryGetValue?

Spicing up a moment of peace

Coupling two 15 Amp circuit breaker for 20 Amp

Employing a contractor proving difficult

How could a self contained organic body propel itself in space

Can I get a PhD for developing educational software?

Cutting numbers into a specific decimals

Are spot colors limited and why CMYK mix is not treated same as spot color mix?

Pen test results for web application include a file from a forbidden directory that is not even used or referenced

Can a network vulnerability be exploited locally?

How do I portray irrational anger in first person?

Can I lend a small amount of my own money to a bank at the federal funds rate?

If the UK Gov. has authority to cancel article 50 notification, why do they have to agree an extension with the EU

Stolen MacBook should I worry about my data?

Normalized Malbolge to Malbolge translator

Why didn't Doc believe Marty was from the future?

Why does glibc's strlen need to be so complicated to run quickly?

Drawing probabilities on a simplex in TikZ

What does GDPR mean to myself regarding my own data?

What is the name of this plot that has rows with two connected dots?

The meaning of asynchronous vs synchronous



Magento 2.X : Add custom columns to sales_order_payment


Sales Grid, adding columns from different SQL tableshow to add custom button in sale viewSales Order Grid - Can't export custom columnsMagento add Custom order statusDisplaying columns in Sales Order GridMagento Add value in custom column of sales_flat_order tableHow to add a Customer Attribute in a custom module using declarative schema in Magento 2.3?Magento Custom button add Custom Controller URL






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








0















I already inserted columns on table sales_order_payment with db_schema.



I created new payment method with custom input field in Form payment template like this :



<select id="paiement_echeance" name="payment[paiement_echeance]" >
... some option
<?php endforeach;?>
</select>


When I submit order from back office, my attribute is send but not saved.



I add my attribute in fieldset.xml



 <scope id="global">
<fieldset id="quote_convert_payment">
<field name="paiement_echeance">
<aspect name="to_order_payment" />
</field>
</fieldset>
</scope>


Did I need to use extension attribute ? if yes i'll try it but didn't help for me :(



Do you guys know how to simple save a string in this database xD ?










share|improve this question
































    0















    I already inserted columns on table sales_order_payment with db_schema.



    I created new payment method with custom input field in Form payment template like this :



    <select id="paiement_echeance" name="payment[paiement_echeance]" >
    ... some option
    <?php endforeach;?>
    </select>


    When I submit order from back office, my attribute is send but not saved.



    I add my attribute in fieldset.xml



     <scope id="global">
    <fieldset id="quote_convert_payment">
    <field name="paiement_echeance">
    <aspect name="to_order_payment" />
    </field>
    </fieldset>
    </scope>


    Did I need to use extension attribute ? if yes i'll try it but didn't help for me :(



    Do you guys know how to simple save a string in this database xD ?










    share|improve this question




























      0












      0








      0








      I already inserted columns on table sales_order_payment with db_schema.



      I created new payment method with custom input field in Form payment template like this :



      <select id="paiement_echeance" name="payment[paiement_echeance]" >
      ... some option
      <?php endforeach;?>
      </select>


      When I submit order from back office, my attribute is send but not saved.



      I add my attribute in fieldset.xml



       <scope id="global">
      <fieldset id="quote_convert_payment">
      <field name="paiement_echeance">
      <aspect name="to_order_payment" />
      </field>
      </fieldset>
      </scope>


      Did I need to use extension attribute ? if yes i'll try it but didn't help for me :(



      Do you guys know how to simple save a string in this database xD ?










      share|improve this question
















      I already inserted columns on table sales_order_payment with db_schema.



      I created new payment method with custom input field in Form payment template like this :



      <select id="paiement_echeance" name="payment[paiement_echeance]" >
      ... some option
      <?php endforeach;?>
      </select>


      When I submit order from back office, my attribute is send but not saved.



      I add my attribute in fieldset.xml



       <scope id="global">
      <fieldset id="quote_convert_payment">
      <field name="paiement_echeance">
      <aspect name="to_order_payment" />
      </field>
      </fieldset>
      </scope>


      Did I need to use extension attribute ? if yes i'll try it but didn't help for me :(



      Do you guys know how to simple save a string in this database xD ?







      magento2.3 sales-order






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Aug 16 at 17:01









      Sumit

      7641 silver badge14 bronze badges




      7641 silver badge14 bronze badges










      asked Aug 16 at 15:18









      AKLuffyAKLuffy

      1




      1























          0






          active

          oldest

          votes














          Your Answer








          StackExchange.ready(function()
          var channelOptions =
          tags: "".split(" "),
          id: "479"
          ;
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function()
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled)
          StackExchange.using("snippets", function()
          createEditor();
          );

          else
          createEditor();

          );

          function createEditor()
          StackExchange.prepareEditor(
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader:
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          ,
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          );



          );













          draft saved

          draft discarded


















          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f285642%2fmagento-2-x-add-custom-columns-to-sales-order-payment%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes















          draft saved

          draft discarded
















































          Thanks for contributing an answer to Magento Stack Exchange!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid


          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.

          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f285642%2fmagento-2-x-add-custom-columns-to-sales-order-payment%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Category:9 (number) SubcategoriesMedia in category "9 (number)"Navigation menuUpload mediaGND ID: 4485639-8Library of Congress authority ID: sh85091979ReasonatorScholiaStatistics

          Circuit construction for execution of conditional statements using least significant bitHow are two different registers being used as “control”?How exactly is the stated composite state of the two registers being produced using the $R_zz$ controlled rotations?Efficiently performing controlled rotations in HHLWould this quantum algorithm implementation work?How to prepare a superposed states of odd integers from $1$ to $sqrtN$?Why is this implementation of the order finding algorithm not working?Circuit construction for Hamiltonian simulationHow can I invert the least significant bit of a certain term of a superposed state?Implementing an oracleImplementing a controlled sum operation

          Magento 2 “No Payment Methods” in Admin New OrderHow to integrate Paypal Express Checkout with the Magento APIMagento 1.5 - Sales > Order > edit order and shipping methods disappearAuto Invoice Check/Money Order Payment methodAdd more simple payment methods?Shipping methods not showingWhat should I do to change payment methods if changing the configuration has no effects?1.9 - No Payment Methods showing upMy Payment Methods not Showing for downloadable/virtual product when checkout?Magento2 API to access internal payment methodHow to call an existing payment methods in the registration form?