Transfering Customers & Orders

[dre]

Is it possible to transfer only the customers and their orders, information etc to a fresh new installed shop with a new database.

If possible, how wil i do that?

The shop has now the following modules realted to customers :
reward points
dualpricing

Thank you for any advice / help

[DrByte]

Why are you using a new database instead of keeping the actual real live database that contains the REAL information?

[dre]

Thank you for your reply.

Because i want to update all the modules and the shop from 1.3.g to h and also start with a new template

Also i tried to update image handler and light box. This failt and my lightbox isnt working anymore

[gilby]

Thank you for your reply.

Because i want to update all the modules and the shop from 1.3.g to h and also start with a new template

Also i tried to update image handler and light box. This failt and my lightbox isnt working anymore

I don't believe there were any database changes from 1.3.9g to 1.3.9h So you should be using the same database as they are the same in both versions.

You just overwrite the php files with the new versions and update your template and modules

[mastico]

Hi

If there was no changes in DB structure of this tables this sql commands will fill your customers and orders information, you have to change new_table and old_table to your table names, and run this commands in your phpMyAdmin.

insert into new_table.`address_book`
select * from old_table.`address_book`;
insert into new_table.`customers`
select * from old_table.`customers`;
insert into new_table.`customers_basket`
select * from old_table.`customers_basket`;
insert into new_table.`customers_basket_attributes`
select * from old_table.`customers_basket_attributes`;
insert into new_table.`customers_info`
select * from old_table.`customers_info`;
insert into new_table.`orders`
select * from old_table.`orders`;
insert into new_table.`orders_products`
select * from old_table.`orders_products`;
insert into new_table.`orders_products_attributes`
select * from old_table.`orders_products_attributes`;
insert into new_table.`orders_products_download`
select * from old_table.`orders_products_download`;
insert into new_table.`orders_status_history`
select * from old_table.`orders_status_history`;
insert into new_table.`orders_total`
select * from old_table.`orders_total`;


Matej

[DrByte]

mastico's suggestion is incomplete, and doesn't accomplish what dre was asking for. In fact it will result in duplicate records and all kinds of MySQL errors. And it will lose payment history data.

A FAR BETTER APPROACH is to use the actual live database directly.

[dre]

pfew I wanted to try the option from mastico . So there is no way to transfer only the customers and their information.

[DrByte]

What's so difficult about using the original live database?

What's so important about this "new" database that you're treating it more sacred than your real live data?

[dre]

The problem is there are some modules not working anymore or i want to get them out of the database .

So is zen lightbox after upgrading image handler not working any more. Paypal is accepting payment but i dont get the orders and i tried mailbeez but al the extra good modules for mailbez you have to pay for.

[dre]

So i its not possible to transfer customer details etc to a new database?