ProductCart Shopping Cart Software Forums : Mass Delete https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 17:18:42 +0000 Thu, 20 Sep 2007 18:55:40 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=1104 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Mass Delete : As long as you don&#039;t have...]]> https://forum.productcart.com/mass-delete_topic1104_post3306.html#3306 Author: Stuck
Subject: 1104
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]]> Thu, 20 Sep 2007 18:55:40 +0000 https://forum.productcart.com/mass-delete_topic1104_post3306.html#3306 <![CDATA[Mass Delete : I suppose i could copy the database...]]> https://forum.productcart.com/mass-delete_topic1104_post3305.html#3305 Author: bigrasta4life
Subject: 1104
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?]]> Thu, 20 Sep 2007 17:22:30 +0000 https://forum.productcart.com/mass-delete_topic1104_post3305.html#3305 <![CDATA[Mass Delete : Big, Only if you delete ALL of...]]> https://forum.productcart.com/mass-delete_topic1104_post3304.html#3304 Author: Stuck
Subject: 1104
Posted: 20-September-2007 at 4:34pm

Big,

Only if you delete ALL of them with "purgeallproducts.asp" and then re-import the smaller number of products you actually want to use.

I was only trying to explain that this may be faster with your particular situation in that you have so many products to be removed.

However, in Fidjitis case, I am assuming she/he only has a small number of products to remove, so Fidjiti would 1st individually delete these products from the control panel & then run "purgeproducts.asp" (NOT  "purgeallproducts.asp")



Edited by Stuck - 20-September-2007 at 4:40pm]]> Thu, 20 Sep 2007 16:34:27 +0000 https://forum.productcart.com/mass-delete_topic1104_post3304.html#3304 <![CDATA[Mass Delete : Stuck, That is what i&#039;ve...]]> https://forum.productcart.com/mass-delete_topic1104_post3302.html#3302 Author: bigrasta4life
Subject: 1104
Posted: 20-September-2007 at 4:18pm

Stuck,

That is what i've been saying.  My original question was how do i delete a massive amount of products from the control panel without doing it individually.  Is there any way to do this?

THANKS

]]> Thu, 20 Sep 2007 16:18:44 +0000 https://forum.productcart.com/mass-delete_topic1104_post3302.html#3302 <![CDATA[Mass Delete : Fidjiti, Yes, to delete individual...]]> https://forum.productcart.com/mass-delete_topic1104_post3301.html#3301 Author: Stuck
Subject: 1104
Posted: 20-September-2007 at 4:10pm

Fidjiti,

Yes, to delete individual products, then you would 1st delete them individually from your control panel, then to completely remove "all traces" of these products, you would run "purgeproducts.asp". In your case bigrasta is correct in that you would 1st delete the products from the control panel (unless you have already done so).

]]> Thu, 20 Sep 2007 16:10:00 +0000 https://forum.productcart.com/mass-delete_topic1104_post3301.html#3301 <![CDATA[Mass Delete : i dont think so, how i interpreted...]]> https://forum.productcart.com/mass-delete_topic1104_post3299.html#3299 Author: bigrasta4life
Subject: 1104
Posted: 20-September-2007 at 3:59pm

i dont think so, how i interpreted purgeallproducts.asp is that it only purges products that have already been deleted from the control panel.  

so were back to stage one.  I need a way to delete many products at once from the control panel and then purgeallproducts.
]]> Thu, 20 Sep 2007 15:59:14 +0000 https://forum.productcart.com/mass-delete_topic1104_post3299.html#3299 <![CDATA[Mass Delete : Fidjiti, If you run this version...]]> https://forum.productcart.com/mass-delete_topic1104_post3300.html#3300 Author: Stuck
Subject: 1104
Posted: 20-September-2007 at 3:59pm

Fidjiti,

If you run this version "purgeproducts.asp", then you can individually select each product you want to delete from your Database.

Hope this helps!

]]> Thu, 20 Sep 2007 15:59:14 +0000 https://forum.productcart.com/mass-delete_topic1104_post3300.html#3300 <![CDATA[Mass Delete : Bigrasta4life, Not sure if this...]]> https://forum.productcart.com/mass-delete_topic1104_post3298.html#3298 Author: Stuck
Subject: 1104
Posted: 20-September-2007 at 3:53pm

Bigrasta4life,

Not sure if this would help or save you time, however, you could remove ALL of your currently existing products by running this "purgeallproducts.asp"

Then re-import the smaller portion of the products you actually intended to use.

Hope this helps!

 

]]> Thu, 20 Sep 2007 15:53:13 +0000 https://forum.productcart.com/mass-delete_topic1104_post3298.html#3298 <![CDATA[Mass Delete : that wont work for me. You must...]]> https://forum.productcart.com/mass-delete_topic1104_post3297.html#3297 Author: bigrasta4life
Subject: 1104
Posted: 20-September-2007 at 2:45pm

that wont work for me.  You must purge each product individually

]]> Thu, 20 Sep 2007 14:45:37 +0000 https://forum.productcart.com/mass-delete_topic1104_post3297.html#3297 <![CDATA[Mass Delete : does the purge products allow...]]> https://forum.productcart.com/mass-delete_topic1104_post3296.html#3296 Author: fidjiti
Subject: 1104
Posted: 20-September-2007 at 2:30pm

does the purge products allow you to select which products to purge or is it all of them? Also if purging the products does the system then go back to product ID #1 after purging all of them?]]> Thu, 20 Sep 2007 14:30:17 +0000 https://forum.productcart.com/mass-delete_topic1104_post3296.html#3296