customer groups function

[godt08]

I am interested in how the 'customer groups' function works: I assume that in combination with the ' Separate Pricing Per Customer' function, it is possible to set different prices for each product, and that these different prices are associated with different customer groups. So that when customer from group 1 logs in, all products display prices appropriate to that group.

Is that the way it will work?

[michael_s]

Yep that is the way it works.

Set up your groups, say, Retail, wholesale.

Then set up your products, and right in the product page, there is the field to place the retail price and a field for the wholesale price.

Then, you go into the customers section and edit the customers that you want assigned to the wholesale group. Then when they login, they see the wholesale prices.

[godt08]

Thanks for that. Is it possible to have a group with no prices, or will osMax baulk at the absence of a price?

[michael_s]

The groups do not get prices... only products do. If you have two product groups, Retail and Wholesale, and you do not set a wholesale price for a product, it will simply display the retail price by default. If you don't set a retail price, it will be free.

[tcshadow]

I don't suppose there's a way to just make it so that wholesale customers get an accross the board discount of 10% on everything without having to edit every single product?

[met00]

May I suggest ezpopulate is your solution?

1) load all the product with prices for your primary group (retail)
2) download with ezpop
3) open up in a spreadsheet
4) create a new column between the two groups prices
5) user a formula to create the new prices for the wholesale group in the new column
6) copy the VALUES to the wholesale price column
7) delete the formula column
save the file as tab delineated
9) upload and update using ezpop

and then you have all the system set up.

If you want to make life easier for updates add a javascript function that takes the prices when you enter them in retail and deducts 10% and pre-fills the wholesale form field. (if you want to see how that works, look at the javascript code in some mortgage rate calculator and lift it for this use. It's not that hard. You just need to add the javascript action to the first field and have it do the math and load the second field with the values.)

[tcshadow]

That's an excellent and easy workaround. Never thought of using EZpopulate cause i'm not used to it being installed since I've come from a pretty vanilla oscommerce install.

[met00]

It's what works for us all the time when we help people set up stores. Of course we have to mod the hell out of it to work with our stores since we have moded the hell out of osCMAX

[tcshadow]

for some reason when i download the easypopulate file, edit it, then reupload and click insert into database it throws a bunch of erros at me and does nothing... and all I was doing was editing data in the existing columns.

Warning: move_uploaded_file(/home/tcsbrook/public_html/oscmax/default//temp/EP2008Feb20-0909.txt) [Web Hosting, Dedicated Servers & E-Commerce]: failed to open stream: Permission denied in /home/tcsbrook/public_html/oscmax/default/admin/easypopulate_functions.php on line 32

Warning: move_uploaded_file() [Web Hosting, Dedicated Servers & E-Commerce]: Unable to move '/tmp/phpv7yy2t' to '/home/tcsbrook/public_html/oscmax/default//temp/EP2008Feb20-0909.txt' in /home/tcsbrook/public_html/oscmax/default/admin/easypopulate_functions.php on line 32

Warning: fopen(/home/tcsbrook/public_html/oscmax/default//temp/EP2008Feb20-0909.txt) [Web Hosting, Dedicated Servers & E-Commerce]: failed to open stream: No such file or directory in /home/tcsbrook/public_html/oscmax/default/admin/easypopulate.php on line 734

Warning: fgets(): supplied argument is not a valid stream resource in /home/tcsbrook/public_html/oscmax/default/admin/easypopulate.php on line 737
Creating file EP_Split1.txt ...
Warning: fopen(/home/tcsbrook/public_html/oscmax/default//temp/EP_Split1.txt) [Web Hosting, Dedicated Servers & E-Commerce]: failed to open stream: Permission denied in /home/tcsbrook/public_html/oscmax/default/admin/easypopulate.php on line 743

Warning: fwrite(): supplied argument is not a valid stream resource in /home/tcsbrook/public_html/oscmax/default/admin/easypopulate.php on line 744

Warning: fgets(): supplied argument is not a valid stream resource in /home/tcsbrook/public_html/oscmax/default/admin/easypopulate.php on line 747
Added 0records and closing file...


Warning: fclose(): supplied argument is not a valid stream resource in /home/tcsbrook/public_html/oscmax/default/admin/easypopulate.php on line 773

Warning: fclose(): supplied argument is not a valid stream resource in /home/tcsbrook/public_html/oscmax/default/admin/easypopulate.php on line 774
You can download your split files at Tools / Files in /catalog/temp/

[met00]

move_uploaded_file(/home/tcsbrook/public_html/oscmax/default//temp/EP2008Feb20-0909.txt)

check the protections on: /home/tcsbrook/public_html/oscmax/default//temp
(don't worry about the // it shouldn't effect anything)