Export products with SEO data

[turdi]

Hello All,

 

Is it posible to Export all my product's information to an CSV file from Prestashop?

 

By ALL I mean, all... Data like url, keywords, meta, product details also offcourse. I need to have everything in one spreadsheet to be able to make modification for my other data bases.

 

For example if I will want to migrate from one platform to another and I don't want to loose any SEO ranks that my Links gained over the years. How should I approach this?

 

How do I maintain the same URL and the same url structure? 

 

Any advices on the topic will be appreciated. I need as much information as posible.

 

Thank you,

[pamorel]

Hi,

 

Did you find a solution to your problem?

 

Thank you. 

[BoKr]

You could search the forum for "tripleedit" by MusicMaster.

 

I used it for something like this once.

 

Or make use of your db:

SQL 

SELECT p.id_product, p.active, p.reference, pl.name, GROUP_CONCAT(DISTINCT(cl.name) SEPARATOR ",") as categories, p.reference, pl.meta_title,  pl.meta_description, pl.link_rewrite, pl.meta_keywords

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 = 4

AND cl.id_lang = 1

AND p.id_shop_default = 1

AND c.id_shop_default = 1

GROUP BY p.id_product

[Zohaib-fk]

Hi,

When I tried exporting products ,only columns in product listing in back-office are exported not all columns are exported.

If seo meta title, description ,keywords columns added in listing it will be exported.

We need to have feature to select column to be exported in export process.

PrestaShop Tutorials Videos [How to do Tasks]

https://www.prestashop.com/forums/topic/907438-prestashop-tutorials-videos-how-to-do-tasks/

Edited June 27, 2021 by Zohaib-fk
Post Updated (see edit history)