HomeHome Product Discus... Product Discus...SmithCartSmithCartError editing variant copied from another productError editing variant copied from another product
Previous
 
Next
New Post
3/21/2012 2:50 PM
 

 

Receiving the following error after copying a variant to another product, then tried to edit it. Get kicked out to the catalog with this message:
'rblDDImageOptions' has a SelectedValue which is invalid because it does not exist in the list of items. Parameter name: value. 
 
Thoughts?
 
 
 
New Post
3/21/2012 3:36 PM
 

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!
 
 

Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartError editing variant copied from another productError editing variant copied from another product