I have a client that set up their products without filling in the cost field. They now wish to report an actual profit in Magento and I have set cost for all products. However, I notice the profit is only correct on reporting after this change. Looking at orders, those that were placed prior to the fix have a profit of $0 since it didn't have the cost value to do the calculation. Those are fine.
Is there any way
I can force Magento to update those historic orders in order to get their profits? I've tried the simple option of doing a "Refresh Stats" but that doesn't change anything.