Jump to content

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

Delete Guest Customers Rate Topic   - - - - -

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

Posted 30 March 2020 - 08:24 PM #1

CS Cart 4.5.2

Seems like I have 32,000 customers in the admin.

Most of these will be guest checkout, can anyone tell me how to filter in admin or phpmyadmin to delete all guest customers 

 

 

THanks

 


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


 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 20526 posts

Posted 31 March 2020 - 07:05 AM #2

Anonymous customers are not stored in the tables with user data, only in tables related with orders


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    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

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

Posted 31 March 2020 - 12:38 PM #3

I have thousands of customers who have name email and telephone number fields but no billing or shipping address fields, I assumed they would be guests ?

NO ?

 

So every customer in may database had registered then


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


 
  • cscartrocks
  • Member
  • Members
  • Join Date: 24-Jan 11
  • 1810 posts

Posted 31 March 2020 - 03:26 PM #4

I have thousands of customers who have name email and telephone number fields but no billing or shipping address fields, I assumed they would be guests ?

NO ?

 

So every customer in may database had registered then

Yes they are registered. You can use 'customers without orders' addon to filter out these customers.


One Step Checkout Addon - The ultimate checkout experience
Best CS-Cart SEO addon - CS-Cart SEO Ultimate Addon
PM for 365-day support and custom development service