joan-coquelin Posted July 10, 2017 Share Posted July 10, 2017 (edited) Hi I need to access my database files to modify the tables ps_product and ps_product_shop. I know the address and password of the databse but how do I use that to access it please ? Thanks a lot ! Joan Edited July 10, 2017 by joan-coquelin (see edit history) Link to comment Share on other sites More sharing options...
selectshop.at Posted July 10, 2017 Share Posted July 10, 2017 1) For to modifiy only FILES, you access the files via FTP and don't need to access the database directly. 2) for to access database: Ask your provider. Usually you have access to phpMyAdmin. With this tool you can access to database. But we advise you to don't manipulate database or data directly into database, if you don't know exactly what you are doing. You can destroy with this your complete shop. The manipulation of database is only reserved to proficient users with knowledge of programming and SQL. 3) For to mount only SQL-queries you can use in the back-office of your prestashop the option: "adanced parameters -> SQL manager". Link to comment Share on other sites More sharing options...
joan-coquelin Posted July 10, 2017 Author Share Posted July 10, 2017 Hi, Thank you very much for your answer. Well maybe if I tell you exactly what I need to do you might be able to provide me with the best and safest solution. In my catalog right now, products can have one of 3 conditions : 'new, used, refurbished'. I need to change used to 'second-hand'. And I also need to translate it in French. Can you help me do that ? Thank you very much. Joan Link to comment Share on other sites More sharing options...
Scully Posted July 10, 2017 Share Posted July 10, 2017 I would recommend to use translation to change that. This way you only adapt the value shown in the front end but not in the database. How to achive this? Go to backoffice -> translations -> translations front office Search for the block 'product' and open it. There you'll find the terms "Condition", "new", "used", "refurbished", Just enter the new values as you want them and click on save. Link to comment Share on other sites More sharing options...
joan-coquelin Posted July 10, 2017 Author Share Posted July 10, 2017 Hi, Exactly what I needed, thank you so much Bye, Link to comment Share on other sites More sharing options...
Scully Posted July 10, 2017 Share Posted July 10, 2017 Very good. Change topic name to SOLVED. Thank you. Link to comment Share on other sites More sharing options...
Teapot Creative Posted July 10, 2017 Share Posted July 10, 2017 Hi Scully, I would recommend leaving the title as it was and just adding a [solved] to the end - that way if anyone has a similar problem, they can find this thread. It will also index in google with the title. Kindest regards Link to comment Share on other sites More sharing options...
Scully Posted July 10, 2017 Share Posted July 10, 2017 That was what I meant to do. But I wasn't clear enough on that. Sorry, my bad. 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