Report with Product Costs

[[email protected]]

Our bookkeeper needs a report that shows orders from the last 30 days with total sales numbers and total product costs for these sales.

I've been running two separate data exports in Miva to get this data:
"Export Products to Flat File"
"Export Orders to Flat File"

It is a real task to try and use Excel to combine these two files into one spreadsheet that shows the sales and costs for each order.

Does anyone know of a way to create a custom report in Miva that gives both order info from the last 30 days that includes the product costs? Even a custom coded solution might be interesting to us at this point if the cost was reasonable.

Thank you!
Mark

[Bruce - PhosphorMedia]

LOL, just mentioned this in another post. I'd create a batch report that runs through each order selected and calculates these values for you. You'd then use the Order Processing Advanced search (or just date range) to create a list of orders from the last 30 days, click Select All (top checkbox on the left side) and choose that report from the Batch Reports menu.