Products list by manufacturers in admin

Hi,
Is this possible to list/separate products in admin using manufacturer name? On catalog side it is possible by clicking on manufacturer name/other products need similar in admin.

Thank you!

jsarwar:

Hi,
Is this possible to list/separate products in admin using manufacturer name? On catalog side it is possible by clicking on manufacturer name/other products need similar in admin.

Thank you!

Can anyone assist on this soon please?

I don't know if this does what you want or not but you might take a look:

http://www.zen-cart.com/downloads.php?do=file&id=1673

stevesh:

I don't know if this does what you want or not but you might take a look:

http://www.zen-cart.com/downloads.php?do=file&id=1673

I tried this and it does not work. It only add manufacturer name to order/ invoice etc. but I need items separated by manufacturer name in admin either using a filter or a page where all manufacturer name appear and can click on any to see/edit its products.

Try something like the code in RED by editing the file:
/your_secret_admin/includes/modules/category_product_listing.php

[B]// bof: add filter by manufacturers_id
if (preg_match('#man:#', $_GET['search'])) {
  $manufacturers_filter = ' or manufacturers_id = ' . substr($_GET['search'], 4) . ' ';
} else {
  $manufacturers_filter = '';
}
[/B]      $products_query_raw = ("select p.products_type, p.products_id, pd.products_name, p.products_quantity,
                                       p.products_image, p.products_price, p.products_date_added,
                                       p.products_last_modified, p.products_date_available,
                                       p.products_status, p2c.categories_id,
                                       p.products_model,
                                       p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute,
                                       p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping,
                                       p.products_quantity_order_max, p.products_sort_order,
                                       p.master_categories_id,
                                       p. manufacturers_id
                                from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, "
                                       . TABLE_PRODUCTS_TO_CATEGORIES . " p2c
                                where p.products_id = pd.products_id
                                and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                                and (p.products_id = p2c.products_id
                                and p.master_categories_id = p2c.categories_id)
                                and (
                                pd.products_name like '%" . zen_db_input($_GET['search']) . "%'
                                or pd.products_description like '%" . zen_db_input($_GET['search']) . "%'
                                or p.products_id = '" . zen_db_input($_GET['search']) . "'
                                or p.products_model like '%" . zen_db_input($_GET['search']) . "%')" .
[B]                                $manufacturers_filter .
[/B]                                $order_by);
[B]// eof: add filter by manufacturers_id
[/B]    } else {
      $products_query_raw = ("select p.products_type, p.products_id, pd.products_name, p.products_quantity,

Then, using the manufactures_id, enter into the search box:
man:3

if you wanted to find all products for manufactures_id 3 ... does this work for you?

NOTE: I have not worked out the page results when there are more than the maximum displayed on the page and the page count may/will be off ...

Ajeh:

Try something like the code in RED by editing the file:
/your_secret_admin/includes/modules/category_product_listing.php

[B]// bof: add filter by manufacturers_id
if (preg_match('#man:#', $_GET['search'])) {
$manufacturers_filter = ' or manufacturers_id = ' . substr($_GET['search'], 4) . ' ';
} else {
$manufacturers_filter = '';
}
[/B] $products_query_raw = ("select p.products_type, p.products_id, pd.products_name, p.products_quantity,
p.products_image, p.products_price, p.products_date_added,
p.products_last_modified, p.products_date_available,
p.products_status, p2c.categories_id,
p.products_model,
p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute,
p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping,
p.products_quantity_order_max, p.products_sort_order,
p.master_categories_id,
p. manufacturers_id
from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, "
. TABLE_PRODUCTS_TO_CATEGORIES . " p2c
where p.products_id = pd.products_id
and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
and (p.products_id = p2c.products_id
and p.master_categories_id = p2c.categories_id)
and (
pd.products_name like '%" . zen_db_input($_GET['search']) . "%'
or pd.products_description like '%" . zen_db_input($_GET['search']) . "%'
or p.products_id = '" . zen_db_input($_GET['search']) . "'
or p.products_model like '%" . zen_db_input($_GET['search']) . "%')" .
[B] $manufacturers_filter .
[/B] $order_by);
[B]// eof: add filter by manufacturers_id
[/B] } else {
$products_query_raw = ("select p.products_type, p.products_id, pd.products_name, p.products_quantity,

> 
> Then, using the manufactures_id, enter into the search box:
> man:3
> 
> if you wanted to find all products for manufactures_id 3 ... does this work for you?
> 
> NOTE: I have not worked out the page results when there are more than the maximum displayed on the page and the page count may/will be off ...


Hi,
Thank you! I tried this it does not show any products in admin search. When enter man:3 it keep loading page for 5 - 10 minutes then shows no products found. 

and I also tried using different manufacturer id and it took almost 7 minutes to load page but did not load full page. It loaded upto 

Left : Categories / Products - Top   Right: Go To Top*

* Drop down on top right. 

Any idea how to fix this or make it work. Thank you!

Okay, start with your clean copy of the file ...
/your_secret_admin/includes/modules/category_product_listing.php

replace the code:

      $products_query_raw = ("select p.products_type, p.products_id, pd.products_name, p.products_quantity,
                                       p.products_image, p.products_price, p.products_date_added,
                                       p.products_last_modified, p.products_date_available,
                                       p.products_status, p2c.categories_id,
                                       p.products_model,
                                       p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute,
                                       p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping,
                                       p.products_quantity_order_max, p.products_sort_order,
                                       p.master_categories_id
                                from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, "
                                       . TABLE_PRODUCTS_TO_CATEGORIES . " p2c
                                where p.products_id = pd.products_id
                                and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                                and (p.products_id = p2c.products_id
                                and p.master_categories_id = p2c.categories_id)
                                and (
                                pd.products_name like '%" . zen_db_input($_GET['search']) . "%'
                                or pd.products_description like '%" . zen_db_input($_GET['search']) . "%'
                                or p.products_id = '" . zen_db_input($_GET['search']) . "'
                                or p.products_model like '%" . zen_db_input($_GET['search']) . "%')" .
                                $order_by);

    } else {
      $products_query_raw = ("select p.products_type, p.products_id, pd.products_name, p.products_quantity,

with this new code:

// bof: add filter by manufacturers_id
if (preg_match('#man:#', $_GET['search'])) {
  $manufacturers_filter = ' and (manufacturers_id = ' . substr($_GET['search'], 4) . ') ';
      $products_query_raw = ("select p.products_type, p.products_id, pd.products_name, p.products_quantity,
                                       p.products_image, p.products_price, p.products_date_added,
                                       p.products_last_modified, p.products_date_available,
                                       p.products_status, p2c.categories_id,
                                       p.products_model,
                                       p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute,
                                       p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping,
                                       p.products_quantity_order_max, p.products_sort_order,
                                       p.master_categories_id,
                                       p. manufacturers_id
                                from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, "
                                       . TABLE_PRODUCTS_TO_CATEGORIES . " p2c
                                where p.products_id = pd.products_id
                                and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                                and (p.products_id = p2c.products_id
                                and p.master_categories_id = p2c.categories_id) " .
                                $manufacturers_filter .
                                $order_by);
} else {
      $products_query_raw = ("select p.products_type, p.products_id, pd.products_name, p.products_quantity,
                                       p.products_image, p.products_price, p.products_date_added,
                                       p.products_last_modified, p.products_date_available,
                                       p.products_status, p2c.categories_id,
                                       p.products_model,
                                       p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute,
                                       p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping,
                                       p.products_quantity_order_max, p.products_sort_order,
                                       p.master_categories_id,
                                       p. manufacturers_id
                                from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, "
                                       . TABLE_PRODUCTS_TO_CATEGORIES . " p2c
                                where p.products_id = pd.products_id
                                and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'
                                and (p.products_id = p2c.products_id
                                and p.master_categories_id = p2c.categories_id)
                                and (
                                pd.products_name like '%" . zen_db_input($_GET['search']) . "%'
                                or pd.products_description like '%" . zen_db_input($_GET['search']) . "%'
                                or p.products_id = '" . zen_db_input($_GET['search']) . "'
                                or p.products_model like '%" . zen_db_input($_GET['search']) . "%')" .
                                $order_by);
}
// eof: add filter by manufacturers_id
    } else {
      $products_query_raw = ("select p.products_type, p.products_id, pd.products_name, p.products_quantity,

This will allow the page navigation to work ...

To test this, go to phpMyAdmin and search the table:
products

to the manufacturers_id that you want to test ...

Check how many Products are found on a search for the manufacturers_id ... then in your Zen Cart Admin, do a search for:
man:XX

where XX is the same manufacturers_id ...

worked like a charm. Thank you!

Thanks for the update that this was able to work for you ...

Remember the Zen Cart Team when you are rich and famous! :cool:

Ajeh:

Thanks for the update that this was able to work for you ...

Remember the Zen Cart Team when you are rich and famous! :cool:

I am web developer and sure will. Have a happy holiday season!

Hope you have a good Holiday season as well ... :smile: