Sorting custom post type columns with external data and without meta values

If I understand it right your workflow is that you query posts (implicitly via normal WP mechanics), then display data from external database for them, but want to sort based on external data.

This isn’t trivial (without mirroring you don’t want to do), since WP relies primarily on SQL over its own data for sorting.

One of the ways you could implement it (assuming parity of entries data with external database) is to use that database for sorting:

  1. Query external database for entries with required sort.
  2. Get a set of ISBN entries.
  3. Query posts from WP database corresponding to entries.
  4. Override main query with this set of posts (post__in query argument and orderby=>post__in for example).

Quite roundabout, but I can’t think of other way without data mirror.

Related Posts:

  1. Store CPT ‘Reviews’ average ratings to a WordPress DB table or to a DB custom table?
  2. How do I set the default admin sort order for a custom post type to a custom column?
  3. Using meta_query, how can i filter by a custom field and order by another one?
  4. How to order adjacent posts (prev / next) by custom field value?
  5. Sorting a query by custom field date
  6. Custom Taxonomy Template Post List with Sort Order
  7. Right way of storing large number of custom post fields
  8. Custom post type or just use custom fields
  9. How to sort a table of custom posts by column containing custom field
  10. How to Sort Custom Field Admin Column by Date
  11. How to Sort by Date When Using d-m-Y Format
  12. Using posts and postmeta table to store custom Address Book Plugin data
  13. Sort by two dates. Default entry date and custom field if present
  14. WP All Import – Using Xpath to set a select value
  15. WP_Query order by custom field, then randomly order some of results
  16. Importing Data from a Non-WordPress database, into WP
  17. Specifying meta field’s column type in Database using add_post_meta
  18. Sort custom post type by most current date picker
  19. Make a custom column sortable by a value from a different custom post type
  20. Ideas to connect external database table to wordpress posts as custom field source
  21. delete duplicate meta_value with same post_id
  22. How can I sort the order of multiple custom field values in a custom post type?
  23. Having a repeating custom field in admin custom post type, what I’d go better with, for DB’s sake? ACF repeater or query a different post type?
  24. when looping through custom post data not appearing
  25. custom post types, custom fields and normalization
  26. How to replicate data storage and querying using WordPress. Custom posts/fields or Custom db tables?
  27. Confused about where to store my data
  28. sorting in wp query based on custom field value
  29. Populate custom post type/custom fields from an external database
  30. Automatically convert standard posts with custom fields to custom post types
  31. How to enable the user to add value through the admin panel?
  32. Displaying database table in backend of wordpress
  33. Sort CPT by taxonomy AND THEN by custom field
  34. Advanced search form with filters for custom taxonomies and custom fields
  35. Help Creating a Slideshow Custom Post Type with Custom Meta Boxes?
  36. Search multiple custom fields by using meta_query
  37. Custom Post Type – Taxonomy Dropdown Menu?
  38. How do I implement custom fields without using any plugins?
  39. How I check if the same post slug has not been used before publishing?
  40. order by meta_value serialized array
  41. Custom post metadata not appearing in public API
  42. Automatically Insert Custom Field on Custom Post Type Publish
  43. Create a post in custom post type using field in registration form after users submit form
  44. WordPress custom meta field for custom post not storing data
  45. Conditional regex in add_rewrite_rule() for specific query filters & pagination
  46. List all images from a single post meta value
  47. Combining sorted and random CPT
  48. Publish an XML feed from a CPT with ACF fields?
  49. WP_Query: include custom post type only with specific meta value
  50. How to set up multisite for multi language?
  51. Creating a Custom Post as a repository for theme constants
  52. Create a clone from one WordPress site to another in a few minutes
  53. Orderby CPT custom fields not working
  54. get_post_meta not working on publishing
  55. Query custom post type with ACF Date
  56. How to create a custom post type with additional fields?
  57. Add custom field in comments form
  58. Order Custom Post Type by Custom Field Value
  59. Hierarchical custom fields
  60. Fields for different parts of a page
  61. Facebook social publisher and custom post type fields [closed]
  62. Searching Custom Fields
  63. How to display custom field value on page?
  64. Should I use custom taxonomies or not?
  65. How to get specific post meta by title or id
  66. Populate a custom field dropdown with post titles by author
  67. Category Search / Custom Post Type search on my website. Custom Post Types that are “page-like”?
  68. Adding Template Post Content
  69. How to display a WordPress Custom Field only on a specific day of the week?
  70. Filtering custom posts by custom fields (ACF) [closed]
  71. Save Custom Fields
  72. Custom loop request based on custom field
  73. Writing a custom Glossary plugin
  74. Filter search posts by post meta?
  75. Display Posts that fit a certain criteria on Category pages
  76. Sort custom post column by generated value?
  77. How to only display all posts to a custom User Role?
  78. Custom post type and custom taxonomy key lenght & query performance
  79. Custom post type order by post_title
  80. register_rest_field update_callback don’t work for $_FILES
  81. How to convert Post Object Custom Field into Tags
  82. Filter custom WP_Query by first letter of a custom field – hopefully using Search and Filter Pro?
  83. PHP Notice: Unidentified index
  84. check_admin_referer not working in custom meta box for custom post type
  85. How to display all custom fields associated with a post type – IN THE ADMIN AREA?
  86. Setting a custom $query->query_vars[‘meta_key’] breaks the WordPress menu
  87. I want to split this into two functions
  88. Repeatable Custom Field for Media Upload
  89. Most efficient way of deleting post
  90. Problem with menu categories doubling up when updating database?
  91. How to store datetime from custom meta box so that it can be sorted by
  92. Custom Post Meta on a Different Page?
  93. Switched server & domain name, now custom post types won’t save
  94. Adding a custom field after post title (ex.Example Title [30 Second Read])
  95. Creating post custom field text area
  96. querying to custom field over ACF REST API
  97. Send email on creation of custom post type and use get_post_meta()
  98. pre_get_posts causes Custom Posts appear under ‘Pages’ menu
  99. WordPress does not show the custom fields box
  100. Query order by a numeric ACF field
tech