Item purchase verification

[igavemybest]

I want to verify that an item with a particular sku was purchased by a customer with "x@x.com" email address from outside the AC7 website. What would be the best way to do that.

[AbleMods]

This should do it for you....

Code: Select all

SELECT u.loweredusername,o.ordernumber, o.orderdate, oi.sku FROM ac_users u 
	LEFT OUTER JOIN ac_orders o ON u.userid = o.userid
	LEFT OUTER JOIN ac_orderitems oi ON o.orderid = oi.orderid
	WHERE u.loweredusername='jhpayne@solunar.com'
	AND SKU='IND-12MON'

Obviously change the email address and SKU to your search criteria.