Printable Price list :: support thread

[trondos]

Really useful functionality. Great work.

Is there an easy way to make a list where each product only once? I.e. if a product is listed in several categories, under the same modelnr., then it only displays in the "parent" category?

Such a list would be very useful while taking inventory, as most shops will have to do in just a month (at least in Norway) ...

I suspect it would be possible to do it by adjusting how the sql-query retrieves the product-list for each category, but I prefer to ask before I start messing too much with those ...

Any ideas?

//TrondOS

[dealbyethan.com]

1. I think the answer is in this thread. (use the "Search this Thread" button and search for "tax")
2. Screen or print?
3. ....
4. Try this: open the CSS file for edit, find the class of the description, and add img {display: none;}

2. Logo doesn't display when enabled in the admin. On the screen the logo doesn't show up. From memory it displays the meta tags or shop name instead. I haven't tried printing it yet.
3. How do I move the product image up so it is on the same row as the pricing to the right? Do you mean you don't know or you don't understand? The product image is under the pricing at the moment, I would like to put it on the same row as the pricing.

[dealbyethan.com]

4. Try this: open the CSS file for edit, find the class of the description, and add img {display: none;}

Just tried this but it didn't work. The stylesheet I tried was profile-a4-portrait.css since I couldn't find any description class in stylesheet.css. My question was I would like to enable the description. However I have also full size product images inside the description. How do I display the description without showing them?

I experimented the code at a few places but none of them work (see below).

/* bof added for image and description */

.imgDescrPL div{
border: 1px dotted black;
border-width: 0 0 2px 0;
/* cm or inch height for printing */
width: 100%;
}
[I PUT "IMG {DISPLAY: NONE}" HERE BUT THE MAIN PRODUCT IMAGE DISAPPEARED. I ONLY WANT THE IMAGES IN DESCRIPTION NOT TO SHOW.]
.imgDescrPL div img {
float: right;
}
[I PUT "IMG {DISPLAY: NONE}" HERE BUT THE MAIN PRODUCT IMAGE DISAPPEARED. I ONLY WANT THE IMAGES IN DESCRIPTION NOT TO SHOW.]
/* eof added for image and description */

/* screen or other media styles above this line or in the common stylesheet.css file */
@media print {
/* bof added for image and description */

.imgDescrPL div{
/* cm or inch height for printing */
height: 2.2cm;
overflow: hidden;
}
[I PUT "IMG {DISPLAY: NONE}" HERE AND THE MAIN PRODUCT IMAGE DID NOT DISAPPEAR. BUT THE IMAGES IN DESCRIPTION STILL SHOWS.]
/* eof added for image and description */

[paulm]

@trondos: good point about the "parent" category. Fortunately we only have to check the stock only once a year (as far as I know), not once a month

I changed this (in the modules/pricelist/header_php.php file)

    $query = 'SELECT *';
    $query .= ' FROM ' . TABLE_PRODUCTS . ' p LEFT JOIN ' . TABLE_PRODUCTS_DESCRIPTION . ' pd USING(products_id) LEFT JOIN ' . TABLE_PRODUCTS_TO_CATEGORIES . ' pc USING(products_id) LEFT JOIN ' . TABLE_CATEGORIES . ' c USING(categories_id) WHERE pd.language_id="' . PL_LANG_ID . '" AND c.categories_id="' . $id . '"' . PL_SHOW_PROD_INACTIVE . PL_SHOW_CAT_INACTIVE;

To this:

    $query = 'SELECT *';
    //$query .= ' FROM ' . TABLE_PRODUCTS . ' p LEFT JOIN ' . TABLE_PRODUCTS_DESCRIPTION . ' pd USING(products_id) LEFT JOIN ' . TABLE_PRODUCTS_TO_CATEGORIES . ' pc USING(products_id) LEFT JOIN ' . TABLE_CATEGORIES . ' c USING(categories_id) WHERE pd.language_id="' . PL_LANG_ID . '" AND c.categories_id="' . $id . '"' . PL_SHOW_PROD_INACTIVE . PL_SHOW_CAT_INACTIVE;
    $query .= ' FROM ' . TABLE_PRODUCTS . ' p LEFT JOIN ' . TABLE_PRODUCTS_DESCRIPTION . ' pd USING(products_id) LEFT JOIN ' . TABLE_PRODUCTS_TO_CATEGORIES . ' pc USING(products_id) LEFT JOIN ' . TABLE_CATEGORIES . ' c USING(categories_id) WHERE pd.language_id="' . PL_LANG_ID . '" AND p.master_categories_id="' . $id . '"' . PL_SHOW_PROD_INACTIVE . PL_SHOW_CAT_INACTIVE;

And it seems to work as expected. The products only show up in the master category.

I would like to add a switch to the configuration for this, but it might take a while before I get to it

[paulm]

2. Logo doesn't display when enabled in the admin. On the screen the logo doesn't show up.

It does show on a default install, so I assume the logo file has been removed or something. I can not reproduce this issue. The file is called logo.gif and it normally can be found in one of the subdirectories of includes/templates/

3. How do I move the product image up so it is on the same row as the pricing to the right? Do you mean you don't know or you don't understand?

Sorry, but it meant that I did not have a quick answer (and not much time to look into it). Note that the images and descriptions were added as a quick hack only.

[paulm]

About hiding the images within your descriptions: I took a quick look, but the pricelist images do not have a separate wrapper or class, so (indeed) css edits only won't work if your own images can't be identified either.

If you change this (in modules/pricelist/header_php.php)

      if(PL_SHOW_IMAGE == 'true'){
        $prodRow .= zen_image(DIR_WS_IMAGES . $cats[$cat_index][$prod_index]['products_image'], '', PL_IMAGE_PRODUCT_WIDTH, PL_IMAGE_PRODUCT_HEIGHT);
      }

to:

      if(PL_SHOW_IMAGE == 'true'){
        $prodRow .= zen_image(DIR_WS_IMAGES . $cats[$cat_index][$prod_index]['products_image'], '', PL_IMAGE_PRODUCT_WIDTH, PL_IMAGE_PRODUCT_HEIGHT, 'class="imgPL"');
      }

The "pricelist images" will have their own class, and then you should be able to hide your own (and still display the pricelist images) using css.

(Other changes to this same part of the code will probably be needed to change the layout to your needs.)

[trondos]

@paulm: Works like a charm! Thank you very much. :-)

[paulm]

Glad to hear it works, and thanks for telling :-)

I attached a new version to this post (will upload the the downloads section later, the attachement will be removed then).

Changelog quoted from the readme:

######################################
# price-list v1.43 2007/12/12 #
######################################
1) Several code changes in header_php.php file (optimized a bit)
2) Moved some pricelist template files from YOUR_TEMPLATE/ to template_default/ (should make fresh installs even easer than before)
3) Added imgPL class to products images
4) Added code to optionally use the master_categories_id (i.s.o. the linked cats). New admin setting: "Use master cats only" (PL_USE_MASTER_CATS_ONLY)
5) Added option to switch on/off price display New admin setting: "Price" (PL_SHOW_PRICE)
6) Improvement of the specials display if no valid date is found (also added a TEXT_PL_SPECIAL definition to the language file for specials without valid expiry date)
7) Modified sql install file to work around sql patch tool oddities (this change should prevent false duplicate key errors)
8) Added some basic debug stuff into the main_page file (only shown when debug is enabled, and even then it will not be printed on paper)

######################################
# price-list v1.42 2007/10/04 #
######################################

Added missing file:
/includes/init_includes/init_zen_group.php
(adding this file should fix the group feature)

Minor change to /includes/extra_functions/group_functions.php which may fix the group function issue with older (1.2.x) Zen Cart versions.

Another minor change to header_php.php to fix a TABLE_HEADING_ADDTOCART bug

Some settings have been added to the admin configuration. The included sql will overwrite your settings, so it might be handy to make a note of your current settings before installing the sql (or add the new settings to you configuration table manually).

[dealbyethan.com]

It does show on a default install, so I assume the logo file has been removed or something. I can not reproduce this issue. The file is called logo.gif and it normally can be found in one of the subdirectories of includes/templates/

I managed to get logo.gif to appear. The problem was my logo name has been changed to a different one.

About hiding the images within your descriptions: I took a quick look, but the pricelist images do not have a separate wrapper or class, so (indeed) css edits only won't work if your own images can't be identified either.
If you change this (in modules/pricelist/header_php.php)

The "pricelist images" will have their own class, and then you should be able to hide your own (and still display the pricelist images) using css.

(Other changes to this same part of the code will probably be needed to change the layout to your needs.)

I upgraded to the latest version. The header_php.php code has already been changed to what you asked me to change. So then I repeated putting img {display: none;} code at the aforementioned places. The same problem occurred. I can't get hide the images within the description and still display the pricelist images.

Also, how do I show partial description only as some of them are rather long? Is it possible to truncate them after certain length?

Thank you for your help :)

[paulm]

Yeah, I imagined some of the changes would be probably be usefull for me too some day, and then I got carried away and I decided to update after all

I upgraded to the latest version. The header_php.php code has already been changed to what you asked me to change. So then I repeated putting img {display: none;} code at the aforementioned places. The same problem occurred. I can't get hide the images within the description and still display the pricelist images.

I do not see the new .imgPL class when I look at your site (so I assume the latest is installed elsewhere) but it should work like this:

/* hide all images in .imgDescrPL */
.imgDescrPL img {
display: none;
}
/* make .imgPL images visible again */
.imgDescrPL img.imgPL {
display: inline;
}

Also, how do I show partial description only as some of them are rather long? Is it possible to truncate them after certain length?

By default the descriptions are truncated @media print only. Or actually the descriptions are not really truncated, but partially hidden (using css). The advantage is that the HTML (and thus the basic layout) of the descriptions is preserved this way. A disadvantage is that the descriptions are cut off without a "more info available" text (or somehing like that) that indicates they are cut off.

A problem with real truncating (which is not supported by the pricelist) is that you need to strip most HTML to keep the code valid, and to make sure it's really truncated to the required size you even need to strip all HTML and change the font to non proportional. And then the descriptions will become one long, usually almost unreadable, line.

Anyway I am note sure what you want and if I can help, but hopefully the above clarifies how it currently works and why.