New Magento 2 theme / design change

[mousepad]

So I want to completely reskin my site. I have a lot of sales data, product info and customer information in it. What is the best way to tackle this? If I start from scratch with a fresh install, then I need to export all customers, product, attributes, sales, promotional codes etc. from the live site and import into the new site.

If so, what are the tables that I would need to export and reimport into the new site to keep all my data ?

[mousepad]

Alternatively, should I start with the current live site, make a duplicate with all data and then once the design is working on staging site, export all design tables and config tables and any files import those into the original live site ?

[Sunil Patel]

Hello ,

There is very hard to do manually data transfer from Magento 1 to Magento 2.

More info:https://github.com/magento/data-migration-tool

Hope it will help you.

If work then give kudoes or mark as solution

[mousepad]

No, I am not looking to migrate from Magento 1 to 2. The current site is in Magento 2.2.3 

I am just looking for the best way to put a new design on it. Obviously I need to work in a staging environment but then how do I move it to the live environment. 

[Rakesh Jesadiya]

Best way for your scenario is create new custom theme on staging site first.

Create new theme by below link,

https://devdocs.magento.com/guides/v2.2/frontend-dev-guide/themes/theme-create.html

Now First create custom theme based on your requirements and move all the files and folder of your new theme from app/design/frontend to your live server.

For Theme/Design changes you dont need to transfer any database table from staging to live site.

You just need some setting from admin panel and transfer files/folder from staging to live site.

[Sunil Patel]

Hello @mousepad

Some of the tables you can copy

1) core_config_data ( where all configuration saved)

2) cms_block and cms_block_store,sequence_cms_block ( where all cms block store)

3) cms_page, cms_page_store,sequence_cms_page

4) For an attribute, please create an attribute using module so it will create when install module, otherwise you need to create manually

5) shipping_tablerate if you imported table rate 

Another table depends upon your theme customization.

Hope it will help you.

Mostly we are creating release note for that, we go live we add manually.

If works then give kudos or mark as solution. 

[Manthan Dave]

Hi @mousepad

Your second approach should be a most paroxysm in this kind of situation !!

So here i would suggest you to create a custom theme or you can purchase any third party theme - there are couple of vendors who provide ready made themes as well !

Based on the option you choose you need to import/create design related files in app/design/frontend directory over there you need to create VendorName and themeName directory in it !!

After that you need to re-skin the design based on the requirement you have. Generally in database only design settings are saved no other details and most of the times it saves in core_config_data table

So you create theme on staging then once its done move that theme into live site and also move its settings into live site

Then check it will works !!

[tridungng]

Hi mousepad.

You can do as follow:

- install a fresh magento site (you can use your current version or latest version)

- export data from source site then import to target site

- install all extensions you are using in the Magento site to the new site and make sure that they work well

- export data from the extensions then import to target site

- INSTALL new template 

I have been done this job before, if you need please inbox me or leave a message via Skype, I will help you to get your job done 

[mousepad]

This is the approach that I am looking at however, do you have a real example of what to export and what to import and how you do that. Do you have a list of tables from Magento using phpMyAdmin that need to be exported and imported.

[pramod kumar_th]

Hi,

It seems data migration from magento 1 to magento 2 took place successfully. Since we planned on using Luma theme for our Magento 2 store unlike store 1, we didn't do a theme migration. But now, when visiting new site, I see this error below.

Exception #0 (LogicException): Unable to load theme by specified key: 'default/theme588'