Question about the Purge Product utility

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

   I occasionally use the Purge-Product utility to keep the database cleaned up.  I've always done it "one product at a time."  There is a button that is labeled "Remove All Products."  Is that referring to only those products that are marked as "deleted," or does it truly remove every product in the database?

Thanks,
Paul

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
paul Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 25-February-2008 Status: Offline Points: 0	Post Options Post Reply Quote paul Report Post Thanks(0) Quote Reply Topic: Question about the Purge Product utility Posted: 17-June-2008 at 3:03pm
	I occasionally use the Purge-Product utility to keep the database cleaned up. I've always done it "one product at a time." There is a button that is labeled "Remove All Products." Is that referring to only those products that are marked as "deleted," or does it truly remove every product in the database? Thanks, Paul

Hamish Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 12-October-2006 Location: United Kingdom Status: Offline Points: 56	Post Options Post Reply Quote Hamish Report Post Thanks(0) Quote Reply Posted: 01-July-2008 at 3:59am
	Hi Paul, PurgeAllProducts is the "Atom Bomb" page for products and orders, and potentially Categories. It's NOT just cleaning up - it's wiping the DB. If you select the link your taken to a page reading :- This is a dangerous feature. It allows you to completely remove all products from your database. When you take this action you will completely delete all products. All orders must and will be deleted as well. This action is permanent and cannot be undone. In other words - unless you want to start again with a new set of products avoid it at all costs. :-) PurgeProducts is dangerous too. As well as removing Products it removes ORDERS that contain those products - so you lose some of your sales history & I suspect any financial figures you extract are also going to be incorrect as a consequence. I would advise not doing this for any product where you need to preserve related order details.
	Editing ProductCart Code? See WIKI Guidelines for Editing ProductCart's ASP Source Code

adezigngirl Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 11-October-2011 Status: Offline Points: -4	Post Options Post Reply Quote adezigngirl Report Post Thanks(0) Quote Reply Posted: 26-April-2012 at 5:04pm
	My admin page is extremely slow, without purging product what can I do to make it less slugish?

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: 26-April-2012 at 5:18pm
	Well, there is no straight answer to this, and purging products is not high on the list of steps I'd be thinking about. Is only the back end of the store slow? Not the front end? Is there a chance that you are on a discount host and a heavily loaded server? Might you need to ask the host to move your site to a faster box with fewer sites? Maybe consider a host who places fewer sites on their servers? Assuming you have a fast internet connection, and without having someone observe this and perhaps do something like running a tracert to see what the hops look like, it's pretty tough to speculate what the cause of the performance issue might be. Have you checked this from other locations?

adezigngirl Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 11-October-2011 Status: Offline Points: -4	Post Options Post Reply Quote adezigngirl Report Post Thanks(0) Quote Reply Posted: 26-April-2012 at 5:42pm
	we have just upgraded our designated server to more space. our website is fast but our admin page is slow. i will submit a ticket and have someone look at it.