Filter Orders by Fulfillment Date

[SHOPbrendan]

We have some customized products that require some TLC, mainly noting specific "Line: Properties." I tried running a CSV containing Line: Properties through the script and it works well, but I need a way to access Line: Properties of orders "Fulfilled yesterday." I cannot find a way to access the date fulfilled either through exports on Shopify or through the Admin API. Is this data accessible anywhere, or can I reference other pieces of data to get the same information?

Thanks!

[CloudlabSam]

You definitely can't do this via the orders screen or any reports. You can definitely accomplish this by using the REST API, but that would get a bit more involved.

Our Report Toaster app can do this pretty easily. This article speaks specifically to exporting with line item properties. Please feel free to take a look and let us know if you have any questions.

[Jonathan-HA]

Hey there @SHOPbrendan ,

The Order API doesn't have a `fulfilled_at` field, you'll basically need to parse the `fulfillments` field which is an array (since an order can have multiple fulfillments) and then grab the highest `created_at` value from the list of fulfillments.

If you need to get the fulfillment date at the line item level, then it's an extra step as you'll have to also match up the `line_item_id` from the fulfillments array.

If you're open to using an app, our EZ Exporter app already has pre-parsed fields for the last fulfillment date both at the order level and line item level which you can filter as well.  We also support exporting and filtering by line item properties.

[SHOPbrendan]

Edit

[SHOPbrendan]

Do you have a trial option? If an app works we would be happy to pay, but don't want to spend money on something that simply won't work.

[CloudlabSam]

Report Toaster has a two week trial for Advanced and Shopify Plus users. If you are a Basic or Shopify user, the app can be used for free indefinitely unless you need advanced features.