different price per customer

[andrea]

hi! exist a countribute to make a different price per costumer for version 2.2csv?

I test "separate price for customer v 3.3" but dont work with this version! :shock:

Anyone know alternative contribute?

sorry for my english...

bye medo

[/b]

[Eliot Rayner]

You could have a look at 'Customer Status' by Elari, a great mod

 

http://www.oscommerce.com/community/contri...ions,315/page,4

 

hope this helps

 

Eliot

[andrea]

hi Eliot thank you for hit bou i have a problem...

why in administrator panel in my store -> costumer status (ecc.) i havent notingh to select??? :oops:

thanks

[elari]

you have to set some cs

 

the query includes some standard value for cs

maybe the query did not run completly

 

check the query in my cvs i think it was updated a little bit after the last published package

 

it need to add something like

########################################################################

#################PACKAGE PRIVATE -> 2N0130                             #

########################################################################

 

#2n0203 change the value of customers satus box for admin

 

DELETE FROM configuration WHERE configuration_key = 'DEFAULT_CUSTOMERS_STATUS_ID_GUEST';

DELETE FROM configuration WHERE configuration_key = 'DEFAULT_CUSTOMERS_STATUS_ID_NEWSLETTER';

DELETE FROM configuration WHERE configuration_key = 'DEFAULT_CUSTOMERS_STATUS_ID';

 

INSERT INTO configuration_group VALUES ('98', 'Customer Status', 'Customers Status Default Option', '98', '1');

 

INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added )

values (

'Customers Status Guest',

'DEFAULT_CUSTOMERS_STATUS_ID_GUEST',

'1',

'What would be the default customers status for a guest before logged in ?',

'98',

'1',

'tep_get_customers_status_name',

'tep_cfg_pull_down_customers_status_list(',

now( )

);

 

INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added )

values (

'Customers Status Subscribe to Newsletter Only',

'DEFAULT_CUSTOMERS_STATUS_ID_NEWSLETTER',

'2',

'What would be the default customers status for subscribing to newsletter before without create account ?',

'98',

'2',

'tep_get_customers_status_name',

'tep_cfg_pull_down_customers_status_list(',

now( )

);

 

INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added )

values (

'Customers Status For New Customers',

'DEFAULT_CUSTOMERS_STATUS_ID',

'3',

'What would be the default customers status for a new customer ?',

'98',

'3',

'tep_get_customers_status_name',

'tep_cfg_pull_down_customers_status_list(',

now( )

);

[elari]

sorry there was this code before the last post

 

########################################################################

#################PACKAGE PUBLISHED 2N0117 -> 2N0123                    #

########################################################################

 

 

 

#Added 2N0124 for request of default status missing

# Contenu de la table `customers_status`

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (1, 1, 'Guest Status', 1, 'light-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 0, 0);

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (1, 2, 'Guest Status', 1, 'light-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 0, 0);

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (1, 3, 'Guest Status', 1, 'light-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 0, 0);

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (1, 4, 'Guest Status', 1, 'light-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 0, 0);

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (2, 1, 'Newsletter Only', 1, 'icon_eye.gif', 0, '10.00', '0', '0.00', '0', 'all', 1, 0);

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (2, 2, 'Newsletter Only', 1, 'icon_eye.gif', 0, '10.00', '0', '0.00', '0', 'all', 1, 0);

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (2, 3, 'Newsletter Only', 1, 'icon_eye.gif', 0, '10.00', '0', '0.00', '0', 'all', 1, 0);

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (2, 4, 'Newsletter Only', 1, 'icon_eye.gif', 0, '10.00', '0', '0.00', '0', 'all', 1, 0);

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (3, 1, 'New Customer', 1, 'smile-grey.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1);

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (3, 2, 'Neue', 1, 'smile-grey.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1);

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (3, 3, 'Novo', 1, 'smile-grey.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1);

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (3, 4, 'Nouveau Client', 1, 'smile-grey.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1);

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (4, 1, 'Trustable', 1, 'smile-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1);

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (4, 2, 'Trustable', 1, 'smile-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1);

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (4, 3, 'Trustable', 1, 'smile-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1);

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (4, 4, 'Confiance', 1, 'smile-yellow.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1);

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (5, 1, 'Care', 0, 'smile-orange.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1);

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (5, 2, 'Care', 0, 'smile-orange.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1);

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (5, 3, 'Care', 0, 'smile-orange.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1);

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (5, 4, 'Faire Attention', 0, 'smile-orange.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1);

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (6, 1, 'No COD', 0, 'smile-red.gif', 0, '0.00', '0', '0.00', '0', 'cod', 1, 1);

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (6, 5, 'Pas de CRBT', 0, 'smile-red.gif', 0, '0.00', '0', '0.00', '0', 'cod', 1, 1);

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (6, 2, 'No COD', 0, 'smile-red.gif', 0, '0.00', '0', '0.00', '0', 'cod', 1, 1);

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (6, 3, 'No COD', 0, 'smile-red.gif', 0, '0.00', '0', '0.00', '0', 'cod', 1, 1);

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (7, 1, 'Banned', 0, 'bad-man-red-light.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1);

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (7, 4, 'Interdit', 0, 'bad-man-red-light.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1);

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (7, 2, 'Banned', 0, 'bad-man-red-light.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1);

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (7, 3, 'Banned', 0, 'bad-man-red-light.gif', 0, '0.00', '0', '0.00', '0', '', 1, 1);

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (8, 1, 'Reseller', 1, 'hand-up.gif', 0, '100.00', '0', '0.00', '0', '', 1, 1);

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (8, 2, 'Reseller', 1, 'hand-up.gif', 0, '100.00', '0', '0.00', '0', '', 1, 1);

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (8, 3, 'Reseller', 1, 'hand-up.gif', 0, '100.00', '0', '0.00', '0', '', 1, 1);

INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_image`, `customers_status_price_level`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_staffelpreis`, `customers_status_payment_unallowed`, `customers_status_show_price`, `customers_status_show_price_tax`) VALUES (8, 4, 'Revendeur', 1, 'hand-up.gif', 0, '100.00', '0', '0.00', '0', '', 1, 1);

 

#CHANGED 2N0124 to define new default statuses according to default values

#Set the default Customers status for News Customers, Guest Not logged, Newsletter subscribe only

#These options would be set in admin / my store

 

DELETE FROM configuration WHERE configuration_key = 'DEFAULT_CUSTOMERS_STATUS_ID';

 

INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added )

values (

'Customers Status Guest',

'DEFAULT_CUSTOMERS_STATUS_ID_GUEST',

'1',

'What would be the default customers status for a guest before logged in ?',

'1',

'1',

'tep_get_customers_status_name',

'tep_cfg_pull_down_customers_status_list(',

now( )

);

 

INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added )

values (

'Customers Status For New Customers',

'DEFAULT_CUSTOMERS_STATUS_ID',

'1',

'What would be the default customers status for a new customer ?',

'1',

'2',

'tep_get_customers_status_name',

'tep_cfg_pull_down_customers_status_list(',

now( )

);

 

 

INSERT INTO configuration( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function, date_added )

values (

'Customers Status Subscribe to Newsletter Only',

'DEFAULT_CUSTOMERS_STATUS_ID_NEWSLETTER',

'1',

'What would be the default customers status for subscribing to newsletter before without create account ?',

'1',

'3',

'tep_get_customers_status_name',

'tep_cfg_pull_down_customers_status_list(',

now( )

);