roro_1 Posted July 22, 2016 Share Posted July 22, 2016 Hi! I use PS 1.6.1.6 I am trying to eliminate some products from the database. How can I find them in the database? Thanks Link to comment Share on other sites More sharing options...
rocky Posted July 23, 2016 Share Posted July 23, 2016 It is best to delete them through the Back Office instead of the database, since the products are spread through multiple tables in the database (i.e. all tables starting with ps_product) and missing some data can cause problems with your website. Link to comment Share on other sites More sharing options...
Nishith Nesdiya Posted July 23, 2016 Share Posted July 23, 2016 Hi...i am also agree with Rocky best options is you can delete the backOffice.Thank You Link to comment Share on other sites More sharing options...
roro_1 Posted July 25, 2016 Author Share Posted July 25, 2016 Ok sure, but I wish to delete the products that are Demo and so I can't delte it from Backoffice. Link to comment Share on other sites More sharing options...
bellini13 Posted July 25, 2016 Share Posted July 25, 2016 Ok sure, but I wish to delete the products that are Demo and so I can't delte it from Backoffice. why? go to the catalog > products page and delete them Link to comment Share on other sites More sharing options...
roro_1 Posted July 25, 2016 Author Share Posted July 25, 2016 why? go to the catalog > products page and delete them I can't delte it from Backoffice because the demo-products not seen from catalog but only from database. How can i delete these demo-products? Link to comment Share on other sites More sharing options...
rocky Posted July 25, 2016 Share Posted July 25, 2016 Weird. I don't understand why products would be listed in the database, but not the Catalog. It's the tables starting with ps_product and ps_category_product that you'll need to delete the products from. You'll also need to delete the demo orders in the tables starting with ps_order. Make a backup of these tables first and be very careful in deleting the product data. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now