[alijaved]

Dear members,

 

 

Could you please tell me how can I know unregistered customers who did shopping on my site or purchased something without registering on my site.

 

I can see the registered customers, but I don't see any tab for Unregistered customers, is there a way I can get this information like how many people checked out as a guest and purchased something, so I can get their e-mails and send them some offers?

 

 

Your comments will be appreciated as always 

[tbirnseth]

SELECT DISTINCT(email) FROM cscart_orders WHERE user_id=0

[alijaved]

SELECT DISTINCT(email) FROM cscart_orders WHERE user_id=0

 

SELECT DISTINCT(email) FROM cscart_orders WHERE user_id=0

 

 

Can you please explain what is this?

[poppedweb]

Can you please explain what is this?

 

Hello,

 

That is a MySQL query. You enter this in the MySQL console and it will output all the unique email addresses who do not have a user account, but who have ordered something at your shop.

 

You may also execute this via PHPMyAdmin (or just ask your hosting company).

 

Kind regards,

[alijaved]

Hello,

 

That is a MySQL query. You enter this in the MySQL console and it will output all the unique email addresses who do not have a user account, but who have ordered something at your shop.

 

You may also execute this via PHPMyAdmin (or just ask your hosting company).

 

Kind regards,

 

 

Coud you please write the exact query for me that I can copy and paste and run, also please let me know where do I have to run  ? I can run this in phpmyadmin my stores database?

[eComLabs]

Coud you please write the exact query for me that I can copy and paste and run, also please let me know where do I have to run  ? I can run this in phpmyadmin my stores database?

 

Yes, this query can be run in phpMyAdmin

 

Go to SQL tab, paste the query and click on the Go button

 

Results can be exported with default phpMyAdmin tools

[johnbol1]

try this

[tbirnseth]

Coud you please write the exact query for me that I can copy and paste and run, also please let me know where do I have to run  ? I can run this in phpmyadmin my stores database?

That is the exact query.

• Open phpMyAdmin from your cpanel console.
• Select the database associated with your cs-cart installation
• Click the SQL tab
• copy/paste the above query.

It will output a list of email addresses where the user checked out anonymously.

[alijaved]

Thanks A lot it worked great, also please tell me how can I know the customers who have purchased more than once? 

[tbirnseth]

Easiest to just generate the list sorted by email so you can figure that one out.

SELECT order_id, email FROM cscart_orders WHERE user_id=0 ORDER BY email

[alijaved]

 

Easiest to just generate the list sorted by email so you can figure that one out.

SELECT order_id, email FROM cscart_orders WHERE user_id=0 ORDER BY email

 

 

Thanks alot EZ, How can I know this about the Registered customers who have ordered more than once? 

[tbirnseth]

Change user_id=0 to user_id!=0