Title: woocommerce sql
Last modified: October 8, 2020

---

# woocommerce sql

 *  Resolved [bostondesignz](https://wordpress.org/support/users/bostondesignz/)
 * (@bostondesignz)
 * [5 years, 7 months ago](https://wordpress.org/support/topic/woocommerce-sql/)
 * I moved a woocommerce site to a new host. I used a plug in to download and upload
   customers and orders. Some of the orders did not migrate. I have access to the
   old database. Is there any way to download the orders and upload them to the 
   new site without screwing up the new site?

Viewing 3 replies - 1 through 3 (of 3 total)

 *  [braehler](https://wordpress.org/support/users/braehler/)
 * (@braehler)
 * [5 years, 7 months ago](https://wordpress.org/support/topic/woocommerce-sql/#post-13511972)
 * [@bostondesignz](https://wordpress.org/support/users/bostondesignz/)
    maybe this
   plugin is helpfull for you [https://woocommerce.com/products/customerorder-csv-import-suite/](https://woocommerce.com/products/customerorder-csv-import-suite/)
 * or you give WP All Import a try
    You´ll need the addons for woocommerce [https://www.wpallimport.com/](https://www.wpallimport.com/)
    -  This reply was modified 5 years, 7 months ago by [braehler](https://wordpress.org/support/users/braehler/).
 *  Plugin Support [Stuart Duff – a11n](https://wordpress.org/support/users/stuartduff/)
 * (@stuartduff)
 * Automattic Happiness Engineer
 * [5 years, 7 months ago](https://wordpress.org/support/topic/woocommerce-sql/#post-13512821)
 * Hey [@bostondesignz](https://wordpress.org/support/users/bostondesignz/),
 * The easiest way to download orders and import those into a new site would be 
   by using a CSV import plugin similar to what [@braehler](https://wordpress.org/support/users/braehler/)
   has recommended.
 *  Thread Starter [bostondesignz](https://wordpress.org/support/users/bostondesignz/)
 * (@bostondesignz)
 * [5 years, 7 months ago](https://wordpress.org/support/topic/woocommerce-sql/#post-13513745)
 * I did this initially. I used a plugin to export all of the orders from the old
   site and imported them to the new site. Apparently, some order numbers were the
   same as post ids, so they were not imported. Is there any way to import them 
   and preserve the numbers? Some customers cannot view their old orders because
   they weren’t imported.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘woocommerce sql’ 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/)

 * 3 replies
 * 3 participants
 * Last reply from: [bostondesignz](https://wordpress.org/support/users/bostondesignz/)
 * Last activity: [5 years, 7 months ago](https://wordpress.org/support/topic/woocommerce-sql/#post-13513745)
 * Status: resolved