Automatically convert standard posts with custom fields to custom post types

The question: what is the easiest way to convert standard posts with custom fields into a new custom post type

There’s no “easy” way. Consider that all posts have custom fields (some are hidden, and WordPress will add them). So you would need to convert post types based on the presence / value of specific custom fields.

This is not easy. It is doable with some SQL skills, but not “easy”.

AND to import/keep the data originally assigned to each post from the custom field into the native field of a new post type? Can this be done automatically?

Changing post type means to change a column in the posts table. As long as the post ID column stays the same, the custom fields in meta table will stay unchanged, so you don’t need to do anything to keep the data originally assigned to each post.

But as said above, there’s no way to do it automatically, you’ll need to run some SQL query on the database.

Related Posts:

  1. 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?
  2. Filtering a WP_Query meta_query by numeric values isn’t working
  3. Automatically fill custom field value on post publish/update
  4. Right way of storing large number of custom post fields
  5. Filter a custom field based on selection of another custom field (ACF) [closed]
  6. Custom post type or just use custom fields
  7. ACF Relationships in Custom Post Type Permalink
  8. How to sort a table of custom posts by column containing custom field
  9. WordPress Search documentation: how to improve search query using taxonomy terms, custom meta fields?
  10. Use Custom Post Type as Custom Field
  11. Using posts and postmeta table to store custom Address Book Plugin data
  12. Display posts if a custom field value is equal to another custom field value
  13. ACF Upload Image in repeater from front-end with custom form? – add_post_meta()
  14. Get Custom Field Values by Another Custom Field in WordPress
  15. How to Display ACF Relationship Custom Field as Link to Specific Custom Post?
  16. Query Custom Post Types by date (custom field) range
  17. Custom Post type and Custom Field WP_Query
  18. WP All Import – Using Xpath to set a select value
  19. How to change post featured image using a custom field of category?
  20. Sorting custom post type columns with external data and without meta values
  21. Retrieve value of a category’s custom field
  22. How can I dynamically add a post to a custom post type which uses a custom field?
  23. Bulk Update Custom Fields for Custom Post Types
  24. WP_Query order by custom field, then randomly order some of results
  25. Query custom post type with ACF Date
  26. Store CPT ‘Reviews’ average ratings to a WordPress DB table or to a DB custom table?
  27. Meta Query Not Returning Output Despite Having Matching Values
  28. ACF From & To Date Validations
  29. Using advanced custom fields from one custom post type in another custom post type / using nested shortcodes
  30. How to render a custom post type template with custom fields using shortcode
  31. Order Custom Post Type by Custom Field Value
  32. Custom fields (wp_post_meta) vs Custom Table for large amount of data
  33. Multiple Frontend Filters Using Advanced Custom Fields
  34. Integrate Custom Post Type Events into Calendar
  35. Displaying custom field according to date
  36. Importing Data from a Non-WordPress database, into WP
  37. WebP Fallback for Inline Background Image in Style Attribute
  38. Query based on custom fields start and end date
  39. Specifying meta field’s column type in Database using add_post_meta
  40. How to get a custom type post data when it has a connection with another custom type post?
  41. List of users that clicked a ‘Join’ button at single post
  42. How to inherit field value from parent post into in child / sub post
  43. Custome fields not displayed
  44. posttype and custom fields on multisite
  45. How do I get_the_postID() for a custom post that uses ACF repeater field?
  46. How do I replace the post title with a custom field?
  47. Sum and count of custom field values
  48. Group by custom field value (start and end times)
  49. Custom post types, disable fields
  50. Ideas to connect external database table to wordpress posts as custom field source
  51. Get A Custom Field From A Custom Taxonomy Of A Custom Post Type [closed]
  52. delete duplicate meta_value with same post_id
  53. Automatically add a character to field in edit post page
  54. Excerpt length: get first paragraph
  55. ACF – Retrieve custom taxonomy from a relationship field
  56. Create if else for post types in WP_Query ‘post__in’ values
  57. when looping through custom post data not appearing
  58. custom post types, custom fields and normalization
  59. Display Custom Field or Custom Taxonomy in front page /post/product
  60. How to access repeater field of a custom field?
  61. Filter posts by their related field’s custom field
  62. filter using custom fields
  63. Create 3 Levels of relations with WordPress
  64. How to replicate data storage and querying using WordPress. Custom posts/fields or Custom db tables?
  65. Autofill advanced custom field with user data
  66. Confused about where to store my data
  67. Advanced search form with multiple custom fields
  68. How do I display specific custom posts, and how do I edit a post’s singular page?
  69. Populate custom post type/custom fields from an external database
  70. Fixed custom fields depending on posttype/category
  71. Can’t pick up a field created with Advanced Custom Fields
  72. How to enable the user to add value through the admin panel?
  73. Get month and day from a Date Picker custom field
  74. Setting a custom $query->query_vars[‘meta_key’] breaks the WordPress menu
  75. Displaying database table in backend of wordpress
  76. If i have custom post type with 5 custom fields do i have to create a new loop to reference each one?
  77. How to show animal lineage/pedigree in WordPress?
  78. ACF – Query relationship without ID
  79. Retrieve a post with its ACF repeater fields in wordpress
  80. Is it possible to specify a time interval (from, to) in ACF with date picker, or other custom field?
  81. Display ACF object field data using Elementor Custom Query
  82. Post object GUID adding http:/
  83. Custom Sort Order for Custom Post Type Taxonomy
  84. Hide custom post type field from author?
  85. wordpress plugin error handling
  86. Trying to save custom post type from frontend partially working
  87. Comparing timestamps in meta query doesn’t work
  88. Is there any performance consideration when using Custom Post Types?
  89. Show image gallery from a custom field
  90. don’t publish custom post type post if a meta data field isn’t valid
  91. A meta box (in a custom post type) with two different type of fields
  92. Cannot obtain custom meta information
  93. SQL query – get ids – Advanced Custom Fields / WPeC
  94. What is the correct way that when creating a custom post type assign values to custom fields created with pods framework?
  95. Copying custom field value in to title
  96. Show Posts in Vertical Tabs with Scrollbar
  97. ACF Relationship: Group posts by parent category term, then child [closed]
  98. WP Query + custom fields: How to query event posts from the current date backwards 6 months and organize it month by month?
  99. selecting custom post types and taxonomies for hub page listing blocks
  100. Remote database access on another wordpress site’s custom post type