There is an error when a product is deleted, and it is in a subcategory. All other products in that subcategory lose their subcategory, retaining only their category.

I have replicated the problem in the test system. I have screen shots, but I don't see how to attach them to this post.

We are running DNN 5.4.2, and Cart 2.93.

Specific steps I took to replicate the error were:

Created two root-level categories, Main 1 and Main 2

Created two subcategories of Main 1, Sub 1-1 and Sub 1-2

Created three products: Product 1 in Main 1, Sub 1-1

Product 2 in Main 1, Sub 1-1

Product 3 in Main 1 only

I then deleted product 1

Product 2 no longer shows up in Sub 1-1, only shows in Main 1

We have fixed this in v2.96 to be released tomorrow. Thanks for reporting it!

---

At your service,
Dave Smith

We will look into this and let you know if we are able to replicate this on our test cart and will post back in this thread with the solution and/or a patch. Thanks for reporting this.

-Scott

---

Scott Kelly
Project Manager

I fixed the issue where changing one item in a subcategory to a different subcategory causes the other products in the same category/subcategory to lose subcategory. To fix the issue run the following stored procedure. Make sure you change the object qualifier to your object qualifier highlighted in yellow below. If your object qualifier is "dnn" you can run as is.

ALTER PROCEDURE [dbo].[dnn_Smith_UpdateProducts]
@ProductID int,
@CategoryID int,
@Manufacturer nvarchar(50),
@ModelNumber nvarchar(50),
@ModelName nvarchar(200),
@ProductImage nvarchar(500),
@ThumbnailImage nvarchar(500),
@UnitCost money,
@MemberPrice money,
@QuantityOnHand int,
@Summary nvarchar(1000),
@Description ntext,
@DownloadUrl nvarchar(1000),
@Featured bit,
@Archived bit,
@weight decimal(12,5),
@sortOrder int,
@ExcludeCoupon bit,
@Items int,
@Share bit,
@TabModuleId int,
@CreatedByUser nvarchar(100),
@CreatedDate datetime,
@LogicallyDeleted bit ,
@Recurring bit ,
@SubscriptionInterval varchar(50) ,
@RecurringOccurances int ,
--@RequiredProductID int ,
@UrlGUID varchar(50) ,
@EncryptUrl bit,
@AddDnnRole varchar(50),
@RequireLogin bit,
@UsePriPriceWght bit,
@bundleID int,
@masterBundleID int,
@RoleExpireDays varchar(50),
@SubCategoryID int,
@TaxExempt bit,
@AffiliateUrl nvarchar(1000),
@RequireCoupon bit,
@ShowPDUDF bit,
@AutoGUID bit,
@Description2 ntext,
@Description3 ntext,
@Description4 ntext,
@Description5 ntext,
@TabName1 varchar(50),
@TabName2 varchar(50),
@TabName3 varchar(50),
@TabName4 varchar(50),
@TabName5 varchar(50)

AS
UPDATE dnn_Smith_Products SET
[Manufacturer] = @Manufacturer,
[CategoryID] = @CategoryID ,
[ModelNumber] = @ModelNumber,
[ModelName] = @ModelName,
[ProductImage] = ISNULL(@ProductImage,ProductImage),
[ThumbnailImage] = ISNULL(@ThumbnailImage,ThumbnailImage),
[UnitCost] = @UnitCost,
[MemberPrice] = @MemberPrice,
[QuantityOnHand]=@QuantityOnHand,
[Summary] = @Summary,
[Description] = @Description,
[DownloadUrl] = @DownloadUrl,
[Featured] = @Featured,
[Archived] = @Archived,
[Weight]=@weight,
[SortOrder] = @SortOrder,
[ExcludeCoupon] = @ExcludeCoupon,
[Items] = @Items,
[Share] = @Share ,
[TabModuleId] = @TabModuleId,
[CreatedByUser] = @CreatedByUser,
[CreatedDate] = @CreatedDate,
[LogicallyDeleted]=@LogicallyDeleted,
[Recurring] = @Recurring,
[SubscriptionInterval] = @SubscriptionInterval,
[RecurringOccurances] = @RecurringOccurances ,
---- [RequiredProductID] = @RequiredProductID ,
[UrlGUID] = @UrlGUID ,
[EncryptUrl] = @EncryptUrl,
[AddDNNRole] = @AddDnnRole,
[RequireLogin] = @RequireLogin,
[UsePriPriceWght] = @UsePriPriceWght,
[BundleID] = @bundleID,
[MasterBundleID] = @masterBundleID,
[RoleExpireDays] = @RoleExpireDays,
[TaxExempt] = @TaxExempt,
[AffiliateUrl] = @AffiliateUrl,
[RequireCoupon] = @RequireCoupon,
[ShowPDUDF] = @ShowPDUDF,
AutoGUID = @AutoGUID,
Description2 = @Description2,
Description3 = @Description3,
Description4 = @Description4,
Description5 = @Description5,
TabName1 = @TabName1,
TabName2 = @TabName2,
TabName3 = @TabName3,
TabName4 = @TabName4,
TabName5 = @TabName5

WHERE
[ProductID] = @ProductID


delete from dnn_Smith_CategoryProduct WHERE ProductID = @ProductID
INSERT INTO dnn_Smith_CategoryProduct(ProductID, CategoryID) VALUES (@ProductID, @CategoryID)
INSERT INTO dnn_Smith_CategoryProduct(ProductID, CategoryID) VALUES (@ProductID, @SubCategoryID)

---

At your service,
Dave Smith