PDA

View Full Version : Price not showing in printable catalog



bhejr
02-03-2006, 07:35 AM
The price is not showing in the printable catalog. I have price set to show in my admin. I get the column for the price ( the column for price is showing ), but no price is shown for any products.

bhejr
02-14-2006, 05:43 PM
Anybody??????? No one else has this problem? If no one can help me is there an easy way to just remove the printable catalog feature of the cart?

kopoba11
04-18-2006, 05:47 PM
Tested my printable catalog on a stock v2 install.
Same problem- prices do not show
Also, Printable Catalog-Show Currency? Hide - does not hide currency drop down box.

Please let us know if you have the same problem.

If you do, we can report it as a bug.

Thank you

bhejr
04-18-2006, 08:49 PM
I do also have the problem with hide currency not working properly as you have mentioned. I agree, this may be a bug.

kopoba11
04-19-2006, 07:29 PM
Ok Folks,
Did the following tests on product catalog.
I used the following for the test: clean OSCMax 2cr2 code, clean DB.
During my test found the following Printable catalog Issues:
1. Products will not show up in catalog if they are in a root and not part of category
2 If hide option selected for config parameter "Printable Catalog-Show Currency?" - currency still shown.
3. Prices will show-up correctly for specials and non special items (not a bug, looks like it is data related since I had price problem before DB clean up)

I am going to report 1 & 2 as bugs.

kopoba11
04-22-2006, 09:29 AM
Figured put why price was not showing.
It has to do with configuration data for printable catalog in Configuration table.
I ran compare for not working configuration and working one and difference only is in dates.

In any case go to gonfiguration table via PhpAdmin, delete all records related to printable catalog configuration.
Use SQL Script below to insert working configuration:

# -----------------------------------

INSERT INTO `configuration` VALUES (740, 'Printable Catalog-Categories column', 'PRODUCT_LIST_CATALOG_CATEGORIES', 'show', 'Do you want to display the Categories column?', 899, 11, '2005-04-24 14:30:53', '2005-04-24 14:30:53', NULL, 'tep_cfg_select_option(array(\'show\', \'hide\'),');
INSERT INTO `configuration` VALUES (739, 'Printable Catalog-Description column', 'PRODUCT_LIST_CATALOG_DESCRIPTION', 'hide', 'Do you want to display the Products Description column?', 899, 10, '2005-04-24 14:30:53', '2005-04-24 14:30:53', NULL, 'tep_cfg_select_option(array(\'show\', \'hide\'),');
INSERT INTO `configuration` VALUES (738, 'Printable Catalog-Manufacturers column', 'PRODUCT_LIST_CATALOG_MANUFACTURERS', 'hide', 'Do you want to display the Manufacturers column?', 899, 9, '2005-04-24 14:30:53', '2005-04-24 14:30:53', NULL, 'tep_cfg_select_option(array(\'show\', \'hide\'),');
INSERT INTO `configuration` VALUES (737, 'Printable Catalog-Name column', 'PRODUCT_LIST_CATALOG_NAME', 'show', 'Do you want to display the Name column?', 899, 8, '2005-04-24 14:30:53', '2005-04-24 14:30:53', NULL, 'tep_cfg_select_option(array(\'show\', \'hide\'),');
INSERT INTO `configuration` VALUES (736, 'Printable Catalog-Options column', 'PRODUCT_LIST_CATALOG_OPTIONS', 'hide', 'Do you want to display the Options colum?', 899, 7, '2005-04-24 14:30:53', '2005-04-24 14:30:53', NULL, 'tep_cfg_select_option(array(\'show\', \'hide\'),');
INSERT INTO `configuration` VALUES (735, 'Printable Catalog-Image column in full catalog link', 'PRODUCT_LIST_CATALOG_IMAGE_FULL', 'hide', 'Do you want to display the Image column in the Full Catalog Script?(hide image for faster page loads on full catalog)', 899, 6, '2005-04-24 14:30:53', '2005-04-24 14:30:53', NULL, 'tep_cfg_select_option(array(\'show\', \'hide\'),');
INSERT INTO `configuration` VALUES (734, 'Printable Catalog-Image column in standard link', 'PRODUCT_LIST_CATALOG_IMAGE', 'show', 'Do you want to display the Image column?', 899, 5, '2005-04-24 14:30:53', '2005-04-24 14:30:53', NULL, 'tep_cfg_select_option(array(\'show\', \'hide\'),');
INSERT INTO `configuration` VALUES (733, 'Printable Catalog-Length of the Description Text', 'PRODUCT_LIST_DESCRIPTION_LENGTH', '400', 'How many characters in the description to display?', 899, 4, '2005-04-24 14:30:53', '2005-04-24 14:30:53', NULL, NULL);
INSERT INTO `configuration` VALUES (732, 'Printable Catalog-Results Per Page', 'PRODUCT_LIST_CATALOG_PERPAGE', '10', 'How many products do you want to list per page?', 899, 3, '2005-04-24 14:30:53', '2005-04-24 14:30:53', NULL, NULL);
INSERT INTO `configuration` VALUES (731, 'Printable Catalog-Number of Page Breaks Displayed', 'PRODUCT_LIST_PAGEBREAK_NUMBERS_PERPAGE', '10', 'How page breaks numbers to display?', 899, 2, '2005-04-24 14:30:53', '2005-04-24 14:30:53', NULL, NULL);
INSERT INTO `configuration` VALUES (730, 'Printable Catalog-Customer Discount in Catalog', 'PRODUCT_LIST_CUSTOMER_DISCOUNT', 'show', 'Setting to -show- will display the catalog with a customer discount applied if logged in. It will display pricing without discount if not logged in. (only valid if Members Discount Mod is loaded. Default if Mod not present is -hide-)', 899, 0, '2005-04-24 14:44:46', '2005-04-24 14:30:53', NULL, 'tep_cfg_select_option(array(\'show\', \'hide\'),');

# ----------------------------------

Then go to store admin for pritntable catalog and activate show price.

THis change worked for me.
Make sure to back-up.
If you screw-up on production server it is your own problem. TEST TEST TEST

kopoba11
04-22-2006, 09:41 AM
Forgot additional COnfig Param

# -------------------
INSERT INTO `configuration` VALUES (747, 'Printable Catalog-Show the Date?', 'PRODUCT_LIST_CATALOG_DATE_SHOW', 'hide', 'Do you want to display the Product Date Added (only valid if Display Printable Catalog Date column is set to -show-)', 899, 18, '2005-04-24 14:30:53', '2005-04-24 14:30:53', NULL, 'tep_cfg_select_option(array(\'show\', \'hide\'),');
INSERT INTO `configuration` VALUES (748, 'Printable Catalog-Show Currency?', 'PRODUCT_LIST_CATALOG_CURRENCY', 'hide', 'Do you want to display the Currency Pull Down', 899, 19, '2005-04-24 14:30:53', '2005-04-24 14:30:53', NULL, 'tep_cfg_select_option(array(\'show\', \'hide\'),');
INSERT INTO `configuration` VALUES (746, 'Printable Catalog-Date column', 'PRODUCT_LIST_CATALOG_DATE', 'hide', 'Do you want to display the Product Date Added column?', 899, 17, '2005-04-24 14:30:53', '2005-04-24 14:30:53', NULL, 'tep_cfg_select_option(array(\'show\', \'hide\'),');
INSERT INTO `configuration` VALUES (744, 'Printable Catalog-Weight column', 'PRODUCT_LIST_CATALOG_WEIGHT', 'hide', 'Do you want to display the Weight column?', 899, 15, '2005-04-24 14:30:53', '2005-04-24 14:30:53', NULL, 'tep_cfg_select_option(array(\'show\', \'hide\'),');
INSERT INTO `configuration` VALUES (745, 'Printable Catalog-Price column', 'PRODUCT_LIST_CATALOG_PRICE', 'show', 'Do you want to display the Price column?', 899, 16, '2005-04-24 14:30:53', '2005-04-24 14:30:53', NULL, 'tep_cfg_select_option(array(\'show\', \'hide\'),');
INSERT INTO `configuration` VALUES (742, 'Printable Catalog-UPC column', 'PRODUCT_LIST_CATALOG_UPC', 'hide', 'Do you want to display the UPC column? (only valid if Members Discount Mod is loaded Default if not present is -hide-)', 899, 13, '2005-04-24 14:30:53', '2005-04-24 14:30:53', NULL, 'tep_cfg_select_option(array(\'show\', \'hide\'),');
INSERT INTO `configuration` VALUES (743, 'Printable Catalog-Quantity column', 'PRODUCT_LIST_CATALOG_QUANTITY', 'hide', 'Do you want to display the Quantity column?', 899, 14, '2005-04-24 14:30:53', '2005-04-24 14:30:53', NULL, 'tep_cfg_select_option(array(\'show\', \'hide\'),');
INSERT INTO `configuration` VALUES (741, 'Printable Catalog-Model column', 'PRODUCT_LIST_CATALOG_MODEL', 'show', 'Do you want to display the Model column?', 899, 12, '2005-04-24 14:30:53', '2005-04-24 14:30:53', NULL, 'tep_cfg_select_option(array(\'show\', \'hide\'),');


# -------------------

kopoba11
04-22-2006, 10:01 AM
I was able to trace the bug.

I analyze configuration data the difference between working and not working price in printable catalog is status of "Printable Catalog-Customer Discount in Catalog" Parameter to hide. If you want your price to show, keep this to "SHOW"