Call captured_wc_fields email display it

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?

https://myagencyinside.com/maquettes/26-juin/wp-content/uploads/2020/06/2.png

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! ??