Hi Alex,
To delete your variants you would need to issue a sql delete statement on the following tables for the variants you want to delete:
- Smith_ProductVariant
- Smith_ProductVariantGroup
- Smith_ProductVariantInventory
- Smith_ProductVariantInvLinker
The SQL delete statement would look something like this (replace the variantid's with your variantid's):
delete * from smith_productvariant where variantid in (1,2,3,4)
Important: Please make sure you have a full database backup before issuing any delete statements in case you need to rollback.
Hope this helps!