billybrag Posted January 19, 2005 Share Posted January 19, 2005 what is the easiest way to create a printed catalogu of products? i have tried the pdf catalogue but that gets loads of &nsbp in it so its no good really? any ideas? with images would be best though not essential. thanks mike "because it'll hurt more"- the greatest film of all time? Link to comment Share on other sites More sharing options...
bobg7 Posted January 19, 2005 Share Posted January 19, 2005 Try the "catalog_products_with_images" contribution, workes fine on my site. Installed Contributions: CCGV, Close Popup, Dynamic Meta Tags, Easy Populate, Froogle Data Feeder, Google Position, Infobox Header Entire Row, Live Support for OSC, PayPal Seal with CC images, Report_m Sales, Shop by Price Revised, SQL Updater, Who's Online Enhancement, Footer, GNA EP Assistant and still going. Link to comment Share on other sites More sharing options...
billybrag Posted January 19, 2005 Author Share Posted January 19, 2005 Try the "catalog_products_with_images" contribution, workes fine on my site. <{POST_SNAPBACK}> thanks for the reply, but i couldnt figure out how to actually print that? probably just me being stupid! any one have any more ideas? "because it'll hurt more"- the greatest film of all time? Link to comment Share on other sites More sharing options...
bobg7 Posted January 19, 2005 Share Posted January 19, 2005 Once it opens a new window and finishes loading, use your browsers print function. Installed Contributions: CCGV, Close Popup, Dynamic Meta Tags, Easy Populate, Froogle Data Feeder, Google Position, Infobox Header Entire Row, Live Support for OSC, PayPal Seal with CC images, Report_m Sales, Shop by Price Revised, SQL Updater, Who's Online Enhancement, Footer, GNA EP Assistant and still going. Link to comment Share on other sites More sharing options...
billybrag Posted January 19, 2005 Author Share Posted January 19, 2005 Once it opens a new window and finishes loading, use your browsers print function. <{POST_SNAPBACK}> ah yes i see from your site, thanks mate which version did you use? thanks again </being stupid> "because it'll hurt more"- the greatest film of all time? Link to comment Share on other sites More sharing options...
bobg7 Posted January 19, 2005 Share Posted January 19, 2005 ah yes i see from your site, thanks mate which version did you use? thanks again </being stupid> <{POST_SNAPBACK}> Using version 1.6.1.2 I think. Also you can add a print button: <input type=button value="Print Page" onClick="print()"> Just after line 58 in >catalog>catalog_products_with_images. Should look something like this: <td class="tableHeading" align="center"><?php echo TABLE_HEADING_PRODUCTS_MODEL; ?></td> <td class="tableHeading" align="center"><?php echo TABLE_HEADING_QUANTITY; ?></td> <td class="tableHeading" align="center"><?php echo TABLE_HEADING_PRICE; ?> </td> </tr> <tr> <td colspan="5"><?php echo tep_draw_separator(); ?></td> </tr> <input type=button value="Print Page" onClick="print()"> <?php if ($HTTP_GET_VARS['page'] > 1) $rows = $HTTP_GET_VARS['page'] * 20 - 20; $products_query_raw = "select p.products_id, p.products_image, p.products_model, p.products_quantity, pd.products_name, p.manufacturers_id, p.products_price, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '" . $languages_id . "' order by pd.products_name"; $products_query = tep_db_query($products_query_raw); while($products = tep_db_fetch_array($products_query)) { $rows++; if (strlen($rows) < 2) { $rows = '0' . $rows; I just did this on mine and it seems to work OK. Bob G. Installed Contributions: CCGV, Close Popup, Dynamic Meta Tags, Easy Populate, Froogle Data Feeder, Google Position, Infobox Header Entire Row, Live Support for OSC, PayPal Seal with CC images, Report_m Sales, Shop by Price Revised, SQL Updater, Who's Online Enhancement, Footer, GNA EP Assistant and still going. Link to comment Share on other sites More sharing options...
billybrag Posted January 19, 2005 Author Share Posted January 19, 2005 right to take this a stage further is there a way that i can manipulate the relevant tables so that i can create a catalogue offline? this doesnt have to be online at all any suggestions where to start etc? "because it'll hurt more"- the greatest film of all time? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.