Hi Paulm,

thanks for your comments. I'm going to perfect my mod and I'll send you the final release so that you can validate it.

An idea could be to combine the "More Info" and "Add to Cart" and put both in the same table cell maybe? Nobody wants to print either of those anyway I suppose, so those two would only be enabled in a profile not meant for printing.

The spirit behind my mod is to make a POS system for the poors, to give a easy way to have all the products on hand while taking order from phone or from a customer in front of you. We don't really need "more info" while clicking on the product name gives the same result, but showing one or the other gives the info on if a product has attributes or not.

about

target="_Cartpage "

This is made beacause I wanted everytime ones clic on "Add to cart" to get the result in the same window. If I write "_blank" this makes a new window or a new tab each time wich is memory consuming and not really user friendly.

Thanks

Regards

Hubert

Hey everyone,
so I'm new in webtechnologies and i'm using the zen1.3.7 german version, the one i'm trying now is to install the pricelist (the version 1.3.6) but when i try to install the Sql pach i becom always the followin erorr

1136 Column count doesn't match value count at row 1
in:
[INSERT INTO configuration_group VALUES (NULL, 'Printable Price-list', 'The main options for the printable price-list module are stored here.', @sortorder+1, 1);]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
I try to install it as it's described in the readme file and with the upload option in the same section.
what the h... does this mean, could one of you explain it to me pleas!!!!
and i dont becom the link to pricelist in admin>confi. wether in the dropdown even in the optional view???

Thank you all guys

Another unexpected update :smartalec:

@MMSAachen: can you try the sql included in the version attached to this post? And PLEASE PLEASE PLEASE tell me if it helps or not (getting a bit tired of creating and posting possible solutions without getting feedback).

@Hubert: I (quickly, but hopefully correctly) added your buy now button code to the new version.

Attached v1.4: some minor fixes, added logic and (basic) CSS for products images random layout (floats left/right, nicer looks on printed catalogs), and added the buy now button code Hubert posted about (in this thread).

Hey evrybody,
@paulm:
thanks for your interest in my problem, so i tryed the v1.4 that you attached in your posting, but now i become the following error (method copy&past):

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1', '2', '3' ),' )' at line 1
in:
[INSERT INTO configuration ( configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, use_function, set_function ) VALUES ( 'Default Profile', 'PL_DEFAULT_PROFILE', '1', 'Choose the default profile to use.', @pricelistid , 10, NULL , 'zen_cfg_select_option(array('1', '2', '3' ),' );]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields..
If i do it with PHPMyAdmin i becom the folowing error:

Profiles

Profile 1

INSERT INTO configuration_group
VALUES (
NULL , 'Price-list Profile-1', 'Settings for printable price-list profile-1.', @sortorder +2, 1
);

MySQL meldet: Dokumentation
#1136 - Column count doesn't match value count at row 1.

am i wrong with all them what i do???? :lamo: :frusty:

It looks like your MySQL version (can you tell me what MySQL version you are using?) does not allow this syntax:

INSERT INTO `configuration_group`
VALUES (
NULL , 'Price-list Profile-1', 'Settings for printable price-list profile-1.', @sortorder +2, 1
);
```but needs the names of all the columns. I fixed this for the other error you posted about, but I did not realize there where more lines having the same problem. Sorry about that :blush:
**
Attached 1.4.1 to this post** (only change compared to 1.4 is the pricelist-3.sql fix ), hopefully this time it's really fixed.

(will remove v1.4)

Hi everyone,
first of all thanks so mauch paul it works lovely, thank you for wosting your time to fix the SQL. So with C&P didn't work, but with PHPmyadmin. So now i have a pricelist thats nice, the one thing is i can't found the entery Pricelist no where in the admin section???? wether in the alternativ view, question: Should i do something in the admin folder some changes the in the file that i downloaded, are only include file changes!!!
thanks allot

Hi egain,
yes peapel it's me again so i have one more quetion, i'm trying to customise the pricelist, so my quetion is, can i change the quantity entery in jpg like its in the shop (red yellow green [Ampelsystem] so i don't know how it call#s in english) so witsh file should i change??? I think its the (TABLE_HEADING_SOH) but where can i found it??

Hi evryone,
so im stell have the same question, i'll be happy if some one can help, so thank you.

EDIT:

It works great, is there any way to add a small thumb image next to it, so that is like a printable catalogue?

I installed the version in the Downloads section, but I see that there is a version 1.4.1 of this mod in this thread. Is the 1.4.1 the latest version?

AFAIK I have successfully installed the mod, but I am not entirely clear how the user (Including the webmaster) prints just the required output because there doesn't seem to be a 'printer-friendly' or a 'print' button. Please, could someone explain how to print?

I have the current version from the download section installed and I would like to know how to only select a few categories. I have seen the switch in the profiles to turn the default all products off however, i do not know how to add specific categories to print. The reason for this is I have linked categories and dont need them all in the printable list.

Just tried the printable pricelist. I have a few of questions:

1. One problem is that it doesn't print the whole page. It cuts off the items and stops printing with about 1/4 of the page left blank at the bottom.

2. Is there anyway to have it not print the web page title and page count at the very top and the webpage address and date at the very bottom?

3. It only prints as much text as is dictated by the picture size. Is there any way to set it to print all text regardless of picture size?

Thanks!

How do you turn off the show stock amount?

:frusty:

gsdcypher:

Just tried the printable pricelist. I have a few of questions:

1. One problem is that it doesn't print the whole page. It cuts off the items and stops printing with about 1/4 of the page left blank at the bottom.

2. Is there anyway to have it not print the web page title and page count at the very top and the webpage address and date at the very bottom?

3. It only prints as much text as is dictated by the picture size. Is there any way to set it to print all text regardless of picture size?

Thanks!

I also need help with 1 and 2 you listed, but sorted 3 out myself, cannot remember exactly what I did, but it works great. The only thing I got problems with if I use bigger text size, but I'm going back to normal text size.

I've tried everything with the page cut-off, cannot get it right:censored::frusty:

Please help us out

Thanx

ghs215:

How do you turn off the show stock amount?

:frusty:

Admin>Config>Printable price list profile "number you are using", go down list till you find it.

blag:

I installed the version in the Downloads section, but I see that there is a version 1.4.1 of this mod in this thread. Is the 1.4.1 the latest version?

AFAIK I have successfully installed the mod, but I am not entirely clear how the user (Including the webmaster) prints just the required output because there doesn't seem to be a 'printer-friendly' or a 'print' button. Please, could someone explain how to print?

You can print it from your browser, but be sure to print preview it first, it sometimes ciutts-off some stuff.

Think hard Fluffy Bunny, how did you fix #3???

3. It only prints as much text as is dictated by the picture size. Is there any way to set it to print all text regardless of picture size?

I also need help with 1 and 2 you listed, but sorted 3 out myself, cannot remember exactly what I did, but it works great. The only thing I got problems with if I use bigger text size, but I'm going back to normal text size.

Does anyone else have these problems?

1. One problem is that it doesn't print the whole page. It cuts off the items and stops printing with about 1/4 of the page left blank at the bottom.

2. Is there anyway to have it not print the web page title and page count at the very top and the webpage address and date at the very bottom?

I read somewhere how to fix no 3, not sure now.

No 2 is my main concirn, but first have to sort out other problems, than I'll get back to it.

OK Fluffy Bunny #2...

Alt+E will turn off headers and footers. :-)
Or If you use IE7, just do a print preview and turn off the headers and footers. That will stop the web page title and web page address from printing. :-)

I read somewhere how to fix no 3, not sure now.

No 2 is my main concirn, but first have to sort out other problems, than I'll get back to it.

Still need 1 and 3. :-)

1. One problem is that it doesn't print the whole page. It cuts off the items and stops printing with about 1/4 of the page left blank at the bottom.

2. It only prints as much text as is dictated by the picture size. Is there any way to set it to print all text regardless of picture size?

More info on the printable pricelist problems just in case someone out there knows how to fix it...

Problem 1: When trying to print the "printable" price list using IE7, it cuts off the bottom of the last boxes in the columns...

Problem 2: When trying to print the "printable" price list using FF, it inserts a blank page after each page...

Does anyone know how to get it to either, print the bottom of the last boxes in the coulmns using IE7, or get it to not insert a blank page after every page in FF?

Thanks!