MB
Asked
Hi,
How to delete all the pos sales of the last year 2020 , more than 4000 sales transaction.
I need an sql code to run it in database because I have many sales to delete.
regards.
How to delete all the pos sales of the last year 2020 , more than 4000 sales transaction.
I need an sql code to run it in database because I have many sales to delete.
regards.
- MSAnsweredHello,
You can backup your database and then truncate the `sma_sales` & `sma_sale_items` tables.
```sql
TRUNCATE TABLE `sma_sales`;
TRUNCATE TABLE `sma_sale_items`;
```
Thank you - MBAnsweredI don't want delete all sales ,only last year, That means between two dates.
I need all sales for these two last months only - MSAnsweredYou can delete the sale as
```sql
DELETE sma_sale_items FROM sma_sale_items LEFT JOIN sma_sales ON sma_sales.id = sma_sale_items.sale_id WHERE sma_sales.date < '2020-12-31 23:59:59';
DELETE sma_sales FROM sma_sales WHERE sma_sales.date < '2020-12-31 23:59:59';
``` - SSAnsweredI want see my POS deleted Sales List. How can I find it?
- MSAnsweredHello,
No. You can't get back the deleted sales. Once delete those will be gone.
If you have backup, you can check that only otherwise :(
Thank you - Login to Reply