Script Required To Convert Guest User To Registered User

Partners Ideas & Requests
1

We need a script/addon which can convert guest users to registered users and assign the registered user to the order of the guest user. Budget 50-75$

2

Please check PM

3 

UPDATE cscart_orders AS o SET o.user_id=u.user_id
  LEFT JOIN cscart_users AS u ON u.email=o.email
 WHERE o.user_id=0 AND u.user_id != NULL

This is UNTESTED but should set all orders to be associated with user accounts where the email in the order matches the email in the users table AND the order has a user_id=0 (anonymous user).

4

We need a script/addon which can convert guest users to registered users and assign the registered user to the order of the guest user. Budget 50-75$

Hello,

We are ready to help you for your requirement so please reach Us at sales@abssoft.co.in.

Thank you.

ABSSoft.

http://abssoft.co.in/

5 
UPDATE cscart_orders AS o SET o.user_id=u.user_id
  LEFT JOIN cscart_users AS u ON u.email=o.email
 WHERE o.user_id=0 AND u.user_id != NULL

This is UNTESTED but should set all orders to be associated with user accounts where the email in the order matches the email in the users table AND the order has a user_id=0 (anonymous user).

Thanks tbirn for the query above, how do the user get converted from guest to registered.

6

If you're wanting to create a user account for all orders that are anonymous, that would be a bit different and would be done in software rather than a DB query so all the business logic is in place. The above only finds orders where the email in the order matches the email in an existing user record and then updates the order to reference the user.

I would not automatically create accounts for users who checked out anonymously since it was their intent to be anonymous and not have an account created.