How can I change a Global Customers Price level from standard to Price A, after the store has been sync. with HQ. I will need to change all global customers in all stores to Price level A.
Changeing HQ Global Customer Price levels
Sep 24, 2007
1 Replies
The following query will do the job.
UPDATE Customer Set PriceLevel = 1 WHERE GlobalCustomer 0
PriceLevel
0 = Standard 1 = Price Level A 2 = Price Level B 3 = Price Level CAll global customers will then update at the stores the next time they sync with HQ
Please ensure you have a backup prior to running any SQL updates and always test on a test database and check if you get the desired results before performing on the live system.
Regards Michael (Brisbane, Australia)
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required