Link new customer account to old orders

[lancermedia]

Is there anyway in v5.5 or v9 to link a new customer account to an old order? Meaning the order happened before they created an account?

-Kevin

[lancermedia]

Re: Link new customer account to old orders

Ok, just checking to see if this is safe (I tried it in dev and worked).

Every order in the s01_Orders table has a field called cust_id. This seems to store the unique id assigned to each customer account in the store. So to link orders with customers, you just need to search the s01_Customers table to get that customer id and enter that in that order.

Just want to make sure this won't blow anything up ;-)

-Kevin

[Rick Wilson]

Re: Link new customer account to old orders

Not yet, but coming very soon.

[lancermedia]

Re: Link new customer account to old orders

Not yet, but coming very soon.

Any idea if my database changes are ok to do?

-Kevin

[Bruce - PhosphorMedia]

Re: Link new customer account to old orders

Yes, we do it with Easy Account cause technically the account is created AFTER the order but we assign the newly created customer id to it.

[lancermedia]

Re: Link new customer account to old orders

Yes, we do it with Easy Account cause technically the account is created AFTER the order but we assign the newly created customer id to it.

Thanks Bruce. Figured it was ok.....just being overly cautious.

-Kevin