We have two WordPress sites (Site 1 and Site 2) in the same database, with different prefixes ("site_1_" and "site_2_").
Let's say we've got a custom post type named "stuff", which is in Site 1. We'd like to use the same content for this particular post type in Site 2, while avoiding duplicated data.
I've played around with
$wpdb->set_prefix(), but as we're also using WPML it gets a bit complicated, and doesn't feel like a bullet-proof solution.
Any suggestions? Or should I simply give up and use duplicated data anyway?
Thank you in advance.