change local customer to global customer

Posted by Victor on July 24, 2007, 8:02 am

Please log in for more thread options

I am trying to change the local customers that i have in my store database to
global customers in hq

I ran this querie in store administrator
UPDATE Customer SET GlobalCustomer = 1

Then ran worksheet 401 in hq, but the customers did not update, then
worksheet 350.

Can someone help?

Posted by Luminox on July 24, 2007, 9:12 am

Please log in for more thread options

Had the same issue ... this worked for me - need to set globalcustomer = 1;
need to set lastupdated = getdate(*); need to set storeid = 'xxxx' (whatever
is appropriate for you). Go into SO Manager and configure ENABLE GLOBAL
CUSTOMERS and NEW CUSTOMERS DEFAULT AS GLOBAL. Need to run 401 TWICE (once to
upload customer records from stores to HQ and again (minutes later) to
download customer records from HQ to each of the other stores.

Hope this helps.

"Victor" wrote:

> I am trying to change the local customers that i have in my store database to

> global customers in hq

> I ran this querie in store administrator

> UPDATE Customer SET GlobalCustomer = 1

> Then ran worksheet 401 in hq, but the customers did not update, then

> worksheet 350.

> Can someone help?

Posted by Victor on July 24, 2007, 6:26 pm

Please log in for more thread options

Thanks for your reply, I am not a sql guy
I did run the sql UPDATE Customer SET GlobalCustomer = 1
can you give me the exact sql staement that i have to run i want to update
all of my customers in my database i started using rms in 05-2005

thank you
Victor

"Luminox" wrote:

> Had the same issue ... this worked for me - need to set globalcustomer = 1;

> need to set lastupdated = getdate(*); need to set storeid = 'xxxx' (whatever

> is appropriate for you). Go into SO Manager and configure ENABLE GLOBAL

> CUSTOMERS and NEW CUSTOMERS DEFAULT AS GLOBAL. Need to run 401 TWICE (once to

> upload customer records from stores to HQ and again (minutes later) to

> download customer records from HQ to each of the other stores.

> Hope this helps.

> "Victor" wrote:

> > I am trying to change the local customers that i have in my store database

> > global customers in hq

> >

> > I ran this querie in store administrator

> > UPDATE Customer SET GlobalCustomer = 1

> >

> > Then ran worksheet 401 in hq, but the customers did not update, then

> > worksheet 350.

> >

> > Can someone help?