Thread: Move to cart button deleting wishlist items

Hey I've been trying to get the wishlist to stop deleting items when you click to the move to cart button. I finally found the line thats been doing it. Its in wishlist.aspx.cs

Code:

DB.ExecuteSQL(string.Format("UPDATE ShoppingCart SET CartType = {0} WHERE ShoppingCartRecID = {1}", 1, MoveToCartID));

Unfortunatley, deleting this line also disables the ability to move items to the cart. Can anybody help me modify this line or create a new sql command to move items to the cart without deleting them from the wishlist? Thanks!

This will create a 'copy' record of the wishlist record. And, therefore, should be placed directly BEFORE the statement you identified. This record will then become the wishlist and the other will then still become the shopping cart record.

Code:

DB.ExecuteSQL(string.Format("INSERT INTO [ShoppingCart] ([CustomerID],[ProductSKU],[ProductPrice],[ProductWeight],[ProductID],[VariantID],[Quantity],[RequiresCount],[ChosenColor],[ChosenColorSKUModifier],[ChosenSize],[ChosenSizeSKUModifier],[IsTaxable],[IsShipSeparately],[IsDownload],[DownloadLocation],[FreeShipping],[CreatedOn],[ProductDimensions],[CartType],[IsSecureAttachment],[TextOption],[NextRecurringShipDate],[RecurringIndex],[OriginalRecurringOrderNumber],[BillingAddressID],[ShippingAddressID],[ShippingMethodID],[ShippingMethod],[DistributorID],[SubscriptionInterval],[Notes],[IsUpsell],[GiftRegistryForCustomerID],[RecurringInterval],[RecurringIntervalType],[ExtensionData],[SubscriptionIntervalType],[CustomerEntersPrice],[IsAKit],[IsKit2],[IsAPack],[IsSystem],[TaxClassID],[TaxRate],[RecurringSubscriptionID]) SELECT [CustomerID],[ProductSKU],[ProductPrice],[ProductWeight],[ProductID],[VariantID],[Quantity],[RequiresCount],[ChosenColor],[ChosenColorSKUModifier],[ChosenSize],[ChosenSizeSKUModifier],[IsTaxable],[IsShipSeparately],[IsDownload],[DownloadLocation],[FreeShipping],[CreatedOn],[ProductDimensions],[CartType],[IsSecureAttachment],[TextOption],[NextRecurringShipDate],[RecurringIndex],[OriginalRecurringOrderNumber],[BillingAddressID],[ShippingAddressID],[ShippingMethodID],[ShippingMethod],[DistributorID],[SubscriptionInterval],[Notes],[IsUpsell],[GiftRegistryForCustomerID],[RecurringInterval],[RecurringIntervalType],[ExtensionData],[SubscriptionIntervalType],[CustomerEntersPrice],[IsAKit],[IsKit2],[IsAPack],[IsSystem],[TaxClassID],[TaxRate],[RecurringSubscriptionID] FROM [ShoppingCart] WHERE [ShoppingCartRecID] = {0}", MoveToCartID));

As usual, please try this on a devleopment database/shop first.

Exactly what I was looking for. I ended up getting it to work by doing it the long version but this helps alot. Thank you!