Jump to content

Export products with SEO data


Recommended Posts

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,

Link to comment
Share on other sites

  • 1 year later...
  • 2 weeks later...

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


I used it for something like this once.


Or make use of your db:

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
Link to comment
Share on other sites


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]


Edited by Zohaib-fk
Post Updated (see edit history)
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...