Customer data missing in some orders

Phoca Cart - complex e-commerce extension
TomasZmuda
Phoca Member
Phoca Member
Posts: 13
Joined: 28 Dec 2019, 22:41

Customer data missing in some orders

Post by TomasZmuda » 12 Jan 2020, 23:19

I some orders (I can't find the key why) is missing the customer data in Orders and in Summary- see in attachment. The reason is, that in phocacart_order_users table is this order_id doubled. One with type=1, ba_sa=0 without data and second type=0, ba_sa=1 with data.
Workaround is delete the row with type=1.

Do you have please solution?

Thank you ve much!
Tomas

https://ibb.co/VWR1WKK
https://ibb.co/cb6PvhP
https://ibb.co/51fZMzC

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 42872
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Customer data missing in some orders

Post by Jan » 14 Jan 2020, 18:33

Hi, this is OK in database.

One order has two rows in phocacart_order_users table:

- one for billing address
- second for shipping address

In case ba_sa = 1, means that billing address is the same like shipping address. So in this case only one row of both includes the address data:

Image

So the question is why there are no data for first items (28,29) even the data are there. Testing now I don't get any such problem:

Image

:idea: :idea:

Can you paste here the screenshot of invoice adresses of orders 28 and 29?
If you find Phoca extensions useful, please support the project

TomasZmuda
Phoca Member
Phoca Member
Posts: 13
Joined: 28 Dec 2019, 22:41

Re: Customer data missing in some orders

Post by TomasZmuda » 21 Jan 2020, 22:39

Hi,
here is another order from today. Thank you for check. http://activityboardshop.cz/order.zip

Same problem with next order. Invoice is without problem. I manually deleting the row without name in order_users table.
See here:
https://activityboardshop.cz/Order35.zip

Thank you for solving the issue!

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 42872
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Customer data missing in some orders

Post by Jan » 26 Jan 2020, 21:01

Hi, I don't understand why you manually delete some rows?

Jan
If you find Phoca extensions useful, please support the project

TomasZmuda
Phoca Member
Phoca Member
Posts: 13
Joined: 28 Dec 2019, 22:41

Re: Customer data missing in some orders

Post by TomasZmuda » 27 Jan 2020, 08:30

Hi,
thank you for responce, because, when is in the database row withnout name with same order ID, the name doesn't appears in Orders liek here: https://ibb.co/51fZMzC and missing in report like here: https://ibb.co/cb6PvhP.

Invoice is ok always.
I can write you, when I receive next order with login into admin for check.

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 42872
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Customer data missing in some orders

Post by Jan » 31 Jan 2020, 18:33

Ok. But no row should be deleted. Because one order just includes both of the rows. It includes the data and when removed, half of data will be removed for each order :idea:

Jan
If you find Phoca extensions useful, please support the project

TomasZmuda
Phoca Member
Phoca Member
Posts: 13
Joined: 28 Dec 2019, 22:41

Re: Customer data missing in some orders

Post by TomasZmuda » 11 Feb 2020, 13:50

Hello, after severals correct order, I received one, where customer data missing again. Shall I provide you access to administration or DB?

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 42872
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Customer data missing in some orders

Post by Jan » 15 Feb 2020, 12:28

Hi, yes, just let me know per PM with description and ID of the order.

Jan
If you find Phoca extensions useful, please support the project

TomasZmuda
Phoca Member
Phoca Member
Posts: 13
Joined: 28 Dec 2019, 22:41

Re: Customer data missing in some orders

Post by TomasZmuda » 17 Feb 2020, 08:57

I don't have privileges to compose message on forum. Shall I write you e-mail? Or reply to yours: tomas@zmuda.cz.

Thank you!

Post Reply