CODEWITHSUNDEEP
phpmysqlprestashop
William
William

Reputation: 330

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?

Upvotes: 1

Views: 3246

Answers (1)

Zimmi
Zimmi

Reputation: 1599

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.

Upvotes: 6

Related Questions