OroCommerce Forums

Covering OroCommerce topics, including community updates and company announcements.

Forums Forums OroCommerce Order – Payment Status

This topic contains 4 replies, has 2 voices, and was last updated by  Tyler 3 years ago.

Starting from March 1, 2020 the forum has been switched to the read-only mode. Please head to StackOverflow for support.

  • Creator
  • #31783


    Hi !
    How to get the payment status of an order ?


Viewing 4 replies - 1 through 4 (of 4 total)
  • Author
  • #31784

    Dmitriy Pasechnik

    Hello Tyler.

    If you want to see payment status of an order via web interface – then you can see it in product`s view page (e.g. /admin/order/view/1, or Admin -> sales -> orders -> view order -> ‘Payment status’ in ‘general’ section)

    Or, if you want to get it in code, then you should use



    Hi Dmitriy,

    Yes I know this method ?
    But with this method I have to loop on each orders to know the payment status.
    Or there is another way to search my orders by payment status into the code ?

    I want to explose as API my all order by payment status like a search.
    I want to request my order like orderByPaymentStatus($status), then the code return the orders with the status given.
    Is it possible ?
    I saw the table payement_status doesnt have relation with others tables, but the entity_class is referer.
    Have I to make a custom request between both tables ?


    Dmitriy Pasechnik

    Yes, you have to make custom query. But it would be better to do DQL query instead of SQL (to get array of ‘Order’ entities instead of array of … arrays :))
    Something like this:



    Haha, of course.
    I made a Subquery and It works.

    Sorry, I was sure we could not use the joins without a foreign key…
    I will try your solution know :)


Viewing 4 replies - 1 through 4 (of 4 total)

The forum ‘OroCommerce’ is closed to new topics and replies.

You will be redirected to [title]. Would you like to continue?

Yes No