Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

List Of Unregistered Customers Rate Topic   - - - - -

 
  • alijaved
  • Advanced Member
  • Members
  • Join Date: 14-Apr 18
  • 77 posts

Posted 07 August 2018 - 02:45 PM #1

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
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 10770 posts

Posted 07 August 2018 - 06:28 PM #2

SELECT DISTINCT(email) FROM cscart_orders WHERE user_id=0

EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • alijaved
  • Advanced Member
  • Members
  • Join Date: 14-Apr 18
  • 77 posts

Posted 08 August 2018 - 09:14 AM #3

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
  • Authorized Reseller
  • Members
  • Join Date: 02-Aug 16
  • 415 posts

Posted 08 August 2018 - 10:04 AM #4

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,


PoppedWeb | sales@poppedweb.com | https://poppedweb.com
TurnKey Website Design | Add-Ons | Performance Audits | Dedicated Server Management
24/7 Support | Response within an hour (during working hours).

 
  • alijaved
  • Advanced Member
  • Members
  • Join Date: 14-Apr 18
  • 77 posts

Posted 08 August 2018 - 10:37 AM #5

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
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 17833 posts

Posted 08 August 2018 - 01:19 PM #6

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


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.


 
  • johnbol1
  • Never Re
  • Members
  • Join Date: 23-Feb 10
  • 4342 posts

Posted 08 August 2018 - 04:43 PM #7

try this


Custom printed hi visibility clothing sale the UK's online hivis safety shop
v4.5.2


 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 10770 posts

Posted 08 August 2018 - 06:46 PM #8

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.


EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • alijaved
  • Advanced Member
  • Members
  • Join Date: 14-Apr 18
  • 77 posts

Posted 10 August 2018 - 08:59 PM #9

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



 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 10770 posts

Posted 10 August 2018 - 10:27 PM #10

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

EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • alijaved
  • Advanced Member
  • Members
  • Join Date: 14-Apr 18
  • 77 posts

Posted 11 August 2018 - 07:58 AM #11

 

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
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 10770 posts

Posted 11 August 2018 - 04:33 PM #12

Change user_id=0 to user_id!=0


EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.