Plugin Support
Fernando a11n
(@fhaps)
Automattic Happiness Engineer
@rikidev From your description, it sounds like you are looking to generate a report that would list all customers, along with the names of products they have purchased in their lifetime, as well as the product prices.
A report like this is not available in WooCommerce out of the box.
Out of the box you can get a report of your customers (WooCommerce > Customers). That report will include their name, email, number of orders placed on the site, and total spend. It will not include a list of product names and prices.
What you described is likely something you will have to build yourself, after exporting data from the site. Using an extension like WooCommerce Customer / Order / Coupon Export, you would generate an export of all your order data. Then you can filter those orders by customer, and generate the report in the format you mentioned.
Thanks @fhaps,
It seems increasingly like this is the only option, I was trying to avoid the manual update and spit out the table/array automatically.
The standard reports get close but no cigar!! 🙂
It might also be worthwhile taking a closer look at https://wordpress.org/plugins/smart-manager-for-wp-e-commerce/. It’s typically used for bulk updating using a spreadsheet-like view in the admin area but would work equally well for generating custom reports as well 🙂
Plugin Support
Fernando a11n
(@fhaps)
Automattic Happiness Engineer
We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.
