A user needed to export orders based on fulfillment/invoice date rather than order placement date for accounting purposes, specifically to isolate last year’s fulfilled orders.
Problem: Shopify’s standard export reports only filter by order placement date, not fulfillment date, making year-end accounting reconciliation difficult.
Solution provided:
Outcome: The solution successfully resolved the issue. The report displayed fulfillment status (1 for fulfilled, 0 for unfulfilled) within the selected timeframe, meeting the accounting requirements.
I am trying to export a report of all orders that have been fulfilled/invoiced within a specific timefra (last year)
When I do try to export such a report in Shopify reports I can only create a report of all orders “placed” within said timeframe regardless of when they were fulfilled. I don’t want to see this years fulfilled orders only those invoiced last year. This has become a headache for accounting
The report you are looking for is available in the New Analytics version. The name of the report is “Orders fulfilled overtime”. If you would like to automate this report than you can try Report Pundit
Thank you for your solution, it worked perfectly as it showed which orders were fulfilled (1) and which were not (0) in the report in the selected timeframe.