neptune Posted January 8, 2004 Share Posted January 8, 2004 I know it is probably a dangerous thing to do, but does anyone have an SQL statement that will delete an item in the database that is marked as inactive? Link to comment Share on other sites More sharing options...
Guest Posted January 8, 2004 Share Posted January 8, 2004 first, backup the database on the server. then backup the database locally. then use mysql connector or phpmyadmin to go to the product table and select the item you want deleted, then delete it. one thing to consider if you do this, the customers who have ordered this item, if they go to see their orders, this item no longer will show . . . Link to comment Share on other sites More sharing options...
neptune Posted January 8, 2004 Author Share Posted January 8, 2004 Thanks a lot. That worked just fine and is a lot easier than doing it through the catalog admin. My store is not live just yet and I've been working through the procedures I'll use when it is. ...Working right now with the Easy Populate module. Later today the big one: how I'll set up PayPal. Link to comment Share on other sites More sharing options...
Guest Posted January 8, 2004 Share Posted January 8, 2004 use paypal ipn, more detail and you dont lose orders Link to comment Share on other sites More sharing options...
neptune Posted January 9, 2004 Author Share Posted January 9, 2004 Yeah, well...I've tried both the PayPal IPN v0.981 for Milestone 2 and the PayPal_Shopping_Cart_IPN v1.5 modules and can't get either one to work right. I've posted my issues regarding that on a different topic. 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.