Force User To Change

General General Questions
1

Hi all

I want to force all user to update their citys

It is anough to empty "s_city" from "cscart_user_profiles" table ?

we have a sql command for this ?

Thanks

2

That wold force them to update on new orders. Don't foget to do user_profiles as well if you do.

3

Hi all

I want to force all user to update their citys

It is anough to empty "s_city" from "cscart_user_profiles" table ?

we have a sql command for this ?

Thanks

Yes, this solution will work. Do not forget to make this field required

4

Yes, this solution will work. Do not forget to make this field required

Can write me sql command for this ?!

Thanks a lot

5 
UPDATE cscart_user_profiles SET s_city = '';

To make field required, go to Design -> Layouts -> Layouts -> Checkout, open the Deliver to block settings and go to Content tab

6 
UPDATE cscart_user_profiles SET s_city = '';

To make field required, go to Design -> Layouts -> Layouts -> Checkout, open the Deliver to block settings and go to Content tab

Thanks a lot

Can edit your previous quote ?

I forgot external link there

Thanks

7

Thanks a lot

Can edit your previous quote ?

I forgot external link there

Thanks

Done

8

Now

Old customers when make order can do this without street profile

So i reciev orders without this profile :(

Some other ideas to force client to do this ?

Profile field is allready mandatory

9

profile means field