We took a copy of the production site 2 months ago and after a vast number of updates we're now ready to deploy it. However, during this time there has been new products, orders, customers added on the production site.
Does anyone know how we can copy all products, orders, and customer data from the production site to the development site without losing the relationship between them all? (I'm assuming we need to keep the product_id in tact)
To make things a bit more difficult, we have various configurable/grouped products which I've recently learned isn't handled by the default Magento import/export.
Any advice greatly appreciated!