printable price list

Ok ..so this is a strange place to be putting this but I cant work out how to add replies to existing threads e.g. about printable pricelist contrib.

So here goes for those intersted and those who tried to install that contrib and failed like I did.

I found through another zenner a lady that can sork miracles with code and presto!!!

It works!!

If you want her name you best email me at [email protected] and I'll pass on your request.

Graeme

You can .zip the contrib and attach it to your post and make it easier for all to access it.

(you could not answer those posts because they are locked and archived)

Thanks Kim

I'd zip etc if I could but that would mean copying each and every part incl sql ...that last bit is beyond me LOL

Her comment was that it was quite a mess and too much to expalin...mind you it took her just one hour to fix ...like WOW

Anyway if anybody wants her email address let me know.

Graeme

Does anyone have style sheets for printing the price list on US 8.5" x 11" paper?

If you rather show a full section on your shop the price list or printable catelog you can download v2.0 price list here

Just make sure you use caution when installing due to core file editing.

You can see it in action here

Is there a way to add an image to the list ?
it would be nice to see an image next to each product.

Alik:

Is there a way to add an image to the list ?
it would be nice to see an image next to each product.
anyone ?

....
..
.

Is there a way to add an image to the list ?
Look at knuckle's post -- it looks like you can add an image in pricelist v2.

knuckle-101:

If you rather show a full section on your shop the price list or printable catelog you can download v2.0 price list
That one has been removed on my request. I downloaded it a while ago and it appeared to be based on an somewhat older version of the pricelist which did not include some fixes for 1.3.x.

Not sure how it got there, but somebody took an older 1.x version, editted the readme (removing the version history and credits to several helpfull coders :wacko: :blink: ) and then uploaded it as version price-list_v2.0 ;-)

dgwyn:

Does anyone have style sheets for printing the price list on US 8.5" x 11" paper?Not sure if it still matters, but the main change would be to edit the stylsheet and change:

.pagePL, #pageOnePL, .pageOnePL
{
height: 25.5cm;
/* overflow: hidden; */
}

To this for example

.pagePL, #pageOnePL, .pageOnePL
{
height: 8inch;
/* overflow: hidden; */
}
```Or in cm if inch does not work, I think inch will work just fine, but I never use inches myself... Of course the exact setting depends on your margins etcetera.

Besides that you may want to tweak the width settings a little (in the same stylesheet) and/or what columns to print (admin).

Is there a way to add an image to the list ?That is not difficult, but it takes time....

The amount of time it takes also depends on how well it should be implemented. The main problem with the images is that everyone may use different sizes, so it will easily get messy. There are several ways to solve this problem of course.

I got a question too this time :P

I was wondering if some who knows more about sql than me, reads this thread (and I know almost nothing about sql so .....).

The current version gets the info from the database like this:

    $query = 'SELECT p.products_id, p.products_quantity, p.products_model, p.products_price, p.products_status, p.products_tax_class_id, p.manufacturers_id, pd.products_name, pc.categories_id, p.products_weight ';

Maybe it is smarter to do it like:

    $query = 'SELECT * ';

to improve the speed. But I am not sure if it really would help, and I am afraid it will increase the memory usage :unsure:

If it does not make much difference for the speed, it might be wise to change it to reduce the number of fields that are read from the database (= only query the fields that are enabled to show).

Also several other improvements on the same matter might be possible.

paulm:

That is not difficult, but it takes time....

The amount of time it takes also depends on how well it should be implemented. The main problem with the images is that everyone may use different sizes, so it will easily get messy. There are several ways to solve this problem of course.

Hi Paulm - Thanks for the great module, it really has been a life-saver for me.
I too, however, badly need to add photos to the pricelist. Would you be willing to give some specifics as to what one must do? I'm not the person to take on this task by any stetch of the imagination, believe me, but would be willing to try, depending on the level of difficulty.

Thanks so much - Tim

As you can see i have added the image colums on the price list, however im stuck because it is not showing the product image. Im using:

$prodRow .= '<td class="modPL"><div>' . zen_image(DIR_WS_IMAGES . $listing->fields['products_image'], $listing->fields['products_id'], IMAGE_PRODUCT_LISTING_WIDTH, IMAGE_PRODUCT_LISTING_HEIGHT) . '</div></td>' . '<td class="prdPL"><div><a href="' . zen_href_link($handler_page, 'products_id=' . $products_id) . '" target="_blank">' . $cats[$cat_index][$prod_index]['products_name'] . '</a></div></td>' . "\n";

Any ideas anyone?

Did you add the products_image to the query as well? You can also use * to get all products info.

I am working on a new version, but I am alo working on a thousands of other things ..... (one of which is trying to make some money ;-) ). Maybe I will upload the a beta soon, it includes images and products descriptions, I only would like to improve it before "official" release, and make it easyer to fit the printed pages.

i have:

$query = 'SELECT p.products_id, p.products_quantity, p.products_model, p.products_price, p.products_status, p.products_tax_class_id, p.manufacturers_id, 

pd.products_name, pc.categories_id, p.products_weight, p.products_image';

BTW, I have setup a support thread here:
http://www.zen-cart.com/forum/showthread.php?p=283332#post283332

The latest version in that thread lets you install the price list without the need to edit any core file (previous versions required editting, or replacing, the currencies.php class)

I just need to get this working for a client other wise i would wait for the beta :p

I think you need pd.products_image i.s.o. p.products_image

(edit: pd is the products description table here)

i now get: Unknown column 'pd.products_image' in 'field list'