How to Delete an Order in PrestaShop

Managing your order history is a standard part of running an e-commerce store. However, by default, PrestaShop does not allow for the complete deletion of orders through the standard administration panel. This is a deliberate security and accounting feature designed to maintain a consistent transaction log and prevent accidental data loss.

Why PrestaShop Restricts Order Deletion

• Accounting Integrity: In many jurisdictions, maintaining a continuous record of orders and invoices is a legal requirement.
• Database Consistency: Orders are linked to customers, products, and statistics. Removing an order manually can sometimes cause discrepancies in your sales reports.
• Security: Restricting deletion ensures that employees or unauthorized users cannot “erase” traces of transactions.

Method 1: Changing Order Status (The Recommended Way)

Instead of deleting an order, the best practice is to change its status. This removes it from your “active” workflow while preserving the data for your records.

1. Log in to your PrestaShop Back Office.
2. Navigate to Orders > Orders.
3. Click on the specific order you wish to handle.
4. In the Status section, select “Canceled” or “Payment Error” from the dropdown menu.
5. Click Update Status.

This approach ensures your stock levels are adjusted correctly and the order no longer appears in your active sales figures.

Method 2: Using a Module (The Efficient Way)

If you frequently need to remove test orders or duplicate entries, using a specialized module is the safest and most efficient method.

1. Go to Modules > Module Catalog.
2. Search for “Delete Orders”.
3. Install a reputable module designed for this purpose.
4. Once installed, these modules typically add a “Delete” icon next to each order in your list, allowing for a one-click removal that also cleans up associated data (like invoices and cart rules).

Method 3: Using PrestaShop Cleaner (For Test Data)

If you are still in the development phase on your mybox-hosted account and want to wipe all test orders before going live:

1. Navigate to Modules > Module Manager.
2. Find the “PrestaShop Cleaner” module (often pre-installed).
3. Under the “Orders and Customers” section, click “Delete orders & customers”.
4. Warning: This will permanently erase all orders and customers from your database. Use this only if you are starting fresh.

Method 4: Manual Deletion via Database (Advanced)

For technical users, orders can be removed directly through the mybox panel using phpMyAdmin.

1. Open phpMyAdmin from your dashboard.
2. Locate the tables starting with ps_orders, ps_order_detail, and ps_order_history.
3. Execute a SQL query or manually delete the specific ID rows. Note: This is risky and can lead to database errors if not done carefully. Always create a backup in the mybox panel before performing manual database edits.

Summary

While PrestaShop prioritizes the permanence of transaction records, you have several ways to manage your list. Whether you simply change the status to “Canceled” or use a module to purge test data, keeping your mybox-hosted store’s order list organized ensures clear reporting and efficient management.