New customers automatically join defined pricing group

gaekwad · 1st July 2007, 07:32 PM

Hi there.
Is it possible to have new customers be added to a pre-defined pricing group by default? I can add them manually, but I'm using the Invoice payment mod and it requires a customer to be in a pricing group.

Thanks in advance.
P

Ajeh · 1st July 2007, 09:50 PM

You can alter the create account so that when the record is created it sets the customers_group_pricing field in the customers table to the value that you are wanting to use as an existing discount group by default ...

gaekwad · 1st July 2007, 10:27 PM

Sweet - that makes perfect sense :) Could I ask which file needs to be edited in order to make that happen? Happy to scootch around a bit, but any pointer would be appreciated.

Thanks, Ajeh - appreciate it :)

swguy · 2nd July 2007, 01:19 AM

Rather than modifying the code, I would suggest you just modify the default value for customers.customers_group_pricing using phpMyAdmin.

Good luck,
Software Guy

gaekwad · 2nd July 2007, 02:44 AM

swguy, you're a genius - thanks. Works a treat! And thanks for making the Invoice mod, very useful.

jenpen · 15th April 2009, 04:26 AM

Quote:

modify the default value for customers.customers_group_pricing using phpMyAdmin

Can anyone give just a little more detail on this? I'm pretty comfortable in phpMyAdmin, just give me a push in the right direction ... jenpen

jenpen · 20th April 2009, 06:08 AM

Me again - does anyone know exactly how to "modify the default value for customers.customers_group_pricing using phpMyAdmin"??
Thanks, Jen

DrByte · 20th April 2009, 11:36 AM

Open phpMyAdmin
Access the customers table structure
Edit the "default" value for the customers_group_pricing table to the value you desire.

jenpen · 21st April 2009, 07:38 AM

So now I'm nearly there ... found exactly how to change the default value but ... what to? Sorry to be a dodo. I tried "invoice" but got an error. Jen

DrByte · 21st April 2009, 07:51 AM

When you created your discount groups in your admin, they were assigned a number. Use that number.

1st July 2007, 07:32 PM	#1
gaekwad New Zenner Join Date: May 2007 Posts: 33	New customers automatically join defined pricing group Hi there. Is it possible to have new customers be added to a pre-defined pricing group by default? I can add them manually, but I'm using the Invoice payment mod and it requires a customer to be in a pricing group. Thanks in advance. P

1st July 2007, 09:50 PM	#2
Ajeh Oba-san Join Date: Sep 2003 Location: Ohio Posts: 51,207	Re: New customers automatically join defined pricing group You can alter the create account so that when the record is created it sets the customers_group_pricing field in the customers table to the value that you are wanting to use as an existing discount group by default ... __________________ 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

1st July 2007, 10:27 PM	#3
gaekwad New Zenner Join Date: May 2007 Posts: 33	Re: New customers automatically join defined pricing group Sweet - that makes perfect sense :) Could I ask which file needs to be edited in order to make that happen? Happy to scootch around a bit, but any pointer would be appreciated. Thanks, Ajeh - appreciate it :)

2nd July 2007, 01:19 AM	#4
swguy Totally Zenned Join Date: Feb 2006 Location: Tampa Bay, Florida Posts: 2,837	Re: New customers automatically join defined pricing group Rather than modifying the code, I would suggest you just modify the default value for customers.customers_group_pricing using phpMyAdmin. Good luck, Software Guy __________________ That Software Guy - The Duke of Discounting. Quantity Discounts, Better Together, SMS on Sale, Gift Wrap at Checkout, and more. Tweeting at @thatsoftwareguy. Constantly releasing new software and telling bad jokes.

2nd July 2007, 02:44 AM	#5
gaekwad New Zenner Join Date: May 2007 Posts: 33	Re: New customers automatically join defined pricing group swguy, you're a genius - thanks. Works a treat! And thanks for making the Invoice mod, very useful.

20th April 2009, 06:08 AM	#7
jenpen Zen Follower Join Date: Sep 2007 Location: Far South Coast, NSW, Australia Posts: 138	Re: New customers automatically join defined pricing group Me again - does anyone know exactly how to "modify the default value for customers.customers_group_pricing using phpMyAdmin"?? Thanks, Jen

20th April 2009, 11:36 AM	#8
DrByte Sensei Join Date: Jan 2004 Location: Ontario, Canada Posts: 39,865	Re: New customers automatically join defined pricing group Open phpMyAdmin Access the customers table structure Edit the "default" value for the customers_group_pricing table to the value you desire. __________________ Zen Cart - putting the dream of business ownership within reach of anyone!

21st April 2009, 07:38 AM	#9
jenpen Zen Follower Join Date: Sep 2007 Location: Far South Coast, NSW, Australia Posts: 138	Re: New customers automatically join defined pricing group So now I'm nearly there ... found exactly how to change the default value but ... what to? Sorry to be a dodo. I tried "invoice" but got an error. Jen

21st April 2009, 07:51 AM	#10
DrByte Sensei Join Date: Jan 2004 Location: Ontario, Canada Posts: 39,865	Re: New customers automatically join defined pricing group When you created your discount groups in your admin, they were assigned a number. Use that number. __________________ Zen Cart - putting the dream of business ownership within reach of anyone!

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
Group Pricing for One Product Category?	PattyGale	Discount Groups	15	22nd September 2009 11:21 PM
group pricing	kmickus	Discount Groups	3	2nd May 2007 10:46 PM