I've uploaded

I definetly think it is some old script that is causing the problem... I did use your printable price list on my PRE-Upgrade version of zen-cart.. worked great!

I wonder if I need to delete or change something from the old version?

the page looks like this now ( is this from an older version?)
http://www.kwmagic.com/index.php?main_page=pricelist

GOT IT

Thanks for the contribution Paul.

Sorry if I missed it somewhere in the thread... but did anyone ever figure out how/what to change so it would work properly with an 8 1/2 x 11 sheet of paper (instead of a4)???

Thanks

I have ver 1.3 on Zen Cart 1.3.7 - all works great. Is there a need to get ver 1.4.1 ?
If so, do I need to do any sql patches - or just uplaod the new files.
Thanks for your help.

Hi 2004g35,

there is no real need to install 1.4.1 if you're happy with 1.3 :smile: But if you do want to upgrade you will need to reinstall the sql (which will reset all settings, sorry: no time to write sql update patches).

Maybe it's better to wait for a new 1.4.x or newer version. I am on 1.4.3 now, but I am unsure if I will continue working on it until I have at least a 1.5 or newer version, or that I will release another 1.4.x version.

Here's a partial changelog (quoted from the readme..):

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

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

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

price-list v1.41 2007/07/19

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

Minor fix in pricelist-3.sql patch file (to prevent install error on some MySQL versions/configurations when using the Zen SQL patch tool).

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

price-list v1.4 2007/07/18

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

1. Made a small change to the sql (which might fix a possible column count error message at install when using the Zen SQL patch tool)

2. Fixed a minor bug (in tpl_main_page.php), now the selected profile should always be remembered when switching categories

3. Added random images floats (left/right) logic for nicer catalogue prints

Also added css to profile-3.css (edit it to control the image floats):

.imgDescrRndPL_3 img, .imgDescrRndPL_4 img {
float: left;
}
.imgDescrRndPL_1 img, .imgDescrRndPL_2 img{
float: right;
}

4. Added code for add to cart buttons (commented: //Added by Vartan Kat on july 2007 for Add to cart button), credits for this should go to Hubert and Vartan Kat

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

price-list v1.3.6 2007/06/04

######################################
Several changes, some of which are:

1. Added basic functionality to print descriptions and images (height and width setting in pricelist admin profile settings)
2. Added group functionality. Uses zen the groups (group names) to allow disallow access to the pricelist. Set in pricelist admin profile settings.

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

price-list v1.2 2006/10/20

######################################
Made several code changes (trying to clean up some mess ;-) ).

Removed the need to overwrite or edit the currencies class.

Merged several files into one. For easier layout edits (I hope).
Header, footer and body all moved to tpl_main_page.php

Some small changes to the stylesheet

Sorry, but I don't find any information about use this mod to generate price listing for wholesales (to use with this mod
http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_61&products_id=166)
I use the wholesales mod
http://www.zen-cart.com/index.php?main_page=product_contrib_info&cPath=40_61&products_id=166
and I use price listing mod to generate price listing.
I would use price listing mod to generate price listing only when wholesales customer log in and show him the reserved price.
I hope I'm clear

Hi,

If this works with product images, is it possible to make use of it to generate a printable price list of the entire catalog and convert the html version to pdf?

@100asa: sorry, but whosale prices are not supported currently. That would require some custom coding.

@dealbyethan.com: you can try CutePDF Writer (= a free Windows programm). Everything you print it writes into PDF files.
(I use it myself to convert invoices to PDF ocasionally, and I assume it would work well on the pricelist too)

Hi

I love this module. I installed it successfully but I would like to fix a few things:

1. Tax inclusive and exclusive don't work when enabled in the admin. Both pricings are the same.
2. Logo doesn't display when enabled in the admin.
3. How do I move the product image up so it is on the same row as the pricing to the right?
4. I would like to enable the description. However I have also some product images inside the description. How do I display the description without showing them?

Any suggestion will be appreciated. Thank you so much.

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;}

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

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.

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 */

@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 :shocking:

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 :(

dealbyethan.com:

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/

dealbyethan.com:

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.

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.)

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

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).

paulm:

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.

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)

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 :)

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 :smile:

dealbyethan.com:

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;
}

dealbyethan.com:

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.