U Commerce migration to v17* did not populate customer tables

Questions
,
1

I upgraded my site from v13 to v17 and also upgraded the Commerce package, initially to 17.1.9 and subsequently over the past week or so, up to v17.6.2 and Commerce 17.2.3 (today)

I only recently noticed that my site is throwing errors when viewing orders in the BO. This eventually lead me to look at the Commerce Customer tables in the db.
All the customer tables have no records at all. The BO doesn’t seem to like this and throws an error.

I have attempted to rerun the Commerce migrations again but nothing changes. The migration appears to succeed and seems to skip over executing the sql migration scripts.

Poking around in the libraries for migration I discover that the cause is likely to be the complete lack of email addresses in the umbracoCommerceOrder table. I have 10K orders in that table and there are no emails though the customerReference field has data.

I suppose this lack of data may be due to my site starting from v13? Don’t know. This problem has only come about since v17 which has this new Customer management feature.

Anyway, are there any suggestions of what I should do from here?
Are there any existing fixup scripts that might populate my Customer tables as required?

Suggestions appreciated.

2

Hi @ajatnow

Do you know if the customer data was there when you initially migrated to Umbraco Commerce 17.1.9? Do you have a backup that you can check?

There were some long running migrations in recent versions that were fixed in 17.2.3 - I suppose it’s possible these may have caused issues, but for the customer data to be missing completely is odd.

Are you able to re-migrate from v13 again all the way to the latest version to see if the same thing happens? If it’s reproduceable, I would raise a support ticket.

I’ve recently migrated Umbraco Commerce from v13 to v17 and did not lose any customer data.

Justin