assign all customers to discount group

jenpen · 14th April 2009, 09:14 AM

Hi,
I have installed the Invoice module (it's excellent) and now wish to assign ALL customers to the discount group "invoice" as this is the only payment method my client wants to use (he's a wholesaler).
Is there some way to automatically add every new customer to this group? All customers must be approved before getting an account.
TIA, jenpen

Ajeh · 14th April 2009, 04:28 PM

Back up the customers table and then find the group_id you want to use, then you can run in the Tools ... Install SQL Patches ...

Code:

UPDATE customers SET customers_group_pricing = XX;

where XX is the group_id that you want to use ...

This will set all existing customers for this group ...

jenpen · 15th April 2009, 01:22 AM

Thanks - is there any way to assign them automatically as they are approved, rather than afterwards?

DrByte · 15th April 2009, 02:39 AM

http://www.zen-cart.com/forum/showthread.php?t=69499

jenpen · 15th April 2009, 04:27 AM

Thanks, that's exactly what I needed - now I just need more detail. Have asked the question in the other thread.

14th April 2009, 09:14 AM	#1
jenpen Zen Follower Join Date: Sep 2007 Location: Far South Coast, NSW, Australia Posts: 131	assign all customers to discount group Hi, I have installed the Invoice module (it's excellent) and now wish to assign ALL customers to the discount group "invoice" as this is the only payment method my client wants to use (he's a wholesaler). Is there some way to automatically add every new customer to this group? All customers must be approved before getting an account. TIA, jenpen

14th April 2009, 04:28 PM	#2
Ajeh Oba-san Join Date: Sep 2003 Location: Ohio Posts: 50,229	Re: assign all customers to discount group Back up the customers table and then find the group_id you want to use, then you can run in the Tools ... Install SQL Patches ... Code: UPDATE customers SET customers_group_pricing = XX; where XX is the group_id that you want to use ... This will set all existing customers for this group ... __________________ Linda McGrath If you have to think ... you haven't been zenned ... Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here Are you using the latest? Perhaps you've a problem that's fixed in --> [Upgrade today: v1.3.8a] Officially PayPal-Certified! Just click here

15th April 2009, 01:22 AM	#3
jenpen Zen Follower Join Date: Sep 2007 Location: Far South Coast, NSW, Australia Posts: 131	Re: assign all customers to discount group Thanks - is there any way to assign them automatically as they are approved, rather than afterwards?

15th April 2009, 02:39 AM	#4
DrByte Sensei Join Date: Jan 2004 Location: Ontario, Canada Posts: 38,586	Re: assign all customers to discount group http://www.zen-cart.com/forum/showthread.php?t=69499 __________________ Zen Cart - putting the dream of business ownership within reach of anyone!

15th April 2009, 04:27 AM	#5
jenpen Zen Follower Join Date: Sep 2007 Location: Far South Coast, NSW, Australia Posts: 131	Re: assign all customers to discount group Thanks, that's exactly what I needed - now I just need more detail. Have asked the question in the other thread.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Discount by group of customers and by category of products	Mikado	Discount Groups	2	29th August 2008 08:24 PM
Automatically assign new customers to group_discount	Maypole	Customers and Orders	2	20th November 2007 01:12 AM
Auto assign to user group by product purchase	craftsyr	Customers and Orders	2	3rd September 2007 04:33 PM
Discount Group not accepting customers	tonibarcelona	Bug Reports	9	27th February 2007 06:13 PM