Cleaning up product database

[mcewan7]

I have probably 1,000 + products in an actinic site and a lot of them are the same product entered two or three times (some times more). I want to clean this up by creating a correct product duplicate for each item that needs to appear in more than one section.

Has anyone got any tips or advice on the best way to approach this?

[leehack]

Put the originals of your 'to be' duplicated products in a folder of their own and eventually have this hidden on your website. Then proceed logically through your folders, deleting the copies of products and 'pasting as duplicates' from your dedicated duplicate folder. Having the dedicated folder gives you one central place for all products that are duplicated.

Oh and get a flask and a comfy chair and don't try and do it all at once.

[Duncan Rounding]

....and backup and compact regularly on the way...

[mcewan7]

Thanks Lee, hadn't thought of that, thats certainly a better way than I was planning to do it! I'm so glad I posted this now.

Right, I'm off to get started

[leehack]

Pleasure Leon, don't forget Duncan's advice too, every half hour IMO you want to be doing that.