Subject: Per Product Sales Reports broken?
We have been using this mod successfully for a couple months now (figured out most of the bugs ourselves). But we have one major issue. When we run reports on our total sales, the amount is obviously correct. But when we report on sales PER PRODUCT, there is no way to report the totals correctly.
In other words, the coupons are verified per product, but applied per order. This is an issue for us because we are paying royalties to vendors for whom we are selling for. So if a customer buys 5 products, one of which has a coupon, we cannot report accurately for that one product - we'd lose money, especially since the coupons are usually pretty big.
So my question is - has anyone modified this contribution to perhaps store the modified price in an extra field or SOMETHING so that we can run reports and get the correct info? I personally am a bit shocked that the "final_price" field is not being used for this.
So any help would be _GREATLY_ appreciated.