ChrisDJ Posted July 10, 2003 Share Posted July 10, 2003 I'm completely reorganizing the category structure of my store. Currently there are over 1600 items in my store. I will be using EasyPopulate to upload the items in there new category structure. I need a quick and dirty way to delete the old items that reside in the old category structure. (I really just wish easy populate would change the categories, rather than create items in new categories, leaving the old items in the old categories behind) What's the quickest way to get this done? I use myPHPAdmin to administer the sql database. Thanks! Link to comment Share on other sites More sharing options...
hankfrid Posted July 10, 2003 Share Posted July 10, 2003 I'm sure others out here more experienced with MySQL will eventually respond, but in the meantime: I believe you should have an option once you select a table in PhpMyAdmin to "Empty" the table. Just empy your category and product tables and then do your reload. HankFrid If I build it...they will come. If I don't try to build it.....I will never know! Link to comment Share on other sites More sharing options...
ChrisDJ Posted July 11, 2003 Author Share Posted July 11, 2003 hankfrid, thanks. I'll try that locally to see what happens, and go from there. Any other ideas? Link to comment Share on other sites More sharing options...
mattcald Posted July 14, 2003 Share Posted July 14, 2003 There is a contribution that will wipe all products and product attributes from the database. It is called "Empty Database". ** God Bless ** --------------------- Link to comment Share on other sites More sharing options...
Tright Posted November 4, 2004 Share Posted November 4, 2004 There is a contribution that will wipe all products and product attributes from the database. It is called "Empty Database". <{POST_SNAPBACK}> This Contribution is exactly what I need - newbie doing some testing to get my feet wet and I'm getting comfortable quickly but made a few mistakes with multiple loads of products and attributes. Can someone please advise where and how this contribution should be installed? Thank you :D Link to comment Share on other sites More sharing options...
Tright Posted November 4, 2004 Share Posted November 4, 2004 This Contribution is exactly what I need - newbie doing some testing to get my feet wet and I'm getting comfortable quickly but made a few mistakes with multiple loads of products and attributes. Can someone please advise where and how this contribution should be installed? Thank you :D <{POST_SNAPBACK}> Can anyone help on this??? Thanks Link to comment Share on other sites More sharing options...
Guest Posted November 4, 2004 Share Posted November 4, 2004 Doug, It contains a SQL file. Just run the SQL code using phpMyAdmin or your Control Panel. It's a one time run to clean out your database, not code to be integrated into your site. ed Link to comment Share on other sites More sharing options...
Guest Posted November 4, 2004 Share Posted November 4, 2004 http://www.oscommerce.com/forums/index.php?showtopic=45037&st=0 courtesy of one of the team members Link to comment Share on other sites More sharing options...
Tright Posted November 4, 2004 Share Posted November 4, 2004 http://www.oscommerce.com/forums/index.php?showtopic=45037&st=0 courtesy of one of the team members <{POST_SNAPBACK}> Thank you very much!!! :D Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.