I have a WP_Query for Products. I have an ACF group for products that includes a Post Object field for the custom post type Author. Authors also have an ACF Group including text fields for first and last name.
I would like to order my query such that the products are ordered by the last name of the author that they are associated with.
Any suggestions would be very much appreciated.
This is not possible because that field you want to order by is not associated with the posts that you want to order.
To do this you would have to copy the field from the post where it is added to the post you want to sort.
I understand that this complicates things, but I would imagine it’s possible…