Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Transfer From Test Site To Live Site Rate Topic   - - - - -

 
  • Ranger-1
  • Member
  • Trial users
  • Join Date: 20-Aug 11
  • 31 posts

Posted 13 November 2019 - 07:53 PM #1

We have been working on an upgraded version of our webshop on a testserver for a few weeks. We have worked on products, categories, functions, layouts, design etc.. Simultaniously we have had our live server doing business as usual, so we have revieved orders, new customers etc on our live server that dont exist on our test server.

 

Now we are ready to go live with our test installation. I am trying to find the best way to do this with as little downtime and possible errors as possible. 

 

We want to keep new orders and customers from live server, and remaining data from test server. How do we achieve this? Is there any documentation on this topic? Or does anyone have the exact database tables that we need to keep or restore from the live server?

 

Thank you for any help!



 
  • soft-solid
  • Junior Member
  • Members
  • Join Date: 19-Apr 10
  • 915 posts

Posted 13 November 2019 - 11:06 PM #2

Hello

 

1. Back up your new store.
2. You can try to do the data transfer via import/export and check the effect
3. Can do it at the database level via phpmyadmin but then you have to move the tables manually (the problem will increase if there are differences in table structures - I don't know what your previous version of the store is)
4. Write a script that will connect to the databases of both stores and transfer data between them (I prefer this way)
5. You must consider the tables order*, user*, profile* (not all)
 
Best regards
Robert

Team of SoftSolid
cs-cart.pl

 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 19833 posts

Posted 14 November 2019 - 05:56 AM #3

There is no easy way to merge two websites. You can try import/export options. But please note that User ID is used on orders export and not used in users export. As a result orders and users can be mixed up


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.


 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 11424 posts

Posted 15 November 2019 - 05:05 AM #4

Given you want the data from your old site and the files/templates from your new:

1) backup both sites (files and databases)

2) Go through the normal upgrade process of your production site (this gets the data ready).

3) copy (or otherwise) update the files from your test site to your production site excluding config.local.php and .htaccess

4) Manually clear the cache by deleting var/cache and it's contents.

 

If you've installed any addons in your test site but not in your production site, you'll have to do the again,


EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • becomarius
  • Senior Member
  • Members
  • Join Date: 09-Feb 12
  • 215 posts

Posted 18 November 2019 - 02:27 PM #5

There is no easy way to merge two websites. You can try import/export options. But please note that User ID is used on orders export and not used in users export. As a result orders and users can be mixed up

Yes... i make these some time a go

I win...and i explain all details on forum for other people

 

I write all steps to a clean new version and import products, orders, and users

And now i must to make it again...and i forgot...and i don`t see my topic :(

 

Import store addon don`t work with 4.11 :(((


CS Cart lovers


 
  • becomarius
  • Senior Member
  • Members
  • Join Date: 09-Feb 12
  • 215 posts

Posted 18 November 2019 - 02:45 PM #6

why someone delete topics ?

 

even are old are still very useful for everyone

 

here are a lot of good tweaks for all


CS Cart lovers


 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 11424 posts

Posted 18 November 2019 - 09:24 PM #7

Our EZ Admin Helper addon has a function to synchronize users in orders to user's in database.


EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.