Exportar productos desde Prestashop 1.3

Tengo que migrar un proyecto con Prestashop 1.3 a 1.4 y como hay varios procesos y varias personas implicadas en la migración, necesito exportar sólamente los productos de la tienda actual para retocarlos en el entorno de desarrollo. Para ello quiero traerme únicamente las tablas que tienen información de los productos.
El equipo de SEO se encargará de retocar y revisar las fichas de productos y prepararlas para la nueva versión.

He hecho esta lista de tablas para exportar:
[shell]ps_attachment
ps_attachment_lang
ps_attribute
ps_attribute_group
ps_attribute_group_lang
ps_attribute_impact
ps_attribute_lang
ps_category
ps_category_group
ps_category_lang
ps_category_product
ps_customization
ps_customization_field
ps_customization_field_lang
ps_customized_data
ps_feature
ps_feature_lang
ps_feature_product
ps_feature_value
ps_feature_value_lang
ps_image
ps_image_lang
ps_image_type
ps_manufacturer
ps_manufacturer_lang
ps_product
ps_product_attachment
ps_product_attribute
ps_product_attribute_combination
ps_product_attribute_image
ps_product_comment
ps_product_comment2
ps_product_comment2_criterion
ps_product_comment2_criterion_product
ps_product_comment2_grade
ps_product_comment_criterion
ps_product_comment_criterion_product
ps_product_comment_grade
ps_product_download
ps_product_lang
ps_product_sale
ps_product_tag
ps_scene
ps_scene_category
ps_scene_lang
ps_scene_products
ps_supplier
ps_supplier_lang[/shell]
y ahora el script
[shell]user=»root»
password=»»
dbname=»prestashop»
mysqldump -u $user -p$password –add-drop-table –quote-name $dbname ps_attachment ps_attachment_lang \
 ps_attribute ps_attribute_group ps_attribute_group_lang ps_attribute_impact ps_attribute_lang ps_category \
ps_category_group ps_category_lang ps_category_product ps_customization ps_customization_field \
 ps_customization_field_lang ps_customized_data ps_feature ps_feature_lang ps_feature_product \
ps_feature_value ps_feature_value_lang ps_image ps_image_lang ps_image_type ps_manufacturer \
ps_manufacturer_lang ps_product ps_product_attachment ps_product_attribute ps_product_attribute_combination \
 ps_product_attribute_image ps_product_comment ps_product_comment2 ps_product_comment2_criterion \
ps_product_comment2_criterion_product ps_product_comment2_grade ps_product_comment_criterion \
 ps_product_comment_criterion_product ps_product_comment_grade ps_product_download ps_product_lang \
ps_product_sale ps_product_tag ps_scene ps_scene_category ps_scene_lang ps_scene_products ps_supplier \
ps_supplier_lang[/shell]
Quizás también os interese exportar traducciones de prestashop

Actualización:
Tablas para la version 1.4
[shell]
ps_attachment
ps_attachment_lang
ps_attribute
ps_attribute_group
ps_attribute_group_lang
ps_attribute_impact
ps_attribute_lang
ps_cart_product
ps_category
ps_category_group
ps_category_lang
ps_category_product
ps_compare
ps_compare_product
ps_country
ps_country_lang
ps_discount_category
ps_feature
ps_feature_lang
ps_feature_product
ps_feature_value
ps_feature_value_lang
ps_group_reduction
ps_image
ps_image_lang
ps_image_type
ps_manufacturer
ps_manufacturer_lang
ps_product
ps_product_attachment
ps_product_attribute
ps_product_attribute_combination
ps_product_attribute_image
ps_product_comment
ps_product_comment2
ps_product_comment2_criterion
ps_product_comment2_criterion_product
ps_product_comment2_grade
ps_product_comment_criterion
ps_product_comment_criterion_category
ps_product_comment_criterion_lang
ps_product_comment_criterion_product
ps_product_comment_grade
ps_product_country_tax
ps_product_download
ps_product_group_reduction_cache
ps_product_lang
ps_product_sale
ps_product_tag
ps_scene
ps_scene_category
ps_scene_lang
ps_scene_products
ps_stock_mvt
ps_stock_mvt_reason
ps_stock_mvt_reason_lang
ps_tag
ps_wishlist
ps_wishlist_email
ps_wishlist_product
ps_wishlist_product_cart
[/shell]

y el script para la version 1.4:
[shell]
user=»root»
password=»»
dbname=»temp»
mysqldump -u $user -p$password –add-drop-table –quote-name $dbname ps_attachment ps_attachment_lang \
ps_attribute ps_attribute_group ps_attribute_group_lang ps_attribute_impact ps_attribute_lang ps_cart_product \
ps_category ps_category_group ps_category_lang ps_category_product ps_compare ps_compare_product \
ps_country ps_country_lang ps_discount_category ps_feature ps_feature_lang ps_feature_product \
ps_feature_value ps_feature_value_lang ps_group_reduction ps_image ps_image_lang ps_image_type \
ps_manufacturer ps_manufacturer_lang ps_product ps_product_attachment ps_product_attribute \
ps_product_attribute_combination ps_product_attribute_image ps_product_comment ps_product_comment2 \
ps_product_comment2_criterion ps_product_comment2_criterion_product ps_product_comment2_grade \
ps_product_comment_criterion ps_product_comment_criterion_category ps_product_comment_criterion_lang \
ps_product_comment_criterion_product ps_product_comment_grade ps_product_country_tax ps_product_download \
ps_product_group_reduction_cache ps_product_lang ps_product_sale ps_product_tag ps_scene ps_scene_category \
ps_scene_lang ps_scene_products ps_stock_mvt ps_stock_mvt_reason ps_stock_mvt_reason_lang ps_tag \
ps_wishlist ps_wishlist_email ps_wishlist_product ps_wishlist_product_cart
[/shell]


Publicado

en

por

Etiquetas:

Comentarios

Deja una respuesta

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *

Este sitio usa Akismet para reducir el spam. Aprende cómo se procesan los datos de tus comentarios.