not allowing duplicate emails

  • Posts: 90
  • Thank you received: 1
11 years 8 months ago #96275

We are not using registration or login. But if an order is submitted using an email address already in the system Hikashop won't allow the new order to be submitted. In essence we can't have return customers.

We need to require an email for correspondence, does anyone know how to make it so that hikashop doesn't care if an email address already exists in our system?

www.i-mac.com/langka.com

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

  • Posts: 13201
  • Thank you received: 2322
11 years 8 months ago #96333

Hi,

It you select the option "no registration" so no emails are asked. The problem should not be present.
What have you selected for the option "registration" in the checkout config part ?

If it's "simplified registration" there is a registration, so the email is checked.

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

  • Posts: 90
  • Thank you received: 1
11 years 7 months ago #96576

We have "No Registration" selected. We need the email so that we can send a confirmation email to notify customer that the order has been processed. But we don't want to have our customers login or register at all. I believe other shopping carts call it "Guest Checkout"

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

  • Posts: 13201
  • Thank you received: 2322
11 years 7 months ago #96688

Hi,

I think that the address used for the guest checkout was already used when the option was not on "no registration".
So an unregistered user cannot purchase using the email of an existing account.

I you checkout with a new email (never used on your website), and checkout again, the problem will not appear, because the email address is not saved for an account.

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

  • Posts: 90
  • Thank you received: 1
11 years 7 months ago #96737

Ok, I was really hoping that is what was wrong. But I tested the theory with a totally new address, And it still won't let me use it more then once. I then deleted all the orders and customers in Hikashop. This allowed me to use any of the emails previously used, once. If I tried them again it won't move to the next step in the checkout process.

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

  • Posts: 90
  • Thank you received: 1
11 years 7 months ago #97184

Still need help with this please advise...

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

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
11 years 7 months ago #97225

Hi,

Please download again HikaShop on our website and install it on yours and that should fix the problem.

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

  • Posts: 90
  • Thank you received: 1
11 years 7 months ago #97453

That worked thanks!

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

  • Posts: 247
  • Thank you received: 2
  • Hikashop Business Hikashop Essential
11 years 4 months ago #112732

Hello - I have been reading this section about duplicate emails and have similar problems. Most of my customers have no problem checking out but some older customers have the duplicate email problem. I have everything set to no login etc just fine.

But I noticed that I still have 350 registered users left from old setups. I am not that familiar with the joomla user system

Question = Can I delete these email addresses (all that would be left is our super-administators, etc. I already have these addresses in my acymailing program.

My thinking is that removing them would get rid of this problem.

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

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
11 years 4 months ago #113000

That's indeed the problem.
If you have email addresses in previous user accounts, they would still be required to login to be able to purchase.
Removing the user accounts will free the user addresses from the database and users will then be able to guest checkout with these email addresses.
Of course, they won't be able to log onto your website anymore after that.

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

  • Posts: 20
  • Thank you received: 0
11 years 1 month ago #125915

Hello,

I'm about to purchase Hikashop, however, after seeing this thread, I still have doubts about the guest checkout feature (which is essential for my website).

Could you please confirm the duplicate email issue for returning customers is resolved?

Thank you in advance.

Regards

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

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
11 years 1 month ago #126040

Hi,

Yes, this was fixed six months ago.

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

  • Posts: 202
  • Thank you received: 2
11 years 6 days ago #133539

I am seeing this as an issue on the latest build. How do I allow guest checkout?

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

  • Posts: 202
  • Thank you received: 2
11 years 6 days ago #133542

Nevermind. Egg on my face!!

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

  • Posts: 2
  • Thank you received: 0
7 years 11 months ago #256929

I know this is an older thread but I am having the same problem. I agree the problem is older users were registered and in the database. I found that in "_hikashop_user > _user_cms_id" had a value greater than 0. When I changed this value to 0 everything worked fine. Problem is I have several hundred users in this situation, and I am not an expert in mysql statements. Can anyone provide a statement to replace the value greater than 0 to 0 in "UPDATE _hikashop_user SET _user_cms_id = REPLACE ..."?

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

  • Posts: 2
  • Thank you received: 0
7 years 11 months ago #256932

Apparently I am an mysql expert. I found the statement that works if anyone needs it.

update myTable set myField = 0 where myField > 0;

Replace myTable and myField with yours.

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

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
7 years 11 months ago #257362

Hi,

Please note that it is also possible to use a "mass action" in HikaShop in order to perform some task without the need to write SQL.
www.hikashop.com/support/documentation/167-massaction-form.html

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.

Time to create page: 0.128 seconds
Powered by Kunena Forum