Migrating users into customers

Fortunately the previous store used core Joomla users for its recordkeeping. After I migrate users into the Eshop customer database, can I manually reconnect them to previous orders? I think that is the only major task before throwing the switch.

Dear spitjack,

Thank you for submitting the question here. Regarding your question: I am sorry but connecting the users / EShop customers to previous orders from another old extension is impossible. EShop can not do that.

Sincerely, Giang

No problem, Giang. I think we can probably manage this via phpMyAdmin.  Thanks for all you help.

No problem at all Spitjack.

Sincerely, Giang

I now have a particular question. In preparing a csv file for phpmyadmin, I placed a test order two see how Eshop would record a multiple purchase. By what magic are the two items bought by fake user Fred Eric connected to the single order? The order_id and order_number fields on the second item are blank so are all products connected by the user login credentials? If so, I will want to add a little note advising visitors they should create an account, though I have guest checkout enabled. (These, then, I imagine would have to refer to their confirmation email?) EDIT: added a second image to show two $1 purcases were treated as a $2 order; my goal is to understand the logic of your method so I can advise customers accordingly.

[edit: I think I have identified three four databases that need to be squared away - there appears to be triangulation quadrilateralization to establish the relationships.]

[ All info in the screenshot is fake or redacted ]

 

Hello spitjack,

I am sorry but I don't understand what do you want to ask exactly.

Sincerely, Giang

Not to worry - I am migrating previous orders into Eshop, and was trying to figure out how you've wired things together. There is no import facility (csv upload) so we have to do this via phpmyadmin. Anyway, I think we have it figured out now.

That's fine spitjack!

Have a nice weekend!

Sincerely, Giang