Thread: Moving order info from one customer to another

Does anyone have a solution to the following (we are using ML Version 8):

Problem: We have a general "phone order" account that we use when we get an order over the phone; we do not set up a specific customer account for each individual phone order.

A few of the customers who have ordered on the phone in the past have turned into very regular customers who should have their own account versus being placed in the general phone order account. Note: these customers always call in an order, they don't place their own order online.

Question: We will be setting up specific customer accounts for these people in order to better track their orders. Is it possible to move their previous order information from the general phone order account into their newly created customer accounts? Can that info be exported from one account/ID to another?

Does anyone know the answer to that? If it can be done, how would we go about doing that?

Thanks,

Leslie

When you say 'General' account, that means you use the same phone order account to all customers who purchased/ordered via phone? Yes, it's possible to convert an existing account from one to another via sql script, but in that case, it's kinda difficult for you to determine which particular order belongs to a specific customer since they share the same account. Anyway, you can check out the following tables in the DB, make sure to make a full backup first before anything else.

Orders_KitCart
Orders_ShoppingCart
Orders_ShoppingCart
CustomCart
ShoppingCart
ShoppingCart
Orders_CustomCart
Orders
Customer
KitCart

you can create an update script that look something like below:

update Orders set Customerid='the new cusotmer id' where customerid ='old customer id' and ordernumber='existing order number'

Again, make sure to have a full backup of your DB first before running any scripts.

Here is a list of all tables/columns in 8.0.12 where there is a customerid.

Code:

Address.CustomerID
AuditLog.CustomerID
AuditLog.UpdatedCustomerID
CouponUsage.CustomerID
CustomCart.CustomerID
Customer.CustomerID
CustomerGiftRegistrySearches.CustomerID
CustomerSession.CustomerID
FailedTransaction.CustomerID
GiftCard.PurchasedByCustomerID
GiftCardUsage.UsedByCustomerID
KitCart.CustomerID
LOG_CustomerEvent.CustomerID
Orders.CustomerID
Orders_CustomCart.CustomerID
Orders_KitCart.CustomerID
Orders_ShoppingCart.CustomerID
Orders_ShoppingCart.GiftRegistryForCustomerID
PasswordLog.CustomerID
PollVotingRecord.CustomerID
Rating.CustomerID
RatingCommentHelpfulness.RatingCustomerID
RatingCommentHelpfulness.VotingCustomerID
SearchLog.CustomerID
ShippingImportExport.CustomerID
ShoppingCart.CustomerID
ShoppingCart.GiftRegistryForCustomerID

So you might have to take care of them aswell as the [Orders], especially [Address]

Thank you for your help with this!

Leslie