Mystery solved / List of customers who have registered account / customer groups & discounts

[vampira]

I would like to activate an automatic 5% discount for all logged in customers.

The shop itself is 10+ years old, has been updated/migrated from 1.3->1.6->1.7.8 and therefore has the Customer Groups Default/Guest/Visitor. I know that now it is Visitor/Guest/Customer, but I have not figured out how the old classification corresponds to that.

As I'm not sure to which of these groups should I add the 5% discount (I tried the default one, but it gives a discount to a guest user as well), the easiest way would probably be to create a new group and assign the discount there? But for that, I need to get info about which customers actually have an account, so I can add only them to this group.

If the info is relevant, then one-page check-out is not possible due to the theme.

 

Edited January 24 by vampira
Solved! (see edit history)

[Prestashop Addict]

Hi, in table ps_customer you have the column is_guest that is set to 1 if the customer is a guest.

[vampira]

Thank you for the answer!

I now ran a SQL query to get the id_default_group from the ps_customer table and with this I understood to which group I must assign the discount to. It was Group 3 (whatever the original name was, I now changed it to Loyal Customer).

[Prestashop Addict]

il y a 43 minutes, vampira a dit :

I now ran a SQL query to get the id_default_group from the ps_customer table and with this I understood to which group I must assign the discount to. It was Group 3 (whatever the original name was, I now changed it to Loyal Customer).

Be careful if your change de id_default_group in ps_customer you must change also the relational table ps_customer_group!

[vampira]

And back to unresolved :(.

Why do some of the Guest accounts have Group 3 and others have Group 1 id number in the ps_customer table column id_default_group? It's really confusing :(.

Is there any other way I could get the correct information if this email has been used for creating a customer account or not?

In the customer profile I can see the difference (see the screenshots), but it is not possible to go through all the customers manually. Not to mention that the customers actually are doubled or tripled or even more times accounted for due to the Prestashop illogic.

[Prestashop Addict]

il y a 57 minutes, vampira a dit :

Why do some of the Guest accounts have Group 3 and others have Group 1 id number in the ps_customer table column id_default_group? It's really confusing :(.
Is there any other way I could get the correct information if this email has been used for creating a customer account or not?

It certainly when guest changed to customer their account

[vampira]

Figured it out. During the migration, the automatic group assigment had been messed up. Need to find a way to correct this, but it is another topic :).

Thanks for your input!