I need to create some custom reports off data that will be collected from two modules, one called Sales Representative Pro and another called Advanced Custom Fields.
I know that we need to see sales by rep by date and be able to see the details of each order that the rep is getting credit for (so that we can see the categories, selling price and not have shipping and tax included).
- Revenue by Zip Code
- Revenue (w/order detail) by group (ie: wholesale / retail/ international)
- A full report with all the fields below and totals at the bottom:
Order #
Customer #
Date
Billing Name
Billing Address
Shipping Name
Shipping Address
Phone
email
Sales Rep (from custom extension Sales Representative Pro)
Coupon Code
Referred By/New Referral: (Custom field from Advanced Custom Fields extension)
Product SKU
Product Description
Quantity
Selling Price
Total Price
(And all numeric fields total at the bottom of the report)
We are freelance software developers. If you contact us, we can give a quote for your project and we can discuss the details further. w w w . so lv e r . i o