Printable Price list :: support thread

Since quite some people ask questions about the price list contribution, I decided to setup a new "official" support thread for it.

I would really like to update the price list to clean up the code and such, and also to add some features and options. It is unlikely that I will have time for all that soon though :( . But hopefully this thread will at least bring people asking for support, and all information about the price list, together.

Price list Links:
Download of the current version: http://www.zen-cart.com/index.php?ma...roducts_id=276
Archived support thread: http://www.zen-cart.com/forum/showthread.php?t=4014 (lots of info there!)

hth,
Paul

(note: of course others are welcome to update and support this contribution as well!)

Thanks for this contribution Paul.

One suggestion, by adding a column for qty to order, then a few lines for customer info and payment type, cc info, this could double as a fax order form and marketing tool to drive more orders.

We still get many phone orders and this would be very helpful.

Thanks for supporting Zen.

Again, thanks for this wonderful contribution. I'd like to throw my hat in the ring by requesting the addition of images to the pricelist.
This is certainly not the first time you've heard this request, I know. (In fact, I believe that you stated in another thread that it was the most requested update.)
I use the pricelist as our automatically updated inventory to be used by my wife and I, as well as our employees in the store. We have a bead, beading supply, craft and designer jewelry store and literally have thousands of products. The pricelist has made it much simpler for me to balance the online inventory with the actual inventory. The only thing that keeps it from being the best module yet presented is the fact that images are not a part of it. The additions of images would be an incredible time-saver for me. I hope that you'll be able to find the time to make this important change.

Thanks so much.

Tim

Some more info about the price list I have written recently:

Quote:

---

The (Printable) Price List obviously is a price list that's mainly targeted at printing (obviously ;-) ) the information on paper. Another (non printing related) usage is that it adds quick links to all your products, which is handy for several purposes.

It currently prints (sorted by category):

* price inc tax
* price ex tax
* special price
* category names
* model nr.
* manufacturer
* weight
* stock
* two extra notes columns (empty, for adding written notes after printing)

Most of which columns are optional. It has a basic sorting feature and opttions to show all categories or only one category at the time (the latter is better for speed and memory usage, with large stores).

And more.... An example stylesheet is included for printing on A4 (should be easy to adapt to other formats).

Most wanted (so the the features mentioned below are not implemented yet!) features are:

* custom columns for additional data
* products descriptions
* products images
* hide prices for non approved customers
* show prices to the store owner only

And more?

(As said, I do not expect to have time for all this soon. But, if time permits, I do have some ideas on how to add some of the above features)

---

@tim and rnet:

In general new columns are added by editting zen-cart\includes\modules\pages\pricelist\header_php.php . One of the columns added a while after the first release was the stock. The modifications that where needed for that are marked by "// stock by bmoroney", this can be used as an example on how to add more columns.

Of course the sql file would need to be editted as well (to switch the new column on/off and set the sort order through admin).

@tim: I think it would be nice to be able to dynamicly add the columns you want. That way adding even more, or other of those "empty columns", later on would be very easy. By dynamicly I mean adding a configuration file for example, which contains an array of column settings for column names, and sort order settings.

Version 1.2:

1. Several minor code changes (trying to clean up a bit of the the old mess ;-) ).

2. Removed the need to overwrite or edit the currencies class. (So no core code changes are needed anymore for this mod!)

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

4. Some small changes to the stylesheet (screen header, the printing css is unchanged)

For now I will attach the zip to this thread. If more important changes are made, or features are added (hopefully soon), it will be uploaded to the Zen downloads section.

Quote:

---

Originally Posted by paulm

2. Removed the need to overwrite or edit the currencies class. (So no core code changes are needed anymore for this mod!)

---

Oops, I just noticed I left in the currencies.php file. Better remove it form the zip before installing, or else do not overwrite your currencies.php file while installing.

It won't break anything, but the idea was to not overwrite or edit any core file with this version :-)

Great mod, thank you for making my life easier for postal customers!!

One question - is there any way of removing the header logo from each page of the price list. It will save me about 5 pages on the pricelist if this is removed, and I don't really need it as all company info is on each page anyway...

Thanks

Sara

Hi Sara,

maybe I should add switches so that it will be possible to switch headers and footer on and off per listing profile?

But for now you can edit YOUR_TEMPLATE/pricelist/tpl_main_page.php and remove the lines between (latest version only):

Code:

---

<!-- bof Price List page header -->

---

and:

Code:

---

<!-- eof Price List page header -->

---

*Or* you can add this to the stylesheet (all recent versions):

Code:

---

.headPL{
display: none;
}

---

When adding the above CSS to YOUR_TEMPLATE/pricelist/stylesheet.css it wil be hidden from all lists, screen and print. It's also possible to add it to a specific stylesheet (like profile-a4-portrait.css for example), then it will only be hidden from that one (and if you put it between the *media print CSS the headers will only be hidden when printing)

Thanks - the switch sounds like a good idea;-)

Quote:

---

But for now you can edit YOUR_TEMPLATE/pricelist/tpl_main_page.php and remove the lines between (latest version only):

Code:

---

<!-- bof Price List page header -->

---

and:

Code:

---

<!-- eof Price List page header -->

---

---

All I have in tpl_main_page.php is this:

Code:

---

$header_template = 'tpl_header.php';
  $footer_template = 'tpl_footer.php';
  $left_column_file = 'column_left.php';
  $right_column_file = 'column_right.php';
  $body_id = str_replace('_', '', $_GET['main_page']);
 
 // this file can be copied to /templates/your_template_dir/pagename
 // example: to override the privacy page
 // make a directory /templates/my_template/privacy
 // copy /templates/templates_defaults/common/tpl_main_page.php to /templates/my_template/privacy/tpl_main_page.php
 // to override the global settings and turn off columns un-comment the lines below for the correct column to turn off

 // $flag_disable_left = true;
 // $flag_disable_right = true;
?>
<body id="<?php echo $body_id; ?>">



<?php require($body_code); ?>

</body>

---

so nothing to remove!

I tried change the css file, which worked fine but didn't reduce the number of pages, rather just left a space at the bottom of each as big as the header used to be!

Is there another tpl_main_page I missed!!

Sara

Quote:

---

Originally Posted by sajiepaj

I tried change the css file, which worked fine but didn't reduce the number of pages, rather just left a space at the bottom of each as big as the header used to be!

---

You need to alter the admin settings to take advantage of this empty space.

Quote:

---

Is there another tpl_main_page I missed!!

---

It seems like you are not using the latest version (uploaded to this thread), but it does not really matter the CSS should do (almost) the same trick, just take a look at the admin settings.

Works a treat - thank you so much! I hadn't noticed the admin setting for that - oops!

Sara

Somehow something went wrong with the last update, and a part of the modifications were lost :cry: Attached 1.23 to this post (which +/- is what 1.22 should have been).

Tested on 1.3.6, no need to modify or replace any core files for installation.

Paul do you have some kind of messenger as i would like to talk to you directly on that in regards to the new release and my add-ons ive done so far. How can i disable the proce list from generating 2 tables on the 1 page?

Hallo Paulm,
seems to be a rather usefull mod, thanks, unfortunately it doesn`t run on my 1.2.6 Version.
I allready ried a lot, but getn`t it running. Used the latest install 1.1.1, with teh DB is everything o.k., it appears in admin (profile 1-3) and on my categories box obove right the box(?). Doesn`t matter, where, as I rather liked to get it running.
If I call "http://www.escrevo.de/shop/index.php?main_page=pricelist"

I get this error:

Fatal error: Call to undefined function: display_price_nosymbol() in /var/www/web780/html/shop/includes/modules/pages/pricelist/header_php.php on line 573

...................


The txt above I wrote before the gau, but meanwhile everything deteriorated: I have a fatal error on my site and can`t enter any more: "Illegal Access" , and probably nobody else....

Never had this before.

My version is 1.2.6, is this eventually linked with this ...??

I don`t know what to do now.

Do you have any idea, or is this a real hack ?

Thanks for help.

my site is: www.escrevo.de/shop

Walter

@connexhosting:
I can send you my latest version I have if you like, so you can comapare. I never use msn or anything (for free support) though, this already takes way too much of my time as it is now ;-)

@walter:

Quote:

---

Fatal error: Call to undefined function: display_price_nosymbol()

---

The version you have requires some changes to be made to the currencies class file. The error shows that your currencies.php file does not include these changes (a currencies.php isincluded in the zip).

Actually I think you better try the latest version attached to this thread (1.2.3). I have not tested it on 1.2.x versions but I am quite sure it works without any modification.

I would like to upload that newer version to de Zen downloads section, but I am waiting for at least one positive response that that version works without problems. Not that I expect any problems of course :-)

Quote:

---

Illegal Access

---

If this is not happening because of something you did yourself recently, and you can't find the cause, I think you better talk to you host about it. It looks like an .htaccess issue or some hosting panel ip-block.

Note about the

Quote:

---

Illegal Access

---

message. It is (very likely) related to incompatibilty of the currencies.php file of 1.2.x and 1.3.x versions. And the pricelist version you are using includes a 1.3.x currencies.php file.

Price list 1.2.3 does not require edits to this currencies.php file, or to any file, so better try that version instead!

(also see: http://www.zen-cart.com/forum/showth...059#post290059 )

Quote:

---

Originally Posted by paulm

try the latest version attached to this thread (1.2.3)...

I would like to upload that newer version to de Zen downloads section, but I am waiting for at least one positive response that that version works without problems. Not that I expect any problems of course :-)

---

Hi Paul,

Just installed your latest v.1.23 mod on a fresh install of zen cart v.1.36.

I couldn't find the link to the pricelist in any of the shop sideboxes or anywhere else (e.g. sitemap) and did not see anywhere in admin to enable it. Then I re-read the readme and noted point 4 in regards to installation ;-)

The 123 archive includes the v.1.20 readme so I assume no changes to the readme were required between 1.20 and 1.23.

I have yet to read this entire thread yet, and it may have already been mentioned on the wishlist. An admin switch to enable a pricelist link in the Info sidebox (and then also display in the sitemap) would be useful. But easy enough to do manually with ez-pages ;-)

My browser title bar meta now shows "Printable Price List:" on EVERY shop page. Is this a signficant bug or I am confused on how to disable this "feature"? ;-)

At the bottom of each pricelist category where the store URL is shown I observe: http://www.mydomain.comDIR_WS_HTTP_CATALOG

Not sure why the define is not called correctly. Not having this issue anywhere else.

The ability to add some basic comments at the top and the bottom of the pricelist would be very useful. e.g. This pricelist does not show "quantity discounts" or reflect "better together" discounts, does not include shipping, prices subject to change, list which credit cards accepted, live phone or office support hours, blah, blah, blah.

At the very top of page, rather than show "Zen Cart! Printable Price List", I would like to show "MY STORE Printable Price List".

And I see someone already requested easy method to disable the logo.

I see five currencies options displayed but the shop is currently configured to support only one currency? When I change from USD to EURO the amount indeed changes/ How could this be? Are currency exchange rates auto converted somehow in the backgrund?

Will read through the rest of this thread and maybe the archived thread to see if I can find answers.

And will be testing more soon. Thanks.

Woody

Thanks for the excellent feedback Woody :-)

Some of the issues can be solved by editting the includs/languages/english/pricelist.php file.

Quote:

---

My browser title bar meta now shows "Printable Price List:" on EVERY shop page.

---

Yeah, cool huh? :smartass:

But, as a quick fix, you can change:

Quote:

---

define('NAVBAR_TITLE', 'Printbare prijslijst'); // acc. to pixxi

---

to:

Quote:

---

//define('NAVBAR_TITLE', 'Printbare prijslijst');

---

(oops, looks like I am quoting the Dutch file) Then it will not show on the pricelist page either, but I assume thats not a major problem ;-)

Actually I just noticed a version I have called v1.3 on my drive. I have been busy with other stuff and I don't even remeber what the exact differences are, but some of the things you mention are changed/fixed in that version. But for some reason I decided that it was not ready for upload at the time ..... :unsure:

Quote:

---

And I see someone already requested easy method to disable the logo.

---

It's a configuration file setting in 1.3-pre2 (it switches both the logo and text on each page on/off, maybe separate switches should be added for the logo and text).

I remember one of the reasons why I did not upload it: I added *unfinished* code to show products images and desciptions. And maybe there were more reasons.....

I will attach it to this post since I am very unsure about when I will have time to work on it again. So use at your own risk! (as always, but it's a bit more "risky" this time than usual).

About the documentation: sorry, but don't expect to much on that part. It consumes lots of time for me to write docs, and it certainly is not my favorite way to pass the time ;-)

Hi Paul - Concerning 1.3-pre2: You mentioned *unfinished* code to show products images and desciptions. Will this version show images? (Using it at my own risk, of course)

Thanks

Quote:

---

Originally Posted by MeltDown

Hi Paul - Concerning 1.3-pre2: You mentioned *unfinished* code to show products images and desciptions. Will this version show images?

---

Yep it will :-)

in extra_configures/ there is a pricelist.php file that contains some settings for the images/decriptions:

Code:

---

define('PL_IMGDESC_EXTRALINES', 5);

// can not use IMAGE_PRODUCT_LISTING_HEIGHT and IMAGE_PRODUCT_LISTING_WIDTH since these are not yet defined here (?)
define('PL_IMAGE_PRODUCT_HEIGHT', '80');
define('PL_IMAGE_PRODUCT_WIDTH', '100');

---

PL_IMGDESC_EXTRALINES is a correction for the amount of space the images/decriptions take (to correct the "line counter" which determines when the page is full).

(and the "// can not use.... " remark can be ignored, not sure why I added it, the image size settings seem to work fine after all)

Quote:

---

Originally Posted by paulm

It's a configuration file setting in 1.3-pre2 (it switches both the logo and text on each page on/off, maybe separate switches should be added for the logo and text)...

About the documentation: sorry, but don't expect to much on that part. It consumes lots of time for me to write docs, and it certainly is not my favorite way to pass the time ;-)

---

Hey Paul,

Thanks for the note on commenting out the NAVBAR_TITLE define. Wondering why I could not figure that out myself. Doh! ;-)

Regarding the define file, where is "%s" variable called from?
For example in:
define('TEXT_PL_HEADER_TITLE', '%s Printable Price List');

Yes I vote for separate switches on displaying logo and text. But not a big priority. I can easily manually edit out the logo/text myself if needed.

And your documentation is very thorough. I was just inquiring if any special points to be aware of in v.1.23, if any significant differences from the readme v.1.20. But I suspect all the info I need to read is in the readme history and this support thread.

I like the idea of being able to toggle on product images and/or product descriptions, if needed. I will sit still and play with your v.1.23 for awhile and wait for reports to come in on 1.30pre2.

Checking out the archive support thread I can now see you have been working on this mod for awhile! Cool!

Thanks again,

Woody

Quote:

---

Most wanted (so the the features mentioned below are not implemented yet!) features are:

* custom columns for additional data
* hide prices for non approved customers
* show prices to the store owner only

And more?

---

Some more questions/ideas...

Is therea recommended method to control access to the pricelist page to logged in users only?

And have the pricelist link show up in info sidebox (and elsewhere) for logged in customers only?

Or have the pricelist link show up for everyone, including in the shop sitemap. But if pricelist link is clicked while not logged in then make the browser redirect to login/create account page, and after logging in, redirect to the price list page.

Woody

Quote:

---

Originally Posted by Woodymon

Yes I vote for separate switches on displaying logo and text. But not a big priority. I can easily manually edit out the logo/text myself if needed.

Woody

---

Paul, Thanks SO MUCH for adding photos to the Pricelist. It is a fantastic module!

Paul / woodymon - concerning manually editing-out the text: How would I do that?

Thanks!

Tim

Quote:

---

Originally Posted by MeltDown

Paul / woodymon - concerning manually editing-out the text: How would I do that?

Thanks!

Tim

---

To Clarify - If I set the "define('PL_IMGDESC_EXTRALINES'," to 0 I still have quite a bit of text being displayed. is it possible to have just have the settings from the original Pricelist (product link, model, qnty, price) and a photo?

Thanks

Tim

Not much time now and I will get back to some other things later, but PL_IMGDESC_EXTRALINES is just a correction for the line/row counter that determines when a new page has to start. Normally on a page would fit 30 lines/rows for example, but when lines/rows are added to show images and/or descriptions these will take up more space than "normal" lines/rows. So if your images take the space of 5 lines for example the PL_IMGDESC_EXTRALINES has to be set to 5 (and then the price list script should start a new page just before the page is full).

Depending on the amount of other data you want to print (and how much space it takes) it might be smarter (save some space) to "float" the image left or right to the other data. But that is not how it's curently programmed.

And printed images will always take up more space than a singel row of product data, won't they?

This is great module!Can someone guide me how to add wholesale prices to this module?At this time,it just can print retail prices .

Thanks for help,

This a great module. - Many Thanks.

Just a few queries though for the stupid like me!

Can anybody please explain what the various CSS entries actually amend (ie which elements of the print/display they refer to)?

When mine prints off I get truncation of the product description for some products.

How can I make the box 'grow' to fit a large description please?

Also I have had to cut out the 'Model' field to fit in large product names. - Again I need the fields to 'grow' where necessary.

Any help please would be much appreciated?

PS - getting tios out to an RTF file would be a complete bonus!

Thanks

@kimson: I sent you a PM.

@crabacle: I must addmit the css classnames do not make much sense, at some point I decided to abbreviate the classnames as much as possible, which was a bad idea.

But finding out what CSS classes and id's are for is not something which is typical for this pricelist contribution. (In general) you just need to look at the html source what the available classes and id's are, and then look in the stylesheet if and how they are being used and then add/edit to the stylesheet whatever you need.

If I remember well I added some comments to the stylesheet. It's a long time ago I wrote that, so I am not sure how extensive these comments are, but it might help a little.

So its been a while since you posted the 1.3-pre release with WARNING... and no comments, so I am guessing (and crossing fingers) that it works as intended... and about to install... if you don't find me on your dorr screaming then it worked perfectly :-) :lol:

SUCCESS! it worked flawlessly over version 1.08. I didn't even replace the SQL... going to do that next. I do wonder if there is a "profile" in there to show the reduced version as well.. I can see needing that on occasion, although the "Boss" loves the new one.. so I hope I don't mess it up.

BTW, I also just upgraded ZC to 1.3.7 today as well

So only comments I have are...

1. If done with EZ Pages and you ask it to open in NEW PAGE,it adds a query param to the link which causes the pricelist not to operate for some reason. Not sure if this is a problem with EZPages, PriceList or ZenCart, but works fin if a specific page is specified.

Code:

---

<li><a href="http://www.totalgarage.ca/products/index.php?main_page=pricelist?target=&amp;quot;_blank" target="_blank">Price List</a></li>
<li><a href="http://www.totalgarage.ca/products/rss2.php?target=&amp;quot;_blank" target="_blank">RSS2 Feed</a></li>

---

above is an example where it works for RSS2. but not for price list.

And is there a way to configure it (query params even) that allow the older minimalistic version to show?

Clearly this url is invalid:

Code:

---

http://www.totalgarage.ca/products/index.php?main_page=pricelist?target="_blank

---

No idea why it is generated and by what piece of code, and I don't see any reason to try to make the pricelist popup when an invalid url is clicked.

Its a bug in EZPages. Not a worry.


On the minimalistic version... is there a toggle to show that?

Quote:

---

On the minimalistic version... is there a toggle to show that?

---

Sorry, I don't understand. A toggle to show what?

I like the new detailed price list with the images and descriptions... but I also liked the old one that was a more minimalistic view. Is there a way to add a query parameter to select which one is shown?

Quote:

---

Originally Posted by quentinjs

I like the new detailed price list with the images and descriptions... but I also liked the old one that was a more minimalistic view. Is there a way to add a query parameter to select which one is shown?

---

:blush: I think that was one of the reasons it was not ready for an "official" release...... I added the (more or less) unfinished code for images and descriptions, and made preparations to add on/off switches, but it looks like I did not get to adding any switch at all :shocking:

I will probably update soon to add those switches :-)

That easily happens, you start on something get distracted with another aspect of it, then the next thing you know life over takes you and when you go back you remember the las stuff you were doing, but forget what you had been doing before that. I have had that happen way to many times as of late.

Hi
Just wanted to say what an absolutely fantastic piece of work this is. I love the version with the images.

Is there a way that I can get the single column page to show the column wider across the page so that it fills the width of A4? I tried using more columns but it didnt look as tidy as the single column per page.

If not no problem as this is still a great add on to the store, am sure this will prove invaluable at craft days and the card workshop I run.

Many thanks

H

Hi helshop,

it's possible to make adjustments like that by edditing the stylesheet. I have barely even touched that file for years, so I hope you'll find your way by taking a look at it yourself ;-)

Absolutely no idea how CSS works but gave it a go and think it has worked, once again thank you!! Now I just need to add the rest of my stock, trouble is my friend also loves it and wants me to set hers up for her as well so thats another cubecart customer who is migrating to zen!! Think this price list was the convincing factor for her, despite all its other great features.

Paulm you are a genius!!

H
:D

hello, thanks for the great mod.
Any way to alter the pricelist to show sub-categories as well?

I have many products in one of my category about 12000, about 300 products in each sub-category of that main category. Its very laggy and database load is insane. Would it be possible to split it to sub.categories?

All Categories default is set to false. :smartass:

Hello,

I know this will sound strange, but I would like to add "Add to cart" button for each item in the pricelist.

The reason for that is that we are doing both online ordering, and by phone ordering, and for the phone case, the pricelist is a way to answer customers faster than diging into the sub categories as a usual web surfer.


Thanks for helping

regards

Hubert

@Timacek: the pricelist does show the subcats. But I assume you mean you want it to show the subcats in the dropdown, so you can select by subcategory.

Although I agree subcategory selection would be a nice feature, I think a better solution would be to add a limit to the number of products the pricelist will print in one go. I originally wrote it for a (osCommerce) shop which only had about 300 products, which I needed a printable pricelist for. There was no need to make it work for thousands of products or more, and that why it wasn't designed to handle lots of products.

@hubert: I think add to cart buttons would be a nice feature. Although it started as a printable price list a long time ago, it does not have to stay just a printable price list.


If I would have lots of spare time I would probably add those features asap :smile: But I am afraid there is very little chance I wil have any time for this soon :(

I am running an older version (1.02) but love it all the same.

Does the new version show attribute prices?

Jacque

Hi
I am using the image version of the price list and cannot get it to print properly despite it looking great on screen!

Any ideas which part of the css I need to amend to correct this please.

Thanks

H

I have read through this thread, and found no mention, so...

Does this mod note stock by attribute? I am using the attribute stock v 4.4 mod. (I know, wishful thinking. A girl can dream can't she :laugh: )

Thanks!
Audra

@jacque427 and audradh: sorry, attributes are not implemented and I am sure I won't find time soon to add code for it. (even very unlikely that I will ever find time for it, so if anyone else wants to update/support this mod please do so!)

@helshop: sorry but the image printing is not officially supported. Please look at the HTML source for CSS classes and try to edit the CSS files to change the looks. You also might need to edit the modules/pages/pricelist/header_php.php file.

edit:
@audrah: I am dreaming too, about having lots of spare time to code... ;-)

Hello Paul,

First of all thank you for a great mod. I have also a question: is there any way to show prices and quantity breaks set in quantity price breaks module?

Adam

Hi Manada,

quite some custom coding would be needed to show the quantitiy prices breaks correctly, I think. And I am currently working on quick updates and other things (a.o. trying to make some money ;-) ), no idea if and when I will work on the price list again.

Others a are free to use and update the price list code too of course. It's GPL! :smartass:

Has anyone tried this version (that shows the pictures) with IH2 installed??? I got an error after installation:

Warning: imagejpeg() [function.imagejpeg]: Unable to open '/kunden/homepages/11/d93880114/htdocs/bmz_cache/6/66c215b0fe591a928a74280301d2cdd6.image.80x96.jpg' for writing in /homepages/11/d93880114/htdocs/includes/classes/bmz_image_handler.class.php on line 652

Quote:

---

Originally Posted by Crzipilot

Has anyone tried this version (that shows the pictures) with IH2 installed??? I got an error after installation:

---

I use price-list_v1.3-pre2.zip with IH2 on 1.3.7.

/Wils

Ok, problem with IH has gone away, not sure what it was, besides PFM. Anyways, anyone have any luck getting the items to print out correctly with images??? Or at least on a 8x11 sheet?

Just wanted to note that he included stylesheets are made for A4 (210x297mm). Never tried it, but it should not be very difficult to convert to US-letter format.

Not sure what you mean by "getting the items to print out correctly with images". I don't really use the price list anymore these days, but I tested it a couple of times and it worked fine here. It still got the pricelist look though, which is not very nice for a printed catalogue of course...

Not really sure how to explain it. But when the price list comes up on screen it seems to look ok. I changed some of the settings in the stylesheet, from a prev. thread, to fit a 8x11 letter paper. When I goto print, it doesn't look like anything off the screen. It scrunches up the boxes to the top of the page.

Anyways, I'll play with it some more, might be something with the printer.

We desire the print out, as we had something similar from our old website we would us as in store quick reference....old habits die hard...

Thanks for the work though, module works good, I'm sure it's something on our end...

Quote:

---

Originally Posted by Crzipilot

Not really sure how to explain it. But when the price list comes up on screen it seems to look ok. I changed some of the settings in the stylesheet, from a prev. thread, to fit a 8x11 letter paper. When I goto print, it doesn't look like anything off the screen. It scrunches up the boxes to the top of the page.

---

You might be able to manipulate the mod output with CSS to format into a layout you require for your printer.

In Zen Cart distribution see /docs/readme_css_system.html

Specifically the reference to:
print*.css // printer-friendly global usage site-wide changes for printing-only

The mod comes with three CSS profiles, namely:

profile-a4-landscape.css
profile-a4-portrait.css
- and -
profile-3.css
This third one is for your customization.
(or you edit the other two as you wish).

If you use Firefox web browser, install the Web Develpper add-on to play around with the CSS to format the page as you like for your printer. Then save the CSS.

Woody

Hi all, first off this is a great mod and ive got it just how i want it so thank you.

Just the 1 problem when you go to print it, it will print a page then a blank page and then another page with products on and it does this until it is all printed.

Any ideas?
Thanks

Hi Troy,

your question is probably related to the question above about the 8x11 letter format. We use another paper format called A4 and that is the reason it's by default configured to fit A4.

There is at least one setting in the stylesheet (in cm) that you should adjust for US letter format (in inch if you like, by default it is 25.5cm which is the A4 length minus standard top and bottom margins). In addition you might have to dedrease the number of lines/rows printed on a page somewhat (pricelist admin setting).

I gues there must be lots of users that found out usable settings for the U.S. letter format, hopefully someone will post it here.

Hi thanks for the quick reply, the US settings wont matter to me, i am in the uk.

Ill av another look round it, see if i can figer it out.

thanks again

Aha, wrong assumption here then :-)

Maybe your margins are larger than mine? And you can still edit the same settings of course, as you probably understand.


Note:
I have decided to upload price-list_v1.3-pre2.zip to the zen downloads section after all. I think it's better to use price-list_v1.3-pre2 than any of the previous versions.

Yes i would agree, i downloaded the 1 on page 2 is that the right 1? as it says its unfinished maybe thats why im having probs.

Its odd really because it looks perfect until you go to print preview.

But still great mod, im not very good at coding but ill have a look around it.

Quote:

---

Originally Posted by troy77

i downloaded the 1 on page 2 is that the right 1? as it says its unfinished maybe thats why im having probs.

---

That is the right one. I think it's better than any of the older versions and I don't think your blank page problem is related to the version.

That it looks ok on the screen, but inserts pages when printing, isn't strange when you know the cause.

The contrib includes CSS code to start a new printing page when a page is finished (this prevents the next page to start on the previous when the previous page is not full yet). It also includes CSS which sets the height when printing (this allows you to print a footer at the bottom). If the height (+ margins) do not fit the paper the printer will start a new page (which will probably be blank, only if the CSS height exceeds the paper a lot your footer might be printed on it).

So if the total height (height set in the CSS + margins set in your browser) does not fit your paper, both the CSS and printer will start a new page, and a "blank page" is inserted (so this "blank page" is actually just a couple of mm of the bottom of the previous page).

So the idea is that the PHP script decides when a page is full (after printing x number of rows), then it inserts a CSS class (.pagePL) which forces a new page to start. This new page should start just before your printer decides that the page is full. If it starts a new page after the printer does, extra (blank) pages will be the result.

This is the CSS that tells the printer to start a new page (unless it's the first page):

Code:

---

.pagePL
{
page-break-before: always;
}
#pageOnePL, .pageOnePL
{
page-break-before: avoid !important; 
}

---

(note: Do not change this! Only telling this because I can't stop talking! :smartalec: )

I just removed the attachement form this thread because it's available at the Zen Cart downloads section now.

So for the latest version (which (still) is v1.3-pre2) goto: http://www.zen-cart.com/index.php?ma...roducts_id=276

Great stuff, i have to say this is the best mod ive installed to my zen cart so far.

Thanks again

Oh yeah and before i forget the blank page thingy i was on about only does it in mozilla not IE

Quote:

---

Originally Posted by troy77

Oh yeah and before i forget the blank page thingy i was on about only does it in mozilla not IE

---

That is possible. Some sizes differ a bit between those two browsers (if I remeber well line-heights are never exactly the same). And of course page margin settings may be different too. I always use Mozilla FF myself, only check IE to see if things work in IE too.

So once you got it right in Firfox you will probably waist a little space at the bottom when using IE.

This may have already been covered, but is there anyway to change 1 profile so it is just a list without the pictures? I don't need the pics and discription as an inventory list, but it is nice for my customers to have pics.

Hi hdonald,

can you try the attached price-list_v1.3-pre3 version?

It's untested (I only tried the new sql), so it might have typos/parse errors. Only the sql install file, header_php.php and the extra_configures/pricelist.php config have changed since the previous version (the old config file should be removed or overwritten).

If it works you should be able to set it through the admin now. Please let me know how it goes!

Thank is just what I am looking for, but now I can't get the price list to display. Any thoughts on that one?

Never mind, my own fault. It works great! This is perfect for what I need.

I have installed v1.3.7 on Zen Cart v1.3.7. I get the followinf error.

ERROR! Profile does not exist, loading default Profile instead. (PL_DEFAULT_PROFILE)

Zen Cart! Printable Price List

Displaying 0 products, click on the links for detailed product information.


No products or categories match your query, please make another selection.
------------------------------------------------------------------------------------------

Something I missed ?????

Quote:

---

Something I missed ?????

---

Did you paste the sql into the Zen admin sqltool box, and submit?

Yes ..... Sure did. I will remove and install again, this time through MyAdmin .... see if that makes a difference.

Still no go ..... I think I will leave this one in the hard basket ..... to many other things to do.

Don't forget to add your zen db prefix then! (if any)

By default the default profile is 1 and it (PL_DEFAULT_PROFILE) should be defined by this setting in the admin (admin: configuration: pricelist settings):

Quote:

---

Default Profile 1

---

Which pricelist version is it that you installed? On which Zen Cart version?

edit:

Quote:

---

to many other things to do

---

That reminds me! :-)

And again another unexpected update :smile:

To make this mod usefull again for myself I have added a feature that makes it possible to show the lists only to customers that belong a certain "pricelist group".

If a group name is entered, the list will be shown only when the customers groupname starts with the name you entered (using the Zen Cart group pricing feature (at: admin|customers|group pricing)).

A group name setting has been added to the admin for each profile.

Code:

---

changed files:
pricelist-3.sql (includes removal of old settings now too)
includes\templates\YOUR_TEMPLATE\pricelist\tpl_main_page.php
includes\modules\pages\pricelist\header_php.php

new:
includes\extra_functions\group_functions.php

---

And the languages file has changed and moved from languages/english/extra_definitions/ to languages/english/ (I think it ended up in the extra_definitions/ folder by mistake). So don't forget to (re)move your language file too, to prevent possible confusion.

File attached to this post (will be removed again when/if uploaded to the Zen downloads section).

(edit: should work on 1.3.6 and 1.3.7)

Woops, the new file should be added to:
includes\functions\extra_functions\group_functions.php

(not to: includes\functions\group_functions.php)

Other than that it seems to work fine :-)

I have installed v1.3.7 on Zen Cart v1.3.7.

I think it could be the prefix ..... what do I need to do to change this?

Thanks

Quote:

---

Originally Posted by trevor4370

I have installed v1.3.7 on Zen Cart v1.3.7.

---

?

Quote:

---

I think it could be the prefix ..... what do I need to do to change this?

---

The sql tool does not always work, but if after copy and paste into the sql tool textarea you get the succes message (Like: "Success 117 statements processed."), and no errors, I am quite sure the sql has been entered succesfully to the database (including the table prefix) of the shop you're logged in to. But the error you get indeed indicates the sql has not been added succesfully to your shops database, so if you want to try it using phpMyAdmin anyway: if your table prefix is "zen_" for example you should add "zen_" to all table names like "configuration" and "configuration_group" (so they become "zen_configuration" and "zen_configuration_group").

Hi
I've got the pricelist working on 1.3.7

except the first 5/6 pages print okay - then it seems to lose the page break and not keep to the A4 size. It sems to print half a table on one sheet and then start a new catagory halfway down a page. The footer would also print over previous table

I have the profiles set to start new table and new page.

Same thing happens in landscape.

Any ideas how to restore the page layout/margins/page break?
John

I guess no one has an idea why this is happening :unsure:

It looks that the description field has a preset number of lines, so if the products have different description length that means that the whole pricelist will print incorectly. That is my guess.

Well I had pricelist working until I tried installing the admin tool for access rights. That didn't go well so removed admin tool.

Now I just found out my Pricelist tool doesn't work.

Problem:

I see the price list and the profiles in the admin -> config
But when I go to the link

index.php?main_page=pricelist

It just re-displays the whole admin's panel.

I removed the whole pricelist and reinstall it twice.
Still same thing.

Please advise!

Thanks

Quote:

---

Originally Posted by wdrx02

when I go to the link

[SIZE=2]index.php?main_page=pricelist

It just re-displays the whole admin's panel

---

:blink: :shocking:
Really weird. I guess some files or modifications of the "admin tool for access rights" (which i don't know anything about) have ended up in your catalog while they should probably be applied to your admin files. I really don't believe that there is way that the pricelist can show anything of the admin, it does not modify any files and it's totally unrelated to the admin (exept that the pricelist settings are controlled by the admin of course).

I would undo the other mod asap, or go back to your latest working backup....

Quote:

---

Originally Posted by paulm

:blink: :shocking:
Really weird. I guess some files or modifications of the "admin tool for access rights" (which i don't know anything about) have ended up in your catalog while they should probably be applied to your admin files. I really don't believe that there is way that the pricelist can show anything of the admin, it does not modify any files and it's totally unrelated to the admin (exept that the pricelist settings are controlled by the admin of course).

I would undo the other mod asap, or go back to your latest working backup....

---

I tried copying some original files from a new full download of Zencart, same thing. I uninstalled, reinstalled pricelist mod and I rechecked that no "admin tool profile" was there.

Same.... I do have a backup but I already done a lot of changes within the past 1-2 days and haven't got a chance to backup! doh! any other ideas? Help!

I got 78 statements of the following:

PHP Code:

---

ERROR: Cannot insert configuration_key "" because it already exists 


---

Did I miss something?

nvm... trying something else..

Tried renaming the configuration and configuration_group to reflect my prefix name and for some reason I get this:

PHP Code:

---

 #1146 - Table 'belladon_cart.configuration_group' doesn't exist 


---

belladon_cart is my database name... I'm not understanding what the problem is.. :(

OK, I fixed the one problem but I still have the 78 statements of:

PHP Code:

---

ERROR: Cannot insert configuration_key "" because it already exists 


---

When going the URL of http://www.belladonnascauldron.com/i...page=pricelist, I recieve the error of:

"ERROR! Profile does not exist, loading default Profile instead. (PL_DEFAULT_PROFILE)"

Anyone? Any idea?

Quote:

---

Originally Posted by paulm

Don't forget to add your zen db prefix then! (if any)

By default the default profile is 1 and it (PL_DEFAULT_PROFILE) should be defined by this setting in the admin (admin: configuration: pricelist settings):


Which pricelist version is it that you installed? On which Zen Cart version?

edit:
That reminds me! :-)

---

what do I replace with my database name?

Quote:

---

Originally Posted by AvieLF

what do I replace with my database name?

---

You don't replace anything with your database name. If you want to enter the sql using phpMyAdmin you need to add the prefix to the table names (this is the same prefix you may have entered during the Zen Cart installation). So "configuration" becomes "zen_configuration" for example (if "zen_" is the prefix you're using), and "configuration_group" becomes "zen_configuration" then.

has this been updated to accomodate 8.5 x 11 yet?

I really need some help here. First of all I must say thanks. It is great module.

I just don't know what I have done wrong!!

I have the profile 1 enabled and nothing else and I am just using this to print myself to pdf for sending to particular clients via email.

Anyway I am having a problem with the incl tax coloumn. It is not showing the amount with the tax it just shows the same as the ex tax. I am in California and I have the state sales tax of 8.25%. I would like to have the correct amount with the incl tax coloumn showing, so what do I need to do??

I have a strange request from I fellow I am working with on his site. He wants the pricelist, minus the prices. Any easy way to hide the pricing. He wants to use more as a catalog of product images, descriptiions & size. Thanks!

Can this printable price list be open within the site instead of opening a new page??

Quote:

---

has this been updated to accomodate 8.5 x 11 yet?

---

There are rumours (and it's very likely) that some people have done this, but as far as I know it's not publicly available. The mod does not include a stylesheet for 8.5" x 11"

@supersnow: the pricelist only show inc. tax prices if the prices are shown inc tax in your shop. So I assume your shop is not setup to show inc tax prices.

@loosecannon: actually I think an option to disable the prices should be added and you request is not strange :-) Because early version were made to replace an existing static pricelist making the prices display optional didn't cross my mind at the time. If I find the time to upgrade I will probably add this option (but don't hol your breath ;-) )

@sal4888: the pricelist is not desigend to open within the site. Some parts would need to be recoded for that (it uses it's own main layout so the site layout won't interfere when printing it).