Post by rbass » Thu Jun 16, 2011 6:02 am

How do I post the "sku" Db field into the /catalog/view/theme/default/template/product/category.tpl?

Database fields: product_id model sku location quantity

<span style="color: #999; font-size: 11px;">Fits: <?php echo $products[$j]['sku']; ?></span><br />


Thanks for your help!!

Code: Select all




<table class="list">
      <?php for ($i = 0; $i < sizeof($products); $i = $i + 4) { ?>
      <tr>
        <?php for ($j = $i; $j < ($i + 4); $j++) { ?>
        <td width="25%"><?php if (isset($products[$j])) { ?>
          <a href="<?php echo $products[$j]['href']; ?>"><?php echo $products[$j]['name']; ?></a><br />
          [highlight]<span style="color: #999; font-size: 11px;">Fits: <?php echo $products[$j]['sku']; ?></span><br />[/highlight]		  <span style="vertical-align: center; font-size: 11px;"><a href="<?php echo $products[$j]['href']; ?>"><img src="<?php echo $products[$j]['thumb']; ?>" title="<?php echo $products[$j]['name']; ?>" alt="<?php echo $products[$j]['name']; ?>" /></a></span><br />
          <br />
          <?php if ($products[$j]['rating']) { ?>
          <img src="catalog/view/theme/default/image/stars_<?php echo $products[$j]['rating'] . '.png'; ?>" alt="<?php echo $products[$j]['stars']; ?>" />
          <?php } ?>
		  <span style="float: bottom">
		  <?php if ($display_price) { ?>
          <?php if (!$products[$j]['special']) { ?>
          <span style="color: #111; font-weight: bold;"><?php echo $products[$j]['price']; ?></span>
          <?php } else { ?>
          <span style="color: #111; font-weight: bold; text-decoration: line-through;"><?php echo $products[$j]['price']; ?></span> <span style="color: #333;"><?php echo $products[$j]['special']; ?></span>
          <?php } ?>
          <a class="button_add_small" href="<?php echo $products[$j]['add']; ?>" title="<?php echo $button_add_to_cart; ?>" >&nbsp;</a>
		  <?php } ?>
          <?php } ?></span></td>
        <?php } ?>
      </tr>
      <?php } ?>
    </table>


New member

Posts

Joined
Mon Nov 22, 2010 6:26 am

Post by qahar » Thu Jun 16, 2011 4:15 pm

do not forget to add sku on category.php controller

Code: Select all

'sku' = result['sku']

User avatar
Expert Member

Posts

Joined
Tue Jun 29, 2010 10:24 pm
Location - Indonesia

Post by rbass » Sat Jun 25, 2011 3:20 am

OK, I have attempted to add the code to cart.php and category.php and I cannot get either to work. Please advise how 'sku' => $result['sku'] is supposed to be included in the contoller files. Thanks!

Code: Select all

//Cart.php

$this->data['products'][] = array(
          			[highlight]'sku' => $result['sku'],[/highlight]					'key'      => $result['key'],
          			'name'     => $result['name'],
          			'model'    => $result['model'],
          			'thumb'    => $this->model_tool_image->resize($image, $this->config->get('config_image_cart_width'), $this->config->get('config_image_cart_height')),
          			'option'   => $option_data,
          			'quantity' => $result['quantity'],
          			'stock'    => $result['stock'],
					

Code: Select all


//Category.php



$this->data['products'][] = array(
            			[highlight]'sku' = result['sku'],[/highlight]						'name'    => $result['name'],
						'model'   => $result['model'],
            			'rating'  => $rating,
						'stars'   => sprintf($this->language->get('text_stars'), $rating),




New member

Posts

Joined
Mon Nov 22, 2010 6:26 am

Post by rbass » Sun Jun 26, 2011 12:08 am

SOLVED

New member

Posts

Joined
Mon Nov 22, 2010 6:26 am

Post by ollie007 » Sun Jun 26, 2011 5:59 am

how did u solve it?

New member

Posts

Joined
Fri Jun 10, 2011 1:56 am

Post by bennyboy79 » Thu Nov 17, 2011 9:14 pm

i would also like to know how you solved it?

thanks

Newbie

Posts

Joined
Wed Nov 16, 2011 5:50 pm
Who is online

Users browsing this forum: No registered users and 8 guests