Hi Kim,
Using Sql Server Management Studio (SSMS) please update the following stored procedure. Don't forget to change the objectqualifier highlighted in yellow below to the object qualifier you use in your database.
ALTER PROCEDURE [dbo].[dnn_Smith_CopyProductVariant]
@ProductID INT, @VariantGroup VARCHAR(50)
AS
INSERT dnn_Smith_ProductVariant
(ProductID,VariantGroup,VariantName,VariantDisplayType,VariantImage,VariantZoomImage,VariantIconImage,PriceAdjustment,WeightAdjustment,SortOrder,PortalId,
VariantRequired, VariantGroupID, Sku, QtyOnHand, ConditionalGroupID, DropDownImageOption, IconImageOption, RenderTextInImage )
SELECT @ProductID as 'ProductID', VariantGroup,VariantName,VariantDisplayType,VariantImage,VariantZoomImage,VariantIconImage,PriceAdjustment,WeightAdjustment,SortOrder,PortalId,
VariantRequired, VariantGroupID, Sku, QtyOnHand, ConditionalGroupID, DropDownImageOption, IconImageOption, RenderTextInImage
FROM dnn_Smith_ProductVariant
where variantid = @VariantGroup
The hotfix for the copy variant function will be available in the next cart release next week. Thanks for reporting the issue!