Guest checkout problem with previously registered user

  • Posts: 42
  • Thank you received: 1
7 years 2 months ago #277968

-- 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?

Please Log in or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
7 years 2 months ago #277969

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,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 42
  • Thank you received: 1
7 years 2 months ago #278143

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 -

UPDATE `j3lmc_hikashop_user` SET `user_cms_id`=0

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

Is that correct?

Last edit: 7 years 2 months ago by BNRBranding. Reason: **edit corrects SQL statement

Please Log in or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
7 years 2 months ago #278146

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) :

UPDATE #__hikashop_user SET user_cms_id = 0 WHERE user_cms_id >= XXX

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.
The following user(s) said Thank You: BNRBranding

Please Log in or Create an account to join the conversation.

Time to create page: 0.055 seconds
Powered by Kunena Forum