649 users online

export from 1,9 to 2,3

Posted: 3 months ago Quote
Is it possible to export customers and orders from version 1,9 to version 2,3.

Im editing my new version 2,3 while the 1.9 is running. Is the database structure sp different in 1,9 that its not possible to import customers/orders directly ??
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: 3 months ago Quote
Sure, it's possible. Have a look at the upgrade scripts: 1.90=>2.00, 2.00=>2.10, 2.10=>2.20, 2.20=>2.30 (especially 1.90=>2.00). They contain all required SQL scripts
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Andrei Mazoulnitsyn,
LinkedIn - http://ru.linkedin.com/in/mazoulnitsyn

Twitter - http://twitter.com/#!/nopCommerce
Facebook community page - http://www.facebook.com/pages/NopCommerce/108282972527146
Google+ page - https://plus.google.com/100073150079669136049
Posted: 3 months ago Quote
If i script the old 1,9 database this way, all the new items i have added in the DB will be lost.

I have a copy of my site at a dif. hotel, all my stuff is going to be moved over there when im ready.

How can i import only orders and customers and not other items like tobics and product katergories and so on.

I have two db one running 1.9 the old shop, with ongoing shopping and orders

And the new one wich is upgraded to 2.3

:-)
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: 3 months ago Quote
You need to pick out only required SQL statements from the upgrade scripts

P.S. It'll require some time and database developer skills to investigate it.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Andrei Mazoulnitsyn,
LinkedIn - http://ru.linkedin.com/in/mazoulnitsyn

Twitter - http://twitter.com/#!/nopCommerce
Facebook community page - http://www.facebook.com/pages/NopCommerce/108282972527146
Google+ page - https://plus.google.com/100073150079669136049
Posted: 3 months ago Quote
Thx

Ill go through the script and filter out the right  lines in SQL server management
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)