add "product_manufacturer_id"

-- url of the page with the problem -- : arthurk.nl/orkestbanden/index.php/catego...tels-a-z-engelstalig
-- HikaShop version -- : HikaShop Starter 2.6.1,
-- Joomla version -- : 3.4.8
-- PHP version -- : 5.6.17
-- Browser(s) name and version -- : Chrome
-- Error-message(debug-mod must be tuned on) -- : none

Hello, my first time for working with Hikashop.
Can you tell me how i can put "product_manufacturer_id" in the same row as "product_name" (see img)

I am trying to fix it in "components/com_hikashop/views/category/tmpl", tried several files but no results.

Link

thank you
Arthur

Do you want to display product_manufacturer_id, manufacturer name or link to manufacturer listing?

@Jerome, sorry for the edits, the links where broken so i changed it in the post. tnx for pointing to the doc file.

@Korzo, let me try to explain what i want.
I have a csv file with mp3 data. Hikashop is the only shop i can find where i can import that list (for free)
Take a look to img1, i found out that this way of importing it will set the data to the fields in img2.
So if i can place the field "Brand" after "Name" in the tabel then i can try to find a way when you select the artist that all his songs come in a list.

I used the menu option Categories Listing, and set by products "Tabel"

Sorry for the bad English

Arthur

I was confused, because product_manufacturer_id is numeric value.

At first create override of file listing_table.php in product view
http://hikashop.com/support/documentation/153-customize-the-display.html#layout

At the start of the file, right after

defined('_JEXEC') or die('Restricted access');

if (!function_exists('get_manufacturer')) {
    function get_manufacturer ($product)
    {
        static $manufacturers = array();

        if (empty($product->product_manufacturer_id)) {
            return false;
        }

        if (isset($manufacturers[$product->product_manufacturer_id])) {
            return $manufacturers[$product->product_manufacturer_id];
        }

        $catclass = hikashop_get('class.category');
        $manufacturer = $catclass->get($product->product_manufacturer_id);

        if ($manufacturer->category_published) {
            $menuclass = hikashop_get("class.menus");
            $manufacturer_itemid = $menuclass->loadAmenuItemId('manufacturer', 'listing');
            if (empty($manufacturer_itemid)) {
                $manufacturer_itemid = $menuclass->loaddAmenuItemId('', '');
            }

            $catclass->AddAlias($manufacturer);
            $manufacturer->url = hikashop_contentLink('category&task=listing&cid='.$manufacturer->category_id.'&name='
                .$manufacturer->alias.'&Itemid='.$manufacturer_itemid, $manufacturer);

            $manufacturers[$product->product_manufacturer_id] = $manufacturer;
            return $manufacturer;
        }
        return false;
    }
}

<?php if($this->params->get('show_vote_product')){ ?>

<th class="hikashop_product_manufacturer">Artist</th>

<?php if($this->params->get('show_vote_product')){ ?>

                    <?php
                    $artist = get_manufacturer($row);
                    echo '<td class="hikashop_product_manufacturer" >';
                    if ($artist) {                        
                        //echo $artist->category_name;
                        echo '<a href="'.$artist->url.'">'.$artist->category_name.'</a>';                        
                    }
                    echo '</td>'; ?>

Hey Korzo, great that you made the coding but the result looks like the image.

Maybe i did or understand something wrong.
I go to Hikashop/display
choose protostar template/Iproduct / listing_table.php
then copy and paste your code (from the link)

Arthur

ok, i put in the code paece by peace and that looks better now, colomname Artist is there but no artist name was filled in.

Arthur

so it's official, i am confused to!
When i import a csv file like i discribed before the product_manufacturer_id filled in the artist name in the Brand field
Now i did a export from hikashop and the id shows numbers?

product_manufacturer_id should be numeric id of manufacturer, but Hikashop is smart enough to figure out there is name instead of id.
Code I posted should work as it's working on my website.
If you have no other modification, you can copy whole file from here:
https://gist.githubusercontent.com/korzo/e12d89316af88a8e2298/raw/bd69d7adfe61fb00fa0a2b2a9040fee7574cdc3a/listing_table.php

ok, but there must be a relationship between the number and name i guess
Hikashop shows the name in product specs.
How can i resolve the name thats connected to the numbers.
In phpmyadmin i cant find anything thats related to each other.

grtz Arthur

Manufacturers are stored in table hikashop_category.

Thank you guy's but it's still not working.

I copy'd all the code, made a new joomla instal, new hikashop install but what ever i try, no output on that field.

Can somebody take a look in my admin why i'ts not working?

tnx
Arthur

Hi,

You can send a backend access via our contact form: www.hikashop.com/support/contact-us.html
Don't forget to give the link to that topic in your message.

Done
You can see the modifications in the view "product / listing_table".

Thanks Xavier!

Great and quick support.

Arthur