Order report is missing the "Status" column, making it far less helpful

Created on 15 January 2025, 6 days ago

Problem/Motivation

Order reports are used for different kind of reports, but in many cases it's important to be able to differentiate the order by their (final) status. For example you'd typically want to sort out canceled or refunded orders or only report on completed orders!

I was wondering, why I couldn't filter the commerce order report for such statuses and looking at the code seems to show, that the status column isn't available for commerce order reports?

Steps to reproduce

Try creating an order report only for completed orders and find out that it's not possible without custom code?

Proposed resolution

Add the order status field for the commerce order report

Remaining tasks

Implement
Test
Release

User interface changes

API changes

Data model changes

🐛 Bug report
Status

Active

Version

1.0

Component

Code

Created by

🇩🇪Germany Anybody Porta Westfalica

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

  • Issue created by @Anybody
  • 🇩🇪Germany Anybody Porta Westfalica
  • First commit to issue fork.
  • 🇩🇪Germany Anybody Porta Westfalica

    Sorry, I ddn't realize that order_report has a relation on the original order!

    So this is fine, as you simply need to add a (required) relation in views from the order report to the order. That relationship can then be used to filter the view by status and everything is fine and works well!

    Thank you!

Production build 0.71.5 2024