hedererjs

ASPerience DeleteOrders

  • Popularity Score 10483 Popularity Score

    Popularity ScoreReferrals to Site/Downloads

    0 0 1+ 1+ 250+ 250+ 1000+ 1000+ 10000+ 10000+

Extension allowing to delete selected test or production orders.
Compatible with:
This extension is currently unavailable on Magento Connect. Please contact the developer.

You will be re-directed to the developer's website to complete your purchase.

You must be registered and logged in to get extension key.
In order to get this extension, you must be logged in to the Magento Community. Click here to login or register.
In order to get this extension, you must have active Magento Go Store. Click here to create Go store.
You must choose from Magento Connect Version 1.5.1.0 or 2.0.
Learn more

Magento Connect 1.0 change

FREE
Previous Next
Overview

ASPerience DeleteOrders

In  Magento, you can't delete orders. This extension allows to delete : 1) selected sales orders without any invoice/shipment/credit memo => level 1 2) selected sales orders and linked invoices, shipments and credit memos => level 2 You can set the status of orders you want to delete in the configuration section.

Warning: It's  preferable to delete only the testing orders during the development of your local website.You take risks if you delete Orders directly in your Website.

 

Configuration path: Configuration/Sales/Sales/Deletion of Orders

This module is developed by ASPerience http://www.asperience.fr

Module can be tried on http://demomodules.asperience.fr/

Vidéo DailyMotion Vidéo Youtube

 

====Warning=====

For your sites with downloader 1.0, you should download latest package and install manually as upload doesn't work for this channel version.

====Releases=====

  • 0.2.7 Sales tax deletion + comments refactoring + packaging correction
  • 0.2.4 Quotes deletion + comments refactoring
  • 0.2.3 specific code for those who don't have any more the constraints between a grid and the flat table, messages improvementand deletion of sales_order_tax lines
  • 0.2.2 There was an error in packaging of previous version (deletes inactive for some tests)
  • 0.2.0 ACL, messages improvement, delete correction for grids and status list extension
  • 0.1.9 State/status correction
  • 0.1.8 Changing supported releases
  • 0.1.7 Refining control on options and warning message depending on options defined
  • 0.1.6 Adding german translate and configuration statuses
  • 0.1.5 Fixing secure url bug
  • 0.1.4 Deleting order grid rewrite
  • 0.1.3 Adding compatibility with 1.4.2/1.5 and deleting order grid rewrite
  • 0.1.2 Changing Beta version to Stable
  • 0.1.1 Adding compatibility with 1.4
  • 0.1.0 First release

 

Magento by default does not allow you to delete orders.
Release Notes

State/status correction

2012-06-02 22:50:28
  • Version number: 0.1.9
  • Stability: Stable
  • Compatibility: 1.3, 1.4, 1.4.1.1, 1.4.2, 1.5, 1.6, 1.6.1, 1.6.2.0, 1.7
You must be registered and logged in to get extension key.

Magento Connect 2.0

Magento Connect 2.0

There was a mistake in validating deletes. 'state' order was taken instead of 'status'

Supported releases

2012-04-30 22:24:13
  • Version number: 0.1.8
  • Stability: Stable
  • Compatibility: 1.3, 1.4, 1.4.1.1, 1.4.2, 1.5, 1.6, 1.6.1, 1.6.2.0
You must be registered and logged in to get extension key.

Magento Connect 2.0

Magento Connect 2.0

Release available and works for pre and post 1.5

Refine

2012-04-09 15:43:15
  • Version number: 0.1.7
  • Stability: Stable
  • Compatibility: 1.3, 1.4, 1.4.1.1, 1.4.2, 1.5, 1.6, 1.6.1, 1.6.2.0
You must be registered and logged in to get extension key.

Magento Connect 2.0

Magento Connect 2.0

Refining control on options and warning message depending on options defined

Adding german translate. Adding Statuses configuration.

2012-02-06 09:05:45
  • Version number: 0.1.6
  • Stability: Stable
  • Compatibility: 1.2, 1.3, 1.4, 1.4.1.1, 1.4.2, 1.5, 1.6, 1.6.1
You must be registered and logged in to get extension key.

Magento Connect 2.0

Magento Connect 2.0

Adding german translate.
Adding Statuses configuration.

Extension allowing to delete all Test Orders.

2012-01-24 17:06:29
  • Version number: 0.1.5
  • Stability: Stable
  • Compatibility: 1.3, 1.4, 1.4.1.1, 1.4.2, 1.5
You must be registered and logged in to get extension key.
You must choose from Magento Connect Version 1.5.1.0 or 2.0.
Learn more

Magento Connect 1.0 change

This extension allows to delete selected sales orders, invoices, shipments and credit memos.
Sales orders must be have status: « cancelled », « ended » or « closed ».

Warning: It's preferable to delete only the testing orders during the development of your local website. You take risks if you delete Orders directly in your Website.
Reviews

About the Developer

This extension was developed by and is supported by hedererjs

ASPerience DeleteOrders 4.4 5 70 70
Doesn't work Selecting multiple orders: Selected order(s) can not be deleted Single select: There are no shipping labels related to selected orders. Also, the dropdown shouldn't say "Delete All!" as that is misleading, it should say "Delete Selected" Either way, it doesn't work. September 19, 2013
Saves a Lots Of Time. This extension is very helpful. It's saves me a lots of time. This is easy to install and configure. We are happy with this. Many thanks to development team. August 19, 2013
Just perfection 3 clicks and I am clean :D hehe great tool. What I like the most is the possibility of customuzation. July 15, 2013
Nice extension Usefull extension, working perfectly on Community Edition 1.7.2.0 June 4, 2013
Great Extension Easy helper to clean up some testing-stuff. The last update brought the delete-option for "pending_payment" and now it's the perfect cleanup-tool :) April 23, 2013
Works great. Follow up on my review below I wrote review "Not deleting anything but reporting it did delete ok" The issue was fixed the same day and with the new version 0.22 everything works great on my magento 1.702 the only thing i had to cleanup manually the get a fresh start before going live were tables: sales_bestsellers_aggregated_monthly; sales_bestsellers_aggregated_yearly; sales_order_tax; sales_flat_quote; report_event; report_viewed_product_aggregated_daily; report_viewed_product_aggregated_monthly report_viewed_product_aggregated_yearly; report_viewed_product_index; -- truncate thanks, michel April 22, 2013
Not deleting anything but reporting it did delete ok Installation smooth via the installer. Changed Admin config to select all order types for delete. When i delete the orders in admin the system reports that orders/invoices etc are deleted ok, but all orders are still in de admin grid and also in the database. no records in any table are getting deleted for example tables: sales_flat_order; sales_flat_order_grid; containt same amount of records before and after the delete. strange :) Magento version 1.7.0.2 with greyscale theme April 18, 2013
Needed to manually erase db tables to clear backoffice Orders where deleted but they still appeared on the backoffice orders list....the same for invoices and shipments. Had to manually empty the following tables: sales_flat_order_grid sales_flat_invoice_grid sales_flat_shipment_grid Hope this helps someone April 15, 2013
Good stuff Working fine with 1.7 I cant understand why this feature is not included in Magento. Thank you very much DEV :) April 9, 2013
Fast & Easy! I added this module and it worked immediately and flawlessly! Love it! March 11, 2013
<<prev2 3 4 5 ... 7 next>>
Q&A
(1 Question : 2 Answers)

Product Q&A

Ask your questions. Share your answers.

 
 
« Back
 
 
Avatar Image Url:: http://www.magentocommerce.com/images/avatars/uploads/avatar_26957443
Customer avatar
We deleted the orders... some say cannot delete them, and when we go to look at them, get a message saying the order doesn't exist...

how do we get this cleaned up totally so we can take this store live?

thanks,
MB
by
mjbrafford
-
1 year, 8 months ago
0points
0out of 0found this question helpful.
Was this helpful?Yes0No0

Answers

Avatar Image Url:: http://www.magentocommerce.com/images/avatars/uploads/avatar_64364
Customer avatar
Answer: 
You lack integrity constraints between grid tables and normal tables. You must have something in installation that has gone bad or a module that deleted these. If you install magento on a fresh database you see these constraints.

You must delete lines in "sales_flat_order_grid", "sales_flat_invoice_grid", "sales_flat_shipment_grid" and "sales_flat_creditmemo_grid"

SQL is:

delete from sales_flat_order_grid where not exists (select * from sales_flat_order B where entity_id = B.entity_id)

you can run this before to list lines to delete:
select * from sales_flat_order_grid A where not exists (select * from sales_flat_order B where A.entity_id = B.entity_id)

and so on for the 3 other tables
by
hedererjs
-
1 year, 8 months ago
-1point
0out of 1found this answer helpful.
Was this helpful?Yes0No1

Avatar Image Url:: http://www.magentocommerce.com/images/avatars/uploads/avatar_64364
Customer avatar
Answer: 
Hi,

New versions of module detect if specific deletion of grid tables must be done, when there is a lack of integrity constraints
by
hedererjs
-
6 days ago
0points
0out of 0found this answer helpful.
Was this helpful?Yes0No0
1 of 1
1 of 1
Get Help

Support for This Extension

The best place to start if you need help with a specific extension is to contact the developer. All Magento developers have both a contact email and a support email listed.

Magento Platform Support

If you need support for a Magento platform, there are different options for support depending on which Magento platform you are using. Below are links for specific platforms.

In order to upload extension, you must be logged in to the Magento Community. Click here to login or register.

Close

Register

* Required Fields

Close window

Forgot Your Password?

Please enter your email below and we'll send you a new password.

* Required Fields

Close window

Login

To upload extension you must be logged in.

* Required Fields

Close window

You are using an outdated browser

We built Magento Connect using the latest techniques and technologies.
This makes Magento Connect faster and easier to use.
Unfortunately, your browser doesn't support those technologies.
Use the links below to download a new browser or upgrade your existing browser.