Deleting 10,000 orders

Store Builder in detail Configuration
#1

Hello,



I need to delete all the orders in my 2.1.3 database as I want to start from order # 1. Deleting page by page is getting quite cumbersome and time consuming.



Is there a way I can delete all the orders in the database in a single shot?



Thnx

#2

Not quite, but you can change the items listed per page by appending the url (adding) &items_per_page=x



Where ‘x’ is 200, 500, 1000 etc.

I don’t suggest more than 500 if you have a decent server. If you find that you are having issues loading the backend after doing this you’ll need to delete cookies as the cart is timing out.



J.

#3

What about locating some DB table and emptying it ?

#4

Any details on which ones ??



thanks for the url shortcut :smiley:

#5

JesseLeeStringer deadly simple concept would have never thought of it DOOOOOHHHHHH





just done 10,000 in 10 mins 900 per go slight delay server didnt even notice :smiley:



THANK YOU u LEGEND

#6

[quote name=‘Lazy’]JesseLeeStringer deadly simple concept would have never thought of it DOOOOOHHHHHH





just done 10,000 in 10 mins 900 per go slight delay server didnt even notice :smiley:



THANK YOU u LEGEND[/quote]



Welcome,



I advise against the db table technique as CS-Cart uses these tables to generate some block elements (Hot Deals etc) and if the orders are removed, you miss out on the ‘bestsellers’

#7

[quote name='JesseLeeStringer' timestamp='1299252470' post='105687']

Welcome,



I advise against the db table technique as CS-Cart uses these tables to generate some block elements (Hot Deals etc) and if the orders are removed, you miss out on the 'bestsellers'

[/quote]





This co

de does not work in the new admin. Is there another code I can use

#8

http://www .yoursite.com/youradmin.php?dispatch=products.manage&items_per_page=500



change the 500 to what you feel is right for your speed

John