OK.. so i just deleted the entire catalog and re-imported with the weight value set as 1 and the product type simple and that solved my problem. thanks for all your assistance.
@shackbill
Fantastic. I am glad I could help.
Please accept my answer as a Solution so other people may benefit from the same too.
Thanks
