3 Antworten zu diesem Thema

[vagelis]

Hello,

 

Is there a way to empty old carts of registered users? I have carts of users who proceed on order with the same items and it seems that they have an active cart

[Wolfgang Schmerge]

Hi,

 

there is no automatic function for this.

 

You can view the products in open shopping carts with an SQL command.

SELECT 
      [ShoppingCartTypeId]
      ,[CustomerId]
      ,[ProductId]
      
      
  FROM [dbo].[ShoppingCartItem]

ShoppingCartTypeId = 1 (Cart)
ShoppingCartTypeId = 2 (Wishlist)

 

Then delete the open shopping carts in the customer administration.

 

Regards

 

Wolfgang

[vagelis]

I've tried to run the below SQL from maintenance

 

delete FROM [dbo].[ShoppingCartItem] where [ShoppingCartTypeId] = 1

 

and it return this error. Any idea?

 

 

Could not load file or assembly 'Microsoft.SqlServer.SqlEnum, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

 

 

Could not load file or assembly 'Microsoft.SqlServer.SqlEnum, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

[Wolfgang Schmerge]

Hi,

 

please use the MS SQL Server Management Studio.

 

Regards

 

Wolfgang