Re-Referencing

[FOXY]

I would like to re-order the products in my catalog because i have found that there are gaps in my product refereences is there a simple script that can be run to rereference the products so

231
248
256

would become
1
2
3

so all the gaps are filled in ? i tried altering the products table but then all my choices for the products got deleted :(

[Jan]

The product reference is used as the key for products within the database so it is not a good idea to change it in the database. The only safe way to do this is to edit it in Actinic (you have to switch off autogenerate product references to do this).

Regards,