[SOLVED] How to filter back office product list by supplier id

Riya · October 18, 2013

how to filter back office product list page by supplier id,

vekia · October 18, 2013

hello

you're looking for something like:

?

Riya · October 18, 2013

Thank you vekia for your quik reply.yes I am looking for this.How to make this?

Riya · October 18, 2013

I want to show only one seller product

ie,it show only supplier AppleStore product only

vekia · October 18, 2013

in this case i can;t help, sorry just thought that you want filtering like filter i created above.

ventura · October 18, 2013

hello

you're looking for something like:

?

I need this

How I made it ?

vekia · October 18, 2013

I need this

How I made it ?

here is the solution:

open file:

controllers/admin/AdminProductsController.php

you can find there code:

$this->_join .= ' JOIN `'._DB_PREFIX_.'product_shop` sa ON (a.`id_product` = sa.`id_product` AND sa.id_shop = '.$id_shop.')
    LEFT JOIN `'._DB_PREFIX_.'category_lang` cl ON ('.$alias.'.`id_category_default` = cl.`id_category` AND b.`id_lang` = cl.`id_lang` AND cl.id_shop = '.$id_shop.')
    LEFT JOIN `'._DB_PREFIX_.'shop` shop ON (shop.id_shop = '.$id_shop.')
    LEFT JOIN `'._DB_PREFIX_.'image_shop` image_shop ON (image_shop.`id_image` = i.`id_image` AND image_shop.`cover` = 1 AND image_shop.id_shop = '.$id_shop.')';

change it to:

$this->_join .= ' JOIN `'._DB_PREFIX_.'product_shop` sa ON (a.`id_product` = sa.`id_product` AND sa.id_shop = '.$id_shop.')
    LEFT JOIN `'._DB_PREFIX_.'category_lang` cl ON ('.$alias.'.`id_category_default` = cl.`id_category` AND b.`id_lang` = cl.`id_lang` AND cl.id_shop = '.$id_shop.')
    LEFT JOIN `'._DB_PREFIX_.'shop` shop ON (shop.id_shop = '.$id_shop.')
    LEFT JOIN `'._DB_PREFIX_.'supplier` supp ON (supp.id_supplier = a.`id_supplier`) 
    LEFT JOIN `'._DB_PREFIX_.'image_shop` image_shop ON (image_shop.`id_image` = i.`id_image` AND image_shop.`cover` = 1 AND image_shop.id_shop = '.$id_shop.')';

below this code add this one:

$this->_select .= 'shop.name as shopname, supp.`name` AS `supp`, ';

and then, right after this:

$this->fields_list['id_product'] = array(
			'title' => $this->l('ID'),
			'align' => 'center',
			'type' => 'int',
			'width' => 40
		);

add this one:

        $this->fields_list['supp'] = array(
			'title' => $this->l('Supplier'),
			'filter_key' => 'supp!name'
		);

ventura · October 19, 2013

Thanks a lot vekia

ventura · October 19, 2013

No works

Unknown column 'supp.name' in 'field list'

This is the code

if (Shop::getContext() == Shop::CONTEXT_SHOP)
{
$this->_join .= ' JOIN `'._DB_PREFIX_.'product_shop` sa ON (a.`id_product` = sa.`id_product` AND sa.id_shop = '.$id_shop.')
                LEFT JOIN `'._DB_PREFIX_.'category_lang` cl ON ('.$alias.'.`id_category_default` = cl.`id_category` AND b.`id_lang` = cl.`id_lang` AND cl.id_shop = '.$id_shop.')
                LEFT JOIN `'._DB_PREFIX_.'shop` shop ON (shop.id_shop = '.$id_shop.')
                LEFT JOIN `'._DB_PREFIX_.'supplier` supp ON (supp.id_supplier = a.`id_supplier`) 
                LEFT JOIN `'._DB_PREFIX_.'image_shop` image_shop ON (image_shop.`id_image` = i.`id_image` AND image_shop.`cover` = 1 AND image_shop.id_shop = '.$id_shop.')';
   $this->_select .= 'shop.name as shopname, supp.`name` AS `supp`, ';
}


else
{
$this->_join .= ' LEFT JOIN `'._DB_PREFIX_.'product_shop` sa ON (a.`id_product` = sa.`id_product` AND sa.id_shop = a.id_shop_default)
LEFT JOIN `'._DB_PREFIX_.'category_lang` cl ON ('.$alias.'.`id_category_default` = cl.`id_category` AND b.`id_lang` = cl.`id_lang` AND cl.id_shop = a.id_shop_default)
LEFT JOIN `'._DB_PREFIX_.'shop` shop ON (shop.id_shop = a.id_shop_default) 
LEFT JOIN `'._DB_PREFIX_.'image_shop` image_shop ON (image_shop.`id_image` = i.`id_image` AND image_shop.`cover` = 1 AND image_shop.id_shop=a.id_shop_default)';
}
$this->_select .= 'shop.name as shopname, ';
}
else
{
$alias = 'a';

and then:

$this->_group = 'GROUP BY '.$alias.'.id_product';


$this->fields_list = array();
$this->fields_list['id_product'] = array(
'title' => $this->l('ID'),
'align' => 'center',
'width' => 20
);
 $this->fields_list['supp'] = array(
'title' => $this->l('Supplier'),
'filter_key' => 'supp!name'
); 
$this->fields_list['image'] = array(
'title' => $this->l('Photo'),
'align' => 'center',
'image' => 'p',
'width' => 70,
'orderby' => false,
'filter' => false,
'search' => false
);

where its the failure?

vekia · October 19, 2013

what ps version you use?

ventura · October 19, 2013

what ps version you use?

1.5.4.1

ventura · October 20, 2013

help me with this please

vekia · October 20, 2013

ok,

code looks a bit different than code in 1.5.6.0

remove code that you added.

now right after:

if (Shop::isFeatureActive())
		{
			$alias = 'sa';
			$alias_image = 'image_shop';
			if (Shop::getContext() == Shop::CONTEXT_SHOP)
			{
				$this->_join .= ' JOIN `'._DB_PREFIX_.'product_shop` sa ON (a.`id_product` = sa.`id_product` AND sa.id_shop = '.(int)$this->context->shop->id.')
				LEFT JOIN `'._DB_PREFIX_.'category_lang` cl ON ('.$alias.'.`id_category_default` = cl.`id_category` AND b.`id_lang` = cl.`id_lang` AND cl.id_shop = '.(int)$this->context->shop->id.')
				LEFT JOIN `'._DB_PREFIX_.'shop` shop ON (shop.id_shop = '.(int)$this->context->shop->id.')  
				LEFT JOIN `'._DB_PREFIX_.'image_shop` image_shop ON (image_shop.`id_image` = i.`id_image` AND image_shop.`cover` = 1 AND image_shop.id_shop='.(int)$this->context->shop->id.')';
			}
			else
			{
				$this->_join .= ' LEFT JOIN `'._DB_PREFIX_.'product_shop` sa ON (a.`id_product` = sa.`id_product` AND sa.id_shop = a.id_shop_default)
				LEFT JOIN `'._DB_PREFIX_.'category_lang` cl ON ('.$alias.'.`id_category_default` = cl.`id_category` AND b.`id_lang` = cl.`id_lang` AND cl.id_shop = a.id_shop_default)
				LEFT JOIN `'._DB_PREFIX_.'shop` shop ON (shop.id_shop = a.id_shop_default)
				LEFT JOIN `'._DB_PREFIX_.'image_shop` image_shop ON (image_shop.`id_image` = i.`id_image` AND image_shop.`cover` = 1 AND image_shop.id_shop=a.id_shop_default)';
			}
			$this->_select .= 'shop.name as shopname, ';
		}
		else
		{
			$alias = 'a';
			$alias_image = 'i';
			$this->_join .= 'LEFT JOIN `'._DB_PREFIX_.'category_lang` cl ON ('.$alias.'.`id_category_default` = cl.`id_category` AND b.`id_lang` = cl.`id_lang` AND cl.id_shop = 1)';
		}

add this:

$this->_join .='LEFT JOIN `'._DB_PREFIX_.'supplier` supp ON (supp.id_supplier = a.`id_supplier`)';
$this->_select .= 'supp.`name` AS `supp`, ';

and then, right after this:

$this->fields_list['id_product'] = array(
            'title' => $this->l('ID'),
            'align' => 'center',
            'type' => 'int',
            'width' => 40
);

add this one:

$this->fields_list['supp'] = array(
            'title' => $this->l('Supplier'),
            'filter_key' => 'supp!name'
);

effect:

ventura · October 20, 2013

Works like a charm!

Thanks a lot vekia

vekia · October 20, 2013

you're welcome thanks for your patience

MGLimhamn · January 29, 2014

Hi and thanks for your solution vekia. However, if I filter by supplier on the product page then go to page 2 for example, the sorted list of suppliers doesn't work anymore. The URL changes to: &productOrderby=name&productOrderway=asc#product. Meaning that it changes the sort order from supplier to name.

How can I fix this?

bissio · February 13, 2014

Hi Vekia,

thanks for your usefull post about the supplier search. I have to search even for supplier reference... i mean if a have a supplier named supp01 and if this supplier has 3 reference codes, so how can i search for supplier code? I need to search for supplier reference.

Thanks

PaoloGDMtech · May 29, 2014

hello

any chance to get the code for 1.6.06 version?

thank you in advance!

vekia · May 29, 2014

after:

		$this->_join .= ' JOIN `'._DB_PREFIX_.'product_shop` sa ON (a.`id_product` = sa.`id_product` AND sa.id_shop = '.$id_shop.')
				LEFT JOIN `'._DB_PREFIX_.'category_lang` cl ON ('.$alias.'.`id_category_default` = cl.`id_category` AND b.`id_lang` = cl.`id_lang` AND cl.id_shop = '.$id_shop.')
				LEFT JOIN `'._DB_PREFIX_.'shop` shop ON (shop.id_shop = '.$id_shop.') 
				LEFT JOIN `'._DB_PREFIX_.'image_shop` image_shop ON (image_shop.`id_image` = i.`id_image` AND image_shop.`cover` = 1 AND image_shop.id_shop = '.$id_shop.')';

add:

$this->_join .='LEFT JOIN `'._DB_PREFIX_.'supplier` AS supp ON (supp.id_supplier = a.`id_supplier`)';                
$this->_select .= 'supp.`name` AS `supp`, ';

and after:

		$this->fields_list['id_product'] = array(
			'title' => $this->l('ID'),
			'align' => 'center',
			'class' => 'fixed-width-xs',
			'type' => 'int'
		);

add:

        $this->fields_list['supp'] = array(
            'title' => $this->l('Supplier'),
            'filter_key' => 'supp!name'
);

PaoloGDMtech · May 29, 2014

wow,

that was fast.

thank you a lot!

subwayside · August 16, 2014

it work awesome!!

Thanks Vekia

vekia · August 17, 2014

there is no other way, modification must work ;-)

what ps version you use?

subwayside · August 24, 2014

hi,

i'm using ps1.6.0.9 and i want like when my employee login to back office then supplier filter will apply on it.

so my employee can only see filtered by supplier product.

Like an x employe login to backoffice.

when he login and click on products then he will see only x supplier products.

same like other employee.

if y employe will login to BO then he only can see y supplier product on product list.

Please help how can i make that.

Thanks

Blawdi · September 30, 2014

Thank you it's work on 1.6.0.8

it's possible to added filter on this page :

Catalogue/supplier

It's verry easy for order to supplier.

Thank you

farrvince · October 28, 2014

after:

		$this->_join .= ' JOIN `'._DB_PREFIX_.'product_shop` sa ON (a.`id_product` = sa.`id_product` AND sa.id_shop = '.$id_shop.')
				LEFT JOIN `'._DB_PREFIX_.'category_lang` cl ON ('.$alias.'.`id_category_default` = cl.`id_category` AND b.`id_lang` = cl.`id_lang` AND cl.id_shop = '.$id_shop.')
				LEFT JOIN `'._DB_PREFIX_.'shop` shop ON (shop.id_shop = '.$id_shop.') 
				LEFT JOIN `'._DB_PREFIX_.'image_shop` image_shop ON (image_shop.`id_image` = i.`id_image` AND image_shop.`cover` = 1 AND image_shop.id_shop = '.$id_shop.')';

add:

$this->_join .='LEFT JOIN `'._DB_PREFIX_.'supplier` AS supp ON (supp.id_supplier = a.`id_supplier`)';                
$this->_select .= 'supp.`name` AS `supp`, ';

and after:

		$this->fields_list['id_product'] = array(
			'title' => $this->l('ID'),
			'align' => 'center',
			'class' => 'fixed-width-xs',
			'type' => 'int'
		);

add:

        $this->fields_list['supp'] = array(
            'title' => $this->l('Supplier'),
            'filter_key' => 'supp!name'
);

Hello

How can I make this posible with Prestashop 1.6.0.9?

hrq1 · November 22, 2014

<?php

/*

*** /public_html/yourshop/override/controllers/admin/AdminProductsController.php **

*/

class AdminProductsController extends AdminProductsControllerCore

{

public function __construct()

{

parent::__construct();

$this->fields_list['price_final'] = array(

'title' => $this->l('Final price'),

'width' => 90,

'type' => 'price',

'align' => 'right',

);

}

public function getList($id_lang, $orderBy = id_product, $orderWay = desc, $start = 0, $limit = null, $id_lang_shop = null)

{

$orderByPriceFinal = (empty($orderBy) ? ($this->context->cookie->__get($this->table.'Orderby') ? $this->context->cookie->__get($this->table.'Orderby') : 'id_'.$this->table) : $orderBy);

$orderWayPriceFinal = (empty($orderWay) ? ($this->context->cookie->__get($this->table.'Orderway') ? $this->context->cookie->__get($this->table.'Orderby') : 'ASC') : $orderWay);

AdminController::getList($id_lang, $orderBy, $orderWay, $start, $limit, $this->context->shop->id);

$nb = count($this->_list);

if ($this->_list)

{

for ($i = 0; $i < $nb; $i++)

{

$this->_list[$i]['price'] = Tools::convertPrice($this->_list[$i]['price'], $this->context->currency, true, $this->context);

$this->_list[$i]['price_tmp'] = Product::getPriceStatic($this->_list[$i]['id_product'], true, null, 2, null, false, true, 1, true);

}

if ($orderByPriceFinal == 'price_final')

{

if (strtolower($orderWayPriceFinal) == 'desc')

uasort($this->_list, 'cmpPriceDesc');

else

uasort($this->_list, 'cmpPriceAsc');

}

for ($i = 0; $this->_list && $i < $nb; $i++)

{

$this->_list[$i]['price_final'] = $this->_list[$i]['price_tmp'];

unset($this->_list[$i]['price_tmp']);

}

if ($orderByPriceFinal == 'price_final')

{

$order = (string)Tools::getValue('productOrderway');

usort($this->_list,

create_function('$a, $b','return $a["price_final"] ' . (strtolower($order) == 'desc' ? '<' : '>') . ' $b["price_final"];')

);

}

Edited November 22, 2014 by hrq1 (see edit history)

bktmk · December 17, 2014

hello

you're looking for something like:

?

that is manufacturer version possible ?

I tried but it didn't work filtering

please help, Prestashop ver. 1.5.6.2

mielnicki · June 19, 2015

Can I do the same with manufacturer?

reno123 · July 24, 2015

Hi,

quick quastion:

how to filter by quantity, eg. quantity > 5, not quantity = 5 ?

dpfdtn · October 5, 2015

HI!

How do I change the "suppiler" to "suppiler reference" number

Can you help?

Thx

Dalibor

Edited October 7, 2015 by dpfdtn (see edit history)

raj_its · December 18, 2015

Works for 1.6.1.3 too. Thanks Legend !

kvsh · March 17, 2016

Hey, just quick question (probably this is quite easy):

how could I change "supplier" to "manfucaturer"? Is there any easy way to modify this code?

speedcrash2013 · April 25, 2016

after:

		$this->_join .= ' JOIN `'._DB_PREFIX_.'product_shop` sa ON (a.`id_product` = sa.`id_product` AND sa.id_shop = '.$id_shop.')
				LEFT JOIN `'._DB_PREFIX_.'category_lang` cl ON ('.$alias.'.`id_category_default` = cl.`id_category` AND b.`id_lang` = cl.`id_lang` AND cl.id_shop = '.$id_shop.')
				LEFT JOIN `'._DB_PREFIX_.'shop` shop ON (shop.id_shop = '.$id_shop.') 
				LEFT JOIN `'._DB_PREFIX_.'image_shop` image_shop ON (image_shop.`id_image` = i.`id_image` AND image_shop.`cover` = 1 AND image_shop.id_shop = '.$id_shop.')';

add:

$this->_join .='LEFT JOIN `'._DB_PREFIX_.'supplier` AS supp ON (supp.id_supplier = a.`id_supplier`)';                
$this->_select .= 'supp.`name` AS `supp`, ';

and after:

		$this->fields_list['id_product'] = array(
			'title' => $this->l('ID'),
			'align' => 'center',
			'class' => 'fixed-width-xs',
			'type' => 'int'
		);

add:

        $this->fields_list['supp'] = array(
            'title' => $this->l('Supplier'),
            'filter_key' => 'supp!name'
);

WOW

it's works perfectly on 1.6.0.and 1..6.1.5

Thanks VEKIA

ELITIV · November 6, 2016

Hi.

Any solution for - Available for order (status in list)

P.S. This, only show statuses but, filter_key and enable\disable not working.

        $this->fields_list['Available_for_order'] = array(
			'title' => $this->l('Available For order'),
			'width' => 90,
			'type' => 'bool',
			'align' => 'right',
            'active' => 'available_for_order',
			'filter_key' => $alias.'!available_for_order'
		);

Thank you for help.

Sergio Martins · December 30, 2016

Hi.

Any solution for - Available for order (status in list)

P.S. This, only show statuses but, filter_key and enable\disable not working.
        $this->fields_list['Available_for_order'] = array(
			'title' => $this->l('Available For order'),
			'width' => 90,
			'type' => 'bool',
			'align' => 'right',
            'active' => 'available_for_order',
			'filter_key' => $alias.'!available_for_order'
		);
Thank you for help.

Can anyone help? I would also like to know how to apply the enable\disable function.

Alex Sanchez · November 6, 2017

Hello,

Can someone help to answer the questions above?

On 30/12/2016 at 10:17 PM, Sergio Martins said:

Can anyone help? I would also like to know how to apply the enable\disable function.

On 7/11/2016 at 0:09 AM, ELITIV said:
Hi.

Any solution for - Available for order (status in list)

P.S. This, only show statuses but, filter_key and enable\disable not working.
        $this->fields_list['Available_for_order'] = array(
			'title' => $this->l('Available For order'),
			'width' => 90,
			'type' => 'bool',
			'align' => 'right',
            'active' => 'available_for_order',
			'filter_key' => $alias.'!available_for_order'
		);
Thank you for help.

I have the same problem, the enable/disable function on the available for order button i have added.

Best regards

Edited November 6, 2017 by Alex Sanchez (see edit history)

decome2013 · January 26, 2018

Hello !

I kow this topic is about product list ^^ however i would like to make exactly the same thing (display Supplier name) on Orders list page in BO.

In cas of several products for an order, does not matter if there is no information on line, it's very rare on my shop.

I tried to put the code on AdminOrdersController, but i get an error

Any chance to get the same code that Products list for Orders list on 1.6.0.14 ?
Regards,

salouso · August 25, 2020

Hello
Does anyone have this code for PrestaShop 1.7?
Also I need the Barcode (UPC) to be listed and searchable. Has anyone altered the code to that yet?
Kind Regards

Tiburoncin23 · September 15, 2022

I solved this issue in PS 1.7.8

I want to add a filter by brand_name so there are the steps to make this work

Pd: my store is configurated in spanish, so I don´t need translations for my_column. If you needed, have to modify the translate file.

I had to modify 4 files:

1 - HEADER

Search this file: 'your_dir/src/PrestaShopBundle/Resources/views/Admin/Product/CatalogPage/Lists/products_table.html.twig'

The first <tr> make reference to the tittle, so you have to add a <th> inside, in the position do you want:

<!--  Nuevo filtro de marca -->
<th scope="col">
	{{ ps.sortable_column_header("Marca", 'brand_name', orderBy, sortOrder) }}
</th>

In the next <tr>, add an input field in the same position as the tittle

<!--  Nuevo filtro de marca -->
<th>
  <input
    type="text"
    class="form-control"
    placeholder="Buscar por marca"
    name="filter_column_brand_name"
    value="{{ filter_column_brand_name }}"
    aria-label="{{ "%inputId% input"|trans({'%inputId%': 'filter_column_brand_name'}, 'Admin.Global') }}"
    {% if filters_disabled %}disabled{% endif %}
  />
</th>

The property name is important, because the filters take this name and verify its contains 'filter_column' ins the string. Keep this format if you want to filter by this new column.

2 - BODY

Search this file: 'your_dir/src/PrestaShopBundle/Resources/views/Admin/Product/CatalogPage/Lists/list.html.twig'

Add the column for the data in the same position as the filter

<!--  Nuevo filtro de marca -->
<td>
	{{ product.brand_name|default('') }}
</td>

In my case, named the variable as 'brand_name', in the next step we are going to chance the query to add this variable.

3 - QUERY

Search this file: 'your_dir/src/Adapter/Product/AdminProductDataProvider.php'

Search getCatalogProductList() function, there is a variable named $sqlSelect

Modify the arguments and add the brand_name variable:

$sqlSelect = [
'id_product' => ['table' => 'p', 'field' => 'id_product', 'filtering' => ' %s '],
'brand_name' => ['table' => 'mn', 'field' => 'name', 'filtering' => self::FILTERING_LIKE_BOTH],
'reference' => ['table' => 'p', 'field' => 'reference', 'filtering' => self::FILTERING_LIKE_BOTH],
. . .
];

In the following variable $sqlTable add the reference for the manufactered table:

$sqlTable = [
'p' => 'product',
'mn' => [
'table' => 'manufacturer',
'join' => 'JOIN',
'on' => 'mn.`id_manufacturer` = p.`id_manufacturer`',
],'pl' => [ . . .

4 - FILTER

Search this file 'your_dir/src/PrestaShopBundle/Entity/AdminFilter.php'

Search getProductCatalogEmptyFilter() function, in return array, add:

return [
'filter_category' => '',
'filter_column_brand_name' => '', . . .

And finally,

Search sanitizeFilterParameters() function, in return array, add:

return filter_var_array($filter, [
'filter_category' => FILTER_SANITIZE_NUMBER_INT,
'filter_column_id_product' => [
'filter' => FILTER_CALLBACK,
'options' => $filterMinMax(FILTER_SANITIZE_NUMBER_INT),
],
'filter_column_brand_name' => FILTER_SANITIZE_STRING, . . .

5 - TEST

It works with the other filters:

That's all, send me message if you have problems with this implementation.

[SOLVED] How to filter back office product list by supplier id

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment