Get The Full Details of Products in MySQL Database in PrestaShop

If you want to get the complete lists of products which are currently on your PrestaShop based website using MySQL database, then use the below MySQL queries.

prestashop

how to get full details of each product item in mysql database in prestashop

Follow the below steps to get the complete details of each product in MySQL database.

Step 1) Login to your cPanel and search PhpMyAdmin.

Step 2) Open PhpMyAdmin and select the current database.

Step 3) Click on the SQL tabs and copy the below MySQL queries and execute it.

After executing below MySQL queries, you will get the full details of your every product.

Note: If you are using the custom database table prefix, then replace the database table prefix from “ps_” to your custom database table prefix.

If you like FreeWebMentor and you would like to contribute, you can write an article and mail your article to [email protected] Your article will appear on the FreeWebMentor main page and help other developers.

Recommended Posts:


Prem Tiwari

An engineer by profession and a passionate blogger by heart. Founder of FreeWebMentor.com (A Programming blog for beginners), Tech Speaker at various forums. A part from this he is an open source enthusiast, WordPress Lover, Blogger, SEO, and Growth Strategic.

Article Tags: , , , ,