Customer Order Report

[padthai]

Hi there

I would like to search customer previous orders.
For Example. I have a customer name call john. I would like to know what he has order previously. and how many orders he made so far

[QMcKay]

Customer Purchase History Reporting

This is a Report to show Historical Purchases on a per-Customer basis. You can select a Date Range to Report on and use Entity Search to load any Customer Purchase History. [image] This Tutorial uses to SQL scripts to pull data from the [Orders] table and the [Tickets] table. The data in the [Orders] table does not include Additional costs or Discount values that might be applied via Order Tag Prices, so the Item Total Prices could be incorrect (too high or too low). Note in th…