Report on Sales By Employee

[rmaweb]

Hello Everyone,

Has anyone created a reports page that will allow you to view the number of orders, and total order value, of the orders created by admins on behalf of customers? To me, I don't see anything in the Orders table that holds info on who placed the order, and I only see info in the Order Notes page that when an admin places an order on behalf of a customer and enters in the payment info, the trigger that sets the order status is used, and makes a note in the system. So it looks like I will have to flag that note on each user and pull all of those flagged notes to pull the order info from.

Just wondering if someone has an easier way of creating this report than that.

[jmestep]

You could try filtering on the remoteip in the orders table.