Price Unavailable

[CnTGifts]

everything on my store is showing price unavailable, If you log in you ca nsee the price

in the admin under customer details i have it set to 0 on Customer Shop Status - View Shop and Prices



Any ideas

[Ajeh]

What is the setting for:

Customer Approval Status - Authorization Pending
Customer must be Authorized to shop
0= Not required
1= Must be Authorized to Browse
2= May browse but no prices unless Authorized
3= Customer May Browse and May see Prices but Must be Authorized to Buy

It is recommended that Option 2 or 3 be used for the purposes of Spiders

[CnTGifts]

hmm in customer details all i see is this

Customer Details

Title Value Action
Email Salutation false
Date of Birth false
Company false
Address Line 2 true
State true
State - Always display as pulldown? false
Create Account Default Country ID United States
Require Referral true
Fax Number false
Show Newsletter Checkbox 1
Customer Default Email Preference 0
Customer Product Notification Status 1
Customer Shop Status - View Shop and Prices 0
Customers Referral Status 0



My prices have been showing up, i just noticed this was happening

http://www.cnt-gifts.com

[Ajeh]

What is the URL for this?

[CnTGifts]

http://www.cnt-gifts.com

[Ajeh]

Switch to Classic Template for a minute ...

This looks like a code issue where the settings for Customer Approval is not being set right if you have that set to 0 on the database and are still seeing that in place of the button ...

[CnTGifts]

k switched to classic but its still the same

[CnTGifts]

seems though the custom approval section was deleted fro mthe database somehow

i ran this query

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Customer Approval Status - Authorization Pending', 'CUSTOMERS_APPROVAL_AUTHORIZATION', '0', 'Customer must be Authorized to shop<br />0= Not required<br />1= Must be Authorized to Browse<br />2= May browse but no prices unless Authorized<br />3= Customer May Browse and May see Prices but Must be Authorized to Buy<br /><br />It is recommended that Option 2 or 3 be used for the purposes of Spiders', '5', '65', 'zen_cfg_select_option(array(\'0\', \'1\', \'2\', \'3\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function) VALUES ('Customer Authorization: filename', 'CUSTOMERS_AUTHORIZATION_FILENAME', 'customers_authorization', 'Customer Authorization filename<br />Note: Do not include the extension<br />Default=customers_authorization', '5', '66', '', now(), NULL);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function) VALUES ('Customer Authorization: Hide Header', 'CUSTOMERS_AUTHORIZATION_HEADER_OFF', 'false', 'Customer Authorization: Hide Header <br />(true=hide false=show)', '5', '67', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now(), NULL);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function) VALUES ('Customer Authorization: Hide Column Left', 'CUSTOMERS_AUTHORIZATION_COLUMN_LEFT_OFF', 'false', 'Customer Authorization: Hide Column Left <br />(true=hide false=show)', '5', '68', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now(), NULL);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function) VALUES ('Customer Authorization: Hide Column Right', 'CUSTOMERS_AUTHORIZATION_COLUMN_RIGHT_OFF', 'false', 'Customer Authorization: Hide Column Right <br />(true=hide false=show)', '5', '69', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now(), NULL);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function) VALUES ('Customer Authorization: Hide Footer', 'CUSTOMERS_AUTHORIZATION_FOOTER_OFF', 'false', 'Customer Authorization: Hide Footer <br />(true=hide false=show)', '5', '70', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now(), NULL);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function) VALUES ('Customer Authorization: Hide Prices', 'CUSTOMERS_AUTHORIZATION_PRICES_OFF', 'false', 'Customer Authorization: Hide Prices <br />(true=hide false=show)', '5', '71', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now(), NULL);

and its working again.. weird

Thanks

[Ajeh]

Go to phpMyAdmin and run a search on the configuration table where the configuration_key = CUSTOMERS_APPROVAL_AUTHORIZATION

Make sure you only have 1 key ...

Also, check the 2 configuration files:
/includes/configure.php
/admin/includes/configure.php

Check that both are using the same database server, database, username and password ...

[Ajeh]

weird ... might want to compare your configuration table to a clean mysql from Zen Cart ...