Is there a module that allows us to specify a date section, Remove the order that has been completed?
Filter mode:
Date Start
Date End
Order Status
Filter the corresponding conditions, Bulk Order Delete.
Is there a suitable module for us to use?
But you don't need any extension for that, if your task is one time. It's much easier to delete orders right from PHPMyAdmin using MySQL query:
DELETE FROM `order` WHERE o.order_status_id IN (1,2,3) AND TO_DAYS(o.date_added) <= (TO_DAYS(NOW()) - 10)
In this example all orders 10 days old and more with statuses 1, 2 or 3 will be deleted. You, of course, can adjust this query to your needs, this is just and example.
NOTE: This is the most basic example, which will delete ONLY orders. If you want to also delete all associated info like vouchers or coupons and restock products from deleted orders, query will be more complex.
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
UK OpenCart Hosting | OpenCart Audits | OpenCart Support - please email info@antropy.co.uk
I actually do the same for missing and unpaid orders. The answer is simple: to keep DB small and healthy.
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
If you keep the order for a long time will only feel chaotic in the order list, So we want to try to streamline the pages of the order page, Would you understand what I mean?
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
Because I am more accustomed to manually delete, After all, if you really delete the data should not be deleted, At least you know how to be deleted.
But I will still tell my boss that there is such a module.
Basically it's the same as you do manually, but doesn't require ANY attention.
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
Can order for specified conditions, when the order is deleted, Do not make any changes in the number of stocks?
Because we are selling limited products, Many products are sold without inventory, My boss does not want to cause a dispute because of the amount of product back.
Does your module be able to avoid this?
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
Our products are added to take the following settings:
Subtract Stock Yes *(All products)
Process the order status of the order:
Bank Transfer (Waiting for payment) Use the order status of this module
Taiwan payment gateway module #1 Processing
Taiwan payment gateway module #2 Pending
Will the order status be used for these payment modules, Whether we delete the order data will not change the number of our product stock?
If not restock, We will consider purchase your module, Because we have the physical store sales.
If we delete the order record, Make a change in the number of our products, That this is a major disaster for us.
Please forgive me that I can only express it as much as possible through Google Translate, I hope you can understand what I mean.
Thank you!
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com
Home / Modules / Auto Delete Orders [Delete After] (Days passed, since order status was changed to selected one.)
Excuse me, If I want to set the order automatically after 90 days to delete, Is it directly in the above input I want the number of days?
E.g: All the orders from now on after 90 days.
Users browsing this forum: Amazon [Bot] and 68 guests