[RESOLVED] Find customers who bought specific SKU

Posted . Visible to the public.

Solution:

SELECT DISTINCT o.customer_email, o.customer_firstname, o.customer_lastname, o.store_id FROM sales_flat_order_item i
INNER JOIN sales_flat_order o ON o.entity_id = i.order_id
WHERE o.customer_id IS NOT NULL
AND i.sku = 'B/BVP700'

Alan Vo
Last edit
Posted by Alan Vo to Alan Vo's deck (2014-04-23 23:18)