Including customer database row id with orders export.

[davdg75]

When I export my orders by going to 'Settings' -> 'Data Management' -> 'Export Orders to Flat File' I want to include the customer database row id with every order row in the order export. This way I can group orders together even if the customer has changed their info. Is there a way to include this data with the order export?

[Bruce - PhosphorMedia]

Not natively. What is your end goal here. Perhaps there is a different way to get what you need.

[davdg75]

The goal is to analyze customer behavior with third party tools by uploading a csv file of orders. We want to link orders together based on customer account because username/Name/email/address can change but the database id is constant.

[Bruce - PhosphorMedia]

if you don't need order details (items) you could use the Order Processing batch view. Use the '+' menu (on far right) to select the fields you want to export. View all orders (or data range) and then select all records (top heading checkbox). Once you do that, use the kabob/rat droppings menu to select Export to CSV.

otherwise, you need to create a custom export module.

[Nick]

Exporting the customer ID is not a native feature within the admin, under data management or the batch list.

There is a module on the APP store that will consolidate the customer accounts based on the criteria that you define: https://apps.miva.com/match-customer-orders.html

You may want to take a look at the module then do the normal export and combine customers based on the criteria you select.

Otherwise the best option would be to create a custom batch report that used template code to pull in the customer ID value.

https://docs.miva.com/dev-videos/batch_reports
Example of a custom batch report that pulls in coupon data: https://docs.miva.com/code-samples/coupon-batch-report

[Bruce - PhosphorMedia]

oh, damn, that's right nick. forgot about batch reports. to me, that sounds like the path you need. we use these a lot for all kinds of reports and also use this handy jQuery plug in to convert the created table into a csv:

https://github.com/rainabba/jquery-table2excel

(though there are many to choose from)