How to empty/clear database?

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Is there a way to clear the database of all existing products and categories? We haven't gone live with the store and want to completely rearrange how things are organized.
Thanks

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
padreick Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 20-February-2012 Status: Offline Points: 24	Post Options Post Reply Quote padreick Report Post Thanks(0) Quote Reply Topic: How to empty/clear database? Posted: 11-November-2013 at 5:41pm
	Is there a way to clear the database of all existing products and categories? We haven't gone live with the store and want to completely rearrange how things are organized. Thanks

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 11-November-2013 at 5:51pm
	search the wiki for "purge products"

Guests Members Profile Send Private Message Find Members Posts Add to Buddy List Guest	Post Options Post Reply Quote Guests Thanks(0) Quote Reply Posted: 11-November-2013 at 10:54pm
	As the wiki is notoriously weak in its search feature, here's the link to the article: http://wiki.productcart.com/how_to/remove_all_products Versions 4.5+ include this page in the control panel (purgeAllProducts.asp), but without a link to it (because it's dangerous to give easy access to!). This is all the more reason to make sure you have renamed your control panel folder to something cryptic! This will not, however, enable you to delete all categories. If you have so many of them that it's arduous to manually delete them all via the control panel, it is very simple to delete them all via script (or even easier with direct access to the database). Also, just a heads up that there is some confusing terminology here: "delete" a product in the control panel actually just flags it as "removed" in the database; while "remove" in this tool actually does delete it from the database entirely.

padreick Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 20-February-2012 Status: Offline Points: 24	Post Options Post Reply Quote padreick Report Post Thanks(0) Quote Reply Posted: 12-November-2013 at 3:08pm
	Thank you! I guess I couldn't get the wording right to find it on google. I was trying to clear the database all at once, but removing all the products and then deleting the categories should work just fine. I appreciate the help.