Need Report To Show Total Cost Of Items Per Order

[Jayman11]

I have detailed monthly sales report module installed but the only thing i need extra is for it to tell me what the total cost of the products on each order was. Anyone have any ideas of a mod to do this? It would save me a ton of time of having to look up and add each item up individually to get the cost of the items on the order. Right now my detailed report looks like this:

 

Order #   Customer        Date         Order Subtotal   Shipping Total Tax Total Order Total 
12345     John Doe        04/28/2010   $5.00            $4.00          $0.00     $9.00 
12346     Jane Doe        04/27/2010   $8.00            $5.00          $0.00     $13.00

I would love to put in a column for Product Cost before the subtotal.

Even if that cant be done another report would be great for product cost on each order.

[Mort-lemur]

Hi,

 

There is a cost / margins add -on that may help.

[Guest]

Jason,

 

Look at this:

 

http://addons.oscommerce.com/info/6242

 

You may be able to modify it into something you can use

 

 

 

 

Chris