Aymen Kareem Aymen Kareem - 1 month ago 18
MySQL Question

Where is the Text of Product Description Stored in Prestashop Database

I am working on building a database for online shop using Microsoft SQL Server. I downloaded Prestashop and installed it on my machine. I am working out its database which seems very complicated.

What stopped me is when I view the product table in Prestashop as admin, I can see text description of each item. But when I view it in the MySQL database I can't see it!!! (I am using XAMPP to view the database) I mean there's no column called description or something. Any one knows where they hide the text?

Answer

In PrestaShop, the texts are saved to database in tables that have their names ending in _lang, in your case it is ps_product_lang (ps_ is default prefix). This allows the relation to to many as a text can be in more than one language.