Export customer data / sales reports for woocommerce
Ability to export customer info, specifically for email marketing purposes. Also ability to export reports into CSV to import into financial management software.
waveminded
shared this idea
-
Edward A. Sanchez
commented
Can we expect some sort of answer from the Woo team? This is important to us. This sort of lack of activity on your part doesn't instill faith in your SINCERE dedication to your clients' requests. There ARE other teams who do answer.
-
Anonymous commented
Definitely not a "completed" solution : /
Exports are downloaded as "Unknown" so forget about getting through a bunch of reports quickly, There is no detailed information on specific item quantities, or variations.As much as I love WooCommerce its Reporting still leaves a lot to be desired.
-
Anonymous
commented
This should not be marked complete. It's 2014 and the export is still useless. $79 and useless. Why isn't there an option to limit exports to groups or products?
-
Graham Davis
commented
There should be an "UnComplete button"? This issue was raised here in 2011 as well as in other posts and there hasn't been a satisfactory resolution.
Like others I am loath to pay for a plugin that appears to be so poorly regarded the functions of which should be in the WooCom core.
-
Carla
commented
I want this too!!!
-
Angie
commented
I would argue this is not completed and that the reporting in WooCommerce is not quite where it needs to be. I also do class registration and the ability to run a report by customer or by product and get a list of customers for that product would be hugely helpful. It's a little strange it's not there.
-
Dave
commented
<?php
//connect to database
$con = mysql_connect("localhost","Test","edwdedwd");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}//selects the Wordpress DB
mysql_select_db("wordpress", $con);
//now selects all data in the table wp_postmeta where the word billing is within the value
$result = mysql_query("SELECT * FROM wp_postmeta WHERE meta_key LIKE '%billing%' ");while($row = mysql_fetch_array($result))
{
//prints the results in a basic table for each row that was retrieved
echo $row['meta_value'] ;
echo "<br />";
}?>
-
Dave
commented
Hi guys,
I have been looking for this as well and am in the process of writing my own PHP script to pull the data from the MySQL DB. So under a standard install the data is held under the wordpress DB in a table called wp_postmeta. You can do s earch under the meta_key column and anything with the prefix billing or shipping will be the order details of the user. Each sale goes through as a Post ID as well so you can gain the value, product SKU etc of that individual order.
Right now to write the PHP which will take me an age as this is the first time i have used SQL & PHP manually!
-
Acqua
commented
This shouldn't be marked complete. Here is why:
The export to csv extension is practically useless. It doesn't include product SKUs, and bulks all individual items and quantities for an order all in one cell! That's just silly, and a complete waste of time.
What we really need is an export that shows all order data in their own respective columns, including sku, quantity, variation selections, and shipping details. That way we can sort by each of these data points, and generate our own reports, charts, etc in excel.
-
Ben Boyle.
commented
Does anyone have any examples of the output from this plugin? Loathe to spend the money on something without seeing at least SOME examples of what comes out the other end...
-
Will Wilson
commented
Just purchased this extension although am very surprised that it is not included as standard, seems that you guys have spent such much time on stupid payment gateways that you have overlooked basic commerce requirements such as reporting and exporting data! Paid $30 for this and it doesn't even show on an order line what the order was for??
-
ilari
commented
You can always ask the Woo Team on the pricing.
-
Anonymous
commented
and its 30 bucks. A bit steep? You can get an entire theme for that.
-
ilari
commented
This is now available here http://www.woothemes.com/extension/order-customer-csv-expor/
-
RichP commented
I'm not sure how exactly to go about this, but the sales/order data must be existing in a MySql table right? If true, then we could probably write a MySql query with a date, customer or order # filter to get this info out. I will post this in the support forum and see if they can give us the table & fields and get us going in the right direction.
-
gchinola
commented
i really just want to be able to export the orders. we do class registration and it would be nice to be able to export those orders into a csv so i can prepare a class list. ctrl-c ctrl-v sucks.