printable price list

[paulm]

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.

[paulm]

I got a question too this time

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

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.

[MeltDown]

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

[connexhosting]

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?

[paulm]

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.

[connexhosting]

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';

[paulm]

BTW, I have setup a support thread here:
http://www.zen-cart.com/forum/showth...332#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)

[connexhosting]

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

[paulm]

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

(edit: pd is the products description table here)

[connexhosting]

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