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.
- posted
16 years ago
Changeing HQ Global Customer Price levels
Loading thread data ...
- Vote on answer
- posted
16 years ago
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)