Order Export --- Purchased Items not exported

[hautebox]

What is the best workflow for exporting data about purchased items using the DataPort Utility?

My objective is to send the order items for each customer and order to a CSV file so that I can import into my inventory/accounting software on a Microsoft platform. Ultimately, I will run pivot tables or other basic analysis for customers, order histories, popular items, etc.

I have run some brief experiments using the existing export feature in DPU. However, it appears to only export "basic" information. The "purchased items" data is not exported.

Has anyone discovered a suitable workflow...?

[Naveed]

Please use the Order XML export feature to export complete information.

[hautebox]

Thanks Naveed,

I do see the data in the xml option...

Interesting that that functionality wasn't included in the csv export option...