ALynn Posted February 4, 2014 Posted February 4, 2014 Is there a way to delete multiple orders at one time ? Once orders are processed and completed we want to delete them from our OSCommerce back office. It is time consuming to select, delete and confirm deletion on each order. Does anyone have another method? Please advise. Thank you.
♥14steve14 Posted February 4, 2014 Posted February 4, 2014 If you delete the orders you are aware that customers will loose their order history, and you as a store will loose all of the backend reporting that would be available if orders were kept. I have many customers that check order history which allows them to see what they purchased before, and to re order them again. I use an add-on that cleans the database and can be set to remove some information from the backend. Its a called Database Optimizer V 1.1 by Jack_mcs. I use this monthly and have never noticed a larger than normal file size in the database. REMEMBER BACKUP, BACKUP AND BACKUP
ALynn Posted February 4, 2014 Author Posted February 4, 2014 No, I was not aware of those details. Thank you. What is the capacity to store orders without the add-on? If you do not know, any suggestions where to find out? thanks.
ken0306 Posted February 4, 2014 Posted February 4, 2014 try this Batch Update Status I only install the deleted order functions and change your sort function by date desc and max record display to 100 or even 1000. You will be able to remove your old orders very fast. ken
ALynn Posted February 5, 2014 Author Posted February 5, 2014 I will check that out too. Still-if anyone knows the capacity for leaving processed orders sit without an add on let me know. thanks.
ken0306 Posted February 5, 2014 Posted February 5, 2014 Don't really know what you mean, there are order filter function on the right hand side. and the batch update status can also deleted function( it has select all build in if you want to select all order that load it to your page). I using that to remove 15000 old orders within 15 mins. Expect that you looking for something that allow you change order status to ship and remove order at the same time. it will be difference story.
burt Posted February 5, 2014 Posted February 5, 2014 Nuke the orders directly in phpmyadmin. You will need to empty; orders orders_products orders_products_attributes orders_products_download orders_status_history orders_total
multimixer Posted February 5, 2014 Posted February 5, 2014 Nuke the orders directly in phpmyadmin. You will need to empty; orders orders_products orders_products_attributes orders_products_download orders_status orders_status_history orders_total Not the table "orders_status", since it contain just a list of available order statuses, not connected to any particular order My community profile | Template system for osCommerce - New: Responsive | Feedback channel
burt Posted February 5, 2014 Posted February 5, 2014 Good spot thanks @@multimixer - I edited my post to reflect that in case people did not read your post as well as mine before trying it!
zefeena Posted November 20, 2014 Posted November 20, 2014 Is there a way to restore a deleted order. Somehow I seem to have deleted a valid order! Thanks Running a botched up version of osCommerce Online Merchant v2.3.4 bootstrap with the dresscode theme installed, numerous add-ons, terrible coding, terrible website, but will have to make do until I have made up for my losses and can risk shutting down for a couple of weeks while I start all over again. - I did not install my program but am endeavouring to fix it with your help.
multimixer Posted November 20, 2014 Posted November 20, 2014 Only if you have a backup of your database that contain that order, if not, then it's gone You still have the email that contain the order details, so you could order the same products your self and change then the customers_id (+ the other customer related fields) in table orders My community profile | Template system for osCommerce - New: Responsive | Feedback channel
zefeena Posted November 20, 2014 Posted November 20, 2014 Hi, Thank you. Yes I did redo the order from the email. The deletion was an error! I just wondered if there was a quick 'undo' but now I know there isn't I'll be more careful! Kellie Running a botched up version of osCommerce Online Merchant v2.3.4 bootstrap with the dresscode theme installed, numerous add-ons, terrible coding, terrible website, but will have to make do until I have made up for my losses and can risk shutting down for a couple of weeks while I start all over again. - I did not install my program but am endeavouring to fix it with your help.
burt Posted November 20, 2014 Posted November 20, 2014 Is it a good idea to allow shopowners to actually delete orders? Is there any reason why an order should be entirely deleted?
♥GLWalker Posted November 20, 2014 Posted November 20, 2014 Is it a good idea to allow shopowners to actually delete orders? Is there any reason why an order should be entirely deleted? That's a question that can have answers go either way. Its also a depends on such and such answer. If a store is getting a large amount of orders, I feel it is a good idea to clear out orders older than so many years - at the very minimum 4 years from date. This leaves a full 3 years of data for tax purposes in the U.S. After all, what does one really do with the data after so many years. The alternative is to back it up to a disk first, then archive it in a filing cabinet to set there collecting dust in the rare occurrence something in there will be needed. Just like a brick-n-mortar. But - It also depends on your industry, customer base, local laws, etc; Follow the community build: BS3 to osCommerce Responsive from the Get Go! Check out the new construction: Admin Gone to Total BS!
♥joli1811 Posted November 20, 2014 Posted November 20, 2014 Tax man haha seriously though The order tables can include credit card details which should not be there I have deleted on older sites databases ( orders table) that included full details maybe ok 20 years ago but not today it should simply not be stored most sites have it xxxx but came across a few with the full details Now not 100% about this as the databases in question have been cleansed just my old memory so no records but if I am correct it is a good reason to delete older records but not applicable I guess to newer versions so end of the day older sites should check and delete records if found in the orders table with credit details newer sites shoud not have the problem in the first place?? Regards Joli To improve is to change; to be perfect is to change often.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.