Automate generating PDF catalog

[taliban]

Anybody know where I can find the contribution for Zen-Cart 1.3.7: PDF Catalog, for automation generating PDF-catalog with all products, sort by categories.
I found that module for OsCommerce shop, but not find for zen-cart.

[Woodymon]

Anybody know where I can find the contribution for Zen-Cart 1.3.7: PDF Catalog, for automation generating PDF-catalog with all products, sort by categories.
I found that module for OsCommerce shop, but not find for zen-cart.

Check the download archives. I recall seeing a version for 1.2x.

Or maybe take one of the XML feed mods and define/create output (via XSLT) and/or which could be input into a XML to PDF conversion engine.

Or with some skill could possibly adapt paulm's printable-pricelist mod to export to PDF.

[High Octane]

Anybody know where I can find the contribution for Zen-Cart 1.3.7: PDF Catalog, for automation generating PDF-catalog with all products, sort by categories.
I found that module for OsCommerce shop, but not find for zen-cart.

zenpdfcreator_0.96. Works just fine for Zen-Cart 1.3.7. :o)

[BlessIsaacola]

zenpdfcreator_0.96. Works just fine for Zen-Cart 1.3.7. :o)

Do you by any chance have a link to the download for zenpdfcreator_0.96? I cannot find it in the download section.

[Rik]

http://www.zen-cart.com/archived_con...eator_0.96.zip

[BlessIsaacola]

http://www.zen-cart.com/archived_con...eator_0.96.zip

Thank you!

[Ryk]

Just installed this on a 1.3.7 site and get the following error:

1054 Unknown column 'p.products_id' in 'on clause'
in:
[select p.products_id, pd.products_name, pd.products_description, p.products_image, p.products_model, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from zen_products p left join zen_manufacturers m on p.manufacturers_id = m.manufacturers_id, zen_products_description pd left join zen_specials s on p.products_id = s.products_id, zen_categories c, zen_products_to_categories p2c where products_status = '1' and p.products_id = pd.products_id and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id AND p.products_image IS NOT NULL order by p.products_date_added DESC, pd.products_name]
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.

The function which is failing is in admin/pdf_catalogue.php - anyone advise as to what I may have done wrong please?

[TheOracle]

I haven't installed this MOD but by looking at your mySQL error message above, this part:

where products_status = '1' 

should rather be replaced with:

where p.products_status = '1' 

[Ryk]

Thanks for your suggestion - unfortunately it didn't work. However, I have someone else looking into it for me and when we find the problem, I'll post it here.

Odd though that HighOctane seems to have had no problems.

[wasana]

I just produced this error message when trying to generate pdf catalogue... zc1.3.7.1 -with IH2 (I tried to reset 'IH resize image' to no still go error)- this is a 'showroom' site without pricing... any ideas on what to do?

Do you need any specific adobe SW installed to make this work?

1054 Unknown column 'p.products_id' in 'on clause'
in:
[select p.products_id, pd.products_name, pd.products_description, p.products_image, p.products_model, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from ereproducts p left join eremanufacturers m on p.manufacturers_id = m.manufacturers_id, ereproducts_description pd left join erespecials s on p.products_id = s.products_id, erecategories c, ereproducts_to_categories p2c where products_status = '1' and p.products_id = pd.products_id and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id AND p.products_image IS NOT NULL order by p.products_date_added DESC, pd.products_name]
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.

thanks