How To Export WooCommerce Orders to Excel, CSV, or XML with WP All Export



hello this is Trey from sofly today I'm going to show you how to export your orders from WooCommerce using WP all export if you go to new export from this drop-down you want to select orders here it will show you the total amount of orders that will be exported you can add filtering options if you need to select the element say you wanted to choose a certain date completed date status let's say that you only wanted to export orders that had been completed so you'll choose status equals WC completed add rule you can see here updates there's only been three orders that were completed you can add more rules if you want I'm going to delete this rule using the little trash can here goes back to five we'll continue to step two in step two this is where you will add elements rearrange elements this is what will being included in your export file you can choose to add fields with this button what would you like to include say order status how would you like to name it this will be in the header status you can go to advanced options here and you can choose to export the value returned by a PHP function put your function name here it'll pass the value in this case it would be the status write your function right here you'd save it hit done over here on the right there's an easy way where you can just drag the elements over as you need them here's order information so we wanted the completed date we already put the status in there currency payment method the order total and like I said you can just click these to change the title if you want here's a customer information we can get the customer user ID billing first name billing last name down here you'll see the shipping information you can collapse these if you want to kind of make it easier to navigate around items here's the item information we'll go and get the Product ID kayuu product name quantity taxes and shipping information get the total tax amounts shipping method things like that fees and discounts say they used a coupon you can add that in there under advanced you'll see more advanced custom fields if you needed to add those to your export over here on the Left you'll see more options you can display each product in its own row or choose not to fill in empty columns you can hover over these for more information on what these options do choose the delimiter for your CSV if you want to change that you can preview the row see here's what your CSV file look like looks good you can export as an XML if you want when you hit preview on an XML you can see it looks like an XML file we'll stick with CSV for this you can save your settings as a template say you want to do a new export later and you want to include all of these elements that you've already added here you'll just click here to load the template that you save so example template just type the name in here when you hit continue it'll save that for you and on the last step you have some advanced settings you can change if you want to only include orders once so if you reran this export and you had this selected then it will only export orders that are new that haven't already been exported so that's pretty handy you can include BOM an export file if you have non-english characters create a new file each time the exports run split it into multiple files let's say you had a ton of orders that you're going to export use this and only include a certain amount of orders per file and then you'll get multiple files and you can choose a friendly name so when you go to manage exports later and you want to find this then this will make it a lot easier to find but my friendly and confirm and run export you'd see the status pretty quick because we only had five orders and then you'll click the blue CSV button to download your CSV file we'll go ahead and do that and see how it looks put it up here it is there's the header you chose and all the information you need looks good complete add a name and if you go over to manage exports here you'll see my friendly name that you chose you can edit the export change the settings if you want to download the file again right there just download the CSV again and you can run it again I think that pretty much covers it that's how you'd export your WooCommerce orders using wpl exporter thank you for watching

7 thoughts on “How To Export WooCommerce Orders to Excel, CSV, or XML with WP All Export

  1. Here is a free plugin that does a better job. https://github.com/lafranceinsoumise/woocommerce-customer-order-csv-export-jlm2017

  2. https://github.com/mithunmanohar/woocommerce-orders-google-sheets-integration check this if you want to export order to google sheets

  3. You should tell people that in order to do this you need to buy the upgrade for items section, product sku, product ID quantity etc. otherwise you really don't get the products purchased without the upgrade, so this video is good but doesn't help if you are only using the free stuff.

  4. The plugin works perfectly apart from that in the description it picks up the website layout code alongside the description (When exporting XML of products)… Any ideas on how to overcome this issue?

Leave a Reply

Your email address will not be published. Required fields are marked *