cyberfruits Posted December 2, 2016 Share Posted December 2, 2016 Hi I have a lot of products in my shop which are no longer available and would like to mass delete them, but not the categories or subcategories, so that i can use easy populate to put current products back. Any idea would be appreciated. Thanks Link to comment Share on other sites More sharing options...
♥BlueBunyip Posted December 2, 2016 Share Posted December 2, 2016 Have a look at Multiple Product Manager: http://addons.oscommerce.com/info/8034 Link to comment Share on other sites More sharing options...
cyberfruits Posted December 2, 2016 Author Share Posted December 2, 2016 Have a look at Multiple Product Manager: http://addons.oscommerce.com/info/8034 Yes thank you just installed it and i think it will do it. Link to comment Share on other sites More sharing options...
ecommunlimited Posted December 2, 2016 Share Posted December 2, 2016 @@cyberfruits If you are trying to wipe them ALL OUT at one time you can do it in your database. With phpMyAdmin you can go to the products table and while their click on the Operations tab. Once it opens up, scroll down to "Empty the table (TRUNCATE)" and click on it. Then click OK when the pop up appears. It will wipe everyone of your products out that quick. You can do that for any table. Just beware that it wipes them all out and not individual ones. Take care Bill Link to comment Share on other sites More sharing options...
♥kymation Posted December 2, 2016 Share Posted December 2, 2016 I do not recommend that you modify the database directly unless you have a clear understanding of the osCommerce database structure. To remove all of your products, you need to truncate the products, products_description, and products_to_categories tables. Failure to empty all three tables will leave behind entries that could cause problems when you add or restore products. It's better to spend the time needed to delete products using the stock osCommerce Admin interface or a properly written Addon. No matter which method you chose, make a full database backup before you start in case something goes wrong. Regards Jim See my profile for a list of my addons and ways to get support. Link to comment Share on other sites More sharing options...
ecommunlimited Posted December 2, 2016 Share Posted December 2, 2016 @@kymation I should of told him about the other tables. That was my bad for not doing so. Although, the average person won't mess with their database unless they understand how it works. I'd like to think you would agree that, if they do know their way around a database then, that is the quickest way to do it. Take care Bill Link to comment Share on other sites More sharing options...
♥kymation Posted December 2, 2016 Share Posted December 2, 2016 It is certainly the fastest, but it is also the most dangerous. I just wanted him to know the risks before he got into too much of a mess. It's not like I have never messed up and had to restore a table. Not fun. Regards Jim See my profile for a list of my addons and ways to get support. Link to comment Share on other sites More sharing options...
ecommunlimited Posted December 2, 2016 Share Posted December 2, 2016 @@kymation It can be dangerous, I'll concede to that. I messed up a whole lot of times with osC. There's a definite learning curve to it. Backups are my best friend. I'll try to advise better next time. Take care Bill Link to comment Share on other sites More sharing options...
cyberfruits Posted December 2, 2016 Author Share Posted December 2, 2016 Yes thanks for all info,i did look at the tables before, but decided not to go ahead with that, after all it is the hart and brain of the shop.I now have done it using the ad on above mentioned, but thanks for the info. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.