Prestashop how to check abandoned cart and customers

In PrestaShop, you can check abandoned carts and the customers who left them from the Back Office. Here are the main methods.

---

1️⃣ Check Abandoned Carts from Orders → Shopping Carts

1. Login to PrestaShop Admin Panel
2. Go to Orders → Shopping Carts
3. You will see:
   • Cart ID
   • Customer name
   • Total cart value
   • Last update time
   • Status

🟡 If a cart has products but no order, it means the customer abandoned the cart.

You can click the cart to see:

• Customer email
• Products added
• Total value

---

2️⃣ Filter Only Abandoned Carts

Inside Shopping Carts page:

Use filters:

• Customer → shows who added products
• Order ID → if empty = abandoned
• Date → find recent abandoned carts

Rule:

• Cart with products + No order ID = Abandoned Cart

---

3️⃣ Check Customer Details

Click the customer name in the cart.

This opens the customer profile, where you can see:

• Email address
• Phone number
• Previous orders
• Total spent

You can contact them manually.

---

4️⃣ Use Abandoned Cart Modules (Recommended)

PrestaShop by default does not send reminders automatically.

Modules can:

• Send reminder emails
• Give discount coupons
• Recover sales

Popular modules:

• Mail Alerts
• Abandoned Cart Reminder Pro
• PrestaShop Checkout

---

5️⃣ Check Using Database (Advanced)

If you want via MySQL:

Tables used:

ps_cart
ps_customer
ps_orders

Example query:

SELECT c.id_cart, cu.email, c.date_add
FROM ps_cart c
LEFT JOIN ps_orders o ON c.id_cart = o.id_cart
LEFT JOIN ps_customer cu ON c.id_customer = cu.id_customer
WHERE o.id_order IS NULL;

This shows all abandoned carts with customer emails.

---