Thank you for this great script
I just used it this way:
- Made a copy of the source PS 1.6.1.24 shop
- Then installed a fresh PS 1.6.1.24 on a subdomain and used Copy Shopdata V0.3 to transfer the data.
- Then used the native PS 1-Click Upgrade to update the fresh store to PS 1.7.6.1
- So now I have a PS1.7 store / database with all my previous PS.16 business data.
- The upgraded PS1.7 store does have various issue, so I also installed a new clean 1.7.1.6 store. The idea was then to use the script to copy the updated 1.7 database to the fresh PS1.7 store (not done this step yet)
However I experience these problems / have these questions:
1 . I have 4 languages, so for the script to work I created these in the fresh 1.6 store, but ID's were not identical, so had to change /match the ID's (1,6,8,9) in the ps_lang / ps_lang_shop for the script to start. Everything went well and also the 1-click Upgrade afterwards. However I now notice that a few tables in target do not have the correct language ID - mainly ps_meta_lang (all the pages) are 1,2,3,4 (not 1,6,8,9 like source), meaning only the english work. Most other 'Lang' tables were correctly matched, so must be some bug, since a few tables not matched.
2. Since the 1.7 database have these language issue (which in worst case I can manually edit), I kind of fear other issues which would then also be transferred to the fresh 1.7
Is it not possible to transfer some selected Business data only - like orders, cms, reviews, customers related tables only?
3. Does the script actually force overwrite all existing tables, or skip tables/ID with content (if target shop for example already have various data)?
4. If I manage to the get the fresh 1.7 shop ready after while, then how should I get all the changes from the meantime (mainly orders and customers)?
I seem like quite a heavy process if having to do all the initial steps all over again for this (the "source" was 1-click upgraded, so can't just repeat the script now)
Thank you in advance!