I have nearly 5000 customers on my site, Some of them have never ordered and good many of them are spammy signups to spam my community forum. is there a way that I can quickly filter the customers that have never ordered? I know there are extensions that allow you to edit products more easily but I can't find anything to clean up my customers. Obviously trying to check 5000 customers individually is not practical
TIA
Alice,
Thanks for that avvici, but I don't have an abandoned order filter and if I did would the customer not have at least had to put something in the cart? Many of these people have signed up purely to spam.
Alice.
Alice.
What version of OC are you using. The filter I am speaking about only counts for customers that make it to confirmation page in checkout. This creates an order_status_id of 0 , which is "Abandoned/Missing"
I am using oc 1.5.2.1 The customers I want to filter have never added anything to the shopping cart and would not have made it to the checkout at all. It would be good if when viewing customers in the dashboard it could say how many orders the customer had made. this way I could just check the ones that had not ordered and delete them.
Alice.
Alice.
The below should select all customers over 100 days old that have not placed an order, you can then delete the records.
This is not entirely checked so make sure you have a table backup before deleting any records.
Code: Select all
SELECT customer.customer_id, customer.date_added
FROM `customer` LEFT JOIN `order` ON customer.customer_id = order.customer_id
WHERE (((order.customer_id) Is Null) AND ((customer.date_added) < date_add(curdate(), interval -100 day)))-
VIEW ALL EXTENSIONS * EXTENSION SUPPORT * WEBSITE * CUSTOM REQUESTS
Indeed, phpMyAdmin
You could also add `customer.cart` to the query so you can see those that have added something to the cart and not delete those ones.
You could also add `customer.cart` to the query so you can see those that have added something to the cart and not delete those ones.
-
VIEW ALL EXTENSIONS * EXTENSION SUPPORT * WEBSITE * CUSTOM REQUESTS
I can't get this to work.
I am just not sure where to put things,
under the query tab in the column section I am selecting SELECT customer.customer_id, customer.date_added
then I have no idea where to put the rest of it.
Alice.
I am just not sure where to put things,
under the query tab in the column section I am selecting SELECT customer.customer_id, customer.date_added
then I have no idea where to put the rest of it.
Alice.
image.jpg (81.67 KiB) Viewed 3378 times
-
VIEW ALL EXTENSIONS * EXTENSION SUPPORT * WEBSITE * CUSTOM REQUESTS
I really appreciate you help, but still no joy, I have done as above it has a yellow box that says loading, then nothing happens.
Alice.
Alice.
I spoke to soon, it was just taking a long time to think, it just did not appear to be processing.
Alice.
Alice.
Who is online
Users browsing this forum: Amazon [Bot] and 57 guests
