VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: kittmaster on August 25, 2012, 23:43:54 PM

Title: How do I remove all products ONLY but not starting from a fresh install??
Post by: kittmaster on August 25, 2012, 23:43:54 PM
I have 27K products and I have duplicate SKU's, so I need to remove ALL the products via sql phpmyadmin.  How do I clean out all the products and all associated data without corrupting the reset like shipping payment etc??

I know the old version 1 had a MYSQL script that everyone knew about, but the tools in the admin area are for 'starting over'.  I only want to do a product sweep nothing more.

Anyone know how to do this?

Thanks
Title: Re: How do I remove all products ONLY but not starting from a fresh install??
Post by: kittmaster on August 26, 2012, 01:56:04 AM
Never mind, the CSVI import tool can do it in the maintenence tab > empty database.......done.....and its fast.

Hope this helps others.