I'm trying to clone a product and it's not working. 

I go to Manage Product and click on the clone link for the product. I get a pop-up that asks me for the product name, sku, and price. I fill that in and click Submit and I'm back at the product list with no additional products. I've cleared cache, reset the app pool - nothing. I've got no errors in my event log.

I'm running 5.65 and DNN 7.0.6.

Tom

I just upgraded to 5.68. The Clone function now works - partially. 

I have several variants on my product. The first is a dropdown where the user can select taxable or tax exempt. Tax exempt has a conditional to show the Tax Exempt number variant group which has a text box as its variant. This works fine in my product. When the user selects Tax Exempt, I get a Tax Exempt Number text box on the refresh.

In the cloned product, I get the variants but the conditional variant doesn't work. Selecting the Tax Exempt variant does not cause the Tax Exempt number text box to display. It looks like the problem is due to the fact that the variants don't have any variant groups. The variant groups themselves were cloned but the variants don't look like they can see them. When editing a variant, the variant group dropdown should show a list of all the variant groups. It is empty.

You can see this in the test portal (26) you gave me to investigate my other problem around not being able to get custom page detail templates to work.

I cloned Product 3 to Prod Tom 3 Tom Clone. You can look at the variants for that product and see that they don't have any variant group and no way to select one. 

Update: I was able to get this working on my site by deleting the variant groups and recreating them. Once I did that, I could go back into the variant and assign them to the variant groups (which now appeared in the variant group dropdown). I left the test portal "broken" so you could see the issue.

Tom

Was this issue ever resolved?

We are using Smith Cart 5.68.0 and DNN 07.00.05 (130).

I need to clone a product about 10 times that has about 12 variant groups, and dozens of conditional variant options.

So far when cloning, the variant groups and conditional options are blank.  Recreating every product manually, or even recreating every conditional group manually is going to be a nightmare...

Hi Guys,

I just confirmed with programming that this will be resolved in the next release.

To fix this issue make a backup and run the following SQL scripts:

ALTER PROCEDURE [dbo].[Smith_CopyProduct]
@ProductID INT,
@ModelNumber nvarchar(50),
@ModelName nvarchar(200),
@UnitCost money
AS

---- Copy Product ----
INSERT Smith_Products
(CategoryID, Manufacturer,ModelNumber,ModelName,ProductImage,ThumbnailImage,UnitCost,MemberPrice,QuantityOnHand,Summary,[Description],DownloadUrl,[Featured],[Archived]
,[Weight],[SortOrder],[ExcludeCoupon],[Items],[Share],[TabModuleId],[CreatedByUser],[CreatedDate],[LogicallyDeleted],[Recurring],[SubscriptionInterval],[RecurringOccurances]
,[UrlGUID],[EncryptUrl],[AddDNNRole],[RequireLogin],[UsePriPriceWght],[BundleID],[MasterBundleID],[RoleExpireDays],[TaxExempt],[PortalID],[AffiliateUrl],[RequireCoupon],ShowPDUDF,AutoGUID
,Description2,Description3,Description4,Description5,TabName1,TabName2,TabName3,TabName4,TabName5,HideThumbnail,HidePrice,PriceClass,MinOrderQty,ChargeHandling,LeadTime,HideQuantity
,PriceUnits,MaxOrderQty,Width,Height,[Length],RecurringStartDate,ExcludeVariantRecur,SalePrice,WholesalePrice,HideProduct,ShowProductRole,TaxRate,Upsell,EnableTrial,TrialInterval,TrialOccurences
,TrialAmount,UseCompanyLogo,UserEnteredAmount,Booking
)
SELECT CategoryID, Manufacturer,@ModelNumber as 'ModelNumber',@ModelName as 'ModelName',ProductImage,ThumbnailImage,@UnitCost as 'UnitCost',MemberPrice,QuantityOnHand,Summary,[Description],DownloadUrl,[Featured],[Archived]
,[Weight],[SortOrder],[ExcludeCoupon],[Items],[Share],[TabModuleId],[CreatedByUser],[CreatedDate],[LogicallyDeleted],[Recurring],[SubscriptionInterval],[RecurringOccurances]
,[UrlGUID],[EncryptUrl],[AddDNNRole],[RequireLogin],[UsePriPriceWght],[BundleID],[MasterBundleID],[RoleExpireDays],[TaxExempt],[PortalID],[AffiliateUrl],[RequireCoupon],ShowPDUDF,AutoGUID
,Description2,Description3,Description4,Description5,TabName1,TabName2,TabName3,TabName4,TabName5,HideThumbnail,HidePrice,PriceClass,MinOrderQty,ChargeHandling,LeadTime,HideQuantity
,PriceUnits,MaxOrderQty,Width,Height,[Length],RecurringStartDate,ExcludeVariantRecur,SalePrice,WholesalePrice,HideProduct,ShowProductRole,TaxRate,Upsell,EnableTrial,TrialInterval,TrialOccurences
,TrialAmount,UseCompanyLogo,UserEnteredAmount,Booking

FROM Smith_Products
where productid = @ProductID

-- Get ProductID just inserted
DECLARE @myProdID int
SELECT @myProdID=scope_identity()

------ Copy Products 2 ----

INSERT INTO Smith_Products2
(ProductID,ShowOrderAsIs,Ecard,BinLocation,NumberOfBoxes,DateAddedToInventory,Client,[Owner] )
SELECT @myProdID as 'ProductID', ShowOrderAsIs,Ecard,BinLocation,NumberOfBoxes,DateAddedToInventory,Client,[Owner]
from Smith_Products2
where productid = @ProductID


------ Copy Variants ----

INSERT Smith_ProductVariant
(ProductID,VariantGroup,VariantName,VariantDisplayType,VariantImage,PriceAdjustment,WeightAdjustment,SortOrder,PortalId,VariantRequired,VariantGroupID
,Sku,QtyOnHand,ConditionalGroupID,VariantIconImage,VariantZoomImage,DropDownImageOption,IconImageOption,RenderTextInImage)
SELECT @myProdID as 'ProductID', VariantGroup, VariantName, VariantDisplayType, VariantImage, PriceAdjustment, WeightAdjustment, SortOrder, PortalId, VariantRequired,VariantGroupID
,Sku,QtyOnHand,ConditionalGroupID,VariantIconImage,VariantZoomImage,DropDownImageOption,IconImageOption,RenderTextInImage
FROM Smith_ProductVariant
where productid = @ProductID


------ Copy Variants Groups ----

INSERT INTO Smith_ProductVariantGroup
(ProductID, VariantHelpURL, VariantGroup, Hide, GroupDescription )
SELECT @myProdID as 'ProductID', VariantHelpURL, VariantGroup, Hide, GroupDescription
from Smith_ProductVariantGroup
where productid = @ProductID


------ Copy Categories ----

INSERT INTO Smith_CategoryProduct
(CategoryID, ProductID )
SELECT CategoryID, @myProdID as 'ProductID'
from Smith_CategoryProduct
where productid = @ProductID