Zen Cart Logo
Forums / General Questions / Removing all products?

Removing all products?

Locked

Views: 1,454

Results 1 to 8 of 8
This thread is locked. New replies are disabled.
5 Apr 2007, 2:31 PM
#1
ddye avatar

ddye

New Zenner

Join Date:
Apr 2007
Posts:
43
Plugin Contributions:
0

Removing all products?

Hi, I'm a Zencart newbie, but I've made some good progress setting up my first shopping cart so far. I have one question...

I worked off of a supplied template and modified it to look like our client's regular site, but I was left with all of the products and categories from the original template. My question is, is there a way to wipe out all products without having to delete them one at a time? If I delete all of the categories, do the products disappear along with them?

There are probably around 100 products still in the template, and deleting them one at a time is a real pain...

Please try to dumb down your answer if you can, as I'm more of a designer than a programmer. I have decent beginner's knowledge of the Admin section though...

Thanks in advance,

Doug Dye

5 Apr 2007, 2:52 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Removing all products?

If you delete the Category it will delete the Products ...

5 Apr 2007, 3:02 PM
#3
ddye avatar

ddye

New Zenner

Join Date:
Apr 2007
Posts:
43
Plugin Contributions:
0

Re: Removing all products?

Ajeh:

If you delete the Category it will delete the Products ...
Thanks, but what about the warning when you delete a category?

*"Warning: Linked Products whose Master Categories ID are deleted will not price properly. You should first assure that when deleting a Category that contains Linked Products that you reset the Product(s) Master Categories ID to another Category before removing a Category"

*That's what confused me, I didn't want a bunch of orphan products around.

Thanks again,

Doug

5 Apr 2007, 3:07 PM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Removing all products?

When all Categories are deleted you should end up without Products ...

The caution is for when you are deleting Categories that have Linked Products and have not reset those Products to utilize a new Category as its master_categories_id ...

As you are not keeping any Products, this warning is not of any major significance ...

5 Apr 2007, 3:14 PM
#5
ddye avatar

ddye

New Zenner

Join Date:
Apr 2007
Posts:
43
Plugin Contributions:
0

Re: Removing all products?

Ajeh:

When all Categories are deleted you should end up without Products ...

The caution is for when you are deleting Categories that have Linked Products and have not reset those Products to utilize a new Category as its master_categories_id ...

As you are not keeping any Products, this warning is not of any major significance ...
Thanks a lot, you've saved me hours of work!

Doug Dye

5 Apr 2007, 7:06 PM
#6
adjb avatar

adjb

New Zenner

Join Date:
Aug 2006
Posts:
6
Plugin Contributions:
0

Re: Removing all products?

I have got a slightly different but similar problem here.

I have tried to delete everything and I now get the following message.

"WARNING: You have Products in the Top Level Category. This will cause pricing to not work properly in the Catalog. Products found: 9"

But I also get...

"ID Categories / Products Model Price/Special/Sale Quantity Status Sort Action

Categories: 0

Products: 0"

Which shows me no products. I am in the Top Category, It is now the only Category.

On the same basis as above is this a "ignorable" problem and can I get rid of the message somehow? I am happy to do manual changes to the database if needed.

ADJB

7 Apr 2007, 1:19 AM
#7
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Removing all products?

If you think you emptied all products and categories ... peek in phpMyAdmin ...

Select the checkboxes on the following:
products
products_description
categories
categories_description
products_to_categories

Technically these should all have 0 records ... you can ensure this by selecting from the dropdown the Empty option ...

It is not a bad idea to scroll through your table listings and just make sure it looks logically clean ...

Example, If you have not products or categories then you have no:
featured
meta_tags_categories_description
meta_tags_products_description
products_attributes
products_attributes_download
product_discount_quantity
products_notifications
specials
reviews
reviews_description
salemaker_sales

etc. etc. etc.

24 May 2007, 11:07 AM
#8
merlin57 avatar

merlin57

New Zenner

Join Date:
Mar 2005
Posts:
22
Plugin Contributions:
0

Re: Removing all products?

Hello I have done an import and have some linked products in the top catagory. Is there a quick way of removing them as there is 150+ and its taking a while.. Would the phpadmin advice earlier work?