[Module] Delete Orders V3.0 - Ps 1.2/1.7

[shacker 1,055]

Enable the option to delete orders in admin page (ideal to delete test orders)
Use this module to enable or disable this feature in a easy way to your clients.
Also you can delete all orders in a clic from the module configuration

Features:
Multilingual
Cross beowser

v2.0-compatible ps 1.6+bootstrap

v3.0- compatible PS1.7

 

 

http://www.catalogo-...ete-orders.html


Visit our site for the latest version of the free module and more modules


comments are welcome

deleteorders.zip

deleteorders.zip v3.0

[Zenith 17]

Just adding this delete button using the code in PS does not remove all instances of an order.

[shacker 1,055]

Just adding this delete button using the code in PS does not remove all instances of an order.

This only does the same trick that enables the delete order in the Adminorders.php

[Zenith 17]

Yes that's what I said, but using this method does not remove all instances of an order like messages, order history, slips, discounts, etc

This module - http://www.prestashop.com/forums/viewthread/18231/ - cleans the order from the database properly.

[shacker 1,055]

Yes that's what I said, but using this method does not remove all instances of an order like messages, order history, slips, discounts, etc

This module - http://www.prestashop.com/forums/viewthread/18231/ - cleans the order from the database properly.

This module only does the trick posted by rocky, without replace any file and no mods, only this.

[shacker 1,055]

v1.1 - compatible ps 1.2/1.5

[ivancitoo_22 0]

Muy bueno lo estaba buscando!Gracias totalesss!

Edited January 7, 2013 by ivancitoo_22 (see edit history)

[Berlindoor 3]

here works perfectly.

 

But in dev mode, when trying to delete all orders with the "one click button" this is what I get:

 

[PrestaShopDatabaseException]

Db->executeS() must be used only with select, show, explain or describe queries

at line 470 in file classes/db/Db.php

 

464.

465. // This method must be used only with queries which display results

466. if (!preg_match('#^\s*\(?\s*(select|show|explain|describe|desc)\s#i', $sql))

467. {

468. if (defined('_PS_MODE_DEV_') && _PS_MODE_DEV_)

469. throw new PrestaShopDatabaseException('Db->executeS() must be used only with select, show, explain or describe queries');

470. return $this->execute($sql, $use_cache);

471. }

472.

473. $this->result = false;

474. $this->last_query = $sql;

• DbCore->executeS - [line 40 - modules/deleteorders/deleteorders.php] - [1 Arguments]
  
• DeleteOrders->getContent - [line 597 - controllers/admin/AdminModulesController.php] - [0 Argument]
  
• AdminModulesControllerCore->postProcessCallback - [line 717 - controllers/admin/AdminModulesController.php] - [0 Argument]
  
• AdminModulesControllerCore->postProcess - [line 158 - classes/controller/Controller.php] - [0 Argument]
  
• ControllerCore->run - [line 348 - classes/Dispatcher.php] - [0 Argument]
  
• DispatcherCore->dispatch - [line 50 - greenadmin/index.php] - [0 Argument]
  

[PrestaShop] Fatal error in module Unk:

Module 'mcrypt' already loaded

[shacker 1,055]

thanks. i check it

[shacker 1,055]

i update the module and solve this

[shacker 1,055]

v1.2 - support ps 1.5.3.1

[shacker 1,055]

v2.0-compatible ps 1.6+bootstrap

[Totti 59]

You can also put the file on this page ?

Thanks.

[Dead2010 6]

hello shacker, added account and will finish in the cart, but when downloading, always fails. I can not download, any problem?

greetings

[shacker 1,055]

hi. what browser iu use and version, and please tell me how you download, order page, my download or email link. help me so i can solve asap

[Dead2010 6]

When will I access my account and try to download, it always gives error and the others I have in my account too. formerly gave no error.

both on firefox and in internet explorer

[shacker 1,055]

hi. can iu please try again?

[Dead2010 6]

hello, still giving error. download failure

[shacker 1,055]

can iu send me a pm with your user and pass?

[Dead2010 6]

hello, now I got it. Thank you

greetings

[shacker 1,055]

 

hello, now I got it. Thank you

greetings

 

perfect.regards

[reinvis 0]

Hi Shacker,

 

Your site is down!

I got only mysql errors.

[shacker 1,055]

yes, we are upgrading mysql and php version

[jcmil 1]

Just tried this on 1.6.0.9 - killed all those dummy orders!

Thanks. 

[shacker 1,055]

Just tried this on 1.6.0.9 - killed all those dummy orders!

Thanks. 

you welcome. please rate the product in our site. This help us

[juanimela 0]

In your code I read:

chmod('../controllers/admin/AdminOrdersController.php', 0777);
if (ini_get('allow_url_fopen') == '0')
    ini_set('allow_url_fopen', '1');
$str = '';
if ($fh = fopen('../controllers/admin/AdminOrdersController.php', 'r'))
{
    while (!feof($fh))
        $str .= fgets($fh);
    $str = str_replace('$this->addRowAction(\'view\');', '$this->addRowAction(\'view\');$this->addRowAction(\'delete\');', $str);
    fclose($fh);
    chmod('../controllers/admin/AdminOrdersController.php', 0644);
}

So, you change the source file ../controllers/admin/AdminOrdersController.php in place (that's dangerous!), to add the delete action to orders. So I have som doubts:

• I've read in this forum that is not safe to just add that action, because that will not take care of all tables that depend on order
• You're not using a module or an override, so the code will come back to normal after any upgrade, ¿no?
• allow_url_fopen might be disabled for security reasons, so this module may not work for some people.

[shacker 1,055]

Hi. change the file is not dangerous when you only add a code (like enable or disable), dont do anything else

If you update, can turn on again. If the customer have disabled overrides, the module dont work.

 

Check what actions do the enable delete functions, and you get all the way up to delete the orders

 

allow url its irrelevant in this case, must be deleted in futures releases.

[juanimela 0]

shacker, I know the code is not malicious and probably works for many people, but I'd very much overwrite the file myself rather than have a module do it for me. Possible issues:

 

- Encoding problem, and my installation is dead

- Uninstall: who needs that?

- Possible conflict with other approaches

 

Further, I agree that the entry in the ps_orders table will get deleted, but our concern is: how about the other tables that depend on it? Will we have stranded invoices or phantom carts? There is one way to check:

 

- Install the official "prestashop cleaner", which has two interesting functions: "CheckAndFix" and "CleanAndOptimize". Use both.

- After deleting one order with this module, use both function again.

- If any of them report any operation after deleting the order, that means your module is not safe to use. A quick fix would be to call those functions from the cleaner module using the right hook. I'm no expert, but I'd say it's actionObjectOrderDeleteAfter.

Edited January 18, 2015 by juanimela (see edit history)

[shacker 1,055]

I doubt ps cleaner works in all ps version. I made this for all version. Anyway, if somebody want to improve, no problem i can add the changes. at the moment i dont have time to develop all free modules and make changes to all. 

 

regards

[El Patron 2,886]

shacker, is the current/correct version downloadable from here or only from your shop?

[shacker 1,055]

shacker, is the current/correct version downloadable from here or only from your shop?

Dont remember, but always download the latest from our site. sometimes i cant upload.

[El Patron 2,886]

Dont remember, but always download the latest from our site. sometimes i cant upload.

 

please attach the current version according to forum rules, this will keep people from downloading old version that may not work. 

[shacker 1,055]

according to forum rules section, there is no rule to put the latest version in free modules 

 

Any module you may provide should be attached directly in your post 
Meaning: not with a link to an external website. The modules you are posting here are 100% free. Thus, you can share them just by attaching the ZIP file to the topic. Posts with an external link will be moderated and taken down.
 
Please use your common sense to make this section pleasant for everyone (respect others, be benevolent).

 

So as i said, i have more than 200 free modules and keep on eye on all its hard job when its free, so i always put a warning that can download latest version from our site

[Xavier du Tertre 590]

according to forum rules section, there is no rule to put the latest version in free modules 

 

Still, it would be better. Can you:

 

- edit first post

- replace ZIP with latest one

- reply to the thread with notification of new ZIP

 

Thanks Vekia!

[vekia 8,971]

You probably mean Shacker, right Xav? ;-)

[shacker 1,055]

You probably mean Shacker, right Xav? ;-)

lol, thats becouse have the same module name

Still, it would be better. Can you:

 

- edit first post

- replace ZIP with latest one

- reply to the thread with notification of new ZIP

 

Thanks Vekia!

i do now, for other modules i try to add the latest when update

[Xavier du Tertre 590]

You probably mean Shacker, right Xav? ;-)

 

Yeah sorry, you're like two brothers from a different mother: I love you both too much but I forget who's who.

 

[shacker 1,055]

Yeah sorry, you're like two brothers from a different mother: I love you both too much but I forget who's who.

 

one is taken, but no one knows what

[elvibora 0]

Looks totally awesome - Thanks!!!

[shacker 1,055]

Looks totally awesome - Thanks!!!

iu welcome

[bcsteeve 7]

Does your module delete all database reference to the order?  Such as things like order_invoice, order_payment, etc?  Or just the 'orders' table?  Thanks.

[shacker 1,055]

The module enables the option DELETE, that is hidden in prestashop by default. You can track all the process of the function

[bcsteeve 7]

"You can track all the process of the function"... huh?

 

Anyway, as you can see I asked WEEKS ago, so nevermind.

[shacker 1,055]

as you can see, i have more than 14000 replies and more  than 500 msg every week to respond, so, cant reply fast

[myselfidem 66]

Thansk for this nice module "shaker".

 

It seems there are little typo errors Inside deleteorders.php :

 

on line 98 : wouldn't be ('submitdeleteo') ?

if (Tools::isSubmit('submitedeleteo')) 

on line 531 : wouldn't be : "submitdeleteo' ?

<center><input type="submit" name="submitedeleteo" value="'.$this->l('Save').'" class="button" /></center>

Friendly

Edited August 7, 2015 by myselfidem (see edit history)

[shacker 1,055]

is with submitdeleteo. Where do you download the module?

[shacker 1,055]

I see, its ok, uses different name to 1.6 version

[viktorb92 3]

Hello does this module resets the number of invoices too?

[shacker 1,055]

no. use the ps cleaner that comes with prestashop to delete all and reset

[nrms 0]

Woks fine in ps 1.6.0.11 for now. Thanks!

[shacker 1,055]

thanks for share

[shacker 1,055]

v3.0 - compatible PS 1.7

[Gipielle 22]

Thanks, works on PS 1.7.6.3

Maybe delete all orders buttum in not a good idea ...

[shacker 1,055]

was requested by a lot of users

[Gipielle 22]

OK, so maybe change the look of the button so it not easy to confuse with the other one

[shacker 1,055]

thanks for comment

[PixGeek 74]

 

Hello and thank you for your module.

I have a problem on a 1.7.6.8 ps, when I uninstall and remove the module, the option to remove commands is still present! it's normal ?

************************************

Salut et merci pour ton module

J'ai un probleme sur un ps 1.7.6.8, quand je désinstalle et supprime le module, l'option pour supprimer les commandes est toujours présent ! c'est normal ?

 

[KamikStudio 5]

you can do it without a module

go to the product in the url
/index.php?controller=AdminOrders&vieworder=&id_order

replace vieworder with deleteorder

the order will be deleted immediately and you will return to the order panel

[SalDan 1]

ciao a me esce in questo modo come mai?

.......it/evte5baiutamzbm9/index.php/sell/orders/3/view?_token=ewd9r7VnwTOJ4wliiyDbD435z0saHl_5Mpqd9fehEzU

[Deragos Webdesign 2]

Hi,

Its installed fine on ps 1.7.7.1 but when i try to put it on / activate in the module.. i get error:

Error opening file in /var/www/domains/domainname.*/www/modules/deleteorders/deleteorders.php on line __LINE.

Then it doesnt activate.

Greetings.

[SalDan 1]

ciao allora in pratica non funziona giusto?? ....in tal caso se trovi qualcosa che fa per la nostra versione mi avvisi grazie mille