Wrong Customer on Order

[jeff8899]

Hi,

i just got an order from a customer but it is so weird that the order shows all admin information on back office rather than the customer.

it seems like the customer login in as admin and then place the order with her own paypal.

i check the invoice it display correctly and paypal details are correctly, only the back office order gets messed up.

anyone knows what happening? 

[jeff8899]

and there is no any new customer created in back office!

[musicmaster]

Can you provide some screendumps. You could edit them a bit for privacy/business secrets reasons. But your description is too vague to give me an impression of what is happening.

[jeff8899]

hi, Musicmaster

 

Thanks for your reply.

after i have a deeper look, i found that the problem is when a customer try to log in or register, it shows up another registered customer info.
example, Tom try to log in but the shop shows Mary's info. 

[shokinro]

have you ever cleaned up your database or imported the data?

I think the data link between customer record are messed up. for example the address data id_customer linked to different customer.

[SherryM]

HI

 

How do you clean up the database I have the same issue one customers has a invoice with wrong address and sometime my customers get invoice and sometimes they don't. Als in the are that says document that is not always right either.

[mustivar]

have you ever cleaned up your database or imported the data?

I think the data link between customer record are messed up. for example the address data id_customer linked to different customer.

 

Hi I also experience this problem on production which may become frustrating. 

In the same day two customers made guest checkouts and orders were placed to the first customer in DB (which is my personal account that I used in all my tests)

 

While going production I cleaned the data with "pscleaner"

 

If that is the problem what will be the fix for that?

 

Thanks.

[shokinro]

what I guess is the ps_customer is cleared, but ps_address is not cleared, so when new customer is created, there is old address is mapped to the customer. 

If my guess is correct, you may have to clean the database again and also try to manually clear ps_address table.

[mustivar]

There is no obsolete data in ps_address.

 

I think I found that the problem may be caused by module Social Login Connect which I use for Facebook and Google login.

I could reproduce the problem by using Google login. 

There is one customer in DB which previously created with Google Login(which is my own customer data) and when I try to login a new customer account with another

google account it immediately logs me in with the previously created customer. 

 

Temporarily I disabled google login and I hope it is the only problem.

[shokinro]

thanks for your feedback. Hope what you found is the cause and solution. Thanks for sharing.

[jetway]

I agree with Prestashop Fanatic. I once had a problem that i deleted a customer in the database but i forgot to clean the order as well. It was a test I did when i started using Prestashop. What happend? Well when a new user registered it got the tests user id and the order was on his account. Anyways...what I am saying is, be careful when deleting or cleaning things in the database. Only do it if you fully understand what you're doing.

Edited October 11, 2016 by jetway (see edit history)

[shokinro]

@jetway

agree with your opinion. a couple of my customers had the same issue caused by database clean using 3rd party database clean up tool. it did not clean up all related tables.