How to Display UPC Code on Product Page

[faDdy]

I need to add UPC code for Combinations on Product page, didn't find any solution for this on forum ....Tried everything but can be able to display .....can anyone please explain how to do this,

 

Please Help

Thanks.

[ukbaz]

Go to Prestashop folder/themes/yourtheme

 

Open product.tpl

 

Find lines:

 

<!-- full description -->

<div id="idTab1" class="rte">{$product->description}</div>

 

Change last part to:

 

<!-- full description -->

<div id="idTab1" class="rte">{$product->description} {l s='EAN Code:'}{$product->ean13}</div>

 

UPC/EAN13 will appear at end of full desscription

 

Hope this helps

 

 

Baz

[faDdy]

Thanks UKbaz it worked perfect but what if i want to show the EAN13/UPC for product Combinations in prestashop 1.4.8.2

[abdullah.maswadeh]

I had this issue and  solved it by the following steps on PrestaShop 1.6  to display on product page also works with combinations :

(( assuming that you are using the default PrestaShop theme ))

1 - Override Default product controller by creating ( ProductController.php ) file on  your_path/override/front/controllers
then add the following code to the file  : 
 

<?php

 

class ProductController extends ProductControllerCore

{

 

   /**

     * Assign template vars related to attribute groups and colors

     */

    protected function assignAttributesGroups()

    {

        $colors = array();

        $groups = array();

 

        // @todo (RM) should only get groups and not all declination ?

        $attributes_groups = $this->product->getAttributesGroups($this->context->language->id);

        if (is_array($attributes_groups) && $attributes_groups) {

            $combination_images = $this->product->getCombinationImages($this->context->language->id);

            $combination_prices_set = array();

            foreach ($attributes_groups as $k => $row) {

                // Color management

                if (isset($row['is_color_group']) && $row['is_color_group'] && (isset($row['attribute_color']) && $row['attribute_color']) || (file_exists(_PS_COL_IMG_DIR_.$row['id_attribute'].'.jpg'))) {

                    $colors[$row['id_attribute']]['value'] = $row['attribute_color'];

                    $colors[$row['id_attribute']]['name'] = $row['attribute_name'];

                    if (!isset($colors[$row['id_attribute']]['attributes_quantity'])) {

                        $colors[$row['id_attribute']]['attributes_quantity'] = 0;

                    }

                    $colors[$row['id_attribute']]['attributes_quantity'] += (int)$row['quantity'];

                }

                if (!isset($groups[$row['id_attribute_group']])) {

                    $groups[$row['id_attribute_group']] = array(

                        'group_name' => $row['group_name'],

                        'name' => $row['public_group_name'],

                        'group_type' => $row['group_type'],

                        'default' => -1,

                    );

                }

 

                $groups[$row['id_attribute_group']]['attributes'][$row['id_attribute']] = $row['attribute_name'];

                if ($row['default_on'] && $groups[$row['id_attribute_group']]['default'] == -1) {

                    $groups[$row['id_attribute_group']]['default'] = (int)$row['id_attribute'];

                }

                if (!isset($groups[$row['id_attribute_group']]['attributes_quantity'][$row['id_attribute']])) {

                    $groups[$row['id_attribute_group']]['attributes_quantity'][$row['id_attribute']] = 0;

                }

                $groups[$row['id_attribute_group']]['attributes_quantity'][$row['id_attribute']] += (int)$row['quantity'];

 

                $combinations[$row['id_product_attribute']]['attributes_values'][$row['id_attribute_group']] = $row['attribute_name'];

                $combinations[$row['id_product_attribute']]['attributes'][] = (int)$row['id_attribute'];

                $combinations[$row['id_product_attribute']]['price'] = (float)$row['price'];

 

                // Call getPriceStatic in order to set $combination_specific_price

                if (!isset($combination_prices_set[(int)$row['id_product_attribute']])) {

                    Product::getPriceStatic((int)$this->product->id, false, $row['id_product_attribute'], 6, null, false, true, 1, false, null, null, null, $combination_specific_price);

                    $combination_prices_set[(int)$row['id_product_attribute']] = true;

                    $combinations[$row['id_product_attribute']]['specific_price'] = $combination_specific_price;

                }

                $combinations[$row['id_product_attribute']]['ecotax'] = (float)$row['ecotax'];

                $combinations[$row['id_product_attribute']]['weight'] = (float)$row['weight'];

                $combinations[$row['id_product_attribute']]['quantity'] = (int)$row['quantity'];

                $combinations[$row['id_product_attribute']]['reference'] = $row['reference'];

                $combinations[$row['id_product_attribute']]['upc'] = $row['upc'];

                $combinations[$row['id_product_attribute']]['unit_impact'] = $row['unit_price_impact'];

                $combinations[$row['id_product_attribute']]['minimal_quantity'] = $row['minimal_quantity'];

                if ($row['available_date'] != '0000-00-00' && Validate::isDate($row['available_date'])) {

                    $combinations[$row['id_product_attribute']]['available_date'] = $row['available_date'];

                    $combinations[$row['id_product_attribute']]['date_formatted'] = Tools::displayDate($row['available_date']);

                } else {

                    $combinations[$row['id_product_attribute']]['available_date'] = $combinations[$row['id_product_attribute']]['date_formatted'] = '';

                }

 

                if (!isset($combination_images[$row['id_product_attribute']][0]['id_image'])) {

                    $combinations[$row['id_product_attribute']]['id_image'] = -1;

                } else {

                    $combinations[$row['id_product_attribute']]['id_image'] = $id_image = (int)$combination_images[$row['id_product_attribute']][0]['id_image'];

                    if ($row['default_on']) {

                        if (isset($this->context->smarty->tpl_vars['cover']->value)) {

                            $current_cover = $this->context->smarty->tpl_vars['cover']->value;

                        }

 

                        if (is_array($combination_images[$row['id_product_attribute']])) {

                            foreach ($combination_images[$row['id_product_attribute']] as $tmp) {

                                if ($tmp['id_image'] == $current_cover['id_image']) {

                                    $combinations[$row['id_product_attribute']]['id_image'] = $id_image = (int)$tmp['id_image'];

                                    break;

                                }

                            }

                        }

 

                        if ($id_image > 0) {

                            if (isset($this->context->smarty->tpl_vars['images']->value)) {

                                $product_images = $this->context->smarty->tpl_vars['images']->value;

                            }

                            if (isset($product_images) && is_array($product_images) && isset($product_images[$id_image])) {

                                $product_images[$id_image]['cover'] = 1;

                                $this->context->smarty->assign('mainImage', $product_images[$id_image]);

                                if (count($product_images)) {

                                    $this->context->smarty->assign('images', $product_images);

                                }

                            }

                            if (isset($this->context->smarty->tpl_vars['cover']->value)) {

                                $cover = $this->context->smarty->tpl_vars['cover']->value;

                            }

                            if (isset($cover) && is_array($cover) && isset($product_images) && is_array($product_images)) {

                                $product_images[$cover['id_image']]['cover'] = 0;

                                if (isset($product_images[$id_image])) {

                                    $cover = $product_images[$id_image];

                                }

                                $cover['id_image'] = (Configuration::get('PS_LEGACY_IMAGES') ? ($this->product->id.'-'.$id_image) : (int)$id_image);

                                $cover['id_image_only'] = (int)$id_image;

                                $this->context->smarty->assign('cover', $cover);

                            }

                        }

                    }

                }

            }

 

            // wash attributes list (if some attributes are unavailables and if allowed to wash it)

            if (!Product::isAvailableWhenOutOfStock($this->product->out_of_stock) && Configuration::get('PS_DISP_UNAVAILABLE_ATTR') == 0) {

                foreach ($groups as &$group) {

                    foreach ($group['attributes_quantity'] as $key => &$quantity) {

                        if ($quantity <= 0) {

                            unset($group['attributes'][$key]);

                        }

                    }

                }

 

                foreach ($colors as $key => $color) {

                    if ($color['attributes_quantity'] <= 0) {

                        unset($colors[$key]);

                    }

                }

            }

            foreach ($combinations as $id_product_attribute => $comb) {

                $attribute_list = '';

                foreach ($comb['attributes'] as $id_attribute) {

                    $attribute_list .= '\''.(int)$id_attribute.'\',';

                }

                $attribute_list = rtrim($attribute_list, ',');

                $combinations[$id_product_attribute]['list'] = $attribute_list;

            }

 

            $this->context->smarty->assign(array(

                'groups' => $groups,

                'colors' => (count($colors)) ? $colors : false,

                'combinations' => $combinations,

                'combinationImages' => $combination_images

            ));

        }

    }

 

}

 

 

?>

 

 

 

2 - override product class controller by creating ( Product.php ) file on your_path/override/classes/
and add the following code to the file :

<?php

 

class Product extends ProductCore

{

     public function getAttributesGroups($id_lang)

    {

 

        if (!Combination::isFeatureActive()) {

            return array();

        }

        $sql = 'SELECT ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,

a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,

IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,

product_attribute_shop.`default_on`, pa.`reference`, pa.`upc`, product_attribute_shop.`unit_price_impact`,

product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`

FROM `'._DB_PREFIX_.'product_attribute` pa

'.Shop::addSqlAssociation('product_attribute', 'pa').'

'.Product::sqlStock('pa', 'pa').'

LEFT JOIN `'._DB_PREFIX_.'product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)

LEFT JOIN `'._DB_PREFIX_.'attribute` a ON (a.`id_attribute` = pac.`id_attribute`)

LEFT JOIN `'._DB_PREFIX_.'attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)

LEFT JOIN `'._DB_PREFIX_.'attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)

LEFT JOIN `'._DB_PREFIX_.'attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)

'.Shop::addSqlAssociation('attribute', 'a').'

WHERE pa.`id_product` = '.(int)$this->id.'

AND al.`id_lang` = '.(int)$id_lang.'

AND agl.`id_lang` = '.(int)$id_lang.'

GROUP BY id_attribute_group, id_product_attribute

ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC';

        return Db::getInstance()->executeS($sql);

    }

}

 

 

3 - Edit the default product template file on your theme :  your_path/themes/default/product.tpl and add the following UPC div after the reference number almost after line 164

<p id="product_upc"{if empty($product->upc) || !$product->upc} style="display: none;"{/if}>

<label>{l s='UPC :'} </label>

<span class="editable">{$product->upc|escape:'html':'UTF-8'}</span>

</p>

 

4 - add Javascript definition for upc to be used in javascript on the bottom of the page after any javascript definition

 

{addJsDef productUpc=$product->upc|escape:'html':'UTF-8'}

 

 

5 - edit product.js on your_path/themes/default/js/product.js

 

- add the following code after line 94

 

combinationsJS[k]['upc'] = combinations['upc'];

 

 

6 - add the following code after line 429

selectedCombination['upc'] = combinations[combination]['upc'];

 

 

7 - add the following code after line 623

 

//update upc

if (selectedCombination['upc'] || productUpc)

{

if (selectedCombination['upc'])

$('#product_upc span').text(selectedCombination['upc']);

else if (productUpc)

$('#product_upc span').text(productUpc);

$('#product_upc:hidden').show('slow');

}

else

$('#product_upc:visible').hide('slow');

 

8 - Have Fun

 

 

 

 

 

 

 

[michaelkim]

Hi, I'm using PrestaShop 1.6.

I tried what you said, but it doesn't work.

Did I miss something?

[ZikmaSolutions]

How to show UPC Barcode just below reference on product page? Not in tabs and not after description? Thanks