Products Database Transfer

Hi guys.

I have a new store and I need to copy all products (with attributes, specifications, images, etc) to one db to another, on same server, so I can use insert from select.

Do you have any script ready for it?

Do you know exactly what I need to copy, only products related info. There is not need top level tables, like categories, manufactures, orders, etc.

Nop 3.7!!

Thanks!

anyone???

It's not straightforward.  There are several tables involved, and there are foreign keys and identity columns.

It might be easier to restore the latest old database backup into new database, and then remove logs, customers and orders.

ilich_x86 wrote:
Maybe, but customers have addresses, generic attributes, shopping carts, etc.  Orders have addresses, order items, etc.

New York wrote:

Piece of cake.

I did it by myself. Just some tables involved.