Mass Delete
Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=1104
Printed Date: 17-February-2025 at 12:41am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: Mass Delete
Posted By: bigrasta4life
Subject: Mass Delete
Date Posted: 20-September-2007 at 10:12am
|
At one point I imported my entire parts inventory (about 17,000 products). I now regret that becasue I will only be using a small fraction of those products. I fear that these unused products will slow down queries to my access database. Any suggestions on how to delete a massive amount of products at one time would be helpful. The Global Change doesn't seem to have this option. Thanks ------------- K.K. |
Replies:
Posted By: Stuck
Date Posted: 20-September-2007 at 1:59pm
|
This FAQ should be helpful to you: http://www.earlyimpact.com/faqs/afmviewfaq.asp?faqid=379 - http://www.earlyimpact.com/faqs/afmviewfaq.asp?faqid=379 |
Posted By: fidjiti
Date 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?
------------- Linda - I wish I knew ASP. To view my ever evolving site click the "www" button below. :) |
Posted By: bigrasta4life
Date Posted: 20-September-2007 at 2:45pm
|
that wont work for me. You must purge each product individually ------------- K.K. |
Posted By: Stuck
Date 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!
|
Posted By: bigrasta4life
Date 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. ------------- K.K. |
Posted By: Stuck
Date 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! |
Posted By: Stuck
Date 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). |
Posted By: bigrasta4life
Date 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 ------------- K.K. |
Posted By: Stuck
Date 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") |
Posted By: bigrasta4life
Date 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. |
Posted By: Stuck
Date 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. |