When viewing this report please can anyone confirm how you interpret ‘Units Ordered’ or ‘Total Order Items’? Which best correlates with actual sales (i.e. accounting for customer returns/refunds/lost in transit)? Unfortunately the glossary of terms link is down.
When comparing the two they often match but sometimes there are slight variances which seem to marry up with customer returns/refunds/lost in transit. For example on one of my items the ‘Units Ordered’ reports 26 and ‘Total Order Items’ reports 6, a variance of 20. I can then see on my MonthlyTransaction report that 20 were refunded which would explain the discrepancy of 20. Is this correct? and should we therefore refer to Total Order Items as the best correlater to sales?
Any advice greatly appreciated!