HomeHome Product Discus... Product Discus...SmithCartSmithCartDisappearing Variant PicturesDisappearing Variant Pictures
Previous
 
Next
New Post
6/3/2010 11:44 AM
 

I added pictures to show the color variants for the products. I uploaded and saved. Everything looked good. I went back to edit the same variant because I decided to change the name a little bit. The name of the picture did not show up in the edit screen. I did not enter an upload name after I edited the variant name because I uploaded the picture earlier in the day. The picture disappeared after i saved. I can't have the picture disappear when I edit a variant name because the PC that's editing the name might not be the one that has the picture to reload. Please help. Thank you.

 
New Post
6/3/2010 3:12 PM
 

If you open up the stored procedure titled "Smith_UpdateProductVariant" and replace the following line:

VariantImage = @VariantImage,

with this one:

VariantImage = ISNULL(@VariantImage, VariantImage),

It will fix the issue you reported. We have this coded for all the product images but didnt have it for the variant image. We have updated this in the production build and will be availible when 2.92 is released. Thanks for reporting it!

-Scott


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
6/7/2010 1:07 PM
 

I waited until you put out 2.92 and upgraded today. The picture value still disappears. I'm updating variants through the SQL Server management studio in the meantime.

 
New Post
6/7/2010 1:14 PM
 

Can you check the stored procedure titled "Smith_UpdateProductVariant" to see if you have this line:

VariantImage = ISNULL(@VariantImage, VariantImage),


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
6/7/2010 1:21 PM
 

That line is not there although the script date is 6/7/2010. Here is the stored procedure:

I was expecting the upgrade to change the file for me. I executed the update procedure after modifying it. It now works.

[DNNSpace] ANSI_NULLS ON QUOTED_IDENTIFIER ON PROCEDURE [dbo].[DNN_Smith_UpdateProductVariant]INT, @VariantGroup VARCHAR(50), @VariantName VARCHAR(50),@VariantDisplayType VARCHAR(50),

@VariantImage

BEGIN

Update

nvarchar(500), @PriceAdjustment Money, @WeightAdjustment FLOAT, @SortOrder INT, @PortalId INT, @VariantID INT, @VariantRequired bit AS DNN_Smith_ProductVariantSET ProductID = @ProductID,

VariantGroup

= @VariantGroup,

VariantName

= @VariantName,

VariantDisplayType

VariantImage

PriceAdjustment

= @VariantDisplayType, = @VariantImage, = @PriceAdjustment,

WeightAdjustment

= @WeightAdjustment,

SortOrder

= @SortOrder,

PortalId

= @PortalId,

VariantRequired

= @VariantRequiredWHERE VariantID = @VariantID

END

GO

USE

/****** Object: StoredProcedure [dbo].[DNN_Smith_UpdateProductVariant] Script Date: 06/07/2010 16:19:05 ******/

SET

GO

SET

GO

ALTER

@ProductID

 
New Post
6/7/2010 1:27 PM
 

In SQL Mgmt Studio can you make the change to the stored procedure "Smith_UpdateProductVariant" and replace the following line:

VariantImage = @VariantImage,

with this one:

VariantImage = ISNULL(@VariantImage, VariantImage),

It will fix the issue you reported.


Scott Kelly
Project Manager
DotNetNuke Consulting, DotNetNuke Store and DNN Ecommerce
 
New Post
6/7/2010 1:43 PM
 

The key here is that you can't just do a save or it tries to put the SQL code on your local hard drive. The key is to click "Execute" which then updates the stored procedure.

 
Previous
 
Next
HomeHome Product Discus... Product Discus...SmithCartSmithCartDisappearing Variant PicturesDisappearing Variant Pictures