Custom Order Report Including Product Code, Shipping Price, Product Price

Hoping that including this in the reporting & analytics forum might garner some results:  I'm trying to organize a custom order report for a client with specific values to enable them to work with their current inventory management software. Doing this via custom reports > customer reports > customers and orders.

Most of their requirements are satisfied with BC's custom order reporting. Not so the following (as far as I can tell):

- Individual sell price of each product (not a total of orders purchased)

- Shipping Charge (not just shipping type)

- Product Code

Honestly, the first two I can somewhat deal with if there's no way to do it. It's simple mathematics that can possibly be performed with vlookups or calculation macros set up in excel on their end. But the final one? Product Code is how they identify each order, and unless I'm seriously blind, there's no way to include it on each line item in the export file which will seriously cause some issues.

Has anyone encountered this or a workaround? Is it there any am I just not seeing it? Help much appreciated.

Liam: It is better to keep to one post so you do not get split messaging and create confusion for people. Also when people search they will find one solid result and not mixed.