Mass Delete

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

   I suppose i could copy the database locally and then run a querry that deletes all inactive products, then re-upload the database.  Does anybody see any reason why that wouldn't work?

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
bigrasta4life Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 21-June-2007 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote bigrasta4life Report Post Thanks(0) Quote Reply Posted: 20-September-2007 at 5:22pm
	I suppose i could copy the database locally and then run a querry that deletes all inactive products, then re-upload the database. Does anybody see any reason why that wouldn't work?
	K.K.

Stuck Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 09-March-2007 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote Stuck Report Post Thanks(0) Quote Reply Posted: 20-September-2007 at 6:55pm
	As long as you don't have any existing customer orders for these products already in your DB, then that should work fine. For any products which may have an existing customer order tied to, then I would suggest you do a "soft delete" from your control panel so that your customers order history would be retained just for these products. PS: I am sure you are already thinking this, however, personally I would download (2) copies of your access DB so that if you run into any problems after modifying, you still could reupload an original copy of your DB and be quickly back in business! Wow, you have 17,000 plus products in an access database, that is awesome. Edited by Stuck - 20-September-2007 at 7:07pm