Printable Price list :: support thread

sorry should add the header and footer are turned "on" in the pricelist profile pages and the footer prints, just not the header.

Printing on A4 but think it is a margain/page size issue. I have played with the sizes under admin with no luck

Hi all !

I have installed the latest version . All is ok but truncate descriptions function doesn't work.

I set different values but nothing changes.

Even if "Trucate description =0" the descriprion is truncated always in the same place

What's wrong ?

Thank you in advance
Mauro

Has anyone ever figured out how to setup the pricelist to print correctly on letter size paper (8.5in x 11in)??? I've played around with the settings but nothing seems to work...

thanks.

Check the settings for your printer when it goes to print. There is often a check box for "fit to page" or something similar. It might be under advanced settings or something like that.

My printouts fit very nicely onto letter size paper, are clearly readable, and I've never modified anything.

Thanks for the reply. When I select print preview in IE7. And choose shrink to fit, the top of the second page appears on the bottom of the first page.

This happens on every page I view and it progressively moves up so the top of the page moves up the page until it starts over again about page 11.

Thanks.

Hi all,

I'm really sorry to have to post this because I'm sure there is someone else who has asked it before...

I have no background with SQL things and so far I've learnt alot about various aspects of the whole ZenCart package and my website works really well (after many months of "learning" I should add.)

Anyway... I'd really like to add this mod successfully first time... rather than fiddle with it in the wrong way and guess things...!! I've loaded the first sql item (pricelist-3.sql) and its showing up under the admin: config: (1,2,3) area.... but the part that loses me is:

(from the readme)

Use the zen sql tool (admin=> Tools :: Install SQL Patches) to load the sql (copy and paste into the text area, do NOT use the file upload feature!).
In rare cases the tool does not work, use phpMyAdmin in those cases (think about adding the table prefix if needed).

What do I put into this tool to load the sql?!! Is there a standard text somewhere for loading the sql?

I've done sql patches before - I understand the idea of it but I've got no clue what to type in to actually execute this requirement.... I've always used the patches included with the documentation...

I'm sorry to have to ask, I feel quite stupid, but I've gone through a lot of the 29 pages worth of support and didn't see someone else ask - and I only have SO long to sift through the threads....

Thanks guys...

Kristan

Its real simple....open the sql file in notepad, then select all and copy. Goto to the spl patch tool in the admin and paste the code you just copied and hit send. Thats all there is to it.

Thank you very much...

You know I half-wondered if thats all it was, but as I said in my original post, I didn't want to do anything wrong in the first place to stuff it up!!

Thanks again
Kristan.

Has no one else experienced this?

Select print preview in IE7 and choose shrink to fit, the top of the second page appears on the bottom of the first page. This happens on every page and it progressively moves up ( top of the page moves up the page until it starts over again about page 11)????

What settings are peope using for US letter size?

Thanks.

@gsdcypher:

Yep, i had this problem as well.....
I am using the Pricelist Profile-1.
Don't know if it is something to do with IE7 or not.....but my fix was to change the 'Printable Page Height' to 26.5cm.
I have a feeling it is something to do with 'Shrink To Fit' changing the size of the tables - but this worked for me. Give it a go and see.......:smile:

Hey guys, great MOD and the options for expansion on it are remarkable.

My question for the guru's above is this: is it possible to add an extra field that has the ZenCart ID for the item (Not the Model No, you enter that manually...i mean the number ZenCart allocates) ???

Also, i couldn't see anywhere a fix for the 'Log in to see prices Issue'....Has anyone found a fix for this?:blink:

Thnx

I forgot to mentiion that while I do have my printer settings set to "shrink to fit" and everything fits nicely onto letter sized pages for me, I do get 1 blank page after every printed page. Strangely....the page numbers are still correct on the printed pages though.

Has a fix been discovered to print on letter sized paper?

It sounds as though you may have the checkbox for start each category on new page, and maybe some additional space has been added to the bottom of each category causing it to fall onto a new page.

check the code to see if any additional <br>'s or <p>'s are there that aren't neccessary.....

also check that in your printer settings you dont have a tickbox called 'seperator page' ticked. That will also cause this problem.

LindysGoodies:

**@gsdcypher:**Don't know if it is something to do with IE7 or not.....but my fix was to change the 'Printable Page Height' to 26.5cmFor US letter size you should actually decrease this value (from the default 25.5cm). I think approximately 9inch (or 23.5cm) should be the value (? 11inch minus 2x1 inch margin).

The 'Printable Page Height' setting forces the page break. And if its value is slightly higher than the height available for printing this page break will make your printer output a second (ususally blank) page following every page.

I am not sure about how "Shrink to fit" influences this. It may sometimes compensate for a wrong setting of course.

@paulm -

LindysGoodies:

Hey guys, great MOD and the options for expansion on it are remarkable.

My question for the guru's above is this: is it possible to add an extra field that has the ZenCart ID for the item (Not the Model No, you enter that manually...i mean the number ZenCart allocates) ???

Also, i couldn't see anywhere a fix for the 'Log in to see prices Issue'....Has anyone found a fix for this?:blink:

Just wondering if you had any ideas about this because it would help out ALOT! (in my case anyway hehe)

LindysGoodies:

is it possible to add an extra field that has the ZenCart IDThe products_id? That's easy.

I attached a modified version of:
includes\modules\pages\pricelist\header_php.php to this post. I think it's possible to copy over an existing 1.5 version (it's actually a file from a 1.5.1 beta version). THe products id should be listed after the file is copied over the original pricelist header_php.php file.

At the the top of the file you can find these two lines:

define('PL_SHOW_PRODUCTS_ID_1', 'true');
define('TABLE_HEADING_PRODUCTS_ID', 'id');

Of course these definitions should actually be moved to the database settings and language file.

Make sure you have a backup of your version of the file at hand, so you can quickly restore it if needed!

No time to look at the 'Log in to see prices Issue' now though. I guess it would not be very difficult.

I have been using this program quite successfully on my site www.bobkatgifts.net - I use the default of http://www.bobkatgifts.net/index.php?main_page=pricelist - recently I added Magic SEO URL to my site and now my Printable Price list gives the user a Error 500 - Internal Server error. Does anyone have any ideas or a suggestion on how to fix this. I am using version 1.5. Do I need to re-install anything? Thanks for your help.

2004g35:

recently I added Magic SEO URL to my site and now my Printable Price list gives the user a Error 500 - Internal Server error. Does anyone have any ideas or a suggestion on how to fix this.I think that's not related to the price list. Probably better ask about this in the Magic SEO contribution thread.

paulm:

I attached a modified version of:
includes\modules\pages\pricelist\header_php.php to this post. I think it's possible to copy over an existing 1.5 version (it's actually a file from a 1.5.1 beta version). THe products id should be listed after the file is copied over the original pricelist header_php.php file.

At the the top of the file you can find these two lines:

define('PL_SHOW_PRODUCTS_ID_1', 'true');
define('TABLE_HEADING_PRODUCTS_ID', 'id');

Thanks Paul, still a little confused though because when i opened your file i couldn't find those two lines of code anywhere?

LindysGoodies:

Thanks Paul, still a little confused though because when i opened your file i couldn't find those two lines of code anywhere?:oops: I uploaded the wrong file. Attached the right one to this post, I think.....