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.