[Free] Delete Orders Module

September 28, 2012

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)

September 28, 2012

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

September 28, 2012

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

September 29, 2012

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

September 30, 2012

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)

October 1, 2012

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

October 1, 2012

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

check your message box for PM from me

October 4, 2012

Hi Vekia

Works well with V 1.5, thanks its a great module

G

October 7, 2012

Works great! Thanks! (PS 1.5.1)

October 8, 2012

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

October 13, 2012

Great module... Thanks!

October 15, 2012

big thx men

October 17, 2012

here is something wrong with picture in the first post

October 18, 2012

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?

October 18, 2012

Just installed and looking good. Thanks

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

October 18, 2012

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?

October 18, 2012

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

October 27, 2012

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

October 30, 2012

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

October 30, 2012

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

November 21, 2012

any news about the update?

November 29, 2012

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)

December 14, 2012

...

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.

December 15, 2012

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

sryy my mistake

December 19, 2012

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.

January 14, 2013

Perfect module

We use it in PS 1.5.3.1

January 15, 2013

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

February 18, 2013

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

February 19, 2013

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

February 19, 2013

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

March 27, 2013

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.

March 27, 2013

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

May 7, 2013

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

May 7, 2013

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

May 8, 2013

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

May 8, 2013

hello,

thanks for your suggestion - it is suggestion for me

i will update this addon to delete the unwanted carts

regards

May 10, 2013

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.

May 10, 2013

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.

May 10, 2013

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:

May 10, 2013

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

May 10, 2013

I removed them by using your module.

May 10, 2013

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?

May 10, 2013

1.5.3.1

May 10, 2013

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

May 10, 2013

Yes, id_order is set to AUTO_INCEMENT.

im going to check this on 1.5.3.1

I'll be very gratefull.

May 10, 2013

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 :/

June 6, 2013

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

June 8, 2013

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

June 8, 2013

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

June 13, 2013

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

September 4, 2013

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)

September 4, 2013

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

September 4, 2013

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)

October 4, 2013

where I can find the button to delete an order?

Using presta 1.5

In presta 1.4 works fine

October 5, 2013

Install the delete orders free module

vekia provides link above

October 5, 2013

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

October 5, 2013

Under the orders menu sats delete order.

Cheers

Under the orders menu says delete order.

Cheers

October 5, 2013

uhhhh

there.. i just notice....

feel like stupid

October 5, 2013

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

October 5, 2013

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.

October 6, 2013

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

October 8, 2013

Right.

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

November 16, 2013

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?

November 16, 2013

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

December 11, 2013

Very useful module. Thanks!!!

December 17, 2013

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)

December 18, 2013

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?)

January 8, 2014

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)

January 11, 2014

great module. just got ride of pesky test orders!

thks

January 25, 2014

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

January 30, 2014

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?

February 18, 2014

same problem here.

February 18, 2014

im working on it guys, thanks for all reports

February 18, 2014

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);

March 13, 2014

I got same error with you.

Have you fixed it?

Hi, same problem, somebody has fixed? Thanks

March 13, 2014

Are you using the latest version of Delete Orders Module?

March 14, 2014

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

March 14, 2014

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)

March 14, 2014

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

March 14, 2014

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.

March 14, 2014

thanks!

March 17, 2014

It doesn´t work on presta v. 1.5.6.2.

nothing change after installation.

regards.

March 27, 2014

update available!

module supports prestashop 1.6

delete orders free for prestashop 1.6

March 27, 2014

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)

March 27, 2014

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.

March 27, 2014

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

April 5, 2014

Another useful module, thanks for sharing

Fine on PS 1.5.6.2

April 9, 2014

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

April 9, 2014

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

This module delete orders, not the theme

April 11, 2014

Haw can I delete 1 icon ?

May 4, 2014

not work in prestashop 1.6.0.6

May 4, 2014

not work in prestashop 1.6.0.6

ok now, the version 1.3 is ok on prestashop 1.6.0.6

May 19, 2014

Thank you so much ! You're awesome.

May 22, 2014

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)

May 28, 2014

noob question: How do I install this module? I tried looking but just didn't find any installation instructions. Do I just put everything in a folder under admin?

Thanks in advance!

May 28, 2014

Just like every module in your back office, modules, add a module, no FTP needed

May 28, 2014

Just like every module in your back office, modules, add a module, no FTP needed

Hi Kevin,

I did that. But nothing seems to appear. There is no extra menu under 'orders' and neither can I find it under modules.

May 28, 2014

Humm very strange that should work, you must see it, install it and enable it.

I always install Vekia modules by the classic way.

I'll let master Vekia answer on this one, maybe yo ucan try FTP upload but I don't see why, sorry

[Free] Delete Orders Module

Recommended Posts

vekia 8,968

Share this post

Link to post

Share on other sites

Pablus 21

Share this post

Link to post

Share on other sites

vekia 8,968

Share this post

Link to post

Share on other sites

vekia 8,968

Share this post

Link to post

Share on other sites

vekia 8,968

Share this post

Link to post

Share on other sites

Pablus 21

Share this post

Link to post

Share on other sites

vekia 8,968

Share this post

Link to post

Share on other sites

JerseyG 15

Share this post

Link to post

Share on other sites

RdeWit 1

Share this post

Link to post

Share on other sites

vekia 8,968

Share this post

Link to post

Share on other sites

ajensen27 43

Share this post

Link to post

Share on other sites

dimonas 3

Share this post

Link to post

Share on other sites

hsawker 0

Share this post

Link to post

Share on other sites

vekia 8,968

Share this post

Link to post

Share on other sites

haylau 200

Share this post

Link to post

Share on other sites

vekia 8,968

Share this post

Link to post

Share on other sites

haylau 200

Share this post

Link to post

Share on other sites

fishingnet 15

Share this post

Link to post

Share on other sites

vekia 8,968

Share this post

Link to post

Share on other sites

fishingnet 15

Share this post