is there any way to mass delete all duplicate products

[maccamason]

any help would be appreciated

thanks

[NormanRouxel]

Untested so only try this on a copy of the site.

The following should move all duplicates into an empty Section where you can then select all and delete.

Create a new dummy Section and put one dummy product into it. Close Actinic.

Now open ActinicCatalog.mdb in Access.

Look in the Products table for the dummy product. Note it's nParentSectionID value.

Now run an Update Query that puts that value into the nParentSectionID field of all products where the Product Reference field contains an exclamation mark (!).

Close Access and restart Actinic. All your Duplicates should now be in the dummy section.

[maccamason]

Untested so only try this on a copy of the site.

The following should move all duplicates into an empty Section where you can then select all and delete.

Create a new dummy Section and put one dummy product into it. Close Actinic.

Now open ActinicCatalog.mdb in Access.

Look in the Products table for the dummy product. Note it's nParentSectionID value.

Now run an Update Query that puts that value into the nParentSectionID field of all products where the Product Reference field contains an exclamation mark (!).

Close Access and restart Actinic. All your Duplicates should now be in the dummy section.

thanks very much Norman

[NormanRouxel]

I've now tried it and it seemed to work OK here. Still best to backup first.

[leehack]

Nice one Norm, gotta love lateral thinking like that.

[Darren B]

Nice one, i'll have to try and remember that,

D