Prestashop how to check abandoned cart and customers

In PrestaShop, you can check abandoned carts and customer details from the Back Office.

Here is the complete step-by-step guide 👇

🔎 1️⃣ How to Check Abandoned Carts in PrestaShop

✅ Method 1: From Orders → Shopping Carts

1. Login to PrestaShop Admin Panel
2. Go to Orders
3. Click Shopping Carts

Here you will see:

• Cart ID
• Customer name
• Total cart value
• Date created
• Whether it was converted into an order

👉 If a cart has:

• Products added
• Customer details filled
• But no order created

➡ That is an Abandoned Cart

You can click on any cart to:

• View products
• View customer
• Send email manually

👥 2️⃣ How to Check Customer Details

1. Go to Customers → Customers
2. Click on customer name

You can see:

• Name
• Email
• Phone
• Total orders
• Total spent
• Last visit
• Connected carts

Inside the customer profile, scroll down to see:

• Shopping carts created
• Orders history

📊 3️⃣ Better Way (Recommended): Use Abandoned Cart Module

Default PrestaShop does NOT send automatic abandoned cart emails.

For automation, install module like:

• Mailchimp
• Klaviyo
• PrestaShop Abandoned Cart Reminder Module

These modules allow:

• Automatic reminder emails
• Discount coupons
• Recovery statistics
• Conversion tracking

🛠 4️⃣ Database Method (Advanced – Since You Work With PHP)

If you want to check from database:

Table:

ps_cart

Condition for abandoned cart:

• id_cart exists
• id_customer NOT 0
• No matching id_order in ps_orders

SQL Example:

SELECT c.id_cart, c.id_customer, c.date_add
FROM ps_cart c
LEFT JOIN ps_orders o ON c.id_cart = o.id_cart
WHERE o.id_order IS NULL
AND c.id_customer != 0;

This will show abandoned carts.

💡 Extra Tip (For Your Speed Optimization Work)

If your store is slow:

• Delete old abandoned carts (older than 6 months)
• Optimize ps_cart table
• Clean guest accounts