How to empty/clear database? |
Post Reply |
Author | |
padreick
Newbie Joined: 20-February-2012 Status: Offline Points: 24 |
Post Options
Thanks(0)
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
Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238 |
Post Options
Thanks(0)
|
search the wiki for "purge products"
|
|
Guests
Guest |
Post Options
Thanks(0)
|
As the wiki is notoriously weak in its search feature, here's the link to the article:
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
Newbie Joined: 20-February-2012 Status: Offline Points: 24 |
Post Options
Thanks(0)
|
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.
|
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |