Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

creating a catalogue of products - printed copy


billybrag

Recommended Posts

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

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

Try the "catalog_products_with_images" contribution, workes fine on my site.

 

 

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

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

ah yes i see from your site, thanks mate

 

which version did you use?

thanks again </being stupid>

 

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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...