How to delete orders on Prestashop?
- 12/03/2015
- Prestashop
Problem: dummy orders
Often on Prestashop environment, we create dummy orders in order to test the shop and in the end such orders remain in our back office, distorting our financial statistics and more.
This need may reoccur if we do not want to keep track of orders refunded or made erroneously by our customers.
Solution
There are two ways to delete an order, the first of which require some technical skills, while the second is very simple.
How to delete an order from the database?
The standard platform to access the database is phpMyAdmin. In the interface of this web application you can view all the tables; in the search field you can search ps_order and the system filters all tables starting with ps_order and they are many.
All rows of these tables containing the id of the order to be deleted must be eliminated. It is very important to proceed with caution in this exercise because there is the risk of compromise the proper functioning of the database.
How to delete an order from the back office?
Since Prestashop does not provide a link or a button on backoffice that allows to delete an order with a simple click, we have to invoke the function with a trick.
- We enter the Orders menu and then we can access the order that we want to be deleted
- In the address bar we have the URL that will be similar to this:
http://www.shop.com/admin/index.php?controller=AdminOrders&id_order=1000&vieworder&token=1a2a1a2a1a21a2ab1289765412
- We locate the label vieworder, we replace it with deleteorder and we press Return. We’re done!
http://www.shop.com/admin/index.php?controller=AdminOrders&id_order=1000&deleteorder&token=1a2a1a2a1a21a2ab1289765412
SeoWebMaster propone periodicamente articoli d'attualità nel mondo di SEO, siti web e, più generalmente, di tecnologia. SeoWebMaster periodically offers current posts in the world of SEO, websites and, more generally, of technology. SeoWebmaster bietet regelmäßig aktuelle Beiträge in der Welt der SEO, Websites und, ganz allgemein, der Technologie.
SeoWebMaster and blog
The agency offers a complete service in web area, by updating you also about the most recent technologies through this blog. We provide our experience in each phase of development process in order to reach optimal results in different areas
Request a quote
We offer professional SEO services which will help your website increment the organic search traffic and compete for the 1st page with the most strategic keywords.