[Free] Delete Orders Module

[vekia 8,845]

Prestashop Delete Orders Free 1.2

This free module is the best and the simplest way to delete orders in PrestaShop. You can delete order by one mouse click. This module adds in "Orders" section (PrestaShop back-office) special tab "delete orders" where you can delete any order you want.This module solves the problem of unwanted orders. For Free!

more informations about module you will find on official webpage of this module:

Prestashop Delete Orders

UPDATE!

UPDATES LOG

 

25.03.2013

v1.3 module supports prestashop 1.6

 

18.02.2013

v1.2 Module follows prestashop 1.5 guidelines and works perfectly, we fix little issue with non-displayin tab in ps.1.5

29.09.2012

v1.1 I updated module to version 1.1. Now all translations works properly. Translations available:

Edited March 27, 2014 by vekia (see edit history)

[Pablus 20]

Thank you for share this module, is very usefull, only one question, when delete the orders, the units deleted is restored to my stock? Regards

[vekia 8,845]

Thank you for share this module, is very usefull, only one question, when delete the orders, the units deleted is restored to my stock? Regards

 

module will do this in next update. Now module only delete orders

[vekia 8,845]

UPDATE!

I updated module to version 1.1. Now all translations works properly. Translations available:

you can download new version from Delete Orders PrestaShop module official website, or from first post.

 

Regards

[vekia 8,845]

here is a tutorial, where you can read how to delete orders using this free module

How to delete orders in PrestaShop

Edited September 30, 2012 by vekia (see edit history)

[Pablus 20]

Thank you, I will wait for your next update, even for the payment module. regards

[vekia 8,845]

Thank you, I will wait for your next update, even for the payment module. regards

 

check your message box for PM from me

[JerseyG 15]

Hi Vekia

 

Works well with V 1.5, thanks its a great module

G

[RdeWit 1]

Works great! Thanks! (PS 1.5.1)

[vekia 8,845]

want improvements? write it here and i will add it to module

[ajensen27 42]

Great module... Thanks!

[dimonas 3]

big thx men

[hsawker 0]

here is something wrong with picture in the first post

[vekia 8,845]

here is something wrong with picture in the first post

 

what do you mean by that? it works fine for me. Could you describe your problem with this picture?

[haylau 197]

Just installed and looking good. Thanks

I wonder if this could be enhanced to be able to multiselect shopping cards for deletion?

[vekia 8,845]

Just installed and looking good. Thanks

I wonder if this could be enhanced to be able to multiselect shopping cards for deletion?

 

hi,

 

what do you mean by "multiselect shopping cards for deletion" ?

 

you want to delete many orders by one mouse click?

[haylau 197]

hi,

 

what do you mean by "multiselect shopping cards for deletion" ?

 

you want to delete many orders by one mouse click?

 

No, not orders - I am thinking of shopping carts that have been abandoned and not converted into an order

 

There was a hack in Ps1.4 where we could get tick boxes against shopping carts . This allowed us to select more than one shoppping cart at a time and delete them

[fishingnet 15]

Hello Vekia ! Thanks for your module ! It's very important for me !

I have installed deleteordersfree_v1.1 and i made a few order tests. After that i deleted this orders via BO with your module.

I checked my DB (all tables beginning with ps_orders).

In the table ps_orders_tax, they have been not deleted.

It is ok if these items remained undeleted, or i must to delete them manually?

I use 1.4.8.2 and my shop is online (FishingNet)

Thank you again for your hard work !

Bogdan

[vekia 8,845]

Hello Vekia ! Thanks for your module ! It's very important for me !

I have installed deleteordersfree_v1.1 and i made a few order tests. After that i deleted this orders via BO with your module.

I checked my DB (all tables beginning with ps_orders).

In the table ps_orders_tax, they have been not deleted.

It is ok if these items remained undeleted, or i must to delete them manually?

I use 1.4.8.2 and my shop is online (FishingNet)

Thank you again for your hard work !

Bogdan

 

sorry for the delay, i will write update for module - new version will eliminate the problem that you mentioned.

 

of course you can delete it manualy

[fishingnet 15]

Thanks for your answer, i am waiting the new version.

[PEPPE83 8]

any news about the update?

[kristianmu 49]

Thank you for share this module, is very usefull, only one question, when delete the orders, the units deleted is restored to my stock? Regards

 

To get the stock back, first of all, go to order details, delete from the list all products, and then delete de order.

By deleting the products you will get the stock restored.

 

 

Hope it helps to all!

Edited November 29, 2012 by KristianMM (see edit history)

[vekia 8,845]

...

now I can't print pdf files and i get an error: FPDF error: Undefined font: verdana B

 

It's impossible, because this module doesn't make any change in pdf generation and other features similar to PDF.

[greeed 0]

true, module was not guilty, just the nationality of the administrator acc was set to english...

sryy my mistake

[josecar 3]

tried in 1.5.2, all well

 

thanks vekia for this

 

loved the "orgullosamente desarrollado por..."

 

ps: I would love a version with a 'Delete all current orders' option. Better for mass elimination of fake orders before production. Anyway, thanks again.

[racemaniac 3]

Perfect module

We use it in PS 1.5.3.1

[vekia 8,845]

thanks, as you said - module works perfeclty in newest version of prestashop too

[vekia 8,845]

we updated this module!

now module is in 1.2 version and you can download it from first post or from module delete orders in prestashop official page

[Totti 59]

Great module, but with the old version there was also the possibility to cancel all orders and trucks in a single pass.

[vekia 8,845]

in the next update I will add this feature it's on my TODO list

[tonicor 3]

Hello and sorry for my English,

 

I tried the free module in Prestashop 1.5.3.1 and removes the order without problems.

My question is:

If I delete an invoice with serial number "50", is the next order to buy will go on "50" or "51"?

 

I deleted an order with the number "50" and then I put the next bill begins with "50" again and says the following prestashop bill must begin with 51. So there will be a jump in the numbering series and I can have legal problems.

 

Thank you.

[vekia 8,845]

unfortunately this module hasn't got feature to "restore" invoice counter, i will check module later, maybe it is possible to create it :-)

[antoniolite 1]

I tried the module to delete the test orders and i found that it does not delete (or truncate) these tables in the database:

 

- ps_order_carrier

- ps_order_message

- ps_order_message_lang

 

I did not check, but in this case, it's possible that when registering next orders with same IDs, shows wrong carrier and shows old messages from other orders.

 

I will continue testing this module. I had a method to delete test orders with PS1.4 but it does not work with PS1.5

[vekia 8,845]

hello thanks for your information

 

new order = always new id, so it isn't possible to show old messages in new order

 

i will update this module asap

[lob 2]

Hi Vekia,

I have a problem in the backoffice with shopping carts.

People make them with as a guest and then leave the store.

In 14 days I have 280+ shopping carts in the backoffice.

I downloaded the free version of your delete orders module but it only deletes orders from clients.

Does the Pro versio delete also non clients shopping carts?

 

Thanks

[vekia 8,845]

hello,

 

thanks for your suggestion - it is suggestion for me

 

i will update this addon to delete the unwanted carts

 

regards

[piotros 0]

I tried the module to delete the test orders and i found that it does not delete (or truncate) these tables in the database:

 

- ps_order_carrier

- ps_order_message

- ps_order_message_lang

 

I did not check, but in this case, it's possible that when registering next orders with same IDs, shows wrong carrier and shows old messages from other orders.

Sadly, you're right. After use this module I have a problem with carriers. (And probably some problems which I don't know at this time. Future can bring me some negative suprise.)

 

new order = always new id, so it isn't possible to show old messages in new order

Actually, prestashop works in a different way.

New order != new id.

BUT

New order == last free id.

 

Here's an example:

Situation 1. If we have orders 1, 2, 3, 4 and we delete order 2 then we have 1, 3, 4. In this situation new order will have number 5.

Situation 2. If we have orders 1, 2, 3, 4 and we delete order 4 then we have 1, 2, 3. In this situation new order will have number 4.

 

At this time using this module can cause horrible faults.

 

Is any solution which can help me to repair damages?

Should I remove records only from table "ps_order_carrier"?

 

Really sorry for my English.

[vekia 8,845]

I can't agree.

id_order is a PRIMARY KEY with AUTO_INCREMENT

 

`id_order` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,

 

which mean that all entries in this field is UNIQUE and can't be doubled.

 

I reproduced your issue, and the effect is:

 

 

conclusion

 

id_order are ALWAYS unique and can't be doubled - even if you remove row.

[piotros 0]

So how can you explain my problem?

I was having six test orders. I removed them all and then added one order.

 

This is how my "ps_orders" table look like now:

As you see "id_order" is 1.

 

And here you have some other screenshots from my database:

 

"ps_order_carrier" table:

 

"ps_order_detail_tax" table:

 

"ps_order_invoice" table:

 

"ps_order_invoice_payment" table:

[vekia 8,845]

you removed them all by deleting them, or by TRUNCATE the table?

[piotros 0]

I removed them by using your module.

[vekia 8,845]

i removed 5 order before:

 

here are other tables:

 

ps_order_carrier

 

other tables look the same, id_order number is correct.

 

What prestashop version you use?

[piotros 0]

1.5.3.1

[vekia 8,845]

when you go to the ps_order table settings

the id_order has got AUTO_INCREMENT ?

 

im going to check this on 1.5.3.1

[piotros 0]

Yes, id_order is set to AUTO_INCEMENT.

 

im going to check this on 1.5.3.1

I'll be very gratefull.

[vekia 8,845]

the same as before, now i created order with id = 6 - then removed it

after all created another order:

 

 

 

 

really weird. I think that the problem is somewhere else - not in the module

as i said before AUTO_INCREMENT fields always generate unique value, even after remove some fields... So it is really really weird :/

[piotros 0]

So maybe you can help me to make everything work properly again?

[rukristin 5]

Brilliant. Needed to delete the initial order that cannot be removed otherwise in Prestashop. THIS IS THE MODULE YOU NEED TO ACTUALLY GET A CLEAN INSTALL. I understand why the prestashop can't include it to begin with, so thank you for doing this.

 

HERO = VEKIA

[vekia 8,845]

You're welcome if you've got any suggestions - feel free to write

[Coluccini 5]

Thanks for the module Vekia, it works great!

I have a suggestion: it would be nice for user using the Google Analytics module that when an order is deleted, a reverse ecommerce transaction were reported to analytics (this ways no non existing orders are affecting analytics stats).

 

More info on https://support.google.com/analytics/answer/1037443?hl=en

[markjl 8]

Hello

Thanks for this module Vekia

However, it does not seem to delete invoices corresponding to the deleted order

Edited September 4, 2013 by markjl (see edit history)

[vekia 8,845]

thanks markjl for attention. i checked it and i can't reproduce the issue, can you describe it how to reproduce issue? i want to fix it if there is any problem with this

[markjl 8]

Maybe its me but I was setting a next invoice number

 

and I couldn't set the next invoice number to the invoice number created from the last deleted order.

Edited September 4, 2013 by markjl (see edit history)

[jose_rui_sa 3]

where I can find the button to delete an order? 

 

Using presta 1.5

 

 

In presta 1.4 works fine

[markjl 8]

Install the delete orders free module

vekia provides link above

[jose_rui_sa 3]

i already install the version 1.2.... cant find delete button...

[markjl 8]

Under the orders menu sats delete order.

 

Cheers

Under the orders menu says delete order.

 

Cheers

[jose_rui_sa 3]

uhhhh

 

 

 

there.. i just notice....    

 

 

feel like stupid

[markjl 8]

S'ok I looked for a button 1st time too :-)

[alsitn 5]

Hi Vekia,

 

just to let you know that I've been checking AdminOrdersController and I've found this

$this->reinjectQuantity($order_detail, $order_detail->product_quantity);

So I've checked your file and didn't find a similar method.

Trying your module confirmed that.

[vekia 8,845]

hello

 

this module works a bit different, you can check full description with screenshots on module website.

 

while you removing order with "standard" button, it doesn't remove all fields, this is why i used different method

[alsitn 5]

Right.

I'd like to know whether the PRO version also reinject item quantity on a non previously "canceled" order or not, please.

[sigdrifa 0]

Thanks for sharing - exactly what I needed. I wanted to remove the sample order (we don't sell computers ) and some test orders I made to have a clean start.

 

I adjusted the German translation a bit (I am German), do you want it?

[vekia 8,845]

Thanks for sharing - exactly what I needed. I wanted to remove the sample order (we don't sell computers ) and some test orders I made to have a clean start.

 

I adjusted the German translation a bit (I am German), do you want it?

 

of course i will be gratefull

 

thanks in advance

support [at] mypresta [dot] eu

[Joytia1999 2]

Very useful module. Thanks!!! 

[puspo 0]

On my Presta 1.5.6.0 I get this error:

 

Notice: Undefined variable: id_tab in /hosting/www/svizne.cz/erotika.preposilani/modules/deleteordersfree/deleteordersfree.php on line 26 Warning: Cannot modify header information - headers already sent by (output started at /hosting/www/svizne.cz/erotika.preposilani/modules/deleteordersfree/deleteordersfree.php:26) in /hosting/www/svizne.cz/erotika.preposilani/classes/Tools.php on line 141

 

Can You give me an advice?

Edited December 17, 2013 by puspo (see edit history)

[vekia 8,845]

On my Presta 1.5.6.0 I get this error:

 

Notice: Undefined variable: id_tab in /hosting/www/svizne.cz/erotika.preposilani/modules/deleteordersfree/deleteordersfree.php on line 26 Warning: Cannot modify header information - headers already sent by (output started at /hosting/www/svizne.cz/erotika.preposilani/modules/deleteordersfree/deleteordersfree.php:26) in /hosting/www/svizne.cz/erotika.preposilani/classes/Tools.php on line 141

 

Can You give me an advice?

 

hello

 

before upload you opened deleteordersfee.php file in simple text editor? (or other text edtiors?)

[KevinNash 117]

Hello Vekia and thank you for another great module

 

I just did a test and deleted an order, PS 1.5.4.1, I checked this database tables to see if there is still traces of the order ( I am not sure I there is more tables to check ) :

 

ps_cart
ps_cart_product
ps_loyalty
ps_loyalty_history
ps_message
ps_orders
ps_order_carrier
ps_order_detail
ps_order_history
ps_order_invoice
ps_order_invoice_payment
ps_order_payment
ps_prestafraud_orders

 

After order deletion with your module, I can still find the order traces in this tables :

 

ps_cart
ps_loyalty
ps_loyalty_history
ps_message
ps_order_carrier
ps_order_invoice
ps_order_invoice_payment
ps_order_payment
ps_prestafraud_orders

 

Can you take a look and eventually adapt the module to have a totally clean order deletion ?

Edited January 9, 2014 by KevinNash (see edit history)

[nayll 1]

great module. just got ride of pesky test orders!

 

thks

[omaral 0]

Nice module but for v 1.5.6.2 I would add:

//delete customer messages and seller replies regarding to an order
$q= 'DELETE a,b FROM '._DB_PREFIX_.'customer_thread AS a 
       LEFT JOIN '._DB_PREFIX_.'customer_message AS b 
       ON a.id_customer_thread = b.id_customer_thread 
       WHERE id_order="'.$id.'"';			
if(!Db::getInstance()->Execute($q)){$this->errorlog[] = $this->l("ERROR");}

//delete payments
$q= 'DELETE a,b,c FROM '._DB_PREFIX_.'order_invoice_payment AS a 
       LEFT JOIN '._DB_PREFIX_.'order_payment AS b 
       ON a.id_order_payment = b.id_order_payment 
       LEFT JOIN '._DB_PREFIX_.'order_invoice_tax AS c 
       ON a.id_order_invoice = c.id_order_invoice 
       WHERE id_order="'.$id.'"';			
if(!Db::getInstance()->Execute($q)){$this->errorlog[] = $this->l("ERROR");}

//delete invoices
$q = 'DELETE FROM '._DB_PREFIX_.'order_invoice WHERE id_order="'.$id.'"';
if(!Db::getInstance()->Execute($q)){$this->errorlog[] = $this->l("ERROR");}

//delete carriers
$q = 'DELETE FROM '._DB_PREFIX_.'order_carrier WHERE id_order="'.$id.'"';
if(!Db::getInstance()->Execute($q)){$this->errorlog[] = $this->l("ERROR");}

//delete messages
$q= 'DELETE a,b FROM '._DB_PREFIX_.'message AS a 
       LEFT JOIN '._DB_PREFIX_.'message_readed AS b 
       ON a.id_message = b.id_message 
       WHERE id_order="'.$id.'"';
if(!Db::getInstance()->Execute($q)){$this->errorlog[] = $this->l("ERROR");}

//delete order cart rules (not shure what are order cart rules)
$q = 'DELETE FROM '._DB_PREFIX_.'order_cart_rule WHERE id_order="'.$id.'"';
if(!Db::getInstance()->Execute($q)){$this->errorlog[] = $this->l("ERROR");}

I would also changed this:

$q = 'DELETE FROM '._DB_PREFIX_.'order_detail WHERE id_order="'.$id.'"';
if(!Db::getInstance()->Execute($q)){$this->errorlog[] = $this->l("ERROR");}

to this:

$q= 'DELETE a,b FROM '._DB_PREFIX_.'order_detail AS a 
            LEFT JOIN '._DB_PREFIX_.'order_detail_tax AS b 
            ON a.id_order_detail = b.id_order_detail 
            WHERE id_order="'.$id.'"';			
if(!Db::getInstance()->Execute($q)){$this->errorlog[] = $this->l("ERROR");}

I'm not sure if anything else

[doavers 0]

On my Presta 1.5.6.0 I get this error:

 

Notice: Undefined variable: id_tab in /hosting/www/svizne.cz/erotika.preposilani/modules/deleteordersfree/deleteordersfree.php on line 26 Warning: Cannot modify header information - headers already sent by (output started at /hosting/www/svizne.cz/erotika.preposilani/modules/deleteordersfree/deleteordersfree.php:26) in /hosting/www/svizne.cz/erotika.preposilani/classes/Tools.php on line 141

 

Can You give me an advice?

 

I got same error with you.

 

Have you fixed it?

[Pronux 108]

same problem here.

[vekia 8,845]

im working on it guys, thanks for all reports

[Pronux 108]

I had some wrong/weird orders after deleting old orders in my shop, so I created this query to clean my DB:

DELETE FROM ps_order_carrier         		WHERE id_order NOT IN (SELECT id_order FROM ps_orders);
DELETE FROM ps_order_cart_rule       	WHERE id_order NOT IN (SELECT id_order FROM ps_orders);
DELETE FROM ps_order_detail          		WHERE id_order NOT IN (SELECT id_order FROM ps_orders);
DELETE FROM ps_order_history         	WHERE id_order NOT IN (SELECT id_order FROM ps_orders);
DELETE FROM ps_order_invoice         	WHERE id_order NOT IN (SELECT id_order FROM ps_orders);
DELETE FROM ps_order_invoice_payment 	WHERE id_order NOT IN (SELECT id_order FROM ps_orders);
DELETE FROM ps_order_return         		WHERE id_order NOT IN (SELECT id_order FROM ps_orders);
DELETE FROM ps_order_slip   		WHERE id_order NOT IN (SELECT id_order FROM ps_orders);
DELETE FROM ps_order_detail_tax 		WHERE id_order_detail  NOT IN (SELECT id_order_detail  FROM ps_order_detail);
DELETE FROM ps_order_invoice_payment 	WHERE id_order_invoice NOT IN (SELECT id_order_invoice FROM ps_order_invoice);
DELETE FROM ps_order_invoice_tax 		WHERE id_order_invoice NOT IN (SELECT id_order_invoice FROM ps_order_invoice);

[tonilopez 5]

I got same error with you.

 

Have you fixed it?

 

Hi, same problem, somebody has fixed? Thanks

[Pronux 108]

Are you using the latest version of Delete Orders Module?

[Beluga 20]

Anyone tried modding this to work with .csv files? So we could delete multiple orders by id at once.

[Beluga 20]

Attached is a bastardization of Vekia's module + Nemo's Order delete module + my CSV upload code + omaral's suggestions + Pronux's cleanup.

 

It's my usual quick and dirty quality so please improve it, if you like. Error reporting could use work! I just left it in a sorry state.

 

I only made it support PS 1.5+

 

Somehow it seems crazy to use a CSV file when it only has one column, but I had that code ready.. On the other hand, maybe it's easy to grab those order ID's from a spreadsheet you are working on.

 

orderdeletewithcsv.zip

Edited March 17, 2014 by Beluga (see edit history)

[KevinNash 117]

Attached is a bastardization of Vekia's module + Nemo's Order delete module + my CSV upload code + omaral's suggestions + Pronux's cleanup.

 

It's my usual quick and dirty quality so please improve it, if you like.

 

Somehow it seems crazy to use a CSV file when it only has one column, but I had that code ready.. On the other hand, maybe it's easy to grab those order ID's from a spreadsheet you are working on.

 

Can you add my cleanup too ?

 

ps_cart

ps_loyalty

ps_loyalty_history

ps_message

ps_order_carrier

ps_order_invoice

ps_order_invoice_payment

ps_order_payment

ps_prestafraud_orders

[Beluga 20]

Can you add my cleanup too ?

 

ps_cart

ps_loyalty

ps_loyalty_history

ps_message

ps_order_carrier

ps_order_invoice

ps_order_invoice_payment

ps_order_payment

ps_prestafraud_orders

After omaral's modifications, the only ones needing to be added are

_cart

_loyalty

_loyalty_history

 

Prestafraud seems to be some 3rd party module.

[Pronux 108]

thanks! 

[designerspain 1]

It doesn´t work on presta v. 1.5.6.2.

nothing change after installation.

regards.

[vekia 8,845]

update available!

module supports prestashop 1.6

delete orders free for prestashop 1.6

[KevinNash 117]

Hello Vekia and thank you for another great module

 

I just did a test and deleted an order, PS 1.5.4.1, I checked this database tables to see if there is still traces of the order ( I am not sure I there is more tables to check ) :

 

ps_cart

ps_cart_product

ps_loyalty

ps_loyalty_history

ps_message

ps_orders

ps_order_carrier

ps_order_detail

ps_order_history

ps_order_invoice

ps_order_invoice_payment

ps_order_payment

ps_prestafraud_orders

 

After order deletion with your module, I can still find the order traces in this tables :

 

ps_cart

ps_loyalty

ps_loyalty_history

ps_message

ps_order_carrier

ps_order_invoice

ps_order_invoice_payment

ps_order_payment

ps_prestafraud_orders

 

Can you take a look and eventually adapt the module to have a totally clean order deletion ?

 

Hello Vekia,

 

Thank you for the update

 

Did you add some cleanup in this new version ?

Edited March 27, 2014 by KevinNash (see edit history)

[RockyS 2]

It's not useful if IDs are not restored. 
If I deleter order with ID 99 I assume that next order should also be 99 and not 100. In your accounting you have to have invoices always incremented by 1, without skipping numbers. 

[KevinNash 117]

Thats not possible RockyS, imagine you have 100 orders and just delete order number 90 ?

 

What should orders 91 to 100 become ? They must stay with the same numbers because it is your customers original orders numbers

 

Your idea should be fine only if you delete the last order

[Shido 0]

Another useful module, thanks for sharing

Fine on PS 1.5.6.2

[maheprasath 0]

i have delete my theme module how can install the theme  module again

[KevinNash 117]

i have delete my theme module how can install the theme  module again

 

This module delete orders, not the theme

[lukruk 4]

Haw can I delete 1 icon ?

[pauldomy 4]

not work in prestashop 1.6.0.6 

[pauldomy 4]

not work in prestashop 1.6.0.6 

ok now, the version 1.3 is ok on prestashop 1.6.0.6

[xantarian 1]

Thank you so much ! You're awesome.

[sergey2000 0]

Hello,

 

the products from deleted order (by module v1.3) don`t going back to stock?

Besides, I found that products from canceled order (not deleted) don`t going back to stock too. Is it same at anybody? Is it PrestaShop bug or I don`t know some settings in stock management? (1.6.0.6)