WooCommerce Data Sync from Remote to LocalHost

Hey Guy’s,

Hope your all well and having a fab day? I have a question that im hoping someone can help with.

Here is my problem.

1 – I have a live Ecommerce website using WordPress and WooCommerce, this site is taking daily orders, and customers are registering too.

2 – I’m working on a new version of the website on my local environment which includes a new theme, and re-arrangement of the categories within the online store.

I believe the website update is going to take a number of weeks to complete, and obviously over this time the DB I have on my local machine will be incredibly out of date compared to the one on the live site. What I mean by this is “Customer Orders, Accounts, etc”.

Is there a plugin or tool I can use that can automatically keep the WooCommerce DB on my local host up to date with the live site? So lets say in two weeks time when the new website goes live, all customer orders, data etc will be current.

Sorry if this seems a really silly question, but ive been racking my brains the last few days with this and haven’t found a solution as of yet! haha

Regards
Tom