Detached order and customer ID

Resolved dev
(@devksec)

4 years, 6 months ago

Hello,

We’ve just restored from a backup (part of a split between a multisite and standalone). This has caused all of our store orders to become detached from users accounts. https://wordpress.org/support/topic/various-issues-with-migration/

When viewing any order, the customer is (#0 -). You can manually re-assign the order however.

Is there an SQL query or PHP script we can use to automatic repairing these?

Many Thanks

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

Igor H
(@ihereira)

4 years, 6 months ago

Hello,

This seems to be related to the plugin: Migrate WordPress Website & Backups – Prime Mover. Is this correct?

If there is a backup of the orders before the migration, it is possible to recover them.

Since the same question is on both forum threads, I’ll mark this as resolved and will keep the other one open (so that anyone is able to chime in to help you out), in accordance with our forum policies.

Thank you.

Thread Starter dev
(@devksec)

4 years, 6 months ago

The orders, customers and users exist however the relation between the customer within the orders is broken.

We have a backup and live site running. What can we do to restore them ?

Thanks

Margaret S. woo-hc
(@margaretwporg)

4 years, 6 months ago

Hi @devksec

As this thread is closed, can you kindly post the comment on the other thread? That’ll be helpful to keep threads organized.

Thanks

Thread Starter dev
(@devksec)

4 years, 6 months ago

Can this be re-opened and I’ll update the other thread.

This is best dealt with here.

Margaret S. woo-hc
(@margaretwporg)

4 years, 6 months ago

Hi @devksec

This thread has been reopened. You can post any additional updates here.

Thanks

Thread Starter dev
(@devksec)

4 years, 6 months ago

Thank you, it looks like it could of been caused by the user IDs changing.

I need a way to re-assign the customer order based on the email used for the order or similar. Re-importing doesn’t fix the issue either.

With thousands of orders it is not feasible to do manually.

Appreciate any help here.

MayKato
(@maykato)

4 years, 6 months ago

Hi @devksec

I need a way to re-assign the customer order based on the email used for the order or similar. Re-importing doesn’t fix the issue either.

It looks like you are getting replies on the other thread too, but as an alternate solution, you can use another plugin to export customers including their IDs from your old site and import them to the new site:

https://wordpress.org/plugins/users-customers-import-export-for-wp-woocommerce/
https://www.webtoffee.com/how-to-do-a-woocommerce-customers-and-customer-orders-export-successfully/

Margaret S. woo-hc
(@margaretwporg)

4 years, 6 months ago

We’ve not heard back from you in a while, so I’m marking this thread as resolved. Hopefully, the above info was helpful.

If you have further questions, please feel free to open a new topic.

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

The topic ‘Detached order and customer ID’ is closed to new replies.