Customers who bought certain product

[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?

[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

[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.