Zen Cart Logo
Forums / General Questions / How can copy some products from database to another database ?

How can copy some products from database to another database ?

Views: 1,177

Results 1 to 6 of 6
7 Nov 2015, 9:45 AM
#1
dmagic avatar

dmagic

Totally Zenned

Join Date:
Oct 2008
Posts:
594
Plugin Contributions:
0

How can copy some products from database to another database ?

I have some new products in my website

I want copy them fast to another website . about 50 products ... how can do that ?

What need copy ?

Thank you.

7 Nov 2015, 9:46 AM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: How can copy some products from database to another database ?

Install and use easy populate on both sites

2 Jul 2018, 1:24 AM
#3
idtags avatar

idtags

Zen Follower

Join Date:
Aug 2005
Posts:
315
Plugin Contributions:
0

Re: How can copy some products from database to another database ?

Hello,
I would like to check for the best way (in 2018) to copy "customers" and "orders" only from store on one domain to the store on another domain?

Is it still EP4 the best option?

Thank you for your time in advance.

2 Jul 2018, 10:20 AM
#4
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: How can copy some products from database to another database ?

idtags:

Hello,
I would like to check for the best way (in 2018) to copy "customers" and "orders" only from store on one domain to the store on another domain?

Is it still EP4 the best option?

Thank you for your time in advance.
Ep4 is not written to address customers and orders. It is or has been for product. Mind you if the product is not also transferred or is not the same in the new location as compared to the old, then the order data will not line up properly with the product of the destination store. For transfer of orders and customers, the main suggested way still is to use the full database export, import and then upgrade as applicable (or in either sequence with upgrade before or after the database move).

There are utilities that will export and presumably import customers and orders, but there remain limitations and/or considerations with that as well.

2 Jul 2018, 12:15 PM
#5
idtags avatar

idtags

Zen Follower

Join Date:
Aug 2005
Posts:
315
Plugin Contributions:
0

Re: How can copy some products from database to another database ?

Thank you for the fast reply.
Our situation is that products are the same, but it tool us time to work with responsive template and customers and orders of older store are ahead of new.
We need just catch up.

2 Jul 2018, 1:54 PM
#6
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: How can copy some products from database to another database ?

idtags:

Thank you for the fast reply.
Our situation is that products are the same, but it tool us time to work with responsive template and customers and orders of older store are ahead of new.
We need just catch up.
As posted in a follow-on thread with a similar message, the changes made to the new store should be duplicated into the database of the live store. Attempting to pick and choose business aspects of the store for copying over is a good way to make a mess of one or the other. This is basically covered in the following FAQ: http://www.zen-cart.com/entry.php?3-How-do-I-rebuild-my-site-on-the-new-version-instead-of-upgrading