From Multistore To SingleStore

[HaCos]

Hello,

I already run multistore in a prestashop installation 169  and willing to migrate to latest version.
Based on https://github.com/PrestaShop/PrestaShop/labels/Multistore it might not be the best idea to create a multistore on latest ps176.
Is there any way to migrate store data from multistore to singlestore?

Thanks in advance,
C

 

[selectshop.at]

Once you activated multistore you cannot undo this. The only possibility you have is to deactivate the feature. Prestashop and this for all versions ! creates several extra database tables with dependencies on other database tables and rows in this case. It is a weird collection of data you cannot "disassemble" again.

In this case I will mount complete new shop by disabling the function on your old shop and export the data, by reimporting them in one file again for each database table on new shop.

[HaCos]

I was afraid there is no way back.
I wouldn't mind going for multistore in ps176 but considering the open bugs on github - doesnt look stable enough for going production. Any exprience on this?

Since the tables will be different  how do you suggest to reimport the data on each table?
Regards

[El Patron]

just do normal upgrade on a development machine then your questions will be answered.....

[selectshop.at]

23 hours ago, HaCos said:

I was afraid there is no way back.
I wouldn't mind going for multistore in ps176 but considering the open bugs on github - doesnt look stable enough for going production. Any exprience on this?

Since the tables will be different  how do you suggest to reimport the data on each table?
Regards

I was thinking about CSV export and reimport of DATA by same way via the BO dashboard to a fresh install, not import/export of entire database tables via phpmyadmin. Furthermore multistore is not working on PS 1.7.6. so don't waste your time in trying to run or upgrade a multistore shop to that version.

[HaCos]

Thanks for your messages.
I tried several ways migrating multistore to singestore from ps 1.6.9 to latest 1.7.6
Tried several times with 1click auto upgrate module - unfortunately it didnt worked thats why i had to consider a migration to a new fresh install.
Migration from multistore to singlestore had several issues, i guess because of several database differences.
I enabled multistore on a new fresh 176 installation which I created new db relations - similar to the ones I have on old ps.
Migration worked fine although there are still several things that I have to fix before going live.

For all the above i have been using migrationpro module.

[El Patron]

3 hours ago, HaCos said:

Thanks for your messages.
I tried several ways migrating multistore to singestore from ps 1.6.9 to latest 1.7.6
Tried several times with 1click auto upgrate module - unfortunately it didnt worked thats why i had to consider a migration to a new fresh install.
Migration from multistore to singlestore had several issues, i guess because of several database differences.
I enabled multistore on a new fresh 176 installation which I created new db relations - similar to the ones I have on old ps.
Migration worked fine although there are still several things that I have to fix before going live.

For all the above i have been using migrationpro module.

when upgrade fails it's best to solve first...the move forward....we might think a manual migration worked until we start missing bits, customers, orders, url's the same etc.

hopefully you did not open pandaoras box

[HaCos]

3 hours ago, El Patron said:

hopefully you did not open pandaoras box

Crossing fingers..
So far, the only issue is at address registration that fails to load states for my default country.. next thin I will be diving into..

edit: I wish Unit Testing was mature enough in PrestaShop..

Edited April 9, 2020 by HaCos (see edit history)

[El Patron]

2 hours ago, HaCos said:

Crossing fingers..
So far, the only issue is at address registration that fails to load states for my default country.. next thin I will be diving into..

edit: I wish Unit Testing was mature enough in PrestaShop..

I'm ready for something that just works, some bugs in 1.7.6 even are perplexing.....shopify is looking dreamy lol

[HaCos]

8 hours ago, El Patron said:

I'm ready for something that just works, some bugs in 1.7.6 even are perplexing.....shopify is looking dreamy lol

Do you have any major bugs that creates perplexing on 176 that i should be aware of?

[El Patron]

5 hours ago, HaCos said:

Do you have any major bugs that creates perplexing on 176 that i should be aware of?

of course, see github for issue reports.  what I find,  open source means community tested lol.

[HaCos]

48 minutes ago, El Patron said:

of course, see github for issue reports.  what I find,  open source means community tested lol.

I am using the community forum to exchange opinions based on experience.. 
Of course github is there..

Anyway, in order to keep posts related to the thread - in case anyone face similar issue, the solution is the folloiwng:
 

23 hours ago, HaCos said:

Migration from multistore to singlestore had several issues, i guess because of several database differences.
I enabled multistore on a new fresh 176 installation which I created new db relations - similar to the ones I have on old ps.
Migration worked fine although there are still several things that I have to fix before going live.

For all the above i have been using migrationpro module.

 

 

Edited April 10, 2020 by HaCos (see edit history)

[jetway]

This can be done but requires some knowledge. However, keep in mind that if you go back to a single store, you will need several installations to run all your stores. All Tables with shop_id need to be adjusted, at least that's what i recommend to avoid future problems. I also recommend cloning your current multi store and going from there. The stores have different ids. Reverting back to a single stores requires the rest of the ids and multi store indication removed. (in database)

Edited April 10, 2020 by jetway (see edit history)