I don't recommend that you delete anything with phpmyadmin. The database records (addresses, orders, etc.) are all intertwined in the database and just brute-forcing the customers out using phpmyadmin pretty much guarantees that you'll have database issues in the future.
You could try a two-prong approach:
- Use phpmyadmin to run this query: SELECT customers_id FROM address_book WHERE entry_country_id=38; ... if your database uses a non-empty value, e.g. zen_, for the DB_PREFIX, prepend that value to address_book (e.g. zen_address_book).
- Using the customer_id values returned from phpmyadmin, use your Zen Cart admin to delete those customers. That will ensure that all appropriate records are deleted.
Please note also that the above will not only delete customers whose primary address is in Canada, but any customer who has used a ship-to or bill-from address in Canada.
Remember to backup your database before you start!
Bookmarks