Can I not show brand or category with 0 quanty

0

Can I not show brand or category with 0 quantity on SHOP?
I don't want the customer to experience the brand or category that has product but no qty.

by default I set the products to load only the items those are not 0 qty but on the menu of category or brand still show up, but some of them when we click it just show nothing because those brands or categories contain products but 0 QTY.

is there anyway to fix that?

Question Resolved For: Stock Manager Advance with All Modules 0 Votes 12 Answers 1.5k Views
Asked by Prom Vongchann 4 years ago

0

Answered by Mian Saleem 1 year ago

Hello,

You can hide the categories & brands in shop settings.

If you want to check for quantity then you can replace the getAllBrands and getAllCategories methods of app/models/shop/Shop_model.php

public function getAllBrands()
{
    if ($this->shop_settings->hide0) {
        // Only check attachment not quantity
        // $pc = "(SELECT count(*) FROM {$this->db->dbprefix('products')} WHERE {$this->db->dbprefix('products')}.brand = {$this->db->dbprefix('brands')}.id)";
        // $this->db->select("{$this->db->dbprefix('brands')}.*, {$pc} AS product_count", false)->order_by('name');

        // Check for all warehouses
        // $this->db->select("{$this->db->dbprefix('brands')}.*, SUM({$this->db->dbprefix('products')}.quantity) AS product_count", false)->having('product_count >', 0);

        // Only check shop warehouse
        $this->db->select("{$this->db->dbprefix('brands')}.*, SUM({$this->db->dbprefix('warehouses_products')}.quantity) AS warehouses_products_quantity", false)
            ->join('products', 'products.brand=brands.id', 'left')
            ->join('warehouses_products', 'warehouses_products.product_id=products.id', 'left')
            ->group_by('brands.id')->order_by('name')
            ->having('warehouses_products_quantity >', 0)
            ->where('warehouses_products.warehouse_id', $this->shop_settings->warehouse);
    }
    return $this->db->get('brands')->result();
}

public function getAllCategories()
{
    if ($this->shop_settings->hide0) {
        // Only check attachment not quantity
        // $pc = "(SELECT count(*) FROM {$this->db->dbprefix('products')} WHERE {$this->db->dbprefix('products')}.category_id = {$this->db->dbprefix('categories')}.id)";
        // $this->db->select("{$this->db->dbprefix('categories')}.*, {$pc} AS product_count", false);

        // Check for all warehouses
        // $this->db->select("{$this->db->dbprefix('categories')}.*, SUM({$this->db->dbprefix('products')}.quantity) AS product_count", false)->join('products', 'products.category_id=categories.id', 'left')->group_by('categories.id')->order_by('name')->having('product_count >', 0);

        // Only check shop warehouse
        $this->db->select("{$this->db->dbprefix('categories')}.*, SUM({$this->db->dbprefix('warehouses_products')}.quantity) AS warehouses_products_quantity", false)
            ->join('products', 'products.category_id=categories.id', 'left')
            ->join('warehouses_products', 'warehouses_products.product_id=products.id', 'left')
            ->group_by('categories.id')->order_by('name')
            ->having('warehouses_products_quantity >', 0)
            ->where('warehouses_products.warehouse_id', $this->shop_settings->warehouse);
    }
    $this->db->group_start()->where('parent_id', null)->or_where('parent_id', 0)->group_end()->order_by('name');
    return $this->db->get('categories')->result();
}

Thank you

0

Answered by Prom Vongchann 1 year ago

Mian Saleem Thank you very much

We use Cookies

We use cookies to ensure that we give you the best experience on our website. By continuing to browse the site you are agreeing to our use of cookies.