Title: Export/Import Woocommerce Orders Last modified: August 31, 2016 --- # Export/Import Woocommerce Orders * Resolved [crobley](https://wordpress.org/support/users/crobley/) * (@crobley) * [10 years, 2 months ago](https://wordpress.org/support/topic/exportimport-woocommerce-orders/) * So I created a new WooCommerce website and before making the switch from the old site I went to export my order information from the old site, only to discover this apparently isn’t a simple task? * It seems like there are only paid plugins all rated very average. * I dont understand how this isn’t some sort of easy process to export a ccv and import it into the new store? Woothemes has an exporter for $79…and then you have to buy an importer for $79. This is just nuts. * Are there any other solutions here? * [https://wordpress.org/plugins/woocommerce/](https://wordpress.org/plugins/woocommerce/) Viewing 14 replies - 1 through 14 (of 14 total) * Plugin Contributor [Mike Jolley](https://wordpress.org/support/users/mikejolley/) * (@mikejolley) * [10 years, 2 months ago](https://wordpress.org/support/topic/exportimport-woocommerce-orders/#post-7360160) * It’s complex because Order IDs (post ids) will change after importing them into another install. * To keep order numbers the same, the WP database should be migrated instead. * Thread Starter [crobley](https://wordpress.org/support/users/crobley/) * (@crobley) * [10 years, 2 months ago](https://wordpress.org/support/topic/exportimport-woocommerce-orders/#post-7360209) * Thanks Mike, So, let me ask you – I was able to export the orders from the old site as an excel doc. Is there any ability to import that information into WooCommerce via a plugin? * Plugin Contributor [Mike Jolley](https://wordpress.org/support/users/mikejolley/) * (@mikejolley) * [10 years, 2 months ago](https://wordpress.org/support/topic/exportimport-woocommerce-orders/#post-7360211) * Yes, using ant of the ‘average’ options you’ve investigated 😉 But as I say, the order IDs might change post-import. * To keep IDs intact and if you’re just moving hosts for example, use [https://wordpress.org/plugins/wp-migrate-db/](https://wordpress.org/plugins/wp-migrate-db/) It’s the easiest option. * Thread Starter [crobley](https://wordpress.org/support/users/crobley/) * (@crobley) * [10 years, 2 months ago](https://wordpress.org/support/topic/exportimport-woocommerce-orders/#post-7360212) * Thanks so much for the help. It looks like if I do this it will completely replace my current new database with the old sites database, is that correct? So not only would it add the orders but it would also include all content such as pages/ posts etc. Is that right? * Plugin Contributor [Mike Jolley](https://wordpress.org/support/users/mikejolley/) * (@mikejolley) * [10 years, 2 months ago](https://wordpress.org/support/topic/exportimport-woocommerce-orders/#post-7360213) * Yes thats correct. This avoids conflicts with Post IDs too, since orders, posts, pages, products, all share the same IDs. * Thread Starter [crobley](https://wordpress.org/support/users/crobley/) * (@crobley) * [10 years, 2 months ago](https://wordpress.org/support/topic/exportimport-woocommerce-orders/#post-7360216) * Ahhhh so this is something I SHOULD have done at the beginning. Since I already have repopulated the new site with new content/pages/posts as well as WooCommerce products this is probably not an option anymore unless I want to overwrite everything. * Mmmmmmm so I guess then the only option is to do a paid plugin to export the orders from the old site and then a separate plugin to import them into the new site huh? * Plugin Contributor [Mike Jolley](https://wordpress.org/support/users/mikejolley/) * (@mikejolley) * [10 years, 2 months ago](https://wordpress.org/support/topic/exportimport-woocommerce-orders/#post-7360217) * Thats one option. Are you moving hosts or just setting up a 2nd install? * Thread Starter [crobley](https://wordpress.org/support/users/crobley/) * (@crobley) * [10 years, 2 months ago](https://wordpress.org/support/topic/exportimport-woocommerce-orders/#post-7360220) * New host. Moving from Dreamhost to GoDaddy. * Plugin Contributor [Mike Jolley](https://wordpress.org/support/users/mikejolley/) * (@mikejolley) * [10 years, 2 months ago](https://wordpress.org/support/topic/exportimport-woocommerce-orders/#post-7360258) * Then you could instead look into exporting your ‘new’ content, moving the DB across, then importing your ‘new’ content and removing anything old you no longer need. Then you keep orders + IDs intact. * Thread Starter [crobley](https://wordpress.org/support/users/crobley/) * (@crobley) * [10 years, 2 months ago](https://wordpress.org/support/topic/exportimport-woocommerce-orders/#post-7360275) * OK so just to make sure I understand. Export the old site database (which includes everyting including product orders) Import that into the new site (This will all all product orders back as well as pages/posts/ which will be a lot of duplicates I will then manually delete). * Is that about right? Dude, seriously thank you so much for the help! * Plugin Contributor [Mike Jolley](https://wordpress.org/support/users/mikejolley/) * (@mikejolley) * [10 years, 2 months ago](https://wordpress.org/support/topic/exportimport-woocommerce-orders/#post-7360281) * Actually I was thinking * 1. Export from new site to backup your content 2. Move the DB from old to new( this will replace any new content) 3. Import the new content * Then replace duplicates. * Thread Starter [crobley](https://wordpress.org/support/users/crobley/) * (@crobley) * [10 years, 2 months ago](https://wordpress.org/support/topic/exportimport-woocommerce-orders/#post-7360283) * OK good thinking. * So then last question, what exactly would this plugin offer that is $200. [Product CSV Import Suite](https://www.woothemes.com/products/product-csv-import-suite/) * Would it basically just take care of all this without me having to worry about duplicating things on the database? * Plugin Contributor [Mike Jolley](https://wordpress.org/support/users/mikejolley/) * (@mikejolley) * [10 years, 2 months ago](https://wordpress.org/support/topic/exportimport-woocommerce-orders/#post-7360292) * Thats for importing just products. It can do merges and new imports. I think in this case you can just use Tools > Export and Tools > Import, then remove duplicates. Down to you. * Thread Starter [crobley](https://wordpress.org/support/users/crobley/) * (@crobley) * [10 years, 2 months ago](https://wordpress.org/support/topic/exportimport-woocommerce-orders/#post-7360294) * You rock Mike, Thanks so much for the help! Viewing 14 replies - 1 through 14 (of 14 total) The topic ‘Export/Import Woocommerce Orders’ is closed to new replies. * ![](https://ps.w.org/woocommerce/assets/icon.svg?rev=3234504) * [WooCommerce](https://wordpress.org/plugins/woocommerce/) * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce/#faq) * [Support Threads](https://wordpress.org/support/plugin/woocommerce/) * [Active Topics](https://wordpress.org/support/plugin/woocommerce/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce/unresolved/) * [Reviews](https://wordpress.org/support/plugin/woocommerce/reviews/) * 14 replies * 2 participants * Last reply from: [crobley](https://wordpress.org/support/users/crobley/) * Last activity: [10 years, 2 months ago](https://wordpress.org/support/topic/exportimport-woocommerce-orders/#post-7360294) * Status: resolved