Does anyone else struggle with the disconnect between Course price and Order total on the orders report? It’s difficult to get an accurate picture of income from courses when the Order total may include things other than the specific course in question, or when there are two or more children that are paid for on the same order.
I’m looking at an orders report right now for a set of recordings that can be purchased individually or as a block (for a lower price than the sum of the children), where someone purchased two children on a single order. On the report, she has two lines (one for each course purchased), and BOTH LINES have $50 for Course price (correct) and $100 for the Order total, when in fact there was a single order for $100. Then there’s someone who purchased a single course for $50, but who purchased something else entirely, so the Course price is $50 (correct) and the Order total is $395.
Some people got a coupon code to use to get their recordings for free, so I can’t use the Course price as an accurate number, and because of the above situations I can’t add up the Order total column and get a correct number, either.
Does anyone else get frustrated by this? There is SO MUCH manual work required to get an accurate financial picture in these situations. Does anyone have any thoughts? I’m DYING here.