Yeah, this is the last option for me because it will took long time...... depend on the number of products that I have.
But the important thing is, why this happened and what should I do to fix it, you can imagine if I have more than 100 products like this, it will cause a head ache ...