Guest checkout problem with previously registered user

-- HikaShop version -- : 3.2.0
-- Joomla version -- : 3.7.5
-- PHP version -- : 7.0.12

We enabled checkout registration but have decided to go back to guest checkout only. Checkout works fine for new users, but any user that made a purchase and registered an account cannot use guest checkout. We get an error saying the email has already been used. Short of deleting all of the registered users, is there anything we can do?

Hello,

See : www.hikashop.com/forum/customers/891788-...as-guest.html#277482

Best would be to remove the "user_cms_id" in the HikaShop user table (for the account you want to remove) and afterwards you will be able to delete the Joomla accounts.
Thanks to that you'll keep the orders, the accounts will be transformed into guest account and they will be able to re-use the email for new guest orders.
For the rest, it's explained in the given URL.

Regards,

Thank you for the reply. I want to make sure that I am doing the right thing because this a high volume store and the client is already upset that we're losing sales.

First I need to execute this statement -

Then I need t delete all Joomla users associated with orders that were place.

Is that correct?

That's almost correct but it will be best to not remove the accounts for your accounts.
So you should add a "WHERE" clause to only affect users created after you activate the registration and select the Joomla user ID of the first account you want to unassigned (delete in Joomla) :
Regards,