Retroactively adding costs to the total for an item

[grizzlyThresher]

While not exactly a common occurrence, it happens occasionally with my company that we put an item up for sale but forget to list the cost. Eventually we manage to catch this oversight and assign a cost to the item, but the problem lies in the product reports. It calculates the total cost of the quantity of said item sold after assigning the cost, but it doesn't include the costs of any items sold before the cost was assigned. Is there any way to add the cost of the items sold before the cost was assigned to the total value?

[Katie]

Unfortunately, there isn't a feature within the Merchant Admin where you can add the cost of a product to the existing order. You wouldn't want all past orders to be updated with a new cost either, so the only way to accomplish this is to either manually update the database or write some custom code within in the Order Admin area.

Thanks for joining the forums!
Katie