Add a customer with a SQL query

[Uchiha]

Hi!

 

To do this, I know I have to insert the data in the ps_customer table. But I don't know what to insert in some columns, like secure_key and optin. How could I do this?

 

Thanks!

[sadlyblue]

As rocky said on another post:

 

I'm currently working on an osCommerce Import module with Tomer. The secure_key is just a random key. Use the following code to generate it:

 

md5(uniqid(rand(), true))

[Uchiha]

As rocky said on another post:

Thanks. But could this impact in user's login?

[benjamin utterback]

Hi Uchiiha, you can also add your customers via CSV, or through the Back Office Admin.

[Uchiha]

Hi Uchiiha, you can also add your customers via CSV, or through the Back Office Admin.

Thanks. I know, but I'll develop a little interface to do some stuff. One of those is the quick customer register.

[benjamin utterback]

Oh okay, actually I don't know what fields need to be present in order to add a customer through SQL.

[tomerg3]

It is best to use the Prestashop Customer class to do it, that way you will be sure all the fields are actually valid (IE content complies with all the length / type limits)