Thanks for using Bitnami Prestashop!
I don’t know the reason behind the removal of that plugin, but indeed it seemed like the recommended way to perform this kind of operation. I think this is something related to the application (maybe they are integrating this feature in future releases) and it’d be nice if you could reach out to the developer to let them know about your feelings.
In any case, I have searched through the UI and I haven’t seen any feature like this.
I have made a simple SQL script that seems to delete all the data related to the orders but leaves the catalog (mock products) intact. You can give it a try:
# Create a file with the following content
$ cat delete_orders.sql
TRUNCATE TABLE `ps_customer`;
TRUNCATE TABLE `ps_address`;
TRUNCATE TABLE `ps_orders`;
TRUNCATE TABLE `ps_order_detail`;
TRUNCATE TABLE `ps_message`;
TRUNCATE TABLE `ps_cart`;
TRUNCATE TABLE `ps_cart_product`;
# Use the following command to delete execute the script in your bitnami prestashop DB
$ mysql -u root -p bitnami_prestashop < delete_orders.sql
Jose Antonio Carmona
Was my answer helpful? Click on