Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Deleting Orders


ALynn

Recommended Posts

Posted

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.

Posted

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

Posted

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.

Posted

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

Posted

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.

Posted

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.

Posted

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

Posted

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

  • 9 months later...
Posted

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.

Posted

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

Posted

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.

Posted

Is it a good idea to allow shopowners to actually delete orders?  Is there any reason why an order should be entirely deleted?

Posted

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!

Posted

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.

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...