How to Preserve Product IDs and Import WooCommerce Customers, Orders, and Subscr

  • Resolved guevara93

    (@guevara93)


    2 months, 2 weeks ago

    I’m redesigning an old WordPress website that uses Flatsome Builder and WooCommerce. The new website is being built using Sage 10 and ACF Pro.

    I need to:

    1. Preserve product IDs: These IDs are critical because subscriptions, orders, and external references (e.g., Google Merchant Center) rely on them.
    2. Import all WooCommerce data: This includes customers, orders, and subscriptions, ensuring continuity without breaking functionality on the new server.

    Some constraints:

    • The old and new websites will be hosted on different servers.
    • The old site is live, so minimizing downtime is important.
    • I’m already comfortable with PHP, WordPress development, and database operations.

    I’ve considered using WooCommerce’s built-in import/export tools or plugins like WP All Export/Import, but I’m not sure if they will handle the subscriptions and preserve product IDs properly.

    What would be the best approach to achieve this migration without breaking product references and maintaining all WooCommerce data integrity?

    I would appreciate detailed steps or recommendations on plugins, database migration, or other tools that can make this process efficient.

Viewing 1 replies (of 1 total)
  • Plugin Support Jonayed (woo-hc)

    (@jonayedhosen)

    Hi @guevara93 ,

    I get that migrating your WooCommerce store to a new server can feel a bit daunting, especially when you want to make sure product IDs, customer data, orders, and subscriptions all stay intact.

    About your question:

    I’ve considered using WooCommerce’s built-in import/export tools or plugins like WP All Export/Import, but I’m not sure if they will handle the subscriptions and preserve product IDs properly.

    The built-in import/export tools and WP All Export/Import are great for many use cases, but they might not fully support exporting subscription data in the way you need. In this case, you might want to explore other options.

    Here are two ways you can approach this:

    1. Direct Database Migration: This keeps everything, including product IDs, exactly as they are. It’s a precise method but requires extra care to avoid any data corruption. If you’re comfortable with databases or working with a developer, this could work well.
    2. Using a Specialized Plugin: A plugin designed for migrations can make the whole process smoother. For example, the Import Export Suite for WooCommerce can handle everything—products, reviews, categories, customers, orders, coupons, and subscriptions. It’s a solid all-in-one solution for migrations like this.

    WooCommerce offers a 30-day refund policy, so you can test the extensions and make sure they meet your needs. If you have any questions before purchasing, you can reach out to us at WooCommerce.com → My Account → Support (you’ll just need to create an account if you don’t already have one).

    I hope this clears things up! Let me know if you have more questions or need help getting started.

Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.