out of stock products hidden on latest module

xxvirusxx wrote: ↑

Tue Aug 06, 2024 1:38 am

You can add quantity in controller and here

Code: Select all

$query = $this->db->query("SELECT p.product_id FROM " . DB_PREFIX . "product p LEFT JOIN " . DB_PREFIX . "product_to_store p2s ON (p.product_id = p2s.product_id) WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '" . (int)$this->config->get('config_store_id') . "' ORDER BY p.date_added DESC LIMIT " . (int)$limit);

AND p.quantity > 0

p.status = '1'

$filter_data = array(
            'sort'  => 'p.date_added',
            'order' => 'DESC',
            'start' => 0,
            //'limit' => $setting['limit']
            'limit' => 20,
        );

        $count = 0;
        $results = $this->model_catalog_product->getProducts($filter_data);

        if ($results) {
            foreach ($results as $result) {
                if ($count == 8) break;
                $count++;
                if ($result['quantity'] < 0) { $count--; continue; }

ADD Creative wrote: ↑

Tue Aug 06, 2024 4:18 pm

Check your storage/modification directory in case you have extensions that are also modifying the files.

ADD Creative wrote: ↑

Tue Aug 06, 2024 7:28 pm

If you modified the getLatestProducts query in catalog/model/catalog/product.php. You will need to make this change as 2.3.0.2 is still using the slower getProducts method.
https://github.com/opencart/opencart/pull/8178

If changing the database query and the above then shouldn't need the changes from the other forum post.

ianhaney50 wrote: ↑

Tue Aug 06, 2024 8:34 pm

I have not modified the getLatestProducts query in catalog/model/catalog/product.php

$query = $this->db->query("SELECT p.product_id FROM " . DB_PREFIX . "product p LEFT JOIN " . DB_PREFIX . "product_to_store p2s ON (p.product_id = p2s.product_id) WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '" . (int)$this->config->get('config_store_id') . "' ORDER BY p.date_added DESC LIMIT " . (int)$limit);

$query = $this->db->query("SELECT p.product_id FROM " . DB_PREFIX . "product p LEFT JOIN " . DB_PREFIX . "product_to_store p2s ON (p.product_id = p2s.product_id) WHERE p.status = '1' AND p.quantity > '0' AND p.date_available <= NOW() AND p2s.store_id = '" . (int)$this->config->get('config_store_id') . "' ORDER BY p.date_added DESC LIMIT " . (int)$limit);

ADD Creative wrote: ↑

Tue Aug 06, 2024 9:58 pm

ianhaney50 wrote: ↑

Tue Aug 06, 2024 8:34 pm

I have not modified the getLatestProducts query in catalog/model/catalog/product.php

If you did want to modify it, it's probably the simplest way.

Revert your changes. Make the change at https://github.com/opencart/opencart/pull/8178

Then in catalog/model/catalog/product.php chage.

Code: Select all

$query = $this->db->query("SELECT p.product_id FROM " . DB_PREFIX . "product p LEFT JOIN " . DB_PREFIX . "product_to_store p2s ON (p.product_id = p2s.product_id) WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '" . (int)$this->config->get('config_store_id') . "' ORDER BY p.date_added DESC LIMIT " . (int)$limit);

To.

Code: Select all

$query = $this->db->query("SELECT p.product_id FROM " . DB_PREFIX . "product p LEFT JOIN " . DB_PREFIX . "product_to_store p2s ON (p.product_id = p2s.product_id) WHERE p.status = '1' AND p.quantity > '0' AND p.date_available <= NOW() AND p2s.store_id = '" . (int)$this->config->get('config_store_id') . "' ORDER BY p.date_added DESC LIMIT " . (int)$limit);

You may also need to clear the files in storage/cache.

AND p.quantity > '0'

ianhaney50 wrote: ↑

Mon Aug 05, 2024 6:13 pm

I'm wondering if I should increase the number 6 to 7 on this line

Code: Select all

if ($count == 6) break;

or does anywhere have some better code to try please

ianhaney50 wrote: ↑

Tue Aug 06, 2024 10:35 pm

I tried the code

Code: Select all

AND p.quantity > '0'

but don't work, on the category page it replaces the products with zero quantity with empty products that have no id numbers and no names

ADD Creative wrote: ↑

Wed Aug 07, 2024 4:15 pm

ianhaney50 wrote: ↑

Tue Aug 06, 2024 10:35 pm

I tried the code

Code: Select all

AND p.quantity > '0'

but don't work, on the category page it replaces the products with zero quantity with empty products that have no id numbers and no names

It should not affect the category page at all. Just tested and changes worked fine. Your are can't be making the correct changes. Sounds like you have added to the wrong query.

p.status = '1'

ianhaney50 wrote: ↑

Thu Aug 08, 2024 1:45 am

Think I just found a way to do it

ianhaney50 wrote: ↑

Thu Aug 08, 2024 12:40 am

Just need to now hide the out of stock products on the category page, what coding would I need to use to hide the out of stock products that have zero quantity on the category page in opencart 2.3.0.2 please

$sql .= " LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) LEFT JOIN " . DB_PREFIX . "product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '" . (int)$this->config->get('config_language_id') . "' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '" . (int)$this->config->get('config_store_id') . "'";

$sql .= " LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) LEFT JOIN " . DB_PREFIX . "product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '" . (int)$this->config->get('config_language_id') . "' AND p.status = '1' AND p.quantity > 0 AND p.date_available <= NOW() AND p2s.store_id = '" . (int)$this->config->get('config_store_id') . "'";