Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Transferring customers from one website to another


kaffy

Recommended Posts

Posted

Hiya,

 

Having looked through the threads I see that it wouldn't be beyond my capabilities to transfer customers to my new oscom website if I didn't already have customers in the database, but I have. So can it be done without over-riding all the ones that are there already, and can any one give me a really easy to follow step by step guide to do it?

I am guessing that I will need to change some customer ID's first.

 

Many thanks in advance,

kaffy

Posted

If you go to PHPadmin panel you should be able to export the two and see, if anything what needs to be changed. You probably just need to copy one to the other using INSERT (which phpmyadmin panel will show you how if you download the data in sql form). So, take the one you are going to use and insert the old ones, should increment properly, shouldn't have to change any ids.

Posted
If you go to PHPadmin panel you should be able to export the two and see, if anything what needs to be changed. You probably just need to copy one to the other using INSERT (which phpmyadmin panel will show you how if you download the data in sql form). So, take the one you are going to use and insert the old ones, should increment properly, shouldn't have to change any ids.

 

Hiya, thanks for answering. Went to 'insert' on the customer table and it will let me do them one at a time. But there must be a way of uploading them altogether as I have over a 1000 to transfer? Tried 'import' but it won't let me do that as the customer table already exists. Anything else I could try? Perhaps merging the 2 sql files together in excel first and then uploading them together?

Posted
Did you set the hook at 'add IF NOT EXISTS' at the structure section while exporting the tables?

 

I hadn't so I tried again with and got this error code: #1062 - Duplicate entry '8' for key 1

Posted

That's because you have a customer with id=8 in your old database as well as in the new one. There are several ways to get around this. You can export the data from the old database as CSV and change the customer_id within your Excel or whatever you're using to a number that doesn't exist in the new database before importing. Also you can change the customer numbers in the new database via SQL-statement to avoid this conflict. But make sure to change both tables (customers and customers_info) the same way, otherwise the data will be messed up.

 

BTW, did you make a backup of the new database before making any changes?

Posted
I hadn't so I tried again with and got this error code: #1062 - Duplicate entry '8' for key 1

 

Ok, changed the duplicate ID numbers and tried again. I have all the customers now transferred but minus any details other than their names. There must be another field I need to tick to save all information?

Posted
Did you also export and import the customers_info table?

Hiya, no I hadn't - hadn't realised the data was stored in different tables. Nor have I exported/imported the address book. Will change the customer ID numbers within those later and give it a go. I'm thinking now that I may be able to transfer orders too in a similar way (changing customer ID and order ID)? A bit time consuming but it would be nice to have all the information in the same place. Thanks for your advice.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...