seelecomunicacion Posted January 26, 2015 Share Posted January 26, 2015 I created a few test orders to my online store while I'm in test environment. I want to leave the database clean to pass to real environment, could you tell me what tables I have to go to clear orders? I made a selection in the image of which I think I have to delete but i'm afraid of make a mistake. If I to erase the orders in the database all fictitious billing orders will begin with the number # 1 or I do something else? Thanks!!!! Link to comment Share on other sites More sharing options...
cristic Posted January 26, 2015 Share Posted January 26, 2015 Use default "PrestaShop Cleaner" module for this. It is safer. Link to comment Share on other sites More sharing options...
seelecomunicacion Posted January 26, 2015 Author Share Posted January 26, 2015 Use default "PrestaShop Cleaner" module for this. It is safer. I I researched about that module and people commented that gives errors in the database and in the end you have to delete the lines by hand, so I prefer to learn how to do the database by hand. Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted January 28, 2015 Share Posted January 28, 2015 it is recommended (by me) to simply cancel the orders, they will drop out of site over time. Never delete anything. Link to comment Share on other sites More sharing options...
zombie process Posted January 31, 2015 Share Posted January 31, 2015 You can override (or simply edit) the adminorderscontroller to enable the delete option (even bulk delete if you want) Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted January 31, 2015 Share Posted January 31, 2015 it is recommended (by me) to simply cancel the orders, they will drop out of site over time. Never delete anything. listen to me, thank me later. so many destroyed perfectly good shops thinking 'cleaning' was a good idea..... Link to comment Share on other sites More sharing options...
zombie process Posted February 1, 2015 Share Posted February 1, 2015 If it's about deleting test orders from a preproduction site, I don't see the problem. Besides, deleting orders is not that big of a deal if you know what you're doing. Link to comment Share on other sites More sharing options...
PrestaHeroes USA Posted February 1, 2015 Share Posted February 1, 2015 If it's about deleting test orders from a preproduction site, I don't see the problem. Besides, deleting orders is not that big of a deal if you know what you're doing. yes, until later on when you start seeing ghost products attached to your cart and orders, amongst other things. I recommend at nausem to just cancel orders, disable products and let them roll off as you get new orders. yes, knowing what you are doing or not, is why I post this warning. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now