Repeat purchase rate in PrestaShop

Share of PrestaShop customers who placed more than one valid order.

SELECT ROUND(100.0 * COUNT(*) FILTER (WHERE n > 1) / NULLIF(COUNT(*), 0), 1) AS repeat_rate_pct
FROM (
  SELECT id_customer, COUNT(*) AS n
  FROM ps_orders
  WHERE valid = 1
  GROUP BY id_customer
) y;

How it works

Counts orders per customer, then the percentage with more than one — a core retention KPI. A low repeat rate points to a win-back or loyalty opportunity.