I am sorry, but I cannot follow those steps.
Please provide to me the access to the live site; I will grab a Duplicator Package, and deploy it locally.
About "In my case you need to import all three databases."
This is a very important detail.
We do not support, and neither does WordPress, multiple Database Websites.
A WordPress WebSite has one Database with 12 tables in it.
A number of tables might vary depending on what Custom Plugins you use, but that would be the minimum.
All those tables must be editable and writable by the Root user of the Website.
If you use a customised method, I cannot assist troubleshooting.
I am quite sure your Website uses one Database only.
Anyway.
1. I reccomend this Plugin, it does exactly what you want, and it has ShortCodes so you can use it in views or content templates as well
hidden link
2. Otherwise this little Custom Code should do the trick.
function get_user_who_bought_the_product(){
//We get all orders (post type shop_order, completed)
$customer_orders = get_posts( array(
'numberposts' => -1,
'post_type' => 'shop_order', // WC orders post type
'post_status' => 'wc-completed' // Only orders with status "completed"
) );
//We create an array for later use
$customer_name = array();
//We foreach over each found order post and get some data
foreach ($customer_orders as $customer_order) {
//customer ID from the post meta
$customer_id = get_post_meta($customer_order->ID, '_customer_user', true);
//get the user data
$customer_object = get_userdata($customer_id);
//get the user name (first)
$customer_name[] = $customer_object->first_name;
}
//return above array joined
return join(" ", $customer_name);
}
add_shortcode('get_user_who_bought_the_product','get_user_who_bought_the_product');
It has to be added to functions.php in your theme, then called in the Content Template with the ShortCode [get_user_who_bought_the_product], this will then display the user First name (of the user who bought the product).
This is custom code and cannot be assisted 100% by us, but it should give an idea of how you can do that.
The feature you are asking for is not officially supported in Toolset or even WooCommerce Core.
