XAdapter › Forums › Order / Coupon / Subscription Export Import Plugin for WooCommerce › Customer Orders Linking to Wrong Order in My Account
May 2, 2018 at 12:43 pm #71010
We are having an issue with customer orders when they login to their account. Basically what is happening is once all the orders are imported, they look fine. We had to do a Find and Replace on the product numbers since we are trying the free version to see if it works and didn’t go by SKU. Once this was done, all the orders had the correct product linked, everything else is great when you view an order. (The issue I describe below happens regardless if you fix the product IDs or not)
The issue comes when we import the users also using your plugin for that. All the users come in fine. I have checked the CSV files and compared. The order numbers are right, the order_id and order_number fields are correct in the orders export csv. The customer_id and customer_user are also correct and match the user file CSV.
I decided to run some tests on my staging site where I imported the new data, which is a totally fresh Woocommerce install. The old site only has 763 orders, 7 products and 153 registered customers, so this is not a huge amount of work, unlike the 20,000 some have.
So, I have everything imported to the new site and the orders look great and have all the right data and information, this is perfect. The users all look great and have all their info.
But, I decided to change some customer passwords and log in as them (this is a staging site, so not changing the real site). When I do, I get the usual My Account information. However, when I click on Orders, I will get an order, but it is totally the wrong order. I have tried about 7 accounts and every time the order number listed in My Account has nothing to do with that customer.
The order number is right for an actual order, but has nothing to do with this particular customer.
So Customer A logs in, clicks Orders and then can see an order in their history, but it is Customer Y’s order. This is no good because I can’t have customers seeing other peoples personal information in their orders.
The bottom line is, can this be fixed so the order history for an imported customer links to the proper order? The CSV files look fine, all the information matches. Customer data is right and order data is right, just somewhere the hook between the two on the Orders page is getting lost.
Any ideas or help would be appreciated. We need to buy a plugin to do this because we need to have the date select options and some other advanced features, but I don’t see how these plugins would actually work since this basic functionality should at least work in our tests of the limited free versions. All the fields we need are present in the files, so maybe we are just doing something wrong. We even tried different orders of importing. (Customers first, then orders and the other way around.)
Thanks for any ideas/help!
May 3, 2018 at 3:21 pm #71216
We checked this in our testing environments and it seems to be working correctly in both front end and back end. Please reach us via support with more details like WooCommerce version, WP version and the importing CSV.
May 8, 2018 at 4:28 am #71519
Using Woocommerce 3.3.5 and WP 4.9.5 (latest versions)
I could edit a CSV file to delete sensitive customer info – where would I send that?
You must be logged in to reply to this topic.