How-to export Woocommerce customers list with total spent on completed orders
SELECT
B.meta_value AS first_name,
C.meta_value AS last_name,
K.user_email AS email,
D.meta_value AS phone,
ROUND(SUM(L.meta_value)) AS total_orders,
H.meta_value AS city,
G.meta_value AS state,
F.meta_value AS country...
amariei.me1 min read