# Customers Status V3.x

## Recommended Posts

Hope that you will give a full oscommerce package for this....too difficult to implement on existing stores

##### Share on other sites

ok, i will download to my dl area a full package of my osc main file

you'll have also to download customers satus 3.x and qtydisplay allowed for adding non Osc files and the query

##### Share on other sites

Hi elari,

is it also possible to set different prices for different groups of coustomers? Not in %, i need different prices for each group.

any idea?

THx

Jan

##### Share on other sites

yes standard + 3 prices (can be exapanded) avalaible by products

for each group you select the price level you want

##### Share on other sites

sorry, i can?t understand your meanings.

In my shop is no group availible.

Is there some thing wrong?

##### Share on other sites

like orders_status in localization you must set them first time

i will add them in a query for fresh install but you can easilly add them

create at least

Guest Status

New Customer Status

define the setting for these groups

then go in admin configuration / my store and set the according values for each default status

##### Share on other sites

here it is ....

#

# 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);

check the default value, they are commercially non sense but just for test

##### Share on other sites

and to define accorded default statuses

#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',

'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( )

);

##### Share on other sites

elari, i have installed the 2&3x sql and am trying to insert this, but i get this error...

Error

SQL-query :

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)

MySQL said:

Unknown column 'customers_status_price_level' in 'field list'

Back

##### Share on other sites

also getting this error...

Fatal error: Call to undefined function: tep_db_query() in /admin/includes/functions/general_elari_cs.php on line 28

##### Share on other sites

fatal error fixed. application_top_elari_cs.php must be after general.php include in application_top.php

now i am getting this when i check out orders.

1054 - Unknown column 'orders_status_need_conf' in 'field list'

select orders_status_id, orders_status_name, orders_status_need_conf, orders_status_need_conf_id, orders_status_final from orders_status where language_id = '1'

[TEP STOP]

People, i would not recommend installing this. It looks great, and i don't mean to slag a free contribution that someone has worked hard on, but... there is no seperation between this contribution and other contributions, so you either have to install all the contributions that elari has used, or go through and remove all references to them. This is tough, because it's not documented what code belongs to what contribution. is the above error for customer_status, or from one of these that have been included:

- helpdesk 1.0 (snowman)

- Product Listing Hack v.2 (Paul Crovella / John Poynton)

- quantity displayed if allowed (elari)

- cod customer confirmation (elari)

- staffelpreise (jurgen)

- support ticket from Dave

- all product printable catalog 1.5

- easy populate

- Gsm logo and ringtones

- Easy news 1.1

- Faq System

- list order content in admin

- login box / my account modified elari for support ticket

and some other i forgot...

CAUTION!!!

##### Share on other sites
elari, i have installed the 2&3x sql and am trying to insert this, but i get this error...

Error

SQL-query :

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)

MySQL said:

Unknown column 'customers_status_price_level' in 'field list'

Back

you missed that in the querry

#Added 2N0117 Set the price level for each status

ALTER TABLE `customers_status` ADD `customers_status_price_level` INT(1) DEFAULT '0' NOT NULL AFTER `customers_status_image` ;

certaily also miss what follow

#Added 2N0121 New field for upgrading osc since 14 Jan 03 to add new configuration for core osc

#INSERT INTO configuration_group VALUES ('14', 'GZip Compression', 'GZip compression options', '14', '1');

#INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Enable GZip Compression', 'GZIP_COMPRESSION', 'false', 'Enable HTTP GZip compression.', '14', '1', 'tep_cfg_select_option(array('true', 'false'), ', now());

#INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Compression Level', 'GZIP_LEVEL', '5', 'Use this compression level 0-9 (0 = minimum, 9 = maximum).', '14', '2', now());

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

#################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',

'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( )

);

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

#################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',

'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( )

);

##### Share on other sites
fatal error fixed. application_top_elari_cs.php must be after general.php include in application_top.php

You can add these lines at the end of each files, just before existing last line ?>

include('includes/application_top_elari_cs.php');

include('includes/functions/general_elari_cs.php');

include('includes/languages/english_elari_cs.php');

include('includes/languages/french_elari_cs.php');

include('includes/languages/espanol_elari_cs.php');

include('includes/languages/german_elari_cs.php');

Catalog Part

include('includes/functions/general_elari_cs.php');

now i am getting this when i check out orders.

1054 - Unknown column 'orders_status_need_conf' in 'field list'

select orders_status_id, orders_status_name, orders_status_need_conf, orders_status_need_conf_id, orders_status_final from orders_status where language_id = '1'

[TEP STOP]

this is part of DOS_Payment, you can install it or remove unnecessary change

People, i would not recommend installing this. It looks great, and i don't mean to slag a free contribution that someone has worked hard on, but... there is no seperation between this contribution and other contributions, so you either have to install all the contributions that elari has used, or go through and remove all references to them. This is tough, because it's not documented what code belongs to what contribution. is the above error for customer_status, or from one of these that have been included:

- helpdesk 1.0 (snowman)

- Product Listing Hack v.2 (Paul Crovella / John Poynton)

- quantity displayed if allowed (elari)

- cod customer confirmation (elari)

- staffelpreise (jurgen)

- support ticket from Dave

- all product printable catalog 1.5

- easy populate

- Gsm logo and ringtones

- Easy news 1.1

- Faq System

- list order content in admin

- login box / my account modified elari for support ticket

and some other i forgot...

CAUTION!!!

yes this is why all osc files are in a separate osc_files that MUST be compared to the file you have.

most change made are indicated in files

1/ in the header there is indicated the hack installed

2/ before most files i have changed i have added the corresponding hack

i agree this is a hard to install contrib, but i will not manage only for your ease plenty version of my change that will be too easy break & loose many part

yes, again, this is hard to implement cstatus, but this is the only way i found to be nearest osc implementation and coding statndard without adding too many separate query that overload server

& nobody force you to use it :)

last, you can pay me to install all contrib directly on your server :)))

##### Share on other sites
yes, again, this is hard to implement cstatus, but this is the only way i found to be nearest osc implementation and coding statndard without adding too many separate query that overload server

& nobody force you to use it :)

last, you can pay me to install all contrib directly on your server :)))

Hello elari and hello guys!

I wanted to have an ecomm website for me and the customers status was fine to me. I can say that the hack from the osc was too hard to me and so i moved to a "normal" oscommerce

Anyway I would like to say that elari was very nice with me and supported me a lot so please don't blame if the contribution is too hard to install. It's free and so if You are not able to hack, don't hack or pay a person that is able to.

Anyway, a good gift certificate for elari will be the first thing i will do when I'll open the online store

##### Share on other sites

thanks for the help. i went to install the sql you provided through phpmyadmin and got this

Error

SQL-query :

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)

MySQL said:

Duplicate entry '1-1' for key 1

here's the table...

Field Type Attributes Null Default Extra Action

customers_status_id int(11) No 0 Change Drop Primary Index Unique Fulltext

language_id int(11) No 1 Change Drop Primary Index Unique Fulltext

customers_status_name varchar(32) No Change Drop Primary Index Unique Fulltext

customers_status_public int(1) No 1 Change Drop Primary Index Unique Fulltext

customers_status_image varchar(64) Yes NULL Change Drop Primary Index Unique Fulltext

customers_status_price_level int(1) No 0 Change Drop Primary Index Unique Fulltext

customers_status_discount decimal(4,2) Yes 0.00 Change Drop Primary Index Unique Fulltext

customers_status_ot_discount_flag char(1) No 0 Change Drop Primary Index Unique Fulltext

customers_status_ot_discount decimal(4,2) Yes 0.00 Change Drop Primary Index Unique Fulltext

customers_status_staffelpreis char(1) No Change Drop Primary Index Unique Fulltext

customers_status_show_price int(1) No 1 Change Drop Primary Index Unique Fulltext

customers_status_show_price_tax int(1) No 1 Change Drop Primary Index Unique Fulltext

customers_status_payment_unallowed varchar(255) No Change Drop Primary Index Unique Fulltext

--------

You are right nobody forced me to use it. i just wanted to warn people of limited experience not to try installing this.

yes this is why all osc files are in a separate osc_files that MUST be compared to the file you have.

most change made are indicated in files

most contributions that i have seen provide just the code changes, not the full install files. this may confuse people. i have never seen the DOS cont before, so i was not sure if it is a part of this or not. I think that it's not a bad way to do it, it was really easy with Beyond Compare, but i think the challenge for people comes when the aren't sure if it is another contribution or this one.

Basically i think OSC needs a module install application like postnuke. it's slick. :)

Ryan

##### Share on other sites
Basically i think OSC needs a module install application like postnuke. it's slick. :)

I believe that is being investigated for a totally new version.

Customer Status 2.x works great for me ! I am just waiting for the

fantastic pace at which elari delivers code for 3.x to stabilize before I try

to integrate it. Customer status is a fantastic and complicated modification, and I am extremelly happy that he has taken up the

In elari's defence, He does provide a loaded version at:

Granted it does not have Customer Status 3x yet, but I am sure he can

put it there soon. Very helpful if your starting a new store.

Eagerly awaiting a stable version :lol:

ibandyop

##### Share on other sites

will be ready with ms1 :) which we all hope will ease some update on stable basis

##### Share on other sites
most contributions that i have seen provide just the code changes, not the full install files. this may confuse people. i have never seen the DOS cont before, so i was not sure if it is a part of this or not.Ryan

as you can see the number of change to make, i can not provide a " how to" and which line to change, it will make more work, more errors...

i think providing the files i use is the best way and make compare

i prefer using examdiff pro v3 from prestosoft

it's really the most powerfull tool i've found

##### Share on other sites

elari,

any ideas?

SQL-query :

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)

MySQL said:

Duplicate entry '1-1' for key 1

1054 - Unknown column 'date_finished' in 'field list'

select customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, comments, currency, currency_value, date_purchased, orders_status, last_modified, customers_fax, customers_ip_order, customers_ip_order_host, customers_ip_confirm, customers_ip_confirm_host, customers_status, customers_status_name, customers_status_image, customers_status_discount, date_finished, orders_status_closed, orders_status_need_conf, orders_status_need_conf_password from orders where orders_id = '100'

here's the table...

Field Type Attributes Null Default Extra Action

customers_status_id int(11) No 0 Change Drop Primary Index Unique Fulltext

language_id int(11) No 1 Change Drop Primary Index Unique Fulltext

customers_status_name varchar(32) No Change Drop Primary Index Unique Fulltext

customers_status_public int(1) No 1 Change Drop Primary Index Unique Fulltext

customers_status_image varchar(64) Yes NULL Change Drop Primary Index Unique Fulltext

customers_status_price_level int(1) No 0 Change Drop Primary Index Unique Fulltext

customers_status_discount decimal(4,2) Yes 0.00 Change Drop Primary Index Unique Fulltext

customers_status_ot_discount_flag char(1) No 0 Change Drop Primary Index Unique Fulltext

customers_status_ot_discount decimal(4,2) Yes 0.00 Change Drop Primary Index Unique Fulltext

customers_status_staffelpreis char(1) No Change Drop Primary Index Unique Fulltext

customers_status_show_price int(1) No 1 Change Drop Primary Index Unique Fulltext

customers_status_show_price_tax int(1) No 1 Change Drop Primary Index Unique Fulltext

customers_status_payment_unallowed varchar(255) No Change Drop Primary Index Unique Fulltext

##### Share on other sites
elari,

any ideas?

SQL-query :

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)

MySQL said:

Duplicate entry '1-1' for key 1

1054 - Unknown column 'date_finished' in 'field list'

select customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, comments, currency, currency_value, date_purchased, orders_status, last_modified, customers_fax, customers_ip_order, customers_ip_order_host, customers_ip_confirm, customers_ip_confirm_host, customers_status, customers_status_name, customers_status_image, customers_status_discount, date_finished, orders_status_closed, orders_status_need_conf, orders_status_need_conf_password from orders where orders_id = '100'

here's the table...

Field Type Attributes Null Default Extra Action

customers_status_id int(11) No 0 Change Drop Primary Index Unique Fulltext

language_id int(11) No 1 Change Drop Primary Index Unique Fulltext

customers_status_name varchar(32) No Change Drop Primary Index Unique Fulltext

customers_status_public int(1) No 1 Change Drop Primary Index Unique Fulltext

customers_status_image varchar(64) Yes NULL Change Drop Primary Index Unique Fulltext

customers_status_price_level int(1) No 0 Change Drop Primary Index Unique Fulltext

customers_status_discount decimal(4,2) Yes 0.00 Change Drop Primary Index Unique Fulltext

customers_status_ot_discount_flag char(1) No 0 Change Drop Primary Index Unique Fulltext

customers_status_ot_discount decimal(4,2) Yes 0.00 Change Drop Primary Index Unique Fulltext

customers_status_staffelpreis char(1) No Change Drop Primary Index Unique Fulltext

customers_status_show_price int(1) No 1 Change Drop Primary Index Unique Fulltext

customers_status_show_price_tax int(1) No 1 Change Drop Primary Index Unique Fulltext

customers_status_payment_unallowed varchar(255) No Change Drop Primary Index Unique Fulltext

you have to set this field in the table

'date_finished' in tha table 'ORDERS' not 'customers_status'

read the query line by line, compare with your actual tables and make your brain work a little more :)

##### Share on other sites

elari

I have made the necessary changes but where do I see the settings of what I have done.

Where is it in the admin section?

##### Share on other sites

Hiya All,

I just love this mod!!

Anyways,

is there any way tobe able to let the admin set the image ov a 'customer status' in some other way than it is now (Browse) as this is a pain in the ass!!

Maybe a drop down list or something, im sure you'll agree this would be better.

Thanks,

Warren

##### Share on other sites

OH NO!!!!!!!!!!!!!!!!!!

I have just found a problem with my cart!!

I will pay for anyone to fix this!!

Whenever a customer signs up, it automatically makes them a newsletter account no matter how they do it (ie if the sign up for a full account) and when they want to upgrade, it still remain as a news account!

Anybody,

Remeber I can PAY!!

PM Me or suggest what the matter may be, PLEASE!!

Warren

##### Share on other sites

PLZ :( :( :( :( :(

##### Share on other sites

:evil: :evil: :evil: :evil: