List of customers who bought a specific product

[danmccoywe31ff]

I need to generate list of my customers who have bought a specific product, ideally with their contact info, but the order number would do the trick.  I want to send them all an offer about a new product, but can't find a way to generate this list.

[glo11486ad4f3e]

Hi danmccoywe31ff,

Thank you for reaching out to us.

If we understand it correct, you are looking to reach out to Customers (via email) who bought specific products.

To achieve this, you can create an SQL based report with following join statement and save the report within a given Dashboard:

SELECT *
FROM "sales_order_item"
INNER JOIN "sales_order" ON sales_order_item.order_id = sales_order.entity_id limit 10000

The resultant tabular format will show you all the matches between Items & their placed order details (including Customer Email).

From the saved dashboard you can navigate to this report and export it as a CSV or XLSX file to view the details & massage the output data basis your business requirement.

For more information please refer to below links:

https://experienceleague.adobe.com/en/docs/commerce-learn/tutorials/mbi/sql-report-builder

https://experienceleague.adobe.com/en/docs/commerce-business-intelligence/mbi/build/share/exp-chart-...