Hi. My vendor described over 400 products erroneously as coming with a CD. Since my site is about products with CDs, I need to turn those products off or remove them.
I am thinking about what is best for the efficient operation of the site. I have about 1700 products plus the 400 I need to remove.
1. If I remove them completely, one by one, will that speed up the site?
2. I am assuming if I just turn them off, it will slow down the site. Is that correct?
3. I thought of making a new category of these products, which would allow them to be all in the same place. That would cause them to be listed twice but because they would then be in the same location, I could more easily delete them from the original categories and then either leave them as a new category without CD at maybe a bargain price, or use this as a way to find them and delete them more easily than searching for the product numbers in many categories and deleting one by one.
4. Is there possibly a quick way to just use PHPMyAdmin to change the setting from on to off, so as to bypass the Zen Cart Admin process which takes so much time one-by-one?
I prefer quicker methods, so assuming I need to go through Admin to make things work right, I am leaning towards setting them in a new category using Easy Populate as in #3 to simplify finding the products, deleting from the 2nd category, and then possibly just deleting the entire new category.
Thanks for any opinions or information.
Bookmarks