Assuming that all the meta (fields) in both of the Custom Post Types (CTPs) is relatable, this is the way I would go about figuring out how much work is in order:
- Make a new post in each CTP (both sites) and make sure all the meta fields are
filled in. It will help if you make all the fields that you want to
match have the same value (like Listing-Field-1) so they are easier
to match up later. - Export the CPT from both sites. In the resulting XML files, find the
post you just added. - Compare the XML elements to see how different the structure is.
If you are lucky, both CPTs will use the same structure. In that case you can find/replace the meta field names of the data you want to move to match up with where they need to go in the new system (sometimes some crafty selection tools in VS Code or Sublime Text can help).
If you are unlucky (like I usually am) you will have to write code to output the XML in a way that is structured to match the new system.
Or, you could use a plugin.
Related Posts:
- Create a clone from one WordPress site to another in a few minutes
- WP All Import – Using Xpath to set a select value
- WordPress export tool doesn’t export post-format value of custom post type?
- Two-way synchronizing of a post type among multisite blogs
- Where are wordpress custom types stored?
- Delete all posts of a custom post type—efficiently
- Importing old blog with regular posts into new custom post types
- Custom Post Type with Input fields to seperate table on database.
- How to use custom database tables for custom post types?
- Custom post type or just use custom fields
- Resource Issues: Importing external data into custom post type and keeping records up to date
- How do I write this SQL statement for Posts written in last 24 hours?
- Custom post types not imported properly
- Save or update data when custom post published
- Custom post type Vs. data in own table
- Using posts and postmeta table to store custom Address Book Plugin data
- Beginner question: Accessing functions.php through admin web interface in order to import custom post types?
- How to use custom post type APIs, but use a different db table
- MySQL Syntax Error upon restoring database from backup [closed]
- Importing New Posts from Live Site into Local Dev Site
- Developing WordPress on Kubernetes
- Recommended custom post type structure for TV Schedule site?
- How much of my site can I recover from public_html?
- WordPress post count not showing for custom post type author
- Export entries and multiple custom field meta to .csv?
- Adding custom tables to WordPress
- Sorting custom post type columns with external data and without meta values
- How to use custom taxonomies to reference complex relationships?
- Export / import WordPress database
- ACF Values Don’t Show After Import Unless I Edit/Update Post
- Database to page routing API?
- Merging two databases without borking it
- Store CPT ‘Reviews’ average ratings to a WordPress DB table or to a DB custom table?
- How to handle a CSV with 65,000+ rows and make it searchable?
- How to change wp prefix for custom post type only?
- Is it possible to store Custom Post Type data in separate set of tables and still have wp_post class functionality?
- Add update or delete database records using custom post type
- How to import a custom MySQL DB table into a WordPress custom post type
- How to import files to individual posts of a custom type
- WordPress Local And Live Site
- Importing Data from a Non-WordPress database, into WP
- How to organise this data within WordPress
- Save custom post type to external database
- Show data from one Custom Post Type in another Custom Post Type
- Specifying meta field’s column type in Database using add_post_meta
- Replace dynamically content in a custom database table when a custom post is created
- Save and user submitted data from a form and display them in the wp backend
- Dump custom post type database
- Importer fails to import every post
- Not able to export large no. of posts in csv
- Create a page by importing data from an XML file ( On clicking a button inside admin options page)
- Convert comma separated list to serialized array to import as post meta
- Update all published posts at once
- How to export custom post type with ACF to individual file with automation?
- Ideas to connect external database table to wordpress posts as custom field source
- WordPress as a frontend website for iOS app [closed]
- Using custom post types WordPress network
- custom post type: own database table structure and custom “new-post” interface
- Say I have a tech blog, how best would I store technical specs for a phone, if i use custom post types
- How do you make relational post types in WordPress? [duplicate]
- Migrate Custom Post Type with Custom Fields data and parent child order
- 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?
- Invalid content when I try to import custom post type from the old template wordpress
- Bulk Edit Media Library alt, caption, image names
- Does this archive template part look like its making too many calls to the db?
- Can’t Export Custom Post Types With Export Tool In A Custom Theme
- Right way to store a large set of similar information on website? [duplicate]
- when looping through custom post data not appearing
- custom post types, custom fields and normalization
- How select query is generated in a Custom Post Type?
- Exporting CPT from dev site and import into live site?
- How to replicate data storage and querying using WordPress. Custom posts/fields or Custom db tables?
- custom data model – link and populate from admin backend
- Confused about where to store my data
- Event Manager: Events Deleted are still in DB as published but hidden in admin
- Changing an item in drop down after 5 latest posts per taxonomy
- Populate custom post type/custom fields from an external database
- Automatically convert standard posts with custom fields to custom post types
- Importing URLs of Audio Enclosures
- In WordPress do I create tables for my plugin or do I create custom post types for a Student and Classes Registration system?
- Creating connections programmatically with common fields on CPT’s
- CPT or Custom Table for Repository of Serial Numbers
- How to enable the user to add value through the admin panel?
- Use Tags to Query Associated Multiple Posts and Get The Average Of Custom Field Values
- Shared Custom post type between WP network sites
- Pulling Content from Existing Database
- Displaying database table in backend of wordpress
- custom post type for custom talbe
- Check in function on custom page
- Most efficient way of deleting post
- Problem with menu categories doubling up when updating database?
- Inserting into WP DB
- Save number of Facebook likes to database
- WordPress and Unity high scores table
- Checking for published posts in a certain post type
- Switched server & domain name, now custom post types won’t save
- custom post types containing a collection of items
- WordPress Admin Page Slow. Customer Post Type is the slowest
- cannot export data from CPT UI (books)
- Remote database access on another wordpress site’s custom post type