Prestashop exported old data

[rarakids]

Hi, 

This is a strange problem (for me anyway)

I've made some updates to my prestashop product short descriptions, but when I export data, it exports without my updates.

 

How can I update prestashop DB to make an export with new informations?

Or any other ideea...

 

Thank you.

 

Example:

Old description_short: old example

New description_short: updated example. 

On my website it shows: "updated example"

On export will show: "old example"

 

I use SQL Manager from Advanced Parameters (in BO) with the following query:

 

SELECT pl.name, p.price,p.reference, pl.description_short

FROM ps_product p

LEFT JOIN ps_product_lang pl ON (p.id_product = pl.id_product)

LEFT JOIN ps_category_product cp ON (p.id_product = cp.id_product)

LEFT JOIN ps_category_lang cl ON (cp.id_category = cl.id_category)

LEFT JOIN ps_category c ON (cp.id_category = c.id_category)

LEFT JOIN ps_product_tag pt ON (p.id_product = pt.id_product)

WHERE pl.id_lang = 1

AND cl.id_lang = 1

AND p.id_shop_default = 1 AND c.id_shop_default = 1

GROUP BY p.id_product

[caravntrader]

Hello rarakids,

 

for sure, that is very strage!

I have the same porblem with my database. i tried to restore my catalog, I have made an epoxrt of product and category tables and after i have imported them in a new database i was surprised that my products/categories was not uptodate. i am asking me where are the current data/table, and why this tables still not overwritten?

 

To all our presta-gurus in this forum, any recomondation?

 

Regards