Printable Price list :: support thread

[hubert]

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

[MMSAachen]

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

[paulm]

Another unexpected update

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

[MMSAachen]

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????

[paulm]

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

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)

[MMSAachen]

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

[MMSAachen]

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??

[MMSAachen]

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

[Fluffy Bunny]

EDIT:

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

[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?