How to export all dashboard data to whole new site

[Donnerberg]

Hello,

I wish to delete existing prestashop site and to install whole new prestashop site.

 

Does any1 know how to export and then to import all customers, and all statistic data.

Also I wish to export/import all order informations.

 

In one word, I wish to have all customers, orders and statistics to the new fresh installed prestashop 1.6.1.12.

 

Many, Many thanks.

[jetway]

Well i would back up the database tables mentioned and when the new shop is up and running import the data.

[Donnerberg]

It is possible by theoretically.

But I think that Database structure of rows and colums are little bit different between PS 1.6.0.9 and PS 1.6.1.12.

 

Am I right ?

[DataKick]

I'm afraid you will encounter many problems. For example, order details contain reference to products, so they will be hard to import if you don't transfer catalog data as well. 

 

Generally it's not a good idea to cherry-pick data and try to import them. Instead, it's much easier to transfer whole database, migrate to new db version, and then selectively truncate tables / remove data you don't need. Data that are required / referenced by other tables will not be deleted - mysql will not allow you to do so, unless you turn off the foreign key constraints. 

 

Just my 2 cents

[tapukatata]

It is possible by theoretically.

 

But I think that Database structure of rows and colums are little bit different between PS 1.6.0.9 and PS 1.6.1.12.

 

Am I right ?

 

You ca try like this: 

 

1. Make backup of your database and files

2. Use the module 1-click update to update your prestashop version

3. After the update you can export database tables which you need and import them to new fresh installation of prestashop. 

 

I exported that tables:

 

ps_accessory

ps_attachment

ps_attachment_lang

ps_attribute

ps_attribute_group

ps_attribute_group_lang

ps_attribute_group_shop

ps_attribute_impact

ps_attribute_lang

ps_attribute_shop

ps_category

ps_category_group

ps_category_lang

ps_category_product

ps_category_shop

ps_product

ps_product_attachment

ps_product_attribute

ps_product_attribute_combination

ps_product_attribute_image

ps_product_attribute_shop

ps_product_carrier

ps_product_country_tax

ps_product_download

ps_product_group_reduction_cache

ps_product_lang

ps_product_sale

ps_product_shop

ps_product_supplier

ps_product_tag

ps_specific_price

ps_specific_price_priority

ps_specific_price_rule

ps_specific_price_rule_condition

ps_specific_price_rule_condition_group

ps_stock

ps_stock_available

ps_stock_mvt

ps_stock_mvt_reason 

ps_stock_mvt_reason_lang

ps_tag 

Edited April 19, 2017 by diyan1234 (see edit history)

[Donnerberg]

That is realy smart move.

 

By upgrading PS version, DB would be reconfigured for newer version.

 

So everything I need is to pray that DB would work just fine after update

 

Many thanks diyan1234