User Eloquent as customer

[mwagena]

Is it possible to use a Eloquent User as a customer?

To not have 2 different tables with auth logic;
I would like to have a Eloquent User be able to do orders, sign in and view it's orders.

Wat are the possibilities to achieve this?

Thanks in advance.

[duncanmcclean]

Sure, just store your customers as Statamic users and store the Statamic users in the database.

[mwagena]

Also it seems to have issues with creating orders on the User (model / tabel).

[duncanmcclean]

It seems that it's trying to save a published field into my users table.

When you're storing users in a database, you'll need to create migrations for any fields you add to your blueprint. It's mentioned in step 6 of the guide on the Statamic docs.

Also it seems to have issues with creating orders on the User (model / tabel).

What issues?

[mwagena]

About the 'published' column:

• it's caused by this piece of code in: https://github.com/duncanmcclean/simple-commerce/blob/7.x/src/Http/Controllers/Concerns/HandlesCustomerInformation.php#L74

The other issue is occurring when the mollie webhook tries to update the order, the following error is given:
Column not found: 1054 Unknown column 'orders' in 'field list'

[duncanmcclean]

Oh, I see. You might need to add the published column (a boolean) and an orders column (json).

[mwagena]

Hi Duncan, yeah that could be a solution but then we would work around the preferred way of setting relationships (by model relations). You had this tackled already with the Customer model and table. In that case i might take look in implementing it perhaps by a PR.