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.