Hi @thibault01
Appreciate your question. Could you please elaborate a bit and maybe give a link to your store or checkout or a screenshot that needs this solution you are asking about?
Hi I would like to create a page on frontend.
The visitor will recover his abandoned cart with his informations (email, shipping, address, …) captured by your plugin. Maybe a summary of his informations.
something like this : https://myagencyinside.com/maquettes/26-juin/wp-content/uploads/2020/06/Capture-d’e?cran-2020-06-26-a?-23.03.18.png
Maybe we could call a <?php echo … ?
Best regards
Thanks for the link, but unfortunatelly it does not open up any image or page. It says the page does not exist: “Oops! Cette page n’existe pas”. Could you please fix the link?
Hey @thibault01
If you would like to take use of the CartBounty data, you can simply connect to the database table “wp_captured_wc_fields” and run SQL queries.
Here is an example that should get you going in the right direction:
function get_cartbounty_row( $user_email ){
global $wpdb;
if(!$user_email){ //If no email has been provided, exit
return;
}
$abandoned_cart_row = $wpdb->get_row(
$wpdb->prepare(
"SELECT *
FROM wp_captured_wc_fields
WHERE
cart_contents != '' AND
email = %s",
$user_email
)
);
return $abandoned_cart_row;
}
$cart_data = get_cartbounty_row('[email protected]');
echo $cart_data->name;
echo $cart_data->surname;
echo $cart_data->email;
Best wishes and good luck! 🙂
