niknakgroup Posted August 10, 2005 Posted August 10, 2005 Hello - If i was alittle more awake I could probably figure this one out, but thought maybe somebody already has done so. When I click delete product in my admin panel, it does a wonderful job of removing the products from the database. However, I know that in the next 2 months I am going to have to delete 2000+ products and add about 4000 in their place. My database is already a bit on the heavy side, and I dont want loads of orphaned attributes and cross sell lines in my database. So, I need the delete button to: 1 - delete the product from the products table 2 - delete the product from the products to categories table 3 - locate and remove all lines in the xsell table relating to that product 4 - locate and remove all the attributes associated with that product 5 - locate and remove all reviews related to that product 6 - locate and remove the image from the images folder for that product Has anybody already done this, and if so, would you mind sharing the code to save me from serious brainache! :-" Please note - if I have suggested a contrib above, it doesnt mean it will work! Most of the contribs are not ones I've used, but may be useful for your particular problem.... Have you tried a refined search? Chances are your problem has already been dealt with elsewhere on the forums..... if (stumped == true) { return(square_one($start_over) } else { $random_query = tep_fetch_answer($forum_query) }
♥yesudo Posted August 10, 2005 Posted August 10, 2005 off the top: products_description customers_basket customers_basket_attributes products_notifications Your online success is Paramount.
niknakgroup Posted August 10, 2005 Author Posted August 10, 2005 oh yep - forgot about them! What he just said added into my wishlist please! Please note - if I have suggested a contrib above, it doesnt mean it will work! Most of the contribs are not ones I've used, but may be useful for your particular problem.... Have you tried a refined search? Chances are your problem has already been dealt with elsewhere on the forums..... if (stumped == true) { return(square_one($start_over) } else { $random_query = tep_fetch_answer($forum_query) }
AllTheAbove Posted August 26, 2005 Posted August 26, 2005 oh yep - forgot about them! What he just said added into my wishlist please! <{POST_SNAPBACK}> I am actually interested in getting rid of orphaned attributes/options/values too.. Anyone can help with this please? Thanks Lori
AllTheAbove Posted August 26, 2005 Posted August 26, 2005 I am actually interested in getting rid of orphaned attributes/options/values too.. Anyone can help with this please?Thanks Lori <{POST_SNAPBACK}> Nevermind.. got it figured out.. just needed to go into the phpadmin mysql and delete all the tables..
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.