Page 1 of 1
Customers who bought certain product
Posted: Thu Aug 06, 2009 3:00 pm
by FCMLMT
I'm trying to find a way to isolate and export a report that shows name, email, date, order number of customers who bought a certain product. For example, I want to find all who have purchase X product. Does anyone know how I can accomplish this?
Re: Customers who bought certain product
Posted: Fri Aug 07, 2009 4:02 am
by mazhar
Have a look at reports under
website/admin/reports folder. In order to implement this report you need write some custom query to bring desired results back from db filtering upon provided product name. You need to query ac_OrderItems table. Read API topics from WIKI for custom queries and data access layer.
http://wiki.ablecommerce.com/index.php/ ... uilder_API
Re: Customers who bought certain product
Posted: Sun Apr 10, 2011 6:04 pm
by david-ebt
If you're still looking for this report, we have a couple that should work for you.
One report will let you view and export orders by sku with the basic customer and order data you mention.
http://www.ecombuildertoday.com/ablecom ... sku-report
Another report that lets you search and export by multiple product SKUs as well as many other order fields.
http://www.ecombuildertoday.com/ablecom ... tus-report
With all of our reports you get full source.
I hope this helps.