Inhalte aufrufen

Profilbild

Clean database


  • Bitte melden Sie sich an, um eine Antwort zu verfassen.
2 Antworten zu diesem Thema

#1 Gonzalo

Gonzalo

    Advanced Member

  • Members
  • PunktPunktPunkt
  • 41 Beiträge

Geschrieben: 14 July 2014 - 13:32

Good afternoon,

 

I have been uploading pictures, prices etc to store online and after some test I would like clean database of test (buy done) but I would like maintenance prices, pictures etc.

Really I want clean only orders  done.

 

How can I do this?

 

Thanks



#2 Marcus Gesing

Marcus Gesing

    SmartStore AG

  • Administrators
  • 3799 Beiträge

Geschrieben: 14 July 2014 - 20:35

Go to "System > Maintenance" in the backend. Enter the following code in the field "SQL query" and execute it at own risk:
Delete from [Order]

Marcus Gesing

Smartstore AG


#3 Gonzalo

Gonzalo

    Advanced Member

  • Members
  • PunktPunktPunkt
  • 41 Beiträge

Geschrieben: 15 July 2014 - 09:35

ok, thanks!!