Report on Sales By Employee
Posted: Tue Jan 20, 2015 9:00 am
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.
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.