Delete all products?

[dancingbay]

I think the only thing I might have to reload are the tables for Local Sales Tax Mod. I had to created a table and update a few more for that. There also may be and sql statement or 2 I will need to run for my template which is the Alysa Rounded from PicaFlor Azul, but not sure about that. The plugins I installed were Local Sales Tax Mod and EasyPopulate CSV for the version v1.5.1 of ZenCart I'm running.

I initially installed ZenCart at ControlPanel on HostGator, so am not exactly sure how to run zc_install. I'm doing some research so if I figure it out before I hear from anyone, will post back to let you know I've figured it out.

As far as having a test and live ZenCart, I am assuming for the test cart, I would just do a new install from Control Panel, but designate a folder, like public_html/testcart/ for instance.

Thanks,
Alisa

[dancingbay]

I went to public_html in FileZilla, looking for zc_install/index.php an cannot find that folder. In public_html, I have these folders:

admin-xxx (zencart admin)
cache
docs
download
editors
email
extras
images
includes
logs
media
popups
tempEP
Testing (which is a folder I created to test PHP scripts)

Before I installed this on the server, I played around with it some at localhost. In that install, I have a folder called zc_install_DB. Not really sure why it would be here and not on my server since I did the installs the same way. Any advice. Can I just drag that folder over to my live server?

This is giving me a headache.

Thanks,
Alisa

[DrByte]

As far as deleting "all products", there are a LOT of tables involved, including the ones in each of these three sections:
http://www.zen-cart.com/wiki/index.p...a#Product_Info
http://www.zen-cart.com/wiki/index.p...ricing_Details
http://www.zen-cart.com/wiki/index.p...ra_Information
... plus any tables you've added (ie: plugins or custom coding) that store data related to any specific product or category or attribute or download or extended product information.

[DrByte]

I went to public_html in FileZilla, looking for zc_install/index.php an cannot find that folder. In public_html, I have these folders:
...

Before I installed this on the server, I played around with it some at localhost. In that install, I have a folder called zc_install_DB. Not really sure why it would be here and not on my server since I did the installs the same way. Any advice. Can I just drag that folder over to my live server?

Your Hostgator one-click install would have removed the zc_install folder because it's no longer needed after installation (and shouldn't be left on a live server anyway). So, yes, you could drag and drop it to the server (as long as it's from the same version of Zen Cart).

[Johnnycopilot]

my reply was for an old post question so I deleted it.. sorry.. Just said that I use Apsona Shopadmin.

[philip937]

another option (not saying its the best) is you could use an addon like Easy Populate.

It has the function to delete products, you simpley download the full catalouge then instead of setting the product status to 0 or 1 you set it to something like 8 or 9 then when you up load the file it deletes the products with the status 8or9..

I have used this factily before and havent had any issues with it....yet ;)

[dancingbay]

Is the product still in the database? What about the categories? All the products/categories in the sample data is related to music and computers. All my products are related to things that can be embroidered or engraved. So, that being said, I want it all gone.

I do have EasyPopulate CSV for v1.5.1 installed, but am having a bit of trouble finding any documentation on what each column in the .csv files does.

Using EasyPopulate wold be my first choice if it does away with all the categories/products that are not needed. On that note, if I go to Catalog -> Categories/Products and try to delete a product from that point, on some products, clicking the red x takes me to a sitemap of my site that says page not found. I did go in and change all the categories and on some of those, it's like the product got unlinked or something.

Thanks,
Alisa

[philip937]

I dont believe easy populate will delete categories. just poducts. if you read the documentation there used to be a section where it tells you what to set the product status to make the product delete.

[DrByte]

EP won't reset the product numbers. It will cause the system to leave gaps and start at the next highest product number since the last product number created whether that number was deleted or not.

[philip937]

EP won't reset the product numbers. It will cause the system to leave gaps and start at the next highest product number since the last product number created whether that number was deleted or not.

not sure I understand DrByte, can this cause a problem? or is it just "untidy"?

what do you mean by leaving gaps? can you give an example so I can understand a little better?

Thanks