Inhalte aufrufen

Profilbild

Empty old carts of registered users


3 Antworten zu diesem Thema

#1 vagelis

vagelis

    Advanced Member

  • Members
  • 73 Beiträge

Geschrieben: 30 January 2018 - 18:11

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



#2 Wolfgang Schmerge

Wolfgang Schmerge

    SmartStore AG

  • Administrators
  • 1907 Beiträge

Geschrieben: 31 January 2018 - 08:14

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


Viele zusätzliche SmartStore.NET Plugins gibt es im MARKETPLACE:
http://community.sma...dex.php?/files/

 

Die deutsche SmartStore.NET Online-Dokumentation gibt es hier:
http://docs.smartsto...display/smnetde

In dem folgenden BLOG findet man interessante Tipps & Tricks zum Thema "SmartStore.NET":

http://community.sma...t-tipps-tricks/

 


#3 vagelis

vagelis

    Advanced Member

  • Members
  • 73 Beiträge

Geschrieben: 31 January 2018 - 19:33

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.


#4 Wolfgang Schmerge

Wolfgang Schmerge

    SmartStore AG

  • Administrators
  • 1907 Beiträge

Geschrieben: 01 February 2018 - 09:28

Hi,

 

please use the MS SQL Server Management Studio.

 

Regards

 

Wolfgang


Viele zusätzliche SmartStore.NET Plugins gibt es im MARKETPLACE:
http://community.sma...dex.php?/files/

 

Die deutsche SmartStore.NET Online-Dokumentation gibt es hier:
http://docs.smartsto...display/smnetde

In dem folgenden BLOG findet man interessante Tipps & Tricks zum Thema "SmartStore.NET":

http://community.sma...t-tipps-tricks/

 




Auf dieses Thema antworten