Merging two sites

[Jo@apartyshop]

I've got two v11 Actinic sites and want to merge the products of one into the other but there will be 200-400 products that have the same product refs on each site.

Any thoughts on the best way to go about this task?

[NormanRouxel]

One way (untested). Export source site to a Hierarchical file (File / Export). In the text file that you create, use a text editor to replace all

Product,"

with:

Product,"X-

And if you import the new file into the other site, all product ref's will have an X- prefix.

Another way is to load the exported file in Excel and manipulate it there.

[Jo@apartyshop]

Thank you Norman. I followed your first example and thought all had gone well until I imported the text file and no products were imported and received the following errors;

Line 36: An invalid Product could not be imported.

Line 36: The 'V4 Tax 1 Opaque Data' field contains an invalid value(101=2000.00=0=). Valid values for your current tax settings are '0=0=nnnn=', '1=0=nnnn=', '6=0=nnnn=' or '301=2000=nnnn=' where 'nnnn' is the custom tax in lowest currency units. This value is ignored unless 'Custom Tax'(6=0=nnnn=) has been specified.

Line 37: An invalid Product could not be imported.

Line 37: The 'V4 Tax 1 Opaque Data' field contains an invalid value(101=2000.00=0=). Valid values for your current tax settings are '0=0=nnnn=', '1=0=nnnn=', '6=0=nnnn=' or '301=2000=nnnn=' where 'nnnn' is the custom tax in lowest currency units. This value is ignored unless 'Custom Tax'(6=0=nnnn=) has been specified.

Do you or anyone else know how I can correct my file of these errors?

I've had a good search but cannot find a solution so i'm assuming the fix is glaringly obvious

[JGLIGHTING]

Hi

Not sure if i am right or wrong. But i think you have to make sure the tax setting are the same as your new site before you do the export and then the import.

[Jo@apartyshop]

Perfect Elliott, cheers!

Combined with Norman's solution, the export/import has merged the two sites perfectly