Title: Importing missing orders after server migration Last modified: August 8, 2024 --- # Importing missing orders after server migration * Resolved [hmschiefer](https://wordpress.org/support/users/hmschiefer/) * (@hmschiefer) * [1 year, 10 months ago](https://wordpress.org/support/topic/importing-missing-orders-after-server-migration/) * We recently migrated servers and a few orders were placed on the “old” server before the DNS got updated. My question is, what is the best method for getting those on the “new” server? Should I go to to the old server, export those orders and then import them? Add them manually? Will this trigger duplicate orders? We use Printful to fulfill orders so I don’t want to trigger a duplicate and have the customer charged again. * System Status Report * ```wp-block-code ### WordPress Environment ### WordPress address (URL): [Redacted] Site address (URL): [Redacted] WC Version: 9.1.4 Legacy REST API Package Version: ✔ 1.0.4 Action Scheduler Version: ✔ 3.7.4 Log Directory Writable: ✔ WP Version: 6.6.1 WP Multisite: – WP Memory Limit: 256 MB WP Debug Mode: – WP Cron: ✔ Language: en_US External object cache: ✔ ### Server Environment ### Server Info: Apache PHP Version: 8.1.29 PHP Post Max Size: 256 MB PHP Time Limit: 60 PHP Max Input Vars: 3000 cURL Version: 7.61.1 OpenSSL/1.1.1k SUHOSIN Installed: – MySQL Version: 10.6.18-MariaDB Max Upload Size: 256 MB Default Timezone is UTC: ✔ fsockopen/cURL: ✔ SoapClient: ✔ DOMDocument: ✔ GZip: ✔ Multibyte String: ✔ Remote Post: ✔ Remote Get: ✔ ### Database ### [REDACTED] ### Post Type Counts ### attachment: 1729 awb_off_canvas: 1 fusion_element: 5 fusion_form: 2 fusion_tb_layout: 8 fusion_tb_section: 12 nav_menu_item: 15 page: 14 product: 94 product_variation: 2406 shop_order: 825 shop_order_refund: 5 wp_font_face: 33 wp_font_family: 12 wp_navigation: 1 ### Security ### Secure connection (HTTPS): ✔ Hide errors from visitors: ✔ ### Active Plugins (17) ### Beautiful and responsive cookie consent: by Beautiful Cookie Banner – 4.3.0 Broken Link Checker: by WPMU DEV – 2.3.0 Facebook for WooCommerce: by Facebook – 3.2.6 Avada Builder: by ThemeFusion – 3.11.9 Avada Core: by ThemeFusion – 5.11.9 Avada Custom Branding: by ThemeFusion – 1.2 Mailchimp for WooCommerce: by Mailchimp – 4.2.1 Meta pixel for WordPress: by Facebook – 3.0.16 Printful Integration for WooCommerce: by Printful – 2.2.10 UpdraftPlus - Backup/Restore: by UpdraftPlus.Com DavidAnderson – 1.24.4 W3 Total Cache: by BoldGrid – 2.7.5 WooCommerce.com Update Manager: by Automattic – 1.0.3 WooCommerce Stripe Gateway: by WooCommerce – 8.5.2 WooCommerce Legacy REST API: by WooCommerce – 1.0.4 WooCommerce: by Automattic – 9.1.4 Wordfence Security: by Wordfence – 7.11.7 Yoast SEO: by Team Yoast – 23.2 ### Inactive Plugins (1) ### LiteSpeed Cache: by LiteSpeed Technologies – 6.3.0.1 ### Dropin Plugins () ### advanced-cache.php: advanced-cache.php object-cache.php: object-cache.php ### Settings ### API Enabled: ✔ Force SSL: ✔ Currency: USD ($) Currency Position: left Thousand Separator: , Decimal Separator: . Number of Decimals: 2 Taxonomies: Product Types: external (external) grouped (grouped) simple (simple) variable (variable) Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog) exclude-from-search (exclude-from-search) featured (featured) outofstock (outofstock) rated-1 (rated-1) rated-2 (rated-2) rated-3 (rated-3) rated-4 (rated-4) rated-5 (rated-5) Connected to WooCommerce.com: ✔ Enforce Approved Product Download Directories: ✔ HPOS feature enabled: ✔ Order datastore: Automattic\WooCommerce\Internal\DataStores\Orders\OrdersTableDataStore HPOS data sync enabled: ✔ ### Logging ### Enabled: ✔ Handler: Automattic\WooCommerce\Internal\Admin\Logging\LogHandlerFileV2 Retention period: 30 days Level threshold: – Log directory size: 13 MB ### WC Pages ### Shop base: #5192 - /shop/ Cart: #5193 - /cart/ - Contains the woocommerce/cart block Checkout: ❌ Page does not contain the [woocommerce_checkout] shortcode or the woocommerce/checkout block. My account: #5195 - /my-account/ Terms and conditions: #5196 - /refund_returns/ ### Theme ### Name: Avada Child Version: 1.0.0 Author URL: https://theme-fusion.com Child Theme: ✔ Parent Theme Name: Avada Parent Theme Version: 7.11.9 Parent Theme Author URL: https://themeforest.net/user/ThemeFusion WooCommerce Support: ✔ ### Templates ### Overrides: Avada/woocommerce/cart/cart.php Avada/woocommerce/checkout/form-pay.php Avada/woocommerce/checkout/review-order.php Avada/woocommerce/single-product/short-description.php Avada/woocommerce/single-product/tabs/additional-information.php Avada/woocommerce/single-product/tabs/description.php ### Admin ### Enabled Features: activity-panels analytics product-block-editor coupons core-profiler customize-store customer-effort-score-tracks import-products-task experimental-fashion-sample-products shipping-smart-defaults shipping-setting-tour homescreen marketing mobile-app-banner navigation onboarding onboarding-tasks product-custom-fields remote-inbox-notifications remote-free-extensions payment-gateway-suggestions shipping-label-banner subscriptions store-alerts transient-notices woo-mobile-welcome wc-pay-promotion wc-pay-welcome-page launch-your-store Disabled Features: experimental-blocks minified-js pattern-toolkit-full-composability product-pre-publish-modal printful settings async-product-editor-category-field product-editor-template-system Daily Cron: ✔ Next scheduled: 2024-08-08 13:54:03 -04:00 Options: ✔ Notes: 69 Onboarding: completed ### Action Scheduler ### Canceled: 88 Oldest: 2024-07-09 14:34:02 +0000 Newest: 2024-08-08 02:12:41 +0000 Complete: 16,375 Oldest: 2024-07-08 13:37:11 +0000 Newest: 2024-08-08 13:31:07 +0000 Failed: 10 Oldest: 2024-05-30 13:57:44 +0000 Newest: 2024-08-06 13:35:07 +0000 Pending: 3 Oldest: 2024-08-08 13:32:07 +0000 Newest: 2024-08-09 02:24:45 +0000 ### Status report information ### Generated at: 2024-08-08 09:31:39 -04:00 ``` * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fimporting-missing-orders-after-server-migration%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 12 replies - 1 through 12 (of 12 total) * [Stef](https://wordpress.org/support/users/serafinnyc/) * (@serafinnyc) * [1 year, 10 months ago](https://wordpress.org/support/topic/importing-missing-orders-after-server-migration/#post-17941384) * Hello [@hmschiefer](https://wordpress.org/support/users/hmschiefer/) do you have the ability to wipe the database on the new server and then import a copy from the old server? If so, that’s the fastest and best way to go about this. * Thread Starter [hmschiefer](https://wordpress.org/support/users/hmschiefer/) * (@hmschiefer) * [1 year, 10 months ago](https://wordpress.org/support/topic/importing-missing-orders-after-server-migration/#post-17941437) * We would be missing a couple hundred orders that have come in since then. * [Stef](https://wordpress.org/support/users/serafinnyc/) * (@serafinnyc) * [1 year, 10 months ago](https://wordpress.org/support/topic/importing-missing-orders-after-server-migration/#post-17941467) * [@hmschiefer](https://wordpress.org/support/users/hmschiefer/) let me ask you again, do you have the ability yourself to wipe the database and import it again? * Thread Starter [hmschiefer](https://wordpress.org/support/users/hmschiefer/) * (@hmschiefer) * [1 year, 10 months ago](https://wordpress.org/support/topic/importing-missing-orders-after-server-migration/#post-17941498) * I do … * [Stef](https://wordpress.org/support/users/serafinnyc/) * (@serafinnyc) * [1 year, 10 months ago](https://wordpress.org/support/topic/importing-missing-orders-after-server-migration/#post-17941509) * Then that’s what I would do. Export the sql from the old server. Drop the sql in the new import. Then reimport the sql again and rewrite the urls if you have to, not sure if you would. Just saying. Should only take 5 mins at the most. - This reply was modified 1 year, 10 months ago by [Stef](https://wordpress.org/support/users/serafinnyc/). * Thread Starter [hmschiefer](https://wordpress.org/support/users/hmschiefer/) * (@hmschiefer) * [1 year, 10 months ago](https://wordpress.org/support/topic/importing-missing-orders-after-server-migration/#post-17941545) * Am I missing something or wouldn’t this not include any of the 200+ orders we’ve received since the migration? * [carolm29 (woo-hc)](https://wordpress.org/support/users/carolm29/) * (@carolm29) * [1 year, 10 months ago](https://wordpress.org/support/topic/importing-missing-orders-after-server-migration/#post-17941734) * Hey there, [@hmschiefer](https://wordpress.org/support/users/hmschiefer/)! Thanks for contacting us. I’m happy to help you. * How many orders are missing? * You mentioned Printiful. Were all the missing orders Printiful products? * Looking forward to your reply. * Have a wonderful day! * [Stef](https://wordpress.org/support/users/serafinnyc/) * (@serafinnyc) * [1 year, 10 months ago](https://wordpress.org/support/topic/importing-missing-orders-after-server-migration/#post-17942059) * Sorry for misunderstanding [@hmschiefer](https://wordpress.org/support/users/hmschiefer/) I was under the impression that you had just done this and that the site wasn’t live yet. * If that’s the case then you will need an app like [https://wordpress.org/plugins/order-import-export-for-woocommerce/](https://wordpress.org/plugins/order-import-export-for-woocommerce/) * Hopefully you have the old server instance accessible with an IP or two domain name * Thread Starter [hmschiefer](https://wordpress.org/support/users/hmschiefer/) * (@hmschiefer) * [1 year, 10 months ago](https://wordpress.org/support/topic/importing-missing-orders-after-server-migration/#post-17943817) * [@carolm29](https://wordpress.org/support/users/carolm29/) Thanks for your help. I think it’s about 14 orders. Yes, they are all Printful. They went through Printful because the old server was still live, but they are just missing from the WooCommerce orders on the new server. I don’t want to duplicate Printful orders or charges to customers obviously. * [carolm29 (woo-hc)](https://wordpress.org/support/users/carolm29/) * (@carolm29) * [1 year, 10 months ago](https://wordpress.org/support/topic/importing-missing-orders-after-server-migration/#post-17944056) * Hey, [@hmschiefer](https://wordpress.org/support/users/hmschiefer/)! * Since there are not a lot of orders, if they were regular WooCommerce orders/ products, I would suggest adding them manually to avoid any issues, since you would have control over how it was set up. * However, since they were done through Printiful, I recommend checking with them how their support thinks it is best to do this to make sure nothing gets duplicated. 🙂 * Please reach out to them and let us know if there’s anything else we can do to help. * Have a wonderful day! * Thread Starter [hmschiefer](https://wordpress.org/support/users/hmschiefer/) * (@hmschiefer) * [1 year, 10 months ago](https://wordpress.org/support/topic/importing-missing-orders-after-server-migration/#post-17947685) * [@carolm29](https://wordpress.org/support/users/carolm29/) I’ll check with them. Thank you! * [ckadenge (woo-hc)](https://wordpress.org/support/users/ckadenge/) * (@ckadenge) * [1 year, 10 months ago](https://wordpress.org/support/topic/importing-missing-orders-after-server-migration/#post-17948435) * Hi [@hmschiefer](https://wordpress.org/support/users/hmschiefer/), * > I’ll check with them. Thank you! * Sounds like a plan. Please keep us updated on how it goes. * All the best. Viewing 12 replies - 1 through 12 (of 12 total) The topic ‘Importing missing orders after server migration’ 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/) ## Tags * [export](https://wordpress.org/support/topic-tag/export/) * [Import](https://wordpress.org/support/topic-tag/import/) * [missing orders](https://wordpress.org/support/topic-tag/missing-orders/) * 12 replies * 4 participants * Last reply from: [ckadenge (woo-hc)](https://wordpress.org/support/users/ckadenge/) * Last activity: [1 year, 10 months ago](https://wordpress.org/support/topic/importing-missing-orders-after-server-migration/#post-17948435) * Status: resolved