Merge two 1.6 shops into one 1.7

['Woger]

Hi there,

 

I need to merge two v1.6 shops into a new v1.7 shop. I need to transfer the products, categories, users and orders. What is the best way to do this? Which addons can I use? I presume a export-merge-import solution is the best way to go.

 

Thanks,

Roger

[shokinro]

I agree import related products/others/customer info from 1.6x to 1.7x is a good solution. there should be some existing modules available for normal import.

But since it is a merge, it is not same as normal import with all data from 1.6x to empty 1.7x. there will some additional requirements. so I guess it is better to hire someone to help you if you are not very confident to do this by your own.

['Woger]

Yes,

But that's why I mean with export-merge-import . If I can export the info to a csv file, I can manual change the csv file to be compatible with 1.7.
I just need a good addon in 1.6 to export this data to a csv.

[tuk66]

Merging two shops means you have to change many many ID values in the database. It is not so easy as it looks. An expert is surely needed.

['Woger]

Why?

If I can export it without ID's or remove the ID's from the csv file, I can import them and they get automatically an ID. Or am I wrong? 

[tuk66]

You want to import orders. The IDs are everywhere and you can't simply merge two products with id_product = 1 from two shops without changing the IDs in one shop. Many IDs, not just id_product.

['Woger]

Ah, yes, offcourse.

And if I drop the need for orders, so just products,categories and users. Would that work?

 

Thanks,

Roger

[tuk66]

I think so. Through CSV import.