I need a volusion custom SQL report that will provide each product sold, quantity that was sold in that time period, and total revenues received for that product. This report will be run on a monthly basis from: Inventory → Import/Export → Saved Exports → Saved Queries.
Some of our products have quantity discounts in place. So I would want a total revenue that includes both the full price and discounted prices all together. I know how to navigate to the custom export page, so I would just need the code to paste in.