This is preserved as a warning! I couldn’t import the orders. I think its because I wanted to keep the ordered after some had been taken. My next attempt is to instill bare minimum plugins and posts.
For far too long my website has been falling over. God knows why. So I’m biting the bullet to rebuild it completely.
But every day or two I have to do a server reboot. I thought it might be AWS Lightsail so moved hosts. Still the same. So I moved it back. debug shows nothing. And there is nothing in server load to hint at a problem. So it can only be some legacy code or datapoint that is triggering a fault. I’m out of ideas. So a rebuild it is. I’m sticking with AWS Lightsail and the design. Some of the content is going to be re-written. Most images will be re-imported. I’m sticking with many of the active plugins, mostly because I use them all on other sites that don’t have the same issue.
- Spin up new WordPress instance. using bitnami on Lightsail. “staging.domain.com” is being used and SSL set up.
- Delete the plugins I don’t want. Add the plugin I need (but not activating yet).
- Activate Woocommerce.
- Amend the settings – including shipping zones
- Add all of products – by hand. My very original site had thousands of variation combinations, and I can’t help but wonder if that is at the root of it all, so woocommerce is a clean set up.
- Now activate the plugins I need.
- Activate Elementor and Elementor Pro
- Use the Hello Fresh theme (perhaps should have done that before Woocommerce, not sure)
- Build templates as I need them – some from the Elementor library, some copied and pasted from my original
- Rebuild the contact forms that I need
- Rebuild pages that I need.
- Make sure that all the relevant plugins are updated
- I took a lightsail snapshot/backup of the staging site. Just in case!
- On the current/live site, Install & activate WP ALL Export Pro (I hate having to pay for these, but it is far too painful to try to do it without a paid for plugin. I wasted days of my life before).
- Install and activate WPAE User Add On & WPAE Woocommerce Add On
- Export Woocommerce Customers (I’m not worried about the old subscribers)
- Export Woocommerce Orders
- Export Woocommerce Coupons (having done a massive clear out) – REMEMBER to select all the fields you need (ID, Name and Expiry isn’t enough!)
- Export posts (set categories)
- Now, on stag install the WP ALL Import plugins (and addons)
- Deep breath and touching wood….
- Import customers first
- I followed the code cust from this original post: http://www.mcgurl.co.uk/2023/09/19/migrating-woocommerce-and-preserving-order-id/
- BEWARE if you’re updating a user with the same creds as you’re logged in with!! create an admin that you can delete later.
THIS DIDN’T WORK. For the life of me I couldn’t get the orders to import. Let’s try again…..